participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,082 rows where station_code = "ES000U" 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 |
---|---|---|---|---|---|
5134111 | 5134111 | 20240916050739_23H7H | ES000U | 2024-09-19T12:17:21.870Z | 2024-09-19T12:17:21.870Z |
5134102 | 5134102 | 20240916050513_L37Yq | ES000U | 2024-09-19T12:17:21.246Z | 2024-09-19T12:17:21.246Z |
5134098 | 5134098 | 20240916050437_DTZcn | ES000U | 2024-09-19T12:17:19.646Z | 2024-09-19T12:17:19.646Z |
5133994 | 5133994 | 20240916042737_pft3o | ES000U | 2024-09-19T12:17:15.545Z | 2024-09-19T12:17:15.545Z |
5133490 | 5133490 | 20240916033249_423xJ | ES000U | 2024-09-19T12:16:59.597Z | 2024-09-19T12:16:59.597Z |
5132410 | 5132410 | 20240916010212_D3dj9 | ES000U | 2024-09-19T12:16:11.189Z | 2024-09-19T12:16:11.189Z |
5129816 | 5129816 | 20240917043711_smU9n | ES000U | 2024-09-19T12:12:07.081Z | 2024-09-19T12:12:07.081Z |
5129781 | 5129781 | 20240917042738_4vPaG | ES000U | 2024-09-19T12:12:04.149Z | 2024-09-19T12:12:04.149Z |
5122228 | 5122228 | 20240914050253_sPauH | ES000U | 2024-09-18T12:11:10.826Z | 2024-09-19T12:20:03.316Z |
5122160 | 5122160 | 20240914044037_cxay5 | ES000U | 2024-09-18T12:11:07.838Z | 2024-09-19T12:20:02.879Z |
5122112 | 5122112 | 20240914043500_S3cHm | ES000U | 2024-09-18T12:11:07.338Z | 2024-09-19T12:20:02.820Z |
5121884 | 5121884 | 20240914041927_RzekV | ES000U | 2024-09-18T12:11:02.758Z | 2024-09-19T12:20:02.477Z |
5121453 | 5121453 | 20240914040326_PgjAn | ES000U | 2024-09-18T12:10:55.675Z | 2024-09-19T12:20:01.870Z |
5120832 | 5120832 | 20240914033659_2c5I0 | ES000U | 2024-09-18T12:10:47.414Z | 2024-09-19T12:20:00.912Z |
5120326 | 5120326 | 20240914031500_Kg3xs | ES000U | 2024-09-18T12:10:37.347Z | 2024-09-19T12:19:59.891Z |
5120209 | 5120209 | 20240914030624_gRNnm | ES000U | 2024-09-18T12:10:34.752Z | 2024-09-19T12:19:59.705Z |
5117547 | 5117547 | 20240915051349_4K7Zg | ES000U | 2024-09-18T12:07:46.247Z | 2024-09-19T12:19:15.853Z |
5117472 | 5117472 | 20240915043925_M3is2 | ES000U | 2024-09-18T12:07:42.442Z | 2024-09-19T12:19:15.230Z |
5117177 | 5117177 | 20240915040828_2hmhC | ES000U | 2024-09-18T12:07:34.394Z | 2024-09-19T12:19:13.694Z |
5116913 | 5116913 | 20240915034955_dXi4A | ES000U | 2024-09-18T12:07:25.818Z | 2024-09-19T12:19:12.707Z |
5116564 | 5116564 | 20240915033143_8iCOE | ES000U | 2024-09-18T12:07:09.941Z | 2024-09-19T12:19:11.523Z |
5116126 | 5116126 | 20240915031010_r15O9 | ES000U | 2024-09-18T12:06:41.858Z | 2024-09-19T12:19:08.795Z |
5116090 | 5116090 | 20240915030743_oOn6T | ES000U | 2024-09-18T12:06:39.016Z | 2024-09-19T12:19:08.642Z |
5115879 | 5115879 | 20240915025804_LwFLC | ES000U | 2024-09-18T12:06:30.676Z | 2024-09-19T12:19:07.702Z |
5112690 | 5112690 | 20240914234221_eFQ22 | ES000U | 2024-09-18T12:03:22.292Z | 2024-09-19T12:18:43.470Z |
5108304 | 5108304 | 20240913044808_V9Km8 | ES000U | 2024-09-17T12:13:35.805Z | 2024-09-19T12:20:48.080Z |
5108302 | 5108302 | 20240913044803_RhrY2 | ES000U | 2024-09-17T12:13:35.719Z | 2024-09-19T12:20:48.059Z |
5108287 | 5108287 | 20240913044502_fZQ4r | ES000U | 2024-09-17T12:13:34.986Z | 2024-09-19T12:20:48.018Z |
5108248 | 5108248 | 20240913043608_3WQin | ES000U | 2024-09-17T12:13:34.060Z | 2024-09-19T12:20:47.970Z |
5108044 | 5108044 | 20240913042106_G2RyO | ES000U | 2024-09-17T12:13:29.830Z | 2024-09-19T12:20:47.813Z |
5107906 | 5107906 | 20240913041456_1Vudi | ES000U | 2024-09-17T12:13:25.791Z | 2024-09-19T12:20:47.632Z |
5107250 | 5107250 | 20240913034919_Pq4GB | ES000U | 2024-09-17T12:13:11.810Z | 2024-09-19T12:20:46.956Z |
5106075 | 5106075 | 20240913030900_1bIcM | ES000U | 2024-09-17T12:12:41.329Z | 2024-09-19T12:20:45.439Z |
5106061 | 5106061 | 20240913030824_QecJO | ES000U | 2024-09-17T12:12:40.443Z | 2024-09-19T12:20:45.408Z |
5105940 | 5105940 | 20240913030339_O5Xab | ES000U | 2024-09-17T12:12:34.331Z | 2024-09-19T12:20:45.077Z |
5105576 | 5105576 | 20240913025222_WCHK2 | ES000U | 2024-09-17T12:12:22.180Z | 2024-09-19T12:20:44.677Z |
5104983 | 5104983 | 20240913022528_jyxq9 | ES000U | 2024-09-17T12:11:48.155Z | 2024-09-19T12:20:43.205Z |
5104689 | 5104689 | 20240913021904_pxLFA | ES000U | 2024-09-17T12:11:43.051Z | 2024-09-19T12:20:42.693Z |
5104590 | 5104590 | 20240913021624_eBaA3 | ES000U | 2024-09-17T12:11:40.408Z | 2024-09-19T12:20:42.529Z |
5102314 | 5102314 | 20240914011923_5Uu2k | ES000U | 2024-09-17T12:07:00.537Z | 2024-09-19T12:19:53.455Z |
5097626 | 5097626 | 20240913005711_Jw8q5 | ES000U | 2024-09-16T12:17:13.740Z | 2024-09-19T12:20:38.854Z |
5094977 | 5094977 | 20240912045854_SyHw0 | ES000U | 2024-09-16T12:15:05.517Z | 2024-09-19T12:21:16.793Z |
5094562 | 5094562 | 20240912041059_FOTOA | ES000U | 2024-09-16T12:14:51.563Z | 2024-09-19T12:21:16.254Z |
5094228 | 5094228 | 20240912035407_Z2zOU | ES000U | 2024-09-16T12:14:39.627Z | 2024-09-19T12:21:16.027Z |
5092963 | 5092963 | 20240912030310_C0QJu | ES000U | 2024-09-16T12:14:08.252Z | 2024-09-19T12:21:14.769Z |
5092942 | 5092942 | 20240912030228_ZEAoK | ES000U | 2024-09-16T12:14:07.721Z | 2024-09-19T12:21:14.745Z |
5092937 | 5092937 | 20240912030203_c8a38 | ES000U | 2024-09-16T12:14:07.476Z | 2024-09-19T12:21:14.716Z |
5092797 | 5092797 | 20240912025802_d7bxs | ES000U | 2024-09-16T12:14:04.507Z | 2024-09-19T12:21:14.576Z |
5092498 | 5092498 | 20240912024817_4fCwB | ES000U | 2024-09-16T12:13:58.373Z | 2024-09-19T12:21:14.282Z |
5091937 | 5091937 | 20240912022904_V5EoB | ES000U | 2024-09-16T12:13:32.717Z | 2024-09-19T12:21:13.514Z |
5091553 | 5091553 | 20240912021320_PyKE5 | ES000U | 2024-09-16T12:13:10.581Z | 2024-09-19T12:21:13.199Z |
5089952 | 5089952 | 20240912010410_oT6le | ES000U | 2024-09-16T12:11:51.367Z | 2024-09-19T12:21:10.788Z |
5089338 | 5089338 | 20240912003623_ddp4m | ES000U | 2024-09-16T12:11:20.795Z | 2024-09-19T12:21:09.891Z |
5089036 | 5089036 | 20240912002246_dVj9f | ES000U | 2024-09-16T12:11:13.344Z | 2024-09-19T12:21:09.709Z |
5087766 | 5087766 | 20240912234301_ZoDQ3 | ES000U | 2024-09-16T12:07:26.271Z | 2024-09-19T12:20:35.664Z |
5087548 | 5087548 | 20240912233117_i5BBt | ES000U | 2024-09-16T12:07:03.552Z | 2024-09-19T12:20:35.341Z |
5080791 | 5080791 | 20240911044818_mGvs4 | ES000U | 2024-09-15T12:17:13.342Z | 2024-09-19T12:21:43.663Z |
5080760 | 5080760 | 20240911044058_9d2r1 | ES000U | 2024-09-15T12:17:12.447Z | 2024-09-19T12:21:43.605Z |
5080670 | 5080670 | 20240911042138_T2GtV | ES000U | 2024-09-15T12:17:09.885Z | 2024-09-19T12:21:43.381Z |
5079803 | 5079803 | 20240911031253_SBGaE | ES000U | 2024-09-15T12:16:36.515Z | 2024-09-19T12:21:42.629Z |
5079229 | 5079229 | 20240911024153_yXiuY | ES000U | 2024-09-15T12:16:11.244Z | 2024-09-19T12:21:41.265Z |
5078867 | 5078867 | 20240911021803_hKI95 | ES000U | 2024-09-15T12:15:54.032Z | 2024-09-19T12:21:40.773Z |
5077691 | 5077691 | 20240911011110_653aS | ES000U | 2024-09-15T12:15:00.023Z | 2024-09-19T12:21:39.519Z |
5075029 | 5075029 | 20240911232334_3i1RA | ES000U | 2024-09-15T12:09:19.324Z | 2024-09-19T12:21:08.018Z |
5072489 | 5072489 | 20240911201347_cJduK | ES000U | 2024-09-15T12:05:29.528Z | 2024-09-19T12:21:04.265Z |
5069396 | 5069396 | 20240910213808_wIBim | ES000U | 2024-09-14T12:19:56.011Z | 2024-09-19T12:21:34.828Z |
5065661 | 5065661 | 20240910050334_1ot9C | ES000U | 2024-09-14T12:17:17.259Z | 2024-09-18T12:15:20.107Z |
5065630 | 5065630 | 20240910045345_j6HOR | ES000U | 2024-09-14T12:17:15.284Z | 2024-09-18T12:15:19.991Z |
5065566 | 5065566 | 20240910044040_ao2Gc | ES000U | 2024-09-14T12:17:11.652Z | 2024-09-18T12:15:19.848Z |
5065476 | 5065476 | 20240910041959_wWkeF | ES000U | 2024-09-14T12:17:07.061Z | 2024-09-18T12:15:19.564Z |
5065413 | 5065413 | 20240910040323_kwP5c | ES000U | 2024-09-14T12:17:04.321Z | 2024-09-18T12:15:19.342Z |
5065357 | 5065357 | 20240910035351_kZqIN | ES000U | 2024-09-14T12:17:01.691Z | 2024-09-18T12:15:19.178Z |
5065343 | 5065343 | 20240910034938_CSlZA | ES000U | 2024-09-14T12:17:01.159Z | 2024-09-18T12:15:19.133Z |
5065324 | 5065324 | 20240910034318_9f8E1 | ES000U | 2024-09-14T12:16:58.621Z | 2024-09-18T12:15:19.059Z |
5065225 | 5065225 | 20240910032339_2jFXt | ES000U | 2024-09-14T12:16:43.888Z | 2024-09-18T12:15:18.772Z |
5065073 | 5065073 | 20240910030055_r0npb | ES000U | 2024-09-14T12:16:22.953Z | 2024-09-18T12:15:18.328Z |
5064982 | 5064982 | 20240910024910_g2B4b | ES000U | 2024-09-14T12:16:15.819Z | 2024-09-18T12:15:18.021Z |
5064613 | 5064613 | 20240910014228_aAtrq | ES000U | 2024-09-14T12:15:47.534Z | 2024-09-18T12:15:16.874Z |
5064342 | 5064342 | 20240910005210_wghKn | ES000U | 2024-09-14T12:15:18.541Z | 2024-09-18T12:15:16.160Z |
5064316 | 5064316 | 20240910004704_npS5T | ES000U | 2024-09-14T12:15:16.692Z | 2024-09-18T12:15:16.114Z |
5064011 | 5064011 | 20240909232054_tb1Zq | ES000U | 2024-09-14T12:14:39.658Z | 2024-09-18T12:15:15.164Z |
5063988 | 5063988 | 20240909231535_cj61e | ES000U | 2024-09-14T12:14:36.877Z | 2024-09-18T12:15:15.124Z |
5063515 | 5063515 | 20240909213128_0L1Bp | ES000U | 2024-09-14T12:14:04.697Z | 2024-09-18T12:15:14.114Z |
5063410 | 5063410 | 20240909210401_XYI23 | ES000U | 2024-09-14T12:13:58.183Z | 2024-09-18T12:15:13.817Z |
5060692 | 5060692 | 20240910205319_ThURC | ES000U | 2024-09-14T12:09:22.336Z | 2024-09-19T12:21:33.467Z |
5054879 | 5054879 | 20240908044543_irxy9 | ES000U | 2024-09-13T12:16:57.731Z | 2024-09-16T12:21:17.090Z |
5054746 | 5054746 | 20240908035000_TyL3w | ES000U | 2024-09-13T12:16:54.770Z | 2024-09-16T12:21:16.770Z |
5054579 | 5054579 | 20240908031300_JB6tI | ES000U | 2024-09-13T12:16:47.529Z | 2024-09-16T12:21:16.125Z |
5052346 | 5052346 | 20240907202429_Kcj34 | ES000U | 2024-09-13T12:15:05.088Z | 2024-09-16T12:21:05.194Z |
5047640 | 5047640 | 20240909050340_ME4iI | ES000U | 2024-09-13T12:09:30.470Z | 2024-09-17T12:19:03.803Z |
5047584 | 5047584 | 20240909045135_Ml88Y | ES000U | 2024-09-13T12:09:26.192Z | 2024-09-17T12:19:03.325Z |
5047569 | 5047569 | 20240909044532_f8Rkl | ES000U | 2024-09-13T12:09:24.526Z | 2024-09-17T12:19:03.172Z |
5047519 | 5047519 | 20240909043303_bpv1R | ES000U | 2024-09-13T12:09:21.147Z | 2024-09-17T12:19:03.011Z |
5047374 | 5047374 | 20240909034434_okVwN | ES000U | 2024-09-13T12:08:53.617Z | 2024-09-17T12:19:02.236Z |
5047370 | 5047370 | 20240909034411_mJMVf | ES000U | 2024-09-13T12:08:53.020Z | 2024-09-17T12:19:02.188Z |
5047283 | 5047283 | 20240909032301_hkK1e | ES000U | 2024-09-13T12:08:44.785Z | 2024-09-17T12:19:01.914Z |
5047266 | 5047266 | 20240909031911_4JH1S | ES000U | 2024-09-13T12:08:43.694Z | 2024-09-17T12:19:01.885Z |
5047166 | 5047166 | 20240909025430_56BUB | ES000U | 2024-09-13T12:08:31.275Z | 2024-09-17T12:19:01.339Z |
5047162 | 5047162 | 20240909025102_FHcPd | ES000U | 2024-09-13T12:08:29.351Z | 2024-09-17T12:19:01.336Z |
5047144 | 5047144 | 20240909024735_AtPLP | ES000U | 2024-09-13T12:08:22.230Z | 2024-09-17T12:19:01.314Z |
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);