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,244 rows where station_code = "USN004" 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
9268625 9268625 20260128105459_bLguD USN004 2026-01-29T14:04:02.742Z 2026-01-29T14:04:02.742Z
9267876 9267876 20260127062257_g6rEf USN004 2026-01-28T14:23:43.552Z 2026-01-29T14:35:50.051Z
9267667 9267667 20260127040720_m9LQa USN004 2026-01-28T14:22:48.006Z 2026-01-29T14:35:26.697Z
9267632 9267632 20260127034902_Qs3ta USN004 2026-01-28T14:22:36.429Z 2026-01-29T14:35:23.663Z
9264117 9264117 20260127111635_Vn8Ip USN004 2026-01-28T14:04:28.826Z 2026-01-29T14:30:20.055Z
9264100 9264100 20260127111427_BV4yH USN004 2026-01-28T14:04:25.102Z 2026-01-29T14:30:20.051Z
9264045 9264045 20260127110301_Y6jSF USN004 2026-01-28T14:04:06.736Z 2026-01-29T14:30:20.027Z
9263613 9263613 20260127092353_4IyUk USN004 2026-01-28T14:01:42.469Z 2026-01-29T14:30:16.593Z
9263604 9263604 20260127092307_rYeZ5 USN004 2026-01-28T14:01:40.289Z 2026-01-29T14:30:16.587Z
9263464 9263464 20260127081802_2DRBF USN004 2026-01-28T14:00:46.261Z 2026-01-29T14:30:16.518Z
9255263 9255263 20260124021621_fOkEE USN004 2026-01-25T14:12:35.323Z 2026-01-29T14:47:13.398Z
9255229 9255229 20260124015707_CH1Jb USN004 2026-01-25T14:12:27.864Z 2026-01-29T14:47:11.398Z
9244615 9244615 20260121091532_6Szhb USN004 2026-01-22T14:26:12.285Z 2026-01-29T15:06:27.691Z
9244597 9244597 20260121091333_ueDCP USN004 2026-01-22T14:26:04.862Z 2026-01-29T15:06:27.071Z
9244499 9244499 20260121084342_Cr74B USN004 2026-01-22T14:25:51.213Z 2026-01-29T15:06:22.722Z
9244177 9244177 20260121063106_NmRuA USN004 2026-01-22T14:24:31.400Z 2026-01-29T15:05:54.791Z
9243993 9243993 20260121054951_U1Ap4 USN004 2026-01-22T14:23:52.899Z 2026-01-29T15:05:37.790Z
9243597 9243597 20260121045055_yo5to USN004 2026-01-22T14:22:18.243Z 2026-01-29T15:05:19.377Z
9243549 9243549 20260121044735_0sbWg USN004 2026-01-22T14:22:10.660Z 2026-01-29T15:05:17.518Z
9242226 9242226 20260121010634_Fh4pX USN004 2026-01-22T14:16:56.589Z 2026-01-29T15:03:37.631Z
9239431 9239431 20260121104616_QSPBW USN004 2026-01-22T14:01:25.070Z 2026-01-29T14:54:15.533Z
9239353 9239353 20260121103045_OMUte USN004 2026-01-22T14:01:06.841Z 2026-01-29T14:54:10.903Z
9239258 9239258 20260121101614_MNHHg USN004 2026-01-22T14:00:39.079Z 2026-01-29T14:54:04.051Z
9239248 9239248 20260121101105_xJLrk USN004 2026-01-22T14:00:34.697Z 2026-01-29T14:54:02.142Z
9238709 9238709 20260120093714_iyEZy USN004 2026-01-21T14:30:26.224Z 2026-01-28T15:02:47.110Z
9238699 9238699 20260120093442_AgyxM USN004 2026-01-21T14:30:25.427Z 2026-01-28T15:02:46.711Z
9238505 9238505 20260120084852_2sVQt USN004 2026-01-21T14:29:49.586Z 2026-01-28T15:02:36.287Z
9238200 9238200 20260120075554_cKhIf USN004 2026-01-21T14:28:54.838Z 2026-01-28T15:02:13.513Z
9238035 9238035 20260120070729_jBGr8 USN004 2026-01-21T14:28:22.793Z 2026-01-28T15:02:04.217Z
9237983 9237983 20260120064451_MlWxl USN004 2026-01-21T14:28:11.806Z 2026-01-28T15:02:01.779Z
9235189 9235189 20260120004141_x718V USN004 2026-01-21T14:17:51.794Z 2026-01-28T14:58:42.651Z
9232599 9232599 20260120115616_mYY6l USN004 2026-01-21T14:02:31.081Z 2026-01-29T14:59:52.942Z
9232565 9232565 20260120114920_zwi9d USN004 2026-01-21T14:02:23.747Z 2026-01-29T14:59:51.026Z
9232404 9232404 20260120112206_pPbfi USN004 2026-01-21T14:01:40.692Z 2026-01-29T14:59:32.854Z
9232014 9232014 20260119104020_Uf35C USN004 2026-01-20T14:35:10.852Z 2026-01-27T15:07:12.458Z
9231880 9231880 20260119100858_3w0JS USN004 2026-01-20T14:34:41.172Z 2026-01-27T15:07:03.821Z
9231697 9231697 20260119093126_bOADM USN004 2026-01-20T14:33:56.854Z 2026-01-27T15:06:55.464Z
9231629 9231629 20260119090651_vSzpD USN004 2026-01-20T14:33:40.634Z 2026-01-27T15:06:41.487Z
9231585 9231585 20260119085353_isAYq USN004 2026-01-20T14:33:27.726Z 2026-01-27T15:06:37.496Z
9231568 9231568 20260119084950_rWehH USN004 2026-01-20T14:33:23.382Z 2026-01-27T15:06:36.577Z
9231131 9231131 20260119060927_3srBO USN004 2026-01-20T14:31:27.970Z 2026-01-27T15:06:00.279Z
9231121 9231121 20260119060657_aA3Ts USN004 2026-01-20T14:31:24.723Z 2026-01-27T15:05:59.682Z
9230970 9230970 20260119053505_g4h21 USN004 2026-01-20T14:30:39.030Z 2026-01-27T15:05:50.537Z
9230967 9230967 20260119053440_SsHgq USN004 2026-01-20T14:30:38.476Z 2026-01-27T15:05:50.417Z
9230694 9230694 20260119045018_UY23V USN004 2026-01-20T14:29:16.334Z 2026-01-27T15:05:20.869Z
9229604 9229604 20260119020612_X0gkw USN004 2026-01-20T14:23:18.674Z 2026-01-27T15:03:44.509Z
9226297 9226297 20260119114322_n8TEG USN004 2026-01-20T14:02:20.101Z 2026-01-28T14:54:53.070Z
9226088 9226088 20260119110437_Itva9 USN004 2026-01-20T14:01:03.240Z 2026-01-28T14:54:34.167Z
9225089 9225089 20260118073050_EVpKT USN004 2026-01-19T14:27:31.555Z 2026-01-26T15:04:01.226Z
9225029 9225029 20260118071755_5Kppo USN004 2026-01-19T14:27:18.779Z 2026-01-26T15:03:59.245Z
9220054 9220054 20260118115808_ESa3a USN004 2026-01-19T14:02:22.277Z 2026-01-27T14:58:47.569Z
9214884 9214884 20260116083421_VPWHm USN004 2026-01-17T14:23:36.647Z 2026-01-24T15:14:11.384Z
9214825 9214825 20260116081921_Y23tL USN004 2026-01-17T14:23:25.747Z 2026-01-24T15:14:09.178Z
9214810 9214810 20260116081753_92v7M USN004 2026-01-17T14:23:23.950Z 2026-01-24T15:14:08.773Z
9214749 9214749 20260116075506_EVu6c USN004 2026-01-17T14:23:04.718Z 2026-01-24T15:14:04.072Z
9214696 9214696 20260116074252_V2TGR USN004 2026-01-17T14:22:47.217Z 2026-01-24T15:14:01.855Z
9214568 9214568 20260116065506_E3mxZ USN004 2026-01-17T14:22:05.876Z 2026-01-24T15:13:52.006Z
9214259 9214259 20260116060111_f6GdN USN004 2026-01-17T14:20:47.497Z 2026-01-24T15:13:26.482Z
9213802 9213802 20260116044500_h9I4E USN004 2026-01-17T14:18:37.537Z 2026-01-24T15:12:47.158Z
9213732 9213732 20260116043218_HdoNF USN004 2026-01-17T14:18:16.694Z 2026-01-24T15:12:32.566Z
9213695 9213695 20260116042752_oVoh2 USN004 2026-01-17T14:18:10.264Z 2026-01-24T15:12:31.315Z
9212921 9212921 20260116013942_LhRnj USN004 2026-01-17T14:14:35.838Z 2026-01-24T15:11:34.169Z
9209558 9209558 20260115100805_gY0JH USN004 2026-01-16T14:16:44.118Z 2026-01-22T15:05:29.172Z
9209199 9209199 20260115085441_4Z2ng USN004 2026-01-16T14:15:30.945Z 2026-01-22T15:04:51.496Z
9209060 9209060 20260115081727_t6oia USN004 2026-01-16T14:14:58.790Z 2026-01-22T15:04:47.955Z
9209029 9209029 20260115080943_E4xmQ USN004 2026-01-16T14:14:51.314Z 2026-01-22T15:04:46.967Z
9208911 9208911 20260115072623_3z1JB USN004 2026-01-16T14:14:25.530Z 2026-01-22T15:04:43.302Z
9208307 9208307 20260115050056_3Ykka USN004 2026-01-16T14:12:05.533Z 2026-01-22T15:04:06.985Z
9207876 9207876 20260115032617_xoyAR USN004 2026-01-16T14:10:30.371Z 2026-01-22T15:03:55.510Z
9207861 9207861 20260115032217_pH5rz USN004 2026-01-16T14:10:27.155Z 2026-01-22T15:03:55.167Z
9203435 9203435 20260114045708_sqR9T USN004 2026-01-15T14:24:24.647Z 2026-01-22T15:10:07.521Z
9202459 9202459 20260114033932_Cz6j0 USN004 2026-01-15T14:21:20.424Z 2026-01-22T15:09:20.370Z
9201399 9201399 20260114021327_o2Dg9 USN004 2026-01-15T14:18:32.939Z 2026-01-22T15:09:02.997Z
9200672 9200672 20260114004847_aWFia USN004 2026-01-15T14:16:04.707Z 2026-01-22T15:08:23.175Z
9200647 9200647 20260114004310_Udhks USN004 2026-01-15T14:15:55.267Z 2026-01-22T15:08:22.588Z
9197563 9197563 20260113114324_tjc8c USN004 2026-01-14T14:23:28.331Z 2026-01-21T15:06:20.382Z
9197441 9197441 20260113111139_Sy1C8 USN004 2026-01-14T14:22:53.037Z 2026-01-21T15:06:18.347Z
9197342 9197342 20260113105449_JqX2w USN004 2026-01-14T14:22:27.579Z 2026-01-21T15:06:17.011Z
9197193 9197193 20260113102518_3Eayb USN004 2026-01-14T14:21:50.076Z 2026-01-21T15:06:15.023Z
9196938 9196938 20260113094234_k3SGu USN004 2026-01-14T14:20:45.888Z 2026-01-21T15:06:10.004Z
9196924 9196924 20260113093805_NH9pQ USN004 2026-01-14T14:20:41.830Z 2026-01-21T15:06:07.215Z
9196659 9196659 20260113081431_NsC0Z USN004 2026-01-14T14:19:24.245Z 2026-01-21T15:05:36.160Z
9196636 9196636 20260113080226_ovKow USN004 2026-01-14T14:19:18.015Z 2026-01-21T15:05:35.699Z
9196490 9196490 20260113071449_rIQDe USN004 2026-01-14T14:18:36.465Z 2026-01-21T15:05:33.700Z
9196469 9196469 20260113070918_3UaU3 USN004 2026-01-14T14:18:27.255Z 2026-01-21T15:05:33.471Z
9196270 9196270 20260113054950_nPy0y USN004 2026-01-14T14:17:30.333Z 2026-01-21T15:05:30.660Z
9195102 9195102 20260113001839_Ji3y0 USN004 2026-01-14T14:12:01.421Z 2026-01-21T15:04:36.148Z
9195011 9195011 20260112235851_ezuoO USN004 2026-01-14T14:11:42.156Z 2026-01-21T15:04:35.121Z
9191664 9191664 20260112113255_MV9zu USN004 2026-01-13T14:26:05.808Z 2026-01-20T15:25:42.623Z
9191581 9191581 20260112112233_Jd6Q6 USN004 2026-01-13T14:25:48.169Z 2026-01-20T15:25:39.464Z
9191117 9191117 20260112103436_ujEU4 USN004 2026-01-13T14:24:28.499Z 2026-01-20T15:25:10.839Z
9190348 9190348 20260112085059_a1dUn USN004 2026-01-13T14:21:51.473Z 2026-01-20T15:24:18.776Z
9190309 9190309 20260112084441_DSYXD USN004 2026-01-13T14:21:43.591Z 2026-01-20T15:24:15.859Z
9190140 9190140 20260112080048_DgzQA USN004 2026-01-13T14:20:53.828Z 2026-01-20T15:24:08.453Z
9190118 9190118 20260112075258_f7IW2 USN004 2026-01-13T14:20:46.433Z 2026-01-20T15:24:07.518Z
9189985 9189985 20260112071640_vwWG8 USN004 2026-01-13T14:20:12.024Z 2026-01-20T15:24:00.960Z
9189888 9189888 20260112064459_R1lAB USN004 2026-01-13T14:19:46.900Z 2026-01-20T15:23:45.785Z
9189649 9189649 20260112053908_wOXWS USN004 2026-01-13T14:18:44.060Z 2026-01-20T15:23:33.230Z
9189644 9189644 20260112053516_8pLdM USN004 2026-01-13T14:18:40.169Z 2026-01-20T15:23:33.016Z
9189316 9189316 20260112035811_JQ8YF USN004 2026-01-13T14:16:59.426Z 2026-01-20T15:23:03.638Z

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