participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,627 rows where station_code = "BE000H" 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 |
---|---|---|---|---|---|
5450235 | 5450235 | 20241031182401_rinxu | BE000H | 2024-11-02T12:14:50.463Z | 2024-11-09T14:24:14.863Z |
5450137 | 5450137 | 20241031180216_JQZvz | BE000H | 2024-11-02T12:14:38.256Z | 2024-11-09T14:24:13.868Z |
5433765 | 5433765 | 20241028030151_tRcQw | BE000H | 2024-10-31T12:24:44.093Z | 2024-11-05T14:27:15.784Z |
5421210 | 5421210 | 20241028050700_D2Alj | BE000H | 2024-10-30T12:19:43.242Z | 2024-11-05T14:27:17.791Z |
5421116 | 5421116 | 20241028044109_eLF1s | BE000H | 2024-10-30T12:19:36.693Z | 2024-11-05T14:27:17.368Z |
5421037 | 5421037 | 20241028042245_27XCY | BE000H | 2024-10-30T12:19:33.692Z | 2024-11-05T14:27:17.115Z |
5420412 | 5420412 | 20241028023924_sEw3c | BE000H | 2024-10-30T12:18:50.016Z | 2024-11-05T14:27:15.380Z |
5418625 | 5418625 | 20241027212528_DPz9L | BE000H | 2024-10-30T12:15:54.397Z | 2024-11-05T14:27:10.843Z |
5417693 | 5417693 | 20241027190231_u4h2Z | BE000H | 2024-10-30T12:14:13.974Z | 2024-11-05T14:27:08.086Z |
5417590 | 5417590 | 20241027185016_b34gl | BE000H | 2024-10-30T12:13:57.455Z | 2024-11-05T14:27:07.699Z |
5417341 | 5417341 | 20241027181706_YFUT0 | BE000H | 2024-10-30T12:13:33.194Z | 2024-11-05T14:27:06.985Z |
5402606 | 5402606 | 20241026200415_Y5YET | BE000H | 2024-10-29T12:07:47.676Z | 2024-11-04T14:28:45.540Z |
5400469 | 5400469 | 20241025012145_PFRAy | BE000H | 2024-10-28T12:22:53.335Z | 2024-11-02T12:28:31.552Z |
5398272 | 5398272 | 20241026024009_1HiTy | BE000H | 2024-10-28T12:19:08.743Z | 2024-11-03T14:27:35.765Z |
5398249 | 5398249 | 20241026023730_Nb3Ai | BE000H | 2024-10-28T12:19:07.673Z | 2024-11-03T14:27:35.725Z |
5398064 | 5398064 | 20241026022155_PWO61 | BE000H | 2024-10-28T12:18:59.455Z | 2024-11-03T14:27:35.262Z |
5397649 | 5397649 | 20241026014543_c6IEs | BE000H | 2024-10-28T12:18:31.034Z | 2024-11-03T14:27:33.666Z |
5397645 | 5397645 | 20241026014536_wwB4u | BE000H | 2024-10-28T12:18:30.839Z | 2024-11-03T14:27:33.657Z |
5394903 | 5394903 | 20241025214205_zMH2G | BE000H | 2024-10-28T12:15:40.833Z | 2024-11-03T14:27:23.326Z |
5388298 | 5388298 | 20241025042731_CH4Lj | BE000H | 2024-10-27T12:22:08.707Z | 2024-11-02T12:28:33.918Z |
5388291 | 5388291 | 20241025042703_oRpql | BE000H | 2024-10-27T12:22:08.357Z | 2024-11-02T12:28:33.914Z |
5388277 | 5388277 | 20241025042423_AhJMp | BE000H | 2024-10-27T12:22:07.911Z | 2024-11-02T12:28:33.907Z |
5388230 | 5388230 | 20241025042029_c82Ob | BE000H | 2024-10-27T12:22:05.269Z | 2024-11-02T12:28:33.891Z |
5388219 | 5388219 | 20241025041924_ZKHT7 | BE000H | 2024-10-27T12:22:04.909Z | 2024-11-02T12:28:33.875Z |
5388206 | 5388206 | 20241025041743_cSNfu | BE000H | 2024-10-27T12:22:04.472Z | 2024-11-02T12:28:33.841Z |
5388153 | 5388153 | 20241025040954_To1AR | BE000H | 2024-10-27T12:22:02.445Z | 2024-11-02T12:28:33.796Z |
5388149 | 5388149 | 20241025040926_9fwkZ | BE000H | 2024-10-27T12:22:02.160Z | 2024-11-02T12:28:33.794Z |
5388081 | 5388081 | 20241025040050_DlRNv | BE000H | 2024-10-27T12:21:58.686Z | 2024-11-02T12:28:33.740Z |
5388053 | 5388053 | 20241025035604_tdSqh | BE000H | 2024-10-27T12:21:57.035Z | 2024-11-02T12:28:33.725Z |
5388005 | 5388005 | 20241025035233_O4eBk | BE000H | 2024-10-27T12:21:52.823Z | 2024-11-02T12:28:33.582Z |
5387936 | 5387936 | 20241025034324_GrJiv | BE000H | 2024-10-27T12:21:49.666Z | 2024-11-02T12:28:33.455Z |
5387927 | 5387927 | 20241025034210_EtyRe | BE000H | 2024-10-27T12:21:49.486Z | 2024-11-02T12:28:33.452Z |
5387871 | 5387871 | 20241025033349_gDzHW | BE000H | 2024-10-27T12:21:46.977Z | 2024-11-02T12:28:33.353Z |
5387859 | 5387859 | 20241025033230_Yp8RC | BE000H | 2024-10-27T12:21:46.424Z | 2024-11-02T12:28:33.344Z |
5387588 | 5387588 | 20241025025759_HvTkD | BE000H | 2024-10-27T12:21:29.768Z | 2024-11-02T12:28:32.795Z |
5387562 | 5387562 | 20241025025457_l4428 | BE000H | 2024-10-27T12:21:28.803Z | 2024-11-02T12:28:32.764Z |
5387170 | 5387170 | 20241025020749_U34Ok | BE000H | 2024-10-27T12:20:58.036Z | 2024-11-02T12:28:32.170Z |
5386954 | 5386954 | 20241025014359_7O5X9 | BE000H | 2024-10-27T12:20:43.237Z | 2024-11-02T12:28:31.754Z |
5386898 | 5386898 | 20241025013912_HO269 | BE000H | 2024-10-27T12:20:38.925Z | 2024-11-02T12:28:31.686Z |
5386831 | 5386831 | 20241025013215_HZcrY | BE000H | 2024-10-27T12:20:35.397Z | 2024-11-02T12:28:31.659Z |
5386786 | 5386786 | 20241025012519_u7Q2K | BE000H | 2024-10-27T12:20:27.988Z | 2024-11-02T12:28:31.601Z |
5386751 | 5386751 | 20241025012144_v71pW | BE000H | 2024-10-27T12:20:25.124Z | 2024-11-02T12:28:31.546Z |
5386709 | 5386709 | 20241025011805_IceNN | BE000H | 2024-10-27T12:20:20.680Z | 2024-11-02T12:28:31.503Z |
5386635 | 5386635 | 20241025010732_rliWx | BE000H | 2024-10-27T12:20:12.546Z | 2024-11-02T12:28:31.406Z |
5386628 | 5386628 | 20241025010714_bQdE9 | BE000H | 2024-10-27T12:20:12.397Z | 2024-11-02T12:28:31.401Z |
5386485 | 5386485 | 20241025004810_rd2zz | BE000H | 2024-10-27T12:20:07.784Z | 2024-11-02T12:28:31.272Z |
5386453 | 5386453 | 20241025004454_Wl1NR | BE000H | 2024-10-27T12:20:05.804Z | 2024-11-02T12:28:31.260Z |
5386419 | 5386419 | 20241025003913_xNtfa | BE000H | 2024-10-27T12:20:04.041Z | 2024-11-02T12:28:31.211Z |
5386401 | 5386401 | 20241025003704_Qxtv0 | BE000H | 2024-10-27T12:20:03.647Z | 2024-11-02T12:28:31.196Z |
5386183 | 5386183 | 20241025001215_ullXp | BE000H | 2024-10-27T12:19:54.250Z | 2024-11-02T12:28:30.831Z |
5386175 | 5386175 | 20241025001148_jxwvP | BE000H | 2024-10-27T12:19:54.033Z | 2024-11-02T12:28:30.825Z |
5385994 | 5385994 | 20241024235214_ISibW | BE000H | 2024-10-27T12:19:44.716Z | 2024-11-02T12:28:30.564Z |
5385900 | 5385900 | 20241024234100_ZeFdi | BE000H | 2024-10-27T12:19:35.556Z | 2024-11-02T12:28:30.450Z |
5385720 | 5385720 | 20241024232141_Oi2Zp | BE000H | 2024-10-27T12:19:19.731Z | 2024-11-02T12:28:30.103Z |
5385715 | 5385715 | 20241024232124_9hLCu | BE000H | 2024-10-27T12:19:19.418Z | 2024-11-02T12:28:30.094Z |
5385532 | 5385532 | 20241024225832_Dn3GE | BE000H | 2024-10-27T12:19:03.778Z | 2024-11-02T12:28:29.899Z |
5385507 | 5385507 | 20241024225515_xYHc2 | BE000H | 2024-10-27T12:19:00.752Z | 2024-11-02T12:28:29.889Z |
5385362 | 5385362 | 20241024223035_LtXUl | BE000H | 2024-10-27T12:18:47.820Z | 2024-11-02T12:28:29.669Z |
5385080 | 5385080 | 20241024214924_UeFni | BE000H | 2024-10-27T12:18:21.911Z | 2024-11-02T12:28:29.118Z |
5384936 | 5384936 | 20241024211837_3nj2N | BE000H | 2024-10-27T12:18:00.821Z | 2024-11-02T12:28:28.746Z |
5383516 | 5383516 | 20241024182825_3OTfz | BE000H | 2024-10-27T12:15:38.790Z | 2024-11-02T12:28:25.709Z |
5383333 | 5383333 | 20241024180956_G1gOy | BE000H | 2024-10-27T12:15:16.152Z | 2024-11-02T12:28:24.959Z |
5378121 | 5378121 | 20241024052748_by82e | BE000H | 2024-10-26T12:22:54.703Z | 2024-11-01T12:27:03.293Z |
5378084 | 5378084 | 20241024052610_4X7J3 | BE000H | 2024-10-26T12:22:54.235Z | 2024-11-01T12:27:03.276Z |
5377802 | 5377802 | 20241024051200_ls663 | BE000H | 2024-10-26T12:22:47.508Z | 2024-11-01T12:27:03.070Z |
5377678 | 5377678 | 20241024050356_Wk4Ce | BE000H | 2024-10-26T12:22:43.736Z | 2024-11-01T12:27:02.717Z |
5377548 | 5377548 | 20241024045658_pIuPJ | BE000H | 2024-10-26T12:22:40.401Z | 2024-11-01T12:27:02.580Z |
5377519 | 5377519 | 20241024045507_w32gC | BE000H | 2024-10-26T12:22:39.365Z | 2024-11-01T12:27:02.562Z |
5377469 | 5377469 | 20241024045225_Az53R | BE000H | 2024-10-26T12:22:38.181Z | 2024-11-01T12:27:02.450Z |
5377333 | 5377333 | 20241024044452_ffINF | BE000H | 2024-10-26T12:22:34.613Z | 2024-11-01T12:27:02.382Z |
5377216 | 5377216 | 20241024043923_4cqNt | BE000H | 2024-10-26T12:22:31.534Z | 2024-11-01T12:27:02.329Z |
5376993 | 5376993 | 20241024042807_fIKpI | BE000H | 2024-10-26T12:22:21.877Z | 2024-11-01T12:27:02.120Z |
5376864 | 5376864 | 20241024042013_nqbi4 | BE000H | 2024-10-26T12:22:15.230Z | 2024-11-01T12:27:01.902Z |
5376544 | 5376544 | 20241024040000_2GESF | BE000H | 2024-10-26T12:22:05.037Z | 2024-11-01T12:27:01.595Z |
5376517 | 5376517 | 20241024035834_yAr4p | BE000H | 2024-10-26T12:22:04.476Z | 2024-11-01T12:27:01.585Z |
5376500 | 5376500 | 20241024035819_mteBH | BE000H | 2024-10-26T12:22:03.526Z | 2024-11-01T12:27:01.579Z |
5376492 | 5376492 | 20241024035802_tXgYx | BE000H | 2024-10-26T12:22:03.362Z | 2024-11-01T12:27:01.572Z |
5376406 | 5376406 | 20241024035403_UIxo5 | BE000H | 2024-10-26T12:22:01.119Z | 2024-11-01T12:27:01.528Z |
5376368 | 5376368 | 20241024035250_Ehu2q | BE000H | 2024-10-26T12:21:59.400Z | 2024-11-01T12:27:01.515Z |
5376356 | 5376356 | 20241024035232_LfADh | BE000H | 2024-10-26T12:21:59.089Z | 2024-11-01T12:27:01.511Z |
5376143 | 5376143 | 20241024034337_VEFOB | BE000H | 2024-10-26T12:21:52.366Z | 2024-11-01T12:27:01.413Z |
5376068 | 5376068 | 20241024034000_MkvSE | BE000H | 2024-10-26T12:21:49.162Z | 2024-11-01T12:27:01.351Z |
5376031 | 5376031 | 20241024033851_xzf53 | BE000H | 2024-10-26T12:21:48.063Z | 2024-11-01T12:27:01.341Z |
5376021 | 5376021 | 20241024033830_Y36BB | BE000H | 2024-10-26T12:21:46.892Z | 2024-11-01T12:27:01.318Z |
5376015 | 5376015 | 20241024033756_sr87s | BE000H | 2024-10-26T12:21:46.565Z | 2024-11-01T12:27:01.316Z |
5375960 | 5375960 | 20241024033645_tOvfo | BE000H | 2024-10-26T12:21:45.165Z | 2024-11-01T12:27:01.297Z |
5375922 | 5375922 | 20241024033548_mM3G3 | BE000H | 2024-10-26T12:21:44.286Z | 2024-11-01T12:27:01.268Z |
5375850 | 5375850 | 20241024033314_EgQYW | BE000H | 2024-10-26T12:21:42.254Z | 2024-11-01T12:27:01.235Z |
5375736 | 5375736 | 20241024032650_MTlm2 | BE000H | 2024-10-26T12:21:38.234Z | 2024-11-01T12:27:01.175Z |
5375724 | 5375724 | 20241024032628_ZKq7d | BE000H | 2024-10-26T12:21:37.535Z | 2024-11-01T12:27:01.172Z |
5375714 | 5375714 | 20241024032625_ZDdOl | BE000H | 2024-10-26T12:21:36.047Z | 2024-11-01T12:27:01.169Z |
5375705 | 5375705 | 20241024032606_7Vgp6 | BE000H | 2024-10-26T12:21:35.918Z | 2024-11-01T12:27:01.167Z |
5375596 | 5375596 | 20241024032123_5YXeA | BE000H | 2024-10-26T12:21:33.015Z | 2024-11-01T12:27:01.105Z |
5375239 | 5375239 | 20241024030409_RiJpp | BE000H | 2024-10-26T12:21:17.252Z | 2024-11-01T12:27:00.458Z |
5375218 | 5375218 | 20241024030308_y3e3z | BE000H | 2024-10-26T12:21:17.014Z | 2024-11-01T12:27:00.445Z |
5375108 | 5375108 | 20241024025802_BV4G9 | BE000H | 2024-10-26T12:21:13.283Z | 2024-11-01T12:27:00.290Z |
5375104 | 5375104 | 20241024025738_YN2WV | BE000H | 2024-10-26T12:21:13.083Z | 2024-11-01T12:27:00.288Z |
5374877 | 5374877 | 20241024024809_DIeHQ | BE000H | 2024-10-26T12:21:04.843Z | 2024-11-01T12:27:00.024Z |
5374644 | 5374644 | 20241024023804_c6gNt | BE000H | 2024-10-26T12:20:55.522Z | 2024-11-01T12:26:59.526Z |
5374602 | 5374602 | 20241024023630_84qXv | BE000H | 2024-10-26T12:20:54.673Z | 2024-11-01T12:26:59.517Z |
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);