participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
837 rows where station_code = "UK0096" 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 |
---|---|---|---|---|---|
5410958 | 5410958 | 20241027055637_Iui32 | UK0096 | 2024-10-29T12:18:13.903Z | 2024-11-04T14:29:06.436Z |
5408270 | 5408270 | 20241027032014_T5b7e | UK0096 | 2024-10-29T12:16:20.574Z | 2024-11-04T14:28:59.043Z |
5408040 | 5408040 | 20241027030419_gs2OY | UK0096 | 2024-10-29T12:16:01.748Z | 2024-11-04T14:28:58.736Z |
5408024 | 5408024 | 20241027030311_wwEGN | UK0096 | 2024-10-29T12:16:00.290Z | 2024-11-04T14:28:58.694Z |
5407841 | 5407841 | 20241027025501_Stiw7 | UK0096 | 2024-10-29T12:15:48.146Z | 2024-11-04T14:28:58.242Z |
5407758 | 5407758 | 20241027025048_CgtGC | UK0096 | 2024-10-29T12:15:38.466Z | 2024-11-04T14:28:58.103Z |
5407639 | 5407639 | 20241027024539_CAjSk | UK0096 | 2024-10-29T12:15:32.606Z | 2024-11-04T14:28:57.960Z |
5407529 | 5407529 | 20241027024051_zc2yN | UK0096 | 2024-10-29T12:15:28.249Z | 2024-11-04T14:28:57.841Z |
5407432 | 5407432 | 20241027023650_n6bpC | UK0096 | 2024-10-29T12:15:24.624Z | 2024-11-04T14:28:57.567Z |
5407419 | 5407419 | 20241027023627_0TmIv | UK0096 | 2024-10-29T12:15:24.406Z | 2024-11-04T14:28:57.501Z |
5407355 | 5407355 | 20241027023252_z6i0R | UK0096 | 2024-10-29T12:15:22.160Z | 2024-11-04T14:28:57.400Z |
5407339 | 5407339 | 20241027023156_iFt4Y | UK0096 | 2024-10-29T12:15:21.263Z | 2024-11-04T14:28:57.342Z |
5407127 | 5407127 | 20241027022314_LhLdT | UK0096 | 2024-10-29T12:15:13.642Z | 2024-11-04T14:28:56.964Z |
5406486 | 5406486 | 20241027014109_E8Bvi | UK0096 | 2024-10-29T12:14:12.878Z | 2024-11-04T14:28:55.760Z |
5406392 | 5406392 | 20241027013434_RMpgu | UK0096 | 2024-10-29T12:14:06.063Z | 2024-11-04T14:28:55.633Z |
5406368 | 5406368 | 20241027013213_nx69B | UK0096 | 2024-10-29T12:14:04.685Z | 2024-11-04T14:28:55.519Z |
5406332 | 5406332 | 20241027012807_2DJXG | UK0096 | 2024-10-29T12:14:02.538Z | 2024-11-04T14:28:55.466Z |
5406144 | 5406144 | 20241027011856_sK82K | UK0096 | 2024-10-29T12:13:53.413Z | 2024-11-04T14:28:55.160Z |
5406135 | 5406135 | 20241027011828_PQMML | UK0096 | 2024-10-29T12:13:53.113Z | 2024-11-04T14:28:55.154Z |
5406057 | 5406057 | 20241027011330_8ZK3h | UK0096 | 2024-10-29T12:13:49.522Z | 2024-11-04T14:28:54.906Z |
5405578 | 5405578 | 20241027004600_Qle1n | UK0096 | 2024-10-29T12:13:03.212Z | 2024-11-04T14:28:53.630Z |
5404537 | 5404537 | 20241026233450_4GU65 | UK0096 | 2024-10-29T12:11:41.320Z | 2024-11-04T14:28:51.305Z |
5404485 | 5404485 | 20241026233046_VaLi7 | UK0096 | 2024-10-29T12:11:32.741Z | 2024-11-04T14:28:51.108Z |
5404041 | 5404041 | 20241026225427_HcHQB | UK0096 | 2024-10-29T12:10:49.720Z | 2024-11-04T14:28:50.264Z |
5403991 | 5403991 | 20241026225145_8WsB7 | UK0096 | 2024-10-29T12:10:45.445Z | 2024-11-04T14:28:50.164Z |
5403967 | 5403967 | 20241026224905_g3PtQ | UK0096 | 2024-10-29T12:10:39.144Z | 2024-11-04T14:28:50.117Z |
5403932 | 5403932 | 20241026224612_ZOrqE | UK0096 | 2024-10-29T12:10:30.581Z | 2024-11-04T14:28:50.029Z |
5403919 | 5403919 | 20241026224525_sJ0Py | UK0096 | 2024-10-29T12:10:28.092Z | 2024-11-04T14:28:50.010Z |
5403846 | 5403846 | 20241026223719_5snze | UK0096 | 2024-10-29T12:10:18.833Z | 2024-11-04T14:28:49.870Z |
5403706 | 5403706 | 20241026222421_OOlsv | UK0096 | 2024-10-29T12:10:08.645Z | 2024-11-04T14:28:49.504Z |
5403282 | 5403282 | 20241026213559_SE2ga | UK0096 | 2024-10-29T12:09:18.768Z | 2024-11-04T14:28:48.261Z |
5402999 | 5402999 | 20241026210052_vMBFV | UK0096 | 2024-10-29T12:08:43.588Z | 2024-11-04T14:28:47.324Z |
5402904 | 5402904 | 20241026204215_BNY4h | UK0096 | 2024-10-29T12:08:34.329Z | 2024-11-04T14:28:46.924Z |
5402854 | 5402854 | 20241026203348_Xcwq4 | UK0096 | 2024-10-29T12:08:28.431Z | 2024-11-04T14:28:46.714Z |
5400154 | 5400154 | 20241026054557_riCXo | UK0096 | 2024-10-28T12:20:25.163Z | 2024-11-03T14:27:41.436Z |
5400127 | 5400127 | 20241026054238_tICmE | UK0096 | 2024-10-28T12:20:23.778Z | 2024-11-03T14:27:41.368Z |
5400111 | 5400111 | 20241026054030_cY2wH | UK0096 | 2024-10-28T12:20:23.182Z | 2024-11-03T14:27:41.309Z |
5399894 | 5399894 | 20241026051050_59Rf3 | UK0096 | 2024-10-28T12:20:15.401Z | 2024-11-03T14:27:40.701Z |
5399870 | 5399870 | 20241026050800_xn3ww | UK0096 | 2024-10-28T12:20:14.015Z | 2024-11-03T14:27:40.641Z |
5399718 | 5399718 | 20241026045343_NJ0Cj | UK0096 | 2024-10-28T12:20:08.470Z | 2024-11-03T14:27:40.309Z |
5399698 | 5399698 | 20241026044915_5kil2 | UK0096 | 2024-10-28T12:20:08.161Z | 2024-11-03T14:27:40.294Z |
5399443 | 5399443 | 20241026041834_V0xC8 | UK0096 | 2024-10-28T12:19:59.519Z | 2024-11-03T14:27:39.723Z |
5399401 | 5399401 | 20241026041504_QPr3M | UK0096 | 2024-10-28T12:19:58.167Z | 2024-11-03T14:27:39.601Z |
5399376 | 5399376 | 20241026041400_NkKr6 | UK0096 | 2024-10-28T12:19:57.128Z | 2024-11-03T14:27:39.574Z |
5399209 | 5399209 | 20241026040059_rGI8U | UK0096 | 2024-10-28T12:19:51.448Z | 2024-11-03T14:27:39.250Z |
5399101 | 5399101 | 20241026035332_NYuXt | UK0096 | 2024-10-28T12:19:48.401Z | 2024-11-03T14:27:39.019Z |
5399019 | 5399019 | 20241026034457_8QMIO | UK0096 | 2024-10-28T12:19:44.555Z | 2024-11-03T14:27:38.889Z |
5398813 | 5398813 | 20241026033111_l8aqi | UK0096 | 2024-10-28T12:19:34.700Z | 2024-11-03T14:27:38.154Z |
5398792 | 5398792 | 20241026032924_3fhFh | UK0096 | 2024-10-28T12:19:33.472Z | 2024-11-03T14:27:38.110Z |
5398644 | 5398644 | 20241026031448_vcqSo | UK0096 | 2024-10-28T12:19:25.386Z | 2024-11-03T14:27:37.448Z |
5398562 | 5398562 | 20241026030835_BOsL4 | UK0096 | 2024-10-28T12:19:21.928Z | 2024-11-03T14:27:36.796Z |
5398502 | 5398502 | 20241026030348_EJMl4 | UK0096 | 2024-10-28T12:19:20.106Z | 2024-11-03T14:27:36.617Z |
5398458 | 5398458 | 20241026025934_yn8Ld | UK0096 | 2024-10-28T12:19:17.966Z | 2024-11-03T14:27:36.385Z |
5398436 | 5398436 | 20241026025617_i74ny | UK0096 | 2024-10-28T12:19:17.211Z | 2024-11-03T14:27:36.372Z |
5398413 | 5398413 | 20241026025525_uJmy0 | UK0096 | 2024-10-28T12:19:14.372Z | 2024-11-03T14:27:36.339Z |
5398200 | 5398200 | 20241026023511_n1mWf | UK0096 | 2024-10-28T12:19:06.078Z | 2024-11-03T14:27:35.688Z |
5356234 | 5356234 | 20241023052251_TaNb9 | UK0096 | 2024-10-24T12:21:56.336Z | 2024-10-31T12:30:11.153Z |
5356181 | 5356181 | 20241023051230_SXOIv | UK0096 | 2024-10-24T12:21:55.033Z | 2024-10-31T12:30:10.764Z |
5356162 | 5356162 | 20241023051011_aHSzk | UK0096 | 2024-10-24T12:21:54.858Z | 2024-10-31T12:30:10.665Z |
5356121 | 5356121 | 20241023050237_Jq3vL | UK0096 | 2024-10-24T12:21:52.979Z | 2024-10-31T12:30:10.490Z |
5356089 | 5356089 | 20241023045517_abnBr | UK0096 | 2024-10-24T12:21:50.373Z | 2024-10-31T12:30:09.796Z |
5356047 | 5356047 | 20241023045226_tJaG6 | UK0096 | 2024-10-24T12:21:48.206Z | 2024-10-31T12:30:09.691Z |
5355856 | 5355856 | 20241023042926_A4i9M | UK0096 | 2024-10-24T12:21:39.754Z | 2024-10-31T12:30:09.088Z |
5355852 | 5355852 | 20241023042823_LNJmR | UK0096 | 2024-10-24T12:21:39.461Z | 2024-10-31T12:30:09.072Z |
5355822 | 5355822 | 20241023042420_KAzd4 | UK0096 | 2024-10-24T12:21:38.093Z | 2024-10-31T12:30:08.936Z |
5355720 | 5355720 | 20241023040445_jHALz | UK0096 | 2024-10-24T12:21:33.478Z | 2024-10-31T12:30:08.551Z |
5355696 | 5355696 | 20241023040211_rtpOj | UK0096 | 2024-10-24T12:21:31.903Z | 2024-10-31T12:30:08.518Z |
5355564 | 5355564 | 20241023035046_Pyck4 | UK0096 | 2024-10-24T12:21:26.126Z | 2024-10-31T12:30:08.067Z |
5355108 | 5355108 | 20241023031504_2tA7o | UK0096 | 2024-10-24T12:21:06.356Z | 2024-10-31T12:30:07.284Z |
5355080 | 5355080 | 20241023031320_hVSI3 | UK0096 | 2024-10-24T12:21:04.338Z | 2024-10-31T12:30:07.269Z |
5354820 | 5354820 | 20241023024836_J2FVg | UK0096 | 2024-10-24T12:20:53.679Z | 2024-10-31T12:30:06.364Z |
5353948 | 5353948 | 20241023015552_9Je5M | UK0096 | 2024-10-24T12:20:05.890Z | 2024-10-31T12:30:05.196Z |
5353574 | 5353574 | 20241023013140_fqe18 | UK0096 | 2024-10-24T12:19:46.912Z | 2024-10-31T12:30:04.383Z |
5352586 | 5352586 | 20241023004044_2zywa | UK0096 | 2024-10-24T12:18:58.778Z | 2024-10-31T12:30:02.919Z |
5351926 | 5351926 | 20241023000003_Y83L4 | UK0096 | 2024-10-24T12:18:09.529Z | 2024-10-31T12:30:01.256Z |
5351617 | 5351617 | 20241022234110_XOxpc | UK0096 | 2024-10-24T12:17:42.659Z | 2024-10-31T12:30:00.606Z |
5351378 | 5351378 | 20241022232201_Cs9rt | UK0096 | 2024-10-24T12:17:28.803Z | 2024-10-31T12:30:00.266Z |
5351240 | 5351240 | 20241022231010_HdEGq | UK0096 | 2024-10-24T12:17:21.769Z | 2024-10-31T12:29:59.647Z |
5350702 | 5350702 | 20241022221716_9E4jK | UK0096 | 2024-10-24T12:16:17.245Z | 2024-10-31T12:29:58.683Z |
5350637 | 5350637 | 20241022221212_JCQZ2 | UK0096 | 2024-10-24T12:16:08.337Z | 2024-10-31T12:29:58.595Z |
5350636 | 5350636 | 20241022221208_9vAjW | UK0096 | 2024-10-24T12:16:07.910Z | 2024-10-31T12:29:58.593Z |
5345135 | 5345135 | 20241022051410_Ac9sb | UK0096 | 2024-10-23T12:19:07.199Z | 2024-10-30T12:26:52.221Z |
5345126 | 5345126 | 20241022051356_beH1J | UK0096 | 2024-10-23T12:19:07.044Z | 2024-10-30T12:26:52.197Z |
5345044 | 5345044 | 20241022050808_7WGHF | UK0096 | 2024-10-23T12:19:03.419Z | 2024-10-30T12:26:52.130Z |
5344836 | 5344836 | 20241022044932_m1P01 | UK0096 | 2024-10-23T12:18:53.258Z | 2024-10-30T12:26:51.832Z |
5344396 | 5344396 | 20241022041843_YDDzm | UK0096 | 2024-10-23T12:18:34.554Z | 2024-10-30T12:26:51.214Z |
5344301 | 5344301 | 20241022041431_ny3KC | UK0096 | 2024-10-23T12:18:30.946Z | 2024-10-30T12:26:51.117Z |
5344273 | 5344273 | 20241022041256_v6jsr | UK0096 | 2024-10-23T12:18:30.316Z | 2024-10-30T12:26:51.102Z |
5344127 | 5344127 | 20241022040640_yv1kN | UK0096 | 2024-10-23T12:18:24.861Z | 2024-10-30T12:26:50.950Z |
5344049 | 5344049 | 20241022040303_zKhmY | UK0096 | 2024-10-23T12:18:20.994Z | 2024-10-30T12:26:50.904Z |
5344042 | 5344042 | 20241022040242_jMi4C | UK0096 | 2024-10-23T12:18:20.515Z | 2024-10-30T12:26:50.900Z |
5344014 | 5344014 | 20241022040133_SO4yx | UK0096 | 2024-10-23T12:18:19.129Z | 2024-10-30T12:26:50.882Z |
5343932 | 5343932 | 20241022035612_tQ3sn | UK0096 | 2024-10-23T12:18:14.853Z | 2024-10-30T12:26:50.764Z |
5343873 | 5343873 | 20241022035257_RF4gH | UK0096 | 2024-10-23T12:18:11.709Z | 2024-10-30T12:26:50.681Z |
5343868 | 5343868 | 20241022035135_cOSpo | UK0096 | 2024-10-23T12:18:11.530Z | 2024-10-30T12:26:50.677Z |
5343759 | 5343759 | 20241022034237_hxVDh | UK0096 | 2024-10-23T12:18:06.036Z | 2024-10-30T12:26:50.521Z |
5343668 | 5343668 | 20241022033942_pVb2M | UK0096 | 2024-10-23T12:17:59.274Z | 2024-10-30T12:26:50.392Z |
5343154 | 5343154 | 20241022031249_kDEBI | UK0096 | 2024-10-23T12:17:37.102Z | 2024-10-30T12:26:49.524Z |
5343085 | 5343085 | 20241022030656_md2dp | UK0096 | 2024-10-23T12:17:34.160Z | 2024-10-30T12:26:49.329Z |
5343038 | 5343038 | 20241022030221_dO2J9 | UK0096 | 2024-10-23T12:17:32.653Z | 2024-10-30T12:26:49.224Z |
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);