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 = "US003N" 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
9611562 9611562 20260405023555_T3vm5 US003N 2026-04-06T12:15:06.859Z 2026-04-06T12:16:14.823Z
9611214 9611214 20260405005433_veC89 US003N 2026-04-06T12:13:30.403Z 2026-04-06T12:16:14.755Z
9609376 9609376 20260405051712_NHvh3 US003N 2026-04-06T12:01:30.928Z 2026-04-06T12:01:30.928Z
9609258 9609258 20260405040537_HMkb7 US003N 2026-04-06T12:00:50.615Z 2026-04-06T12:00:50.615Z
9607245 9607245 20260404060422_4hBaT US003N 2026-04-05T12:01:10.334Z 2026-04-06T12:16:14.392Z
9607203 9607203 20260404044957_2uRSx US003N 2026-04-05T12:00:53.001Z 2026-04-06T12:16:14.383Z
9607022 9607022 20260404031327_Siemx US003N 2026-04-05T12:00:09.011Z 2026-04-06T12:16:14.341Z
9598781 9598781 20260331062219_aajyE US003N 2026-04-01T12:01:02.492Z 2026-04-06T12:26:58.540Z
9598756 9598756 20260331045017_0lvG0 US003N 2026-04-01T12:00:53.942Z 2026-04-06T12:26:56.339Z
9593248 9593248 20260329083025_4kOr0 US003N 2026-03-30T12:03:22.828Z 2026-04-06T12:34:59.766Z
9593244 9593244 20260329082855_Zl9sV US003N 2026-03-30T12:03:22.037Z 2026-04-06T12:34:59.461Z
9593222 9593222 20260329080624_TlTsS US003N 2026-03-30T12:03:18.406Z 2026-04-06T12:34:57.965Z
9593201 9593201 20260329075424_Hick4 US003N 2026-03-30T12:03:15.951Z 2026-04-06T12:34:55.989Z
9593162 9593162 20260329071855_JQtrA US003N 2026-03-30T12:03:09.727Z 2026-04-06T12:34:54.073Z
9593078 9593078 20260329051738_w33Oj US003N 2026-03-30T12:02:52.106Z 2026-04-06T12:34:49.097Z
9592909 9592909 20260329035408_gDCeH US003N 2026-03-30T12:02:17.963Z 2026-04-06T12:34:40.135Z
9592644 9592644 20260329025118_2o92o US003N 2026-03-30T12:01:30.021Z 2026-04-06T12:34:18.961Z
9592530 9592530 20260329022331_Q2eFV US003N 2026-03-30T12:01:12.856Z 2026-04-06T12:34:14.168Z
9592375 9592375 20260329015929_17HFB US003N 2026-03-30T12:00:50.647Z 2026-04-06T12:34:08.579Z
9592303 9592303 20260329014606_RXYzy US003N 2026-03-30T12:00:36.676Z 2026-04-06T12:33:59.454Z
9590469 9590469 20260328092038_kn0la US003N 2026-03-29T12:02:43.106Z 2026-04-06T12:38:11.128Z
9590454 9590454 20260328091447_KMiKK US003N 2026-03-29T12:02:41.569Z 2026-04-06T12:38:10.377Z
9590371 9590371 20260328083846_ODk7Z US003N 2026-03-29T12:02:29.783Z 2026-04-06T12:38:03.556Z
9590316 9590316 20260328081313_VA3fg US003N 2026-03-29T12:02:24.742Z 2026-04-06T12:38:01.053Z
9590283 9590283 20260328080056_zO0bk US003N 2026-03-29T12:02:21.727Z 2026-04-06T12:37:59.514Z
9590244 9590244 20260328074626_r3cHo US003N 2026-03-29T12:02:19.278Z 2026-04-06T12:37:58.206Z
9590238 9590238 20260328074421_f46No US003N 2026-03-29T12:02:16.926Z 2026-04-06T12:37:57.883Z
9590218 9590218 20260328073414_zbfyS US003N 2026-03-29T12:02:14.538Z 2026-04-06T12:37:56.779Z
9590154 9590154 20260328071453_pL8qx US003N 2026-03-29T12:02:07.474Z 2026-04-06T12:37:53.780Z
9590090 9590090 20260328050844_2WaNJ US003N 2026-03-29T12:01:59.179Z 2026-04-06T12:37:50.208Z
9582868 9582868 20260326095305_aZHXo US003N 2026-03-27T12:07:03.817Z 2026-04-04T12:40:33.758Z
9582811 9582811 20260326093655_bKO2r US003N 2026-03-27T12:06:52.698Z 2026-04-04T12:40:29.804Z
9582756 9582756 20260326091908_VWqRX US003N 2026-03-27T12:06:42.322Z 2026-04-04T12:40:27.268Z
9582743 9582743 20260326091819_glKlc US003N 2026-03-27T12:06:39.336Z 2026-04-04T12:40:26.625Z
9582581 9582581 20260326083217_2jWIS US003N 2026-03-27T12:06:14.841Z 2026-04-04T12:40:11.865Z
9582550 9582550 20260326082418_aXCno US003N 2026-03-27T12:06:07.750Z 2026-04-04T12:40:08.836Z
9582459 9582459 20260326074336_gTPd3 US003N 2026-03-27T12:05:51.591Z 2026-04-04T12:40:02.239Z
9577393 9577393 20260325054137_UI89A US003N 2026-03-26T12:05:00.813Z 2026-04-03T12:37:00.119Z
9572660 9572660 20260324094448_mP5Zx US003N 2026-03-25T12:05:52.759Z 2026-04-02T12:35:33.126Z
9572422 9572422 20260324090216_2wIB7 US003N 2026-03-25T12:05:04.032Z 2026-04-02T12:35:24.203Z
9572307 9572307 20260324083124_b9Z3c US003N 2026-03-25T12:04:37.754Z 2026-04-02T12:35:13.462Z
9572214 9572214 20260324080503_SJ2DK US003N 2026-03-25T12:04:15.784Z 2026-04-02T12:35:07.970Z
9572202 9572202 20260324080440_uJYPj US003N 2026-03-25T12:04:14.451Z 2026-04-02T12:35:07.723Z
9572074 9572074 20260324072330_QP1d5 US003N 2026-03-25T12:03:40.515Z 2026-04-02T12:35:01.820Z
9572027 9572027 20260324070540_aS67O US003N 2026-03-25T12:03:33.258Z 2026-04-02T12:35:00.040Z
9572004 9572004 20260324065744_FOcph US003N 2026-03-25T12:03:28.747Z 2026-04-02T12:34:58.891Z
9571908 9571908 20260324054105_H0R2M US003N 2026-03-25T12:03:09.213Z 2026-04-02T12:34:54.622Z
9571901 9571901 20260324053854_68fWj US003N 2026-03-25T12:03:08.264Z 2026-04-02T12:34:54.278Z
9571892 9571892 20260324053359_jsHaY US003N 2026-03-25T12:03:06.546Z 2026-04-02T12:34:53.929Z
9571881 9571881 20260324053025_Flzwb US003N 2026-03-25T12:03:04.444Z 2026-04-02T12:34:53.511Z
9571862 9571862 20260324052232_Rr2Hr US003N 2026-03-25T12:03:01.046Z 2026-04-02T12:34:52.742Z
9571838 9571838 20260324050145_irW60 US003N 2026-03-25T12:02:55.130Z 2026-04-02T12:34:51.366Z
9571835 9571835 20260324045229_JGKZa US003N 2026-03-25T12:02:54.246Z 2026-04-02T12:34:51.136Z
9571812 9571812 20260324043504_RDiPM US003N 2026-03-25T12:02:47.988Z 2026-04-02T12:34:50.121Z
9556395 9556395 20260322102417_S3ze4 US003N 2026-03-23T12:04:45.011Z 2026-03-30T12:28:59.727Z
9556341 9556341 20260322100751_I9xlc US003N 2026-03-23T12:04:41.202Z 2026-03-30T12:28:58.075Z
9556201 9556201 20260322093251_zpWRx US003N 2026-03-23T12:04:28.154Z 2026-03-30T12:28:47.250Z
9556152 9556152 20260322092755_m1MiM US003N 2026-03-23T12:04:24.694Z 2026-03-30T12:28:46.148Z
9556069 9556069 20260322091211_rdOda US003N 2026-03-23T12:04:18.958Z 2026-03-30T12:28:43.845Z
9556067 9556067 20260322091107_s4ErF US003N 2026-03-23T12:04:18.704Z 2026-03-30T12:28:43.795Z
9555820 9555820 20260322081220_xDchl US003N 2026-03-23T12:03:58.714Z 2026-03-30T12:28:36.379Z
9555813 9555813 20260322081115_NyrEK US003N 2026-03-23T12:03:58.056Z 2026-03-30T12:28:36.225Z
9555709 9555709 20260322073454_8zY28 US003N 2026-03-23T12:03:48.305Z 2026-03-30T12:28:32.741Z
9555611 9555611 20260322070326_fUdmz US003N 2026-03-23T12:03:41.550Z 2026-03-30T12:28:30.552Z
9555604 9555604 20260322070001_RJU3r US003N 2026-03-23T12:03:41.015Z 2026-03-30T12:28:30.429Z
9555599 9555599 20260322065806_BrhLk US003N 2026-03-23T12:03:40.657Z 2026-03-30T12:28:30.311Z
9544595 9544595 20260321085847_AELwx US003N 2026-03-22T12:07:14.063Z 2026-03-29T12:19:31.482Z
9544345 9544345 20260321082122_UnisT US003N 2026-03-22T12:06:31.851Z 2026-03-29T12:19:28.647Z
9544317 9544317 20260321081648_C96Eh US003N 2026-03-22T12:06:25.417Z 2026-03-29T12:19:28.240Z
9536402 9536402 20260320094512_8OKT4 US003N 2026-03-21T12:13:20.261Z 2026-03-22T12:27:41.292Z
9536356 9536356 20260320093819_c72p5 US003N 2026-03-21T12:13:11.523Z 2026-03-28T12:35:00.748Z
9536345 9536345 20260320093624_pXAKL US003N 2026-03-21T12:13:10.243Z 2026-03-28T12:35:00.577Z
9536293 9536293 20260320093038_RdxjD US003N 2026-03-21T12:13:02.920Z 2026-03-28T12:34:59.330Z
9536220 9536220 20260320092455_Ws67m US003N 2026-03-21T12:12:50.182Z 2026-03-28T12:34:58.654Z
9536107 9536107 20260320091204_65uda US003N 2026-03-21T12:12:37.576Z 2026-03-28T12:34:57.598Z
9536009 9536009 20260320085931_F6FVj US003N 2026-03-21T12:12:20.892Z 2026-03-28T12:34:55.345Z
9535640 9535640 20260320081226_ESwYY US003N 2026-03-21T12:11:25.245Z 2026-03-28T12:34:48.249Z
9535627 9535627 20260320081052_4ECX5 US003N 2026-03-21T12:11:23.094Z 2026-03-28T12:34:47.907Z
9535494 9535494 20260320074614_uVvW1 US003N 2026-03-21T12:10:59.030Z 2026-03-28T12:34:45.096Z
9535417 9535417 20260320073000_02DOp US003N 2026-03-21T12:10:43.222Z 2026-03-28T12:34:34.590Z
9535389 9535389 20260320072101_ZBl3x US003N 2026-03-21T12:10:36.644Z 2026-03-28T12:34:34.113Z
9535334 9535334 20260320071012_XtILc US003N 2026-03-21T12:10:25.106Z 2026-03-28T12:34:33.110Z
9535244 9535244 20260320063215_QcWpx US003N 2026-03-21T12:10:10.880Z 2026-03-28T12:34:30.972Z
9535241 9535241 20260320062704_Vt6JX US003N 2026-03-21T12:10:10.364Z 2026-03-28T12:34:30.709Z
9535171 9535171 20260320055702_C0L4l US003N 2026-03-21T12:09:56.875Z 2026-03-28T12:34:28.772Z
9535127 9535127 20260320054450_cNsj2 US003N 2026-03-21T12:09:49.970Z 2026-03-28T12:34:27.926Z
9535071 9535071 20260320052547_61Jyq US003N 2026-03-21T12:09:40.246Z 2026-03-28T12:34:26.801Z
9535030 9535030 20260320051407_95ic2 US003N 2026-03-21T12:09:31.801Z 2026-03-28T12:34:25.965Z
9535025 9535025 20260320051331_H3dV9 US003N 2026-03-21T12:09:31.412Z 2026-03-28T12:34:25.893Z
9534947 9534947 20260320044623_312qU US003N 2026-03-21T12:09:14.953Z 2026-03-28T12:34:24.002Z
9534931 9534931 20260320044215_YKuiQ US003N 2026-03-21T12:09:12.128Z 2026-03-28T12:34:23.699Z
9512880 9512880 20260318075833_BhbDK US003N 2026-03-19T12:13:47.157Z 2026-03-26T12:37:49.604Z
9512864 9512864 20260318075729_gyKFZ US003N 2026-03-19T12:13:44.522Z 2026-03-26T12:37:49.508Z
9512773 9512773 20260318074644_O5Kka US003N 2026-03-19T12:13:33.004Z 2026-03-26T12:37:48.847Z
9512699 9512699 20260318073620_9oq4o US003N 2026-03-19T12:13:21.426Z 2026-03-26T12:37:48.159Z
9512573 9512573 20260318070842_zW48f US003N 2026-03-19T12:13:00.389Z 2026-03-26T12:37:46.879Z
9512561 9512561 20260318070451_Ke5o3 US003N 2026-03-19T12:12:56.390Z 2026-03-26T12:37:46.736Z
9512559 9512559 20260318070451_MygS2 US003N 2026-03-19T12:12:56.034Z 2026-03-19T12:27:30.350Z
9512537 9512537 20260318065654_isitW US003N 2026-03-19T12:12:52.379Z 2026-03-26T12:37:46.428Z
9512531 9512531 20260318065231_WhfvH US003N 2026-03-19T12:12:50.351Z 2026-03-26T12:37:46.392Z

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