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

8,522 rows where station_code = "US004Q" 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
9609678 9609678 20260405090451_eSlWU US004Q 2026-04-06T12:03:17.433Z 2026-04-06T12:03:17.433Z
9609670 9609670 20260405090303_k71xM US004Q 2026-04-06T12:03:11.752Z 2026-04-06T12:03:11.752Z
9609550 9609550 20260405080658_fcuoh US004Q 2026-04-06T12:02:29.885Z 2026-04-06T12:02:29.885Z
9599037 9599037 20260331110748_mw7Sk US004Q 2026-04-01T12:02:08.597Z 2026-04-06T12:27:21.754Z
9599035 9599035 20260331110333_o7P1U US004Q 2026-04-01T12:02:07.922Z 2026-04-06T12:27:21.623Z
9598884 9598884 20260331082551_yWtj8 US004Q 2026-04-01T12:01:25.472Z 2026-04-06T12:27:04.613Z
9598804 9598804 20260331073231_hqD21 US004Q 2026-04-01T12:01:09.137Z 2026-04-06T12:27:00.068Z
9598783 9598783 20260331062355_PFXoH US004Q 2026-04-01T12:01:02.987Z 2026-04-06T12:26:58.718Z
9598778 9598778 20260331061028_RirFt US004Q 2026-04-01T12:01:01.677Z 2026-04-06T12:26:58.378Z
9598776 9598776 20260331060717_ABu6P US004Q 2026-04-01T12:01:00.902Z 2026-04-06T12:26:58.205Z
9596114 9596114 20260330111513_udxtO US004Q 2026-03-31T12:03:30.459Z 2026-04-06T12:30:58.744Z
9596068 9596068 20260330105831_MQIln US004Q 2026-03-31T12:03:19.616Z 2026-04-06T12:30:50.722Z
9596064 9596064 20260330105759_I5Jk8 US004Q 2026-03-31T12:03:17.801Z 2026-04-06T12:30:50.414Z
9596062 9596062 20260330105755_xb23X US004Q 2026-03-31T12:03:17.352Z 2026-04-06T12:30:50.237Z
9595915 9595915 20260330100316_pRfyi US004Q 2026-03-31T12:02:49.906Z 2026-04-06T12:30:40.582Z
9595848 9595848 20260330092348_Ss45I US004Q 2026-03-31T12:02:41.759Z 2026-04-06T12:30:37.498Z
9595826 9595826 20260330090845_223uB US004Q 2026-03-31T12:02:38.038Z 2026-04-06T12:30:35.812Z
9595787 9595787 20260330083928_5LQeJ US004Q 2026-03-31T12:02:30.351Z 2026-04-06T12:30:33.069Z
9595612 9595612 20260330071247_TWBg2 US004Q 2026-03-31T12:01:54.685Z 2026-04-06T12:30:13.445Z
9595568 9595568 20260330060800_saj28 US004Q 2026-03-31T12:01:46.923Z 2026-04-06T12:30:10.349Z
9595132 9595132 20260330023101_l5nIH US004Q 2026-03-31T12:00:32.987Z 2026-04-06T12:29:41.779Z
9593309 9593309 20260329085943_Wynfb US004Q 2026-03-30T12:03:32.563Z 2026-04-06T12:35:02.618Z
9587090 9587090 20260327110841_S1peV US004Q 2026-03-28T12:04:45.123Z 2026-04-05T12:34:01.396Z
9587052 9587052 20260327105933_PbCL2 US004Q 2026-03-28T12:04:41.617Z 2026-04-05T12:34:00.267Z
9586963 9586963 20260327103243_rxEe7 US004Q 2026-03-28T12:04:27.858Z 2026-04-05T12:33:56.315Z
9586836 9586836 20260327095549_40VBU US004Q 2026-03-28T12:04:11.610Z 2026-04-05T12:33:51.221Z
9586828 9586828 20260327095109_eCP3o US004Q 2026-03-28T12:04:08.153Z 2026-04-05T12:33:50.628Z
9586705 9586705 20260327091622_Iv5cY US004Q 2026-03-28T12:03:48.409Z 2026-04-05T12:33:38.389Z
9586674 9586674 20260327090522_OD5Cx US004Q 2026-03-28T12:03:45.047Z 2026-04-05T12:33:37.135Z
9586534 9586534 20260327081259_3BE6a US004Q 2026-03-28T12:03:21.535Z 2026-04-05T12:33:29.578Z
9586277 9586277 20260327054118_1IViP US004Q 2026-03-28T12:02:42.411Z 2026-04-05T12:33:18.695Z
9586201 9586201 20260327045125_xtPYR US004Q 2026-03-28T12:02:30.979Z 2026-04-05T12:33:07.952Z
9585945 9585945 20260327031539_vzT92 US004Q 2026-03-28T12:01:48.174Z 2026-04-05T12:32:54.091Z
9585782 9585782 20260327022950_Gc7Vq US004Q 2026-03-28T12:01:18.580Z 2026-04-05T12:32:45.159Z
9583155 9583155 20260326112439_v0B3F US004Q 2026-03-27T12:07:53.425Z 2026-04-04T12:40:54.173Z
9582655 9582655 20260326085616_3QzXn US004Q 2026-03-27T12:06:27.578Z 2026-04-04T12:40:17.547Z
9582555 9582555 20260326082642_74ZQP US004Q 2026-03-27T12:06:08.676Z 2026-04-04T12:40:09.265Z
9582540 9582540 20260326082102_UrdQM US004Q 2026-03-27T12:06:05.876Z 2026-04-04T12:40:07.919Z
9582525 9582525 20260326081557_G3KD4 US004Q 2026-03-27T12:06:03.199Z 2026-04-04T12:40:06.797Z
9582457 9582457 20260326074222_pgHEE US004Q 2026-03-27T12:05:51.098Z 2026-04-04T12:40:02.064Z
9582440 9582440 20260326072834_4JKjt US004Q 2026-03-27T12:05:45.660Z 2026-04-04T12:40:00.980Z
9582175 9582175 20260326044612_FTs2k US004Q 2026-03-27T12:04:48.662Z 2026-04-04T12:39:40.095Z
9581091 9581091 20260326022120_SHvOn US004Q 2026-03-27T12:02:06.814Z 2026-04-04T12:38:42.382Z
9581065 9581065 20260326021815_F2ZW2 US004Q 2026-03-27T12:02:02.713Z 2026-04-04T12:38:41.265Z
9580983 9580983 20260326020503_M0bkH US004Q 2026-03-27T12:01:49.406Z 2026-04-04T12:38:37.849Z
9577641 9577641 20260325075606_aYgAz US004Q 2026-03-26T12:05:43.750Z 2026-04-03T12:37:11.744Z
9577581 9577581 20260325073351_Cy1oR US004Q 2026-03-26T12:05:34.116Z 2026-04-03T12:37:09.121Z
9577475 9577475 20260325062801_VVjJ4 US004Q 2026-03-26T12:05:14.325Z 2026-04-03T12:37:03.055Z
9577400 9577400 20260325054509_FIQOy US004Q 2026-03-26T12:05:01.459Z 2026-04-03T12:37:00.328Z
9577372 9577372 20260325052246_erjAY US004Q 2026-03-26T12:04:56.741Z 2026-04-03T12:36:59.110Z
9577352 9577352 20260325050613_OOW23 US004Q 2026-03-26T12:04:52.720Z 2026-04-03T12:36:58.044Z
9577243 9577243 20260325042305_Zer4I US004Q 2026-03-26T12:04:31.360Z 2026-04-03T12:36:52.969Z
9577075 9577075 20260325035131_UTwQx US004Q 2026-03-26T12:04:03.682Z 2026-04-03T12:36:33.417Z
9576835 9576835 20260325031517_RN0l9 US004Q 2026-03-26T12:03:26.831Z 2026-04-03T12:36:23.013Z
9564112 9564112 20260323100033_OkElP US004Q 2026-03-24T12:07:27.301Z 2026-03-31T12:27:02.949Z
9563877 9563877 20260323092448_Loyjv US004Q 2026-03-24T12:06:54.584Z 2026-03-31T12:26:58.315Z
9563199 9563199 20260323073457_uQ7jN US004Q 2026-03-24T12:05:27.860Z 2026-03-31T12:26:38.055Z
9563024 9563024 20260323044417_GvP3F US004Q 2026-03-24T12:04:47.434Z 2026-03-31T12:26:32.697Z
9562830 9562830 20260323032123_Pcbyc US004Q 2026-03-24T12:04:11.715Z 2026-03-31T12:26:27.124Z
9556732 9556732 20260322112623_2yNGO US004Q 2026-03-23T12:05:09.637Z 2026-03-30T12:29:09.298Z
9556475 9556475 20260322104031_qw0s5 US004Q 2026-03-23T12:04:50.362Z 2026-03-30T12:29:02.044Z
9556425 9556425 20260322103144_474rp US004Q 2026-03-23T12:04:47.152Z 2026-03-30T12:29:00.654Z
9556411 9556411 20260322102922_3QxGL US004Q 2026-03-23T12:04:46.342Z 2026-03-30T12:29:00.141Z
9556131 9556131 20260322092158_2DyCn US004Q 2026-03-23T12:04:23.049Z 2026-03-30T12:28:45.577Z
9556105 9556105 20260322091933_qZ2at US004Q 2026-03-23T12:04:21.569Z 2026-03-30T12:28:44.976Z
9555968 9555968 20260322085501_8SejU US004Q 2026-03-23T12:04:12.968Z 2026-03-30T12:28:40.626Z
9555913 9555913 20260322083635_YSEn7 US004Q 2026-03-23T12:04:07.800Z 2026-03-30T12:28:38.952Z
9555827 9555827 20260322081327_weMa7 US004Q 2026-03-23T12:03:59.298Z 2026-03-30T12:28:36.527Z
9555815 9555815 20260322081202_Bf4E1 US004Q 2026-03-23T12:03:58.270Z 2026-03-30T12:28:36.282Z
9555788 9555788 20260322075645_vmJgn US004Q 2026-03-23T12:03:54.693Z 2026-03-30T12:28:35.035Z
9555782 9555782 20260322075442_aw1Gp US004Q 2026-03-23T12:03:54.093Z 2026-03-30T12:28:34.814Z
9555729 9555729 20260322074049_7O044 US004Q 2026-03-23T12:03:49.844Z 2026-03-30T12:28:33.322Z
9555639 9555639 20260322071345_BWyHH US004Q 2026-03-23T12:03:43.571Z 2026-03-30T12:28:31.086Z
9555632 9555632 20260322070604_JPS4s US004Q 2026-03-23T12:03:42.792Z 2026-03-30T12:28:30.860Z
9555629 9555629 20260322070456_sIZ8I US004Q 2026-03-23T12:03:42.574Z 2026-03-30T12:28:30.785Z
9555626 9555626 20260322070453_MeDSt US004Q 2026-03-23T12:03:42.350Z 2026-03-30T12:28:30.755Z
9555596 9555596 20260322065606_e7ky4 US004Q 2026-03-23T12:03:40.421Z 2026-03-30T12:28:30.252Z
9555559 9555559 20260322063731_tqE13 US004Q 2026-03-23T12:03:37.521Z 2026-03-30T12:28:29.378Z
9555555 9555555 20260322063639_2TGa4 US004Q 2026-03-23T12:03:37.114Z 2026-03-30T12:28:29.246Z
9555487 9555487 20260322052453_2Ewp3 US004Q 2026-03-23T12:03:29.352Z 2026-03-30T12:28:27.473Z
9555485 9555485 20260322052324_rNkYA US004Q 2026-03-23T12:03:29.224Z 2026-03-30T12:28:27.398Z
9555482 9555482 20260322052246_CUTuB US004Q 2026-03-23T12:03:28.966Z 2026-03-30T12:28:27.313Z
9555481 9555481 20260322051840_ZjWVP US004Q 2026-03-23T12:03:28.818Z 2026-03-30T12:28:27.255Z
9555421 9555421 20260322045537_3UM2X US004Q 2026-03-23T12:03:25.335Z 2026-03-30T12:28:26.376Z
9555209 9555209 20260322042022_LRnf3 US004Q 2026-03-23T12:03:15.473Z 2026-03-30T12:28:22.968Z
9555181 9555181 20260322041459_zYmSS US004Q 2026-03-23T12:03:14.055Z 2026-03-30T12:28:22.569Z
9555044 9555044 20260322035859_9wHUa US004Q 2026-03-23T12:03:06.804Z 2026-03-30T12:28:13.632Z
9553936 9553936 20260322022535_OmsKh US004Q 2026-03-23T12:02:01.574Z 2026-03-30T12:27:55.454Z
9553829 9553829 20260322021826_co93k US004Q 2026-03-23T12:01:54.115Z 2026-03-30T12:27:53.236Z
9553470 9553470 20260322014426_Sckks US004Q 2026-03-23T12:01:32.223Z 2026-03-30T12:27:41.757Z
9545849 9545849 20260321111347_ud10x US004Q 2026-03-22T12:10:24.844Z 2026-03-29T12:19:45.007Z
9545624 9545624 20260321105234_zl8ki US004Q 2026-03-22T12:09:52.402Z 2026-03-29T12:19:41.928Z
9545535 9545535 20260321104519_mTMOs US004Q 2026-03-22T12:09:39.649Z 2026-03-29T12:19:41.104Z
9545455 9545455 20260321103711_4YmpP US004Q 2026-03-22T12:09:27.447Z 2026-03-29T12:19:40.345Z
9545431 9545431 20260321103330_cZr5N US004Q 2026-03-22T12:09:24.569Z 2026-03-29T12:19:40.065Z
9545293 9545293 20260321102032_GWVt2 US004Q 2026-03-22T12:09:04.324Z 2026-03-29T12:19:38.891Z
9545196 9545196 20260321101200_kQhxu US004Q 2026-03-22T12:08:52.606Z 2026-03-29T12:19:37.983Z
9545159 9545159 20260321100737_I5EVY US004Q 2026-03-22T12:08:43.904Z 2026-03-29T12:19:37.493Z
9544957 9544957 20260321094537_uvSgj US004Q 2026-03-22T12:08:14.283Z 2026-03-29T12:19:35.724Z
9544883 9544883 20260321093601_EcwJS US004Q 2026-03-22T12:08:03.375Z 2026-03-29T12:19:34.861Z

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