participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,990 rows where station_code = "UK002K" 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 |
---|---|---|---|---|---|
5133974 | 5133974 | 20240916042433_0Twgx | UK002K | 2024-09-19T12:17:15.220Z | 2024-09-19T12:17:15.220Z |
5133946 | 5133946 | 20240916041942_aX270 | UK002K | 2024-09-19T12:17:13.871Z | 2024-09-19T12:17:13.871Z |
5133900 | 5133900 | 20240916041710_QOsCQ | UK002K | 2024-09-19T12:17:12.819Z | 2024-09-19T12:17:12.819Z |
5133888 | 5133888 | 20240916041432_8bXnQ | UK002K | 2024-09-19T12:17:12.235Z | 2024-09-19T12:17:12.235Z |
5133795 | 5133795 | 20240916040600_rfa4F | UK002K | 2024-09-19T12:17:08.259Z | 2024-09-19T12:17:08.259Z |
5133609 | 5133609 | 20240916034744_63kze | UK002K | 2024-09-19T12:17:03.806Z | 2024-09-19T12:17:03.806Z |
5133583 | 5133583 | 20240916034306_cj0dS | UK002K | 2024-09-19T12:17:02.268Z | 2024-09-19T12:17:02.268Z |
5133517 | 5133517 | 20240916033624_CKW3Z | UK002K | 2024-09-19T12:17:00.429Z | 2024-09-19T12:17:00.429Z |
5133197 | 5133197 | 20240916030635_NyQ6D | UK002K | 2024-09-19T12:16:48.470Z | 2024-09-19T12:16:48.470Z |
5132868 | 5132868 | 20240916022411_GKFz3 | UK002K | 2024-09-19T12:16:35.065Z | 2024-09-19T12:16:35.065Z |
5132840 | 5132840 | 20240916022134_cUpiw | UK002K | 2024-09-19T12:16:34.403Z | 2024-09-19T12:16:34.403Z |
5132782 | 5132782 | 20240916021209_Der22 | UK002K | 2024-09-19T12:16:32.725Z | 2024-09-19T12:16:32.725Z |
5132743 | 5132743 | 20240916020416_4EYn6 | UK002K | 2024-09-19T12:16:30.619Z | 2024-09-19T12:16:30.619Z |
5132734 | 5132734 | 20240916020339_UArj4 | UK002K | 2024-09-19T12:16:30.116Z | 2024-09-19T12:16:30.116Z |
5132638 | 5132638 | 20240916014919_jECKZ | UK002K | 2024-09-19T12:16:24.111Z | 2024-09-19T12:16:24.111Z |
5132623 | 5132623 | 20240916014701_Xhiys | UK002K | 2024-09-19T12:16:23.353Z | 2024-09-19T12:16:23.353Z |
5132496 | 5132496 | 20240916011841_r8Re2 | UK002K | 2024-09-19T12:16:15.477Z | 2024-09-19T12:16:15.477Z |
5132365 | 5132365 | 20240916005201_5RaLE | UK002K | 2024-09-19T12:16:09.672Z | 2024-09-19T12:16:09.672Z |
5132362 | 5132362 | 20240916005201_G2aMl | UK002K | 2024-09-19T12:16:09.444Z | 2024-09-19T12:16:09.444Z |
5132342 | 5132342 | 20240916004138_cpE2E | UK002K | 2024-09-19T12:16:08.250Z | 2024-09-19T12:16:08.250Z |
5132258 | 5132258 | 20240916001321_0n1p8 | UK002K | 2024-09-19T12:16:02.199Z | 2024-09-19T12:16:02.199Z |
5132246 | 5132246 | 20240916001010_S7lSY | UK002K | 2024-09-19T12:16:00.393Z | 2024-09-19T12:16:00.393Z |
5132114 | 5132114 | 20240915232657_yRbn8 | UK002K | 2024-09-19T12:15:51.044Z | 2024-09-19T12:15:51.044Z |
5132101 | 5132101 | 20240915232241_ypDdu | UK002K | 2024-09-19T12:15:50.407Z | 2024-09-19T12:15:50.407Z |
5132056 | 5132056 | 20240915225807_0pz6L | UK002K | 2024-09-19T12:15:47.035Z | 2024-09-19T12:15:47.035Z |
5131864 | 5131864 | 20240915215918_6YvZK | UK002K | 2024-09-19T12:15:32.083Z | 2024-09-19T12:15:32.083Z |
5129638 | 5129638 | 20240917041612_ynGtz | UK002K | 2024-09-19T12:11:56.928Z | 2024-09-19T12:11:56.928Z |
5129447 | 5129447 | 20240917035734_Cwva2 | UK002K | 2024-09-19T12:11:38.671Z | 2024-09-19T12:11:38.671Z |
5129329 | 5129329 | 20240917034940_Z32Lr | UK002K | 2024-09-19T12:11:29.344Z | 2024-09-19T12:11:29.344Z |
5129160 | 5129160 | 20240917033110_TQgm4 | UK002K | 2024-09-19T12:11:18.879Z | 2024-09-19T12:11:18.879Z |
5128973 | 5128973 | 20240917030311_NmY68 | UK002K | 2024-09-19T12:11:09.886Z | 2024-09-19T12:11:09.886Z |
5128800 | 5128800 | 20240917024150_rcFBd | UK002K | 2024-09-19T12:11:02.693Z | 2024-09-19T12:11:02.693Z |
5128599 | 5128599 | 20240917020913_TfuJP | UK002K | 2024-09-19T12:10:46.926Z | 2024-09-19T12:10:46.926Z |
5128085 | 5128085 | 20240917003411_AqYOW | UK002K | 2024-09-19T12:10:02.396Z | 2024-09-19T12:10:02.396Z |
5127961 | 5127961 | 20240917001034_DHbPk | UK002K | 2024-09-19T12:09:48.768Z | 2024-09-19T12:09:48.768Z |
5127946 | 5127946 | 20240917000644_8yTh8 | UK002K | 2024-09-19T12:09:47.774Z | 2024-09-19T12:09:47.774Z |
5127887 | 5127887 | 20240917000013_TaN8V | UK002K | 2024-09-19T12:09:45.565Z | 2024-09-19T12:09:45.565Z |
5127718 | 5127718 | 20240916231020_Lo0L5 | UK002K | 2024-09-19T12:09:34.296Z | 2024-09-19T12:09:34.296Z |
5127696 | 5127696 | 20240916230246_0v2S7 | UK002K | 2024-09-19T12:09:32.109Z | 2024-09-19T12:09:32.109Z |
5127671 | 5127671 | 20240916224918_wvvi2 | UK002K | 2024-09-19T12:09:31.225Z | 2024-09-19T12:09:31.225Z |
5127328 | 5127328 | 20240916213045_cE7Nz | UK002K | 2024-09-19T12:08:53.169Z | 2024-09-19T12:08:53.169Z |
5127202 | 5127202 | 20240916205455_3OK9Z | UK002K | 2024-09-19T12:08:32.234Z | 2024-09-19T12:08:32.234Z |
5127174 | 5127174 | 20240916204207_1tWVG | UK002K | 2024-09-19T12:08:24.594Z | 2024-09-19T12:08:24.594Z |
5126827 | 5126827 | 20240916194024_Ud8Qt | UK002K | 2024-09-19T12:07:24.371Z | 2024-09-19T12:07:24.371Z |
5121869 | 5121869 | 20240914041800_qCUmK | UK002K | 2024-09-18T12:11:02.516Z | 2024-09-19T12:20:02.474Z |
5121852 | 5121852 | 20240914041646_ko7IR | UK002K | 2024-09-18T12:11:02.272Z | 2024-09-19T12:20:02.434Z |
5121743 | 5121743 | 20240914041331_usi4A | UK002K | 2024-09-18T12:11:01.160Z | 2024-09-19T12:20:02.321Z |
5121487 | 5121487 | 20240914040449_QZ3T7 | UK002K | 2024-09-18T12:10:57.143Z | 2024-09-19T12:20:01.958Z |
5120840 | 5120840 | 20240914033739_42LWu | UK002K | 2024-09-18T12:10:47.628Z | 2024-09-19T12:20:00.927Z |
5120801 | 5120801 | 20240914033549_HftPa | UK002K | 2024-09-18T12:10:47.080Z | 2024-09-19T12:20:00.901Z |
5120452 | 5120452 | 20240914032048_wX9f3 | UK002K | 2024-09-18T12:10:40.365Z | 2024-09-19T12:20:00.330Z |
5120376 | 5120376 | 20240914031907_3J4lm | UK002K | 2024-09-18T12:10:39.079Z | 2024-09-19T12:20:00.086Z |
5120228 | 5120228 | 20240914030913_UO3Uh | UK002K | 2024-09-18T12:10:35.532Z | 2024-09-19T12:19:59.743Z |
5119885 | 5119885 | 20240914025141_uCbHb | UK002K | 2024-09-18T12:10:28.432Z | 2024-09-19T12:19:59.053Z |
5119762 | 5119762 | 20240914024814_YroJV | UK002K | 2024-09-18T12:10:26.241Z | 2024-09-19T12:19:58.923Z |
5119724 | 5119724 | 20240914024553_vYShz | UK002K | 2024-09-18T12:10:24.601Z | 2024-09-19T12:19:58.789Z |
5119688 | 5119688 | 20240914024409_grNiF | UK002K | 2024-09-18T12:10:24.067Z | 2024-09-19T12:19:58.737Z |
5119321 | 5119321 | 20240914022402_Gu8fz | UK002K | 2024-09-18T12:10:19.908Z | 2024-09-19T12:19:57.923Z |
5119278 | 5119278 | 20240914021950_QpAZ9 | UK002K | 2024-09-18T12:10:19.265Z | 2024-09-19T12:19:57.561Z |
5119223 | 5119223 | 20240914021831_2SKUF | UK002K | 2024-09-18T12:10:18.739Z | 2024-09-19T12:19:57.469Z |
5117286 | 5117286 | 20240915041633_GX8vC | UK002K | 2024-09-18T12:07:37.210Z | 2024-09-19T12:19:14.148Z |
5117203 | 5117203 | 20240915041137_eouSH | UK002K | 2024-09-18T12:07:35.595Z | 2024-09-19T12:19:13.893Z |
5116979 | 5116979 | 20240915035311_gFGMP | UK002K | 2024-09-18T12:07:27.216Z | 2024-09-19T12:19:12.938Z |
5116894 | 5116894 | 20240915034751_DhpkO | UK002K | 2024-09-18T12:07:24.848Z | 2024-09-19T12:19:12.609Z |
5116742 | 5116742 | 20240915033825_jSmQ6 | UK002K | 2024-09-18T12:07:18.612Z | 2024-09-19T12:19:12.200Z |
5116501 | 5116501 | 20240915033018_VgXWk | UK002K | 2024-09-18T12:07:07.880Z | 2024-09-19T12:19:11.410Z |
5116467 | 5116467 | 20240915032805_EgFMs | UK002K | 2024-09-18T12:07:04.780Z | 2024-09-19T12:19:11.235Z |
5116421 | 5116421 | 20240915032539_9leAG | UK002K | 2024-09-18T12:07:01.982Z | 2024-09-19T12:19:11.103Z |
5116205 | 5116205 | 20240915031615_9X39g | UK002K | 2024-09-18T12:06:48.212Z | 2024-09-19T12:19:09.741Z |
5116141 | 5116141 | 20240915031156_ahNCo | UK002K | 2024-09-18T12:06:43.795Z | 2024-09-19T12:19:08.957Z |
5116067 | 5116067 | 20240915030714_e97Xy | UK002K | 2024-09-18T12:06:36.742Z | 2024-09-19T12:19:08.385Z |
5115760 | 5115760 | 20240915025311_L3poC | UK002K | 2024-09-18T12:06:23.284Z | 2024-09-19T12:19:07.095Z |
5115451 | 5115451 | 20240915023927_3ohzm | UK002K | 2024-09-18T12:06:14.913Z | 2024-09-19T12:19:04.825Z |
5115250 | 5115250 | 20240915022930_IL8U8 | UK002K | 2024-09-18T12:06:08.076Z | 2024-09-19T12:19:03.410Z |
5112549 | 5112549 | 20240914232901_rULlG | UK002K | 2024-09-18T12:03:13.309Z | 2024-09-19T12:18:41.438Z |
5112457 | 5112457 | 20240914231847_2KZA0 | UK002K | 2024-09-18T12:03:09.177Z | 2024-09-19T12:18:41.085Z |
5111781 | 5111781 | 20240914211700_pLBEl | UK002K | 2024-09-18T12:02:17.053Z | 2024-09-19T12:18:34.037Z |
5111660 | 5111660 | 20240914205845_MMRs8 | UK002K | 2024-09-18T12:02:09.928Z | 2024-09-19T12:18:32.850Z |
5111451 | 5111451 | 20240914203754_fIoxq | UK002K | 2024-09-18T12:01:57.037Z | 2024-09-19T12:18:30.335Z |
5111389 | 5111389 | 20240914203159_KvJ3h | UK002K | 2024-09-18T12:01:53.843Z | 2024-09-19T12:18:29.815Z |
5110461 | 5110461 | 20240911013821_UfMc2 | UK002K | 2024-09-17T12:17:58.866Z | 2024-09-19T12:21:39.943Z |
5108114 | 5108114 | 20240913042358_AZAj2 | UK002K | 2024-09-17T12:13:30.683Z | 2024-09-19T12:20:47.851Z |
5107372 | 5107372 | 20240913035337_cxzYp | UK002K | 2024-09-17T12:13:13.774Z | 2024-09-19T12:20:47.026Z |
5107293 | 5107293 | 20240913035206_SCEhV | UK002K | 2024-09-17T12:13:12.728Z | 2024-09-19T12:20:46.989Z |
5107157 | 5107157 | 20240913034540_HdeRC | UK002K | 2024-09-17T12:13:10.141Z | 2024-09-19T12:20:46.869Z |
5106795 | 5106795 | 20240913033513_TN2om | UK002K | 2024-09-17T12:13:01.804Z | 2024-09-19T12:20:46.435Z |
5106475 | 5106475 | 20240913032728_zwfDL | UK002K | 2024-09-17T12:12:56.307Z | 2024-09-19T12:20:46.141Z |
5106433 | 5106433 | 20240913032447_eD33I | UK002K | 2024-09-17T12:12:54.026Z | 2024-09-19T12:20:46.079Z |
5106368 | 5106368 | 20240913032133_QXffb | UK002K | 2024-09-17T12:12:51.082Z | 2024-09-19T12:20:46.001Z |
5106348 | 5106348 | 20240913032043_2RkvF | UK002K | 2024-09-17T12:12:50.864Z | 2024-09-19T12:20:45.980Z |
5106273 | 5106273 | 20240913031648_y9XF3 | UK002K | 2024-09-17T12:12:47.768Z | 2024-09-19T12:20:45.738Z |
5105848 | 5105848 | 20240913030048_iMMnC | UK002K | 2024-09-17T12:12:30.829Z | 2024-09-19T12:20:44.987Z |
5105738 | 5105738 | 20240913025619_qM1bX | UK002K | 2024-09-17T12:12:28.313Z | 2024-09-19T12:20:44.866Z |
5105614 | 5105614 | 20240913025306_fY3iE | UK002K | 2024-09-17T12:12:23.558Z | 2024-09-19T12:20:44.726Z |
5104752 | 5104752 | 20240913022027_C2wow | UK002K | 2024-09-17T12:11:43.988Z | 2024-09-19T12:20:42.843Z |
5104682 | 5104682 | 20240913021854_aeYvH | UK002K | 2024-09-17T12:11:42.318Z | 2024-09-19T12:20:42.679Z |
5104567 | 5104567 | 20240913021513_Xr6d8 | UK002K | 2024-09-17T12:11:39.404Z | 2024-09-19T12:20:41.701Z |
5103515 | 5103515 | 20240913013155_6xY3b | UK002K | 2024-09-17T12:11:01.142Z | 2024-09-19T12:20:40.239Z |
5103485 | 5103485 | 20240913013131_UGhv3 | UK002K | 2024-09-17T12:10:59.809Z | 2024-09-19T12:20:40.214Z |
5103078 | 5103078 | 20240914020025_Rfh6Z | UK002K | 2024-09-17T12:07:51.019Z | 2024-09-19T12:19:56.516Z |
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);