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

2,457 rows where station_code = "DE000M" 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
9248542 9248542 20260122003700_hRYOA DE000M 2026-01-23T14:13:03.374Z 2026-01-29T14:57:25.957Z
9243092 9243092 20260121034154_TepYM DE000M 2026-01-22T14:20:33.100Z 2026-01-29T15:04:46.289Z
9243011 9243011 20260121033207_hN7e6 DE000M 2026-01-22T14:20:18.487Z 2026-01-29T15:04:43.536Z
9242960 9242960 20260121032208_iNs9E DE000M 2026-01-22T14:20:07.641Z 2026-01-29T15:04:32.548Z
9242932 9242932 20260121031903_qj7Fm DE000M 2026-01-22T14:19:54.296Z 2026-01-29T15:04:30.591Z
9242839 9242839 20260121025820_dez1f DE000M 2026-01-22T14:19:31.539Z 2026-01-29T15:04:23.897Z
9242630 9242630 20260121022621_E2I0X DE000M 2026-01-22T14:18:38.031Z 2026-01-29T15:04:14.998Z
9241945 9241945 20260120234123_3rf7W DE000M 2026-01-22T14:15:29.544Z 2026-01-29T15:03:14.100Z
9241938 9241938 20260120234040_YxIga DE000M 2026-01-22T14:15:27.898Z 2026-01-29T15:03:13.681Z
9241874 9241874 20260120231216_syWLt DE000M 2026-01-22T14:15:01.845Z 2026-01-29T15:03:07.516Z
9241749 9241749 20260120221328_3WxWf DE000M 2026-01-22T14:14:23.447Z 2026-01-29T15:03:00.685Z
9241687 9241687 20260120213343_Xc6Lz DE000M 2026-01-22T14:14:09.007Z 2026-01-29T15:02:57.185Z
9241584 9241584 20260120211233_yOUl5 DE000M 2026-01-22T14:13:48.739Z 2026-01-29T15:02:54.048Z
9241493 9241493 20260120204519_8v12D DE000M 2026-01-22T14:13:20.589Z 2026-01-29T15:02:40.586Z
9237662 9237662 20260120054905_c23uz DE000M 2026-01-21T14:27:15.872Z 2026-01-28T15:01:35.330Z
9237635 9237635 20260120054608_z1IQT DE000M 2026-01-21T14:27:10.574Z 2026-01-28T15:01:34.185Z
9237555 9237555 20260120053543_0wgds DE000M 2026-01-21T14:27:00.185Z 2026-01-28T15:01:31.054Z
9237451 9237451 20260120052015_KDvQB DE000M 2026-01-21T14:26:32.998Z 2026-01-28T15:01:26.425Z
9237226 9237226 20260120045244_qQWSS DE000M 2026-01-21T14:25:43.893Z 2026-01-28T15:01:04.951Z
9237124 9237124 20260120044015_qSmh7 DE000M 2026-01-21T14:25:19.727Z 2026-01-28T15:00:58.980Z
9237089 9237089 20260120043559_03YEe DE000M 2026-01-21T14:25:15.480Z 2026-01-28T15:00:57.736Z
9236996 9236996 20260120042604_BQOXQ DE000M 2026-01-21T14:24:54.406Z 2026-01-28T15:00:52.938Z
9236836 9236836 20260120040515_bUSK0 DE000M 2026-01-21T14:24:19.788Z 2026-01-28T15:00:38.314Z
9236826 9236826 20260120040434_t2dEh DE000M 2026-01-21T14:24:19.014Z 2026-01-28T15:00:38.080Z
9236207 9236207 20260120024727_UPp18 DE000M 2026-01-21T14:21:58.197Z 2026-01-28T14:59:50.138Z
9235693 9235693 20260120014813_7jGgS DE000M 2026-01-21T14:19:59.900Z 2026-01-28T14:59:16.335Z
9235661 9235661 20260120014523_Az4mS DE000M 2026-01-21T14:19:51.054Z 2026-01-28T14:59:15.103Z
9235579 9235579 20260120013629_cHLnd DE000M 2026-01-21T14:19:29.205Z 2026-01-28T14:59:03.230Z
9235573 9235573 20260120013508_NmhAR DE000M 2026-01-21T14:19:27.919Z 2026-01-28T14:59:02.834Z
9234898 9234898 20260119234753_bKGWA DE000M 2026-01-21T14:16:37.258Z 2026-01-28T14:58:19.565Z
9234644 9234644 20260119224526_cozCZ DE000M 2026-01-21T14:15:33.623Z 2026-01-28T14:57:58.070Z
9234000 9234000 20260119191058_y4POM DE000M 2026-01-21T14:11:44.459Z 2026-01-28T14:56:57.874Z
9233884 9233884 20260119182909_tBrJJ DE000M 2026-01-21T14:11:10.350Z 2026-01-28T14:56:50.125Z
9233879 9233879 20260119182752_wx80R DE000M 2026-01-21T14:11:04.282Z 2026-01-28T14:56:49.955Z
9233708 9233708 20260119170956_Jhou3 DE000M 2026-01-21T14:10:02.883Z 2026-01-28T14:56:24.289Z
9231076 9231076 20260119055644_ymjPr DE000M 2026-01-20T14:31:08.708Z 2026-01-27T15:05:56.722Z
9230996 9230996 20260119054143_MlHgY DE000M 2026-01-20T14:30:46.670Z 2026-01-27T15:05:52.064Z
9230926 9230926 20260119052950_ip1My DE000M 2026-01-20T14:30:30.048Z 2026-01-27T15:05:37.081Z
9230908 9230908 20260119052907_3sKp4 DE000M 2026-01-20T14:30:20.852Z 2026-01-27T15:05:35.973Z
9230808 9230808 20260119051229_OeUmd DE000M 2026-01-20T14:29:51.520Z 2026-01-27T15:05:28.015Z
9230742 9230742 20260119050041_23WY3 DE000M 2026-01-20T14:29:33.573Z 2026-01-27T15:05:23.870Z
9230667 9230667 20260119044717_drI3k DE000M 2026-01-20T14:29:10.384Z 2026-01-27T15:05:19.561Z
9230546 9230546 20260119043205_fnHtd DE000M 2026-01-20T14:28:28.165Z 2026-01-27T15:05:02.585Z
9230481 9230481 20260119042530_Psk8V DE000M 2026-01-20T14:28:05.381Z 2026-01-27T15:04:57.250Z
9230449 9230449 20260119042005_UryB3 DE000M 2026-01-20T14:27:55.754Z 2026-01-27T15:04:55.115Z
9230376 9230376 20260119041021_6fbzR DE000M 2026-01-20T14:27:31.382Z 2026-01-27T15:04:51.234Z
9230337 9230337 20260119040404_C06Zt DE000M 2026-01-20T14:27:17.688Z 2026-01-27T15:04:49.409Z
9230192 9230192 20260119033850_DMMVb DE000M 2026-01-20T14:26:29.980Z 2026-01-27T15:04:32.332Z
9230133 9230133 20260119033240_n0b9i DE000M 2026-01-20T14:26:12.654Z 2026-01-27T15:04:29.346Z
9229979 9229979 20260119030356_EwX3z DE000M 2026-01-20T14:25:15.847Z 2026-01-27T15:04:17.853Z
9229945 9229945 20260119025902_f5bhy DE000M 2026-01-20T14:25:05.240Z 2026-01-27T15:04:16.075Z
9229919 9229919 20260119025620_N83D4 DE000M 2026-01-20T14:25:00.378Z 2026-01-27T15:04:14.918Z
9229916 9229916 20260119025619_64dvv DE000M 2026-01-20T14:24:59.731Z 2026-01-27T15:04:14.802Z
9229781 9229781 20260119023607_aGcy7 DE000M 2026-01-20T14:24:12.654Z 2026-01-27T15:03:56.642Z
9229683 9229683 20260119021714_VahTL DE000M 2026-01-20T14:23:42.633Z 2026-01-27T15:03:49.391Z
9229676 9229676 20260119021604_4r1bj DE000M 2026-01-20T14:23:41.375Z 2026-01-27T15:03:49.131Z
9229565 9229565 20260119020217_BDbHI DE000M 2026-01-20T14:23:10.524Z 2026-01-27T15:03:42.650Z
9229471 9229471 20260119015034_hsobm DE000M 2026-01-20T14:22:44.869Z 2026-01-27T15:03:27.839Z
9229408 9229408 20260119014222_XFtNB DE000M 2026-01-20T14:22:24.375Z 2026-01-27T15:03:22.567Z
9229360 9229360 20260119013625_64Iq4 DE000M 2026-01-20T14:22:14.309Z 2026-01-27T15:03:20.017Z
9229312 9229312 20260119012955_Lek8j DE000M 2026-01-20T14:21:57.380Z 2026-01-27T15:03:17.174Z
9228985 9228985 20260119003124_52J7P DE000M 2026-01-20T14:20:30.192Z 2026-01-27T15:02:46.578Z
9228956 9228956 20260119002434_WQJcd DE000M 2026-01-20T14:20:19.182Z 2026-01-27T15:02:45.143Z
9228875 9228875 20260119001131_rt31w DE000M 2026-01-20T14:19:54.036Z 2026-01-27T15:02:40.770Z
9228819 9228819 20260118235903_icoQv DE000M 2026-01-20T14:19:41.399Z 2026-01-27T15:02:37.462Z
9228254 9228254 20260118210126_b3AbO DE000M 2026-01-20T14:16:55.098Z 2026-01-27T15:01:38.921Z
9182452 9182452 20260111052608_dUztn DE000M 2026-01-12T14:14:37.458Z 2026-01-19T15:18:32.918Z
9182420 9182420 20260111052254_wQWOC DE000M 2026-01-12T14:14:30.442Z 2026-01-19T15:18:31.605Z
9182409 9182409 20260111052113_Vd8Vv DE000M 2026-01-12T14:14:29.027Z 2026-01-19T15:18:31.261Z
9182360 9182360 20260111051029_Fkd0K DE000M 2026-01-12T14:14:15.963Z 2026-01-19T15:18:29.391Z
9182351 9182351 20260111050856_Tv72E DE000M 2026-01-12T14:14:14.596Z 2026-01-19T15:18:27.747Z
9182345 9182345 20260111050749_etWOY DE000M 2026-01-12T14:14:13.739Z 2026-01-19T15:18:27.438Z
9182246 9182246 20260111044928_4kJNO DE000M 2026-01-12T14:13:51.406Z 2026-01-19T15:18:22.483Z
9181954 9181954 20260111034905_uMiH9 DE000M 2026-01-12T14:12:43.282Z 2026-01-19T15:17:57.340Z
9181318 9181318 20260111011959_l7ved DE000M 2026-01-12T14:10:20.741Z 2026-01-19T15:17:12.533Z
9181238 9181238 20260111010120_b6qQS DE000M 2026-01-12T14:10:04.497Z 2026-01-19T15:17:09.160Z
9181219 9181219 20260111005931_3KqY3 DE000M 2026-01-12T14:09:59.958Z 2026-01-19T15:17:08.439Z
9181190 9181190 20260111004937_RXMrb DE000M 2026-01-12T14:09:54.354Z 2026-01-19T15:17:07.301Z
9180825 9180825 20260110224921_afVCQ DE000M 2026-01-12T14:08:31.681Z 2026-01-19T15:16:34.385Z
9180681 9180681 20260110213232_kuder DE000M 2026-01-12T14:07:59.486Z 2026-01-19T15:16:27.355Z
9180410 9180410 20260110202056_QKrnn DE000M 2026-01-12T14:07:02.760Z 2026-01-19T15:16:01.202Z
9179651 9179651 20260110171159_ZatFs DE000M 2026-01-12T14:03:43.826Z 2026-01-19T15:15:09.726Z
9118735 9118735 20251230052805_OqCfS DE000M 2026-01-01T14:49:15.518Z 2026-01-07T15:09:20.446Z
9109653 9109653 20251230201254_a3dNQ DE000M 2026-01-01T14:02:26.633Z 2026-01-08T15:04:17.357Z
9109306 9109306 20251227202234_m7udH DE000M 2025-12-31T15:21:03.153Z 2026-01-04T15:35:31.417Z
9108935 9108935 20251229195549_VjSFJ DE000M 2025-12-31T14:44:58.866Z 2025-12-31T14:44:58.866Z
9108885 9108885 20251229194908_mwbyt DE000M 2025-12-31T14:44:43.564Z 2026-01-06T15:22:05.398Z
9108784 9108784 20251229193711_KxhYx DE000M 2025-12-31T14:44:31.445Z 2025-12-31T14:44:31.445Z
9108478 9108478 20251229185753_B8kNZ DE000M 2025-12-31T14:43:41.201Z 2026-01-06T15:21:36.163Z
9108405 9108405 20251229184417_HVryL DE000M 2025-12-31T14:43:29.544Z 2026-01-06T15:21:33.895Z
9104619 9104619 20251230061310_cAqvh DE000M 2025-12-31T14:21:50.040Z 2026-01-07T15:09:50.615Z
9104324 9104324 20251230054358_arRU5 DE000M 2025-12-31T14:20:58.229Z 2026-01-07T15:09:39.220Z
9104231 9104231 20251230053757_poocH DE000M 2025-12-31T14:20:40.949Z 2026-01-07T15:09:35.572Z
9104142 9104142 20251230053235_tBv21 DE000M 2025-12-31T14:20:25.674Z 2026-01-07T15:09:32.186Z
9104090 9104090 20251230053016_9AJUG DE000M 2025-12-31T14:20:15.636Z 2026-01-07T15:09:30.317Z
9104079 9104079 20251230052938_2G2ss DE000M 2025-12-31T14:20:12.863Z 2026-01-07T15:09:29.444Z
9103999 9103999 20251230052440_1e6DZ DE000M 2025-12-31T14:19:59.028Z 2026-01-07T15:09:18.529Z
9103889 9103889 20251230051425_C8bNY DE000M 2025-12-31T14:19:37.306Z 2026-01-07T15:09:13.816Z
9103864 9103864 20251230051135_w7tgI DE000M 2025-12-31T14:19:33.166Z 2026-01-07T15:09:12.827Z
9103667 9103667 20251230045104_837Xo DE000M 2025-12-31T14:18:45.124Z 2026-01-07T15:09:03.123Z

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