participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,966 rows where station_code = "UK006G" 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 |
---|---|---|---|---|---|
5133797 | 5133797 | 20240916040600_rfa4F | UK006G | 2024-09-19T12:17:08.259Z | 2024-09-19T12:17:08.259Z |
5133732 | 5133732 | 20240916040118_72rcZ | UK006G | 2024-09-19T12:17:06.725Z | 2024-09-19T12:17:06.725Z |
5133574 | 5133574 | 20240916034148_UGbIi | UK006G | 2024-09-19T12:17:02.136Z | 2024-09-19T12:17:02.136Z |
5133520 | 5133520 | 20240916033624_CKW3Z | UK006G | 2024-09-19T12:17:00.429Z | 2024-09-19T12:17:00.429Z |
5132869 | 5132869 | 20240916022411_GKFz3 | UK006G | 2024-09-19T12:16:35.065Z | 2024-09-19T12:16:35.065Z |
5132845 | 5132845 | 20240916022134_cUpiw | UK006G | 2024-09-19T12:16:34.404Z | 2024-09-19T12:16:34.404Z |
5132736 | 5132736 | 20240916020339_UArj4 | UK006G | 2024-09-19T12:16:30.117Z | 2024-09-19T12:16:30.117Z |
5132497 | 5132497 | 20240916011841_r8Re2 | UK006G | 2024-09-19T12:16:15.477Z | 2024-09-19T12:16:15.477Z |
5132356 | 5132356 | 20240916005037_rslEv | UK006G | 2024-09-19T12:16:09.290Z | 2024-09-19T12:16:09.290Z |
5132343 | 5132343 | 20240916004138_cpE2E | UK006G | 2024-09-19T12:16:08.250Z | 2024-09-19T12:16:08.250Z |
5132263 | 5132263 | 20240916001321_0n1p8 | UK006G | 2024-09-19T12:16:02.199Z | 2024-09-19T12:16:02.199Z |
5132116 | 5132116 | 20240915232657_yRbn8 | UK006G | 2024-09-19T12:15:51.044Z | 2024-09-19T12:15:51.044Z |
5131920 | 5131920 | 20240915221409_y63vZ | UK006G | 2024-09-19T12:15:34.076Z | 2024-09-19T12:15:34.076Z |
5131868 | 5131868 | 20240915215918_6YvZK | UK006G | 2024-09-19T12:15:32.083Z | 2024-09-19T12:15:32.083Z |
5129587 | 5129587 | 20240917041141_wj8r4 | UK006G | 2024-09-19T12:11:50.664Z | 2024-09-19T12:11:50.664Z |
5128803 | 5128803 | 20240917024150_rcFBd | UK006G | 2024-09-19T12:11:02.693Z | 2024-09-19T12:11:02.693Z |
5128386 | 5128386 | 20240917013344_8bUeG | UK006G | 2024-09-19T12:10:30.304Z | 2024-09-19T12:10:30.304Z |
5128049 | 5128049 | 20240917002958_DCV0a | UK006G | 2024-09-19T12:09:56.963Z | 2024-09-19T12:09:56.963Z |
5127719 | 5127719 | 20240916231020_Lo0L5 | UK006G | 2024-09-19T12:09:34.296Z | 2024-09-19T12:09:34.296Z |
5127672 | 5127672 | 20240916224918_wvvi2 | UK006G | 2024-09-19T12:09:31.225Z | 2024-09-19T12:09:31.225Z |
5121872 | 5121872 | 20240914041800_qCUmK | UK006G | 2024-09-18T12:11:02.516Z | 2024-09-19T12:20:02.474Z |
5120802 | 5120802 | 20240914033549_HftPa | UK006G | 2024-09-18T12:10:47.080Z | 2024-09-19T12:20:00.901Z |
5120727 | 5120727 | 20240914033304_2dWFf | UK006G | 2024-09-18T12:10:46.215Z | 2024-09-19T12:20:00.801Z |
5119888 | 5119888 | 20240914025141_uCbHb | UK006G | 2024-09-18T12:10:28.432Z | 2024-09-19T12:19:59.053Z |
5119692 | 5119692 | 20240914024409_grNiF | UK006G | 2024-09-18T12:10:24.068Z | 2024-09-19T12:19:58.737Z |
5119665 | 5119665 | 20240914024356_3tGR8 | UK006G | 2024-09-18T12:10:23.878Z | 2024-09-19T12:19:58.714Z |
5119245 | 5119245 | 20240914021832_IPZrP | UK006G | 2024-09-18T12:10:18.774Z | 2024-09-19T12:19:57.474Z |
5117290 | 5117290 | 20240915041633_GX8vC | UK006G | 2024-09-18T12:07:37.210Z | 2024-09-19T12:19:14.148Z |
5116895 | 5116895 | 20240915034751_DhpkO | UK006G | 2024-09-18T12:07:24.848Z | 2024-09-19T12:19:12.609Z |
5116661 | 5116661 | 20240915033422_KaH04 | UK006G | 2024-09-18T12:07:14.905Z | 2024-09-19T12:19:11.859Z |
5116059 | 5116059 | 20240915030621_o3P8e | UK006G | 2024-09-18T12:06:35.904Z | 2024-09-19T12:19:08.346Z |
5115906 | 5115906 | 20240915025912_eze3N | UK006G | 2024-09-18T12:06:31.499Z | 2024-09-19T12:19:07.807Z |
5115761 | 5115761 | 20240915025311_L3poC | UK006G | 2024-09-18T12:06:23.284Z | 2024-09-19T12:19:07.095Z |
5115453 | 5115453 | 20240915023927_3ohzm | UK006G | 2024-09-18T12:06:14.913Z | 2024-09-19T12:19:04.825Z |
5115252 | 5115252 | 20240915022930_IL8U8 | UK006G | 2024-09-18T12:06:08.076Z | 2024-09-19T12:19:03.410Z |
5114381 | 5114381 | 20240915014044_iD3CJ | UK006G | 2024-09-18T12:05:14.128Z | 2024-09-19T12:18:57.925Z |
5111782 | 5111782 | 20240914211700_pLBEl | UK006G | 2024-09-18T12:02:17.053Z | 2024-09-19T12:18:34.037Z |
5111578 | 5111578 | 20240914205051_F6LRZ | UK006G | 2024-09-18T12:02:04.393Z | 2024-09-19T12:18:31.498Z |
5110457 | 5110457 | 20240911013506_HtI3v | UK006G | 2024-09-17T12:17:58.797Z | 2024-09-19T12:21:39.902Z |
5107664 | 5107664 | 20240913040748_x4tvX | UK006G | 2024-09-17T12:13:20.791Z | 2024-09-19T12:20:47.446Z |
5106483 | 5106483 | 20240913032728_zwfDL | UK006G | 2024-09-17T12:12:56.308Z | 2024-09-19T12:20:46.141Z |
5106353 | 5106353 | 20240913032043_2RkvF | UK006G | 2024-09-17T12:12:50.864Z | 2024-09-19T12:20:45.980Z |
5106274 | 5106274 | 20240913031648_y9XF3 | UK006G | 2024-09-17T12:12:47.768Z | 2024-09-19T12:20:45.738Z |
5105918 | 5105918 | 20240913030259_2bMnC | UK006G | 2024-09-17T12:12:32.697Z | 2024-09-19T12:20:45.049Z |
5105800 | 5105800 | 20240913025849_ag2Ct | UK006G | 2024-09-17T12:12:29.270Z | 2024-09-19T12:20:44.929Z |
5105743 | 5105743 | 20240913025619_qM1bX | UK006G | 2024-09-17T12:12:28.313Z | 2024-09-19T12:20:44.866Z |
5105616 | 5105616 | 20240913025306_fY3iE | UK006G | 2024-09-17T12:12:23.558Z | 2024-09-19T12:20:44.726Z |
5105314 | 5105314 | 20240913024136_GZ2H1 | UK006G | 2024-09-17T12:12:09.274Z | 2024-09-19T12:20:44.284Z |
5105093 | 5105093 | 20240913023005_SZnmf | UK006G | 2024-09-17T12:11:54.465Z | 2024-09-19T12:20:43.504Z |
5104756 | 5104756 | 20240913022027_C2wow | UK006G | 2024-09-17T12:11:43.989Z | 2024-09-19T12:20:42.843Z |
5103810 | 5103810 | 20240913014047_z3EeP | UK006G | 2024-09-17T12:11:11.587Z | 2024-09-19T12:20:40.580Z |
5103520 | 5103520 | 20240913013155_6xY3b | UK006G | 2024-09-17T12:11:01.142Z | 2024-09-19T12:20:40.239Z |
5103407 | 5103407 | 20240913012946_dnm7z | UK006G | 2024-09-17T12:10:56.416Z | 2024-09-19T12:20:40.158Z |
5103297 | 5103297 | 20240913012428_vJUXK | UK006G | 2024-09-17T12:10:49.757Z | 2024-09-19T12:20:40.004Z |
5103144 | 5103144 | 20240914020250_Sndae | UK006G | 2024-09-17T12:07:53.955Z | 2024-09-19T12:19:56.688Z |
5103064 | 5103064 | 20240914020001_PczKj | UK006G | 2024-09-17T12:07:49.795Z | 2024-09-19T12:19:56.479Z |
5102984 | 5102984 | 20240914015558_UuU9v | UK006G | 2024-09-17T12:07:45.942Z | 2024-09-19T12:19:56.229Z |
5102828 | 5102828 | 20240914014741_8S2Id | UK006G | 2024-09-17T12:07:39.049Z | 2024-09-19T12:19:55.844Z |
5102580 | 5102580 | 20240914013208_a6I9u | UK006G | 2024-09-17T12:07:26.102Z | 2024-09-19T12:19:55.150Z |
5102420 | 5102420 | 20240914012525_cwUk0 | UK006G | 2024-09-17T12:07:08.580Z | 2024-09-19T12:19:54.101Z |
5100837 | 5100837 | 20240913234638_kQP3K | UK006G | 2024-09-17T12:04:59.054Z | 2024-09-19T12:19:48.800Z |
5100813 | 5100813 | 20240913234633_aIf8p | UK006G | 2024-09-17T12:04:57.585Z | 2024-09-19T12:19:48.789Z |
5100780 | 5100780 | 20240913234531_EU2Us | UK006G | 2024-09-17T12:04:55.330Z | 2024-09-19T12:19:48.729Z |
5100646 | 5100646 | 20240913233926_jeEWy | UK006G | 2024-09-17T12:04:47.328Z | 2024-09-19T12:19:48.362Z |
5100292 | 5100292 | 20240913231738_R5pOg | UK006G | 2024-09-17T12:04:25.472Z | 2024-09-19T12:19:47.685Z |
5099968 | 5099968 | 20240913222849_BAlR1 | UK006G | 2024-09-17T12:03:46.857Z | 2024-09-19T12:19:46.615Z |
5099840 | 5099840 | 20240913221107_YCkiG | UK006G | 2024-09-17T12:03:38.880Z | 2024-09-19T12:19:46.113Z |
5099741 | 5099741 | 20240913215147_vEZCt | UK006G | 2024-09-17T12:03:27.741Z | 2024-09-19T12:19:45.779Z |
5098888 | 5098888 | 20240913195302_iYM7q | UK006G | 2024-09-17T12:01:56.023Z | 2024-09-19T12:19:42.532Z |
5097800 | 5097800 | 20240913010444_xlrsA | UK006G | 2024-09-16T12:17:15.039Z | 2024-09-19T12:20:38.988Z |
5097559 | 5097559 | 20240913005406_o3Wqq | UK006G | 2024-09-16T12:17:13.382Z | 2024-09-19T12:20:38.719Z |
5094495 | 5094495 | 20240912040602_PFOOw | UK006G | 2024-09-16T12:14:48.680Z | 2024-09-19T12:21:16.183Z |
5094412 | 5094412 | 20240912040047_V3VTj | UK006G | 2024-09-16T12:14:44.364Z | 2024-09-19T12:21:16.107Z |
5094165 | 5094165 | 20240912035149_3Y5F1 | UK006G | 2024-09-16T12:14:37.430Z | 2024-09-19T12:21:15.905Z |
5092853 | 5092853 | 20240912030003_9J4oV | UK006G | 2024-09-16T12:14:05.558Z | 2024-09-19T12:21:14.616Z |
5092728 | 5092728 | 20240912025521_FWK32 | UK006G | 2024-09-16T12:14:02.785Z | 2024-09-19T12:21:14.441Z |
5091703 | 5091703 | 20240912021926_tEcwD | UK006G | 2024-09-16T12:13:19.501Z | 2024-09-19T12:21:13.356Z |
5091602 | 5091602 | 20240912021508_y6TK3 | UK006G | 2024-09-16T12:13:13.004Z | 2024-09-19T12:21:13.247Z |
5091377 | 5091377 | 20240912020714_jUwlz | UK006G | 2024-09-16T12:13:03.535Z | 2024-09-19T12:21:12.962Z |
5090543 | 5090543 | 20240912012909_p53oY | UK006G | 2024-09-16T12:12:22.805Z | 2024-09-19T12:21:11.369Z |
5090404 | 5090404 | 20240912012419_mPZCp | UK006G | 2024-09-16T12:12:18.870Z | 2024-09-19T12:21:11.293Z |
5090365 | 5090365 | 20240912012257_F3UOr | UK006G | 2024-09-16T12:12:16.244Z | 2024-09-19T12:21:11.249Z |
5089975 | 5089975 | 20240912010507_R27s6 | UK006G | 2024-09-16T12:11:53.024Z | 2024-09-19T12:21:10.873Z |
5089844 | 5089844 | 20240912005940_hQXW8 | UK006G | 2024-09-16T12:11:46.079Z | 2024-09-19T12:21:10.575Z |
5089512 | 5089512 | 20240912004736_JbN2x | UK006G | 2024-09-16T12:11:28.178Z | 2024-09-19T12:21:10.021Z |
5089107 | 5089107 | 20240912002626_qEzWN | UK006G | 2024-09-16T12:11:15.175Z | 2024-09-19T12:21:09.744Z |
5088720 | 5088720 | 20240913002210_EHj21 | UK006G | 2024-09-16T12:08:22.437Z | 2024-09-19T12:20:37.198Z |
5087996 | 5087996 | 20240912235300_5F02O | UK006G | 2024-09-16T12:07:40.233Z | 2024-09-19T12:20:36.036Z |
5087751 | 5087751 | 20240912234242_IeGMY | UK006G | 2024-09-16T12:07:23.928Z | 2024-09-19T12:20:35.635Z |
5087237 | 5087237 | 20240912231658_ufw5Q | UK006G | 2024-09-16T12:06:48.140Z | 2024-09-19T12:20:34.353Z |
5086601 | 5086601 | 20240912224327_ohPmx | UK006G | 2024-09-16T12:05:54.416Z | 2024-09-19T12:20:31.459Z |
5086291 | 5086291 | 20240912222528_j5yYN | UK006G | 2024-09-16T12:05:29.481Z | 2024-09-19T12:20:30.748Z |
5086255 | 5086255 | 20240912222234_aofZa | UK006G | 2024-09-16T12:05:25.881Z | 2024-09-19T12:20:30.705Z |
5086092 | 5086092 | 20240912220938_mtSD3 | UK006G | 2024-09-16T12:05:13.882Z | 2024-09-19T12:20:30.222Z |
5086047 | 5086047 | 20240912220603_XiyJ3 | UK006G | 2024-09-16T12:05:11.244Z | 2024-09-19T12:20:30.031Z |
5085611 | 5085611 | 20240912213506_BxA2T | UK006G | 2024-09-16T12:04:30.223Z | 2024-09-19T12:20:29.251Z |
5085149 | 5085149 | 20240912205232_dLLnT | UK006G | 2024-09-16T12:03:37.226Z | 2024-09-19T12:20:28.122Z |
5084753 | 5084753 | 20240912201000_tAAep | UK006G | 2024-09-16T12:02:52.426Z | 2024-09-19T12:20:27.098Z |
5084652 | 5084652 | 20240912200141_2QDuo | UK006G | 2024-09-16T12:02:43.934Z | 2024-09-19T12:20:26.744Z |
5080231 | 5080231 | 20240911034320_lbnWt | UK006G | 2024-09-15T12:16:54.476Z | 2024-09-19T12:21:43.135Z |
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);