participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,594 rows where station_code = "UK0032" 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 |
---|---|---|---|---|---|
5573022 | 5573022 | 20241121034226_bQbpx | UK0032 | 2024-11-22T14:19:06.123Z | 2024-11-22T14:19:22.436Z |
5573013 | 5573013 | 20241121033947_W8Jkj | UK0032 | 2024-11-22T14:19:04.101Z | 2024-11-22T14:19:22.433Z |
5572986 | 5572986 | 20241121033537_sKrDj | UK0032 | 2024-11-22T14:19:02.691Z | 2024-11-22T14:19:22.428Z |
5572938 | 5572938 | 20241121032736_Phj3k | UK0032 | 2024-11-22T14:19:00.072Z | 2024-11-22T14:19:22.418Z |
5572869 | 5572869 | 20241121031826_VVY21 | UK0032 | 2024-11-22T14:18:55.224Z | 2024-11-22T14:19:22.405Z |
5572764 | 5572764 | 20241121030741_kkVq8 | UK0032 | 2024-11-22T14:18:48.592Z | 2024-11-22T14:19:22.387Z |
5572551 | 5572551 | 20241121023624_V7bdI | UK0032 | 2024-11-22T14:18:35.543Z | 2024-11-22T14:19:22.350Z |
5571862 | 5571862 | 20241121005800_rRCZ4 | UK0032 | 2024-11-22T14:17:43.337Z | 2024-11-22T14:19:22.210Z |
5571679 | 5571679 | 20241121003114_h2e3o | UK0032 | 2024-11-22T14:17:34.522Z | 2024-11-22T14:19:22.173Z |
5571625 | 5571625 | 20241121002047_Ypq6P | UK0032 | 2024-11-22T14:17:27.141Z | 2024-11-22T14:19:22.161Z |
5571166 | 5571166 | 20241120224043_zOGfI | UK0032 | 2024-11-22T14:16:33.705Z | 2024-11-22T14:19:22.055Z |
5571153 | 5571153 | 20241120223759_8SdDI | UK0032 | 2024-11-22T14:16:31.533Z | 2024-11-22T14:19:22.053Z |
5571002 | 5571002 | 20241120215316_733VO | UK0032 | 2024-11-22T14:16:18.455Z | 2024-11-22T14:19:22.021Z |
5570394 | 5570394 | 20241120193141_UzvGr | UK0032 | 2024-11-22T14:15:19.603Z | 2024-11-22T14:19:21.910Z |
5570385 | 5570385 | 20241120192951_MD9Zb | UK0032 | 2024-11-22T14:15:18.903Z | 2024-11-22T14:19:21.909Z |
5569919 | 5569919 | 20241120180013_MqnBA | UK0032 | 2024-11-22T14:14:35.939Z | 2024-11-22T14:19:21.829Z |
5566483 | 5566483 | 20241121062210_ys52B | UK0032 | 2024-11-22T14:03:00.191Z | 2024-11-22T14:03:00.191Z |
5566383 | 5566383 | 20241121060606_65Gk6 | UK0032 | 2024-11-22T14:02:41.242Z | 2024-11-22T14:02:41.242Z |
5566338 | 5566338 | 20241121060207_aXcBg | UK0032 | 2024-11-22T14:02:29.622Z | 2024-11-22T14:02:29.622Z |
5566264 | 5566264 | 20241121055413_lubIt | UK0032 | 2024-11-22T14:02:20.114Z | 2024-11-22T14:02:20.114Z |
5566152 | 5566152 | 20241121053849_Z9KBN | UK0032 | 2024-11-22T14:02:00.492Z | 2024-11-22T14:02:00.492Z |
5566129 | 5566129 | 20241121053536_Q3APM | UK0032 | 2024-11-22T14:01:54.909Z | 2024-11-22T14:01:54.909Z |
5566118 | 5566118 | 20241121053452_2xQvH | UK0032 | 2024-11-22T14:01:52.992Z | 2024-11-22T14:01:52.992Z |
5566098 | 5566098 | 20241121053247_FgpG9 | UK0032 | 2024-11-22T14:01:49.669Z | 2024-11-22T14:01:49.669Z |
5565974 | 5565974 | 20241121051237_AK4hA | UK0032 | 2024-11-22T14:01:30.411Z | 2024-11-22T14:01:30.411Z |
5565961 | 5565961 | 20241121051140_OiM9E | UK0032 | 2024-11-22T14:01:29.451Z | 2024-11-22T14:01:29.451Z |
5565928 | 5565928 | 20241121050741_iFvz3 | UK0032 | 2024-11-22T14:01:25.600Z | 2024-11-22T14:01:25.600Z |
5565896 | 5565896 | 20241121050229_W50yc | UK0032 | 2024-11-22T14:01:21.269Z | 2024-11-22T14:01:21.269Z |
5565886 | 5565886 | 20241121050112_dNvFA | UK0032 | 2024-11-22T14:01:20.450Z | 2024-11-22T14:01:20.450Z |
5565781 | 5565781 | 20241121044523_cfhYO | UK0032 | 2024-11-22T14:00:56.108Z | 2024-11-22T14:00:56.108Z |
5565723 | 5565723 | 20241121043756_7Oweu | UK0032 | 2024-11-22T14:00:46.693Z | 2024-11-22T14:00:46.693Z |
5565613 | 5565613 | 20241121042620_vq38K | UK0032 | 2024-11-22T14:00:24.821Z | 2024-11-22T14:00:24.821Z |
5565357 | 5565357 | 20241120042104_qtf2g | UK0032 | 2024-11-21T14:18:47.168Z | 2024-11-22T14:21:46.164Z |
5565331 | 5565331 | 20241120041932_spJFM | UK0032 | 2024-11-21T14:18:46.656Z | 2024-11-22T14:21:46.007Z |
5565033 | 5565033 | 20241120034528_4ZYP8 | UK0032 | 2024-11-21T14:18:23.160Z | 2024-11-22T14:21:40.494Z |
5564433 | 5564433 | 20241120025746_ikvTM | UK0032 | 2024-11-21T14:17:35.651Z | 2024-11-22T14:21:31.866Z |
5564303 | 5564303 | 20241120024713_3F2O4 | UK0032 | 2024-11-21T14:17:26.507Z | 2024-11-22T14:21:30.329Z |
5564252 | 5564252 | 20241120024110_nynFn | UK0032 | 2024-11-21T14:17:22.356Z | 2024-11-22T14:21:29.542Z |
5564172 | 5564172 | 20241120023502_B9zPh | UK0032 | 2024-11-21T14:17:15.560Z | 2024-11-22T14:21:27.876Z |
5563953 | 5563953 | 20241120021824_ez9L1 | UK0032 | 2024-11-21T14:17:00.339Z | 2024-11-22T14:21:25.606Z |
5563766 | 5563766 | 20241120020307_RArq8 | UK0032 | 2024-11-21T14:16:42.360Z | 2024-11-22T14:21:22.307Z |
5563755 | 5563755 | 20241120020151_ALaNa | UK0032 | 2024-11-21T14:16:40.741Z | 2024-11-22T14:21:22.109Z |
5563452 | 5563452 | 20241120013119_CN6jy | UK0032 | 2024-11-21T14:16:07.421Z | 2024-11-22T14:21:15.993Z |
5563391 | 5563391 | 20241120012546_NEfGZ | UK0032 | 2024-11-21T14:16:02.349Z | 2024-11-22T14:21:14.891Z |
5563288 | 5563288 | 20241120011435_CSU9I | UK0032 | 2024-11-21T14:15:51.271Z | 2024-11-22T14:21:12.331Z |
5563181 | 5563181 | 20241120010329_nzNVm | UK0032 | 2024-11-21T14:15:39.931Z | 2024-11-22T14:21:10.588Z |
5562778 | 5562778 | 20241120001107_IYi0Z | UK0032 | 2024-11-21T14:15:21.780Z | 2024-11-22T14:21:03.923Z |
5562596 | 5562596 | 20241119235356_h5w2P | UK0032 | 2024-11-21T14:15:12.606Z | 2024-11-22T14:21:00.811Z |
5562121 | 5562121 | 20241119230234_b6Dtf | UK0032 | 2024-11-21T14:14:27.012Z | 2024-11-22T14:20:53.019Z |
5562075 | 5562075 | 20241119225836_Gb8zI | UK0032 | 2024-11-21T14:14:23.585Z | 2024-11-22T14:20:52.447Z |
5562044 | 5562044 | 20241119225039_UUeLH | UK0032 | 2024-11-21T14:14:21.832Z | 2024-11-22T14:20:51.980Z |
5561665 | 5561665 | 20241119212809_VFtNs | UK0032 | 2024-11-21T14:13:41.823Z | 2024-11-22T14:20:42.658Z |
5558401 | 5558401 | 20241120060206_ojGCL | UK0032 | 2024-11-21T14:03:12.169Z | 2024-11-22T14:19:21.224Z |
5558374 | 5558374 | 20241120060132_nm3SC | UK0032 | 2024-11-21T14:03:09.753Z | 2024-11-22T14:19:21.221Z |
5558306 | 5558306 | 20241120055418_NPKEm | UK0032 | 2024-11-21T14:02:58.964Z | 2024-11-22T14:19:21.208Z |
5558209 | 5558209 | 20241120054545_jO3FO | UK0032 | 2024-11-21T14:02:44.603Z | 2024-11-22T14:19:21.194Z |
5558087 | 5558087 | 20241120053638_fIl5E | UK0032 | 2024-11-21T14:02:29.636Z | 2024-11-22T14:19:21.177Z |
5557928 | 5557928 | 20241120052358_a3X3M | UK0032 | 2024-11-21T14:02:05.194Z | 2024-11-22T14:19:21.148Z |
5557895 | 5557895 | 20241120052225_wRKvI | UK0032 | 2024-11-21T14:02:01.533Z | 2024-11-22T14:19:21.142Z |
5557651 | 5557651 | 20241120050344_jlK41 | UK0032 | 2024-11-21T14:01:26.020Z | 2024-11-22T14:19:21.105Z |
5557419 | 5557419 | 20241120044437_TIB6u | UK0032 | 2024-11-21T14:00:47.828Z | 2024-11-22T14:19:21.067Z |
5553747 | 5553747 | 20241118041028_xfN3L | UK0032 | 2024-11-19T14:11:24.785Z | 2024-11-22T14:22:56.010Z |
5553673 | 5553673 | 20241118035050_3RmvS | UK0032 | 2024-11-19T14:11:14.268Z | 2024-11-22T14:22:55.242Z |
5553630 | 5553630 | 20241118033706_4isqt | UK0032 | 2024-11-19T14:11:06.639Z | 2024-11-22T14:22:54.908Z |
5549608 | 5549608 | 20241118053730_QBXk6 | UK0032 | 2024-11-19T14:00:24.929Z | 2024-11-22T14:21:50.645Z |
5545097 | 5545097 | 20241116000817_pPrNB | UK0032 | 2024-11-17T14:03:47.195Z | 2024-11-22T14:23:36.035Z |
5545092 | 5545092 | 20241115235350_ef245 | UK0032 | 2024-11-17T14:03:46.461Z | 2024-11-22T14:23:35.884Z |
5543259 | 5543259 | 20241114233349_TkeDf | UK0032 | 2024-11-16T14:05:53.402Z | 2024-11-22T14:23:57.789Z |
5543173 | 5543173 | 20241114221848_jDirO | UK0032 | 2024-11-16T14:05:39.626Z | 2024-11-22T14:23:57.316Z |
5543153 | 5543153 | 20241114215426_3K1wF | UK0032 | 2024-11-16T14:05:37.566Z | 2024-11-22T14:23:57.225Z |
5538945 | 5538945 | 20241113052335_VLsCr | UK0032 | 2024-11-14T14:14:04.952Z | 2024-11-21T14:26:30.450Z |
5537811 | 5537811 | 20241113004503_ocUPH | UK0032 | 2024-11-14T14:12:31.481Z | 2024-11-21T14:26:16.354Z |
5537693 | 5537693 | 20241113000858_Jj3Bz | UK0032 | 2024-11-14T14:12:24.823Z | 2024-11-21T14:26:15.368Z |
5537658 | 5537658 | 20241112235933_XM8F7 | UK0032 | 2024-11-14T14:12:23.099Z | 2024-11-21T14:26:15.161Z |
5537521 | 5537521 | 20241112232938_jckJm | UK0032 | 2024-11-14T14:12:02.724Z | 2024-11-21T14:26:14.006Z |
5537284 | 5537284 | 20241112215518_GtoU4 | UK0032 | 2024-11-14T14:11:31.159Z | 2024-11-21T14:26:10.825Z |
5532631 | 5532631 | 20241112054522_dg0DL | UK0032 | 2024-11-13T14:17:04.545Z | 2024-11-20T14:26:25.304Z |
5531711 | 5531711 | 20241112040225_GW8rP | UK0032 | 2024-11-13T14:15:51.875Z | 2024-11-20T14:26:13.639Z |
5529772 | 5529772 | 20241112010401_prPM4 | UK0032 | 2024-11-13T14:13:10.277Z | 2024-11-20T14:25:48.167Z |
5529700 | 5529700 | 20241112005723_2IXdj | UK0032 | 2024-11-13T14:13:06.959Z | 2024-11-20T14:25:47.590Z |
5528797 | 5528797 | 20241111224051_ddHlY | UK0032 | 2024-11-13T14:11:27.134Z | 2024-11-20T14:25:36.058Z |
5528667 | 5528667 | 20241111221118_HtR52 | UK0032 | 2024-11-13T14:11:15.186Z | 2024-11-20T14:25:33.411Z |
5528626 | 5528626 | 20241111215900_VfCJ2 | UK0032 | 2024-11-13T14:11:11.374Z | 2024-11-20T14:25:32.883Z |
5528154 | 5528154 | 20241111194635_t7TpN | UK0032 | 2024-11-13T14:10:09.296Z | 2024-11-20T14:25:26.115Z |
5527731 | 5527731 | 20241111182548_t960E | UK0032 | 2024-11-13T14:09:00.619Z | 2024-11-20T14:25:18.629Z |
5442503 | 5442503 | 20241030014139_Pyv0T | UK0032 | 2024-11-01T12:19:55.520Z | 2024-11-07T14:26:46.829Z |
5442219 | 5442219 | 20241030005608_K2w9k | UK0032 | 2024-11-01T12:19:34.275Z | 2024-11-07T14:26:45.643Z |
5442085 | 5442085 | 20241030003508_lH933 | UK0032 | 2024-11-01T12:19:24.637Z | 2024-11-07T14:26:44.974Z |
5442014 | 5442014 | 20241030001813_DFi3T | UK0032 | 2024-11-01T12:19:19.455Z | 2024-11-07T14:26:44.688Z |
5441907 | 5441907 | 20241030000203_Mk8n1 | UK0032 | 2024-11-01T12:19:12.099Z | 2024-11-07T14:26:44.332Z |
5441850 | 5441850 | 20241029235241_3H8V0 | UK0032 | 2024-11-01T12:19:06.562Z | 2024-11-07T14:26:43.816Z |
5441842 | 5441842 | 20241029234951_H8MNb | UK0032 | 2024-11-01T12:19:05.850Z | 2024-11-07T14:26:43.754Z |
5441775 | 5441775 | 20241029232911_HBR3L | UK0032 | 2024-11-01T12:19:01.514Z | 2024-11-07T14:26:43.227Z |
5441755 | 5441755 | 20241029232520_cME6e | UK0032 | 2024-11-01T12:18:59.839Z | 2024-11-07T14:26:43.162Z |
5441712 | 5441712 | 20241029231637_gNQ6G | UK0032 | 2024-11-01T12:18:55.228Z | 2024-11-07T14:26:43.082Z |
5441590 | 5441590 | 20241029224338_DVNNS | UK0032 | 2024-11-01T12:18:46.753Z | 2024-11-07T14:26:42.701Z |
5441579 | 5441579 | 20241029223915_Zaw2x | UK0032 | 2024-11-01T12:18:46.420Z | 2024-11-07T14:26:42.690Z |
5441313 | 5441313 | 20241029214000_BMcJ1 | UK0032 | 2024-11-01T12:18:26.049Z | 2024-11-07T14:26:41.677Z |
5441151 | 5441151 | 20241029205857_BxmHS | UK0032 | 2024-11-01T12:18:11.585Z | 2024-11-07T14:26:41.006Z |
5433495 | 5433495 | 20241029200823_6kUqA | UK0032 | 2024-10-31T12:22:18.534Z | 2024-11-07T14:26:39.946Z |
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);