participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,567 rows where station_code = "UK0004" 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 |
---|---|---|---|---|---|
5128789 | 5128789 | 20240917023914_nzNSY | UK0004 | 2024-09-19T12:11:02.027Z | 2024-09-19T12:11:02.027Z |
5128786 | 5128786 | 20240917023533_BH8UM | UK0004 | 2024-09-19T12:11:01.467Z | 2024-09-19T12:11:01.467Z |
5128528 | 5128528 | 20240917015733_gDg1F | UK0004 | 2024-09-19T12:10:41.183Z | 2024-09-19T12:10:41.183Z |
5128315 | 5128315 | 20240917012548_PybtW | UK0004 | 2024-09-19T12:10:26.565Z | 2024-09-19T12:10:26.565Z |
5128262 | 5128262 | 20240917011136_6GJGM | UK0004 | 2024-09-19T12:10:22.338Z | 2024-09-19T12:10:22.338Z |
5127925 | 5127925 | 20240917000518_ymau4 | UK0004 | 2024-09-19T12:09:47.056Z | 2024-09-19T12:09:47.056Z |
5127753 | 5127753 | 20240916232311_8V4um | UK0004 | 2024-09-19T12:09:36.433Z | 2024-09-19T12:09:36.433Z |
5127725 | 5127725 | 20240916231123_Yg20l | UK0004 | 2024-09-19T12:09:34.590Z | 2024-09-19T12:09:34.590Z |
5127712 | 5127712 | 20240916230701_f72yp | UK0004 | 2024-09-19T12:09:33.723Z | 2024-09-19T12:09:33.723Z |
5127478 | 5127478 | 20240916221051_U3b5a | UK0004 | 2024-09-19T12:09:14.468Z | 2024-09-19T12:09:14.468Z |
5127426 | 5127426 | 20240916214941_Ec293 | UK0004 | 2024-09-19T12:09:06.472Z | 2024-09-19T12:09:06.472Z |
5126885 | 5126885 | 20240916194559_2lTHx | UK0004 | 2024-09-19T12:07:33.676Z | 2024-09-19T12:07:33.676Z |
5125593 | 5125593 | 20240918030454_PzTLA | UK0004 | 2024-09-19T12:03:36.207Z | 2024-09-19T12:06:42.055Z |
5125087 | 5125087 | 20240918000711_h8IDR | UK0004 | 2024-09-19T12:02:14.496Z | 2024-09-19T12:06:41.975Z |
5121793 | 5121793 | 20240914041439_BclDK | UK0004 | 2024-09-18T12:11:01.417Z | 2024-09-19T12:20:02.369Z |
5121553 | 5121553 | 20240914040827_9O551 | UK0004 | 2024-09-18T12:10:58.283Z | 2024-09-19T12:20:02.088Z |
5121465 | 5121465 | 20240914040354_STmA2 | UK0004 | 2024-09-18T12:10:56.855Z | 2024-09-19T12:20:01.907Z |
5121167 | 5121167 | 20240914035440_zfJJC | UK0004 | 2024-09-18T12:10:52.106Z | 2024-09-19T12:20:01.464Z |
5120559 | 5120559 | 20240914032801_Gq8pV | UK0004 | 2024-09-18T12:10:43.124Z | 2024-09-19T12:20:00.565Z |
5120198 | 5120198 | 20240914030432_ofW5X | UK0004 | 2024-09-18T12:10:34.351Z | 2024-09-19T12:19:59.640Z |
5120061 | 5120061 | 20240914025821_3O2iZ | UK0004 | 2024-09-18T12:10:31.620Z | 2024-09-19T12:19:59.363Z |
5120005 | 5120005 | 20240914025625_lO87G | UK0004 | 2024-09-18T12:10:31.070Z | 2024-09-19T12:19:59.301Z |
5119752 | 5119752 | 20240914024800_g2wv1 | UK0004 | 2024-09-18T12:10:25.652Z | 2024-09-19T12:19:58.875Z |
5119642 | 5119642 | 20240914024101_F7KB2 | UK0004 | 2024-09-18T12:10:22.798Z | 2024-09-19T12:19:58.615Z |
5119611 | 5119611 | 20240914024004_DBTib | UK0004 | 2024-09-18T12:10:22.636Z | 2024-09-19T12:19:58.593Z |
5119538 | 5119538 | 20240914023837_UfZw2 | UK0004 | 2024-09-18T12:10:22.187Z | 2024-09-19T12:19:58.485Z |
5119462 | 5119462 | 20240914023600_2u6WP | UK0004 | 2024-09-18T12:10:21.526Z | 2024-09-19T12:19:58.286Z |
5119397 | 5119397 | 20240914023117_zHIDQ | UK0004 | 2024-09-18T12:10:20.763Z | 2024-09-19T12:19:58.115Z |
5119239 | 5119239 | 20240914021832_IPZrP | UK0004 | 2024-09-18T12:10:18.774Z | 2024-09-19T12:19:57.474Z |
5117395 | 5117395 | 20240915042632_rWIzu | UK0004 | 2024-09-18T12:07:40.039Z | 2024-09-19T12:19:14.819Z |
5117339 | 5117339 | 20240915041928_38V2e | UK0004 | 2024-09-18T12:07:38.064Z | 2024-09-19T12:19:14.339Z |
5117313 | 5117313 | 20240915041735_Zsh12 | UK0004 | 2024-09-18T12:07:37.736Z | 2024-09-19T12:19:14.272Z |
5117047 | 5117047 | 20240915035814_CY30F | UK0004 | 2024-09-18T12:07:30.917Z | 2024-09-19T12:19:13.191Z |
5116791 | 5116791 | 20240915034250_fike3 | UK0004 | 2024-09-18T12:07:21.242Z | 2024-09-19T12:19:12.403Z |
5116658 | 5116658 | 20240915033422_KaH04 | UK0004 | 2024-09-18T12:07:14.905Z | 2024-09-19T12:19:11.859Z |
5116511 | 5116511 | 20240915033030_5Zu31 | UK0004 | 2024-09-18T12:07:08.342Z | 2024-09-19T12:19:11.432Z |
5116420 | 5116420 | 20240915032539_9leAG | UK0004 | 2024-09-18T12:07:01.982Z | 2024-09-19T12:19:11.103Z |
5116306 | 5116306 | 20240915032028_Q31Uc | UK0004 | 2024-09-18T12:06:56.137Z | 2024-09-19T12:19:10.288Z |
5115636 | 5115636 | 20240915024646_wH3WO | UK0004 | 2024-09-18T12:06:19.919Z | 2024-09-19T12:19:05.848Z |
5115487 | 5115487 | 20240915024141_HqUoh | UK0004 | 2024-09-18T12:06:16.017Z | 2024-09-19T12:19:05.057Z |
5115477 | 5115477 | 20240915024134_YdZw3 | UK0004 | 2024-09-18T12:06:15.888Z | 2024-09-19T12:19:04.990Z |
5114869 | 5114869 | 20240915020208_wRoJF | UK0004 | 2024-09-18T12:05:38.781Z | 2024-09-19T12:19:00.424Z |
5114483 | 5114483 | 20240915014441_aDP0R | UK0004 | 2024-09-18T12:05:19.775Z | 2024-09-19T12:18:58.558Z |
5114374 | 5114374 | 20240915014044_iD3CJ | UK0004 | 2024-09-18T12:05:14.128Z | 2024-09-19T12:18:57.925Z |
5114250 | 5114250 | 20240915013349_gnE23 | UK0004 | 2024-09-18T12:05:08.913Z | 2024-09-19T12:18:57.327Z |
5114059 | 5114059 | 20240915012355_aWv0t | UK0004 | 2024-09-18T12:05:00.226Z | 2024-09-19T12:18:55.509Z |
5113358 | 5113358 | 20240915003928_6K3G8 | UK0004 | 2024-09-18T12:04:09.826Z | 2024-09-19T12:18:48.598Z |
5112488 | 5112488 | 20240914232111_dupQg | UK0004 | 2024-09-18T12:03:10.669Z | 2024-09-19T12:18:41.164Z |
5112196 | 5112196 | 20240914223551_aQkt1 | UK0004 | 2024-09-18T12:02:53.061Z | 2024-09-19T12:18:39.214Z |
5111925 | 5111925 | 20240914214238_Ps1ut | UK0004 | 2024-09-18T12:02:31.113Z | 2024-09-19T12:18:35.291Z |
5111851 | 5111851 | 20240914212409_KHtgx | UK0004 | 2024-09-18T12:02:22.628Z | 2024-09-19T12:18:34.652Z |
5111844 | 5111844 | 20240914212216_UMATW | UK0004 | 2024-09-18T12:02:20.452Z | 2024-09-19T12:18:34.627Z |
5111531 | 5111531 | 20240914204443_1i0n6 | UK0004 | 2024-09-18T12:02:01.203Z | 2024-09-19T12:18:31.071Z |
5111162 | 5111162 | 20240914200831_cF5f0 | UK0004 | 2024-09-18T12:01:41.377Z | 2024-09-19T12:18:27.189Z |
5111153 | 5111153 | 20240914200831_aR3Zk | UK0004 | 2024-09-18T12:01:41.204Z | 2024-09-19T12:18:27.165Z |
5111031 | 5111031 | 20240914194409_MAqnU | UK0004 | 2024-09-18T12:01:21.356Z | 2024-09-19T12:18:25.497Z |
5110934 | 5110934 | 20240914193007_bLy1e | UK0004 | 2024-09-18T12:01:13.359Z | 2024-09-19T12:18:24.881Z |
5108079 | 5108079 | 20240913042229_1fef9 | UK0004 | 2024-09-17T12:13:30.314Z | 2024-09-19T12:20:47.836Z |
5107815 | 5107815 | 20240913041111_ppxsb | UK0004 | 2024-09-17T12:13:24.052Z | 2024-09-19T12:20:47.566Z |
5107594 | 5107594 | 20240913040418_nyTHn | UK0004 | 2024-09-17T12:13:17.708Z | 2024-09-19T12:20:47.295Z |
5107531 | 5107531 | 20240913035852_195hD | UK0004 | 2024-09-17T12:13:16.650Z | 2024-09-19T12:20:47.208Z |
5107319 | 5107319 | 20240913035244_r9TG4 | UK0004 | 2024-09-17T12:13:13.233Z | 2024-09-19T12:20:47.002Z |
5107126 | 5107126 | 20240913034510_dBYnT | UK0004 | 2024-09-17T12:13:09.519Z | 2024-09-19T12:20:46.844Z |
5107104 | 5107104 | 20240913034502_w3gxO | UK0004 | 2024-09-17T12:13:09.360Z | 2024-09-19T12:20:46.842Z |
5106807 | 5106807 | 20240913033538_U5EMJ | UK0004 | 2024-09-17T12:13:02.037Z | 2024-09-19T12:20:46.442Z |
5106733 | 5106733 | 20240913033306_XUFcm | UK0004 | 2024-09-17T12:13:00.091Z | 2024-09-19T12:20:46.303Z |
5105378 | 5105378 | 20240913024341_ZdaEM | UK0004 | 2024-09-17T12:12:12.327Z | 2024-09-19T12:20:44.388Z |
5105092 | 5105092 | 20240913023005_SZnmf | UK0004 | 2024-09-17T12:11:54.465Z | 2024-09-19T12:20:43.504Z |
5104945 | 5104945 | 20240913022446_Dmclr | UK0004 | 2024-09-17T12:11:47.351Z | 2024-09-19T12:20:43.130Z |
5104906 | 5104906 | 20240913022346_wH8wQ | UK0004 | 2024-09-17T12:11:46.470Z | 2024-09-19T12:20:43.109Z |
5104841 | 5104841 | 20240913022156_n3Bko | UK0004 | 2024-09-17T12:11:45.409Z | 2024-09-19T12:20:43.058Z |
5104606 | 5104606 | 20240913021743_Ctcvz | UK0004 | 2024-09-17T12:11:41.209Z | 2024-09-19T12:20:42.636Z |
5104566 | 5104566 | 20240913021513_Xr6d8 | UK0004 | 2024-09-17T12:11:39.404Z | 2024-09-19T12:20:41.701Z |
5104485 | 5104485 | 20240913021141_amQg3 | UK0004 | 2024-09-17T12:11:36.814Z | 2024-09-19T12:20:41.535Z |
5104274 | 5104274 | 20240913020159_43ImQ | UK0004 | 2024-09-17T12:11:31.539Z | 2024-09-19T12:20:41.307Z |
5103924 | 5103924 | 20240913014410_zSz3m | UK0004 | 2024-09-17T12:11:17.608Z | 2024-09-19T12:20:40.673Z |
5103806 | 5103806 | 20240913014047_z3EeP | UK0004 | 2024-09-17T12:11:11.587Z | 2024-09-19T12:20:40.580Z |
5103659 | 5103659 | 20240913013551_Kikf3 | UK0004 | 2024-09-17T12:11:07.705Z | 2024-09-19T12:20:40.420Z |
5103491 | 5103491 | 20240913013140_oIZ4q | UK0004 | 2024-09-17T12:11:00.411Z | 2024-09-19T12:20:40.227Z |
5103467 | 5103467 | 20240913013101_XK3yS | UK0004 | 2024-09-17T12:10:58.532Z | 2024-09-19T12:20:40.189Z |
5103191 | 5103191 | 20240914020407_gEqPb | UK0004 | 2024-09-17T12:07:56.967Z | 2024-09-19T12:19:56.806Z |
5102956 | 5102956 | 20240914015535_a14ii | UK0004 | 2024-09-17T12:07:45.127Z | 2024-09-19T12:19:56.216Z |
5102837 | 5102837 | 20240914014853_hZZaJ | UK0004 | 2024-09-17T12:07:39.243Z | 2024-09-19T12:19:55.858Z |
5102324 | 5102324 | 20240914011955_nqXk7 | UK0004 | 2024-09-17T12:07:02.050Z | 2024-09-19T12:19:53.506Z |
5101991 | 5101991 | 20240914005823_B2qmT | UK0004 | 2024-09-17T12:06:37.313Z | 2024-09-19T12:19:52.126Z |
5101867 | 5101867 | 20240914005300_qjs2H | UK0004 | 2024-09-17T12:06:18.950Z | 2024-09-19T12:19:51.735Z |
5101861 | 5101861 | 20240914005258_VOnjM | UK0004 | 2024-09-17T12:06:18.703Z | 2024-09-19T12:19:51.721Z |
5101081 | 5101081 | 20240914000036_C3ZTv | UK0004 | 2024-09-17T12:05:18.191Z | 2024-09-19T12:19:49.664Z |
5101071 | 5101071 | 20240914000036_CD4f4 | UK0004 | 2024-09-17T12:05:17.926Z | 2024-09-19T12:19:49.651Z |
5100486 | 5100486 | 20240913232838_Zt08a | UK0004 | 2024-09-17T12:04:36.606Z | 2024-09-19T12:19:48.057Z |
5100220 | 5100220 | 20240913230702_TG3Ey | UK0004 | 2024-09-17T12:04:19.512Z | 2024-09-19T12:19:47.330Z |
5100116 | 5100116 | 20240913225343_D4wrg | UK0004 | 2024-09-17T12:03:59.304Z | 2024-09-19T12:19:46.943Z |
5100070 | 5100070 | 20240913224611_5xHJx | UK0004 | 2024-09-17T12:03:56.028Z | 2024-09-19T12:19:46.824Z |
5099891 | 5099891 | 20240913222044_FYxaB | UK0004 | 2024-09-17T12:03:42.452Z | 2024-09-19T12:19:46.312Z |
5099088 | 5099088 | 20240913202135_Rq0o6 | UK0004 | 2024-09-17T12:02:19.113Z | 2024-09-19T12:19:43.385Z |
5097797 | 5097797 | 20240913010444_xlrsA | UK0004 | 2024-09-16T12:17:15.039Z | 2024-09-19T12:20:38.988Z |
5097133 | 5097133 | 20240913003318_ISyzp | UK0004 | 2024-09-16T12:17:05.919Z | 2024-09-19T12:20:37.557Z |
5094730 | 5094730 | 20240912042058_6TkcY | UK0004 | 2024-09-16T12:14:57.447Z | 2024-09-19T12:21:16.409Z |
5094604 | 5094604 | 20240912041229_dzmcA | UK0004 | 2024-09-16T12:14:52.549Z | 2024-09-19T12:21:16.331Z |
5094398 | 5094398 | 20240912035953_GD21O | UK0004 | 2024-09-16T12:14:44.039Z | 2024-09-19T12:21:16.102Z |
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);