participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,277 rows where station_code = "UK003S" 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 |
---|---|---|---|---|---|
1758511 | 1758511 | 20221010222140_n0VgG | UK003S | 2024-01-05T23:50:58.826Z | 2024-01-05T23:50:58.826Z |
1733832 | 1733832 | 20221003214024_XYCC2 | UK003S | 2024-01-05T23:50:44.627Z | 2024-01-05T23:50:44.627Z |
1730050 | 1730050 | 20221002223227_CN5zN | UK003S | 2024-01-05T23:50:42.668Z | 2024-01-05T23:50:42.668Z |
1722600 | 1722600 | 20221001040339_kp0zh | UK003S | 2024-01-05T23:50:39.215Z | 2024-01-05T23:50:39.215Z |
1704257 | 1704257 | 20220927233738_XP3YN | UK003S | 2024-01-05T23:50:33.225Z | 2024-01-05T23:50:33.225Z |
1704064 | 1704064 | 20220927225226_h8mEq | UK003S | 2024-01-05T23:50:33.207Z | 2024-01-05T23:50:33.207Z |
1701822 | 1701822 | 20220927040624_JTgH8 | UK003S | 2024-01-05T23:50:31.547Z | 2024-01-05T23:50:31.547Z |
1684488 | 1684488 | 20220923014633_wBvVy | UK003S | 2024-01-05T23:50:23.066Z | 2024-01-05T23:50:23.066Z |
1654014 | 1654014 | 20220914195910_rCjJk | UK003S | 2024-01-05T23:50:08.459Z | 2024-01-05T23:50:08.459Z |
1649823 | 1649823 | 20220910232933_3c5sZ | UK003S | 2024-01-05T23:50:03.257Z | 2024-01-05T23:50:03.257Z |
1649772 | 1649772 | 20220910231455_W731o | UK003S | 2024-01-05T23:50:03.253Z | 2024-01-05T23:50:03.253Z |
1649689 | 1649689 | 20220910224002_uZuj2 | UK003S | 2024-01-05T23:50:03.243Z | 2024-01-05T23:50:03.243Z |
1648902 | 1648902 | 20220909235311_8Zs7l | UK003S | 2024-01-05T23:50:01.953Z | 2024-01-05T23:50:01.953Z |
1648887 | 1648887 | 20220909233702_OD2CH | UK003S | 2024-01-05T23:50:01.951Z | 2024-01-05T23:50:01.951Z |
1640238 | 1640238 | 20220905232853_k6BB2 | UK003S | 2024-01-05T23:49:56.787Z | 2024-01-05T23:49:56.787Z |
1617400 | 1617400 | 20220831003337_3TDhF | UK003S | 2024-01-05T23:49:43.941Z | 2024-01-05T23:49:43.941Z |
1617301 | 1617301 | 20220831002302_oVUYm | UK003S | 2024-01-05T23:49:43.924Z | 2024-01-05T23:49:43.924Z |
1567928 | 1567928 | 20220815231806_823jM | UK003S | 2024-01-05T23:49:10.093Z | 2024-01-05T23:49:10.093Z |
1566261 | 1566261 | 20220815020413_IEfBr | UK003S | 2024-01-05T23:49:08.688Z | 2024-01-05T23:49:08.688Z |
1566075 | 1566075 | 20220815012521_ehxoE | UK003S | 2024-01-05T23:49:08.665Z | 2024-01-05T23:49:08.665Z |
1566059 | 1566059 | 20220815012109_PlNSy | UK003S | 2024-01-05T23:49:08.662Z | 2024-01-05T23:49:08.662Z |
1565573 | 1565573 | 20220814235044_QRTbr | UK003S | 2024-01-05T23:49:08.595Z | 2024-01-05T23:49:08.595Z |
1565438 | 1565438 | 20220814231959_AZpTa | UK003S | 2024-01-05T23:49:08.580Z | 2024-01-05T23:49:08.580Z |
1560570 | 1560570 | 20220814014431_T6XSg | UK003S | 2024-01-05T23:49:06.766Z | 2024-01-05T23:49:06.766Z |
1560548 | 1560548 | 20220814014404_flG9q | UK003S | 2024-01-05T23:49:06.765Z | 2024-01-05T23:49:06.765Z |
1560517 | 1560517 | 20220814014237_cCNcT | UK003S | 2024-01-05T23:49:06.762Z | 2024-01-05T23:49:06.762Z |
1560452 | 1560452 | 20220814013902_B65Hk | UK003S | 2024-01-05T23:49:06.754Z | 2024-01-05T23:49:06.754Z |
1560250 | 1560250 | 20220814012728_W8n02 | UK003S | 2024-01-05T23:49:06.727Z | 2024-01-05T23:49:06.727Z |
1560089 | 1560089 | 20220814011650_lCQx0 | UK003S | 2024-01-05T23:49:06.707Z | 2024-01-05T23:49:06.707Z |
1559923 | 1559923 | 20220814010856_ZJJYE | UK003S | 2024-01-05T23:49:06.685Z | 2024-01-05T23:49:06.685Z |
1559715 | 1559715 | 20220814005729_7cHOk | UK003S | 2024-01-05T23:49:06.662Z | 2024-01-05T23:49:06.662Z |
1559511 | 1559511 | 20220814004858_qmpHn | UK003S | 2024-01-05T23:49:06.639Z | 2024-01-05T23:49:06.639Z |
1559435 | 1559435 | 20220814004559_oaHX5 | UK003S | 2024-01-05T23:49:06.632Z | 2024-01-05T23:49:06.632Z |
1559127 | 1559127 | 20220814003236_3fMOY | UK003S | 2024-01-05T23:49:06.600Z | 2024-01-05T23:49:06.600Z |
1558897 | 1558897 | 20220814001828_QcDZB | UK003S | 2024-01-05T23:49:06.573Z | 2024-01-05T23:49:06.573Z |
1558654 | 1558654 | 20220814000547_UP9zR | UK003S | 2024-01-05T23:49:06.545Z | 2024-01-05T23:49:06.545Z |
1558196 | 1558196 | 20220813234345_vrX3c | UK003S | 2024-01-05T23:49:06.499Z | 2024-01-05T23:49:06.499Z |
1558103 | 1558103 | 20220813234004_UbE6H | UK003S | 2024-01-05T23:49:06.490Z | 2024-01-05T23:49:06.490Z |
1549350 | 1549350 | 20220813013841_P29bd | UK003S | 2024-01-05T23:49:05.341Z | 2024-01-05T23:49:05.341Z |
1549151 | 1549151 | 20220813013100_gPYDy | UK003S | 2024-01-05T23:49:05.319Z | 2024-01-05T23:49:05.319Z |
1548954 | 1548954 | 20220813012422_Y14Qg | UK003S | 2024-01-05T23:49:05.303Z | 2024-01-05T23:49:05.303Z |
1548937 | 1548937 | 20220813012341_P3Z6x | UK003S | 2024-01-05T23:49:05.302Z | 2024-01-05T23:49:05.302Z |
1548927 | 1548927 | 20220813012323_pWMXy | UK003S | 2024-01-05T23:49:05.301Z | 2024-01-05T23:49:05.301Z |
1548790 | 1548790 | 20220813012009_GkLyG | UK003S | 2024-01-05T23:49:03.752Z | 2024-01-05T23:49:03.752Z |
1548743 | 1548743 | 20220813011825_Oychw | UK003S | 2024-01-05T23:49:03.749Z | 2024-01-05T23:49:03.749Z |
1548273 | 1548273 | 20220813010158_1j8oO | UK003S | 2024-01-05T23:49:03.709Z | 2024-01-05T23:49:03.709Z |
1538217 | 1538217 | 20220812014432_0b18T | UK003S | 2024-01-05T23:49:02.399Z | 2024-01-05T23:49:02.399Z |
1537996 | 1537996 | 20220812012854_aMgaw | UK003S | 2024-01-05T23:49:02.373Z | 2024-01-05T23:49:02.373Z |
1537980 | 1537980 | 20220812012852_GBd2L | UK003S | 2024-01-05T23:49:02.372Z | 2024-01-05T23:49:02.372Z |
1537905 | 1537905 | 20220812012534_G4gBP | UK003S | 2024-01-05T23:49:02.364Z | 2024-01-05T23:49:02.364Z |
1537897 | 1537897 | 20220812012526_p9jdG | UK003S | 2024-01-05T23:49:02.363Z | 2024-01-05T23:49:02.363Z |
1537715 | 1537715 | 20220812011444_fpj2c | UK003S | 2024-01-05T23:49:02.341Z | 2024-01-05T23:49:02.341Z |
1537442 | 1537442 | 20220812010224_iSVYz | UK003S | 2024-01-05T23:49:02.307Z | 2024-01-05T23:49:02.307Z |
1485083 | 1485083 | 20220806015205_RryVd | UK003S | 2024-01-05T23:48:40.421Z | 2024-01-05T23:48:40.421Z |
1485005 | 1485005 | 20220806014944_7jib1 | UK003S | 2024-01-05T23:48:40.409Z | 2024-01-05T23:48:40.409Z |
1484649 | 1484649 | 20220806013340_cEb3Y | UK003S | 2024-01-05T23:48:40.336Z | 2024-01-05T23:48:40.336Z |
1484615 | 1484615 | 20220806013309_LyfRE | UK003S | 2024-01-05T23:48:40.332Z | 2024-01-05T23:48:40.332Z |
1459977 | 1459977 | 20220801020740_RCnW5 | UK003S | 2024-01-05T23:48:22.048Z | 2024-01-05T23:48:22.048Z |
1448620 | 1448620 | 20220729022807_b13o4 | UK003S | 2024-01-05T23:48:13.903Z | 2024-01-05T23:48:13.903Z |
1448520 | 1448520 | 20220729021043_B5s2W | UK003S | 2024-01-05T23:48:13.891Z | 2024-01-05T23:48:13.891Z |
1442421 | 1442421 | 20220727030024_K8tQ4 | UK003S | 2024-01-05T23:48:10.610Z | 2024-01-05T23:48:10.610Z |
1400295 | 1400295 | 20220706021007_54w1y | UK003S | 2024-01-05T23:47:32.925Z | 2024-01-05T23:47:32.925Z |
1392256 | 1392256 | 20220703005714_BBAr6 | UK003S | 2024-01-05T23:47:25.754Z | 2024-01-05T23:47:25.754Z |
1358437 | 1358437 | 20220608225032_3SbUB | UK003S | 2024-01-05T23:46:51.339Z | 2024-01-05T23:46:51.339Z |
1322755 | 1322755 | 20220513222840_3llGN | UK003S | 2024-01-05T23:45:31.690Z | 2024-01-05T23:45:31.690Z |
1320309 | 1320309 | 20220512020030_07DZa | UK003S | 2024-01-05T23:45:29.376Z | 2024-01-05T23:45:29.376Z |
1319685 | 1319685 | 20220511225137_F3qn6 | UK003S | 2024-01-05T23:45:27.083Z | 2024-01-05T23:45:27.083Z |
1319680 | 1319680 | 20220511225035_mpiMV | UK003S | 2024-01-05T23:45:27.082Z | 2024-01-05T23:45:27.082Z |
1319590 | 1319590 | 20220511220441_SQRvt | UK003S | 2024-01-05T23:45:27.061Z | 2024-01-05T23:45:27.061Z |
1319564 | 1319564 | 20220511215246_bzs1W | UK003S | 2024-01-05T23:45:27.056Z | 2024-01-05T23:45:27.056Z |
1317587 | 1317587 | 20220510220658_CP6w1 | UK003S | 2024-01-05T23:45:24.170Z | 2024-01-05T23:45:24.170Z |
1317573 | 1317573 | 20220510215152_8i3fT | UK003S | 2024-01-05T23:45:24.164Z | 2024-01-05T23:45:24.164Z |
1317557 | 1317557 | 20220510212253_C3ad2 | UK003S | 2024-01-05T23:45:24.157Z | 2024-01-05T23:45:24.157Z |
1314365 | 1314365 | 20220509023140_3YU8K | UK003S | 2024-01-05T23:45:17.417Z | 2024-01-05T23:45:17.417Z |
1314165 | 1314165 | 20220509020836_DJ8EE | UK003S | 2024-01-05T23:45:17.396Z | 2024-01-05T23:45:17.396Z |
1313856 | 1313856 | 20220509011021_niJK7 | UK003S | 2024-01-05T23:45:17.363Z | 2024-01-05T23:45:17.363Z |
1313554 | 1313554 | 20220508224555_VwOUZ | UK003S | 2024-01-05T23:45:17.328Z | 2024-01-05T23:45:17.328Z |
1311892 | 1311892 | 20220508023455_nwrqk | UK003S | 2024-01-05T23:45:12.758Z | 2024-01-05T23:45:12.758Z |
1311720 | 1311720 | 20220508012458_ilzAF | UK003S | 2024-01-05T23:45:12.735Z | 2024-01-05T23:45:12.735Z |
1311708 | 1311708 | 20220508011816_DiX3i | UK003S | 2024-01-05T23:45:12.732Z | 2024-01-05T23:45:12.732Z |
1307282 | 1307282 | 20220505230655_xT1k2 | UK003S | 2024-01-05T23:45:03.699Z | 2024-01-05T23:45:03.699Z |
1304687 | 1304687 | 20220505022625_A5weL | UK003S | 2024-01-05T23:45:01.667Z | 2024-01-05T23:45:01.667Z |
1304677 | 1304677 | 20220505022521_MRfEo | UK003S | 2024-01-05T23:45:01.666Z | 2024-01-05T23:45:01.666Z |
1304315 | 1304315 | 20220505013937_2b8vA | UK003S | 2024-01-05T23:45:01.623Z | 2024-01-05T23:45:01.623Z |
1304263 | 1304263 | 20220505012947_6udKW | UK003S | 2024-01-05T23:45:01.616Z | 2024-01-05T23:45:01.616Z |
1304057 | 1304057 | 20220505005020_88nEY | UK003S | 2024-01-05T23:45:01.592Z | 2024-01-05T23:45:01.592Z |
1303893 | 1303893 | 20220505001319_0ysxM | UK003S | 2024-01-05T23:45:01.577Z | 2024-01-05T23:45:01.577Z |
1303749 | 1303749 | 20220504234617_LtGUK | UK003S | 2024-01-05T23:45:01.562Z | 2024-01-05T23:45:01.562Z |
1303682 | 1303682 | 20220504233359_xAHSO | UK003S | 2024-01-05T23:45:01.555Z | 2024-01-05T23:45:01.555Z |
1303604 | 1303604 | 20220504225610_AhTY3 | UK003S | 2024-01-05T23:45:01.544Z | 2024-01-05T23:45:01.544Z |
1303486 | 1303486 | 20220504215258_ruq42 | UK003S | 2024-01-05T23:45:01.528Z | 2024-01-05T23:45:01.528Z |
1295963 | 1295963 | 20220430014441_k7zri | UK003S | 2024-01-05T23:44:41.665Z | 2024-01-05T23:44:41.665Z |
1295727 | 1295727 | 20220430004846_gYqUU | UK003S | 2024-01-05T23:44:41.547Z | 2024-01-05T23:44:41.547Z |
1295541 | 1295541 | 20220430001618_OI5g0 | UK003S | 2024-01-05T23:44:41.450Z | 2024-01-05T23:44:41.450Z |
1295465 | 1295465 | 20220429235455_yVlMs | UK003S | 2024-01-05T23:44:41.397Z | 2024-01-05T23:44:41.397Z |
1295403 | 1295403 | 20220429233738_6m8Ga | UK003S | 2024-01-05T23:44:41.369Z | 2024-01-05T23:44:41.369Z |
1295349 | 1295349 | 20220429233139_3zcuI | UK003S | 2024-01-05T23:44:41.343Z | 2024-01-05T23:44:41.343Z |
1295313 | 1295313 | 20220429232258_fbY0x | UK003S | 2024-01-05T23:44:41.325Z | 2024-01-05T23:44:41.325Z |
1295266 | 1295266 | 20220429230836_NaM7L | UK003S | 2024-01-05T23:44:41.302Z | 2024-01-05T23:44:41.302Z |
1290520 | 1290520 | 20220427023515_VXkdd | UK003S | 2024-01-05T23:44:33.538Z | 2024-01-05T23:44:33.538Z |
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);