participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,015 rows where station_code = "UK00B1" 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 |
---|---|---|---|---|---|
5454274 | 5454274 | 20241031040417_rKXbw | UK00B1 | 2024-11-02T12:22:57.452Z | 2024-11-08T14:23:21.969Z |
5454242 | 5454242 | 20241031040144_uoLSq | UK00B1 | 2024-11-02T12:22:56.101Z | 2024-11-08T14:23:21.685Z |
5454114 | 5454114 | 20241031034304_Dghkj | UK00B1 | 2024-11-02T12:22:51.287Z | 2024-11-08T14:23:20.571Z |
5454106 | 5454106 | 20241031034216_6zmAl | UK00B1 | 2024-11-02T12:22:50.858Z | 2024-11-08T14:23:20.465Z |
5454077 | 5454077 | 20241031033955_aVdUJ | UK00B1 | 2024-11-02T12:22:50.161Z | 2024-11-08T14:23:20.305Z |
5453538 | 5453538 | 20241031022149_zqek7 | UK00B1 | 2024-11-02T12:22:35.594Z | 2024-11-08T14:23:18.019Z |
5453446 | 5453446 | 20241031021249_lrTYY | UK00B1 | 2024-11-02T12:22:33.781Z | 2024-11-08T14:23:17.413Z |
5453395 | 5453395 | 20241031020833_kQIcv | UK00B1 | 2024-11-02T12:22:32.933Z | 2024-11-08T14:23:17.243Z |
5453305 | 5453305 | 20241031015935_5jjKd | UK00B1 | 2024-11-02T12:22:31.478Z | 2024-11-08T14:23:16.526Z |
5453237 | 5453237 | 20241031015311_B4HYI | UK00B1 | 2024-11-02T12:22:30.181Z | 2024-11-08T14:23:16.206Z |
5453158 | 5453158 | 20241031014541_JbXG3 | UK00B1 | 2024-11-02T12:22:28.378Z | 2024-11-08T14:23:16.102Z |
5444512 | 5444512 | 20241031012717_yV29g | UK00B1 | 2024-11-01T12:21:20.534Z | 2024-11-08T14:23:15.777Z |
5444449 | 5444449 | 20241031012224_bE1qt | UK00B1 | 2024-11-01T12:21:18.211Z | 2024-11-08T14:23:15.624Z |
5444364 | 5444364 | 20241031011151_yEQyc | UK00B1 | 2024-11-01T12:21:13.961Z | 2024-11-08T14:23:14.714Z |
5444357 | 5444357 | 20241031011110_LEGMa | UK00B1 | 2024-11-01T12:21:13.931Z | 2024-11-08T14:23:14.689Z |
5444287 | 5444287 | 20241031010507_wd3n4 | UK00B1 | 2024-11-01T12:21:12.105Z | 2024-11-08T14:23:14.279Z |
5444246 | 5444246 | 20241031010230_6wNae | UK00B1 | 2024-11-01T12:21:11.436Z | 2024-11-08T14:23:14.183Z |
5444202 | 5444202 | 20241031005904_2flLE | UK00B1 | 2024-11-01T12:21:09.886Z | 2024-11-08T14:23:14.100Z |
5443978 | 5443978 | 20241031003439_vQ3J7 | UK00B1 | 2024-11-01T12:21:00.359Z | 2024-11-08T14:23:13.410Z |
5443806 | 5443806 | 20241031001701_kE2F2 | UK00B1 | 2024-11-01T12:20:52.731Z | 2024-11-08T14:23:12.668Z |
5443569 | 5443569 | 20241030234244_3U9DA | UK00B1 | 2024-11-01T12:20:38.777Z | 2024-11-08T14:23:11.667Z |
5440982 | 5440982 | 20241030233139_XmOp1 | UK00B1 | 2024-11-01T12:16:05.406Z | 2024-11-08T14:23:11.494Z |
5440966 | 5440966 | 20241030233030_DIGlF | UK00B1 | 2024-11-01T12:16:04.425Z | 2024-11-08T14:23:11.355Z |
5440839 | 5440839 | 20241030231422_zBdcA | UK00B1 | 2024-11-01T12:15:53.961Z | 2024-11-08T14:23:10.806Z |
5440605 | 5440605 | 20241030223145_gdtLg | UK00B1 | 2024-11-01T12:15:38.813Z | 2024-11-08T14:23:09.991Z |
5440584 | 5440584 | 20241030222956_tcQCA | UK00B1 | 2024-11-01T12:15:38.208Z | 2024-11-08T14:23:09.948Z |
5440577 | 5440577 | 20241030222833_QBB3e | UK00B1 | 2024-11-01T12:15:37.922Z | 2024-11-08T14:23:09.928Z |
5440247 | 5440247 | 20241030214619_9JdRo | UK00B1 | 2024-11-01T12:15:05.222Z | 2024-11-08T14:23:08.361Z |
5440243 | 5440243 | 20241030214604_HKiF0 | UK00B1 | 2024-11-01T12:15:04.198Z | 2024-11-08T14:23:08.188Z |
5440001 | 5440001 | 20241030210438_SsIqy | UK00B1 | 2024-11-01T12:14:43.632Z | 2024-11-08T14:23:06.692Z |
5439982 | 5439982 | 20241030210032_W42aY | UK00B1 | 2024-11-01T12:14:41.987Z | 2024-11-08T14:23:06.586Z |
5439907 | 5439907 | 20241030204701_CF3N2 | UK00B1 | 2024-11-01T12:14:37.353Z | 2024-11-08T14:23:06.017Z |
5439884 | 5439884 | 20241030204346_2oHiG | UK00B1 | 2024-11-01T12:14:35.488Z | 2024-11-08T14:23:05.982Z |
5439811 | 5439811 | 20241030203401_I37v3 | UK00B1 | 2024-11-01T12:14:31.383Z | 2024-11-08T14:23:05.836Z |
5439624 | 5439624 | 20241030201316_Go3k8 | UK00B1 | 2024-11-01T12:14:04.693Z | 2024-11-08T14:23:04.326Z |
5439612 | 5439612 | 20241030201154_Yz2Eo | UK00B1 | 2024-11-01T12:14:02.805Z | 2024-11-08T14:23:04.278Z |
5439591 | 5439591 | 20241030201130_sH7Xc | UK00B1 | 2024-11-01T12:14:00.773Z | 2024-11-08T14:23:04.239Z |
5439450 | 5439450 | 20241030195418_2m1Zk | UK00B1 | 2024-11-01T12:13:50.705Z | 2024-11-08T14:23:03.349Z |
5432937 | 5432937 | 20241029052030_TK0no | UK00B1 | 2024-10-31T12:21:40.550Z | 2024-11-06T14:27:29.354Z |
5432935 | 5432935 | 20241029052018_kQMnp | UK00B1 | 2024-10-31T12:21:39.852Z | 2024-11-06T14:27:29.351Z |
5432276 | 5432276 | 20241029030628_P47Az | UK00B1 | 2024-10-31T12:21:16.254Z | 2024-11-06T14:27:26.426Z |
5432246 | 5432246 | 20241029030124_J2Q6M | UK00B1 | 2024-10-31T12:21:15.039Z | 2024-11-06T14:27:26.359Z |
5432116 | 5432116 | 20241029024404_qdDwu | UK00B1 | 2024-10-31T12:21:03.310Z | 2024-11-06T14:27:25.982Z |
5432056 | 5432056 | 20241029023701_J8Bq7 | UK00B1 | 2024-10-31T12:20:59.292Z | 2024-11-06T14:27:25.840Z |
5432046 | 5432046 | 20241029023519_62gDg | UK00B1 | 2024-10-31T12:20:57.630Z | 2024-11-06T14:27:25.805Z |
5431993 | 5431993 | 20241029022804_Yz6ui | UK00B1 | 2024-10-31T12:20:55.483Z | 2024-11-06T14:27:25.666Z |
5431922 | 5431922 | 20241029021551_e20ng | UK00B1 | 2024-10-31T12:20:50.297Z | 2024-11-06T14:27:25.356Z |
5431670 | 5431670 | 20241029014459_ajDUw | UK00B1 | 2024-10-31T12:20:31.158Z | 2024-11-06T14:27:24.413Z |
5431643 | 5431643 | 20241029014044_S3J7C | UK00B1 | 2024-10-31T12:20:28.009Z | 2024-11-06T14:27:24.343Z |
5431628 | 5431628 | 20241029013849_t92oO | UK00B1 | 2024-10-31T12:20:26.838Z | 2024-11-06T14:27:24.274Z |
5431300 | 5431300 | 20241029005257_Ufvuo | UK00B1 | 2024-10-31T12:19:52.164Z | 2024-11-06T14:27:23.157Z |
5431259 | 5431259 | 20241029004512_tthtO | UK00B1 | 2024-10-31T12:19:47.867Z | 2024-11-06T14:27:23.081Z |
5431127 | 5431127 | 20241029003129_S9uwP | UK00B1 | 2024-10-31T12:19:37.038Z | 2024-11-06T14:27:22.844Z |
5430232 | 5430232 | 20241028213856_QC18F | UK00B1 | 2024-10-31T12:17:55.543Z | 2024-11-06T14:27:19.400Z |
5430204 | 5430204 | 20241028213437_SbNFU | UK00B1 | 2024-10-31T12:17:52.259Z | 2024-11-06T14:27:19.327Z |
5409918 | 5409918 | 20241027044154_RzwHJ | UK00B1 | 2024-10-29T12:17:44.081Z | 2024-11-04T14:29:02.929Z |
5409871 | 5409871 | 20241027043852_w2XyA | UK00B1 | 2024-10-29T12:17:42.690Z | 2024-11-04T14:29:02.825Z |
5409749 | 5409749 | 20241027043331_VxE3m | UK00B1 | 2024-10-29T12:17:39.900Z | 2024-11-04T14:29:02.429Z |
5409520 | 5409520 | 20241027042255_Sl3dy | UK00B1 | 2024-10-29T12:17:28.040Z | 2024-11-04T14:29:01.925Z |
5409339 | 5409339 | 20241027041119_jU0ix | UK00B1 | 2024-10-29T12:17:16.824Z | 2024-11-04T14:29:01.588Z |
5409301 | 5409301 | 20241027041019_PAQMx | UK00B1 | 2024-10-29T12:17:15.280Z | 2024-11-04T14:29:01.495Z |
5409084 | 5409084 | 20241027035918_Ss0G2 | UK00B1 | 2024-10-29T12:17:05.048Z | 2024-11-04T14:29:01.037Z |
5409025 | 5409025 | 20241027035545_CacHo | UK00B1 | 2024-10-29T12:17:01.736Z | 2024-11-04T14:29:00.940Z |
5408322 | 5408322 | 20241027032209_pd6Do | UK00B1 | 2024-10-29T12:16:22.713Z | 2024-11-04T14:28:59.084Z |
5408317 | 5408317 | 20241027032209_2JJ6D | UK00B1 | 2024-10-29T12:16:22.104Z | 2024-11-04T14:28:59.079Z |
5408075 | 5408075 | 20241027030532_rtsX5 | UK00B1 | 2024-10-29T12:16:03.739Z | 2024-11-04T14:28:58.750Z |
5408017 | 5408017 | 20241027030215_8dZrM | UK00B1 | 2024-10-29T12:15:59.680Z | 2024-11-04T14:28:58.691Z |
5407942 | 5407942 | 20241027025839_GLXBN | UK00B1 | 2024-10-29T12:15:54.213Z | 2024-11-04T14:28:58.515Z |
5407559 | 5407559 | 20241027024201_XOabj | UK00B1 | 2024-10-29T12:15:29.111Z | 2024-11-04T14:28:57.867Z |
5407545 | 5407545 | 20241027024103_Hk8Wo | UK00B1 | 2024-10-29T12:15:28.532Z | 2024-11-04T14:28:57.860Z |
5407492 | 5407492 | 20241027023847_h52k1 | UK00B1 | 2024-10-29T12:15:26.761Z | 2024-11-04T14:28:57.768Z |
5407264 | 5407264 | 20241027022841_QfjO2 | UK00B1 | 2024-10-29T12:15:19.103Z | 2024-11-04T14:28:57.274Z |
5406307 | 5406307 | 20241027012647_e1hSo | UK00B1 | 2024-10-29T12:14:01.490Z | 2024-11-04T14:28:55.422Z |
5405996 | 5405996 | 20241027011156_4fZZZ | UK00B1 | 2024-10-29T12:13:45.289Z | 2024-11-04T14:28:54.830Z |
5405915 | 5405915 | 20241027010720_Zw4Tl | UK00B1 | 2024-10-29T12:13:32.374Z | 2024-11-04T14:28:54.601Z |
5405908 | 5405908 | 20241027010653_F8A9o | UK00B1 | 2024-10-29T12:13:32.012Z | 2024-11-04T14:28:54.595Z |
5405721 | 5405721 | 20241027005426_BE5eI | UK00B1 | 2024-10-29T12:13:10.676Z | 2024-11-04T14:28:53.929Z |
5405687 | 5405687 | 20241027005316_bssPK | UK00B1 | 2024-10-29T12:13:09.536Z | 2024-11-04T14:28:53.898Z |
5405677 | 5405677 | 20241027005237_6cjxi | UK00B1 | 2024-10-29T12:13:09.047Z | 2024-11-04T14:28:53.887Z |
5405663 | 5405663 | 20241027005228_PfhNB | UK00B1 | 2024-10-29T12:13:08.385Z | 2024-11-04T14:28:53.878Z |
5405279 | 5405279 | 20241027002634_Jtu4X | UK00B1 | 2024-10-29T12:12:47.249Z | 2024-11-04T14:28:53.233Z |
5405256 | 5405256 | 20241027002547_lNBYz | UK00B1 | 2024-10-29T12:12:46.320Z | 2024-11-04T14:28:53.177Z |
5405191 | 5405191 | 20241027002104_bppXB | UK00B1 | 2024-10-29T12:12:40.226Z | 2024-11-04T14:28:52.773Z |
5405151 | 5405151 | 20241027001630_dKs5J | UK00B1 | 2024-10-29T12:12:32.990Z | 2024-11-04T14:28:52.727Z |
5405046 | 5405046 | 20241027001005_sYxuw | UK00B1 | 2024-10-29T12:12:19.220Z | 2024-11-04T14:28:52.617Z |
5404960 | 5404960 | 20241027000250_hZG38 | UK00B1 | 2024-10-29T12:12:10.720Z | 2024-11-04T14:28:52.451Z |
5404616 | 5404616 | 20241026234047_H30uQ | UK00B1 | 2024-10-29T12:11:46.007Z | 2024-11-04T14:28:51.410Z |
5404394 | 5404394 | 20241026232245_d3wlO | UK00B1 | 2024-10-29T12:11:18.023Z | 2024-11-04T14:28:50.846Z |
5404109 | 5404109 | 20241026225817_hOpOJ | UK00B1 | 2024-10-29T12:10:54.032Z | 2024-11-04T14:28:50.338Z |
5404012 | 5404012 | 20241026225255_PE3NF | UK00B1 | 2024-10-29T12:10:47.518Z | 2024-11-04T14:28:50.217Z |
5403637 | 5403637 | 20241026221849_qC8hl | UK00B1 | 2024-10-29T12:10:03.494Z | 2024-11-04T14:28:49.373Z |
5403632 | 5403632 | 20241026221838_IxpdU | UK00B1 | 2024-10-29T12:10:03.126Z | 2024-11-04T14:28:49.363Z |
5403526 | 5403526 | 20241026220558_dzQr2 | UK00B1 | 2024-10-29T12:09:42.015Z | 2024-11-04T14:28:49.117Z |
5403422 | 5403422 | 20241026215522_0rMfb | UK00B1 | 2024-10-29T12:09:28.660Z | 2024-11-04T14:28:48.760Z |
5403073 | 5403073 | 20241026211440_wPGmK | UK00B1 | 2024-10-29T12:08:52.192Z | 2024-11-04T14:28:47.661Z |
5402819 | 5402819 | 20241026202902_ZJYYP | UK00B1 | 2024-10-29T12:08:17.949Z | 2024-11-04T14:28:46.630Z |
5402699 | 5402699 | 20241026201529_2JLqC | UK00B1 | 2024-10-29T12:07:58.504Z | 2024-11-04T14:28:46.214Z |
5402578 | 5402578 | 20241026195745_Q4t2b | UK00B1 | 2024-10-29T12:07:43.910Z | 2024-11-04T14:28:45.359Z |
5402528 | 5402528 | 20241026195115_IJwcy | UK00B1 | 2024-10-29T12:07:32.913Z | 2024-11-04T14:28:45.085Z |
5402381 | 5402381 | 20241026192444_MS5ox | UK00B1 | 2024-10-29T12:07:07.045Z | 2024-11-04T14:28:44.163Z |
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);