participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,837 rows where station_code = "ES0013" 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 |
---|---|---|---|---|---|
5564659 | 5564659 | 20241120031627_X1oi3 | ES0013 | 2024-11-21T14:17:55.436Z | 2024-11-22T14:21:34.938Z |
5530354 | 5530354 | 20241112021025_jx8Xv | ES0013 | 2024-11-13T14:14:10.772Z | 2024-11-20T14:25:57.811Z |
5528485 | 5528485 | 20241111210912_R7U3d | ES0013 | 2024-11-13T14:10:50.010Z | 2024-11-20T14:25:31.162Z |
5334916 | 5334916 | 20241021033258_Mp3ly | ES0013 | 2024-10-22T12:17:38.101Z | 2024-10-29T12:26:35.741Z |
5334439 | 5334439 | 20241021023420_pJa7q | ES0013 | 2024-10-22T12:16:50.739Z | 2024-10-29T12:26:35.168Z |
5333759 | 5333759 | 20241021012239_kPXmq | ES0013 | 2024-10-22T12:16:02.363Z | 2024-10-29T12:26:34.595Z |
5327764 | 5327764 | 20241020034618_O9Qhm | ES0013 | 2024-10-21T12:13:05.552Z | 2024-10-28T12:26:46.726Z |
5327564 | 5327564 | 20241020024335_hpQtZ | ES0013 | 2024-10-21T12:12:20.953Z | 2024-10-28T12:26:45.609Z |
5327520 | 5327520 | 20241020023251_H5XbR | ES0013 | 2024-10-21T12:12:16.581Z | 2024-10-28T12:26:45.439Z |
5327496 | 5327496 | 20241020022458_Dx0L2 | ES0013 | 2024-10-21T12:12:14.644Z | 2024-10-28T12:26:45.300Z |
5284852 | 5284852 | 20241011031455_FuHGp | ES0013 | 2024-10-12T12:17:41.634Z | 2024-10-19T12:27:58.424Z |
5284608 | 5284608 | 20241011025556_3lqYG | ES0013 | 2024-10-12T12:17:29.578Z | 2024-10-19T12:27:56.533Z |
5283191 | 5283191 | 20241011010105_0784j | ES0013 | 2024-10-12T12:16:27.498Z | 2024-10-19T12:27:49.548Z |
5282700 | 5282700 | 20241010231144_S7zd6 | ES0013 | 2024-10-12T12:15:57.542Z | 2024-10-19T12:27:45.464Z |
5282492 | 5282492 | 20241010220101_E21IU | ES0013 | 2024-10-12T12:15:38.394Z | 2024-10-19T12:27:44.131Z |
5282383 | 5282383 | 20241010213155_ah5CE | ES0013 | 2024-10-12T12:15:30.453Z | 2024-10-19T12:27:43.600Z |
5276705 | 5276705 | 20241011050026_lhvIw | ES0013 | 2024-10-12T12:01:32.488Z | 2024-10-20T12:23:12.949Z |
5276001 | 5276001 | 20241011041011_xlMhN | ES0013 | 2024-10-12T12:00:11.124Z | 2024-10-20T12:23:03.795Z |
5246533 | 5246533 | 20241006015552_UcOUV | ES0013 | 2024-10-07T12:16:30.370Z | 2024-10-14T12:24:38.203Z |
5245821 | 5245821 | 20241006001038_DgbKL | ES0013 | 2024-10-07T12:15:58.578Z | 2024-10-14T12:24:36.316Z |
5235827 | 5235827 | 20241005021328_Xv0RM | ES0013 | 2024-10-06T12:16:43.219Z | 2024-10-13T12:26:26.457Z |
5225361 | 5225361 | 20241003222711_oIYd1 | ES0013 | 2024-10-05T12:19:40.329Z | 2024-10-12T12:25:09.925Z |
5225144 | 5225144 | 20241003220134_SgSuI | ES0013 | 2024-10-05T12:19:24.512Z | 2024-10-12T12:25:09.603Z |
5224183 | 5224183 | 20241003201159_CSvX2 | ES0013 | 2024-10-05T12:18:14.500Z | 2024-10-12T12:25:07.688Z |
5220092 | 5220092 | 20241003044647_OPmxM | ES0013 | 2024-10-05T12:10:14.595Z | 2024-10-12T12:24:56.828Z |
5200009 | 5200009 | 20241001021229_a5zss | ES0013 | 2024-10-02T12:01:09.707Z | 2024-10-10T12:24:29.384Z |
5194998 | 5194998 | 20240930040110_YhqSW | ES0013 | 2024-10-01T12:03:01.652Z | 2024-10-09T12:29:01.721Z |
5191187 | 5191187 | 20240928192646_xY324 | ES0013 | 2024-09-30T12:17:32.667Z | 2024-10-06T12:28:21.994Z |
5184757 | 5184757 | 20240929012518_s6gtT | ES0013 | 2024-09-30T12:02:25.866Z | 2024-10-07T12:21:16.321Z |
5179705 | 5179705 | 20240928043745_ODCNE | ES0013 | 2024-09-29T12:08:22.033Z | 2024-10-06T12:28:05.124Z |
5179513 | 5179513 | 20240928041435_nyZKU | ES0013 | 2024-09-29T12:08:09.003Z | 2024-10-06T12:28:04.179Z |
5179359 | 5179359 | 20240928040347_f45Ua | ES0013 | 2024-09-29T12:07:57.008Z | 2024-10-06T12:28:03.449Z |
5129850 | 5129850 | 20240917044229_O93fZ | ES0013 | 2024-09-19T12:12:09.759Z | 2024-09-25T12:22:33.312Z |
5129780 | 5129780 | 20240917042649_pbP43 | ES0013 | 2024-09-19T12:12:03.735Z | 2024-09-25T12:22:32.814Z |
5120417 | 5120417 | 20240914032015_lrYn4 | ES0013 | 2024-09-18T12:10:39.700Z | 2024-09-22T12:17:56.872Z |
5120415 | 5120415 | 20240914032014_Y1Knp | ES0013 | 2024-09-18T12:10:39.430Z | 2024-09-22T12:17:56.842Z |
5102107 | 5102107 | 20240914010623_O1rMH | ES0013 | 2024-09-17T12:06:49.132Z | 2024-09-22T12:17:52.662Z |
5101821 | 5101821 | 20240914004806_Z9Jns | ES0013 | 2024-09-17T12:06:14.336Z | 2024-09-22T12:17:52.066Z |
5092843 | 5092843 | 20240912025947_TiRUY | ES0013 | 2024-09-16T12:14:05.373Z | 2024-09-20T12:21:51.609Z |
5065298 | 5065298 | 20240910033814_ipun0 | ES0013 | 2024-09-14T12:16:55.902Z | 2024-09-18T12:15:18.960Z |
5064505 | 5064505 | 20240910012557_xU9RT | ES0013 | 2024-09-14T12:15:34.357Z | 2024-09-18T12:15:16.785Z |
5047272 | 5047272 | 20240909032033_Aj2HS | ES0013 | 2024-09-13T12:08:44.209Z | 2024-09-17T12:19:01.898Z |
5047149 | 5047149 | 20240909024811_3QTrc | ES0013 | 2024-09-13T12:08:23.281Z | 2024-09-17T12:19:01.325Z |
5046561 | 5046561 | 20240909001244_V0J4q | ES0013 | 2024-09-13T12:06:56.488Z | 2024-09-17T12:18:59.500Z |
5046354 | 5046354 | 20240908225418_Gs0QT | ES0013 | 2024-09-13T12:06:32.418Z | 2024-09-17T12:18:59.131Z |
5045811 | 5045811 | 20240908193055_9fRyS | ES0013 | 2024-09-13T12:05:01.537Z | 2024-09-17T12:18:57.413Z |
5040533 | 5040533 | 20240906043816_mASVB | ES0013 | 2024-09-12T12:16:15.412Z | 2024-09-14T12:23:09.871Z |
5026614 | 5026614 | 20240905043217_3gmC3 | ES0013 | 2024-09-11T12:12:49.168Z | 2024-09-13T12:19:59.072Z |
5026508 | 5026508 | 20240905034632_RRE9Q | ES0013 | 2024-09-11T12:12:38.669Z | 2024-09-13T12:19:58.511Z |
5021072 | 5021072 | 20240905043217_OlMY3 | ES0013 | 2024-09-10T12:15:13.765Z | 2024-09-10T12:16:55.304Z |
5020968 | 5020968 | 20240905034632_LOyGr | ES0013 | 2024-09-10T12:15:09.349Z | 2024-09-10T12:16:55.282Z |
4983021 | 4983021 | 20240812004033_Xf373 | ES0013 | 2024-09-06T12:15:12.045Z | 2024-09-06T12:15:12.045Z |
4982923 | 4982923 | 20240812003922_7zgfD | ES0013 | 2024-09-06T12:15:07.441Z | 2024-09-06T12:15:07.441Z |
4976307 | 4976307 | 20240811232837_u3sYw | ES0013 | 2024-09-06T12:11:24.021Z | 2024-09-06T12:11:24.021Z |
4974497 | 4974497 | 20240811230742_ZDgLo | ES0013 | 2024-09-05T12:11:25.617Z | 2024-09-06T12:10:27.452Z |
4967155 | 4967155 | 20240811214020_PFNie | ES0013 | 2024-09-05T12:07:32.618Z | 2024-09-06T12:06:54.809Z |
4955153 | 4955153 | 20240811034946_rtd2Q | ES0013 | 2024-09-03T12:18:50.007Z | 2024-09-06T12:29:21.554Z |
4955122 | 4955122 | 20240811034313_Z8hg3 | ES0013 | 2024-09-03T12:18:45.847Z | 2024-09-06T12:29:19.870Z |
4954922 | 4954922 | 20240811031630_ncDCb | ES0013 | 2024-09-03T12:18:26.028Z | 2024-09-06T12:29:11.687Z |
4954137 | 4954137 | 20240811025247_LXpeH | ES0013 | 2024-09-03T12:18:08.194Z | 2024-09-06T12:28:50.956Z |
4946468 | 4946468 | 20240811010134_AeD5J | ES0013 | 2024-09-02T12:13:56.377Z | 2024-09-06T12:26:23.365Z |
4941323 | 4941323 | 20240810233038_SDnho | ES0013 | 2024-09-02T12:10:25.483Z | 2024-09-06T12:23:46.141Z |
4937109 | 4937109 | 20240810214007_oheo1 | ES0013 | 2024-09-01T12:08:03.155Z | 2024-09-06T12:21:59.548Z |
4929364 | 4929364 | 20240810034603_ZopYM | ES0013 | 2024-08-31T12:22:07.585Z | 2024-09-02T12:29:32.627Z |
4926571 | 4926571 | 20240810015234_XDkgL | ES0013 | 2024-08-31T12:19:44.445Z | 2024-09-02T12:27:55.728Z |
4921555 | 4921555 | 20240810005800_Cpaih | ES0013 | 2024-08-30T12:14:14.571Z | 2024-09-02T12:27:05.550Z |
4920841 | 4920841 | 20240810003939_ZpqqH | ES0013 | 2024-08-30T12:13:41.046Z | 2024-09-02T12:26:40.717Z |
4919380 | 4919380 | 20240810001114_B4WRI | ES0013 | 2024-08-30T12:12:42.063Z | 2024-09-02T12:25:51.252Z |
4919209 | 4919209 | 20240810000627_Uh5R0 | ES0013 | 2024-08-30T12:12:34.334Z | 2024-09-02T12:25:42.734Z |
4903625 | 4903625 | 20240808030618_32tlu | ES0013 | 2024-08-28T12:19:43.499Z | 2024-08-28T12:19:43.499Z |
4901055 | 4901055 | 20240808010240_j6soi | ES0013 | 2024-08-28T12:18:32.243Z | 2024-08-28T12:18:32.243Z |
4900139 | 4900139 | 20240807235347_Ugrqh | ES0013 | 2024-08-28T12:17:50.607Z | 2024-08-28T12:17:50.607Z |
4891711 | 4891711 | 20240809013050_9vgX1 | ES0013 | 2024-08-28T12:09:18.322Z | 2024-08-30T12:21:22.722Z |
4891048 | 4891048 | 20240809002023_JAxQK | ES0013 | 2024-08-28T12:08:32.005Z | 2024-08-30T12:20:52.100Z |
4889782 | 4889782 | 20240808214808_T9h9W | ES0013 | 2024-08-28T12:06:44.707Z | 2024-08-30T12:19:38.279Z |
4889776 | 4889776 | 20240808214711_jtvkk | ES0013 | 2024-08-28T12:06:44.175Z | 2024-08-30T12:19:37.433Z |
4889638 | 4889638 | 20240808212855_p5JCg | ES0013 | 2024-08-28T12:06:32.140Z | 2024-08-30T12:19:30.330Z |
4884587 | 4884587 | 20240807034925_xOTN8 | ES0013 | 2024-08-20T12:15:45.159Z | 2024-08-27T12:16:23.250Z |
4884383 | 4884383 | 20240807031429_Fe2l9 | ES0013 | 2024-08-20T12:15:34.040Z | 2024-08-27T12:16:11.383Z |
4876564 | 4876564 | 20240806234140_Ylzr2 | ES0013 | 2024-08-19T12:12:55.944Z | 2024-08-27T12:12:45.053Z |
4871585 | 4871585 | 20240806205001_ZlwuA | ES0013 | 2024-08-19T12:09:15.605Z | 2024-08-27T12:09:53.367Z |
4833157 | 4833157 | 20240805000639_yy17c | ES0013 | 2024-08-15T12:13:41.156Z | 2024-08-17T12:31:25.303Z |
4826472 | 4826472 | 20240804033455_Rezjb | ES0013 | 2024-08-14T12:21:08.047Z | 2024-08-15T12:26:19.798Z |
4825352 | 4825352 | 20240804010611_n1tSK | ES0013 | 2024-08-14T12:20:03.800Z | 2024-08-15T12:25:49.875Z |
4797185 | 4797185 | 20240802030202_NPXyn | ES0013 | 2024-08-11T12:16:21.182Z | 2024-08-11T12:16:21.182Z |
4796984 | 4796984 | 20240802024456_BumD1 | ES0013 | 2024-08-11T12:16:16.053Z | 2024-08-11T12:16:16.053Z |
4786313 | 4786313 | 20240802005641_eX6gP | ES0013 | 2024-08-10T12:16:52.288Z | 2024-08-11T12:15:02.317Z |
4785503 | 4785503 | 20240802002019_ovsZM | ES0013 | 2024-08-10T12:16:05.449Z | 2024-08-11T12:14:48.220Z |
4784205 | 4784205 | 20240801231710_3GP18 | ES0013 | 2024-08-10T12:14:42.436Z | 2024-08-11T12:14:25.801Z |
4780075 | 4780075 | 20240801014355_m1HWj | ES0013 | 2024-08-07T12:14:48.285Z | 2024-08-10T12:21:45.908Z |
4769431 | 4769431 | 20240731203532_1T4YA | ES0013 | 2024-08-06T12:10:52.711Z | 2024-08-10T12:20:35.458Z |
4762969 | 4762969 | 20240731030053_eYu0i | ES0013 | 2024-08-06T12:03:30.398Z | 2024-08-10T12:18:01.996Z |
4762906 | 4762906 | 20240731025312_dxxzj | ES0013 | 2024-08-06T12:03:27.450Z | 2024-08-10T12:18:00.338Z |
4762319 | 4762319 | 20240731015935_DB8m6 | ES0013 | 2024-08-06T12:02:16.989Z | 2024-08-10T12:17:42.310Z |
4760130 | 4760130 | 20240730232609_IoZ90 | ES0013 | 2024-08-05T12:15:49.014Z | 2024-08-08T12:24:26.843Z |
4758874 | 4758874 | 20240730222414_UEmK3 | ES0013 | 2024-08-05T12:14:44.971Z | 2024-08-08T12:23:44.604Z |
4718232 | 4718232 | 20240728022648_KiVis | ES0013 | 2024-07-30T12:09:21.235Z | 2024-08-05T12:19:54.915Z |
4717358 | 4717358 | 20240728015727_Xe0PT | ES0013 | 2024-07-30T12:08:25.752Z | 2024-08-05T12:19:51.773Z |
4695639 | 4695639 | 20240726220900_9eAOK | ES0013 | 2024-07-28T12:01:30.387Z | 2024-08-04T12:19:07.463Z |
4689708 | 4689708 | 20240725221016_4P73n | ES0013 | 2024-07-27T12:01:29.378Z | 2024-08-03T12:21:03.362Z |
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);