participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,735 rows where station_code = "UK003P" 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 |
---|---|---|---|---|---|
5285599 | 5285599 | 20241011040759_tJQ3C | UK003P | 2024-10-12T12:18:16.931Z | 2024-10-19T12:28:03.972Z |
5285396 | 5285396 | 20241011035350_OjWSt | UK003P | 2024-10-12T12:18:08.369Z | 2024-10-19T12:28:02.340Z |
5284615 | 5284615 | 20241011025628_FGVsX | UK003P | 2024-10-12T12:17:30.188Z | 2024-10-19T12:27:56.781Z |
5284500 | 5284500 | 20241011025008_nEqDk | UK003P | 2024-10-12T12:17:26.252Z | 2024-10-19T12:27:56.118Z |
5283951 | 5283951 | 20241011021054_m2rA9 | UK003P | 2024-10-12T12:17:02.547Z | 2024-10-19T12:27:53.564Z |
5283673 | 5283673 | 20241011014256_EHfyv | UK003P | 2024-10-12T12:16:50.328Z | 2024-10-19T12:27:52.356Z |
5283591 | 5283591 | 20241011013740_IhdNj | UK003P | 2024-10-12T12:16:47.769Z | 2024-10-19T12:27:52.240Z |
5283474 | 5283474 | 20241011012842_fvXsI | UK003P | 2024-10-12T12:16:43.728Z | 2024-10-19T12:27:51.712Z |
5283401 | 5283401 | 20241011012220_bJ9ll | UK003P | 2024-10-12T12:16:39.988Z | 2024-10-19T12:27:51.460Z |
5276836 | 5276836 | 20241011051319_lkskp | UK003P | 2024-10-12T12:01:50.766Z | 2024-10-20T12:23:14.205Z |
5276678 | 5276678 | 20241011045654_NzjCn | UK003P | 2024-10-12T12:01:29.668Z | 2024-10-20T12:23:12.652Z |
5276347 | 5276347 | 20241011043353_fxszU | UK003P | 2024-10-12T12:00:55.314Z | 2024-10-20T12:23:08.159Z |
5276286 | 5276286 | 20241011042935_gbk3P | UK003P | 2024-10-12T12:00:49.558Z | 2024-10-20T12:23:07.617Z |
5276225 | 5276225 | 20241011042548_nDzCp | UK003P | 2024-10-12T12:00:39.006Z | 2024-10-20T12:23:06.762Z |
5275986 | 5275986 | 20241011040914_AkCe1 | UK003P | 2024-10-12T12:00:09.418Z | 2024-10-20T12:23:03.669Z |
5268743 | 5268743 | 20241009030108_4lzCa | UK003P | 2024-10-10T12:16:24.182Z | 2024-10-17T12:20:18.600Z |
5268491 | 5268491 | 20241009020242_RvHy2 | UK003P | 2024-10-10T12:15:57.177Z | 2024-10-17T12:20:17.350Z |
5263221 | 5263221 | 20241009034008_Vw7K1 | UK003P | 2024-10-10T12:00:14.407Z | 2024-10-18T12:21:31.192Z |
5262502 | 5262502 | 20241008013921_OSFc4 | UK003P | 2024-10-09T12:15:51.446Z | 2024-10-16T12:21:18.948Z |
5254429 | 5254429 | 20241007021034_CzqTi | UK003P | 2024-10-08T12:14:25.218Z | 2024-10-15T12:29:15.360Z |
5252873 | 5252873 | 20241006215557_xF0Tg | UK003P | 2024-10-08T12:12:43.742Z | 2024-10-15T12:29:05.190Z |
5252709 | 5252709 | 20241006211120_jIBk4 | UK003P | 2024-10-08T12:12:17.890Z | 2024-10-15T12:29:02.953Z |
5248537 | 5248537 | 20241007045046_UjHw3 | UK003P | 2024-10-08T12:02:35.856Z | 2024-10-16T12:21:00.268Z |
5247831 | 5247831 | 20241007032418_5XOfo | UK003P | 2024-10-08T12:00:50.827Z | 2024-10-16T12:20:57.037Z |
5247802 | 5247802 | 20241007032008_wNxXY | UK003P | 2024-10-08T12:00:43.473Z | 2024-10-16T12:20:56.979Z |
5247542 | 5247542 | 20241005021248_j2ETq | UK003P | 2024-10-07T12:18:56.232Z | 2024-10-13T12:26:26.452Z |
5240103 | 5240103 | 20241005050149_Zl4Fu | UK003P | 2024-10-07T12:07:41.810Z | 2024-10-14T12:24:21.183Z |
5239837 | 5239837 | 20241005043202_tcM5b | UK003P | 2024-10-07T12:07:13.981Z | 2024-10-14T12:24:20.847Z |
5239347 | 5239347 | 20241005035153_gUyIU | UK003P | 2024-10-07T12:06:18.512Z | 2024-10-14T12:24:19.074Z |
5238922 | 5238922 | 20241005031231_yOh26 | UK003P | 2024-10-07T12:05:28.032Z | 2024-10-14T12:24:17.649Z |
5238843 | 5238843 | 20241005030236_rpb15 | UK003P | 2024-10-07T12:05:21.192Z | 2024-10-14T12:24:17.326Z |
5238665 | 5238665 | 20241005025034_v8qtB | UK003P | 2024-10-07T12:04:50.838Z | 2024-10-14T12:24:16.906Z |
5238616 | 5238616 | 20241005024731_3r2GX | UK003P | 2024-10-07T12:04:45.024Z | 2024-10-14T12:24:16.881Z |
5235857 | 5235857 | 20241005000013_gp2gb | UK003P | 2024-10-06T12:16:57.541Z | 2024-10-13T12:26:24.460Z |
5235844 | 5235844 | 20241004235703_5AUi8 | UK003P | 2024-10-06T12:16:55.947Z | 2024-10-13T12:26:24.453Z |
5235452 | 5235452 | 20241004233609_VmZJm | UK003P | 2024-10-06T12:16:05.416Z | 2024-10-13T12:26:24.248Z |
5234955 | 5234955 | 20241004223630_r7uHI | UK003P | 2024-10-06T12:15:43.417Z | 2024-10-13T12:26:23.198Z |
5227553 | 5227553 | 20241004012910_t04gx | UK003P | 2024-10-05T12:21:34.657Z | 2024-10-12T12:25:12.817Z |
5227367 | 5227367 | 20241004011928_s2rpy | UK003P | 2024-10-05T12:21:27.336Z | 2024-10-12T12:25:12.723Z |
5226905 | 5226905 | 20241004004740_HlwLG | UK003P | 2024-10-05T12:21:02.703Z | 2024-10-12T12:25:12.238Z |
5226816 | 5226816 | 20241004004123_Flbfd | UK003P | 2024-10-05T12:20:59.843Z | 2024-10-12T12:25:12.116Z |
5226781 | 5226781 | 20241004003723_UH40i | UK003P | 2024-10-05T12:20:58.691Z | 2024-10-12T12:25:12.100Z |
5226724 | 5226724 | 20241004003455_Maf0m | UK003P | 2024-10-05T12:20:55.776Z | 2024-10-12T12:25:12.021Z |
5225996 | 5225996 | 20241003233553_3l2AD | UK003P | 2024-10-05T12:20:21.908Z | 2024-10-12T12:25:11.070Z |
5225853 | 5225853 | 20241003232304_g2g02 | UK003P | 2024-10-05T12:20:14.560Z | 2024-10-12T12:25:10.938Z |
5224977 | 5224977 | 20241003215002_8Lfb3 | UK003P | 2024-10-05T12:19:16.889Z | 2024-10-12T12:25:09.425Z |
5224923 | 5224923 | 20241003214152_U8Ngo | UK003P | 2024-10-05T12:19:12.084Z | 2024-10-12T12:25:09.174Z |
5219678 | 5219678 | 20241003040906_Qf2cF | UK003P | 2024-10-05T12:09:26.347Z | 2024-10-12T12:24:56.026Z |
5216797 | 5216797 | 20241003012710_eeyhs | UK003P | 2024-10-04T12:13:49.724Z | 2024-10-11T12:23:37.790Z |
5216586 | 5216586 | 20241003010916_5Ia2a | UK003P | 2024-10-04T12:13:31.467Z | 2024-10-11T12:23:37.524Z |
5216429 | 5216429 | 20241003005805_qoS8X | UK003P | 2024-10-04T12:13:13.926Z | 2024-10-11T12:23:37.133Z |
5216036 | 5216036 | 20241003003018_0cSoF | UK003P | 2024-10-04T12:12:47.973Z | 2024-10-11T12:23:36.425Z |
5215192 | 5215192 | 20241002230646_0w6Gj | UK003P | 2024-10-04T12:11:34.601Z | 2024-10-11T12:23:35.008Z |
5215155 | 5215155 | 20241002230148_o70M3 | UK003P | 2024-10-04T12:11:30.880Z | 2024-10-11T12:23:34.974Z |
5214998 | 5214998 | 20241002224729_deFW4 | UK003P | 2024-10-04T12:11:08.095Z | 2024-10-11T12:23:34.658Z |
5214963 | 5214963 | 20241002224438_b3Zac | UK003P | 2024-10-04T12:11:05.098Z | 2024-10-11T12:23:34.615Z |
5214708 | 5214708 | 20241002221055_e1JXP | UK003P | 2024-10-04T12:10:41.123Z | 2024-10-11T12:23:34.023Z |
5214669 | 5214669 | 20241002220656_fj3T6 | UK003P | 2024-10-04T12:10:38.768Z | 2024-10-11T12:23:33.980Z |
5214228 | 5214228 | 20241002210609_5P2H7 | UK003P | 2024-10-04T12:09:49.952Z | 2024-10-11T12:23:32.918Z |
5214116 | 5214116 | 20241002205332_3YQZT | UK003P | 2024-10-04T12:09:41.837Z | 2024-10-11T12:23:32.792Z |
5213677 | 5213677 | 20241002193635_wFHQS | UK003P | 2024-10-04T12:08:50.203Z | 2024-10-11T12:23:31.608Z |
5213514 | 5213514 | 20241002185439_opyyW | UK003P | 2024-10-04T12:08:20.112Z | 2024-10-11T12:23:31.098Z |
5212955 | 5212955 | 20241003033641_MaLK2 | UK003P | 2024-10-04T12:04:10.647Z | 2024-10-12T12:24:55.296Z |
5212640 | 5212640 | 20241003031500_Z4Pdl | UK003P | 2024-10-04T12:03:29.115Z | 2024-10-12T12:24:54.867Z |
5212454 | 5212454 | 20241003030023_oHSbY | UK003P | 2024-10-04T12:03:02.132Z | 2024-10-12T12:24:54.691Z |
5212448 | 5212448 | 20241003025931_zRV2d | UK003P | 2024-10-04T12:03:01.334Z | 2024-10-12T12:24:54.686Z |
5212090 | 5212090 | 20241003023317_TSdYL | UK003P | 2024-10-04T12:02:12.574Z | 2024-10-12T12:24:54.273Z |
5205698 | 5205698 | 20241001002850_oeEHw | UK003P | 2024-10-02T12:12:56.107Z | 2024-10-09T12:29:16.732Z |
5205652 | 5205652 | 20241001002126_Ybh2k | UK003P | 2024-10-02T12:12:54.348Z | 2024-10-09T12:29:16.661Z |
5205436 | 5205436 | 20240930234440_ThndN | UK003P | 2024-10-02T12:12:42.499Z | 2024-10-09T12:29:16.303Z |
5205273 | 5205273 | 20240930230056_Ejozb | UK003P | 2024-10-02T12:12:33.306Z | 2024-10-09T12:29:15.905Z |
5205113 | 5205113 | 20240930221008_76Hlv | UK003P | 2024-10-02T12:12:22.874Z | 2024-10-09T12:29:15.556Z |
5205111 | 5205111 | 20240930221005_k3nWE | UK003P | 2024-10-02T12:12:22.675Z | 2024-10-09T12:29:15.552Z |
5204953 | 5204953 | 20240930213440_49f69 | UK003P | 2024-10-02T12:12:13.003Z | 2024-10-09T12:29:15.231Z |
5204463 | 5204463 | 20240930195645_h2i8F | UK003P | 2024-10-02T12:11:38.199Z | 2024-10-09T12:29:14.092Z |
5204416 | 5204416 | 20240930194749_Zv2di | UK003P | 2024-10-02T12:11:34.840Z | 2024-10-09T12:29:13.987Z |
5200298 | 5200298 | 20241001030627_OU5Ow | UK003P | 2024-10-02T12:01:46.754Z | 2024-10-10T12:24:30.480Z |
5200180 | 5200180 | 20241001024806_4oHl5 | UK003P | 2024-10-02T12:01:34.574Z | 2024-10-10T12:24:29.908Z |
5200172 | 5200172 | 20241001024740_BKPDC | UK003P | 2024-10-02T12:01:34.029Z | 2024-10-10T12:24:29.904Z |
5200045 | 5200045 | 20241001022045_qc2h1 | UK003P | 2024-10-02T12:01:16.719Z | 2024-10-10T12:24:29.506Z |
5200020 | 5200020 | 20241001021512_Xxy9l | UK003P | 2024-10-02T12:01:12.275Z | 2024-10-10T12:24:29.412Z |
5199883 | 5199883 | 20241001015255_dAR42 | UK003P | 2024-10-02T12:00:51.230Z | 2024-10-10T12:24:28.836Z |
5199844 | 5199844 | 20241001014921_RvV02 | UK003P | 2024-10-02T12:00:48.257Z | 2024-10-10T12:24:28.620Z |
5199621 | 5199621 | 20241001010824_iub8r | UK003P | 2024-10-02T12:00:21.464Z | 2024-10-10T12:24:28.030Z |
5192783 | 5192783 | 20240928231622_c9hLm | UK003P | 2024-09-30T12:18:54.209Z | 2024-10-06T12:28:26.234Z |
5192531 | 5192531 | 20240928224514_U3G8j | UK003P | 2024-09-30T12:18:44.813Z | 2024-10-06T12:28:25.875Z |
5192476 | 5192476 | 20240928224104_lLO3t | UK003P | 2024-09-30T12:18:42.489Z | 2024-10-06T12:28:25.749Z |
5192360 | 5192360 | 20240928222809_VhcK9 | UK003P | 2024-09-30T12:18:37.986Z | 2024-10-06T12:28:25.526Z |
5192236 | 5192236 | 20240928221230_BiCOh | UK003P | 2024-09-30T12:18:32.420Z | 2024-10-06T12:28:25.303Z |
5191895 | 5191895 | 20240928210932_YW3UE | UK003P | 2024-09-30T12:18:13.979Z | 2024-10-06T12:28:24.450Z |
5184649 | 5184649 | 20240929011817_UBO7N | UK003P | 2024-09-30T12:02:14.756Z | 2024-10-07T12:21:15.959Z |
5184524 | 5184524 | 20240929010607_CqGYg | UK003P | 2024-09-30T12:01:50.402Z | 2024-10-07T12:21:15.357Z |
5182741 | 5182741 | 20240927231323_BTqRK | UK003P | 2024-09-29T12:16:13.192Z | 2024-10-05T12:29:09.049Z |
5182330 | 5182330 | 20240927223356_Igd4X | UK003P | 2024-09-29T12:15:55.358Z | 2024-10-05T12:29:08.521Z |
5181988 | 5181988 | 20240927215547_YZoJZ | UK003P | 2024-09-29T12:15:39.306Z | 2024-10-05T12:29:07.654Z |
5181525 | 5181525 | 20240927210246_PgVaq | UK003P | 2024-09-29T12:15:10.590Z | 2024-10-05T12:29:05.951Z |
5181443 | 5181443 | 20240927205432_W2c2Y | UK003P | 2024-09-29T12:15:04.602Z | 2024-10-05T12:29:05.843Z |
5181304 | 5181304 | 20240927203511_ANOsH | UK003P | 2024-09-29T12:14:55.211Z | 2024-10-05T12:29:05.571Z |
5180960 | 5180960 | 20240927195131_eoGyD | UK003P | 2024-09-29T12:14:27.558Z | 2024-10-05T12:29:03.282Z |
5180775 | 5180775 | 20240927192330_3xPtV | UK003P | 2024-09-29T12:14:16.424Z | 2024-10-05T12:29:01.825Z |
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);