participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,455 rows where station_code = "UK004R" 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 |
---|---|---|---|---|---|
5129864 | 5129864 | 20240917044638_fk6yF | UK004R | 2024-09-19T12:12:11.261Z | 2024-09-19T12:12:11.261Z |
5129689 | 5129689 | 20240917042252_kfpAb | UK004R | 2024-09-19T12:12:01.119Z | 2024-09-19T12:12:01.119Z |
5129645 | 5129645 | 20240917041727_QS9kK | UK004R | 2024-09-19T12:11:57.899Z | 2024-09-19T12:11:57.899Z |
5129582 | 5129582 | 20240917041110_SqkSJ | UK004R | 2024-09-19T12:11:50.357Z | 2024-09-19T12:11:50.357Z |
5117499 | 5117499 | 20240915044717_IPa6D | UK004R | 2024-09-18T12:07:43.305Z | 2024-09-19T12:19:15.487Z |
5117423 | 5117423 | 20240915043237_MSlzq | UK004R | 2024-09-18T12:07:41.301Z | 2024-09-19T12:19:15.024Z |
5117417 | 5117417 | 20240915043152_5Ef2C | UK004R | 2024-09-18T12:07:41.183Z | 2024-09-19T12:19:15.013Z |
5117103 | 5117103 | 20240915040250_U52LG | UK004R | 2024-09-18T12:07:32.803Z | 2024-09-19T12:19:13.386Z |
5116950 | 5116950 | 20240915035119_yDVH0 | UK004R | 2024-09-18T12:07:26.631Z | 2024-09-19T12:19:12.813Z |
5116861 | 5116861 | 20240915034432_ESaip | UK004R | 2024-09-18T12:07:22.788Z | 2024-09-19T12:19:12.471Z |
5116527 | 5116527 | 20240915033058_N4Qn0 | UK004R | 2024-09-18T12:07:08.914Z | 2024-09-19T12:19:11.485Z |
5116251 | 5116251 | 20240915031804_0fR6w | UK004R | 2024-09-18T12:06:51.127Z | 2024-09-19T12:19:09.970Z |
5115988 | 5115988 | 20240915030242_kxnSo | UK004R | 2024-09-18T12:06:33.544Z | 2024-09-19T12:19:08.090Z |
5115947 | 5115947 | 20240915030121_uw3zb | UK004R | 2024-09-18T12:06:32.482Z | 2024-09-19T12:19:07.960Z |
5115857 | 5115857 | 20240915025624_ZUmTm | UK004R | 2024-09-18T12:06:29.365Z | 2024-09-19T12:19:07.574Z |
5115716 | 5115716 | 20240915025047_8SkHQ | UK004R | 2024-09-18T12:06:22.018Z | 2024-09-19T12:19:06.513Z |
5115651 | 5115651 | 20240915024711_AbFZ5 | UK004R | 2024-09-18T12:06:20.400Z | 2024-09-19T12:19:06.031Z |
5115534 | 5115534 | 20240915024423_gIPQx | UK004R | 2024-09-18T12:06:17.449Z | 2024-09-19T12:19:05.221Z |
5115383 | 5115383 | 20240915023529_Hs9Pi | UK004R | 2024-09-18T12:06:12.281Z | 2024-09-19T12:19:04.150Z |
5114996 | 5114996 | 20240915021309_nvDxB | UK004R | 2024-09-18T12:05:50.408Z | 2024-09-19T12:19:01.113Z |
5114469 | 5114469 | 20240915014359_AoEVk | UK004R | 2024-09-18T12:05:19.175Z | 2024-09-19T12:18:58.450Z |
5114314 | 5114314 | 20240915013637_urfjS | UK004R | 2024-09-18T12:05:10.561Z | 2024-09-19T12:18:57.540Z |
5114106 | 5114106 | 20240915012713_aniW3 | UK004R | 2024-09-18T12:05:02.374Z | 2024-09-19T12:18:56.084Z |
5113164 | 5113164 | 20240915002907_K7egW | UK004R | 2024-09-18T12:04:00.574Z | 2024-09-19T12:18:47.736Z |
5112508 | 5112508 | 20240914232405_qfREx | UK004R | 2024-09-18T12:03:11.117Z | 2024-09-19T12:18:41.212Z |
5112500 | 5112500 | 20240914232157_EP6sA | UK004R | 2024-09-18T12:03:10.950Z | 2024-09-19T12:18:41.190Z |
5112043 | 5112043 | 20240914220210_xrEsu | UK004R | 2024-09-18T12:02:43.386Z | 2024-09-19T12:18:37.172Z |
5111972 | 5111972 | 20240914214849_4oPa0 | UK004R | 2024-09-18T12:02:34.408Z | 2024-09-19T12:18:35.960Z |
5111941 | 5111941 | 20240914214431_3hy7d | UK004R | 2024-09-18T12:02:31.384Z | 2024-09-19T12:18:35.440Z |
5111877 | 5111877 | 20240914213012_Wk3ui | UK004R | 2024-09-18T12:02:28.267Z | 2024-09-19T12:18:34.845Z |
5111810 | 5111810 | 20240914211815_Ejih7 | UK004R | 2024-09-18T12:02:18.313Z | 2024-09-19T12:18:34.067Z |
5111673 | 5111673 | 20240914205932_LUdP1 | UK004R | 2024-09-18T12:02:10.471Z | 2024-09-19T12:18:32.871Z |
5111632 | 5111632 | 20240914205731_4w1Kg | UK004R | 2024-09-18T12:02:08.795Z | 2024-09-19T12:18:32.642Z |
5111395 | 5111395 | 20240914203230_zzwlw | UK004R | 2024-09-18T12:01:54.100Z | 2024-09-19T12:18:29.880Z |
5111342 | 5111342 | 20240914202324_0FQgK | UK004R | 2024-09-18T12:01:50.509Z | 2024-09-19T12:18:29.146Z |
5111277 | 5111277 | 20240914201530_Q2eI8 | UK004R | 2024-09-18T12:01:46.885Z | 2024-09-19T12:18:28.344Z |
5111243 | 5111243 | 20240914201405_GQTM7 | UK004R | 2024-09-18T12:01:44.896Z | 2024-09-19T12:18:28.007Z |
5108271 | 5108271 | 20240913043838_875oU | UK004R | 2024-09-17T12:13:34.586Z | 2024-09-19T12:20:47.991Z |
5108251 | 5108251 | 20240913043626_l4o2z | UK004R | 2024-09-17T12:13:34.163Z | 2024-09-19T12:20:47.975Z |
5108205 | 5108205 | 20240913043131_d3Xeq | UK004R | 2024-09-17T12:13:32.534Z | 2024-09-19T12:20:47.917Z |
5108128 | 5108128 | 20240913042431_77a6a | UK004R | 2024-09-17T12:13:30.924Z | 2024-09-19T12:20:47.857Z |
5107990 | 5107990 | 20240913041811_55fbX | UK004R | 2024-09-17T12:13:26.941Z | 2024-09-19T12:20:47.709Z |
5107725 | 5107725 | 20240913040923_Amflw | UK004R | 2024-09-17T12:13:22.523Z | 2024-09-19T12:20:47.507Z |
5107606 | 5107606 | 20240913040428_u8c5x | UK004R | 2024-09-17T12:13:18.887Z | 2024-09-19T12:20:47.330Z |
5107559 | 5107559 | 20240913040104_HZK8i | UK004R | 2024-09-17T12:13:17.040Z | 2024-09-19T12:20:47.222Z |
5107422 | 5107422 | 20240913035541_FeQAp | UK004R | 2024-09-17T12:13:15.028Z | 2024-09-19T12:20:47.134Z |
5107063 | 5107063 | 20240913034300_srWkV | UK004R | 2024-09-17T12:13:08.729Z | 2024-09-19T12:20:46.798Z |
5105448 | 5105448 | 20240913024656_Bg793 | UK004R | 2024-09-17T12:12:17.751Z | 2024-09-19T12:20:44.553Z |
5105338 | 5105338 | 20240913024202_DYPRX | UK004R | 2024-09-17T12:12:10.181Z | 2024-09-19T12:20:44.307Z |
5105272 | 5105272 | 20240913024028_UF3A3 | UK004R | 2024-09-17T12:12:08.089Z | 2024-09-19T12:20:44.235Z |
5104439 | 5104439 | 20240913021014_RwRim | UK004R | 2024-09-17T12:11:35.522Z | 2024-09-19T12:20:41.481Z |
5104389 | 5104389 | 20240913020703_6fIhb | UK004R | 2024-09-17T12:11:34.273Z | 2024-09-19T12:20:41.438Z |
5098201 | 5098201 | 20240913012201_Wm6P1 | UK004R | 2024-09-16T12:17:21.631Z | 2024-09-19T12:20:39.852Z |
5098116 | 5098116 | 20240913011906_oVg3e | UK004R | 2024-09-16T12:17:19.616Z | 2024-09-19T12:20:39.691Z |
5097963 | 5097963 | 20240913011033_axzhn | UK004R | 2024-09-16T12:17:17.379Z | 2024-09-19T12:20:39.229Z |
5097734 | 5097734 | 20240913010027_vBlOm | UK004R | 2024-09-16T12:17:14.276Z | 2024-09-19T12:20:38.928Z |
5097491 | 5097491 | 20240913005148_l6Qiu | UK004R | 2024-09-16T12:17:12.983Z | 2024-09-19T12:20:38.659Z |
5097274 | 5097274 | 20240913003832_Ye3ds | UK004R | 2024-09-16T12:17:09.387Z | 2024-09-19T12:20:38.025Z |
5097228 | 5097228 | 20240913003801_BEkTf | UK004R | 2024-09-16T12:17:08.666Z | 2024-09-19T12:20:37.920Z |
5088776 | 5088776 | 20240913002655_rOw3A | UK004R | 2024-09-16T12:08:30.066Z | 2024-09-19T12:20:37.289Z |
5088762 | 5088762 | 20240913002554_92QQg | UK004R | 2024-09-16T12:08:29.614Z | 2024-09-19T12:20:37.274Z |
5088168 | 5088168 | 20240913000050_qmeo3 | UK004R | 2024-09-16T12:07:47.172Z | 2024-09-19T12:20:36.470Z |
5088102 | 5088102 | 20240912235554_8BJJs | UK004R | 2024-09-16T12:07:43.688Z | 2024-09-19T12:20:36.367Z |
5088090 | 5088090 | 20240912235536_32M8L | UK004R | 2024-09-16T12:07:43.468Z | 2024-09-19T12:20:36.366Z |
5088055 | 5088055 | 20240912235516_aIg3B | UK004R | 2024-09-16T12:07:42.837Z | 2024-09-19T12:20:36.328Z |
5087818 | 5087818 | 20240912234509_yo2lv | UK004R | 2024-09-16T12:07:29.828Z | 2024-09-19T12:20:35.681Z |
5087458 | 5087458 | 20240912232817_KTxO8 | UK004R | 2024-09-16T12:06:56.967Z | 2024-09-19T12:20:35.034Z |
5087415 | 5087415 | 20240912232647_kEZSY | UK004R | 2024-09-16T12:06:55.583Z | 2024-09-19T12:20:34.822Z |
5087269 | 5087269 | 20240912232030_wWlZ2 | UK004R | 2024-09-16T12:06:50.336Z | 2024-09-19T12:20:34.547Z |
5087026 | 5087026 | 20240912230338_2WxZp | UK004R | 2024-09-16T12:06:26.625Z | 2024-09-19T12:20:33.586Z |
5087003 | 5087003 | 20240912230105_5qCpS | UK004R | 2024-09-16T12:06:23.092Z | 2024-09-19T12:20:33.411Z |
5086889 | 5086889 | 20240912225351_Y27vi | UK004R | 2024-09-16T12:06:11.384Z | 2024-09-19T12:20:32.931Z |
5086871 | 5086871 | 20240912225324_GIaug | UK004R | 2024-09-16T12:06:10.744Z | 2024-09-19T12:20:32.790Z |
5086327 | 5086327 | 20240912222839_pIQMS | UK004R | 2024-09-16T12:05:35.311Z | 2024-09-19T12:20:30.904Z |
5085788 | 5085788 | 20240912215137_JP7UV | UK004R | 2024-09-16T12:04:55.957Z | 2024-09-19T12:20:29.623Z |
5085769 | 5085769 | 20240912215035_SmROL | UK004R | 2024-09-16T12:04:54.403Z | 2024-09-19T12:20:29.586Z |
5085753 | 5085753 | 20240912214934_WTFtg | UK004R | 2024-09-16T12:04:53.226Z | 2024-09-19T12:20:29.575Z |
5085556 | 5085556 | 20240912212919_t3mVX | UK004R | 2024-09-16T12:04:23.859Z | 2024-09-19T12:20:29.044Z |
5085281 | 5085281 | 20240912210612_ZHC2N | UK004R | 2024-09-16T12:03:50.658Z | 2024-09-19T12:20:28.319Z |
5026519 | 5026519 | 20240905035030_mGSty | UK004R | 2024-09-11T12:12:39.957Z | 2024-09-13T12:19:58.566Z |
5020979 | 5020979 | 20240905035030_CwQsY | UK004R | 2024-09-10T12:15:09.923Z | 2024-09-10T12:16:55.285Z |
4786890 | 4786890 | 20240802032313_h8PTN | UK004R | 2024-08-11T12:00:12.702Z | 2024-08-13T12:15:09.416Z |
4779870 | 4779870 | 20240801012329_sMTlY | UK004R | 2024-08-07T12:14:43.971Z | 2024-08-10T12:21:41.209Z |
4779446 | 4779446 | 20240801004237_ZbXBV | UK004R | 2024-08-07T12:14:28.521Z | 2024-08-10T12:21:29.394Z |
4779376 | 4779376 | 20240801003729_PnIEX | UK004R | 2024-08-07T12:14:25.899Z | 2024-08-10T12:21:28.270Z |
4771378 | 4771378 | 20240731011007_cf2VH | UK004R | 2024-08-06T12:14:14.541Z | 2024-08-08T12:25:22.101Z |
4771251 | 4771251 | 20240731010119_oaOSn | UK004R | 2024-08-06T12:14:12.560Z | 2024-08-08T12:25:20.920Z |
4771122 | 4771122 | 20240731005646_Clf2W | UK004R | 2024-08-06T12:14:10.165Z | 2024-08-08T12:25:18.946Z |
4771115 | 4771115 | 20240731005607_T6qaD | UK004R | 2024-08-06T12:14:10.044Z | 2024-08-08T12:25:18.834Z |
4771041 | 4771041 | 20240731005246_olqji | UK004R | 2024-08-06T12:14:08.760Z | 2024-08-08T12:25:17.918Z |
4770870 | 4770870 | 20240731004531_Q6z19 | UK004R | 2024-08-06T12:14:05.295Z | 2024-08-08T12:25:15.931Z |
4770786 | 4770786 | 20240731004030_omKZr | UK004R | 2024-08-06T12:14:04.607Z | 2024-08-08T12:25:15.128Z |
4770610 | 4770610 | 20240731003215_K3XJu | UK004R | 2024-08-06T12:14:02.211Z | 2024-08-08T12:25:13.039Z |
4770376 | 4770376 | 20240731002115_DqYci | UK004R | 2024-08-06T12:13:58.771Z | 2024-08-08T12:25:08.448Z |
4763045 | 4763045 | 20240731032136_TcvQD | UK004R | 2024-08-06T12:03:37.794Z | 2024-08-10T12:18:04.385Z |
4763041 | 4763041 | 20240731032119_g9HIK | UK004R | 2024-08-06T12:03:37.347Z | 2024-08-10T12:18:04.081Z |
4763024 | 4763024 | 20240731031443_2dBsE | UK004R | 2024-08-06T12:03:36.004Z | 2024-08-10T12:18:03.661Z |
4763018 | 4763018 | 20240731031300_2hSKN | UK004R | 2024-08-06T12:03:35.599Z | 2024-08-10T12:18:03.568Z |
4762992 | 4762992 | 20240731030647_kzktn | UK004R | 2024-08-06T12:03:32.922Z | 2024-08-10T12:18:02.862Z |
4762979 | 4762979 | 20240731030407_fZPvi | UK004R | 2024-08-06T12:03:31.565Z | 2024-08-10T12:18:02.482Z |
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);