participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
598 rows where station_code = "UK00BL" 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 |
---|---|---|---|---|---|
5135322 | 5135322 | 20240915040245_zGMqY | UK00BL | 2024-09-19T12:19:13.340Z | 2024-09-19T12:19:13.340Z |
5129759 | 5129759 | 20240917042512_YPcGy | UK00BL | 2024-09-19T12:12:02.895Z | 2024-09-19T12:12:02.895Z |
5129684 | 5129684 | 20240917042148_53vsL | UK00BL | 2024-09-19T12:12:00.538Z | 2024-09-19T12:12:00.538Z |
5129664 | 5129664 | 20240917042119_UWnWe | UK00BL | 2024-09-19T12:12:00.122Z | 2024-09-19T12:12:00.122Z |
5129492 | 5129492 | 20240917040451_YYTpq | UK00BL | 2024-09-19T12:11:44.686Z | 2024-09-19T12:11:44.686Z |
5129301 | 5129301 | 20240917034630_6Zgnr | UK00BL | 2024-09-19T12:11:26.313Z | 2024-09-19T12:11:26.313Z |
5129029 | 5129029 | 20240917030907_ZYVJx | UK00BL | 2024-09-19T12:11:11.875Z | 2024-09-19T12:11:11.875Z |
5129016 | 5129016 | 20240917030739_7PbCu | UK00BL | 2024-09-19T12:11:11.356Z | 2024-09-19T12:11:11.356Z |
5128828 | 5128828 | 20240917024456_2qPrg | UK00BL | 2024-09-19T12:11:03.169Z | 2024-09-19T12:11:03.169Z |
5128774 | 5128774 | 20240917023446_0sTAC | UK00BL | 2024-09-19T12:11:00.860Z | 2024-09-19T12:11:00.860Z |
5128597 | 5128597 | 20240917020759_7vm3g | UK00BL | 2024-09-19T12:10:46.472Z | 2024-09-19T12:10:46.472Z |
5128563 | 5128563 | 20240917020349_oJXd2 | UK00BL | 2024-09-19T12:10:43.531Z | 2024-09-19T12:10:43.531Z |
5128306 | 5128306 | 20240917012201_PHVbY | UK00BL | 2024-09-19T12:10:25.679Z | 2024-09-19T12:10:25.679Z |
5128259 | 5128259 | 20240917010944_y4nji | UK00BL | 2024-09-19T12:10:21.933Z | 2024-09-19T12:10:21.933Z |
5128199 | 5128199 | 20240917010457_029vC | UK00BL | 2024-09-19T12:10:19.785Z | 2024-09-19T12:10:19.785Z |
5128099 | 5128099 | 20240917003554_INf3N | UK00BL | 2024-09-19T12:10:03.475Z | 2024-09-19T12:10:03.475Z |
5127921 | 5127921 | 20240917000505_sC3Ql | UK00BL | 2024-09-19T12:09:46.715Z | 2024-09-19T12:09:46.715Z |
5127883 | 5127883 | 20240916235705_EtZUI | UK00BL | 2024-09-19T12:09:44.994Z | 2024-09-19T12:09:44.994Z |
5127737 | 5127737 | 20240916231523_C4vek | UK00BL | 2024-09-19T12:09:34.971Z | 2024-09-19T12:09:34.971Z |
5127692 | 5127692 | 20240916225232_XdM57 | UK00BL | 2024-09-19T12:09:31.439Z | 2024-09-19T12:09:31.439Z |
5127552 | 5127552 | 20240916222505_cTlkD | UK00BL | 2024-09-19T12:09:21.231Z | 2024-09-19T12:09:21.231Z |
5127533 | 5127533 | 20240916221624_TycVy | UK00BL | 2024-09-19T12:09:17.666Z | 2024-09-19T12:09:17.666Z |
5127510 | 5127510 | 20240916221249_AmGNp | UK00BL | 2024-09-19T12:09:15.777Z | 2024-09-19T12:09:15.777Z |
5127086 | 5127086 | 20240916202246_g6ZuL | UK00BL | 2024-09-19T12:08:08.613Z | 2024-09-19T12:08:08.613Z |
5125045 | 5125045 | 20240917234923_b4Xu6 | UK00BL | 2024-09-19T12:02:01.460Z | 2024-09-19T12:06:41.966Z |
5124986 | 5124986 | 20240917231620_u9bFZ | UK00BL | 2024-09-19T12:01:54.553Z | 2024-09-19T12:06:41.959Z |
5124933 | 5124933 | 20240917225248_MAb5G | UK00BL | 2024-09-19T12:01:48.892Z | 2024-09-19T12:06:41.953Z |
5124864 | 5124864 | 20240917222213_yHrjk | UK00BL | 2024-09-19T12:01:41.214Z | 2024-09-19T12:06:41.943Z |
5124792 | 5124792 | 20240917220112_DZ7h4 | UK00BL | 2024-09-19T12:01:35.012Z | 2024-09-19T12:06:41.935Z |
5124764 | 5124764 | 20240917215748_Yi0FR | UK00BL | 2024-09-19T12:01:32.616Z | 2024-09-19T12:06:41.932Z |
5124641 | 5124641 | 20240917213954_J1UwB | UK00BL | 2024-09-19T12:01:14.862Z | 2024-09-19T12:06:41.919Z |
5124637 | 5124637 | 20240917213921_D2aqM | UK00BL | 2024-09-19T12:01:14.480Z | 2024-09-19T12:06:41.919Z |
5124379 | 5124379 | 20240917194406_YeB2s | UK00BL | 2024-09-19T12:00:40.915Z | 2024-09-19T12:06:41.884Z |
5122140 | 5122140 | 20240914043824_gRWOa | UK00BL | 2024-09-18T12:11:07.613Z | 2024-09-19T12:20:02.863Z |
5121711 | 5121711 | 20240914041223_Y2S4F | UK00BL | 2024-09-18T12:10:59.821Z | 2024-09-19T12:20:02.264Z |
5121673 | 5121673 | 20240914041155_QyLxn | UK00BL | 2024-09-18T12:10:59.188Z | 2024-09-19T12:20:02.207Z |
5121642 | 5121642 | 20240914041042_HtKAC | UK00BL | 2024-09-18T12:10:58.923Z | 2024-09-19T12:20:02.186Z |
5120829 | 5120829 | 20240914033552_fwlf5 | UK00BL | 2024-09-18T12:10:47.149Z | 2024-09-19T12:20:00.904Z |
5120634 | 5120634 | 20240914033018_Ulnqj | UK00BL | 2024-09-18T12:10:43.874Z | 2024-09-19T12:20:00.633Z |
5120441 | 5120441 | 20240914032021_0w0mb | UK00BL | 2024-09-18T12:10:39.801Z | 2024-09-19T12:20:00.207Z |
5120344 | 5120344 | 20240914031622_NOzQq | UK00BL | 2024-09-18T12:10:37.819Z | 2024-09-19T12:19:59.955Z |
5120129 | 5120129 | 20240914030045_kaNSo | UK00BL | 2024-09-18T12:10:32.249Z | 2024-09-19T12:19:59.457Z |
5120036 | 5120036 | 20240914025740_w5sTV | UK00BL | 2024-09-18T12:10:31.118Z | 2024-09-19T12:19:59.306Z |
5119992 | 5119992 | 20240914025549_LzwIX | UK00BL | 2024-09-18T12:10:30.708Z | 2024-09-19T12:19:59.252Z |
5119985 | 5119985 | 20240914025549_J0nJG | UK00BL | 2024-09-18T12:10:30.653Z | 2024-09-19T12:19:59.216Z |
5119809 | 5119809 | 20240914025012_cKCvm | UK00BL | 2024-09-18T12:10:27.213Z | 2024-09-19T12:19:58.959Z |
5119686 | 5119686 | 20240914024404_FwclT | UK00BL | 2024-09-18T12:10:24.054Z | 2024-09-19T12:19:58.732Z |
5119639 | 5119639 | 20240914024041_hBkgB | UK00BL | 2024-09-18T12:10:22.791Z | 2024-09-19T12:19:58.602Z |
5119519 | 5119519 | 20240914023649_p2M5o | UK00BL | 2024-09-18T12:10:21.866Z | 2024-09-19T12:19:58.428Z |
5119507 | 5119507 | 20240914023634_WcZAw | UK00BL | 2024-09-18T12:10:21.786Z | 2024-09-19T12:19:58.392Z |
5119487 | 5119487 | 20240914023613_JmUeA | UK00BL | 2024-09-18T12:10:21.620Z | 2024-09-19T12:19:58.335Z |
5119296 | 5119296 | 20240914022153_PDykK | UK00BL | 2024-09-18T12:10:19.550Z | 2024-09-19T12:19:57.632Z |
5119125 | 5119125 | 20240914021212_g33OE | UK00BL | 2024-09-18T12:10:16.408Z | 2024-09-19T12:19:57.196Z |
5117422 | 5117422 | 20240915043152_5Ef2C | UK00BL | 2024-09-18T12:07:41.183Z | 2024-09-19T12:19:15.013Z |
5117127 | 5117127 | 20240915040350_u04rH | UK00BL | 2024-09-18T12:07:33.119Z | 2024-09-19T12:19:13.449Z |
5117004 | 5117004 | 20240915035520_RrWza | UK00BL | 2024-09-18T12:07:28.025Z | 2024-09-19T12:19:12.990Z |
5116965 | 5116965 | 20240915035119_yDVH0 | UK00BL | 2024-09-18T12:07:26.631Z | 2024-09-19T12:19:12.813Z |
5116627 | 5116627 | 20240915033346_gv04B | UK00BL | 2024-09-18T12:07:12.506Z | 2024-09-19T12:19:11.695Z |
5116604 | 5116604 | 20240915033247_BBCVw | UK00BL | 2024-09-18T12:07:11.064Z | 2024-09-19T12:19:11.605Z |
5116411 | 5116411 | 20240915032506_4lBjC | UK00BL | 2024-09-18T12:07:01.120Z | 2024-09-19T12:19:11.089Z |
5116282 | 5116282 | 20240915031959_WrKJe | UK00BL | 2024-09-18T12:06:54.173Z | 2024-09-19T12:19:10.237Z |
5116078 | 5116078 | 20240915030714_6Cyyw | UK00BL | 2024-09-18T12:06:37.765Z | 2024-09-19T12:19:08.416Z |
5115996 | 5115996 | 20240915030242_kxnSo | UK00BL | 2024-09-18T12:06:33.544Z | 2024-09-19T12:19:08.090Z |
5115863 | 5115863 | 20240915025624_ZUmTm | UK00BL | 2024-09-18T12:06:29.365Z | 2024-09-19T12:19:07.574Z |
5115725 | 5115725 | 20240915025047_8SkHQ | UK00BL | 2024-09-18T12:06:22.019Z | 2024-09-19T12:19:06.513Z |
5115657 | 5115657 | 20240915024711_AbFZ5 | UK00BL | 2024-09-18T12:06:20.400Z | 2024-09-19T12:19:06.031Z |
5114776 | 5114776 | 20240915015743_9K7A3 | UK00BL | 2024-09-18T12:05:33.745Z | 2024-09-19T12:18:59.867Z |
5114662 | 5114662 | 20240915015312_gJZU1 | UK00BL | 2024-09-18T12:05:27.636Z | 2024-09-19T12:18:59.191Z |
5114176 | 5114176 | 20240915013005_Ep2rP | UK00BL | 2024-09-18T12:05:05.080Z | 2024-09-19T12:18:56.578Z |
5113745 | 5113745 | 20240915011104_fXah3 | UK00BL | 2024-09-18T12:04:48.698Z | 2024-09-19T12:18:51.810Z |
5113504 | 5113504 | 20240915005320_mrhzA | UK00BL | 2024-09-18T12:04:24.896Z | 2024-09-19T12:18:49.754Z |
5113145 | 5113145 | 20240915002437_TaEq6 | UK00BL | 2024-09-18T12:03:58.261Z | 2024-09-19T12:18:47.421Z |
5112580 | 5112580 | 20240914233020_Bsvf4 | UK00BL | 2024-09-18T12:03:15.244Z | 2024-09-19T12:18:41.498Z |
5112361 | 5112361 | 20240914230410_KjigL | UK00BL | 2024-09-18T12:03:00.974Z | 2024-09-19T12:18:40.686Z |
5112164 | 5112164 | 20240914222722_efnwZ | UK00BL | 2024-09-18T12:02:50.578Z | 2024-09-19T12:18:38.786Z |
5112123 | 5112123 | 20240914221653_IlpIA | UK00BL | 2024-09-18T12:02:48.816Z | 2024-09-19T12:18:38.503Z |
5112042 | 5112042 | 20240914220150_fcwLb | UK00BL | 2024-09-18T12:02:43.205Z | 2024-09-19T12:18:37.122Z |
5111825 | 5111825 | 20240914211815_Ejih7 | UK00BL | 2024-09-18T12:02:18.321Z | 2024-09-19T12:18:34.067Z |
5111794 | 5111794 | 20240914211708_tO7K3 | UK00BL | 2024-09-18T12:02:17.667Z | 2024-09-19T12:18:34.050Z |
5111658 | 5111658 | 20240914205827_EAv50 | UK00BL | 2024-09-18T12:02:09.572Z | 2024-09-19T12:18:32.802Z |
5111641 | 5111641 | 20240914205731_4w1Kg | UK00BL | 2024-09-18T12:02:08.807Z | 2024-09-19T12:18:32.643Z |
5111603 | 5111603 | 20240914205236_oBoDU | UK00BL | 2024-09-18T12:02:05.845Z | 2024-09-19T12:18:31.670Z |
5111515 | 5111515 | 20240914204302_3jFoI | UK00BL | 2024-09-18T12:01:59.983Z | 2024-09-19T12:18:30.852Z |
5111466 | 5111466 | 20240914203952_gx6rh | UK00BL | 2024-09-18T12:01:57.836Z | 2024-09-19T12:18:30.436Z |
5111374 | 5111374 | 20240914202837_OlHm7 | UK00BL | 2024-09-18T12:01:52.739Z | 2024-09-19T12:18:29.612Z |
5111363 | 5111363 | 20240914202836_2MqV3 | UK00BL | 2024-09-18T12:01:52.447Z | 2024-09-19T12:18:29.519Z |
5111251 | 5111251 | 20240914201405_GQTM7 | UK00BL | 2024-09-18T12:01:44.912Z | 2024-09-19T12:18:28.008Z |
5108281 | 5108281 | 20240913043838_875oU | UK00BL | 2024-09-17T12:13:34.587Z | 2024-09-19T12:20:47.991Z |
5107951 | 5107951 | 20240913041517_xTvtL | UK00BL | 2024-09-17T12:13:26.077Z | 2024-09-19T12:20:47.639Z |
5107520 | 5107520 | 20240913035831_fqGqQ | UK00BL | 2024-09-17T12:13:16.408Z | 2024-09-19T12:20:47.195Z |
5107371 | 5107371 | 20240913035328_kCWOY | UK00BL | 2024-09-17T12:13:13.715Z | 2024-09-19T12:20:47.024Z |
5107146 | 5107146 | 20240913034535_Nfjnq | UK00BL | 2024-09-17T12:13:09.977Z | 2024-09-19T12:20:46.862Z |
5107095 | 5107095 | 20240913034428_WQOmY | UK00BL | 2024-09-17T12:13:09.060Z | 2024-09-19T12:20:46.809Z |
5107059 | 5107059 | 20240913034223_r2lZE | UK00BL | 2024-09-17T12:13:08.372Z | 2024-09-19T12:20:46.793Z |
5107035 | 5107035 | 20240913034216_uUJpJ | UK00BL | 2024-09-17T12:13:08.239Z | 2024-09-19T12:20:46.785Z |
5106718 | 5106718 | 20240913033244_xNwMk | UK00BL | 2024-09-17T12:12:59.798Z | 2024-09-19T12:20:46.295Z |
5106371 | 5106371 | 20240913032211_OjKBL | UK00BL | 2024-09-17T12:12:51.185Z | 2024-09-19T12:20:46.006Z |
5106367 | 5106367 | 20240913032113_vvVsw | UK00BL | 2024-09-17T12:12:51.052Z | 2024-09-19T12:20:46.000Z |
5106085 | 5106085 | 20240913031003_YQISS | UK00BL | 2024-09-17T12:12:41.862Z | 2024-09-19T12:20:45.476Z |
5105587 | 5105587 | 20240913025257_tw1aR | UK00BL | 2024-09-17T12:12:22.725Z | 2024-09-19T12:20:44.710Z |
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);