participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,441 rows where station_code = "UK00A2" 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 |
---|---|---|---|---|---|
5563670 | 5563670 | 20241120015644_giLEd | UK00A2 | 2024-11-21T14:16:33.528Z | 2024-11-22T14:21:20.676Z |
5563590 | 5563590 | 20241120014846_qSMa2 | UK00A2 | 2024-11-21T14:16:25.721Z | 2024-11-22T14:21:19.469Z |
5563092 | 5563092 | 20241120005133_qk8j5 | UK00A2 | 2024-11-21T14:15:36.437Z | 2024-11-22T14:21:09.553Z |
5562892 | 5562892 | 20241120002403_0EGvs | UK00A2 | 2024-11-21T14:15:26.386Z | 2024-11-22T14:21:05.895Z |
5562832 | 5562832 | 20241120001600_9AOY8 | UK00A2 | 2024-11-21T14:15:24.242Z | 2024-11-22T14:21:05.296Z |
5562622 | 5562622 | 20241119235735_3zDhZ | UK00A2 | 2024-11-21T14:15:13.935Z | 2024-11-22T14:21:00.984Z |
5562486 | 5562486 | 20241119234338_7vitt | UK00A2 | 2024-11-21T14:14:59.862Z | 2024-11-22T14:20:59.302Z |
5562354 | 5562354 | 20241119232929_K8iSJ | UK00A2 | 2024-11-21T14:14:44.397Z | 2024-11-22T14:20:56.551Z |
5562269 | 5562269 | 20241119231841_RDA4I | UK00A2 | 2024-11-21T14:14:39.542Z | 2024-11-22T14:20:54.934Z |
5561645 | 5561645 | 20241119212443_JB2fU | UK00A2 | 2024-11-21T14:13:39.594Z | 2024-11-22T14:20:42.520Z |
5561606 | 5561606 | 20241119211252_NWJ3R | UK00A2 | 2024-11-21T14:13:33.842Z | 2024-11-22T14:20:41.715Z |
5561565 | 5561565 | 20241119210548_J3uZS | UK00A2 | 2024-11-21T14:13:27.864Z | 2024-11-22T14:20:40.782Z |
5561420 | 5561420 | 20241119202905_2KR7m | UK00A2 | 2024-11-21T14:13:15.388Z | 2024-11-22T14:20:35.813Z |
5561363 | 5561363 | 20241119201228_GEFkZ | UK00A2 | 2024-11-21T14:13:09.433Z | 2024-11-22T14:20:33.373Z |
5561218 | 5561218 | 20241119190741_vW3o2 | UK00A2 | 2024-11-21T14:12:39.931Z | 2024-11-22T14:20:26.715Z |
5557690 | 5557690 | 20241120050451_2LZXa | UK00A2 | 2024-11-21T14:01:30.810Z | 2024-11-22T14:19:21.112Z |
5557354 | 5557354 | 20241120044003_ucuow | UK00A2 | 2024-11-21T14:00:35.740Z | 2024-11-22T14:19:21.057Z |
5532713 | 5532713 | 20241112055403_3xb33 | UK00A2 | 2024-11-13T14:17:11.209Z | 2024-11-20T14:26:25.754Z |
5532670 | 5532670 | 20241112054955_GfT8G | UK00A2 | 2024-11-13T14:17:08.246Z | 2024-11-20T14:26:25.538Z |
5532599 | 5532599 | 20241112054310_J3THw | UK00A2 | 2024-11-13T14:17:02.539Z | 2024-11-20T14:26:25.049Z |
5532523 | 5532523 | 20241112053337_REb4U | UK00A2 | 2024-11-13T14:16:57.162Z | 2024-11-20T14:26:24.159Z |
5532285 | 5532285 | 20241112050322_o2bIq | UK00A2 | 2024-11-13T14:16:33.423Z | 2024-11-20T14:26:21.633Z |
5532120 | 5532120 | 20241112043846_ht0Nr | UK00A2 | 2024-11-13T14:16:20.149Z | 2024-11-20T14:26:18.910Z |
5532022 | 5532022 | 20241112042835_iiSrA | UK00A2 | 2024-11-13T14:16:10.658Z | 2024-11-20T14:26:17.327Z |
5531811 | 5531811 | 20241112041029_ZJUDS | UK00A2 | 2024-11-13T14:15:55.888Z | 2024-11-20T14:26:14.665Z |
5531757 | 5531757 | 20241112040735_hP8MG | UK00A2 | 2024-11-13T14:15:53.794Z | 2024-11-20T14:26:14.007Z |
5531242 | 5531242 | 20241112032453_eQ6Ry | UK00A2 | 2024-11-13T14:15:31.230Z | 2024-11-20T14:26:08.923Z |
5531120 | 5531120 | 20241112031535_RJqds | UK00A2 | 2024-11-13T14:15:15.810Z | 2024-11-20T14:26:08.064Z |
5531112 | 5531112 | 20241112031510_3UDCM | UK00A2 | 2024-11-13T14:15:15.554Z | 2024-11-20T14:26:07.976Z |
5530958 | 5530958 | 20241112030233_IQ3LL | UK00A2 | 2024-11-13T14:14:55.128Z | 2024-11-20T14:26:05.643Z |
5530654 | 5530654 | 20241112023659_ou9RS | UK00A2 | 2024-11-13T14:14:26.431Z | 2024-11-20T14:26:02.319Z |
5530442 | 5530442 | 20241112021819_8yAYO | UK00A2 | 2024-11-13T14:14:15.649Z | 2024-11-20T14:26:00.136Z |
5530401 | 5530401 | 20241112021544_DTd7b | UK00A2 | 2024-11-13T14:14:13.964Z | 2024-11-20T14:25:58.469Z |
5530317 | 5530317 | 20241112020725_fPTJd | UK00A2 | 2024-11-13T14:14:08.326Z | 2024-11-20T14:25:56.883Z |
5530076 | 5530076 | 20241112013959_C7nco | UK00A2 | 2024-11-13T14:13:48.793Z | 2024-11-20T14:25:54.076Z |
5530064 | 5530064 | 20241112013857_ArZX7 | UK00A2 | 2024-11-13T14:13:47.786Z | 2024-11-20T14:25:54.002Z |
5530049 | 5530049 | 20241112013807_Njehl | UK00A2 | 2024-11-13T14:13:44.807Z | 2024-11-20T14:25:53.478Z |
5529723 | 5529723 | 20241112010024_SfLKs | UK00A2 | 2024-11-13T14:13:07.996Z | 2024-11-20T14:25:47.713Z |
5529524 | 5529524 | 20241112003018_oICpu | UK00A2 | 2024-11-13T14:12:56.382Z | 2024-11-20T14:25:45.992Z |
5529456 | 5529456 | 20241112002219_zRapU | UK00A2 | 2024-11-13T14:12:52.066Z | 2024-11-20T14:25:45.143Z |
5529104 | 5529104 | 20241111233014_Fnk4i | UK00A2 | 2024-11-13T14:12:05.473Z | 2024-11-20T14:25:39.965Z |
5529049 | 5529049 | 20241111232252_aw59R | UK00A2 | 2024-11-13T14:12:01.043Z | 2024-11-20T14:25:39.347Z |
5528851 | 5528851 | 20241111225411_zNPg2 | UK00A2 | 2024-11-13T14:11:30.497Z | 2024-11-20T14:25:36.706Z |
5528840 | 5528840 | 20241111224902_ORoLY | UK00A2 | 2024-11-13T14:11:29.431Z | 2024-11-20T14:25:36.613Z |
5528784 | 5528784 | 20241111223857_fX3ft | UK00A2 | 2024-11-13T14:11:26.139Z | 2024-11-20T14:25:35.668Z |
5525642 | 5525642 | 20241112055828_3mpNn | UK00A2 | 2024-11-13T14:00:10.855Z | 2024-11-21T14:25:24.449Z |
5454874 | 5454874 | 20241031053726_wXM6h | UK00A2 | 2024-11-02T12:23:25.648Z | 2024-11-08T14:23:26.075Z |
5454845 | 5454845 | 20241031053136_5ZonS | UK00A2 | 2024-11-02T12:23:24.916Z | 2024-11-08T14:23:25.934Z |
5454643 | 5454643 | 20241031045128_Iqmf2 | UK00A2 | 2024-11-02T12:23:15.447Z | 2024-11-08T14:23:24.585Z |
5454574 | 5454574 | 20241031044105_7FHnq | UK00A2 | 2024-11-02T12:23:12.459Z | 2024-11-08T14:23:24.151Z |
5454564 | 5454564 | 20241031043943_0XFWq | UK00A2 | 2024-11-02T12:23:11.649Z | 2024-11-08T14:23:24.045Z |
5452950 | 5452950 | 20241101054003_bbWVg | UK00A2 | 2024-11-02T12:19:36.554Z | 2024-11-09T14:24:36.872Z |
5452943 | 5452943 | 20241101053657_AABlU | UK00A2 | 2024-11-02T12:19:35.678Z | 2024-11-09T14:24:36.803Z |
5452857 | 5452857 | 20241101050611_3CzAu | UK00A2 | 2024-11-02T12:19:30.364Z | 2024-11-09T14:24:35.040Z |
5452803 | 5452803 | 20241101044003_8c103 | UK00A2 | 2024-11-02T12:19:23.221Z | 2024-11-09T14:24:34.079Z |
5452798 | 5452798 | 20241101043851_XpGRz | UK00A2 | 2024-11-02T12:19:22.981Z | 2024-11-09T14:24:33.900Z |
5452789 | 5452789 | 20241101043723_JvHhc | UK00A2 | 2024-11-02T12:19:21.994Z | 2024-11-09T14:24:33.846Z |
5452708 | 5452708 | 20241101041330_hqFeZ | UK00A2 | 2024-11-02T12:19:16.070Z | 2024-11-09T14:24:33.280Z |
5452674 | 5452674 | 20241101040631_7YmFY | UK00A2 | 2024-11-02T12:19:12.569Z | 2024-11-09T14:24:32.658Z |
5444501 | 5444501 | 20241031012628_qILci | UK00A2 | 2024-11-01T12:21:20.488Z | 2024-11-08T14:23:15.758Z |
5444066 | 5444066 | 20241031004354_dLm70 | UK00A2 | 2024-11-01T12:21:04.380Z | 2024-11-08T14:23:13.777Z |
5444047 | 5444047 | 20241031004148_suqGe | UK00A2 | 2024-11-01T12:21:03.312Z | 2024-11-08T14:23:13.616Z |
5443966 | 5443966 | 20241031003355_hoIx9 | UK00A2 | 2024-11-01T12:20:59.908Z | 2024-11-08T14:23:13.383Z |
5443799 | 5443799 | 20241031001656_MLnqT | UK00A2 | 2024-11-01T12:20:52.636Z | 2024-11-08T14:23:12.655Z |
5443786 | 5443786 | 20241031001540_C7KQu | UK00A2 | 2024-11-01T12:20:51.491Z | 2024-11-08T14:23:12.451Z |
5443646 | 5443646 | 20241030235905_Ywkcn | UK00A2 | 2024-11-01T12:20:44.324Z | 2024-11-08T14:23:11.912Z |
5443644 | 5443644 | 20241030235845_TGoX7 | UK00A2 | 2024-11-01T12:20:44.095Z | 2024-11-08T14:23:11.886Z |
5443557 | 5443557 | 20241030234224_8NiFD | UK00A2 | 2024-11-01T12:20:38.659Z | 2024-11-08T14:23:11.630Z |
5440430 | 5440430 | 20241030221246_tj9dR | UK00A2 | 2024-11-01T12:15:30.587Z | 2024-11-08T14:23:09.423Z |
5440143 | 5440143 | 20241030213007_kgq9c | UK00A2 | 2024-11-01T12:14:53.913Z | 2024-11-08T14:23:07.574Z |
5440010 | 5440010 | 20241030210651_l7aCB | UK00A2 | 2024-11-01T12:14:44.285Z | 2024-11-08T14:23:06.789Z |
5432177 | 5432177 | 20241029025215_syCle | UK00A2 | 2024-10-31T12:21:10.191Z | 2024-11-06T14:27:26.185Z |
5431436 | 5431436 | 20241029011159_G83pe | UK00A2 | 2024-10-31T12:20:08.198Z | 2024-11-06T14:27:23.732Z |
5431374 | 5431374 | 20241029010154_qDyQx | UK00A2 | 2024-10-31T12:20:03.128Z | 2024-11-06T14:27:23.376Z |
5431159 | 5431159 | 20241029003729_CrRkd | UK00A2 | 2024-10-31T12:19:40.611Z | 2024-11-06T14:27:22.882Z |
5431057 | 5431057 | 20241029002011_PCWyY | UK00A2 | 2024-10-31T12:19:31.383Z | 2024-11-06T14:27:22.628Z |
5431038 | 5431038 | 20241029001842_xNtqy | UK00A2 | 2024-10-31T12:19:30.627Z | 2024-11-06T14:27:22.565Z |
5430988 | 5430988 | 20241029001206_1NNQs | UK00A2 | 2024-10-31T12:19:25.507Z | 2024-11-06T14:27:22.404Z |
5430964 | 5430964 | 20241029000926_s8egs | UK00A2 | 2024-10-31T12:19:22.458Z | 2024-11-06T14:27:22.351Z |
5430716 | 5430716 | 20241028232751_u1sYA | UK00A2 | 2024-10-31T12:18:54.432Z | 2024-11-06T14:27:21.156Z |
5430699 | 5430699 | 20241028232451_2y3Ux | UK00A2 | 2024-10-31T12:18:53.367Z | 2024-11-06T14:27:21.094Z |
5430651 | 5430651 | 20241028231504_u7rvA | UK00A2 | 2024-10-31T12:18:46.548Z | 2024-11-06T14:27:20.944Z |
5422982 | 5422982 | 20241027011550_xMiev | UK00A2 | 2024-10-30T12:22:35.812Z | 2024-11-04T14:28:55.117Z |
5412452 | 5412452 | 20241026043644_VA2Op | UK00A2 | 2024-10-29T12:22:08.641Z | 2024-11-03T14:27:40.031Z |
5410670 | 5410670 | 20241027052601_vi3x0 | UK00A2 | 2024-10-29T12:18:02.217Z | 2024-11-04T14:29:05.206Z |
5410570 | 5410570 | 20241027051839_CHur0 | UK00A2 | 2024-10-29T12:17:58.376Z | 2024-11-04T14:29:04.981Z |
5408516 | 5408516 | 20241027032839_Rzm81 | UK00A2 | 2024-10-29T12:16:34.160Z | 2024-11-04T14:28:59.583Z |
5408394 | 5408394 | 20241027032520_Qpize | UK00A2 | 2024-10-29T12:16:26.028Z | 2024-11-04T14:28:59.312Z |
5408350 | 5408350 | 20241027032304_6oxSO | UK00A2 | 2024-10-29T12:16:24.485Z | 2024-11-04T14:28:59.244Z |
5406441 | 5406441 | 20241027013754_krzSl | UK00A2 | 2024-10-29T12:14:09.697Z | 2024-11-04T14:28:55.705Z |
5406253 | 5406253 | 20241027012357_3kuD2 | UK00A2 | 2024-10-29T12:13:59.470Z | 2024-11-04T14:28:55.258Z |
5406203 | 5406203 | 20241027012125_S2pCb | UK00A2 | 2024-10-29T12:13:57.098Z | 2024-11-04T14:28:55.205Z |
5406072 | 5406072 | 20241027011406_xc9vf | UK00A2 | 2024-10-29T12:13:50.169Z | 2024-11-04T14:28:54.917Z |
5406016 | 5406016 | 20241027011214_RRwA9 | UK00A2 | 2024-10-29T12:13:48.051Z | 2024-11-04T14:28:54.885Z |
5405773 | 5405773 | 20241027005715_ezAS0 | UK00A2 | 2024-10-29T12:13:15.522Z | 2024-11-04T14:28:54.181Z |
5405309 | 5405309 | 20241027002753_DuxbX | UK00A2 | 2024-10-29T12:12:49.022Z | 2024-11-04T14:28:53.268Z |
5405106 | 5405106 | 20241027001346_BhzSC | UK00A2 | 2024-10-29T12:12:27.672Z | 2024-11-04T14:28:52.681Z |
5405065 | 5405065 | 20241027001145_y2Fmy | UK00A2 | 2024-10-29T12:12:22.362Z | 2024-11-04T14:28:52.653Z |
5404093 | 5404093 | 20241026225713_GNcZK | UK00A2 | 2024-10-29T12:10:52.986Z | 2024-11-04T14:28:50.323Z |
5404001 | 5404001 | 20241026225239_Xz8bw | UK00A2 | 2024-10-29T12:10:46.897Z | 2024-11-04T14:28:50.194Z |
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);