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

279 rows where station_code = "DE000H" 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
8098120 8098120 20251013230617_77Xa3 DE000H 2025-10-15T12:15:07.632Z 2025-10-22T13:09:47.859Z
8050536 8050536 20251003004845_7hJ20 DE000H 2025-10-04T12:41:42.037Z 2025-10-11T12:40:30.047Z
8050508 8050508 20251003004448_2IOwh DE000H 2025-10-04T12:41:38.680Z 2025-10-11T12:40:28.868Z
8050001 8050001 20251002205218_JU6Xm DE000H 2025-10-04T12:39:49.400Z 2025-10-11T12:39:34.134Z
8049980 8049980 20251002202741_KV8NW DE000H 2025-10-04T12:39:45.575Z 2025-10-11T12:39:32.109Z
8042900 8042900 20251002034639_NTI36 DE000H 2025-10-03T12:38:55.552Z 2025-10-10T12:41:55.985Z
8041846 8041846 20251002022801_unxt3 DE000H 2025-10-03T12:37:21.631Z 2025-10-03T12:37:21.631Z
8041057 8041057 20251002013958_u0IGs DE000H 2025-10-03T12:35:47.084Z 2025-10-10T12:40:52.050Z
8040895 8040895 20251002012923_bwL5l DE000H 2025-10-03T12:35:09.554Z 2025-10-10T12:40:45.975Z
8039772 8039772 20251001235723_53cKc DE000H 2025-10-03T12:33:22.350Z 2025-10-10T12:40:07.603Z
8038221 8038221 20251001201729_0jAt9 DE000H 2025-10-03T12:29:20.599Z 2025-10-10T12:39:44.042Z
8029183 8029183 20250930021411_2iQ23 DE000H 2025-10-02T12:36:38.401Z 2025-10-08T12:43:26.835Z
8029164 8029164 20250930003754_WuBu8 DE000H 2025-10-02T12:35:38.250Z 2025-10-08T12:43:01.958Z
8029160 8029160 20250930002517_hoiLA DE000H 2025-10-02T12:35:33.891Z 2025-10-08T12:42:59.949Z
8016270 8016270 20250929212602_EE0LF DE000H 2025-10-01T12:23:06.156Z 2025-10-08T12:42:21.649Z
8009431 8009431 20250929031710_tQQhd DE000H 2025-09-30T12:31:26.565Z 2025-10-07T13:01:18.524Z
8009393 8009393 20250929031553_3I32m DE000H 2025-09-30T12:31:24.462Z 2025-10-07T13:01:18.336Z
8007721 8007721 20250929021511_GHIko DE000H 2025-09-30T12:28:53.689Z 2025-10-07T13:01:08.012Z
8001202 8001202 20250928201128_9E6FY DE000H 2025-09-30T12:14:47.566Z 2025-10-07T13:00:15.961Z
8000395 8000395 20250928183228_W0aoU DE000H 2025-09-30T12:12:20.505Z 2025-10-07T12:59:56.406Z
8000336 8000336 20250928181322_TeL1X DE000H 2025-09-30T12:11:59.650Z 2025-10-07T12:59:54.695Z
7995042 7995042 20250928001115_bsLI1 DE000H 2025-09-29T12:22:52.793Z 2025-10-05T13:07:06.220Z
7985208 7985208 20250927030050_aBDaj DE000H 2025-09-28T12:25:54.883Z 2025-10-05T13:11:09.674Z
7963879 7963879 20250925034134_n6G5X DE000H 2025-09-26T12:29:13.407Z 2025-10-03T13:04:41.348Z
7962654 7962654 20250925023608_nQCrY DE000H 2025-09-26T12:27:36.937Z 2025-10-03T13:04:22.956Z
7962337 7962337 20250925021629_8MBDq DE000H 2025-09-26T12:27:09.635Z 2025-10-03T13:04:19.376Z
7962076 7962076 20250925020210_KNZVd DE000H 2025-09-26T12:26:48.377Z 2025-10-03T13:04:18.520Z
7961427 7961427 20250925012710_y23nL DE000H 2025-09-26T12:25:52.706Z 2025-10-03T13:04:16.065Z
7960352 7960352 20250925003249_8oFN8 DE000H 2025-09-26T12:24:29.761Z 2025-10-03T13:04:12.042Z
7960350 7960350 20250925003249_ipUu8 DE000H 2025-09-26T12:24:29.496Z 2025-10-03T13:04:12.034Z
7960348 7960348 20250925003249_8L2ez DE000H 2025-09-26T12:24:29.287Z 2025-10-03T13:04:12.032Z
7959600 7959600 20250924234657_Qp8Iw DE000H 2025-09-26T12:23:22.956Z 2025-10-03T13:04:05.033Z
7957864 7957864 20250924213255_nM8e2 DE000H 2025-09-26T12:20:28.190Z 2025-10-03T13:04:00.358Z
7957022 7957022 20250924200726_QsEJU DE000H 2025-09-26T12:18:24.820Z 2025-10-03T13:03:56.669Z
7956707 7956707 20250924193430_fJRYu DE000H 2025-09-26T12:17:38.916Z 2025-10-03T13:03:55.420Z
7950188 7950188 20250924023546_U8CT8 DE000H 2025-09-25T12:34:47.552Z 2025-10-02T13:27:53.497Z
7950097 7950097 20250924023238_IoceW DE000H 2025-09-25T12:34:43.254Z 2025-10-02T13:27:48.473Z
7949971 7949971 20250924022515_rH1Xx DE000H 2025-09-25T12:34:36.049Z 2025-10-02T13:27:42.726Z
7949592 7949592 20250924020340_ENMkJ DE000H 2025-09-25T12:33:45.558Z 2025-10-02T13:27:28.481Z
7949247 7949247 20250924014303_8uduF DE000H 2025-09-25T12:33:28.658Z 2025-10-02T13:27:20.629Z
7947852 7947852 20250924002816_RCxcG DE000H 2025-09-25T12:31:22.511Z 2025-10-02T13:26:54.397Z
7946500 7946500 20250923231253_3n9Cj DE000H 2025-09-25T12:29:05.572Z 2025-10-02T13:26:41.109Z
7945748 7945748 20250923223020_15VdK DE000H 2025-09-25T12:27:43.079Z 2025-10-02T13:26:34.673Z
7945730 7945730 20250923222918_9BYz9 DE000H 2025-09-25T12:27:41.666Z 2025-10-02T13:26:34.548Z
7944172 7944172 20250923203507_zPHUf DE000H 2025-09-25T12:24:38.286Z 2025-10-02T13:26:23.534Z
7937620 7937620 20250924034755_Lfgft DE000H 2025-09-25T12:00:56.170Z 2025-10-03T13:02:27.627Z
7937457 7937457 20250924033822_UgBln DE000H 2025-09-25T12:00:25.517Z 2025-10-03T13:02:24.829Z
7921415 7921415 20250923020143_YeWnK DE000H 2025-09-24T12:30:11.922Z 2025-10-01T13:24:43.103Z
7918967 7918967 20250922235703_rkbdY DE000H 2025-09-24T12:26:44.616Z 2025-10-01T13:24:14.160Z
7918266 7918266 20250922231545_FRNG7 DE000H 2025-09-24T12:25:28.106Z 2025-10-01T13:24:02.705Z
7917448 7917448 20250922222319_yc5LM DE000H 2025-09-24T12:24:01.849Z 2025-10-01T13:23:52.364Z
7909307 7909307 20250923031211_R7vXS DE000H 2025-09-24T12:00:38.981Z 2025-10-02T13:22:17.953Z
7909202 7909202 20250923030623_3iVcP DE000H 2025-09-24T12:00:20.780Z 2025-10-02T13:22:16.661Z
7897868 7897868 20250921030208_dVWAW DE000H 2025-09-22T12:03:49.155Z 2025-09-30T13:00:58.926Z
7896091 7896091 20250920003221_dFYRm DE000H 2025-09-21T12:39:33.038Z 2025-09-28T12:54:47.282Z
7884076 7884076 20250920020100_y7tyC DE000H 2025-09-21T12:02:17.414Z 2025-09-29T13:02:41.684Z
7845185 7845185 20250916013208_GcyMf DE000H 2025-09-17T12:06:21.343Z 2025-09-24T13:15:37.009Z
7845014 7845014 20250916011634_GYZX9 DE000H 2025-09-17T12:05:35.562Z 2025-09-24T13:15:34.203Z
7844701 7844701 20250916003946_XHU8H DE000H 2025-09-17T12:04:14.962Z 2025-09-24T13:15:23.660Z
7824273 7824273 20250912204650_faw0H DE000H 2025-09-14T12:29:51.514Z 2025-09-20T13:03:09.628Z
7819711 7819711 20250913005128_4m4Uk DE000H 2025-09-14T12:05:39.699Z 2025-09-21T13:08:21.410Z
7818980 7818980 20250912222006_9G8LP DE000H 2025-09-14T12:01:57.498Z 2025-09-21T13:08:06.997Z
7812575 7812575 20250912025329_0E9tj DE000H 2025-09-13T12:13:29.675Z 2025-09-20T13:01:57.810Z
7810124 7810124 20250911230638_V8WoF DE000H 2025-09-13T12:04:55.454Z 2025-09-20T13:01:25.213Z
7805773 7805773 20250911031826_a03xp DE000H 2025-09-12T12:07:28.557Z 2025-09-19T12:57:01.962Z
7784107 7784107 20250907003811_h7zmi DE000H 2025-09-08T12:08:22.853Z 2025-09-15T12:43:33.871Z
7758681 7758681 20250903203055_STknJ DE000H 2025-09-05T12:06:59.809Z 2025-09-12T12:48:23.880Z
7751491 7751491 20250903025140_eqcIY DE000H 2025-09-04T12:16:29.174Z 2025-09-11T12:44:03.382Z
7751313 7751313 20250903022800_wvN9o DE000H 2025-09-04T12:16:11.865Z 2025-09-11T12:43:58.364Z
7750792 7750792 20250903011440_S2Is3 DE000H 2025-09-04T12:14:29.661Z 2025-09-11T12:43:47.213Z
7750645 7750645 20250903005545_VgiLe DE000H 2025-09-04T12:14:08.386Z 2025-09-11T12:43:45.988Z
7750502 7750502 20250903002934_8gH6M DE000H 2025-09-04T12:13:36.471Z 2025-09-11T12:43:44.945Z
7728951 7728951 20250901010526_PMNLu DE000H 2025-09-02T12:24:01.216Z 2025-09-09T12:48:23.931Z
7728254 7728254 20250901002723_8K58I DE000H 2025-09-02T12:22:32.017Z 2025-09-09T12:48:13.845Z
7727082 7727082 20250831231234_3xlYO DE000H 2025-09-02T12:20:06.151Z 2025-09-09T12:47:41.629Z
7715685 7715685 20250831030210_1Sthq DE000H 2025-09-01T12:21:25.099Z 2025-09-08T12:52:54.415Z
7715616 7715616 20250831025915_pjHdY DE000H 2025-09-01T12:21:20.566Z 2025-09-08T12:52:54.138Z
7715280 7715280 20250831024208_11uWw DE000H 2025-09-01T12:20:38.219Z 2025-09-08T12:52:47.775Z
7713762 7713762 20250831012919_JNz15 DE000H 2025-09-01T12:17:45.629Z 2025-09-08T12:52:29.368Z
7712855 7712855 20250831003651_25C9a DE000H 2025-09-01T12:15:36.705Z 2025-09-08T12:52:22.461Z
7712305 7712305 20250830234458_TVbWe DE000H 2025-09-01T12:13:56.113Z 2025-09-08T12:52:19.411Z
7711944 7711944 20250830225925_F6RuW DE000H 2025-09-01T12:12:55.654Z 2025-09-08T12:52:10.311Z
7711480 7711480 20250830215634_Qu32x DE000H 2025-09-01T12:11:35.785Z 2025-09-08T12:52:04.426Z
7702484 7702484 20250829221704_pskJe DE000H 2025-08-31T12:20:20.762Z 2025-09-07T12:58:07.141Z
7662645 7662645 20250826023227_bZmnl DE000H 2025-08-27T12:28:45.709Z 2025-09-03T12:53:03.761Z
7662253 7662253 20250826021636_bq6D7 DE000H 2025-08-27T12:28:05.903Z 2025-09-03T12:53:01.462Z
7660750 7660750 20250826010805_Gi110 DE000H 2025-08-27T12:24:48.392Z 2025-09-03T12:52:51.820Z
7657756 7657756 20250825221433_TpnFA DE000H 2025-08-27T12:18:09.163Z 2025-09-03T12:52:29.175Z
7657710 7657710 20250825221023_yyFtS DE000H 2025-08-27T12:18:04.252Z 2025-09-03T12:52:28.717Z
7650320 7650320 20250825024520_iybHa DE000H 2025-08-26T12:31:45.586Z 2025-09-02T12:52:18.462Z
7648324 7648324 20250825011441_iIFT5 DE000H 2025-08-26T12:28:53.049Z 2025-09-02T12:52:00.586Z
7648000 7648000 20250825005950_UlQCc DE000H 2025-08-26T12:28:18.766Z 2025-09-02T12:51:58.170Z
7647704 7647704 20250825005043_wIEzl DE000H 2025-08-26T12:27:55.680Z 2025-09-02T12:51:57.276Z
7646691 7646691 20250824235727_qFQOm DE000H 2025-08-26T12:25:52.030Z 2025-09-02T12:51:51.636Z
7646379 7646379 20250824233647_O3uSm DE000H 2025-08-26T12:25:13.731Z 2025-09-02T12:51:48.775Z
7645848 7645848 20250824230721_w2YSX DE000H 2025-08-26T12:24:03.654Z 2025-09-02T12:51:46.993Z
7637508 7637508 20250824024339_Leahu DE000H 2025-08-25T12:29:51.877Z 2025-09-01T12:56:11.596Z
7635672 7635672 20250824004826_HPiTV DE000H 2025-08-25T12:26:11.937Z 2025-09-01T12:56:08.273Z
7635514 7635514 20250824004149_Gt32S DE000H 2025-08-25T12:25:59.253Z 2025-09-01T12:56:07.844Z
7634940 7634940 20250824001513_20n7i DE000H 2025-08-25T12:24:51.495Z 2025-09-01T12:56:06.717Z

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