participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,724 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 |
---|---|---|---|---|---|
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 |
5444351 | 5444351 | 20241031011055_yg9YQ | UK00AB | 2024-11-01T12:21:13.729Z | 2024-11-08T14:23:14.617Z |
5444190 | 5444190 | 20241031005630_k22LO | UK00AB | 2024-11-01T12:21:08.370Z | 2024-11-08T14:23:14.071Z |
5444173 | 5444173 | 20241031005507_PbHTO | UK00AB | 2024-11-01T12:21:08.128Z | 2024-11-08T14:23:14.055Z |
5444123 | 5444123 | 20241031004941_pD2Nm | UK00AB | 2024-11-01T12:21:06.667Z | 2024-11-08T14:23:13.991Z |
5444071 | 5444071 | 20241031004556_uHFGP | UK00AB | 2024-11-01T12:21:04.672Z | 2024-11-08T14:23:13.785Z |
5444067 | 5444067 | 20241031004354_dLm70 | UK00AB | 2024-11-01T12:21:04.380Z | 2024-11-08T14:23:13.777Z |
5444048 | 5444048 | 20241031004148_suqGe | UK00AB | 2024-11-01T12:21:03.313Z | 2024-11-08T14:23:13.616Z |
5443967 | 5443967 | 20241031003355_hoIx9 | UK00AB | 2024-11-01T12:20:59.908Z | 2024-11-08T14:23:13.383Z |
5443800 | 5443800 | 20241031001656_MLnqT | UK00AB | 2024-11-01T12:20:52.636Z | 2024-11-08T14:23:12.655Z |
5443787 | 5443787 | 20241031001540_C7KQu | UK00AB | 2024-11-01T12:20:51.491Z | 2024-11-08T14:23:12.451Z |
5443693 | 5443693 | 20241031000525_nXwxN | UK00AB | 2024-11-01T12:20:46.488Z | 2024-11-08T14:23:11.997Z |
5443664 | 5443664 | 20241031000145_OMpa7 | UK00AB | 2024-11-01T12:20:45.276Z | 2024-11-08T14:23:11.953Z |
5443647 | 5443647 | 20241030235905_Ywkcn | UK00AB | 2024-11-01T12:20:44.324Z | 2024-11-08T14:23:11.912Z |
5443558 | 5443558 | 20241030234224_8NiFD | UK00AB | 2024-11-01T12:20:38.659Z | 2024-11-08T14:23:11.630Z |
5443539 | 5443539 | 20241030233731_HlR8Z | UK00AB | 2024-11-01T12:20:37.811Z | 2024-11-08T14:23:11.578Z |
5440955 | 5440955 | 20241030233013_klOD0 | UK00AB | 2024-11-01T12:16:04.317Z | 2024-11-08T14:23:11.331Z |
5440882 | 5440882 | 20241030231813_X4ksq | UK00AB | 2024-11-01T12:15:56.966Z | 2024-11-08T14:23:10.863Z |
5440868 | 5440868 | 20241030231622_fZXTr | UK00AB | 2024-11-01T12:15:55.685Z | 2024-11-08T14:23:10.838Z |
5440847 | 5440847 | 20241030231509_yd6wa | UK00AB | 2024-11-01T12:15:54.539Z | 2024-11-08T14:23:10.821Z |
5440803 | 5440803 | 20241030230826_lrVfR | UK00AB | 2024-11-01T12:15:52.092Z | 2024-11-08T14:23:10.739Z |
5440748 | 5440748 | 20241030230026_oWN2D | UK00AB | 2024-11-01T12:15:48.625Z | 2024-11-08T14:23:10.609Z |
5440655 | 5440655 | 20241030224123_ktVL9 | UK00AB | 2024-11-01T12:15:42.246Z | 2024-11-08T14:23:10.220Z |
5440652 | 5440652 | 20241030224044_Z0Yo1 | UK00AB | 2024-11-01T12:15:41.922Z | 2024-11-08T14:23:10.209Z |
5440562 | 5440562 | 20241030222702_FPTQK | UK00AB | 2024-11-01T12:15:37.038Z | 2024-11-08T14:23:09.909Z |
5440463 | 5440463 | 20241030221503_tYKjD | UK00AB | 2024-11-01T12:15:31.957Z | 2024-11-08T14:23:09.518Z |
5440431 | 5440431 | 20241030221246_tj9dR | UK00AB | 2024-11-01T12:15:30.587Z | 2024-11-08T14:23:09.423Z |
5440376 | 5440376 | 20241030220424_yjf59 | UK00AB | 2024-11-01T12:15:27.656Z | 2024-11-08T14:23:09.285Z |
5440209 | 5440209 | 20241030214320_2wrRa | UK00AB | 2024-11-01T12:14:58.164Z | 2024-11-08T14:23:07.709Z |
5440144 | 5440144 | 20241030213007_kgq9c | UK00AB | 2024-11-01T12:14:53.913Z | 2024-11-08T14:23:07.574Z |
5440011 | 5440011 | 20241030210651_l7aCB | UK00AB | 2024-11-01T12:14:44.291Z | 2024-11-08T14:23:06.789Z |
5423004 | 5423004 | 20241027033823_BrBn3 | UK00AB | 2024-10-30T12:22:58.721Z | 2024-11-04T14:29:00.325Z |
5422974 | 5422974 | 20241027010945_kKqFD | UK00AB | 2024-10-30T12:22:34.342Z | 2024-11-04T14:28:54.649Z |
5422967 | 5422967 | 20241027001749_52Dig | UK00AB | 2024-10-30T12:22:27.587Z | 2024-11-04T14:28:52.748Z |
5422949 | 5422949 | 20241026215526_dKw7b | UK00AB | 2024-10-30T12:22:07.756Z | 2024-11-04T14:28:48.787Z |
5422938 | 5422938 | 20241026203110_xhN9q | UK00AB | 2024-10-30T12:22:00.829Z | 2024-11-04T14:28:46.638Z |
5412453 | 5412453 | 20241026043644_VA2Op | UK00AB | 2024-10-29T12:22:08.641Z | 2024-11-03T14:27:40.031Z |
5400009 | 5400009 | 20241026052154_k3YcL | UK00AB | 2024-10-28T12:20:18.718Z | 2024-11-03T14:27:41.102Z |
5399738 | 5399738 | 20241026045815_8aMYf | UK00AB | 2024-10-28T12:20:09.133Z | 2024-11-03T14:27:40.349Z |
5399693 | 5399693 | 20241026044855_TOG87 | UK00AB | 2024-10-28T12:20:07.591Z | 2024-11-03T14:27:40.291Z |
5399612 | 5399612 | 20241026043919_ErU0z | UK00AB | 2024-10-28T12:20:04.032Z | 2024-11-03T14:27:40.081Z |
5399558 | 5399558 | 20241026043439_7uBhC | UK00AB | 2024-10-28T12:20:01.869Z | 2024-11-03T14:27:39.954Z |
5399490 | 5399490 | 20241026042746_cZxn7 | UK00AB | 2024-10-28T12:20:00.780Z | 2024-11-03T14:27:39.850Z |
5399432 | 5399432 | 20241026041813_zY361 | UK00AB | 2024-10-28T12:19:59.442Z | 2024-11-03T14:27:39.705Z |
5399282 | 5399282 | 20241026040752_yF28Y | UK00AB | 2024-10-28T12:19:53.281Z | 2024-11-03T14:27:39.331Z |
5399250 | 5399250 | 20241026040459_FIVN3 | UK00AB | 2024-10-28T12:19:52.438Z | 2024-11-03T14:27:39.281Z |
5399102 | 5399102 | 20241026035333_fQLsf | UK00AB | 2024-10-28T12:19:48.476Z | 2024-11-03T14:27:39.022Z |
5399056 | 5399056 | 20241026034737_FsP3c | UK00AB | 2024-10-28T12:19:45.886Z | 2024-11-03T14:27:38.952Z |
5399041 | 5399041 | 20241026034639_3Fr8K | UK00AB | 2024-10-28T12:19:45.502Z | 2024-11-03T14:27:38.931Z |
5398993 | 5398993 | 20241026034400_Lpq47 | UK00AB | 2024-10-28T12:19:43.828Z | 2024-11-03T14:27:38.817Z |
5398959 | 5398959 | 20241026034102_T2rAB | UK00AB | 2024-10-28T12:19:41.399Z | 2024-11-03T14:27:38.714Z |
5398818 | 5398818 | 20241026033115_y1kIB | UK00AB | 2024-10-28T12:19:34.835Z | 2024-11-03T14:27:38.228Z |
5398582 | 5398582 | 20241026030950_zOgGC | UK00AB | 2024-10-28T12:19:23.178Z | 2024-11-03T14:27:36.878Z |
5397988 | 5397988 | 20241026021300_w2dks | UK00AB | 2024-10-28T12:18:54.935Z | 2024-11-03T14:27:34.778Z |
5397950 | 5397950 | 20241026020917_j0fNF | UK00AB | 2024-10-28T12:18:52.042Z | 2024-11-03T14:27:34.622Z |
5397745 | 5397745 | 20241026015242_Aam06 | UK00AB | 2024-10-28T12:18:38.167Z | 2024-11-03T14:27:34.064Z |
5397739 | 5397739 | 20241026015229_oB2QR | UK00AB | 2024-10-28T12:18:38.055Z | 2024-11-03T14:27:34.023Z |
5397542 | 5397542 | 20241026013856_tI2Qi | UK00AB | 2024-10-28T12:18:26.608Z | 2024-11-03T14:27:33.355Z |
5397408 | 5397408 | 20241026012638_3l5He | UK00AB | 2024-10-28T12:18:20.316Z | 2024-11-03T14:27:32.797Z |
5397275 | 5397275 | 20241026011415_9WWx2 | UK00AB | 2024-10-28T12:18:14.034Z | 2024-11-03T14:27:32.478Z |
5396952 | 5396952 | 20241026004908_Zli4t | UK00AB | 2024-10-28T12:18:00.467Z | 2024-11-03T14:27:31.525Z |
5396123 | 5396123 | 20241025234132_irMl3 | UK00AB | 2024-10-28T12:17:19.242Z | 2024-11-03T14:27:28.601Z |
5396062 | 5396062 | 20241025233656_2FM6H | UK00AB | 2024-10-28T12:17:16.890Z | 2024-11-03T14:27:28.330Z |
5396041 | 5396041 | 20241025233449_7CL2D | UK00AB | 2024-10-28T12:17:15.213Z | 2024-11-03T14:27:28.204Z |
5395708 | 5395708 | 20241025230609_MGgY5 | UK00AB | 2024-10-28T12:16:41.883Z | 2024-11-03T14:27:26.499Z |
5395630 | 5395630 | 20241025230014_j0iQn | UK00AB | 2024-10-28T12:16:34.346Z | 2024-11-03T14:27:26.298Z |
5395513 | 5395513 | 20241025224750_vqiLr | UK00AB | 2024-10-28T12:16:22.381Z | 2024-11-03T14:27:25.661Z |
5395403 | 5395403 | 20241025224035_XthSJ | UK00AB | 2024-10-28T12:16:12.668Z | 2024-11-03T14:27:25.452Z |
5395319 | 5395319 | 20241025223222_i2uyi | UK00AB | 2024-10-28T12:16:07.284Z | 2024-11-03T14:27:25.017Z |
5395220 | 5395220 | 20241025222152_3TpN2 | UK00AB | 2024-10-28T12:16:01.583Z | 2024-11-03T14:27:24.313Z |
5395112 | 5395112 | 20241025221201_43A9u | UK00AB | 2024-10-28T12:15:57.229Z | 2024-11-03T14:27:24.031Z |
5395059 | 5395059 | 20241025220336_KIB0E | UK00AB | 2024-10-28T12:15:54.951Z | 2024-11-03T14:27:23.866Z |
5395037 | 5395037 | 20241025220237_Qc2Un | UK00AB | 2024-10-28T12:15:54.101Z | 2024-11-03T14:27:23.707Z |
5394711 | 5394711 | 20241025211339_v6YYj | UK00AB | 2024-10-28T12:15:16.743Z | 2024-11-03T14:27:22.379Z |
5394629 | 5394629 | 20241025210028_gvRs8 | UK00AB | 2024-10-28T12:15:07.576Z | 2024-11-03T14:27:21.914Z |
5394583 | 5394583 | 20241025205320_czHtR | UK00AB | 2024-10-28T12:15:00.771Z | 2024-11-03T14:27:21.763Z |
5394390 | 5394390 | 20241025202609_L2i4x | UK00AB | 2024-10-28T12:14:33.649Z | 2024-11-03T14:27:21.126Z |
5389329 | 5389329 | 20241023025654_CSVua | UK00AB | 2024-10-27T12:26:56.612Z | 2024-10-31T12:30:06.762Z |
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);