participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
268 rows where station_code = "ES001D" 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 |
---|---|---|---|---|---|
5592244 | 5592244 | 20241123024359_FY2j8 | ES001D | 2024-11-24T14:20:49.051Z | 2024-11-26T14:23:42.153Z |
5584532 | 5584532 | 20241123045914_17crc | ES001D | 2024-11-24T14:01:24.776Z | 2024-11-26T14:19:04.500Z |
5582499 | 5582499 | 20241122033901_Jekp2 | ES001D | 2024-11-23T14:21:06.707Z | 2024-11-26T14:25:27.501Z |
5573574 | 5573574 | 20241122042746_m293J | ES001D | 2024-11-23T14:01:00.086Z | 2024-11-26T14:22:06.735Z |
5564749 | 5564749 | 20241120032457_NfQX7 | ES001D | 2024-11-21T14:18:02.032Z | 2024-11-26T14:27:51.358Z |
5563845 | 5563845 | 20241120020957_9la9j | ES001D | 2024-11-21T14:16:49.465Z | 2024-11-26T14:27:46.294Z |
5562993 | 5562993 | 20241120003803_R3FoX | ES001D | 2024-11-21T14:15:30.967Z | 2024-11-26T14:27:42.351Z |
5557278 | 5557278 | 20241120043324_ZJNqC | ES001D | 2024-11-21T14:00:21.399Z | 2024-11-26T14:25:34.318Z |
5538407 | 5538407 | 20241113033404_3GmH0 | ES001D | 2024-11-14T14:13:24.186Z | 2024-11-21T14:26:25.325Z |
5532698 | 5532698 | 20241112055333_UQ0eh | ES001D | 2024-11-13T14:17:10.096Z | 2024-11-20T14:26:25.697Z |
5531997 | 5531997 | 20241112042542_8Fyic | ES001D | 2024-11-13T14:16:07.675Z | 2024-11-20T14:26:16.822Z |
5524678 | 5524678 | 20241111050659_vZsZq | ES001D | 2024-11-12T14:17:53.533Z | 2024-11-19T14:22:23.329Z |
5524532 | 5524532 | 20241111042754_vNJcA | ES001D | 2024-11-12T14:17:36.026Z | 2024-11-19T14:22:22.008Z |
5523997 | 5523997 | 20241111030104_UEYWB | ES001D | 2024-11-12T14:16:24.978Z | 2024-11-19T14:22:16.481Z |
5523818 | 5523818 | 20241111022832_WV9xj | ES001D | 2024-11-12T14:16:15.319Z | 2024-11-19T14:22:15.397Z |
5523476 | 5523476 | 20241111013042_N0b5B | ES001D | 2024-11-12T14:15:44.970Z | 2024-11-19T14:22:12.830Z |
5523305 | 5523305 | 20241111005825_07pYl | ES001D | 2024-11-12T14:15:17.755Z | 2024-11-19T14:22:11.190Z |
5523077 | 5523077 | 20241110235755_RyKeY | ES001D | 2024-11-12T14:14:44.262Z | 2024-11-19T14:22:09.849Z |
5517989 | 5517989 | 20241110053225_tMV2h | ES001D | 2024-11-11T14:15:06.676Z | 2024-11-18T14:26:39.123Z |
5517758 | 5517758 | 20241110044506_sy2A7 | ES001D | 2024-11-11T14:14:50.194Z | 2024-11-18T14:26:38.069Z |
5517303 | 5517303 | 20241110032137_PmatV | ES001D | 2024-11-11T14:14:12.966Z | 2024-11-18T14:26:35.820Z |
5516632 | 5516632 | 20241110013123_fr8wV | ES001D | 2024-11-11T14:13:12.303Z | 2024-11-18T14:26:32.476Z |
5515684 | 5515684 | 20241109222247_mCXFp | ES001D | 2024-11-11T14:11:21.680Z | 2024-11-18T14:26:27.464Z |
5511099 | 5511099 | 20241109042640_zW5og | ES001D | 2024-11-10T14:16:14.648Z | 2024-11-17T14:24:04.583Z |
5510380 | 5510380 | 20241109023110_mSYve | ES001D | 2024-11-10T14:15:07.137Z | 2024-11-17T14:23:56.701Z |
5510166 | 5510166 | 20241109015238_h9t4E | ES001D | 2024-11-10T14:14:41.763Z | 2024-11-17T14:23:53.667Z |
5505074 | 5505074 | 20241108034914_3FcmU | ES001D | 2024-11-09T14:15:41.647Z | 2024-11-16T14:28:26.267Z |
5504923 | 5504923 | 20241108031938_A4UqZ | ES001D | 2024-11-09T14:15:23.947Z | 2024-11-16T14:28:24.959Z |
5504897 | 5504897 | 20241108031430_KqJuS | ES001D | 2024-11-09T14:15:20.861Z | 2024-11-16T14:28:24.461Z |
5504156 | 5504156 | 20241108010717_jx34c | ES001D | 2024-11-09T14:14:09.622Z | 2024-11-16T14:28:16.714Z |
5503924 | 5503924 | 20241108001500_LtUC1 | ES001D | 2024-11-09T14:13:51.731Z | 2024-11-16T14:28:13.818Z |
5470073 | 5470073 | 20241103052217_a6kRc | ES001D | 2024-11-04T14:17:45.101Z | 2024-11-11T14:23:04.074Z |
5470010 | 5470010 | 20241103050843_Zohxd | ES001D | 2024-11-04T14:17:33.941Z | 2024-11-11T14:23:03.487Z |
5468186 | 5468186 | 20241102234723_2qa5Z | ES001D | 2024-11-04T14:13:38.545Z | 2024-11-11T14:22:51.969Z |
5452270 | 5452270 | 20241101024041_RQaB3 | ES001D | 2024-11-02T12:18:33.439Z | 2024-11-09T14:24:29.934Z |
5375789 | 5375789 | 20241024032933_ewRWg | ES001D | 2024-10-26T12:21:39.583Z | 2024-11-01T12:27:01.196Z |
5374484 | 5374484 | 20241024023001_cRrbG | ES001D | 2024-10-26T12:20:50.858Z | 2024-11-01T12:26:59.445Z |
5340800 | 5340800 | 20241022004802_zoP3l | ES001D | 2024-10-23T12:14:54.616Z | 2024-10-30T12:26:46.308Z |
5334712 | 5334712 | 20241021030511_fXKvF | ES001D | 2024-10-22T12:17:19.412Z | 2024-10-29T12:26:35.471Z |
5333815 | 5333815 | 20241021012818_M7BiV | ES001D | 2024-10-22T12:16:07.934Z | 2024-10-29T12:26:34.630Z |
5333789 | 5333789 | 20241021012508_Wu65y | ES001D | 2024-10-22T12:16:06.999Z | 2024-10-29T12:26:34.621Z |
5333761 | 5333761 | 20241021012243_J8bIx | ES001D | 2024-10-22T12:16:02.488Z | 2024-10-29T12:26:34.596Z |
5333143 | 5333143 | 20241020234855_jeNSI | ES001D | 2024-10-22T12:14:46.839Z | 2024-10-29T12:26:34.136Z |
5323327 | 5323327 | 20241019005543_7ahxO | ES001D | 2024-10-20T12:05:47.119Z | 2024-10-27T12:28:50.536Z |
5323303 | 5323303 | 20241019003940_Sy7Dj | ES001D | 2024-10-20T12:05:41.234Z | 2024-10-27T12:28:50.170Z |
5323281 | 5323281 | 20241019001414_egxVd | ES001D | 2024-10-20T12:05:36.274Z | 2024-10-27T12:28:50.142Z |
5302183 | 5302183 | 20241013003810_EKs2Q | ES001D | 2024-10-14T12:15:58.889Z | 2024-10-21T12:24:04.864Z |
5301456 | 5301456 | 20241012232819_kMPCh | ES001D | 2024-10-14T12:15:26.032Z | 2024-10-21T12:23:58.422Z |
5285592 | 5285592 | 20241011040748_nYCcO | ES001D | 2024-10-12T12:18:16.750Z | 2024-10-19T12:28:03.963Z |
5285590 | 5285590 | 20241011040736_WfvLt | ES001D | 2024-10-12T12:18:16.678Z | 2024-10-19T12:28:03.960Z |
5282990 | 5282990 | 20241011002603_qsE1w | ES001D | 2024-10-12T12:16:17.730Z | 2024-10-19T12:27:48.100Z |
5282187 | 5282187 | 20241010202746_D9T8X | ES001D | 2024-10-12T12:15:16.596Z | 2024-10-19T12:27:42.260Z |
5276493 | 5276493 | 20241011044424_8sRd4 | ES001D | 2024-10-12T12:01:15.857Z | 2024-10-20T12:23:10.233Z |
5276045 | 5276045 | 20241011041401_i6BHT | ES001D | 2024-10-12T12:00:17.832Z | 2024-10-20T12:23:04.630Z |
5269343 | 5269343 | 20241010051358_30iTS | ES001D | 2024-10-11T12:01:20.816Z | 2024-10-19T12:26:49.374Z |
5269016 | 5269016 | 20241010035720_ZzgKC | ES001D | 2024-10-11T12:00:13.629Z | 2024-10-19T12:26:45.706Z |
5263111 | 5263111 | 20241008030859_iiPKB | ES001D | 2024-10-09T12:16:39.107Z | 2024-10-16T12:21:21.602Z |
5255619 | 5255619 | 20241008044948_5Iig0 | ES001D | 2024-10-09T12:01:28.066Z | 2024-10-17T12:19:53.140Z |
5245644 | 5245644 | 20241005234111_z54rb | ES001D | 2024-10-07T12:15:49.875Z | 2024-10-14T12:24:35.965Z |
5244879 | 5244879 | 20241005212134_THfyI | ES001D | 2024-10-07T12:15:24.541Z | 2024-10-14T12:24:34.315Z |
5239238 | 5239238 | 20241005034248_e39BD | ES001D | 2024-10-07T12:06:09.514Z | 2024-10-14T12:24:18.799Z |
5238671 | 5238671 | 20241005025054_kwHjn | ES001D | 2024-10-07T12:04:51.237Z | 2024-10-14T12:24:16.907Z |
5236944 | 5236944 | 20240930224403_ilPAR | ES001D | 2024-10-06T12:26:40.137Z | 2024-10-09T12:29:15.769Z |
5236942 | 5236942 | 20240930214439_e9T3L | ES001D | 2024-10-06T12:26:37.346Z | 2024-10-09T12:29:15.328Z |
5236930 | 5236930 | 20240930022929_P4NBv | ES001D | 2024-10-06T12:25:31.764Z | 2024-10-09T12:29:00.612Z |
5236928 | 5236928 | 20241001234816_gzh4A | ES001D | 2024-10-06T12:25:19.113Z | 2024-10-10T12:24:47.785Z |
5236926 | 5236926 | 20241001230911_Bqu29 | ES001D | 2024-10-06T12:25:17.981Z | 2024-10-10T12:24:47.493Z |
5236924 | 5236924 | 20241001185118_zKbRY | ES001D | 2024-10-06T12:25:08.638Z | 2024-10-10T12:24:45.452Z |
5236850 | 5236850 | 20241004010743_1ZXH8 | ES001D | 2024-10-06T12:21:45.050Z | 2024-10-12T12:25:12.573Z |
5236754 | 5236754 | 20241003202325_bjYTC | ES001D | 2024-10-06T12:20:43.416Z | 2024-10-12T12:25:07.973Z |
5236748 | 5236748 | 20241003201445_sPvgS | ES001D | 2024-10-06T12:20:40.606Z | 2024-10-12T12:25:07.713Z |
5236728 | 5236728 | 20241003184415_uRMQY | ES001D | 2024-10-06T12:20:24.834Z | 2024-10-12T12:25:06.281Z |
5236716 | 5236716 | 20241003041821_Cv2hh | ES001D | 2024-10-06T12:18:51.333Z | 2024-10-12T12:24:56.308Z |
5236714 | 5236714 | 20241003041453_l8h2K | ES001D | 2024-10-06T12:18:50.360Z | 2024-10-12T12:24:56.279Z |
5236712 | 5236712 | 20241003035453_Qkvyf | ES001D | 2024-10-06T12:18:44.578Z | 2024-10-12T12:24:55.782Z |
5236706 | 5236706 | 20241003031238_41HPV | ES001D | 2024-10-06T12:18:27.520Z | 2024-10-12T12:24:54.837Z |
5236434 | 5236434 | 20241005005053_WpQh9 | ES001D | 2024-10-06T12:17:33.490Z | 2024-10-13T12:26:25.012Z |
5235360 | 5235360 | 20241004232658_DPfzQ | ES001D | 2024-10-06T12:16:01.533Z | 2024-10-13T12:26:24.181Z |
5228351 | 5228351 | 20241004044907_RCUja | ES001D | 2024-10-06T12:03:03.823Z | 2024-10-13T12:26:09.785Z |
5228237 | 5228237 | 20241004034713_G3B9D | ES001D | 2024-10-06T12:02:14.548Z | 2024-10-13T12:26:08.714Z |
5179150 | 5179150 | 20240928034707_1cPoJ | ES001D | 2024-09-29T12:07:29.992Z | 2024-10-06T12:28:02.494Z |
5179115 | 5179115 | 20240928034410_D3FGv | ES001D | 2024-09-29T12:07:27.320Z | 2024-10-06T12:28:02.394Z |
5166019 | 5166019 | 20240926041426_FI8Ey | ES001D | 2024-09-27T12:01:39.037Z | 2024-10-04T12:25:11.533Z |
5165646 | 5165646 | 20240926012101_KBJUr | ES001D | 2024-09-27T12:00:30.451Z | 2024-10-04T12:25:07.108Z |
5134070 | 5134070 | 20240916044103_ea5lm | ES001D | 2024-09-19T12:17:18.059Z | 2024-09-24T12:15:53.694Z |
5133993 | 5133993 | 20240916042709_XvQC4 | ES001D | 2024-09-19T12:17:15.497Z | 2024-09-24T12:15:53.106Z |
5132048 | 5132048 | 20240915225452_bD978 | ES001D | 2024-09-19T12:15:45.126Z | 2024-09-24T12:15:39.671Z |
5129853 | 5129853 | 20240917044230_IGrIu | ES001D | 2024-09-19T12:12:10.019Z | 2024-09-25T12:22:33.374Z |
5120473 | 5120473 | 20240914032248_6MwNu | ES001D | 2024-09-18T12:10:41.234Z | 2024-09-22T12:17:57.151Z |
5120163 | 5120163 | 20240914030310_Jcl95 | ES001D | 2024-09-18T12:10:33.422Z | 2024-09-22T12:17:56.303Z |
5117189 | 5117189 | 20240915041047_iMjgO | ES001D | 2024-09-18T12:07:34.921Z | 2024-09-23T12:16:24.178Z |
5116433 | 5116433 | 20240915032617_xWpxO | ES001D | 2024-09-18T12:07:02.522Z | 2024-09-23T12:16:21.391Z |
5101292 | 5101292 | 20240914001745_8M9Ih | ES001D | 2024-09-17T12:05:32.266Z | 2024-09-22T12:17:51.129Z |
5100246 | 5100246 | 20240913231010_CH4Pz | ES001D | 2024-09-17T12:04:21.631Z | 2024-09-22T12:17:49.390Z |
5089283 | 5089283 | 20240912003210_bt9hm | ES001D | 2024-09-16T12:11:18.899Z | 2024-09-20T12:21:41.844Z |
5078102 | 5078102 | 20240911013940_uj4UE | ES001D | 2024-09-15T12:15:20.198Z | 2024-09-19T12:21:39.994Z |
5065471 | 5065471 | 20240910041519_4PJtd | ES001D | 2024-09-14T12:17:06.761Z | 2024-09-18T12:15:19.551Z |
5064315 | 5064315 | 20240910004536_iEhvR | ES001D | 2024-09-14T12:15:16.078Z | 2024-09-18T12:15:16.113Z |
5063733 | 5063733 | 20240909222727_zczcw | ES001D | 2024-09-14T12:14:16.932Z | 2024-09-18T12:15:14.458Z |
5047477 | 5047477 | 20240909042424_mt9Be | ES001D | 2024-09-13T12:09:08.438Z | 2024-09-17T12:19:02.789Z |
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);