participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,723 rows where station_code = "UK009S" 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 |
---|---|---|---|---|---|
5463315 | 5463315 | 20241102031544_vv3Yx | UK009S | 2024-11-03T14:18:32.555Z | 2024-11-09T14:23:39.988Z |
5463031 | 5463031 | 20241102021723_8A6FC | UK009S | 2024-11-03T14:18:15.303Z | 2024-11-09T14:23:37.340Z |
5462944 | 5462944 | 20241102020242_Gdfeb | UK009S | 2024-11-03T14:18:10.764Z | 2024-11-09T14:23:36.892Z |
5462808 | 5462808 | 20241102013542_N0AFm | UK009S | 2024-11-03T14:18:05.670Z | 2024-11-09T14:23:36.339Z |
5452938 | 5452938 | 20241101053625_swY1Z | UK009S | 2024-11-02T12:19:35.306Z | 2024-11-09T14:24:36.591Z |
5452907 | 5452907 | 20241101052135_oGBTn | UK009S | 2024-11-02T12:19:32.905Z | 2024-11-09T14:24:35.878Z |
5452868 | 5452868 | 20241101050832_ncjNz | UK009S | 2024-11-02T12:19:30.691Z | 2024-11-09T14:24:35.150Z |
5452849 | 5452849 | 20241101050417_bFtS2 | UK009S | 2024-11-02T12:19:29.414Z | 2024-11-09T14:24:34.676Z |
5451406 | 5451406 | 20241031235038_B3Te0 | UK009S | 2024-11-02T12:17:05.129Z | 2024-11-09T14:24:23.411Z |
5451154 | 5451154 | 20241031225200_wZ1bg | UK009S | 2024-11-02T12:16:39.644Z | 2024-11-09T14:24:21.937Z |
5451126 | 5451126 | 20241031224440_kZx5T | UK009S | 2024-11-02T12:16:37.690Z | 2024-11-09T14:24:21.685Z |
5451092 | 5451092 | 20241031223620_5oB2O | UK009S | 2024-11-02T12:16:35.179Z | 2024-11-09T14:24:21.489Z |
5450932 | 5450932 | 20241031214904_z9gNm | UK009S | 2024-11-02T12:16:17.997Z | 2024-11-09T14:24:20.045Z |
5440384 | 5440384 | 20241030220526_2eN0B | UK009S | 2024-11-01T12:15:28.122Z | 2024-11-08T14:23:09.300Z |
5432589 | 5432589 | 20241029035551_K6bCW | UK009S | 2024-10-31T12:21:27.957Z | 2024-11-06T14:27:28.137Z |
5432575 | 5432575 | 20241029035426_Lh3QG | UK009S | 2024-10-31T12:21:27.410Z | 2024-11-06T14:27:27.958Z |
5432563 | 5432563 | 20241029035352_Ylk3Q | UK009S | 2024-10-31T12:21:27.200Z | 2024-11-06T14:27:27.849Z |
5432559 | 5432559 | 20241029035326_N8tRx | UK009S | 2024-10-31T12:21:27.015Z | 2024-11-06T14:27:27.838Z |
5431458 | 5431458 | 20241029011517_B2aPg | UK009S | 2024-10-31T12:20:10.566Z | 2024-11-06T14:27:23.776Z |
5430689 | 5430689 | 20241028232227_LVVEF | UK009S | 2024-10-31T12:18:51.587Z | 2024-11-06T14:27:21.069Z |
5430672 | 5430672 | 20241028231727_hkyu4 | UK009S | 2024-10-31T12:18:49.751Z | 2024-11-06T14:27:21.036Z |
5430598 | 5430598 | 20241028231107_cE292 | UK009S | 2024-10-31T12:18:41.700Z | 2024-11-06T14:27:20.625Z |
5412441 | 5412441 | 20241026001307_NJacK | UK009S | 2024-10-29T12:21:47.084Z | 2024-11-03T14:27:30.290Z |
5410500 | 5410500 | 20241027051544_zFtsH | UK009S | 2024-10-29T12:17:56.983Z | 2024-11-04T14:29:04.651Z |
5410417 | 5410417 | 20241027051216_CG6LR | UK009S | 2024-10-29T12:17:55.491Z | 2024-11-04T14:29:04.562Z |
5410340 | 5410340 | 20241027050707_1K6eG | UK009S | 2024-10-29T12:17:53.420Z | 2024-11-04T14:29:04.346Z |
5410266 | 5410266 | 20241027050420_ajY4E | UK009S | 2024-10-29T12:17:51.875Z | 2024-11-04T14:29:04.273Z |
5410260 | 5410260 | 20241027050420_esUpI | UK009S | 2024-10-29T12:17:51.832Z | 2024-11-04T14:29:04.271Z |
5409932 | 5409932 | 20241027044239_eUWQD | UK009S | 2024-10-29T12:17:44.176Z | 2024-11-04T14:29:02.941Z |
5408976 | 5408976 | 20241027035141_YSaAm | UK009S | 2024-10-29T12:16:58.777Z | 2024-11-04T14:29:00.881Z |
5408641 | 5408641 | 20241027033405_Yu5Dt | UK009S | 2024-10-29T12:16:41.913Z | 2024-11-04T14:28:59.711Z |
5408555 | 5408555 | 20241027033015_JimKY | UK009S | 2024-10-29T12:16:35.922Z | 2024-11-04T14:28:59.615Z |
5408501 | 5408501 | 20241027032816_MnvOW | UK009S | 2024-10-29T12:16:33.266Z | 2024-11-04T14:28:59.566Z |
5408361 | 5408361 | 20241027032326_g33z3 | UK009S | 2024-10-29T12:16:24.794Z | 2024-11-04T14:28:59.284Z |
5408165 | 5408165 | 20241027031221_B0CNF | UK009S | 2024-10-29T12:16:13.206Z | 2024-11-04T14:28:58.941Z |
5407392 | 5407392 | 20241027023430_87xUX | UK009S | 2024-10-29T12:15:23.418Z | 2024-11-04T14:28:57.485Z |
5407096 | 5407096 | 20241027022218_4q33v | UK009S | 2024-10-29T12:15:12.227Z | 2024-11-04T14:28:56.843Z |
5407038 | 5407038 | 20241027021751_ZtfmF | UK009S | 2024-10-29T12:15:09.757Z | 2024-11-04T14:28:56.791Z |
5406904 | 5406904 | 20241027020807_6KKnH | UK009S | 2024-10-29T12:14:54.436Z | 2024-11-04T14:28:56.613Z |
5406859 | 5406859 | 20241027020439_0A7AZ | UK009S | 2024-10-29T12:14:50.745Z | 2024-11-04T14:28:56.519Z |
5406737 | 5406737 | 20241027015728_KpCWV | UK009S | 2024-10-29T12:14:36.904Z | 2024-11-04T14:28:56.326Z |
5406423 | 5406423 | 20241027013627_tP1U6 | UK009S | 2024-10-29T12:14:07.824Z | 2024-11-04T14:28:55.689Z |
5405942 | 5405942 | 20241027010938_ur8m2 | UK009S | 2024-10-29T12:13:37.395Z | 2024-11-04T14:28:54.628Z |
5405816 | 5405816 | 20241027010042_G2Nyl | UK009S | 2024-10-29T12:13:19.321Z | 2024-11-04T14:28:54.399Z |
5405811 | 5405811 | 20241027010014_3Y08T | UK009S | 2024-10-29T12:13:18.711Z | 2024-11-04T14:28:54.336Z |
5403837 | 5403837 | 20241026223622_2mYJU | UK009S | 2024-10-29T12:10:17.575Z | 2024-11-04T14:28:49.864Z |
5403812 | 5403812 | 20241026223257_npkrJ | UK009S | 2024-10-29T12:10:15.250Z | 2024-11-04T14:28:49.784Z |
5403686 | 5403686 | 20241026222325_ehWM8 | UK009S | 2024-10-29T12:10:07.452Z | 2024-11-04T14:28:49.486Z |
5403389 | 5403389 | 20241026215030_M67K5 | UK009S | 2024-10-29T12:09:26.464Z | 2024-11-04T14:28:48.671Z |
5403159 | 5403159 | 20241026212450_G520f | UK009S | 2024-10-29T12:09:07.823Z | 2024-11-04T14:28:47.885Z |
5403130 | 5403130 | 20241026212124_LMhul | UK009S | 2024-10-29T12:09:01.960Z | 2024-11-04T14:28:47.782Z |
5402766 | 5402766 | 20241026202223_wo2Vn | UK009S | 2024-10-29T12:08:06.522Z | 2024-11-04T14:28:46.478Z |
5400161 | 5400161 | 20241026054650_ko9Bd | UK009S | 2024-10-28T12:20:25.246Z | 2024-11-03T14:27:41.441Z |
5400129 | 5400129 | 20241026054240_1xNpz | UK009S | 2024-10-28T12:20:23.874Z | 2024-11-03T14:27:41.370Z |
5399999 | 5399999 | 20241026052054_Po499 | UK009S | 2024-10-28T12:20:18.620Z | 2024-11-03T14:27:41.079Z |
5399902 | 5399902 | 20241026051105_CabTu | UK009S | 2024-10-28T12:20:15.793Z | 2024-11-03T14:27:40.704Z |
5399830 | 5399830 | 20241026050521_ScxBP | UK009S | 2024-10-28T12:20:12.485Z | 2024-11-03T14:27:40.582Z |
5399791 | 5399791 | 20241026050252_s3bXi | UK009S | 2024-10-28T12:20:11.121Z | 2024-11-03T14:27:40.512Z |
5399754 | 5399754 | 20241026045922_Yn5dP | UK009S | 2024-10-28T12:20:10.092Z | 2024-11-03T14:27:40.420Z |
5399715 | 5399715 | 20241026045313_jRIYs | UK009S | 2024-10-28T12:20:08.464Z | 2024-11-03T14:27:40.307Z |
5399635 | 5399635 | 20241026044309_h5TB7 | UK009S | 2024-10-28T12:20:04.558Z | 2024-11-03T14:27:40.147Z |
5399620 | 5399620 | 20241026044010_mtAoB | UK009S | 2024-10-28T12:20:04.302Z | 2024-11-03T14:27:40.089Z |
5399587 | 5399587 | 20241026043612_3F26A | UK009S | 2024-10-28T12:20:03.245Z | 2024-11-03T14:27:40.016Z |
5399548 | 5399548 | 20241026043334_KwyFm | UK009S | 2024-10-28T12:20:01.764Z | 2024-11-03T14:27:39.944Z |
5399386 | 5399386 | 20241026041430_2qLNc | UK009S | 2024-10-28T12:19:57.727Z | 2024-11-03T14:27:39.582Z |
5399305 | 5399305 | 20241026040918_mY3gp | UK009S | 2024-10-28T12:19:53.659Z | 2024-11-03T14:27:39.354Z |
5399198 | 5399198 | 20241026040028_XM5If | UK009S | 2024-10-28T12:19:50.958Z | 2024-11-03T14:27:39.208Z |
5399190 | 5399190 | 20241026040020_gCgy8 | UK009S | 2024-10-28T12:19:50.893Z | 2024-11-03T14:27:39.195Z |
5399168 | 5399168 | 20241026035758_sfM3v | UK009S | 2024-10-28T12:19:50.313Z | 2024-11-03T14:27:39.167Z |
5399084 | 5399084 | 20241026034919_IsFTH | UK009S | 2024-10-28T12:19:48.143Z | 2024-11-03T14:27:39.008Z |
5398586 | 5398586 | 20241026031024_nkSHF | UK009S | 2024-10-28T12:19:23.491Z | 2024-11-03T14:27:36.885Z |
5398477 | 5398477 | 20241026030057_aCl50 | UK009S | 2024-10-28T12:19:18.837Z | 2024-11-03T14:27:36.575Z |
5398235 | 5398235 | 20241026023612_bYtns | UK009S | 2024-10-28T12:19:06.875Z | 2024-11-03T14:27:35.713Z |
5398205 | 5398205 | 20241026023518_Pb2rd | UK009S | 2024-10-28T12:19:06.174Z | 2024-11-03T14:27:35.689Z |
5398001 | 5398001 | 20241026021450_MFIxW | UK009S | 2024-10-28T12:18:55.442Z | 2024-11-03T14:27:34.811Z |
5397889 | 5397889 | 20241026020428_H3QDN | UK009S | 2024-10-28T12:18:49.209Z | 2024-11-03T14:27:34.443Z |
5397738 | 5397738 | 20241026015229_oB2QR | UK009S | 2024-10-28T12:18:38.055Z | 2024-11-03T14:27:34.023Z |
5397734 | 5397734 | 20241026015222_3AwY0 | UK009S | 2024-10-28T12:18:37.935Z | 2024-11-03T14:27:34.021Z |
5397608 | 5397608 | 20241026014323_0JfB6 | UK009S | 2024-10-28T12:18:30.171Z | 2024-11-03T14:27:33.560Z |
5397596 | 5397596 | 20241026014214_3AXVd | UK009S | 2024-10-28T12:18:29.389Z | 2024-11-03T14:27:33.438Z |
5397371 | 5397371 | 20241026012418_Orzip | UK009S | 2024-10-28T12:18:18.391Z | 2024-11-03T14:27:32.758Z |
5397357 | 5397357 | 20241026012135_bayza | UK009S | 2024-10-28T12:18:17.975Z | 2024-11-03T14:27:32.728Z |
5397260 | 5397260 | 20241026011359_zP3Ik | UK009S | 2024-10-28T12:18:13.609Z | 2024-11-03T14:27:32.464Z |
5397219 | 5397219 | 20241026011130_jf8xS | UK009S | 2024-10-28T12:18:11.604Z | 2024-11-03T14:27:32.206Z |
5397187 | 5397187 | 20241026010810_drk4K | UK009S | 2024-10-28T12:18:10.565Z | 2024-11-03T14:27:32.150Z |
5397159 | 5397159 | 20241026010640_8KjOL | UK009S | 2024-10-28T12:18:09.645Z | 2024-11-03T14:27:32.113Z |
5396908 | 5396908 | 20241026004441_kvqiH | UK009S | 2024-10-28T12:17:59.023Z | 2024-11-03T14:27:31.304Z |
5396850 | 5396850 | 20241026004126_7IriY | UK009S | 2024-10-28T12:17:57.700Z | 2024-11-03T14:27:31.212Z |
5396766 | 5396766 | 20241026003140_rI23K | UK009S | 2024-10-28T12:17:55.341Z | 2024-11-03T14:27:30.862Z |
5396749 | 5396749 | 20241026002953_Eyd7d | UK009S | 2024-10-28T12:17:54.983Z | 2024-11-03T14:27:30.839Z |
5396234 | 5396234 | 20241025234948_VPgqa | UK009S | 2024-10-28T12:17:28.277Z | 2024-11-03T14:27:28.986Z |
5396122 | 5396122 | 20241025234132_irMl3 | UK009S | 2024-10-28T12:17:19.242Z | 2024-11-03T14:27:28.601Z |
5396117 | 5396117 | 20241025234128_SH2JL | UK009S | 2024-10-28T12:17:19.101Z | 2024-11-03T14:27:28.587Z |
5395924 | 5395924 | 20241025232312_9QY2B | UK009S | 2024-10-28T12:17:05.207Z | 2024-11-03T14:27:27.621Z |
5395773 | 5395773 | 20241025231004_8fh27 | UK009S | 2024-10-28T12:16:49.281Z | 2024-11-03T14:27:26.681Z |
5395764 | 5395764 | 20241025230931_Aoyd5 | UK009S | 2024-10-28T12:16:47.962Z | 2024-11-03T14:27:26.660Z |
5395642 | 5395642 | 20241025230121_DZbcH | UK009S | 2024-10-28T12:16:35.280Z | 2024-11-03T14:27:26.308Z |
5395284 | 5395284 | 20241025222924_jrEqm | UK009S | 2024-10-28T12:16:04.448Z | 2024-11-03T14:27:24.575Z |
5395241 | 5395241 | 20241025222614_RblmZ | UK009S | 2024-10-28T12:16:02.795Z | 2024-11-03T14:27:24.393Z |
5395050 | 5395050 | 20241025220304_WlNoh | UK009S | 2024-10-28T12:15:54.534Z | 2024-11-03T14:27:23.781Z |
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);