participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,801 rows where station_code = "UK00AB" 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 |
---|---|---|---|---|---|
5565014 | 5565014 | 20241120034448_q3Yl7 | UK00AB | 2024-11-21T14:18:19.748Z | 2024-11-22T14:21:40.291Z |
5564944 | 5564944 | 20241120034020_MOrjs | UK00AB | 2024-11-21T14:18:15.877Z | 2024-11-22T14:21:39.682Z |
5564907 | 5564907 | 20241120033817_asmSZ | UK00AB | 2024-11-21T14:18:14.909Z | 2024-11-22T14:21:39.499Z |
5564903 | 5564903 | 20241120033803_0OxdL | UK00AB | 2024-11-21T14:18:14.703Z | 2024-11-22T14:21:39.454Z |
5564464 | 5564464 | 20241120025859_J0mxx | UK00AB | 2024-11-21T14:17:39.438Z | 2024-11-22T14:21:32.542Z |
5564279 | 5564279 | 20241120024505_Yot3P | UK00AB | 2024-11-21T14:17:24.358Z | 2024-11-22T14:21:29.941Z |
5564159 | 5564159 | 20241120023413_iAYwX | UK00AB | 2024-11-21T14:17:14.632Z | 2024-11-22T14:21:27.741Z |
5563949 | 5563949 | 20241120021824_JMW0w | UK00AB | 2024-11-21T14:16:59.951Z | 2024-11-22T14:21:25.600Z |
5563726 | 5563726 | 20241120015945_00giz | UK00AB | 2024-11-21T14:16:36.131Z | 2024-11-22T14:21:21.485Z |
5563671 | 5563671 | 20241120015644_giLEd | UK00AB | 2024-11-21T14:16:33.528Z | 2024-11-22T14:21:20.676Z |
5563591 | 5563591 | 20241120014846_qSMa2 | UK00AB | 2024-11-21T14:16:25.721Z | 2024-11-22T14:21:19.469Z |
5563411 | 5563411 | 20241120012830_iIfVG | UK00AB | 2024-11-21T14:16:03.558Z | 2024-11-22T14:21:15.139Z |
5563317 | 5563317 | 20241120011610_CVvcP | UK00AB | 2024-11-21T14:15:52.810Z | 2024-11-22T14:21:12.856Z |
5563093 | 5563093 | 20241120005133_qk8j5 | UK00AB | 2024-11-21T14:15:36.437Z | 2024-11-22T14:21:09.553Z |
5563080 | 5563080 | 20241120004820_5Za7d | UK00AB | 2024-11-21T14:15:34.886Z | 2024-11-22T14:21:09.329Z |
5562893 | 5562893 | 20241120002403_0EGvs | UK00AB | 2024-11-21T14:15:26.386Z | 2024-11-22T14:21:05.895Z |
5562849 | 5562849 | 20241120001823_2x4ut | UK00AB | 2024-11-21T14:15:24.981Z | 2024-11-22T14:21:05.494Z |
5562833 | 5562833 | 20241120001600_9AOY8 | UK00AB | 2024-11-21T14:15:24.242Z | 2024-11-22T14:21:05.296Z |
5562669 | 5562669 | 20241120000303_2SduA | UK00AB | 2024-11-21T14:15:15.997Z | 2024-11-22T14:21:01.939Z |
5562623 | 5562623 | 20241119235735_3zDhZ | UK00AB | 2024-11-21T14:15:13.935Z | 2024-11-22T14:21:00.984Z |
5562562 | 5562562 | 20241119235220_5tkYJ | UK00AB | 2024-11-21T14:15:08.657Z | 2024-11-22T14:21:00.351Z |
5562487 | 5562487 | 20241119234338_7vitt | UK00AB | 2024-11-21T14:14:59.862Z | 2024-11-22T14:20:59.302Z |
5562413 | 5562413 | 20241119233416_5D2o4 | UK00AB | 2024-11-21T14:14:47.168Z | 2024-11-22T14:20:57.147Z |
5562325 | 5562325 | 20241119232215_TLRFU | UK00AB | 2024-11-21T14:14:42.094Z | 2024-11-22T14:20:55.898Z |
5562270 | 5562270 | 20241119231841_RDA4I | UK00AB | 2024-11-21T14:14:39.542Z | 2024-11-22T14:20:54.934Z |
5562238 | 5562238 | 20241119231549_CoOTg | UK00AB | 2024-11-21T14:14:35.477Z | 2024-11-22T14:20:54.500Z |
5562146 | 5562146 | 20241119230300_5LvQN | UK00AB | 2024-11-21T14:14:28.667Z | 2024-11-22T14:20:53.364Z |
5562099 | 5562099 | 20241119225935_EmdPQ | UK00AB | 2024-11-21T14:14:24.501Z | 2024-11-22T14:20:52.677Z |
5561686 | 5561686 | 20241119214034_zKptk | UK00AB | 2024-11-21T14:13:45.022Z | 2024-11-22T14:20:43.278Z |
5561607 | 5561607 | 20241119211252_NWJ3R | UK00AB | 2024-11-21T14:13:33.842Z | 2024-11-22T14:20:41.715Z |
5561566 | 5561566 | 20241119210548_J3uZS | UK00AB | 2024-11-21T14:13:27.864Z | 2024-11-22T14:20:40.782Z |
5561421 | 5561421 | 20241119202905_2KR7m | UK00AB | 2024-11-21T14:13:15.388Z | 2024-11-22T14:20:35.813Z |
5561342 | 5561342 | 20241119200302_kVBAR | UK00AB | 2024-11-21T14:13:07.389Z | 2024-11-22T14:20:32.633Z |
5561219 | 5561219 | 20241119190741_vW3o2 | UK00AB | 2024-11-21T14:12:39.931Z | 2024-11-22T14:20:26.715Z |
5558271 | 5558271 | 20241120055119_VSAgS | UK00AB | 2024-11-21T14:02:54.086Z | 2024-11-22T14:19:21.202Z |
5557922 | 5557922 | 20241120052334_4L1Ez | UK00AB | 2024-11-21T14:02:03.954Z | 2024-11-22T14:19:21.146Z |
5557910 | 5557910 | 20241120052236_GwnrA | UK00AB | 2024-11-21T14:02:02.847Z | 2024-11-22T14:19:21.145Z |
5557831 | 5557831 | 20241120051548_qMaD7 | UK00AB | 2024-11-21T14:01:53.170Z | 2024-11-22T14:19:21.135Z |
5557808 | 5557808 | 20241120051338_57azv | UK00AB | 2024-11-21T14:01:48.612Z | 2024-11-22T14:19:21.131Z |
5557758 | 5557758 | 20241120051032_O5jIp | UK00AB | 2024-11-21T14:01:41.188Z | 2024-11-22T14:19:21.124Z |
5557691 | 5557691 | 20241120050451_2LZXa | UK00AB | 2024-11-21T14:01:30.810Z | 2024-11-22T14:19:21.112Z |
5557685 | 5557685 | 20241120050450_0csWC | UK00AB | 2024-11-21T14:01:30.512Z | 2024-11-22T14:19:21.111Z |
5557641 | 5557641 | 20241120050301_5KEsy | UK00AB | 2024-11-21T14:01:24.385Z | 2024-11-22T14:19:21.103Z |
5557522 | 5557522 | 20241120045330_4QRnY | UK00AB | 2024-11-21T14:01:05.173Z | 2024-11-22T14:19:21.084Z |
5557355 | 5557355 | 20241120044003_ucuow | UK00AB | 2024-11-21T14:00:35.752Z | 2024-11-22T14:19:21.057Z |
5557299 | 5557299 | 20241120043424_vNu5u | UK00AB | 2024-11-21T14:00:27.858Z | 2024-11-22T14:19:21.049Z |
5543873 | 5543873 | 20241115035757_Zuomy | UK00AB | 2024-11-16T14:07:34.534Z | 2024-11-22T14:24:02.170Z |
5543823 | 5543823 | 20241115034527_9pRZq | UK00AB | 2024-11-16T14:07:20.117Z | 2024-11-22T14:24:01.753Z |
5532671 | 5532671 | 20241112054955_GfT8G | UK00AB | 2024-11-13T14:17:08.246Z | 2024-11-20T14:26:25.538Z |
5532621 | 5532621 | 20241112054437_LYIkN | UK00AB | 2024-11-13T14:17:03.777Z | 2024-11-20T14:26:25.171Z |
5532600 | 5532600 | 20241112054310_J3THw | UK00AB | 2024-11-13T14:17:02.539Z | 2024-11-20T14:26:25.049Z |
5532524 | 5532524 | 20241112053337_REb4U | UK00AB | 2024-11-13T14:16:57.162Z | 2024-11-20T14:26:24.159Z |
5532435 | 5532435 | 20241112052140_GA86y | UK00AB | 2024-11-13T14:16:46.383Z | 2024-11-20T14:26:22.859Z |
5532206 | 5532206 | 20241112045206_TbtmD | UK00AB | 2024-11-13T14:16:27.088Z | 2024-11-20T14:26:20.883Z |
5532121 | 5532121 | 20241112043846_ht0Nr | UK00AB | 2024-11-13T14:16:20.149Z | 2024-11-20T14:26:18.910Z |
5531571 | 5531571 | 20241112035013_kErfB | UK00AB | 2024-11-13T14:15:45.127Z | 2024-11-20T14:26:12.369Z |
5531539 | 5531539 | 20241112034801_CMESG | UK00AB | 2024-11-13T14:15:44.077Z | 2024-11-20T14:26:12.131Z |
5531121 | 5531121 | 20241112031535_RJqds | UK00AB | 2024-11-13T14:15:15.810Z | 2024-11-20T14:26:08.064Z |
5531113 | 5531113 | 20241112031510_3UDCM | UK00AB | 2024-11-13T14:15:15.554Z | 2024-11-20T14:26:07.976Z |
5531066 | 5531066 | 20241112031008_2oDeT | UK00AB | 2024-11-13T14:15:07.580Z | 2024-11-20T14:26:06.942Z |
5530923 | 5530923 | 20241112025947_puJ4C | UK00AB | 2024-11-13T14:14:50.901Z | 2024-11-20T14:26:05.299Z |
5530741 | 5530741 | 20241112024152_NikYY | UK00AB | 2024-11-13T14:14:33.758Z | 2024-11-20T14:26:02.981Z |
5530696 | 5530696 | 20241112023817_KZO0v | UK00AB | 2024-11-13T14:14:28.049Z | 2024-11-20T14:26:02.613Z |
5530443 | 5530443 | 20241112021819_8yAYO | UK00AB | 2024-11-13T14:14:15.649Z | 2024-11-20T14:26:00.136Z |
5530402 | 5530402 | 20241112021544_DTd7b | UK00AB | 2024-11-13T14:14:13.964Z | 2024-11-20T14:25:58.469Z |
5530318 | 5530318 | 20241112020725_fPTJd | UK00AB | 2024-11-13T14:14:08.326Z | 2024-11-20T14:25:56.883Z |
5530249 | 5530249 | 20241112020153_75BbG | UK00AB | 2024-11-13T14:14:04.463Z | 2024-11-20T14:25:56.108Z |
5530145 | 5530145 | 20241112014947_WKusm | UK00AB | 2024-11-13T14:13:58.545Z | 2024-11-20T14:25:54.852Z |
5530077 | 5530077 | 20241112013959_C7nco | UK00AB | 2024-11-13T14:13:48.793Z | 2024-11-20T14:25:54.076Z |
5530065 | 5530065 | 20241112013857_ArZX7 | UK00AB | 2024-11-13T14:13:47.786Z | 2024-11-20T14:25:54.002Z |
5530050 | 5530050 | 20241112013807_Njehl | UK00AB | 2024-11-13T14:13:44.807Z | 2024-11-20T14:25:53.478Z |
5530031 | 5530031 | 20241112013748_0KGyc | UK00AB | 2024-11-13T14:13:41.771Z | 2024-11-20T14:25:53.142Z |
5529782 | 5529782 | 20241112010424_ZWBsh | UK00AB | 2024-11-13T14:13:10.683Z | 2024-11-20T14:25:48.215Z |
5529724 | 5529724 | 20241112010024_SfLKs | UK00AB | 2024-11-13T14:13:07.996Z | 2024-11-20T14:25:47.713Z |
5529589 | 5529589 | 20241112004005_yD2Th | UK00AB | 2024-11-13T14:13:00.024Z | 2024-11-20T14:25:46.523Z |
5525686 | 5525686 | 20241112060645_ORdFb | UK00AB | 2024-11-13T14:00:20.935Z | 2024-11-21T14:25:25.402Z |
5525643 | 5525643 | 20241112055828_3mpNn | UK00AB | 2024-11-13T14:00:10.857Z | 2024-11-21T14:25:24.449Z |
5454880 | 5454880 | 20241031053803_u3Rq0 | UK00AB | 2024-11-02T12:23:25.686Z | 2024-11-08T14:23:26.089Z |
5454875 | 5454875 | 20241031053726_wXM6h | UK00AB | 2024-11-02T12:23:25.648Z | 2024-11-08T14:23:26.075Z |
5454846 | 5454846 | 20241031053136_5ZonS | UK00AB | 2024-11-02T12:23:24.916Z | 2024-11-08T14:23:25.934Z |
5454644 | 5454644 | 20241031045128_Iqmf2 | UK00AB | 2024-11-02T12:23:15.447Z | 2024-11-08T14:23:24.585Z |
5454575 | 5454575 | 20241031044105_7FHnq | UK00AB | 2024-11-02T12:23:12.459Z | 2024-11-08T14:23:24.151Z |
5454565 | 5454565 | 20241031043943_0XFWq | UK00AB | 2024-11-02T12:23:11.649Z | 2024-11-08T14:23:24.045Z |
5454412 | 5454412 | 20241031041711_eGz0U | UK00AB | 2024-11-02T12:23:05.748Z | 2024-11-08T14:23:22.872Z |
5454264 | 5454264 | 20241031040354_hkiBg | UK00AB | 2024-11-02T12:22:56.908Z | 2024-11-08T14:23:21.765Z |
5454225 | 5454225 | 20241031035841_P8YoY | UK00AB | 2024-11-02T12:22:55.391Z | 2024-11-08T14:23:21.548Z |
5454189 | 5454189 | 20241031035359_ubSRP | UK00AB | 2024-11-02T12:22:54.142Z | 2024-11-08T14:23:21.024Z |
5454063 | 5454063 | 20241031033821_PBtx3 | UK00AB | 2024-11-02T12:22:49.869Z | 2024-11-08T14:23:20.229Z |
5453999 | 5453999 | 20241031032759_AZUqu | UK00AB | 2024-11-02T12:22:47.307Z | 2024-11-08T14:23:19.952Z |
5453982 | 5453982 | 20241031032441_Gyu6L | UK00AB | 2024-11-02T12:22:46.779Z | 2024-11-08T14:23:19.826Z |
5453704 | 5453704 | 20241031024928_rvD6x | UK00AB | 2024-11-02T12:22:40.855Z | 2024-11-08T14:23:18.871Z |
5453632 | 5453632 | 20241031023715_SES36 | UK00AB | 2024-11-02T12:22:37.714Z | 2024-11-08T14:23:18.307Z |
5453618 | 5453618 | 20241031023256_oySr3 | UK00AB | 2024-11-02T12:22:37.208Z | 2024-11-08T14:23:18.267Z |
5453342 | 5453342 | 20241031020400_pjgDD | UK00AB | 2024-11-02T12:22:32.081Z | 2024-11-08T14:23:16.773Z |
5453335 | 5453335 | 20241031020315_6gMKu | UK00AB | 2024-11-02T12:22:31.911Z | 2024-11-08T14:23:16.757Z |
5453196 | 5453196 | 20241031014943_RSop5 | UK00AB | 2024-11-02T12:22:29.725Z | 2024-11-08T14:23:16.161Z |
5453185 | 5453185 | 20241031014900_5Hnfu | UK00AB | 2024-11-02T12:22:29.353Z | 2024-11-08T14:23:16.145Z |
5444502 | 5444502 | 20241031012628_qILci | UK00AB | 2024-11-01T12:21:20.488Z | 2024-11-08T14:23:15.758Z |
5444444 | 5444444 | 20241031012200_Jm3Wr | UK00AB | 2024-11-01T12:21:18.130Z | 2024-11-08T14:23:15.594Z |
5444383 | 5444383 | 20241031011512_wIvKY | UK00AB | 2024-11-01T12:21:15.127Z | 2024-11-08T14:23:15.210Z |
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);