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

6,046 rows where station_code = "DE000Q" 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
9260336 9260336 20260125034936_Fvohr DE000Q 2026-01-26T14:21:19.894Z 2026-01-29T14:44:06.642Z
9260289 9260289 20260125032707_zQEx4 DE000Q 2026-01-26T14:21:05.171Z 2026-01-29T14:44:04.134Z
9249664 9249664 20260122061529_LOu0I DE000Q 2026-01-23T14:15:51.995Z 2026-01-29T14:58:48.550Z
9249592 9249592 20260122060309_2jPgp DE000Q 2026-01-23T14:15:46.140Z 2026-01-29T14:58:46.280Z
9249285 9249285 20260122043817_SrQn0 DE000Q 2026-01-23T14:15:06.966Z 2026-01-29T14:58:21.738Z
9249216 9249216 20260122041421_Hm6Dp DE000Q 2026-01-23T14:14:53.061Z 2026-01-29T14:58:17.536Z
9249064 9249064 20260122032654_sfAUB DE000Q 2026-01-23T14:14:31.929Z 2026-01-29T14:58:11.347Z
9248955 9248955 20260122025507_3p1jf DE000Q 2026-01-23T14:14:10.438Z 2026-01-29T14:57:56.388Z
9248904 9248904 20260122024013_BM7Zj DE000Q 2026-01-23T14:14:06.064Z 2026-01-29T14:57:54.342Z
9248859 9248859 20260122023025_UhFMm DE000Q 2026-01-23T14:14:00.126Z 2026-01-29T14:57:50.083Z
9248606 9248606 20260122010719_N2lG3 DE000Q 2026-01-23T14:13:15.119Z 2026-01-29T14:57:36.437Z
9248215 9248215 20260121221932_Oi1Of DE000Q 2026-01-23T14:12:15.093Z 2026-01-29T14:57:08.829Z
9248025 9248025 20260121211112_E2Nmw DE000Q 2026-01-23T14:11:44.692Z 2026-01-29T14:56:48.974Z
9247994 9247994 20260121210145_TAOT2 DE000Q 2026-01-23T14:11:41.813Z 2026-01-29T14:56:47.667Z
9247652 9247652 20260121192327_3cg6v DE000Q 2026-01-23T14:10:40.888Z 2026-01-29T14:56:21.810Z
9243582 9243582 20260121044944_XxszF DE000Q 2026-01-22T14:22:15.202Z 2026-01-29T15:05:18.563Z
9237670 9237670 20260120054913_g6cn2 DE000Q 2026-01-21T14:27:16.331Z 2026-01-28T15:01:35.511Z
9237486 9237486 20260120052350_eBknl DE000Q 2026-01-21T14:26:44.799Z 2026-01-28T15:01:27.976Z
9237421 9237421 20260120051642_LLHGT DE000Q 2026-01-21T14:26:29.318Z 2026-01-28T15:01:25.214Z
9237389 9237389 20260120051041_U33Rp DE000Q 2026-01-21T14:26:24.040Z 2026-01-28T15:01:23.326Z
9237297 9237297 20260120045901_p5aMc DE000Q 2026-01-21T14:25:52.433Z 2026-01-28T15:01:08.380Z
9237180 9237180 20260120044712_K7gM0 DE000Q 2026-01-21T14:25:28.869Z 2026-01-28T15:01:01.359Z
9236993 9236993 20260120042600_J3w2M DE000Q 2026-01-21T14:24:54.030Z 2026-01-28T15:00:52.855Z
9236789 9236789 20260120035928_FWFPl DE000Q 2026-01-21T14:24:13.564Z 2026-01-28T15:00:36.112Z
9236777 9236777 20260120035907_UsmrA DE000Q 2026-01-21T14:24:11.685Z 2026-01-28T15:00:34.383Z
9236617 9236617 20260120034023_K61YA DE000Q 2026-01-21T14:23:32.264Z 2026-01-28T15:00:25.034Z
9236229 9236229 20260120024915_bTX4R DE000Q 2026-01-21T14:22:01.581Z 2026-01-28T14:59:51.229Z
9236018 9236018 20260120022747_1mjCg DE000Q 2026-01-21T14:21:15.374Z 2026-01-28T14:59:34.579Z
9235961 9235961 20260120022053_76oJi DE000Q 2026-01-21T14:20:53.328Z 2026-01-28T14:59:30.488Z
9235958 9235958 20260120022053_ig15o DE000Q 2026-01-21T14:20:53.107Z 2026-01-28T14:59:30.448Z
9235942 9235942 20260120022026_ILVpB DE000Q 2026-01-21T14:20:51.195Z 2026-01-28T14:59:29.767Z
9235709 9235709 20260120015059_F2ECn DE000Q 2026-01-21T14:20:01.867Z 2026-01-28T14:59:16.788Z
9235633 9235633 20260120014129_2gV3X DE000Q 2026-01-21T14:19:45.700Z 2026-01-28T14:59:13.517Z
9235439 9235439 20260120011405_v8P4l DE000Q 2026-01-21T14:18:54.241Z 2026-01-28T14:58:55.309Z
9235310 9235310 20260120005256_mhiVs DE000Q 2026-01-21T14:18:26.427Z 2026-01-28T14:58:48.724Z
9235182 9235182 20260120004131_sbZfD DE000Q 2026-01-21T14:17:50.931Z 2026-01-28T14:58:41.976Z
9235171 9235171 20260120004050_AP24L DE000Q 2026-01-21T14:17:50.080Z 2026-01-28T14:58:37.023Z
9235093 9235093 20260120002904_LAymY DE000Q 2026-01-21T14:17:29.313Z 2026-01-28T14:58:30.501Z
9234949 9234949 20260119235356_rAaho DE000Q 2026-01-21T14:16:48.279Z 2026-01-28T14:58:21.822Z
9234930 9234930 20260119235300_yrxfa DE000Q 2026-01-21T14:16:42.845Z 2026-01-28T14:58:21.289Z
9234781 9234781 20260119232046_5msD3 DE000Q 2026-01-21T14:16:04.603Z 2026-01-28T14:58:08.953Z
9234779 9234779 20260119232045_vt4ho DE000Q 2026-01-21T14:16:04.195Z 2026-01-28T14:58:05.979Z
9234159 9234159 20260119195428_STOvc DE000Q 2026-01-21T14:12:41.678Z 2026-01-28T14:57:18.867Z
9182699 9182699 20260111061514_ZTdys DE000Q 2026-01-12T14:15:27.447Z 2026-01-19T15:18:55.812Z
9182684 9182684 20260111060820_Yty6Z DE000Q 2026-01-12T14:15:24.833Z 2026-01-19T15:18:55.171Z
9182660 9182660 20260111060110_fVIBO DE000Q 2026-01-12T14:15:20.211Z 2026-01-19T15:18:53.995Z
9182585 9182585 20260111055016_euFNw DE000Q 2026-01-12T14:15:04.132Z 2026-01-19T15:18:50.226Z
9182537 9182537 20260111053911_13kM9 DE000Q 2026-01-12T14:14:55.396Z 2026-01-19T15:18:48.610Z
9182529 9182529 20260111053727_enKcG DE000Q 2026-01-12T14:14:52.380Z 2026-01-19T15:18:48.405Z
9182495 9182495 20260111053238_RWfQ7 DE000Q 2026-01-12T14:14:45.930Z 2026-01-19T15:18:44.612Z
9182403 9182403 20260111052108_5P62T DE000Q 2026-01-12T14:14:28.532Z 2026-01-19T15:18:31.159Z
9182370 9182370 20260111051201_uUFaK DE000Q 2026-01-12T14:14:16.820Z 2026-01-19T15:18:29.611Z
9182065 9182065 20260111040824_GJXaj DE000Q 2026-01-12T14:13:08.682Z 2026-01-19T15:18:14.207Z
9182050 9182050 20260111040546_aCQe2 DE000Q 2026-01-12T14:13:04.231Z 2026-01-19T15:18:13.436Z
9181992 9181992 20260111035744_gVRYd DE000Q 2026-01-12T14:12:52.830Z 2026-01-19T15:17:59.123Z
9181784 9181784 20260111030625_yUddl DE000Q 2026-01-12T14:12:07.833Z 2026-01-19T15:17:48.401Z
9181624 9181624 20260111022740_zGPEr DE000Q 2026-01-12T14:11:30.945Z 2026-01-19T15:17:40.840Z
9181425 9181425 20260111014315_ZbP0f DE000Q 2026-01-12T14:10:46.150Z 2026-01-19T15:17:17.464Z
9181285 9181285 20260111011330_3vTa9 DE000Q 2026-01-12T14:10:15.305Z 2026-01-19T15:17:11.303Z
9181154 9181154 20260111003711_Jcsvs DE000Q 2026-01-12T14:09:45.556Z 2026-01-19T15:17:05.672Z
9181057 9181057 20260111000714_l4oKT DE000Q 2026-01-12T14:09:26.609Z 2026-01-19T15:16:46.203Z
9181034 9181034 20260110235811_t82ye DE000Q 2026-01-12T14:09:19.498Z 2026-01-19T15:16:45.102Z
9181018 9181018 20260110235538_yp8qd DE000Q 2026-01-12T14:09:14.877Z 2026-01-19T15:16:44.356Z
9180968 9180968 20260110233758_FEIBL DE000Q 2026-01-12T14:09:06.575Z 2026-01-19T15:16:42.512Z
9180912 9180912 20260110232338_h1KUR DE000Q 2026-01-12T14:08:52.220Z 2026-01-19T15:16:38.611Z
9171877 9171877 20260109041704_eQyOD DE000Q 2026-01-10T14:10:13.174Z 2026-01-17T15:24:39.935Z
9162807 9162807 20260107043747_uZaHH DE000Q 2026-01-08T14:06:56.821Z 2026-01-13T15:02:40.113Z
9162262 9162262 20260107011914_W3Mlq DE000Q 2026-01-08T14:04:03.449Z 2026-01-13T15:01:56.993Z
9162210 9162210 20260107003607_blnsJ DE000Q 2026-01-08T14:03:35.663Z 2026-01-13T15:01:46.093Z
9162127 9162127 20260106222644_EdmC9 DE000Q 2026-01-08T14:03:05.832Z 2026-01-13T15:01:38.579Z
9151051 9151051 20260105043129_eILFi DE000Q 2026-01-06T14:12:27.697Z 2026-01-13T15:14:16.624Z
9150897 9150897 20260105035739_3I0AS DE000Q 2026-01-06T14:11:50.598Z 2026-01-13T15:14:06.974Z
9149523 9149523 20260104213419_Hhxi8 DE000Q 2026-01-06T14:05:48.915Z 2026-01-13T15:12:15.457Z
9149503 9149503 20260104213249_v6EcT DE000Q 2026-01-06T14:05:45.927Z 2026-01-13T15:12:14.778Z
9120092 9120092 20251228053854_BnYlm DE000Q 2026-01-01T15:25:38.645Z 2026-01-05T15:10:32.457Z
9111462 9111462 20251231011048_JX78w DE000Q 2026-01-01T14:11:34.331Z 2026-01-08T15:06:41.116Z
9110886 9110886 20251231001228_TAozt DE000Q 2026-01-01T14:09:15.085Z 2026-01-08T15:05:58.773Z
9110588 9110588 20251230233306_QGkG1 DE000Q 2026-01-01T14:07:57.934Z 2026-01-08T15:05:40.681Z
9110300 9110300 20251230224652_wgQte DE000Q 2026-01-01T14:06:45.941Z 2026-01-08T15:05:17.065Z
9110190 9110190 20251230223003_jI9ua DE000Q 2026-01-01T14:06:15.768Z 2026-01-08T15:05:11.961Z
9110057 9110057 20251230220953_oDzws DE000Q 2026-01-01T14:05:34.697Z 2026-01-01T14:57:49.191Z
9109890 9109890 20251230211248_cp3TO DE000Q 2026-01-01T14:04:26.302Z 2026-01-08T15:04:43.605Z
9109555 9109555 20251230195446_BED3O DE000Q 2026-01-01T14:01:38.135Z 2026-01-08T15:03:59.854Z
9104440 9104440 20251230055345_ZXtOA DE000Q 2025-12-31T14:21:14.369Z 2026-01-07T15:09:42.926Z
9104161 9104161 20251230053500_qMnYS DE000Q 2025-12-31T14:20:30.420Z 2026-01-07T15:09:33.021Z
9103874 9103874 20251230051324_Jj8PK DE000Q 2025-12-31T14:19:35.741Z 2026-01-07T15:09:13.347Z
9103708 9103708 20251230045357_stxjr DE000Q 2025-12-31T14:18:56.681Z 2026-01-07T15:09:05.601Z
9103691 9103691 20251230045302_1GxGH DE000Q 2025-12-31T14:18:53.773Z 2026-01-07T15:09:05.037Z
9103618 9103618 20251230044625_DgmhI DE000Q 2025-12-31T14:18:31.096Z 2026-01-07T15:09:00.214Z
9103495 9103495 20251230043328_BYc5Z DE000Q 2025-12-31T14:18:00.031Z 2026-01-07T15:08:47.196Z
9103464 9103464 20251230043132_22dps DE000Q 2025-12-31T14:17:55.550Z 2026-01-07T15:08:44.794Z
9103074 9103074 20251230035420_YrG9t DE000Q 2025-12-31T14:16:22.194Z 2026-01-07T15:08:17.969Z
9102593 9102593 20251230031553_xJFHO DE000Q 2025-12-31T14:14:32.208Z 2026-01-07T15:07:45.521Z
9102333 9102333 20251230025129_24KyA DE000Q 2025-12-31T14:13:25.762Z 2026-01-07T15:07:34.275Z
9102198 9102198 20251230023513_0E7pt DE000Q 2025-12-31T14:12:40.156Z 2026-01-07T15:07:18.294Z
9102058 9102058 20251230022037_hsPPk DE000Q 2025-12-31T14:11:55.223Z 2026-01-07T15:07:09.724Z
9102035 9102035 20251230021914_OlUxP DE000Q 2025-12-31T14:11:51.037Z 2026-01-07T15:07:08.766Z
9101697 9101697 20251230011953_z7HPR DE000Q 2025-12-31T14:10:01.726Z 2026-01-07T15:06:42.215Z
9100000 9100000 20251224211754_eHcJA DE000Q 2025-12-30T15:43:19.082Z 2026-01-01T15:57:22.732Z
9099758 9099758 20251225061143_EvXiv DE000Q 2025-12-30T15:31:18.949Z 2026-01-02T15:45:41.038Z

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