participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,653 rows where station_code = "UK00AD" 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 |
---|---|---|---|---|---|
5133868 | 5133868 | 20240916041209_wiAjp | UK00AD | 2024-09-19T12:17:11.328Z | 2024-09-19T12:17:11.328Z |
5133709 | 5133709 | 20240916035213_847mi | UK00AD | 2024-09-19T12:17:05.549Z | 2024-09-19T12:17:05.549Z |
5133695 | 5133695 | 20240916035118_59DwK | UK00AD | 2024-09-19T12:17:05.382Z | 2024-09-19T12:17:05.382Z |
5133189 | 5133189 | 20240916030536_PPRja | UK00AD | 2024-09-19T12:16:47.942Z | 2024-09-19T12:16:47.942Z |
5132957 | 5132957 | 20240916023320_uMgEB | UK00AD | 2024-09-19T12:16:38.772Z | 2024-09-19T12:16:38.772Z |
5132838 | 5132838 | 20240916022115_23bbU | UK00AD | 2024-09-19T12:16:34.353Z | 2024-09-19T12:16:34.353Z |
5132495 | 5132495 | 20240916011641_pwlKh | UK00AD | 2024-09-19T12:16:15.386Z | 2024-09-19T12:16:15.386Z |
5132413 | 5132413 | 20240916010259_KbzDR | UK00AD | 2024-09-19T12:16:11.567Z | 2024-09-19T12:16:11.567Z |
5132380 | 5132380 | 20240916005506_0KAa7 | UK00AD | 2024-09-19T12:16:09.937Z | 2024-09-19T12:16:09.937Z |
5132273 | 5132273 | 20240916001432_FBg0w | UK00AD | 2024-09-19T12:16:02.774Z | 2024-09-19T12:16:02.774Z |
5132184 | 5132184 | 20240915235357_eZ81q | UK00AD | 2024-09-19T12:15:56.970Z | 2024-09-19T12:15:56.970Z |
5132165 | 5132165 | 20240915234939_oj3WQ | UK00AD | 2024-09-19T12:15:54.029Z | 2024-09-19T12:15:54.029Z |
5131974 | 5131974 | 20240915222635_1LSCq | UK00AD | 2024-09-19T12:15:39.164Z | 2024-09-19T12:15:39.164Z |
5131940 | 5131940 | 20240915222118_A0smM | UK00AD | 2024-09-19T12:15:35.188Z | 2024-09-19T12:15:35.188Z |
5131806 | 5131806 | 20240915211642_gLIsd | UK00AD | 2024-09-19T12:15:22.559Z | 2024-09-19T12:15:22.559Z |
5131643 | 5131643 | 20240915203900_KiMRx | UK00AD | 2024-09-19T12:15:12.554Z | 2024-09-19T12:15:12.554Z |
5129598 | 5129598 | 20240917041236_Q3V1d | UK00AD | 2024-09-19T12:11:51.827Z | 2024-09-19T12:11:51.827Z |
5127006 | 5127006 | 20240916201006_3I8NH | UK00AD | 2024-09-19T12:07:52.217Z | 2024-09-19T12:07:52.217Z |
5125082 | 5125082 | 20240918000127_1fhod | UK00AD | 2024-09-19T12:02:11.349Z | 2024-09-19T12:06:41.973Z |
5125064 | 5125064 | 20240917235351_3pH4H | UK00AD | 2024-09-19T12:02:05.605Z | 2024-09-19T12:06:41.970Z |
5113626 | 5113626 | 20240915010110_nKTUr | UK00AD | 2024-09-18T12:04:35.647Z | 2024-09-19T12:18:50.669Z |
5106319 | 5106319 | 20240913031823_RqNvZ | UK00AD | 2024-09-17T12:12:49.714Z | 2024-09-19T12:20:45.821Z |
5106269 | 5106269 | 20240913031625_50Gni | UK00AD | 2024-09-17T12:12:47.667Z | 2024-09-19T12:20:45.728Z |
5105252 | 5105252 | 20240913023921_qXE37 | UK00AD | 2024-09-17T12:12:06.187Z | 2024-09-19T12:20:44.172Z |
5094522 | 5094522 | 20240912040705_DP8Xf | UK00AD | 2024-09-16T12:14:49.739Z | 2024-09-19T12:21:16.204Z |
5092233 | 5092233 | 20240912024016_4O2An | UK00AD | 2024-09-16T12:13:44.217Z | 2024-09-19T12:21:13.711Z |
5090936 | 5090936 | 20240912015239_M5FgQ | UK00AD | 2024-09-16T12:12:43.645Z | 2024-09-19T12:21:12.379Z |
5088744 | 5088744 | 20240913002322_7N96B | UK00AD | 2024-09-16T12:08:25.511Z | 2024-09-19T12:20:37.224Z |
5088509 | 5088509 | 20240913001427_YL9iH | UK00AD | 2024-09-16T12:08:07.573Z | 2024-09-19T12:20:36.977Z |
5087678 | 5087678 | 20240912233928_nzWKv | UK00AD | 2024-09-16T12:07:13.007Z | 2024-09-19T12:20:35.528Z |
5087665 | 5087665 | 20240912233912_ts3pc | UK00AD | 2024-09-16T12:07:12.317Z | 2024-09-19T12:20:35.524Z |
5087070 | 5087070 | 20240912230658_ySd9Y | UK00AD | 2024-09-16T12:06:31.318Z | 2024-09-19T12:20:33.952Z |
5087038 | 5087038 | 20240912230404_Wpa5Z | UK00AD | 2024-09-16T12:06:27.820Z | 2024-09-19T12:20:33.595Z |
5086310 | 5086310 | 20240912222646_IlhZo | UK00AD | 2024-09-16T12:05:32.616Z | 2024-09-19T12:20:30.852Z |
5080490 | 5080490 | 20240911040238_PEFrT | UK00AD | 2024-09-15T12:17:05.120Z | 2024-09-19T12:21:43.317Z |
5080147 | 5080147 | 20240911033610_Expz5 | UK00AD | 2024-09-15T12:16:52.028Z | 2024-09-19T12:21:43.115Z |
5079966 | 5079966 | 20240911032236_E0xow | UK00AD | 2024-09-15T12:16:42.888Z | 2024-09-19T12:21:42.914Z |
5079924 | 5079924 | 20240911032054_Ku4W1 | UK00AD | 2024-09-15T12:16:41.890Z | 2024-09-19T12:21:42.787Z |
5079821 | 5079821 | 20240911031455_3y9J2 | UK00AD | 2024-09-15T12:16:37.725Z | 2024-09-19T12:21:42.688Z |
5079254 | 5079254 | 20240911024448_3mRpt | UK00AD | 2024-09-15T12:16:13.122Z | 2024-09-19T12:21:41.296Z |
5078245 | 5078245 | 20240911014519_s4yYl | UK00AD | 2024-09-15T12:15:27.961Z | 2024-09-19T12:21:40.110Z |
5078096 | 5078096 | 20240911013938_G8bsu | UK00AD | 2024-09-15T12:15:19.814Z | 2024-09-19T12:21:39.983Z |
5078041 | 5078041 | 20240911013658_yTsKs | UK00AD | 2024-09-15T12:15:17.425Z | 2024-09-19T12:21:39.924Z |
5077200 | 5077200 | 20240911003228_gFOeF | UK00AD | 2024-09-15T12:14:29.795Z | 2024-09-19T12:21:38.510Z |
5077173 | 5077173 | 20240911002937_aR5h8 | UK00AD | 2024-09-15T12:14:27.027Z | 2024-09-19T12:21:38.311Z |
5077168 | 5077168 | 20240911002858_uHvnL | UK00AD | 2024-09-15T12:14:26.521Z | 2024-09-19T12:21:38.307Z |
5077014 | 5077014 | 20240911002103_tX4ui | UK00AD | 2024-09-15T12:14:17.534Z | 2024-09-19T12:21:37.961Z |
5076376 | 5076376 | 20240910232945_SHRKj | UK00AD | 2024-09-15T12:13:31.069Z | 2024-09-19T12:21:36.767Z |
5074207 | 5074207 | 20240911222259_wyPjO | UK00AD | 2024-09-15T12:08:08.690Z | 2024-09-19T12:21:06.979Z |
5073425 | 5073425 | 20240911212326_BJlHF | UK00AD | 2024-09-15T12:07:09.822Z | 2024-09-19T12:21:05.748Z |
5073214 | 5073214 | 20240911210558_YeKrz | UK00AD | 2024-09-15T12:06:55.129Z | 2024-09-19T12:21:05.233Z |
5072663 | 5072663 | 20240911203602_uKAtI | UK00AD | 2024-09-15T12:05:58.684Z | 2024-09-19T12:21:04.582Z |
5070371 | 5070371 | 20240910225442_1vrpw | UK00AD | 2024-09-14T12:20:21.154Z | 2024-09-19T12:21:36.044Z |
5069913 | 5069913 | 20240910221435_EPSls | UK00AD | 2024-09-14T12:20:09.354Z | 2024-09-19T12:21:35.444Z |
5069515 | 5069515 | 20240910215005_2gmaK | UK00AD | 2024-09-14T12:19:59.171Z | 2024-09-19T12:21:34.991Z |
5069276 | 5069276 | 20240910212519_XIKeR | UK00AD | 2024-09-14T12:19:52.031Z | 2024-09-19T12:21:34.407Z |
5064221 | 5064221 | 20240910002537_rUBcB | UK00AD | 2024-09-14T12:15:05.464Z | 2024-09-18T12:15:15.868Z |
5063991 | 5063991 | 20240909231627_k1gPL | UK00AD | 2024-09-14T12:14:37.207Z | 2024-09-18T12:15:15.138Z |
5053891 | 5053891 | 20240908014521_2wtJF | UK00AD | 2024-09-13T12:16:20.993Z | 2024-09-16T12:21:13.028Z |
5032398 | 5032398 | 20240907005706_2LdyC | UK00AD | 2024-09-12T12:07:14.296Z | 2024-09-15T12:21:26.327Z |
5031605 | 5031605 | 20240906224107_17Ydf | UK00AD | 2024-09-12T12:05:15.730Z | 2024-09-15T12:21:23.413Z |
5031365 | 5031365 | 20240906213336_C4ADd | UK00AD | 2024-09-12T12:04:37.313Z | 2024-09-15T12:21:22.100Z |
5031300 | 5031300 | 20240906211843_PIl6V | UK00AD | 2024-09-12T12:04:28.320Z | 2024-09-15T12:21:21.925Z |
5031267 | 5031267 | 20240906210527_PyyYt | UK00AD | 2024-09-12T12:04:24.356Z | 2024-09-15T12:21:21.866Z |
5031227 | 5031227 | 20240906205602_I9vwM | UK00AD | 2024-09-12T12:04:20.182Z | 2024-09-15T12:21:21.766Z |
5009980 | 5009980 | 20240904022305_EQ22b | UK00AD | 2024-09-09T12:08:16.805Z | 2024-09-12T12:19:25.253Z |
5008904 | 5008904 | 20240904003425_3G1j4 | UK00AD | 2024-09-09T12:07:12.985Z | 2024-09-12T12:19:20.589Z |
4998229 | 4998229 | 20240903023238_evnxK | UK00AD | 2024-09-08T12:07:24.405Z | 2024-09-11T12:21:11.532Z |
4998177 | 4998177 | 20240903022648_zBK5Y | UK00AD | 2024-09-08T12:07:21.451Z | 2024-09-11T12:21:11.370Z |
4997944 | 4997944 | 20240903014830_diHqe | UK00AD | 2024-09-08T12:06:59.471Z | 2024-09-11T12:21:10.099Z |
4997871 | 4997871 | 20240903013802_xPa5n | UK00AD | 2024-09-08T12:06:54.434Z | 2024-09-11T12:21:09.593Z |
4990827 | 4990827 | 20240901011638_Zv7UH | UK00AD | 2024-09-07T12:11:11.583Z | 2024-09-09T12:26:46.411Z |
4990722 | 4990722 | 20240901010004_Kdg7P | UK00AD | 2024-09-07T12:10:58.882Z | 2024-09-09T12:26:33.374Z |
4990325 | 4990325 | 20240901000238_qPXVr | UK00AD | 2024-09-07T12:10:20.869Z | 2024-09-09T12:26:16.570Z |
4983266 | 4983266 | 20240812004238_pCrnZ | UK00AD | 2024-09-06T12:15:23.921Z | 2024-09-06T12:15:23.921Z |
4982514 | 4982514 | 20240812003429_ZYAKW | UK00AD | 2024-09-06T12:14:54.452Z | 2024-09-06T12:14:54.452Z |
4979790 | 4979790 | 20240812000443_Ycy0u | UK00AD | 2024-09-06T12:13:28.102Z | 2024-09-06T12:13:28.102Z |
4968716 | 4968716 | 20240811220223_DyNvA | UK00AD | 2024-09-05T12:08:25.959Z | 2024-09-06T12:07:35.328Z |
4952217 | 4952217 | 20240811021733_WbTZ2 | UK00AD | 2024-09-03T12:16:52.488Z | 2024-09-06T12:27:53.639Z |
4947855 | 4947855 | 20240811012539_5hmEJ | UK00AD | 2024-09-02T12:14:48.824Z | 2024-09-06T12:27:03.237Z |
4947802 | 4947802 | 20240811012459_P1pGI | UK00AD | 2024-09-02T12:14:48.074Z | 2024-09-06T12:27:02.825Z |
4945250 | 4945250 | 20240811004314_SbD3q | UK00AD | 2024-09-02T12:13:13.226Z | 2024-09-06T12:25:50.917Z |
4944467 | 4944467 | 20240811002949_NM8ax | UK00AD | 2024-09-02T12:12:32.935Z | 2024-09-06T12:25:23.381Z |
4944295 | 4944295 | 20240811002643_UzSwe | UK00AD | 2024-09-02T12:12:27.163Z | 2024-09-06T12:25:17.314Z |
4944280 | 4944280 | 20240811002614_FE1zr | UK00AD | 2024-09-02T12:12:26.599Z | 2024-09-06T12:25:16.879Z |
4938635 | 4938635 | 20240810222438_LKpaP | UK00AD | 2024-09-01T12:09:13.160Z | 2024-09-06T12:22:58.481Z |
4937873 | 4937873 | 20240810220340_lB695 | UK00AD | 2024-09-01T12:08:41.110Z | 2024-09-06T12:22:35.662Z |
4927804 | 4927804 | 20240810022315_vWx9I | UK00AD | 2024-08-31T12:20:55.854Z | 2024-09-02T12:28:51.448Z |
4927730 | 4927730 | 20240810022014_avtCK | UK00AD | 2024-08-31T12:20:50.388Z | 2024-09-02T12:28:49.090Z |
4927648 | 4927648 | 20240810021716_t6aWh | UK00AD | 2024-08-31T12:20:46.959Z | 2024-09-02T12:28:45.842Z |
4927616 | 4927616 | 20240810021629_ndggG | UK00AD | 2024-08-31T12:20:45.329Z | 2024-09-02T12:28:44.140Z |
4927573 | 4927573 | 20240810021600_JT1Ht | UK00AD | 2024-08-31T12:20:43.967Z | 2024-09-02T12:28:42.456Z |
4927270 | 4927270 | 20240810020844_kEZE0 | UK00AD | 2024-08-31T12:20:25.256Z | 2024-09-02T12:28:28.234Z |
4926907 | 4926907 | 20240810020111_w9JD8 | UK00AD | 2024-08-31T12:20:09.298Z | 2024-09-02T12:28:11.739Z |
4926778 | 4926778 | 20240810015655_O05wp | UK00AD | 2024-08-31T12:19:54.702Z | 2024-09-02T12:28:04.882Z |
4926364 | 4926364 | 20240810014741_UGtyd | UK00AD | 2024-08-31T12:19:36.825Z | 2024-09-02T12:27:46.782Z |
4919356 | 4919356 | 20240810001055_3El2A | UK00AD | 2024-08-30T12:12:41.148Z | 2024-09-02T12:25:50.681Z |
4918948 | 4918948 | 20240810000130_PVpbV | UK00AD | 2024-08-30T12:12:26.899Z | 2024-09-02T12:25:39.183Z |
4917131 | 4917131 | 20240809232948_z4Q73 | UK00AD | 2024-08-30T12:11:17.538Z | 2024-09-02T12:24:53.158Z |
4917081 | 4917081 | 20240809232858_f2jgK | UK00AD | 2024-08-30T12:11:15.722Z | 2024-09-02T12:24:51.280Z |
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);