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

6,632 rows where station_code = "US004Q" 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
8683214 8683214 20251203064241_sqt9d US004Q 2025-12-04T14:18:57.158Z 2025-12-06T14:29:46.484Z
8682912 8682912 20251203061555_0Z3MT US004Q 2025-12-04T14:18:20.132Z 2025-12-06T14:29:31.512Z
8681506 8681506 20251203031620_k9va2 US004Q 2025-12-04T14:14:50.099Z 2025-12-06T14:28:14.845Z
8677646 8677646 20251203112921_XDZZP US004Q 2025-12-04T14:02:08.291Z 2025-12-06T14:19:53.902Z
8677578 8677578 20251203105147_XevnQ US004Q 2025-12-04T14:01:49.471Z 2025-12-06T14:19:41.419Z
8677547 8677547 20251203103923_2pSG6 US004Q 2025-12-04T14:01:41.578Z 2025-12-06T14:19:37.382Z
8677512 8677512 20251203102930_3w5Es US004Q 2025-12-04T14:01:29.683Z 2025-12-06T14:19:34.108Z
8677459 8677459 20251203100941_uySuw US004Q 2025-12-04T14:01:18.761Z 2025-12-06T14:19:30.171Z
8677455 8677455 20251203100839_wgzc0 US004Q 2025-12-04T14:01:18.009Z 2025-12-06T14:19:29.703Z
8677425 8677425 20251203095203_ddQm8 US004Q 2025-12-04T14:01:10.345Z 2025-12-06T14:19:26.327Z
8677415 8677415 20251203094252_MyS2n US004Q 2025-12-04T14:01:07.715Z 2025-12-06T14:19:25.182Z
8677384 8677384 20251203092935_sTQ3u US004Q 2025-12-04T14:00:59.634Z 2025-12-06T14:19:21.186Z
8677374 8677374 20251203092435_NbLQn US004Q 2025-12-04T14:00:57.261Z 2025-12-06T14:19:20.466Z
8677366 8677366 20251203092018_McXyb US004Q 2025-12-04T14:00:55.392Z 2025-12-06T14:19:19.869Z
8677342 8677342 20251203085557_iuPPS US004Q 2025-12-04T14:00:50.244Z 2025-12-06T14:19:17.883Z
8677308 8677308 20251203083309_6kpFO US004Q 2025-12-04T14:00:41.451Z 2025-12-06T14:19:04.127Z
8677306 8677306 20251203083242_rwUaR US004Q 2025-12-04T14:00:41.021Z 2025-12-06T14:19:03.760Z
8677297 8677297 20251203082810_MPUqV US004Q 2025-12-04T14:00:39.268Z 2025-12-06T14:18:56.615Z
8677279 8677279 20251203081151_8r93v US004Q 2025-12-04T14:00:34.938Z 2025-12-06T14:18:48.941Z
8677238 8677238 20251203073758_PvpaZ US004Q 2025-12-04T14:00:27.234Z 2025-12-06T14:18:28.490Z
8677207 8677207 20251203071231_KBqVS US004Q 2025-12-04T14:00:21.755Z 2025-12-06T14:18:15.177Z
8677162 8677162 20251203065541_OcWaX US004Q 2025-12-04T14:00:10.653Z 2025-12-06T14:18:03.065Z
8677147 8677147 20251202070814_1Jw99 US004Q 2025-12-03T14:26:21.972Z 2025-12-06T14:35:36.884Z
8677111 8677111 20251202065245_ysdDT US004Q 2025-12-03T14:26:18.835Z 2025-12-06T14:35:35.334Z
8677006 8677006 20251202063801_n5ncb US004Q 2025-12-03T14:26:04.224Z 2025-12-06T14:35:32.758Z
8669764 8669764 20251202120820_ubEhW US004Q 2025-12-03T14:05:23.337Z 2025-12-06T14:24:19.099Z
8669569 8669569 20251202113352_A3flL US004Q 2025-12-03T14:04:34.048Z 2025-12-06T14:24:03.014Z
8669550 8669550 20251202112952_FkhzO US004Q 2025-12-03T14:04:29.924Z 2025-12-06T14:24:00.936Z
8669548 8669548 20251202112947_FO6N3 US004Q 2025-12-03T14:04:29.333Z 2025-12-06T14:24:00.796Z
8669516 8669516 20251202112429_EMnbQ US004Q 2025-12-03T14:04:17.570Z 2025-12-06T14:23:59.087Z
8669469 8669469 20251202111626_ZCv4J US004Q 2025-12-03T14:04:03.402Z 2025-12-06T14:23:56.738Z
8669436 8669436 20251202111115_5QwJZ US004Q 2025-12-03T14:03:43.407Z 2025-12-06T14:23:54.274Z
8669392 8669392 20251202110537_quEhh US004Q 2025-12-03T14:03:33.465Z 2025-12-06T14:23:51.792Z
8669335 8669335 20251202105404_FrEPk US004Q 2025-12-03T14:03:23.897Z 2025-12-06T14:23:49.531Z
8669312 8669312 20251202105229_XTUqC US004Q 2025-12-03T14:03:20.759Z 2025-12-06T14:23:48.762Z
8669295 8669295 20251202104743_7EAxX US004Q 2025-12-03T14:03:17.736Z 2025-12-06T14:23:47.798Z
8669292 8669292 20251202104622_04i2L US004Q 2025-12-03T14:03:17.230Z 2025-12-06T14:23:47.612Z
8669184 8669184 20251202102931_FkR55 US004Q 2025-12-03T14:02:48.869Z 2025-12-06T14:23:39.296Z
8669162 8669162 20251202102450_9PTz1 US004Q 2025-12-03T14:02:45.973Z 2025-12-06T14:23:38.493Z
8669148 8669148 20251202101936_N6eQp US004Q 2025-12-03T14:02:43.412Z 2025-12-06T14:23:37.670Z
8669135 8669135 20251202101712_xg329 US004Q 2025-12-03T14:02:41.546Z 2025-12-06T14:23:35.407Z
8669018 8669018 20251202095352_XBZkV US004Q 2025-12-03T14:02:01.513Z 2025-12-06T14:23:25.974Z
8668933 8668933 20251202092824_qDlyg US004Q 2025-12-03T14:01:37.411Z 2025-12-06T14:23:21.874Z
8668909 8668909 20251202092136_Ts91s US004Q 2025-12-03T14:01:34.519Z 2025-12-06T14:23:21.135Z
8668889 8668889 20251202091800_qoysA US004Q 2025-12-03T14:01:32.268Z 2025-12-06T14:23:16.793Z
8668876 8668876 20251202091555_2H2WW US004Q 2025-12-03T14:01:31.076Z 2025-12-06T14:23:15.997Z
8668865 8668865 20251202091255_DJTi4 US004Q 2025-12-03T14:01:29.167Z 2025-12-06T14:23:14.820Z
8668763 8668763 20251202085348_uxJrP US004Q 2025-12-03T14:01:10.265Z 2025-12-06T14:23:08.884Z
8668718 8668718 20251202083953_uYS5x US004Q 2025-12-03T14:00:56.030Z 2025-12-06T14:23:06.561Z
8668716 8668716 20251202083809_FpHW6 US004Q 2025-12-03T14:00:55.600Z 2025-12-06T14:23:06.502Z
8668710 8668710 20251202083618_8GeLz US004Q 2025-12-03T14:00:54.703Z 2025-12-06T14:23:05.965Z
8668673 8668673 20251202081752_dVOaS US004Q 2025-12-03T14:00:48.032Z 2025-12-06T14:23:02.621Z
8668654 8668654 20251202080950_mAzrV US004Q 2025-12-03T14:00:44.014Z 2025-12-06T14:23:00.569Z
8668596 8668596 20251202075242_QSBGa US004Q 2025-12-03T14:00:31.742Z 2025-12-06T14:22:56.575Z
8668592 8668592 20251202075019_bxuj4 US004Q 2025-12-03T14:00:30.590Z 2025-12-06T14:22:56.367Z
8668575 8668575 20251202074458_ih2p0 US004Q 2025-12-03T14:00:28.331Z 2025-12-06T14:22:55.625Z
8668557 8668557 20251202073151_zTUnz US004Q 2025-12-03T14:00:21.706Z 2025-12-06T14:22:48.124Z
8668547 8668547 20251202073011_P2xrY US004Q 2025-12-03T14:00:17.895Z 2025-12-06T14:22:47.425Z
8668383 8668383 20251130074840_pPURs US004Q 2025-12-02T14:42:21.960Z 2025-12-06T14:50:31.254Z
8668350 8668350 20251130073450_kJl0V US004Q 2025-12-02T14:42:20.255Z 2025-12-06T14:50:30.731Z
8668348 8668348 20251130073432_SMRiW US004Q 2025-12-02T14:42:20.150Z 2025-12-06T14:50:30.669Z
8668318 8668318 20251130071924_Zsbfl US004Q 2025-12-02T14:42:18.722Z 2025-12-06T14:50:30.301Z
8668280 8668280 20251130070720_HCV8d US004Q 2025-12-02T14:42:16.480Z 2025-12-06T14:50:29.519Z
8668214 8668214 20251130064442_rQcsV US004Q 2025-12-02T14:42:11.765Z 2025-12-06T14:50:26.868Z
8668075 8668075 20251130055332_32bfI US004Q 2025-12-02T14:41:56.913Z 2025-12-06T14:50:15.257Z
8667886 8667886 20251130045336_O3C1J US004Q 2025-12-02T14:41:10.655Z 2025-12-06T14:49:34.417Z
8667698 8667698 20251130032159_ceaih US004Q 2025-12-02T14:39:45.861Z 2025-12-06T14:48:44.664Z
8667658 8667658 20251130031003_8MrCR US004Q 2025-12-02T14:39:37.924Z 2025-12-06T14:48:40.614Z
8667634 8667634 20251130025606_lyGEm US004Q 2025-12-02T14:39:30.608Z 2025-12-06T14:48:36.875Z
8660273 8660273 20251130121848_r5dHW US004Q 2025-12-02T14:07:11.265Z 2025-12-06T14:36:58.631Z
8659743 8659743 20251130111144_rcwsZ US004Q 2025-12-02T14:05:12.134Z 2025-12-06T14:36:41.204Z
8659642 8659642 20251130105906_83df1 US004Q 2025-12-02T14:04:42.966Z 2025-12-06T14:36:26.090Z
8659616 8659616 20251130105452_09DwV US004Q 2025-12-02T14:04:38.818Z 2025-12-06T14:36:25.253Z
8659562 8659562 20251130104819_6wlvQ US004Q 2025-12-02T14:04:29.346Z 2025-12-06T14:36:23.585Z
8659558 8659558 20251130104744_UoUEq US004Q 2025-12-02T14:04:28.419Z 2025-12-06T14:36:23.457Z
8659532 8659532 20251130104220_pMDD9 US004Q 2025-12-02T14:04:20.680Z 2025-12-06T14:36:22.880Z
8659461 8659461 20251130103032_GGA2C US004Q 2025-12-02T14:04:02.574Z 2025-12-06T14:36:19.436Z
8659442 8659442 20251130102831_kYAWD US004Q 2025-12-02T14:03:54.755Z 2025-12-06T14:36:18.516Z
8659432 8659432 20251130102631_2zBaq US004Q 2025-12-02T14:03:52.254Z 2025-12-06T14:36:18.001Z
8659318 8659318 20251130100844_5MEA9 US004Q 2025-12-02T14:03:28.701Z 2025-12-06T14:36:14.114Z
8659254 8659254 20251130095915_EJD8r US004Q 2025-12-02T14:03:15.758Z 2025-12-06T14:36:12.353Z
8659206 8659206 20251130094929_2WdJn US004Q 2025-12-02T14:02:57.344Z 2025-12-06T14:36:10.936Z
8659126 8659126 20251130093641_PV3x3 US004Q 2025-12-02T14:02:41.683Z 2025-12-06T14:36:07.937Z
8659064 8659064 20251130092718_3keZi US004Q 2025-12-02T14:02:25.126Z 2025-12-06T14:36:04.728Z
8658989 8658989 20251130091530_SwP00 US004Q 2025-12-02T14:02:03.354Z 2025-12-06T14:36:01.962Z
8658980 8658980 20251130091249_2SXqh US004Q 2025-12-02T14:02:00.136Z 2025-12-06T14:36:01.251Z
8658978 8658978 20251130091135_buSa2 US004Q 2025-12-02T14:01:59.399Z 2025-12-06T14:36:01.172Z
8658930 8658930 20251130085802_fDjCf US004Q 2025-12-02T14:01:41.214Z 2025-12-06T14:35:54.576Z
8658895 8658895 20251130085154_3km5z US004Q 2025-12-02T14:01:26.455Z 2025-12-06T14:35:46.356Z
8658860 8658860 20251130084217_krD04 US004Q 2025-12-02T14:01:16.759Z 2025-12-06T14:35:43.772Z
8658350 8658350 20251127014957_2Bajz US004Q 2025-12-01T14:57:51.484Z 2025-12-05T15:04:11.792Z
8658348 8658348 20251127012631_cPfR3 US004Q 2025-12-01T14:57:49.103Z 2025-12-05T15:04:04.914Z
8658344 8658344 20251126115308_oXfXg US004Q 2025-12-01T14:55:27.187Z 2025-12-05T15:01:31.438Z
8658336 8658336 20251126104025_Dktn7 US004Q 2025-12-01T14:54:40.172Z 2025-12-05T15:01:03.923Z
8658326 8658326 20251126092759_hWf1t US004Q 2025-12-01T14:54:16.464Z 2025-12-05T15:00:53.478Z
8658324 8658324 20251126092715_Uxr0L US004Q 2025-12-01T14:54:14.533Z 2025-12-05T15:00:53.379Z
8638069 8638069 20251128081800_aY80w US004Q 2025-11-29T14:28:27.811Z 2025-12-06T15:04:07.561Z
8638026 8638026 20251128080645_lMr2M US004Q 2025-11-29T14:28:25.334Z 2025-12-06T15:04:07.091Z
8638002 8638002 20251128075631_rH5Ta US004Q 2025-11-29T14:28:23.679Z 2025-12-06T15:04:06.746Z
8637922 8637922 20251128073226_R6fGS US004Q 2025-11-29T14:28:12.268Z 2025-12-06T15:04:05.680Z

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