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

120 rows where station_code = "US0048" 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
8658727 8658727 20251201094108_As2pI US0048 2025-12-02T14:00:28.550Z 2025-12-06T14:30:11.537Z
8658700 8658700 20251201080531_Wb33Z US0048 2025-12-02T14:00:20.090Z 2025-12-06T14:29:53.598Z
8637271 8637271 20251128052336_JWsbs US0048 2025-11-29T14:27:02.507Z 2025-12-06T15:03:58.457Z
8626948 8626948 20251128100224_9Q6Ef US0048 2025-11-29T14:02:08.261Z 2025-12-06T14:51:09.643Z
8624550 8624550 20251127052339_0EG2S US0048 2025-11-28T14:25:08.018Z 2025-12-05T15:05:13.635Z
8624362 8624362 20251127042806_lLDls US0048 2025-11-28T14:24:32.694Z 2025-12-05T15:05:00.052Z
8623752 8623752 20251127015421_jVojl US0048 2025-11-28T14:22:48.969Z 2025-12-05T15:04:15.016Z
8623414 8623414 20251127002717_1pYd6 US0048 2025-11-28T14:21:41.594Z 2025-12-05T15:03:49.791Z
8605196 8605196 20251126112053_uNP0D US0048 2025-11-27T14:02:26.169Z 2025-12-05T15:01:12.534Z
8592832 8592832 20251124093212_xzyIg US0048 2025-11-25T14:28:04.862Z 2025-12-02T15:13:07.943Z
8592621 8592621 20251124084621_s2hl2 US0048 2025-11-25T14:27:21.381Z 2025-12-02T15:13:05.844Z
8583423 8583423 20251124110036_DJASF US0048 2025-11-25T14:01:54.257Z 2025-12-02T15:05:30.138Z
8581989 8581989 20251123033122_FhlX2 US0048 2025-11-24T14:32:57.806Z 2025-12-01T15:22:10.008Z
8515261 8515261 20251118040607_0qnoJ US0048 2025-11-19T14:39:22.348Z 2025-11-26T15:07:59.919Z
8513920 8513920 20251118011835_Y6S1w US0048 2025-11-19T14:36:37.557Z 2025-11-26T15:07:51.514Z
8498572 8498572 20251117084656_bLenh US0048 2025-11-18T14:30:35.918Z 2025-11-25T15:11:17.303Z
8498561 8498561 20251117083251_2rR6A US0048 2025-11-18T14:30:34.316Z 2025-11-25T15:11:15.764Z
8493627 8493627 20251117015533_wGN9v US0048 2025-11-18T14:22:33.780Z 2025-11-25T15:09:20.367Z
8485059 8485059 20251115102314_f6y3C US0048 2025-11-17T14:33:13.437Z 2025-11-23T15:19:54.324Z
8483926 8483926 20251115091037_3Nls6 US0048 2025-11-17T14:32:05.284Z 2025-11-23T15:19:20.564Z
8470669 8470669 20251115052427_0Nbf2 US0048 2025-11-16T14:23:14.426Z 2025-11-23T15:18:16.883Z
8469763 8469763 20251115033149_bGc34 US0048 2025-11-16T14:21:02.917Z 2025-11-23T15:17:57.361Z
8461900 8461900 20251114101633_jAN0B US0048 2025-11-15T14:25:02.512Z 2025-11-22T15:23:44.671Z
8459994 8459994 20251114052608_j12Q8 US0048 2025-11-15T14:21:12.901Z 2025-11-22T15:22:21.281Z
8459775 8459775 20251114044355_NPWBo US0048 2025-11-15T14:20:35.754Z 2025-11-22T15:22:12.243Z
8452398 8452398 20251113062607_nf8nb US0048 2025-11-14T14:28:31.519Z 2025-11-21T15:13:00.504Z
8452212 8452212 20251113111801_pnCEX US0048 2025-11-14T14:27:44.084Z 2025-11-21T15:13:43.875Z
8451226 8451226 20251113071840_iJhLE US0048 2025-11-14T14:25:13.006Z 2025-11-21T15:13:04.043Z
8450138 8450138 20251113034939_tWmBI US0048 2025-11-14T14:22:34.101Z 2025-11-21T15:12:28.872Z
8441355 8441355 20251112100758_PkFYS US0048 2025-11-13T14:30:44.646Z 2025-11-20T15:26:12.308Z
8441065 8441065 20251112084736_mwfrV US0048 2025-11-13T14:30:05.592Z 2025-11-20T15:26:03.729Z
8440733 8440733 20251112073104_6mtrr US0048 2025-11-13T14:29:18.077Z 2025-11-20T15:25:57.566Z
8438349 8438349 20251112014754_TWxs2 US0048 2025-11-13T14:23:36.531Z 2025-11-20T15:24:29.122Z
8437616 8437616 20251112002746_eEGjN US0048 2025-11-13T14:21:33.595Z 2025-11-20T15:23:48.693Z
8428932 8428932 20251111075201_Xbzk4 US0048 2025-11-12T14:42:47.168Z 2025-11-19T15:18:24.368Z
8428481 8428481 20251111065757_CjlEr US0048 2025-11-12T14:30:44.284Z 2025-11-19T15:18:19.697Z
8416677 8416677 20251110095353_3S3Uv US0048 2025-11-11T14:26:25.249Z 2025-11-18T15:21:48.607Z
8386367 8386367 20251106035558_7ulU3 US0048 2025-11-07T14:10:51.152Z 2025-11-14T15:08:42.141Z
8373000 8373000 20251104111018_qALFG US0048 2025-11-05T14:19:49.347Z 2025-11-12T15:12:08.719Z
8372989 8372989 20251104110906_44svW US0048 2025-11-05T14:19:47.513Z 2025-11-12T15:12:07.154Z
8345739 8345739 20251101071741_2G68C US0048 2025-11-02T14:43:22.683Z 2025-11-09T15:04:27.291Z
8342901 8342901 20251101005618_vLEcQ US0048 2025-11-02T14:39:11.508Z 2025-11-09T15:00:50.493Z
8338206 8338206 20251031082139_SOCUI US0048 2025-11-02T14:31:56.956Z 2025-11-08T15:16:35.016Z
8337282 8337282 20251031062039_1IDB8 US0048 2025-11-02T14:30:50.670Z 2025-11-08T15:16:21.077Z
8246804 8246804 20251025105538_XeBa4 US0048 2025-10-27T12:41:49.023Z 2025-11-02T15:05:51.528Z
8226098 8226098 20251024090042_Q0lPM US0048 2025-10-26T12:44:34.976Z 2025-11-01T13:11:24.039Z
8225441 8225441 20251024080533_bOPn3 US0048 2025-10-26T12:43:16.944Z 2025-11-01T13:11:21.913Z
8224535 8224535 20251024064853_qYTyg US0048 2025-10-26T12:41:59.894Z 2025-11-01T13:11:19.468Z
8224400 8224400 20251024063542_gdwve US0048 2025-10-26T12:41:42.045Z 2025-11-01T13:11:19.146Z
8204308 8204308 20251023103155_NY4CJ US0048 2025-10-25T12:27:12.747Z 2025-10-31T13:09:06.316Z
8203401 8203401 20251023090044_cwOEg US0048 2025-10-25T12:24:28.814Z 2025-10-31T13:08:59.783Z
8202846 8202846 20251023074315_16Dh2 US0048 2025-10-25T12:22:36.183Z 2025-10-31T13:08:57.745Z
8202412 8202412 20251023063334_prr8c US0048 2025-10-25T12:21:07.667Z 2025-10-31T13:08:55.191Z
8197331 8197331 20251022105253_r9PxY US0048 2025-10-24T12:36:05.261Z 2025-10-30T13:13:53.734Z
8195757 8195757 20251022080910_bkmY3 US0048 2025-10-24T12:32:26.706Z 2025-10-30T13:13:43.569Z
8185745 8185745 20251021100756_uZH22 US0048 2025-10-23T12:36:27.603Z 2025-10-29T13:08:12.111Z
8185249 8185249 20251021093940_XJmKs US0048 2025-10-23T12:36:10.619Z 2025-10-29T13:08:04.646Z
8183728 8183728 20251021075140_33ZvR US0048 2025-10-23T12:33:09.270Z 2025-10-29T13:07:51.590Z
8183119 8183119 20251021065411_RTLpA US0048 2025-10-23T12:31:49.923Z 2025-10-29T13:07:48.716Z
8182364 8182364 20251021052055_m3KG5 US0048 2025-10-23T12:30:17.075Z 2025-10-29T13:07:43.484Z
8170889 8170889 20251020082207_y1aXC US0048 2025-10-22T12:40:33.017Z 2025-10-28T13:09:10.114Z
8170525 8170525 20251020075720_nygcn US0048 2025-10-22T12:39:50.684Z 2025-10-28T13:09:08.232Z
8169645 8169645 20251020063803_LoBzU US0048 2025-10-22T12:38:29.456Z 2025-10-28T13:09:02.248Z
8167333 8167333 20251020021406_2U17X US0048 2025-10-22T12:33:12.006Z 2025-10-28T13:08:36.246Z
8163656 8163656 20251021023937_lQH5F US0048 2025-10-22T12:18:38.661Z 2025-10-22T12:45:00.116Z
8137114 8137114 20251018091736_VFaog US0048 2025-10-19T12:20:47.049Z 2025-10-26T13:16:20.912Z
8137084 8137084 20251018091547_Cza27 US0048 2025-10-19T12:20:44.067Z 2025-10-26T13:16:20.792Z
8135848 8135848 20251018073208_YPnCq US0048 2025-10-19T12:18:32.831Z 2025-10-26T13:16:09.883Z
8107315 8107315 20251015100104_mMWi2 US0048 2025-10-16T12:24:39.781Z 2025-10-23T13:09:19.913Z
8106900 8106900 20251015091137_4768C US0048 2025-10-16T12:23:44.013Z 2025-10-23T13:09:16.055Z
8106890 8106890 20251015091040_02oQX US0048 2025-10-16T12:23:43.464Z 2025-10-23T13:09:16.004Z
8104715 8104715 20251015024416_rv4Rw US0048 2025-10-16T12:17:02.811Z 2025-10-23T13:08:52.713Z
8100587 8100587 20251014103613_XqIJL US0048 2025-10-15T12:22:26.003Z 2025-10-22T13:10:31.951Z
8100366 8100366 20251014095632_yOe4Z US0048 2025-10-15T12:21:36.316Z 2025-10-22T13:10:28.644Z
8099745 8099745 20251014065844_NYCHC US0048 2025-10-15T12:19:44.758Z 2025-10-22T13:10:17.512Z
8099421 8099421 20251014041959_qClTE US0048 2025-10-15T12:18:50.376Z 2025-10-22T13:10:09.042Z
8093900 8093900 20251013102928_amJOR US0048 2025-10-14T12:14:40.412Z 2025-10-21T13:09:54.846Z
8093792 8093792 20251013085328_TFG59 US0048 2025-10-14T12:14:31.194Z 2025-10-21T13:09:53.643Z
8093714 8093714 20251013075057_0qlCc US0048 2025-10-14T12:14:08.875Z 2025-10-21T13:09:51.653Z
8093456 8093456 20251013045139_b1APa US0048 2025-10-14T12:13:28.542Z 2025-10-21T13:09:48.471Z
8088435 8088435 20251012071818_btSW4 US0048 2025-10-13T12:13:50.091Z 2025-10-20T13:04:00.852Z
8088406 8088406 20251012070721_bH8p2 US0048 2025-10-13T12:13:34.685Z 2025-10-20T13:04:00.655Z
8088351 8088351 20251012064952_b8eqD US0048 2025-10-13T12:13:17.265Z 2025-10-20T13:04:00.334Z
8088317 8088317 20251012064221_tCVGT US0048 2025-10-13T12:13:12.438Z 2025-10-20T13:04:00.061Z
8088213 8088213 20251012054612_GM6fS US0048 2025-10-13T12:13:03.846Z 2025-10-20T13:03:56.440Z
8083303 8083303 20251011074306_I9ym9 US0048 2025-10-12T12:09:59.821Z 2025-10-19T12:50:10.583Z
8083167 8083167 20251011051107_9bSsp US0048 2025-10-12T12:09:43.991Z 2025-10-19T12:50:09.303Z
8075866 8075866 20251009045540_n1NtD US0048 2025-10-10T12:10:36.255Z 2025-10-17T12:38:00.574Z
8041534 8041534 20251002020906_PH72n US0048 2025-10-03T12:36:31.519Z 2025-10-10T12:41:09.522Z
8041199 8041199 20251002015014_Jq7Mc US0048 2025-10-03T12:36:13.668Z 2025-10-10T12:40:56.388Z
8031766 8031766 20251001044850_bVIK2 US0048 2025-10-02T12:48:00.900Z 2025-10-09T12:39:45.380Z
7998771 7998771 20250929085712_7tqep US0048 2025-09-30T12:05:00.098Z 2025-10-08T12:41:26.037Z
7998554 7998554 20250929081518_rUXYa US0048 2025-09-30T12:04:02.499Z 2025-10-08T12:41:16.855Z
7990565 7990565 20250928100622_gtjwt US0048 2025-09-29T12:02:34.563Z 2025-10-07T12:59:27.374Z
7990525 7990525 20250928092936_cuxFk US0048 2025-09-29T12:02:23.496Z 2025-10-07T12:59:26.245Z
7899023 7899023 20250921083101_hF9Op US0048 2025-09-22T12:08:07.216Z 2025-09-30T13:01:39.408Z
7898997 7898997 20250921074152_xTKpk US0048 2025-09-22T12:07:59.868Z 2025-09-30T13:01:36.278Z
7800296 7800296 20250910024505_64Fem US0048 2025-09-11T12:08:09.967Z 2025-09-18T12:59:32.359Z
7800232 7800232 20250910022924_bRtew US0048 2025-09-11T12:07:48.131Z 2025-09-18T12:59:32.115Z
7800139 7800139 20250910020900_mc9F3 US0048 2025-09-11T12:07:29.318Z 2025-09-18T12:59:30.697Z

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