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

5,776 rows where station_code = "DE0004" 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
9259275 9259275 20260124200641_0MG3V DE0004 2026-01-26T14:16:25.211Z 2026-01-29T14:42:45.763Z
9252598 9252598 20260123043609_y8TOM DE0004 2026-01-24T14:16:24.908Z 2026-01-29T14:53:10.767Z
9249284 9249284 20260122043817_SrQn0 DE0004 2026-01-23T14:15:06.966Z 2026-01-29T14:58:21.738Z
9249274 9249274 20260122043530_u9Z2n DE0004 2026-01-23T14:15:06.363Z 2026-01-29T14:58:21.433Z
9249250 9249250 20260122042422_jd1HL DE0004 2026-01-23T14:15:03.348Z 2026-01-29T14:58:19.859Z
9249063 9249063 20260122032654_sfAUB DE0004 2026-01-23T14:14:31.929Z 2026-01-29T14:58:11.347Z
9248713 9248713 20260122014959_HWgkq DE0004 2026-01-23T14:13:29.989Z 2026-01-29T14:57:42.383Z
9248626 9248626 20260122012311_cECyX DE0004 2026-01-23T14:13:18.737Z 2026-01-29T14:57:37.583Z
9248592 9248592 20260122005848_37j9o DE0004 2026-01-23T14:13:13.607Z 2026-01-29T14:57:36.003Z
9248555 9248555 20260122004129_MFcLX DE0004 2026-01-23T14:13:04.288Z 2026-01-29T14:57:26.351Z
9248547 9248547 20260122003722_qmndS DE0004 2026-01-23T14:13:03.727Z 2026-01-29T14:57:26.090Z
9248541 9248541 20260122003700_hRYOA DE0004 2026-01-23T14:13:03.374Z 2026-01-29T14:57:25.957Z
9248454 9248454 20260121235012_ry0kX DE0004 2026-01-23T14:12:49.928Z 2026-01-29T14:57:19.657Z
9248147 9248147 20260121215300_A2wi3 DE0004 2026-01-23T14:12:08.082Z 2026-01-29T14:57:05.285Z
9247220 9247220 20260121173815_ARZeF DE0004 2026-01-23T14:09:26.783Z 2026-01-29T14:55:50.515Z
9241531 9241531 20260120205437_1feOJ DE0004 2026-01-22T14:13:34.025Z 2026-01-29T15:02:42.790Z
9237840 9237840 20260120061120_usFOF DE0004 2026-01-21T14:27:45.223Z 2026-01-28T15:01:44.295Z
9237836 9237836 20260120061117_fSCa2 DE0004 2026-01-21T14:27:45.048Z 2026-01-28T15:01:44.140Z
9237755 9237755 20260120060056_Qb2X2 DE0004 2026-01-21T14:27:35.229Z 2026-01-28T15:01:39.552Z
9237650 9237650 20260120054713_V3UWQ DE0004 2026-01-21T14:27:11.627Z 2026-01-28T15:01:34.526Z
9237485 9237485 20260120052350_eBknl DE0004 2026-01-21T14:26:44.799Z 2026-01-28T15:01:27.976Z
9237395 9237395 20260120051211_aqqCk DE0004 2026-01-21T14:26:24.634Z 2026-01-28T15:01:23.528Z
9237296 9237296 20260120045901_p5aMc DE0004 2026-01-21T14:25:52.433Z 2026-01-28T15:01:08.380Z
9237161 9237161 20260120044439_rtzbG DE0004 2026-01-21T14:25:24.890Z 2026-01-28T15:01:00.705Z
9237039 9237039 20260120042914_ppLXv DE0004 2026-01-21T14:25:00.558Z 2026-01-28T15:00:55.138Z
9236972 9236972 20260120042405_3OpJA DE0004 2026-01-21T14:24:38.232Z 2026-01-28T15:00:51.575Z
9236542 9236542 20260120033158_H5ItF DE0004 2026-01-21T14:23:11.994Z 2026-01-28T15:00:11.636Z
9236483 9236483 20260120032519_4m721 DE0004 2026-01-21T14:22:57.480Z 2026-01-28T15:00:04.219Z
9235986 9235986 20260120022506_8YbTq DE0004 2026-01-21T14:21:10.036Z 2026-01-28T14:59:31.643Z
9235956 9235956 20260120022053_ig15o DE0004 2026-01-21T14:20:53.107Z 2026-01-28T14:59:30.448Z
9235689 9235689 20260120014808_Lh1O6 DE0004 2026-01-21T14:19:59.301Z 2026-01-28T14:59:16.209Z
9234929 9234929 20260119235300_yrxfa DE0004 2026-01-21T14:16:42.845Z 2026-01-28T14:58:21.289Z
9234744 9234744 20260119231418_DzTv3 DE0004 2026-01-21T14:15:57.549Z 2026-01-28T14:58:04.065Z
9234414 9234414 20260119211759_SaPxJ DE0004 2026-01-21T14:14:21.168Z 2026-01-28T14:57:38.994Z
9234259 9234259 20260119202719_HRdTT DE0004 2026-01-21T14:13:25.800Z 2026-01-28T14:57:25.760Z
9229071 9229071 20260119004442_2njtD DE0004 2026-01-20T14:20:50.526Z 2026-01-27T15:02:52.709Z
9228498 9228498 20260118223557_cQnlV DE0004 2026-01-20T14:18:03.652Z 2026-01-27T15:02:04.618Z
9218102 9218102 20260117000904_EYW3V DE0004 2026-01-18T14:10:28.714Z 2026-01-25T14:58:00.243Z
9182584 9182584 20260111055016_euFNw DE0004 2026-01-12T14:15:04.132Z 2026-01-19T15:18:50.226Z
9182556 9182556 20260111054226_wD5WX DE0004 2026-01-12T14:14:59.268Z 2026-01-19T15:18:49.215Z
9181596 9181596 20260111022343_S0643 DE0004 2026-01-12T14:11:24.102Z 2026-01-19T15:17:39.356Z
9151227 9151227 20260105050207_Hb62k DE0004 2026-01-06T14:13:02.717Z 2026-01-13T15:14:32.771Z
9151196 9151196 20260105045154_3vGbQ DE0004 2026-01-06T14:12:55.742Z 2026-01-13T15:14:30.966Z
9151050 9151050 20260105043129_eILFi DE0004 2026-01-06T14:12:27.696Z 2026-01-13T15:14:16.624Z
9151041 9151041 20260105042934_MbIiS DE0004 2026-01-06T14:12:26.347Z 2026-01-13T15:14:16.263Z
9150541 9150541 20260105024459_tJtMv DE0004 2026-01-06T14:10:24.300Z 2026-01-13T15:13:39.793Z
9149632 9149632 20260104223918_F1ns3 DE0004 2026-01-06T14:06:23.591Z 2026-01-13T15:12:23.610Z
9144992 9144992 20260104030045_1UdxR DE0004 2026-01-05T14:19:47.517Z 2026-01-12T15:07:21.020Z
9144883 9144883 20260104025717_GEj7o DE0004 2026-01-05T14:19:39.708Z 2026-01-05T14:30:34.001Z
9143292 9143292 20260104020513_sUV4U DE0004 2026-01-05T14:17:22.420Z 2026-01-12T15:06:19.519Z
9142034 9142034 20260104011920_3ldDJ DE0004 2026-01-05T14:15:28.699Z 2026-01-12T15:05:18.338Z
9138463 9138463 20260103222715_K3WSe DE0004 2026-01-05T14:09:57.765Z 2026-01-12T15:02:50.003Z
9112474 9112474 20251231022924_4aWXI DE0004 2026-01-01T14:15:11.895Z 2026-01-08T15:07:45.489Z
9112304 9112304 20251231021832_R13Jb DE0004 2026-01-01T14:14:39.720Z 2026-01-08T15:07:37.444Z
9112146 9112146 20251231020747_spezv DE0004 2026-01-01T14:14:08.282Z 2026-01-08T15:07:22.991Z
9111461 9111461 20251231011048_JX78w DE0004 2026-01-01T14:11:34.331Z 2026-01-08T15:06:41.116Z
9111241 9111241 20251231005324_EVwik DE0004 2026-01-01T14:10:42.972Z 2026-01-08T15:06:24.441Z
9111110 9111110 20251231004150_meIfD DE0004 2026-01-01T14:10:13.883Z 2026-01-08T15:06:17.058Z
9110299 9110299 20251230224652_wgQte DE0004 2026-01-01T14:06:45.941Z 2026-01-08T15:05:17.065Z
9110281 9110281 20251230224452_NOUd2 DE0004 2026-01-01T14:06:39.577Z 2026-01-08T15:05:16.341Z
9110048 9110048 20251230220559_6h75m DE0004 2026-01-01T14:05:30.402Z 2026-01-08T15:04:56.202Z
9109921 9109921 20251230212719_w3fgw DE0004 2026-01-01T14:04:42.275Z 2026-01-08T15:04:46.665Z
9109423 9109423 20251230193502_81o7R DE0004 2026-01-01T14:00:24.882Z 2026-01-08T15:03:48.348Z
9109078 9109078 20251228172957_reEFt DE0004 2025-12-31T14:56:40.682Z 2026-01-05T15:13:46.306Z
9106960 9106960 20251229050123_zbF1f DE0004 2025-12-31T14:36:56.289Z 2026-01-06T15:18:25.203Z
9106932 9106932 20251229035328_JO1Ov DE0004 2025-12-31T14:35:51.752Z 2026-01-06T15:17:42.727Z
9106877 9106877 20251229015601_LCmJM DE0004 2025-12-31T14:34:02.288Z 2026-01-06T15:16:26.147Z
9099995 9099995 20251224211707_hQrOO DE0004 2025-12-30T15:43:18.759Z 2026-01-01T15:57:22.599Z
9099637 9099637 20251225040715_ZvSDv DE0004 2025-12-30T15:29:00.813Z 2026-01-02T15:44:27.953Z
9099619 9099619 20251225035107_IB35F DE0004 2025-12-30T15:28:54.284Z 2026-01-02T15:44:21.739Z
9099610 9099610 20251225033846_enDga DE0004 2025-12-30T15:28:47.546Z 2026-01-02T15:44:17.639Z
9099601 9099601 20251225032847_Zr72Y DE0004 2025-12-30T15:28:18.610Z 2026-01-02T15:44:14.688Z
9099540 9099540 20251225023009_YgGC8 DE0004 2025-12-30T15:27:07.919Z 2026-01-02T15:43:37.659Z
9099526 9099526 20251225021652_TJS32 DE0004 2025-12-30T15:26:58.601Z 2026-01-02T15:43:32.737Z
9099470 9099470 20251225004920_VELRT DE0004 2025-12-30T15:25:23.377Z 2026-01-02T15:42:50.469Z
9099468 9099468 20251225004903_oInMT DE0004 2025-12-30T15:25:23.055Z 2026-01-02T15:42:50.365Z
9099430 9099430 20251224235006_iOFmu DE0004 2025-12-30T15:24:53.334Z 2026-01-02T15:42:14.835Z
9098764 9098764 20251227200208_6h9cQ DE0004 2025-12-30T15:10:50.290Z 2026-01-04T15:35:26.400Z
9098285 9098285 20251227184252_AB9WB DE0004 2025-12-30T15:10:03.464Z 2026-01-04T15:34:53.764Z
9086287 9086287 20251228044421_OnBph DE0004 2025-12-30T14:40:49.471Z 2026-01-05T15:10:14.588Z
9083264 9083264 20251227232723_w8oMY DE0004 2025-12-30T14:32:06.156Z 2026-01-05T15:07:42.568Z
9082889 9082889 20251227220235_Ilo9R DE0004 2025-12-30T14:30:55.864Z 2026-01-05T15:07:30.503Z
9082643 9082643 20251227211612_B2Pku DE0004 2025-12-30T14:30:08.101Z 2025-12-30T14:53:53.587Z
9081131 9081131 20251229055059_jyYqq DE0004 2025-12-30T14:23:54.820Z 2026-01-06T15:18:52.151Z
9080994 9080994 20251229052738_VaPYW DE0004 2025-12-30T14:23:24.233Z 2026-01-06T15:18:47.465Z
9080801 9080801 20251229050749_c9PZY DE0004 2025-12-30T14:22:41.860Z 2026-01-06T15:18:30.598Z
9080452 9080452 20251229044111_k33Q5 DE0004 2025-12-30T14:21:15.863Z 2026-01-06T15:18:17.252Z
9080446 9080446 20251229044043_JIHIi DE0004 2025-12-30T14:21:15.034Z 2026-01-06T15:18:16.923Z
9080241 9080241 20251229042522_TxGe5 DE0004 2025-12-30T14:20:25.296Z 2026-01-06T15:17:57.697Z
9079721 9079721 20251229033845_j40Fm DE0004 2025-12-30T14:18:10.191Z 2026-01-06T15:17:36.171Z
9078642 9078642 20251229021903_fXl4X DE0004 2025-12-30T14:13:53.493Z 2026-01-06T15:16:35.530Z
9078470 9078470 20251229015959_1zT5a DE0004 2025-12-30T14:13:08.180Z 2026-01-06T15:16:28.242Z
9078412 9078412 20251229015601_3xq0B DE0004 2025-12-30T14:12:52.120Z 2026-01-06T15:16:25.926Z
9077761 9077761 20251229010318_sXGzR DE0004 2025-12-30T14:09:23.363Z 2026-01-06T15:15:42.551Z
9077666 9077666 20251229005359_szt6X DE0004 2025-12-30T14:08:57.527Z 2026-01-06T15:15:37.608Z
9077307 9077307 20251229001703_baJX2 DE0004 2025-12-30T14:07:30.834Z 2026-01-06T15:15:25.294Z
9076451 9076451 20251228221523_2UUPR DE0004 2025-12-30T14:03:35.975Z 2026-01-06T15:14:36.550Z
9074224 9074224 20251225192855_IX2uc DE0004 2025-12-29T15:00:18.581Z 2026-01-02T15:48:27.395Z
9074043 9074043 20251225190532_f8XDS DE0004 2025-12-29T15:00:03.514Z 2026-01-02T15:48:06.203Z
9072223 9072223 20251226203702_33le3 DE0004 2025-12-29T14:50:29.049Z 2026-01-03T15:43:45.341Z

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