participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,912 rows where station_code = "ES0001" 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 |
---|---|---|---|---|---|
5505417 | 5505417 | 20241108051316_QuEOA | ES0001 | 2024-11-09T14:16:16.682Z | 2024-11-09T14:16:28.779Z |
5505207 | 5505207 | 20241108040804_UN6fn | ES0001 | 2024-11-09T14:15:55.795Z | 2024-11-09T14:16:28.725Z |
5505081 | 5505081 | 20241108035019_1SnGe | ES0001 | 2024-11-09T14:15:42.362Z | 2024-11-09T14:16:28.697Z |
5505023 | 5505023 | 20241108033619_3d6BP | ES0001 | 2024-11-09T14:15:35.597Z | 2024-11-09T14:16:28.682Z |
5504997 | 5504997 | 20241108033020_Vo85U | ES0001 | 2024-11-09T14:15:32.938Z | 2024-11-09T14:16:28.676Z |
5504823 | 5504823 | 20241108030302_kx59U | ES0001 | 2024-11-09T14:15:14.085Z | 2024-11-09T14:16:28.635Z |
5504555 | 5504555 | 20241108021447_Ep3WL | ES0001 | 2024-11-09T14:14:50.893Z | 2024-11-09T14:16:28.569Z |
5504472 | 5504472 | 20241108020317_FUJdy | ES0001 | 2024-11-09T14:14:41.541Z | 2024-11-09T14:16:28.547Z |
5504470 | 5504470 | 20241108020253_sXZbO | ES0001 | 2024-11-09T14:14:41.517Z | 2024-11-09T14:16:28.546Z |
5504385 | 5504385 | 20241108015022_fsE37 | ES0001 | 2024-11-09T14:14:30.434Z | 2024-11-09T14:16:28.523Z |
5504149 | 5504149 | 20241108010505_bJQQz | ES0001 | 2024-11-09T14:14:08.657Z | 2024-11-09T14:16:28.461Z |
5504001 | 5504001 | 20241108003842_1K9nP | ES0001 | 2024-11-09T14:13:57.924Z | 2024-11-09T14:16:28.424Z |
5503901 | 5503901 | 20241108000946_nzqDP | ES0001 | 2024-11-09T14:13:50.444Z | 2024-11-09T14:16:28.387Z |
5503109 | 5503109 | 20241107204244_DLWN5 | ES0001 | 2024-11-09T14:12:25.501Z | 2024-11-09T14:16:28.168Z |
5502920 | 5502920 | 20241107201144_332JY | ES0001 | 2024-11-09T14:12:12.485Z | 2024-11-09T14:16:28.128Z |
5502880 | 5502880 | 20241107200348_CupDv | ES0001 | 2024-11-09T14:12:10.297Z | 2024-11-09T14:16:28.118Z |
5491116 | 5491116 | 20241106020257_yIwWh | ES0001 | 2024-11-07T14:15:19.726Z | 2024-11-09T14:20:04.123Z |
5490951 | 5490951 | 20241106012218_jFir1 | ES0001 | 2024-11-07T14:15:07.541Z | 2024-11-09T14:20:02.269Z |
5490787 | 5490787 | 20241106003859_277Si | ES0001 | 2024-11-07T14:14:55.886Z | 2024-11-09T14:19:59.571Z |
5490768 | 5490768 | 20241106003237_D69v6 | ES0001 | 2024-11-07T14:14:52.348Z | 2024-11-09T14:19:59.384Z |
5490702 | 5490702 | 20241106001343_EwmiG | ES0001 | 2024-11-07T14:14:35.227Z | 2024-11-09T14:19:58.660Z |
5490543 | 5490543 | 20241105231854_MoZ8p | ES0001 | 2024-11-07T14:14:11.014Z | 2024-11-09T14:19:56.786Z |
5490529 | 5490529 | 20241105231644_rmLCT | ES0001 | 2024-11-07T14:14:09.598Z | 2024-11-09T14:19:56.684Z |
5490244 | 5490244 | 20241105214635_zc82Z | ES0001 | 2024-11-07T14:13:42.784Z | 2024-11-09T14:19:53.113Z |
5490136 | 5490136 | 20241105212000_GjWu1 | ES0001 | 2024-11-07T14:13:18.678Z | 2024-11-09T14:19:51.290Z |
5470030 | 5470030 | 20241103051204_kC2cc | ES0001 | 2024-11-04T14:17:37.180Z | 2024-11-09T14:23:04.848Z |
5470002 | 5470002 | 20241103050515_GCvM9 | ES0001 | 2024-11-04T14:17:32.881Z | 2024-11-09T14:23:04.627Z |
5469885 | 5469885 | 20241103043603_ykTKy | ES0001 | 2024-11-04T14:17:14.536Z | 2024-11-09T14:23:04.176Z |
5469373 | 5469373 | 20241103031924_7QQ2Q | ES0001 | 2024-11-04T14:16:22.699Z | 2024-11-09T14:23:02.304Z |
5469329 | 5469329 | 20241103031145_FUddP | ES0001 | 2024-11-04T14:16:20.366Z | 2024-11-09T14:23:02.162Z |
5468892 | 5468892 | 20241103020603_u7Wxn | ES0001 | 2024-11-04T14:15:12.042Z | 2024-11-09T14:23:00.240Z |
5468541 | 5468541 | 20241103005403_n9VNp | ES0001 | 2024-11-04T14:14:23.543Z | 2024-11-09T14:22:58.722Z |
5462913 | 5462913 | 20241102015611_hDqy3 | ES0001 | 2024-11-03T14:18:09.799Z | 2024-11-09T14:23:36.826Z |
5462686 | 5462686 | 20241102011044_LIKp1 | ES0001 | 2024-11-03T14:17:55.300Z | 2024-11-09T14:23:35.453Z |
5462181 | 5462181 | 20241101231709_uoKUy | ES0001 | 2024-11-03T14:17:02.387Z | 2024-11-09T14:23:33.018Z |
5461777 | 5461777 | 20241101212242_Gppgx | ES0001 | 2024-11-03T14:16:15.079Z | 2024-11-09T14:23:31.245Z |
5461696 | 5461696 | 20241101205234_YkzG9 | ES0001 | 2024-11-03T14:16:04.995Z | 2024-11-09T14:23:30.610Z |
5461487 | 5461487 | 20241101191643_DvsLe | ES0001 | 2024-11-03T14:15:49.830Z | 2024-11-09T14:23:29.553Z |
5461421 | 5461421 | 20241101185401_RIjCm | ES0001 | 2024-11-03T14:15:39.015Z | 2024-11-09T14:23:28.773Z |
5461399 | 5461399 | 20241101184509_iYkjU | ES0001 | 2024-11-03T14:15:32.631Z | 2024-11-09T14:23:28.716Z |
5452773 | 5452773 | 20241101042709_WCoWZ | ES0001 | 2024-11-02T12:19:21.206Z | 2024-11-09T14:24:33.596Z |
5452488 | 5452488 | 20241101032425_CiYvg | ES0001 | 2024-11-02T12:18:52.520Z | 2024-11-09T14:24:31.267Z |
5452155 | 5452155 | 20241101021135_6XYP3 | ES0001 | 2024-11-02T12:18:21.296Z | 2024-11-09T14:24:28.502Z |
5452009 | 5452009 | 20241101014400_xFQs5 | ES0001 | 2024-11-02T12:18:10.892Z | 2024-11-09T14:24:27.601Z |
5451980 | 5451980 | 20241101013940_b9xOm | ES0001 | 2024-11-02T12:18:09.389Z | 2024-11-09T14:24:27.416Z |
5451815 | 5451815 | 20241101011011_O9G7E | ES0001 | 2024-11-02T12:17:59.172Z | 2024-11-09T14:24:25.570Z |
5451595 | 5451595 | 20241101002630_XUnqP | ES0001 | 2024-11-02T12:17:39.020Z | 2024-11-09T14:24:24.426Z |
5451449 | 5451449 | 20241031235727_EPZsS | ES0001 | 2024-11-02T12:17:11.431Z | 2024-11-09T14:24:23.682Z |
5451428 | 5451428 | 20241031235512_117Er | ES0001 | 2024-11-02T12:17:08.950Z | 2024-11-09T14:24:23.600Z |
5450940 | 5450940 | 20241031215828_hyt8U | ES0001 | 2024-11-02T12:16:20.146Z | 2024-11-09T14:24:20.252Z |
5450907 | 5450907 | 20241031213735_Tzl97 | ES0001 | 2024-11-02T12:16:14.914Z | 2024-11-09T14:24:19.907Z |
5450648 | 5450648 | 20241031201030_dRJmj | ES0001 | 2024-11-02T12:15:41.832Z | 2024-11-09T14:24:17.387Z |
5450566 | 5450566 | 20241031195150_LgGY8 | ES0001 | 2024-11-02T12:15:36.015Z | 2024-11-09T14:24:16.761Z |
5432868 | 5432868 | 20241029050248_dKr4k | ES0001 | 2024-10-31T12:21:37.219Z | 2024-11-06T14:27:29.069Z |
5432723 | 5432723 | 20241029042640_l48UZ | ES0001 | 2024-10-31T12:21:32.664Z | 2024-11-06T14:27:28.567Z |
5432191 | 5432191 | 20241029025348_Kv78U | ES0001 | 2024-10-31T12:21:11.209Z | 2024-11-06T14:27:26.209Z |
5432163 | 5432163 | 20241029024938_ZX8c3 | ES0001 | 2024-10-31T12:21:08.482Z | 2024-11-06T14:27:26.156Z |
5431816 | 5431816 | 20241029020140_M38xu | ES0001 | 2024-10-31T12:20:42.015Z | 2024-11-06T14:27:24.950Z |
5375988 | 5375988 | 20241024033713_2S3TE | ES0001 | 2024-10-26T12:21:45.766Z | 2024-11-01T12:27:01.306Z |
5374479 | 5374479 | 20241024022921_4VcgI | ES0001 | 2024-10-26T12:20:50.738Z | 2024-11-01T12:26:59.442Z |
5372759 | 5372759 | 20241024010630_Jo4YO | ES0001 | 2024-10-26T12:19:41.907Z | 2024-11-01T12:26:57.909Z |
5362638 | 5362638 | 20241023194950_GjOji | ES0001 | 2024-10-25T12:14:53.953Z | 2024-11-01T12:26:52.163Z |
5361774 | 5361774 | 20241023184304_EIjWE | ES0001 | 2024-10-25T12:13:28.242Z | 2024-11-01T12:26:50.528Z |
5352376 | 5352376 | 20241023002946_pEgSp | ES0001 | 2024-10-24T12:18:42.680Z | 2024-10-31T12:30:02.567Z |
5326715 | 5326715 | 20241019195044_ZbtRe | ES0001 | 2024-10-21T12:10:11.917Z | 2024-10-28T12:26:42.340Z |
5326634 | 5326634 | 20241019192116_EMrcU | ES0001 | 2024-10-21T12:10:03.889Z | 2024-10-28T12:26:42.184Z |
5323077 | 5323077 | 20241018194300_dMPwR | ES0001 | 2024-10-20T12:04:55.353Z | 2024-10-27T12:28:49.372Z |
5323051 | 5323051 | 20241018185947_5kUU2 | ES0001 | 2024-10-20T12:04:51.155Z | 2024-10-27T12:28:49.339Z |
5323038 | 5323038 | 20241018183531_AgWXQ | ES0001 | 2024-10-20T12:04:48.681Z | 2024-10-27T12:28:49.153Z |
5302871 | 5302871 | 20241013015405_XcmfE | ES0001 | 2024-10-14T12:16:52.559Z | 2024-10-21T12:24:13.717Z |
5301672 | 5301672 | 20241012235345_pmmmz | ES0001 | 2024-10-14T12:15:34.499Z | 2024-10-21T12:23:59.916Z |
5300664 | 5300664 | 20241012211655_zaU7y | ES0001 | 2024-10-14T12:14:21.221Z | 2024-10-21T12:23:51.413Z |
5283885 | 5283885 | 20241011020235_mwYJ2 | ES0001 | 2024-10-12T12:17:00.669Z | 2024-10-19T12:27:53.274Z |
5283641 | 5283641 | 20241011014137_CQGUx | ES0001 | 2024-10-12T12:16:49.090Z | 2024-10-19T12:27:52.282Z |
5283454 | 5283454 | 20241011012748_e5ZWM | ES0001 | 2024-10-12T12:16:43.158Z | 2024-10-19T12:27:51.672Z |
5283139 | 5283139 | 20241011005428_3AaiQ | ES0001 | 2024-10-12T12:16:25.703Z | 2024-10-19T12:27:49.356Z |
5282765 | 5282765 | 20241010233415_ijsMV | ES0001 | 2024-10-12T12:16:01.943Z | 2024-10-19T12:27:46.509Z |
5282190 | 5282190 | 20241010202942_n6lez | ES0001 | 2024-10-12T12:15:17.073Z | 2024-10-19T12:27:42.326Z |
5281512 | 5281512 | 20241010184241_r8w2N | ES0001 | 2024-10-12T12:14:15.607Z | 2024-10-19T12:27:33.962Z |
5275275 | 5275275 | 20241010014053_zMW0e | ES0001 | 2024-10-11T12:15:37.481Z | 2024-10-18T12:22:15.832Z |
5269174 | 5269174 | 20241010043746_iJidk | ES0001 | 2024-10-11T12:00:51.027Z | 2024-10-19T12:26:47.512Z |
5269172 | 5269172 | 20241010043600_i0PAm | ES0001 | 2024-10-11T12:00:50.487Z | 2024-10-19T12:26:47.477Z |
5269007 | 5269007 | 20241010035406_Wd3qD | ES0001 | 2024-10-11T12:00:11.415Z | 2024-10-19T12:26:45.537Z |
5262693 | 5262693 | 20241008021111_kXNfl | ES0001 | 2024-10-09T12:16:07.463Z | 2024-10-16T12:21:19.740Z |
5248188 | 5248188 | 20241007040327_lrnFp | ES0001 | 2024-10-08T12:01:43.964Z | 2024-10-16T12:20:58.505Z |
5244086 | 5244086 | 20241005191814_TUWId | ES0001 | 2024-10-07T12:14:28.097Z | 2024-10-14T12:24:32.648Z |
5238908 | 5238908 | 20241005031033_cB52f | ES0001 | 2024-10-07T12:05:26.980Z | 2024-10-14T12:24:17.537Z |
5238701 | 5238701 | 20241005025227_A9q86 | ES0001 | 2024-10-07T12:04:54.955Z | 2024-10-14T12:24:17.022Z |
5238698 | 5238698 | 20241005025224_MYqMJ | ES0001 | 2024-10-07T12:04:54.716Z | 2024-10-14T12:24:17.022Z |
5235222 | 5235222 | 20241004230715_e28EQ | ES0001 | 2024-10-06T12:15:55.489Z | 2024-10-13T12:26:24.056Z |
5234573 | 5234573 | 20241004215320_uTy4n | ES0001 | 2024-10-06T12:15:00.816Z | 2024-10-13T12:26:22.632Z |
5234180 | 5234180 | 20241004210747_3Ke2u | ES0001 | 2024-10-06T12:14:41.338Z | 2024-10-13T12:26:22.311Z |
5233881 | 5233881 | 20241004202400_J3w3D | ES0001 | 2024-10-06T12:14:00.310Z | 2024-10-13T12:26:21.653Z |
5227466 | 5227466 | 20241004012550_zjIQY | ES0001 | 2024-10-05T12:21:32.423Z | 2024-10-12T12:25:12.772Z |
5226403 | 5226403 | 20241004001148_kyaFt | ES0001 | 2024-10-05T12:20:40.988Z | 2024-10-12T12:25:11.662Z |
5224861 | 5224861 | 20241003213428_F2TLY | ES0001 | 2024-10-05T12:19:08.209Z | 2024-10-12T12:25:09.083Z |
5224742 | 5224742 | 20241003211857_YHKHA | ES0001 | 2024-10-05T12:19:01.918Z | 2024-10-12T12:25:08.889Z |
5224740 | 5224740 | 20241003211812_XSD0m | ES0001 | 2024-10-05T12:19:01.794Z | 2024-10-12T12:25:08.887Z |
5219159 | 5219159 | 20241004045000_Evuyr | ES0001 | 2024-10-05T12:06:13.332Z | 2024-10-13T12:26:09.820Z |
5219142 | 5219142 | 20241004044646_XCW3B | ES0001 | 2024-10-05T12:06:11.666Z | 2024-10-13T12:26:09.766Z |
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);