participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,585 rows where station_code = "UK006C" 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 |
---|---|---|---|---|---|
5565449 | 5565449 | 20241120042726_b4FNl | UK006C | 2024-11-21T14:18:49.507Z | 2024-11-21T14:18:54.210Z |
5565293 | 5565293 | 20241120041701_aDnh0 | UK006C | 2024-11-21T14:18:45.550Z | 2024-11-21T14:18:54.189Z |
5565085 | 5565085 | 20241120035100_IBmkW | UK006C | 2024-11-21T14:18:28.623Z | 2024-11-21T14:18:54.152Z |
5564713 | 5564713 | 20241120032154_D2Mgu | UK006C | 2024-11-21T14:17:59.124Z | 2024-11-21T14:18:54.087Z |
5564379 | 5564379 | 20241120025052_ZY4RL | UK006C | 2024-11-21T14:17:31.462Z | 2024-11-21T14:18:54.032Z |
5564305 | 5564305 | 20241120024713_3F2O4 | UK006C | 2024-11-21T14:17:26.507Z | 2024-11-21T14:18:54.021Z |
5564073 | 5564073 | 20241120022707_JBueg | UK006C | 2024-11-21T14:17:07.560Z | 2024-11-21T14:18:53.974Z |
5564019 | 5564019 | 20241120022444_la2qe | UK006C | 2024-11-21T14:17:05.108Z | 2024-11-21T14:18:53.966Z |
5563971 | 5563971 | 20241120021932_xdyhl | UK006C | 2024-11-21T14:17:00.927Z | 2024-11-21T14:18:53.953Z |
5563867 | 5563867 | 20241120021131_V5yii | UK006C | 2024-11-21T14:16:51.923Z | 2024-11-21T14:18:53.934Z |
5563625 | 5563625 | 20241120015326_F7t5V | UK006C | 2024-11-21T14:16:30.224Z | 2024-11-21T14:18:53.891Z |
5563257 | 5563257 | 20241120011234_sfwAR | UK006C | 2024-11-21T14:15:48.471Z | 2024-11-21T14:18:53.820Z |
5563210 | 5563210 | 20241120010500_639EG | UK006C | 2024-11-21T14:15:40.430Z | 2024-11-21T14:18:53.808Z |
5562709 | 5562709 | 20241120000441_lzEId | UK006C | 2024-11-21T14:15:17.604Z | 2024-11-21T14:18:53.725Z |
5562455 | 5562455 | 20241119234026_yimqW | UK006C | 2024-11-21T14:14:52.978Z | 2024-11-21T14:18:53.687Z |
5562382 | 5562382 | 20241119233237_IRvio | UK006C | 2024-11-21T14:14:45.988Z | 2024-11-21T14:18:53.675Z |
5562036 | 5562036 | 20241119224750_AFI9r | UK006C | 2024-11-21T14:14:21.315Z | 2024-11-21T14:18:53.624Z |
5561965 | 5561965 | 20241119224019_N3gY5 | UK006C | 2024-11-21T14:14:17.428Z | 2024-11-21T14:18:53.613Z |
5561905 | 5561905 | 20241119222753_gZ41l | UK006C | 2024-11-21T14:14:13.336Z | 2024-11-21T14:18:53.601Z |
5561899 | 5561899 | 20241119222540_BA6zm | UK006C | 2024-11-21T14:14:13.098Z | 2024-11-21T14:18:53.600Z |
5561590 | 5561590 | 20241119211125_10v7a | UK006C | 2024-11-21T14:13:31.833Z | 2024-11-21T14:18:53.544Z |
5561358 | 5561358 | 20241119200955_2rbb3 | UK006C | 2024-11-21T14:13:08.734Z | 2024-11-21T14:18:53.484Z |
5561307 | 5561307 | 20241119194535_pVMjY | UK006C | 2024-11-21T14:13:03.468Z | 2024-11-21T14:18:53.467Z |
5558023 | 5558023 | 20241120053214_Nlfdq | UK006C | 2024-11-21T14:02:20.033Z | 2024-11-21T14:02:20.033Z |
5557729 | 5557729 | 20241120050806_ucm4i | UK006C | 2024-11-21T14:01:36.105Z | 2024-11-21T14:01:36.105Z |
5557625 | 5557625 | 20241120050225_8hSlr | UK006C | 2024-11-21T14:01:23.435Z | 2024-11-21T14:01:23.435Z |
5557502 | 5557502 | 20241120045147_jpSCq | UK006C | 2024-11-21T14:01:01.442Z | 2024-11-21T14:01:01.442Z |
5557431 | 5557431 | 20241120044510_U7lFI | UK006C | 2024-11-21T14:00:49.483Z | 2024-11-21T14:00:49.483Z |
5553913 | 5553913 | 20241118045457_ZRpOj | UK006C | 2024-11-19T14:11:33.391Z | 2024-11-21T14:22:23.832Z |
5553871 | 5553871 | 20241118043641_MHJBX | UK006C | 2024-11-19T14:11:30.776Z | 2024-11-21T14:22:22.874Z |
5553821 | 5553821 | 20241118042706_6r8OY | UK006C | 2024-11-19T14:11:28.559Z | 2024-11-21T14:22:22.582Z |
5553013 | 5553013 | 20241118001258_GfJWz | UK006C | 2024-11-19T14:09:56.890Z | 2024-11-21T14:22:05.846Z |
5549735 | 5549735 | 20241118061226_VUk9t | UK006C | 2024-11-19T14:00:41.799Z | 2024-11-21T14:18:59.278Z |
5549720 | 5549720 | 20241118061018_nQTwp | UK006C | 2024-11-19T14:00:40.608Z | 2024-11-21T14:18:58.971Z |
5549695 | 5549695 | 20241118060303_F8StD | UK006C | 2024-11-19T14:00:34.976Z | 2024-11-21T14:18:57.802Z |
5549655 | 5549655 | 20241118055006_3ekE4 | UK006C | 2024-11-19T14:00:30.865Z | 2024-11-21T14:18:57.317Z |
5549641 | 5549641 | 20241118054747_o2TJx | UK006C | 2024-11-19T14:00:29.152Z | 2024-11-21T14:18:57.196Z |
5549634 | 5549634 | 20241118054558_z1J2C | UK006C | 2024-11-19T14:00:28.405Z | 2024-11-21T14:18:57.168Z |
5549586 | 5549586 | 20241118053424_dSek1 | UK006C | 2024-11-19T14:00:21.509Z | 2024-11-21T14:18:56.628Z |
5549569 | 5549569 | 20241118053122_4UcrV | UK006C | 2024-11-19T14:00:19.595Z | 2024-11-21T14:18:56.443Z |
5549507 | 5549507 | 20241118050213_mBUjP | UK006C | 2024-11-19T14:00:10.627Z | 2024-11-21T14:18:55.674Z |
5549486 | 5549486 | 20241117050327_oidc8 | UK006C | 2024-11-18T14:11:44.315Z | 2024-11-21T14:23:17.869Z |
5545675 | 5545675 | 20241117060941_lKjR2 | UK006C | 2024-11-18T14:00:37.869Z | 2024-11-21T14:20:56.915Z |
5545612 | 5545612 | 20241117054255_7yreK | UK006C | 2024-11-18T14:00:27.059Z | 2024-11-21T14:20:55.121Z |
5545594 | 5545594 | 20241117053451_4BvGj | UK006C | 2024-11-18T14:00:23.622Z | 2024-11-21T14:20:54.740Z |
5545590 | 5545590 | 20241117053232_eNrxX | UK006C | 2024-11-18T14:00:23.186Z | 2024-11-21T14:20:54.710Z |
5545572 | 5545572 | 20241117052547_IaQXl | UK006C | 2024-11-18T14:00:19.589Z | 2024-11-21T14:20:54.176Z |
5545131 | 5545131 | 20241116010757_dvU32 | UK006C | 2024-11-17T14:03:52.152Z | 2024-11-21T14:23:43.493Z |
5545078 | 5545078 | 20241115233555_QOieF | UK006C | 2024-11-17T14:03:45.280Z | 2024-11-21T14:23:42.703Z |
5545068 | 5545068 | 20241115231249_EQ3Kb | UK006C | 2024-11-17T14:03:43.835Z | 2024-11-21T14:23:42.557Z |
5545037 | 5545037 | 20241115224955_DhGcj | UK006C | 2024-11-17T14:03:39.772Z | 2024-11-21T14:23:41.696Z |
5545015 | 5545015 | 20241115221152_ToncZ | UK006C | 2024-11-17T14:03:37.117Z | 2024-11-21T14:23:41.203Z |
5543948 | 5543948 | 20241115044909_YiCf2 | UK006C | 2024-11-16T14:07:44.032Z | 2024-11-21T14:24:37.001Z |
5543921 | 5543921 | 20241115043838_UMgSj | UK006C | 2024-11-16T14:07:40.157Z | 2024-11-21T14:24:36.603Z |
5543667 | 5543667 | 20241115025011_MTyF4 | UK006C | 2024-11-16T14:06:59.839Z | 2024-11-21T14:24:30.778Z |
5543619 | 5543619 | 20241115023625_69Ezs | UK006C | 2024-11-16T14:06:56.692Z | 2024-11-21T14:24:30.596Z |
5543572 | 5543572 | 20241115021638_lA2Qz | UK006C | 2024-11-16T14:06:46.863Z | 2024-11-21T14:24:29.869Z |
5543347 | 5543347 | 20241115002703_PQMme | UK006C | 2024-11-16T14:06:08.215Z | 2024-11-21T14:24:26.813Z |
5543303 | 5543303 | 20241114235908_F9xUM | UK006C | 2024-11-16T14:06:03.908Z | 2024-11-21T14:24:25.785Z |
5543278 | 5543278 | 20241114234502_MfvkU | UK006C | 2024-11-16T14:05:59.253Z | 2024-11-21T14:24:25.637Z |
5543164 | 5543164 | 20241114221033_Z7N9t | UK006C | 2024-11-16T14:05:38.469Z | 2024-11-21T14:24:24.289Z |
5542109 | 5542109 | 20241115054207_0Bvqn | UK006C | 2024-11-16T14:00:12.088Z | 2024-11-21T14:23:20.453Z |
5542068 | 5542068 | 20241114053731_42Hws | UK006C | 2024-11-15T14:08:52.381Z | 2024-11-21T14:25:22.621Z |
5542065 | 5542065 | 20241114053707_OciJY | UK006C | 2024-11-15T14:08:52.146Z | 2024-11-21T14:25:22.619Z |
5542051 | 5542051 | 20241114053428_2oBAv | UK006C | 2024-11-15T14:08:51.297Z | 2024-11-21T14:25:22.091Z |
5541985 | 5541985 | 20241114052555_7Dt1J | UK006C | 2024-11-15T14:08:46.009Z | 2024-11-21T14:25:21.111Z |
5541879 | 5541879 | 20241114050245_yb3Jo | UK006C | 2024-11-15T14:08:36.855Z | 2024-11-21T14:25:20.115Z |
5539299 | 5539299 | 20241114060825_ikGgf | UK006C | 2024-11-15T14:00:37.449Z | 2024-11-21T14:23:53.621Z |
5539074 | 5539074 | 20241113054100_ZQ2QJ | UK006C | 2024-11-14T14:14:11.168Z | 2024-11-21T14:26:31.553Z |
5539008 | 5539008 | 20241113053244_a8ori | UK006C | 2024-11-14T14:14:08.378Z | 2024-11-21T14:26:31.008Z |
5538853 | 5538853 | 20241113050517_F9dOw | UK006C | 2024-11-14T14:14:00.669Z | 2024-11-21T14:26:29.217Z |
5538749 | 5538749 | 20241113045043_Xkzsg | UK006C | 2024-11-14T14:13:54.902Z | 2024-11-21T14:26:28.684Z |
5538603 | 5538603 | 20241113042134_9obYo | UK006C | 2024-11-14T14:13:43.314Z | 2024-11-21T14:26:27.557Z |
5538518 | 5538518 | 20241113040232_Q1WcX | UK006C | 2024-11-14T14:13:35.242Z | 2024-11-21T14:26:26.907Z |
5529215 | 5529215 | 20241111234711_VF8R6 | UK006C | 2024-11-13T14:12:13.975Z | 2024-11-20T14:25:41.874Z |
5528939 | 5528939 | 20241111231058_WIEDE | UK006C | 2024-11-13T14:11:44.910Z | 2024-11-20T14:25:37.628Z |
5528931 | 5528931 | 20241111230901_qxnFt | UK006C | 2024-11-13T14:11:42.533Z | 2024-11-20T14:25:37.603Z |
5528911 | 5528911 | 20241111230447_Pgrj4 | UK006C | 2024-11-13T14:11:38.016Z | 2024-11-20T14:25:37.196Z |
5528605 | 5528605 | 20241111214904_4XhiB | UK006C | 2024-11-13T14:11:09.131Z | 2024-11-20T14:25:32.569Z |
5528317 | 5528317 | 20241111202318_eEt3I | UK006C | 2024-11-13T14:10:26.901Z | 2024-11-20T14:25:28.436Z |
5528294 | 5528294 | 20241111201433_nl9m3 | UK006C | 2024-11-13T14:10:24.851Z | 2024-11-20T14:25:28.056Z |
5528182 | 5528182 | 20241111195037_mNX3i | UK006C | 2024-11-13T14:10:13.222Z | 2024-11-20T14:25:26.367Z |
5527985 | 5527985 | 20241111190937_kihwN | UK006C | 2024-11-13T14:09:39.475Z | 2024-11-20T14:25:23.756Z |
5527876 | 5527876 | 20241111185021_I690c | UK006C | 2024-11-13T14:09:29.961Z | 2024-11-20T14:25:22.519Z |
5524568 | 5524568 | 20241111043651_m6pM3 | UK006C | 2024-11-12T14:17:41.571Z | 2024-11-19T14:22:22.272Z |
5524482 | 5524482 | 20241111041948_WS278 | UK006C | 2024-11-12T14:17:24.658Z | 2024-11-19T14:22:21.550Z |
5524320 | 5524320 | 20241111035306_VHSty | UK006C | 2024-11-12T14:17:00.672Z | 2024-11-19T14:22:19.979Z |
5524287 | 5524287 | 20241111034722_sWKra | UK006C | 2024-11-12T14:16:54.975Z | 2024-11-19T14:22:19.702Z |
5524185 | 5524185 | 20241111032501_ruGG1 | UK006C | 2024-11-12T14:16:42.626Z | 2024-11-19T14:22:17.851Z |
5524157 | 5524157 | 20241111032022_qY3qV | UK006C | 2024-11-12T14:16:38.162Z | 2024-11-19T14:22:17.605Z |
5524070 | 5524070 | 20241111030812_tDDGw | UK006C | 2024-11-12T14:16:30.717Z | 2024-11-19T14:22:16.979Z |
5524025 | 5524025 | 20241111030301_RTYxS | UK006C | 2024-11-12T14:16:28.381Z | 2024-11-19T14:22:16.640Z |
5523926 | 5523926 | 20241111024904_vtZ4n | UK006C | 2024-11-12T14:16:20.949Z | 2024-11-19T14:22:15.920Z |
5523879 | 5523879 | 20241111024303_XGdyo | UK006C | 2024-11-12T14:16:18.738Z | 2024-11-19T14:22:15.691Z |
5523141 | 5523141 | 20241111001332_Gjhdu | UK006C | 2024-11-12T14:14:49.234Z | 2024-11-19T14:22:10.153Z |
5523136 | 5523136 | 20241111001308_gC4BO | UK006C | 2024-11-12T14:14:48.817Z | 2024-11-19T14:22:10.149Z |
5522120 | 5522120 | 20241110190919_IHiXM | UK006C | 2024-11-12T14:12:51.880Z | 2024-11-19T14:21:58.445Z |
5452918 | 5452918 | 20241101052641_bBmHf | UK006C | 2024-11-02T12:19:33.570Z | 2024-11-09T14:24:36.040Z |
5442999 | 5442999 | 20241030031027_jAWg3 | UK006C | 2024-11-01T12:20:15.301Z | 2024-11-07T14:26:49.250Z |
5442985 | 5442985 | 20241030030846_thtrz | UK006C | 2024-11-01T12:20:14.935Z | 2024-11-07T14:26:49.094Z |
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);