participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,742 rows where station_code = "UK005H" 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 |
---|---|---|---|---|---|
5133761 | 5133761 | 20240916040327_IbtOL | UK005H | 2024-09-19T12:17:07.293Z | 2024-09-19T12:17:07.293Z |
5133689 | 5133689 | 20240916035051_298Kt | UK005H | 2024-09-19T12:17:05.257Z | 2024-09-19T12:17:05.257Z |
5133656 | 5133656 | 20240916035000_ySRCK | UK005H | 2024-09-19T12:17:04.958Z | 2024-09-19T12:17:04.958Z |
5133638 | 5133638 | 20240916034914_CZQGb | UK005H | 2024-09-19T12:17:04.554Z | 2024-09-19T12:17:04.554Z |
5133630 | 5133630 | 20240916034910_mp5PQ | UK005H | 2024-09-19T12:17:04.332Z | 2024-09-19T12:17:04.332Z |
5133448 | 5133448 | 20240916033110_5jGcn | UK005H | 2024-09-19T12:16:56.814Z | 2024-09-19T12:16:56.814Z |
5133426 | 5133426 | 20240916032951_wW9CU | UK005H | 2024-09-19T12:16:56.299Z | 2024-09-19T12:16:56.299Z |
5133408 | 5133408 | 20240916032800_zKDzl | UK005H | 2024-09-19T12:16:56.197Z | 2024-09-19T12:16:56.197Z |
5133384 | 5133384 | 20240916032749_bSoYG | UK005H | 2024-09-19T12:16:55.901Z | 2024-09-19T12:16:55.901Z |
5133343 | 5133343 | 20240916032404_3sYLS | UK005H | 2024-09-19T12:16:54.543Z | 2024-09-19T12:16:54.543Z |
5133328 | 5133328 | 20240916032335_geFny | UK005H | 2024-09-19T12:16:54.445Z | 2024-09-19T12:16:54.445Z |
5133159 | 5133159 | 20240916030303_7KrY0 | UK005H | 2024-09-19T12:16:45.953Z | 2024-09-19T12:16:45.953Z |
5132808 | 5132808 | 20240916021515_8gZYt | UK005H | 2024-09-19T12:16:33.366Z | 2024-09-19T12:16:33.366Z |
5132668 | 5132668 | 20240916015145_9afZI | UK005H | 2024-09-19T12:16:25.856Z | 2024-09-19T12:16:25.856Z |
5132543 | 5132543 | 20240916012624_l27ZM | UK005H | 2024-09-19T12:16:17.830Z | 2024-09-19T12:16:17.830Z |
5132533 | 5132533 | 20240916012618_St0Z6 | UK005H | 2024-09-19T12:16:17.653Z | 2024-09-19T12:16:17.653Z |
5132482 | 5132482 | 20240916011537_8Z6Pz | UK005H | 2024-09-19T12:16:14.669Z | 2024-09-19T12:16:14.669Z |
5132308 | 5132308 | 20240916003156_lj24Q | UK005H | 2024-09-19T12:16:05.110Z | 2024-09-19T12:16:05.110Z |
5132232 | 5132232 | 20240916000934_ad0L4 | UK005H | 2024-09-19T12:16:00.008Z | 2024-09-19T12:16:00.008Z |
5132216 | 5132216 | 20240916000305_wezP8 | UK005H | 2024-09-19T12:15:59.074Z | 2024-09-19T12:15:59.074Z |
5131953 | 5131953 | 20240915222340_a3ikz | UK005H | 2024-09-19T12:15:37.375Z | 2024-09-19T12:15:37.375Z |
5131878 | 5131878 | 20240915220029_xDUD3 | UK005H | 2024-09-19T12:15:32.238Z | 2024-09-19T12:15:32.238Z |
5129616 | 5129616 | 20240917041350_8Ytfi | UK005H | 2024-09-19T12:11:54.024Z | 2024-09-19T12:11:54.024Z |
5128336 | 5128336 | 20240917012738_7wLoW | UK005H | 2024-09-19T12:10:27.440Z | 2024-09-19T12:10:27.440Z |
5128008 | 5128008 | 20240917002016_VD3L1 | UK005H | 2024-09-19T12:09:54.376Z | 2024-09-19T12:09:54.376Z |
5127781 | 5127781 | 20240916232731_VaeRR | UK005H | 2024-09-19T12:09:37.933Z | 2024-09-19T12:09:37.933Z |
5127747 | 5127747 | 20240916231742_DoQH3 | UK005H | 2024-09-19T12:09:35.762Z | 2024-09-19T12:09:35.762Z |
5127491 | 5127491 | 20240916221156_Vi4D9 | UK005H | 2024-09-19T12:09:15.436Z | 2024-09-19T12:09:15.436Z |
5127483 | 5127483 | 20240916221109_8S1uG | UK005H | 2024-09-19T12:09:14.987Z | 2024-09-19T12:09:14.987Z |
5127440 | 5127440 | 20240916215228_fyYNu | UK005H | 2024-09-19T12:09:07.598Z | 2024-09-19T12:09:07.598Z |
5126991 | 5126991 | 20240916200351_LJ4N3 | UK005H | 2024-09-19T12:07:50.490Z | 2024-09-19T12:07:50.490Z |
5126962 | 5126962 | 20240916200134_DfSMC | UK005H | 2024-09-19T12:07:48.716Z | 2024-09-19T12:07:48.716Z |
5122043 | 5122043 | 20240914042919_kBCVX | UK005H | 2024-09-18T12:11:05.171Z | 2024-09-19T12:20:02.713Z |
5121814 | 5121814 | 20240914041445_8V42i | UK005H | 2024-09-18T12:11:01.619Z | 2024-09-19T12:20:02.386Z |
5121592 | 5121592 | 20240914041015_fnO1f | UK005H | 2024-09-18T12:10:58.727Z | 2024-09-19T12:20:02.160Z |
5121526 | 5121526 | 20240914040751_ERo2K | UK005H | 2024-09-18T12:10:57.976Z | 2024-09-19T12:20:02.083Z |
5121519 | 5121519 | 20240914040750_ae4sy | UK005H | 2024-09-18T12:10:57.908Z | 2024-09-19T12:20:02.082Z |
5121096 | 5121096 | 20240914035213_HxWrG | UK005H | 2024-09-18T12:10:51.080Z | 2024-09-19T12:20:01.335Z |
5120524 | 5120524 | 20240914032631_UikgF | UK005H | 2024-09-18T12:10:42.874Z | 2024-09-19T12:20:00.561Z |
5120401 | 5120401 | 20240914031928_Z7jJ3 | UK005H | 2024-09-18T12:10:39.180Z | 2024-09-19T12:20:00.089Z |
5120346 | 5120346 | 20240914031645_ly1cL | UK005H | 2024-09-18T12:10:37.882Z | 2024-09-19T12:19:59.957Z |
5119769 | 5119769 | 20240914024845_eXMdp | UK005H | 2024-09-18T12:10:26.757Z | 2024-09-19T12:19:58.938Z |
5119510 | 5119510 | 20240914023649_c77Dl | UK005H | 2024-09-18T12:10:21.809Z | 2024-09-19T12:19:58.397Z |
5117284 | 5117284 | 20240915041627_a3TeT | UK005H | 2024-09-18T12:07:37.092Z | 2024-09-19T12:19:14.144Z |
5117141 | 5117141 | 20240915040529_G0aVg | UK005H | 2024-09-18T12:07:33.663Z | 2024-09-19T12:19:13.545Z |
5116772 | 5116772 | 20240915034120_vq4jI | UK005H | 2024-09-18T12:07:20.556Z | 2024-09-19T12:19:12.340Z |
5116619 | 5116619 | 20240915033346_gv04B | UK005H | 2024-09-18T12:07:12.505Z | 2024-09-19T12:19:11.695Z |
5116246 | 5116246 | 20240915031733_AnGNx | UK005H | 2024-09-18T12:06:50.909Z | 2024-09-19T12:19:09.969Z |
5116155 | 5116155 | 20240915031223_s9K6J | UK005H | 2024-09-18T12:06:44.370Z | 2024-09-19T12:19:09.025Z |
5115923 | 5115923 | 20240915025921_Xj6EX | UK005H | 2024-09-18T12:06:31.911Z | 2024-09-19T12:19:07.870Z |
5115752 | 5115752 | 20240915025136_KNTj4 | UK005H | 2024-09-18T12:06:22.765Z | 2024-09-19T12:19:06.744Z |
5115541 | 5115541 | 20240915024428_CUS2m | UK005H | 2024-09-18T12:06:17.728Z | 2024-09-19T12:19:05.352Z |
5115290 | 5115290 | 20240915023113_oy2q4 | UK005H | 2024-09-18T12:06:10.087Z | 2024-09-19T12:19:03.776Z |
5115218 | 5115218 | 20240915022746_zQh1s | UK005H | 2024-09-18T12:06:06.992Z | 2024-09-19T12:19:03.115Z |
5115198 | 5115198 | 20240915022642_3UIH3 | UK005H | 2024-09-18T12:06:06.026Z | 2024-09-19T12:19:02.965Z |
5114920 | 5114920 | 20240915020738_X45uT | UK005H | 2024-09-18T12:05:42.432Z | 2024-09-19T12:19:00.562Z |
5114420 | 5114420 | 20240915014110_JrNif | UK005H | 2024-09-18T12:05:14.433Z | 2024-09-19T12:18:57.943Z |
5114327 | 5114327 | 20240915013642_J2rXY | UK005H | 2024-09-18T12:05:10.763Z | 2024-09-19T12:18:57.541Z |
5114304 | 5114304 | 20240915013545_Wv4zf | UK005H | 2024-09-18T12:05:09.792Z | 2024-09-19T12:18:57.460Z |
5113891 | 5113891 | 20240915011750_GE31n | UK005H | 2024-09-18T12:04:54.749Z | 2024-09-19T12:18:54.042Z |
5113593 | 5113593 | 20240915010038_yynXa | UK005H | 2024-09-18T12:04:34.570Z | 2024-09-19T12:18:50.527Z |
5112873 | 5112873 | 20240915000328_gXDS2 | UK005H | 2024-09-18T12:03:44.791Z | 2024-09-19T12:18:45.487Z |
5112871 | 5112871 | 20240915000243_Te3L2 | UK005H | 2024-09-18T12:03:44.548Z | 2024-09-19T12:18:45.463Z |
5112684 | 5112684 | 20240914234145_AWkK2 | UK005H | 2024-09-18T12:03:21.786Z | 2024-09-19T12:18:43.005Z |
5112608 | 5112608 | 20240914233444_D7QiL | UK005H | 2024-09-18T12:03:16.629Z | 2024-09-19T12:18:41.631Z |
5111892 | 5111892 | 20240914213134_Iov9u | UK005H | 2024-09-18T12:02:28.898Z | 2024-09-19T12:18:34.928Z |
5111564 | 5111564 | 20240914204925_jNPIh | UK005H | 2024-09-18T12:02:03.714Z | 2024-09-19T12:18:31.430Z |
5111367 | 5111367 | 20240914202837_OlHm7 | UK005H | 2024-09-18T12:01:52.739Z | 2024-09-19T12:18:29.612Z |
5111189 | 5111189 | 20240914201007_8Xvja | UK005H | 2024-09-18T12:01:42.469Z | 2024-09-19T12:18:27.298Z |
5111174 | 5111174 | 20240914200837_zjWMY | UK005H | 2024-09-18T12:01:41.650Z | 2024-09-19T12:18:27.193Z |
5110977 | 5110977 | 20240914193728_DJtmL | UK005H | 2024-09-18T12:01:17.374Z | 2024-09-19T12:18:25.203Z |
5110416 | 5110416 | 20240910224240_Q1l5m | UK005H | 2024-09-17T12:17:51.503Z | 2024-09-19T12:21:35.911Z |
5106962 | 5106962 | 20240913034042_ZP9nE | UK005H | 2024-09-17T12:13:05.180Z | 2024-09-19T12:20:46.611Z |
5106931 | 5106931 | 20240913033909_P0dHA | UK005H | 2024-09-17T12:13:04.334Z | 2024-09-19T12:20:46.587Z |
5106856 | 5106856 | 20240913033726_7td3P | UK005H | 2024-09-17T12:13:03.267Z | 2024-09-19T12:20:46.495Z |
5106299 | 5106299 | 20240913031736_J3lbC | UK005H | 2024-09-17T12:12:48.675Z | 2024-09-19T12:20:45.758Z |
5106287 | 5106287 | 20240913031718_3P6Q2 | UK005H | 2024-09-17T12:12:48.214Z | 2024-09-19T12:20:45.751Z |
5105853 | 5105853 | 20240913030048_iMMnC | UK005H | 2024-09-17T12:12:30.829Z | 2024-09-19T12:20:44.988Z |
5105825 | 5105825 | 20240913025956_HUrEo | UK005H | 2024-09-17T12:12:30.226Z | 2024-09-19T12:20:44.972Z |
5105430 | 5105430 | 20240913024559_yx8NE | UK005H | 2024-09-17T12:12:16.529Z | 2024-09-19T12:20:44.486Z |
5105047 | 5105047 | 20240913022812_VdYf6 | UK005H | 2024-09-17T12:11:50.822Z | 2024-09-19T12:20:43.436Z |
5104961 | 5104961 | 20240913022500_v6miM | UK005H | 2024-09-17T12:11:47.657Z | 2024-09-19T12:20:43.142Z |
5104865 | 5104865 | 20240913022207_0Ph2X | UK005H | 2024-09-17T12:11:45.646Z | 2024-09-19T12:20:43.071Z |
5104816 | 5104816 | 20240913022148_1xM2P | UK005H | 2024-09-17T12:11:45.169Z | 2024-09-19T12:20:42.918Z |
5104803 | 5104803 | 20240913022144_tZ9CV | UK005H | 2024-09-17T12:11:45.013Z | 2024-09-19T12:20:42.912Z |
5104382 | 5104382 | 20240913020629_YsuPv | UK005H | 2024-09-17T12:11:34.121Z | 2024-09-19T12:20:41.432Z |
5104063 | 5104063 | 20240913015017_dqYNP | UK005H | 2024-09-17T12:11:23.911Z | 2024-09-19T12:20:40.944Z |
5103626 | 5103626 | 20240913013439_UNbp7 | UK005H | 2024-09-17T12:11:06.422Z | 2024-09-19T12:20:40.385Z |
5103348 | 5103348 | 20240913012858_STgh9 | UK005H | 2024-09-17T12:10:54.749Z | 2024-09-19T12:20:40.095Z |
5103275 | 5103275 | 20240913012421_rxmbH | UK005H | 2024-09-17T12:10:49.429Z | 2024-09-19T12:20:39.999Z |
5102275 | 5102275 | 20240914011508_5KWPl | UK005H | 2024-09-17T12:06:57.493Z | 2024-09-19T12:19:53.183Z |
5100861 | 5100861 | 20240913234912_GMPq2 | UK005H | 2024-09-17T12:05:04.368Z | 2024-09-19T12:19:48.875Z |
5100713 | 5100713 | 20240913234332_0bTfc | UK005H | 2024-09-17T12:04:49.656Z | 2024-09-19T12:19:48.598Z |
5100703 | 5100703 | 20240913234143_eJhd3 | UK005H | 2024-09-17T12:04:49.381Z | 2024-09-19T12:19:48.576Z |
5099790 | 5099790 | 20240913220121_ykBpG | UK005H | 2024-09-17T12:03:35.035Z | 2024-09-19T12:19:45.922Z |
5099321 | 5099321 | 20240913205922_9oFBJ | UK005H | 2024-09-17T12:02:46.001Z | 2024-09-19T12:19:44.464Z |
5099275 | 5099275 | 20240913205059_IN0GT | UK005H | 2024-09-17T12:02:39.456Z | 2024-09-19T12:19:44.371Z |
5098900 | 5098900 | 20240913195314_tqsCh | UK005H | 2024-09-17T12:01:57.506Z | 2024-09-19T12:19:42.536Z |
5098869 | 5098869 | 20240913195156_xQFPG | UK005H | 2024-09-17T12:01:53.474Z | 2024-09-19T12:19:41.756Z |
5098062 | 5098062 | 20240913011525_idCZ7 | UK005H | 2024-09-16T12:17:19.217Z | 2024-09-19T12:20:39.592Z |
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);