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

60 rows where station_code = "US0070" 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
9611689 9611689 20260405031449_IyUaP US0070 2026-04-06T12:15:45.169Z 2026-04-06T12:16:14.848Z
9609552 9609552 20260405080720_U9jAH US0070 2026-04-06T12:02:30.764Z 2026-04-06T12:02:30.764Z
9595804 9595804 20260330084820_6nbk8 US0070 2026-03-31T12:02:33.360Z 2026-04-06T12:30:34.174Z
9587114 9587114 20260327111612_uM0XX US0070 2026-03-28T12:04:47.613Z 2026-04-05T12:34:02.136Z
9586740 9586740 20260327092152_z2d2R US0070 2026-03-28T12:03:53.794Z 2026-04-05T12:33:43.364Z
9586668 9586668 20260327090138_KPsrl US0070 2026-03-28T12:03:43.440Z 2026-04-05T12:33:36.765Z
9586663 9586663 20260327090118_zcuEG US0070 2026-03-28T12:03:42.586Z 2026-04-05T12:33:36.418Z
9586604 9586604 20260327083703_XnPhY US0070 2026-03-28T12:03:32.124Z 2026-04-05T12:33:32.365Z
9583045 9583045 20260326104051_LCjWn US0070 2026-03-27T12:07:29.976Z 2026-04-04T12:40:42.983Z
9582714 9582714 20260326091012_01seP US0070 2026-03-27T12:06:34.992Z 2026-04-04T12:40:25.010Z
9582651 9582651 20260326085451_NlgLM US0070 2026-03-27T12:06:26.606Z 2026-04-04T12:40:17.285Z
9582490 9582490 20260326080052_kHDtd US0070 2026-03-27T12:05:57.353Z 2026-04-04T12:40:04.170Z
9582465 9582465 20260326074736_OrNa3 US0070 2026-03-27T12:05:52.849Z 2026-04-04T12:40:02.502Z
9582461 9582461 20260326074500_Vcw4H US0070 2026-03-27T12:05:51.968Z 2026-04-04T12:40:02.368Z
9582425 9582425 20260326072427_p4o8J US0070 2026-03-27T12:05:44.552Z 2026-04-04T12:40:00.608Z
9582233 9582233 20260326053209_Px3en US0070 2026-03-27T12:05:02.406Z 2026-04-04T12:39:43.653Z
9582221 9582221 20260326052408_wQw9j US0070 2026-03-27T12:04:59.702Z 2026-04-04T12:39:42.825Z
9582180 9582180 20260326044914_rvFai US0070 2026-03-27T12:04:49.770Z 2026-04-04T12:39:40.432Z
9564626 9564626 20260323105639_g9nb2 US0070 2026-03-24T12:08:29.409Z 2026-03-31T12:27:12.788Z
9556663 9556663 20260322111710_eau2p US0070 2026-03-23T12:05:05.414Z 2026-03-30T12:29:07.416Z
9556366 9556366 20260322101553_6ZnNi US0070 2026-03-23T12:04:42.692Z 2026-03-30T12:28:58.751Z
9555967 9555967 20260322085444_J0EmG US0070 2026-03-23T12:04:12.829Z 2026-03-30T12:28:40.526Z
9555953 9555953 20260322084936_KwAJ0 US0070 2026-03-23T12:04:11.644Z 2026-03-30T12:28:40.165Z
9555944 9555944 20260322084702_DAJ8N US0070 2026-03-23T12:04:10.761Z 2026-03-30T12:28:39.906Z
9555938 9555938 20260322084535_ffCmx US0070 2026-03-23T12:04:09.949Z 2026-03-30T12:28:39.650Z
9555896 9555896 20260322083257_W0bcJ US0070 2026-03-23T12:04:06.796Z 2026-03-30T12:28:38.508Z
9555760 9555760 20260322075047_mI592 US0070 2026-03-23T12:03:52.439Z 2026-03-30T12:28:34.106Z
9555589 9555589 20260322065341_Li3NF US0070 2026-03-23T12:03:39.869Z 2026-03-30T12:28:30.156Z
9555561 9555561 20260322063810_TkXbE US0070 2026-03-23T12:03:37.710Z 2026-03-30T12:28:29.477Z
9555505 9555505 20260322055605_g4pQ4 US0070 2026-03-23T12:03:30.764Z 2026-03-30T12:28:27.834Z
9553907 9553907 20260322022422_HSw2h US0070 2026-03-23T12:01:59.210Z 2026-03-30T12:27:54.767Z
9545801 9545801 20260321110758_DVhnh US0070 2026-03-22T12:10:17.698Z 2026-03-29T12:19:44.481Z
9544717 9544717 20260321091343_mbs0u US0070 2026-03-22T12:07:34.551Z 2026-03-29T12:19:32.935Z
9544526 9544526 20260321085047_byKrP US0070 2026-03-22T12:07:05.558Z 2026-03-29T12:19:30.839Z
9543836 9543836 20260321054541_EgkAN US0070 2026-03-22T12:04:54.238Z 2026-03-29T12:19:12.973Z
9543776 9543776 20260321052112_aPXvL US0070 2026-03-22T12:04:43.676Z 2026-03-29T12:19:11.167Z
9542952 9542952 20260321020352_ijd2E US0070 2026-03-22T12:02:11.211Z 2026-03-29T12:19:00.740Z
9537343 9537343 20260320113201_ZD8V7 US0070 2026-03-21T12:15:34.982Z 2026-03-28T12:35:25.112Z
9537250 9537250 20260320111938_kbzT9 US0070 2026-03-21T12:15:23.892Z 2026-03-28T12:35:23.856Z
9536648 9536648 20260320101215_rWBTn US0070 2026-03-21T12:14:00.590Z 2026-03-28T12:35:04.870Z
9536489 9536489 20260320095701_geQjg US0070 2026-03-21T12:13:37.054Z 2026-03-28T12:35:02.624Z
9536473 9536473 20260320095449_dYxs7 US0070 2026-03-21T12:13:34.594Z 2026-03-28T12:35:02.444Z
9536448 9536448 20260320095233_XS9lX US0070 2026-03-21T12:13:30.230Z 2026-03-28T12:35:01.986Z
9535972 9535972 20260320085553_MZd4y US0070 2026-03-21T12:12:16.457Z 2026-03-28T12:34:54.734Z
9535739 9535739 20260320082822_vFsHF US0070 2026-03-21T12:11:44.124Z 2026-03-28T12:34:50.304Z
9523506 9523506 20260319101411_pedql US0070 2026-03-20T12:11:32.265Z 2026-03-27T12:41:29.621Z
9523497 9523497 20260319101349_xjo5x US0070 2026-03-20T12:11:31.583Z 2026-03-27T12:41:29.544Z
9523154 9523154 20260319093257_SguEU US0070 2026-03-20T12:10:58.320Z 2026-03-27T12:41:25.526Z
9523132 9523132 20260319092928_qAkEg US0070 2026-03-20T12:10:55.025Z 2026-03-27T12:41:25.296Z
9522654 9522654 20260319083607_DW9Ph US0070 2026-03-20T12:10:11.205Z 2026-03-27T12:41:20.533Z
9522403 9522403 20260319074340_Oi3dy US0070 2026-03-20T12:09:45.186Z 2026-03-27T12:41:17.878Z
9522384 9522384 20260319073725_RvKKF US0070 2026-03-20T12:09:42.023Z 2026-03-27T12:41:17.407Z
9522291 9522291 20260319071815_QDxP1 US0070 2026-03-20T12:09:30.243Z 2026-03-27T12:41:16.338Z
9512479 9512479 20260318062937_XyY1S US0070 2026-03-19T12:12:40.778Z 2026-03-26T12:37:45.893Z
9511153 9511153 20260318033810_f8nbY US0070 2026-03-19T12:09:34.492Z 2026-03-26T12:37:25.308Z
9478649 9478649 20260314094809_rOUZ7 US0070 2026-03-15T12:11:37.714Z 2026-03-22T12:42:11.033Z
9478607 9478607 20260314094122_aOybB US0070 2026-03-15T12:11:30.874Z 2026-03-22T12:42:10.881Z
9477975 9477975 20260314075316_2U9ER US0070 2026-03-15T12:09:49.425Z 2026-03-22T12:42:06.834Z
9477727 9477727 20260314061545_0quP4 US0070 2026-03-15T12:08:55.990Z 2026-03-22T12:42:04.732Z
9477323 9477323 20260314044206_mekzr US0070 2026-03-15T12:08:03.936Z 2026-03-22T12:42:02.225Z

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