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

3,943 rows where station_code = "ES0013" 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
8687124 8687124 20251204045333_sVnci ES0013 2025-12-05T14:13:56.923Z 2025-12-05T14:14:35.628Z
8687120 8687120 20251204044734_jei6X ES0013 2025-12-05T14:13:56.253Z 2025-12-05T14:14:35.626Z
8687118 8687118 20251204044532_PYScC ES0013 2025-12-05T14:13:55.829Z 2025-12-05T14:14:35.625Z
8687100 8687100 20251204035742_M5q9w ES0013 2025-12-05T14:13:53.489Z 2025-12-05T14:14:35.619Z
8687098 8687098 20251204035505_07CnP ES0013 2025-12-05T14:13:53.064Z 2025-12-05T14:14:35.618Z
8687094 8687094 20251204034409_0QJYQ ES0013 2025-12-05T14:13:52.454Z 2025-12-05T14:14:35.616Z
8687082 8687082 20251204032001_vrk2N ES0013 2025-12-05T14:13:50.405Z 2025-12-05T14:14:35.608Z
8687068 8687068 20251204030427_l2wyY ES0013 2025-12-05T14:13:47.790Z 2025-12-05T14:14:35.601Z
8680473 8680473 20251203001527_PG8f4 ES0013 2025-12-04T14:12:06.663Z 2025-12-05T14:20:40.068Z
8680347 8680347 20251202233124_8m2a3 ES0013 2025-12-04T14:11:49.509Z 2025-12-05T14:20:35.012Z
8673752 8673752 20251201222156_UivSj ES0013 2025-12-03T14:19:57.605Z 2025-12-05T14:27:03.549Z
8673563 8673563 20251201200637_j82YZ ES0013 2025-12-03T14:19:18.996Z 2025-12-05T14:26:53.006Z
8654137 8654137 20251130030059_GQIB4 ES0013 2025-12-01T14:24:54.240Z 2025-12-05T14:43:47.798Z
8653697 8653697 20251130023552_LD6uM ES0013 2025-12-01T14:23:57.042Z 2025-12-05T14:43:38.056Z
8651862 8651862 20251130002751_PY63e ES0013 2025-12-01T14:20:08.500Z 2025-12-05T14:42:08.034Z
8651151 8651151 20251129225216_HSvWF ES0013 2025-12-01T14:18:08.447Z 2025-12-05T14:41:50.336Z
8647790 8647790 20251129053246_rLC7I ES0013 2025-11-30T14:28:54.384Z 2025-12-05T14:52:47.792Z
8647096 8647096 20251129034254_Z444o ES0013 2025-11-30T14:27:35.218Z 2025-12-05T14:52:32.881Z
8646919 8646919 20251129031159_erklU ES0013 2025-11-30T14:27:07.952Z 2025-12-05T14:51:59.806Z
8646907 8646907 20251129031006_9oT5x ES0013 2025-11-30T14:27:06.641Z 2025-12-05T14:51:57.238Z
8646905 8646905 20251129030949_WPJac ES0013 2025-11-30T14:27:06.465Z 2025-12-05T14:51:56.957Z
8646896 8646896 20251129030845_V2032 ES0013 2025-11-30T14:27:05.770Z 2025-12-05T14:51:56.658Z
8646874 8646874 20251129030529_bgpxQ ES0013 2025-11-30T14:27:03.850Z 2025-12-05T14:51:55.877Z
8646872 8646872 20251129030456_LWuw3 ES0013 2025-11-30T14:27:03.721Z 2025-12-05T14:51:55.846Z
8646721 8646721 20251129024248_8JAgq ES0013 2025-11-30T14:26:42.521Z 2025-12-05T14:51:52.454Z
8646267 8646267 20251129013511_tEZYh ES0013 2025-11-30T14:25:45.799Z 2025-12-05T14:51:37.663Z
8646151 8646151 20251129011339_VaD6O ES0013 2025-11-30T14:25:17.265Z 2025-12-05T14:51:34.285Z
8646148 8646148 20251129011321_wx2hM ES0013 2025-11-30T14:25:17.022Z 2025-12-05T14:51:34.252Z
8646075 8646075 20251129005954_4SuD5 ES0013 2025-11-30T14:25:09.207Z 2025-12-05T14:51:32.435Z
8645824 8645824 20251128235817_rwfit ES0013 2025-11-30T14:24:35.819Z 2025-12-05T14:51:20.231Z
8645626 8645626 20251128230931_gYgWG ES0013 2025-11-30T14:24:18.090Z 2025-12-05T14:50:58.794Z
8637572 8637572 20251128055407_OAB52 ES0013 2025-11-29T14:27:35.410Z 2025-12-05T15:00:05.505Z
8637542 8637542 20251128054932_6MF30 ES0013 2025-11-29T14:27:33.138Z 2025-12-05T15:00:00.537Z
8637449 8637449 20251128054056_GF5DM ES0013 2025-11-29T14:27:17.735Z 2025-12-05T14:59:53.583Z
8637407 8637407 20251128053752_nQu9p ES0013 2025-11-29T14:27:12.851Z 2025-12-05T14:59:51.120Z
8637353 8637353 20251128053214_yU2h3 ES0013 2025-11-29T14:27:06.853Z 2025-12-05T14:59:44.644Z
8637262 8637262 20251128052122_pVpYr ES0013 2025-11-29T14:27:01.839Z 2025-12-05T14:59:39.512Z
8637235 8637235 20251128051753_KcD5D ES0013 2025-11-29T14:26:59.774Z 2025-12-05T14:59:39.047Z
8637131 8637131 20251128050519_U4iJ3 ES0013 2025-11-29T14:26:52.653Z 2025-12-05T14:59:37.647Z
8636794 8636794 20251128042827_3z3AV ES0013 2025-11-29T14:26:12.761Z 2025-12-05T14:59:29.939Z
8636729 8636729 20251128042022_o3mxq ES0013 2025-11-29T14:26:08.034Z 2025-12-05T14:59:28.744Z
8636711 8636711 20251128041917_S9iP9 ES0013 2025-11-29T14:26:07.072Z 2025-12-05T14:59:28.515Z
8636642 8636642 20251128041348_FNJh1 ES0013 2025-11-29T14:25:47.157Z 2025-12-05T14:59:27.281Z
8636617 8636617 20251128040923_ljbHG ES0013 2025-11-29T14:25:45.466Z 2025-12-05T14:59:26.911Z
8636025 8636025 20251128030838_5K1BC ES0013 2025-11-29T14:24:48.525Z 2025-12-05T14:59:18.291Z
8635961 8635961 20251128030221_3q33e ES0013 2025-11-29T14:24:42.339Z 2025-12-05T14:59:17.334Z
8635567 8635567 20251128022641_nwxTY ES0013 2025-11-29T14:23:41.724Z 2025-12-05T14:59:05.063Z
8635525 8635525 20251128022241_jion5 ES0013 2025-11-29T14:23:35.480Z 2025-12-05T14:58:56.257Z
8635484 8635484 20251128021809_cn5jN ES0013 2025-11-29T14:23:28.331Z 2025-12-05T14:58:46.548Z
8635260 8635260 20251128015830_GBF3J ES0013 2025-11-29T14:22:55.556Z 2025-12-05T14:58:33.165Z
8635003 8635003 20251128013312_zZWeY ES0013 2025-11-29T14:22:21.684Z 2025-12-05T14:58:27.448Z
8634936 8634936 20251128012718_Gevw5 ES0013 2025-11-29T14:22:13.057Z 2025-12-05T14:58:26.549Z
8634787 8634787 20251128011757_Kzbau ES0013 2025-11-29T14:22:03.515Z 2025-12-05T14:58:24.935Z
8634648 8634648 20251128010720_2XU7L ES0013 2025-11-29T14:21:44.929Z 2025-12-05T14:58:23.092Z
8634599 8634599 20251128010319_p3aE0 ES0013 2025-11-29T14:21:36.199Z 2025-12-05T14:58:22.570Z
8634081 8634081 20251128002059_Yjyuk ES0013 2025-11-29T14:20:42.236Z 2025-12-05T14:58:16.244Z
8633900 8633900 20251128000233_1W7uV ES0013 2025-11-29T14:20:29.439Z 2025-12-05T14:58:13.888Z
8633135 8633135 20251127224314_DTB2P ES0013 2025-11-29T14:19:02.023Z 2025-12-05T14:57:14.052Z
8632750 8632750 20251127215005_9eoGC ES0013 2025-11-29T14:18:19.034Z 2025-12-05T14:56:35.320Z
8624610 8624610 20251127053600_4IUnG ES0013 2025-11-28T14:25:12.757Z 2025-12-05T15:05:18.670Z
8624533 8624533 20251127052116_m3CSt ES0013 2025-11-28T14:25:06.886Z 2025-12-05T15:05:11.574Z
8624414 8624414 20251127044230_ymwaP ES0013 2025-11-28T14:24:38.450Z 2025-12-05T15:05:04.542Z
8624406 8624406 20251127043649_7ZJsM ES0013 2025-11-28T14:24:37.461Z 2025-12-05T15:05:04.350Z
8624260 8624260 20251127035030_DfnXE ES0013 2025-11-28T14:24:22.493Z 2025-12-05T15:04:56.850Z
8624127 8624127 20251127031430_kpHlI ES0013 2025-11-28T14:23:50.300Z 2025-12-05T15:04:46.279Z
8624014 8624014 20251127024704_SXYLU ES0013 2025-11-28T14:23:37.396Z 2025-12-05T15:04:34.200Z
8623971 8623971 20251127023508_TaMd1 ES0013 2025-11-28T14:23:13.736Z 2025-12-05T15:04:31.738Z
8623793 8623793 20251127020510_JdhO9 ES0013 2025-11-28T14:22:54.059Z 2025-12-05T15:04:17.322Z
8623636 8623636 20251127013236_6iglD ES0013 2025-11-28T14:22:18.466Z 2025-12-05T15:04:05.743Z
8623616 8623616 20251127012726_2IW95 ES0013 2025-11-28T14:22:16.285Z 2025-12-05T15:04:05.036Z
8623454 8623454 20251127004354_6wCJd ES0013 2025-11-28T14:21:46.511Z 2025-12-05T15:03:54.367Z
8623431 8623431 20251127003557_2KPlW ES0013 2025-11-28T14:21:44.255Z 2025-12-05T15:03:53.293Z
8623234 8623234 20251126232706_RaI0f ES0013 2025-11-28T14:21:10.588Z 2025-12-05T15:03:39.375Z
8616093 8616093 20251126053846_NnZ27 ES0013 2025-11-27T14:30:30.374Z 2025-12-04T15:11:35.641Z
8616078 8616078 20251126053657_kAdOE ES0013 2025-11-27T14:30:28.879Z 2025-12-04T15:11:35.364Z
8615794 8615794 20251126051950_o9zH1 ES0013 2025-11-27T14:30:11.542Z 2025-12-04T15:11:32.527Z
8615480 8615480 20251126050435_tdW4x ES0013 2025-11-27T14:29:35.512Z 2025-12-04T15:11:29.307Z
8615136 8615136 20251126044636_znkXf ES0013 2025-11-27T14:29:16.174Z 2025-12-04T15:11:26.211Z
8613200 8613200 20251126030929_T7ngL ES0013 2025-11-27T14:25:30.250Z 2025-12-04T15:09:38.422Z
8613148 8613148 20251126030548_5kLGb ES0013 2025-11-27T14:25:26.670Z 2025-12-04T15:09:37.894Z
8613070 8613070 20251126030048_XNwuq ES0013 2025-11-27T14:25:21.989Z 2025-12-04T15:09:36.996Z
8612934 8612934 20251126025628_7TMBV ES0013 2025-11-27T14:25:01.169Z 2025-12-04T15:09:35.906Z
8612546 8612546 20251126023723_xVdDV ES0013 2025-11-27T14:24:20.564Z 2025-12-04T15:09:31.772Z
8612189 8612189 20251126022126_L3oaK ES0013 2025-11-27T14:23:35.964Z 2025-12-04T15:09:28.157Z
8611960 8611960 20251126021049_wk8ZA ES0013 2025-11-27T14:23:07.686Z 2025-12-04T15:09:26.161Z
8611801 8611801 20251126020100_gkK3O ES0013 2025-11-27T14:22:54.504Z 2025-12-04T15:09:24.327Z
8610421 8610421 20251126004422_d5bOB ES0013 2025-11-27T14:20:06.228Z 2025-12-04T15:08:05.346Z
8610349 8610349 20251126003940_9E9TJ ES0013 2025-11-27T14:19:57.852Z 2025-12-04T15:08:04.486Z
8610251 8610251 20251126003205_c3GIQ ES0013 2025-11-27T14:19:39.664Z 2025-12-04T15:08:03.710Z
8609649 8609649 20251125235818_D2plu ES0013 2025-11-27T14:18:46.901Z 2025-12-04T15:07:56.389Z
8608643 8608643 20251125223214_Sb0sT ES0013 2025-11-27T14:16:25.419Z 2025-12-04T15:07:47.351Z
8607921 8607921 20251125213511_Y2G4Y ES0013 2025-11-27T14:14:48.351Z 2025-12-04T15:07:39.190Z
8580669 8580669 20251123053749_W0bLQ ES0013 2025-11-24T14:17:35.245Z 2025-12-01T15:22:22.163Z
8580628 8580628 20251123050638_vwsgY ES0013 2025-11-24T14:17:29.618Z 2025-12-01T15:22:20.605Z
8580452 8580452 20251123042409_eVxyq ES0013 2025-11-24T14:17:01.709Z 2025-12-01T15:22:17.413Z
8580386 8580386 20251123040928_4L9MN ES0013 2025-11-24T14:16:53.657Z 2025-12-01T15:22:16.277Z
8580251 8580251 20251123031810_nZOMj ES0013 2025-11-24T14:16:29.639Z 2025-12-01T15:22:04.022Z
8579637 8579637 20251123003546_6ggat ES0013 2025-11-24T14:14:53.840Z 2025-12-01T15:20:50.915Z
8577827 8577827 20251122185945_sh08H ES0013 2025-11-24T14:09:50.041Z 2025-12-01T15:18:59.777Z
8572454 8572454 20251122004913_zpcHd ES0013 2025-11-23T14:39:23.365Z 2025-11-30T15:05:50.394Z

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