participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,078 rows where station_code = "UK003W" 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 |
---|---|---|---|---|---|
5128154 | 5128154 | 20240917005425_JslyQ | UK003W | 2024-09-19T12:10:13.111Z | 2024-09-19T12:10:13.111Z |
5127995 | 5127995 | 20240917001852_jdaSA | UK003W | 2024-09-19T12:09:53.374Z | 2024-09-19T12:09:53.374Z |
5127927 | 5127927 | 20240917000518_ymau4 | UK003W | 2024-09-19T12:09:47.056Z | 2024-09-19T12:09:47.056Z |
5127808 | 5127808 | 20240916233733_LUnDY | UK003W | 2024-09-19T12:09:40.627Z | 2024-09-19T12:09:40.627Z |
5127544 | 5127544 | 20240916222203_0x3Sy | UK003W | 2024-09-19T12:09:20.526Z | 2024-09-19T12:09:20.526Z |
5127041 | 5127041 | 20240916201358_bg3qD | UK003W | 2024-09-19T12:07:56.083Z | 2024-09-19T12:07:56.083Z |
5126904 | 5126904 | 20240916194848_vd6lL | UK003W | 2024-09-19T12:07:37.803Z | 2024-09-19T12:07:37.803Z |
5121531 | 5121531 | 20240914040812_UuGYS | UK003W | 2024-09-18T12:10:58.031Z | 2024-09-19T12:20:02.085Z |
5121420 | 5121420 | 20240914040049_qQLo8 | UK003W | 2024-09-18T12:10:55.272Z | 2024-09-19T12:20:01.789Z |
5121299 | 5121299 | 20240914035805_aEwVT | UK003W | 2024-09-18T12:10:54.131Z | 2024-09-19T12:20:01.619Z |
5120776 | 5120776 | 20240914033522_Iae8b | UK003W | 2024-09-18T12:10:46.657Z | 2024-09-19T12:20:00.856Z |
5120719 | 5120719 | 20240914033304_2dWFf | UK003W | 2024-09-18T12:10:46.215Z | 2024-09-19T12:20:00.801Z |
5120007 | 5120007 | 20240914025625_lO87G | UK003W | 2024-09-18T12:10:31.070Z | 2024-09-19T12:19:59.301Z |
5119705 | 5119705 | 20240914024413_3Swqf | UK003W | 2024-09-18T12:10:24.382Z | 2024-09-19T12:19:58.781Z |
5119689 | 5119689 | 20240914024409_grNiF | UK003W | 2024-09-18T12:10:24.067Z | 2024-09-19T12:19:58.737Z |
5119643 | 5119643 | 20240914024101_F7KB2 | UK003W | 2024-09-18T12:10:22.798Z | 2024-09-19T12:19:58.615Z |
5119540 | 5119540 | 20240914023837_UfZw2 | UK003W | 2024-09-18T12:10:22.187Z | 2024-09-19T12:19:58.485Z |
5119464 | 5119464 | 20240914023600_2u6WP | UK003W | 2024-09-18T12:10:21.526Z | 2024-09-19T12:19:58.286Z |
5119399 | 5119399 | 20240914023117_zHIDQ | UK003W | 2024-09-18T12:10:20.763Z | 2024-09-19T12:19:58.115Z |
5119373 | 5119373 | 20240914022955_aPR5h | UK003W | 2024-09-18T12:10:20.652Z | 2024-09-19T12:19:58.099Z |
5119242 | 5119242 | 20240914021832_IPZrP | UK003W | 2024-09-18T12:10:18.774Z | 2024-09-19T12:19:57.474Z |
5119169 | 5119169 | 20240914021531_hq33r | UK003W | 2024-09-18T12:10:17.913Z | 2024-09-19T12:19:57.327Z |
5119150 | 5119150 | 20240914021347_8OpnT | UK003W | 2024-09-18T12:10:16.762Z | 2024-09-19T12:19:57.242Z |
5117308 | 5117308 | 20240915041720_ffZA5 | UK003W | 2024-09-18T12:07:37.503Z | 2024-09-19T12:19:14.228Z |
5117279 | 5117279 | 20240915041611_3DJeO | UK003W | 2024-09-18T12:07:36.714Z | 2024-09-19T12:19:14.077Z |
5117023 | 5117023 | 20240915035717_riBIF | UK003W | 2024-09-18T12:07:30.191Z | 2024-09-19T12:19:13.125Z |
5116513 | 5116513 | 20240915033030_5Zu31 | UK003W | 2024-09-18T12:07:08.342Z | 2024-09-19T12:19:11.432Z |
5116422 | 5116422 | 20240915032539_9leAG | UK003W | 2024-09-18T12:07:01.982Z | 2024-09-19T12:19:11.103Z |
5116307 | 5116307 | 20240915032028_Q31Uc | UK003W | 2024-09-18T12:06:56.137Z | 2024-09-19T12:19:10.288Z |
5116131 | 5116131 | 20240915031015_glnIT | UK003W | 2024-09-18T12:06:42.036Z | 2024-09-19T12:19:08.799Z |
5116013 | 5116013 | 20240915030349_gXZnN | UK003W | 2024-09-18T12:06:34.351Z | 2024-09-19T12:19:08.198Z |
5115737 | 5115737 | 20240915025118_ZVC3C | UK003W | 2024-09-18T12:06:22.630Z | 2024-09-19T12:19:06.714Z |
5115702 | 5115702 | 20240915024921_zSx7C | UK003W | 2024-09-18T12:06:21.535Z | 2024-09-19T12:19:06.420Z |
5115449 | 5115449 | 20240915023908_2Lzv1 | UK003W | 2024-09-18T12:06:14.761Z | 2024-09-19T12:19:04.821Z |
5114702 | 5114702 | 20240915015523_OwM1a | UK003W | 2024-09-18T12:05:29.966Z | 2024-09-19T12:18:59.403Z |
5114584 | 5114584 | 20240915015105_XYGtF | UK003W | 2024-09-18T12:05:23.110Z | 2024-09-19T12:18:58.992Z |
5114436 | 5114436 | 20240915014207_RUeb3 | UK003W | 2024-09-18T12:05:16.718Z | 2024-09-19T12:18:58.176Z |
5114377 | 5114377 | 20240915014044_iD3CJ | UK003W | 2024-09-18T12:05:14.128Z | 2024-09-19T12:18:57.925Z |
5114093 | 5114093 | 20240915012638_dss2q | UK003W | 2024-09-18T12:05:01.790Z | 2024-09-19T12:18:55.915Z |
5113262 | 5113262 | 20240915003432_6n1N7 | UK003W | 2024-09-18T12:04:05.017Z | 2024-09-19T12:18:48.290Z |
5113211 | 5113211 | 20240915003210_PtWdE | UK003W | 2024-09-18T12:04:03.183Z | 2024-09-19T12:18:48.003Z |
5112848 | 5112848 | 20240915000053_Z12Zb | UK003W | 2024-09-18T12:03:42.599Z | 2024-09-19T12:18:45.297Z |
5112424 | 5112424 | 20240914230944_ybmw3 | UK003W | 2024-09-18T12:03:03.963Z | 2024-09-19T12:18:40.947Z |
5112340 | 5112340 | 20240914230112_vUTa1 | UK003W | 2024-09-18T12:03:00.504Z | 2024-09-19T12:18:40.621Z |
5112260 | 5112260 | 20240914224747_14gv3 | UK003W | 2024-09-18T12:02:57.165Z | 2024-09-19T12:18:40.240Z |
5112139 | 5112139 | 20240914222537_yN6EK | UK003W | 2024-09-18T12:02:49.873Z | 2024-09-19T12:18:38.649Z |
5111867 | 5111867 | 20240914212804_u1UDt | UK003W | 2024-09-18T12:02:26.455Z | 2024-09-19T12:18:34.791Z |
5111832 | 5111832 | 20240914212020_ys9E5 | UK003W | 2024-09-18T12:02:19.078Z | 2024-09-19T12:18:34.222Z |
5111532 | 5111532 | 20240914204443_1i0n6 | UK003W | 2024-09-18T12:02:01.203Z | 2024-09-19T12:18:31.071Z |
5111095 | 5111095 | 20240914195529_AQxfA | UK003W | 2024-09-18T12:01:32.256Z | 2024-09-19T12:18:26.562Z |
5108115 | 5108115 | 20240913042358_AZAj2 | UK003W | 2024-09-17T12:13:30.683Z | 2024-09-19T12:20:47.851Z |
5108108 | 5108108 | 20240913042358_TeKGC | UK003W | 2024-09-17T12:13:30.612Z | 2024-09-19T12:20:47.850Z |
5108081 | 5108081 | 20240913042229_1fef9 | UK003W | 2024-09-17T12:13:30.314Z | 2024-09-19T12:20:47.836Z |
5107820 | 5107820 | 20240913041144_1s6ON | UK003W | 2024-09-17T12:13:24.220Z | 2024-09-19T12:20:47.577Z |
5107322 | 5107322 | 20240913035244_r9TG4 | UK003W | 2024-09-17T12:13:13.233Z | 2024-09-19T12:20:47.002Z |
5107287 | 5107287 | 20240913035130_kt4f0 | UK003W | 2024-09-17T12:13:12.670Z | 2024-09-19T12:20:46.986Z |
5107158 | 5107158 | 20240913034540_HdeRC | UK003W | 2024-09-17T12:13:10.141Z | 2024-09-19T12:20:46.869Z |
5106810 | 5106810 | 20240913033538_U5EMJ | UK003W | 2024-09-17T12:13:02.037Z | 2024-09-19T12:20:46.442Z |
5106400 | 5106400 | 20240913032352_FKSGC | UK003W | 2024-09-17T12:12:53.098Z | 2024-09-19T12:20:46.050Z |
5105488 | 5105488 | 20240913024807_tVe1F | UK003W | 2024-09-17T12:12:18.751Z | 2024-09-19T12:20:44.597Z |
5105309 | 5105309 | 20240913024136_GZ2H1 | UK003W | 2024-09-17T12:12:09.274Z | 2024-09-19T12:20:44.284Z |
5105193 | 5105193 | 20240913023720_AH0tJ | UK003W | 2024-09-17T12:12:02.316Z | 2024-09-19T12:20:44.109Z |
5105019 | 5105019 | 20240913022751_USkgs | UK003W | 2024-09-17T12:11:50.349Z | 2024-09-19T12:20:43.419Z |
5104933 | 5104933 | 20240913022409_pqIWJ | UK003W | 2024-09-17T12:11:46.900Z | 2024-09-19T12:20:43.121Z |
5104843 | 5104843 | 20240913022156_n3Bko | UK003W | 2024-09-17T12:11:45.409Z | 2024-09-19T12:20:43.058Z |
5104468 | 5104468 | 20240913021035_SeuAh | UK003W | 2024-09-17T12:11:36.066Z | 2024-09-19T12:20:41.506Z |
5103808 | 5103808 | 20240913014047_z3EeP | UK003W | 2024-09-17T12:11:11.587Z | 2024-09-19T12:20:40.580Z |
5103517 | 5103517 | 20240913013155_6xY3b | UK003W | 2024-09-17T12:11:01.142Z | 2024-09-19T12:20:40.239Z |
5103492 | 5103492 | 20240913013140_oIZ4q | UK003W | 2024-09-17T12:11:00.411Z | 2024-09-19T12:20:40.227Z |
5102981 | 5102981 | 20240914015558_UuU9v | UK003W | 2024-09-17T12:07:45.941Z | 2024-09-19T12:19:56.229Z |
5102787 | 5102787 | 20240914014439_R2HqQ | UK003W | 2024-09-17T12:07:36.608Z | 2024-09-19T12:19:55.644Z |
5102730 | 5102730 | 20240914014006_3jfFa | UK003W | 2024-09-17T12:07:33.221Z | 2024-09-19T12:19:55.448Z |
5101870 | 5101870 | 20240914005300_qjs2H | UK003W | 2024-09-17T12:06:18.950Z | 2024-09-19T12:19:51.735Z |
5101666 | 5101666 | 20240914004212_3V4ND | UK003W | 2024-09-17T12:06:07.644Z | 2024-09-19T12:19:51.185Z |
5100904 | 5100904 | 20240913235248_h28Td | UK003W | 2024-09-17T12:05:09.761Z | 2024-09-19T12:19:49.316Z |
5100613 | 5100613 | 20240913233503_8Xd6R | UK003W | 2024-09-17T12:04:42.072Z | 2024-09-19T12:19:48.205Z |
5100601 | 5100601 | 20240913233427_ai43h | UK003W | 2024-09-17T12:04:41.257Z | 2024-09-19T12:19:48.188Z |
5100522 | 5100522 | 20240913232936_gqCs2 | UK003W | 2024-09-17T12:04:37.933Z | 2024-09-19T12:19:48.092Z |
5100250 | 5100250 | 20240913231030_w3U5u | UK003W | 2024-09-17T12:04:22.303Z | 2024-09-19T12:19:47.382Z |
5099839 | 5099839 | 20240913221107_YCkiG | UK003W | 2024-09-17T12:03:38.880Z | 2024-09-19T12:19:46.113Z |
5099676 | 5099676 | 20240913214750_lu2LC | UK003W | 2024-09-17T12:03:22.672Z | 2024-09-19T12:19:45.667Z |
5098145 | 5098145 | 20240913012014_inp5O | UK003W | 2024-09-16T12:17:20.791Z | 2024-09-19T12:20:39.706Z |
5097771 | 5097771 | 20240913010422_ONzqz | UK003W | 2024-09-16T12:17:14.893Z | 2024-09-19T12:20:38.976Z |
5094144 | 5094144 | 20240912035145_3lqZ8 | UK003W | 2024-09-16T12:14:37.385Z | 2024-09-19T12:21:15.904Z |
5094067 | 5094067 | 20240912034644_xtPR0 | UK003W | 2024-09-16T12:14:32.965Z | 2024-09-19T12:21:15.857Z |
5093797 | 5093797 | 20240912033621_7aj6M | UK003W | 2024-09-16T12:14:25.640Z | 2024-09-19T12:21:15.658Z |
5093273 | 5093273 | 20240912031621_Ke8ar | UK003W | 2024-09-16T12:14:14.133Z | 2024-09-19T12:21:15.080Z |
5092893 | 5092893 | 20240912030050_T23ZJ | UK003W | 2024-09-16T12:14:06.433Z | 2024-09-19T12:21:14.652Z |
5091513 | 5091513 | 20240912021153_V9eHa | UK003W | 2024-09-16T12:13:08.945Z | 2024-09-19T12:21:13.106Z |
5090961 | 5090961 | 20240912015504_fm01C | UK003W | 2024-09-16T12:12:45.953Z | 2024-09-19T12:21:12.435Z |
5090423 | 5090423 | 20240912012436_5c7Kq | UK003W | 2024-09-16T12:12:19.773Z | 2024-09-19T12:21:11.315Z |
5090400 | 5090400 | 20240912012419_mPZCp | UK003W | 2024-09-16T12:12:18.870Z | 2024-09-19T12:21:11.293Z |
5090353 | 5090353 | 20240912012234_ZeZJU | UK003W | 2024-09-16T12:12:15.684Z | 2024-09-19T12:21:11.234Z |
5090129 | 5090129 | 20240912011204_ejuB8 | UK003W | 2024-09-16T12:12:01.658Z | 2024-09-19T12:21:10.988Z |
5090085 | 5090085 | 20240912011044_xMpqB | UK003W | 2024-09-16T12:12:00.052Z | 2024-09-19T12:21:10.967Z |
5088282 | 5088282 | 20240913000450_xq4dH | UK003W | 2024-09-16T12:07:52.750Z | 2024-09-19T12:20:36.620Z |
5088066 | 5088066 | 20240912235528_jrW6p | UK003W | 2024-09-16T12:07:43.160Z | 2024-09-19T12:20:36.362Z |
5087783 | 5087783 | 20240912234345_FzPNH | UK003W | 2024-09-16T12:07:27.009Z | 2024-09-19T12:20:35.673Z |
5087101 | 5087101 | 20240912230810_pb65H | UK003W | 2024-09-16T12:06:39.219Z | 2024-09-19T12:20:34.032Z |
5086997 | 5086997 | 20240912230103_Tqc3L | UK003W | 2024-09-16T12:06:22.777Z | 2024-09-19T12:20:33.407Z |
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);