home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

4,588 rows where station_code = "ES000E" sorted by created_at descending

✎ View and edit SQL

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
8028250 8028250 20250930234628_dwisr ES000E 2025-10-02T12:25:54.359Z 2025-10-09T12:38:43.199Z
8027274 8027274 20250930221318_QnfsD ES000E 2025-10-02T12:23:14.279Z 2025-10-09T12:38:13.038Z
8018170 8018170 20250930035730_Cfs3y ES000E 2025-10-01T12:28:17.890Z 2025-10-08T12:43:58.326Z
8018141 8018141 20250930034149_Ze4cc ES000E 2025-10-01T12:28:13.984Z 2025-10-08T12:43:53.078Z
8018116 8018116 20250930032748_4cvBc ES000E 2025-10-01T12:28:09.559Z 2025-10-08T12:43:49.215Z
8018086 8018086 20250930031217_mjsoA ES000E 2025-10-01T12:28:05.329Z 2025-10-08T12:43:44.530Z
8017988 8017988 20250930023438_faj2p ES000E 2025-10-01T12:27:42.177Z 2025-10-08T12:43:33.342Z
8017983 8017983 20250930022746_QU8aF ES000E 2025-10-01T12:27:40.451Z 2025-10-08T12:43:32.461Z
8017957 8017957 20250930021713_luFPH ES000E 2025-10-01T12:27:35.754Z 2025-10-08T12:43:27.536Z
8017818 8017818 20250930012747_Nvy5I ES000E 2025-10-01T12:27:13.685Z 2025-10-08T12:43:15.757Z
8016663 8016663 20250929222723_wjDPs ES000E 2025-10-01T12:24:19.556Z 2025-10-08T12:42:34.586Z
8016544 8016544 20250929221029_WrdDt ES000E 2025-10-01T12:23:53.343Z 2025-10-08T12:42:31.426Z
8015648 8015648 20250929191222_J98gP ES000E 2025-10-01T12:20:47.630Z 2025-10-08T12:42:10.449Z
8009824 8009824 20250929033357_DHmGx ES000E 2025-09-30T12:32:07.404Z 2025-10-07T13:01:20.439Z
8004466 8004466 20250928235353_HJ6RE ES000E 2025-09-30T12:22:42.261Z 2025-10-07T13:00:47.231Z
7989767 7989767 20250926041116_Dup8e ES000E 2025-09-28T12:36:51.654Z 2025-10-04T13:07:24.039Z
7985635 7985635 20250927034017_KgQ24 ES000E 2025-09-28T12:26:41.625Z 2025-10-05T13:11:17.495Z
7985490 7985490 20250927032820_SaLmb ES000E 2025-09-28T12:26:29.702Z 2025-10-05T13:11:16.577Z
7985152 7985152 20250927025513_0P27m ES000E 2025-09-28T12:25:51.043Z 2025-10-05T13:11:08.156Z
7984440 7984440 20250927013923_WjzfW ES000E 2025-09-28T12:24:18.687Z 2025-10-05T13:10:51.793Z
7984437 7984437 20250927013920_6msVy ES000E 2025-09-28T12:24:18.517Z 2025-10-05T13:10:51.561Z
7984182 7984182 20250927005802_f5yLF ES000E 2025-09-28T12:23:43.197Z 2025-10-05T13:10:48.206Z
7984087 7984087 20250927004457_4IczG ES000E 2025-09-28T12:23:35.411Z 2025-10-05T13:10:46.349Z
7983994 7983994 20250927002634_Bsk33 ES000E 2025-09-28T12:23:11.005Z 2025-10-05T13:10:44.421Z
7983934 7983934 20250927001557_4gMS3 ES000E 2025-09-28T12:23:06.484Z 2025-10-05T13:10:43.904Z
7983839 7983839 20250926235458_1N024 ES000E 2025-09-28T12:22:59.917Z 2025-10-05T13:10:43.658Z
7983781 7983781 20250926233705_I5382 ES000E 2025-09-28T12:22:54.745Z 2025-10-05T13:10:43.192Z
7983691 7983691 20250926231356_3qITv ES000E 2025-09-28T12:22:33.842Z 2025-10-05T13:10:42.658Z
7983518 7983518 20250926223109_kQRue ES000E 2025-09-28T12:22:16.970Z 2025-10-05T13:10:41.045Z
7982993 7982993 20250926202103_5UDjI ES000E 2025-09-28T12:21:03.169Z 2025-10-05T13:10:28.272Z
7982462 7982462 20250926190608_vv8bK ES000E 2025-09-28T12:19:52.044Z 2025-10-05T13:10:18.243Z
7976671 7976671 20250926043248_dqfkg ES000E 2025-09-28T12:06:02.294Z 2025-10-05T13:08:06.908Z
7960355 7960355 20250925003256_x50sQ ES000E 2025-09-26T12:24:30.173Z 2025-10-03T13:04:12.074Z
7957173 7957173 20250924202039_be6vD ES000E 2025-09-26T12:18:48.679Z 2025-10-03T13:03:57.391Z
7951143 7951143 20250924032427_fwLpH ES000E 2025-09-25T12:35:56.959Z 2025-10-02T13:28:09.261Z
7950898 7950898 20250924031124_3g79a ES000E 2025-09-25T12:35:33.742Z 2025-10-02T13:28:03.415Z
7950713 7950713 20250924030216_U8lri ES000E 2025-09-25T12:35:26.481Z 2025-10-02T13:28:01.144Z
7950541 7950541 20250924025216_f2F2b ES000E 2025-09-25T12:35:18.451Z 2025-09-25T12:36:35.033Z
7949928 7949928 20250924022145_dzJMj ES000E 2025-09-25T12:34:34.324Z 2025-10-02T13:27:41.811Z
7949106 7949106 20250924013408_MItRw ES000E 2025-09-25T12:33:19.821Z 2025-10-02T13:27:19.795Z
7948071 7948071 20250924003950_xC8pe ES000E 2025-09-25T12:31:33.353Z 2025-10-02T13:26:57.037Z
7946616 7946616 20250923231752_Ojajf ES000E 2025-09-25T12:29:11.752Z 2025-10-02T13:26:41.666Z
7937910 7937910 20250924040821_3Xea3 ES000E 2025-09-25T12:01:56.566Z 2025-10-03T13:02:31.279Z
7922218 7922218 20250923023500_XKn9O ES000E 2025-09-24T12:31:08.307Z 2025-10-01T13:24:53.951Z
7918678 7918678 20250922234105_3XFjN ES000E 2025-09-24T12:26:10.823Z 2025-10-01T13:24:10.164Z
7917528 7917528 20250922222547_AsXRM ES000E 2025-09-24T12:24:06.329Z 2025-10-01T13:23:52.759Z
7909363 7909363 20250923031347_BlsqP ES000E 2025-09-24T12:00:48.909Z 2025-10-02T13:22:18.504Z
7909333 7909333 20250923031230_3EiGs ES000E 2025-09-24T12:00:41.386Z 2025-10-02T13:22:18.026Z
7896200 7896200 20250920003909_uZ3I0 ES000E 2025-09-21T12:39:40.503Z 2025-09-28T12:54:47.771Z
7895236 7895236 20250919233610_DoPIl ES000E 2025-09-21T12:38:27.990Z 2025-09-28T12:54:39.964Z
7885620 7885620 20250920043144_qpXmW ES000E 2025-09-21T12:09:22.397Z 2025-09-29T13:03:17.788Z
7885584 7885584 20250920042048_NrdV3 ES000E 2025-09-21T12:09:15.899Z 2025-09-29T13:03:15.542Z
7885195 7885195 20250920031758_ZwSgN ES000E 2025-09-21T12:07:23.017Z 2025-09-29T13:03:03.304Z
7880603 7880603 20250918213839_OmvqV ES000E 2025-09-20T12:33:14.852Z 2025-09-27T12:47:38.784Z
7879802 7879802 20250918202737_wXA5D ES000E 2025-09-20T12:31:24.585Z 2025-09-27T12:47:36.259Z
7874303 7874303 20250919033547_91QQZ ES000E 2025-09-20T12:10:18.506Z 2025-09-28T12:53:17.874Z
7871551 7871551 20250917234532_2mak0 ES000E 2025-09-19T12:31:29.409Z 2025-09-25T13:13:09.209Z
7871425 7871425 20250917233431_ZtRPo ES000E 2025-09-19T12:31:22.001Z 2025-09-25T13:13:08.823Z
7871374 7871374 20250917232828_JTt3X ES000E 2025-09-19T12:31:18.360Z 2025-09-25T13:13:08.021Z
7870950 7870950 20250917224418_z29HA ES000E 2025-09-19T12:30:17.617Z 2025-09-25T13:13:01.876Z
7870849 7870849 20250917223403_Oi5jR ES000E 2025-09-19T12:29:49.635Z 2025-09-25T13:13:00.390Z
7870717 7870717 20250917221905_m2ZvB ES000E 2025-09-19T12:29:36.232Z 2025-09-25T13:12:59.524Z
7869727 7869727 20250917201355_pYz9k ES000E 2025-09-19T12:26:56.878Z 2025-09-25T13:12:47.078Z
7869524 7869524 20250917194747_CAsuk ES000E 2025-09-19T12:26:14.617Z 2025-09-25T13:12:44.227Z
7866124 7866124 20250918031506_z5erY ES000E 2025-09-19T12:09:02.329Z 2025-09-27T12:46:26.226Z
7865586 7865586 20250918022831_Li4AE ES000E 2025-09-19T12:06:41.893Z 2025-09-27T12:46:14.442Z
7865431 7865431 20250918021353_Abrv4 ES000E 2025-09-19T12:06:07.763Z 2025-09-27T12:46:10.600Z
7865429 7865429 20250918021326_oB95v ES000E 2025-09-19T12:06:07.348Z 2025-09-27T12:46:10.596Z
7865305 7865305 20250918020213_fbqjn ES000E 2025-09-19T12:05:40.406Z 2025-09-27T12:46:09.185Z
7864893 7864893 20250918013039_gwrtB ES000E 2025-09-19T12:03:38.442Z 2025-09-27T12:46:00.668Z
7854021 7854021 20250915192421_rPThv ES000E 2025-09-17T12:34:10.448Z 2025-09-22T13:05:25.596Z
7805962 7805962 20250911035414_KrRoD ES000E 2025-09-12T12:08:18.479Z 2025-09-19T12:57:09.011Z
7805937 7805937 20250911035043_S4LbF ES000E 2025-09-12T12:08:13.303Z 2025-09-19T12:57:08.394Z
7743872 7743872 20250902040018_51rTo ES000E 2025-09-03T12:24:20.784Z 2025-09-10T12:47:37.475Z
7742989 7742989 20250902025341_Lo3fM ES000E 2025-09-03T12:23:17.315Z 2025-09-10T12:47:32.011Z
7742392 7742392 20250902021852_W23Ao ES000E 2025-09-03T12:22:17.492Z 2025-09-10T12:47:18.065Z
7742305 7742305 20250902021305_D21Xs ES000E 2025-09-03T12:21:53.866Z 2025-09-10T12:47:13.650Z
7740777 7740777 20250902004529_BKQfc ES000E 2025-09-03T12:18:49.306Z 2025-09-10T12:46:38.773Z
7738288 7738288 20250901213259_PZGdZ ES000E 2025-09-03T12:12:06.339Z 2025-09-10T12:45:44.844Z
7059754 7059754 20250708023802_uiOT5 ES000E 2025-07-09T12:25:31.025Z 2025-07-16T12:46:46.159Z
7059128 7059128 20250708012322_n9DYM ES000E 2025-07-09T12:24:00.558Z 2025-07-16T12:46:29.768Z
7058745 7058745 20250708004809_hRjCX ES000E 2025-07-09T12:23:08.083Z 2025-07-16T12:46:13.625Z
7058545 7058545 20250708002937_V3eF1 ES000E 2025-07-09T12:22:28.984Z 2025-07-16T12:46:03.810Z
7058124 7058124 20250707234158_b5cxt ES000E 2025-07-09T12:21:07.827Z 2025-07-16T12:45:44.004Z
7042250 7042250 20250705020532_4Aci6 ES000E 2025-07-06T12:19:45.300Z 2025-07-13T12:50:07.779Z
7040697 7040697 20250704222315_rIdEd ES000E 2025-07-06T12:15:32.959Z 2025-07-13T12:48:50.338Z
7030401 7030401 20250704024634_6tuYr ES000E 2025-07-05T12:02:27.154Z 2025-07-13T12:46:14.408Z
7030352 7030352 20250704022421_3au7G ES000E 2025-07-05T12:02:15.391Z 2025-07-13T12:45:59.249Z
7026972 7026972 20250703030120_FdwZY ES000E 2025-07-04T12:06:09.282Z 2025-07-12T12:57:06.851Z
7026965 7026965 20250703024402_p2Dns ES000E 2025-07-04T12:06:07.680Z 2025-07-12T12:57:04.978Z
7026951 7026951 20250703023950_ZZiJ5 ES000E 2025-07-04T12:06:05.791Z 2025-07-12T12:57:01.320Z
7026847 7026847 20250703020640_0vce8 ES000E 2025-07-04T12:05:41.995Z 2025-07-12T12:56:51.627Z
7026845 7026845 20250703020638_O0sSQ ES000E 2025-07-04T12:05:41.614Z 2025-07-12T12:56:51.528Z
7026106 7026106 20250703011647_qYgck ES000E 2025-07-04T12:03:44.666Z 2025-07-12T12:56:29.533Z
7024325 7024325 20250701223938_MFsO8 ES000E 2025-07-03T12:21:47.964Z 2025-07-09T13:02:09.919Z
7022103 7022103 20250702030156_hFSX7 ES000E 2025-07-03T12:07:41.915Z 2025-07-10T12:25:47.855Z
7022055 7022055 20250702021502_kXcV3 ES000E 2025-07-03T12:07:30.606Z 2025-07-10T12:25:46.912Z
7021075 7021075 20250702002942_939cR ES000E 2025-07-03T12:03:54.717Z 2025-07-10T12:25:32.755Z
7020863 7020863 20250702001329_OxLq5 ES000E 2025-07-03T12:03:12.576Z 2025-07-10T12:25:28.654Z
7020708 7020708 20250701235801_ZCpV2 ES000E 2025-07-03T12:02:22.343Z 2025-07-10T12:25:27.204Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network