participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,934 rows where station_code = "UK006T" 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 |
---|---|---|---|---|---|
5134039 | 5134039 | 20240916043515_A1XRI | UK006T | 2024-09-19T12:17:16.801Z | 2024-09-19T12:17:16.801Z |
5133769 | 5133769 | 20240916040434_vD9Tv | UK006T | 2024-09-19T12:17:07.426Z | 2024-09-19T12:17:07.426Z |
5133658 | 5133658 | 20240916035000_ySRCK | UK006T | 2024-09-19T12:17:04.958Z | 2024-09-19T12:17:04.958Z |
5133631 | 5133631 | 20240916034910_mp5PQ | UK006T | 2024-09-19T12:17:04.332Z | 2024-09-19T12:17:04.332Z |
5133465 | 5133465 | 20240916033130_5v03X | UK006T | 2024-09-19T12:16:57.404Z | 2024-09-19T12:16:57.404Z |
5133387 | 5133387 | 20240916032749_bSoYG | UK006T | 2024-09-19T12:16:55.901Z | 2024-09-19T12:16:55.901Z |
5133344 | 5133344 | 20240916032404_3sYLS | UK006T | 2024-09-19T12:16:54.543Z | 2024-09-19T12:16:54.543Z |
5133330 | 5133330 | 20240916032335_geFny | UK006T | 2024-09-19T12:16:54.445Z | 2024-09-19T12:16:54.445Z |
5132887 | 5132887 | 20240916022606_DNFFW | UK006T | 2024-09-19T12:16:35.324Z | 2024-09-19T12:16:35.324Z |
5132855 | 5132855 | 20240916022137_rH5c2 | UK006T | 2024-09-19T12:16:34.481Z | 2024-09-19T12:16:34.481Z |
5132570 | 5132570 | 20240916013307_N3s7Z | UK006T | 2024-09-19T12:16:19.370Z | 2024-09-19T12:16:19.370Z |
5132535 | 5132535 | 20240916012618_St0Z6 | UK006T | 2024-09-19T12:16:17.653Z | 2024-09-19T12:16:17.653Z |
5132522 | 5132522 | 20240916012417_VjU0M | UK006T | 2024-09-19T12:16:16.748Z | 2024-09-19T12:16:16.748Z |
5132484 | 5132484 | 20240916011537_8Z6Pz | UK006T | 2024-09-19T12:16:14.669Z | 2024-09-19T12:16:14.669Z |
5132472 | 5132472 | 20240916011528_gDqpw | UK006T | 2024-09-19T12:16:14.091Z | 2024-09-19T12:16:14.091Z |
5132233 | 5132233 | 20240916000934_ad0L4 | UK006T | 2024-09-19T12:16:00.008Z | 2024-09-19T12:16:00.008Z |
5131520 | 5131520 | 20240915200850_koie8 | UK006T | 2024-09-19T12:15:07.407Z | 2024-09-19T12:15:07.407Z |
5129602 | 5129602 | 20240917041305_jXRwF | UK006T | 2024-09-19T12:11:52.792Z | 2024-09-19T12:11:52.792Z |
5129053 | 5129053 | 20240917031209_wrefG | UK006T | 2024-09-19T12:11:12.878Z | 2024-09-19T12:11:12.878Z |
5128673 | 5128673 | 20240917022337_4JaNX | UK006T | 2024-09-19T12:10:55.289Z | 2024-09-19T12:10:55.289Z |
5128500 | 5128500 | 20240917015222_IBDPu | UK006T | 2024-09-19T12:10:39.312Z | 2024-09-19T12:10:39.312Z |
5128460 | 5128460 | 20240917014556_EpX3t | UK006T | 2024-09-19T12:10:36.539Z | 2024-09-19T12:10:36.539Z |
5128337 | 5128337 | 20240917012738_7wLoW | UK006T | 2024-09-19T12:10:27.440Z | 2024-09-19T12:10:27.440Z |
5128287 | 5128287 | 20240917012139_RtkFS | UK006T | 2024-09-19T12:10:25.282Z | 2024-09-19T12:10:25.282Z |
5128284 | 5128284 | 20240917012138_w2DDR | UK006T | 2024-09-19T12:10:24.995Z | 2024-09-19T12:10:24.995Z |
5124770 | 5124770 | 20240917215915_6tDWw | UK006T | 2024-09-19T12:01:33.558Z | 2024-09-19T12:06:41.933Z |
5124523 | 5124523 | 20240917205551_GBozT | UK006T | 2024-09-19T12:01:05.529Z | 2024-09-19T12:06:41.907Z |
5122045 | 5122045 | 20240914042919_kBCVX | UK006T | 2024-09-18T12:11:05.171Z | 2024-09-19T12:20:02.713Z |
5121816 | 5121816 | 20240914041445_8V42i | UK006T | 2024-09-18T12:11:01.619Z | 2024-09-19T12:20:02.386Z |
5121593 | 5121593 | 20240914041015_fnO1f | UK006T | 2024-09-18T12:10:58.727Z | 2024-09-19T12:20:02.160Z |
5121520 | 5121520 | 20240914040750_ae4sy | UK006T | 2024-09-18T12:10:57.908Z | 2024-09-19T12:20:02.082Z |
5119770 | 5119770 | 20240914024845_eXMdp | UK006T | 2024-09-18T12:10:26.757Z | 2024-09-19T12:19:58.939Z |
5114921 | 5114921 | 20240915020738_X45uT | UK006T | 2024-09-18T12:05:42.432Z | 2024-09-19T12:19:00.562Z |
5114305 | 5114305 | 20240915013545_Wv4zf | UK006T | 2024-09-18T12:05:09.792Z | 2024-09-19T12:18:57.460Z |
5113893 | 5113893 | 20240915011750_GE31n | UK006T | 2024-09-18T12:04:54.749Z | 2024-09-19T12:18:54.042Z |
5112301 | 5112301 | 20240914225223_Pdi0R | UK006T | 2024-09-18T12:02:58.951Z | 2024-09-19T12:18:40.427Z |
5107707 | 5107707 | 20240913040843_C1k02 | UK006T | 2024-09-17T12:13:22.109Z | 2024-09-19T12:20:47.477Z |
5107259 | 5107259 | 20240913034944_bhuPa | UK006T | 2024-09-17T12:13:11.937Z | 2024-09-19T12:20:46.967Z |
5106963 | 5106963 | 20240913034042_ZP9nE | UK006T | 2024-09-17T12:13:05.180Z | 2024-09-19T12:20:46.611Z |
5106934 | 5106934 | 20240913033909_P0dHA | UK006T | 2024-09-17T12:13:04.334Z | 2024-09-19T12:20:46.587Z |
5106858 | 5106858 | 20240913033726_7td3P | UK006T | 2024-09-17T12:13:03.267Z | 2024-09-19T12:20:46.495Z |
5106116 | 5106116 | 20240913031146_n7YuO | UK006T | 2024-09-17T12:12:42.511Z | 2024-09-19T12:20:45.502Z |
5105856 | 5105856 | 20240913030048_iMMnC | UK006T | 2024-09-17T12:12:30.829Z | 2024-09-19T12:20:44.988Z |
5104805 | 5104805 | 20240913022144_tZ9CV | UK006T | 2024-09-17T12:11:45.013Z | 2024-09-19T12:20:42.912Z |
5104383 | 5104383 | 20240913020629_YsuPv | UK006T | 2024-09-17T12:11:34.121Z | 2024-09-19T12:20:41.432Z |
5104064 | 5104064 | 20240913015017_dqYNP | UK006T | 2024-09-17T12:11:23.911Z | 2024-09-19T12:20:40.944Z |
5104052 | 5104052 | 20240913015011_H7FwX | UK006T | 2024-09-17T12:11:23.710Z | 2024-09-19T12:20:40.942Z |
5103628 | 5103628 | 20240913013439_UNbp7 | UK006T | 2024-09-17T12:11:06.422Z | 2024-09-19T12:20:40.386Z |
5103277 | 5103277 | 20240913012421_rxmbH | UK006T | 2024-09-17T12:10:49.429Z | 2024-09-19T12:20:39.999Z |
5099804 | 5099804 | 20240913220625_lZj2O | UK006T | 2024-09-17T12:03:35.758Z | 2024-09-19T12:19:45.957Z |
5099622 | 5099622 | 20240913214047_6Jcmp | UK006T | 2024-09-17T12:03:15.038Z | 2024-09-19T12:19:45.497Z |
5099528 | 5099528 | 20240913213113_nAbWf | UK006T | 2024-09-17T12:03:06.644Z | 2024-09-19T12:19:45.226Z |
5099323 | 5099323 | 20240913205922_9oFBJ | UK006T | 2024-09-17T12:02:46.002Z | 2024-09-19T12:19:44.464Z |
5099313 | 5099313 | 20240913205849_FR81V | UK006T | 2024-09-17T12:02:44.803Z | 2024-09-19T12:19:44.456Z |
5097546 | 5097546 | 20240913005322_QMVyB | UK006T | 2024-09-16T12:17:13.363Z | 2024-09-19T12:20:38.713Z |
5097393 | 5097393 | 20240913004503_V9g8l | UK006T | 2024-09-16T12:17:12.043Z | 2024-09-19T12:20:38.467Z |
5097186 | 5097186 | 20240913003527_hiq3W | UK006T | 2024-09-16T12:17:07.449Z | 2024-09-19T12:20:37.840Z |
5090826 | 5090826 | 20240912014735_jUAV5 | UK006T | 2024-09-16T12:12:37.992Z | 2024-09-19T12:21:12.144Z |
5088814 | 5088814 | 20240913002803_D7kPJ | UK006T | 2024-09-16T12:08:31.666Z | 2024-09-19T12:20:37.309Z |
5087590 | 5087590 | 20240912233251_v8XIb | UK006T | 2024-09-16T12:07:05.518Z | 2024-09-19T12:20:35.476Z |
5087116 | 5087116 | 20240912230849_iiMFc | UK006T | 2024-09-16T12:06:40.099Z | 2024-09-19T12:20:34.036Z |
5086468 | 5086468 | 20240912223609_pOUv6 | UK006T | 2024-09-16T12:05:47.303Z | 2024-09-19T12:20:31.296Z |
5085885 | 5085885 | 20240912215642_wviFO | UK006T | 2024-09-16T12:05:01.496Z | 2024-09-19T12:20:29.774Z |
5085511 | 5085511 | 20240912212453_E49uV | UK006T | 2024-09-16T12:04:20.853Z | 2024-09-19T12:20:28.984Z |
5080390 | 5080390 | 20240911035205_htYpC | UK006T | 2024-09-15T12:17:00.846Z | 2024-09-19T12:21:43.222Z |
5079460 | 5079460 | 20240911025659_nxwsk | UK006T | 2024-09-15T12:16:21.472Z | 2024-09-19T12:21:42.283Z |
5078846 | 5078846 | 20240911021655_vM3oG | UK006T | 2024-09-15T12:15:53.139Z | 2024-09-19T12:21:40.738Z |
5078343 | 5078343 | 20240911015105_b0x6U | UK006T | 2024-09-15T12:15:34.476Z | 2024-09-19T12:21:40.294Z |
5078208 | 5078208 | 20240911014312_Y26SO | UK006T | 2024-09-15T12:15:23.645Z | 2024-09-19T12:21:40.058Z |
5078003 | 5078003 | 20240911013442_rm8Vl | UK006T | 2024-09-15T12:15:16.458Z | 2024-09-19T12:21:39.896Z |
5077576 | 5077576 | 20240911010406_dmUok | UK006T | 2024-09-15T12:14:53.066Z | 2024-09-19T12:21:39.388Z |
5077144 | 5077144 | 20240911002609_hNzOa | UK006T | 2024-09-15T12:14:25.088Z | 2024-09-19T12:21:38.283Z |
5077044 | 5077044 | 20240911002232_UOycP | UK006T | 2024-09-15T12:14:19.011Z | 2024-09-19T12:21:37.984Z |
5076314 | 5076314 | 20240910232023_QZp5G | UK006T | 2024-09-15T12:13:27.465Z | 2024-09-19T12:21:36.706Z |
5076182 | 5076182 | 20240910231202_mx5RQ | UK006T | 2024-09-15T12:13:21.807Z | 2024-09-19T12:21:36.575Z |
5075932 | 5075932 | 20240910230054_b7anD | UK006T | 2024-09-15T12:13:12.809Z | 2024-09-19T12:21:36.244Z |
5075212 | 5075212 | 20240911233659_txOQP | UK006T | 2024-09-15T12:09:31.792Z | 2024-09-19T12:21:09.027Z |
5074058 | 5074058 | 20240911220958_pB7RJ | UK006T | 2024-09-15T12:07:52.761Z | 2024-09-19T12:21:06.867Z |
5070096 | 5070096 | 20240910223342_6lxPN | UK006T | 2024-09-14T12:20:14.292Z | 2024-09-19T12:21:35.757Z |
5069695 | 5069695 | 20240910215817_u16Vh | UK006T | 2024-09-14T12:20:04.054Z | 2024-09-19T12:21:35.243Z |
5069557 | 5069557 | 20240910215110_Tv2B8 | UK006T | 2024-09-14T12:19:59.874Z | 2024-09-19T12:21:35.061Z |
5069119 | 5069119 | 20240910211221_cs5xW | UK006T | 2024-09-14T12:19:45.605Z | 2024-09-19T12:21:33.667Z |
5060416 | 5060416 | 20240910202922_iqmqp | UK006T | 2024-09-14T12:08:47.121Z | 2024-09-19T12:21:32.375Z |
5019398 | 5019398 | 20240904224219_6SfxY | UK006T | 2024-09-10T12:12:42.139Z | 2024-09-13T12:19:51.694Z |
5019371 | 5019371 | 20240904223926_TLJQX | UK006T | 2024-09-10T12:12:40.646Z | 2024-09-13T12:19:51.514Z |
5019075 | 5019075 | 20240904214358_lwfFv | UK006T | 2024-09-10T12:12:02.448Z | 2024-09-13T12:19:50.370Z |
5008756 | 5008756 | 20240904001808_TMYiC | UK006T | 2024-09-09T12:07:02.395Z | 2024-09-12T12:19:19.072Z |
5008522 | 5008522 | 20240903235120_cuTVw | UK006T | 2024-09-09T12:06:51.558Z | 2024-09-12T12:19:18.009Z |
5008336 | 5008336 | 20240903233443_xOMdU | UK006T | 2024-09-09T12:06:37.973Z | 2024-09-12T12:19:17.137Z |
5008238 | 5008238 | 20240903232359_JTY3t | UK006T | 2024-09-09T12:06:33.910Z | 2024-09-12T12:19:16.644Z |
5008195 | 5008195 | 20240903231757_ryEo8 | UK006T | 2024-09-09T12:06:31.575Z | 2024-09-12T12:19:16.517Z |
5008054 | 5008054 | 20240903225703_33Ugq | UK006T | 2024-09-09T12:06:20.905Z | 2024-09-12T12:19:15.977Z |
5007855 | 5007855 | 20240903223036_y0NHc | UK006T | 2024-09-09T12:06:09.959Z | 2024-09-12T12:19:15.104Z |
4983457 | 4983457 | 20240812004444_jVIw4 | UK006T | 2024-09-06T12:15:34.028Z | 2024-09-06T12:15:34.028Z |
4983378 | 4983378 | 20240812004351_pzU5I | UK006T | 2024-09-06T12:15:30.450Z | 2024-09-06T12:15:30.450Z |
4982964 | 4982964 | 20240812003939_XV0lu | UK006T | 2024-09-06T12:15:09.541Z | 2024-09-06T12:15:09.541Z |
4982905 | 4982905 | 20240812003915_nh133 | UK006T | 2024-09-06T12:15:07.130Z | 2024-09-06T12:15:07.130Z |
4982426 | 4982426 | 20240812003328_ohrfM | UK006T | 2024-09-06T12:14:50.795Z | 2024-09-06T12:14:50.795Z |
4982396 | 4982396 | 20240812003313_rja08 | UK006T | 2024-09-06T12:14:50.535Z | 2024-09-06T12:14:50.535Z |
4982064 | 4982064 | 20240812002945_lc6jq | UK006T | 2024-09-06T12:14:42.104Z | 2024-09-06T12:14:42.104Z |
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);