participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,451 rows where station_code = "UK006X" 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 |
---|---|---|---|---|---|
5129403 | 5129403 | 20240917035457_VPmvh | UK006X | 2024-09-19T12:11:34.640Z | 2024-09-19T12:11:34.640Z |
5129215 | 5129215 | 20240917033757_CJFTp | UK006X | 2024-09-19T12:11:23.450Z | 2024-09-19T12:11:23.450Z |
5122028 | 5122028 | 20240914042820_mJEfX | UK006X | 2024-09-18T12:11:05.022Z | 2024-09-19T12:20:02.705Z |
5121893 | 5121893 | 20240914042027_UwaLG | UK006X | 2024-09-18T12:11:02.834Z | 2024-09-19T12:20:02.482Z |
5121835 | 5121835 | 20240914041453_vvmAX | UK006X | 2024-09-18T12:11:01.722Z | 2024-09-19T12:20:02.390Z |
5121328 | 5121328 | 20240914035815_Xm2fk | UK006X | 2024-09-18T12:10:54.567Z | 2024-09-19T12:20:01.624Z |
5121203 | 5121203 | 20240914035523_kP3a1 | UK006X | 2024-09-18T12:10:52.371Z | 2024-09-19T12:20:01.490Z |
5121151 | 5121151 | 20240914035416_WO0B7 | UK006X | 2024-09-18T12:10:52.062Z | 2024-09-19T12:20:01.457Z |
5120492 | 5120492 | 20240914032427_CUlG2 | UK006X | 2024-09-18T12:10:42.070Z | 2024-09-19T12:20:00.494Z |
5119964 | 5119964 | 20240914025452_2jk3k | UK006X | 2024-09-18T12:10:30.091Z | 2024-09-19T12:19:59.202Z |
5119778 | 5119778 | 20240914024916_13w3A | UK006X | 2024-09-18T12:10:26.896Z | 2024-09-19T12:19:58.940Z |
5119732 | 5119732 | 20240914024608_v3ZnX | UK006X | 2024-09-18T12:10:24.624Z | 2024-09-19T12:19:58.797Z |
5119584 | 5119584 | 20240914023949_7m02R | UK006X | 2024-09-18T12:10:22.489Z | 2024-09-19T12:19:58.552Z |
5119388 | 5119388 | 20240914023010_2gAO0 | UK006X | 2024-09-18T12:10:20.699Z | 2024-09-19T12:19:58.109Z |
5119104 | 5119104 | 20240914020910_eApWm | UK006X | 2024-09-18T12:10:16.105Z | 2024-09-19T12:19:57.137Z |
5117368 | 5117368 | 20240915042118_HJm5b | UK006X | 2024-09-18T12:07:38.816Z | 2024-09-19T12:19:14.503Z |
5117260 | 5117260 | 20240915041543_32kqX | UK006X | 2024-09-18T12:07:36.388Z | 2024-09-19T12:19:14.055Z |
5117214 | 5117214 | 20240915041252_4Zis3 | UK006X | 2024-09-18T12:07:35.679Z | 2024-09-19T12:19:13.901Z |
5117164 | 5117164 | 20240915040711_ETWrb | UK006X | 2024-09-18T12:07:34.310Z | 2024-09-19T12:19:13.674Z |
5116776 | 5116776 | 20240915034143_L2wKJ | UK006X | 2024-09-18T12:07:20.731Z | 2024-09-19T12:19:12.351Z |
5116555 | 5116555 | 20240915033128_ritA0 | UK006X | 2024-09-18T12:07:09.643Z | 2024-09-19T12:19:11.512Z |
5116540 | 5116540 | 20240915033128_j9tT2 | UK006X | 2024-09-18T12:07:09.412Z | 2024-09-19T12:19:11.501Z |
5116374 | 5116374 | 20240915032405_ghSQJ | UK006X | 2024-09-18T12:07:00.268Z | 2024-09-19T12:19:10.748Z |
5116094 | 5116094 | 20240915030817_fn6LA | UK006X | 2024-09-18T12:06:39.428Z | 2024-09-19T12:19:08.692Z |
5114799 | 5114799 | 20240915015831_iQYsV | UK006X | 2024-09-18T12:05:34.746Z | 2024-09-19T12:18:59.962Z |
5114673 | 5114673 | 20240915015324_Xb4qe | UK006X | 2024-09-18T12:05:28.076Z | 2024-09-19T12:18:59.202Z |
5114529 | 5114529 | 20240915014649_fdMaf | UK006X | 2024-09-18T12:05:20.940Z | 2024-09-19T12:18:58.750Z |
5114404 | 5114404 | 20240915014101_hZoLI | UK006X | 2024-09-18T12:05:14.305Z | 2024-09-19T12:18:57.938Z |
5114045 | 5114045 | 20240915012349_L3tux | UK006X | 2024-09-18T12:04:59.893Z | 2024-09-19T12:18:55.472Z |
5113847 | 5113847 | 20240915011543_gYMsi | UK006X | 2024-09-18T12:04:52.719Z | 2024-09-19T12:18:53.295Z |
5112563 | 5112563 | 20240914232945_zEWSh | UK006X | 2024-09-18T12:03:14.838Z | 2024-09-19T12:18:41.478Z |
5108068 | 5108068 | 20240913042227_zWWmq | UK006X | 2024-09-17T12:13:30.150Z | 2024-09-19T12:20:47.834Z |
5108052 | 5108052 | 20240913042113_BuZZr | UK006X | 2024-09-17T12:13:29.900Z | 2024-09-19T12:20:47.825Z |
5107199 | 5107199 | 20240913034700_OF89q | UK006X | 2024-09-17T12:13:10.532Z | 2024-09-19T12:20:46.900Z |
5106574 | 5106574 | 20240913032848_C8UT3 | UK006X | 2024-09-17T12:12:57.311Z | 2024-09-19T12:20:46.179Z |
5105949 | 5105949 | 20240913030350_8635I | UK006X | 2024-09-17T12:12:34.439Z | 2024-09-19T12:20:45.079Z |
5105672 | 5105672 | 20240913025456_vtBVi | UK006X | 2024-09-17T12:12:25.624Z | 2024-09-19T12:20:44.791Z |
5105349 | 5105349 | 20240913024217_lH8wJ | UK006X | 2024-09-17T12:12:10.507Z | 2024-09-19T12:20:44.309Z |
5105125 | 5105125 | 20240913023157_iEiTZ | UK006X | 2024-09-17T12:11:57.298Z | 2024-09-19T12:20:43.741Z |
5103902 | 5103902 | 20240913014324_nuV16 | UK006X | 2024-09-17T12:11:16.224Z | 2024-09-19T12:20:40.661Z |
5103848 | 5103848 | 20240913014220_6dD5N | UK006X | 2024-09-17T12:11:13.377Z | 2024-09-19T12:20:40.626Z |
5103184 | 5103184 | 20240914020350_qfFdZ | UK006X | 2024-09-17T12:07:55.802Z | 2024-09-19T12:19:56.781Z |
5103090 | 5103090 | 20240914020052_EQ9K3 | UK006X | 2024-09-17T12:07:51.602Z | 2024-09-19T12:19:56.609Z |
5102969 | 5102969 | 20240914015551_ZQths | UK006X | 2024-09-17T12:07:45.569Z | 2024-09-19T12:19:56.228Z |
5102899 | 5102899 | 20240914015229_kmyL9 | UK006X | 2024-09-17T12:07:42.639Z | 2024-09-19T12:19:56.083Z |
5102716 | 5102716 | 20240914013942_mSflV | UK006X | 2024-09-17T12:07:32.700Z | 2024-09-19T12:19:55.433Z |
5102691 | 5102691 | 20240914013752_rN9a2 | UK006X | 2024-09-17T12:07:31.646Z | 2024-09-19T12:19:55.406Z |
5102566 | 5102566 | 20240914013205_aVAkd | UK006X | 2024-09-17T12:07:25.778Z | 2024-09-19T12:19:55.145Z |
5102528 | 5102528 | 20240914013033_3gEnZ | UK006X | 2024-09-17T12:07:19.202Z | 2024-09-19T12:19:54.725Z |
5102399 | 5102399 | 20240914012355_rrY0Z | UK006X | 2024-09-17T12:07:07.330Z | 2024-09-19T12:19:54.057Z |
5101921 | 5101921 | 20240914005527_NzMrf | UK006X | 2024-09-17T12:06:24.077Z | 2024-09-19T12:19:51.861Z |
5101314 | 5101314 | 20240914001913_y13qc | UK006X | 2024-09-17T12:05:34.809Z | 2024-09-19T12:19:50.251Z |
5101275 | 5101275 | 20240914001728_IQ32l | UK006X | 2024-09-17T12:05:31.454Z | 2024-09-19T12:19:50.144Z |
5101117 | 5101117 | 20240914000512_hOC8P | UK006X | 2024-09-17T12:05:21.078Z | 2024-09-19T12:19:49.821Z |
5101052 | 5101052 | 20240913235911_soX3X | UK006X | 2024-09-17T12:05:16.797Z | 2024-09-19T12:19:49.591Z |
5100823 | 5100823 | 20240913234635_px7iK | UK006X | 2024-09-17T12:04:58.035Z | 2024-09-19T12:19:48.798Z |
5100459 | 5100459 | 20240913232718_Rbr4s | UK006X | 2024-09-17T12:04:34.781Z | 2024-09-19T12:19:48.005Z |
5100161 | 5100161 | 20240913225901_JMOgI | UK006X | 2024-09-17T12:04:05.388Z | 2024-09-19T12:19:47.060Z |
5099643 | 5099643 | 20240913214413_NYLuO | UK006X | 2024-09-17T12:03:17.396Z | 2024-09-19T12:19:45.546Z |
5099289 | 5099289 | 20240913205605_cIAgm | UK006X | 2024-09-17T12:02:41.768Z | 2024-09-19T12:19:44.419Z |
5097521 | 5097521 | 20240913005218_90IdC | UK006X | 2024-09-16T12:17:13.224Z | 2024-09-19T12:20:38.685Z |
5097429 | 5097429 | 20240913004659_0vszY | UK006X | 2024-09-16T12:17:12.615Z | 2024-09-19T12:20:38.620Z |
5094673 | 5094673 | 20240912041435_23yq3 | UK006X | 2024-09-16T12:14:53.887Z | 2024-09-19T12:21:16.372Z |
5094238 | 5094238 | 20240912035411_JoaMv | UK006X | 2024-09-16T12:14:39.794Z | 2024-09-19T12:21:16.030Z |
5093413 | 5093413 | 20240912032020_FW32T | UK006X | 2024-09-16T12:14:16.550Z | 2024-09-19T12:21:15.307Z |
5093129 | 5093129 | 20240912031231_OMnQR | UK006X | 2024-09-16T12:14:11.820Z | 2024-09-19T12:21:14.948Z |
5092407 | 5092407 | 20240912024433_m5fyE | UK006X | 2024-09-16T12:13:51.850Z | 2024-09-19T12:21:13.938Z |
5092285 | 5092285 | 20240912024205_EW2CV | UK006X | 2024-09-16T12:13:47.547Z | 2024-09-19T12:21:13.813Z |
5092204 | 5092204 | 20240912024005_69ypU | UK006X | 2024-09-16T12:13:43.783Z | 2024-09-19T12:21:13.699Z |
5091433 | 5091433 | 20240912020942_gADsK | UK006X | 2024-09-16T12:13:06.237Z | 2024-09-19T12:21:13.031Z |
5091196 | 5091196 | 20240912020213_U1v85 | UK006X | 2024-09-16T12:12:54.734Z | 2024-09-19T12:21:12.642Z |
5090520 | 5090520 | 20240912012856_Zeybw | UK006X | 2024-09-16T12:12:22.552Z | 2024-09-19T12:21:11.367Z |
5090506 | 5090506 | 20240912012829_SkQJG | UK006X | 2024-09-16T12:12:22.274Z | 2024-09-19T12:21:11.357Z |
5090477 | 5090477 | 20240912012733_SX3w8 | UK006X | 2024-09-16T12:12:21.535Z | 2024-09-19T12:21:11.339Z |
5090199 | 5090199 | 20240912011515_ffDTi | UK006X | 2024-09-16T12:12:06.611Z | 2024-09-19T12:21:11.065Z |
5089764 | 5089764 | 20240912005655_LHM8j | UK006X | 2024-09-16T12:11:41.520Z | 2024-09-19T12:21:10.459Z |
5089635 | 5089635 | 20240912005204_9pMze | UK006X | 2024-09-16T12:11:33.223Z | 2024-09-19T12:21:10.111Z |
5089261 | 5089261 | 20240912003156_oe9n6 | UK006X | 2024-09-16T12:11:18.694Z | 2024-09-19T12:21:09.851Z |
5088603 | 5088603 | 20240913001835_osUHJ | UK006X | 2024-09-16T12:08:16.105Z | 2024-09-19T12:20:37.052Z |
5088453 | 5088453 | 20240913001128_lNQY2 | UK006X | 2024-09-16T12:08:00.748Z | 2024-09-19T12:20:36.867Z |
5087618 | 5087618 | 20240912233719_xxsaK | UK006X | 2024-09-16T12:07:07.677Z | 2024-09-19T12:20:35.512Z |
5086644 | 5086644 | 20240912224433_lMMxg | UK006X | 2024-09-16T12:05:55.984Z | 2024-09-19T12:20:31.473Z |
5086151 | 5086151 | 20240912221201_mK4XH | UK006X | 2024-09-16T12:05:17.540Z | 2024-09-19T12:20:30.298Z |
5085812 | 5085812 | 20240912215229_4c7pE | UK006X | 2024-09-16T12:04:56.588Z | 2024-09-19T12:20:29.635Z |
5085416 | 5085416 | 20240912211944_8yZoQ | UK006X | 2024-09-16T12:04:15.036Z | 2024-09-19T12:20:28.619Z |
5084559 | 5084559 | 20240912195112_0ihOd | UK006X | 2024-09-16T12:02:24.084Z | 2024-09-19T12:20:26.335Z |
5076325 | 5076325 | 20240910232115_LfGta | UK006X | 2024-09-15T12:13:27.794Z | 2024-09-19T12:21:36.711Z |
5075907 | 5075907 | 20240910225934_MsR71 | UK006X | 2024-09-15T12:13:12.130Z | 2024-09-19T12:21:36.221Z |
5075507 | 5075507 | 20240911235200_KlSwZ | UK006X | 2024-09-15T12:09:56.701Z | 2024-09-19T12:21:09.253Z |
5075419 | 5075419 | 20240911234722_jY2wx | UK006X | 2024-09-15T12:09:43.238Z | 2024-09-19T12:21:09.207Z |
5074473 | 5074473 | 20240911224013_BDj3o | UK006X | 2024-09-15T12:08:33.658Z | 2024-09-19T12:21:07.347Z |
5074027 | 5074027 | 20240911220835_d4NIX | UK006X | 2024-09-15T12:07:51.983Z | 2024-09-19T12:21:06.860Z |
5073855 | 5073855 | 20240911215141_dgcmH | UK006X | 2024-09-15T12:07:41.553Z | 2024-09-19T12:21:06.328Z |
5073675 | 5073675 | 20240911213846_INXu1 | UK006X | 2024-09-15T12:07:33.125Z | 2024-09-19T12:21:06.147Z |
5073265 | 5073265 | 20240911211205_8zerw | UK006X | 2024-09-15T12:07:00.126Z | 2024-09-19T12:21:05.387Z |
5073154 | 5073154 | 20240911210229_g4HKP | UK006X | 2024-09-15T12:06:50.383Z | 2024-09-19T12:21:05.187Z |
5072745 | 5072745 | 20240911203918_UoZHX | UK006X | 2024-09-15T12:06:05.586Z | 2024-09-19T12:21:04.712Z |
5069735 | 5069735 | 20240910220412_yrNl3 | UK006X | 2024-09-14T12:20:05.330Z | 2024-09-19T12:21:35.281Z |
5069381 | 5069381 | 20240910213622_syVr5 | UK006X | 2024-09-14T12:19:55.211Z | 2024-09-19T12:21:34.798Z |
5064373 | 5064373 | 20240910005435_FHodt | UK006X | 2024-09-14T12:15:20.178Z | 2024-09-18T12:15:16.375Z |
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);