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 = "US000G" 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
9273532 9273532 20260128065511_nMda5 US000G 2026-01-29T14:30:11.862Z 2026-01-29T14:30:25.831Z
9273446 9273446 20260128061332_NvZSL US000G 2026-01-29T14:29:48.646Z 2026-01-29T14:30:25.814Z
9273438 9273438 20260128061313_Shgmb US000G 2026-01-29T14:29:47.653Z 2026-01-29T14:30:25.812Z
9273090 9273090 20260128043515_2OS3e US000G 2026-01-29T14:28:43.711Z 2026-01-29T14:30:25.748Z
9273024 9273024 20260128042612_HDs7o US000G 2026-01-29T14:28:30.654Z 2026-01-29T14:30:25.738Z
9272939 9272939 20260128040418_9nh95 US000G 2026-01-29T14:28:16.385Z 2026-01-29T14:30:25.709Z
9272881 9272881 20260128035501_Qouk3 US000G 2026-01-29T14:28:06.010Z 2026-01-29T14:30:25.702Z
9272653 9272653 20260128025501_wZg91 US000G 2026-01-29T14:27:20.436Z 2026-01-29T14:30:25.433Z
9272556 9272556 20260128023543_eULBT US000G 2026-01-29T14:27:10.241Z 2026-01-29T14:30:25.377Z
9269272 9269272 20260128125445_wdnpj US000G 2026-01-29T14:07:14.232Z 2026-01-29T14:07:14.232Z
9269113 9269113 20260128123115_H2OkX US000G 2026-01-29T14:06:34.018Z 2026-01-29T14:06:34.018Z
9268979 9268979 20260128115722_ZUbXC US000G 2026-01-29T14:05:50.181Z 2026-01-29T14:05:50.181Z
9268818 9268818 20260128112845_q64w5 US000G 2026-01-29T14:05:01.202Z 2026-01-29T14:05:01.202Z
9268811 9268811 20260128112543_InJJt US000G 2026-01-29T14:04:59.747Z 2026-01-29T14:04:59.747Z
9268548 9268548 20260128104548_9s8YE US000G 2026-01-29T14:03:39.042Z 2026-01-29T14:03:39.042Z
9268533 9268533 20260128104258_9YUIv US000G 2026-01-29T14:03:34.345Z 2026-01-29T14:03:34.345Z
9268381 9268381 20260128100457_e2MFa US000G 2026-01-29T14:02:44.306Z 2026-01-29T14:02:44.306Z
9268342 9268342 20260128095434_XodCc US000G 2026-01-29T14:02:30.731Z 2026-01-29T14:02:30.731Z
9268170 9268170 20260128090656_VocrW US000G 2026-01-29T14:01:30.681Z 2026-01-29T14:01:30.681Z
9267705 9267705 20260127042833_vxD81 US000G 2026-01-28T14:22:57.025Z 2026-01-29T14:35:30.189Z
9264764 9264764 20260127130749_D3Hpr US000G 2026-01-28T14:07:31.853Z 2026-01-29T14:30:24.280Z
9264755 9264755 20260127130658_CsHNf US000G 2026-01-28T14:07:30.099Z 2026-01-29T14:30:24.279Z
9264630 9264630 20260127125113_IsP4R US000G 2026-01-28T14:06:57.771Z 2026-01-29T14:30:24.233Z
9264527 9264527 20260127124251_rERck US000G 2026-01-28T14:06:34.674Z 2026-01-29T14:30:24.196Z
9264280 9264280 20260127115423_o405l US000G 2026-01-28T14:05:17.452Z 2026-01-29T14:30:20.576Z
9264270 9264270 20260127115319_ZWxb1 US000G 2026-01-28T14:05:14.582Z 2026-01-29T14:30:20.573Z
9264110 9264110 20260127111522_qBaT9 US000G 2026-01-28T14:04:28.088Z 2026-01-29T14:30:20.054Z
9264032 9264032 20260127105947_m0aB4 US000G 2026-01-28T14:04:01.819Z 2026-01-29T14:30:20.013Z
9263867 9263867 20260127102439_LtKJE US000G 2026-01-28T14:03:13.721Z 2026-01-29T14:30:19.509Z
9263677 9263677 20260127094556_eeED3 US000G 2026-01-28T14:02:11.048Z 2026-01-29T14:30:18.024Z
9263669 9263669 20260127093847_WXD97 US000G 2026-01-28T14:02:06.742Z 2026-01-29T14:30:17.620Z
9263644 9263644 20260127093427_XTjDx US000G 2026-01-28T14:01:57.414Z 2026-01-29T14:30:17.611Z
9263614 9263614 20260127092501_3gzzh US000G 2026-01-28T14:01:43.898Z 2026-01-29T14:30:16.597Z
9263453 9263453 20260127081009_4z5I3 US000G 2026-01-28T14:00:41.066Z 2026-01-29T14:30:16.508Z
9263137 9263137 20260126073626_abmH3 US000G 2026-01-27T14:17:09.997Z 2026-01-29T14:39:18.668Z
9263003 9263003 20260126060102_tVHSq US000G 2026-01-27T14:16:34.044Z 2026-01-29T14:39:08.830Z
9262983 9262983 20260126054805_SulTu US000G 2026-01-27T14:16:23.713Z 2026-01-29T14:39:07.821Z
9262965 9262965 20260126053423_T3P96 US000G 2026-01-27T14:16:17.673Z 2026-01-29T14:39:06.702Z
9262913 9262913 20260126045113_HjpZo US000G 2026-01-27T14:16:06.366Z 2026-01-29T14:39:01.195Z
9262846 9262846 20260126034526_4gdxJ US000G 2026-01-27T14:15:39.758Z 2026-01-29T14:38:52.378Z
9262813 9262813 20260126032237_wPI4Y US000G 2026-01-27T14:15:31.983Z 2026-01-29T14:38:49.873Z
9261767 9261767 20260126131234_VCvYL US000G 2026-01-27T14:05:29.249Z 2026-01-29T14:32:56.575Z
9261756 9261756 20260126131017_S22kj US000G 2026-01-27T14:05:24.596Z 2026-01-29T14:32:55.489Z
9261525 9261525 20260126120712_nhrn4 US000G 2026-01-27T14:04:12.125Z 2026-01-29T14:32:37.833Z
9261462 9261462 20260126114801_Fe2LH US000G 2026-01-27T14:03:49.122Z 2026-01-29T14:32:26.218Z
9261440 9261440 20260126114046_f2eSv US000G 2026-01-27T14:03:44.116Z 2026-01-29T14:32:24.864Z
9261382 9261382 20260126111958_Cx4jY US000G 2026-01-27T14:03:28.830Z 2026-01-29T14:32:15.120Z
9261350 9261350 20260126111053_dxatG US000G 2026-01-27T14:03:16.548Z 2026-01-29T14:32:12.921Z
9261231 9261231 20260126103502_mXg2e US000G 2026-01-27T14:02:42.293Z 2026-01-29T14:32:05.958Z
9261134 9261134 20260126095740_N0Phz US000G 2026-01-27T14:02:10.195Z 2026-01-29T14:31:58.587Z
9261129 9261129 20260126095717_qY02v US000G 2026-01-27T14:02:07.788Z 2026-01-29T14:31:58.201Z
9261111 9261111 20260126095405_mzwSk US000G 2026-01-27T14:01:58.647Z 2026-01-29T14:31:57.159Z
9261102 9261102 20260126095207_JSmF0 US000G 2026-01-27T14:01:53.296Z 2026-01-29T14:31:55.368Z
9261090 9261090 20260126095100_JCFny US000G 2026-01-27T14:01:51.107Z 2026-01-29T14:31:51.388Z
9261087 9261087 20260126095050_nT9hm US000G 2026-01-27T14:01:49.719Z 2026-01-29T14:31:48.940Z
9261070 9261070 20260126094427_chCl0 US000G 2026-01-27T14:01:45.075Z 2026-01-29T14:31:44.244Z
9261046 9261046 20260126093731_zXB6d US000G 2026-01-27T14:01:38.065Z 2026-01-29T14:31:33.110Z
9261023 9261023 20260126092920_1RwYW US000G 2026-01-27T14:01:28.864Z 2026-01-29T14:31:27.537Z
9260988 9260988 20260126091245_Hic3T US000G 2026-01-27T14:01:15.950Z 2026-01-29T14:31:17.529Z
9260967 9260967 20260126090303_HXbud US000G 2026-01-27T14:01:10.936Z 2026-01-29T14:31:16.552Z
9260878 9260878 20260126082740_DBZy1 US000G 2026-01-27T14:00:35.706Z 2026-01-29T14:31:04.032Z
9260837 9260837 20260126080739_voaXN US000G 2026-01-27T14:00:25.572Z 2026-01-29T14:30:44.970Z
9260807 9260807 20260126075735_sxyBP US000G 2026-01-27T14:00:18.051Z 2026-01-29T14:30:35.797Z
9252854 9252854 20260123070741_jQRRb US000G 2026-01-24T14:17:30.621Z 2026-01-29T14:53:37.880Z
9252187 9252187 20260123013921_0hsq7 US000G 2026-01-24T14:14:41.694Z 2026-01-29T14:52:38.678Z
9249762 9249762 20260122082507_BlLzo US000G 2026-01-23T14:16:11.667Z 2026-01-29T14:58:54.000Z
9249700 9249700 20260122070914_Kd1tO US000G 2026-01-23T14:15:56.556Z 2026-01-29T14:58:50.148Z
9249330 9249330 20260122045115_RVJ8w US000G 2026-01-23T14:15:11.219Z 2026-01-29T14:58:26.273Z
9248851 9248851 20260122022652_AgE2a US000G 2026-01-23T14:13:59.123Z 2026-01-29T14:57:49.605Z
9245018 9245018 20260116102657_LNbwe US000G 2026-01-22T15:01:04.139Z 2026-01-24T15:15:02.343Z
9244969 9244969 20260116024251_0fk4C US000G 2026-01-22T14:58:39.292Z 2026-01-24T15:11:50.882Z
9244940 9244940 20260117071811_33phv US000G 2026-01-22T14:55:01.340Z 2026-01-25T14:58:59.980Z
9244934 9244934 20260117054756_S26ya US000G 2026-01-22T14:54:49.366Z 2026-01-25T14:58:51.165Z
9244926 9244926 20260117041110_irvlG US000G 2026-01-22T14:54:22.182Z 2026-01-25T14:58:27.308Z
9244904 9244904 20260118084633_ms2Wx US000G 2026-01-22T14:51:25.258Z 2026-01-26T15:04:09.378Z
9244890 9244890 20260117123309_jzCRX US000G 2026-01-22T14:46:31.736Z 2026-01-26T14:59:23.052Z
9244884 9244884 20260117114636_EiUzG US000G 2026-01-22T14:46:09.918Z 2026-01-26T14:59:13.854Z
9244878 9244878 20260117113330_66cTw US000G 2026-01-22T14:46:06.812Z 2026-01-26T14:59:07.797Z
9244858 9244858 20260118114242_X7QTh US000G 2026-01-22T14:38:23.537Z 2026-01-27T14:58:42.963Z
9244562 9244562 20260121090653_tbevb US000G 2026-01-22T14:26:00.971Z 2026-01-29T15:06:25.739Z
9244554 9244554 20260121090514_asc2k US000G 2026-01-22T14:26:00.375Z 2026-01-29T15:06:25.439Z
9244539 9244539 20260121090033_cFJPd US000G 2026-01-22T14:25:58.086Z 2026-01-29T15:06:24.865Z
9244431 9244431 20260121082826_WPWgI US000G 2026-01-22T14:25:31.650Z 2026-01-29T15:06:09.164Z
9244429 9244429 20260121082826_Xgr3J US000G 2026-01-22T14:25:31.213Z 2026-01-29T15:06:09.044Z
9244300 9244300 20260121072211_ZfUOC US000G 2026-01-22T14:24:55.655Z 2026-01-29T15:06:00.006Z
9244244 9244244 20260121065924_G5gIK US000G 2026-01-22T14:24:42.902Z 2026-01-29T15:05:57.298Z
9243859 9243859 20260121052632_uEM6a US000G 2026-01-22T14:23:22.802Z 2026-01-29T15:05:30.417Z
9242894 9242894 20260121030957_1p0wB US000G 2026-01-22T14:19:41.045Z 2026-01-29T15:04:28.500Z
9242835 9242835 20260121025605_6cD5d US000G 2026-01-22T14:19:30.365Z 2026-01-29T15:04:23.618Z
9242593 9242593 20260121022334_6vGvU US000G 2026-01-22T14:18:30.612Z 2026-01-29T15:04:13.029Z
9242579 9242579 20260121021747_rth9E US000G 2026-01-22T14:18:28.795Z 2026-01-29T15:04:12.199Z
9242321 9242321 20260121012711_762l0 US000G 2026-01-22T14:17:19.765Z 2026-01-29T15:03:44.008Z
9240158 9240158 20260120124911_rKQG3 US000G 2026-01-22T14:06:16.085Z 2026-01-22T14:06:16.085Z
9240097 9240097 20260120122028_SFK6d US000G 2026-01-22T14:05:41.655Z 2026-01-22T14:05:41.655Z
9239914 9239914 20260121131443_ObAPP US000G 2026-01-22T14:03:45.083Z 2026-01-29T14:55:02.551Z
9239861 9239861 20260121125541_J8TFg US000G 2026-01-22T14:03:32.424Z 2026-01-29T14:54:50.846Z
9239859 9239859 20260121125449_HiayH US000G 2026-01-22T14:03:31.835Z 2026-01-29T14:54:50.791Z
9239837 9239837 20260121124354_OryBI US000G 2026-01-22T14:03:26.540Z 2026-01-29T14:54:46.901Z
9239767 9239767 20260121121803_QknM9 US000G 2026-01-22T14:03:04.016Z 2026-01-29T14:54:40.615Z
9239695 9239695 20260121114716_5wW5m US000G 2026-01-22T14:02:40.377Z 2026-01-29T14:54:35.796Z

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