participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,472 rows where station_code = "UK00B6" 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 |
---|---|---|---|---|---|
5134075 | 5134075 | 20240916044312_oY2oy | UK00B6 | 2024-09-19T12:17:18.140Z | 2024-09-19T12:17:18.140Z |
5134065 | 5134065 | 20240916043818_grZ1z | UK00B6 | 2024-09-19T12:17:17.543Z | 2024-09-19T12:17:17.543Z |
5134031 | 5134031 | 20240916043241_NJB1J | UK00B6 | 2024-09-19T12:17:16.536Z | 2024-09-19T12:17:16.536Z |
5133920 | 5133920 | 20240916041805_DQZme | UK00B6 | 2024-09-19T12:17:13.076Z | 2024-09-19T12:17:13.076Z |
5133849 | 5133849 | 20240916040939_Jnajp | UK00B6 | 2024-09-19T12:17:10.291Z | 2024-09-19T12:17:10.291Z |
5133297 | 5133297 | 20240916031942_Vmm3f | UK00B6 | 2024-09-19T12:16:53.313Z | 2024-09-19T12:16:53.313Z |
5133144 | 5133144 | 20240916030148_31ILJ | UK00B6 | 2024-09-19T12:16:45.577Z | 2024-09-19T12:16:45.577Z |
5122156 | 5122156 | 20240914043912_O2Sf6 | UK00B6 | 2024-09-18T12:11:07.669Z | 2024-09-19T12:20:02.876Z |
5121789 | 5121789 | 20240914041403_ASe5X | UK00B6 | 2024-09-18T12:11:01.307Z | 2024-09-19T12:20:02.367Z |
5121689 | 5121689 | 20240914041207_LDHts | UK00B6 | 2024-09-18T12:10:59.349Z | 2024-09-19T12:20:02.212Z |
5120978 | 5120978 | 20240914034301_pu1Yj | UK00B6 | 2024-09-18T12:10:48.931Z | 2024-09-19T12:20:01.080Z |
5120398 | 5120398 | 20240914031909_PWt2f | UK00B6 | 2024-09-18T12:10:39.140Z | 2024-09-19T12:20:00.089Z |
5108182 | 5108182 | 20240913042923_2WrGD | UK00B6 | 2024-09-17T12:13:31.956Z | 2024-09-19T12:20:47.896Z |
5108030 | 5108030 | 20240913042031_D9G3s | UK00B6 | 2024-09-17T12:13:28.326Z | 2024-09-19T12:20:47.751Z |
5107931 | 5107931 | 20240913041500_M9G1b | UK00B6 | 2024-09-17T12:13:25.945Z | 2024-09-19T12:20:47.637Z |
5107904 | 5107904 | 20240913041400_b8zTH | UK00B6 | 2024-09-17T12:13:25.508Z | 2024-09-19T12:20:47.630Z |
5107653 | 5107653 | 20240913040744_ph42q | UK00B6 | 2024-09-17T12:13:20.694Z | 2024-09-19T12:20:47.439Z |
5107491 | 5107491 | 20240913035754_qRrr2 | UK00B6 | 2024-09-17T12:13:16.116Z | 2024-09-19T12:20:47.186Z |
5107360 | 5107360 | 20240913035317_228ze | UK00B6 | 2024-09-17T12:13:13.643Z | 2024-09-19T12:20:47.011Z |
5106909 | 5106909 | 20240913033804_6bAi1 | UK00B6 | 2024-09-17T12:13:03.762Z | 2024-09-19T12:20:46.511Z |
5106564 | 5106564 | 20240913032846_X30ef | UK00B6 | 2024-09-17T12:12:57.187Z | 2024-09-19T12:20:46.174Z |
5105501 | 5105501 | 20240913024902_25FhM | UK00B6 | 2024-09-17T12:12:19.274Z | 2024-09-19T12:20:44.603Z |
5105040 | 5105040 | 20240913022811_3jGUA | UK00B6 | 2024-09-17T12:11:50.580Z | 2024-09-19T12:20:43.425Z |
5104931 | 5104931 | 20240913022403_dPyMy | UK00B6 | 2024-09-17T12:11:46.679Z | 2024-09-19T12:20:43.117Z |
5104741 | 5104741 | 20240913021954_cot1K | UK00B6 | 2024-09-17T12:11:43.630Z | 2024-09-19T12:20:42.836Z |
5104674 | 5104674 | 20240913021814_1HhV8 | UK00B6 | 2024-09-17T12:11:41.919Z | 2024-09-19T12:20:42.660Z |
5104631 | 5104631 | 20240913021743_J37Pr | UK00B6 | 2024-09-17T12:11:41.383Z | 2024-09-19T12:20:42.648Z |
5104458 | 5104458 | 20240913021014_RwRim | UK00B6 | 2024-09-17T12:11:35.523Z | 2024-09-19T12:20:41.482Z |
5104378 | 5104378 | 20240913020628_pM37y | UK00B6 | 2024-09-17T12:11:33.947Z | 2024-09-19T12:20:41.426Z |
5103710 | 5103710 | 20240913013553_ejHYY | UK00B6 | 2024-09-17T12:11:07.998Z | 2024-09-19T12:20:40.423Z |
5103458 | 5103458 | 20240913013054_BCgK8 | UK00B6 | 2024-09-17T12:10:57.980Z | 2024-09-19T12:20:40.183Z |
5100345 | 5100345 | 20240913232300_arrHI | UK00B6 | 2024-09-17T12:04:29.179Z | 2024-09-19T12:19:47.816Z |
5098304 | 5098304 | 20240913012412_Zi2Wf | UK00B6 | 2024-09-16T12:17:22.217Z | 2024-09-19T12:20:39.998Z |
5098239 | 5098239 | 20240913012243_5cvdD | UK00B6 | 2024-09-16T12:17:21.772Z | 2024-09-19T12:20:39.908Z |
5098017 | 5098017 | 20240913011253_KaTRW | UK00B6 | 2024-09-16T12:17:18.115Z | 2024-09-19T12:20:39.480Z |
5097672 | 5097672 | 20240913005751_S5ImR | UK00B6 | 2024-09-16T12:17:13.917Z | 2024-09-19T12:20:38.878Z |
5097263 | 5097263 | 20240913003830_3xJ2D | UK00B6 | 2024-09-16T12:17:09.371Z | 2024-09-19T12:20:38.022Z |
5094657 | 5094657 | 20240912041421_mhOs2 | UK00B6 | 2024-09-16T12:14:53.123Z | 2024-09-19T12:21:16.340Z |
5094585 | 5094585 | 20240912041145_oiFYn | UK00B6 | 2024-09-16T12:14:51.852Z | 2024-09-19T12:21:16.261Z |
5093511 | 5093511 | 20240912032428_dsMTa | UK00B6 | 2024-09-16T12:14:19.074Z | 2024-09-19T12:21:15.387Z |
5093088 | 5093088 | 20240912031040_pKDvH | UK00B6 | 2024-09-16T12:14:11.296Z | 2024-09-19T12:21:14.928Z |
5092339 | 5092339 | 20240912024216_fcrEt | UK00B6 | 2024-09-16T12:13:48.122Z | 2024-09-19T12:21:13.834Z |
5092039 | 5092039 | 20240912023519_8Kpq9 | UK00B6 | 2024-09-16T12:13:38.403Z | 2024-09-19T12:21:13.603Z |
5089369 | 5089369 | 20240912003809_jofbv | UK00B6 | 2024-09-16T12:11:21.853Z | 2024-09-19T12:21:09.904Z |
5088705 | 5088705 | 20240913002128_494pi | UK00B6 | 2024-09-16T12:08:20.948Z | 2024-09-19T12:20:37.182Z |
5088654 | 5088654 | 20240913002024_Uqddr | UK00B6 | 2024-09-16T12:08:18.053Z | 2024-09-19T12:20:37.097Z |
5088496 | 5088496 | 20240913001319_oXjVZ | UK00B6 | 2024-09-16T12:08:05.627Z | 2024-09-19T12:20:36.959Z |
5088199 | 5088199 | 20240913000137_JRvC6 | UK00B6 | 2024-09-16T12:07:47.876Z | 2024-09-19T12:20:36.490Z |
5088121 | 5088121 | 20240912235824_7tWqw | UK00B6 | 2024-09-16T12:07:44.689Z | 2024-09-19T12:20:36.429Z |
5087869 | 5087869 | 20240912234652_8dID4 | UK00B6 | 2024-09-16T12:07:34.605Z | 2024-09-19T12:20:35.844Z |
5087813 | 5087813 | 20240912234445_WPLRd | UK00B6 | 2024-09-16T12:07:28.301Z | 2024-09-19T12:20:35.680Z |
5087520 | 5087520 | 20240912232938_365zx | UK00B6 | 2024-09-16T12:07:00.532Z | 2024-09-19T12:20:35.213Z |
5086912 | 5086912 | 20240912225407_1YBeJ | UK00B6 | 2024-09-16T12:06:11.911Z | 2024-09-19T12:20:33.055Z |
5086780 | 5086780 | 20240912224835_msEM6 | UK00B6 | 2024-09-16T12:06:02.883Z | 2024-09-19T12:20:31.692Z |
5086564 | 5086564 | 20240912224112_AsFAS | UK00B6 | 2024-09-16T12:05:52.339Z | 2024-09-19T12:20:31.418Z |
5086075 | 5086075 | 20240912220647_xO3Mw | UK00B6 | 2024-09-16T12:05:11.943Z | 2024-09-19T12:20:30.096Z |
5085804 | 5085804 | 20240912215137_JP7UV | UK00B6 | 2024-09-16T12:04:55.958Z | 2024-09-19T12:20:29.623Z |
5085742 | 5085742 | 20240912214723_q7Lw2 | UK00B6 | 2024-09-16T12:04:50.449Z | 2024-09-19T12:20:29.567Z |
5085469 | 5085469 | 20240912212111_LR80Y | UK00B6 | 2024-09-16T12:04:16.899Z | 2024-09-19T12:20:28.704Z |
5085262 | 5085262 | 20240912210504_tz8dz | UK00B6 | 2024-09-16T12:03:48.334Z | 2024-09-19T12:20:28.301Z |
5085026 | 5085026 | 20240912204039_9P7Ps | UK00B6 | 2024-09-16T12:03:26.250Z | 2024-09-19T12:20:27.761Z |
5084739 | 5084739 | 20240912200957_8PGDM | UK00B6 | 2024-09-16T12:02:51.376Z | 2024-09-19T12:20:27.055Z |
5080543 | 5080543 | 20240911040954_TU50v | UK00B6 | 2024-09-15T12:17:06.588Z | 2024-09-19T12:21:43.334Z |
5080450 | 5080450 | 20240911035655_GDpAs | UK00B6 | 2024-09-15T12:17:03.356Z | 2024-09-19T12:21:43.285Z |
5080419 | 5080419 | 20240911035644_xS8RK | UK00B6 | 2024-09-15T12:17:02.801Z | 2024-09-19T12:21:43.254Z |
5080380 | 5080380 | 20240911035146_Mx6pv | UK00B6 | 2024-09-15T12:16:59.970Z | 2024-09-19T12:21:43.194Z |
5080060 | 5080060 | 20240911033042_dD6c7 | UK00B6 | 2024-09-15T12:16:49.279Z | 2024-09-19T12:21:43.070Z |
5080000 | 5080000 | 20240911032440_Yc2oJ | UK00B6 | 2024-09-15T12:16:44.509Z | 2024-09-19T12:21:42.976Z |
5079755 | 5079755 | 20240911030915_OaCsy | UK00B6 | 2024-09-15T12:16:34.485Z | 2024-09-19T12:21:42.585Z |
5079648 | 5079648 | 20240911030659_TzHRU | UK00B6 | 2024-09-15T12:16:32.231Z | 2024-09-19T12:21:42.539Z |
5079070 | 5079070 | 20240911023116_rdfK5 | UK00B6 | 2024-09-15T12:16:03.542Z | 2024-09-19T12:21:41.053Z |
5078944 | 5078944 | 20240911022226_kdGIf | UK00B6 | 2024-09-15T12:15:58.117Z | 2024-09-19T12:21:40.855Z |
5078740 | 5078740 | 20240911021310_K3EJ9 | UK00B6 | 2024-09-15T12:15:50.585Z | 2024-09-19T12:21:40.684Z |
5078387 | 5078387 | 20240911015343_Md2B8 | UK00B6 | 2024-09-15T12:15:37.342Z | 2024-09-19T12:21:40.331Z |
5078367 | 5078367 | 20240911015129_xK6Sc | UK00B6 | 2024-09-15T12:15:36.274Z | 2024-09-19T12:21:40.314Z |
5078173 | 5078173 | 20240911014137_9qWyW | UK00B6 | 2024-09-15T12:15:22.303Z | 2024-09-19T12:21:40.039Z |
5078055 | 5078055 | 20240911013707_Kl8Gf | UK00B6 | 2024-09-15T12:15:17.747Z | 2024-09-19T12:21:39.926Z |
5078015 | 5078015 | 20240911013453_GXOeV | UK00B6 | 2024-09-15T12:15:16.695Z | 2024-09-19T12:21:39.900Z |
5077879 | 5077879 | 20240911012608_1Svrk | UK00B6 | 2024-09-15T12:15:09.385Z | 2024-09-19T12:21:39.757Z |
5077659 | 5077659 | 20240911010841_mZen5 | UK00B6 | 2024-09-15T12:14:56.617Z | 2024-09-19T12:21:39.468Z |
5077597 | 5077597 | 20240911010457_vjWy9 | UK00B6 | 2024-09-15T12:14:53.415Z | 2024-09-19T12:21:39.393Z |
5076827 | 5076827 | 20240911000952_cJB9n | UK00B6 | 2024-09-15T12:14:05.059Z | 2024-09-19T12:21:37.612Z |
5076288 | 5076288 | 20240910231924_tM102 | UK00B6 | 2024-09-15T12:13:26.525Z | 2024-09-19T12:21:36.693Z |
5075868 | 5075868 | 20240912001008_0xdDz | UK00B6 | 2024-09-15T12:10:18.101Z | 2024-09-19T12:21:09.604Z |
5075098 | 5075098 | 20240911232830_Exz9a | UK00B6 | 2024-09-15T12:09:23.865Z | 2024-09-19T12:21:08.264Z |
5074450 | 5074450 | 20240911223929_SzJX1 | UK00B6 | 2024-09-15T12:08:33.051Z | 2024-09-19T12:21:07.318Z |
5074204 | 5074204 | 20240911222228_LIrlt | UK00B6 | 2024-09-15T12:08:07.488Z | 2024-09-19T12:21:06.975Z |
5070141 | 5070141 | 20240910223504_N8O0m | UK00B6 | 2024-09-14T12:20:15.234Z | 2024-09-19T12:21:35.789Z |
5069245 | 5069245 | 20240910212210_LGXr3 | UK00B6 | 2024-09-14T12:19:49.482Z | 2024-09-19T12:21:33.996Z |
5060461 | 5060461 | 20240910203101_iXB7O | UK00B6 | 2024-09-14T12:08:49.605Z | 2024-09-19T12:21:32.389Z |
5060360 | 5060360 | 20240910202256_8Uym3 | UK00B6 | 2024-09-14T12:08:40.880Z | 2024-09-19T12:21:32.197Z |
5019768 | 5019768 | 20240904234654_NhZup | UK00B6 | 2024-09-10T12:13:25.269Z | 2024-09-13T12:19:53.718Z |
5019251 | 5019251 | 20240904221714_SJ5xu | UK00B6 | 2024-09-10T12:12:29.233Z | 2024-09-13T12:19:51.135Z |
5009908 | 5009908 | 20240904021417_i0mP1 | UK00B6 | 2024-09-09T12:08:13.099Z | 2024-09-12T12:19:24.926Z |
5009859 | 5009859 | 20240904020820_DZdkK | UK00B6 | 2024-09-09T12:08:10.463Z | 2024-09-12T12:19:24.700Z |
5009687 | 5009687 | 20240904014925_lbrMO | UK00B6 | 2024-09-09T12:07:55.323Z | 2024-09-12T12:19:23.993Z |
5009507 | 5009507 | 20240904013022_lO3dL | UK00B6 | 2024-09-09T12:07:47.146Z | 2024-09-12T12:19:23.166Z |
5009427 | 5009427 | 20240904012309_b65kr | UK00B6 | 2024-09-09T12:07:43.989Z | 2024-09-12T12:19:22.781Z |
5008841 | 5008841 | 20240904002908_PHBSV | UK00B6 | 2024-09-09T12:07:07.881Z | 2024-09-12T12:19:20.247Z |
5008660 | 5008660 | 20240904000644_7Nv7W | UK00B6 | 2024-09-09T12:06:57.198Z | 2024-09-12T12:19:18.568Z |
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);