participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,113 rows where station_code = "UK002L" 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 |
---|---|---|---|---|---|
5443394 | 5443394 | 20241030055211_URJw2 | UK002L | 2024-11-01T12:20:29.505Z | 2024-11-07T14:26:51.203Z |
5443331 | 5443331 | 20241030052127_K8VHQ | UK002L | 2024-11-01T12:20:28.081Z | 2024-11-07T14:26:50.856Z |
5443247 | 5443247 | 20241030041717_oGySH | UK002L | 2024-11-01T12:20:24.598Z | 2024-11-07T14:26:50.158Z |
5442936 | 5442936 | 20241030025846_kIVm3 | UK002L | 2024-11-01T12:20:13.320Z | 2024-11-07T14:26:48.988Z |
5441658 | 5441658 | 20241029230333_7Htn2 | UK002L | 2024-11-01T12:18:51.694Z | 2024-11-07T14:26:42.852Z |
5410956 | 5410956 | 20241027055637_Iui32 | UK002L | 2024-10-29T12:18:13.903Z | 2024-11-04T14:29:06.436Z |
5410867 | 5410867 | 20241027054322_mtdsv | UK002L | 2024-10-29T12:18:06.698Z | 2024-11-04T14:29:05.923Z |
5410811 | 5410811 | 20241027053826_w1Glx | UK002L | 2024-10-29T12:18:05.508Z | 2024-11-04T14:29:05.566Z |
5410352 | 5410352 | 20241027050737_Zj6ra | UK002L | 2024-10-29T12:17:53.955Z | 2024-11-04T14:29:04.417Z |
5410120 | 5410120 | 20241027045429_JSvIa | UK002L | 2024-10-29T12:17:48.337Z | 2024-11-04T14:29:03.798Z |
5410073 | 5410073 | 20241027045136_5PMNb | UK002L | 2024-10-29T12:17:47.087Z | 2024-11-04T14:29:03.659Z |
5409976 | 5409976 | 20241027044648_n1grp | UK002L | 2024-10-29T12:17:45.258Z | 2024-11-04T14:29:03.169Z |
5409957 | 5409957 | 20241027044421_dpcfG | UK002L | 2024-10-29T12:17:44.940Z | 2024-11-04T14:29:03.110Z |
5409905 | 5409905 | 20241027044053_vc2xN | UK002L | 2024-10-29T12:17:43.888Z | 2024-11-04T14:29:02.915Z |
5409490 | 5409490 | 20241027042154_cbHDj | UK002L | 2024-10-29T12:17:26.294Z | 2024-11-04T14:29:01.910Z |
5409043 | 5409043 | 20241027035637_5p7mN | UK002L | 2024-10-29T12:17:03.097Z | 2024-11-04T14:29:00.988Z |
5407631 | 5407631 | 20241027024522_ZamG6 | UK002L | 2024-10-29T12:15:31.985Z | 2024-11-04T14:28:57.955Z |
5407526 | 5407526 | 20241027024051_zc2yN | UK002L | 2024-10-29T12:15:28.249Z | 2024-11-04T14:28:57.841Z |
5406738 | 5406738 | 20241027015740_5HF0P | UK002L | 2024-10-29T12:14:37.587Z | 2024-11-04T14:28:56.329Z |
5405088 | 5405088 | 20241027001255_6GNj0 | UK002L | 2024-10-29T12:12:25.807Z | 2024-11-04T14:28:52.665Z |
5404841 | 5404841 | 20241026235607_9bfon | UK002L | 2024-10-29T12:12:02.196Z | 2024-11-04T14:28:52.179Z |
5404533 | 5404533 | 20241026233450_4GU65 | UK002L | 2024-10-29T12:11:41.320Z | 2024-11-04T14:28:51.304Z |
5404481 | 5404481 | 20241026233046_VaLi7 | UK002L | 2024-10-29T12:11:32.740Z | 2024-11-04T14:28:51.108Z |
5404407 | 5404407 | 20241026232352_5pzdL | UK002L | 2024-10-29T12:11:19.442Z | 2024-11-04T14:28:50.855Z |
5404063 | 5404063 | 20241026225543_MJeFC | UK002L | 2024-10-29T12:10:51.722Z | 2024-11-04T14:28:50.281Z |
5403987 | 5403987 | 20241026225145_8WsB7 | UK002L | 2024-10-29T12:10:45.445Z | 2024-11-04T14:28:50.164Z |
5403929 | 5403929 | 20241026224612_ZOrqE | UK002L | 2024-10-29T12:10:30.581Z | 2024-11-04T14:28:50.029Z |
5403490 | 5403490 | 20241026220426_3Fte5 | UK002L | 2024-10-29T12:09:37.416Z | 2024-11-04T14:28:49.008Z |
5403451 | 5403451 | 20241026215834_ukyPE | UK002L | 2024-10-29T12:09:32.261Z | 2024-11-04T14:28:48.893Z |
5403374 | 5403374 | 20241026214712_9dJL2 | UK002L | 2024-10-29T12:09:25.632Z | 2024-11-04T14:28:48.603Z |
5402853 | 5402853 | 20241026203348_Xcwq4 | UK002L | 2024-10-29T12:08:28.431Z | 2024-11-04T14:28:46.714Z |
5402554 | 5402554 | 20241026195540_W3JOT | UK002L | 2024-10-29T12:07:41.041Z | 2024-11-04T14:28:45.222Z |
5402245 | 5402245 | 20241026190545_n6hoR | UK002L | 2024-10-29T12:06:43.770Z | 2024-11-04T14:28:43.327Z |
5400153 | 5400153 | 20241026054557_riCXo | UK002L | 2024-10-28T12:20:25.163Z | 2024-11-03T14:27:41.436Z |
5400125 | 5400125 | 20241026054238_tICmE | UK002L | 2024-10-28T12:20:23.778Z | 2024-11-03T14:27:41.368Z |
5399867 | 5399867 | 20241026050800_xn3ww | UK002L | 2024-10-28T12:20:13.989Z | 2024-11-03T14:27:40.641Z |
5356296 | 5356296 | 20241023053645_DgQ5Q | UK002L | 2024-10-24T12:21:57.379Z | 2024-10-31T12:30:11.555Z |
5356233 | 5356233 | 20241023052251_TaNb9 | UK002L | 2024-10-24T12:21:56.336Z | 2024-10-31T12:30:11.153Z |
5356159 | 5356159 | 20241023051011_aHSzk | UK002L | 2024-10-24T12:21:54.858Z | 2024-10-31T12:30:10.665Z |
5356087 | 5356087 | 20241023045517_abnBr | UK002L | 2024-10-24T12:21:50.373Z | 2024-10-31T12:30:09.796Z |
5356046 | 5356046 | 20241023045226_tJaG6 | UK002L | 2024-10-24T12:21:48.206Z | 2024-10-31T12:30:09.691Z |
5355850 | 5355850 | 20241023042823_LNJmR | UK002L | 2024-10-24T12:21:39.461Z | 2024-10-31T12:30:09.072Z |
5355821 | 5355821 | 20241023042420_KAzd4 | UK002L | 2024-10-24T12:21:38.093Z | 2024-10-31T12:30:08.936Z |
5355719 | 5355719 | 20241023040445_jHALz | UK002L | 2024-10-24T12:21:33.478Z | 2024-10-31T12:30:08.551Z |
5355694 | 5355694 | 20241023040211_rtpOj | UK002L | 2024-10-24T12:21:31.903Z | 2024-10-31T12:30:08.518Z |
5353572 | 5353572 | 20241023013140_fqe18 | UK002L | 2024-10-24T12:19:46.912Z | 2024-10-31T12:30:04.383Z |
5351925 | 5351925 | 20241023000003_Y83L4 | UK002L | 2024-10-24T12:18:09.529Z | 2024-10-31T12:30:01.256Z |
5351616 | 5351616 | 20241022234110_XOxpc | UK002L | 2024-10-24T12:17:42.644Z | 2024-10-31T12:30:00.606Z |
5344835 | 5344835 | 20241022044932_m1P01 | UK002L | 2024-10-23T12:18:53.258Z | 2024-10-30T12:26:51.832Z |
5344394 | 5344394 | 20241022041843_YDDzm | UK002L | 2024-10-23T12:18:34.554Z | 2024-10-30T12:26:51.214Z |
5344271 | 5344271 | 20241022041256_v6jsr | UK002L | 2024-10-23T12:18:30.316Z | 2024-10-30T12:26:51.102Z |
5344260 | 5344260 | 20241022041231_KHsh3 | UK002L | 2024-10-23T12:18:30.174Z | 2024-10-30T12:26:51.096Z |
5344125 | 5344125 | 20241022040640_yv1kN | UK002L | 2024-10-23T12:18:24.861Z | 2024-10-30T12:26:50.950Z |
5343936 | 5343936 | 20241022035651_Yo5Gd | UK002L | 2024-10-23T12:18:14.918Z | 2024-10-30T12:26:50.768Z |
5343083 | 5343083 | 20241022030656_md2dp | UK002L | 2024-10-23T12:17:34.160Z | 2024-10-30T12:26:49.329Z |
5343036 | 5343036 | 20241022030221_dO2J9 | UK002L | 2024-10-23T12:17:32.653Z | 2024-10-30T12:26:49.224Z |
5343017 | 5343017 | 20241022030045_R0lcL | UK002L | 2024-10-23T12:17:31.980Z | 2024-10-30T12:26:49.150Z |
5342645 | 5342645 | 20241022023749_RN33T | UK002L | 2024-10-23T12:17:09.775Z | 2024-10-30T12:26:48.726Z |
5342393 | 5342393 | 20241022022440_4pW3h | UK002L | 2024-10-23T12:16:50.905Z | 2024-10-30T12:26:48.442Z |
5340747 | 5340747 | 20241022004631_gBfta | UK002L | 2024-10-23T12:14:52.234Z | 2024-10-30T12:26:46.259Z |
5340571 | 5340571 | 20241022003108_2CGfw | UK002L | 2024-10-23T12:14:39.063Z | 2024-10-30T12:26:46.009Z |
5339912 | 5339912 | 20241021232808_zujRJ | UK002L | 2024-10-23T12:14:05.990Z | 2024-10-30T12:26:45.039Z |
5339881 | 5339881 | 20241021232548_CIznb | UK002L | 2024-10-23T12:14:00.375Z | 2024-10-30T12:26:45.028Z |
5339700 | 5339700 | 20241021230712_DODxL | UK002L | 2024-10-23T12:13:35.739Z | 2024-10-30T12:26:44.790Z |
5333615 | 5333615 | 20241021010147_52QKT | UK002L | 2024-10-22T12:15:40.571Z | 2024-10-29T12:26:34.442Z |
5332930 | 5332930 | 20241020230831_b3s7W | UK002L | 2024-10-22T12:14:28.981Z | 2024-10-29T12:26:33.968Z |
5326708 | 5326708 | 20241019194751_6LbHE | UK002L | 2024-10-21T12:10:11.476Z | 2024-10-28T12:26:42.313Z |
5326421 | 5326421 | 20241019182336_LpK39 | UK002L | 2024-10-21T12:09:23.432Z | 2024-10-28T12:26:41.647Z |
5326405 | 5326405 | 20241019182137_lqrxa | UK002L | 2024-10-21T12:09:21.014Z | 2024-10-28T12:26:41.613Z |
5323501 | 5323501 | 20241019032519_zqH9z | UK002L | 2024-10-20T12:06:21.441Z | 2024-10-27T12:28:50.918Z |
5323480 | 5323480 | 20241019031057_0TXf3 | UK002L | 2024-10-20T12:06:18.788Z | 2024-10-27T12:28:50.890Z |
5323452 | 5323452 | 20241019025719_Fj5ea | UK002L | 2024-10-20T12:06:15.380Z | 2024-10-27T12:28:50.759Z |
5323435 | 5323435 | 20241019024849_ZHfiG | UK002L | 2024-10-20T12:06:12.769Z | 2024-10-27T12:28:50.698Z |
5321648 | 5321648 | 20241018053316_ZWFbm | UK002L | 2024-10-19T12:07:59.422Z | 2024-10-26T12:27:57.098Z |
5321498 | 5321498 | 20241018050015_DpzqY | UK002L | 2024-10-19T12:07:41.713Z | 2024-10-26T12:27:56.890Z |
5321104 | 5321104 | 20241018034636_S9A8Q | UK002L | 2024-10-19T12:06:46.528Z | 2024-10-26T12:27:56.187Z |
5320445 | 5320445 | 20241018014310_GYht1 | UK002L | 2024-10-19T12:05:26.838Z | 2024-10-26T12:27:54.571Z |
5320137 | 5320137 | 20241018000642_jUITD | UK002L | 2024-10-19T12:04:42.561Z | 2024-10-26T12:27:54.056Z |
5319701 | 5319701 | 20241017200957_ATzk3 | UK002L | 2024-10-19T12:03:33.422Z | 2024-10-26T12:27:52.912Z |
5313288 | 5313288 | 20241014044538_cxk6K | UK002L | 2024-10-16T12:14:03.345Z | 2024-10-22T12:24:45.829Z |
5313140 | 5313140 | 20241014032430_lwmC1 | UK002L | 2024-10-16T12:13:45.685Z | 2024-10-22T12:24:41.745Z |
5311726 | 5311726 | 20241015014642_CyIN3 | UK002L | 2024-10-16T12:09:28.412Z | 2024-10-23T12:24:45.113Z |
5311546 | 5311546 | 20241015010705_0Pv5K | UK002L | 2024-10-16T12:09:01.435Z | 2024-10-23T12:24:43.763Z |
5311327 | 5311327 | 20241015000900_CEKcc | UK002L | 2024-10-16T12:08:47.581Z | 2024-10-23T12:24:42.869Z |
5311320 | 5311320 | 20241015000729_oqGbc | UK002L | 2024-10-16T12:08:47.271Z | 2024-10-23T12:24:42.865Z |
5311178 | 5311178 | 20241014233331_lK2lh | UK002L | 2024-10-16T12:08:37.143Z | 2024-10-23T12:24:41.721Z |
5311037 | 5311037 | 20241014223839_RStX4 | UK002L | 2024-10-16T12:08:11.298Z | 2024-10-23T12:24:40.697Z |
5310922 | 5310922 | 20241014214955_C3B6f | UK002L | 2024-10-16T12:08:01.226Z | 2024-10-23T12:24:40.037Z |
5310849 | 5310849 | 20241014205536_nlgd7 | UK002L | 2024-10-16T12:07:54.304Z | 2024-10-23T12:24:39.303Z |
5310510 | 5310510 | 20241014184011_hE2gt | UK002L | 2024-10-16T12:07:09.561Z | 2024-10-23T12:24:34.189Z |
5306894 | 5306894 | 20241014044903_VaWNk | UK002L | 2024-10-15T12:08:42.649Z | 2024-10-22T12:24:45.929Z |
5306886 | 5306886 | 20241014044240_bddNw | UK002L | 2024-10-15T12:08:40.814Z | 2024-10-22T12:24:45.797Z |
5306876 | 5306876 | 20241014043753_qJcHO | UK002L | 2024-10-15T12:08:39.240Z | 2024-10-22T12:24:45.273Z |
5306835 | 5306835 | 20241014041809_7r8RF | UK002L | 2024-10-15T12:08:29.963Z | 2024-10-22T12:24:44.749Z |
5306769 | 5306769 | 20241014035529_F7yNq | UK002L | 2024-10-15T12:08:22.049Z | 2024-10-22T12:24:43.125Z |
5306761 | 5306761 | 20241014035314_tJ0WT | UK002L | 2024-10-15T12:08:20.616Z | 2024-10-22T12:24:43.066Z |
5306711 | 5306711 | 20241014034112_1CvSs | UK002L | 2024-10-15T12:08:15.835Z | 2024-10-22T12:24:42.280Z |
5306629 | 5306629 | 20241014031541_xmBWo | UK002L | 2024-10-15T12:08:07.163Z | 2024-10-22T12:24:41.540Z |
5306502 | 5306502 | 20241014024135_DsTfl | UK002L | 2024-10-15T12:07:40.239Z | 2024-10-22T12:24:40.218Z |
5306418 | 5306418 | 20241014021748_aZnBk | UK002L | 2024-10-15T12:07:22.417Z | 2024-10-22T12:24:39.263Z |
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);