participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
743 rows where station_code = "UK009U" 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 |
---|---|---|---|---|---|
5135308 | 5135308 | 20240915034452_7Om9l | UK009U | 2024-09-19T12:19:12.501Z | 2024-09-19T12:19:12.501Z |
5133966 | 5133966 | 20240916042310_YEvo7 | UK009U | 2024-09-19T12:17:14.523Z | 2024-09-19T12:17:14.523Z |
5133951 | 5133951 | 20240916041942_aX270 | UK009U | 2024-09-19T12:17:13.871Z | 2024-09-19T12:17:13.871Z |
5133938 | 5133938 | 20240916041901_tzT48 | UK009U | 2024-09-19T12:17:13.754Z | 2024-09-19T12:17:13.754Z |
5133904 | 5133904 | 20240916041710_QOsCQ | UK009U | 2024-09-19T12:17:12.819Z | 2024-09-19T12:17:12.819Z |
5133806 | 5133806 | 20240916040602_bYLGY | UK009U | 2024-09-19T12:17:08.308Z | 2024-09-19T12:17:08.308Z |
5133772 | 5133772 | 20240916040459_6QbTj | UK009U | 2024-09-19T12:17:07.501Z | 2024-09-19T12:17:07.501Z |
5133734 | 5133734 | 20240916040118_72rcZ | UK009U | 2024-09-19T12:17:06.725Z | 2024-09-19T12:17:06.725Z |
5133703 | 5133703 | 20240916035130_ixNe7 | UK009U | 2024-09-19T12:17:05.534Z | 2024-09-19T12:17:05.534Z |
5133682 | 5133682 | 20240916035019_gZBwP | UK009U | 2024-09-19T12:17:05.213Z | 2024-09-19T12:17:05.213Z |
5133504 | 5133504 | 20240916033352_DmaLk | UK009U | 2024-09-19T12:17:00.003Z | 2024-09-19T12:17:00.003Z |
5133142 | 5133142 | 20240916030148_31ILJ | UK009U | 2024-09-19T12:16:45.577Z | 2024-09-19T12:16:45.577Z |
5133004 | 5133004 | 20240916024224_IvLx2 | UK009U | 2024-09-19T12:16:40.551Z | 2024-09-19T12:16:40.551Z |
5132942 | 5132942 | 20240916023025_7bUPG | UK009U | 2024-09-19T12:16:38.045Z | 2024-09-19T12:16:38.045Z |
5132847 | 5132847 | 20240916022134_cUpiw | UK009U | 2024-09-19T12:16:34.404Z | 2024-09-19T12:16:34.404Z |
5132702 | 5132702 | 20240916015931_Bis2O | UK009U | 2024-09-19T12:16:28.585Z | 2024-09-19T12:16:28.585Z |
5132585 | 5132585 | 20240916013728_TLFSN | UK009U | 2024-09-19T12:16:20.419Z | 2024-09-19T12:16:20.419Z |
5132577 | 5132577 | 20240916013356_2Cxen | UK009U | 2024-09-19T12:16:19.627Z | 2024-09-19T12:16:19.627Z |
5132466 | 5132466 | 20240916011515_Zrmnt | UK009U | 2024-09-19T12:16:13.923Z | 2024-09-19T12:16:13.923Z |
5132424 | 5132424 | 20240916010512_5lgHa | UK009U | 2024-09-19T12:16:12.018Z | 2024-09-19T12:16:12.018Z |
5132358 | 5132358 | 20240916005037_rslEv | UK009U | 2024-09-19T12:16:09.291Z | 2024-09-19T12:16:09.291Z |
5132059 | 5132059 | 20240915225807_0pz6L | UK009U | 2024-09-19T12:15:47.035Z | 2024-09-19T12:15:47.035Z |
5131855 | 5131855 | 20240915214824_cFSdO | UK009U | 2024-09-19T12:15:30.673Z | 2024-09-19T12:15:30.673Z |
5128391 | 5128391 | 20240917013344_8bUeG | UK009U | 2024-09-19T12:10:30.305Z | 2024-09-19T12:10:30.305Z |
5116763 | 5116763 | 20240915034018_8sSmw | UK009U | 2024-09-18T12:07:20.178Z | 2024-09-19T12:19:12.313Z |
5116519 | 5116519 | 20240915033030_5Zu31 | UK009U | 2024-09-18T12:07:08.342Z | 2024-09-19T12:19:11.432Z |
5116168 | 5116168 | 20240915031254_FwXDE | UK009U | 2024-09-18T12:06:45.632Z | 2024-09-19T12:19:09.097Z |
5116043 | 5116043 | 20240915030422_BjdsF | UK009U | 2024-09-18T12:06:35.056Z | 2024-09-19T12:19:08.235Z |
5115909 | 5115909 | 20240915025912_eze3N | UK009U | 2024-09-18T12:06:31.499Z | 2024-09-19T12:19:07.807Z |
5114632 | 5114632 | 20240915015225_PAl02 | UK009U | 2024-09-18T12:05:25.859Z | 2024-09-19T12:18:59.082Z |
5114497 | 5114497 | 20240915014441_aDP0R | UK009U | 2024-09-18T12:05:19.775Z | 2024-09-19T12:18:58.559Z |
5114386 | 5114386 | 20240915014044_iD3CJ | UK009U | 2024-09-18T12:05:14.128Z | 2024-09-19T12:18:57.925Z |
5113933 | 5113933 | 20240915012025_uhUMW | UK009U | 2024-09-18T12:04:55.862Z | 2024-09-19T12:18:54.474Z |
5113906 | 5113906 | 20240915011813_4rPkM | UK009U | 2024-09-18T12:04:55.120Z | 2024-09-19T12:18:54.250Z |
5113766 | 5113766 | 20240915011105_IiwPt | UK009U | 2024-09-18T12:04:49.297Z | 2024-09-19T12:18:51.854Z |
5113639 | 5113639 | 20240915010131_ao2gb | UK009U | 2024-09-18T12:04:35.808Z | 2024-09-19T12:18:50.699Z |
5113556 | 5113556 | 20240915005823_LCrNE | UK009U | 2024-09-18T12:04:29.908Z | 2024-09-19T12:18:50.373Z |
5113281 | 5113281 | 20240915003517_LfTxr | UK009U | 2024-09-18T12:04:05.540Z | 2024-09-19T12:18:48.353Z |
5113216 | 5113216 | 20240915003210_PtWdE | UK009U | 2024-09-18T12:04:03.183Z | 2024-09-19T12:18:48.003Z |
5112895 | 5112895 | 20240915000407_OizCB | UK009U | 2024-09-18T12:03:45.403Z | 2024-09-19T12:18:45.519Z |
5112264 | 5112264 | 20240914224747_14gv3 | UK009U | 2024-09-18T12:02:57.165Z | 2024-09-19T12:18:40.240Z |
5112145 | 5112145 | 20240914222537_yN6EK | UK009U | 2024-09-18T12:02:49.873Z | 2024-09-19T12:18:38.649Z |
5110395 | 5110395 | 20240912030013_O0Leh | UK009U | 2024-09-17T12:16:43.910Z | 2024-09-19T12:21:14.622Z |
5094849 | 5094849 | 20240912042556_x1sh4 | UK009U | 2024-09-16T12:14:59.344Z | 2024-09-19T12:21:16.447Z |
5094743 | 5094743 | 20240912042058_6TkcY | UK009U | 2024-09-16T12:14:57.447Z | 2024-09-19T12:21:16.409Z |
5094652 | 5094652 | 20240912041421_mhOs2 | UK009U | 2024-09-16T12:14:53.122Z | 2024-09-19T12:21:16.340Z |
5094622 | 5094622 | 20240912041229_dzmcA | UK009U | 2024-09-16T12:14:52.550Z | 2024-09-19T12:21:16.331Z |
5094512 | 5094512 | 20240912040615_3I3yW | UK009U | 2024-09-16T12:14:49.070Z | 2024-09-19T12:21:16.189Z |
5094499 | 5094499 | 20240912040602_PFOOw | UK009U | 2024-09-16T12:14:48.680Z | 2024-09-19T12:21:16.183Z |
5094385 | 5094385 | 20240912035914_LegIv | UK009U | 2024-09-16T12:14:43.114Z | 2024-09-19T12:21:16.097Z |
5094331 | 5094331 | 20240912035726_MvYSU | UK009U | 2024-09-16T12:14:41.442Z | 2024-09-19T12:21:16.072Z |
5094153 | 5094153 | 20240912035145_3lqZ8 | UK009U | 2024-09-16T12:14:37.385Z | 2024-09-19T12:21:15.904Z |
5094119 | 5094119 | 20240912034856_WwawY | UK009U | 2024-09-16T12:14:35.171Z | 2024-09-19T12:21:15.891Z |
5094056 | 5094056 | 20240912034632_TZRoc | UK009U | 2024-09-16T12:14:32.788Z | 2024-09-19T12:21:15.854Z |
5093738 | 5093738 | 20240912033357_uP31N | UK009U | 2024-09-16T12:14:24.686Z | 2024-09-19T12:21:15.628Z |
5093617 | 5093617 | 20240912032851_jTyya | UK009U | 2024-09-16T12:14:22.631Z | 2024-09-19T12:21:15.528Z |
5093383 | 5093383 | 20240912031937_Gkdyr | UK009U | 2024-09-16T12:14:16.120Z | 2024-09-19T12:21:15.298Z |
5093226 | 5093226 | 20240912031506_uvmvL | UK009U | 2024-09-16T12:14:13.427Z | 2024-09-19T12:21:15.021Z |
5093164 | 5093164 | 20240912031253_ABOb4 | UK009U | 2024-09-16T12:14:12.413Z | 2024-09-19T12:21:14.989Z |
5093106 | 5093106 | 20240912031124_CDBfh | UK009U | 2024-09-16T12:14:11.685Z | 2024-09-19T12:21:14.943Z |
5092859 | 5092859 | 20240912030003_9J4oV | UK009U | 2024-09-16T12:14:05.558Z | 2024-09-19T12:21:14.616Z |
5092818 | 5092818 | 20240912025925_IS24K | UK009U | 2024-09-16T12:14:04.920Z | 2024-09-19T12:21:14.595Z |
5092318 | 5092318 | 20240912024211_aj3XV | UK009U | 2024-09-16T12:13:47.914Z | 2024-09-19T12:21:13.822Z |
5092121 | 5092121 | 20240912023649_Dol26 | UK009U | 2024-09-16T12:13:40.936Z | 2024-09-19T12:21:13.656Z |
5091922 | 5091922 | 20240912022808_XB8yk | UK009U | 2024-09-16T12:13:31.264Z | 2024-09-19T12:21:13.479Z |
5091633 | 5091633 | 20240912021551_2PdfP | UK009U | 2024-09-16T12:13:14.047Z | 2024-09-19T12:21:13.270Z |
5091607 | 5091607 | 20240912021508_y6TK3 | UK009U | 2024-09-16T12:13:13.005Z | 2024-09-19T12:21:13.247Z |
5091404 | 5091404 | 20240912020804_wspDM | UK009U | 2024-09-16T12:13:05.073Z | 2024-09-19T12:21:12.998Z |
5091366 | 5091366 | 20240912020650_wxlwg | UK009U | 2024-09-16T12:13:02.993Z | 2024-09-19T12:21:12.951Z |
5091134 | 5091134 | 20240912015814_jXe3P | UK009U | 2024-09-16T12:12:50.267Z | 2024-09-19T12:21:12.575Z |
5090999 | 5090999 | 20240912015538_aVAWu | UK009U | 2024-09-16T12:12:46.349Z | 2024-09-19T12:21:12.448Z |
5090411 | 5090411 | 20240912012419_mPZCp | UK009U | 2024-09-16T12:12:18.870Z | 2024-09-19T12:21:11.293Z |
5090187 | 5090187 | 20240912011434_FAVx6 | UK009U | 2024-09-16T12:12:06.163Z | 2024-09-19T12:21:11.059Z |
5090140 | 5090140 | 20240912011204_ejuB8 | UK009U | 2024-09-16T12:12:01.658Z | 2024-09-19T12:21:10.989Z |
5090106 | 5090106 | 20240912011104_GijBU | UK009U | 2024-09-16T12:12:00.423Z | 2024-09-19T12:21:10.972Z |
5090087 | 5090087 | 20240912011044_xMpqB | UK009U | 2024-09-16T12:12:00.052Z | 2024-09-19T12:21:10.967Z |
5090042 | 5090042 | 20240912010731_xozc3 | UK009U | 2024-09-16T12:11:57.077Z | 2024-09-19T12:21:10.939Z |
5089918 | 5089918 | 20240912010230_ZYdiN | UK009U | 2024-09-16T12:11:49.109Z | 2024-09-19T12:21:10.613Z |
5089849 | 5089849 | 20240912005940_hQXW8 | UK009U | 2024-09-16T12:11:46.079Z | 2024-09-19T12:21:10.576Z |
5089536 | 5089536 | 20240912004829_NYYW4 | UK009U | 2024-09-16T12:11:28.674Z | 2024-09-19T12:21:10.029Z |
5089395 | 5089395 | 20240912003848_dkHvt | UK009U | 2024-09-16T12:11:22.538Z | 2024-09-19T12:21:09.912Z |
5089377 | 5089377 | 20240912003834_PhLaY | UK009U | 2024-09-16T12:11:22.307Z | 2024-09-19T12:21:09.909Z |
5089113 | 5089113 | 20240912002626_qEzWN | UK009U | 2024-09-16T12:11:15.175Z | 2024-09-19T12:21:09.744Z |
5089081 | 5089081 | 20240912002541_eQh3U | UK009U | 2024-09-16T12:11:14.830Z | 2024-09-19T12:21:09.740Z |
5089000 | 5089000 | 20240912001742_K4Gki | UK009U | 2024-09-16T12:11:11.345Z | 2024-09-19T12:21:09.644Z |
5088931 | 5088931 | 20240912001235_VG35c | UK009U | 2024-09-16T12:11:09.415Z | 2024-09-19T12:21:09.608Z |
5079480 | 5079480 | 20240911025748_BLxey | UK009U | 2024-09-15T12:16:22.532Z | 2024-09-19T12:21:42.293Z |
5077730 | 5077730 | 20240911011302_YqjsE | UK009U | 2024-09-15T12:15:02.233Z | 2024-09-19T12:21:39.575Z |
5077108 | 5077108 | 20240911002342_mE6fx | UK009U | 2024-09-15T12:14:23.593Z | 2024-09-19T12:21:38.208Z |
5075717 | 5075717 | 20240912000243_pBiGC | UK009U | 2024-09-15T12:10:09.452Z | 2024-09-19T12:21:09.449Z |
5075668 | 5075668 | 20240912000100_8ZvS0 | UK009U | 2024-09-15T12:10:07.575Z | 2024-09-19T12:21:09.424Z |
5075446 | 5075446 | 20240911234840_ofVV2 | UK009U | 2024-09-15T12:09:45.803Z | 2024-09-19T12:21:09.212Z |
5069929 | 5069929 | 20240910221634_hHCYL | UK009U | 2024-09-14T12:20:09.676Z | 2024-09-19T12:21:35.464Z |
5069664 | 5069664 | 20240910215713_m0Yjn | UK009U | 2024-09-14T12:20:03.300Z | 2024-09-19T12:21:35.230Z |
5060767 | 5060767 | 20240910210459_GkvLH | UK009U | 2024-09-14T12:09:31.139Z | 2024-09-19T12:21:33.573Z |
5060270 | 5060270 | 20240910201412_1tHVn | UK009U | 2024-09-14T12:08:34.394Z | 2024-09-19T12:21:32.039Z |
5060202 | 5060202 | 20240910200706_xPGRx | UK009U | 2024-09-14T12:08:29.216Z | 2024-09-19T12:21:32.002Z |
5008307 | 5008307 | 20240903233125_Ihuc8 | UK009U | 2024-09-09T12:06:36.607Z | 2024-09-12T12:19:17.014Z |
5008138 | 5008138 | 20240903230637_XO6cY | UK009U | 2024-09-09T12:06:28.275Z | 2024-09-12T12:19:16.305Z |
5008016 | 5008016 | 20240903225414_1cKbM | UK009U | 2024-09-09T12:06:19.278Z | 2024-09-12T12:19:15.856Z |
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);