participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,921 rows where station_code = "BE0007" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5450303 | 5450303 | 20241031183718_bSYjT | BE0007 | 2024-11-02T12:14:55.471Z | 2024-11-03T14:21:10.760Z |
5450193 | 5450193 | 20241031180953_KqbCl | BE0007 | 2024-11-02T12:14:43.544Z | 2024-11-03T14:21:07.755Z |
5430343 | 5430343 | 20241028221316_tWG3v | BE0007 | 2024-10-31T12:18:09.667Z | 2024-11-03T14:25:00.901Z |
5429820 | 5429820 | 20241028200925_SUGkd | BE0007 | 2024-10-31T12:17:06.381Z | 2024-11-03T14:24:58.912Z |
5418840 | 5418840 | 20241027220657_eBMf6 | BE0007 | 2024-10-30T12:16:21.492Z | 2024-11-03T14:25:54.983Z |
5418828 | 5418828 | 20241027220356_EtmpF | BE0007 | 2024-10-30T12:16:19.481Z | 2024-11-03T14:25:54.936Z |
5418600 | 5418600 | 20241027211805_Wgj5Q | BE0007 | 2024-10-30T12:15:52.780Z | 2024-11-03T14:25:53.937Z |
5418366 | 5418366 | 20241027203047_CLDH0 | BE0007 | 2024-10-30T12:15:36.042Z | 2024-11-03T14:25:51.190Z |
5418149 | 5418149 | 20241027200127_UeHX6 | BE0007 | 2024-10-30T12:15:00.103Z | 2024-11-03T14:25:49.865Z |
5417827 | 5417827 | 20241027192027_HnzWv | BE0007 | 2024-10-30T12:14:30.876Z | 2024-11-03T14:25:46.758Z |
5417274 | 5417274 | 20241027180842_KPhXn | BE0007 | 2024-10-30T12:13:27.577Z | 2024-11-03T14:25:44.537Z |
5402771 | 5402771 | 20241026202345_T8JxY | BE0007 | 2024-10-29T12:08:07.344Z | 2024-11-03T14:26:28.163Z |
5402569 | 5402569 | 20241026195733_J1tfb | BE0007 | 2024-10-29T12:07:43.561Z | 2024-11-03T14:26:26.433Z |
5402546 | 5402546 | 20241026195416_pJH22 | BE0007 | 2024-10-29T12:07:38.734Z | 2024-11-03T14:26:26.301Z |
5402262 | 5402262 | 20241026190725_7xFjU | BE0007 | 2024-10-29T12:06:46.229Z | 2024-11-03T14:26:23.658Z |
5399657 | 5399657 | 20241026044559_4dbJi | BE0007 | 2024-10-28T12:20:05.047Z | 2024-11-03T14:27:40.171Z |
5399177 | 5399177 | 20241026035839_vKCd4 | BE0007 | 2024-10-28T12:19:50.650Z | 2024-11-03T14:27:39.188Z |
5399087 | 5399087 | 20241026034935_lugbq | BE0007 | 2024-10-28T12:19:48.200Z | 2024-11-03T14:27:39.011Z |
5398884 | 5398884 | 20241026033500_GYsRJ | BE0007 | 2024-10-28T12:19:38.910Z | 2024-11-03T14:27:38.350Z |
5398849 | 5398849 | 20241026033327_zlFax | BE0007 | 2024-10-28T12:19:37.205Z | 2024-11-03T14:27:38.298Z |
5398442 | 5398442 | 20241026025829_RyWhf | BE0007 | 2024-10-28T12:19:17.540Z | 2024-11-03T14:27:36.379Z |
5397655 | 5397655 | 20241026014551_RkKyj | BE0007 | 2024-10-28T12:18:31.043Z | 2024-11-03T14:27:33.678Z |
5396966 | 5396966 | 20241026005121_RUtFH | BE0007 | 2024-10-28T12:18:01.106Z | 2024-11-03T14:27:31.581Z |
5396953 | 5396953 | 20241026004914_Ht5vh | BE0007 | 2024-10-28T12:18:00.563Z | 2024-11-03T14:27:31.528Z |
5396692 | 5396692 | 20241026002401_mckft | BE0007 | 2024-10-28T12:17:53.430Z | 2024-11-03T14:27:30.704Z |
5396582 | 5396582 | 20241026001410_JDMeU | BE0007 | 2024-10-28T12:17:50.293Z | 2024-11-03T14:27:30.394Z |
5396075 | 5396075 | 20241025233745_dTE3x | BE0007 | 2024-10-28T12:17:17.536Z | 2024-11-03T14:27:28.363Z |
5396036 | 5396036 | 20241025233409_3SAcJ | BE0007 | 2024-10-28T12:17:14.499Z | 2024-11-03T14:27:28.169Z |
5396001 | 5396001 | 20241025232914_igGrc | BE0007 | 2024-10-28T12:17:10.107Z | 2024-11-03T14:27:27.959Z |
5395879 | 5395879 | 20241025231741_TXlSS | BE0007 | 2024-10-28T12:17:02.928Z | 2024-11-03T14:27:27.518Z |
5395815 | 5395815 | 20241025231244_N9bt8 | BE0007 | 2024-10-28T12:16:54.861Z | 2024-11-03T14:27:26.711Z |
5395757 | 5395757 | 20241025230910_amt87 | BE0007 | 2024-10-28T12:16:46.916Z | 2024-11-03T14:27:26.657Z |
5395739 | 5395739 | 20241025230722_1HOp0 | BE0007 | 2024-10-28T12:16:44.761Z | 2024-11-03T14:27:26.586Z |
5395462 | 5395462 | 20241025224500_xLd5e | BE0007 | 2024-10-28T12:16:16.514Z | 2024-11-03T14:27:25.591Z |
5395378 | 5395378 | 20241025223735_SdS5F | BE0007 | 2024-10-28T12:16:11.505Z | 2024-11-03T14:27:25.402Z |
5395365 | 5395365 | 20241025223629_uVluJ | BE0007 | 2024-10-28T12:16:10.986Z | 2024-11-03T14:27:25.228Z |
5395256 | 5395256 | 20241025222833_HB81y | BE0007 | 2024-10-28T12:16:03.572Z | 2024-11-03T14:27:24.452Z |
5395053 | 5395053 | 20241025220317_JrdyT | BE0007 | 2024-10-28T12:15:54.652Z | 2024-11-03T14:27:23.820Z |
5394994 | 5394994 | 20241025215819_8ZLeP | BE0007 | 2024-10-28T12:15:52.241Z | 2024-11-03T14:27:23.630Z |
5394932 | 5394932 | 20241025214716_K40R5 | BE0007 | 2024-10-28T12:15:45.090Z | 2024-11-03T14:27:23.500Z |
5394855 | 5394855 | 20241025213513_lwh2d | BE0007 | 2024-10-28T12:15:32.839Z | 2024-11-03T14:27:22.913Z |
5394784 | 5394784 | 20241025212542_NGz2A | BE0007 | 2024-10-28T12:15:25.474Z | 2024-11-03T14:27:22.773Z |
5394703 | 5394703 | 20241025211254_I9YSy | BE0007 | 2024-10-28T12:15:15.813Z | 2024-11-03T14:27:22.359Z |
5394586 | 5394586 | 20241025205321_mKcMj | BE0007 | 2024-10-28T12:15:01.388Z | 2024-11-03T14:27:21.765Z |
5393612 | 5393612 | 20241025181905_Bbk4X | BE0007 | 2024-10-28T12:12:53.386Z | 2024-11-03T14:27:16.687Z |
5393473 | 5393473 | 20241025174929_3jerZ | BE0007 | 2024-10-28T12:12:37.824Z | 2024-11-03T14:27:15.547Z |
5388051 | 5388051 | 20241025035536_ONEIW | BE0007 | 2024-10-27T12:21:56.730Z | 2024-11-02T12:28:33.724Z |
5387802 | 5387802 | 20241025032424_rBoZ6 | BE0007 | 2024-10-27T12:21:40.887Z | 2024-11-02T12:28:33.275Z |
5387486 | 5387486 | 20241025024436_aVoOr | BE0007 | 2024-10-27T12:21:25.039Z | 2024-11-02T12:28:32.630Z |
5387189 | 5387189 | 20241025020836_kPTx2 | BE0007 | 2024-10-27T12:20:59.239Z | 2024-11-02T12:28:32.200Z |
5366582 | 5366582 | 20241023025241_EocZd | BE0007 | 2024-10-25T12:21:18.202Z | 2024-10-31T12:30:06.472Z |
5366555 | 5366555 | 20241023024634_rg4Hj | BE0007 | 2024-10-25T12:21:16.606Z | 2024-10-31T12:30:06.342Z |
5366534 | 5366534 | 20241023023432_Hejrq | BE0007 | 2024-10-25T12:21:14.861Z | 2024-10-31T12:30:06.111Z |
5366527 | 5366527 | 20241023023216_Qu2nW | BE0007 | 2024-10-25T12:21:14.177Z | 2024-10-31T12:30:05.970Z |
5365836 | 5365836 | 20241023235139_q49ru | BE0007 | 2024-10-25T12:18:08.536Z | 2024-11-01T12:26:56.447Z |
5363490 | 5363490 | 20241023211244_cM0sH | BE0007 | 2024-10-25T12:16:16.165Z | 2024-11-01T12:26:53.323Z |
5363254 | 5363254 | 20241023204014_Yr4Z8 | BE0007 | 2024-10-25T12:15:47.179Z | 2024-11-01T12:26:53.003Z |
5362276 | 5362276 | 20241023192152_vfIVI | BE0007 | 2024-10-25T12:14:09.353Z | 2024-11-01T12:26:51.172Z |
5361196 | 5361196 | 20241023175910_mtA17 | BE0007 | 2024-10-25T12:12:27.004Z | 2024-11-01T12:26:49.511Z |
5356078 | 5356078 | 20241023045400_gznSX | BE0007 | 2024-10-24T12:21:49.930Z | 2024-10-31T12:30:09.757Z |
5356028 | 5356028 | 20241023045120_fXf8D | BE0007 | 2024-10-24T12:21:48.001Z | 2024-10-31T12:30:09.654Z |
5355876 | 5355876 | 20241023043246_G9vxW | BE0007 | 2024-10-24T12:21:40.942Z | 2024-10-31T12:30:09.143Z |
5355373 | 5355373 | 20241023033613_w06TD | BE0007 | 2024-10-24T12:21:17.120Z | 2024-10-31T12:30:07.571Z |
5355353 | 5355353 | 20241023033453_4IiMo | BE0007 | 2024-10-24T12:21:16.233Z | 2024-10-31T12:30:07.561Z |
5355335 | 5355335 | 20241023033226_wHWWC | BE0007 | 2024-10-24T12:21:15.066Z | 2024-10-31T12:30:07.544Z |
5355008 | 5355008 | 20241023030419_HuPNO | BE0007 | 2024-10-24T12:20:59.848Z | 2024-10-31T12:30:06.994Z |
5354998 | 5354998 | 20241023030328_MRxFs | BE0007 | 2024-10-24T12:20:59.609Z | 2024-10-31T12:30:06.842Z |
5354529 | 5354529 | 20241023023021_uFsAq | BE0007 | 2024-10-24T12:20:38.484Z | 2024-10-31T12:30:05.892Z |
5354427 | 5354427 | 20241023022603_kXJ1Y | BE0007 | 2024-10-24T12:20:33.594Z | 2024-10-31T12:30:05.849Z |
5354296 | 5354296 | 20241023021854_ZUxpk | BE0007 | 2024-10-24T12:20:27.074Z | 2024-10-31T12:30:05.626Z |
5353294 | 5353294 | 20241023011910_0wm9J | BE0007 | 2024-10-24T12:19:38.440Z | 2024-10-31T12:30:04.101Z |
5353107 | 5353107 | 20241023010800_w424S | BE0007 | 2024-10-24T12:19:32.557Z | 2024-10-31T12:30:03.829Z |
5352921 | 5352921 | 20241023005631_lzDKU | BE0007 | 2024-10-24T12:19:25.849Z | 2024-10-31T12:30:03.542Z |
5352840 | 5352840 | 20241023005305_R5WRM | BE0007 | 2024-10-24T12:19:17.099Z | 2024-10-31T12:30:03.406Z |
5352836 | 5352836 | 20241023005305_efv9U | BE0007 | 2024-10-24T12:19:16.627Z | 2024-10-31T12:30:03.402Z |
5352796 | 5352796 | 20241023005057_wQsc7 | BE0007 | 2024-10-24T12:19:14.143Z | 2024-10-31T12:30:03.303Z |
5352700 | 5352700 | 20241023004433_uXCJ0 | BE0007 | 2024-10-24T12:19:06.453Z | 2024-10-31T12:30:03.175Z |
5352571 | 5352571 | 20241023003946_LNwn3 | BE0007 | 2024-10-24T12:18:58.028Z | 2024-10-31T12:30:02.907Z |
5352350 | 5352350 | 20241023002745_qzmVQ | BE0007 | 2024-10-24T12:18:39.844Z | 2024-10-31T12:30:02.495Z |
5352326 | 5352326 | 20241023002619_jqieE | BE0007 | 2024-10-24T12:18:38.464Z | 2024-10-31T12:30:02.426Z |
5351833 | 5351833 | 20241022235512_QXyw3 | BE0007 | 2024-10-24T12:18:03.428Z | 2024-10-31T12:30:01.002Z |
5351757 | 5351757 | 20241022235059_SsP2k | BE0007 | 2024-10-24T12:17:56.554Z | 2024-10-31T12:30:00.865Z |
5351445 | 5351445 | 20241022232909_2yNnm | BE0007 | 2024-10-24T12:17:32.322Z | 2024-10-31T12:30:00.370Z |
5351420 | 5351420 | 20241022232707_Io5Et | BE0007 | 2024-10-24T12:17:31.122Z | 2024-10-31T12:30:00.325Z |
5350811 | 5350811 | 20241022223007_JtlgI | BE0007 | 2024-10-24T12:16:36.180Z | 2024-10-31T12:29:58.813Z |
5350745 | 5350745 | 20241022222442_aW7JK | BE0007 | 2024-10-24T12:16:27.363Z | 2024-10-31T12:29:58.744Z |
5350601 | 5350601 | 20241022220706_p8hjX | BE0007 | 2024-10-24T12:16:03.813Z | 2024-10-31T12:29:58.532Z |
5350082 | 5350082 | 20241022210946_Hd27R | BE0007 | 2024-10-24T12:15:18.834Z | 2024-10-31T12:29:57.285Z |
5349959 | 5349959 | 20241022205351_OLfpB | BE0007 | 2024-10-24T12:14:56.768Z | 2024-10-31T12:29:57.035Z |
5349820 | 5349820 | 20241022203758_7Rrne | BE0007 | 2024-10-24T12:14:41.485Z | 2024-10-31T12:29:56.572Z |
5349608 | 5349608 | 20241022201610_WJzAx | BE0007 | 2024-10-24T12:14:09.718Z | 2024-10-31T12:29:55.906Z |
5349485 | 5349485 | 20241022200412_KuItN | BE0007 | 2024-10-24T12:13:46.820Z | 2024-10-31T12:29:55.595Z |
5349179 | 5349179 | 20241022193118_tB0Ya | BE0007 | 2024-10-24T12:13:16.078Z | 2024-10-31T12:29:54.673Z |
5349176 | 5349176 | 20241022193059_3kWST | BE0007 | 2024-10-24T12:13:15.482Z | 2024-10-31T12:29:54.669Z |
5326772 | 5326772 | 20241019201527_pYVv7 | BE0007 | 2024-10-21T12:10:19.453Z | 2024-10-28T12:26:42.496Z |
5316955 | 5316955 | 20241016021151_9riy9 | BE0007 | 2024-10-17T12:07:26.214Z | 2024-10-24T12:27:58.447Z |
5303657 | 5303657 | 20241013032142_wY8P3 | BE0007 | 2024-10-14T12:17:31.005Z | 2024-10-21T12:24:19.197Z |
5303600 | 5303600 | 20241013031523_26n4z | BE0007 | 2024-10-14T12:17:29.794Z | 2024-10-21T12:24:18.895Z |
5302618 | 5302618 | 20241013012758_aupm7 | BE0007 | 2024-10-14T12:16:32.922Z | 2024-10-21T12:24:11.599Z |
5302612 | 5302612 | 20241013012756_FgkV8 | BE0007 | 2024-10-14T12:16:32.039Z | 2024-10-21T12:24:11.539Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);