participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,757 rows where station_code = "UK002W" 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 |
---|---|---|---|---|---|
5570153 | 5570153 | 20241120185230_L3ika | UK002W | 2024-11-22T14:14:56.208Z | 2024-11-22T14:19:21.872Z |
5570075 | 5570075 | 20241120183900_A2fAZ | UK002W | 2024-11-22T14:14:49.612Z | 2024-11-22T14:19:21.857Z |
5565264 | 5565264 | 20241120040847_2Crxx | UK002W | 2024-11-21T14:18:44.082Z | 2024-11-22T14:21:44.802Z |
5563303 | 5563303 | 20241120011610_3tbmH | UK002W | 2024-11-21T14:15:52.136Z | 2024-11-22T14:21:12.594Z |
5561349 | 5561349 | 20241119200723_WXxVe | UK002W | 2024-11-21T14:13:08.153Z | 2024-11-22T14:20:33.103Z |
5558528 | 5558528 | 20241120062418_4s5VE | UK002W | 2024-11-21T14:03:31.941Z | 2024-11-22T14:19:21.246Z |
5558520 | 5558520 | 20241120062049_33gTk | UK002W | 2024-11-21T14:03:29.907Z | 2024-11-22T14:19:21.244Z |
5558490 | 5558490 | 20241120061428_t3kvy | UK002W | 2024-11-21T14:03:25.660Z | 2024-11-22T14:19:21.239Z |
5558102 | 5558102 | 20241120053726_z3Uci | UK002W | 2024-11-21T14:02:31.500Z | 2024-11-22T14:19:21.179Z |
5543776 | 5543776 | 20241115032904_A0Mg0 | UK002W | 2024-11-16T14:07:12.459Z | 2024-11-22T14:24:01.343Z |
5543746 | 5543746 | 20241115031639_RPIDC | UK002W | 2024-11-16T14:07:07.700Z | 2024-11-22T14:24:01.121Z |
5543742 | 5543742 | 20241115031529_3L0Yy | UK002W | 2024-11-16T14:07:07.383Z | 2024-11-22T14:24:01.108Z |
5543642 | 5543642 | 20241115024147_dcgI8 | UK002W | 2024-11-16T14:06:57.947Z | 2024-11-22T14:24:00.553Z |
5543587 | 5543587 | 20241115022224_MK7E5 | UK002W | 2024-11-16T14:06:53.429Z | 2024-11-22T14:24:00.237Z |
5543577 | 5543577 | 20241115021646_46wcC | UK002W | 2024-11-16T14:06:49.058Z | 2024-11-22T14:24:00.124Z |
5543543 | 5543543 | 20241115020036_NWZa8 | UK002W | 2024-11-16T14:06:39.446Z | 2024-11-22T14:23:59.955Z |
5543452 | 5543452 | 20241115012859_dQ8jg | UK002W | 2024-11-16T14:06:23.773Z | 2024-11-22T14:23:59.371Z |
5543283 | 5543283 | 20241114234951_Rx6zR | UK002W | 2024-11-16T14:06:00.250Z | 2024-11-22T14:23:57.911Z |
5543244 | 5543244 | 20241114232047_e8L0E | UK002W | 2024-11-16T14:05:49.510Z | 2024-11-22T14:23:57.686Z |
5537271 | 5537271 | 20241112214520_CHAtW | UK002W | 2024-11-14T14:11:29.635Z | 2024-11-21T14:26:10.762Z |
5532474 | 5532474 | 20241112052812_4BBgp | UK002W | 2024-11-13T14:16:51.697Z | 2024-11-20T14:26:23.824Z |
5532398 | 5532398 | 20241112051837_2jsja | UK002W | 2024-11-13T14:16:42.683Z | 2024-11-20T14:26:22.712Z |
5532357 | 5532357 | 20241112051319_SUlgr | UK002W | 2024-11-13T14:16:39.089Z | 2024-11-20T14:26:22.209Z |
5532035 | 5532035 | 20241112042950_9wUpx | UK002W | 2024-11-13T14:16:11.901Z | 2024-11-20T14:26:17.756Z |
5531904 | 5531904 | 20241112041756_GZyao | UK002W | 2024-11-13T14:16:01.281Z | 2024-11-20T14:26:15.799Z |
5531765 | 5531765 | 20241112040804_KiYVV | UK002W | 2024-11-13T14:15:54.201Z | 2024-11-20T14:26:14.216Z |
5531615 | 5531615 | 20241112035333_LewPv | UK002W | 2024-11-13T14:15:46.625Z | 2024-11-20T14:26:12.731Z |
5531535 | 5531535 | 20241112034801_CMESG | UK002W | 2024-11-13T14:15:44.077Z | 2024-11-20T14:26:12.131Z |
5531527 | 5531527 | 20241112034705_xDmWY | UK002W | 2024-11-13T14:15:43.905Z | 2024-11-20T14:26:12.095Z |
5531435 | 5531435 | 20241112033941_tNiRL | UK002W | 2024-11-13T14:15:39.491Z | 2024-11-20T14:26:11.279Z |
5530989 | 5530989 | 20241112030429_hPE2K | UK002W | 2024-11-13T14:14:58.738Z | 2024-11-20T14:26:05.814Z |
5530974 | 5530974 | 20241112030334_xk9Lx | UK002W | 2024-11-13T14:14:57.361Z | 2024-11-20T14:26:05.737Z |
5530323 | 5530323 | 20241112020747_6fpxx | UK002W | 2024-11-13T14:14:08.485Z | 2024-11-20T14:25:56.967Z |
5530263 | 5530263 | 20241112020304_p8ZSp | UK002W | 2024-11-13T14:14:05.019Z | 2024-11-20T14:25:56.269Z |
5529987 | 5529987 | 20241112013234_1FIKg | UK002W | 2024-11-13T14:13:34.333Z | 2024-11-20T14:25:52.059Z |
5529493 | 5529493 | 20241112002642_JXaBI | UK002W | 2024-11-13T14:12:54.534Z | 2024-11-20T14:25:45.701Z |
5528413 | 5528413 | 20241111204407_fQpGg | UK002W | 2024-11-13T14:10:35.882Z | 2024-11-20T14:25:30.232Z |
5528381 | 5528381 | 20241111203653_Ye3aN | UK002W | 2024-11-13T14:10:33.537Z | 2024-11-20T14:25:29.112Z |
5527769 | 5527769 | 20241111183247_7UCQg | UK002W | 2024-11-13T14:09:05.100Z | 2024-11-20T14:25:19.979Z |
5454830 | 5454830 | 20241031052652_3pyqN | UK002W | 2024-11-02T12:23:24.488Z | 2024-11-08T14:23:25.848Z |
5454714 | 5454714 | 20241031045841_iq3av | UK002W | 2024-11-02T12:23:18.601Z | 2024-11-08T14:23:24.854Z |
5454669 | 5454669 | 20241031045405_Z44CO | UK002W | 2024-11-02T12:23:16.267Z | 2024-11-08T14:23:24.702Z |
5454319 | 5454319 | 20241031040837_UX3DB | UK002W | 2024-11-02T12:23:00.606Z | 2024-11-08T14:23:22.196Z |
5454240 | 5454240 | 20241031040144_uoLSq | UK002W | 2024-11-02T12:22:56.101Z | 2024-11-08T14:23:21.685Z |
5454188 | 5454188 | 20241031035359_ubSRP | UK002W | 2024-11-02T12:22:54.142Z | 2024-11-08T14:23:21.024Z |
5454128 | 5454128 | 20241031034503_tpHBa | UK002W | 2024-11-02T12:22:51.601Z | 2024-11-08T14:23:20.655Z |
5454115 | 5454115 | 20241031034342_BqoDO | UK002W | 2024-11-02T12:22:51.348Z | 2024-11-08T14:23:20.606Z |
5454112 | 5454112 | 20241031034304_Dghkj | UK002W | 2024-11-02T12:22:51.287Z | 2024-11-08T14:23:20.571Z |
5454104 | 5454104 | 20241031034216_6zmAl | UK002W | 2024-11-02T12:22:50.827Z | 2024-11-08T14:23:20.465Z |
5453878 | 5453878 | 20241031031138_dvJx7 | UK002W | 2024-11-02T12:22:44.167Z | 2024-11-08T14:23:19.601Z |
5453615 | 5453615 | 20241031023126_i1KFG | UK002W | 2024-11-02T12:22:37.166Z | 2024-11-08T14:23:18.258Z |
5453608 | 5453608 | 20241031023038_ciH2v | UK002W | 2024-11-02T12:22:36.949Z | 2024-11-08T14:23:18.191Z |
5453573 | 5453573 | 20241031022637_doZbT | UK002W | 2024-11-02T12:22:36.350Z | 2024-11-08T14:23:18.109Z |
5453537 | 5453537 | 20241031022149_zqek7 | UK002W | 2024-11-02T12:22:35.594Z | 2024-11-08T14:23:18.019Z |
5453529 | 5453529 | 20241031022001_hcJTu | UK002W | 2024-11-02T12:22:35.246Z | 2024-11-08T14:23:17.880Z |
5453456 | 5453456 | 20241031021359_OUBH2 | UK002W | 2024-11-02T12:22:34.024Z | 2024-11-08T14:23:17.421Z |
5453391 | 5453391 | 20241031020833_kQIcv | UK002W | 2024-11-02T12:22:32.912Z | 2024-11-08T14:23:17.243Z |
5453350 | 5453350 | 20241031020438_hY25q | UK002W | 2024-11-02T12:22:32.188Z | 2024-11-08T14:23:16.919Z |
5453303 | 5453303 | 20241031015935_5jjKd | UK002W | 2024-11-02T12:22:31.450Z | 2024-11-08T14:23:16.526Z |
5453138 | 5453138 | 20241031014441_QfnBx | UK002W | 2024-11-02T12:22:27.889Z | 2024-11-08T14:23:16.081Z |
5453082 | 5453082 | 20241031013557_MUILu | UK002W | 2024-11-02T12:22:25.990Z | 2024-11-08T14:23:15.943Z |
5453078 | 5453078 | 20241031013544_pwdEC | UK002W | 2024-11-02T12:22:25.907Z | 2024-11-08T14:23:15.933Z |
5444505 | 5444505 | 20241031012717_yV29g | UK002W | 2024-11-01T12:21:20.534Z | 2024-11-08T14:23:15.777Z |
5444447 | 5444447 | 20241031012224_bE1qt | UK002W | 2024-11-01T12:21:18.211Z | 2024-11-08T14:23:15.624Z |
5444360 | 5444360 | 20241031011151_yEQyc | UK002W | 2024-11-01T12:21:13.961Z | 2024-11-08T14:23:14.714Z |
5444320 | 5444320 | 20241031010818_Rmjam | UK002W | 2024-11-01T12:21:12.613Z | 2024-11-08T14:23:14.334Z |
5444282 | 5444282 | 20241031010507_wd3n4 | UK002W | 2024-11-01T12:21:12.105Z | 2024-11-08T14:23:14.279Z |
5444243 | 5444243 | 20241031010230_6wNae | UK002W | 2024-11-01T12:21:11.436Z | 2024-11-08T14:23:14.183Z |
5444200 | 5444200 | 20241031005904_2flLE | UK002W | 2024-11-01T12:21:09.885Z | 2024-11-08T14:23:14.100Z |
5443973 | 5443973 | 20241031003439_vQ3J7 | UK002W | 2024-11-01T12:21:00.359Z | 2024-11-08T14:23:13.410Z |
5443960 | 5443960 | 20241031003350_3csz3 | UK002W | 2024-11-01T12:20:59.803Z | 2024-11-08T14:23:13.373Z |
5443914 | 5443914 | 20241031002905_qq2zl | UK002W | 2024-11-01T12:20:56.608Z | 2024-11-08T14:23:13.192Z |
5443600 | 5443600 | 20241030235042_kaeMR | UK002W | 2024-11-01T12:20:41.334Z | 2024-11-08T14:23:11.711Z |
5440959 | 5440959 | 20241030233030_DIGlF | UK002W | 2024-11-01T12:16:04.425Z | 2024-11-08T14:23:11.355Z |
5440866 | 5440866 | 20241030231622_fZXTr | UK002W | 2024-11-01T12:15:55.685Z | 2024-11-08T14:23:10.838Z |
5440834 | 5440834 | 20241030231422_zBdcA | UK002W | 2024-11-01T12:15:53.961Z | 2024-11-08T14:23:10.805Z |
5440461 | 5440461 | 20241030221503_tYKjD | UK002W | 2024-11-01T12:15:31.952Z | 2024-11-08T14:23:09.518Z |
5407540 | 5407540 | 20241027024103_Hk8Wo | UK002W | 2024-10-29T12:15:28.532Z | 2024-11-04T14:28:57.860Z |
5405116 | 5405116 | 20241027001428_SrH8F | UK002W | 2024-10-29T12:12:29.796Z | 2024-11-04T14:28:52.692Z |
5404953 | 5404953 | 20241027000250_hZG38 | UK002W | 2024-10-29T12:12:10.720Z | 2024-11-04T14:28:52.451Z |
5404923 | 5404923 | 20241027000055_S3oYq | UK002W | 2024-10-29T12:12:07.563Z | 2024-11-04T14:28:52.407Z |
5404506 | 5404506 | 20241026233229_n25yi | UK002W | 2024-10-29T12:11:38.849Z | 2024-11-04T14:28:51.271Z |
5404103 | 5404103 | 20241026225817_hOpOJ | UK002W | 2024-10-29T12:10:54.031Z | 2024-11-04T14:28:50.337Z |
5404049 | 5404049 | 20241026225453_4WnQH | UK002W | 2024-10-29T12:10:50.997Z | 2024-11-04T14:28:50.276Z |
5404007 | 5404007 | 20241026225255_PE3NF | UK002W | 2024-10-29T12:10:47.501Z | 2024-11-04T14:28:50.217Z |
5403521 | 5403521 | 20241026220558_dzQr2 | UK002W | 2024-10-29T12:09:42.015Z | 2024-11-04T14:28:49.117Z |
5403070 | 5403070 | 20241026211440_wPGmK | UK002W | 2024-10-29T12:08:52.192Z | 2024-11-04T14:28:47.661Z |
5402895 | 5402895 | 20241026204013_8Ts0k | UK002W | 2024-10-29T12:08:33.615Z | 2024-11-04T14:28:46.899Z |
5396237 | 5396237 | 20241025235010_PkDO3 | UK002W | 2024-10-28T12:17:28.505Z | 2024-11-03T14:27:29.020Z |
5395995 | 5395995 | 20241025232804_42iMe | UK002W | 2024-10-28T12:17:09.862Z | 2024-11-03T14:27:27.958Z |
5384023 | 5384023 | 20241024192555_qmi2x | UK002W | 2024-10-27T12:16:43.576Z | 2024-11-02T12:28:26.674Z |
5378114 | 5378114 | 20241024052729_nWSLp | UK002W | 2024-10-26T12:22:54.558Z | 2024-11-01T12:27:03.290Z |
5377991 | 5377991 | 20241024052241_e90z3 | UK002W | 2024-10-26T12:22:52.158Z | 2024-11-01T12:27:03.216Z |
5377589 | 5377589 | 20241024045819_DjBC3 | UK002W | 2024-10-26T12:22:41.322Z | 2024-11-01T12:27:02.617Z |
5377334 | 5377334 | 20241024044452_ffINF | UK002W | 2024-10-26T12:22:34.613Z | 2024-11-01T12:27:02.382Z |
5377290 | 5377290 | 20241024044214_1yiQV | UK002W | 2024-10-26T12:22:33.318Z | 2024-11-01T12:27:02.352Z |
5376321 | 5376321 | 20241024035140_ZaP1s | UK002W | 2024-10-26T12:21:56.829Z | 2024-11-01T12:27:01.501Z |
5376256 | 5376256 | 20241024034739_6zwLw | UK002W | 2024-10-26T12:21:55.064Z | 2024-11-01T12:27:01.474Z |
5373663 | 5373663 | 20241024014900_Fjb2V | UK002W | 2024-10-26T12:20:20.504Z | 2024-11-01T12:26:58.357Z |
5372863 | 5372863 | 20241024011157_5mYti | UK002W | 2024-10-26T12:19:46.278Z | 2024-11-01T12:26:58.006Z |
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);