participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,318 rows where station_code = "UK009J" 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 |
---|---|---|---|---|---|
5134026 | 5134026 | 20240916043241_NJB1J | UK009J | 2024-09-19T12:17:16.536Z | 2024-09-19T12:17:16.536Z |
5134000 | 5134000 | 20240916042843_lX3HC | UK009J | 2024-09-19T12:17:15.621Z | 2024-09-19T12:17:15.621Z |
5133915 | 5133915 | 20240916041805_DQZme | UK009J | 2024-09-19T12:17:13.076Z | 2024-09-19T12:17:13.076Z |
5133714 | 5133714 | 20240916035225_gJ1M7 | UK009J | 2024-09-19T12:17:05.732Z | 2024-09-19T12:17:05.732Z |
5133702 | 5133702 | 20240916035130_ixNe7 | UK009J | 2024-09-19T12:17:05.534Z | 2024-09-19T12:17:05.534Z |
5133529 | 5133529 | 20240916033639_vK8Iz | UK009J | 2024-09-19T12:17:00.642Z | 2024-09-19T12:17:00.642Z |
5133417 | 5133417 | 20240916032947_7LIC4 | UK009J | 2024-09-19T12:16:56.221Z | 2024-09-19T12:16:56.221Z |
5133241 | 5133241 | 20240916031216_Py6bX | UK009J | 2024-09-19T12:16:51.137Z | 2024-09-19T12:16:51.137Z |
5133141 | 5133141 | 20240916030148_31ILJ | UK009J | 2024-09-19T12:16:45.577Z | 2024-09-19T12:16:45.577Z |
5133086 | 5133086 | 20240916025101_HAzlq | UK009J | 2024-09-19T12:16:43.739Z | 2024-09-19T12:16:43.739Z |
5132828 | 5132828 | 20240916021859_cSIb1 | UK009J | 2024-09-19T12:16:33.961Z | 2024-09-19T12:16:33.961Z |
5132701 | 5132701 | 20240916015931_Bis2O | UK009J | 2024-09-19T12:16:28.585Z | 2024-09-19T12:16:28.585Z |
5128865 | 5128865 | 20240917024843_8lfcr | UK009J | 2024-09-19T12:11:04.080Z | 2024-09-19T12:11:04.080Z |
5128707 | 5128707 | 20240917022511_pyqVJ | UK009J | 2024-09-19T12:10:57.604Z | 2024-09-19T12:10:57.604Z |
5126921 | 5126921 | 20240916195352_LkSm4 | UK009J | 2024-09-19T12:07:41.508Z | 2024-09-19T12:07:41.508Z |
5124500 | 5124500 | 20240917205329_3n4lR | UK009J | 2024-09-19T12:01:03.510Z | 2024-09-19T12:06:41.904Z |
5121396 | 5121396 | 20240914035911_Tv6J3 | UK009J | 2024-09-18T12:10:54.723Z | 2024-09-19T12:20:01.708Z |
5121294 | 5121294 | 20240914035744_4lrF8 | UK009J | 2024-09-18T12:10:54.113Z | 2024-09-19T12:20:01.619Z |
5121160 | 5121160 | 20240914035416_WO0B7 | UK009J | 2024-09-18T12:10:52.062Z | 2024-09-19T12:20:01.457Z |
5120970 | 5120970 | 20240914034301_pu1Yj | UK009J | 2024-09-18T12:10:48.930Z | 2024-09-19T12:20:01.080Z |
5120406 | 5120406 | 20240914031959_1YP8A | UK009J | 2024-09-18T12:10:39.292Z | 2024-09-19T12:20:00.109Z |
5120263 | 5120263 | 20240914031049_39oaf | UK009J | 2024-09-18T12:10:36.415Z | 2024-09-19T12:19:59.844Z |
5120069 | 5120069 | 20240914025821_3O2iZ | UK009J | 2024-09-18T12:10:31.620Z | 2024-09-19T12:19:59.363Z |
5119621 | 5119621 | 20240914024024_5JL2w | UK009J | 2024-09-18T12:10:22.717Z | 2024-09-19T12:19:58.600Z |
5119603 | 5119603 | 20240914023959_ZZWNM | UK009J | 2024-09-18T12:10:22.568Z | 2024-09-19T12:19:58.560Z |
5116941 | 5116941 | 20240915035106_fqa3m | UK009J | 2024-09-18T12:07:26.453Z | 2024-09-19T12:19:12.803Z |
5116854 | 5116854 | 20240915034432_PyZhQ | UK009J | 2024-09-18T12:07:22.647Z | 2024-09-19T12:19:12.458Z |
5116814 | 5116814 | 20240915034322_raSAp | UK009J | 2024-09-18T12:07:21.765Z | 2024-09-19T12:19:12.427Z |
5116578 | 5116578 | 20240915033225_MK2tZ | UK009J | 2024-09-18T12:07:10.682Z | 2024-09-19T12:19:11.568Z |
5116226 | 5116226 | 20240915031635_croLP | UK009J | 2024-09-18T12:06:49.708Z | 2024-09-19T12:19:09.918Z |
5116041 | 5116041 | 20240915030422_BjdsF | UK009J | 2024-09-18T12:06:35.056Z | 2024-09-19T12:19:08.235Z |
5115839 | 5115839 | 20240915025433_9ZS2s | UK009J | 2024-09-18T12:06:26.622Z | 2024-09-19T12:19:07.441Z |
5115694 | 5115694 | 20240915024901_cfo4B | UK009J | 2024-09-18T12:06:21.189Z | 2024-09-19T12:19:06.385Z |
5115672 | 5115672 | 20240915024901_VW6yq | UK009J | 2024-09-18T12:06:21.014Z | 2024-09-19T12:19:06.372Z |
5115572 | 5115572 | 20240915024434_7N2Sy | UK009J | 2024-09-18T12:06:17.831Z | 2024-09-19T12:19:05.367Z |
5115037 | 5115037 | 20240915021449_91apG | UK009J | 2024-09-18T12:05:51.494Z | 2024-09-19T12:19:01.184Z |
5114957 | 5114957 | 20240915021002_mSWqB | UK009J | 2024-09-18T12:05:46.254Z | 2024-09-19T12:19:00.849Z |
5114629 | 5114629 | 20240915015225_PAl02 | UK009J | 2024-09-18T12:05:25.859Z | 2024-09-19T12:18:59.082Z |
5114495 | 5114495 | 20240915014441_aDP0R | UK009J | 2024-09-18T12:05:19.775Z | 2024-09-19T12:18:58.559Z |
5114266 | 5114266 | 20240915013416_YFd5H | UK009J | 2024-09-18T12:05:09.097Z | 2024-09-19T12:18:57.332Z |
5113280 | 5113280 | 20240915003517_LfTxr | UK009J | 2024-09-18T12:04:05.540Z | 2024-09-19T12:18:48.353Z |
5113253 | 5113253 | 20240915003259_1dwE3 | UK009J | 2024-09-18T12:04:04.682Z | 2024-09-19T12:18:48.268Z |
5113016 | 5113016 | 20240915001451_1USQT | UK009J | 2024-09-18T12:03:51.005Z | 2024-09-19T12:18:46.441Z |
5112988 | 5112988 | 20240915001109_JKPUo | UK009J | 2024-09-18T12:03:49.893Z | 2024-09-19T12:18:46.235Z |
5112962 | 5112962 | 20240915001108_I3lqt | UK009J | 2024-09-18T12:03:49.752Z | 2024-09-19T12:18:46.054Z |
5112894 | 5112894 | 20240915000407_OizCB | UK009J | 2024-09-18T12:03:45.403Z | 2024-09-19T12:18:45.519Z |
5112531 | 5112531 | 20240914232550_H2UbD | UK009J | 2024-09-18T12:03:12.197Z | 2024-09-19T12:18:41.275Z |
5112473 | 5112473 | 20240914231854_40L2a | UK009J | 2024-09-18T12:03:09.635Z | 2024-09-19T12:18:41.111Z |
5111006 | 5111006 | 20240914193941_xDZd2 | UK009J | 2024-09-18T12:01:19.167Z | 2024-09-19T12:18:25.275Z |
5108175 | 5108175 | 20240913042923_2WrGD | UK009J | 2024-09-17T12:13:31.956Z | 2024-09-19T12:20:47.896Z |
5108022 | 5108022 | 20240913042031_D9G3s | UK009J | 2024-09-17T12:13:28.326Z | 2024-09-19T12:20:47.751Z |
5107924 | 5107924 | 20240913041500_M9G1b | UK009J | 2024-09-17T12:13:25.945Z | 2024-09-19T12:20:47.637Z |
5107774 | 5107774 | 20240913040937_NdYVv | UK009J | 2024-09-17T12:13:23.554Z | 2024-09-19T12:20:47.532Z |
5107647 | 5107647 | 20240913040744_ph42q | UK009J | 2024-09-17T12:13:20.693Z | 2024-09-19T12:20:47.439Z |
5107484 | 5107484 | 20240913035754_qRrr2 | UK009J | 2024-09-17T12:13:16.116Z | 2024-09-19T12:20:47.186Z |
5107355 | 5107355 | 20240913035317_228ze | UK009J | 2024-09-17T12:13:13.643Z | 2024-09-19T12:20:47.011Z |
5106904 | 5106904 | 20240913033804_6bAi1 | UK009J | 2024-09-17T12:13:03.762Z | 2024-09-19T12:20:46.511Z |
5106617 | 5106617 | 20240913033032_VdHgR | UK009J | 2024-09-17T12:12:58.250Z | 2024-09-19T12:20:46.201Z |
5106606 | 5106606 | 20240913032918_4RKKo | UK009J | 2024-09-17T12:12:57.692Z | 2024-09-19T12:20:46.192Z |
5106559 | 5106559 | 20240913032846_X30ef | UK009J | 2024-09-17T12:12:57.187Z | 2024-09-19T12:20:46.174Z |
5106245 | 5106245 | 20240913031554_OvOOU | UK009J | 2024-09-17T12:12:45.346Z | 2024-09-19T12:20:45.682Z |
5106132 | 5106132 | 20240913031225_NtuIQ | UK009J | 2024-09-17T12:12:42.738Z | 2024-09-19T12:20:45.508Z |
5106092 | 5106092 | 20240913031041_Kn2zk | UK009J | 2024-09-17T12:12:41.991Z | 2024-09-19T12:20:45.481Z |
5106049 | 5106049 | 20240913030733_lQoMo | UK009J | 2024-09-17T12:12:39.062Z | 2024-09-19T12:20:45.361Z |
5105783 | 5105783 | 20240913025820_kNv3a | UK009J | 2024-09-17T12:12:28.806Z | 2024-09-19T12:20:44.875Z |
5105640 | 5105640 | 20240913025355_b87ZU | UK009J | 2024-09-17T12:12:24.244Z | 2024-09-19T12:20:44.766Z |
5105182 | 5105182 | 20240913023629_Vr2h5 | UK009J | 2024-09-17T12:12:01.678Z | 2024-09-19T12:20:44.092Z |
5105132 | 5105132 | 20240913023157_iEiTZ | UK009J | 2024-09-17T12:11:57.298Z | 2024-09-19T12:20:43.741Z |
5104784 | 5104784 | 20240913022109_NoJDj | UK009J | 2024-09-17T12:11:44.558Z | 2024-09-19T12:20:42.881Z |
5104666 | 5104666 | 20240913021814_1HhV8 | UK009J | 2024-09-17T12:11:41.919Z | 2024-09-19T12:20:42.659Z |
5104543 | 5104543 | 20240913021459_xXwf6 | UK009J | 2024-09-17T12:11:38.836Z | 2024-09-19T12:20:41.692Z |
5103855 | 5103855 | 20240913014220_6dD5N | UK009J | 2024-09-17T12:11:13.377Z | 2024-09-19T12:20:40.626Z |
5103703 | 5103703 | 20240913013553_ejHYY | UK009J | 2024-09-17T12:11:07.998Z | 2024-09-19T12:20:40.423Z |
5103669 | 5103669 | 20240913013551_Kikf3 | UK009J | 2024-09-17T12:11:07.705Z | 2024-09-19T12:20:40.420Z |
5103568 | 5103568 | 20240913013227_p597S | UK009J | 2024-09-17T12:11:03.782Z | 2024-09-19T12:20:40.293Z |
5103425 | 5103425 | 20240913013030_VT9oc | UK009J | 2024-09-17T12:10:57.192Z | 2024-09-19T12:20:40.175Z |
5103372 | 5103372 | 20240913012914_waADd | UK009J | 2024-09-17T12:10:55.282Z | 2024-09-19T12:20:40.116Z |
5101658 | 5101658 | 20240914004134_epWXK | UK009J | 2024-09-17T12:06:07.005Z | 2024-09-19T12:19:51.178Z |
5101622 | 5101622 | 20240914003907_SgXcF | UK009J | 2024-09-17T12:06:05.143Z | 2024-09-19T12:19:51.104Z |
5101433 | 5101433 | 20240914002611_gq64X | UK009J | 2024-09-17T12:05:47.568Z | 2024-09-19T12:19:50.523Z |
5101397 | 5101397 | 20240914002224_WXZng | UK009J | 2024-09-17T12:05:40.189Z | 2024-09-19T12:19:50.411Z |
5101162 | 5101162 | 20240914000741_Ettys | UK009J | 2024-09-17T12:05:23.103Z | 2024-09-19T12:19:49.884Z |
5101122 | 5101122 | 20240914000512_hOC8P | UK009J | 2024-09-17T12:05:21.078Z | 2024-09-19T12:19:49.822Z |
5101010 | 5101010 | 20240913235545_Br5Rp | UK009J | 2024-09-17T12:05:13.523Z | 2024-09-19T12:19:49.478Z |
5100910 | 5100910 | 20240913235319_rBjno | UK009J | 2024-09-17T12:05:10.127Z | 2024-09-19T12:19:49.329Z |
5100770 | 5100770 | 20240913234523_7Nw8T | UK009J | 2024-09-17T12:04:54.854Z | 2024-09-19T12:19:48.706Z |
5100752 | 5100752 | 20240913234453_wAdQj | UK009J | 2024-09-17T12:04:54.335Z | 2024-09-19T12:19:48.697Z |
5100497 | 5100497 | 20240913232838_Zt08a | UK009J | 2024-09-17T12:04:36.606Z | 2024-09-19T12:19:48.057Z |
5100341 | 5100341 | 20240913232300_arrHI | UK009J | 2024-09-17T12:04:29.179Z | 2024-09-19T12:19:47.816Z |
5100258 | 5100258 | 20240913231212_Z6zRC | UK009J | 2024-09-17T12:04:22.574Z | 2024-09-19T12:19:47.576Z |
5100229 | 5100229 | 20240913230702_TG3Ey | UK009J | 2024-09-17T12:04:19.512Z | 2024-09-19T12:19:47.330Z |
5100057 | 5100057 | 20240913224450_iWQym | UK009J | 2024-09-17T12:03:55.275Z | 2024-09-19T12:19:46.807Z |
5099959 | 5099959 | 20240913222709_wt2pr | UK009J | 2024-09-17T12:03:46.127Z | 2024-09-19T12:19:46.609Z |
5099882 | 5099882 | 20240913222014_2nIJI | UK009J | 2024-09-17T12:03:42.160Z | 2024-09-19T12:19:46.310Z |
5099706 | 5099706 | 20240913214850_kavWR | UK009J | 2024-09-17T12:03:24.008Z | 2024-09-19T12:19:45.709Z |
5099357 | 5099357 | 20240913210539_NZJ4w | UK009J | 2024-09-17T12:02:48.810Z | 2024-09-19T12:19:44.582Z |
5099171 | 5099171 | 20240913203235_ylaZt | UK009J | 2024-09-17T12:02:24.404Z | 2024-09-19T12:19:43.666Z |
5098298 | 5098298 | 20240913012412_Zi2Wf | UK009J | 2024-09-16T12:17:22.217Z | 2024-09-19T12:20:39.998Z |
5098172 | 5098172 | 20240913012105_oIerk | UK009J | 2024-09-16T12:17:21.262Z | 2024-09-19T12:20:39.759Z |
5097699 | 5097699 | 20240913005803_2vgkq | UK009J | 2024-09-16T12:17:14.086Z | 2024-09-19T12:20:38.905Z |
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);