participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000U" 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 |
---|---|---|---|---|---|
5497932 | 5497932 | 20241107061054_PnOvi | US000U | 2024-11-08T14:14:31.277Z | 2024-11-08T14:14:35.454Z |
5497895 | 5497895 | 20241107055706_4p1k3 | US000U | 2024-11-08T14:14:29.408Z | 2024-11-08T14:14:35.446Z |
5497644 | 5497644 | 20241107041700_llzqT | US000U | 2024-11-08T14:14:07.535Z | 2024-11-08T14:14:35.390Z |
5497479 | 5497479 | 20241107034854_O94FQ | US000U | 2024-11-08T14:13:51.501Z | 2024-11-08T14:14:35.353Z |
5497427 | 5497427 | 20241107033814_iX8Tk | US000U | 2024-11-08T14:13:45.705Z | 2024-11-08T14:14:35.340Z |
5493674 | 5493674 | 20241107125928_KrvZN | US000U | 2024-11-08T14:04:28.355Z | 2024-11-08T14:04:28.355Z |
5493657 | 5493657 | 20241107125626_1ItMX | US000U | 2024-11-08T14:04:26.877Z | 2024-11-08T14:04:26.877Z |
5493552 | 5493552 | 20241107123306_3s3i1 | US000U | 2024-11-08T14:04:03.422Z | 2024-11-08T14:04:03.422Z |
5493480 | 5493480 | 20241107122016_F1FzT | US000U | 2024-11-08T14:03:51.488Z | 2024-11-08T14:03:51.488Z |
5493473 | 5493473 | 20241107121941_5IiuS | US000U | 2024-11-08T14:03:51.193Z | 2024-11-08T14:03:51.193Z |
5493442 | 5493442 | 20241107121153_thM32 | US000U | 2024-11-08T14:03:46.198Z | 2024-11-08T14:03:46.198Z |
5493365 | 5493365 | 20241107115608_ASj0D | US000U | 2024-11-08T14:03:37.548Z | 2024-11-08T14:03:37.548Z |
5493341 | 5493341 | 20241107115055_0uNXg | US000U | 2024-11-08T14:03:35.197Z | 2024-11-08T14:03:35.197Z |
5493269 | 5493269 | 20241107113108_4KRAQ | US000U | 2024-11-08T14:03:25.873Z | 2024-11-08T14:03:25.873Z |
5493115 | 5493115 | 20241107105850_dPtZ2 | US000U | 2024-11-08T14:02:52.911Z | 2024-11-08T14:02:52.911Z |
5493078 | 5493078 | 20241107104952_bMc8o | US000U | 2024-11-08T14:02:49.359Z | 2024-11-08T14:02:49.359Z |
5493064 | 5493064 | 20241107104736_tzYi3 | US000U | 2024-11-08T14:02:47.938Z | 2024-11-08T14:02:47.938Z |
5493022 | 5493022 | 20241107103801_a8M2y | US000U | 2024-11-08T14:02:43.977Z | 2024-11-08T14:02:43.977Z |
5492992 | 5492992 | 20241107103310_pptud | US000U | 2024-11-08T14:02:40.998Z | 2024-11-08T14:02:40.998Z |
5492920 | 5492920 | 20241107102037_QLkYP | US000U | 2024-11-08T14:02:34.271Z | 2024-11-08T14:02:34.271Z |
5492772 | 5492772 | 20241107095408_qm0GJ | US000U | 2024-11-08T14:02:04.088Z | 2024-11-08T14:02:04.088Z |
5492728 | 5492728 | 20241107094554_wbIL3 | US000U | 2024-11-08T14:01:58.927Z | 2024-11-08T14:01:58.927Z |
5492716 | 5492716 | 20241107094008_0lpfB | US000U | 2024-11-08T14:01:57.403Z | 2024-11-08T14:01:57.403Z |
5492651 | 5492651 | 20241107092401_gvydX | US000U | 2024-11-08T14:01:45.299Z | 2024-11-08T14:01:45.299Z |
5492536 | 5492536 | 20241107085533_2L21m | US000U | 2024-11-08T14:01:22.432Z | 2024-11-08T14:01:22.432Z |
5492500 | 5492500 | 20241107084348_VRhKn | US000U | 2024-11-08T14:01:18.138Z | 2024-11-08T14:01:18.138Z |
5492476 | 5492476 | 20241107084011_gTjV7 | US000U | 2024-11-08T14:01:15.697Z | 2024-11-08T14:01:15.697Z |
5492420 | 5492420 | 20241107083138_TM2YK | US000U | 2024-11-08T14:01:03.098Z | 2024-11-08T14:01:03.098Z |
5492402 | 5492402 | 20241107082530_kRiGz | US000U | 2024-11-08T14:01:00.327Z | 2024-11-08T14:01:00.327Z |
5492304 | 5492304 | 20241107080507_8Lpb2 | US000U | 2024-11-08T14:00:44.504Z | 2024-11-08T14:00:44.504Z |
5492238 | 5492238 | 20241107074202_hevPN | US000U | 2024-11-08T14:00:36.189Z | 2024-11-08T14:00:36.189Z |
5492209 | 5492209 | 20241107072923_7ZHx0 | US000U | 2024-11-08T14:00:29.691Z | 2024-11-08T14:00:29.691Z |
5492134 | 5492134 | 20241107070115_sn7T4 | US000U | 2024-11-08T14:00:17.561Z | 2024-11-08T14:00:17.561Z |
5492116 | 5492116 | 20241107064659_ZrMaH | US000U | 2024-11-08T14:00:14.337Z | 2024-11-08T14:00:14.337Z |
5492015 | 5492015 | 20241105051745_N3YY7 | US000U | 2024-11-07T14:20:32.037Z | 2024-11-08T14:18:51.184Z |
5486683 | 5486683 | 20241106125414_9HbXX | US000U | 2024-11-07T14:03:45.308Z | 2024-11-08T14:14:34.302Z |
5486657 | 5486657 | 20241106124414_iePJO | US000U | 2024-11-07T14:03:42.316Z | 2024-11-08T14:14:34.294Z |
5486478 | 5486478 | 20241106115155_q5JaU | US000U | 2024-11-07T14:03:11.241Z | 2024-11-08T14:14:34.248Z |
5486353 | 5486353 | 20241106110305_lG5DH | US000U | 2024-11-07T14:02:41.420Z | 2024-11-08T14:14:34.217Z |
5486300 | 5486300 | 20241106103343_GmK5k | US000U | 2024-11-07T14:02:28.180Z | 2024-11-08T14:14:34.205Z |
5486186 | 5486186 | 20241106100114_a41ux | US000U | 2024-11-07T14:02:10.658Z | 2024-11-08T14:14:34.182Z |
5486141 | 5486141 | 20241106095139_h0CZE | US000U | 2024-11-07T14:02:02.946Z | 2024-11-08T14:14:34.171Z |
5486135 | 5486135 | 20241106094942_U9Vst | US000U | 2024-11-07T14:01:57.985Z | 2024-11-08T14:14:34.169Z |
5486077 | 5486077 | 20241106092809_Fn2Mj | US000U | 2024-11-07T14:01:45.003Z | 2024-11-08T14:14:34.156Z |
5486074 | 5486074 | 20241106092809_VG2us | US000U | 2024-11-07T14:01:44.487Z | 2024-11-08T14:14:34.156Z |
5486064 | 5486064 | 20241106092448_gAnx8 | US000U | 2024-11-07T14:01:42.452Z | 2024-11-08T14:14:34.153Z |
5486040 | 5486040 | 20241106091954_9oO2R | US000U | 2024-11-07T14:01:37.831Z | 2024-11-08T14:14:34.148Z |
5486036 | 5486036 | 20241106091654_ENUK7 | US000U | 2024-11-07T14:01:36.860Z | 2024-11-08T14:14:34.147Z |
5486030 | 5486030 | 20241106091528_bLWdA | US000U | 2024-11-07T14:01:35.760Z | 2024-11-08T14:14:34.146Z |
5485982 | 5485982 | 20241106090106_rQAD2 | US000U | 2024-11-07T14:01:23.596Z | 2024-11-08T14:14:34.135Z |
5485885 | 5485885 | 20241106081617_QC00d | US000U | 2024-11-07T14:01:00.607Z | 2024-11-08T14:14:34.109Z |
5485816 | 5485816 | 20241106074049_m7s03 | US000U | 2024-11-07T14:00:43.616Z | 2024-11-08T14:14:34.091Z |
5485552 | 5485552 | 20241105063458_UltUc | US000U | 2024-11-06T14:18:28.987Z | 2024-11-08T14:18:52.270Z |
5485501 | 5485501 | 20241105060850_iFp2p | US000U | 2024-11-06T14:18:23.122Z | 2024-11-08T14:18:52.010Z |
5485448 | 5485448 | 20241105054424_JfB3O | US000U | 2024-11-06T14:18:18.676Z | 2024-11-08T14:18:51.627Z |
5485391 | 5485391 | 20241105051743_BOB97 | US000U | 2024-11-06T14:18:12.044Z | 2024-11-08T14:18:51.156Z |
5485306 | 5485306 | 20241105044427_3eGll | US000U | 2024-11-06T14:18:05.283Z | 2024-11-08T14:18:50.630Z |
5485292 | 5485292 | 20241105043957_kJi3Z | US000U | 2024-11-06T14:18:03.912Z | 2024-11-08T14:18:50.491Z |
5485210 | 5485210 | 20241105042243_m4294 | US000U | 2024-11-06T14:17:54.356Z | 2024-11-08T14:18:49.822Z |
5484849 | 5484849 | 20241105033437_ztr9C | US000U | 2024-11-06T14:17:22.766Z | 2024-11-08T14:18:46.257Z |
5484098 | 5484098 | 20241105020942_13gbH | US000U | 2024-11-06T14:16:13.946Z | 2024-11-08T14:18:41.102Z |
5480430 | 5480430 | 20241105125452_bsamv | US000U | 2024-11-06T14:05:35.196Z | 2024-11-08T14:15:26.078Z |
5480417 | 5480417 | 20241105124828_lVRx3 | US000U | 2024-11-06T14:05:30.579Z | 2024-11-08T14:15:25.445Z |
5480169 | 5480169 | 20241105115650_aRlvC | US000U | 2024-11-06T14:04:43.136Z | 2024-11-08T14:15:18.139Z |
5480123 | 5480123 | 20241105114442_bOJaS | US000U | 2024-11-06T14:04:33.837Z | 2024-11-08T14:15:17.033Z |
5480069 | 5480069 | 20241105112944_KeA0B | US000U | 2024-11-06T14:04:26.221Z | 2024-11-08T14:15:14.679Z |
5480058 | 5480058 | 20241105112852_ezaI3 | US000U | 2024-11-06T14:04:24.900Z | 2024-11-08T14:15:14.421Z |
5479999 | 5479999 | 20241105111439_Ojqs3 | US000U | 2024-11-06T14:04:17.634Z | 2024-11-08T14:15:12.156Z |
5479964 | 5479964 | 20241105111011_CzpzP | US000U | 2024-11-06T14:04:08.434Z | 2024-11-08T14:15:10.936Z |
5479935 | 5479935 | 20241105110431_WqovX | US000U | 2024-11-06T14:03:58.645Z | 2024-11-08T14:15:09.988Z |
5479764 | 5479764 | 20241105103508_GJE92 | US000U | 2024-11-06T14:03:31.182Z | 2024-11-08T14:15:03.998Z |
5479731 | 5479731 | 20241105102808_5xr6o | US000U | 2024-11-06T14:03:19.900Z | 2024-11-08T14:15:02.435Z |
5479726 | 5479726 | 20241105102714_oyh1X | US000U | 2024-11-06T14:03:17.928Z | 2024-11-08T14:15:02.333Z |
5479690 | 5479690 | 20241105101910_t34Qe | US000U | 2024-11-06T14:03:05.780Z | 2024-11-08T14:15:00.814Z |
5479661 | 5479661 | 20241105101549_625pQ | US000U | 2024-11-06T14:03:02.176Z | 2024-11-08T14:15:00.033Z |
5479628 | 5479628 | 20241105100706_FB0iZ | US000U | 2024-11-06T14:02:55.648Z | 2024-11-08T14:14:59.154Z |
5479534 | 5479534 | 20241105095234_pxVf5 | US000U | 2024-11-06T14:02:42.373Z | 2024-11-08T14:14:56.728Z |
5479510 | 5479510 | 20241105094621_a0dTu | US000U | 2024-11-06T14:02:33.118Z | 2024-11-08T14:14:55.737Z |
5479489 | 5479489 | 20241105094054_NqICX | US000U | 2024-11-06T14:02:24.586Z | 2024-11-08T14:14:54.796Z |
5479214 | 5479214 | 20241105083242_36CmD | US000U | 2024-11-06T14:01:31.147Z | 2024-11-08T14:14:46.154Z |
5479128 | 5479128 | 20241105081246_Y6jrC | US000U | 2024-11-06T14:01:08.215Z | 2024-11-08T14:14:42.882Z |
5479083 | 5479083 | 20241105075852_Q28jj | US000U | 2024-11-06T14:00:57.420Z | 2024-11-08T14:14:41.628Z |
5479054 | 5479054 | 20241105074105_1Fde4 | US000U | 2024-11-06T14:00:49.576Z | 2024-11-08T14:14:40.702Z |
5478927 | 5478927 | 20241105065613_V4HP1 | US000U | 2024-11-06T14:00:22.603Z | 2024-11-08T14:14:38.087Z |
5478922 | 5478922 | 20241105065533_903QJ | US000U | 2024-11-06T14:00:22.120Z | 2024-11-08T14:14:38.058Z |
5478742 | 5478742 | 20241104053531_SJ6lX | US000U | 2024-11-05T14:18:47.026Z | 2024-11-08T14:20:16.841Z |
5478739 | 5478739 | 20241104053518_x39c2 | US000U | 2024-11-05T14:18:46.667Z | 2024-11-08T14:20:16.831Z |
5478625 | 5478625 | 20241104044527_IXN0N | US000U | 2024-11-05T14:18:35.168Z | 2024-11-08T14:20:15.731Z |
5477737 | 5477737 | 20241104022852_JmWkN | US000U | 2024-11-05T14:17:20.754Z | 2024-11-08T14:20:06.484Z |
5477415 | 5477415 | 20241104014938_KFGtZ | US000U | 2024-11-05T14:16:51.481Z | 2024-11-08T14:20:03.490Z |
5471880 | 5471880 | 20241104125516_vSgwX | US000U | 2024-11-05T14:04:45.400Z | 2024-11-08T14:17:43.213Z |
5471871 | 5471871 | 20241104125314_zx0kH | US000U | 2024-11-05T14:04:44.684Z | 2024-11-08T14:17:43.173Z |
5471835 | 5471835 | 20241104124924_3AaeK | US000U | 2024-11-05T14:04:41.331Z | 2024-11-08T14:17:42.505Z |
5471783 | 5471783 | 20241104123815_M8ws0 | US000U | 2024-11-05T14:04:35.935Z | 2024-11-08T14:17:41.608Z |
5471674 | 5471674 | 20241104122307_N4EbZ | US000U | 2024-11-05T14:04:18.522Z | 2024-11-08T14:17:39.282Z |
5471620 | 5471620 | 20241104121057_0BGc6 | US000U | 2024-11-05T14:04:05.918Z | 2024-11-08T14:17:37.667Z |
5471607 | 5471607 | 20241104120844_cEGZ1 | US000U | 2024-11-05T14:04:03.722Z | 2024-11-08T14:17:37.268Z |
5471572 | 5471572 | 20241104120500_ZhZ1t | US000U | 2024-11-05T14:03:57.849Z | 2024-11-08T14:17:36.252Z |
5471520 | 5471520 | 20241104115835_BIRML | US000U | 2024-11-05T14:03:52.399Z | 2024-11-08T14:17:34.867Z |
5471475 | 5471475 | 20241104114810_kNJll | US000U | 2024-11-05T14:03:47.863Z | 2024-11-08T14:17:34.089Z |
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);