participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,690 rows where station_code = "UK00AP" 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 |
---|---|---|---|---|---|
5135321 | 5135321 | 20240915040245_zGMqY | UK00AP | 2024-09-19T12:19:13.340Z | 2024-09-19T12:19:13.340Z |
5129800 | 5129800 | 20240917043123_m7HA3 | UK00AP | 2024-09-19T12:12:05.536Z | 2024-09-19T12:12:05.536Z |
5129291 | 5129291 | 20240917034459_KC7K8 | UK00AP | 2024-09-19T12:11:25.884Z | 2024-09-19T12:11:25.884Z |
5128884 | 5128884 | 20240917025018_phAnT | UK00AP | 2024-09-19T12:11:05.049Z | 2024-09-19T12:11:05.049Z |
5128709 | 5128709 | 20240917022511_pyqVJ | UK00AP | 2024-09-19T12:10:57.604Z | 2024-09-19T12:10:57.604Z |
5128481 | 5128481 | 20240917014807_us3hY | UK00AP | 2024-09-19T12:10:37.366Z | 2024-09-19T12:10:37.366Z |
5128273 | 5128273 | 20240917011741_3Wx1j | UK00AP | 2024-09-19T12:10:23.841Z | 2024-09-19T12:10:23.841Z |
5128109 | 5128109 | 20240917003940_bMPLf | UK00AP | 2024-09-19T12:10:04.456Z | 2024-09-19T12:10:04.456Z |
5128105 | 5128105 | 20240917003928_qdP9l | UK00AP | 2024-09-19T12:10:04.093Z | 2024-09-19T12:10:04.093Z |
5127880 | 5127880 | 20240916235705_EtZUI | UK00AP | 2024-09-19T12:09:44.967Z | 2024-09-19T12:09:44.967Z |
5127838 | 5127838 | 20240916234608_XsSg9 | UK00AP | 2024-09-19T12:09:42.716Z | 2024-09-19T12:09:42.716Z |
5127822 | 5127822 | 20240916233946_t3Cpk | UK00AP | 2024-09-19T12:09:41.040Z | 2024-09-19T12:09:41.040Z |
5127716 | 5127716 | 20240916230839_FrM9D | UK00AP | 2024-09-19T12:09:33.988Z | 2024-09-19T12:09:33.988Z |
5127708 | 5127708 | 20240916230311_Q2lOj | UK00AP | 2024-09-19T12:09:33.078Z | 2024-09-19T12:09:33.078Z |
5127569 | 5127569 | 20240916223002_KjcOd | UK00AP | 2024-09-19T12:09:23.927Z | 2024-09-19T12:09:23.927Z |
5127286 | 5127286 | 20240916211259_3j3gG | UK00AP | 2024-09-19T12:08:47.030Z | 2024-09-19T12:08:47.030Z |
5127197 | 5127197 | 20240916205428_kKvLe | UK00AP | 2024-09-19T12:08:30.970Z | 2024-09-19T12:08:30.970Z |
5127037 | 5127037 | 20240916201356_2oguW | UK00AP | 2024-09-19T12:07:55.163Z | 2024-09-19T12:07:55.163Z |
5127017 | 5127017 | 20240916201243_mOrwJ | UK00AP | 2024-09-19T12:07:53.136Z | 2024-09-19T12:07:53.136Z |
5126982 | 5126982 | 20240916200135_rzLZ6 | UK00AP | 2024-09-19T12:07:49.259Z | 2024-09-19T12:07:49.259Z |
5124398 | 5124398 | 20240917195357_Dexjn | UK00AP | 2024-09-19T12:00:44.403Z | 2024-09-19T12:06:41.888Z |
5122130 | 5122130 | 20240914043816_SE29n | UK00AP | 2024-09-18T12:11:07.582Z | 2024-09-19T12:20:02.862Z |
5121984 | 5121984 | 20240914042323_4l1UM | UK00AP | 2024-09-18T12:11:03.681Z | 2024-09-19T12:20:02.557Z |
5121953 | 5121953 | 20240914042253_2LDId | UK00AP | 2024-09-18T12:11:03.436Z | 2024-09-19T12:20:02.534Z |
5121897 | 5121897 | 20240914042027_UwaLG | UK00AP | 2024-09-18T12:11:02.834Z | 2024-09-19T12:20:02.482Z |
5121828 | 5121828 | 20240914041452_XrXcV | UK00AP | 2024-09-18T12:11:01.682Z | 2024-09-19T12:20:02.389Z |
5121698 | 5121698 | 20240914041211_gzgsf | UK00AP | 2024-09-18T12:10:59.392Z | 2024-09-19T12:20:02.218Z |
5121668 | 5121668 | 20240914041155_QyLxn | UK00AP | 2024-09-18T12:10:59.188Z | 2024-09-19T12:20:02.207Z |
5121337 | 5121337 | 20240914035815_Xm2fk | UK00AP | 2024-09-18T12:10:54.567Z | 2024-09-19T12:20:01.624Z |
5121243 | 5121243 | 20240914035618_03B7Q | UK00AP | 2024-09-18T12:10:52.843Z | 2024-09-19T12:20:01.520Z |
5121211 | 5121211 | 20240914035523_kP3a1 | UK00AP | 2024-09-18T12:10:52.371Z | 2024-09-19T12:20:01.491Z |
5121163 | 5121163 | 20240914035416_WO0B7 | UK00AP | 2024-09-18T12:10:52.062Z | 2024-09-19T12:20:01.457Z |
5121058 | 5121058 | 20240914034954_3WsOm | UK00AP | 2024-09-18T12:10:50.328Z | 2024-09-19T12:20:01.269Z |
5121016 | 5121016 | 20240914034732_m2Oyn | UK00AP | 2024-09-18T12:10:49.398Z | 2024-09-19T12:20:01.160Z |
5120826 | 5120826 | 20240914033552_fwlf5 | UK00AP | 2024-09-18T12:10:47.149Z | 2024-09-19T12:20:00.904Z |
5120766 | 5120766 | 20240914033443_UEKyt | UK00AP | 2024-09-18T12:10:46.591Z | 2024-09-19T12:20:00.853Z |
5120090 | 5120090 | 20240914025930_rIbm3 | UK00AP | 2024-09-18T12:10:31.838Z | 2024-09-19T12:19:59.384Z |
5119970 | 5119970 | 20240914025452_2jk3k | UK00AP | 2024-09-18T12:10:30.092Z | 2024-09-19T12:19:59.202Z |
5119877 | 5119877 | 20240914025122_ie63A | UK00AP | 2024-09-18T12:10:28.275Z | 2024-09-19T12:19:59.034Z |
5119740 | 5119740 | 20240914024608_v3ZnX | UK00AP | 2024-09-18T12:10:24.624Z | 2024-09-19T12:19:58.797Z |
5119636 | 5119636 | 20240914024041_hBkgB | UK00AP | 2024-09-18T12:10:22.791Z | 2024-09-19T12:19:58.602Z |
5119578 | 5119578 | 20240914023927_OhmTT | UK00AP | 2024-09-18T12:10:22.440Z | 2024-09-19T12:19:58.542Z |
5119447 | 5119447 | 20240914023429_3r0OL | UK00AP | 2024-09-18T12:10:21.380Z | 2024-09-19T12:19:58.255Z |
5119193 | 5119193 | 20240914021639_pPkX5 | UK00AP | 2024-09-18T12:10:18.066Z | 2024-09-19T12:19:57.353Z |
5119109 | 5119109 | 20240914020910_eApWm | UK00AP | 2024-09-18T12:10:16.106Z | 2024-09-19T12:19:57.137Z |
5117481 | 5117481 | 20240915044025_CUwv8 | UK00AP | 2024-09-18T12:07:42.511Z | 2024-09-19T12:19:15.234Z |
5117421 | 5117421 | 20240915043152_5Ef2C | UK00AP | 2024-09-18T12:07:41.183Z | 2024-09-19T12:19:15.013Z |
5117372 | 5117372 | 20240915042118_HJm5b | UK00AP | 2024-09-18T12:07:38.816Z | 2024-09-19T12:19:14.503Z |
5117266 | 5117266 | 20240915041543_32kqX | UK00AP | 2024-09-18T12:07:36.388Z | 2024-09-19T12:19:14.056Z |
5117246 | 5117246 | 20240915041441_M8bBe | UK00AP | 2024-09-18T12:07:36.074Z | 2024-09-19T12:19:13.976Z |
5117227 | 5117227 | 20240915041401_n0PlA | UK00AP | 2024-09-18T12:07:35.893Z | 2024-09-19T12:19:13.935Z |
5117218 | 5117218 | 20240915041252_4Zis3 | UK00AP | 2024-09-18T12:07:35.679Z | 2024-09-19T12:19:13.901Z |
5117172 | 5117172 | 20240915040711_ETWrb | UK00AP | 2024-09-18T12:07:34.310Z | 2024-09-19T12:19:13.674Z |
5117124 | 5117124 | 20240915040350_u04rH | UK00AP | 2024-09-18T12:07:33.119Z | 2024-09-19T12:19:13.449Z |
5116962 | 5116962 | 20240915035119_yDVH0 | UK00AP | 2024-09-18T12:07:26.631Z | 2024-09-19T12:19:12.813Z |
5116943 | 5116943 | 20240915035106_fqa3m | UK00AP | 2024-09-18T12:07:26.453Z | 2024-09-19T12:19:12.803Z |
5116856 | 5116856 | 20240915034432_PyZhQ | UK00AP | 2024-09-18T12:07:22.647Z | 2024-09-19T12:19:12.458Z |
5116778 | 5116778 | 20240915034143_L2wKJ | UK00AP | 2024-09-18T12:07:20.731Z | 2024-09-19T12:19:12.351Z |
5116720 | 5116720 | 20240915033724_p3md7 | UK00AP | 2024-09-18T12:07:17.601Z | 2024-09-19T12:19:12.115Z |
5116697 | 5116697 | 20240915033705_ixQop | UK00AP | 2024-09-18T12:07:17.107Z | 2024-09-19T12:19:12.086Z |
5116690 | 5116690 | 20240915033650_JsdV6 | UK00AP | 2024-09-18T12:07:16.695Z | 2024-09-19T12:19:12.044Z |
5116607 | 5116607 | 20240915033251_Li3oe | UK00AP | 2024-09-18T12:07:11.664Z | 2024-09-19T12:19:11.616Z |
5116496 | 5116496 | 20240915032951_21KzE | UK00AP | 2024-09-18T12:07:06.950Z | 2024-09-19T12:19:11.360Z |
5116409 | 5116409 | 20240915032506_4lBjC | UK00AP | 2024-09-18T12:07:01.120Z | 2024-09-19T12:19:11.089Z |
5116293 | 5116293 | 20240915032022_XfqN3 | UK00AP | 2024-09-18T12:06:55.249Z | 2024-09-19T12:19:10.255Z |
5116242 | 5116242 | 20240915031713_QoefO | UK00AP | 2024-09-18T12:06:50.278Z | 2024-09-19T12:19:09.929Z |
5116229 | 5116229 | 20240915031635_croLP | UK00AP | 2024-09-18T12:06:49.709Z | 2024-09-19T12:19:09.919Z |
5116096 | 5116096 | 20240915030817_fn6LA | UK00AP | 2024-09-18T12:06:39.428Z | 2024-09-19T12:19:08.692Z |
5116024 | 5116024 | 20240915030405_5Ojrt | UK00AP | 2024-09-18T12:06:34.521Z | 2024-09-19T12:19:08.230Z |
5115954 | 5115954 | 20240915030127_yG9LC | UK00AP | 2024-09-18T12:06:32.625Z | 2024-09-19T12:19:07.979Z |
5115820 | 5115820 | 20240915025422_gs7RP | UK00AP | 2024-09-18T12:06:25.400Z | 2024-09-19T12:19:07.415Z |
5115724 | 5115724 | 20240915025047_8SkHQ | UK00AP | 2024-09-18T12:06:22.019Z | 2024-09-19T12:19:06.513Z |
5115584 | 5115584 | 20240915024448_01C53 | UK00AP | 2024-09-18T12:06:17.979Z | 2024-09-19T12:19:05.370Z |
5115416 | 5115416 | 20240915023653_YvvWz | UK00AP | 2024-09-18T12:06:13.123Z | 2024-09-19T12:19:04.541Z |
5115147 | 5115147 | 20240915022210_sU2UB | UK00AP | 2024-09-18T12:06:03.526Z | 2024-09-19T12:19:02.554Z |
5115020 | 5115020 | 20240915021323_HVCtY | UK00AP | 2024-09-18T12:05:50.974Z | 2024-09-19T12:19:01.144Z |
5115002 | 5115002 | 20240915021309_nvDxB | UK00AP | 2024-09-18T12:05:50.408Z | 2024-09-19T12:19:01.113Z |
5114774 | 5114774 | 20240915015743_9K7A3 | UK00AP | 2024-09-18T12:05:33.745Z | 2024-09-19T12:18:59.867Z |
5114682 | 5114682 | 20240915015324_Xb4qe | UK00AP | 2024-09-18T12:05:28.076Z | 2024-09-19T12:18:59.202Z |
5114534 | 5114534 | 20240915014649_fdMaf | UK00AP | 2024-09-18T12:05:20.941Z | 2024-09-19T12:18:58.750Z |
5114434 | 5114434 | 20240915014157_Vwngi | UK00AP | 2024-09-18T12:05:16.357Z | 2024-09-19T12:18:58.158Z |
5114323 | 5114323 | 20240915013637_urfjS | UK00AP | 2024-09-18T12:05:10.561Z | 2024-09-19T12:18:57.540Z |
5114300 | 5114300 | 20240915013500_FRf7e | UK00AP | 2024-09-18T12:05:09.545Z | 2024-09-19T12:18:57.389Z |
5114283 | 5114283 | 20240915013446_9wt2n | UK00AP | 2024-09-18T12:05:09.195Z | 2024-09-19T12:18:57.346Z |
5114051 | 5114051 | 20240915012349_L3tux | UK00AP | 2024-09-18T12:04:59.893Z | 2024-09-19T12:18:55.472Z |
5114026 | 5114026 | 20240915012337_AGBJ0 | UK00AP | 2024-09-18T12:04:59.007Z | 2024-09-19T12:18:55.316Z |
5113850 | 5113850 | 20240915011543_gYMsi | UK00AP | 2024-09-18T12:04:52.719Z | 2024-09-19T12:18:53.295Z |
5113295 | 5113295 | 20240915003543_t3rXu | UK00AP | 2024-09-18T12:04:06.455Z | 2024-09-19T12:18:48.413Z |
5113207 | 5113207 | 20240915003144_fsUq3 | UK00AP | 2024-09-18T12:04:02.988Z | 2024-09-19T12:18:47.997Z |
5113109 | 5113109 | 20240915002226_FdJ8u | UK00AP | 2024-09-18T12:03:56.696Z | 2024-09-19T12:18:47.099Z |
5113099 | 5113099 | 20240915002226_lCVmS | UK00AP | 2024-09-18T12:03:56.471Z | 2024-09-19T12:18:47.048Z |
5112990 | 5112990 | 20240915001109_JKPUo | UK00AP | 2024-09-18T12:03:49.893Z | 2024-09-19T12:18:46.235Z |
5112964 | 5112964 | 20240915001108_I3lqt | UK00AP | 2024-09-18T12:03:49.752Z | 2024-09-19T12:18:46.054Z |
5112843 | 5112843 | 20240914235937_knDpk | UK00AP | 2024-09-18T12:03:41.844Z | 2024-09-19T12:18:45.255Z |
5112719 | 5112719 | 20240914234456_Vc7bV | UK00AP | 2024-09-18T12:03:24.556Z | 2024-09-19T12:18:43.589Z |
5112565 | 5112565 | 20240914232945_zEWSh | UK00AP | 2024-09-18T12:03:14.838Z | 2024-09-19T12:18:41.478Z |
5112515 | 5112515 | 20240914232405_qfREx | UK00AP | 2024-09-18T12:03:11.117Z | 2024-09-19T12:18:41.212Z |
5112502 | 5112502 | 20240914232157_EP6sA | UK00AP | 2024-09-18T12:03:10.950Z | 2024-09-19T12:18:41.190Z |
5112411 | 5112411 | 20240914230809_UazIM | UK00AP | 2024-09-18T12:03:02.637Z | 2024-09-19T12:18:40.822Z |
5112228 | 5112228 | 20240914223819_rd33g | UK00AP | 2024-09-18T12:02:54.247Z | 2024-09-19T12:18:39.837Z |
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);