participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,591 rows where station_code = "UK008T" 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 |
---|---|---|---|---|---|
5570404 | 5570404 | 20241120193252_DUphZ | UK008T | 2024-11-22T14:15:19.707Z | 2024-11-22T14:19:21.911Z |
5569970 | 5569970 | 20241120181410_o3L1o | UK008T | 2024-11-22T14:14:42.078Z | 2024-11-22T14:19:21.840Z |
5569752 | 5569752 | 20241120171759_FIsno | UK008T | 2024-11-22T14:14:04.393Z | 2024-11-22T14:19:21.798Z |
5569745 | 5569745 | 20241120171459_3QQkf | UK008T | 2024-11-22T14:14:03.674Z | 2024-11-22T14:19:21.796Z |
5565097 | 5565097 | 20241120035152_iGrP3 | UK008T | 2024-11-21T14:18:29.668Z | 2024-11-22T14:21:41.476Z |
5565017 | 5565017 | 20241120034448_KJWec | UK008T | 2024-11-21T14:18:20.827Z | 2024-11-22T14:21:40.322Z |
5564873 | 5564873 | 20241120033348_EpJqL | UK008T | 2024-11-21T14:18:10.923Z | 2024-11-22T14:21:37.581Z |
5564751 | 5564751 | 20241120032508_aBBi1 | UK008T | 2024-11-21T14:18:02.166Z | 2024-11-22T14:21:36.276Z |
5564135 | 5564135 | 20241120023233_3ElG1 | UK008T | 2024-11-21T14:17:12.848Z | 2024-11-22T14:21:27.372Z |
5563659 | 5563659 | 20241120015608_UE65W | UK008T | 2024-11-21T14:16:32.286Z | 2024-11-22T14:21:20.393Z |
5563577 | 5563577 | 20241120014645_XgmP5 | UK008T | 2024-11-21T14:16:24.400Z | 2024-11-22T14:21:19.019Z |
5563335 | 5563335 | 20241120011805_0BzDR | UK008T | 2024-11-21T14:15:55.287Z | 2024-11-22T14:21:13.166Z |
5563261 | 5563261 | 20241120011253_E45wm | UK008T | 2024-11-21T14:15:48.601Z | 2024-11-22T14:21:11.842Z |
5563091 | 5563091 | 20241120005133_qk8j5 | UK008T | 2024-11-21T14:15:36.437Z | 2024-11-22T14:21:09.553Z |
5562621 | 5562621 | 20241119235735_3zDhZ | UK008T | 2024-11-21T14:15:13.935Z | 2024-11-22T14:21:00.983Z |
5562565 | 5562565 | 20241119235220_Jm3GQ | UK008T | 2024-11-21T14:15:09.151Z | 2024-11-22T14:21:00.418Z |
5562407 | 5562407 | 20241119233416_QU1fd | UK008T | 2024-11-21T14:14:46.984Z | 2024-11-22T14:20:57.063Z |
5562316 | 5562316 | 20241119232153_a15jI | UK008T | 2024-11-21T14:14:41.809Z | 2024-11-22T14:20:55.856Z |
5562244 | 5562244 | 20241119231600_UtJs0 | UK008T | 2024-11-21T14:14:35.908Z | 2024-11-22T14:20:54.544Z |
5561836 | 5561836 | 20241119221540_tZ68X | UK008T | 2024-11-21T14:14:09.193Z | 2024-11-22T14:20:47.179Z |
5557969 | 5557969 | 20241120052707_wNHtb | UK008T | 2024-11-21T14:02:10.298Z | 2024-11-22T14:19:21.154Z |
5557948 | 5557948 | 20241120052450_WNgq4 | UK008T | 2024-11-21T14:02:07.259Z | 2024-11-22T14:19:21.150Z |
5557908 | 5557908 | 20241120052236_GwnrA | UK008T | 2024-11-21T14:02:02.847Z | 2024-11-22T14:19:21.145Z |
5557837 | 5557837 | 20241120051721_wS6c8 | UK008T | 2024-11-21T14:01:53.811Z | 2024-11-22T14:19:21.136Z |
5557776 | 5557776 | 20241120051113_uv1jT | UK008T | 2024-11-21T14:01:43.489Z | 2024-11-22T14:19:21.126Z |
5557754 | 5557754 | 20241120051025_UYeF4 | UK008T | 2024-11-21T14:01:39.730Z | 2024-11-22T14:19:21.122Z |
5532295 | 5532295 | 20241112050358_klfDw | UK008T | 2024-11-13T14:16:34.962Z | 2024-11-20T14:26:21.704Z |
5532226 | 5532226 | 20241112045305_LtPMK | UK008T | 2024-11-13T14:16:28.513Z | 2024-11-20T14:26:21.157Z |
5532127 | 5532127 | 20241112043915_pK3NG | UK008T | 2024-11-13T14:16:20.319Z | 2024-11-20T14:26:19.004Z |
5531987 | 5531987 | 20241112042519_3bfzU | UK008T | 2024-11-13T14:16:06.805Z | 2024-11-20T14:26:16.798Z |
5531246 | 5531246 | 20241112032517_MOtZC | UK008T | 2024-11-13T14:15:31.493Z | 2024-11-20T14:26:09.472Z |
5531104 | 5531104 | 20241112031407_43hig | UK008T | 2024-11-13T14:15:13.343Z | 2024-11-20T14:26:07.859Z |
5531054 | 5531054 | 20241112030941_DnhA8 | UK008T | 2024-11-13T14:15:06.746Z | 2024-11-20T14:26:06.802Z |
5530740 | 5530740 | 20241112024152_NikYY | UK008T | 2024-11-13T14:14:33.758Z | 2024-11-20T14:26:02.981Z |
5530695 | 5530695 | 20241112023817_KZO0v | UK008T | 2024-11-13T14:14:28.049Z | 2024-11-20T14:26:02.613Z |
5530692 | 5530692 | 20241112023807_9HB72 | UK008T | 2024-11-13T14:14:27.855Z | 2024-11-20T14:26:02.599Z |
5530682 | 5530682 | 20241112023745_kV3Kb | UK008T | 2024-11-13T14:14:27.576Z | 2024-11-20T14:26:02.577Z |
5530315 | 5530315 | 20241112020725_fPTJd | UK008T | 2024-11-13T14:14:08.326Z | 2024-11-20T14:25:56.883Z |
5530286 | 5530286 | 20241112020545_lXy0h | UK008T | 2024-11-13T14:14:06.998Z | 2024-11-20T14:25:56.572Z |
5530144 | 5530144 | 20241112014947_WKusm | UK008T | 2024-11-13T14:13:58.545Z | 2024-11-20T14:25:54.852Z |
5530128 | 5530128 | 20241112014926_uIWV9 | UK008T | 2024-11-13T14:13:58.093Z | 2024-11-20T14:25:54.797Z |
5530075 | 5530075 | 20241112013959_C7nco | UK008T | 2024-11-13T14:13:48.793Z | 2024-11-20T14:25:54.076Z |
5530030 | 5530030 | 20241112013748_0KGyc | UK008T | 2024-11-13T14:13:41.771Z | 2024-11-20T14:25:53.142Z |
5529686 | 5529686 | 20241112005416_foSVe | UK008T | 2024-11-13T14:13:05.961Z | 2024-11-20T14:25:47.384Z |
5529234 | 5529234 | 20241111235332_QYpx6 | UK008T | 2024-11-13T14:12:15.124Z | 2024-11-20T14:25:42.130Z |
5529132 | 5529132 | 20241111233329_sfakS | UK008T | 2024-11-13T14:12:07.735Z | 2024-11-20T14:25:40.448Z |
5529010 | 5529010 | 20241111231852_R2Wiv | UK008T | 2024-11-13T14:11:57.401Z | 2024-11-20T14:25:38.533Z |
5528974 | 5528974 | 20241111231428_hCFoY | UK008T | 2024-11-13T14:11:52.084Z | 2024-11-20T14:25:38.160Z |
5528925 | 5528925 | 20241111230750_pSgUc | UK008T | 2024-11-13T14:11:40.519Z | 2024-11-20T14:25:37.478Z |
5528850 | 5528850 | 20241111225411_zNPg2 | UK008T | 2024-11-13T14:11:30.497Z | 2024-11-20T14:25:36.706Z |
5528783 | 5528783 | 20241111223857_fX3ft | UK008T | 2024-11-13T14:11:26.139Z | 2024-11-20T14:25:35.668Z |
5528704 | 5528704 | 20241111222216_5ZdLE | UK008T | 2024-11-13T14:11:18.524Z | 2024-11-20T14:25:34.046Z |
5423003 | 5423003 | 20241027033823_BrBn3 | UK008T | 2024-10-30T12:22:58.721Z | 2024-11-04T14:29:00.325Z |
5418736 | 5418736 | 20241027214639_qqIbB | UK008T | 2024-10-30T12:16:02.591Z | 2024-11-05T14:27:11.016Z |
5418462 | 5418462 | 20241027205247_1WfDe | UK008T | 2024-10-30T12:15:42.754Z | 2024-11-05T14:27:10.083Z |
5418125 | 5418125 | 20241027195709_3UmAx | UK008T | 2024-10-30T12:14:57.697Z | 2024-11-05T14:27:09.199Z |
5417999 | 5417999 | 20241027193913_ZrTVJ | UK008T | 2024-10-30T12:14:43.804Z | 2024-11-05T14:27:08.834Z |
5410543 | 5410543 | 20241027051716_2ffzo | UK008T | 2024-10-29T12:17:57.831Z | 2024-11-04T14:29:04.803Z |
5410525 | 5410525 | 20241027051628_JiLam | UK008T | 2024-10-29T12:17:57.483Z | 2024-11-04T14:29:04.730Z |
5410388 | 5410388 | 20241027051052_4qk7q | UK008T | 2024-10-29T12:17:55.061Z | 2024-11-04T14:29:04.493Z |
5410350 | 5410350 | 20241027050732_zafP6 | UK008T | 2024-10-29T12:17:53.806Z | 2024-11-04T14:29:04.414Z |
5409975 | 5409975 | 20241027044630_VpkuQ | UK008T | 2024-10-29T12:17:45.190Z | 2024-11-04T14:29:03.166Z |
5409885 | 5409885 | 20241027043935_RBUSX | UK008T | 2024-10-29T12:17:43.297Z | 2024-11-04T14:29:02.847Z |
5409543 | 5409543 | 20241027042423_EM54p | UK008T | 2024-10-29T12:17:29.341Z | 2024-11-04T14:29:01.947Z |
5409496 | 5409496 | 20241027042217_aIykT | UK008T | 2024-10-29T12:17:26.710Z | 2024-11-04T14:29:01.915Z |
5409444 | 5409444 | 20241027041830_tIy3I | UK008T | 2024-10-29T12:17:24.251Z | 2024-11-04T14:29:01.741Z |
5409313 | 5409313 | 20241027041040_kPa89 | UK008T | 2024-10-29T12:17:16.192Z | 2024-11-04T14:29:01.517Z |
5409260 | 5409260 | 20241027040735_CKqZO | UK008T | 2024-10-29T12:17:14.337Z | 2024-11-04T14:29:01.440Z |
5409091 | 5409091 | 20241027035945_g4d8o | UK008T | 2024-10-29T12:17:05.273Z | 2024-11-04T14:29:01.042Z |
5408939 | 5408939 | 20241027035043_EEvAM | UK008T | 2024-10-29T12:16:57.712Z | 2024-11-04T14:29:00.847Z |
5408508 | 5408508 | 20241027032818_k9kCr | UK008T | 2024-10-29T12:16:33.563Z | 2024-11-04T14:28:59.580Z |
5408456 | 5408456 | 20241027032750_OBiFX | UK008T | 2024-10-29T12:16:31.339Z | 2024-11-04T14:28:59.509Z |
5408349 | 5408349 | 20241027032304_6oxSO | UK008T | 2024-10-29T12:16:24.485Z | 2024-11-04T14:28:59.244Z |
5408091 | 5408091 | 20241027030717_WO83A | UK008T | 2024-10-29T12:16:05.240Z | 2024-11-04T14:28:58.843Z |
5408066 | 5408066 | 20241027030530_deLch | UK008T | 2024-10-29T12:16:03.711Z | 2024-11-04T14:28:58.749Z |
5408060 | 5408060 | 20241027030513_4CLDQ | UK008T | 2024-10-29T12:16:03.400Z | 2024-11-04T14:28:58.747Z |
5407969 | 5407969 | 20241027030048_OBkfw | UK008T | 2024-10-29T12:15:55.978Z | 2024-11-04T14:28:58.535Z |
5407965 | 5407965 | 20241027030033_2mrzP | UK008T | 2024-10-29T12:15:55.667Z | 2024-11-04T14:28:58.534Z |
5407328 | 5407328 | 20241027023140_0D39A | UK008T | 2024-10-29T12:15:20.987Z | 2024-11-04T14:28:57.339Z |
5406877 | 5406877 | 20241027020604_jFPhF | UK008T | 2024-10-29T12:14:52.345Z | 2024-11-04T14:28:56.541Z |
5406687 | 5406687 | 20241027015356_gDssW | UK008T | 2024-10-29T12:14:32.240Z | 2024-11-04T14:28:56.033Z |
5405762 | 5405762 | 20241027005551_3TGSo | UK008T | 2024-10-29T12:13:13.244Z | 2024-11-04T14:28:54.154Z |
5405350 | 5405350 | 20241027002923_N3J0M | UK008T | 2024-10-29T12:12:50.675Z | 2024-11-04T14:28:53.318Z |
5405307 | 5405307 | 20241027002753_DuxbX | UK008T | 2024-10-29T12:12:49.022Z | 2024-11-04T14:28:53.268Z |
5405147 | 5405147 | 20241027001553_rKOVQ | UK008T | 2024-10-29T12:12:32.800Z | 2024-11-04T14:28:52.726Z |
5405033 | 5405033 | 20241027000946_K376n | UK008T | 2024-10-29T12:12:18.766Z | 2024-11-04T14:28:52.602Z |
5404972 | 5404972 | 20241027000348_MIR12 | UK008T | 2024-10-29T12:12:12.248Z | 2024-11-04T14:28:52.463Z |
5404899 | 5404899 | 20241026235956_WLvJt | UK008T | 2024-10-29T12:12:06.111Z | 2024-11-04T14:28:52.384Z |
5404853 | 5404853 | 20241026235704_UUM28 | UK008T | 2024-10-29T12:12:03.209Z | 2024-11-04T14:28:52.210Z |
5404849 | 5404849 | 20241026235657_GGxDS | UK008T | 2024-10-29T12:12:02.844Z | 2024-11-04T14:28:52.202Z |
5404835 | 5404835 | 20241026235536_sSovp | UK008T | 2024-10-29T12:12:00.851Z | 2024-11-04T14:28:52.174Z |
5404511 | 5404511 | 20241026233229_n25yi | UK008T | 2024-10-29T12:11:38.849Z | 2024-11-04T14:28:51.271Z |
5404381 | 5404381 | 20241026232145_gArhC | UK008T | 2024-10-29T12:11:16.746Z | 2024-11-04T14:28:50.826Z |
5403910 | 5403910 | 20241026224510_atRJZ | UK008T | 2024-10-29T12:10:26.912Z | 2024-11-04T14:28:50.002Z |
5395803 | 5395803 | 20241025231053_2y3ah | UK008T | 2024-10-28T12:16:52.627Z | 2024-11-03T14:27:26.700Z |
5395670 | 5395670 | 20241025230345_265KH | UK008T | 2024-10-28T12:16:38.056Z | 2024-11-03T14:27:26.383Z |
5395629 | 5395629 | 20241025230014_j0iQn | UK008T | 2024-10-28T12:16:34.345Z | 2024-11-03T14:27:26.298Z |
5395401 | 5395401 | 20241025224035_XthSJ | UK008T | 2024-10-28T12:16:12.668Z | 2024-11-03T14:27:25.452Z |
5395318 | 5395318 | 20241025223222_i2uyi | UK008T | 2024-10-28T12:16:07.284Z | 2024-11-03T14:27:25.017Z |
5394645 | 5394645 | 20241025210154_9Xbfn | UK008T | 2024-10-28T12:15:09.402Z | 2024-11-03T14:27:21.962Z |
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);