participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,918 rows where station_code = "UK0045" 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 |
---|---|---|---|---|---|
5570600 | 5570600 | 20241120202156_1pI0V | UK0045 | 2024-11-22T14:15:52.260Z | 2024-11-22T14:19:21.946Z |
5570473 | 5570473 | 20241120194424_gA4RR | UK0045 | 2024-11-22T14:15:34.200Z | 2024-11-22T14:19:21.922Z |
5570401 | 5570401 | 20241120193252_DUphZ | UK0045 | 2024-11-22T14:15:19.707Z | 2024-11-22T14:19:21.911Z |
5570325 | 5570325 | 20241120191916_Avb1M | UK0045 | 2024-11-22T14:15:09.626Z | 2024-11-22T14:19:21.898Z |
5569765 | 5569765 | 20241120171935_o2iEP | UK0045 | 2024-11-22T14:14:05.656Z | 2024-11-22T14:19:21.800Z |
5569755 | 5569755 | 20241120171800_ve49r | UK0045 | 2024-11-22T14:14:04.643Z | 2024-11-22T14:19:21.798Z |
5569744 | 5569744 | 20241120171459_3QQkf | UK0045 | 2024-11-22T14:14:03.631Z | 2024-11-22T14:19:21.796Z |
5564754 | 5564754 | 20241120032508_85llB | UK0045 | 2024-11-21T14:18:02.258Z | 2024-11-22T14:21:36.304Z |
5564564 | 5564564 | 20241120030951_osvKU | UK0045 | 2024-11-21T14:17:49.722Z | 2024-11-22T14:21:33.538Z |
5563323 | 5563323 | 20241120011703_3fTFv | UK0045 | 2024-11-21T14:15:53.560Z | 2024-11-22T14:21:13.086Z |
5563071 | 5563071 | 20241120004819_Pyamh | UK0045 | 2024-11-21T14:15:34.521Z | 2024-11-22T14:21:09.007Z |
5562810 | 5562810 | 20241120001505_2Vhud | UK0045 | 2024-11-21T14:15:23.326Z | 2024-11-22T14:21:05.039Z |
5562658 | 5562658 | 20241120000233_QSrEj | UK0045 | 2024-11-21T14:15:15.893Z | 2024-11-22T14:21:01.930Z |
5562429 | 5562429 | 20241119233622_oWshd | UK0045 | 2024-11-21T14:14:49.067Z | 2024-11-22T14:20:57.456Z |
5562312 | 5562312 | 20241119232153_a15jI | UK0045 | 2024-11-21T14:14:41.809Z | 2024-11-22T14:20:55.856Z |
5561694 | 5561694 | 20241119214109_x1y4s | UK0045 | 2024-11-21T14:13:46.403Z | 2024-11-22T14:20:43.368Z |
5561290 | 5561290 | 20241119193503_71U1L | UK0045 | 2024-11-21T14:13:01.036Z | 2024-11-22T14:20:30.050Z |
5558139 | 5558139 | 20241120054046_2VdIJ | UK0045 | 2024-11-21T14:02:35.908Z | 2024-11-22T14:19:21.184Z |
5558128 | 5558128 | 20241120053912_RZl1O | UK0045 | 2024-11-21T14:02:34.067Z | 2024-11-22T14:19:21.182Z |
5557924 | 5557924 | 20241120052353_T2V04 | UK0045 | 2024-11-21T14:02:04.616Z | 2024-11-22T14:19:21.147Z |
5557834 | 5557834 | 20241120051721_wS6c8 | UK0045 | 2024-11-21T14:01:53.811Z | 2024-11-22T14:19:21.136Z |
5557802 | 5557802 | 20241120051312_2zbrh | UK0045 | 2024-11-21T14:01:47.974Z | 2024-11-22T14:19:21.130Z |
5557750 | 5557750 | 20241120051025_5i2Zl | UK0045 | 2024-11-21T14:01:39.363Z | 2024-11-22T14:19:21.122Z |
5557586 | 5557586 | 20241120045909_ut2Fp | UK0045 | 2024-11-21T14:01:17.183Z | 2024-11-22T14:19:21.096Z |
5557338 | 5557338 | 20241120043939_s6VBt | UK0045 | 2024-11-21T14:00:34.235Z | 2024-11-22T14:19:21.055Z |
5557307 | 5557307 | 20241120043531_ICooJ | UK0045 | 2024-11-21T14:00:28.488Z | 2024-11-22T14:19:21.050Z |
5545350 | 5545350 | 20241116045630_dVcZR | UK0045 | 2024-11-17T14:04:30.553Z | 2024-11-22T14:23:40.289Z |
5545337 | 5545337 | 20241116045008_8Vr79 | UK0045 | 2024-11-17T14:04:29.900Z | 2024-11-22T14:23:40.242Z |
5545319 | 5545319 | 20241116042727_xgvuc | UK0045 | 2024-11-17T14:04:27.452Z | 2024-11-22T14:23:39.749Z |
5545314 | 5545314 | 20241116042440_4tR3E | UK0045 | 2024-11-17T14:04:26.794Z | 2024-11-22T14:23:39.680Z |
5545293 | 5545293 | 20241116040547_2PH5X | UK0045 | 2024-11-17T14:04:24.637Z | 2024-11-22T14:23:39.536Z |
5532221 | 5532221 | 20241112045305_LtPMK | UK0045 | 2024-11-13T14:16:28.513Z | 2024-11-20T14:26:21.157Z |
5532178 | 5532178 | 20241112044732_7W4pb | UK0045 | 2024-11-13T14:16:25.057Z | 2024-11-20T14:26:20.701Z |
5532123 | 5532123 | 20241112043915_pK3NG | UK0045 | 2024-11-13T14:16:20.318Z | 2024-11-20T14:26:19.004Z |
5531985 | 5531985 | 20241112042519_3bfzU | UK0045 | 2024-11-13T14:16:06.805Z | 2024-11-20T14:26:16.798Z |
5531835 | 5531835 | 20241112041146_T8WGv | UK0045 | 2024-11-13T14:15:57.497Z | 2024-11-20T14:26:15.008Z |
5531403 | 5531403 | 20241112033816_BmM3Q | UK0045 | 2024-11-13T14:15:37.913Z | 2024-11-20T14:26:11.157Z |
5530688 | 5530688 | 20241112023807_9HB72 | UK0045 | 2024-11-13T14:14:27.855Z | 2024-11-20T14:26:02.599Z |
5530490 | 5530490 | 20241112022351_Itng3 | UK0045 | 2024-11-13T14:14:18.754Z | 2024-11-20T14:26:00.822Z |
5530165 | 5530165 | 20241112015313_GLukE | UK0045 | 2024-11-13T14:13:59.695Z | 2024-11-20T14:25:55.076Z |
5529830 | 5529830 | 20241112010725_HZqjI | UK0045 | 2024-11-13T14:13:13.923Z | 2024-11-20T14:25:48.896Z |
5529732 | 5529732 | 20241112010052_l63wZ | UK0045 | 2024-11-13T14:13:08.343Z | 2024-11-20T14:25:47.839Z |
5529665 | 5529665 | 20241112005116_YhDOy | UK0045 | 2024-11-13T14:13:05.338Z | 2024-11-20T14:25:47.334Z |
5529084 | 5529084 | 20241111232743_i632N | UK0045 | 2024-11-13T14:12:03.876Z | 2024-11-20T14:25:39.641Z |
5529044 | 5529044 | 20241111232240_40XSz | UK0045 | 2024-11-13T14:12:00.679Z | 2024-11-20T14:25:39.240Z |
5529032 | 5529032 | 20241111232117_C4C2i | UK0045 | 2024-11-13T14:11:59.377Z | 2024-11-20T14:25:38.866Z |
5529022 | 5529022 | 20241111231939_bFfSs | UK0045 | 2024-11-13T14:11:58.290Z | 2024-11-20T14:25:38.616Z |
5528922 | 5528922 | 20241111230750_pSgUc | UK0045 | 2024-11-13T14:11:40.519Z | 2024-11-20T14:25:37.478Z |
5528848 | 5528848 | 20241111225411_zNPg2 | UK0045 | 2024-11-13T14:11:30.497Z | 2024-11-20T14:25:36.706Z |
5422989 | 5422989 | 20241027013029_R2UDR | UK0045 | 2024-10-30T12:22:38.855Z | 2024-11-04T14:28:55.509Z |
5417696 | 5417696 | 20241027190231_u4h2Z | UK0045 | 2024-10-30T12:14:14.002Z | 2024-11-05T14:27:08.086Z |
5410742 | 5410742 | 20241027053338_M6zDp | UK0045 | 2024-10-29T12:18:04.018Z | 2024-11-04T14:29:05.375Z |
5410521 | 5410521 | 20241027051628_JiLam | UK0045 | 2024-10-29T12:17:57.483Z | 2024-11-04T14:29:04.730Z |
5410473 | 5410473 | 20241027051435_8G2ZC | UK0045 | 2024-10-29T12:17:56.713Z | 2024-11-04T14:29:04.638Z |
5410100 | 5410100 | 20241027045401_25B5I | UK0045 | 2024-10-29T12:17:48.055Z | 2024-11-04T14:29:03.786Z |
5410017 | 5410017 | 20241027044750_J1byC | UK0045 | 2024-10-29T12:17:45.923Z | 2024-11-04T14:29:03.445Z |
5409617 | 5409617 | 20241027042822_BqxLZ | UK0045 | 2024-10-29T12:17:33.873Z | 2024-11-04T14:29:02.017Z |
5409327 | 5409327 | 20241027041115_SFESB | UK0045 | 2024-10-29T12:17:16.723Z | 2024-11-04T14:29:01.584Z |
5409255 | 5409255 | 20241027040735_CKqZO | UK0045 | 2024-10-29T12:17:14.336Z | 2024-11-04T14:29:01.440Z |
5408882 | 5408882 | 20241027034757_LEst2 | UK0045 | 2024-10-29T12:16:55.729Z | 2024-11-04T14:29:00.767Z |
5408850 | 5408850 | 20241027034607_3iyT8 | UK0045 | 2024-10-29T12:16:54.823Z | 2024-11-04T14:29:00.680Z |
5408830 | 5408830 | 20241027034515_XxIix | UK0045 | 2024-10-29T12:16:54.393Z | 2024-11-04T14:29:00.613Z |
5408760 | 5408760 | 20241027034205_8ZCpx | UK0045 | 2024-10-29T12:16:49.206Z | 2024-11-04T14:29:00.463Z |
5408615 | 5408615 | 20241027033232_wxbnM | UK0045 | 2024-10-29T12:16:39.508Z | 2024-11-04T14:28:59.678Z |
5408252 | 5408252 | 20241027031943_YdRX2 | UK0045 | 2024-10-29T12:16:19.995Z | 2024-11-04T14:28:59.037Z |
5408183 | 5408183 | 20241027031414_pK9kX | UK0045 | 2024-10-29T12:16:14.791Z | 2024-11-04T14:28:58.952Z |
5407961 | 5407961 | 20241027030033_2mrzP | UK0045 | 2024-10-29T12:15:55.667Z | 2024-11-04T14:28:58.534Z |
5407947 | 5407947 | 20241027025847_95Suf | UK0045 | 2024-10-29T12:15:54.575Z | 2024-11-04T14:28:58.526Z |
5407745 | 5407745 | 20241027025023_O1W3U | UK0045 | 2024-10-29T12:15:36.986Z | 2024-11-04T14:28:58.092Z |
5407481 | 5407481 | 20241027023845_UqzIV | UK0045 | 2024-10-29T12:15:26.626Z | 2024-11-04T14:28:57.767Z |
5407397 | 5407397 | 20241027023438_s3aUe | UK0045 | 2024-10-29T12:15:23.661Z | 2024-11-04T14:28:57.489Z |
5406989 | 5406989 | 20241027021551_326ji | UK0045 | 2024-10-29T12:15:06.048Z | 2024-11-04T14:28:56.759Z |
5406798 | 5406798 | 20241027020000_RsDrd | UK0045 | 2024-10-29T12:14:43.350Z | 2024-11-04T14:28:56.400Z |
5406608 | 5406608 | 20241027014745_gYKFl | UK0045 | 2024-10-29T12:14:24.107Z | 2024-11-04T14:28:55.909Z |
5406571 | 5406571 | 20241027014608_S6zYW | UK0045 | 2024-10-29T12:14:22.328Z | 2024-11-04T14:28:55.884Z |
5406452 | 5406452 | 20241027013824_kkpkl | UK0045 | 2024-10-29T12:14:10.696Z | 2024-11-04T14:28:55.715Z |
5406121 | 5406121 | 20241027011754_A24cT | UK0045 | 2024-10-29T12:13:52.832Z | 2024-11-04T14:28:55.149Z |
5405589 | 5405589 | 20241027004711_mp5yq | UK0045 | 2024-10-29T12:13:03.710Z | 2024-11-04T14:28:53.648Z |
5405348 | 5405348 | 20241027002923_N3J0M | UK0045 | 2024-10-29T12:12:50.675Z | 2024-11-04T14:28:53.318Z |
5405345 | 5405345 | 20241027002923_pvn6Y | UK0045 | 2024-10-29T12:12:50.509Z | 2024-11-04T14:28:53.313Z |
5404889 | 5404889 | 20241026235904_JgdKl | UK0045 | 2024-10-29T12:12:05.493Z | 2024-11-04T14:28:52.372Z |
5404507 | 5404507 | 20241026233229_n25yi | UK0045 | 2024-10-29T12:11:38.849Z | 2024-11-04T14:28:51.271Z |
5403005 | 5403005 | 20241026210152_4Davd | UK0045 | 2024-10-29T12:08:44.141Z | 2024-11-04T14:28:47.346Z |
5398498 | 5398498 | 20241026030319_Mlyo6 | UK0045 | 2024-10-28T12:19:20.051Z | 2024-11-03T14:27:36.615Z |
5397650 | 5397650 | 20241026014543_c6IEs | UK0045 | 2024-10-28T12:18:31.034Z | 2024-11-03T14:27:33.666Z |
5397395 | 5397395 | 20241026012513_qNFwW | UK0045 | 2024-10-28T12:18:19.510Z | 2024-11-03T14:27:32.774Z |
5397038 | 5397038 | 20241026005836_gvWzk | UK0045 | 2024-10-28T12:18:04.295Z | 2024-11-03T14:27:31.946Z |
5396994 | 5396994 | 20241026005514_5o4vq | UK0045 | 2024-10-28T12:18:01.791Z | 2024-11-03T14:27:31.659Z |
5396921 | 5396921 | 20241026004645_A43DX | UK0045 | 2024-10-28T12:17:59.516Z | 2024-11-03T14:27:31.342Z |
5396690 | 5396690 | 20241026002254_lZXQk | UK0045 | 2024-10-28T12:17:53.273Z | 2024-11-03T14:27:30.695Z |
5396652 | 5396652 | 20241026001954_3IKcj | UK0045 | 2024-10-28T12:17:52.154Z | 2024-11-03T14:27:30.546Z |
5396609 | 5396609 | 20241026001645_6L32Y | UK0045 | 2024-10-28T12:17:51.080Z | 2024-11-03T14:27:30.448Z |
5393572 | 5393572 | 20241025181330_UkDFQ | UK0045 | 2024-10-28T12:12:47.878Z | 2024-11-03T14:27:16.366Z |
5386454 | 5386454 | 20241025004454_Wl1NR | UK0045 | 2024-10-27T12:20:05.804Z | 2024-11-02T12:28:31.260Z |
5386345 | 5386345 | 20241025002759_mOXIH | UK0045 | 2024-10-27T12:20:00.978Z | 2024-11-02T12:28:31.104Z |
5386176 | 5386176 | 20241025001148_jxwvP | UK0045 | 2024-10-27T12:19:54.033Z | 2024-11-02T12:28:30.825Z |
5385949 | 5385949 | 20241024234617_bINre | UK0045 | 2024-10-27T12:19:39.465Z | 2024-11-02T12:28:30.517Z |
5378018 | 5378018 | 20241024052400_4aHkL | UK0045 | 2024-10-26T12:22:52.883Z | 2024-11-01T12:27:03.228Z |
5377982 | 5377982 | 20241024052142_IQBWk | UK0045 | 2024-10-26T12:22:51.580Z | 2024-11-01T12:27:03.212Z |
5377759 | 5377759 | 20241024050757_s0IkZ | UK0045 | 2024-10-26T12:22:46.430Z | 2024-11-01T12:27:02.774Z |
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);