participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,795 rows where station_code = "UK004C" 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 |
---|---|---|---|---|---|
5128530 | 5128530 | 20240917015733_gDg1F | UK004C | 2024-09-19T12:10:41.183Z | 2024-09-19T12:10:41.183Z |
5127928 | 5127928 | 20240917000518_ymau4 | UK004C | 2024-09-19T12:09:47.056Z | 2024-09-19T12:09:47.056Z |
5121923 | 5121923 | 20240914042121_Ge34S | UK004C | 2024-09-18T12:11:03.077Z | 2024-09-19T12:20:02.520Z |
5121913 | 5121913 | 20240914042121_KCxWZ | UK004C | 2024-09-18T12:11:03.012Z | 2024-09-19T12:20:02.510Z |
5121794 | 5121794 | 20240914041439_BclDK | UK004C | 2024-09-18T12:11:01.417Z | 2024-09-19T12:20:02.369Z |
5121171 | 5121171 | 20240914035440_zfJJC | UK004C | 2024-09-18T12:10:52.106Z | 2024-09-19T12:20:01.464Z |
5120721 | 5120721 | 20240914033304_2dWFf | UK004C | 2024-09-18T12:10:46.215Z | 2024-09-19T12:20:00.801Z |
5120064 | 5120064 | 20240914025821_3O2iZ | UK004C | 2024-09-18T12:10:31.620Z | 2024-09-19T12:19:59.363Z |
5120009 | 5120009 | 20240914025625_lO87G | UK004C | 2024-09-18T12:10:31.070Z | 2024-09-19T12:19:59.301Z |
5119708 | 5119708 | 20240914024413_3Swqf | UK004C | 2024-09-18T12:10:24.382Z | 2024-09-19T12:19:58.781Z |
5119594 | 5119594 | 20240914023959_ZZWNM | UK004C | 2024-09-18T12:10:22.568Z | 2024-09-19T12:19:58.560Z |
5119466 | 5119466 | 20240914023600_2u6WP | UK004C | 2024-09-18T12:10:21.526Z | 2024-09-19T12:19:58.286Z |
5119415 | 5119415 | 20240914023143_BcW4W | UK004C | 2024-09-18T12:10:20.841Z | 2024-09-19T12:19:58.123Z |
5119400 | 5119400 | 20240914023117_zHIDQ | UK004C | 2024-09-18T12:10:20.763Z | 2024-09-19T12:19:58.115Z |
5119375 | 5119375 | 20240914022955_aPR5h | UK004C | 2024-09-18T12:10:20.652Z | 2024-09-19T12:19:58.099Z |
5117342 | 5117342 | 20240915041928_38V2e | UK004C | 2024-09-18T12:07:38.065Z | 2024-09-19T12:19:14.339Z |
5117315 | 5117315 | 20240915041735_Zsh12 | UK004C | 2024-09-18T12:07:37.736Z | 2024-09-19T12:19:14.272Z |
5116693 | 5116693 | 20240915033705_tV0ex | UK004C | 2024-09-18T12:07:16.862Z | 2024-09-19T12:19:12.048Z |
5116308 | 5116308 | 20240915032028_Q31Uc | UK004C | 2024-09-18T12:06:56.137Z | 2024-09-19T12:19:10.288Z |
5116014 | 5116014 | 20240915030349_gXZnN | UK004C | 2024-09-18T12:06:34.351Z | 2024-09-19T12:19:08.198Z |
5115877 | 5115877 | 20240915025750_tvoiv | UK004C | 2024-09-18T12:06:30.510Z | 2024-09-19T12:19:07.685Z |
5115618 | 5115618 | 20240915024635_3lD3O | UK004C | 2024-09-18T12:06:19.526Z | 2024-09-19T12:19:05.826Z |
5115600 | 5115600 | 20240915024537_rYGdT | UK004C | 2024-09-18T12:06:18.701Z | 2024-09-19T12:19:05.603Z |
5115479 | 5115479 | 20240915024134_YdZw3 | UK004C | 2024-09-18T12:06:15.888Z | 2024-09-19T12:19:04.990Z |
5115354 | 5115354 | 20240915023445_i6H0A | UK004C | 2024-09-18T12:06:11.730Z | 2024-09-19T12:19:04.065Z |
5115315 | 5115315 | 20240915023131_Iwwwa | UK004C | 2024-09-18T12:06:10.554Z | 2024-09-19T12:19:03.871Z |
5114731 | 5114731 | 20240915015715_XXfVt | UK004C | 2024-09-18T12:05:32.268Z | 2024-09-19T12:18:59.675Z |
5114489 | 5114489 | 20240915014441_aDP0R | UK004C | 2024-09-18T12:05:19.775Z | 2024-09-19T12:18:58.558Z |
5114061 | 5114061 | 20240915012355_aWv0t | UK004C | 2024-09-18T12:05:00.226Z | 2024-09-19T12:18:55.509Z |
5113789 | 5113789 | 20240915011351_hmlct | UK004C | 2024-09-18T12:04:50.677Z | 2024-09-19T12:18:52.687Z |
5113757 | 5113757 | 20240915011105_IiwPt | UK004C | 2024-09-18T12:04:49.297Z | 2024-09-19T12:18:51.854Z |
5113246 | 5113246 | 20240915003259_1dwE3 | UK004C | 2024-09-18T12:04:04.682Z | 2024-09-19T12:18:48.268Z |
5112886 | 5112886 | 20240915000407_OizCB | UK004C | 2024-09-18T12:03:45.403Z | 2024-09-19T12:18:45.518Z |
5112849 | 5112849 | 20240915000053_Z12Zb | UK004C | 2024-09-18T12:03:42.599Z | 2024-09-19T12:18:45.297Z |
5112829 | 5112829 | 20240914235929_Bsfpi | UK004C | 2024-09-18T12:03:41.582Z | 2024-09-19T12:18:45.232Z |
5112729 | 5112729 | 20240914234642_5yMMA | UK004C | 2024-09-18T12:03:25.778Z | 2024-09-19T12:18:43.749Z |
5112276 | 5112276 | 20240914225021_LECLE | UK004C | 2024-09-18T12:02:57.965Z | 2024-09-19T12:18:40.293Z |
5112199 | 5112199 | 20240914223551_aQkt1 | UK004C | 2024-09-18T12:02:53.062Z | 2024-09-19T12:18:39.214Z |
5111929 | 5111929 | 20240914214238_Ps1ut | UK004C | 2024-09-18T12:02:31.113Z | 2024-09-19T12:18:35.291Z |
5111680 | 5111680 | 20240914210048_MwtEp | UK004C | 2024-09-18T12:02:10.979Z | 2024-09-19T12:18:33.105Z |
5107757 | 5107757 | 20240913040937_NdYVv | UK004C | 2024-09-17T12:13:23.553Z | 2024-09-19T12:20:47.532Z |
5107597 | 5107597 | 20240913040418_nyTHn | UK004C | 2024-09-17T12:13:17.709Z | 2024-09-19T12:20:47.295Z |
5107288 | 5107288 | 20240913035130_kt4f0 | UK004C | 2024-09-17T12:13:12.670Z | 2024-09-19T12:20:46.986Z |
5107107 | 5107107 | 20240913034502_w3gxO | UK004C | 2024-09-17T12:13:09.360Z | 2024-09-19T12:20:46.842Z |
5106812 | 5106812 | 20240913033538_U5EMJ | UK004C | 2024-09-17T12:13:02.037Z | 2024-09-19T12:20:46.442Z |
5106736 | 5106736 | 20240913033306_XUFcm | UK004C | 2024-09-17T12:13:00.091Z | 2024-09-19T12:20:46.303Z |
5105381 | 5105381 | 20240913024341_ZdaEM | UK004C | 2024-09-17T12:12:12.327Z | 2024-09-19T12:20:44.388Z |
5105194 | 5105194 | 20240913023720_AH0tJ | UK004C | 2024-09-17T12:12:02.316Z | 2024-09-19T12:20:44.109Z |
5104947 | 5104947 | 20240913022446_Dmclr | UK004C | 2024-09-17T12:11:47.351Z | 2024-09-19T12:20:43.130Z |
5104908 | 5104908 | 20240913022346_wH8wQ | UK004C | 2024-09-17T12:11:46.470Z | 2024-09-19T12:20:43.110Z |
5104845 | 5104845 | 20240913022156_n3Bko | UK004C | 2024-09-17T12:11:45.409Z | 2024-09-19T12:20:43.058Z |
5104779 | 5104779 | 20240913022109_NoJDj | UK004C | 2024-09-17T12:11:44.558Z | 2024-09-19T12:20:42.881Z |
5104423 | 5104423 | 20240913020751_1LqQv | UK004C | 2024-09-17T12:11:35.075Z | 2024-09-19T12:20:41.463Z |
5103388 | 5103388 | 20240913012923_cas72 | UK004C | 2024-09-17T12:10:55.750Z | 2024-09-19T12:20:40.140Z |
5103194 | 5103194 | 20240914020407_gEqPb | UK004C | 2024-09-17T12:07:56.967Z | 2024-09-19T12:19:56.806Z |
5102958 | 5102958 | 20240914015535_a14ii | UK004C | 2024-09-17T12:07:45.127Z | 2024-09-19T12:19:56.216Z |
5102838 | 5102838 | 20240914014853_hZZaJ | UK004C | 2024-09-17T12:07:39.243Z | 2024-09-19T12:19:55.858Z |
5102222 | 5102222 | 20240914011225_Ry2D1 | UK004C | 2024-09-17T12:06:55.028Z | 2024-09-19T12:19:52.885Z |
5101826 | 5101826 | 20240914004935_3FFAa | UK004C | 2024-09-17T12:06:15.372Z | 2024-09-19T12:19:51.627Z |
5101786 | 5101786 | 20240914004710_euUEq | UK004C | 2024-09-17T12:06:12.693Z | 2024-09-19T12:19:51.483Z |
5101709 | 5101709 | 20240914004340_8M1TP | UK004C | 2024-09-17T12:06:09.652Z | 2024-09-19T12:19:51.305Z |
5100602 | 5100602 | 20240913233427_ai43h | UK004C | 2024-09-17T12:04:41.257Z | 2024-09-19T12:19:48.188Z |
5100524 | 5100524 | 20240913232936_gqCs2 | UK004C | 2024-09-17T12:04:37.933Z | 2024-09-19T12:19:48.092Z |
5100491 | 5100491 | 20240913232838_Zt08a | UK004C | 2024-09-17T12:04:36.606Z | 2024-09-19T12:19:48.057Z |
5099896 | 5099896 | 20240913222044_FYxaB | UK004C | 2024-09-17T12:03:42.452Z | 2024-09-19T12:19:46.312Z |
5097136 | 5097136 | 20240913003318_ISyzp | UK004C | 2024-09-16T12:17:05.919Z | 2024-09-19T12:20:37.557Z |
5094836 | 5094836 | 20240912042556_x1sh4 | UK004C | 2024-09-16T12:14:59.343Z | 2024-09-19T12:21:16.447Z |
5094734 | 5094734 | 20240912042058_6TkcY | UK004C | 2024-09-16T12:14:57.447Z | 2024-09-19T12:21:16.409Z |
5094392 | 5094392 | 20240912035920_QmQ1B | UK004C | 2024-09-16T12:14:43.287Z | 2024-09-19T12:21:16.100Z |
5094256 | 5094256 | 20240912035433_lV9rG | UK004C | 2024-09-16T12:14:40.103Z | 2024-09-19T12:21:16.046Z |
5094068 | 5094068 | 20240912034644_xtPR0 | UK004C | 2024-09-16T12:14:32.965Z | 2024-09-19T12:21:15.857Z |
5093274 | 5093274 | 20240912031621_Ke8ar | UK004C | 2024-09-16T12:14:14.133Z | 2024-09-19T12:21:15.080Z |
5092894 | 5092894 | 20240912030050_T23ZJ | UK004C | 2024-09-16T12:14:06.433Z | 2024-09-19T12:21:14.652Z |
5092476 | 5092476 | 20240912024711_Z6cC2 | UK004C | 2024-09-16T12:13:57.870Z | 2024-09-19T12:21:14.271Z |
5091570 | 5091570 | 20240912021347_KzsVa | UK004C | 2024-09-16T12:13:11.365Z | 2024-09-19T12:21:13.223Z |
5091490 | 5091490 | 20240912021043_YcOm4 | UK004C | 2024-09-16T12:13:08.153Z | 2024-09-19T12:21:13.091Z |
5091294 | 5091294 | 20240912020419_5ovFE | UK004C | 2024-09-16T12:12:58.572Z | 2024-09-19T12:21:12.742Z |
5090131 | 5090131 | 20240912011204_ejuB8 | UK004C | 2024-09-16T12:12:01.658Z | 2024-09-19T12:21:10.989Z |
5089910 | 5089910 | 20240912010230_ZYdiN | UK004C | 2024-09-16T12:11:49.109Z | 2024-09-19T12:21:10.612Z |
5089009 | 5089009 | 20240912001850_AsJSR | UK004C | 2024-09-16T12:11:11.639Z | 2024-09-19T12:21:09.648Z |
5088848 | 5088848 | 20240913002935_33NUH | UK004C | 2024-09-16T12:08:33.258Z | 2024-09-19T12:20:37.349Z |
5088068 | 5088068 | 20240912235528_jrW6p | UK004C | 2024-09-16T12:07:43.160Z | 2024-09-19T12:20:36.362Z |
5086799 | 5086799 | 20240912224937_N3Wst | UK004C | 2024-09-16T12:06:04.731Z | 2024-09-19T12:20:32.450Z |
5086624 | 5086624 | 20240912224337_yY15b | UK004C | 2024-09-16T12:05:55.098Z | 2024-09-19T12:20:31.465Z |
5086065 | 5086065 | 20240912220621_9beDJ | UK004C | 2024-09-16T12:05:11.671Z | 2024-09-19T12:20:30.095Z |
5080285 | 5080285 | 20240911034706_kHKSc | UK004C | 2024-09-15T12:16:56.431Z | 2024-09-19T12:21:43.159Z |
5080191 | 5080191 | 20240911034257_VRikx | UK004C | 2024-09-15T12:16:53.976Z | 2024-09-19T12:21:43.129Z |
5079903 | 5079903 | 20240911031935_2zmtu | UK004C | 2024-09-15T12:16:40.872Z | 2024-09-19T12:21:42.779Z |
5079888 | 5079888 | 20240911031858_uzQW5 | UK004C | 2024-09-15T12:16:40.439Z | 2024-09-19T12:21:42.771Z |
5079851 | 5079851 | 20240911031601_LpKgU | UK004C | 2024-09-15T12:16:39.010Z | 2024-09-19T12:21:42.701Z |
5079714 | 5079714 | 20240911030821_V2Jap | UK004C | 2024-09-15T12:16:33.995Z | 2024-09-19T12:21:42.564Z |
5079679 | 5079679 | 20240911030745_gyG2P | UK004C | 2024-09-15T12:16:33.009Z | 2024-09-19T12:21:42.556Z |
5079474 | 5079474 | 20240911025748_BLxey | UK004C | 2024-09-15T12:16:22.532Z | 2024-09-19T12:21:42.293Z |
5078987 | 5078987 | 20240911022824_ob4qw | UK004C | 2024-09-15T12:16:01.716Z | 2024-09-19T12:21:40.959Z |
5078832 | 5078832 | 20240911021638_UYqYP | UK004C | 2024-09-15T12:15:52.937Z | 2024-09-19T12:21:40.733Z |
5078749 | 5078749 | 20240911021414_ub6D3 | UK004C | 2024-09-15T12:15:51.031Z | 2024-09-19T12:21:40.695Z |
5078328 | 5078328 | 20240911015100_fSvwA | UK004C | 2024-09-15T12:15:34.127Z | 2024-09-19T12:21:40.234Z |
5078238 | 5078238 | 20240911014424_cmHEk | UK004C | 2024-09-15T12:15:27.369Z | 2024-09-19T12:21:40.102Z |
5077723 | 5077723 | 20240911011302_YqjsE | UK004C | 2024-09-15T12:15:02.233Z | 2024-09-19T12:21:39.575Z |
5077323 | 5077323 | 20240911004436_Ln2n2 | UK004C | 2024-09-15T12:14:38.367Z | 2024-09-19T12:21:38.659Z |
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);