participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,718 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 |
---|---|---|---|---|---|
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 |
5366092 | 5366092 | 20241024000427_7yUSb | UK002W | 2024-10-25T12:18:16.099Z | 2024-11-01T12:26:56.744Z |
5364108 | 5364108 | 20241023220748_BUUIT | UK002W | 2024-10-25T12:17:09.427Z | 2024-11-01T12:26:54.546Z |
5363768 | 5363768 | 20241023214253_PZ3o9 | UK002W | 2024-10-25T12:16:43.570Z | 2024-11-01T12:26:53.617Z |
5363732 | 5363732 | 20241023213945_i2zrE | UK002W | 2024-10-25T12:16:38.677Z | 2024-11-01T12:26:53.587Z |
5363218 | 5363218 | 20241023203730_MUJjd | UK002W | 2024-10-25T12:15:42.339Z | 2024-11-01T12:26:52.964Z |
5362890 | 5362890 | 20241023200939_sneYk | UK002W | 2024-10-25T12:15:15.511Z | 2024-11-01T12:26:52.505Z |
5356292 | 5356292 | 20241023053320_XgB3y | UK002W | 2024-10-24T12:21:57.083Z | 2024-10-31T12:30:11.378Z |
5356127 | 5356127 | 20241023050401_N2yyJ | UK002W | 2024-10-24T12:21:53.713Z | 2024-10-31T12:30:10.516Z |
5356014 | 5356014 | 20241023044928_eiDMK | UK002W | 2024-10-24T12:21:47.571Z | 2024-10-31T12:30:09.540Z |
5355916 | 5355916 | 20241023043658_GNvYw | UK002W | 2024-10-24T12:21:42.115Z | 2024-10-31T12:30:09.204Z |
5355895 | 5355895 | 20241023043332_5G372 | UK002W | 2024-10-24T12:21:41.456Z | 2024-10-31T12:30:09.151Z |
5355664 | 5355664 | 20241023040022_Fu6ay | UK002W | 2024-10-24T12:21:30.150Z | 2024-10-31T12:30:08.393Z |
5355587 | 5355587 | 20241023035329_K14j8 | UK002W | 2024-10-24T12:21:26.806Z | 2024-10-31T12:30:08.085Z |
5355534 | 5355534 | 20241023034813_OGROG | UK002W | 2024-10-24T12:21:25.561Z | 2024-10-31T12:30:08.052Z |
5355449 | 5355449 | 20241023034110_QDCpV | UK002W | 2024-10-24T12:21:21.291Z | 2024-10-31T12:30:07.698Z |
5355404 | 5355404 | 20241023033724_aT6Gf | UK002W | 2024-10-24T12:21:18.123Z | 2024-10-31T12:30:07.650Z |
5355375 | 5355375 | 20241023033616_fvxp4 | UK002W | 2024-10-24T12:21:17.284Z | 2024-10-31T12:30:07.573Z |
5355266 | 5355266 | 20241023032551_Azc6y | UK002W | 2024-10-24T12:21:11.872Z | 2024-10-31T12:30:07.460Z |
5355223 | 5355223 | 20241023032228_cd85C | UK002W | 2024-10-24T12:21:10.599Z | 2024-10-31T12:30:07.386Z |
5354545 | 5354545 | 20241023023142_kSDUO | UK002W | 2024-10-24T12:20:40.253Z | 2024-10-31T12:30:05.965Z |
5354178 | 5354178 | 20241023020944_tX95S | UK002W | 2024-10-24T12:20:20.758Z | 2024-10-31T12:30:05.493Z |
5353936 | 5353936 | 20241023015539_p1gTI | UK002W | 2024-10-24T12:20:05.491Z | 2024-10-31T12:30:05.186Z |
5351280 | 5351280 | 20241022231317_q2SOj | UK002W | 2024-10-24T12:17:23.891Z | 2024-10-31T12:29:59.742Z |
5345023 | 5345023 | 20241022050718_uSe2O | UK002W | 2024-10-23T12:19:03.001Z | 2024-10-30T12:26:52.121Z |
5344998 | 5344998 | 20241022050553_Ewqhe | UK002W | 2024-10-23T12:19:02.150Z | 2024-10-30T12:26:52.073Z |
5344777 | 5344777 | 20241022044533_4KsUN | UK002W | 2024-10-23T12:18:50.455Z | 2024-10-30T12:26:51.667Z |
5344768 | 5344768 | 20241022044500_lbGEG | UK002W | 2024-10-23T12:18:50.318Z | 2024-10-30T12:26:51.657Z |
5344708 | 5344708 | 20241022044135_vqgeG | UK002W | 2024-10-23T12:18:48.513Z | 2024-10-30T12:26:51.568Z |
5344457 | 5344457 | 20241022042459_7pa8C | UK002W | 2024-10-23T12:18:37.897Z | 2024-10-30T12:26:51.270Z |
5344323 | 5344323 | 20241022041520_re0Hn | UK002W | 2024-10-23T12:18:31.712Z | 2024-10-30T12:26:51.170Z |
5344309 | 5344309 | 20241022041502_2rKh2 | UK002W | 2024-10-23T12:18:31.423Z | 2024-10-30T12:26:51.153Z |
5344298 | 5344298 | 20241022041400_3Rsi3 | UK002W | 2024-10-23T12:18:30.916Z | 2024-10-30T12:26:51.116Z |
5344199 | 5344199 | 20241022041003_pHEEF | UK002W | 2024-10-23T12:18:27.813Z | 2024-10-30T12:26:51.013Z |
5344166 | 5344166 | 20241022040917_py6zW | UK002W | 2024-10-23T12:18:27.116Z | 2024-10-30T12:26:50.977Z |
5344074 | 5344074 | 20241022040426_DiohI | UK002W | 2024-10-23T12:18:22.251Z | 2024-10-30T12:26:50.917Z |
5343698 | 5343698 | 20241022034030_3S9Kx | UK002W | 2024-10-23T12:18:01.737Z | 2024-10-30T12:26:50.449Z |
5343460 | 5343460 | 20241022033025_fhe3a | UK002W | 2024-10-23T12:17:47.138Z | 2024-10-30T12:26:50.043Z |
5342915 | 5342915 | 20241022025351_BowKd | UK002W | 2024-10-23T12:17:28.534Z | 2024-10-30T12:26:49.048Z |
5335010 | 5335010 | 20241021034256_vtH06 | UK002W | 2024-10-22T12:17:46.374Z | 2024-10-29T12:26:35.812Z |
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);