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,186 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
9268370 9268370 20260128100235_OyW2d US003Q 2026-01-29T14:02:41.727Z 2026-01-29T14:02:41.727Z
9268218 9268218 20260128092358_FLIH4 US003Q 2026-01-29T14:01:44.461Z 2026-01-29T14:01:44.461Z
9268027 9268027 20260128080137_knDJ8 US003Q 2026-01-29T14:00:31.566Z 2026-01-29T14:00:31.566Z
9264120 9264120 20260127111659_FZCti US003Q 2026-01-28T14:04:30.149Z 2026-01-29T14:30:20.066Z
9263798 9263798 20260127101427_54Kyx US003Q 2026-01-28T14:02:51.524Z 2026-01-29T14:30:18.940Z
9263522 9263522 20260127085327_9qqka US003Q 2026-01-28T14:01:08.496Z 2026-01-29T14:30:16.550Z
9256398 9256398 20260124081425_MQka3 US003Q 2026-01-25T14:16:56.386Z 2026-01-29T14:48:47.573Z
9256245 9256245 20260124062803_Pzcoo US003Q 2026-01-25T14:16:17.746Z 2026-01-29T14:48:30.639Z
9255752 9255752 20260124044525_oiogr US003Q 2026-01-25T14:14:33.731Z 2026-01-29T14:47:55.184Z
9253030 9253030 20260124083751_aEZBL US003Q 2026-01-25T14:00:11.947Z 2026-01-29T14:40:11.010Z
9248774 9248774 20260122020749_ofqtq US003Q 2026-01-23T14:13:50.423Z 2026-01-29T14:57:46.181Z
9244519 9244519 20260121085224_nReOx US003Q 2026-01-22T14:25:54.830Z 2026-01-29T15:06:24.043Z
9244342 9244342 20260121074934_EkHuE US003Q 2026-01-22T14:25:12.255Z 2026-01-29T15:06:02.425Z
9237695 9237695 20260120055112_zUcRp US003Q 2026-01-21T14:27:21.515Z 2026-01-28T15:01:36.708Z
9231497 9231497 20260119082243_jtFOE US003Q 2026-01-20T14:33:04.626Z 2026-01-27T15:06:32.783Z
9229877 9229877 20260119024709_wCa0s US003Q 2026-01-20T14:24:44.123Z 2026-01-27T15:04:12.247Z
9215072 9215072 20260116090731_nu3xj US003Q 2026-01-17T14:24:15.612Z 2026-01-24T15:14:28.731Z
9214981 9214981 20260116085332_SL858 US003Q 2026-01-17T14:24:00.206Z 2026-01-24T15:14:25.667Z
9197013 9197013 20260113095600_UeCMM US003Q 2026-01-14T14:21:07.721Z 2026-01-21T15:06:12.413Z
9196829 9196829 20260113091229_QDUR3 US003Q 2026-01-14T14:20:16.484Z 2026-01-21T15:05:58.894Z
9196671 9196671 20260113082457_NUqxU US003Q 2026-01-14T14:19:28.340Z 2026-01-21T15:05:36.377Z
9189607 9189607 20260112052149_0GIgf US003Q 2026-01-13T14:18:28.581Z 2026-01-20T15:23:30.930Z
9172466 9172466 20260109104629_oaq23 US003Q 2026-01-10T14:13:27.848Z 2026-01-17T15:25:34.932Z
9171694 9171694 20260109013144_6Nc1x US003Q 2026-01-10T14:08:58.431Z 2026-01-17T15:24:19.947Z
9171591 9171591 20260108232742_r12Zy US003Q 2026-01-10T14:08:14.628Z 2026-01-17T15:24:08.376Z
9167846 9167846 20260108054002_hJkGM US003Q 2026-01-09T14:09:28.839Z 2026-01-16T15:11:55.324Z
9167493 9167493 20260108021044_cEWfl US003Q 2026-01-09T14:07:58.785Z 2026-01-16T15:11:22.622Z
9167285 9167285 20260108000808_5NvIq US003Q 2026-01-09T14:07:01.148Z 2026-01-16T15:11:00.375Z
9038758 9038758 20251224112704_ewvaL US003Q 2025-12-28T14:39:54.731Z 2026-01-01T15:55:30.693Z
9037957 9037957 20251224101306_2Xoci US003Q 2025-12-28T14:38:17.895Z 2026-01-01T15:54:56.535Z
9037661 9037661 20251224093157_pecHU US003Q 2025-12-28T14:37:43.409Z 2026-01-01T15:54:51.879Z
9037458 9037458 20251224080022_gG8bd US003Q 2025-12-28T14:37:22.559Z 2026-01-01T15:54:48.587Z
9037367 9037367 20251224064954_TicVb US003Q 2025-12-28T14:36:57.925Z 2026-01-01T15:54:46.977Z
9019834 9019834 20251220104357_Z325D US003Q 2025-12-27T15:05:02.676Z 2025-12-29T15:24:38.489Z
9019574 9019574 20251220101153_uQllC US003Q 2025-12-27T15:04:46.105Z 2025-12-27T15:04:46.105Z
9019270 9019270 20251220092805_dxTMZ US003Q 2025-12-27T15:03:52.851Z 2025-12-29T15:24:31.404Z
9019264 9019264 20251220092717_jXjaZ US003Q 2025-12-27T15:03:49.541Z 2025-12-29T15:24:31.289Z
9019042 9019042 20251220085616_QlYsQ US003Q 2025-12-27T15:03:03.112Z 2025-12-29T15:24:28.147Z
9018897 9018897 20251220081920_p1A3u US003Q 2025-12-27T15:02:51.868Z 2025-12-29T15:24:25.940Z
9018891 9018891 20251220081741_5XU6b US003Q 2025-12-27T15:02:51.803Z 2025-12-29T15:24:25.280Z
9018804 9018804 20251220080402_vxDM4 US003Q 2025-12-27T15:02:49.930Z 2025-12-29T15:24:13.850Z
9018712 9018712 20251220074606_n6p4U US003Q 2025-12-27T15:02:46.168Z 2025-12-29T15:24:01.201Z
9007782 9007782 20251221103118_b4nwz US003Q 2025-12-27T14:41:17.120Z 2025-12-27T14:41:17.120Z
9007540 9007540 20251221100221_7i2Dk US003Q 2025-12-27T14:40:36.827Z 2025-12-27T14:40:36.827Z
9006642 9006642 20251221065521_SVe3z US003Q 2025-12-27T14:38:20.787Z 2025-12-27T14:38:20.787Z
9006520 9006520 20251221062938_V8IB2 US003Q 2025-12-27T14:38:10.517Z 2025-12-27T14:38:10.517Z
9006109 9006109 20251221043759_WkYHt US003Q 2025-12-27T14:36:51.277Z 2025-12-27T14:36:51.277Z
9005842 9005842 20251221033119_rIifE US003Q 2025-12-27T14:36:02.618Z 2025-12-27T14:36:02.618Z
9001700 9001700 20251222103423_ypXxi US003Q 2025-12-27T14:22:58.871Z 2025-12-28T15:01:08.328Z
9001676 9001676 20251222103220_AcJ1Q US003Q 2025-12-27T14:22:55.853Z 2025-12-30T15:48:00.620Z
9001434 9001434 20251222101430_xR13F US003Q 2025-12-27T14:22:03.732Z 2025-12-28T15:01:02.591Z
9000656 9000656 20251222091637_W8d2U US003Q 2025-12-27T14:19:55.630Z 2025-12-30T15:47:50.478Z
9000617 9000617 20251222091317_ymR3u US003Q 2025-12-27T14:19:52.334Z 2025-12-28T15:00:49.807Z
9000368 9000368 20251222085947_VByNA US003Q 2025-12-27T14:19:10.247Z 2025-12-30T15:47:47.909Z
9000210 9000210 20251222084956_iXwON US003Q 2025-12-27T14:18:56.908Z 2025-12-30T15:47:46.288Z
9000165 9000165 20251222084718_4LfTU US003Q 2025-12-27T14:18:40.676Z 2025-12-28T15:00:19.087Z
9000146 9000146 20251222084517_EP0Ai US003Q 2025-12-27T14:18:34.359Z 2025-12-30T15:47:45.690Z
8999537 8999537 20251222074951_30dbE US003Q 2025-12-27T14:17:04.905Z 2025-12-28T15:00:03.953Z
8999199 8999199 20251222071033_X5iUn US003Q 2025-12-27T14:16:00.939Z 2025-12-30T15:46:55.622Z
8999177 8999177 20251222070838_F6MKs US003Q 2025-12-27T14:15:48.988Z 2025-12-30T15:46:55.402Z
8998792 8998792 20251222062018_kIjY3 US003Q 2025-12-27T14:14:36.912Z 2025-12-28T14:59:18.315Z
8998773 8998773 20251222061805_htquk US003Q 2025-12-27T14:14:29.108Z 2025-12-28T14:59:18.001Z
8998685 8998685 20251222060743_Fc00b US003Q 2025-12-27T14:14:18.265Z 2025-12-30T15:46:49.551Z
8998389 8998389 20251222053451_QbOVn US003Q 2025-12-27T14:13:29.046Z 2025-12-28T14:59:12.109Z
8997522 8997522 20251222042706_XaBd5 US003Q 2025-12-27T14:10:04.931Z 2025-12-30T15:46:37.771Z
8996952 8996952 20251222032343_RZTAz US003Q 2025-12-27T14:07:34.201Z 2025-12-28T14:58:15.850Z
8996104 8996104 20251222012322_fhJ9t US003Q 2025-12-27T14:02:59.515Z 2025-12-30T15:45:42.770Z
8987580 8987580 20251218085020_yLTwU US003Q 2025-12-26T14:40:39.247Z 2025-12-27T15:20:43.583Z
8987516 8987516 20251218083931_ZWBEk US003Q 2025-12-26T14:40:32.356Z 2025-12-26T14:40:32.356Z
8986656 8986656 20251218061449_uI3CA US003Q 2025-12-26T14:38:25.784Z 2025-12-27T15:19:32.179Z
8974408 8974408 20251220022239_PFfND US003Q 2025-12-26T14:04:25.551Z 2025-12-29T15:22:41.803Z
8974115 8974115 20251220020450_jjzqK US003Q 2025-12-26T14:03:49.192Z 2025-12-29T15:22:38.998Z
8965837 8965837 20251216111340_hEhlY US003Q 2025-12-25T14:44:39.483Z 2025-12-25T14:44:39.483Z
8965828 8965828 20251216111132_z5bFF US003Q 2025-12-25T14:44:38.306Z 2025-12-25T14:44:38.306Z
8965462 8965462 20251216103830_sP12Z US003Q 2025-12-25T14:43:47.810Z 2025-12-25T14:43:47.810Z
8965418 8965418 20251216103309_3jiw4 US003Q 2025-12-25T14:43:44.939Z 2025-12-25T14:43:44.939Z
8965392 8965392 20251216103038_nu9aS US003Q 2025-12-25T14:43:42.956Z 2025-12-25T14:43:42.956Z
8964472 8964472 20251216083832_mHlMw US003Q 2025-12-25T14:41:44.737Z 2025-12-25T14:41:44.737Z
8964439 8964439 20251216083214_632KJ US003Q 2025-12-25T14:41:28.003Z 2025-12-25T14:41:28.003Z
8962342 8962342 20251216031057_Lc5A5 US003Q 2025-12-25T14:35:38.824Z 2025-12-25T14:35:38.824Z
8952975 8952975 20251217024719_01WTq US003Q 2025-12-25T14:03:36.840Z 2025-12-26T14:55:36.925Z
8951370 8951370 20251215013700_3SRwF US003Q 2025-12-24T15:08:15.697Z 2025-12-24T15:08:15.697Z
8951274 8951274 20251215013327_C5F2D US003Q 2025-12-24T15:08:05.075Z 2025-12-24T15:08:05.075Z
8926033 8926033 20251215024701_etqkN US003Q 2025-12-24T14:01:37.861Z 2025-12-24T15:09:28.588Z
8808048 8808048 20251213013344_lf8K2 US003Q 2025-12-16T14:40:43.732Z 2025-12-21T14:17:34.525Z
8782795 8782795 20251213013353_A2L6f US003Q 2025-12-15T14:34:24.012Z 2025-12-21T14:17:34.530Z
8782788 8782788 20251213013344_sa86S US003Q 2025-12-15T14:34:23.902Z 2025-12-15T14:40:56.767Z
8780918 8780918 20251213010718_2ypyz US003Q 2025-12-15T14:33:15.779Z 2025-12-21T14:17:33.521Z
8780854 8780854 20251213010554_IV3mL US003Q 2025-12-15T14:33:14.232Z 2025-12-21T14:17:33.470Z
8780515 8780515 20251213010023_eDtxw US003Q 2025-12-15T14:32:51.359Z 2025-12-21T14:17:33.288Z
8778874 8778874 20251213003216_zccnk US003Q 2025-12-15T14:31:18.853Z 2025-12-21T14:17:32.398Z
8777944 8777944 20251213001608_YHQ3e US003Q 2025-12-15T14:30:43.642Z 2025-12-21T14:17:31.864Z
8728621 8728621 20251212090711_ut3IM US003Q 2025-12-13T14:13:21.321Z 2025-12-21T14:17:22.728Z
8728234 8728234 20251212082650_OuFi1 US003Q 2025-12-13T14:11:19.584Z 2025-12-21T14:17:22.359Z
8727942 8727942 20251212075538_Nh2BG US003Q 2025-12-13T14:10:20.347Z 2025-12-21T14:17:22.114Z
8720096 8720096 20251211044029_pmgAi US003Q 2025-12-12T14:01:42.225Z 2025-12-20T14:21:55.831Z
8715866 8715866 20251210081534_TiCzr US003Q 2025-12-11T14:08:33.782Z 2025-12-19T15:06:52.448Z
8708621 8708621 20251209045400_UlWsb US003Q 2025-12-10T14:00:16.448Z 2025-12-17T15:22:34.090Z
8687054 8687054 20251204022943_upGbB US003Q 2025-12-05T14:13:45.081Z 2025-12-11T14:41:59.736Z
8687049 8687049 20251204022255_kBDfF US003Q 2025-12-05T14:13:43.952Z 2025-12-11T14:41:59.537Z

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