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 = "DE0005" 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
9260124 9260124 20260125024100_Ns8YM DE0005 2026-01-26T14:20:21.242Z 2026-01-29T14:43:49.970Z
9260114 9260114 20260125023806_Tk2WP DE0005 2026-01-26T14:20:19.450Z 2026-01-29T14:43:49.400Z
9259871 9259871 20260125005306_wkXmh DE0005 2026-01-26T14:19:06.208Z 2026-01-29T14:43:32.008Z
9259810 9259810 20260125002611_CrZoK DE0005 2026-01-26T14:18:40.043Z 2026-01-29T14:43:22.724Z
9259796 9259796 20260125002224_jdC9w DE0005 2026-01-26T14:18:37.660Z 2026-01-29T14:43:21.868Z
9259731 9259731 20260124234424_fVzsY DE0005 2026-01-26T14:18:18.658Z 2026-01-29T14:43:15.894Z
9252696 9252696 20260123052152_rrw6K DE0005 2026-01-24T14:16:46.064Z 2026-01-29T14:53:16.865Z
9252642 9252642 20260123045403_XTeih DE0005 2026-01-24T14:16:32.310Z 2026-01-29T14:53:13.123Z
9249622 9249622 20260122060651_22W1P DE0005 2026-01-23T14:15:48.586Z 2026-01-29T14:58:47.241Z
9249541 9249541 20260122053921_6VE3Y DE0005 2026-01-23T14:15:40.730Z 2026-01-29T14:58:43.825Z
9249520 9249520 20260122053608_MX72P DE0005 2026-01-23T14:15:38.217Z 2026-01-29T14:58:42.950Z
9249515 9249515 20260122053409_m1sh3 DE0005 2026-01-23T14:15:37.814Z 2026-01-29T14:58:42.728Z
9249485 9249485 20260122053027_h8UGI DE0005 2026-01-23T14:15:34.555Z 2026-01-29T14:58:41.546Z
9249442 9249442 20260122052207_gpX3b DE0005 2026-01-23T14:15:26.635Z 2026-01-29T14:58:39.366Z
9249425 9249425 20260122051503_Mi2RW DE0005 2026-01-23T14:15:21.235Z 2026-01-29T14:58:30.110Z
9249407 9249407 20260122051019_2RiAI DE0005 2026-01-23T14:15:18.963Z 2026-01-29T14:58:29.193Z
9249359 9249359 20260122050241_34R3k DE0005 2026-01-23T14:15:13.499Z 2026-01-29T14:58:27.167Z
9249299 9249299 20260122044035_yfy6L DE0005 2026-01-23T14:15:08.238Z 2026-01-29T14:58:22.261Z
9249275 9249275 20260122043530_u9Z2n DE0005 2026-01-23T14:15:06.363Z 2026-01-29T14:58:21.433Z
9249135 9249135 20260122034520_NqVvz DE0005 2026-01-23T14:14:39.361Z 2026-01-29T14:58:14.099Z
9248994 9248994 20260122030511_e2oVd DE0005 2026-01-23T14:14:16.664Z 2026-01-29T14:58:07.586Z
9248965 9248965 20260122025609_a3NIl DE0005 2026-01-23T14:14:13.352Z 2026-01-29T14:57:57.846Z
9248937 9248937 20260122025135_4zUvD DE0005 2026-01-23T14:14:08.348Z 2026-01-29T14:57:55.536Z
9248923 9248923 20260122024422_mOeM2 DE0005 2026-01-23T14:14:06.867Z 2026-01-29T14:57:54.791Z
9248772 9248772 20260122020728_PyHCG DE0005 2026-01-23T14:13:49.273Z 2026-01-29T14:57:46.035Z
9248654 9248654 20260122013354_6DbJg DE0005 2026-01-23T14:13:21.878Z 2026-01-29T14:57:38.978Z
9248283 9248283 20260121224615_6kDDh DE0005 2026-01-23T14:12:24.323Z 2026-01-29T14:57:11.714Z
9248130 9248130 20260121214116_aRRXj DE0005 2026-01-23T14:12:05.943Z 2026-01-29T14:56:55.853Z
9247934 9247934 20260121203638_3oYiS DE0005 2026-01-23T14:11:34.280Z 2026-01-29T14:56:44.506Z
9237621 9237621 20260120054452_Srttm DE0005 2026-01-21T14:27:08.800Z 2026-01-28T15:01:33.502Z
9237532 9237532 20260120053156_z23C1 DE0005 2026-01-21T14:26:52.761Z 2026-01-28T15:01:29.777Z
9237470 9237470 20260120052107_9DOPZ DE0005 2026-01-21T14:26:41.018Z 2026-01-28T15:01:27.113Z
9237360 9237360 20260120050654_tuLtn DE0005 2026-01-21T14:26:17.372Z 2026-01-28T15:01:21.813Z
9237269 9237269 20260120045618_tdEd2 DE0005 2026-01-21T14:25:49.041Z 2026-01-28T15:01:06.868Z
9236890 9236890 20260120041447_INjJ0 DE0005 2026-01-21T14:24:26.715Z 2026-01-28T15:00:42.017Z
9236736 9236736 20260120035315_EgjU3 DE0005 2026-01-21T14:23:51.650Z 2026-01-28T15:00:32.588Z
9236479 9236479 20260120032427_he3Pp DE0005 2026-01-21T14:22:56.806Z 2026-01-28T15:00:03.813Z
9236418 9236418 20260120031349_XABJO DE0005 2026-01-21T14:22:46.250Z 2026-01-28T14:59:59.155Z
9236352 9236352 20260120030526_Jrk0v DE0005 2026-01-21T14:22:28.708Z 2026-01-28T14:59:56.810Z
9236313 9236313 20260120025938_x3B1y DE0005 2026-01-21T14:22:19.666Z 2026-01-28T14:59:54.664Z
9236246 9236246 20260120025100_0CCjJ DE0005 2026-01-21T14:22:10.435Z 2026-01-28T14:59:51.791Z
9236005 9236005 20260120022649_Q2Ovv DE0005 2026-01-21T14:21:13.480Z 2026-01-28T14:59:32.572Z
9235949 9235949 20260120022033_5vaZw DE0005 2026-01-21T14:20:51.902Z 2026-01-28T14:59:30.068Z
9235846 9235846 20260120020723_889Bt DE0005 2026-01-21T14:20:33.467Z 2026-01-28T14:59:24.133Z
9235762 9235762 20260120015700_523hv DE0005 2026-01-21T14:20:10.338Z 2026-01-28T14:59:19.503Z
9235739 9235739 20260120015515_X8kA2 DE0005 2026-01-21T14:20:07.280Z 2026-01-28T14:59:18.421Z
9235688 9235688 20260120014727_ijtFN DE0005 2026-01-21T14:19:58.243Z 2026-01-28T14:59:16.105Z
9235479 9235479 20260120012026_LQNQX DE0005 2026-01-21T14:19:03.387Z 2026-01-28T14:58:57.467Z
9235246 9235246 20260120004718_eSGrJ DE0005 2026-01-21T14:18:06.618Z 2026-01-28T14:58:45.555Z
9235048 9235048 20260120001812_I0cIl DE0005 2026-01-21T14:17:18.148Z 2026-01-28T14:58:26.680Z
9234790 9234790 20260119232407_NCnTz DE0005 2026-01-21T14:16:06.309Z 2026-01-28T14:58:13.349Z
9234767 9234767 20260119231815_i4f0D DE0005 2026-01-21T14:16:01.394Z 2026-01-28T14:58:05.173Z
9234755 9234755 20260119231548_ZJQMu DE0005 2026-01-21T14:15:59.312Z 2026-01-28T14:58:04.474Z
9234258 9234258 20260119202719_baDtg DE0005 2026-01-21T14:13:25.459Z 2026-01-28T14:57:25.598Z
9234200 9234200 20260119200453_BAwU5 DE0005 2026-01-21T14:12:57.930Z 2026-01-28T14:57:21.198Z
9228521 9228521 20260118224139_DH4Xa DE0005 2026-01-20T14:18:07.813Z 2026-01-27T15:02:05.386Z
9228448 9228448 20260118222424_fqmDy DE0005 2026-01-20T14:17:51.873Z 2026-01-27T15:02:01.767Z
9228434 9228434 20260118222058_0pITm DE0005 2026-01-20T14:17:49.275Z 2026-01-27T15:02:00.873Z
9228355 9228355 20260118214826_DcuGV DE0005 2026-01-20T14:17:24.413Z 2026-01-27T15:01:55.730Z
9227993 9227993 20260118190450_qPv3V DE0005 2026-01-20T14:15:21.315Z 2026-01-27T15:01:10.025Z
9218012 9218012 20260116215049_pSxb2 DE0005 2026-01-18T14:09:58.163Z 2026-01-25T14:57:55.080Z
9182526 9182526 20260111053616_9mnOg DE0005 2026-01-12T14:14:51.468Z 2026-01-19T15:18:48.205Z
9182149 9182149 20260111042945_eyF4j DE0005 2026-01-12T14:13:28.222Z 2026-01-19T15:18:17.485Z
9182124 9182124 20260111042518_7yW2M DE0005 2026-01-12T14:13:21.667Z 2026-01-19T15:18:16.612Z
9182091 9182091 20260111041750_7yHKK DE0005 2026-01-12T14:13:16.030Z 2026-01-19T15:18:15.474Z
9181819 9181819 20260111031936_gIRay DE0005 2026-01-12T14:12:13.950Z 2026-01-19T15:17:49.961Z
9181559 9181559 20260111021040_8E2yu DE0005 2026-01-12T14:11:15.908Z 2026-01-19T15:17:24.437Z
9180902 9180902 20260110231859_bkIZT DE0005 2026-01-12T14:08:49.733Z 2026-01-19T15:16:38.129Z
9141932 9141932 20260104011453_MRRf6 DE0005 2026-01-05T14:15:22.171Z 2026-01-12T15:05:15.153Z
9141506 9141506 20260104005721_ArHAZ DE0005 2026-01-05T14:14:42.893Z 2026-01-12T15:05:02.788Z
9141310 9141310 20260104004915_hH2UG DE0005 2026-01-05T14:14:24.726Z 2026-01-12T15:04:57.557Z
9139860 9139860 20260103234905_XufE0 DE0005 2026-01-05T14:12:15.195Z 2026-01-12T15:03:52.394Z
9139800 9139800 20260103234712_KuhIc DE0005 2026-01-05T14:12:13.009Z 2026-01-12T15:03:51.385Z
9139339 9139339 20260103232903_G2upt DE0005 2026-01-05T14:11:29.585Z 2026-01-12T15:03:26.211Z
9139057 9139057 20260103230955_ksqGc DE0005 2026-01-05T14:11:07.213Z 2026-01-12T15:03:19.478Z
9139034 9139034 20260103230806_MPrqr DE0005 2026-01-05T14:11:04.938Z 2026-01-12T15:03:18.801Z
9138295 9138295 20260103221658_bE3lN DE0005 2026-01-05T14:09:48.081Z 2026-01-12T15:02:45.880Z
9133918 9133918 20260102164848_y5aWu DE0005 2026-01-04T14:29:42.428Z 2026-01-09T14:50:58.286Z
9129665 9129665 20260102235004_QTXWQ DE0005 2026-01-04T14:05:19.193Z 2026-01-10T14:58:02.742Z
9129366 9129366 20260102214631_7RS5m DE0005 2026-01-04T14:03:38.696Z 2026-01-10T14:57:35.994Z
9129250 9129250 20260102203958_VQXfr DE0005 2026-01-04T14:02:58.576Z 2026-01-10T14:57:23.224Z
9119371 9119371 20251230174322_1RkxK DE0005 2026-01-01T14:55:58.090Z 2026-01-07T15:12:29.658Z
9118727 9118727 20251230052646_wqLp5 DE0005 2026-01-01T14:49:12.944Z 2026-01-07T15:09:19.405Z
9111558 9111558 20251231012254_Zw9tj DE0005 2026-01-01T14:11:57.055Z 2026-01-08T15:06:45.880Z
9110853 9110853 20251231000935_da8BZ DE0005 2026-01-01T14:09:03.451Z 2026-01-08T15:05:56.821Z
9109788 9109788 20251230205300_IVTzp DE0005 2026-01-01T14:03:50.321Z 2026-01-08T15:04:28.763Z
9106851 9106851 20251229004759_luYwW DE0005 2025-12-31T14:32:58.883Z 2026-01-06T15:15:36.209Z
9104028 9104028 20251230052647_0vRhq DE0005 2025-12-31T14:20:03.066Z 2026-01-07T15:09:19.532Z
9103940 9103940 20251230052040_nO0v9 DE0005 2025-12-31T14:19:51.875Z 2026-01-07T15:09:16.709Z
9103862 9103862 20251230051124_JZFsW DE0005 2025-12-31T14:19:32.468Z 2026-01-07T15:09:12.694Z
9100005 9100005 20251224215118_l18Vg DE0005 2025-12-30T15:43:25.811Z 2026-01-01T15:57:25.942Z
9099681 9099681 20251225050725_RMfIX DE0005 2025-12-30T15:30:10.812Z 2026-01-02T15:45:00.830Z
9099657 9099657 20251225043330_jqR2z DE0005 2025-12-30T15:29:54.496Z 2026-01-02T15:44:51.496Z
9099653 9099653 20251225042659_nI46T DE0005 2025-12-30T15:29:44.611Z 2026-01-02T15:44:49.477Z
9099615 9099615 20251225034353_bcvvZ DE0005 2025-12-30T15:28:50.223Z 2026-01-02T15:44:19.282Z
9099565 9099565 20251225025458_XyUvS DE0005 2025-12-30T15:27:53.863Z 2026-01-02T15:43:48.418Z
9099510 9099510 20251225015058_DcQQG DE0005 2025-12-30T15:26:17.744Z 2026-01-02T15:43:08.771Z
9099435 9099435 20251224235504_7Z38C DE0005 2025-12-30T15:24:55.517Z 2026-01-02T15:42:16.364Z
9099289 9099289 20251226200535_sjpJ4 DE0005 2025-12-30T15:23:17.322Z 2026-01-03T15:43:37.474Z
9099184 9099184 20251226184033_BhVTo DE0005 2025-12-30T15:22:39.145Z 2026-01-03T15:42:55.072Z

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