participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,778 rows where station_code = "UK001Z" 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 |
---|---|---|---|---|---|
5454268 | 5454268 | 20241031040417_rKXbw | UK001Z | 2024-11-02T12:22:57.452Z | 2024-11-08T14:23:21.968Z |
5454198 | 5454198 | 20241031035545_lYDGS | UK001Z | 2024-11-02T12:22:54.431Z | 2024-11-08T14:23:21.340Z |
5454084 | 5454084 | 20241031034058_92XpZ | UK001Z | 2024-11-02T12:22:50.489Z | 2024-11-08T14:23:20.310Z |
5453775 | 5453775 | 20241031025835_68J4T | UK001Z | 2024-11-02T12:22:42.472Z | 2024-11-08T14:23:19.036Z |
5453593 | 5453593 | 20241031022824_5Eolw | UK001Z | 2024-11-02T12:22:36.686Z | 2024-11-08T14:23:18.170Z |
5453483 | 5453483 | 20241031021533_suTNg | UK001Z | 2024-11-02T12:22:34.496Z | 2024-11-08T14:23:17.588Z |
5453443 | 5453443 | 20241031021249_lrTYY | UK001Z | 2024-11-02T12:22:33.781Z | 2024-11-08T14:23:17.413Z |
5453370 | 5453370 | 20241031020641_vwfG0 | UK001Z | 2024-11-02T12:22:32.794Z | 2024-11-08T14:23:17.225Z |
5453326 | 5453326 | 20241031020301_PjpLB | UK001Z | 2024-11-02T12:22:31.868Z | 2024-11-08T14:23:16.735Z |
5453313 | 5453313 | 20241031020151_O3cL5 | UK001Z | 2024-11-02T12:22:31.753Z | 2024-11-08T14:23:16.590Z |
5453249 | 5453249 | 20241031015350_Le1BT | UK001Z | 2024-11-02T12:22:30.428Z | 2024-11-08T14:23:16.230Z |
5453077 | 5453077 | 20241031013544_pwdEC | UK001Z | 2024-11-02T12:22:25.907Z | 2024-11-08T14:23:15.933Z |
5453066 | 5453066 | 20241031013303_Ny1pg | UK001Z | 2024-11-02T12:22:25.430Z | 2024-11-08T14:23:15.854Z |
5444489 | 5444489 | 20241031012558_2yC02 | UK001Z | 2024-11-01T12:21:19.968Z | 2024-11-08T14:23:15.737Z |
5444463 | 5444463 | 20241031012315_PH2uD | UK001Z | 2024-11-01T12:21:18.471Z | 2024-11-08T14:23:15.669Z |
5444388 | 5444388 | 20241031011553_zYtgX | UK001Z | 2024-11-01T12:21:15.440Z | 2024-11-08T14:23:15.299Z |
5444281 | 5444281 | 20241031010507_wd3n4 | UK001Z | 2024-11-01T12:21:12.105Z | 2024-11-08T14:23:14.279Z |
5444269 | 5444269 | 20241031010430_QV9mi | UK001Z | 2024-11-01T12:21:11.976Z | 2024-11-08T14:23:14.270Z |
5444205 | 5444205 | 20241031005937_HXc0G | UK001Z | 2024-11-01T12:21:10.098Z | 2024-11-08T14:23:14.114Z |
5444162 | 5444162 | 20241031005442_dX8l1 | UK001Z | 2024-11-01T12:21:08.102Z | 2024-11-08T14:23:14.032Z |
5444139 | 5444139 | 20241031005205_KUDsg | UK001Z | 2024-11-01T12:21:07.767Z | 2024-11-08T14:23:14.019Z |
5444089 | 5444089 | 20241031004703_i0231 | UK001Z | 2024-11-01T12:21:05.842Z | 2024-11-08T14:23:13.914Z |
5444082 | 5444082 | 20241031004703_07GZP | UK001Z | 2024-11-01T12:21:05.537Z | 2024-11-08T14:23:13.815Z |
5444077 | 5444077 | 20241031004701_eejQs | UK001Z | 2024-11-01T12:21:05.517Z | 2024-11-08T14:23:13.805Z |
5444016 | 5444016 | 20241031003829_xy2xj | UK001Z | 2024-11-01T12:21:01.792Z | 2024-11-08T14:23:13.547Z |
5443902 | 5443902 | 20241031002713_TZ28n | UK001Z | 2024-11-01T12:20:56.236Z | 2024-11-08T14:23:13.067Z |
5443874 | 5443874 | 20241031002311_fZnmk | UK001Z | 2024-11-01T12:20:55.240Z | 2024-11-08T14:23:12.960Z |
5443865 | 5443865 | 20241031002233_6iFui | UK001Z | 2024-11-01T12:20:55.117Z | 2024-11-08T14:23:12.954Z |
5443843 | 5443843 | 20241031002027_qulJ4 | UK001Z | 2024-11-01T12:20:54.045Z | 2024-11-08T14:23:12.726Z |
5443761 | 5443761 | 20241031001138_wb9Rc | UK001Z | 2024-11-01T12:20:49.366Z | 2024-11-08T14:23:12.156Z |
5443749 | 5443749 | 20241031001103_GDQlG | UK001Z | 2024-11-01T12:20:48.757Z | 2024-11-08T14:23:12.135Z |
5443599 | 5443599 | 20241030235042_kaeMR | UK001Z | 2024-11-01T12:20:41.334Z | 2024-11-08T14:23:11.711Z |
5440978 | 5440978 | 20241030233139_XmOp1 | UK001Z | 2024-11-01T12:16:05.406Z | 2024-11-08T14:23:11.494Z |
5440855 | 5440855 | 20241030231617_rOR0p | UK001Z | 2024-11-01T12:15:55.201Z | 2024-11-08T14:23:10.835Z |
5440751 | 5440751 | 20241030230054_aZZ9M | UK001Z | 2024-11-01T12:15:48.822Z | 2024-11-08T14:23:10.611Z |
5440608 | 5440608 | 20241030223312_rdKXI | UK001Z | 2024-11-01T12:15:39.028Z | 2024-11-08T14:23:10.014Z |
5440593 | 5440593 | 20241030223112_2scyg | UK001Z | 2024-11-01T12:15:38.649Z | 2024-11-08T14:23:09.976Z |
5440586 | 5440586 | 20241030223045_4mckj | UK001Z | 2024-11-01T12:15:38.373Z | 2024-11-08T14:23:09.953Z |
5440550 | 5440550 | 20241030222650_d3eYq | UK001Z | 2024-11-01T12:15:36.599Z | 2024-11-08T14:23:09.899Z |
5440414 | 5440414 | 20241030220853_1tx8l | UK001Z | 2024-11-01T12:15:29.499Z | 2024-11-08T14:23:09.370Z |
5440312 | 5440312 | 20241030215554_ZwxHj | UK001Z | 2024-11-01T12:15:21.835Z | 2024-11-08T14:23:08.939Z |
5440102 | 5440102 | 20241030212312_cPqJP | UK001Z | 2024-11-01T12:14:50.416Z | 2024-11-08T14:23:07.350Z |
5439995 | 5439995 | 20241030210438_SsIqy | UK001Z | 2024-11-01T12:14:43.600Z | 2024-11-08T14:23:06.692Z |
5432946 | 5432946 | 20241029052349_N2K4C | UK001Z | 2024-10-31T12:21:40.843Z | 2024-11-06T14:27:29.374Z |
5432834 | 5432834 | 20241029045208_nlk6Y | UK001Z | 2024-10-31T12:21:36.365Z | 2024-11-06T14:27:28.902Z |
5432428 | 5432428 | 20241029033305_6kzP9 | UK001Z | 2024-10-31T12:21:22.239Z | 2024-11-06T14:27:27.000Z |
5432263 | 5432263 | 20241029030351_NdA84 | UK001Z | 2024-10-31T12:21:15.826Z | 2024-11-06T14:27:26.407Z |
5432172 | 5432172 | 20241029025203_bS91s | UK001Z | 2024-10-31T12:21:09.634Z | 2024-11-06T14:27:26.163Z |
5432148 | 5432148 | 20241029024835_OiDUJ | UK001Z | 2024-10-31T12:21:07.067Z | 2024-11-06T14:27:26.117Z |
5431392 | 5431392 | 20241029010442_Q7I7x | UK001Z | 2024-10-31T12:20:04.698Z | 2024-11-06T14:27:23.402Z |
5431190 | 5431190 | 20241029004019_hqxaa | UK001Z | 2024-10-31T12:19:44.969Z | 2024-11-06T14:27:22.943Z |
5431042 | 5431042 | 20241029001930_jE233 | UK001Z | 2024-10-31T12:19:31.027Z | 2024-11-06T14:27:22.595Z |
5430950 | 5430950 | 20241029000656_PJWAH | UK001Z | 2024-10-31T12:19:21.466Z | 2024-11-06T14:27:22.306Z |
5430801 | 5430801 | 20241028234113_K2U25 | UK001Z | 2024-10-31T12:19:04.160Z | 2024-11-06T14:27:21.615Z |
5430767 | 5430767 | 20241028233559_vs1hb | UK001Z | 2024-10-31T12:19:00.070Z | 2024-11-06T14:27:21.493Z |
5430637 | 5430637 | 20241028231345_SJq0Q | UK001Z | 2024-10-31T12:18:45.538Z | 2024-11-06T14:27:20.913Z |
5410827 | 5410827 | 20241027053957_mtQzN | UK001Z | 2024-10-29T12:18:05.850Z | 2024-11-04T14:29:05.637Z |
5410164 | 5410164 | 20241027045832_yZY1r | UK001Z | 2024-10-29T12:17:49.745Z | 2024-11-04T14:29:03.980Z |
5408986 | 5408986 | 20241027035230_OoKjm | UK001Z | 2024-10-29T12:16:59.827Z | 2024-11-04T14:29:00.898Z |
5408972 | 5408972 | 20241027035141_YSaAm | UK001Z | 2024-10-29T12:16:58.777Z | 2024-11-04T14:29:00.881Z |
5408918 | 5408918 | 20241027034956_e8IYl | UK001Z | 2024-10-29T12:16:57.132Z | 2024-11-04T14:29:00.824Z |
5408795 | 5408795 | 20241027034349_rxYtc | UK001Z | 2024-10-29T12:16:52.701Z | 2024-11-04T14:29:00.554Z |
5408765 | 5408765 | 20241027034250_M3BSv | UK001Z | 2024-10-29T12:16:49.334Z | 2024-11-04T14:29:00.465Z |
5406786 | 5406786 | 20241027015948_VWc9O | UK001Z | 2024-10-29T12:14:42.191Z | 2024-11-04T14:28:56.383Z |
5406574 | 5406574 | 20241027014613_WY1lb | UK001Z | 2024-10-29T12:14:22.679Z | 2024-11-04T14:28:55.888Z |
5406467 | 5406467 | 20241027013929_eAP5T | UK001Z | 2024-10-29T12:14:11.950Z | 2024-11-04T14:28:55.735Z |
5405505 | 5405505 | 20241027003956_3XpyO | UK001Z | 2024-10-29T12:12:59.591Z | 2024-11-04T14:28:53.580Z |
5405244 | 5405244 | 20241027002538_wvpGC | UK001Z | 2024-10-29T12:12:46.104Z | 2024-11-04T14:28:53.162Z |
5405232 | 5405232 | 20241027002508_n8JUC | UK001Z | 2024-10-29T12:12:45.720Z | 2024-11-04T14:28:53.148Z |
5405172 | 5405172 | 20241027001859_Ac0e3 | UK001Z | 2024-10-29T12:12:37.070Z | 2024-11-04T14:28:52.753Z |
5404997 | 5404997 | 20241027000707_bkzkk | UK001Z | 2024-10-29T12:12:15.319Z | 2024-11-04T14:28:52.505Z |
5404793 | 5404793 | 20241026235236_4BpHX | UK001Z | 2024-10-29T12:11:58.053Z | 2024-11-04T14:28:51.952Z |
5404590 | 5404590 | 20241026233956_AI8fa | UK001Z | 2024-10-29T12:11:45.066Z | 2024-11-04T14:28:51.366Z |
5404338 | 5404338 | 20241026231842_Ru2n4 | UK001Z | 2024-10-29T12:11:11.257Z | 2024-11-04T14:28:50.728Z |
5404273 | 5404273 | 20241026231326_6dOEF | UK001Z | 2024-10-29T12:11:04.250Z | 2024-11-04T14:28:50.573Z |
5403970 | 5403970 | 20241026224935_13ak2 | UK001Z | 2024-10-29T12:10:39.633Z | 2024-11-04T14:28:50.128Z |
5403771 | 5403771 | 20241026223014_JBCOm | UK001Z | 2024-10-29T12:10:13.221Z | 2024-11-04T14:28:49.652Z |
5403304 | 5403304 | 20241026213913_F7x7K | UK001Z | 2024-10-29T12:09:21.047Z | 2024-11-04T14:28:48.294Z |
5403091 | 5403091 | 20241026211748_OAwnL | UK001Z | 2024-10-29T12:08:53.727Z | 2024-11-04T14:28:47.701Z |
5403052 | 5403052 | 20241026211040_D0Fyz | UK001Z | 2024-10-29T12:08:50.780Z | 2024-11-04T14:28:47.632Z |
5402935 | 5402935 | 20241026204833_8SEz4 | UK001Z | 2024-10-29T12:08:37.473Z | 2024-11-04T14:28:47.011Z |
5402608 | 5402608 | 20241026200426_Gll2y | UK001Z | 2024-10-29T12:07:48.002Z | 2024-11-04T14:28:45.609Z |
5402275 | 5402275 | 20241026190926_Fh2Md | UK001Z | 2024-10-29T12:06:52.216Z | 2024-11-04T14:28:43.594Z |
5402061 | 5402061 | 20241026183841_unwQU | UK001Z | 2024-10-29T12:06:20.489Z | 2024-11-04T14:28:42.003Z |
5400157 | 5400157 | 20241026054650_ko9Bd | UK001Z | 2024-10-28T12:20:25.245Z | 2024-11-03T14:27:41.441Z |
5400134 | 5400134 | 20241026054249_QcBfN | UK001Z | 2024-10-28T12:20:24.464Z | 2024-11-03T14:27:41.387Z |
5399976 | 5399976 | 20241026051840_kn2e2 | UK001Z | 2024-10-28T12:20:18.051Z | 2024-11-03T14:27:40.940Z |
5399785 | 5399785 | 20241026050252_s3bXi | UK001Z | 2024-10-28T12:20:11.121Z | 2024-11-03T14:27:40.512Z |
5399709 | 5399709 | 20241026045313_jRIYs | UK001Z | 2024-10-28T12:20:08.463Z | 2024-11-03T14:27:40.307Z |
5399582 | 5399582 | 20241026043612_3F26A | UK001Z | 2024-10-28T12:20:03.245Z | 2024-11-03T14:27:40.016Z |
5399389 | 5399389 | 20241026041435_RzvOD | UK001Z | 2024-10-28T12:19:57.882Z | 2024-11-03T14:27:39.596Z |
5399263 | 5399263 | 20241026040637_Zj2W3 | UK001Z | 2024-10-28T12:19:52.762Z | 2024-11-03T14:27:39.296Z |
5399210 | 5399210 | 20241026040116_HwJ1w | UK001Z | 2024-10-28T12:19:51.480Z | 2024-11-03T14:27:39.251Z |
5399185 | 5399185 | 20241026040020_gCgy8 | UK001Z | 2024-10-28T12:19:50.893Z | 2024-11-03T14:27:39.195Z |
5399162 | 5399162 | 20241026035758_sfM3v | UK001Z | 2024-10-28T12:19:50.312Z | 2024-11-03T14:27:39.167Z |
5399143 | 5399143 | 20241026035649_k5UEh | UK001Z | 2024-10-28T12:19:49.857Z | 2024-11-03T14:27:39.132Z |
5398617 | 5398617 | 20241026031143_qHcTn | UK001Z | 2024-10-28T12:19:24.299Z | 2024-11-03T14:27:36.930Z |
5398596 | 5398596 | 20241026031056_TBVTM | UK001Z | 2024-10-28T12:19:23.605Z | 2024-11-03T14:27:36.915Z |
5398444 | 5398444 | 20241026025829_7JpiW | UK001Z | 2024-10-28T12:19:17.614Z | 2024-11-03T14:27:36.380Z |
5398232 | 5398232 | 20241026023612_bYtns | UK001Z | 2024-10-28T12:19:06.875Z | 2024-11-03T14:27:35.713Z |
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);