participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,230 rows where station_code = "ES000H" 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 |
---|---|---|---|---|---|
5135647 | 5135647 | 20240914004219_NtEoq | ES000H | 2024-09-19T12:19:51.230Z | 2024-09-19T12:19:51.230Z |
5134006 | 5134006 | 20240916042956_FumwN | ES000H | 2024-09-19T12:17:15.735Z | 2024-09-19T12:17:15.735Z |
5133892 | 5133892 | 20240916041526_zDne5 | ES000H | 2024-09-19T12:17:12.538Z | 2024-09-19T12:17:12.538Z |
5133879 | 5133879 | 20240916041258_FmJpc | ES000H | 2024-09-19T12:17:11.773Z | 2024-09-19T12:17:11.773Z |
5133853 | 5133853 | 20240916041019_0M3kE | ES000H | 2024-09-19T12:17:10.482Z | 2024-09-19T12:17:10.482Z |
5133727 | 5133727 | 20240916035704_Z91tS | ES000H | 2024-09-19T12:17:06.272Z | 2024-09-19T12:17:06.272Z |
5133673 | 5133673 | 20240916035011_5QGQ3 | ES000H | 2024-09-19T12:17:05.073Z | 2024-09-19T12:17:05.073Z |
5133516 | 5133516 | 20240916033616_WC9bt | ES000H | 2024-09-19T12:17:00.366Z | 2024-09-19T12:17:00.366Z |
5133347 | 5133347 | 20240916032448_H8NU7 | ES000H | 2024-09-19T12:16:54.705Z | 2024-09-19T12:16:54.705Z |
5133307 | 5133307 | 20240916032035_HxaWq | ES000H | 2024-09-19T12:16:53.881Z | 2024-09-19T12:16:53.881Z |
5133234 | 5133234 | 20240916031130_6Ckxh | ES000H | 2024-09-19T12:16:51.064Z | 2024-09-19T12:16:51.064Z |
5133230 | 5133230 | 20240916031035_XIc1j | ES000H | 2024-09-19T12:16:50.554Z | 2024-09-19T12:16:50.554Z |
5133047 | 5133047 | 20240916024800_ZyJb2 | ES000H | 2024-09-19T12:16:42.531Z | 2024-09-19T12:16:42.531Z |
5131446 | 5131446 | 20240915195615_iBf53 | ES000H | 2024-09-19T12:15:04.041Z | 2024-09-19T12:15:04.041Z |
5121867 | 5121867 | 20240914041747_txPHp | ES000H | 2024-09-18T12:11:02.390Z | 2024-09-19T12:20:02.450Z |
5121858 | 5121858 | 20240914041722_M932h | ES000H | 2024-09-18T12:11:02.317Z | 2024-09-19T12:20:02.442Z |
5121775 | 5121775 | 20240914041359_aVaNw | ES000H | 2024-09-18T12:11:01.269Z | 2024-09-19T12:20:02.367Z |
5121719 | 5121719 | 20240914041228_3cCmI | ES000H | 2024-09-18T12:11:00.298Z | 2024-09-19T12:20:02.269Z |
5121700 | 5121700 | 20240914041222_obvdM | ES000H | 2024-09-18T12:10:59.681Z | 2024-09-19T12:20:02.240Z |
5121652 | 5121652 | 20240914041046_H7DAR | ES000H | 2024-09-18T12:10:59.106Z | 2024-09-19T12:20:02.206Z |
5121472 | 5121472 | 20240914040426_I1VGz | ES000H | 2024-09-18T12:10:56.925Z | 2024-09-19T12:20:01.908Z |
5121443 | 5121443 | 20240914040239_M2bxJ | ES000H | 2024-09-18T12:10:55.549Z | 2024-09-19T12:20:01.857Z |
5121131 | 5121131 | 20240914035334_7vL26 | ES000H | 2024-09-18T12:10:51.426Z | 2024-09-19T12:20:01.415Z |
5121072 | 5121072 | 20240914035112_pCzvq | ES000H | 2024-09-18T12:10:50.445Z | 2024-09-19T12:20:01.284Z |
5120866 | 5120866 | 20240914033857_Xndsn | ES000H | 2024-09-18T12:10:48.201Z | 2024-09-19T12:20:00.978Z |
5120839 | 5120839 | 20240914033723_qLlkL | ES000H | 2024-09-18T12:10:47.575Z | 2024-09-19T12:20:00.926Z |
5120652 | 5120652 | 20240914033051_jGvnZ | ES000H | 2024-09-18T12:10:44.231Z | 2024-09-19T12:20:00.672Z |
5120478 | 5120478 | 20240914032329_bUtve | ES000H | 2024-09-18T12:10:41.484Z | 2024-09-19T12:20:00.488Z |
5119993 | 5119993 | 20240914025553_WI4HT | ES000H | 2024-09-18T12:10:30.916Z | 2024-09-19T12:19:59.296Z |
5119860 | 5119860 | 20240914025121_DN3pM | ES000H | 2024-09-18T12:10:28.256Z | 2024-09-19T12:19:59.029Z |
5119452 | 5119452 | 20240914023510_BA16A | ES000H | 2024-09-18T12:10:21.466Z | 2024-09-19T12:19:58.274Z |
5119429 | 5119429 | 20240914023258_bNw2l | ES000H | 2024-09-18T12:10:21.215Z | 2024-09-19T12:19:58.237Z |
5119146 | 5119146 | 20240914021342_MVDBZ | ES000H | 2024-09-18T12:10:16.652Z | 2024-09-19T12:19:57.240Z |
5119054 | 5119054 | 20240914020659_pD930 | ES000H | 2024-09-18T12:10:15.442Z | 2024-09-19T12:19:56.995Z |
5117098 | 5117098 | 20240915040230_9Vd6Z | ES000H | 2024-09-18T12:07:32.667Z | 2024-09-19T12:19:13.325Z |
5116877 | 5116877 | 20240915034541_uwNSY | ES000H | 2024-09-18T12:07:24.126Z | 2024-09-19T12:19:12.514Z |
5116431 | 5116431 | 20240915032601_EvqGe | ES000H | 2024-09-18T12:07:02.321Z | 2024-09-19T12:19:11.121Z |
5116058 | 5116058 | 20240915030520_BghRp | ES000H | 2024-09-18T12:06:35.687Z | 2024-09-19T12:19:08.319Z |
5115758 | 5115758 | 20240915025304_O3nVg | ES000H | 2024-09-18T12:06:23.146Z | 2024-09-19T12:19:06.778Z |
5115754 | 5115754 | 20240915025213_4NbTm | ES000H | 2024-09-18T12:06:23.005Z | 2024-09-19T12:19:06.768Z |
5115630 | 5115630 | 20240915024646_aOYWw | ES000H | 2024-09-18T12:06:19.765Z | 2024-09-19T12:19:05.841Z |
5115439 | 5115439 | 20240915023829_MqzOW | ES000H | 2024-09-18T12:06:14.366Z | 2024-09-19T12:19:04.746Z |
5115116 | 5115116 | 20240915022046_oooC8 | ES000H | 2024-09-18T12:06:00.610Z | 2024-09-19T12:19:01.659Z |
5115047 | 5115047 | 20240915021601_RsBR2 | ES000H | 2024-09-18T12:05:53.796Z | 2024-09-19T12:19:01.236Z |
5114948 | 5114948 | 20240915020928_gJ2y4 | ES000H | 2024-09-18T12:05:45.498Z | 2024-09-19T12:19:00.727Z |
5114857 | 5114857 | 20240915020142_JLxgj | ES000H | 2024-09-18T12:05:38.059Z | 2024-09-19T12:19:00.298Z |
5114364 | 5114364 | 20240915013924_3nyDT | ES000H | 2024-09-18T12:05:13.530Z | 2024-09-19T12:18:57.827Z |
5114238 | 5114238 | 20240915013334_Reifx | ES000H | 2024-09-18T12:05:08.503Z | 2024-09-19T12:18:57.226Z |
5114183 | 5114183 | 20240915013019_vO5BS | ES000H | 2024-09-18T12:05:05.502Z | 2024-09-19T12:18:56.643Z |
5113538 | 5113538 | 20240915005645_9B7oY | ES000H | 2024-09-18T12:04:26.900Z | 2024-09-19T12:18:50.079Z |
5108159 | 5108159 | 20240913042846_ydrz1 | ES000H | 2024-09-17T12:13:31.817Z | 2024-09-19T12:20:47.894Z |
5107996 | 5107996 | 20240913041825_Dtvff | ES000H | 2024-09-17T12:13:27.419Z | 2024-09-19T12:20:47.735Z |
5107994 | 5107994 | 20240913041818_y5fTz | ES000H | 2024-09-17T12:13:27.322Z | 2024-09-19T12:20:47.721Z |
5107973 | 5107973 | 20240913041711_FOJi8 | ES000H | 2024-09-17T12:13:26.379Z | 2024-09-19T12:20:47.664Z |
5107715 | 5107715 | 20240913040853_DXvTc | ES000H | 2024-09-17T12:13:22.222Z | 2024-09-19T12:20:47.484Z |
5107689 | 5107689 | 20240913040820_b3BVG | ES000H | 2024-09-17T12:13:21.598Z | 2024-09-19T12:20:47.455Z |
5107687 | 5107687 | 20240913040808_B32D3 | ES000H | 2024-09-17T12:13:21.421Z | 2024-09-19T12:20:47.453Z |
5107472 | 5107472 | 20240913035747_osjQQ | ES000H | 2024-09-17T12:13:16.003Z | 2024-09-19T12:20:47.181Z |
5106847 | 5106847 | 20240913033721_TG6lE | ES000H | 2024-09-17T12:13:03.139Z | 2024-09-19T12:20:46.494Z |
5106373 | 5106373 | 20240913032218_bNm1A | ES000H | 2024-09-17T12:12:51.413Z | 2024-09-19T12:20:46.008Z |
5105790 | 5105790 | 20240913025841_nHxS3 | ES000H | 2024-09-17T12:12:29.168Z | 2024-09-19T12:20:44.923Z |
5105105 | 5105105 | 20240913023046_k7cdz | ES000H | 2024-09-17T12:11:55.414Z | 2024-09-19T12:20:43.673Z |
5104151 | 5104151 | 20240913015552_xbGqJ | ES000H | 2024-09-17T12:11:27.454Z | 2024-09-19T12:20:41.153Z |
5103794 | 5103794 | 20240913014010_9sPSw | ES000H | 2024-09-17T12:11:10.751Z | 2024-09-19T12:20:40.564Z |
5103719 | 5103719 | 20240913013712_2GznK | ES000H | 2024-09-17T12:11:08.919Z | 2024-09-19T12:20:40.434Z |
5103164 | 5103164 | 20240914020252_0HhWl | ES000H | 2024-09-17T12:07:54.477Z | 2024-09-19T12:19:56.706Z |
5102932 | 5102932 | 20240914015509_19C6N | ES000H | 2024-09-17T12:07:44.484Z | 2024-09-19T12:19:56.168Z |
5102797 | 5102797 | 20240914014450_SQFK3 | ES000H | 2024-09-17T12:07:36.813Z | 2024-09-19T12:19:55.706Z |
5102701 | 5102701 | 20240914013845_4bmbZ | ES000H | 2024-09-17T12:07:31.984Z | 2024-09-19T12:19:55.416Z |
5102345 | 5102345 | 20240914012114_MwCka | ES000H | 2024-09-17T12:07:03.580Z | 2024-09-19T12:19:53.857Z |
5102312 | 5102312 | 20240914011907_yhbAh | ES000H | 2024-09-17T12:07:00.185Z | 2024-09-19T12:19:53.408Z |
5102261 | 5102261 | 20240914011315_71MhS | ES000H | 2024-09-17T12:06:56.298Z | 2024-09-19T12:19:53.120Z |
5101837 | 5101837 | 20240914004935_jfqRh | ES000H | 2024-09-17T12:06:16.299Z | 2024-09-19T12:19:51.628Z |
5101674 | 5101674 | 20240914004218_ulVvV | ES000H | 2024-09-17T12:06:08.232Z | 2024-09-19T12:19:51.224Z |
5101554 | 5101554 | 20240914003441_Ybq5R | ES000H | 2024-09-17T12:06:01.092Z | 2024-09-19T12:19:50.925Z |
5101044 | 5101044 | 20240913235832_49enY | ES000H | 2024-09-17T12:05:16.072Z | 2024-09-19T12:19:49.568Z |
5100624 | 5100624 | 20240913233611_05Qfe | ES000H | 2024-09-17T12:04:45.156Z | 2024-09-19T12:19:48.247Z |
5099950 | 5099950 | 20240913222600_aGT1c | ES000H | 2024-09-17T12:03:45.370Z | 2024-09-19T12:19:46.581Z |
5098876 | 5098876 | 20240913195222_FYhEc | ES000H | 2024-09-17T12:01:54.734Z | 2024-09-19T12:19:41.761Z |
5097904 | 5097904 | 20240913010904_2yAKg | ES000H | 2024-09-16T12:17:16.821Z | 2024-09-19T12:20:39.186Z |
5097311 | 5097311 | 20240913004020_HFk8E | ES000H | 2024-09-16T12:17:09.597Z | 2024-09-19T12:20:38.069Z |
5088629 | 5088629 | 20240913002003_0Hdob | ES000H | 2024-09-16T12:08:17.862Z | 2024-09-19T12:20:37.096Z |
5088372 | 5088372 | 20240913000826_LJ1MR | ES000H | 2024-09-16T12:07:56.812Z | 2024-09-19T12:20:36.726Z |
5088241 | 5088241 | 20240913000232_dx3vs | ES000H | 2024-09-16T12:07:49.664Z | 2024-09-19T12:20:36.542Z |
5088041 | 5088041 | 20240912235413_tkbpR | ES000H | 2024-09-16T12:07:41.829Z | 2024-09-19T12:20:36.199Z |
5087679 | 5087679 | 20240912233930_gaIFF | ES000H | 2024-09-16T12:07:13.540Z | 2024-09-19T12:20:35.554Z |
5086396 | 5086396 | 20240912223213_L6s7i | ES000H | 2024-09-16T12:05:39.926Z | 2024-09-19T12:20:31.042Z |
4983414 | 4983414 | 20240812004416_vGKab | ES000H | 2024-09-06T12:15:31.758Z | 2024-09-06T12:15:31.758Z |
4983018 | 4983018 | 20240812004032_C6yFe | ES000H | 2024-09-06T12:15:11.809Z | 2024-09-06T12:15:11.809Z |
4982927 | 4982927 | 20240812003925_DEcF3 | ES000H | 2024-09-06T12:15:08.221Z | 2024-09-06T12:15:08.221Z |
4982793 | 4982793 | 20240812003744_0EW1z | ES000H | 2024-09-06T12:15:02.912Z | 2024-09-06T12:15:02.912Z |
4982717 | 4982717 | 20240812003628_va7NN | ES000H | 2024-09-06T12:14:59.309Z | 2024-09-06T12:14:59.309Z |
4982467 | 4982467 | 20240812003346_2cJiF | ES000H | 2024-09-06T12:14:52.622Z | 2024-09-06T12:14:52.622Z |
4980972 | 4980972 | 20240812001759_DXKBp | ES000H | 2024-09-06T12:14:25.216Z | 2024-09-06T12:14:25.216Z |
4980215 | 4980215 | 20240812001008_lxFnQ | ES000H | 2024-09-06T12:13:53.231Z | 2024-09-06T12:13:53.231Z |
4980057 | 4980057 | 20240812000758_vjYpI | ES000H | 2024-09-06T12:13:45.468Z | 2024-09-06T12:13:45.468Z |
4979372 | 4979372 | 20240812000133_S7qc8 | ES000H | 2024-09-06T12:13:12.474Z | 2024-09-06T12:13:12.474Z |
4979088 | 4979088 | 20240811235920_qkpwE | ES000H | 2024-09-06T12:12:57.034Z | 2024-09-06T12:12:57.034Z |
4978675 | 4978675 | 20240811235331_sb31J | ES000H | 2024-09-06T12:12:40.646Z | 2024-09-06T12:12:40.646Z |
4978634 | 4978634 | 20240811235311_37JbL | ES000H | 2024-09-06T12:12:38.077Z | 2024-09-06T12:12:38.077Z |
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);