participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
13,874 rows where station_code = "ES000F" 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 |
---|---|---|---|---|---|
5135646 | 5135646 | 20240914004219_NtEoq | ES000F | 2024-09-19T12:19:51.230Z | 2024-09-19T12:19:51.230Z |
5134069 | 5134069 | 20240916044103_ea5lm | ES000F | 2024-09-19T12:17:18.059Z | 2024-09-19T12:17:18.059Z |
5134015 | 5134015 | 20240916043130_s4zok | ES000F | 2024-09-19T12:17:16.045Z | 2024-09-19T12:17:16.045Z |
5134005 | 5134005 | 20240916042956_FumwN | ES000F | 2024-09-19T12:17:15.735Z | 2024-09-19T12:17:15.735Z |
5133992 | 5133992 | 20240916042709_XvQC4 | ES000F | 2024-09-19T12:17:15.497Z | 2024-09-19T12:17:15.497Z |
5133971 | 5133971 | 20240916042410_Kjz7a | ES000F | 2024-09-19T12:17:14.832Z | 2024-09-19T12:17:14.832Z |
5133930 | 5133930 | 20240916041847_7ymOK | ES000F | 2024-09-19T12:17:13.358Z | 2024-09-19T12:17:13.358Z |
5133852 | 5133852 | 20240916041019_0M3kE | ES000F | 2024-09-19T12:17:10.482Z | 2024-09-19T12:17:10.482Z |
5133777 | 5133777 | 20240916040503_zngAE | ES000F | 2024-09-19T12:17:07.682Z | 2024-09-19T12:17:07.682Z |
5133726 | 5133726 | 20240916035704_Z91tS | ES000F | 2024-09-19T12:17:06.272Z | 2024-09-19T12:17:06.272Z |
5133672 | 5133672 | 20240916035011_5QGQ3 | ES000F | 2024-09-19T12:17:05.073Z | 2024-09-19T12:17:05.073Z |
5133551 | 5133551 | 20240916033920_fP33f | ES000F | 2024-09-19T12:17:01.423Z | 2024-09-19T12:17:01.423Z |
5133515 | 5133515 | 20240916033616_WC9bt | ES000F | 2024-09-19T12:17:00.366Z | 2024-09-19T12:17:00.366Z |
5133445 | 5133445 | 20240916033103_NB29u | ES000F | 2024-09-19T12:16:56.522Z | 2024-09-19T12:16:56.522Z |
5133358 | 5133358 | 20240916032619_t1YQE | ES000F | 2024-09-19T12:16:55.306Z | 2024-09-19T12:16:55.306Z |
5133350 | 5133350 | 20240916032503_kaGK3 | ES000F | 2024-09-19T12:16:54.886Z | 2024-09-19T12:16:54.886Z |
5133306 | 5133306 | 20240916032035_HxaWq | ES000F | 2024-09-19T12:16:53.881Z | 2024-09-19T12:16:53.881Z |
5133133 | 5133133 | 20240916030003_UGiO2 | ES000F | 2024-09-19T12:16:45.060Z | 2024-09-19T12:16:45.060Z |
5133119 | 5133119 | 20240916025830_fgH6D | ES000F | 2024-09-19T12:16:44.494Z | 2024-09-19T12:16:44.494Z |
5133011 | 5133011 | 20240916024227_q386K | ES000F | 2024-09-19T12:16:40.945Z | 2024-09-19T12:16:40.945Z |
5132565 | 5132565 | 20240916013301_sOwl8 | ES000F | 2024-09-19T12:16:19.222Z | 2024-09-19T12:16:19.222Z |
5132491 | 5132491 | 20240916011611_sN4ee | ES000F | 2024-09-19T12:16:15.093Z | 2024-09-19T12:16:15.093Z |
5132306 | 5132306 | 20240916003036_4UzXi | ES000F | 2024-09-19T12:16:04.887Z | 2024-09-19T12:16:04.887Z |
5132223 | 5132223 | 20240916000724_u33Po | ES000F | 2024-09-19T12:15:59.514Z | 2024-09-19T12:15:59.514Z |
5132182 | 5132182 | 20240915235339_CJ8nq | ES000F | 2024-09-19T12:15:56.602Z | 2024-09-19T12:15:56.602Z |
5132100 | 5132100 | 20240915231959_oSIHG | ES000F | 2024-09-19T12:15:50.199Z | 2024-09-19T12:15:50.199Z |
5132047 | 5132047 | 20240915225452_bD978 | ES000F | 2024-09-19T12:15:45.126Z | 2024-09-19T12:15:45.126Z |
5132011 | 5132011 | 20240915224715_DeCw7 | ES000F | 2024-09-19T12:15:43.657Z | 2024-09-19T12:15:43.657Z |
5131995 | 5131995 | 20240915223306_akOz2 | ES000F | 2024-09-19T12:15:41.426Z | 2024-09-19T12:15:41.426Z |
5131827 | 5131827 | 20240915212351_tDudf | ES000F | 2024-09-19T12:15:25.134Z | 2024-09-19T12:15:25.134Z |
5131724 | 5131724 | 20240915205607_oz8f9 | ES000F | 2024-09-19T12:15:18.173Z | 2024-09-19T12:15:18.173Z |
5129860 | 5129860 | 20240917044501_QjiKc | ES000F | 2024-09-19T12:12:10.742Z | 2024-09-19T12:12:10.742Z |
5129790 | 5129790 | 20240917042953_UZrPk | ES000F | 2024-09-19T12:12:05.062Z | 2024-09-19T12:12:05.062Z |
5129632 | 5129632 | 20240917041528_qVUou | ES000F | 2024-09-19T12:11:55.756Z | 2024-09-19T12:11:55.756Z |
5129085 | 5129085 | 20240917031520_bo5vS | ES000F | 2024-09-19T12:11:14.668Z | 2024-09-19T12:11:14.668Z |
5128730 | 5128730 | 20240917022946_mSPiY | ES000F | 2024-09-19T12:10:59.143Z | 2024-09-19T12:10:59.143Z |
5128642 | 5128642 | 20240917021924_oPjFM | ES000F | 2024-09-19T12:10:51.485Z | 2024-09-19T12:10:51.485Z |
5128414 | 5128414 | 20240917013909_FVt9C | ES000F | 2024-09-19T12:10:32.823Z | 2024-09-19T12:10:32.823Z |
5128162 | 5128162 | 20240917005627_ua6h5 | ES000F | 2024-09-19T12:10:14.543Z | 2024-09-19T12:10:14.543Z |
5126772 | 5126772 | 20240916191503_00bo8 | ES000F | 2024-09-19T12:07:09.158Z | 2024-09-19T12:07:09.158Z |
5122098 | 5122098 | 20240914043306_0Sf7S | ES000F | 2024-09-18T12:11:06.822Z | 2024-09-19T12:20:02.769Z |
5122090 | 5122090 | 20240914043205_nCai4 | ES000F | 2024-09-18T12:11:05.487Z | 2024-09-19T12:20:02.754Z |
5121851 | 5121851 | 20240914041638_bZtZk | ES000F | 2024-09-18T12:11:02.192Z | 2024-09-19T12:20:02.423Z |
5121724 | 5121724 | 20240914041301_srmov | ES000F | 2024-09-18T12:11:00.881Z | 2024-09-19T12:20:02.317Z |
5121718 | 5121718 | 20240914041228_3cCmI | ES000F | 2024-09-18T12:11:00.298Z | 2024-09-19T12:20:02.269Z |
5121651 | 5121651 | 20240914041046_H7DAR | ES000F | 2024-09-18T12:10:59.106Z | 2024-09-19T12:20:02.206Z |
5121557 | 5121557 | 20240914040905_LLbsn | ES000F | 2024-09-18T12:10:58.298Z | 2024-09-19T12:20:02.117Z |
5121471 | 5121471 | 20240914040426_I1VGz | ES000F | 2024-09-18T12:10:56.925Z | 2024-09-19T12:20:01.908Z |
5121428 | 5121428 | 20240914040056_Ml4GP | ES000F | 2024-09-18T12:10:55.351Z | 2024-09-19T12:20:01.814Z |
5120911 | 5120911 | 20240914034121_ZEemt | ES000F | 2024-09-18T12:10:48.739Z | 2024-09-19T12:20:01.073Z |
5120651 | 5120651 | 20240914033051_jGvnZ | ES000F | 2024-09-18T12:10:44.231Z | 2024-09-19T12:20:00.672Z |
5120592 | 5120592 | 20240914032936_BWsYL | ES000F | 2024-09-18T12:10:43.555Z | 2024-09-19T12:20:00.625Z |
5120480 | 5120480 | 20240914032334_V23ZB | ES000F | 2024-09-18T12:10:41.570Z | 2024-09-19T12:20:00.490Z |
5120477 | 5120477 | 20240914032329_bUtve | ES000F | 2024-09-18T12:10:41.484Z | 2024-09-19T12:20:00.488Z |
5120162 | 5120162 | 20240914030310_Jcl95 | ES000F | 2024-09-18T12:10:33.422Z | 2024-09-19T12:19:59.520Z |
5119659 | 5119659 | 20240914024335_Dcs3u | ES000F | 2024-09-18T12:10:23.569Z | 2024-09-19T12:19:58.672Z |
5119647 | 5119647 | 20240914024154_HyCew | ES000F | 2024-09-18T12:10:22.846Z | 2024-09-19T12:19:58.635Z |
5119523 | 5119523 | 20240914023723_Enh2M | ES000F | 2024-09-18T12:10:22.009Z | 2024-09-19T12:19:58.452Z |
5119454 | 5119454 | 20240914023532_WBQtQ | ES000F | 2024-09-18T12:10:21.516Z | 2024-09-19T12:19:58.284Z |
5119339 | 5119339 | 20240914022549_R1Y2d | ES000F | 2024-09-18T12:10:20.263Z | 2024-09-19T12:19:58.000Z |
5119214 | 5119214 | 20240914021805_ydtDF | ES000F | 2024-09-18T12:10:18.626Z | 2024-09-19T12:19:57.404Z |
5119093 | 5119093 | 20240914020843_3WxDI | ES000F | 2024-09-18T12:10:15.936Z | 2024-09-19T12:19:57.057Z |
5117505 | 5117505 | 20240915044950_dMDlG | ES000F | 2024-09-18T12:07:43.701Z | 2024-09-19T12:19:15.509Z |
5117459 | 5117459 | 20240915043528_C3ktx | ES000F | 2024-09-18T12:07:42.031Z | 2024-09-19T12:19:15.135Z |
5117271 | 5117271 | 20240915041557_41jXv | ES000F | 2024-09-18T12:07:36.578Z | 2024-09-19T12:19:14.075Z |
5117188 | 5117188 | 20240915041047_iMjgO | ES000F | 2024-09-18T12:07:34.921Z | 2024-09-19T12:19:13.765Z |
5117097 | 5117097 | 20240915040230_9Vd6Z | ES000F | 2024-09-18T12:07:32.667Z | 2024-09-19T12:19:13.325Z |
5116771 | 5116771 | 20240915034036_DAPfY | ES000F | 2024-09-18T12:07:20.452Z | 2024-09-19T12:19:12.318Z |
5116432 | 5116432 | 20240915032617_xWpxO | ES000F | 2024-09-18T12:07:02.522Z | 2024-09-19T12:19:11.163Z |
5116269 | 5116269 | 20240915031958_5l9iB | ES000F | 2024-09-18T12:06:53.795Z | 2024-09-19T12:19:10.185Z |
5116062 | 5116062 | 20240915030621_Kbwnr | ES000F | 2024-09-18T12:06:36.101Z | 2024-09-19T12:19:08.358Z |
5115757 | 5115757 | 20240915025304_O3nVg | ES000F | 2024-09-18T12:06:23.146Z | 2024-09-19T12:19:06.778Z |
5115629 | 5115629 | 20240915024646_aOYWw | ES000F | 2024-09-18T12:06:19.765Z | 2024-09-19T12:19:05.841Z |
5114845 | 5114845 | 20240915020038_lxoSQ | ES000F | 2024-09-18T12:05:36.591Z | 2024-09-19T12:19:00.153Z |
5114307 | 5114307 | 20240915013548_WNesZ | ES000F | 2024-09-18T12:05:09.944Z | 2024-09-19T12:18:57.485Z |
5114228 | 5114228 | 20240915013227_cU5LN | ES000F | 2024-09-18T12:05:07.761Z | 2024-09-19T12:18:57.059Z |
5114206 | 5114206 | 20240915013114_UpkOF | ES000F | 2024-09-18T12:05:06.300Z | 2024-09-19T12:18:56.732Z |
5114181 | 5114181 | 20240915013018_Izpu4 | ES000F | 2024-09-18T12:05:05.356Z | 2024-09-19T12:18:56.613Z |
5113433 | 5113433 | 20240915004917_p8aha | ES000F | 2024-09-18T12:04:16.480Z | 2024-09-19T12:18:49.040Z |
5113291 | 5113291 | 20240915003532_LS82u | ES000F | 2024-09-18T12:04:06.123Z | 2024-09-19T12:18:48.381Z |
5113289 | 5113289 | 20240915003531_3doEP | ES000F | 2024-09-18T12:04:05.931Z | 2024-09-19T12:18:48.371Z |
5113194 | 5113194 | 20240915003041_v3G3G | ES000F | 2024-09-18T12:04:02.561Z | 2024-09-19T12:18:47.947Z |
5113035 | 5113035 | 20240915001634_gQ8uH | ES000F | 2024-09-18T12:03:52.223Z | 2024-09-19T12:18:46.660Z |
5112414 | 5112414 | 20240914230815_bSO4b | ES000F | 2024-09-18T12:03:02.749Z | 2024-09-19T12:18:40.840Z |
5112247 | 5112247 | 20240914224505_upRFv | ES000F | 2024-09-18T12:02:56.228Z | 2024-09-19T12:18:40.080Z |
5111848 | 5111848 | 20240914212227_1LgDN | ES000F | 2024-09-18T12:02:22.142Z | 2024-09-19T12:18:34.647Z |
5111359 | 5111359 | 20240914202805_CS3dM | ES000F | 2024-09-18T12:01:52.148Z | 2024-09-19T12:18:29.450Z |
5108284 | 5108284 | 20240913044049_WZ3w4 | ES000F | 2024-09-17T12:13:34.742Z | 2024-09-19T12:20:48.001Z |
5108004 | 5108004 | 20240913041902_RINod | ES000F | 2024-09-17T12:13:27.622Z | 2024-09-19T12:20:47.742Z |
5107972 | 5107972 | 20240913041711_FOJi8 | ES000F | 2024-09-17T12:13:26.379Z | 2024-09-19T12:20:47.664Z |
5107471 | 5107471 | 20240913035747_osjQQ | ES000F | 2024-09-17T12:13:16.003Z | 2024-09-19T12:20:47.181Z |
5107470 | 5107470 | 20240913035739_PcN0v | ES000F | 2024-09-17T12:13:15.920Z | 2024-09-19T12:20:47.175Z |
5106998 | 5106998 | 20240913034154_kq80Y | ES000F | 2024-09-17T12:13:06.743Z | 2024-09-19T12:20:46.765Z |
5106425 | 5106425 | 20240913032415_F3DTF | ES000F | 2024-09-17T12:12:53.625Z | 2024-09-19T12:20:46.067Z |
5106186 | 5106186 | 20240913031454_XBR71 | ES000F | 2024-09-17T12:12:44.262Z | 2024-09-19T12:20:45.610Z |
5106165 | 5106165 | 20240913031346_Pvpxu | ES000F | 2024-09-17T12:12:43.706Z | 2024-09-19T12:20:45.572Z |
5106054 | 5106054 | 20240913030734_eikig | ES000F | 2024-09-17T12:12:39.499Z | 2024-09-19T12:20:45.389Z |
5105173 | 5105173 | 20240913023546_MfT7W | ES000F | 2024-09-17T12:12:00.973Z | 2024-09-19T12:20:44.069Z |
5105119 | 5105119 | 20240913023153_2h9Yf | ES000F | 2024-09-17T12:11:57.195Z | 2024-09-19T12:20:43.740Z |
5105117 | 5105117 | 20240913023153_gFDvh | ES000F | 2024-09-17T12:11:56.923Z | 2024-09-19T12:20:43.720Z |
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);