participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,106 rows where station_code = "ES0004" 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 |
---|---|---|---|---|---|
5133923 | 5133923 | 20240916041831_sbJ1D | ES0004 | 2024-09-19T12:17:13.201Z | 2024-09-19T12:17:13.201Z |
5133854 | 5133854 | 20240916041137_vfmWB | ES0004 | 2024-09-19T12:17:10.587Z | 2024-09-19T12:17:10.587Z |
5133730 | 5133730 | 20240916035925_tbTn0 | ES0004 | 2024-09-19T12:17:06.670Z | 2024-09-19T12:17:06.670Z |
5133549 | 5133549 | 20240916033920_fP33f | ES0004 | 2024-09-19T12:17:01.423Z | 2024-09-19T12:17:01.423Z |
5133315 | 5133315 | 20240916032119_1rvmu | ES0004 | 2024-09-19T12:16:54.311Z | 2024-09-19T12:16:54.311Z |
5133090 | 5133090 | 20240916025114_gqTX4 | ES0004 | 2024-09-19T12:16:43.977Z | 2024-09-19T12:16:43.977Z |
5132929 | 5132929 | 20240916022945_jgrGB | ES0004 | 2024-09-19T12:16:36.443Z | 2024-09-19T12:16:36.443Z |
5131993 | 5131993 | 20240915223306_akOz2 | ES0004 | 2024-09-19T12:15:41.426Z | 2024-09-19T12:15:41.426Z |
5131840 | 5131840 | 20240915213903_22Z9s | ES0004 | 2024-09-19T12:15:27.964Z | 2024-09-19T12:15:27.964Z |
5128279 | 5128279 | 20240917011930_E6GJO | ES0004 | 2024-09-19T12:10:24.613Z | 2024-09-19T12:10:24.613Z |
5128241 | 5128241 | 20240917010850_goJvt | ES0004 | 2024-09-19T12:10:21.418Z | 2024-09-19T12:10:21.418Z |
5127620 | 5127620 | 20240916223652_Ezcjn | ES0004 | 2024-09-19T12:09:26.826Z | 2024-09-19T12:09:26.826Z |
5127618 | 5127618 | 20240916223619_s22t1 | ES0004 | 2024-09-19T12:09:26.468Z | 2024-09-19T12:09:26.468Z |
5121597 | 5121597 | 20240914041018_CSF48 | ES0004 | 2024-09-18T12:10:58.822Z | 2024-09-19T12:20:02.180Z |
5120223 | 5120223 | 20240914030801_jpaz2 | ES0004 | 2024-09-18T12:10:35.324Z | 2024-09-19T12:19:59.709Z |
5119651 | 5119651 | 20240914024257_hQ7GS | ES0004 | 2024-09-18T12:10:22.994Z | 2024-09-19T12:19:58.651Z |
5119163 | 5119163 | 20240914021448_dm9Vv | ES0004 | 2024-09-18T12:10:17.522Z | 2024-09-19T12:19:57.319Z |
5117457 | 5117457 | 20240915043528_C3ktx | ES0004 | 2024-09-18T12:07:42.031Z | 2024-09-19T12:19:15.135Z |
5117434 | 5117434 | 20240915043327_2pmIu | ES0004 | 2024-09-18T12:07:41.550Z | 2024-09-19T12:19:15.091Z |
5114971 | 5114971 | 20240915021230_JveNH | ES0004 | 2024-09-18T12:05:47.907Z | 2024-09-19T12:19:00.919Z |
5113548 | 5113548 | 20240915005747_IWPPh | ES0004 | 2024-09-18T12:04:28.639Z | 2024-09-19T12:18:50.292Z |
5112922 | 5112922 | 20240915000612_P2UrQ | ES0004 | 2024-09-18T12:03:47.320Z | 2024-09-19T12:18:45.864Z |
5112711 | 5112711 | 20240914234325_GbaBa | ES0004 | 2024-09-18T12:03:23.697Z | 2024-09-19T12:18:43.556Z |
5112192 | 5112192 | 20240914223529_pAshk | ES0004 | 2024-09-18T12:02:52.526Z | 2024-09-19T12:18:38.989Z |
5111955 | 5111955 | 20240914214656_ZmUnR | ES0004 | 2024-09-18T12:02:32.634Z | 2024-09-19T12:18:35.616Z |
5110949 | 5110949 | 20240914193111_AIhHW | ES0004 | 2024-09-18T12:01:13.618Z | 2024-09-19T12:18:24.894Z |
5107686 | 5107686 | 20240913040808_B32D3 | ES0004 | 2024-09-17T12:13:21.421Z | 2024-09-19T12:20:47.453Z |
5107568 | 5107568 | 20240913040140_zvpI3 | ES0004 | 2024-09-17T12:13:17.160Z | 2024-09-19T12:20:47.253Z |
5106190 | 5106190 | 20240913031533_YmHlr | ES0004 | 2024-09-17T12:12:44.556Z | 2024-09-19T12:20:45.623Z |
5105815 | 5105815 | 20240913025932_ezQOj | ES0004 | 2024-09-17T12:12:29.609Z | 2024-09-19T12:20:44.950Z |
5105599 | 5105599 | 20240913025302_myBJU | ES0004 | 2024-09-17T12:12:23.250Z | 2024-09-19T12:20:44.719Z |
5103887 | 5103887 | 20240913014300_WkH9P | ES0004 | 2024-09-17T12:11:15.346Z | 2024-09-19T12:20:40.653Z |
5103737 | 5103737 | 20240913013825_o6MEF | ES0004 | 2024-09-17T12:11:09.494Z | 2024-09-19T12:20:40.441Z |
5103118 | 5103118 | 20240914020110_fBHXO | ES0004 | 2024-09-17T12:07:52.391Z | 2024-09-19T12:19:56.636Z |
5101903 | 5101903 | 20240914005502_SuIji | ES0004 | 2024-09-17T12:06:22.838Z | 2024-09-19T12:19:51.855Z |
5100335 | 5100335 | 20240913232119_jpd4q | ES0004 | 2024-09-17T12:04:28.921Z | 2024-09-19T12:19:47.812Z |
5099248 | 5099248 | 20240913204606_1QCxd | ES0004 | 2024-09-17T12:02:34.641Z | 2024-09-19T12:19:44.252Z |
5098783 | 5098783 | 20240913192757_lVTK4 | ES0004 | 2024-09-17T12:01:35.563Z | 2024-09-19T12:19:41.068Z |
5098042 | 5098042 | 20240913011432_rb32E | ES0004 | 2024-09-16T12:17:18.960Z | 2024-09-19T12:20:39.555Z |
5086490 | 5086490 | 20240912223708_7VpW5 | ES0004 | 2024-09-16T12:05:48.671Z | 2024-09-19T12:20:31.313Z |
5080011 | 5080011 | 20240911032629_Axg31 | ES0004 | 2024-09-15T12:16:45.202Z | 2024-09-19T12:21:42.988Z |
5079144 | 5079144 | 20240911023436_NLI9q | ES0004 | 2024-09-15T12:16:08.079Z | 2024-09-19T12:21:41.163Z |
5078650 | 5078650 | 20240911020801_A6wwG | ES0004 | 2024-09-15T12:15:47.961Z | 2024-09-19T12:21:40.646Z |
5077849 | 5077849 | 20240911012242_WFjLl | ES0004 | 2024-09-15T12:15:07.951Z | 2024-09-19T12:21:39.747Z |
5077493 | 5077493 | 20240911005931_ytUx0 | ES0004 | 2024-09-15T12:14:49.022Z | 2024-09-19T12:21:39.279Z |
5077021 | 5077021 | 20240911002205_wau3H | ES0004 | 2024-09-15T12:14:18.179Z | 2024-09-19T12:21:37.966Z |
5065331 | 5065331 | 20240910034614_6S6eb | ES0004 | 2024-09-14T12:17:00.056Z | 2024-09-18T12:15:19.075Z |
5065284 | 5065284 | 20240910033654_a3qcF | ES0004 | 2024-09-14T12:16:52.884Z | 2024-09-18T12:15:18.923Z |
5065061 | 5065061 | 20240910025942_xXUzI | ES0004 | 2024-09-14T12:16:21.372Z | 2024-09-18T12:15:18.286Z |
5064923 | 5064923 | 20240910023303_rhcVx | ES0004 | 2024-09-14T12:16:10.169Z | 2024-09-18T12:15:17.782Z |
5064912 | 5064912 | 20240910022905_vNR2o | ES0004 | 2024-09-14T12:16:09.665Z | 2024-09-18T12:15:17.764Z |
5064839 | 5064839 | 20240910021411_ytOqC | ES0004 | 2024-09-14T12:16:05.704Z | 2024-09-18T12:15:17.499Z |
5064776 | 5064776 | 20240910020317_fMzlN | ES0004 | 2024-09-14T12:16:01.348Z | 2024-09-18T12:15:17.328Z |
5064768 | 5064768 | 20240910020045_G8b1n | ES0004 | 2024-09-14T12:16:00.714Z | 2024-09-18T12:15:17.297Z |
5064548 | 5064548 | 20240910013106_JsNoy | ES0004 | 2024-09-14T12:15:38.391Z | 2024-09-18T12:15:16.827Z |
5064539 | 5064539 | 20240910012911_3WBIq | ES0004 | 2024-09-14T12:15:36.755Z | 2024-09-18T12:15:16.817Z |
5064431 | 5064431 | 20240910010726_FneHo | ES0004 | 2024-09-14T12:15:26.731Z | 2024-09-18T12:15:16.629Z |
5064421 | 5064421 | 20240910010245_Zdeu8 | ES0004 | 2024-09-14T12:15:26.128Z | 2024-09-18T12:15:16.608Z |
5064204 | 5064204 | 20240910002256_IC2F1 | ES0004 | 2024-09-14T12:15:03.993Z | 2024-09-18T12:15:15.786Z |
5064198 | 5064198 | 20240910002050_kuN2h | ES0004 | 2024-09-14T12:15:03.454Z | 2024-09-18T12:15:15.779Z |
5064175 | 5064175 | 20240910001651_Doe6G | ES0004 | 2024-09-14T12:15:02.377Z | 2024-09-18T12:15:15.745Z |
5063212 | 5063212 | 20240909201959_r3zpT | ES0004 | 2024-09-14T12:13:42.460Z | 2024-09-18T12:15:13.411Z |
5047475 | 5047475 | 20240909042336_wYtWU | ES0004 | 2024-09-13T12:09:07.823Z | 2024-09-17T12:19:02.786Z |
5047459 | 5047459 | 20240909041505_wnLcw | ES0004 | 2024-09-13T12:09:02.625Z | 2024-09-17T12:19:02.686Z |
5047381 | 5047381 | 20240909034628_F7Evt | ES0004 | 2024-09-13T12:08:54.444Z | 2024-09-17T12:19:02.243Z |
5047338 | 5047338 | 20240909033130_23JUB | ES0004 | 2024-09-13T12:08:49.420Z | 2024-09-17T12:19:02.078Z |
5047311 | 5047311 | 20240909032706_Lzvcb | ES0004 | 2024-09-13T12:08:46.764Z | 2024-09-17T12:19:01.982Z |
5047281 | 5047281 | 20240909032254_32MbM | ES0004 | 2024-09-13T12:08:44.596Z | 2024-09-17T12:19:01.913Z |
5047178 | 5047178 | 20240909025723_Hq34t | ES0004 | 2024-09-13T12:08:35.802Z | 2024-09-17T12:19:01.459Z |
5047090 | 5047090 | 20240909023636_wx3Ry | ES0004 | 2024-09-13T12:08:16.369Z | 2024-09-17T12:19:01.080Z |
5046965 | 5046965 | 20240909020146_T531Y | ES0004 | 2024-09-13T12:08:01.886Z | 2024-09-17T12:19:00.657Z |
5046945 | 5046945 | 20240909015622_3QFdY | ES0004 | 2024-09-13T12:07:59.945Z | 2024-09-17T12:19:00.638Z |
5046802 | 5046802 | 20240909012453_yoxXa | ES0004 | 2024-09-13T12:07:33.392Z | 2024-09-17T12:19:00.383Z |
5046792 | 5046792 | 20240909012316_Vbg5T | ES0004 | 2024-09-13T12:07:32.005Z | 2024-09-17T12:19:00.326Z |
5046746 | 5046746 | 20240909011058_gpIPh | ES0004 | 2024-09-13T12:07:26.132Z | 2024-09-17T12:19:00.225Z |
5046619 | 5046619 | 20240909002645_BIgqT | ES0004 | 2024-09-13T12:07:08.865Z | 2024-09-17T12:18:59.622Z |
5046452 | 5046452 | 20240908233810_JVqFk | ES0004 | 2024-09-13T12:06:43.485Z | 2024-09-17T12:18:59.369Z |
5046402 | 5046402 | 20240908231725_J5QGw | ES0004 | 2024-09-13T12:06:38.425Z | 2024-09-17T12:18:59.331Z |
5046048 | 5046048 | 20240908205458_Ejm3b | ES0004 | 2024-09-13T12:05:40.108Z | 2024-09-17T12:18:58.450Z |
5045945 | 5045945 | 20240908201530_jI0Mb | ES0004 | 2024-09-13T12:05:25.833Z | 2024-09-17T12:18:58.244Z |
5032442 | 5032442 | 20240907010256_RrzhI | ES0004 | 2024-09-12T12:07:18.699Z | 2024-09-15T12:21:26.464Z |
5026243 | 5026243 | 20240905024704_IycH3 | ES0004 | 2024-09-11T12:12:07.524Z | 2024-09-13T12:19:57.265Z |
5020689 | 5020689 | 20240905024704_qgvs2 | ES0004 | 2024-09-10T12:14:56.591Z | 2024-09-10T12:16:55.216Z |
5006944 | 5006944 | 20240903193323_EG0Lt | ES0004 | 2024-09-09T12:05:14.727Z | 2024-09-12T12:19:10.939Z |
5001306 | 5001306 | 20240902042009_InzGg | ES0004 | 2024-09-08T12:16:18.891Z | 2024-09-10T12:19:32.799Z |
5001297 | 5001297 | 20240902041732_UV4Iv | ES0004 | 2024-09-08T12:16:18.526Z | 2024-09-10T12:19:32.761Z |
5001264 | 5001264 | 20240902040619_a3CEF | ES0004 | 2024-09-08T12:16:17.344Z | 2024-09-10T12:19:32.641Z |
5001244 | 5001244 | 20240902035848_ufmi2 | ES0004 | 2024-09-08T12:16:16.353Z | 2024-09-10T12:19:32.508Z |
5001238 | 5001238 | 20240902035717_xu38p | ES0004 | 2024-09-08T12:16:16.007Z | 2024-09-10T12:19:32.493Z |
5001137 | 5001137 | 20240902033653_66J65 | ES0004 | 2024-09-08T12:16:11.449Z | 2024-09-10T12:19:32.036Z |
5001087 | 5001087 | 20240902033043_saP9l | ES0004 | 2024-09-08T12:16:09.483Z | 2024-09-10T12:19:31.654Z |
5000844 | 5000844 | 20240902025446_0ai5z | ES0004 | 2024-09-08T12:15:55.802Z | 2024-09-10T12:19:30.008Z |
5000827 | 5000827 | 20240902025108_4egmZ | ES0004 | 2024-09-08T12:15:50.664Z | 2024-09-10T12:19:29.912Z |
5000708 | 5000708 | 20240902024140_x64ib | ES0004 | 2024-09-08T12:15:37.435Z | 2024-09-10T12:19:29.517Z |
5000361 | 5000361 | 20240902020445_kDNnb | ES0004 | 2024-09-08T12:15:21.468Z | 2024-09-10T12:19:26.815Z |
5000197 | 5000197 | 20240902014317_BjJb8 | ES0004 | 2024-09-08T12:15:15.273Z | 2024-09-10T12:19:25.900Z |
5000112 | 5000112 | 20240902013445_XTOWk | ES0004 | 2024-09-08T12:15:11.360Z | 2024-09-10T12:19:24.946Z |
4999635 | 4999635 | 20240902004314_fx7mI | ES0004 | 2024-09-08T12:14:38.705Z | 2024-09-10T12:19:21.378Z |
4979359 | 4979359 | 20240812000120_C1DpV | ES0004 | 2024-09-06T12:13:11.575Z | 2024-09-06T12:13:11.575Z |
4978911 | 4978911 | 20240811235634_fXG8C | ES0004 | 2024-09-06T12:12:44.985Z | 2024-09-06T12:12:44.985Z |
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);