participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,047 rows where station_code = "UK003H" 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 |
---|---|---|---|---|---|
1763915 | 1763915 | 20221013033822_TMIP5 | UK003H | 2024-01-05T23:51:01.851Z | 2024-01-05T23:51:01.851Z |
1763852 | 1763852 | 20221013032532_Jx4xP | UK003H | 2024-01-05T23:51:01.845Z | 2024-01-05T23:51:01.845Z |
1761136 | 1761136 | 20221011223100_31y8u | UK003H | 2024-01-05T23:51:00.326Z | 2024-01-05T23:51:00.326Z |
1760853 | 1760853 | 20221011194844_92PBL | UK003H | 2024-01-05T23:51:00.297Z | 2024-01-05T23:51:00.297Z |
1760811 | 1760811 | 20221011192748_H0K4z | UK003H | 2024-01-05T23:51:00.292Z | 2024-01-05T23:51:00.292Z |
1758820 | 1758820 | 20221011005451_GJ9nP | UK003H | 2024-01-05T23:50:58.855Z | 2024-01-05T23:50:58.855Z |
1758496 | 1758496 | 20221010220544_e9DBS | UK003H | 2024-01-05T23:50:58.824Z | 2024-01-05T23:50:58.824Z |
1758427 | 1758427 | 20221010205354_xmyQO | UK003H | 2024-01-05T23:50:58.817Z | 2024-01-05T23:50:58.817Z |
1758411 | 1758411 | 20221010204852_CYNgn | UK003H | 2024-01-05T23:50:58.816Z | 2024-01-05T23:50:58.816Z |
1758301 | 1758301 | 20221010190547_w00Qm | UK003H | 2024-01-05T23:50:58.806Z | 2024-01-05T23:50:58.806Z |
1756543 | 1756543 | 20221009051338_3oCof | UK003H | 2024-01-05T23:50:55.375Z | 2024-01-05T23:50:55.375Z |
1756055 | 1756055 | 20221009035627_03GCL | UK003H | 2024-01-05T23:50:55.339Z | 2024-01-05T23:50:55.339Z |
1755822 | 1755822 | 20221009031216_oLszX | UK003H | 2024-01-05T23:50:55.315Z | 2024-01-05T23:50:55.315Z |
1755666 | 1755666 | 20221009024613_Dd29i | UK003H | 2024-01-05T23:50:55.301Z | 2024-01-05T23:50:55.301Z |
1755205 | 1755205 | 20221009004250_Zkv7S | UK003H | 2024-01-05T23:50:55.253Z | 2024-01-05T23:50:55.253Z |
1755177 | 1755177 | 20221009003549_rq7W2 | UK003H | 2024-01-05T23:50:55.251Z | 2024-01-05T23:50:55.251Z |
1755159 | 1755159 | 20221009003243_NyuQ2 | UK003H | 2024-01-05T23:50:55.249Z | 2024-01-05T23:50:55.249Z |
1755014 | 1755014 | 20221008235322_TGYna | UK003H | 2024-01-05T23:50:55.236Z | 2024-01-05T23:50:55.236Z |
1754989 | 1754989 | 20221008234540_u4lpY | UK003H | 2024-01-05T23:50:55.233Z | 2024-01-05T23:50:55.233Z |
1754919 | 1754919 | 20221008232831_43kNG | UK003H | 2024-01-05T23:50:55.227Z | 2024-01-05T23:50:55.227Z |
1754860 | 1754860 | 20221008231333_T3MF9 | UK003H | 2024-01-05T23:50:55.220Z | 2024-01-05T23:50:55.220Z |
1753256 | 1753256 | 20221008043211_guuNh | UK003H | 2024-01-05T23:50:53.261Z | 2024-01-05T23:50:53.261Z |
1753112 | 1753112 | 20221008042202_luju7 | UK003H | 2024-01-05T23:50:53.251Z | 2024-01-05T23:50:53.251Z |
1752906 | 1752906 | 20221008040918_XunFF | UK003H | 2024-01-05T23:50:53.235Z | 2024-01-05T23:50:53.235Z |
1752891 | 1752891 | 20221008040722_OaZBT | UK003H | 2024-01-05T23:50:53.234Z | 2024-01-05T23:50:53.234Z |
1752810 | 1752810 | 20221008040213_Gl2XO | UK003H | 2024-01-05T23:50:53.229Z | 2024-01-05T23:50:53.229Z |
1752247 | 1752247 | 20221008030842_MwcEO | UK003H | 2024-01-05T23:50:53.181Z | 2024-01-05T23:50:53.181Z |
1752220 | 1752220 | 20221008030419_Njjzs | UK003H | 2024-01-05T23:50:53.179Z | 2024-01-05T23:50:53.179Z |
1751401 | 1751401 | 20221008012441_aUQtk | UK003H | 2024-01-05T23:50:53.111Z | 2024-01-05T23:50:53.111Z |
1750953 | 1750953 | 20221007233811_V5U2R | UK003H | 2024-01-05T23:50:53.076Z | 2024-01-05T23:50:53.076Z |
1750813 | 1750813 | 20221007223333_HEIBq | UK003H | 2024-01-05T23:50:53.062Z | 2024-01-05T23:50:53.062Z |
1750657 | 1750657 | 20221007212552_6RiNm | UK003H | 2024-01-05T23:50:53.046Z | 2024-01-05T23:50:53.046Z |
1750591 | 1750591 | 20221007210231_rAba0 | UK003H | 2024-01-05T23:50:53.040Z | 2024-01-05T23:50:53.040Z |
1750462 | 1750462 | 20221007201411_rRZ6O | UK003H | 2024-01-05T23:50:53.026Z | 2024-01-05T23:50:53.026Z |
1750425 | 1750425 | 20221007200337_d7w2N | UK003H | 2024-01-05T23:50:53.022Z | 2024-01-05T23:50:53.022Z |
1748552 | 1748552 | 20221007024520_iY1Ex | UK003H | 2024-01-05T23:50:51.251Z | 2024-01-05T23:50:51.251Z |
1745689 | 1745689 | 20221006045120_DX505 | UK003H | 2024-01-05T23:50:49.497Z | 2024-01-05T23:50:49.497Z |
1745670 | 1745670 | 20221006045033_PN1RN | UK003H | 2024-01-05T23:50:49.495Z | 2024-01-05T23:50:49.495Z |
1745049 | 1745049 | 20221006041819_s27nO | UK003H | 2024-01-05T23:50:49.454Z | 2024-01-05T23:50:49.454Z |
1744748 | 1744748 | 20221006040025_t0NJs | UK003H | 2024-01-05T23:50:49.431Z | 2024-01-05T23:50:49.431Z |
1744585 | 1744585 | 20221006035606_3sR21 | UK003H | 2024-01-05T23:50:49.421Z | 2024-01-05T23:50:49.421Z |
1744296 | 1744296 | 20221006034122_vduvP | UK003H | 2024-01-05T23:50:49.403Z | 2024-01-05T23:50:49.403Z |
1744098 | 1744098 | 20221006033450_dRyv6 | UK003H | 2024-01-05T23:50:49.392Z | 2024-01-05T23:50:49.392Z |
1742994 | 1742994 | 20221006022101_Ie2Vi | UK003H | 2024-01-05T23:50:49.303Z | 2024-01-05T23:50:49.303Z |
1742864 | 1742864 | 20221006021407_TRarZ | UK003H | 2024-01-05T23:50:49.294Z | 2024-01-05T23:50:49.294Z |
1742600 | 1742600 | 20221006015927_ISVXn | UK003H | 2024-01-05T23:50:49.273Z | 2024-01-05T23:50:49.273Z |
1742538 | 1742538 | 20221006015700_DFgI0 | UK003H | 2024-01-05T23:50:49.269Z | 2024-01-05T23:50:49.269Z |
1742467 | 1742467 | 20221006015218_YqGtU | UK003H | 2024-01-05T23:50:49.264Z | 2024-01-05T23:50:49.264Z |
1742272 | 1742272 | 20221006014144_1D9mJ | UK003H | 2024-01-05T23:50:49.247Z | 2024-01-05T23:50:49.247Z |
1742080 | 1742080 | 20221006013147_UwcRY | UK003H | 2024-01-05T23:50:49.233Z | 2024-01-05T23:50:49.233Z |
1742058 | 1742058 | 20221006013011_SqJVa | UK003H | 2024-01-05T23:50:49.231Z | 2024-01-05T23:50:49.231Z |
1741534 | 1741534 | 20221006004310_t7eU3 | UK003H | 2024-01-05T23:50:49.189Z | 2024-01-05T23:50:49.189Z |
1741375 | 1741375 | 20221006002119_VzhcE | UK003H | 2024-01-05T23:50:49.172Z | 2024-01-05T23:50:49.172Z |
1740672 | 1740672 | 20221005223739_2InQC | UK003H | 2024-01-05T23:50:49.110Z | 2024-01-05T23:50:49.110Z |
1740566 | 1740566 | 20221005222538_TndV7 | UK003H | 2024-01-05T23:50:49.102Z | 2024-01-05T23:50:49.102Z |
1740486 | 1740486 | 20221005221338_yA6ER | UK003H | 2024-01-05T23:50:49.096Z | 2024-01-05T23:50:49.096Z |
1740391 | 1740391 | 20221005215304_aheKv | UK003H | 2024-01-05T23:50:49.089Z | 2024-01-05T23:50:49.089Z |
1739955 | 1739955 | 20221005195622_wNMsz | UK003H | 2024-01-05T23:50:49.046Z | 2024-01-05T23:50:49.046Z |
1730628 | 1730628 | 20221003000253_8ZPhZ | UK003H | 2024-01-05T23:50:42.721Z | 2024-01-05T23:50:42.721Z |
1730546 | 1730546 | 20221002234448_Mk0ns | UK003H | 2024-01-05T23:50:42.713Z | 2024-01-05T23:50:42.713Z |
1729874 | 1729874 | 20221002215801_HgnTm | UK003H | 2024-01-05T23:50:42.653Z | 2024-01-05T23:50:42.653Z |
1729636 | 1729636 | 20221002210819_f9JYJ | UK003H | 2024-01-05T23:50:42.630Z | 2024-01-05T23:50:42.630Z |
1729580 | 1729580 | 20221002204848_7aZzk | UK003H | 2024-01-05T23:50:42.623Z | 2024-01-05T23:50:42.623Z |
1729544 | 1729544 | 20221002203924_C0yBq | UK003H | 2024-01-05T23:50:42.619Z | 2024-01-05T23:50:42.619Z |
1729341 | 1729341 | 20221002195009_xc83N | UK003H | 2024-01-05T23:50:42.600Z | 2024-01-05T23:50:42.600Z |
1722232 | 1722232 | 20221001032543_dP8rV | UK003H | 2024-01-05T23:50:39.185Z | 2024-01-05T23:50:39.185Z |
1722057 | 1722057 | 20221001030505_lFDpp | UK003H | 2024-01-05T23:50:39.169Z | 2024-01-05T23:50:39.169Z |
1722060 | 1722060 | 20221001030839_MelKI | UK003H | 2024-01-05T23:50:39.169Z | 2024-01-05T23:50:39.169Z |
1721569 | 1721569 | 20221001020032_MS3hS | UK003H | 2024-01-05T23:50:39.122Z | 2024-01-05T23:50:39.122Z |
1721465 | 1721465 | 20221001015046_JcRi9 | UK003H | 2024-01-05T23:50:39.115Z | 2024-01-05T23:50:39.115Z |
1721388 | 1721388 | 20221001013930_I45A3 | UK003H | 2024-01-05T23:50:39.108Z | 2024-01-05T23:50:39.108Z |
1721327 | 1721327 | 20221001013214_zGp3i | UK003H | 2024-01-05T23:50:39.104Z | 2024-01-05T23:50:39.104Z |
1720749 | 1720749 | 20220930232851_ao0fo | UK003H | 2024-01-05T23:50:39.050Z | 2024-01-05T23:50:39.050Z |
1717376 | 1717376 | 20220930044134_ik8S0 | UK003H | 2024-01-05T23:50:37.466Z | 2024-01-05T23:50:37.466Z |
1717320 | 1717320 | 20220930043427_lNBF0 | UK003H | 2024-01-05T23:50:37.459Z | 2024-01-05T23:50:37.459Z |
1717151 | 1717151 | 20220930041247_W3yV6 | UK003H | 2024-01-05T23:50:37.440Z | 2024-01-05T23:50:37.440Z |
1717154 | 1717154 | 20220930041318_kn3bM | UK003H | 2024-01-05T23:50:37.440Z | 2024-01-05T23:50:37.440Z |
1716884 | 1716884 | 20220930034513_aTiZb | UK003H | 2024-01-05T23:50:37.414Z | 2024-01-05T23:50:37.414Z |
1716711 | 1716711 | 20220930032829_tzTpK | UK003H | 2024-01-05T23:50:37.398Z | 2024-01-05T23:50:37.398Z |
1716142 | 1716142 | 20220930023420_xVt8e | UK003H | 2024-01-05T23:50:37.348Z | 2024-01-05T23:50:37.348Z |
1716021 | 1716021 | 20220930022423_Uw9OT | UK003H | 2024-01-05T23:50:37.336Z | 2024-01-05T23:50:37.336Z |
1715845 | 1715845 | 20220930020656_rXH7Y | UK003H | 2024-01-05T23:50:37.319Z | 2024-01-05T23:50:37.319Z |
1715470 | 1715470 | 20220930012229_rC5HK | UK003H | 2024-01-05T23:50:37.285Z | 2024-01-05T23:50:37.285Z |
1715343 | 1715343 | 20220930010849_blWvT | UK003H | 2024-01-05T23:50:37.273Z | 2024-01-05T23:50:37.273Z |
1714289 | 1714289 | 20220929231919_2IPcY | UK003H | 2024-01-05T23:50:37.182Z | 2024-01-05T23:50:37.182Z |
1714095 | 1714095 | 20220929225244_aY65R | UK003H | 2024-01-05T23:50:37.164Z | 2024-01-05T23:50:37.164Z |
1713851 | 1713851 | 20220929222345_3lF2S | UK003H | 2024-01-05T23:50:37.144Z | 2024-01-05T23:50:37.144Z |
1713794 | 1713794 | 20220929221452_agqKW | UK003H | 2024-01-05T23:50:37.137Z | 2024-01-05T23:50:37.137Z |
1713743 | 1713743 | 20220929220447_MQYGb | UK003H | 2024-01-05T23:50:37.131Z | 2024-01-05T23:50:37.131Z |
1713729 | 1713729 | 20220929220409_4N6lH | UK003H | 2024-01-05T23:50:37.130Z | 2024-01-05T23:50:37.130Z |
1713660 | 1713660 | 20220929215805_zMyo9 | UK003H | 2024-01-05T23:50:37.125Z | 2024-01-05T23:50:37.125Z |
1713488 | 1713488 | 20220929212948_r28PX | UK003H | 2024-01-05T23:50:37.108Z | 2024-01-05T23:50:37.108Z |
1713205 | 1713205 | 20220929202405_cwm1R | UK003H | 2024-01-05T23:50:37.076Z | 2024-01-05T23:50:37.076Z |
1713188 | 1713188 | 20220929202031_3aGlE | UK003H | 2024-01-05T23:50:37.075Z | 2024-01-05T23:50:37.075Z |
1713021 | 1713021 | 20220929194751_cpHcb | UK003H | 2024-01-05T23:50:37.058Z | 2024-01-05T23:50:37.058Z |
1709909 | 1709909 | 20220929002245_TwK6O | UK003H | 2024-01-05T23:50:35.215Z | 2024-01-05T23:50:35.215Z |
1709882 | 1709882 | 20220929001606_U9yIm | UK003H | 2024-01-05T23:50:35.212Z | 2024-01-05T23:50:35.212Z |
1709798 | 1709798 | 20220929000157_2ag6H | UK003H | 2024-01-05T23:50:35.205Z | 2024-01-05T23:50:35.205Z |
1709596 | 1709596 | 20220928231729_RU2F4 | UK003H | 2024-01-05T23:50:35.184Z | 2024-01-05T23:50:35.184Z |
1709582 | 1709582 | 20220928231133_HYZlc | UK003H | 2024-01-05T23:50:35.183Z | 2024-01-05T23:50:35.183Z |
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);