participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,215 rows where station_code = "UK007Y" 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 |
---|---|---|---|---|---|
5133660 | 5133660 | 20240916035000_ySRCK | UK007Y | 2024-09-19T12:17:04.958Z | 2024-09-19T12:17:04.958Z |
5133615 | 5133615 | 20240916034744_63kze | UK007Y | 2024-09-19T12:17:03.806Z | 2024-09-19T12:17:03.806Z |
5133586 | 5133586 | 20240916034306_cj0dS | UK007Y | 2024-09-19T12:17:02.269Z | 2024-09-19T12:17:02.269Z |
5133575 | 5133575 | 20240916034148_UGbIi | UK007Y | 2024-09-19T12:17:02.136Z | 2024-09-19T12:17:02.136Z |
5133391 | 5133391 | 20240916032749_bSoYG | UK007Y | 2024-09-19T12:16:55.901Z | 2024-09-19T12:16:55.901Z |
5132819 | 5132819 | 20240916021828_SSv83 | UK007Y | 2024-09-19T12:16:33.509Z | 2024-09-19T12:16:33.509Z |
5132784 | 5132784 | 20240916021209_Der22 | UK007Y | 2024-09-19T12:16:32.725Z | 2024-09-19T12:16:32.725Z |
5132744 | 5132744 | 20240916020416_4EYn6 | UK007Y | 2024-09-19T12:16:30.619Z | 2024-09-19T12:16:30.619Z |
5132737 | 5132737 | 20240916020339_UArj4 | UK007Y | 2024-09-19T12:16:30.117Z | 2024-09-19T12:16:30.117Z |
5132612 | 5132612 | 20240916014543_L2WVL | UK007Y | 2024-09-19T12:16:22.912Z | 2024-09-19T12:16:22.912Z |
5132499 | 5132499 | 20240916011841_r8Re2 | UK007Y | 2024-09-19T12:16:15.477Z | 2024-09-19T12:16:15.477Z |
5128100 | 5128100 | 20240917003755_cwKC2 | UK007Y | 2024-09-19T12:10:03.701Z | 2024-09-19T12:10:03.701Z |
5128013 | 5128013 | 20240917002016_VD3L1 | UK007Y | 2024-09-19T12:09:54.376Z | 2024-09-19T12:09:54.376Z |
5127697 | 5127697 | 20240916230246_0v2S7 | UK007Y | 2024-09-19T12:09:32.109Z | 2024-09-19T12:09:32.109Z |
5127205 | 5127205 | 20240916205455_3OK9Z | UK007Y | 2024-09-19T12:08:32.234Z | 2024-09-19T12:08:32.234Z |
5127176 | 5127176 | 20240916204207_1tWVG | UK007Y | 2024-09-19T12:08:24.594Z | 2024-09-19T12:08:24.594Z |
5126829 | 5126829 | 20240916194024_Ud8Qt | UK007Y | 2024-09-19T12:07:24.388Z | 2024-09-19T12:07:24.388Z |
5121854 | 5121854 | 20240914041646_ko7IR | UK007Y | 2024-09-18T12:11:02.272Z | 2024-09-19T12:20:02.434Z |
5121746 | 5121746 | 20240914041331_usi4A | UK007Y | 2024-09-18T12:11:01.160Z | 2024-09-19T12:20:02.321Z |
5121594 | 5121594 | 20240914041015_fnO1f | UK007Y | 2024-09-18T12:10:58.727Z | 2024-09-19T12:20:02.160Z |
5121528 | 5121528 | 20240914040751_ERo2K | UK007Y | 2024-09-18T12:10:57.976Z | 2024-09-19T12:20:02.083Z |
5120803 | 5120803 | 20240914033549_HftPa | UK007Y | 2024-09-18T12:10:47.080Z | 2024-09-19T12:20:00.901Z |
5120454 | 5120454 | 20240914032048_wX9f3 | UK007Y | 2024-09-18T12:10:40.365Z | 2024-09-19T12:20:00.330Z |
5120382 | 5120382 | 20240914031907_3J4lm | UK007Y | 2024-09-18T12:10:39.079Z | 2024-09-19T12:20:00.086Z |
5120313 | 5120313 | 20240914031430_0uk27 | UK007Y | 2024-09-18T12:10:36.959Z | 2024-09-19T12:19:59.864Z |
5119889 | 5119889 | 20240914025141_uCbHb | UK007Y | 2024-09-18T12:10:28.432Z | 2024-09-19T12:19:59.053Z |
5119764 | 5119764 | 20240914024814_YroJV | UK007Y | 2024-09-18T12:10:26.241Z | 2024-09-19T12:19:58.923Z |
5119725 | 5119725 | 20240914024553_vYShz | UK007Y | 2024-09-18T12:10:24.601Z | 2024-09-19T12:19:58.789Z |
5119667 | 5119667 | 20240914024356_3tGR8 | UK007Y | 2024-09-18T12:10:23.878Z | 2024-09-19T12:19:58.714Z |
5119322 | 5119322 | 20240914022402_Gu8fz | UK007Y | 2024-09-18T12:10:19.908Z | 2024-09-19T12:19:57.923Z |
5119279 | 5119279 | 20240914021950_QpAZ9 | UK007Y | 2024-09-18T12:10:19.265Z | 2024-09-19T12:19:57.561Z |
5119226 | 5119226 | 20240914021831_2SKUF | UK007Y | 2024-09-18T12:10:18.739Z | 2024-09-19T12:19:57.470Z |
5117292 | 5117292 | 20240915041633_GX8vC | UK007Y | 2024-09-18T12:07:37.210Z | 2024-09-19T12:19:14.148Z |
5117204 | 5117204 | 20240915041137_eouSH | UK007Y | 2024-09-18T12:07:35.596Z | 2024-09-19T12:19:13.893Z |
5116981 | 5116981 | 20240915035311_gFGMP | UK007Y | 2024-09-18T12:07:27.216Z | 2024-09-19T12:19:12.938Z |
5116897 | 5116897 | 20240915034751_DhpkO | UK007Y | 2024-09-18T12:07:24.848Z | 2024-09-19T12:19:12.609Z |
5116743 | 5116743 | 20240915033825_jSmQ6 | UK007Y | 2024-09-18T12:07:18.612Z | 2024-09-19T12:19:12.200Z |
5116682 | 5116682 | 20240915033621_9Y0Ky | UK007Y | 2024-09-18T12:07:16.591Z | 2024-09-19T12:19:12.038Z |
5116504 | 5116504 | 20240915033018_VgXWk | UK007Y | 2024-09-18T12:07:07.881Z | 2024-09-19T12:19:11.410Z |
5116469 | 5116469 | 20240915032805_EgFMs | UK007Y | 2024-09-18T12:07:04.780Z | 2024-09-19T12:19:11.235Z |
5116179 | 5116179 | 20240915031401_jyPst | UK007Y | 2024-09-18T12:06:46.545Z | 2024-09-19T12:19:09.407Z |
5116144 | 5116144 | 20240915031156_ahNCo | UK007Y | 2024-09-18T12:06:43.795Z | 2024-09-19T12:19:08.957Z |
5116071 | 5116071 | 20240915030714_e97Xy | UK007Y | 2024-09-18T12:06:36.742Z | 2024-09-19T12:19:08.385Z |
5115762 | 5115762 | 20240915025311_L3poC | UK007Y | 2024-09-18T12:06:23.284Z | 2024-09-19T12:19:07.095Z |
5115472 | 5115472 | 20240915024039_Rj2ao | UK007Y | 2024-09-18T12:06:15.738Z | 2024-09-19T12:19:04.988Z |
5115455 | 5115455 | 20240915023927_3ohzm | UK007Y | 2024-09-18T12:06:14.913Z | 2024-09-19T12:19:04.825Z |
5115372 | 5115372 | 20240915023515_zDfX8 | UK007Y | 2024-09-18T12:06:11.905Z | 2024-09-19T12:19:04.067Z |
5115292 | 5115292 | 20240915023113_oy2q4 | UK007Y | 2024-09-18T12:06:10.087Z | 2024-09-19T12:19:03.776Z |
5115254 | 5115254 | 20240915022930_IL8U8 | UK007Y | 2024-09-18T12:06:08.076Z | 2024-09-19T12:19:03.410Z |
5113861 | 5113861 | 20240915011552_lJSl9 | UK007Y | 2024-09-18T12:04:53.314Z | 2024-09-19T12:18:53.442Z |
5113147 | 5113147 | 20240915002512_AyMPf | UK007Y | 2024-09-18T12:03:58.449Z | 2024-09-19T12:18:47.424Z |
5112746 | 5112746 | 20240914234820_iCJNL | UK007Y | 2024-09-18T12:03:27.224Z | 2024-09-19T12:18:44.245Z |
5112552 | 5112552 | 20240914232901_rULlG | UK007Y | 2024-09-18T12:03:13.309Z | 2024-09-19T12:18:41.438Z |
5112461 | 5112461 | 20240914231847_2KZA0 | UK007Y | 2024-09-18T12:03:09.177Z | 2024-09-19T12:18:41.085Z |
5112127 | 5112127 | 20240914221852_k1eZr | UK007Y | 2024-09-18T12:02:48.957Z | 2024-09-19T12:18:38.519Z |
5111965 | 5111965 | 20240914214807_yraDw | UK007Y | 2024-09-18T12:02:33.643Z | 2024-09-19T12:18:35.830Z |
5111944 | 5111944 | 20240914214458_3UwC5 | UK007Y | 2024-09-18T12:02:31.637Z | 2024-09-19T12:18:35.444Z |
5111784 | 5111784 | 20240914211700_pLBEl | UK007Y | 2024-09-18T12:02:17.053Z | 2024-09-19T12:18:34.037Z |
5111664 | 5111664 | 20240914205845_MMRs8 | UK007Y | 2024-09-18T12:02:09.928Z | 2024-09-19T12:18:32.850Z |
5111524 | 5111524 | 20240914204431_DXgxw | UK007Y | 2024-09-18T12:02:00.785Z | 2024-09-19T12:18:31.026Z |
5111038 | 5111038 | 20240914194527_qURbs | UK007Y | 2024-09-18T12:01:22.579Z | 2024-09-19T12:18:25.566Z |
5110954 | 5110954 | 20240914193254_7WIau | UK007Y | 2024-09-18T12:01:14.171Z | 2024-09-19T12:18:24.938Z |
5107376 | 5107376 | 20240913035337_cxzYp | UK007Y | 2024-09-17T12:13:13.774Z | 2024-09-19T12:20:47.026Z |
5107296 | 5107296 | 20240913035206_SCEhV | UK007Y | 2024-09-17T12:13:12.728Z | 2024-09-19T12:20:46.989Z |
5107283 | 5107283 | 20240913035032_LE6Iw | UK007Y | 2024-09-17T12:13:12.469Z | 2024-09-19T12:20:46.980Z |
5106796 | 5106796 | 20240913033513_TN2om | UK007Y | 2024-09-17T12:13:01.804Z | 2024-09-19T12:20:46.435Z |
5106724 | 5106724 | 20240913033253_CvuB0 | UK007Y | 2024-09-17T12:12:59.907Z | 2024-09-19T12:20:46.301Z |
5106486 | 5106486 | 20240913032728_zwfDL | UK007Y | 2024-09-17T12:12:56.308Z | 2024-09-19T12:20:46.141Z |
5106441 | 5106441 | 20240913032447_eD33I | UK007Y | 2024-09-17T12:12:54.026Z | 2024-09-19T12:20:46.079Z |
5106355 | 5106355 | 20240913032043_2RkvF | UK007Y | 2024-09-17T12:12:50.864Z | 2024-09-19T12:20:45.980Z |
5106276 | 5106276 | 20240913031648_y9XF3 | UK007Y | 2024-09-17T12:12:47.768Z | 2024-09-19T12:20:45.738Z |
5106265 | 5106265 | 20240913031620_PYhHL | UK007Y | 2024-09-17T12:12:47.410Z | 2024-09-19T12:20:45.727Z |
5105882 | 5105882 | 20240913030151_Y6fEz | UK007Y | 2024-09-17T12:12:31.381Z | 2024-09-19T12:20:45.009Z |
5105858 | 5105858 | 20240913030048_iMMnC | UK007Y | 2024-09-17T12:12:30.829Z | 2024-09-19T12:20:44.988Z |
5105802 | 5105802 | 20240913025849_ag2Ct | UK007Y | 2024-09-17T12:12:29.270Z | 2024-09-19T12:20:44.929Z |
5104758 | 5104758 | 20240913022027_C2wow | UK007Y | 2024-09-17T12:11:43.989Z | 2024-09-19T12:20:42.843Z |
5103651 | 5103651 | 20240913013512_stZDM | UK007Y | 2024-09-17T12:11:07.216Z | 2024-09-19T12:20:40.398Z |
5103080 | 5103080 | 20240914020025_Rfh6Z | UK007Y | 2024-09-17T12:07:51.019Z | 2024-09-19T12:19:56.516Z |
5102830 | 5102830 | 20240914014741_8S2Id | UK007Y | 2024-09-17T12:07:39.049Z | 2024-09-19T12:19:55.844Z |
5101305 | 5101305 | 20240914001850_GoD3U | UK007Y | 2024-09-17T12:05:33.637Z | 2024-09-19T12:19:50.217Z |
5101225 | 5101225 | 20240914001437_p09kM | UK007Y | 2024-09-17T12:05:28.236Z | 2024-09-19T12:19:50.077Z |
5100647 | 5100647 | 20240913233926_jeEWy | UK007Y | 2024-09-17T12:04:47.328Z | 2024-09-19T12:19:48.362Z |
5100294 | 5100294 | 20240913231738_R5pOg | UK007Y | 2024-09-17T12:04:25.472Z | 2024-09-19T12:19:47.685Z |
5100248 | 5100248 | 20240913231020_mr1R3 | UK007Y | 2024-09-17T12:04:21.975Z | 2024-09-19T12:19:47.373Z |
5100148 | 5100148 | 20240913225730_MnPbI | UK007Y | 2024-09-17T12:04:03.256Z | 2024-09-19T12:19:47.031Z |
5099969 | 5099969 | 20240913222849_BAlR1 | UK007Y | 2024-09-17T12:03:46.857Z | 2024-09-19T12:19:46.615Z |
5099849 | 5099849 | 20240913221108_C5BkC | UK007Y | 2024-09-17T12:03:39.239Z | 2024-09-19T12:19:46.155Z |
5099793 | 5099793 | 20240913220121_ykBpG | UK007Y | 2024-09-17T12:03:35.036Z | 2024-09-19T12:19:45.922Z |
5099742 | 5099742 | 20240913215147_vEZCt | UK007Y | 2024-09-17T12:03:27.741Z | 2024-09-19T12:19:45.779Z |
5099391 | 5099391 | 20240913210737_gtxPN | UK007Y | 2024-09-17T12:02:52.049Z | 2024-09-19T12:19:44.734Z |
5099339 | 5099339 | 20240913210353_bsyOr | UK007Y | 2024-09-17T12:02:48.108Z | 2024-09-19T12:19:44.560Z |
5099225 | 5099225 | 20240913204123_EmM7A | UK007Y | 2024-09-17T12:02:31.606Z | 2024-09-19T12:19:44.114Z |
5099199 | 5099199 | 20240913203902_1PE96 | UK007Y | 2024-09-17T12:02:29.017Z | 2024-09-19T12:19:44.061Z |
5098815 | 5098815 | 20240913194109_qWX7g | UK007Y | 2024-09-17T12:01:41.028Z | 2024-09-19T12:19:41.317Z |
5097789 | 5097789 | 20240913010430_ktVxe | UK007Y | 2024-09-16T12:17:14.974Z | 2024-09-19T12:20:38.982Z |
5097385 | 5097385 | 20240913004450_TfRwr | UK007Y | 2024-09-16T12:17:11.899Z | 2024-09-19T12:20:38.465Z |
5097195 | 5097195 | 20240913003528_pZ3pP | UK007Y | 2024-09-16T12:17:07.463Z | 2024-09-19T12:20:37.842Z |
5097187 | 5097187 | 20240913003527_hiq3W | UK007Y | 2024-09-16T12:17:07.449Z | 2024-09-19T12:20:37.840Z |
5094597 | 5094597 | 20240912041227_HdOPp | UK007Y | 2024-09-16T12:14:52.461Z | 2024-09-19T12:21:16.321Z |
5094414 | 5094414 | 20240912040047_V3VTj | UK007Y | 2024-09-16T12:14:44.364Z | 2024-09-19T12:21:16.107Z |
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);