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

>10,000 rows count all where station_code = "DE0001" 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
9260288 9260288 20260125032707_zQEx4 DE0001 2026-01-26T14:21:05.165Z 2026-01-29T14:44:04.134Z
9252118 9252118 20260123010416_p9pqA DE0001 2026-01-24T14:14:23.496Z 2026-01-29T14:52:34.475Z
9249662 9249662 20260122061529_LOu0I DE0001 2026-01-23T14:15:51.995Z 2026-01-29T14:58:48.550Z
9249645 9249645 20260122060951_3DBYU DE0001 2026-01-23T14:15:50.014Z 2026-01-29T14:58:47.691Z
9249591 9249591 20260122060309_2jPgp DE0001 2026-01-23T14:15:46.139Z 2026-01-29T14:58:46.280Z
9249576 9249576 20260122055312_W0InN DE0001 2026-01-23T14:15:44.154Z 2026-01-29T14:58:45.344Z
9249499 9249499 20260122053218_KuYAx DE0001 2026-01-23T14:15:36.267Z 2026-01-29T14:58:41.960Z
9249445 9249445 20260122052324_Ue3Ne DE0001 2026-01-23T14:15:26.963Z 2026-01-29T14:58:40.019Z
9249361 9249361 20260122050259_TBIjR DE0001 2026-01-23T14:15:13.869Z 2026-01-29T14:58:27.312Z
9249237 9249237 20260122042140_oJZQs DE0001 2026-01-23T14:15:02.494Z 2026-01-29T14:58:19.346Z
9249183 9249183 20260122040146_RQRpe DE0001 2026-01-23T14:14:44.542Z 2026-01-29T14:58:15.850Z
9249050 9249050 20260122032239_fNL7X DE0001 2026-01-23T14:14:30.466Z 2026-01-29T14:58:10.783Z
9248954 9248954 20260122025507_3p1jf DE0001 2026-01-23T14:14:10.438Z 2026-01-29T14:57:56.388Z
9248858 9248858 20260122023025_UhFMm DE0001 2026-01-23T14:14:00.126Z 2026-01-29T14:57:50.083Z
9248844 9248844 20260122022633_nKehQ DE0001 2026-01-23T14:13:58.526Z 2026-01-29T14:57:49.457Z
9248605 9248605 20260122010719_N2lG3 DE0001 2026-01-23T14:13:15.119Z 2026-01-29T14:57:36.437Z
9248503 9248503 20260122002339_jhiHX DE0001 2026-01-23T14:12:57.093Z 2026-01-29T14:57:24.275Z
9248217 9248217 20260121222134_6NOow DE0001 2026-01-23T14:12:15.437Z 2026-01-29T14:57:08.997Z
9248057 9248057 20260121212100_qyaDu DE0001 2026-01-23T14:11:48.551Z 2026-01-29T14:56:52.639Z
9243581 9243581 20260121044944_XxszF DE0001 2026-01-22T14:22:15.202Z 2026-01-29T15:05:18.563Z
9240938 9240938 20260120183152_cKY0a DE0001 2026-01-22T14:10:58.400Z 2026-01-29T15:02:03.624Z
9240691 9240691 20260120172532_Jpwsa DE0001 2026-01-22T14:09:36.910Z 2026-01-29T15:01:45.924Z
9237668 9237668 20260120054913_g6cn2 DE0001 2026-01-21T14:27:16.331Z 2026-01-28T15:01:35.511Z
9237609 9237609 20260120054252_GCk5W DE0001 2026-01-21T14:27:07.370Z 2026-01-28T15:01:32.986Z
9237484 9237484 20260120052350_eBknl DE0001 2026-01-21T14:26:44.799Z 2026-01-28T15:01:27.976Z
9237433 9237433 20260120051750_4b362 DE0001 2026-01-21T14:26:29.925Z 2026-01-28T15:01:25.484Z
9237420 9237420 20260120051642_LLHGT DE0001 2026-01-21T14:26:29.318Z 2026-01-28T15:01:25.214Z
9237332 9237332 20260120050524_3HUs3 DE0001 2026-01-21T14:26:00.326Z 2026-01-28T15:01:20.169Z
9237179 9237179 20260120044712_K7gM0 DE0001 2026-01-21T14:25:28.869Z 2026-01-28T15:01:01.359Z
9236776 9236776 20260120035907_UsmrA DE0001 2026-01-21T14:24:11.685Z 2026-01-28T15:00:34.383Z
9236615 9236615 20260120034023_K61YA DE0001 2026-01-21T14:23:32.264Z 2026-01-28T15:00:25.034Z
9236507 9236507 20260120032843_x4FcR DE0001 2026-01-21T14:23:00.625Z 2026-01-28T15:00:05.765Z
9236228 9236228 20260120024915_bTX4R DE0001 2026-01-21T14:22:01.581Z 2026-01-28T14:59:51.229Z
9236017 9236017 20260120022747_1mjCg DE0001 2026-01-21T14:21:15.374Z 2026-01-28T14:59:34.579Z
9235955 9235955 20260120022053_ig15o DE0001 2026-01-21T14:20:53.107Z 2026-01-28T14:59:30.448Z
9235941 9235941 20260120022026_ILVpB DE0001 2026-01-21T14:20:51.195Z 2026-01-28T14:59:29.767Z
9235915 9235915 20260120021759_rG0lR DE0001 2026-01-21T14:20:45.387Z 2026-01-28T14:59:28.882Z
9235707 9235707 20260120015059_F2ECn DE0001 2026-01-21T14:20:01.867Z 2026-01-28T14:59:16.788Z
9235399 9235399 20260120010527_s3Knd DE0001 2026-01-21T14:18:47.937Z 2026-01-28T14:58:52.907Z
9235302 9235302 20260120005239_6ZvS8 DE0001 2026-01-21T14:18:25.544Z 2026-01-28T14:58:48.456Z
9235201 9235201 20260120004314_9NdDi DE0001 2026-01-21T14:17:54.091Z 2026-01-28T14:58:43.379Z
9235199 9235199 20260120004313_rasDc DE0001 2026-01-21T14:17:53.636Z 2026-01-28T14:58:43.211Z
9235181 9235181 20260120004131_sbZfD DE0001 2026-01-21T14:17:50.931Z 2026-01-28T14:58:41.976Z
9235170 9235170 20260120004050_AP24L DE0001 2026-01-21T14:17:50.080Z 2026-01-28T14:58:37.023Z
9234948 9234948 20260119235356_rAaho DE0001 2026-01-21T14:16:48.278Z 2026-01-28T14:58:21.822Z
9231009 9231009 20260119054208_SBQ0J DE0001 2026-01-20T14:30:53.597Z 2026-01-27T15:05:52.717Z
9230824 9230824 20260119051443_Ayx1q DE0001 2026-01-20T14:29:58.363Z 2026-01-27T15:05:28.995Z
9230630 9230630 20260119044221_3r82M DE0001 2026-01-20T14:28:59.748Z 2026-01-27T15:05:17.661Z
9230317 9230317 20260119040028_CXA1m DE0001 2026-01-20T14:27:13.483Z 2026-01-27T15:04:48.451Z
9230277 9230277 20260119035106_TxQev DE0001 2026-01-20T14:26:58.256Z 2026-01-27T15:04:45.852Z
9230175 9230175 20260119033741_Qw4ax DE0001 2026-01-20T14:26:25.470Z 2026-01-27T15:04:31.711Z
9230131 9230131 20260119033145_oF2Iw DE0001 2026-01-20T14:26:11.973Z 2026-01-27T15:04:29.248Z
9230128 9230128 20260119033145_dFkLp DE0001 2026-01-20T14:26:11.220Z 2026-01-27T15:04:29.098Z
9230057 9230057 20260119031850_TnGqa DE0001 2026-01-20T14:25:43.204Z 2026-01-27T15:04:22.788Z
9230041 9230041 20260119031522_352Vr DE0001 2026-01-20T14:25:36.840Z 2026-01-27T15:04:22.023Z
9230027 9230027 20260119031248_IGXFd DE0001 2026-01-20T14:25:31.815Z 2026-01-27T15:04:21.161Z
9229852 9229852 20260119024538_N3Ebw DE0001 2026-01-20T14:24:37.581Z 2026-01-27T15:04:00.844Z
9229384 9229384 20260119013912_OLx0J DE0001 2026-01-20T14:22:19.169Z 2026-01-27T15:03:21.334Z
9229183 9229183 20260119010327_BJeYu DE0001 2026-01-20T14:21:21.971Z 2026-01-27T15:03:10.343Z
9228977 9228977 20260119002800_ZaaWz DE0001 2026-01-20T14:20:23.819Z 2026-01-27T15:02:46.107Z
9228806 9228806 20260118235617_yqQjc DE0001 2026-01-20T14:19:37.865Z 2026-01-27T15:02:36.627Z
9228780 9228780 20260118235018_1hTpQ DE0001 2026-01-20T14:19:27.140Z 2026-01-27T15:02:34.574Z
9228640 9228640 20260118232250_H2cK0 DE0001 2026-01-20T14:18:47.650Z 2026-01-27T15:02:12.572Z
9228437 9228437 20260118222201_Eh2gr DE0001 2026-01-20T14:17:50.031Z 2026-01-27T15:02:01.173Z
9224624 9224624 20260118052339_4PcQT DE0001 2026-01-19T14:25:13.577Z 2026-01-26T15:03:42.561Z
9224597 9224597 20260118051710_DJH7F DE0001 2026-01-19T14:25:08.779Z 2026-01-26T15:03:30.352Z
9224427 9224427 20260118044229_eFHaL DE0001 2026-01-19T14:24:21.319Z 2026-01-26T15:03:18.569Z
9224261 9224261 20260118040646_BarRZ DE0001 2026-01-19T14:23:39.089Z 2026-01-26T15:03:11.212Z
9224234 9224234 20260118035920_DhzLu DE0001 2026-01-19T14:23:32.067Z 2026-01-26T15:03:10.120Z
9224162 9224162 20260118034002_kYPmt DE0001 2026-01-19T14:23:08.705Z 2026-01-26T15:03:07.292Z
9224139 9224139 20260118033348_w9FY1 DE0001 2026-01-19T14:23:03.797Z 2026-01-26T15:03:06.434Z
9224029 9224029 20260118031137_ecQDE DE0001 2026-01-19T14:22:28.061Z 2026-01-26T15:02:48.432Z
9223766 9223766 20260118022245_GQG2N DE0001 2026-01-19T14:21:05.235Z 2026-01-26T15:02:35.324Z
9223739 9223739 20260118021616_SB22l DE0001 2026-01-19T14:20:48.701Z 2026-01-26T15:02:34.207Z
9223724 9223724 20260118021317_5ceD4 DE0001 2026-01-19T14:20:46.835Z 2026-01-26T15:02:33.939Z
9223516 9223516 20260118010910_tSoVi DE0001 2026-01-19T14:19:42.910Z 2026-01-26T15:02:12.807Z
9223471 9223471 20260118005057_qzOuY DE0001 2026-01-19T14:19:29.245Z 2026-01-26T15:02:08.238Z
9223329 9223329 20260118001616_3nss5 DE0001 2026-01-19T14:18:47.842Z 2026-01-26T15:02:02.557Z
9218796 9218796 20260117054947_UKcRM DE0001 2026-01-18T14:13:42.907Z 2026-01-25T14:58:51.469Z
9218670 9218670 20260117051409_toN0r DE0001 2026-01-18T14:13:09.703Z 2026-01-25T14:58:34.972Z
9207149 9207149 20260114223741_58kSv DE0001 2026-01-16T14:07:21.661Z 2026-01-22T15:03:11.982Z
9182715 9182715 20260111061840_n57HC DE0001 2026-01-12T14:15:30.347Z 2026-01-19T15:18:56.528Z
9182698 9182698 20260111061514_ZTdys DE0001 2026-01-12T14:15:27.447Z 2026-01-19T15:18:55.812Z
9182658 9182658 20260111060110_fVIBO DE0001 2026-01-12T14:15:20.211Z 2026-01-19T15:18:53.995Z
9182645 9182645 20260111060020_rnTwg DE0001 2026-01-12T14:15:16.912Z 2026-01-19T15:18:53.357Z
9182555 9182555 20260111054226_wD5WX DE0001 2026-01-12T14:14:59.268Z 2026-01-19T15:18:49.215Z
9182536 9182536 20260111053911_13kM9 DE0001 2026-01-12T14:14:55.396Z 2026-01-19T15:18:48.610Z
9182494 9182494 20260111053238_RWfQ7 DE0001 2026-01-12T14:14:45.930Z 2026-01-19T15:18:44.612Z
9182402 9182402 20260111052108_5P62T DE0001 2026-01-12T14:14:28.532Z 2026-01-19T15:18:31.159Z
9182369 9182369 20260111051201_uUFaK DE0001 2026-01-12T14:14:16.820Z 2026-01-19T15:18:29.611Z
9182049 9182049 20260111040546_aCQe2 DE0001 2026-01-12T14:13:04.231Z 2026-01-19T15:18:13.436Z
9181991 9181991 20260111035744_gVRYd DE0001 2026-01-12T14:12:52.830Z 2026-01-19T15:17:59.123Z
9181623 9181623 20260111022740_zGPEr DE0001 2026-01-12T14:11:30.945Z 2026-01-19T15:17:40.840Z
9181533 9181533 20260111020500_7fuuD DE0001 2026-01-12T14:11:08.975Z 2026-01-19T15:17:23.428Z
9181436 9181436 20260111014436_5xcN4 DE0001 2026-01-12T14:10:48.717Z 2026-01-19T15:17:17.909Z
9181273 9181273 20260111011231_PrivI DE0001 2026-01-12T14:10:12.983Z 2026-01-19T15:17:10.686Z
9181248 9181248 20260111010802_XxYpI DE0001 2026-01-12T14:10:06.797Z 2026-01-19T15:17:09.564Z
9181158 9181158 20260111003722_C8Tvk DE0001 2026-01-12T14:09:47.959Z 2026-01-19T15:17:05.920Z
9181153 9181153 20260111003711_Jcsvs DE0001 2026-01-12T14:09:45.556Z 2026-01-19T15:17:05.672Z
9181056 9181056 20260111000714_l4oKT DE0001 2026-01-12T14:09:26.609Z 2026-01-19T15:16:46.203Z

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