participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,242 rows where station_code = "UK007Q" 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 |
---|---|---|---|---|---|
5129497 | 5129497 | 20240917040539_XE3NV | UK007Q | 2024-09-19T12:11:44.929Z | 2024-09-19T12:11:44.929Z |
5127786 | 5127786 | 20240916232851_6zpE1 | UK007Q | 2024-09-19T12:09:38.237Z | 2024-09-19T12:09:38.237Z |
5127564 | 5127564 | 20240916223002_KjcOd | UK007Q | 2024-09-19T12:09:23.927Z | 2024-09-19T12:09:23.927Z |
5127278 | 5127278 | 20240916211259_3j3gG | UK007Q | 2024-09-19T12:08:47.030Z | 2024-09-19T12:08:47.030Z |
5127033 | 5127033 | 20240916201356_2oguW | UK007Q | 2024-09-19T12:07:55.163Z | 2024-09-19T12:07:55.163Z |
5126973 | 5126973 | 20240916200135_rzLZ6 | UK007Q | 2024-09-19T12:07:49.259Z | 2024-09-19T12:07:49.259Z |
5124883 | 5124883 | 20240917223523_WW6Ik | UK007Q | 2024-09-19T12:01:44.003Z | 2024-09-19T12:06:41.946Z |
5124701 | 5124701 | 20240917214754_f3UuU | UK007Q | 2024-09-19T12:01:20.590Z | 2024-09-19T12:06:41.926Z |
5124667 | 5124667 | 20240917214605_w34ej | UK007Q | 2024-09-19T12:01:18.321Z | 2024-09-19T12:06:41.923Z |
5124656 | 5124656 | 20240917214518_pkmee | UK007Q | 2024-09-19T12:01:16.999Z | 2024-09-19T12:06:41.922Z |
5124449 | 5124449 | 20240917202122_3xUrK | UK007Q | 2024-09-19T12:00:56.463Z | 2024-09-19T12:06:41.896Z |
5122127 | 5122127 | 20240914043816_SE29n | UK007Q | 2024-09-18T12:11:07.582Z | 2024-09-19T12:20:02.862Z |
5121236 | 5121236 | 20240914035618_03B7Q | UK007Q | 2024-09-18T12:10:52.843Z | 2024-09-19T12:20:01.520Z |
5121065 | 5121065 | 20240914035025_3qCc6 | UK007Q | 2024-09-18T12:10:50.420Z | 2024-09-19T12:20:01.282Z |
5121057 | 5121057 | 20240914034954_3WsOm | UK007Q | 2024-09-18T12:10:50.328Z | 2024-09-19T12:20:01.269Z |
5121010 | 5121010 | 20240914034732_m2Oyn | UK007Q | 2024-09-18T12:10:49.398Z | 2024-09-19T12:20:01.160Z |
5120193 | 5120193 | 20240914030424_GTfjB | UK007Q | 2024-09-18T12:10:34.234Z | 2024-09-19T12:19:59.611Z |
5119965 | 5119965 | 20240914025452_2jk3k | UK007Q | 2024-09-18T12:10:30.091Z | 2024-09-19T12:19:59.202Z |
5119869 | 5119869 | 20240914025122_ie63A | UK007Q | 2024-09-18T12:10:28.275Z | 2024-09-19T12:19:59.033Z |
5119575 | 5119575 | 20240914023927_OhmTT | UK007Q | 2024-09-18T12:10:22.440Z | 2024-09-19T12:19:58.542Z |
5119444 | 5119444 | 20240914023429_3r0OL | UK007Q | 2024-09-18T12:10:21.364Z | 2024-09-19T12:19:58.255Z |
5119317 | 5119317 | 20240914022258_gF0ug | UK007Q | 2024-09-18T12:10:19.875Z | 2024-09-19T12:19:57.916Z |
5119189 | 5119189 | 20240914021639_pPkX5 | UK007Q | 2024-09-18T12:10:18.066Z | 2024-09-19T12:19:57.353Z |
5117428 | 5117428 | 20240915043301_lxCmY | UK007Q | 2024-09-18T12:07:41.426Z | 2024-09-19T12:19:15.033Z |
5117215 | 5117215 | 20240915041252_4Zis3 | UK007Q | 2024-09-18T12:07:35.679Z | 2024-09-19T12:19:13.901Z |
5117165 | 5117165 | 20240915040711_ETWrb | UK007Q | 2024-09-18T12:07:34.310Z | 2024-09-19T12:19:13.674Z |
5117104 | 5117104 | 20240915040250_U52LG | UK007Q | 2024-09-18T12:07:32.803Z | 2024-09-19T12:19:13.386Z |
5117028 | 5117028 | 20240915035722_FmXt7 | UK007Q | 2024-09-18T12:07:30.349Z | 2024-09-19T12:19:13.126Z |
5116954 | 5116954 | 20240915035119_yDVH0 | UK007Q | 2024-09-18T12:07:26.631Z | 2024-09-19T12:19:12.813Z |
5116686 | 5116686 | 20240915033650_JsdV6 | UK007Q | 2024-09-18T12:07:16.695Z | 2024-09-19T12:19:12.044Z |
5116647 | 5116647 | 20240915033414_U3Hq6 | UK007Q | 2024-09-18T12:07:14.586Z | 2024-09-19T12:19:11.831Z |
5116495 | 5116495 | 20240915032951_21KzE | UK007Q | 2024-09-18T12:07:06.950Z | 2024-09-19T12:19:11.360Z |
5116450 | 5116450 | 20240915032640_CI2LX | UK007Q | 2024-09-18T12:07:03.972Z | 2024-09-19T12:19:11.202Z |
5116375 | 5116375 | 20240915032405_ghSQJ | UK007Q | 2024-09-18T12:07:00.269Z | 2024-09-19T12:19:10.748Z |
5116290 | 5116290 | 20240915032022_XfqN3 | UK007Q | 2024-09-18T12:06:55.249Z | 2024-09-19T12:19:10.255Z |
5116022 | 5116022 | 20240915030405_5Ojrt | UK007Q | 2024-09-18T12:06:34.521Z | 2024-09-19T12:19:08.229Z |
5115958 | 5115958 | 20240915030148_7J6bj | UK007Q | 2024-09-18T12:06:32.731Z | 2024-09-19T12:19:08.002Z |
5115949 | 5115949 | 20240915030121_uw3zb | UK007Q | 2024-09-18T12:06:32.482Z | 2024-09-19T12:19:07.960Z |
5115653 | 5115653 | 20240915024711_AbFZ5 | UK007Q | 2024-09-18T12:06:20.400Z | 2024-09-19T12:19:06.031Z |
5115146 | 5115146 | 20240915022210_sU2UB | UK007Q | 2024-09-18T12:06:03.526Z | 2024-09-19T12:19:02.554Z |
5114999 | 5114999 | 20240915021309_nvDxB | UK007Q | 2024-09-18T12:05:50.408Z | 2024-09-19T12:19:01.113Z |
5114509 | 5114509 | 20240915014454_RF4lc | UK007Q | 2024-09-18T12:05:19.969Z | 2024-09-19T12:18:58.589Z |
5114317 | 5114317 | 20240915013637_urfjS | UK007Q | 2024-09-18T12:05:10.561Z | 2024-09-19T12:18:57.540Z |
5114297 | 5114297 | 20240915013500_FRf7e | UK007Q | 2024-09-18T12:05:09.545Z | 2024-09-19T12:18:57.389Z |
5114230 | 5114230 | 20240915013229_XxfcW | UK007Q | 2024-09-18T12:05:07.995Z | 2024-09-19T12:18:57.090Z |
5114025 | 5114025 | 20240915012337_AGBJ0 | UK007Q | 2024-09-18T12:04:59.007Z | 2024-09-19T12:18:55.316Z |
5113106 | 5113106 | 20240915002226_FdJ8u | UK007Q | 2024-09-18T12:03:56.696Z | 2024-09-19T12:18:47.099Z |
5113097 | 5113097 | 20240915002226_lCVmS | UK007Q | 2024-09-18T12:03:56.471Z | 2024-09-19T12:18:47.048Z |
5112669 | 5112669 | 20240914234000_uqKMh | UK007Q | 2024-09-18T12:03:20.583Z | 2024-09-19T12:18:42.867Z |
5112403 | 5112403 | 20240914230809_UazIM | UK007Q | 2024-09-18T12:03:02.637Z | 2024-09-19T12:18:40.822Z |
5111973 | 5111973 | 20240914214849_4oPa0 | UK007Q | 2024-09-18T12:02:34.408Z | 2024-09-19T12:18:35.960Z |
5111879 | 5111879 | 20240914213012_Wk3ui | UK007Q | 2024-09-18T12:02:28.267Z | 2024-09-19T12:18:34.845Z |
5111815 | 5111815 | 20240914211815_Ejih7 | UK007Q | 2024-09-18T12:02:18.315Z | 2024-09-19T12:18:34.067Z |
5108207 | 5108207 | 20240913043131_d3Xeq | UK007Q | 2024-09-17T12:13:32.534Z | 2024-09-19T12:20:47.917Z |
5108092 | 5108092 | 20240913042246_PcaE2 | UK007Q | 2024-09-17T12:13:30.364Z | 2024-09-19T12:20:47.843Z |
5107894 | 5107894 | 20240913041400_b8zTH | UK007Q | 2024-09-17T12:13:25.507Z | 2024-09-19T12:20:47.630Z |
5107787 | 5107787 | 20240913040941_D2MXS | UK007Q | 2024-09-17T12:13:23.622Z | 2024-09-19T12:20:47.536Z |
5107727 | 5107727 | 20240913040923_Amflw | UK007Q | 2024-09-17T12:13:22.523Z | 2024-09-19T12:20:47.508Z |
5107608 | 5107608 | 20240913040428_u8c5x | UK007Q | 2024-09-17T12:13:18.887Z | 2024-09-19T12:20:47.330Z |
5107584 | 5107584 | 20240913040240_2pVXe | UK007Q | 2024-09-17T12:13:17.605Z | 2024-09-19T12:20:47.281Z |
5107562 | 5107562 | 20240913040104_HZK8i | UK007Q | 2024-09-17T12:13:17.040Z | 2024-09-19T12:20:47.222Z |
5107184 | 5107184 | 20240913034632_ZaTPh | UK007Q | 2024-09-17T12:13:10.502Z | 2024-09-19T12:20:46.899Z |
5107023 | 5107023 | 20240913034216_HMLrn | UK007Q | 2024-09-17T12:13:08.100Z | 2024-09-19T12:20:46.784Z |
5106835 | 5106835 | 20240913033650_EvQFQ | UK007Q | 2024-09-17T12:13:02.691Z | 2024-09-19T12:20:46.478Z |
5106780 | 5106780 | 20240913033429_Vg6vb | UK007Q | 2024-09-17T12:13:00.994Z | 2024-09-19T12:20:46.394Z |
5106523 | 5106523 | 20240913032845_3pQuD | UK007Q | 2024-09-17T12:12:57.084Z | 2024-09-19T12:20:46.172Z |
5106510 | 5106510 | 20240913032819_BGeiB | UK007Q | 2024-09-17T12:12:56.691Z | 2024-09-19T12:20:46.164Z |
5105902 | 5105902 | 20240913030246_y664z | UK007Q | 2024-09-17T12:12:32.462Z | 2024-09-19T12:20:45.047Z |
5105896 | 5105896 | 20240913030210_5vnyB | UK007Q | 2024-09-17T12:12:32.213Z | 2024-09-19T12:20:45.039Z |
5105273 | 5105273 | 20240913024028_UF3A3 | UK007Q | 2024-09-17T12:12:08.089Z | 2024-09-19T12:20:44.235Z |
5104208 | 5104208 | 20240913015826_GtGD4 | UK007Q | 2024-09-17T12:11:28.886Z | 2024-09-19T12:20:41.203Z |
5104194 | 5104194 | 20240913015826_egVkX | UK007Q | 2024-09-17T12:11:28.831Z | 2024-09-19T12:20:41.199Z |
5104079 | 5104079 | 20240913015024_CbWxx | UK007Q | 2024-09-17T12:11:24.196Z | 2024-09-19T12:20:40.948Z |
5103744 | 5103744 | 20240913013839_MgwIZ | UK007Q | 2024-09-17T12:11:09.652Z | 2024-09-19T12:20:40.445Z |
5103606 | 5103606 | 20240913013431_c3daU | UK007Q | 2024-09-17T12:11:06.077Z | 2024-09-19T12:20:40.379Z |
5103475 | 5103475 | 20240913013113_8DvbC | UK007Q | 2024-09-17T12:10:59.110Z | 2024-09-19T12:20:40.202Z |
5103326 | 5103326 | 20240913012623_wUh5U | UK007Q | 2024-09-17T12:10:50.949Z | 2024-09-19T12:20:40.028Z |
5102378 | 5102378 | 20240914012318_R4SVA | UK007Q | 2024-09-17T12:07:05.965Z | 2024-09-19T12:19:53.915Z |
5102147 | 5102147 | 20240914010716_DiQCX | UK007Q | 2024-09-17T12:06:50.484Z | 2024-09-19T12:19:52.532Z |
5102081 | 5102081 | 20240914010522_m1qbx | UK007Q | 2024-09-17T12:06:47.106Z | 2024-09-19T12:19:52.409Z |
5101727 | 5101727 | 20240914004411_A1rfk | UK007Q | 2024-09-17T12:06:10.254Z | 2024-09-19T12:19:51.321Z |
5100981 | 5100981 | 20240913235534_dvXWJ | UK007Q | 2024-09-17T12:05:13.182Z | 2024-09-19T12:19:49.465Z |
5100931 | 5100931 | 20240913235416_fY2kn | UK007Q | 2024-09-17T12:05:11.374Z | 2024-09-19T12:19:49.338Z |
5100442 | 5100442 | 20240913232701_sSbP2 | UK007Q | 2024-09-17T12:04:34.038Z | 2024-09-19T12:19:47.979Z |
5100266 | 5100266 | 20240913231225_nwlol | UK007Q | 2024-09-17T12:04:22.894Z | 2024-09-19T12:19:47.577Z |
5100162 | 5100162 | 20240913225901_JMOgI | UK007Q | 2024-09-17T12:04:05.388Z | 2024-09-19T12:19:47.060Z |
5100108 | 5100108 | 20240913225247_Ezjry | UK007Q | 2024-09-17T12:03:58.011Z | 2024-09-19T12:19:46.925Z |
5099974 | 5099974 | 20240913222943_F9HlP | UK007Q | 2024-09-17T12:03:47.544Z | 2024-09-19T12:19:46.633Z |
5099934 | 5099934 | 20240913222341_GN3zg | UK007Q | 2024-09-17T12:03:43.885Z | 2024-09-19T12:19:46.379Z |
5099764 | 5099764 | 20240913215446_pC8Ki | UK007Q | 2024-09-17T12:03:33.101Z | 2024-09-19T12:19:45.838Z |
5099425 | 5099425 | 20240913211253_N7nj2 | UK007Q | 2024-09-17T12:02:55.784Z | 2024-09-19T12:19:44.874Z |
5099373 | 5099373 | 20240913210606_iTXdO | UK007Q | 2024-09-17T12:02:49.736Z | 2024-09-19T12:19:44.630Z |
5099256 | 5099256 | 20240913204713_UyM31 | UK007Q | 2024-09-17T12:02:36.642Z | 2024-09-19T12:19:44.332Z |
5097820 | 5097820 | 20240913010511_PskUa | UK007Q | 2024-09-16T12:17:15.284Z | 2024-09-19T12:20:39.040Z |
5097524 | 5097524 | 20240913005218_90IdC | UK007Q | 2024-09-16T12:17:13.224Z | 2024-09-19T12:20:38.685Z |
5094715 | 5094715 | 20240912041732_3odKs | UK007Q | 2024-09-16T12:14:56.696Z | 2024-09-19T12:21:16.400Z |
5094674 | 5094674 | 20240912041435_23yq3 | UK007Q | 2024-09-16T12:14:53.888Z | 2024-09-19T12:21:16.372Z |
5094567 | 5094567 | 20240912041140_mOBSe | UK007Q | 2024-09-16T12:14:51.782Z | 2024-09-19T12:21:16.259Z |
5094273 | 5094273 | 20240912035448_IvS3R | UK007Q | 2024-09-16T12:14:40.288Z | 2024-09-19T12:21:16.047Z |
5093677 | 5093677 | 20240912033215_GhtkC | UK007Q | 2024-09-16T12:14:23.878Z | 2024-09-19T12:21:15.589Z |
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);