participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,020 rows where station_code = "UK001K" 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 |
---|---|---|---|---|---|
5454949 | 5454949 | 20241031055304_QM4JR | UK001K | 2024-11-02T12:23:27.502Z | 2024-11-08T14:23:26.468Z |
5454877 | 5454877 | 20241031053803_u3Rq0 | UK001K | 2024-11-02T12:23:25.686Z | 2024-11-08T14:23:26.089Z |
5454794 | 5454794 | 20241031051718_3x5Mv | UK001K | 2024-11-02T12:23:23.508Z | 2024-11-08T14:23:25.671Z |
5454736 | 5454736 | 20241031050500_snRO7 | UK001K | 2024-11-02T12:23:19.516Z | 2024-11-08T14:23:25.424Z |
5454624 | 5454624 | 20241031044701_SCl33 | UK001K | 2024-11-02T12:23:14.635Z | 2024-11-08T14:23:24.484Z |
5454616 | 5454616 | 20241031044551_NLV53 | UK001K | 2024-11-02T12:23:14.274Z | 2024-11-08T14:23:24.459Z |
5454585 | 5454585 | 20241031044138_E1Lby | UK001K | 2024-11-02T12:23:13.297Z | 2024-11-08T14:23:24.289Z |
5454366 | 5454366 | 20241031041211_k67AD | UK001K | 2024-11-02T12:23:03.768Z | 2024-11-08T14:23:22.517Z |
5454153 | 5454153 | 20241031034828_Y3wQp | UK001K | 2024-11-02T12:22:52.197Z | 2024-11-08T14:23:20.776Z |
5453984 | 5453984 | 20241031032552_X64j1 | UK001K | 2024-11-02T12:22:46.799Z | 2024-11-08T14:23:19.827Z |
5453963 | 5453963 | 20241031032311_a1MQY | UK001K | 2024-11-02T12:22:46.257Z | 2024-11-08T14:23:19.793Z |
5453916 | 5453916 | 20241031031617_9qK6N | UK001K | 2024-11-02T12:22:44.935Z | 2024-11-08T14:23:19.663Z |
5453849 | 5453849 | 20241031031011_0uimx | UK001K | 2024-11-02T12:22:43.735Z | 2024-11-08T14:23:19.541Z |
5453763 | 5453763 | 20241031025737_Azrbe | UK001K | 2024-11-02T12:22:42.138Z | 2024-11-08T14:23:19.014Z |
5453668 | 5453668 | 20241031024101_xFdXo | UK001K | 2024-11-02T12:22:39.716Z | 2024-11-08T14:23:18.632Z |
5453620 | 5453620 | 20241031023313_67EM2 | UK001K | 2024-11-02T12:22:37.303Z | 2024-11-08T14:23:18.269Z |
5453602 | 5453602 | 20241031022946_fJq2a | UK001K | 2024-11-02T12:22:36.855Z | 2024-11-08T14:23:18.176Z |
5453562 | 5453562 | 20241031022525_5xCyh | UK001K | 2024-11-02T12:22:36.145Z | 2024-11-08T14:23:18.100Z |
5450838 | 5450838 | 20241031211910_Oqeqn | UK001K | 2024-11-02T12:16:02.458Z | 2024-11-09T14:24:18.796Z |
5450524 | 5450524 | 20241031193924_YUDc6 | UK001K | 2024-11-02T12:15:34.222Z | 2024-11-09T14:24:16.400Z |
5410932 | 5410932 | 20241027055447_Dl4Tf | UK001K | 2024-10-29T12:18:12.685Z | 2024-11-04T14:29:06.384Z |
5410926 | 5410926 | 20241027055341_XKj2v | UK001K | 2024-10-29T12:18:12.379Z | 2024-11-04T14:29:06.381Z |
5410547 | 5410547 | 20241027051723_5XDE3 | UK001K | 2024-10-29T12:17:57.937Z | 2024-11-04T14:29:04.806Z |
5410452 | 5410452 | 20241027051356_izjAW | UK001K | 2024-10-29T12:17:55.984Z | 2024-11-04T14:29:04.610Z |
5410261 | 5410261 | 20241027050420_ajY4E | UK001K | 2024-10-29T12:17:51.874Z | 2024-11-04T14:29:04.272Z |
5410220 | 5410220 | 20241027050029_2hblT | UK001K | 2024-10-29T12:17:50.921Z | 2024-11-04T14:29:04.202Z |
5409276 | 5409276 | 20241027040846_rxzqP | UK001K | 2024-10-29T12:17:14.575Z | 2024-11-04T14:29:01.447Z |
5408683 | 5408683 | 20241027033632_5i8Gg | UK001K | 2024-10-29T12:16:45.111Z | 2024-11-04T14:29:00.304Z |
5407185 | 5407185 | 20241027022509_NvqtG | UK001K | 2024-10-29T12:15:16.314Z | 2024-11-04T14:28:57.232Z |
5401930 | 5401930 | 20241026181000_EOdeR | UK001K | 2024-10-29T12:05:52.144Z | 2024-11-04T14:28:41.076Z |
5400080 | 5400080 | 20241026053722_jV2o3 | UK001K | 2024-10-28T12:20:21.857Z | 2024-11-03T14:27:41.269Z |
5399928 | 5399928 | 20241026051303_oyNEc | UK001K | 2024-10-28T12:20:17.129Z | 2024-11-03T14:27:40.870Z |
5399926 | 5399926 | 20241026051259_UVg4Q | UK001K | 2024-10-28T12:20:17.072Z | 2024-11-03T14:27:40.866Z |
5399793 | 5399793 | 20241026050301_Q7xhn | UK001K | 2024-10-28T12:20:11.247Z | 2024-11-03T14:27:40.529Z |
5399531 | 5399531 | 20241026043233_5buxY | UK001K | 2024-10-28T12:20:01.657Z | 2024-11-03T14:27:39.939Z |
5398832 | 5398832 | 20241026033213_krvse | UK001K | 2024-10-28T12:19:35.778Z | 2024-11-03T14:27:38.274Z |
5398676 | 5398676 | 20241026031816_9D2at | UK001K | 2024-10-28T12:19:28.132Z | 2024-11-03T14:27:37.673Z |
5397802 | 5397802 | 20241026015903_4b8bm | UK001K | 2024-10-28T12:18:43.613Z | 2024-11-03T14:27:34.163Z |
5397382 | 5397382 | 20241026012425_dJLYN | UK001K | 2024-10-28T12:18:18.803Z | 2024-11-03T14:27:32.761Z |
5397154 | 5397154 | 20241026010640_8KjOL | UK001K | 2024-10-28T12:18:09.645Z | 2024-11-03T14:27:32.113Z |
5397138 | 5397138 | 20241026010515_qeq7S | UK001K | 2024-10-28T12:18:09.160Z | 2024-11-03T14:27:32.078Z |
5396501 | 5396501 | 20241026000812_pz3O5 | UK001K | 2024-10-28T12:17:47.258Z | 2024-11-03T14:27:30.021Z |
5396453 | 5396453 | 20241026000531_vysEB | UK001K | 2024-10-28T12:17:44.454Z | 2024-11-03T14:27:29.915Z |
5396100 | 5396100 | 20241025234034_ajIkV | UK001K | 2024-10-28T12:17:18.600Z | 2024-11-03T14:27:28.535Z |
5396028 | 5396028 | 20241025233229_x2J1l | UK001K | 2024-10-28T12:17:13.966Z | 2024-11-03T14:27:28.150Z |
5396006 | 5396006 | 20241025232938_fYFq9 | UK001K | 2024-10-28T12:17:10.607Z | 2024-11-03T14:27:28.036Z |
5395850 | 5395850 | 20241025231533_RicEh | UK001K | 2024-10-28T12:16:59.684Z | 2024-11-03T14:27:27.305Z |
5395680 | 5395680 | 20241025230354_dFeBB | UK001K | 2024-10-28T12:16:38.871Z | 2024-11-03T14:27:26.404Z |
5395673 | 5395673 | 20241025230347_JLJZX | UK001K | 2024-10-28T12:16:38.172Z | 2024-11-03T14:27:26.387Z |
5395597 | 5395597 | 20241025225819_qI077 | UK001K | 2024-10-28T12:16:31.160Z | 2024-11-03T14:27:26.085Z |
5394768 | 5394768 | 20241025212420_FJxZj | UK001K | 2024-10-28T12:15:24.348Z | 2024-11-03T14:27:22.698Z |
5394651 | 5394651 | 20241025210233_2lFdb | UK001K | 2024-10-28T12:15:10.225Z | 2024-11-03T14:27:22.068Z |
5394549 | 5394549 | 20241025204938_C9Q6K | UK001K | 2024-10-28T12:14:54.684Z | 2024-11-03T14:27:21.555Z |
5394302 | 5394302 | 20241025201327_IOq2Y | UK001K | 2024-10-28T12:14:21.294Z | 2024-11-03T14:27:20.753Z |
5394255 | 5394255 | 20241025200434_RORKg | UK001K | 2024-10-28T12:14:16.378Z | 2024-11-03T14:27:20.511Z |
5394210 | 5394210 | 20241025195732_vrc8C | UK001K | 2024-10-28T12:14:11.500Z | 2024-11-03T14:27:20.300Z |
5394030 | 5394030 | 20241025192611_xR8zJ | UK001K | 2024-10-28T12:13:59.786Z | 2024-11-03T14:27:19.682Z |
5378029 | 5378029 | 20241024052459_lJHZ0 | UK001K | 2024-10-26T12:22:53.148Z | 2024-11-01T12:27:03.261Z |
5377878 | 5377878 | 20241024051622_xtA1l | UK001K | 2024-10-26T12:22:49.131Z | 2024-11-01T12:27:03.151Z |
5377869 | 5377869 | 20241024051515_woGDk | UK001K | 2024-10-26T12:22:48.810Z | 2024-11-01T12:27:03.106Z |
5377863 | 5377863 | 20241024051513_NZFuI | UK001K | 2024-10-26T12:22:48.712Z | 2024-11-01T12:27:03.094Z |
5363683 | 5363683 | 20241023213528_Vl41c | UK001K | 2024-10-25T12:16:34.784Z | 2024-11-01T12:26:53.492Z |
5363142 | 5363142 | 20241023203112_3jXao | UK001K | 2024-10-25T12:15:32.208Z | 2024-11-01T12:26:52.878Z |
5354886 | 5354886 | 20241023025339_ErT7v | UK001K | 2024-10-24T12:20:55.756Z | 2024-10-31T12:30:06.682Z |
5354775 | 5354775 | 20241023024508_L2KZw | UK001K | 2024-10-24T12:20:49.994Z | 2024-10-31T12:30:06.317Z |
5354579 | 5354579 | 20241023023410_p58Yo | UK001K | 2024-10-24T12:20:41.488Z | 2024-10-31T12:30:06.019Z |
5354555 | 5354555 | 20241023023255_ntqxt | UK001K | 2024-10-24T12:20:40.766Z | 2024-10-31T12:30:05.979Z |
5352675 | 5352675 | 20241023004333_8OzVi | UK001K | 2024-10-24T12:19:04.713Z | 2024-10-31T12:30:03.138Z |
5352559 | 5352559 | 20241023003850_3x73X | UK001K | 2024-10-24T12:18:57.245Z | 2024-10-31T12:30:02.891Z |
5352006 | 5352006 | 20241023000543_HTyJx | UK001K | 2024-10-24T12:18:13.839Z | 2024-10-31T12:30:01.623Z |
5351817 | 5351817 | 20241022235501_CaISW | UK001K | 2024-10-24T12:18:02.287Z | 2024-10-31T12:30:00.975Z |
5351487 | 5351487 | 20241022233323_tPP92 | UK001K | 2024-10-24T12:17:36.056Z | 2024-10-31T12:30:00.451Z |
5350813 | 5350813 | 20241022223033_eM3sl | UK001K | 2024-10-24T12:16:36.754Z | 2024-10-31T12:29:58.823Z |
5350663 | 5350663 | 20241022221402_1ylaS | UK001K | 2024-10-24T12:16:13.281Z | 2024-10-31T12:29:58.638Z |
5350538 | 5350538 | 20241022220015_L1I9W | UK001K | 2024-10-24T12:15:54.694Z | 2024-10-31T12:29:58.418Z |
5349052 | 5349052 | 20241022192304_PlB0X | UK001K | 2024-10-24T12:13:02.628Z | 2024-10-31T12:29:54.521Z |
5340401 | 5340401 | 20241022001114_tZChu | UK001K | 2024-10-23T12:14:31.384Z | 2024-10-30T12:26:45.780Z |
5340353 | 5340353 | 20241022000806_jrElY | UK001K | 2024-10-23T12:14:29.563Z | 2024-10-30T12:26:45.694Z |
5340321 | 5340321 | 20241022000513_h8Zw7 | UK001K | 2024-10-23T12:14:28.552Z | 2024-10-30T12:26:45.678Z |
5340126 | 5340126 | 20241021234810_eDGl0 | UK001K | 2024-10-23T12:14:19.852Z | 2024-10-30T12:26:45.418Z |
5303778 | 5303778 | 20241013033307_bwb0B | UK001K | 2024-10-14T12:17:34.202Z | 2024-10-21T12:24:20.388Z |
5303520 | 5303520 | 20241013030920_7Pfxd | UK001K | 2024-10-14T12:17:27.680Z | 2024-10-21T12:24:18.400Z |
5302827 | 5302827 | 20241013014851_x8kzl | UK001K | 2024-10-14T12:16:49.998Z | 2024-10-21T12:24:13.347Z |
5302109 | 5302109 | 20241013003144_hhm34 | UK001K | 2024-10-14T12:15:53.582Z | 2024-10-21T12:24:04.618Z |
5301378 | 5301378 | 20241012231627_7SuBy | UK001K | 2024-10-14T12:15:22.584Z | 2024-10-21T12:23:57.908Z |
5301241 | 5301241 | 20241012225808_tNArA | UK001K | 2024-10-14T12:15:08.865Z | 2024-10-21T12:23:56.949Z |
5301181 | 5301181 | 20241012225052_K3K0I | UK001K | 2024-10-14T12:14:59.789Z | 2024-10-21T12:23:55.996Z |
5300735 | 5300735 | 20241012213644_Vc3Lc | UK001K | 2024-10-14T12:14:25.183Z | 2024-10-21T12:23:52.098Z |
5300693 | 5300693 | 20241012212533_AkBvu | UK001K | 2024-10-14T12:14:23.091Z | 2024-10-21T12:23:51.970Z |
5300181 | 5300181 | 20241012200913_0Iq3u | UK001K | 2024-10-14T12:13:33.747Z | 2024-10-21T12:23:47.124Z |
5299527 | 5299527 | 20241012190222_tSZtw | UK001K | 2024-10-14T12:12:26.417Z | 2024-10-21T12:23:40.449Z |
5299310 | 5299310 | 20241012183143_j17PD | UK001K | 2024-10-14T12:12:09.100Z | 2024-10-21T12:23:37.205Z |
5285607 | 5285607 | 20241011040807_AjpVw | UK001K | 2024-10-12T12:18:16.968Z | 2024-10-19T12:28:03.981Z |
5284343 | 5284343 | 20241011023714_vJcyK | UK001K | 2024-10-12T12:17:17.936Z | 2024-10-19T12:27:55.478Z |
5284259 | 5284259 | 20241011023333_5rL2r | UK001K | 2024-10-12T12:17:15.608Z | 2024-10-19T12:27:54.882Z |
5284184 | 5284184 | 20241011022709_3F0ix | UK001K | 2024-10-12T12:17:11.836Z | 2024-10-19T12:27:54.413Z |
5283843 | 5283843 | 20241011015759_2ki1s | UK001K | 2024-10-12T12:16:59.156Z | 2024-10-19T12:27:52.902Z |
5283482 | 5283482 | 20241011012910_KQtEz | UK001K | 2024-10-12T12:16:44.214Z | 2024-10-19T12:27:51.722Z |
5283329 | 5283329 | 20241011011241_XyJyU | UK001K | 2024-10-12T12:16:36.557Z | 2024-10-19T12:27:50.434Z |
5283262 | 5283262 | 20241011010758_s2rn2 | UK001K | 2024-10-12T12:16:33.796Z | 2024-10-19T12:27:50.198Z |
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);