participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,869 rows where station_code = "UK005J" 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 |
---|---|---|---|---|---|
5583883 | 5583883 | 20241119000440_r3bJe | UK005J | 2024-11-23T14:25:07.652Z | 2024-11-23T14:25:07.652Z |
5583864 | 5583864 | 20241118204840_Df3gl | UK005J | 2024-11-23T14:25:05.870Z | 2024-11-23T14:25:05.870Z |
5583850 | 5583850 | 20241118194606_USRYN | UK005J | 2024-11-23T14:25:05.371Z | 2024-11-23T14:25:05.371Z |
5574371 | 5574371 | 20241122053911_sLAFH | UK005J | 2024-11-23T14:03:08.860Z | 2024-11-23T14:03:08.860Z |
5573192 | 5573192 | 20241121040533_EVv0L | UK005J | 2024-11-22T14:19:15.053Z | 2024-11-23T14:23:52.336Z |
5572197 | 5572197 | 20241121014555_uIb3w | UK005J | 2024-11-22T14:18:04.359Z | 2024-11-23T14:23:41.361Z |
5572141 | 5572141 | 20241121014045_oWpLu | UK005J | 2024-11-22T14:18:01.126Z | 2024-11-23T14:23:40.539Z |
5572115 | 5572115 | 20241121013503_WgEDq | UK005J | 2024-11-22T14:17:58.617Z | 2024-11-23T14:23:40.290Z |
5572106 | 5572106 | 20241121013330_3aDCM | UK005J | 2024-11-22T14:17:58.168Z | 2024-11-23T14:23:40.183Z |
5571828 | 5571828 | 20241121005218_vQJUC | UK005J | 2024-11-22T14:17:41.645Z | 2024-11-23T14:23:35.870Z |
5571731 | 5571731 | 20241121003637_xiTAd | UK005J | 2024-11-22T14:17:36.380Z | 2024-11-23T14:23:34.094Z |
5571038 | 5571038 | 20241120220222_KmRZE | UK005J | 2024-11-22T14:16:19.493Z | 2024-11-23T14:23:21.839Z |
5570884 | 5570884 | 20241120212234_5gcZl | UK005J | 2024-11-22T14:16:10.591Z | 2024-11-23T14:23:19.616Z |
5570880 | 5570880 | 20241120212232_5tXfE | UK005J | 2024-11-22T14:16:10.427Z | 2024-11-23T14:23:19.548Z |
5566400 | 5566400 | 20241121060815_Ka6pF | UK005J | 2024-11-22T14:02:45.730Z | 2024-11-23T14:21:23.695Z |
5557233 | 5557233 | 20241119044311_h1IVk | UK005J | 2024-11-20T14:12:29.857Z | 2024-11-23T14:25:10.869Z |
5557169 | 5557169 | 20241119041808_02SzF | UK005J | 2024-11-20T14:12:24.265Z | 2024-11-23T14:25:10.563Z |
5557164 | 5557164 | 20241119041554_gD4td | UK005J | 2024-11-20T14:12:23.655Z | 2024-11-23T14:25:10.535Z |
5557072 | 5557072 | 20241119034552_ROfpM | UK005J | 2024-11-20T14:12:12.287Z | 2024-11-23T14:25:09.992Z |
5556953 | 5556953 | 20241119030636_ZtB7f | UK005J | 2024-11-20T14:11:47.476Z | 2024-11-23T14:25:09.446Z |
5556719 | 5556719 | 20241119013021_N4fkU | UK005J | 2024-11-20T14:11:21.781Z | 2024-11-23T14:25:08.234Z |
5556425 | 5556425 | 20241118212449_33YIV | UK005J | 2024-11-20T14:10:28.577Z | 2024-11-23T14:25:06.240Z |
5556309 | 5556309 | 20241118182810_r8Agr | UK005J | 2024-11-20T14:09:52.027Z | 2024-11-23T14:25:04.845Z |
5556296 | 5556296 | 20241118180517_yO4GD | UK005J | 2024-11-20T14:09:48.656Z | 2024-11-23T14:25:04.657Z |
5554130 | 5554130 | 20241119062520_kQw33 | UK005J | 2024-11-20T14:00:49.192Z | 2024-11-23T14:23:58.664Z |
5554125 | 5554125 | 20241119062407_QvK0F | UK005J | 2024-11-20T14:00:48.842Z | 2024-11-23T14:23:58.663Z |
5554089 | 5554089 | 20241119060523_2ZeCK | UK005J | 2024-11-20T14:00:42.785Z | 2024-11-23T14:23:58.356Z |
5554051 | 5554051 | 20241119054947_l4RCE | UK005J | 2024-11-20T14:00:34.375Z | 2024-11-23T14:23:57.948Z |
5553486 | 5553486 | 20241118025515_M2y3X | UK005J | 2024-11-19T14:10:41.809Z | 2024-11-23T14:25:29.848Z |
5553339 | 5553339 | 20241118020738_rjPVD | UK005J | 2024-11-19T14:10:20.347Z | 2024-11-23T14:25:29.338Z |
5553025 | 5553025 | 20241118002201_dIz3y | UK005J | 2024-11-19T14:09:57.660Z | 2024-11-23T14:25:28.265Z |
5549615 | 5549615 | 20241118053901_ULjwS | UK005J | 2024-11-19T14:00:26.216Z | 2024-11-23T14:24:49.197Z |
5549519 | 5549519 | 20241118050902_QbpXP | UK005J | 2024-11-19T14:00:12.303Z | 2024-11-23T14:24:48.962Z |
5549333 | 5549333 | 20241117042613_r898C | UK005J | 2024-11-18T14:11:28.470Z | 2024-11-23T14:25:44.071Z |
5549286 | 5549286 | 20241117041215_jSqt9 | UK005J | 2024-11-18T14:11:25.164Z | 2024-11-23T14:25:44.001Z |
5549257 | 5549257 | 20241117040342_Szuzi | UK005J | 2024-11-18T14:11:22.649Z | 2024-11-23T14:25:43.850Z |
5549122 | 5549122 | 20241117031513_3rbH5 | UK005J | 2024-11-18T14:11:01.201Z | 2024-11-23T14:25:43.208Z |
5548997 | 5548997 | 20241117024022_sZH6L | UK005J | 2024-11-18T14:10:37.074Z | 2024-11-23T14:25:42.456Z |
5543761 | 5543761 | 20241115032110_3vgE1 | UK005J | 2024-11-16T14:07:10.066Z | 2024-11-23T14:26:20.844Z |
5543664 | 5543664 | 20241115024757_6tvuX | UK005J | 2024-11-16T14:06:59.495Z | 2024-11-23T14:26:20.220Z |
5543436 | 5543436 | 20241115012248_9QfJA | UK005J | 2024-11-16T14:06:20.352Z | 2024-11-23T14:26:18.943Z |
5543275 | 5543275 | 20241114234229_5ejbn | UK005J | 2024-11-16T14:05:58.700Z | 2024-11-23T14:26:18.354Z |
5543217 | 5543217 | 20241114230821_2Nxrw | UK005J | 2024-11-16T14:05:47.186Z | 2024-11-23T14:26:18.228Z |
5543040 | 5543040 | 20241114183659_dVSkQ | UK005J | 2024-11-16T14:05:25.231Z | 2024-11-23T14:26:17.364Z |
5542157 | 5542157 | 20241115061850_2XpUk | UK005J | 2024-11-16T14:00:26.950Z | 2024-11-23T14:25:46.406Z |
5541970 | 5541970 | 20241114052323_PB0lJ | UK005J | 2024-11-15T14:08:44.833Z | 2024-11-22T14:24:21.471Z |
5541825 | 5541825 | 20241114044907_Kn59J | UK005J | 2024-11-15T14:08:32.408Z | 2024-11-22T14:24:20.515Z |
5541603 | 5541603 | 20241114030835_3FZnM | UK005J | 2024-11-15T14:07:56.214Z | 2024-11-22T14:24:19.577Z |
5541598 | 5541598 | 20241114030724_KI1ol | UK005J | 2024-11-15T14:07:56.108Z | 2024-11-22T14:24:19.566Z |
5541568 | 5541568 | 20241114024541_5uMpJ | UK005J | 2024-11-15T14:07:52.480Z | 2024-11-22T14:24:19.487Z |
5541511 | 5541511 | 20241114021728_kPHcR | UK005J | 2024-11-15T14:07:46.280Z | 2024-11-22T14:24:19.269Z |
5541400 | 5541400 | 20241114012722_IrCJC | UK005J | 2024-11-15T14:07:34.325Z | 2024-11-22T14:24:18.494Z |
5541390 | 5541390 | 20241114012125_jkvdM | UK005J | 2024-11-15T14:07:33.408Z | 2024-11-22T14:24:18.473Z |
5541367 | 5541367 | 20241114010522_Sov0D | UK005J | 2024-11-15T14:07:31.472Z | 2024-11-22T14:24:18.355Z |
5541330 | 5541330 | 20241114003212_juiev | UK005J | 2024-11-15T14:07:27.760Z | 2024-11-22T14:24:18.085Z |
5541322 | 5541322 | 20241114002139_kHzvl | UK005J | 2024-11-15T14:07:27.046Z | 2024-11-22T14:24:18.034Z |
5541285 | 5541285 | 20241113234342_HL483 | UK005J | 2024-11-15T14:07:22.566Z | 2024-11-22T14:24:17.810Z |
5541248 | 5541248 | 20241113220151_0uDYl | UK005J | 2024-11-15T14:07:08.536Z | 2024-11-22T14:24:17.498Z |
5539036 | 5539036 | 20241113053614_3tXXm | UK005J | 2024-11-14T14:14:09.543Z | 2024-11-21T14:26:31.066Z |
5538986 | 5538986 | 20241113052849_oR2YR | UK005J | 2024-11-14T14:14:07.559Z | 2024-11-21T14:26:30.992Z |
5538933 | 5538933 | 20241113052150_K1zg4 | UK005J | 2024-11-14T14:14:04.511Z | 2024-11-21T14:26:30.073Z |
5538897 | 5538897 | 20241113051212_PbpMD | UK005J | 2024-11-14T14:14:02.747Z | 2024-11-21T14:26:29.648Z |
5538776 | 5538776 | 20241113045526_Xw7pl | UK005J | 2024-11-14T14:13:56.516Z | 2024-11-21T14:26:28.698Z |
5538686 | 5538686 | 20241113043711_xKgD5 | UK005J | 2024-11-14T14:13:49.229Z | 2024-11-21T14:26:28.530Z |
5537844 | 5537844 | 20241113010332_IEONF | UK005J | 2024-11-14T14:12:33.213Z | 2024-11-21T14:26:16.451Z |
5537549 | 5537549 | 20241112233652_yW2cs | UK005J | 2024-11-14T14:12:08.118Z | 2024-11-21T14:26:14.171Z |
5537543 | 5537543 | 20241112233630_C3MIh | UK005J | 2024-11-14T14:12:07.189Z | 2024-11-21T14:26:14.115Z |
5537502 | 5537502 | 20241112232619_9HNoH | UK005J | 2024-11-14T14:12:00.345Z | 2024-11-21T14:26:13.946Z |
5537390 | 5537390 | 20241112223512_GSZOW | UK005J | 2024-11-14T14:11:43.596Z | 2024-11-21T14:26:11.951Z |
5537342 | 5537342 | 20241112221239_TG3zG | UK005J | 2024-11-14T14:11:39.161Z | 2024-11-21T14:26:11.352Z |
5537233 | 5537233 | 20241112211622_HEUIX | UK005J | 2024-11-14T14:11:23.175Z | 2024-11-21T14:26:10.231Z |
5536852 | 5536852 | 20241112192749_8ULyN | UK005J | 2024-11-14T14:10:37.441Z | 2024-11-21T14:26:06.509Z |
5536376 | 5536376 | 20241112174915_jadjZ | UK005J | 2024-11-14T14:09:45.886Z | 2024-11-21T14:26:00.386Z |
5536344 | 5536344 | 20241112173959_PrtEU | UK005J | 2024-11-14T14:09:40.519Z | 2024-11-21T14:26:00.204Z |
5531496 | 5531496 | 20241112034357_09MRQ | UK005J | 2024-11-13T14:15:42.928Z | 2024-11-20T14:26:11.838Z |
5531332 | 5531332 | 20241112033232_K48No | UK005J | 2024-11-13T14:15:34.680Z | 2024-11-20T14:26:10.378Z |
5530335 | 5530335 | 20241112020926_560aZ | UK005J | 2024-11-13T14:14:09.586Z | 2024-11-20T14:25:57.225Z |
5530223 | 5530223 | 20241112015802_Rt8xx | UK005J | 2024-11-13T14:14:02.553Z | 2024-11-20T14:25:55.534Z |
5529354 | 5529354 | 20241112000635_2rJdO | UK005J | 2024-11-13T14:12:26.250Z | 2024-11-20T14:25:43.271Z |
5528303 | 5528303 | 20241111201820_D4RUA | UK005J | 2024-11-13T14:10:25.642Z | 2024-11-20T14:25:28.090Z |
5524571 | 5524571 | 20241111043701_1Us3E | UK005J | 2024-11-12T14:17:41.861Z | 2024-11-19T14:22:22.449Z |
5524191 | 5524191 | 20241111032657_QSMep | UK005J | 2024-11-12T14:16:43.423Z | 2024-11-19T14:22:18.537Z |
5524082 | 5524082 | 20241111031130_JDZnf | UK005J | 2024-11-12T14:16:31.324Z | 2024-11-19T14:22:17.029Z |
5523793 | 5523793 | 20241111022407_w3HaN | UK005J | 2024-11-12T14:16:13.404Z | 2024-11-19T14:22:14.942Z |
5523739 | 5523739 | 20241111021532_frZ8u | UK005J | 2024-11-12T14:16:10.328Z | 2024-11-19T14:22:14.698Z |
5523409 | 5523409 | 20241111012008_nwYPG | UK005J | 2024-11-12T14:15:33.526Z | 2024-11-19T14:22:11.807Z |
5523352 | 5523352 | 20241111010831_TP43A | UK005J | 2024-11-12T14:15:23.534Z | 2024-11-19T14:22:11.400Z |
5523284 | 5523284 | 20241111005451_ItO02 | UK005J | 2024-11-12T14:15:14.431Z | 2024-11-19T14:22:11.066Z |
5523239 | 5523239 | 20241111004311_J39A1 | UK005J | 2024-11-12T14:15:05.591Z | 2024-11-19T14:22:10.675Z |
5523183 | 5523183 | 20241111002356_ZPFoB | UK005J | 2024-11-12T14:14:54.956Z | 2024-11-19T14:22:10.366Z |
5523174 | 5523174 | 20241111002239_BK214 | UK005J | 2024-11-12T14:14:53.382Z | 2024-11-19T14:22:10.303Z |
5523146 | 5523146 | 20241111001336_6I7pn | UK005J | 2024-11-12T14:14:49.919Z | 2024-11-19T14:22:10.178Z |
5523100 | 5523100 | 20241111000154_OpHkA | UK005J | 2024-11-12T14:14:45.709Z | 2024-11-19T14:22:09.970Z |
5523069 | 5523069 | 20241110235536_P32Wp | UK005J | 2024-11-12T14:14:43.842Z | 2024-11-19T14:22:09.835Z |
5522990 | 5522990 | 20241110232702_wm9M1 | UK005J | 2024-11-12T14:14:36.569Z | 2024-11-19T14:22:09.395Z |
5522904 | 5522904 | 20241110225041_3DvM3 | UK005J | 2024-11-12T14:14:28.196Z | 2024-11-19T14:22:08.733Z |
5522901 | 5522901 | 20241110224923_aP3rC | UK005J | 2024-11-12T14:14:27.932Z | 2024-11-19T14:22:08.700Z |
5522899 | 5522899 | 20241110224737_xC6g4 | UK005J | 2024-11-12T14:14:27.764Z | 2024-11-19T14:22:08.697Z |
5522788 | 5522788 | 20241110213404_O2JgA | UK005J | 2024-11-12T14:14:18.463Z | 2024-11-19T14:22:06.336Z |
5522743 | 5522743 | 20241110211325_RKK5Z | UK005J | 2024-11-12T14:14:05.140Z | 2024-11-19T14:22:05.780Z |
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);