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

1,088 rows where station_code = "US003Q" 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
8687054 8687054 20251204022943_upGbB US003Q 2025-12-05T14:13:45.081Z 2025-12-06T14:22:27.692Z
8687049 8687049 20251204022255_kBDfF US003Q 2025-12-05T14:13:43.952Z 2025-12-06T14:22:27.070Z
8687028 8687028 20251204015046_fzesP US003Q 2025-12-05T14:13:30.814Z 2025-12-06T14:22:24.863Z
8647275 8647275 20251129041355_q2IZ1 US003Q 2025-11-30T14:27:55.281Z 2025-12-06T14:56:35.567Z
8638750 8638750 20251129093623_UDo7y US003Q 2025-11-30T14:02:06.554Z 2025-12-06T14:42:59.965Z
8638505 8638505 20251129085842_oQjzb US003Q 2025-11-30T14:01:14.333Z 2025-12-06T14:42:52.988Z
8638305 8638305 20251129082247_nGo9Z US003Q 2025-11-30T14:00:27.201Z 2025-12-06T14:42:47.225Z
8638099 8638099 20251128082526_Br3CU US003Q 2025-11-29T14:28:30.082Z 2025-12-06T15:04:08.006Z
8626680 8626680 20251128092024_5Bflv US003Q 2025-11-29T14:01:10.585Z 2025-12-06T14:50:40.484Z
8623561 8623561 20251127010639_9wG6d US003Q 2025-11-28T14:22:09.643Z 2025-12-05T15:03:59.387Z
8592808 8592808 20251124092816_UPQfe US003Q 2025-11-25T14:28:01.028Z 2025-12-02T15:13:07.689Z
8592531 8592531 20251124081325_mtQFC US003Q 2025-11-25T14:26:56.016Z 2025-12-02T15:13:04.884Z
8592522 8592522 20251124081206_ucyrb US003Q 2025-11-25T14:26:54.544Z 2025-12-02T15:13:04.809Z
8592347 8592347 20251124065400_7mvU0 US003Q 2025-11-25T14:26:33.891Z 2025-12-02T15:13:03.401Z
8592212 8592212 20251124060541_ynTT0 US003Q 2025-11-25T14:26:03.314Z 2025-12-02T15:13:02.387Z
8591964 8591964 20251124052450_cZXB5 US003Q 2025-11-25T14:25:27.051Z 2025-12-02T15:13:01.224Z
8590825 8590825 20251124031720_hNQzN US003Q 2025-11-25T14:22:52.920Z 2025-12-02T15:12:55.667Z
8583931 8583931 20251123101656_WptvU US003Q 2025-11-25T14:04:37.563Z 2025-12-02T15:09:44.380Z
8583858 8583858 20251123095826_B2dSA US003Q 2025-11-25T14:04:16.014Z 2025-12-02T15:09:43.318Z
8583427 8583427 20251124110039_8s02n US003Q 2025-11-25T14:01:54.975Z 2025-12-02T15:05:30.162Z
8582745 8582745 20251123081902_qTzFs US003Q 2025-11-24T14:34:28.448Z 2025-12-01T15:22:27.390Z
8582401 8582401 20251123060318_ZmoKV US003Q 2025-11-24T14:33:34.076Z 2025-12-01T15:22:23.260Z
8525389 8525389 20251118104418_V5nJJ US003Q 2025-11-20T14:36:54.903Z 2025-11-26T15:08:28.196Z
8517281 8517281 20251118103020_r3UfW US003Q 2025-11-19T14:43:00.266Z 2025-11-26T15:08:25.559Z
8517221 8517221 20251118102039_czQr3 US003Q 2025-11-19T14:42:57.737Z 2025-11-26T15:08:23.809Z
8517059 8517059 20251118093914_giqjz US003Q 2025-11-19T14:42:24.666Z 2025-11-26T15:08:20.037Z
8516980 8516980 20251118092623_ALIg4 US003Q 2025-11-19T14:42:20.378Z 2025-11-26T15:08:17.122Z
8516874 8516874 20251118085148_cTImq US003Q 2025-11-19T14:42:15.376Z 2025-11-26T15:08:10.614Z
8516835 8516835 20251118084256_e0Bxy US003Q 2025-11-19T14:42:14.035Z 2025-11-26T15:08:09.656Z
8516242 8516242 20251118060552_Q2367 US003Q 2025-11-19T14:40:41.151Z 2025-11-19T14:40:41.151Z
8515796 8515796 20251118050755_dPecZ US003Q 2025-11-19T14:39:58.281Z 2025-11-26T15:08:04.157Z
8514715 8514715 20251118025529_XuGLm US003Q 2025-11-19T14:38:25.367Z 2025-11-26T15:07:56.436Z
8513033 8513033 20251117234543_7yGsQ US003Q 2025-11-19T14:35:36.531Z 2025-11-26T15:07:47.407Z
8498579 8498579 20251117085135_TlpB2 US003Q 2025-11-18T14:30:36.643Z 2025-11-18T14:30:36.643Z
8495337 8495337 20251117034126_bf2Cz US003Q 2025-11-18T14:26:04.774Z 2025-11-25T15:09:50.024Z
8482828 8482828 20251115070639_gg4Qj US003Q 2025-11-17T14:30:46.712Z 2025-11-23T15:18:29.725Z
8482811 8482811 20251115070340_2QXY3 US003Q 2025-11-17T14:30:45.182Z 2025-11-23T15:18:29.151Z
8461789 8461789 20251114100411_GkRrV US003Q 2025-11-15T14:24:54.042Z 2025-11-22T15:23:41.728Z
8461474 8461474 20251114092425_7aMfB US003Q 2025-11-15T14:24:19.409Z 2025-11-22T15:23:26.892Z
8461465 8461465 20251114092240_Bdw62 US003Q 2025-11-15T14:24:17.545Z 2025-11-22T15:23:26.057Z
8461443 8461443 20251114092008_vofVR US003Q 2025-11-15T14:24:14.591Z 2025-11-22T15:23:25.431Z
8460911 8460911 20251114081004_CxB6N US003Q 2025-11-15T14:23:10.548Z 2025-11-22T15:22:56.400Z
8460736 8460736 20251114074241_rv2ey US003Q 2025-11-15T14:22:45.651Z 2025-11-22T15:22:46.718Z
8460694 8460694 20251114073732_i0ue7 US003Q 2025-11-15T14:22:41.249Z 2025-11-22T15:22:45.535Z
8460156 8460156 20251114060655_5cZTH US003Q 2025-11-15T14:21:27.564Z 2025-11-22T15:22:24.953Z
8459993 8459993 20251114052603_gO0Er US003Q 2025-11-15T14:21:12.618Z 2025-11-22T15:22:21.231Z
8459840 8459840 20251114045448_sGCv2 US003Q 2025-11-15T14:20:39.833Z 2025-11-22T15:22:14.483Z
8459519 8459519 20251114040034_ynOb1 US003Q 2025-11-15T14:19:57.024Z 2025-11-22T15:21:58.785Z
8458671 8458671 20251114010734_yoM6h US003Q 2025-11-15T14:17:32.804Z 2025-11-22T15:21:16.795Z
8458660 8458660 20251114010625_e6fIs US003Q 2025-11-15T14:17:31.749Z 2025-11-22T15:21:16.708Z
8458440 8458440 20251114001139_aPD9V US003Q 2025-11-15T14:16:43.767Z 2025-11-22T15:21:03.369Z
8451873 8451873 20251113095802_tr8F3 US003Q 2025-11-14T14:26:57.828Z 2025-11-21T15:13:32.212Z
8451571 8451571 20251113084728_Noqno US003Q 2025-11-14T14:26:01.791Z 2025-11-21T15:13:18.235Z
8451277 8451277 20251113073859_T52GM US003Q 2025-11-14T14:25:33.649Z 2025-11-21T15:13:05.928Z
8451168 8451168 20251113070044_2cgRM US003Q 2025-11-14T14:25:05.974Z 2025-11-21T15:13:02.703Z
8450443 8450443 20251113043114_iFi26 US003Q 2025-11-14T14:23:25.924Z 2025-11-21T15:12:38.906Z
8429508 8429508 20251111100901_nbw23 US003Q 2025-11-12T14:44:36.846Z 2025-11-19T15:18:44.082Z
8427254 8427254 20251111042031_FpL0q US003Q 2025-11-12T14:27:32.069Z 2025-11-19T15:17:48.724Z
8417027 8417027 20251110105441_e2dmp US003Q 2025-11-11T14:27:17.713Z 2025-11-18T15:21:52.275Z
8416949 8416949 20251110104205_QWXwb US003Q 2025-11-11T14:27:07.543Z 2025-11-18T15:21:51.654Z
8406386 8406386 20251109061209_LRiJk US003Q 2025-11-10T14:16:38.360Z 2025-11-17T14:59:13.393Z
8392924 8392924 20251107074915_l1rRz US003Q 2025-11-08T14:19:38.238Z 2025-11-15T15:00:48.623Z
8392138 8392138 20251107044237_wgl62 US003Q 2025-11-08T14:17:11.999Z 2025-11-15T15:00:42.468Z
8391316 8391316 20251107023530_6Nmwm US003Q 2025-11-08T14:14:32.289Z 2025-11-15T15:00:27.473Z
8391088 8391088 20251107020455_Nk6AK US003Q 2025-11-08T14:13:42.081Z 2025-11-15T15:00:18.892Z
8386684 8386684 20251106062803_hCYhq US003Q 2025-11-07T14:12:02.664Z 2025-11-14T15:08:44.937Z
8370862 8370862 20251104031234_gruIm US003Q 2025-11-05T14:12:47.259Z 2025-11-12T15:10:52.569Z
8370172 8370172 20251104005436_60UJs US003Q 2025-11-05T14:09:47.173Z 2025-11-12T15:10:21.011Z
8369886 8369886 20251103232046_0gEoo US003Q 2025-11-05T14:08:45.914Z 2025-11-12T15:09:57.915Z
8354657 8354657 20251101104125_uD3zz US003Q 2025-11-03T14:36:12.544Z 2025-11-09T15:06:26.826Z
8354623 8354623 20251101103644_hFTIb US003Q 2025-11-03T14:36:10.419Z 2025-11-09T15:06:23.512Z
8347363 8347363 20251101094954_cjxt0 US003Q 2025-11-02T14:46:20.629Z 2025-11-09T15:05:58.897Z
8346452 8346452 20251101083153_W3h65 US003Q 2025-11-02T14:44:28.686Z 2025-11-09T15:05:19.324Z
8346014 8346014 20251101074630_7qZiN US003Q 2025-11-02T14:43:42.149Z 2025-11-09T15:04:54.022Z
8345821 8345821 20251101072459_x9use US003Q 2025-11-02T14:43:32.957Z 2025-11-09T15:04:36.899Z
8345818 8345818 20251101072455_4Z0fV US003Q 2025-11-02T14:43:30.562Z 2025-11-09T15:04:36.883Z
8345619 8345619 20251101070100_YoVq3 US003Q 2025-11-02T14:43:17.331Z 2025-11-02T14:43:17.331Z
8335192 8335192 20251031025944_MWPdr US003Q 2025-11-02T14:27:02.532Z 2025-11-08T15:14:32.459Z
8335013 8335013 20251031024312_c8oTG US003Q 2025-11-02T14:26:26.617Z 2025-11-08T15:14:21.050Z
8293522 8293522 20251028094036_KLuX4 US003Q 2025-10-30T12:39:38.351Z 2025-11-05T15:24:00.659Z
8293395 8293395 20251028093426_oaLEH US003Q 2025-10-30T12:39:32.465Z 2025-11-05T15:23:58.121Z
8284974 8284974 20251028052840_6st9K US003Q 2025-10-29T12:46:49.946Z 2025-11-05T15:22:59.623Z
8277200 8277200 20251027100504_1peoe US003Q 2025-10-29T12:31:25.652Z 2025-11-04T15:47:38.127Z
8276185 8276185 20251027081930_Suirl US003Q 2025-10-29T12:29:11.820Z 2025-11-04T15:46:50.932Z
8275640 8275640 20251027071610_F8H2H US003Q 2025-10-29T12:28:12.921Z 2025-11-04T15:46:09.996Z
8266809 8266809 20251026102632_O8LPT US003Q 2025-10-28T12:40:07.320Z 2025-11-03T15:17:10.323Z
8265811 8265811 20251026084315_jZ6Mu US003Q 2025-10-28T12:39:14.406Z 2025-11-03T15:17:05.456Z
8265557 8265557 20251026081618_A038O US003Q 2025-10-28T12:38:35.900Z 2025-11-03T15:17:04.728Z
8265499 8265499 20251026080614_X5wth US003Q 2025-10-28T12:38:32.478Z 2025-11-03T15:17:04.368Z
8265367 8265367 20251026075046_xaci8 US003Q 2025-10-28T12:38:27.130Z 2025-11-03T15:17:03.907Z
8264773 8264773 20251026061849_rnWQt US003Q 2025-10-28T12:37:20.415Z 2025-11-03T15:17:00.147Z
8261915 8261915 20251026040604_n8CV3 US003Q 2025-10-28T12:35:03.674Z 2025-11-03T15:16:45.289Z
8254230 8254230 20251027034943_RpDn2 US003Q 2025-10-28T12:19:30.735Z 2025-11-04T15:44:22.006Z
8252309 8252309 20251027003124_kbaFp US003Q 2025-10-28T12:14:36.975Z 2025-11-04T15:42:42.382Z
8245435 8245435 20251025091514_D4jDR US003Q 2025-10-27T12:39:44.352Z 2025-11-02T15:05:47.071Z
8244592 8244592 20251025081456_zQPsU US003Q 2025-10-27T12:38:01.459Z 2025-11-02T15:05:44.005Z
8244431 8244431 20251025075857_FVuxp US003Q 2025-10-27T12:37:48.139Z 2025-11-02T15:05:43.287Z
8226377 8226377 20251024092149_ZU7fW US003Q 2025-10-26T12:44:59.893Z 2025-11-01T13:11:25.327Z
8226363 8226363 20251024092039_iQnzE US003Q 2025-10-26T12:44:59.179Z 2025-11-01T13:11:25.225Z
8226148 8226148 20251024090426_oY3Kg US003Q 2025-10-26T12:44:43.880Z 2025-11-01T13:11:24.338Z

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