participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,127 rows where station_code = "UK00B1" 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 |
---|---|---|---|---|---|
5592664 | 5592664 | 20241122033357_gCpd7 | UK00B1 | 2024-11-24T14:22:36.957Z | 2024-11-24T14:22:36.957Z |
5592645 | 5592645 | 20241122023433_705pk | UK00B1 | 2024-11-24T14:22:33.380Z | 2024-11-24T14:22:33.380Z |
5582854 | 5582854 | 20241122040249_7cP3d | UK00B1 | 2024-11-23T14:21:21.765Z | 2024-11-24T14:22:38.185Z |
5582786 | 5582786 | 20241122035806_KBvNg | UK00B1 | 2024-11-23T14:21:19.246Z | 2024-11-24T14:22:37.995Z |
5582745 | 5582745 | 20241122035254_WXrgj | UK00B1 | 2024-11-23T14:21:16.638Z | 2024-11-24T14:22:37.878Z |
5582683 | 5582683 | 20241122034954_9pqzn | UK00B1 | 2024-11-23T14:21:14.034Z | 2024-11-24T14:22:37.652Z |
5582625 | 5582625 | 20241122034550_Pyosl | UK00B1 | 2024-11-23T14:21:12.493Z | 2024-11-24T14:22:37.527Z |
5582189 | 5582189 | 20241122031053_W5cp8 | UK00B1 | 2024-11-23T14:20:58.959Z | 2024-11-24T14:22:36.109Z |
5582124 | 5582124 | 20241122030406_PjTdx | UK00B1 | 2024-11-23T14:20:57.218Z | 2024-11-24T14:22:35.883Z |
5582119 | 5582119 | 20241122030349_sP6Es | UK00B1 | 2024-11-23T14:20:57.091Z | 2024-11-24T14:22:35.880Z |
5582074 | 5582074 | 20241122030159_BRPIX | UK00B1 | 2024-11-23T14:20:55.730Z | 2024-11-24T14:22:35.757Z |
5582011 | 5582011 | 20241122025633_3nYKq | UK00B1 | 2024-11-23T14:20:53.869Z | 2024-11-24T14:22:35.546Z |
5581785 | 5581785 | 20241122023432_rrQXx | UK00B1 | 2024-11-23T14:20:43.151Z | 2024-11-24T14:22:33.321Z |
5581763 | 5581763 | 20241122023236_0hKpu | UK00B1 | 2024-11-23T14:20:42.153Z | 2024-11-24T14:22:33.239Z |
5581633 | 5581633 | 20241122022015_D3ku2 | UK00B1 | 2024-11-23T14:20:33.339Z | 2024-11-24T14:22:32.435Z |
5581614 | 5581614 | 20241122021855_nl2IF | UK00B1 | 2024-11-23T14:20:33.011Z | 2024-11-24T14:22:32.295Z |
5581593 | 5581593 | 20241122021605_00jUU | UK00B1 | 2024-11-23T14:20:32.456Z | 2024-11-24T14:22:32.210Z |
5581467 | 5581467 | 20241122020518_fqZ1M | UK00B1 | 2024-11-23T14:20:24.701Z | 2024-11-24T14:22:31.845Z |
5581244 | 5581244 | 20241122014716_v0Ife | UK00B1 | 2024-11-23T14:20:11.010Z | 2024-11-24T14:22:31.096Z |
5581163 | 5581163 | 20241122014332_i3tzP | UK00B1 | 2024-11-23T14:20:08.220Z | 2024-11-24T14:22:30.922Z |
5581104 | 5581104 | 20241122014116_kBVAW | UK00B1 | 2024-11-23T14:20:03.947Z | 2024-11-24T14:22:30.730Z |
5581089 | 5581089 | 20241122014028_R02J4 | UK00B1 | 2024-11-23T14:20:03.500Z | 2024-11-24T14:22:30.691Z |
5581079 | 5581079 | 20241122013924_zvNC6 | UK00B1 | 2024-11-23T14:20:03.343Z | 2024-11-24T14:22:30.675Z |
5581068 | 5581068 | 20241122013826_vZedG | UK00B1 | 2024-11-23T14:20:02.785Z | 2024-11-24T14:22:30.661Z |
5581020 | 5581020 | 20241122013457_JJ93F | UK00B1 | 2024-11-23T14:19:59.556Z | 2024-11-24T14:22:30.537Z |
5581006 | 5581006 | 20241122013446_z62r0 | UK00B1 | 2024-11-23T14:19:58.219Z | 2024-11-24T14:22:30.500Z |
5580905 | 5580905 | 20241122012233_gxfns | UK00B1 | 2024-11-23T14:19:49.819Z | 2024-11-24T14:22:30.187Z |
5580773 | 5580773 | 20241122011219_xP381 | UK00B1 | 2024-11-23T14:19:41.336Z | 2024-11-24T14:22:29.688Z |
5580764 | 5580764 | 20241122011154_yJOaH | UK00B1 | 2024-11-23T14:19:41.150Z | 2024-11-24T14:22:29.673Z |
5580754 | 5580754 | 20241122011108_C3DnD | UK00B1 | 2024-11-23T14:19:40.950Z | 2024-11-24T14:22:29.637Z |
5580222 | 5580222 | 20241122001810_2OL2e | UK00B1 | 2024-11-23T14:19:11.988Z | 2024-11-24T14:22:27.691Z |
5579940 | 5579940 | 20241121233622_9hVnR | UK00B1 | 2024-11-23T14:18:57.009Z | 2024-11-24T14:22:26.582Z |
5579899 | 5579899 | 20241121233401_kKKki | UK00B1 | 2024-11-23T14:18:55.213Z | 2024-11-24T14:22:26.443Z |
5579689 | 5579689 | 20241121230742_lkx9A | UK00B1 | 2024-11-23T14:18:43.095Z | 2024-11-24T14:22:25.820Z |
5578978 | 5578978 | 20241121212942_B4cdE | UK00B1 | 2024-11-23T14:17:42.373Z | 2024-11-24T14:22:23.071Z |
5578914 | 5578914 | 20241121211922_3mSq3 | UK00B1 | 2024-11-23T14:17:38.334Z | 2024-11-24T14:22:22.763Z |
5578824 | 5578824 | 20241121210538_xkpmY | UK00B1 | 2024-11-23T14:17:34.975Z | 2024-11-24T14:22:22.349Z |
5578647 | 5578647 | 20241121203856_Dn8QV | UK00B1 | 2024-11-23T14:17:26.361Z | 2024-11-24T14:22:21.469Z |
5577868 | 5577868 | 20241121180624_2GbIr | UK00B1 | 2024-11-23T14:16:11.566Z | 2024-11-24T14:22:17.636Z |
5577800 | 5577800 | 20241121175945_o2BSc | UK00B1 | 2024-11-23T14:16:01.535Z | 2024-11-24T14:22:17.176Z |
5577616 | 5577616 | 20241121172354_y86pz | UK00B1 | 2024-11-23T14:15:31.071Z | 2024-11-24T14:22:15.937Z |
5574689 | 5574689 | 20241122061347_C0AqM | UK00B1 | 2024-11-23T14:04:06.625Z | 2024-11-24T14:21:10.102Z |
5574603 | 5574603 | 20241122060308_GNAg8 | UK00B1 | 2024-11-23T14:03:46.885Z | 2024-11-24T14:21:10.086Z |
5574482 | 5574482 | 20241122054910_lqYxO | UK00B1 | 2024-11-23T14:03:31.131Z | 2024-11-24T14:21:10.062Z |
5574362 | 5574362 | 20241122053733_QVYJh | UK00B1 | 2024-11-23T14:03:06.399Z | 2024-11-24T14:21:10.037Z |
5574285 | 5574285 | 20241122053132_KW1zN | UK00B1 | 2024-11-23T14:02:57.909Z | 2024-11-24T14:21:10.025Z |
5574268 | 5574268 | 20241122053025_530xh | UK00B1 | 2024-11-23T14:02:56.618Z | 2024-11-24T14:21:10.022Z |
5574195 | 5574195 | 20241122052054_EcVyA | UK00B1 | 2024-11-23T14:02:43.188Z | 2024-11-24T14:21:10.009Z |
5573991 | 5573991 | 20241122045838_6I1qx | UK00B1 | 2024-11-23T14:02:05.764Z | 2024-11-24T14:21:09.926Z |
5573529 | 5573529 | 20241122042312_hA3kT | UK00B1 | 2024-11-23T14:00:44.334Z | 2024-11-24T14:21:09.845Z |
5573504 | 5573504 | 20241122042238_vcTYu | UK00B1 | 2024-11-23T14:00:40.554Z | 2024-11-24T14:21:09.841Z |
5573486 | 5573486 | 20241122042014_XxQS8 | UK00B1 | 2024-11-23T14:00:38.189Z | 2024-11-24T14:21:09.838Z |
5573464 | 5573464 | 20241122041908_crsFZ | UK00B1 | 2024-11-23T14:00:36.707Z | 2024-11-24T14:21:09.836Z |
5573443 | 5573443 | 20241122041838_ozhC5 | UK00B1 | 2024-11-23T14:00:32.572Z | 2024-11-24T14:21:09.834Z |
5573374 | 5573374 | 20241122041434_F5eSt | UK00B1 | 2024-11-23T14:00:23.941Z | 2024-11-24T14:21:09.823Z |
5573367 | 5573367 | 20241122041336_i8n2E | UK00B1 | 2024-11-23T14:00:22.819Z | 2024-11-24T14:21:09.821Z |
5573348 | 5573348 | 20241122041053_YV9gV | UK00B1 | 2024-11-23T14:00:20.146Z | 2024-11-24T14:21:09.819Z |
5569972 | 5569972 | 20241120181410_o3L1o | UK00B1 | 2024-11-22T14:14:42.078Z | 2024-11-24T14:23:27.442Z |
5569853 | 5569853 | 20241120174744_8IZwX | UK00B1 | 2024-11-22T14:14:28.141Z | 2024-11-24T14:23:25.362Z |
5569788 | 5569788 | 20241120173150_X66Wl | UK00B1 | 2024-11-22T14:14:11.016Z | 2024-11-24T14:23:23.945Z |
5565457 | 5565457 | 20241120042807_EXWOu | UK00B1 | 2024-11-21T14:18:49.803Z | 2024-11-24T14:24:47.174Z |
5565387 | 5565387 | 20241120042154_CgFDk | UK00B1 | 2024-11-21T14:18:47.606Z | 2024-11-24T14:24:46.984Z |
5565361 | 5565361 | 20241120042104_qtf2g | UK00B1 | 2024-11-21T14:18:47.168Z | 2024-11-24T14:24:46.929Z |
5565269 | 5565269 | 20241120040847_2Crxx | UK00B1 | 2024-11-21T14:18:44.082Z | 2024-11-24T14:24:46.494Z |
5565081 | 5565081 | 20241120035033_rvX54 | UK00B1 | 2024-11-21T14:18:28.545Z | 2024-11-24T14:24:45.783Z |
5565045 | 5565045 | 20241120034535_3lqSv | UK00B1 | 2024-11-21T14:18:23.436Z | 2024-11-24T14:24:45.656Z |
5565003 | 5565003 | 20241120034414_un24h | UK00B1 | 2024-11-21T14:18:18.614Z | 2024-11-24T14:24:45.459Z |
5564593 | 5564593 | 20241120031131_8wxDl | UK00B1 | 2024-11-21T14:17:52.061Z | 2024-11-24T14:24:43.472Z |
5564549 | 5564549 | 20241120030747_TluGP | UK00B1 | 2024-11-21T14:17:47.687Z | 2024-11-24T14:24:43.335Z |
5564522 | 5564522 | 20241120030621_d77nL | UK00B1 | 2024-11-21T14:17:45.392Z | 2024-11-24T14:24:43.213Z |
5564105 | 5564105 | 20241120022833_wJJzG | UK00B1 | 2024-11-21T14:17:09.904Z | 2024-11-24T14:24:40.720Z |
5563886 | 5563886 | 20241120021216_RHPRj | UK00B1 | 2024-11-21T14:16:53.430Z | 2024-11-24T14:24:39.542Z |
5563735 | 5563735 | 20241120015950_5OPoV | UK00B1 | 2024-11-21T14:16:36.883Z | 2024-11-24T14:24:39.013Z |
5563644 | 5563644 | 20241120015409_NDtD6 | UK00B1 | 2024-11-21T14:16:31.286Z | 2024-11-24T14:24:38.502Z |
5563601 | 5563601 | 20241120015033_n2fMe | UK00B1 | 2024-11-21T14:16:26.527Z | 2024-11-24T14:24:38.167Z |
5562191 | 5562191 | 20241119230853_SBsHs | UK00B1 | 2024-11-21T14:14:31.459Z | 2024-11-24T14:24:31.282Z |
5558453 | 5558453 | 20241120060552_0RyG1 | UK00B1 | 2024-11-21T14:03:17.251Z | 2024-11-24T14:22:51.963Z |
5558427 | 5558427 | 20241120060333_SdPOj | UK00B1 | 2024-11-21T14:03:14.171Z | 2024-11-24T14:22:51.595Z |
5558413 | 5558413 | 20241120060228_5NrA2 | UK00B1 | 2024-11-21T14:03:13.141Z | 2024-11-24T14:22:51.435Z |
5558365 | 5558365 | 20241120055924_KFYWV | UK00B1 | 2024-11-21T14:03:08.048Z | 2024-11-24T14:22:50.994Z |
5558168 | 5558168 | 20241120054136_fR05W | UK00B1 | 2024-11-21T14:02:38.617Z | 2024-11-24T14:22:48.540Z |
5558069 | 5558069 | 20241120053426_zGDiR | UK00B1 | 2024-11-21T14:02:26.215Z | 2024-11-24T14:22:47.646Z |
5557858 | 5557858 | 20241120052001_3ou34 | UK00B1 | 2024-11-21T14:01:57.630Z | 2024-11-24T14:22:45.461Z |
5557619 | 5557619 | 20241120050159_45ldZ | UK00B1 | 2024-11-21T14:01:22.940Z | 2024-11-24T14:22:43.192Z |
5557531 | 5557531 | 20241120045342_7SdTj | UK00B1 | 2024-11-21T14:01:05.740Z | 2024-11-24T14:22:41.729Z |
5557349 | 5557349 | 20241120043954_wkyXy | UK00B1 | 2024-11-21T14:00:35.024Z | 2024-11-24T14:22:40.038Z |
5557292 | 5557292 | 20241120043404_uUNLx | UK00B1 | 2024-11-21T14:00:23.603Z | 2024-11-24T14:22:39.827Z |
5532684 | 5532684 | 20241112055201_cRjHr | UK00B1 | 2024-11-13T14:17:08.893Z | 2024-11-20T14:26:25.607Z |
5532478 | 5532478 | 20241112052812_4BBgp | UK00B1 | 2024-11-13T14:16:51.697Z | 2024-11-20T14:26:23.824Z |
5532405 | 5532405 | 20241112051837_2jsja | UK00B1 | 2024-11-13T14:16:42.683Z | 2024-11-20T14:26:22.712Z |
5532359 | 5532359 | 20241112051319_SUlgr | UK00B1 | 2024-11-13T14:16:39.089Z | 2024-11-20T14:26:22.210Z |
5532034 | 5532034 | 20241112042949_8TC83 | UK00B1 | 2024-11-13T14:16:11.580Z | 2024-11-20T14:26:17.637Z |
5531980 | 5531980 | 20241112042426_5goly | UK00B1 | 2024-11-13T14:16:05.340Z | 2024-11-20T14:26:16.714Z |
5531801 | 5531801 | 20241112040959_4QB9e | UK00B1 | 2024-11-13T14:15:55.501Z | 2024-11-20T14:26:14.594Z |
5531769 | 5531769 | 20241112040804_KiYVV | UK00B1 | 2024-11-13T14:15:54.201Z | 2024-11-20T14:26:14.216Z |
5531532 | 5531532 | 20241112034705_xDmWY | UK00B1 | 2024-11-13T14:15:43.905Z | 2024-11-20T14:26:12.095Z |
5531459 | 5531459 | 20241112034035_XVcr2 | UK00B1 | 2024-11-13T14:15:40.505Z | 2024-11-20T14:26:11.374Z |
5531438 | 5531438 | 20241112033941_tNiRL | UK00B1 | 2024-11-13T14:15:39.491Z | 2024-11-20T14:26:11.279Z |
5530979 | 5530979 | 20241112030334_xk9Lx | UK00B1 | 2024-11-13T14:14:57.361Z | 2024-11-20T14:26:05.737Z |
5530763 | 5530763 | 20241112024446_pFr11 | UK00B1 | 2024-11-13T14:14:34.689Z | 2024-11-20T14:26:03.010Z |
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);