participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,316 rows where station_code = "UK005P" 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 |
---|---|---|---|---|---|
5570474 | 5570474 | 20241120194424_gA4RR | UK005P | 2024-11-22T14:15:34.200Z | 2024-11-22T14:19:21.923Z |
5570327 | 5570327 | 20241120191916_Avb1M | UK005P | 2024-11-22T14:15:09.627Z | 2024-11-22T14:19:21.898Z |
5569756 | 5569756 | 20241120171800_ve49r | UK005P | 2024-11-22T14:14:04.643Z | 2024-11-22T14:19:21.798Z |
5562314 | 5562314 | 20241119232153_a15jI | UK005P | 2024-11-21T14:14:41.809Z | 2024-11-22T14:20:55.856Z |
5561259 | 5561259 | 20241119192426_y9mqs | UK005P | 2024-11-21T14:12:51.616Z | 2024-11-22T14:20:28.957Z |
5561201 | 5561201 | 20241119190315_fEy3y | UK005P | 2024-11-21T14:12:36.132Z | 2024-11-22T14:20:26.162Z |
5558450 | 5558450 | 20241120060552_0RyG1 | UK005P | 2024-11-21T14:03:17.251Z | 2024-11-22T14:19:21.231Z |
5558257 | 5558257 | 20241120054954_SUK0A | UK005P | 2024-11-21T14:02:52.628Z | 2024-11-22T14:19:21.200Z |
5558141 | 5558141 | 20241120054046_2VdIJ | UK005P | 2024-11-21T14:02:35.908Z | 2024-11-22T14:19:21.184Z |
5558130 | 5558130 | 20241120053912_RZl1O | UK005P | 2024-11-21T14:02:34.067Z | 2024-11-22T14:19:21.182Z |
5545351 | 5545351 | 20241116045630_dVcZR | UK005P | 2024-11-17T14:04:30.553Z | 2024-11-22T14:23:40.289Z |
5545315 | 5545315 | 20241116042440_4tR3E | UK005P | 2024-11-17T14:04:26.794Z | 2024-11-22T14:23:39.680Z |
5532223 | 5532223 | 20241112045305_LtPMK | UK005P | 2024-11-13T14:16:28.513Z | 2024-11-20T14:26:21.157Z |
5532136 | 5532136 | 20241112044027_l6UuB | UK005P | 2024-11-13T14:16:21.303Z | 2024-11-20T14:26:20.149Z |
5531688 | 5531688 | 20241112040005_ItT5h | UK005P | 2024-11-13T14:15:50.803Z | 2024-11-20T14:26:13.469Z |
5531404 | 5531404 | 20241112033816_BmM3Q | UK005P | 2024-11-13T14:15:37.913Z | 2024-11-20T14:26:11.157Z |
5530937 | 5530937 | 20241112030112_UmMcE | UK005P | 2024-11-13T14:14:52.423Z | 2024-11-20T14:26:05.382Z |
5530166 | 5530166 | 20241112015313_GLukE | UK005P | 2024-11-13T14:13:59.695Z | 2024-11-20T14:25:55.076Z |
5530007 | 5530007 | 20241112013613_7O8C4 | UK005P | 2024-11-13T14:13:38.142Z | 2024-11-20T14:25:52.453Z |
5529995 | 5529995 | 20241112013325_4GuW8 | UK005P | 2024-11-13T14:13:35.669Z | 2024-11-20T14:25:52.348Z |
5529832 | 5529832 | 20241112010725_HZqjI | UK005P | 2024-11-13T14:13:13.923Z | 2024-11-20T14:25:48.896Z |
5529086 | 5529086 | 20241111232743_i632N | UK005P | 2024-11-13T14:12:03.876Z | 2024-11-20T14:25:39.641Z |
5529033 | 5529033 | 20241111232117_C4C2i | UK005P | 2024-11-13T14:11:59.377Z | 2024-11-20T14:25:38.866Z |
5529024 | 5529024 | 20241111231939_bFfSs | UK005P | 2024-11-13T14:11:58.312Z | 2024-11-20T14:25:38.616Z |
5417697 | 5417697 | 20241027190231_u4h2Z | UK005P | 2024-10-30T12:14:14.012Z | 2024-11-05T14:27:08.086Z |
5410536 | 5410536 | 20241027051649_kMZ98 | UK005P | 2024-10-29T12:17:57.728Z | 2024-11-04T14:29:04.736Z |
5410101 | 5410101 | 20241027045401_25B5I | UK005P | 2024-10-29T12:17:48.055Z | 2024-11-04T14:29:03.786Z |
5410018 | 5410018 | 20241027044750_J1byC | UK005P | 2024-10-29T12:17:45.924Z | 2024-11-04T14:29:03.445Z |
5409257 | 5409257 | 20241027040735_CKqZO | UK005P | 2024-10-29T12:17:14.336Z | 2024-11-04T14:29:01.440Z |
5408761 | 5408761 | 20241027034205_8ZCpx | UK005P | 2024-10-29T12:16:49.206Z | 2024-11-04T14:29:00.463Z |
5408616 | 5408616 | 20241027033232_wxbnM | UK005P | 2024-10-29T12:16:39.508Z | 2024-11-04T14:28:59.678Z |
5408185 | 5408185 | 20241027031414_pK9kX | UK005P | 2024-10-29T12:16:14.791Z | 2024-11-04T14:28:58.952Z |
5407963 | 5407963 | 20241027030033_2mrzP | UK005P | 2024-10-29T12:15:55.667Z | 2024-11-04T14:28:58.534Z |
5407949 | 5407949 | 20241027025847_95Suf | UK005P | 2024-10-29T12:15:54.575Z | 2024-11-04T14:28:58.526Z |
5407746 | 5407746 | 20241027025023_O1W3U | UK005P | 2024-10-29T12:15:36.986Z | 2024-11-04T14:28:58.092Z |
5407398 | 5407398 | 20241027023438_s3aUe | UK005P | 2024-10-29T12:15:23.661Z | 2024-11-04T14:28:57.489Z |
5405836 | 5405836 | 20241027010247_3H2ma | UK005P | 2024-10-29T12:13:21.456Z | 2024-11-04T14:28:54.421Z |
5405759 | 5405759 | 20241027005551_3TGSo | UK005P | 2024-10-29T12:13:13.244Z | 2024-11-04T14:28:54.154Z |
5404464 | 5404464 | 20241026232939_9d72X | UK005P | 2024-10-29T12:11:31.528Z | 2024-11-04T14:28:51.080Z |
5404285 | 5404285 | 20241026231423_MNKg2 | UK005P | 2024-10-29T12:11:05.042Z | 2024-11-04T14:28:50.582Z |
5404028 | 5404028 | 20241026225341_GOqcS | UK005P | 2024-10-29T12:10:48.642Z | 2024-11-04T14:28:50.252Z |
5404009 | 5404009 | 20241026225255_PE3NF | UK005P | 2024-10-29T12:10:47.501Z | 2024-11-04T14:28:50.217Z |
5403958 | 5403958 | 20241026224822_NUqTY | UK005P | 2024-10-29T12:10:38.410Z | 2024-11-04T14:28:50.108Z |
5403544 | 5403544 | 20241026220826_S6kg3 | UK005P | 2024-10-29T12:09:50.677Z | 2024-11-04T14:28:49.134Z |
5403397 | 5403397 | 20241026215123_OROH7 | UK005P | 2024-10-29T12:09:27.240Z | 2024-11-04T14:28:48.692Z |
5403392 | 5403392 | 20241026215039_3i3Uv | UK005P | 2024-10-29T12:09:26.815Z | 2024-11-04T14:28:48.683Z |
5403013 | 5403013 | 20241026210248_YapMr | UK005P | 2024-10-29T12:08:44.520Z | 2024-11-04T14:28:47.372Z |
5403006 | 5403006 | 20241026210152_4Davd | UK005P | 2024-10-29T12:08:44.155Z | 2024-11-04T14:28:47.346Z |
5398768 | 5398768 | 20241026032713_xJqcw | UK005P | 2024-10-28T12:19:32.167Z | 2024-11-03T14:27:38.046Z |
5398591 | 5398591 | 20241026031039_vPqh5 | UK005P | 2024-10-28T12:19:23.570Z | 2024-11-03T14:27:36.886Z |
5398559 | 5398559 | 20241026030757_BGq41 | UK005P | 2024-10-28T12:19:21.872Z | 2024-11-03T14:27:36.791Z |
5398394 | 5398394 | 20241026025248_voi50 | UK005P | 2024-10-28T12:19:13.789Z | 2024-11-03T14:27:36.238Z |
5398390 | 5398390 | 20241026025220_QSskz | UK005P | 2024-10-28T12:19:13.697Z | 2024-11-03T14:27:36.234Z |
5397918 | 5397918 | 20241026020645_1TBcY | UK005P | 2024-10-28T12:18:50.392Z | 2024-11-03T14:27:34.533Z |
5397651 | 5397651 | 20241026014543_c6IEs | UK005P | 2024-10-28T12:18:31.034Z | 2024-11-03T14:27:33.666Z |
5397613 | 5397613 | 20241026014323_9073P | UK005P | 2024-10-28T12:18:30.272Z | 2024-11-03T14:27:33.607Z |
5397552 | 5397552 | 20241026013937_hXSjq | UK005P | 2024-10-28T12:18:27.207Z | 2024-11-03T14:27:33.376Z |
5396996 | 5396996 | 20241026005514_5o4vq | UK005P | 2024-10-28T12:18:01.791Z | 2024-11-03T14:27:31.659Z |
5396982 | 5396982 | 20241026005427_6Xeat | UK005P | 2024-10-28T12:18:01.546Z | 2024-11-03T14:27:31.616Z |
5396922 | 5396922 | 20241026004645_A43DX | UK005P | 2024-10-28T12:17:59.516Z | 2024-11-03T14:27:31.342Z |
5396900 | 5396900 | 20241026004441_nsLYm | UK005P | 2024-10-28T12:17:58.969Z | 2024-11-03T14:27:31.303Z |
5396654 | 5396654 | 20241026001954_3IKcj | UK005P | 2024-10-28T12:17:52.154Z | 2024-11-03T14:27:30.546Z |
5394252 | 5394252 | 20241025200344_P7zKI | UK005P | 2024-10-28T12:14:15.919Z | 2024-11-03T14:27:20.485Z |
5386953 | 5386953 | 20241025014347_94Zcn | UK005P | 2024-10-27T12:20:43.071Z | 2024-11-02T12:28:31.752Z |
5386630 | 5386630 | 20241025010714_bQdE9 | UK005P | 2024-10-27T12:20:12.397Z | 2024-11-02T12:28:31.401Z |
5386550 | 5386550 | 20241025010057_3sS9I | UK005P | 2024-10-27T12:20:10.244Z | 2024-11-02T12:28:31.335Z |
5386488 | 5386488 | 20241025004810_rd2zz | UK005P | 2024-10-27T12:20:07.784Z | 2024-11-02T12:28:31.272Z |
5386455 | 5386455 | 20241025004454_Wl1NR | UK005P | 2024-10-27T12:20:05.804Z | 2024-11-02T12:28:31.260Z |
5384506 | 5384506 | 20241024201525_K0Ycc | UK005P | 2024-10-27T12:17:08.727Z | 2024-11-02T12:28:27.259Z |
5376868 | 5376868 | 20241024042013_nqbi4 | UK005P | 2024-10-26T12:22:15.230Z | 2024-11-01T12:27:01.902Z |
5376413 | 5376413 | 20241024035412_pH6us | UK005P | 2024-10-26T12:22:01.920Z | 2024-11-01T12:27:01.532Z |
5376371 | 5376371 | 20241024035250_Ehu2q | UK005P | 2024-10-26T12:21:59.400Z | 2024-11-01T12:27:01.515Z |
5376165 | 5376165 | 20241024034430_M2F1P | UK005P | 2024-10-26T12:21:52.561Z | 2024-11-01T12:27:01.416Z |
5375708 | 5375708 | 20241024032606_7Vgp6 | UK005P | 2024-10-26T12:21:35.918Z | 2024-11-01T12:27:01.167Z |
5375241 | 5375241 | 20241024030409_RiJpp | UK005P | 2024-10-26T12:21:17.252Z | 2024-11-01T12:27:00.458Z |
5375105 | 5375105 | 20241024025738_YN2WV | UK005P | 2024-10-26T12:21:13.083Z | 2024-11-01T12:27:00.288Z |
5374878 | 5374878 | 20241024024809_DIeHQ | UK005P | 2024-10-26T12:21:04.843Z | 2024-11-01T12:27:00.025Z |
5374855 | 5374855 | 20241024024631_gi4xc | UK005P | 2024-10-26T12:21:03.555Z | 2024-11-01T12:27:00.012Z |
5374610 | 5374610 | 20241024023658_HDLoC | UK005P | 2024-10-26T12:20:54.724Z | 2024-11-01T12:26:59.519Z |
5374144 | 5374144 | 20241024021211_AyF24 | UK005P | 2024-10-26T12:20:37.801Z | 2024-11-01T12:26:58.709Z |
5373785 | 5373785 | 20241024015354_yHnOi | UK005P | 2024-10-26T12:20:25.618Z | 2024-11-01T12:26:58.476Z |
5373103 | 5373103 | 20241024012425_OrOI1 | UK005P | 2024-10-26T12:19:57.799Z | 2024-11-01T12:26:58.133Z |
5372827 | 5372827 | 20241024011025_a0l5w | UK005P | 2024-10-26T12:19:44.875Z | 2024-11-01T12:26:57.930Z |
5372554 | 5372554 | 20241024005415_mF60X | UK005P | 2024-10-26T12:19:30.238Z | 2024-11-01T12:26:57.513Z |
5372219 | 5372219 | 20241024003900_yq8BJ | UK005P | 2024-10-26T12:19:15.154Z | 2024-11-01T12:26:57.312Z |
5366430 | 5366430 | 20241024002026_if98W | UK005P | 2024-10-25T12:18:26.369Z | 2024-11-01T12:26:56.957Z |
5366350 | 5366350 | 20241024001641_Xw2v2 | UK005P | 2024-10-25T12:18:23.934Z | 2024-11-01T12:26:56.904Z |
5366259 | 5366259 | 20241024001305_jH4de | UK005P | 2024-10-25T12:18:19.978Z | 2024-11-01T12:26:56.822Z |
5365444 | 5365444 | 20241023233317_7MCd3 | UK005P | 2024-10-25T12:17:58.112Z | 2024-11-01T12:26:56.132Z |
5365106 | 5365106 | 20241023231430_IU9Mb | UK005P | 2024-10-25T12:17:46.199Z | 2024-11-01T12:26:55.877Z |
5364942 | 5364942 | 20241023230517_JXwnp | UK005P | 2024-10-25T12:17:40.958Z | 2024-11-01T12:26:55.781Z |
5364922 | 5364922 | 20241023230310_WXGLG | UK005P | 2024-10-25T12:17:40.418Z | 2024-11-01T12:26:55.755Z |
5364740 | 5364740 | 20241023225030_wVRlw | UK005P | 2024-10-25T12:17:31.834Z | 2024-11-01T12:26:55.604Z |
5363709 | 5363709 | 20241023213657_4n2vH | UK005P | 2024-10-25T12:16:37.063Z | 2024-11-01T12:26:53.542Z |
5363687 | 5363687 | 20241023213550_FYR1W | UK005P | 2024-10-25T12:16:34.939Z | 2024-11-01T12:26:53.500Z |
5355377 | 5355377 | 20241023033616_fvxp4 | UK005P | 2024-10-24T12:21:17.284Z | 2024-10-31T12:30:07.573Z |
5352527 | 5352527 | 20241023003748_v8Lyd | UK005P | 2024-10-24T12:18:55.260Z | 2024-10-31T12:30:02.859Z |
5352398 | 5352398 | 20241023003107_tWTGk | UK005P | 2024-10-24T12:18:44.612Z | 2024-10-31T12:30:02.594Z |
5352384 | 5352384 | 20241023003012_JhHSG | UK005P | 2024-10-24T12:18:43.033Z | 2024-10-31T12:30:02.572Z |
5352357 | 5352357 | 20241023002813_x3E3w | UK005P | 2024-10-24T12:18:40.052Z | 2024-10-31T12:30:02.506Z |
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);