participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,429 rows where station_code = "UK005N" 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 |
---|---|---|---|---|---|
5135293 | 5135293 | 20240915020041_7PesS | UK005N | 2024-09-19T12:19:00.228Z | 2024-09-19T12:19:00.228Z |
5128431 | 5128431 | 20240917014244_XuzZ7 | UK005N | 2024-09-19T12:10:34.656Z | 2024-09-19T12:10:34.656Z |
5128134 | 5128134 | 20240917004738_p3zvx | UK005N | 2024-09-19T12:10:08.468Z | 2024-09-19T12:10:08.468Z |
5128042 | 5128042 | 20240917002930_ioWAj | UK005N | 2024-09-19T12:09:56.681Z | 2024-09-19T12:09:56.681Z |
5127858 | 5127858 | 20240916235248_llpFg | UK005N | 2024-09-19T12:09:44.085Z | 2024-09-19T12:09:44.085Z |
5127626 | 5127626 | 20240916223750_uUPkw | UK005N | 2024-09-19T12:09:27.504Z | 2024-09-19T12:09:27.504Z |
5126814 | 5126814 | 20240916193654_zRgQO | UK005N | 2024-09-19T12:07:19.822Z | 2024-09-19T12:07:19.822Z |
5122070 | 5122070 | 20240914043057_QqBh3 | UK005N | 2024-09-18T12:11:05.320Z | 2024-09-19T12:20:02.721Z |
5121680 | 5121680 | 20240914041207_LDHts | UK005N | 2024-09-18T12:10:59.349Z | 2024-09-19T12:20:02.212Z |
5121325 | 5121325 | 20240914035815_Xm2fk | UK005N | 2024-09-18T12:10:54.567Z | 2024-09-19T12:20:01.624Z |
5121220 | 5121220 | 20240914035546_z4tKw | UK005N | 2024-09-18T12:10:52.471Z | 2024-09-19T12:20:01.494Z |
5121148 | 5121148 | 20240914035416_WO0B7 | UK005N | 2024-09-18T12:10:52.062Z | 2024-09-19T12:20:01.457Z |
5120961 | 5120961 | 20240914034301_pu1Yj | UK005N | 2024-09-18T12:10:48.930Z | 2024-09-19T12:20:01.080Z |
5120510 | 5120510 | 20240914032557_QEKEm | UK005N | 2024-09-18T12:10:42.495Z | 2024-09-19T12:20:00.512Z |
5120465 | 5120465 | 20240914032201_e6H2p | UK005N | 2024-09-18T12:10:41.043Z | 2024-09-19T12:20:00.387Z |
5119918 | 5119918 | 20240914025341_z3AvP | UK005N | 2024-09-18T12:10:29.523Z | 2024-09-19T12:19:59.165Z |
5119832 | 5119832 | 20240914025103_D1BGx | UK005N | 2024-09-18T12:10:28.191Z | 2024-09-19T12:19:59.015Z |
5119619 | 5119619 | 20240914024024_5JL2w | UK005N | 2024-09-18T12:10:22.717Z | 2024-09-19T12:19:58.600Z |
5119103 | 5119103 | 20240914020910_eApWm | UK005N | 2024-09-18T12:10:16.105Z | 2024-09-19T12:19:57.137Z |
5117232 | 5117232 | 20240915041438_lwds4 | UK005N | 2024-09-18T12:07:35.964Z | 2024-09-19T12:19:13.959Z |
5116931 | 5116931 | 20240915035106_fqa3m | UK005N | 2024-09-18T12:07:26.453Z | 2024-09-19T12:19:12.803Z |
5116882 | 5116882 | 20240915034630_Wu231 | UK005N | 2024-09-18T12:07:24.414Z | 2024-09-19T12:19:12.587Z |
5116809 | 5116809 | 20240915034322_raSAp | UK005N | 2024-09-18T12:07:21.765Z | 2024-09-19T12:19:12.427Z |
5116478 | 5116478 | 20240915032855_z9J9E | UK005N | 2024-09-18T12:07:05.638Z | 2024-09-19T12:19:11.298Z |
5116354 | 5116354 | 20240915032341_RXHs5 | UK005N | 2024-09-18T12:06:59.896Z | 2024-09-19T12:19:10.635Z |
5115685 | 5115685 | 20240915024901_cfo4B | UK005N | 2024-09-18T12:06:21.189Z | 2024-09-19T12:19:06.385Z |
5115508 | 5115508 | 20240915024318_EW1V3 | UK005N | 2024-09-18T12:06:16.607Z | 2024-09-19T12:19:05.112Z |
5115406 | 5115406 | 20240915023653_YvvWz | UK005N | 2024-09-18T12:06:13.122Z | 2024-09-19T12:19:04.540Z |
5115162 | 5115162 | 20240915022255_gNLkC | UK005N | 2024-09-18T12:06:04.346Z | 2024-09-19T12:19:02.633Z |
5114740 | 5114740 | 20240915015716_MKkOP | UK005N | 2024-09-18T12:05:32.359Z | 2024-09-19T12:18:59.682Z |
5114259 | 5114259 | 20240915013416_YFd5H | UK005N | 2024-09-18T12:05:09.097Z | 2024-09-19T12:18:57.332Z |
5114197 | 5114197 | 20240915013034_k8F25 | UK005N | 2024-09-18T12:05:06.105Z | 2024-09-19T12:18:56.697Z |
5114123 | 5114123 | 20240915012759_VBJvG | UK005N | 2024-09-18T12:05:03.190Z | 2024-09-19T12:18:56.190Z |
5114076 | 5114076 | 20240915012521_pzUJL | UK005N | 2024-09-18T12:05:00.816Z | 2024-09-19T12:18:55.721Z |
5114044 | 5114044 | 20240915012349_L3tux | UK005N | 2024-09-18T12:04:59.893Z | 2024-09-19T12:18:55.472Z |
5113809 | 5113809 | 20240915011405_FkSd0 | UK005N | 2024-09-18T12:04:51.277Z | 2024-09-19T12:18:52.849Z |
5113302 | 5113302 | 20240915003646_pb17F | UK005N | 2024-09-18T12:04:06.691Z | 2024-09-19T12:18:48.424Z |
5113054 | 5113054 | 20240915001700_VQfkl | UK005N | 2024-09-18T12:03:53.157Z | 2024-09-19T12:18:46.732Z |
5113029 | 5113029 | 20240915001631_Ul52A | UK005N | 2024-09-18T12:03:51.992Z | 2024-09-19T12:18:46.575Z |
5112995 | 5112995 | 20240915001128_05fde | UK005N | 2024-09-18T12:03:50.087Z | 2024-09-19T12:18:46.260Z |
5112978 | 5112978 | 20240915001109_JKPUo | UK005N | 2024-09-18T12:03:49.881Z | 2024-09-19T12:18:46.235Z |
5112955 | 5112955 | 20240915001108_I3lqt | UK005N | 2024-09-18T12:03:49.751Z | 2024-09-19T12:18:46.054Z |
5112332 | 5112332 | 20240914225935_jTITy | UK005N | 2024-09-18T12:03:00.364Z | 2024-09-19T12:18:40.597Z |
5111885 | 5111885 | 20240914213020_q30xV | UK005N | 2024-09-18T12:02:28.411Z | 2024-09-19T12:18:34.867Z |
5111857 | 5111857 | 20240914212428_4dPyF | UK005N | 2024-09-18T12:02:23.058Z | 2024-09-19T12:18:34.673Z |
5111737 | 5111737 | 20240914211135_QpvFq | UK005N | 2024-09-18T12:02:14.754Z | 2024-09-19T12:18:33.764Z |
5111334 | 5111334 | 20240914202259_6rxme | UK005N | 2024-09-18T12:01:49.849Z | 2024-09-19T12:18:29.098Z |
5108147 | 5108147 | 20240913042645_M2B6h | UK005N | 2024-09-17T12:13:31.473Z | 2024-09-19T12:20:47.868Z |
5107854 | 5107854 | 20240913041239_xuIIZ | UK005N | 2024-09-17T12:13:24.834Z | 2024-09-19T12:20:47.606Z |
5107274 | 5107274 | 20240913035023_br1Wh | UK005N | 2024-09-17T12:13:12.222Z | 2024-09-19T12:20:46.973Z |
5107005 | 5107005 | 20240913034207_pu92q | UK005N | 2024-09-17T12:13:07.004Z | 2024-09-19T12:20:46.771Z |
5106896 | 5106896 | 20240913033804_6bAi1 | UK005N | 2024-09-17T12:13:03.762Z | 2024-09-19T12:20:46.510Z |
5106597 | 5106597 | 20240913032918_4RKKo | UK005N | 2024-09-17T12:12:57.692Z | 2024-09-19T12:20:46.192Z |
5106572 | 5106572 | 20240913032848_C8UT3 | UK005N | 2024-09-17T12:12:57.311Z | 2024-09-19T12:20:46.178Z |
5106543 | 5106543 | 20240913032846_X30ef | UK005N | 2024-09-17T12:12:57.187Z | 2024-09-19T12:20:46.174Z |
5106042 | 5106042 | 20240913030733_lQoMo | UK005N | 2024-09-17T12:12:39.062Z | 2024-09-19T12:20:45.361Z |
5105758 | 5105758 | 20240913025646_YLUy6 | UK005N | 2024-09-17T12:12:28.512Z | 2024-09-19T12:20:44.868Z |
5105290 | 5105290 | 20240913024058_qnDfa | UK005N | 2024-09-17T12:12:08.620Z | 2024-09-19T12:20:44.241Z |
5104621 | 5104621 | 20240913021743_J37Pr | UK005N | 2024-09-17T12:11:41.383Z | 2024-09-19T12:20:42.648Z |
5104440 | 5104440 | 20240913021014_RwRim | UK005N | 2024-09-17T12:11:35.522Z | 2024-09-19T12:20:41.481Z |
5104019 | 5104019 | 20240913014743_HNaIF | UK005N | 2024-09-17T12:11:22.353Z | 2024-09-19T12:20:40.896Z |
5103869 | 5103869 | 20240913014238_YhbsR | UK005N | 2024-09-17T12:11:14.493Z | 2024-09-19T12:20:40.639Z |
5103845 | 5103845 | 20240913014220_6dD5N | UK005N | 2024-09-17T12:11:13.377Z | 2024-09-19T12:20:40.626Z |
5103445 | 5103445 | 20240913013054_BCgK8 | UK005N | 2024-09-17T12:10:57.980Z | 2024-09-19T12:20:40.183Z |
5103042 | 5103042 | 20240914015933_3CQ1x | UK005N | 2024-09-17T12:07:49.006Z | 2024-09-19T12:19:56.471Z |
5102690 | 5102690 | 20240914013752_rN9a2 | UK005N | 2024-09-17T12:07:31.646Z | 2024-09-19T12:19:55.406Z |
5102527 | 5102527 | 20240914013033_3gEnZ | UK005N | 2024-09-17T12:07:19.202Z | 2024-09-19T12:19:54.725Z |
5102245 | 5102245 | 20240914011310_txDH5 | UK005N | 2024-09-17T12:06:55.815Z | 2024-09-19T12:19:53.092Z |
5102086 | 5102086 | 20240914010550_bMIHT | UK005N | 2024-09-17T12:06:47.308Z | 2024-09-19T12:19:52.432Z |
5101799 | 5101799 | 20240914004732_A2oj5 | UK005N | 2024-09-17T12:06:12.955Z | 2024-09-19T12:19:51.512Z |
5101613 | 5101613 | 20240914003907_SgXcF | UK005N | 2024-09-17T12:06:05.143Z | 2024-09-19T12:19:51.103Z |
5101157 | 5101157 | 20240914000741_Ettys | UK005N | 2024-09-17T12:05:23.103Z | 2024-09-19T12:19:49.884Z |
5100764 | 5100764 | 20240913234523_7Nw8T | UK005N | 2024-09-17T12:04:54.854Z | 2024-09-19T12:19:48.706Z |
5100735 | 5100735 | 20240913234446_3POWW | UK005N | 2024-09-17T12:04:53.491Z | 2024-09-19T12:19:48.695Z |
5100687 | 5100687 | 20240913234141_y3H1k | UK005N | 2024-09-17T12:04:49.115Z | 2024-09-19T12:19:48.530Z |
5100587 | 5100587 | 20240913233325_pOsL2 | UK005N | 2024-09-17T12:04:40.032Z | 2024-09-19T12:19:48.156Z |
5100458 | 5100458 | 20240913232718_Rbr4s | UK005N | 2024-09-17T12:04:34.781Z | 2024-09-19T12:19:48.005Z |
5099607 | 5099607 | 20240913213959_saTlk | UK005N | 2024-09-17T12:03:12.987Z | 2024-09-19T12:19:45.453Z |
5099582 | 5099582 | 20240913213756_QKdb2 | UK005N | 2024-09-17T12:03:11.594Z | 2024-09-19T12:19:45.377Z |
5099511 | 5099511 | 20240913212810_PX7Lu | UK005N | 2024-09-17T12:03:05.371Z | 2024-09-19T12:19:45.180Z |
5099231 | 5099231 | 20240913204143_FqMZU | UK005N | 2024-09-17T12:02:32.512Z | 2024-09-19T12:19:44.146Z |
5099001 | 5099001 | 20240913200553_WCSls | UK005N | 2024-09-17T12:02:09.252Z | 2024-09-19T12:19:42.952Z |
5098073 | 5098073 | 20240913011603_LLww2 | UK005N | 2024-09-16T12:17:19.294Z | 2024-09-19T12:20:39.652Z |
5097881 | 5097881 | 20240913010803_maxng | UK005N | 2024-09-16T12:17:16.376Z | 2024-09-19T12:20:39.166Z |
5094486 | 5094486 | 20240912040535_zdI9l | UK005N | 2024-09-16T12:14:48.604Z | 2024-09-19T12:21:16.181Z |
5094439 | 5094439 | 20240912040131_YK5u3 | UK005N | 2024-09-16T12:14:45.110Z | 2024-09-19T12:21:16.122Z |
5094290 | 5094290 | 20240912035559_0hO85 | UK005N | 2024-09-16T12:14:40.816Z | 2024-09-19T12:21:16.061Z |
5094236 | 5094236 | 20240912035411_JoaMv | UK005N | 2024-09-16T12:14:39.794Z | 2024-09-19T12:21:16.030Z |
5093987 | 5093987 | 20240912034347_dg27o | UK005N | 2024-09-16T12:14:30.352Z | 2024-09-19T12:21:15.812Z |
5093574 | 5093574 | 20240912032716_ANq2s | UK005N | 2024-09-16T12:14:21.426Z | 2024-09-19T12:21:15.417Z |
5093499 | 5093499 | 20240912032428_dsMTa | UK005N | 2024-09-16T12:14:19.073Z | 2024-09-19T12:21:15.387Z |
5093342 | 5093342 | 20240912031838_souLP | UK005N | 2024-09-16T12:14:15.751Z | 2024-09-19T12:21:15.264Z |
5093178 | 5093178 | 20240912031313_DDnVR | UK005N | 2024-09-16T12:14:12.771Z | 2024-09-19T12:21:14.997Z |
5093001 | 5093001 | 20240912030726_6MzRJ | UK005N | 2024-09-16T12:14:09.606Z | 2024-09-19T12:21:14.822Z |
5092202 | 5092202 | 20240912024005_69ypU | UK005N | 2024-09-16T12:13:43.783Z | 2024-09-19T12:21:13.699Z |
5092184 | 5092184 | 20240912023930_5pP7A | UK005N | 2024-09-16T12:13:43.138Z | 2024-09-19T12:21:13.684Z |
5092050 | 5092050 | 20240912023534_jYkrO | UK005N | 2024-09-16T12:13:38.794Z | 2024-09-19T12:21:13.607Z |
5091993 | 5091993 | 20240912023438_SL9zm | UK005N | 2024-09-16T12:13:37.254Z | 2024-09-19T12:21:13.568Z |
5091966 | 5091966 | 20240912023208_o3hQI | UK005N | 2024-09-16T12:13:34.325Z | 2024-09-19T12:21:13.541Z |
5091756 | 5091756 | 20240912022043_FF0NL | UK005N | 2024-09-16T12:13:22.181Z | 2024-09-19T12:21:13.383Z |
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);