participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,766 rows where station_code = "UK00AE" 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 |
---|---|---|---|---|---|
5570430 | 5570430 | 20241120193535_42Yk1 | UK00AE | 2024-11-22T14:15:24.920Z | 2024-11-22T14:19:21.916Z |
5570413 | 5570413 | 20241120193407_SGLRZ | UK00AE | 2024-11-22T14:15:20.595Z | 2024-11-22T14:19:21.913Z |
5570214 | 5570214 | 20241120190327_KO9VU | UK00AE | 2024-11-22T14:15:01.966Z | 2024-11-22T14:19:21.881Z |
5570204 | 5570204 | 20241120190318_rWMRF | UK00AE | 2024-11-22T14:15:00.652Z | 2024-11-22T14:19:21.880Z |
5570181 | 5570181 | 20241120185712_yPfSh | UK00AE | 2024-11-22T14:14:57.935Z | 2024-11-22T14:19:21.876Z |
5570124 | 5570124 | 20241120184529_qiOFO | UK00AE | 2024-11-22T14:14:53.803Z | 2024-11-22T14:19:21.866Z |
5570008 | 5570008 | 20241120182336_22fr3 | UK00AE | 2024-11-22T14:14:44.759Z | 2024-11-22T14:19:21.845Z |
5569891 | 5569891 | 20241120175339_c391V | UK00AE | 2024-11-22T14:14:31.322Z | 2024-11-22T14:19:21.823Z |
5569787 | 5569787 | 20241120173150_X66Wl | UK00AE | 2024-11-22T14:14:11.016Z | 2024-11-22T14:19:21.805Z |
5569738 | 5569738 | 20241120171139_2oIHL | UK00AE | 2024-11-22T14:14:02.244Z | 2024-11-22T14:19:21.795Z |
5565475 | 5565475 | 20241120042920_9KRta | UK00AE | 2024-11-21T14:18:50.200Z | 2024-11-22T14:21:47.482Z |
5565334 | 5565334 | 20241120041932_spJFM | UK00AE | 2024-11-21T14:18:46.656Z | 2024-11-22T14:21:46.007Z |
5565297 | 5565297 | 20241120041701_aDnh0 | UK00AE | 2024-11-21T14:18:45.551Z | 2024-11-22T14:21:45.752Z |
5565132 | 5565132 | 20241120035432_PW6Ms | UK00AE | 2024-11-21T14:18:32.947Z | 2024-11-22T14:21:42.222Z |
5565123 | 5565123 | 20241120035340_gF2mc | UK00AE | 2024-11-21T14:18:32.066Z | 2024-11-22T14:21:41.862Z |
5565079 | 5565079 | 20241120035033_rvX54 | UK00AE | 2024-11-21T14:18:28.545Z | 2024-11-22T14:21:41.349Z |
5565001 | 5565001 | 20241120034414_un24h | UK00AE | 2024-11-21T14:18:18.614Z | 2024-11-22T14:21:40.203Z |
5564843 | 5564843 | 20241120033011_gSD9H | UK00AE | 2024-11-21T14:18:06.804Z | 2024-11-22T14:21:36.887Z |
5564657 | 5564657 | 20241120031615_kBSKe | UK00AE | 2024-11-21T14:17:55.348Z | 2024-11-22T14:21:34.929Z |
5564591 | 5564591 | 20241120031131_8wxDl | UK00AE | 2024-11-21T14:17:52.061Z | 2024-11-22T14:21:33.791Z |
5564244 | 5564244 | 20241120024056_lXHGV | UK00AE | 2024-11-21T14:17:21.434Z | 2024-11-22T14:21:29.289Z |
5564176 | 5564176 | 20241120023502_B9zPh | UK00AE | 2024-11-21T14:17:15.560Z | 2024-11-22T14:21:27.876Z |
5563785 | 5563785 | 20241120020425_Uj2Jb | UK00AE | 2024-11-21T14:16:43.808Z | 2024-11-22T14:21:22.932Z |
5563652 | 5563652 | 20241120015430_O6XYk | UK00AE | 2024-11-21T14:16:31.604Z | 2024-11-22T14:21:20.309Z |
5563642 | 5563642 | 20241120015409_NDtD6 | UK00AE | 2024-11-21T14:16:31.286Z | 2024-11-22T14:21:20.285Z |
5563599 | 5563599 | 20241120015033_n2fMe | UK00AE | 2024-11-21T14:16:26.527Z | 2024-11-22T14:21:19.611Z |
5563584 | 5563584 | 20241120014725_qG2GX | UK00AE | 2024-11-21T14:16:25.361Z | 2024-11-22T14:21:19.371Z |
5563155 | 5563155 | 20241120005856_a8L3l | UK00AE | 2024-11-21T14:15:38.500Z | 2024-11-22T14:21:10.151Z |
5563123 | 5563123 | 20241120005428_0MmQS | UK00AE | 2024-11-21T14:15:37.406Z | 2024-11-22T14:21:09.868Z |
5563048 | 5563048 | 20241120004501_NH6MF | UK00AE | 2024-11-21T14:15:32.766Z | 2024-11-22T14:21:08.622Z |
5562794 | 5562794 | 20241120001315_dKFjk | UK00AE | 2024-11-21T14:15:22.077Z | 2024-11-22T14:21:03.953Z |
5562698 | 5562698 | 20241120000409_kYvs2 | UK00AE | 2024-11-21T14:15:17.226Z | 2024-11-22T14:21:02.584Z |
5562587 | 5562587 | 20241119235326_HFuZ8 | UK00AE | 2024-11-21T14:15:11.151Z | 2024-11-22T14:21:00.753Z |
5562495 | 5562495 | 20241119234356_QWnVi | UK00AE | 2024-11-21T14:15:01.604Z | 2024-11-22T14:20:59.423Z |
5562466 | 5562466 | 20241119234035_rTPwP | UK00AE | 2024-11-21T14:14:54.454Z | 2024-11-22T14:20:58.834Z |
5562394 | 5562394 | 20241119233355_M5NSf | UK00AE | 2024-11-21T14:14:46.585Z | 2024-11-22T14:20:57.045Z |
5562374 | 5562374 | 20241119233131_9Nsyw | UK00AE | 2024-11-21T14:14:45.464Z | 2024-11-22T14:20:56.840Z |
5562363 | 5562363 | 20241119232932_rdCXM | UK00AE | 2024-11-21T14:14:44.638Z | 2024-11-22T14:20:56.638Z |
5562201 | 5562201 | 20241119230919_uMTyK | UK00AE | 2024-11-21T14:14:31.654Z | 2024-11-22T14:20:53.891Z |
5562178 | 5562178 | 20241119230840_X7t8Y | UK00AE | 2024-11-21T14:14:30.948Z | 2024-11-22T14:20:53.827Z |
5562116 | 5562116 | 20241119230157_2wlaD | UK00AE | 2024-11-21T14:14:26.130Z | 2024-11-22T14:20:52.973Z |
5562059 | 5562059 | 20241119225319_SbN4P | UK00AE | 2024-11-21T14:14:22.470Z | 2024-11-22T14:20:52.201Z |
5561855 | 5561855 | 20241119221811_opfaj | UK00AE | 2024-11-21T14:14:10.302Z | 2024-11-22T14:20:47.826Z |
5561581 | 5561581 | 20241119210932_5YHL8 | UK00AE | 2024-11-21T14:13:29.792Z | 2024-11-22T14:20:41.218Z |
5561512 | 5561512 | 20241119205046_pkfsv | UK00AE | 2024-11-21T14:13:22.755Z | 2024-11-22T14:20:39.073Z |
5561331 | 5561331 | 20241119195748_hIfUb | UK00AE | 2024-11-21T14:13:06.387Z | 2024-11-22T14:20:32.322Z |
5561253 | 5561253 | 20241119191937_qsgCK | UK00AE | 2024-11-21T14:12:49.022Z | 2024-11-22T14:20:28.673Z |
5558530 | 5558530 | 20241120062418_4s5VE | UK00AE | 2024-11-21T14:03:31.941Z | 2024-11-22T14:19:21.246Z |
5558515 | 5558515 | 20241120061951_PLFUQ | UK00AE | 2024-11-21T14:03:29.151Z | 2024-11-22T14:19:21.243Z |
5558207 | 5558207 | 20241120054529_xVqf4 | UK00AE | 2024-11-21T14:02:44.019Z | 2024-11-22T14:19:21.193Z |
5558092 | 5558092 | 20241120053638_fIl5E | UK00AE | 2024-11-21T14:02:29.636Z | 2024-11-22T14:19:21.177Z |
5557412 | 5557412 | 20241120044412_W5T5q | UK00AE | 2024-11-21T14:00:44.977Z | 2024-11-22T14:19:21.066Z |
5557347 | 5557347 | 20241120043954_wkyXy | UK00AE | 2024-11-21T14:00:35.011Z | 2024-11-22T14:19:21.056Z |
5548466 | 5548466 | 20241116234211_yCkmu | UK00AE | 2024-11-18T14:09:17.208Z | 2024-11-22T14:23:13.400Z |
5532551 | 5532551 | 20241112053631_2FUZe | UK00AE | 2024-11-13T14:16:59.170Z | 2024-11-20T14:26:24.544Z |
5532543 | 5532543 | 20241112053628_7NWEH | UK00AE | 2024-11-13T14:16:58.751Z | 2024-11-20T14:26:24.470Z |
5532270 | 5532270 | 20241112050113_4B6Hy | UK00AE | 2024-11-13T14:16:32.298Z | 2024-11-20T14:26:21.488Z |
5531589 | 5531589 | 20241112035023_Abjvj | UK00AE | 2024-11-13T14:15:45.701Z | 2024-11-20T14:26:12.589Z |
5531554 | 5531554 | 20241112034810_CaEeh | UK00AE | 2024-11-13T14:15:44.421Z | 2024-11-20T14:26:12.149Z |
5531531 | 5531531 | 20241112034705_xDmWY | UK00AE | 2024-11-13T14:15:43.905Z | 2024-11-20T14:26:12.095Z |
5531372 | 5531372 | 20241112033408_muBiX | UK00AE | 2024-11-13T14:15:36.064Z | 2024-11-20T14:26:10.650Z |
5531297 | 5531297 | 20241112032916_Uq4oI | UK00AE | 2024-11-13T14:15:33.101Z | 2024-11-20T14:26:09.986Z |
5531253 | 5531253 | 20241112032556_pDsI2 | UK00AE | 2024-11-13T14:15:31.703Z | 2024-11-20T14:26:09.543Z |
5530993 | 5530993 | 20241112030429_hPE2K | UK00AE | 2024-11-13T14:14:58.738Z | 2024-11-20T14:26:05.815Z |
5530978 | 5530978 | 20241112030334_xk9Lx | UK00AE | 2024-11-13T14:14:57.361Z | 2024-11-20T14:26:05.737Z |
5530779 | 5530779 | 20241112024610_EQxZ1 | UK00AE | 2024-11-13T14:14:37.417Z | 2024-11-20T14:26:03.449Z |
5530616 | 5530616 | 20241112023358_h3TtC | UK00AE | 2024-11-13T14:14:24.880Z | 2024-11-20T14:26:01.997Z |
5530534 | 5530534 | 20241112022626_2VeHV | UK00AE | 2024-11-13T14:14:20.641Z | 2024-11-20T14:26:01.230Z |
5530467 | 5530467 | 20241112022046_r4b4r | UK00AE | 2024-11-13T14:14:17.298Z | 2024-11-20T14:26:00.566Z |
5530259 | 5530259 | 20241112020235_9M4Gi | UK00AE | 2024-11-13T14:14:04.739Z | 2024-11-20T14:25:56.122Z |
5530213 | 5530213 | 20241112015638_erhNb | UK00AE | 2024-11-13T14:14:01.796Z | 2024-11-20T14:25:55.435Z |
5530204 | 5530204 | 20241112015624_bQ2kV | UK00AE | 2024-11-13T14:14:01.612Z | 2024-11-20T14:25:55.419Z |
5530175 | 5530175 | 20241112015357_Se1c6 | UK00AE | 2024-11-13T14:13:59.895Z | 2024-11-20T14:25:55.094Z |
5529982 | 5529982 | 20241112013231_2fAAn | UK00AE | 2024-11-13T14:13:33.586Z | 2024-11-20T14:25:52.008Z |
5529816 | 5529816 | 20241112010559_kfL0v | UK00AE | 2024-11-13T14:13:13.023Z | 2024-11-20T14:25:48.484Z |
5529599 | 5529599 | 20241112004025_fXG6X | UK00AE | 2024-11-13T14:13:00.854Z | 2024-11-20T14:25:46.710Z |
5529548 | 5529548 | 20241112003306_borKW | UK00AE | 2024-11-13T14:12:57.245Z | 2024-11-20T14:25:46.227Z |
5529509 | 5529509 | 20241112002902_FNvhS | UK00AE | 2024-11-13T14:12:55.131Z | 2024-11-20T14:25:45.774Z |
5529506 | 5529506 | 20241112002841_KYCdI | UK00AE | 2024-11-13T14:12:55.010Z | 2024-11-20T14:25:45.754Z |
5529480 | 5529480 | 20241112002410_sD5o8 | UK00AE | 2024-11-13T14:12:53.249Z | 2024-11-20T14:25:45.450Z |
5529363 | 5529363 | 20241112000642_0QOAy | UK00AE | 2024-11-13T14:12:26.902Z | 2024-11-20T14:25:43.329Z |
5529310 | 5529310 | 20241112000024_TINoe | UK00AE | 2024-11-13T14:12:21.120Z | 2024-11-20T14:25:42.683Z |
5529091 | 5529091 | 20241111232813_RYWfK | UK00AE | 2024-11-13T14:12:04.587Z | 2024-11-20T14:25:39.701Z |
5528830 | 5528830 | 20241111224803_LGUof | UK00AE | 2024-11-13T14:11:28.659Z | 2024-11-20T14:25:36.402Z |
5528769 | 5528769 | 20241111223507_EZ8eY | UK00AE | 2024-11-13T14:11:25.122Z | 2024-11-20T14:25:35.467Z |
5528766 | 5528766 | 20241111223405_e66Vr | UK00AE | 2024-11-13T14:11:24.873Z | 2024-11-20T14:25:35.425Z |
5528635 | 5528635 | 20241111220159_FeRpn | UK00AE | 2024-11-13T14:11:11.865Z | 2024-11-20T14:25:33.010Z |
5528592 | 5528592 | 20241111214601_46jti | UK00AE | 2024-11-13T14:11:08.612Z | 2024-11-20T14:25:32.488Z |
5528467 | 5528467 | 20241111210042_hTxoQ | UK00AE | 2024-11-13T14:10:45.494Z | 2024-11-20T14:25:30.893Z |
5528384 | 5528384 | 20241111203653_Ye3aN | UK00AE | 2024-11-13T14:10:33.537Z | 2024-11-20T14:25:29.112Z |
5527886 | 5527886 | 20241111185250_9qg23 | UK00AE | 2024-11-13T14:09:30.427Z | 2024-11-20T14:25:22.565Z |
5527858 | 5527858 | 20241111184658_2nFsX | UK00AE | 2024-11-13T14:09:27.759Z | 2024-11-20T14:25:22.296Z |
5527654 | 5527654 | 20241111180530_cSU0J | UK00AE | 2024-11-13T14:08:51.699Z | 2024-11-20T14:25:16.375Z |
5527585 | 5527585 | 20241111174131_whKT2 | UK00AE | 2024-11-13T14:08:42.605Z | 2024-11-20T14:25:14.274Z |
5525627 | 5525627 | 20241112055747_0142F | UK00AE | 2024-11-13T14:00:09.926Z | 2024-11-21T14:25:24.392Z |
5454895 | 5454895 | 20241031054114_Yq36M | UK00AE | 2024-11-02T12:23:26.111Z | 2024-11-08T14:23:26.147Z |
5454813 | 5454813 | 20241031052254_7f3pm | UK00AE | 2024-11-02T12:23:23.935Z | 2024-11-08T14:23:25.801Z |
5454787 | 5454787 | 20241031051641_voIyP | UK00AE | 2024-11-02T12:23:23.145Z | 2024-11-08T14:23:25.649Z |
5454667 | 5454667 | 20241031045333_pVNad | UK00AE | 2024-11-02T12:23:16.023Z | 2024-11-08T14:23:24.674Z |
5454635 | 5454635 | 20241031044754_d7Wih | UK00AE | 2024-11-02T12:23:15.003Z | 2024-11-08T14:23:24.510Z |
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);