participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,646 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 |
---|---|---|---|---|---|
5571055 | 5571055 | 20241120220623_ac6fF | BE000H | 2024-11-22T14:16:20.216Z | 2024-11-22T14:19:22.030Z |
5571040 | 5571040 | 20241120220312_WEWGf | BE000H | 2024-11-22T14:16:19.626Z | 2024-11-22T14:19:22.028Z |
5570936 | 5570936 | 20241120213513_nQmOG | BE000H | 2024-11-22T14:16:13.058Z | 2024-11-22T14:19:22.009Z |
5570912 | 5570912 | 20241120212848_7f5rS | BE000H | 2024-11-22T14:16:11.888Z | 2024-11-22T14:19:22.004Z |
5570848 | 5570848 | 20241120211447_BufIS | BE000H | 2024-11-22T14:16:09.245Z | 2024-11-22T14:19:21.994Z |
5570780 | 5570780 | 20241120205538_nEafF | BE000H | 2024-11-22T14:16:05.460Z | 2024-11-22T14:19:21.980Z |
5570587 | 5570587 | 20241120202149_2a37A | BE000H | 2024-11-22T14:15:51.438Z | 2024-11-22T14:19:21.944Z |
5564752 | 5564752 | 20241120032508_85llB | BE000H | 2024-11-21T14:18:02.258Z | 2024-11-22T14:21:36.304Z |
5564616 | 5564616 | 20241120031419_gRTAw | BE000H | 2024-11-21T14:17:53.371Z | 2024-11-22T14:21:34.429Z |
5562809 | 5562809 | 20241120001505_2Vhud | BE000H | 2024-11-21T14:15:23.320Z | 2024-11-22T14:21:05.039Z |
5541203 | 5541203 | 20241113193253_822qX | BE000H | 2024-11-15T14:06:55.317Z | 2024-11-22T14:24:16.617Z |
5541201 | 5541201 | 20241113192930_CKX1x | BE000H | 2024-11-15T14:06:54.892Z | 2024-11-22T14:24:16.528Z |
5537309 | 5537309 | 20241112220202_Z0ysu | BE000H | 2024-11-14T14:11:34.005Z | 2024-11-21T14:26:11.087Z |
5537270 | 5537270 | 20241112214520_CHAtW | BE000H | 2024-11-14T14:11:29.635Z | 2024-11-21T14:26:10.762Z |
5537083 | 5537083 | 20241112202312_WGZsj | BE000H | 2024-11-14T14:11:00.393Z | 2024-11-21T14:26:08.704Z |
5530005 | 5530005 | 20241112013613_7O8C4 | BE000H | 2024-11-13T14:13:38.141Z | 2024-11-20T14:25:52.453Z |
5529750 | 5529750 | 20241112010220_38bUj | BE000H | 2024-11-13T14:13:09.319Z | 2024-11-20T14:25:47.933Z |
5529019 | 5529019 | 20241111231939_bFfSs | BE000H | 2024-11-13T14:11:58.290Z | 2024-11-20T14:25:38.616Z |
5527641 | 5527641 | 20241111175926_f3z8Z | BE000H | 2024-11-13T14:08:50.069Z | 2024-11-20T14:25:15.907Z |
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 |
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);