participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,634 rows where station_code = "BE000V" 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 |
---|---|---|---|---|---|
5326631 | 5326631 | 20241019192030_33tOH | BE000V | 2024-10-21T12:10:03.379Z | 2024-10-28T12:26:42.182Z |
5326378 | 5326378 | 20241019181528_vhnas | BE000V | 2024-10-21T12:09:18.477Z | 2024-10-28T12:26:41.568Z |
5317437 | 5317437 | 20241016043439_c9g7H | BE000V | 2024-10-17T12:08:40.278Z | 2024-10-24T12:28:00.326Z |
5317390 | 5317390 | 20241016041436_s2oFQ | BE000V | 2024-10-17T12:08:32.057Z | 2024-10-24T12:28:00.148Z |
5317371 | 5317371 | 20241016040751_y7kmu | BE000V | 2024-10-17T12:08:29.390Z | 2024-10-24T12:28:00.094Z |
5317328 | 5317328 | 20241016035455_13ufA | BE000V | 2024-10-17T12:08:23.741Z | 2024-10-24T12:27:59.939Z |
5317278 | 5317278 | 20241016034601_KnT2g | BE000V | 2024-10-17T12:08:17.286Z | 2024-10-24T12:27:59.720Z |
5317181 | 5317181 | 20241016032311_f3A5k | BE000V | 2024-10-17T12:08:00.800Z | 2024-10-24T12:27:59.295Z |
5317150 | 5317150 | 20241016031641_2tiRe | BE000V | 2024-10-17T12:07:56.175Z | 2024-10-24T12:27:59.017Z |
5317112 | 5317112 | 20241016030809_Sdva3 | BE000V | 2024-10-17T12:07:50.248Z | 2024-10-24T12:27:58.897Z |
5317083 | 5317083 | 20241016025603_P9FB3 | BE000V | 2024-10-17T12:07:47.126Z | 2024-10-24T12:27:58.823Z |
5317041 | 5317041 | 20241016024234_Bjsab | BE000V | 2024-10-17T12:07:41.117Z | 2024-10-24T12:27:58.630Z |
5156113 | 5156113 | 20240923211544_KkXLj | BE000V | 2024-09-25T12:07:15.984Z | 2024-10-01T12:22:22.965Z |
5155955 | 5155955 | 20240923201443_PKTQM | BE000V | 2024-09-25T12:06:54.828Z | 2024-10-01T12:22:21.892Z |
5155845 | 5155845 | 20240923191116_j6aFi | BE000V | 2024-09-25T12:06:21.834Z | 2024-10-01T12:22:21.408Z |
5146485 | 5146485 | 20240922012427_fa0OB | BE000V | 2024-09-23T12:02:51.980Z | 2024-09-30T12:22:37.408Z |
5145346 | 5145346 | 20240920192751_u7Bpe | BE000V | 2024-09-22T12:11:29.635Z | 2024-09-28T12:23:27.666Z |
5145261 | 5145261 | 20240920190239_JtiYu | BE000V | 2024-09-22T12:11:19.479Z | 2024-09-28T12:23:26.793Z |
5145232 | 5145232 | 20240920185209_9PtMV | BE000V | 2024-09-22T12:11:16.509Z | 2024-09-28T12:23:26.173Z |
5143301 | 5143301 | 20240921040102_A26Ko | BE000V | 2024-09-22T12:04:28.613Z | 2024-09-29T12:22:06.657Z |
5142879 | 5142879 | 20240921023202_h3sdA | BE000V | 2024-09-22T12:03:34.554Z | 2024-09-29T12:22:05.079Z |
5142817 | 5142817 | 20240921022249_M42kK | BE000V | 2024-09-22T12:03:17.421Z | 2024-09-29T12:22:04.383Z |
5142812 | 5142812 | 20240921022241_38cvh | BE000V | 2024-09-22T12:03:15.767Z | 2024-09-29T12:22:04.381Z |
5142806 | 5142806 | 20240921022037_qU8QO | BE000V | 2024-09-22T12:03:13.437Z | 2024-09-29T12:22:04.273Z |
5142712 | 5142712 | 20240921015751_fuFF1 | BE000V | 2024-09-22T12:03:00.414Z | 2024-09-29T12:22:03.993Z |
5142560 | 5142560 | 20240921012041_867iD | BE000V | 2024-09-22T12:02:45.362Z | 2024-09-29T12:22:03.499Z |
5142388 | 5142388 | 20240921004646_1gB3j | BE000V | 2024-09-22T12:02:14.244Z | 2024-09-29T12:22:02.515Z |
5142374 | 5142374 | 20240921004342_nHHSI | BE000V | 2024-09-22T12:02:11.945Z | 2024-09-29T12:22:02.460Z |
5142134 | 5142134 | 20240920234109_GEYUt | BE000V | 2024-09-22T12:01:40.175Z | 2024-09-29T12:22:00.912Z |
5141599 | 5141599 | 20240920200215_vlRgp | BE000V | 2024-09-22T12:00:18.177Z | 2024-09-29T12:21:56.938Z |
5139536 | 5139536 | 20240920041043_O2h9u | BE000V | 2024-09-21T12:02:28.678Z | 2024-09-28T12:23:16.273Z |
5139511 | 5139511 | 20240920035845_vbLHt | BE000V | 2024-09-21T12:02:26.904Z | 2024-09-28T12:23:15.898Z |
5139488 | 5139488 | 20240920034802_kZ5ug | BE000V | 2024-09-21T12:02:25.447Z | 2024-09-28T12:23:15.791Z |
5139477 | 5139477 | 20240920034307_J9dYi | BE000V | 2024-09-21T12:02:24.631Z | 2024-09-28T12:23:15.723Z |
5139452 | 5139452 | 20240920033645_3QRap | BE000V | 2024-09-21T12:02:22.933Z | 2024-09-28T12:23:15.548Z |
5139397 | 5139397 | 20240920031758_7ZAih | BE000V | 2024-09-21T12:02:18.476Z | 2024-09-28T12:23:15.326Z |
5139365 | 5139365 | 20240920030536_A35vP | BE000V | 2024-09-21T12:02:16.645Z | 2024-09-28T12:23:15.226Z |
5139139 | 5139139 | 20240920014828_aLihC | BE000V | 2024-09-21T12:01:44.646Z | 2024-09-28T12:23:13.913Z |
5139123 | 5139123 | 20240920012838_kdgUJ | BE000V | 2024-09-21T12:01:40.696Z | 2024-09-28T12:23:13.819Z |
5139100 | 5139100 | 20240920011425_U3FiA | BE000V | 2024-09-21T12:01:38.836Z | 2024-09-28T12:23:13.724Z |
5139091 | 5139091 | 20240920011230_wYrrb | BE000V | 2024-09-21T12:01:37.885Z | 2024-09-28T12:23:13.701Z |
5139032 | 5139032 | 20240920004558_I2VeX | BE000V | 2024-09-21T12:01:33.176Z | 2024-09-28T12:23:13.014Z |
5139030 | 5139030 | 20240920004539_9fF25 | BE000V | 2024-09-21T12:01:33.017Z | 2024-09-28T12:23:13.001Z |
5138982 | 5138982 | 20240920002300_VopIr | BE000V | 2024-09-21T12:01:28.029Z | 2024-09-28T12:23:12.205Z |
5138940 | 5138940 | 20240920001016_s6jwV | BE000V | 2024-09-21T12:01:24.079Z | 2024-09-28T12:23:11.992Z |
5136774 | 5136774 | 20240919040629_pRFMs | BE000V | 2024-09-20T12:03:05.215Z | 2024-09-27T12:19:50.835Z |
5136739 | 5136739 | 20240919034844_bpNfz | BE000V | 2024-09-20T12:03:02.035Z | 2024-09-27T12:19:50.527Z |
5136618 | 5136618 | 20240919025002_GgVYI | BE000V | 2024-09-20T12:02:41.946Z | 2024-09-27T12:19:49.463Z |
5136602 | 5136602 | 20240919024435_qVcnR | BE000V | 2024-09-20T12:02:37.905Z | 2024-09-27T12:19:48.701Z |
5136598 | 5136598 | 20240919024335_cVb5m | BE000V | 2024-09-20T12:02:36.655Z | 2024-09-27T12:19:48.691Z |
5136515 | 5136515 | 20240919021722_Ljeqq | BE000V | 2024-09-20T12:02:21.336Z | 2024-09-27T12:19:47.923Z |
5136511 | 5136511 | 20240919020805_HaALs | BE000V | 2024-09-20T12:02:20.559Z | 2024-09-27T12:19:47.563Z |
5136434 | 5136434 | 20240919013629_Cgktf | BE000V | 2024-09-20T12:02:09.333Z | 2024-09-27T12:19:46.837Z |
5136410 | 5136410 | 20240919011504_gBMJE | BE000V | 2024-09-20T12:02:05.977Z | 2024-09-27T12:19:46.643Z |
5136362 | 5136362 | 20240919004356_R2Uuq | BE000V | 2024-09-20T12:01:54.749Z | 2024-09-27T12:19:46.172Z |
5133508 | 5133508 | 20240916033415_KuR4E | BE000V | 2024-09-19T12:17:00.087Z | 2024-09-24T12:15:49.860Z |
5133287 | 5133287 | 20240916031909_r8j8J | BE000V | 2024-09-19T12:16:53.145Z | 2024-09-24T12:15:48.689Z |
5133232 | 5133232 | 20240916031112_GY5wi | BE000V | 2024-09-19T12:16:50.904Z | 2024-09-24T12:15:48.439Z |
5133225 | 5133225 | 20240916030919_rszA3 | BE000V | 2024-09-19T12:16:50.006Z | 2024-09-24T12:15:48.293Z |
5133164 | 5133164 | 20240916030328_a4JOL | BE000V | 2024-09-19T12:16:46.074Z | 2024-09-24T12:15:47.609Z |
5132927 | 5132927 | 20240916022931_Gx2xK | BE000V | 2024-09-19T12:16:36.270Z | 2024-09-24T12:15:46.199Z |
5125773 | 5125773 | 20240918035232_svkpp | BE000V | 2024-09-19T12:04:04.411Z | 2024-09-26T12:18:43.542Z |
5125473 | 5125473 | 20240918024449_dXY6D | BE000V | 2024-09-19T12:03:19.766Z | 2024-09-26T12:18:41.297Z |
5125445 | 5125445 | 20240918023858_khYUX | BE000V | 2024-09-19T12:03:15.837Z | 2024-09-26T12:18:41.181Z |
5125165 | 5125165 | 20240918004758_mKSQ1 | BE000V | 2024-09-19T12:02:25.934Z | 2024-09-26T12:18:38.797Z |
5121313 | 5121313 | 20240914035815_rVEIB | BE000V | 2024-09-18T12:10:54.518Z | 2024-09-22T12:18:00.397Z |
5121025 | 5121025 | 20240914034828_TgzTB | BE000V | 2024-09-18T12:10:49.592Z | 2024-09-22T12:17:59.588Z |
5120991 | 5120991 | 20240914034430_NtmJ6 | BE000V | 2024-09-18T12:10:49.106Z | 2024-09-22T12:17:59.384Z |
5120369 | 5120369 | 20240914031817_Patgp | BE000V | 2024-09-18T12:10:38.739Z | 2024-09-22T12:17:56.725Z |
5120234 | 5120234 | 20240914030924_gndWX | BE000V | 2024-09-18T12:10:35.835Z | 2024-09-22T12:17:56.444Z |
5119765 | 5119765 | 20240914024835_qB4bN | BE000V | 2024-09-18T12:10:26.249Z | 2024-09-22T12:17:55.728Z |
5119744 | 5119744 | 20240914024656_vMUvq | BE000V | 2024-09-18T12:10:25.601Z | 2024-09-22T12:17:55.651Z |
5119722 | 5119722 | 20240914024439_PEe3i | BE000V | 2024-09-18T12:10:24.549Z | 2024-09-22T12:17:55.603Z |
5119674 | 5119674 | 20240914024358_Qs2A9 | BE000V | 2024-09-18T12:10:23.897Z | 2024-09-22T12:17:55.524Z |
5119438 | 5119438 | 20240914023338_3wrLy | BE000V | 2024-09-18T12:10:21.279Z | 2024-09-22T12:17:55.264Z |
5119425 | 5119425 | 20240914023149_Bvkn8 | BE000V | 2024-09-18T12:10:21.021Z | 2024-09-22T12:17:55.240Z |
5119359 | 5119359 | 20240914022741_AT34L | BE000V | 2024-09-18T12:10:20.548Z | 2024-09-22T12:17:55.178Z |
5119257 | 5119257 | 20240914021846_3U7CM | BE000V | 2024-09-18T12:10:18.826Z | 2024-09-22T12:17:54.949Z |
5119047 | 5119047 | 20240914020604_N1vF0 | BE000V | 2024-09-18T12:10:15.329Z | 2024-09-22T12:17:54.650Z |
5117008 | 5117008 | 20240915035557_3vQF3 | BE000V | 2024-09-18T12:07:28.212Z | 2024-09-23T12:16:23.660Z |
5116786 | 5116786 | 20240915034211_aNg3H | BE000V | 2024-09-18T12:07:21.010Z | 2024-09-23T12:16:22.850Z |
5116748 | 5116748 | 20240915033836_lRzJd | BE000V | 2024-09-18T12:07:19.491Z | 2024-09-23T12:16:22.809Z |
5116730 | 5116730 | 20240915033756_e2CxP | BE000V | 2024-09-18T12:07:18.029Z | 2024-09-23T12:16:22.580Z |
5116570 | 5116570 | 20240915033222_TqQU5 | BE000V | 2024-09-18T12:07:10.541Z | 2024-09-23T12:16:21.826Z |
5116465 | 5116465 | 20240915032803_qrufc | BE000V | 2024-09-18T12:07:04.542Z | 2024-09-23T12:16:21.453Z |
5116349 | 5116349 | 20240915032339_oV3my | BE000V | 2024-09-18T12:06:59.719Z | 2024-09-23T12:16:21.059Z |
5116346 | 5116346 | 20240915032335_hjzIA | BE000V | 2024-09-18T12:06:59.422Z | 2024-09-23T12:16:21.041Z |
5116112 | 5116112 | 20240915030904_T6I4t | BE000V | 2024-09-18T12:06:40.683Z | 2024-09-23T12:16:20.474Z |
5115940 | 5115940 | 20240915030103_9nPMG | BE000V | 2024-09-18T12:06:32.307Z | 2024-09-23T12:16:20.018Z |
5115442 | 5115442 | 20240915023845_9EhUI | BE000V | 2024-09-18T12:06:14.537Z | 2024-09-23T12:16:17.224Z |
5115380 | 5115380 | 20240915023521_dGnrX | BE000V | 2024-09-18T12:06:12.172Z | 2024-09-23T12:16:17.092Z |
5115267 | 5115267 | 20240915023047_G0Yy1 | BE000V | 2024-09-18T12:06:08.804Z | 2024-09-23T12:16:16.836Z |
5115244 | 5115244 | 20240915022845_ygCaC | BE000V | 2024-09-18T12:06:07.562Z | 2024-09-23T12:16:16.707Z |
5115211 | 5115211 | 20240915022724_kJdop | BE000V | 2024-09-18T12:06:06.456Z | 2024-09-23T12:16:16.420Z |
5115191 | 5115191 | 20240915022515_qzHYw | BE000V | 2024-09-18T12:06:05.376Z | 2024-09-23T12:16:16.265Z |
5115172 | 5115172 | 20240915022320_DegKA | BE000V | 2024-09-18T12:06:04.692Z | 2024-09-23T12:16:16.084Z |
5115026 | 5115026 | 20240915021439_0Qwyu | BE000V | 2024-09-18T12:05:51.314Z | 2024-09-23T12:16:15.483Z |
5114358 | 5114358 | 20240915013911_fCmjX | BE000V | 2024-09-18T12:05:13.029Z | 2024-09-23T12:16:13.093Z |
5114349 | 5114349 | 20240915013743_3AoQd | BE000V | 2024-09-18T12:05:12.315Z | 2024-09-23T12:16:13.057Z |
5114185 | 5114185 | 20240915013023_d9icH | BE000V | 2024-09-18T12:05:05.717Z | 2024-09-23T12:16:12.481Z |
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);