participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,292 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 |
---|---|---|---|---|---|
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 |
5352355 | 5352355 | 20241023002813_vLx5L | UK005P | 2024-10-24T12:18:39.992Z | 2024-10-31T12:30:02.505Z |
5343537 | 5343537 | 20241022033341_kgi27 | UK005P | 2024-10-23T12:17:49.179Z | 2024-10-30T12:26:50.174Z |
5343024 | 5343024 | 20241022030111_MMzed | UK005P | 2024-10-23T12:17:32.298Z | 2024-10-30T12:26:49.154Z |
5342004 | 5342004 | 20241022020308_jSvYx | UK005P | 2024-10-23T12:16:28.031Z | 2024-10-30T12:26:47.786Z |
5341772 | 5341772 | 20241022015211_KEKCL | UK005P | 2024-10-23T12:16:12.524Z | 2024-10-30T12:26:47.452Z |
5341732 | 5341732 | 20241022015040_Li9EL | UK005P | 2024-10-23T12:16:10.707Z | 2024-10-30T12:26:47.433Z |
5341685 | 5341685 | 20241022014847_1INSJ | UK005P | 2024-10-23T12:16:06.998Z | 2024-10-30T12:26:47.337Z |
5341485 | 5341485 | 20241022013810_xGw8z | UK005P | 2024-10-23T12:15:55.179Z | 2024-10-30T12:26:47.108Z |
5341445 | 5341445 | 20241022013554_8YDqK | UK005P | 2024-10-23T12:15:50.607Z | 2024-10-30T12:26:47.032Z |
5341033 | 5341033 | 20241022011021_g6Kpf | UK005P | 2024-10-23T12:15:14.343Z | 2024-10-30T12:26:46.527Z |
5340995 | 5340995 | 20241022010747_aGvXB | UK005P | 2024-10-23T12:15:09.645Z | 2024-10-30T12:26:46.504Z |
5340860 | 5340860 | 20241022005448_kIqfB | UK005P | 2024-10-23T12:14:59.211Z | 2024-10-30T12:26:46.330Z |
5340462 | 5340462 | 20241022001637_Y2JpX | UK005P | 2024-10-23T12:14:33.968Z | 2024-10-30T12:26:45.900Z |
5340332 | 5340332 | 20241022000531_qTXo3 | UK005P | 2024-10-23T12:14:28.806Z | 2024-10-30T12:26:45.688Z |
5340247 | 5340247 | 20241021235935_FlOLE | UK005P | 2024-10-23T12:14:25.347Z | 2024-10-30T12:26:45.575Z |
5339645 | 5339645 | 20241021230112_TzP20 | UK005P | 2024-10-23T12:13:28.700Z | 2024-10-30T12:26:44.680Z |
5339554 | 5339554 | 20241021225315_S1N07 | UK005P | 2024-10-23T12:13:18.562Z | 2024-10-30T12:26:44.431Z |
5339498 | 5339498 | 20241021224707_LKsFs | UK005P | 2024-10-23T12:13:10.907Z | 2024-10-30T12:26:44.299Z |
5332669 | 5332669 | 20241020213636_4xQTh | UK005P | 2024-10-22T12:13:56.644Z | 2024-10-29T12:26:33.693Z |
5332644 | 5332644 | 20241020213055_UybS2 | UK005P | 2024-10-22T12:13:51.602Z | 2024-10-29T12:26:33.657Z |
5326455 | 5326455 | 20241019183418_uoMDa | UK005P | 2024-10-21T12:09:27.473Z | 2024-10-28T12:26:41.702Z |
5323021 | 5323021 | 20241018181908_xL5iB | UK005P | 2024-10-20T12:04:45.671Z | 2024-10-27T12:28:48.966Z |
5319637 | 5319637 | 20241017191318_nJGiY | UK005P | 2024-10-19T12:03:27.905Z | 2024-10-26T12:27:52.767Z |
5318397 | 5318397 | 20241017030402_J36Sl | UK005P | 2024-10-18T12:03:43.689Z | 2024-10-25T12:24:35.159Z |
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);