participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,866 rows where station_code = "UK009X" 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 |
---|---|---|---|---|---|
5524227 | 5524227 | 20241111033600_jnmbM | UK009X | 2024-11-12T14:16:48.686Z | 2024-11-12T14:18:08.521Z |
5450138 | 5450138 | 20241031180216_JQZvz | UK009X | 2024-11-02T12:14:38.256Z | 2024-11-09T14:24:13.868Z |
5439936 | 5439936 | 20241030205129_85znC | UK009X | 2024-11-01T12:14:39.269Z | 2024-11-08T14:23:06.366Z |
5439922 | 5439922 | 20241030204940_C2ZBS | UK009X | 2024-11-01T12:14:38.340Z | 2024-11-08T14:23:06.154Z |
5439647 | 5439647 | 20241030201626_7c4l2 | UK009X | 2024-11-01T12:14:06.201Z | 2024-11-08T14:23:04.522Z |
5432863 | 5432863 | 20241029050040_xToHS | UK009X | 2024-10-31T12:21:37.025Z | 2024-11-06T14:27:29.037Z |
5432219 | 5432219 | 20241029025525_l1g9X | UK009X | 2024-10-31T12:21:13.218Z | 2024-11-06T14:27:26.262Z |
5432171 | 5432171 | 20241029025202_RtKH8 | UK009X | 2024-10-31T12:21:09.206Z | 2024-11-06T14:27:26.163Z |
5432131 | 5432131 | 20241029024614_J3YN8 | UK009X | 2024-10-31T12:21:04.941Z | 2024-11-06T14:27:26.043Z |
5432082 | 5432082 | 20241029024034_XmGd7 | UK009X | 2024-10-31T12:21:01.761Z | 2024-11-06T14:27:25.949Z |
5431992 | 5431992 | 20241029022804_Yz6ui | UK009X | 2024-10-31T12:20:55.483Z | 2024-11-06T14:27:25.666Z |
5431964 | 5431964 | 20241029022331_FpLSu | UK009X | 2024-10-31T12:20:53.893Z | 2024-11-06T14:27:25.625Z |
5431056 | 5431056 | 20241029002011_PCWyY | UK009X | 2024-10-31T12:19:31.383Z | 2024-11-06T14:27:22.628Z |
5429958 | 5429958 | 20241028203339_CSxt5 | UK009X | 2024-10-31T12:17:17.999Z | 2024-11-06T14:27:18.130Z |
5429902 | 5429902 | 20241028202124_q7N2Y | UK009X | 2024-10-31T12:17:12.240Z | 2024-11-06T14:27:18.015Z |
5423063 | 5423063 | 20241026015012_Pkuv1 | UK009X | 2024-10-30T12:24:15.941Z | 2024-11-03T14:27:33.846Z |
5423030 | 5423030 | 20241025232609_Dzovd | UK009X | 2024-10-30T12:24:08.451Z | 2024-11-03T14:27:27.775Z |
5418447 | 5418447 | 20241027205006_i2C22 | UK009X | 2024-10-30T12:15:42.262Z | 2024-11-05T14:27:10.045Z |
5417698 | 5417698 | 20241027190231_u4h2Z | UK009X | 2024-10-30T12:14:14.117Z | 2024-11-05T14:27:08.086Z |
5410744 | 5410744 | 20241027053338_M6zDp | UK009X | 2024-10-29T12:18:04.018Z | 2024-11-04T14:29:05.375Z |
5410645 | 5410645 | 20241027052531_2yEQL | UK009X | 2024-10-29T12:18:01.853Z | 2024-11-04T14:29:05.187Z |
5410538 | 5410538 | 20241027051649_kMZ98 | UK009X | 2024-10-29T12:17:57.728Z | 2024-11-04T14:29:04.736Z |
5410526 | 5410526 | 20241027051628_JiLam | UK009X | 2024-10-29T12:17:57.483Z | 2024-11-04T14:29:04.730Z |
5410505 | 5410505 | 20241027051551_t69Ip | UK009X | 2024-10-29T12:17:57.133Z | 2024-11-04T14:29:04.656Z |
5410476 | 5410476 | 20241027051435_8G2ZC | UK009X | 2024-10-29T12:17:56.713Z | 2024-11-04T14:29:04.638Z |
5410103 | 5410103 | 20241027045401_25B5I | UK009X | 2024-10-29T12:17:48.055Z | 2024-11-04T14:29:03.786Z |
5409954 | 5409954 | 20241027044414_ziM9D | UK009X | 2024-10-29T12:17:44.918Z | 2024-11-04T14:29:03.108Z |
5409917 | 5409917 | 20241027044154_RzwHJ | UK009X | 2024-10-29T12:17:44.081Z | 2024-11-04T14:29:02.929Z |
5409314 | 5409314 | 20241027041040_kPa89 | UK009X | 2024-10-29T12:17:16.192Z | 2024-11-04T14:29:01.517Z |
5409261 | 5409261 | 20241027040735_CKqZO | UK009X | 2024-10-29T12:17:14.337Z | 2024-11-04T14:29:01.440Z |
5409163 | 5409163 | 20241027040335_t2uFM | UK009X | 2024-10-29T12:17:09.339Z | 2024-11-04T14:29:01.230Z |
5409092 | 5409092 | 20241027035945_g4d8o | UK009X | 2024-10-29T12:17:05.273Z | 2024-11-04T14:29:01.042Z |
5408764 | 5408764 | 20241027034205_8ZCpx | UK009X | 2024-10-29T12:16:49.206Z | 2024-11-04T14:29:00.463Z |
5408457 | 5408457 | 20241027032750_OBiFX | UK009X | 2024-10-29T12:16:31.339Z | 2024-11-04T14:28:59.509Z |
5408153 | 5408153 | 20241027031142_IB6ey | UK009X | 2024-10-29T12:16:12.462Z | 2024-11-04T14:28:58.935Z |
5408148 | 5408148 | 20241027031142_2Iczn | UK009X | 2024-10-29T12:16:12.105Z | 2024-11-04T14:28:58.920Z |
5408122 | 5408122 | 20241027031041_wPLCQ | UK009X | 2024-10-29T12:16:09.123Z | 2024-11-04T14:28:58.883Z |
5408061 | 5408061 | 20241027030513_4CLDQ | UK009X | 2024-10-29T12:16:03.401Z | 2024-11-04T14:28:58.747Z |
5407970 | 5407970 | 20241027030048_OBkfw | UK009X | 2024-10-29T12:15:55.978Z | 2024-11-04T14:28:58.535Z |
5407966 | 5407966 | 20241027030033_2mrzP | UK009X | 2024-10-29T12:15:55.667Z | 2024-11-04T14:28:58.534Z |
5407888 | 5407888 | 20241027025638_AsMMm | UK009X | 2024-10-29T12:15:50.690Z | 2024-11-04T14:28:58.293Z |
5407385 | 5407385 | 20241027023429_5a257 | UK009X | 2024-10-29T12:15:23.213Z | 2024-11-04T14:28:57.469Z |
5407329 | 5407329 | 20241027023140_0D39A | UK009X | 2024-10-29T12:15:20.987Z | 2024-11-04T14:28:57.339Z |
5407210 | 5407210 | 20241027022623_M1x4l | UK009X | 2024-10-29T12:15:16.929Z | 2024-11-04T14:28:57.239Z |
5407117 | 5407117 | 20241027022300_UEcc0 | UK009X | 2024-10-29T12:15:13.025Z | 2024-11-04T14:28:56.959Z |
5406878 | 5406878 | 20241027020604_jFPhF | UK009X | 2024-10-29T12:14:52.345Z | 2024-11-04T14:28:56.541Z |
5406833 | 5406833 | 20241027020212_iXR1P | UK009X | 2024-10-29T12:14:47.863Z | 2024-11-04T14:28:56.490Z |
5406797 | 5406797 | 20241027015959_12Tv6 | UK009X | 2024-10-29T12:14:42.909Z | 2024-11-04T14:28:56.399Z |
5406732 | 5406732 | 20241027015709_3gf35 | UK009X | 2024-10-29T12:14:35.376Z | 2024-11-04T14:28:56.318Z |
5406663 | 5406663 | 20241027015232_Svpm6 | UK009X | 2024-10-29T12:14:29.584Z | 2024-11-04T14:28:55.980Z |
5406610 | 5406610 | 20241027014745_gYKFl | UK009X | 2024-10-29T12:14:24.107Z | 2024-11-04T14:28:55.909Z |
5406124 | 5406124 | 20241027011754_A24cT | UK009X | 2024-10-29T12:13:52.832Z | 2024-11-04T14:28:55.149Z |
5405838 | 5405838 | 20241027010247_3H2ma | UK009X | 2024-10-29T12:13:21.456Z | 2024-11-04T14:28:54.421Z |
5405782 | 5405782 | 20241027005742_yi0HO | UK009X | 2024-10-29T12:13:16.503Z | 2024-11-04T14:28:54.229Z |
5405763 | 5405763 | 20241027005551_3TGSo | UK009X | 2024-10-29T12:13:13.244Z | 2024-11-04T14:28:54.154Z |
5405362 | 5405362 | 20241027002945_uaVkX | UK009X | 2024-10-29T12:12:51.648Z | 2024-11-04T14:28:53.349Z |
5405308 | 5405308 | 20241027002753_DuxbX | UK009X | 2024-10-29T12:12:49.022Z | 2024-11-04T14:28:53.268Z |
5405231 | 5405231 | 20241027002452_Z1Xbq | UK009X | 2024-10-29T12:12:45.535Z | 2024-11-04T14:28:53.146Z |
5405140 | 5405140 | 20241027001537_1GJHD | UK009X | 2024-10-29T12:12:32.444Z | 2024-11-04T14:28:52.722Z |
5404901 | 5404901 | 20241026235956_WLvJt | UK009X | 2024-10-29T12:12:06.111Z | 2024-11-04T14:28:52.384Z |
5404854 | 5404854 | 20241026235704_UUM28 | UK009X | 2024-10-29T12:12:03.209Z | 2024-11-04T14:28:52.210Z |
5404823 | 5404823 | 20241026235445_b6VTz | UK009X | 2024-10-29T12:11:59.678Z | 2024-11-04T14:28:52.043Z |
5404631 | 5404631 | 20241026234105_8I0kh | UK009X | 2024-10-29T12:11:47.007Z | 2024-11-04T14:28:51.446Z |
5404512 | 5404512 | 20241026233229_n25yi | UK009X | 2024-10-29T12:11:38.849Z | 2024-11-04T14:28:51.271Z |
5404479 | 5404479 | 20241026233029_LcZ2Z | UK009X | 2024-10-29T12:11:32.332Z | 2024-11-04T14:28:51.102Z |
5404428 | 5404428 | 20241026232607_E4IWH | UK009X | 2024-10-29T12:11:23.906Z | 2024-11-04T14:28:50.995Z |
5404288 | 5404288 | 20241026231423_MNKg2 | UK009X | 2024-10-29T12:11:05.042Z | 2024-11-04T14:28:50.582Z |
5403960 | 5403960 | 20241026224822_NUqTY | UK009X | 2024-10-29T12:10:38.410Z | 2024-11-04T14:28:50.109Z |
5403911 | 5403911 | 20241026224510_atRJZ | UK009X | 2024-10-29T12:10:26.920Z | 2024-11-04T14:28:50.002Z |
5403547 | 5403547 | 20241026220826_S6kg3 | UK009X | 2024-10-29T12:09:50.677Z | 2024-11-04T14:28:49.134Z |
5403513 | 5403513 | 20241026220528_LK5cF | UK009X | 2024-10-29T12:09:39.896Z | 2024-11-04T14:28:49.094Z |
5403401 | 5403401 | 20241026215123_OROH7 | UK009X | 2024-10-29T12:09:27.240Z | 2024-11-04T14:28:48.692Z |
5399431 | 5399431 | 20241026041813_zY361 | UK009X | 2024-10-28T12:19:59.442Z | 2024-11-03T14:27:39.705Z |
5398899 | 5398899 | 20241026033645_U8Q2y | UK009X | 2024-10-28T12:19:39.696Z | 2024-11-03T14:27:38.384Z |
5398802 | 5398802 | 20241026033006_ubLdk | UK009X | 2024-10-28T12:19:33.884Z | 2024-11-03T14:27:38.135Z |
5398769 | 5398769 | 20241026032713_xJqcw | UK009X | 2024-10-28T12:19:32.167Z | 2024-11-03T14:27:38.046Z |
5398703 | 5398703 | 20241026032031_zgOZc | UK009X | 2024-10-28T12:19:28.874Z | 2024-11-03T14:27:37.861Z |
5398659 | 5398659 | 20241026031527_wJf9P | UK009X | 2024-10-28T12:19:27.034Z | 2024-11-03T14:27:37.508Z |
5398595 | 5398595 | 20241026031039_vPqh5 | UK009X | 2024-10-28T12:19:23.570Z | 2024-11-03T14:27:36.886Z |
5398392 | 5398392 | 20241026025220_QSskz | UK009X | 2024-10-28T12:19:13.715Z | 2024-11-03T14:27:36.235Z |
5398159 | 5398159 | 20241026023042_BytYc | UK009X | 2024-10-28T12:19:03.288Z | 2024-11-03T14:27:35.595Z |
5398018 | 5398018 | 20241026021756_x2hND | UK009X | 2024-10-28T12:18:56.631Z | 2024-11-03T14:27:34.891Z |
5397919 | 5397919 | 20241026020645_1TBcY | UK009X | 2024-10-28T12:18:50.392Z | 2024-11-03T14:27:34.533Z |
5397750 | 5397750 | 20241026015349_Ja28T | UK009X | 2024-10-28T12:18:38.583Z | 2024-11-03T14:27:34.072Z |
5397698 | 5397698 | 20241026014910_VmwIv | UK009X | 2024-10-28T12:18:35.112Z | 2024-11-03T14:27:33.760Z |
5397652 | 5397652 | 20241026014543_c6IEs | UK009X | 2024-10-28T12:18:31.034Z | 2024-11-03T14:27:33.666Z |
5397616 | 5397616 | 20241026014323_9073P | UK009X | 2024-10-28T12:18:30.272Z | 2024-11-03T14:27:33.607Z |
5397587 | 5397587 | 20241026014154_7F2bz | UK009X | 2024-10-28T12:18:28.790Z | 2024-11-03T14:27:33.432Z |
5397107 | 5397107 | 20241026010214_K1z5C | UK009X | 2024-10-28T12:18:08.205Z | 2024-11-03T14:27:32.033Z |
5396721 | 5396721 | 20241026002611_emrFn | UK009X | 2024-10-28T12:17:54.022Z | 2024-11-03T14:27:30.742Z |
5396656 | 5396656 | 20241026001954_3IKcj | UK009X | 2024-10-28T12:17:52.154Z | 2024-11-03T14:27:30.546Z |
5396529 | 5396529 | 20241026000941_62k6o | UK009X | 2024-10-28T12:17:48.833Z | 2024-11-03T14:27:30.068Z |
5396400 | 5396400 | 20241026000152_9T5zA | UK009X | 2024-10-28T12:17:38.805Z | 2024-11-03T14:27:29.720Z |
5396207 | 5396207 | 20241025234727_izSv7 | UK009X | 2024-10-28T12:17:25.477Z | 2024-11-03T14:27:28.853Z |
5396061 | 5396061 | 20241025233656_2FM6H | UK009X | 2024-10-28T12:17:16.890Z | 2024-11-03T14:27:28.330Z |
5395945 | 5395945 | 20241025232514_MK3UQ | UK009X | 2024-10-28T12:17:06.350Z | 2024-11-03T14:27:27.697Z |
5395671 | 5395671 | 20241025230345_265KH | UK009X | 2024-10-28T12:16:38.056Z | 2024-11-03T14:27:26.383Z |
5395473 | 5395473 | 20241025224529_QuhbH | UK009X | 2024-10-28T12:16:17.782Z | 2024-11-03T14:27:25.602Z |
5395407 | 5395407 | 20241025224037_62B3v | UK009X | 2024-10-28T12:16:12.873Z | 2024-11-03T14:27:25.455Z |
5395402 | 5395402 | 20241025224035_XthSJ | UK009X | 2024-10-28T12:16:12.668Z | 2024-11-03T14:27:25.452Z |
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);