participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,737 rows where station_code = "UK0022" 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 |
---|---|---|---|---|---|
5129474 | 5129474 | 20240917040048_Yoxo3 | UK0022 | 2024-09-19T12:11:41.539Z | 2024-09-19T12:11:41.539Z |
5129392 | 5129392 | 20240917035457_VPmvh | UK0022 | 2024-09-19T12:11:34.640Z | 2024-09-19T12:11:34.640Z |
5129211 | 5129211 | 20240917033757_CJFTp | UK0022 | 2024-09-19T12:11:23.450Z | 2024-09-19T12:11:23.450Z |
5128763 | 5128763 | 20240917023353_Q01e3 | UK0022 | 2024-09-19T12:11:00.559Z | 2024-09-19T12:11:00.559Z |
5128739 | 5128739 | 20240917023112_gpYjQ | UK0022 | 2024-09-19T12:10:59.755Z | 2024-09-19T12:10:59.755Z |
5126876 | 5126876 | 20240916194256_Ehu7i | UK0022 | 2024-09-19T12:07:30.925Z | 2024-09-19T12:07:30.925Z |
5018764 | 5018764 | 20240904201018_Gb2S8 | UK0022 | 2024-09-10T12:11:31.069Z | 2024-09-13T12:19:48.844Z |
5010838 | 5010838 | 20240904035010_3eUN7 | UK0022 | 2024-09-09T12:09:05.266Z | 2024-09-12T12:19:29.272Z |
5010722 | 5010722 | 20240904033513_VrHV2 | UK0022 | 2024-09-09T12:08:58.538Z | 2024-09-12T12:19:28.765Z |
5010584 | 5010584 | 20240904032013_tukYR | UK0022 | 2024-09-09T12:08:52.398Z | 2024-09-12T12:19:28.035Z |
5010500 | 5010500 | 20240904031247_6bF4j | UK0022 | 2024-09-09T12:08:48.419Z | 2024-09-12T12:19:27.683Z |
5010480 | 5010480 | 20240904031056_HvvIU | UK0022 | 2024-09-09T12:08:47.683Z | 2024-09-12T12:19:27.635Z |
5010458 | 5010458 | 20240904030619_O6oJw | UK0022 | 2024-09-09T12:08:46.785Z | 2024-09-12T12:19:27.549Z |
5009952 | 5009952 | 20240904022019_3fca3 | UK0022 | 2024-09-09T12:08:16.049Z | 2024-09-12T12:19:25.082Z |
5009899 | 5009899 | 20240904021313_e1CH3 | UK0022 | 2024-09-09T12:08:12.867Z | 2024-09-12T12:19:24.910Z |
5009649 | 5009649 | 20240904014442_jkfVI | UK0022 | 2024-09-09T12:07:53.788Z | 2024-09-12T12:19:23.894Z |
5009534 | 5009534 | 20240904013222_LkLAp | UK0022 | 2024-09-09T12:07:48.710Z | 2024-09-12T12:19:23.258Z |
5009262 | 5009262 | 20240904010741_DaJDU | UK0022 | 2024-09-09T12:07:33.047Z | 2024-09-12T12:19:22.240Z |
5009163 | 5009163 | 20240904010135_YR4nJ | UK0022 | 2024-09-09T12:07:28.364Z | 2024-09-12T12:19:21.870Z |
5009137 | 5009137 | 20240904005654_3Z7lp | UK0022 | 2024-09-09T12:07:26.942Z | 2024-09-12T12:19:21.713Z |
5009058 | 5009058 | 20240904005044_57zfU | UK0022 | 2024-09-09T12:07:22.954Z | 2024-09-12T12:19:21.285Z |
5008927 | 5008927 | 20240904003800_cMfP5 | UK0022 | 2024-09-09T12:07:16.062Z | 2024-09-12T12:19:20.689Z |
5008507 | 5008507 | 20240903234953_mM49v | UK0022 | 2024-09-09T12:06:50.751Z | 2024-09-12T12:19:17.924Z |
5008381 | 5008381 | 20240903233810_RkKL8 | UK0022 | 2024-09-09T12:06:41.213Z | 2024-09-12T12:19:17.352Z |
5007261 | 5007261 | 20240903203512_LDRxK | UK0022 | 2024-09-09T12:05:39.347Z | 2024-09-12T12:19:12.309Z |
5007197 | 5007197 | 20240903202141_TlwUr | UK0022 | 2024-09-09T12:05:34.306Z | 2024-09-12T12:19:12.055Z |
5007134 | 5007134 | 20240903200059_Di5Zc | UK0022 | 2024-09-09T12:05:27.679Z | 2024-09-12T12:19:11.639Z |
4988910 | 4988910 | 20240901220002_vFNNi | UK0022 | 2024-09-07T12:08:12.618Z | 2024-09-10T12:19:15.860Z |
4988606 | 4988606 | 20240901211231_VEdbK | UK0022 | 2024-09-07T12:07:44.656Z | 2024-09-10T12:19:14.785Z |
4983248 | 4983248 | 20240812004226_8OJQU | UK0022 | 2024-09-06T12:15:22.301Z | 2024-09-06T12:15:22.301Z |
4983039 | 4983039 | 20240812004045_4i3nE | UK0022 | 2024-09-06T12:15:13.941Z | 2024-09-06T12:15:13.941Z |
4982483 | 4982483 | 20240812003359_G4i2n | UK0022 | 2024-09-06T12:14:53.251Z | 2024-09-06T12:14:53.251Z |
4982407 | 4982407 | 20240812003325_nDtLD | UK0022 | 2024-09-06T12:14:50.625Z | 2024-09-06T12:14:50.625Z |
4982203 | 4982203 | 20240812003122_u33AF | UK0022 | 2024-09-06T12:14:47.057Z | 2024-09-06T12:14:47.057Z |
4982169 | 4982169 | 20240812003104_y7cmn | UK0022 | 2024-09-06T12:14:45.389Z | 2024-09-06T12:14:45.389Z |
4982148 | 4982148 | 20240812003044_07IR3 | UK0022 | 2024-09-06T12:14:43.830Z | 2024-09-06T12:14:43.830Z |
4981816 | 4981816 | 20240812002731_CICO7 | UK0022 | 2024-09-06T12:14:38.216Z | 2024-09-06T12:14:38.216Z |
4981771 | 4981771 | 20240812002719_zdGmG | UK0022 | 2024-09-06T12:14:37.479Z | 2024-09-06T12:14:37.479Z |
4981168 | 4981168 | 20240812001908_8QUgM | UK0022 | 2024-09-06T12:14:27.118Z | 2024-09-06T12:14:27.118Z |
4981125 | 4981125 | 20240812001855_i2PYB | UK0022 | 2024-09-06T12:14:26.692Z | 2024-09-06T12:14:26.692Z |
4981031 | 4981031 | 20240812001827_rDhIB | UK0022 | 2024-09-06T12:14:25.759Z | 2024-09-06T12:14:25.759Z |
4980958 | 4980958 | 20240812001753_hSkSa | UK0022 | 2024-09-06T12:14:24.952Z | 2024-09-06T12:14:24.952Z |
4980242 | 4980242 | 20240812001017_yEdXJ | UK0022 | 2024-09-06T12:13:54.011Z | 2024-09-06T12:13:54.011Z |
4980106 | 4980106 | 20240812000843_8vUOC | UK0022 | 2024-09-06T12:13:47.765Z | 2024-09-06T12:13:47.765Z |
4979747 | 4979747 | 20240812000429_LoqMZ | UK0022 | 2024-09-06T12:13:26.532Z | 2024-09-06T12:13:26.532Z |
4979694 | 4979694 | 20240812000340_BHBlA | UK0022 | 2024-09-06T12:13:22.809Z | 2024-09-06T12:13:22.809Z |
4979202 | 4979202 | 20240812000029_4wC0S | UK0022 | 2024-09-06T12:13:05.400Z | 2024-09-06T12:13:05.400Z |
4979110 | 4979110 | 20240811235927_p02J4 | UK0022 | 2024-09-06T12:12:58.002Z | 2024-09-06T12:12:58.002Z |
4978808 | 4978808 | 20240811235541_GfUgi | UK0022 | 2024-09-06T12:12:43.236Z | 2024-09-06T12:12:43.236Z |
4978781 | 4978781 | 20240811235502_ODBJw | UK0022 | 2024-09-06T12:12:42.741Z | 2024-09-06T12:12:42.741Z |
4978660 | 4978660 | 20240811235316_lokiD | UK0022 | 2024-09-06T12:12:38.829Z | 2024-09-06T12:12:38.829Z |
4978520 | 4978520 | 20240811235209_qSL7q | UK0022 | 2024-09-06T12:12:35.470Z | 2024-09-06T12:12:35.470Z |
4978513 | 4978513 | 20240811235152_Ieya3 | UK0022 | 2024-09-06T12:12:35.334Z | 2024-09-06T12:12:35.334Z |
4978167 | 4978167 | 20240811234844_VP1K2 | UK0022 | 2024-09-06T12:12:30.695Z | 2024-09-06T12:12:30.695Z |
4978071 | 4978071 | 20240811234748_0CRxz | UK0022 | 2024-09-06T12:12:29.034Z | 2024-09-06T12:12:29.034Z |
4977918 | 4977918 | 20240811234623_4XnIr | UK0022 | 2024-09-06T12:12:26.702Z | 2024-09-06T12:12:26.702Z |
4977816 | 4977816 | 20240811234451_d7POk | UK0022 | 2024-09-06T12:12:23.534Z | 2024-09-06T12:12:23.534Z |
4977795 | 4977795 | 20240811234445_qlqdB | UK0022 | 2024-09-06T12:12:23.276Z | 2024-09-06T12:12:23.276Z |
4977685 | 4977685 | 20240811234330_i0GDn | UK0022 | 2024-09-06T12:12:21.985Z | 2024-09-06T12:12:21.985Z |
4977614 | 4977614 | 20240811234208_u7NIE | UK0022 | 2024-09-06T12:12:20.691Z | 2024-09-06T12:12:20.691Z |
4977279 | 4977279 | 20240811233828_YChBI | UK0022 | 2024-09-06T12:12:11.284Z | 2024-09-06T12:12:11.284Z |
4977221 | 4977221 | 20240811233755_Xe4RM | UK0022 | 2024-09-06T12:12:07.668Z | 2024-09-06T12:12:07.668Z |
4977022 | 4977022 | 20240811233550_V5o1U | UK0022 | 2024-09-06T12:12:01.712Z | 2024-09-06T12:12:01.712Z |
4976912 | 4976912 | 20240811233448_Vh8v6 | UK0022 | 2024-09-06T12:11:57.277Z | 2024-09-06T12:11:57.277Z |
4975658 | 4975658 | 20240811232053_5TaFD | UK0022 | 2024-09-06T12:10:46.936Z | 2024-09-06T12:10:46.936Z |
4975494 | 4975494 | 20240811231913_hNS9q | UK0022 | 2024-09-05T12:11:51.712Z | 2024-09-06T12:10:42.213Z |
4975397 | 4975397 | 20240811231753_lqZ3T | UK0022 | 2024-09-05T12:11:48.789Z | 2024-09-06T12:10:41.090Z |
4975176 | 4975176 | 20240811231554_T68Js | UK0022 | 2024-09-05T12:11:41.483Z | 2024-09-06T12:10:38.425Z |
4975071 | 4975071 | 20240811231426_FVOOI | UK0022 | 2024-09-05T12:11:39.300Z | 2024-09-06T12:10:36.700Z |
4974852 | 4974852 | 20240811231213_Ct3tF | UK0022 | 2024-09-05T12:11:33.920Z | 2024-09-06T12:10:33.971Z |
4974407 | 4974407 | 20240811230647_TCUNZ | UK0022 | 2024-09-05T12:11:24.263Z | 2024-09-06T12:10:26.458Z |
4973423 | 4973423 | 20240811225639_96Z4o | UK0022 | 2024-09-05T12:10:51.106Z | 2024-09-06T12:09:54.345Z |
4973253 | 4973253 | 20240811225522_1TBUm | UK0022 | 2024-09-05T12:10:45.759Z | 2024-09-06T12:09:50.156Z |
4972054 | 4972054 | 20240811224239_C3pIV | UK0022 | 2024-09-05T12:10:14.681Z | 2024-09-06T12:09:04.194Z |
4971888 | 4971888 | 20240811224038_kWKFF | UK0022 | 2024-09-05T12:10:06.819Z | 2024-09-06T12:08:59.835Z |
4971499 | 4971499 | 20240811223624_ePKfB | UK0022 | 2024-09-05T12:09:45.147Z | 2024-09-06T12:08:53.868Z |
4971111 | 4971111 | 20240811223209_AcY3K | UK0022 | 2024-09-05T12:09:39.469Z | 2024-09-06T12:08:49.499Z |
4970931 | 4970931 | 20240811222948_Xklqe | UK0022 | 2024-09-05T12:09:34.642Z | 2024-09-06T12:08:46.699Z |
4970735 | 4970735 | 20240811222818_Rfu7g | UK0022 | 2024-09-05T12:09:31.452Z | 2024-09-06T12:08:44.238Z |
4970210 | 4970210 | 20240811222222_XSA31 | UK0022 | 2024-09-05T12:09:21.603Z | 2024-09-06T12:08:30.179Z |
4970034 | 4970034 | 20240811222011_8iwZZ | UK0022 | 2024-09-05T12:09:17.119Z | 2024-09-06T12:08:18.353Z |
4969650 | 4969650 | 20240811221405_u9IsN | UK0022 | 2024-09-05T12:08:52.752Z | 2024-09-06T12:07:57.433Z |
4969397 | 4969397 | 20240811221130_8nkU0 | UK0022 | 2024-09-05T12:08:44.318Z | 2024-09-06T12:07:51.370Z |
4969356 | 4969356 | 20240811221044_5d3ur | UK0022 | 2024-09-05T12:08:43.325Z | 2024-09-06T12:07:50.573Z |
4969179 | 4969179 | 20240811220752_j9c5b | UK0022 | 2024-09-05T12:08:37.057Z | 2024-09-06T12:07:44.070Z |
4969045 | 4969045 | 20240811220605_Xvy0A | UK0022 | 2024-09-05T12:08:34.300Z | 2024-09-06T12:07:41.908Z |
4968815 | 4968815 | 20240811220259_v8mlt | UK0022 | 2024-09-05T12:08:27.618Z | 2024-09-06T12:07:36.703Z |
4968408 | 4968408 | 20240811215826_2J7tH | UK0022 | 2024-09-05T12:08:18.758Z | 2024-09-06T12:07:30.152Z |
4968235 | 4968235 | 20240811215555_qcBeL | UK0022 | 2024-09-05T12:08:08.760Z | 2024-09-06T12:07:26.891Z |
4967887 | 4967887 | 20240811215114_0FxUl | UK0022 | 2024-09-05T12:07:52.644Z | 2024-09-06T12:07:14.628Z |
4967826 | 4967826 | 20240811215037_QVULk | UK0022 | 2024-09-05T12:07:51.590Z | 2024-09-06T12:07:11.976Z |
4967507 | 4967507 | 20240811214506_3ycBM | UK0022 | 2024-09-05T12:07:40.936Z | 2024-09-06T12:07:01.325Z |
4967283 | 4967283 | 20240811214140_3c3Gq | UK0022 | 2024-09-05T12:07:34.786Z | 2024-09-06T12:06:56.320Z |
4967257 | 4967257 | 20240811214136_vIYaD | UK0022 | 2024-09-05T12:07:34.624Z | 2024-09-06T12:06:56.231Z |
4967080 | 4967080 | 20240811213823_K1L0v | UK0022 | 2024-09-05T12:07:29.751Z | 2024-09-06T12:06:52.727Z |
4966796 | 4966796 | 20240811213344_7M5c5 | UK0022 | 2024-09-05T12:07:14.498Z | 2024-09-06T12:06:47.694Z |
4966609 | 4966609 | 20240811213146_A25Js | UK0022 | 2024-09-04T12:07:30.989Z | 2024-09-06T12:06:37.269Z |
4966590 | 4966590 | 20240811213128_AgJUt | UK0022 | 2024-09-04T12:07:30.333Z | 2024-09-06T12:06:35.948Z |
4966236 | 4966236 | 20240811212559_I0d80 | UK0022 | 2024-09-04T12:07:21.633Z | 2024-09-06T12:06:18.978Z |
4966121 | 4966121 | 20240811212429_jPibk | UK0022 | 2024-09-04T12:07:18.823Z | 2024-09-06T12:06:14.261Z |
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);