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,807 rows where station_code = "US003P" 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
9611563 9611563 20260405023555_T3vm5 US003P 2026-04-06T12:15:06.859Z 2026-04-06T12:16:14.823Z
9611545 9611545 20260405023315_h72Xe US003P 2026-04-06T12:15:03.030Z 2026-04-06T12:16:14.819Z
9611513 9611513 20260405022553_nf71F US003P 2026-04-06T12:14:53.267Z 2026-04-06T12:16:14.814Z
9609396 9609396 20260405055359_K5yAC US003P 2026-04-06T12:01:37.561Z 2026-04-06T12:01:37.561Z
9609259 9609259 20260405040537_HMkb7 US003P 2026-04-06T12:00:50.628Z 2026-04-06T12:00:50.628Z
9608987 9608987 20260404030036_8vH4Y US003P 2026-04-05T12:12:29.676Z 2026-04-06T12:20:55.544Z
9598969 9598969 20260331100148_cRIjg US003P 2026-04-01T12:01:49.415Z 2026-04-06T12:27:12.672Z
9598943 9598943 20260331091943_aIVFA US003P 2026-04-01T12:01:41.058Z 2026-04-06T12:27:10.655Z
9598788 9598788 20260331070632_qF4Ex US003P 2026-04-01T12:01:04.966Z 2026-04-06T12:26:59.038Z
9593228 9593228 20260329081617_i423A US003P 2026-03-30T12:03:19.496Z 2026-04-06T12:34:58.393Z
9593226 9593226 20260329081546_Sn3o1 US003P 2026-03-30T12:03:19.170Z 2026-04-06T12:34:58.215Z
9593156 9593156 20260329070500_yepVC US003P 2026-03-30T12:03:08.924Z 2026-04-06T12:34:53.832Z
9593140 9593140 20260329065114_VXS4q US003P 2026-03-30T12:03:04.480Z 2026-04-06T12:34:52.678Z
9593117 9593117 20260329063726_gjH1j US003P 2026-03-30T12:02:59.806Z 2026-04-06T12:34:51.324Z
9593083 9593083 20260329052621_U9MsE US003P 2026-03-30T12:02:53.082Z 2026-04-06T12:34:49.364Z
9593051 9593051 20260329044021_5FODN US003P 2026-03-30T12:02:45.334Z 2026-04-06T12:34:47.576Z
9592376 9592376 20260329015929_17HFB US003P 2026-03-30T12:00:50.647Z 2026-04-06T12:34:08.579Z
9592304 9592304 20260329014606_RXYzy US003P 2026-03-30T12:00:36.690Z 2026-04-06T12:33:59.454Z
9590505 9590505 20260328094202_M22zD US003P 2026-03-29T12:02:49.301Z 2026-04-06T12:38:13.355Z
9590239 9590239 20260328074421_f46No US003P 2026-03-29T12:02:16.926Z 2026-04-06T12:37:57.883Z
9590219 9590219 20260328073414_zbfyS US003P 2026-03-29T12:02:14.538Z 2026-04-06T12:37:56.779Z
9590160 9590160 20260328071657_9mMyf US003P 2026-03-29T12:02:08.089Z 2026-04-06T12:37:54.201Z
9590155 9590155 20260328071453_pL8qx US003P 2026-03-29T12:02:07.474Z 2026-04-06T12:37:53.780Z
9582819 9582819 20260326094159_C1q52 US003P 2026-03-27T12:06:54.584Z 2026-04-04T12:40:30.445Z
9582791 9582791 20260326092818_wuI8u US003P 2026-03-27T12:06:48.724Z 2026-04-04T12:40:28.571Z
9582757 9582757 20260326091908_VWqRX US003P 2026-03-27T12:06:42.322Z 2026-04-04T12:40:27.268Z
9577394 9577394 20260325054137_UI89A US003P 2026-03-26T12:05:00.832Z 2026-04-03T12:37:00.119Z
9572697 9572697 20260324095348_s9kJr US003P 2026-03-25T12:06:01.201Z 2026-04-02T12:35:34.806Z
9572287 9572287 20260324083003_6xw0b US003P 2026-03-25T12:04:35.221Z 2026-04-02T12:35:12.796Z
9572276 9572276 20260324082610_ys5a8 US003P 2026-03-25T12:04:32.141Z 2026-04-02T12:35:12.107Z
9572253 9572253 20260324082127_3LKHm US003P 2026-03-25T12:04:26.130Z 2026-04-02T12:35:10.997Z
9572203 9572203 20260324080440_uJYPj US003P 2026-03-25T12:04:14.451Z 2026-04-02T12:35:07.723Z
9572179 9572179 20260324080020_v3Z0y US003P 2026-03-25T12:04:08.240Z 2026-04-02T12:35:06.653Z
9572138 9572138 20260324074911_cVR5f US003P 2026-03-25T12:03:58.982Z 2026-04-02T12:35:04.889Z
9572111 9572111 20260324074301_Rj67Y US003P 2026-03-25T12:03:53.166Z 2026-04-02T12:35:03.987Z
9572086 9572086 20260324072728_tE1Q3 US003P 2026-03-25T12:03:45.245Z 2026-04-02T12:35:02.635Z
9572077 9572077 20260324072340_2Kp71 US003P 2026-03-25T12:03:41.096Z 2026-04-02T12:35:01.960Z
9572075 9572075 20260324072330_QP1d5 US003P 2026-03-25T12:03:40.515Z 2026-04-02T12:35:01.820Z
9572063 9572063 20260324071943_bxbSv US003P 2026-03-25T12:03:38.659Z 2026-04-02T12:35:01.342Z
9572020 9572020 20260324070339_PFQ9l US003P 2026-03-25T12:03:31.744Z 2026-04-02T12:34:59.643Z
9572005 9572005 20260324065744_FOcph US003P 2026-03-25T12:03:28.747Z 2026-04-02T12:34:58.891Z
9571915 9571915 20260324054755_DHK33 US003P 2026-03-25T12:03:10.675Z 2026-04-02T12:34:54.985Z
9571909 9571909 20260324054105_H0R2M US003P 2026-03-25T12:03:09.213Z 2026-04-02T12:34:54.622Z
9571902 9571902 20260324053854_68fWj US003P 2026-03-25T12:03:08.264Z 2026-04-02T12:34:54.278Z
9571888 9571888 20260324053321_R4q60 US003P 2026-03-25T12:03:05.880Z 2026-04-02T12:34:53.816Z
9571882 9571882 20260324053025_Flzwb US003P 2026-03-25T12:03:04.444Z 2026-04-02T12:34:53.511Z
9556342 9556342 20260322100751_I9xlc US003P 2026-03-23T12:04:41.202Z 2026-03-30T12:28:58.075Z
9556060 9556060 20260322090848_5Rus0 US003P 2026-03-23T12:04:17.922Z 2026-03-30T12:28:42.760Z
9555955 9555955 20260322084939_i1wgd US003P 2026-03-23T12:04:11.882Z 2026-03-30T12:28:40.227Z
9555670 9555670 20260322072348_KhFHi US003P 2026-03-23T12:03:45.608Z 2026-03-30T12:28:31.869Z
9555641 9555641 20260322071409_Mtp1j US003P 2026-03-23T12:03:43.862Z 2026-03-30T12:28:31.172Z
9544981 9544981 20260321094718_fM9b9 US003P 2026-03-22T12:08:19.360Z 2026-03-29T12:19:35.959Z
9536359 9536359 20260320093852_VREmX US003P 2026-03-21T12:13:11.890Z 2026-03-28T12:35:00.772Z
9536319 9536319 20260320093359_qrJiy US003P 2026-03-21T12:13:06.024Z 2026-03-28T12:34:59.713Z
9536294 9536294 20260320093038_RdxjD US003P 2026-03-21T12:13:02.920Z 2026-03-28T12:34:59.330Z
9535490 9535490 20260320074558_2spoT US003P 2026-03-21T12:10:57.578Z 2026-03-28T12:34:45.031Z
9535141 9535141 20260320054930_FuL4O US003P 2026-03-21T12:09:53.133Z 2026-03-28T12:34:28.280Z
9535128 9535128 20260320054450_cNsj2 US003P 2026-03-21T12:09:49.970Z 2026-03-28T12:34:27.926Z
9535026 9535026 20260320051331_H3dV9 US003P 2026-03-21T12:09:31.412Z 2026-03-28T12:34:25.893Z
9512538 9512538 20260318065654_isitW US003P 2026-03-19T12:12:52.379Z 2026-03-26T12:37:46.428Z
9512476 9512476 20260318062857_TFDc5 US003P 2026-03-19T12:12:40.230Z 2026-03-26T12:37:45.890Z
9512359 9512359 20260318053418_MFESt US003P 2026-03-19T12:12:18.105Z 2026-03-26T12:37:44.402Z
9512347 9512347 20260318052509_uO4ba US003P 2026-03-19T12:12:15.303Z 2026-03-26T12:37:44.328Z
9512266 9512266 20260318050129_2v5r2 US003P 2026-03-19T12:12:03.122Z 2026-03-26T12:37:43.395Z
9512203 9512203 20260318045535_K2ygE US003P 2026-03-19T12:11:54.410Z 2026-03-26T12:37:42.948Z
9511862 9511862 20260318042612_zbYb2 US003P 2026-03-19T12:11:12.364Z 2026-03-26T12:37:40.382Z
9511298 9511298 20260318034519_pBBPo US003P 2026-03-19T12:09:53.723Z 2026-03-26T12:37:34.397Z
9510828 9510828 20260318031810_MXAf6 US003P 2026-03-19T12:08:45.793Z 2026-03-26T12:37:17.029Z
9510346 9510346 20260318024607_Rc1hw US003P 2026-03-19T12:07:26.313Z 2026-03-26T12:37:11.846Z
9508956 9508956 20260318011716_bcqxX US003P 2026-03-19T12:04:09.677Z 2026-03-26T12:37:02.064Z
9508740 9508740 20260318010843_fWObN US003P 2026-03-19T12:03:43.565Z 2026-03-26T12:37:00.511Z
9503315 9503315 20260317083102_A1GDU US003P 2026-03-18T12:05:22.268Z 2026-03-25T12:42:15.215Z
9503158 9503158 20260317081139_qROKI US003P 2026-03-18T12:05:02.913Z 2026-03-25T12:42:14.351Z
9503050 9503050 20260317075022_SOJ4L US003P 2026-03-18T12:04:45.804Z 2026-03-25T12:42:11.245Z
9502785 9502785 20260317062224_ihk6h US003P 2026-03-18T12:04:03.196Z 2026-03-25T12:41:59.400Z
9502754 9502754 20260317055750_pBm2d US003P 2026-03-18T12:03:57.062Z 2026-03-25T12:41:58.445Z
9486143 9486143 20260315050420_XZ73X US003P 2026-03-16T12:08:49.600Z 2026-03-23T12:21:55.569Z
9478943 9478943 20260314102525_E5MYa US003P 2026-03-15T12:12:21.603Z 2026-03-22T12:42:12.524Z
9478604 9478604 20260314093944_C5ff0 US003P 2026-03-15T12:11:30.344Z 2026-03-22T12:42:10.860Z
9478405 9478405 20260314091813_sp3QV US003P 2026-03-15T12:11:00.665Z 2026-03-22T12:42:09.987Z
9477923 9477923 20260314073900_n3Vq2 US003P 2026-03-15T12:09:41.042Z 2026-03-22T12:42:06.479Z
9477886 9477886 20260314072119_lKjqF US003P 2026-03-15T12:09:32.836Z 2026-03-22T12:42:06.210Z
9477869 9477869 20260314071442_kqKKs US003P 2026-03-15T12:09:27.675Z 2026-03-22T12:42:06.040Z
9477813 9477813 20260314065128_i8JEO US003P 2026-03-15T12:09:15.956Z 2026-03-22T12:42:05.499Z
9477745 9477745 20260314062320_kwqaZ US003P 2026-03-15T12:08:58.910Z 2026-03-22T12:42:04.885Z
9477734 9477734 20260314061828_Y1yfE US003P 2026-03-15T12:08:57.370Z 2026-03-22T12:42:04.793Z
9477638 9477638 20260314052550_cpxLA US003P 2026-03-15T12:08:40.545Z 2026-03-22T12:42:04.051Z
9477226 9477226 20260314043058_HEAmZ US003P 2026-03-15T12:07:54.244Z 2026-03-22T12:42:01.875Z
9477072 9477072 20260314041204_u36LO US003P 2026-03-15T12:07:32.508Z 2026-03-22T12:42:00.938Z
9471414 9471414 20260313101128_10qZC US003P 2026-03-14T12:10:21.869Z 2026-03-21T12:49:21.409Z
9471314 9471314 20260313094633_3bjp9 US003P 2026-03-14T12:10:01.759Z 2026-03-21T12:49:19.983Z
9471312 9471312 20260313094547_zXbZr US003P 2026-03-14T12:10:01.080Z 2026-03-21T12:49:19.982Z
9471274 9471274 20260313093657_iIJOt US003P 2026-03-14T12:09:54.378Z 2026-03-21T12:49:19.462Z
9471245 9471245 20260313093053_ObBGZ US003P 2026-03-14T12:09:47.757Z 2026-03-21T12:49:19.165Z
9471181 9471181 20260313091822_y1rkJ US003P 2026-03-14T12:09:36.925Z 2026-03-21T12:49:18.433Z
9471162 9471162 20260313091406_Zpw1l US003P 2026-03-14T12:09:34.555Z 2026-03-21T12:49:18.300Z
9470721 9470721 20260313072942_GdH3S US003P 2026-03-14T12:08:11.935Z 2026-03-21T12:49:12.600Z
9470712 9470712 20260313072749_tZsxE US003P 2026-03-14T12:08:10.731Z 2026-03-21T12:49:12.421Z
9470647 9470647 20260313070816_3Ph4L US003P 2026-03-14T12:08:01.764Z 2026-03-21T12:49:11.568Z
9470573 9470573 20260313063037_2Dex3 US003P 2026-03-14T12:07:45.288Z 2026-03-21T12:49:10.924Z

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