participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,314 rows where station_code = "UK00C2" 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 |
---|---|---|---|---|---|
5410716 | 5410716 | 20241027053054_BwOEC | UK00C2 | 2024-10-29T12:18:03.158Z | 2024-11-04T14:29:05.285Z |
5410685 | 5410685 | 20241027052755_rMIxt | UK00C2 | 2024-10-29T12:18:02.339Z | 2024-11-04T14:29:05.213Z |
5410303 | 5410303 | 20241027050526_99QyE | UK00C2 | 2024-10-29T12:17:52.648Z | 2024-11-04T14:29:04.317Z |
5409856 | 5409856 | 20241027043844_8Mukd | UK00C2 | 2024-10-29T12:17:42.453Z | 2024-11-04T14:29:02.818Z |
5408477 | 5408477 | 20241027032805_oUwqC | UK00C2 | 2024-10-29T12:16:32.322Z | 2024-11-04T14:28:59.554Z |
5402785 | 5402785 | 20241026202414_l3re5 | UK00C2 | 2024-10-29T12:08:07.947Z | 2024-11-04T14:28:46.520Z |
5402662 | 5402662 | 20241026201132_k0xJF | UK00C2 | 2024-10-29T12:07:54.923Z | 2024-11-04T14:28:45.893Z |
5402290 | 5402290 | 20241026191011_L8XOc | UK00C2 | 2024-10-29T12:06:53.435Z | 2024-11-04T14:28:43.603Z |
5402282 | 5402282 | 20241026190926_Fh2Md | UK00C2 | 2024-10-29T12:06:52.250Z | 2024-11-04T14:28:43.595Z |
5402244 | 5402244 | 20241026190525_zPSdF | UK00C2 | 2024-10-29T12:06:43.391Z | 2024-11-04T14:28:43.326Z |
5399483 | 5399483 | 20241026042639_GP8u8 | UK00C2 | 2024-10-28T12:20:00.499Z | 2024-11-03T14:27:39.842Z |
5397064 | 5397064 | 20241026005940_zCzpA | UK00C2 | 2024-10-28T12:18:05.368Z | 2024-11-03T14:27:31.979Z |
5396783 | 5396783 | 20241026003248_AGjxn | UK00C2 | 2024-10-28T12:17:55.540Z | 2024-11-03T14:27:30.888Z |
5396761 | 5396761 | 20241026003053_MeuLc | UK00C2 | 2024-10-28T12:17:55.169Z | 2024-11-03T14:27:30.859Z |
5395574 | 5395574 | 20241025225522_2pqft | UK00C2 | 2024-10-28T12:16:28.107Z | 2024-11-03T14:27:26.062Z |
5395394 | 5395394 | 20241025223936_PELed | UK00C2 | 2024-10-28T12:16:11.998Z | 2024-11-03T14:27:25.423Z |
5386060 | 5386060 | 20241024235843_Q5yg6 | UK00C2 | 2024-10-27T12:19:48.103Z | 2024-11-02T12:28:30.650Z |
5384907 | 5384907 | 20241024211439_22Biw | UK00C2 | 2024-10-27T12:17:57.669Z | 2024-11-02T12:28:28.584Z |
5384889 | 5384889 | 20241024211249_NEU7H | UK00C2 | 2024-10-27T12:17:55.842Z | 2024-11-02T12:28:28.574Z |
5383393 | 5383393 | 20241024181717_Ad8DM | UK00C2 | 2024-10-27T12:15:23.016Z | 2024-11-02T12:28:25.102Z |
5378083 | 5378083 | 20241024052606_xa2xB | UK00C2 | 2024-10-26T12:22:54.219Z | 2024-11-01T12:27:03.276Z |
5378052 | 5378052 | 20241024052525_uw2Cu | UK00C2 | 2024-10-26T12:22:53.740Z | 2024-11-01T12:27:03.265Z |
5377853 | 5377853 | 20241024051448_9475l | UK00C2 | 2024-10-26T12:22:48.464Z | 2024-11-01T12:27:03.088Z |
5377777 | 5377777 | 20241024050923_2pBoi | UK00C2 | 2024-10-26T12:22:46.808Z | 2024-11-01T12:27:02.814Z |
5375826 | 5375826 | 20241024033205_Du9An | UK00C2 | 2024-10-26T12:21:41.193Z | 2024-11-01T12:27:01.213Z |
5363481 | 5363481 | 20241023210916_nDzBE | UK00C2 | 2024-10-25T12:16:15.220Z | 2024-11-01T12:26:53.317Z |
5362836 | 5362836 | 20241023200401_L3Kru | UK00C2 | 2024-10-25T12:15:11.628Z | 2024-11-01T12:26:52.472Z |
5351503 | 5351503 | 20241022233349_XN0Bl | UK00C2 | 2024-10-24T12:17:36.528Z | 2024-10-31T12:30:00.475Z |
5351134 | 5351134 | 20241022230019_4RhpW | UK00C2 | 2024-10-24T12:17:14.821Z | 2024-10-31T12:29:59.517Z |
5350127 | 5350127 | 20241022211517_a6QHa | UK00C2 | 2024-10-24T12:15:23.492Z | 2024-10-31T12:29:57.341Z |
5349228 | 5349228 | 20241022193507_jCC3J | UK00C2 | 2024-10-24T12:13:19.921Z | 2024-10-31T12:29:54.917Z |
5349031 | 5349031 | 20241022192054_ZIjDR | UK00C2 | 2024-10-24T12:12:55.376Z | 2024-10-31T12:29:54.506Z |
5348956 | 5348956 | 20241022191151_McGs9 | UK00C2 | 2024-10-24T12:12:38.403Z | 2024-10-31T12:29:54.233Z |
5338797 | 5338797 | 20241021203922_CRu6n | UK00C2 | 2024-10-23T12:11:56.409Z | 2024-10-30T12:26:42.801Z |
5321612 | 5321612 | 20241018052442_vDBsX | UK00C2 | 2024-10-19T12:07:53.966Z | 2024-10-26T12:27:57.052Z |
5321406 | 5321406 | 20241018044734_XmrLl | UK00C2 | 2024-10-19T12:07:22.497Z | 2024-10-26T12:27:56.610Z |
5321372 | 5321372 | 20241018044336_IY9t2 | UK00C2 | 2024-10-19T12:07:15.869Z | 2024-10-26T12:27:56.567Z |
5321323 | 5321323 | 20241018043156_XsDnQ | UK00C2 | 2024-10-19T12:07:12.036Z | 2024-10-26T12:27:56.505Z |
5321206 | 5321206 | 20241018040547_4qIhU | UK00C2 | 2024-10-19T12:07:01.102Z | 2024-10-26T12:27:56.347Z |
5321084 | 5321084 | 20241018034059_Hz0eg | UK00C2 | 2024-10-19T12:06:41.579Z | 2024-10-26T12:27:56.100Z |
5320920 | 5320920 | 20241018031308_V9rwA | UK00C2 | 2024-10-19T12:06:21.072Z | 2024-10-26T12:27:55.756Z |
5320799 | 5320799 | 20241018024500_EVmYQ | UK00C2 | 2024-10-19T12:06:10.900Z | 2024-10-26T12:27:55.362Z |
5320757 | 5320757 | 20241018023509_Rmn7M | UK00C2 | 2024-10-19T12:05:58.730Z | 2024-10-26T12:27:55.197Z |
5300645 | 5300645 | 20241012211041_NokBC | UK00C2 | 2024-10-14T12:14:20.052Z | 2024-10-21T12:23:50.820Z |
5300626 | 5300626 | 20241012210458_ciDZo | UK00C2 | 2024-10-14T12:14:19.439Z | 2024-10-21T12:23:50.581Z |
5291831 | 5291831 | 20241011220341_3Fnc3 | UK00C2 | 2024-10-13T12:15:17.736Z | 2024-10-20T12:24:36.782Z |
5291519 | 5291519 | 20241011211356_LgoOw | UK00C2 | 2024-10-13T12:14:42.420Z | 2024-10-20T12:24:32.505Z |
5291066 | 5291066 | 20241011195136_cCv15 | UK00C2 | 2024-10-13T12:13:54.529Z | 2024-10-20T12:24:24.848Z |
5290744 | 5290744 | 20241011184949_W3lRe | UK00C2 | 2024-10-13T12:13:14.198Z | 2024-10-20T12:24:19.775Z |
5290685 | 5290685 | 20241011183853_4MNX8 | UK00C2 | 2024-10-13T12:13:05.442Z | 2024-10-20T12:24:18.734Z |
5285440 | 5285440 | 20241011035716_Z39su | UK00C2 | 2024-10-12T12:18:10.027Z | 2024-10-19T12:28:02.713Z |
5282852 | 5282852 | 20241010235805_ZKdJE | UK00C2 | 2024-10-12T12:16:08.025Z | 2024-10-19T12:27:46.941Z |
5282820 | 5282820 | 20241010235036_Mlr1O | UK00C2 | 2024-10-12T12:16:05.309Z | 2024-10-19T12:27:46.733Z |
5282542 | 5282542 | 20241010221439_WRua3 | UK00C2 | 2024-10-12T12:15:43.643Z | 2024-10-19T12:27:44.647Z |
5282488 | 5282488 | 20241010215827_BE5h5 | UK00C2 | 2024-10-12T12:15:37.117Z | 2024-10-19T12:27:44.097Z |
5276879 | 5276879 | 20241011051543_oke7I | UK00C2 | 2024-10-12T12:01:58.554Z | 2024-10-20T12:23:14.888Z |
5276364 | 5276364 | 20241011043444_v7YDU | UK00C2 | 2024-10-12T12:00:56.675Z | 2024-10-20T12:23:08.309Z |
5267415 | 5267415 | 20241008200432_bb2Z0 | UK00C2 | 2024-10-10T12:13:55.975Z | 2024-10-17T12:20:09.154Z |
5247995 | 5247995 | 20241007034207_od4JV | UK00C2 | 2024-10-08T12:01:12.896Z | 2024-10-16T12:20:57.857Z |
5247871 | 5247871 | 20241007032718_6q8H3 | UK00C2 | 2024-10-08T12:00:55.856Z | 2024-10-16T12:20:57.163Z |
5240048 | 5240048 | 20241005045907_r68me | UK00C2 | 2024-10-07T12:07:38.406Z | 2024-10-14T12:24:21.145Z |
5239989 | 5239989 | 20241005044824_9RUg3 | UK00C2 | 2024-10-07T12:07:29.981Z | 2024-10-14T12:24:21.053Z |
5239910 | 5239910 | 20241005043742_1e6nw | UK00C2 | 2024-10-07T12:07:19.625Z | 2024-10-14T12:24:20.968Z |
5239865 | 5239865 | 20241005043458_893bq | UK00C2 | 2024-10-07T12:07:15.572Z | 2024-10-14T12:24:20.864Z |
5239714 | 5239714 | 20241005042248_Bcsrd | UK00C2 | 2024-10-07T12:07:01.857Z | 2024-10-14T12:24:20.661Z |
5239574 | 5239574 | 20241005040952_yFOFI | UK00C2 | 2024-10-07T12:06:41.522Z | 2024-10-14T12:24:19.473Z |
5239405 | 5239405 | 20241005035847_j544O | UK00C2 | 2024-10-07T12:06:23.412Z | 2024-10-14T12:24:19.219Z |
5235988 | 5235988 | 20241005001117_IrpIG | UK00C2 | 2024-10-06T12:17:04.497Z | 2024-10-13T12:26:24.604Z |
5235904 | 5235904 | 20241005000417_6ZGBd | UK00C2 | 2024-10-06T12:17:00.124Z | 2024-10-13T12:26:24.556Z |
5235276 | 5235276 | 20241004231402_EIIvb | UK00C2 | 2024-10-06T12:15:58.129Z | 2024-10-13T12:26:24.077Z |
5227922 | 5227922 | 20241004015558_pNhkt | UK00C2 | 2024-10-05T12:21:42.374Z | 2024-10-12T12:25:13.202Z |
5227487 | 5227487 | 20241004012615_2ZlQF | UK00C2 | 2024-10-05T12:21:33.303Z | 2024-10-12T12:25:12.782Z |
5226927 | 5226927 | 20241004004912_Z95mh | UK00C2 | 2024-10-05T12:21:04.096Z | 2024-10-12T12:25:12.257Z |
5226867 | 5226867 | 20241004004327_iShT5 | UK00C2 | 2024-10-05T12:21:01.898Z | 2024-10-12T12:25:12.223Z |
5225929 | 5225929 | 20241003233007_tNyPH | UK00C2 | 2024-10-05T12:20:18.209Z | 2024-10-12T12:25:10.997Z |
5225640 | 5225640 | 20241003230331_CFph3 | UK00C2 | 2024-10-05T12:19:59.880Z | 2024-10-12T12:25:10.533Z |
5224277 | 5224277 | 20241003201857_tVd6e | UK00C2 | 2024-10-05T12:18:20.671Z | 2024-10-12T12:25:07.837Z |
5224145 | 5224145 | 20241003200804_k02mg | UK00C2 | 2024-10-05T12:18:12.599Z | 2024-10-12T12:25:07.636Z |
5224027 | 5224027 | 20241003195940_shYlE | UK00C2 | 2024-10-05T12:18:07.426Z | 2024-10-12T12:25:07.206Z |
5223796 | 5223796 | 20241003193113_qLwdz | UK00C2 | 2024-10-05T12:17:34.880Z | 2024-10-12T12:25:07.003Z |
5223590 | 5223590 | 20241003190633_YCCIb | UK00C2 | 2024-10-05T12:17:18.249Z | 2024-10-12T12:25:06.700Z |
5219967 | 5219967 | 20241003043228_qI38C | UK00C2 | 2024-10-05T12:09:59.493Z | 2024-10-12T12:24:56.523Z |
5218991 | 5218991 | 20241004042818_2ruZk | UK00C2 | 2024-10-05T12:05:46.767Z | 2024-10-13T12:26:09.317Z |
5217653 | 5217653 | 20241004024405_97Cl3 | UK00C2 | 2024-10-05T12:02:14.236Z | 2024-10-13T12:26:07.234Z |
5216853 | 5216853 | 20241003013100_L22ZY | UK00C2 | 2024-10-04T12:13:51.380Z | 2024-10-11T12:23:37.825Z |
5216493 | 5216493 | 20241003010335_8Y3bk | UK00C2 | 2024-10-04T12:13:20.602Z | 2024-10-11T12:23:37.231Z |
5215799 | 5215799 | 20241003000648_2S2ad | UK00C2 | 2024-10-04T12:12:33.318Z | 2024-10-11T12:23:36.104Z |
5215704 | 5215704 | 20241002235728_x3w9C | UK00C2 | 2024-10-04T12:12:17.531Z | 2024-10-11T12:23:35.896Z |
5215557 | 5215557 | 20241002233808_USrOz | UK00C2 | 2024-10-04T12:11:59.576Z | 2024-10-11T12:23:35.525Z |
5215532 | 5215532 | 20241002233737_g6yrP | UK00C2 | 2024-10-04T12:11:58.174Z | 2024-10-11T12:23:35.508Z |
5215052 | 5215052 | 20241002225216_7PSRr | UK00C2 | 2024-10-04T12:11:15.783Z | 2024-10-11T12:23:34.910Z |
5215032 | 5215032 | 20241002225020_GJmMa | UK00C2 | 2024-10-04T12:11:11.668Z | 2024-10-11T12:23:34.708Z |
5214467 | 5214467 | 20241002214340_AwzwT | UK00C2 | 2024-10-04T12:10:20.693Z | 2024-10-11T12:23:33.659Z |
5214176 | 5214176 | 20241002210159_3Qpqa | UK00C2 | 2024-10-04T12:09:47.327Z | 2024-10-11T12:23:32.870Z |
5214012 | 5214012 | 20241002203427_6Q9KM | UK00C2 | 2024-10-04T12:09:33.112Z | 2024-10-11T12:23:32.475Z |
5212627 | 5212627 | 20241003031254_MyoLF | UK00C2 | 2024-10-04T12:03:27.175Z | 2024-10-12T12:24:54.843Z |
5212515 | 5212515 | 20241003030406_y3ifb | UK00C2 | 2024-10-04T12:03:08.807Z | 2024-10-12T12:24:54.727Z |
5212049 | 5212049 | 20241003023201_clGru | UK00C2 | 2024-10-04T12:02:08.612Z | 2024-10-12T12:24:54.227Z |
5211614 | 5211614 | 20241003020329_9RmFK | UK00C2 | 2024-10-04T12:01:01.786Z | 2024-10-12T12:24:53.737Z |
5211305 | 5211305 | 20241003013447_SBggz | UK00C2 | 2024-10-04T12:00:11.870Z | 2024-10-12T12:24:53.301Z |
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);