participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,919 rows where station_code = "UK005U" 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 |
---|---|---|---|---|---|
5570589 | 5570589 | 20241120202149_2a37A | UK005U | 2024-11-22T14:15:51.456Z | 2024-11-22T14:19:21.945Z |
5569749 | 5569749 | 20241120171759_FIsno | UK005U | 2024-11-22T14:14:04.392Z | 2024-11-22T14:19:21.798Z |
5564504 | 5564504 | 20241120030420_tcm7Q | UK005U | 2024-11-21T14:17:42.904Z | 2024-11-22T14:21:32.877Z |
5564459 | 5564459 | 20241120025859_I8qc0 | UK005U | 2024-11-21T14:17:39.284Z | 2024-11-22T14:21:32.246Z |
5563249 | 5563249 | 20241120011155_CZCtJ | UK005U | 2024-11-21T14:15:46.227Z | 2024-11-22T14:21:11.661Z |
5562966 | 5562966 | 20241120003504_vSAC9 | UK005U | 2024-11-21T14:15:30.307Z | 2024-11-22T14:21:07.039Z |
5562748 | 5562748 | 20241120000736_tfowD | UK005U | 2024-11-21T14:15:19.848Z | 2024-11-22T14:21:03.392Z |
5517085 | 5517085 | 20241110024555_nDtW7 | UK005U | 2024-11-11T14:13:52.343Z | 2024-11-18T14:26:34.679Z |
5454320 | 5454320 | 20241031040837_UX3DB | UK005U | 2024-11-02T12:23:00.606Z | 2024-11-08T14:23:22.196Z |
5454130 | 5454130 | 20241031034503_tpHBa | UK005U | 2024-11-02T12:22:51.601Z | 2024-11-08T14:23:20.655Z |
5453902 | 5453902 | 20241031031356_sLb72 | UK005U | 2024-11-02T12:22:44.739Z | 2024-11-08T14:23:19.656Z |
5453879 | 5453879 | 20241031031138_dvJx7 | UK005U | 2024-11-02T12:22:44.167Z | 2024-11-08T14:23:19.601Z |
5453616 | 5453616 | 20241031023126_i1KFG | UK005U | 2024-11-02T12:22:37.166Z | 2024-11-08T14:23:18.258Z |
5453530 | 5453530 | 20241031022001_hcJTu | UK005U | 2024-11-02T12:22:35.246Z | 2024-11-08T14:23:17.880Z |
5453304 | 5453304 | 20241031015935_5jjKd | UK005U | 2024-11-02T12:22:31.450Z | 2024-11-08T14:23:16.526Z |
5444499 | 5444499 | 20241031012628_qILci | UK005U | 2024-11-01T12:21:20.488Z | 2024-11-08T14:23:15.758Z |
5432448 | 5432448 | 20241029033626_Xd2Vh | UK005U | 2024-10-31T12:21:22.881Z | 2024-11-06T14:27:27.499Z |
5398647 | 5398647 | 20241026031459_Sb0av | UK005U | 2024-10-28T12:19:25.389Z | 2024-11-03T14:27:37.450Z |
5398592 | 5398592 | 20241026031039_vPqh5 | UK005U | 2024-10-28T12:19:23.570Z | 2024-11-03T14:27:36.886Z |
5398391 | 5398391 | 20241026025220_QSskz | UK005U | 2024-10-28T12:19:13.697Z | 2024-11-03T14:27:36.234Z |
5376548 | 5376548 | 20241024040000_2GESF | UK005U | 2024-10-26T12:22:05.037Z | 2024-11-01T12:27:01.595Z |
5376519 | 5376519 | 20241024035834_yAr4p | UK005U | 2024-10-26T12:22:04.476Z | 2024-11-01T12:27:01.585Z |
5376436 | 5376436 | 20241024035544_pGR5N | UK005U | 2024-10-26T12:22:02.504Z | 2024-11-01T12:27:01.557Z |
5376372 | 5376372 | 20241024035250_Ehu2q | UK005U | 2024-10-26T12:21:59.400Z | 2024-11-01T12:27:01.515Z |
5376146 | 5376146 | 20241024034337_VEFOB | UK005U | 2024-10-26T12:21:52.366Z | 2024-11-01T12:27:01.413Z |
5375966 | 5375966 | 20241024033645_tOvfo | UK005U | 2024-10-26T12:21:45.165Z | 2024-11-01T12:27:01.297Z |
5375477 | 5375477 | 20241024031447_eeUvl | UK005U | 2024-10-26T12:21:28.045Z | 2024-11-01T12:27:00.706Z |
5374792 | 5374792 | 20241024024403_ajlMR | UK005U | 2024-10-26T12:21:01.705Z | 2024-11-01T12:26:59.607Z |
5374116 | 5374116 | 20241024021106_DwKQA | UK005U | 2024-10-26T12:20:37.507Z | 2024-11-01T12:26:58.704Z |
5373786 | 5373786 | 20241024015354_yHnOi | UK005U | 2024-10-26T12:20:25.618Z | 2024-11-01T12:26:58.476Z |
5372894 | 5372894 | 20241024011305_MBPjR | UK005U | 2024-10-26T12:19:47.118Z | 2024-11-01T12:26:58.016Z |
5372848 | 5372848 | 20241024011155_eMD1T | UK005U | 2024-10-26T12:19:45.941Z | 2024-11-01T12:26:58.003Z |
5363166 | 5363166 | 20241023203241_AC6sz | UK005U | 2024-10-25T12:15:36.055Z | 2024-11-01T12:26:52.893Z |
5349161 | 5349161 | 20241022192955_7MJqp | UK005U | 2024-10-24T12:13:14.097Z | 2024-10-31T12:29:54.658Z |
5342471 | 5342471 | 20241022022814_f5Cyg | UK005U | 2024-10-23T12:16:56.856Z | 2024-10-30T12:26:48.536Z |
5342245 | 5342245 | 20241022021705_s6rUW | UK005U | 2024-10-23T12:16:43.278Z | 2024-10-30T12:26:48.196Z |
5342005 | 5342005 | 20241022020308_jSvYx | UK005U | 2024-10-23T12:16:28.031Z | 2024-10-30T12:26:47.786Z |
5341773 | 5341773 | 20241022015211_KEKCL | UK005U | 2024-10-23T12:16:12.524Z | 2024-10-30T12:26:47.453Z |
5341494 | 5341494 | 20241022013814_395cF | UK005U | 2024-10-23T12:15:55.245Z | 2024-10-30T12:26:47.121Z |
5341486 | 5341486 | 20241022013810_xGw8z | UK005U | 2024-10-23T12:15:55.179Z | 2024-10-30T12:26:47.108Z |
5341446 | 5341446 | 20241022013554_8YDqK | UK005U | 2024-10-23T12:15:50.607Z | 2024-10-30T12:26:47.032Z |
5302213 | 5302213 | 20241013004048_fHC9X | UK005U | 2024-10-14T12:16:00.556Z | 2024-10-21T12:24:04.957Z |
5302058 | 5302058 | 20241013002712_pbVo7 | UK005U | 2024-10-14T12:15:50.457Z | 2024-10-21T12:24:04.269Z |
5301926 | 5301926 | 20241013001756_GvtRu | UK005U | 2024-10-14T12:15:44.921Z | 2024-10-21T12:24:03.071Z |
5300935 | 5300935 | 20241012221146_9tW2E | UK005U | 2024-10-14T12:14:38.191Z | 2024-10-21T12:23:54.056Z |
5300775 | 5300775 | 20241012214013_3PlE9 | UK005U | 2024-10-14T12:14:26.562Z | 2024-10-21T12:23:52.448Z |
5285618 | 5285618 | 20241011040814_NKwwz | UK005U | 2024-10-12T12:18:17.128Z | 2024-10-19T12:28:04.000Z |
5284983 | 5284983 | 20241011032431_9KH2L | UK005U | 2024-10-12T12:17:47.982Z | 2024-10-19T12:27:59.408Z |
5276611 | 5276611 | 20241011045152_giI53 | UK005U | 2024-10-12T12:01:24.753Z | 2024-10-20T12:23:11.970Z |
5255570 | 5255570 | 20241008044451_pkChh | UK005U | 2024-10-09T12:01:23.772Z | 2024-10-17T12:19:52.869Z |
5255469 | 5255469 | 20241008042720_oE8mv | UK005U | 2024-10-09T12:01:14.922Z | 2024-10-17T12:19:52.355Z |
5255458 | 5255458 | 20241008042636_8eJmR | UK005U | 2024-10-09T12:01:14.247Z | 2024-10-17T12:19:52.344Z |
5255441 | 5255441 | 20241008042548_mRKc0 | UK005U | 2024-10-09T12:01:13.038Z | 2024-10-17T12:19:52.301Z |
5255435 | 5255435 | 20241008042522_Ko2i2 | UK005U | 2024-10-09T12:01:12.639Z | 2024-10-17T12:19:52.299Z |
5255283 | 5255283 | 20241008040441_soN8b | UK005U | 2024-10-09T12:00:55.167Z | 2024-10-17T12:19:51.569Z |
5255183 | 5255183 | 20241008035036_DRoE8 | UK005U | 2024-10-09T12:00:45.998Z | 2024-10-17T12:19:51.313Z |
5255167 | 5255167 | 20241008034727_HvswU | UK005U | 2024-10-09T12:00:44.621Z | 2024-10-17T12:19:51.273Z |
5255102 | 5255102 | 20241008033953_WYNYd | UK005U | 2024-10-09T12:00:36.117Z | 2024-10-17T12:19:51.015Z |
5255088 | 5255088 | 20241008033850_yPT1I | UK005U | 2024-10-09T12:00:34.245Z | 2024-10-17T12:19:51.002Z |
5254550 | 5254550 | 20241007022710_Vmwek | UK005U | 2024-10-08T12:14:31.408Z | 2024-10-15T12:29:16.135Z |
5254351 | 5254351 | 20241007020355_w8tUJ | UK005U | 2024-10-08T12:14:19.260Z | 2024-10-15T12:29:14.963Z |
5254197 | 5254197 | 20241007014655_fAF2v | UK005U | 2024-10-08T12:14:09.597Z | 2024-10-15T12:29:13.339Z |
5253448 | 5253448 | 20241006235711_bKl9R | UK005U | 2024-10-08T12:13:15.653Z | 2024-10-15T12:29:09.403Z |
5253427 | 5253427 | 20241006235357_m8MXD | UK005U | 2024-10-08T12:13:14.856Z | 2024-10-15T12:29:09.214Z |
5248013 | 5248013 | 20241007034353_xYl5k | UK005U | 2024-10-08T12:01:15.059Z | 2024-10-16T12:20:57.910Z |
5247920 | 5247920 | 20241007032904_rYDcO | UK005U | 2024-10-08T12:01:01.482Z | 2024-10-16T12:20:57.244Z |
5234904 | 5234904 | 20241004222701_d4yem | UK005U | 2024-10-06T12:15:37.664Z | 2024-10-13T12:26:22.999Z |
5234416 | 5234416 | 20241004213329_JHTWO | UK005U | 2024-10-06T12:14:53.804Z | 2024-10-13T12:26:22.492Z |
5226347 | 5226347 | 20241004000652_lALSB | UK005U | 2024-10-05T12:20:38.123Z | 2024-10-12T12:25:11.615Z |
5224769 | 5224769 | 20241003212034_TlOMA | UK005U | 2024-10-05T12:19:02.770Z | 2024-10-12T12:25:08.896Z |
5223970 | 5223970 | 20241003195257_8LfeH | UK005U | 2024-10-05T12:18:04.579Z | 2024-10-12T12:25:07.153Z |
5220000 | 5220000 | 20241003043520_TTero | UK005U | 2024-10-05T12:10:03.606Z | 2024-10-12T12:24:56.577Z |
5218438 | 5218438 | 20241004034033_gptxx | UK005U | 2024-10-05T12:04:22.955Z | 2024-10-13T12:26:08.584Z |
5218428 | 5218428 | 20241004034001_BFMr4 | UK005U | 2024-10-05T12:04:21.579Z | 2024-10-13T12:26:08.465Z |
5218284 | 5218284 | 20241004032632_2Hig2 | UK005U | 2024-10-05T12:04:00.816Z | 2024-10-13T12:26:08.340Z |
5217753 | 5217753 | 20241004025302_tnRxS | UK005U | 2024-10-05T12:02:30.218Z | 2024-10-13T12:26:07.425Z |
5214762 | 5214762 | 20241002221452_qg4UT | UK005U | 2024-10-04T12:10:44.096Z | 2024-10-11T12:23:34.063Z |
5192640 | 5192640 | 20240928225602_sIjtp | UK005U | 2024-09-30T12:18:49.395Z | 2024-10-06T12:28:26.024Z |
5192205 | 5192205 | 20240928220613_WaR2n | UK005U | 2024-09-30T12:18:30.987Z | 2024-10-06T12:28:25.220Z |
5185698 | 5185698 | 20240929024514_46r3d | UK005U | 2024-09-30T12:04:54.882Z | 2024-10-07T12:21:18.649Z |
5185669 | 5185669 | 20240929024251_plf4e | UK005U | 2024-09-30T12:04:52.249Z | 2024-10-07T12:21:18.633Z |
5185036 | 5185036 | 20240929015148_J9hm2 | UK005U | 2024-09-30T12:03:14.213Z | 2024-10-07T12:21:16.977Z |
5184799 | 5184799 | 20240929013100_6DeLy | UK005U | 2024-09-30T12:02:31.148Z | 2024-10-07T12:21:16.524Z |
5182235 | 5182235 | 20240927222011_1lfBi | UK005U | 2024-09-29T12:15:49.197Z | 2024-10-05T12:29:08.041Z |
5182102 | 5182102 | 20240927220509_IeFZq | UK005U | 2024-09-29T12:15:44.177Z | 2024-10-05T12:29:07.823Z |
5179896 | 5179896 | 20240928045853_RNdZz | UK005U | 2024-09-29T12:08:39.630Z | 2024-10-06T12:28:05.843Z |
5179681 | 5179681 | 20240928043453_O43A8 | UK005U | 2024-09-29T12:08:19.782Z | 2024-10-06T12:28:05.034Z |
5179111 | 5179111 | 20240928034249_KdHNa | UK005U | 2024-09-29T12:07:26.824Z | 2024-10-06T12:28:02.362Z |
5178597 | 5178597 | 20240928030746_x1fxV | UK005U | 2024-09-29T12:06:36.708Z | 2024-10-06T12:28:00.312Z |
5177982 | 5177982 | 20240928022536_HFeLs | UK005U | 2024-09-29T12:05:33.427Z | 2024-10-06T12:27:57.709Z |
5177662 | 5177662 | 20240928015826_Dc9ls | UK005U | 2024-09-29T12:04:49.087Z | 2024-10-06T12:27:55.814Z |
5177464 | 5177464 | 20240928014313_ZRAxs | UK005U | 2024-09-29T12:04:20.791Z | 2024-10-06T12:27:55.105Z |
5176583 | 5176583 | 20240928004411_ie8DA | UK005U | 2024-09-29T12:02:37.437Z | 2024-10-06T12:27:51.725Z |
5135294 | 5135294 | 20240915020041_7PesS | UK005U | 2024-09-19T12:19:00.228Z | 2024-09-23T12:16:14.402Z |
5133998 | 5133998 | 20240916042843_lX3HC | UK005U | 2024-09-19T12:17:15.621Z | 2024-09-24T12:15:53.246Z |
5129524 | 5129524 | 20240917040642_BTzLE | UK005U | 2024-09-19T12:11:46.966Z | 2024-09-25T12:22:31.402Z |
5121764 | 5121764 | 20240914041341_L2d8X | UK005U | 2024-09-18T12:11:01.176Z | 2024-09-22T12:18:02.859Z |
5121326 | 5121326 | 20240914035815_Xm2fk | UK005U | 2024-09-18T12:10:54.567Z | 2024-09-22T12:18:00.400Z |
5121173 | 5121173 | 20240914035440_zfJJC | UK005U | 2024-09-18T12:10:52.106Z | 2024-09-22T12:17:59.832Z |
5121149 | 5121149 | 20240914035416_WO0B7 | UK005U | 2024-09-18T12:10:52.062Z | 2024-09-22T12:17:59.815Z |
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);