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

4,786 rows where station_code = "US003M" 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
9612312 9612312 20260406093850_jNlk0 US003M 2026-04-07T12:01:27.598Z 2026-04-07T12:01:27.598Z
9612222 9612222 20260406084539_Q2qqq US003M 2026-04-07T12:01:07.619Z 2026-04-07T12:01:07.619Z
9609375 9609375 20260405051712_NHvh3 US003M 2026-04-06T12:01:30.906Z 2026-04-07T12:13:18.918Z
9609029 9609029 20260404030629_LPvcR US003M 2026-04-05T12:12:42.420Z 2026-04-07T12:18:36.890Z
9607060 9607060 20260404032156_XbMVe US003M 2026-04-05T12:00:17.177Z 2026-04-07T12:13:31.072Z
9593221 9593221 20260329080624_TlTsS US003M 2026-03-30T12:03:18.405Z 2026-04-07T12:27:04.703Z
9593069 9593069 20260329050340_fFlTi US003M 2026-03-30T12:02:50.117Z 2026-04-07T12:27:00.643Z
9592529 9592529 20260329022331_Q2eFV US003M 2026-03-30T12:01:12.841Z 2026-04-07T12:26:34.245Z
9590468 9590468 20260328092038_kn0la US003M 2026-03-29T12:02:43.106Z 2026-04-06T12:38:11.128Z
9590441 9590441 20260328091328_M2WNe US003M 2026-03-29T12:02:40.570Z 2026-04-06T12:38:09.883Z
9590400 9590400 20260328085458_9DdxC US003M 2026-03-29T12:02:34.160Z 2026-04-06T12:38:05.858Z
9590156 9590156 20260328071623_wSjd1 US003M 2026-03-29T12:02:07.842Z 2026-04-06T12:37:53.962Z
9582867 9582867 20260326095305_aZHXo US003M 2026-03-27T12:07:03.817Z 2026-04-04T12:40:33.758Z
9582742 9582742 20260326091819_glKlc US003M 2026-03-27T12:06:39.336Z 2026-04-04T12:40:26.625Z
9577499 9577499 20260325064821_ckWVm US003M 2026-03-26T12:05:17.779Z 2026-04-03T12:37:03.918Z
9577390 9577390 20260325053909_B8djr US003M 2026-03-26T12:05:00.347Z 2026-04-03T12:37:00.031Z
9572704 9572704 20260324095648_8BoY4 US003M 2026-03-25T12:06:03.259Z 2026-04-02T12:35:35.230Z
9572659 9572659 20260324094448_mP5Zx US003M 2026-03-25T12:05:52.759Z 2026-04-02T12:35:33.126Z
9572527 9572527 20260324092301_Vaj53 US003M 2026-03-25T12:05:28.242Z 2026-04-02T12:35:28.701Z
9572501 9572501 20260324091557_h6jnr US003M 2026-03-25T12:05:22.425Z 2026-04-02T12:35:27.274Z
9572445 9572445 20260324090413_GG12J US003M 2026-03-25T12:05:11.153Z 2026-04-02T12:35:25.049Z
9572213 9572213 20260324080503_SJ2DK US003M 2026-03-25T12:04:15.784Z 2026-04-02T12:35:07.970Z
9572025 9572025 20260324070440_YamRK US003M 2026-03-25T12:03:32.803Z 2026-04-02T12:34:59.946Z
9571861 9571861 20260324052232_Rr2Hr US003M 2026-03-25T12:03:01.032Z 2026-04-02T12:34:52.742Z
9555603 9555603 20260322070001_RJU3r US003M 2026-03-23T12:03:41.015Z 2026-03-30T12:28:30.429Z
9545122 9545122 20260321100354_Kldb9 US003M 2026-03-22T12:08:37.553Z 2026-03-29T12:19:37.123Z
9544993 9544993 20260321094905_TOkrr US003M 2026-03-22T12:08:21.287Z 2026-03-29T12:19:36.025Z
9544594 9544594 20260321085847_AELwx US003M 2026-03-22T12:07:14.060Z 2026-03-29T12:19:31.482Z
9536401 9536401 20260320094512_8OKT4 US003M 2026-03-21T12:13:20.261Z 2026-03-22T12:27:41.292Z
9535839 9535839 20260320083623_HIHdJ US003M 2026-03-21T12:11:59.844Z 2026-03-28T12:34:52.136Z
9535388 9535388 20260320072101_ZBl3x US003M 2026-03-21T12:10:36.644Z 2026-03-28T12:34:34.113Z
9535305 9535305 20260320065922_Cdc4S US003M 2026-03-21T12:10:20.189Z 2026-03-28T12:34:32.560Z
9535029 9535029 20260320051407_95ic2 US003M 2026-03-21T12:09:31.801Z 2026-03-28T12:34:25.965Z
9532918 9532918 20260320013817_v0i5P US003M 2026-03-21T12:03:58.270Z 2026-03-28T12:33:46.362Z
9513057 9513057 20260318082713_DjaOY US003M 2026-03-19T12:14:15.009Z 2026-03-26T12:37:51.171Z
9513025 9513025 20260318082211_xd849 US003M 2026-03-19T12:14:12.213Z 2026-03-26T12:37:51.033Z
9512772 9512772 20260318074644_O5Kka US003M 2026-03-19T12:13:33.004Z 2026-03-26T12:37:48.847Z
9512714 9512714 20260318073908_NRSBI US003M 2026-03-19T12:13:24.204Z 2026-03-26T12:37:48.298Z
9512666 9512666 20260318072825_eQp3T US003M 2026-03-19T12:13:13.826Z 2026-03-26T12:37:47.826Z
9512572 9512572 20260318070842_zW48f US003M 2026-03-19T12:13:00.389Z 2026-03-26T12:37:46.879Z
9512487 9512487 20260318063506_ev3k2 US003M 2026-03-19T12:12:42.486Z 2026-03-26T12:37:45.947Z
9510907 9510907 20260318032243_mVig5 US003M 2026-03-19T12:08:57.448Z 2026-03-26T12:37:17.709Z
9487280 9487280 20260315094522_KsYrx US003M 2026-03-16T12:12:21.271Z 2026-03-23T12:22:13.305Z
9486107 9486107 20260315045211_Rlikv US003M 2026-03-16T12:08:41.454Z 2026-03-23T12:21:55.378Z
9479024 9479024 20260314103646_oZK4X US003M 2026-03-15T12:12:34.976Z 2026-03-22T12:42:12.925Z
9478741 9478741 20260314095827_ffMQv US003M 2026-03-15T12:11:53.015Z 2026-03-22T12:42:11.614Z
9478704 9478704 20260314095359_Gueon US003M 2026-03-15T12:11:46.959Z 2026-03-22T12:42:11.322Z
9478278 9478278 20260314090003_P4EpF US003M 2026-03-15T12:10:41.955Z 2026-03-22T12:42:09.392Z
9478160 9478160 20260314083725_BHGCQ US003M 2026-03-15T12:10:23.576Z 2026-03-22T12:42:08.778Z
9478058 9478058 20260314081344_CXZi9 US003M 2026-03-15T12:10:07.070Z 2026-03-22T12:42:08.220Z
9478051 9478051 20260314081232_Yyosx US003M 2026-03-15T12:10:03.974Z 2026-03-22T12:42:08.211Z
9477982 9477982 20260314075421_3VUgy US003M 2026-03-15T12:09:51.172Z 2026-03-22T12:42:06.896Z
9477946 9477946 20260314074558_4naZH US003M 2026-03-15T12:09:44.493Z 2026-03-22T12:42:06.600Z
9477860 9477860 20260314071042_QJoms US003M 2026-03-15T12:09:25.912Z 2026-03-22T12:42:05.971Z
9477775 9477775 20260314063905_109K2 US003M 2026-03-15T12:09:06.094Z 2026-03-22T12:42:05.159Z
9477685 9477685 20260314055456_5mLuA US003M 2026-03-15T12:08:50.454Z 2026-03-22T12:42:04.563Z
9471368 9471368 20260313100305_oCtG0 US003M 2026-03-14T12:10:10.062Z 2026-03-21T12:49:20.779Z
9471275 9471275 20260313093807_vgGut US003M 2026-03-14T12:09:54.818Z 2026-03-21T12:49:19.472Z
9470873 9470873 20260313080620_3mZ3W US003M 2026-03-14T12:08:42.196Z 2026-03-21T12:49:14.964Z
9470696 9470696 20260313072354_Jm92F US003M 2026-03-14T12:08:08.566Z 2026-03-21T12:49:12.078Z
9458473 9458473 20260311095745_xYDth US003M 2026-03-12T12:06:14.806Z 2026-03-19T12:44:59.025Z
9457841 9457841 20260311062046_ed0al US003M 2026-03-12T12:04:46.000Z 2026-03-19T12:44:52.902Z
9452061 9452061 20260310065531_yhXEe US003M 2026-03-11T12:04:36.883Z 2026-03-18T12:39:09.079Z
9452016 9452016 20260310060400_Kw6aN US003M 2026-03-11T12:04:27.204Z 2026-03-18T12:39:08.393Z
9452014 9452014 20260310055503_BZaCF US003M 2026-03-11T12:04:26.804Z 2026-03-18T12:39:08.363Z
9451896 9451896 20260310044639_4sXrQ US003M 2026-03-11T12:04:10.529Z 2026-03-18T12:39:06.569Z
9451813 9451813 20260310040016_2P6nb US003M 2026-03-11T12:03:54.658Z 2026-03-18T12:39:04.996Z
9451739 9451739 20260310033329_1I4ke US003M 2026-03-11T12:03:42.221Z 2026-03-18T12:39:03.670Z
9451714 9451714 20260310033004_lLEUO US003M 2026-03-11T12:03:38.986Z 2026-03-18T12:39:03.270Z
9451533 9451533 20260310023818_YGqXn US003M 2026-03-11T12:03:06.031Z 2026-03-18T12:38:47.993Z
9451477 9451477 20260310022027_h6mg5 US003M 2026-03-11T12:02:54.410Z 2026-03-18T12:38:47.051Z
9447954 9447954 20260309092730_h9qr1 US003M 2026-03-10T12:08:25.669Z 2026-03-17T12:41:58.611Z
9447930 9447930 20260309091958_gtUVe US003M 2026-03-10T12:08:18.941Z 2026-03-17T12:41:58.373Z
9447185 9447185 20260309054505_yhdKh US003M 2026-03-10T12:05:29.035Z 2026-03-17T12:41:48.664Z
9446834 9446834 20260309031201_sQ4kP US003M 2026-03-10T12:04:07.014Z 2026-03-17T12:41:43.662Z
9446564 9446564 20260309021154_b8NUR US003M 2026-03-10T12:02:56.764Z 2026-03-17T12:41:39.724Z
9446557 9446557 20260309021050_Keh6q US003M 2026-03-10T12:02:54.650Z 2026-03-17T12:41:39.596Z
9446339 9446339 20260309010719_me0U7 US003M 2026-03-10T12:02:01.941Z 2026-03-17T12:41:36.652Z
9416455 9416455 20260302105032_TQCKQ US003M 2026-03-03T14:03:45.759Z 2026-03-10T12:36:13.258Z
9415627 9415627 20260302022946_WKmCH US003M 2026-03-03T14:00:56.772Z 2026-03-10T12:35:45.931Z
9415505 9415505 20260302000104_r73YH US003M 2026-03-03T14:00:26.888Z 2026-03-10T12:35:42.958Z
9412608 9412608 20260301042036_R3UhR US003M 2026-03-02T14:01:45.166Z 2026-03-09T12:39:44.764Z
9412543 9412543 20260301040649_NXvOd US003M 2026-03-02T14:01:37.760Z 2026-03-09T12:39:42.551Z
9412346 9412346 20260301030115_VktFS US003M 2026-03-02T14:01:10.852Z 2026-03-09T12:39:35.627Z
9410363 9410363 20260228105803_20F5h US003M 2026-03-01T14:03:24.483Z 2026-03-08T12:41:59.854Z
9410266 9410266 20260228101503_Bfgen US003M 2026-03-01T14:03:14.788Z 2026-03-08T12:41:56.565Z
9410100 9410100 20260228090643_3ccrU US003M 2026-03-01T14:02:55.775Z 2026-03-08T12:41:51.173Z
9409992 9409992 20260228082106_M3wrM US003M 2026-03-01T14:02:42.084Z 2026-03-08T12:41:47.639Z
9409807 9409807 20260228052813_D2710 US003M 2026-03-01T14:02:16.809Z 2026-03-08T12:41:32.398Z
9409471 9409471 20260228032636_MehI0 US003M 2026-03-01T14:01:32.729Z 2026-03-08T12:41:18.642Z
9403713 9403713 20260227103614_x0wIc US003M 2026-02-28T14:09:01.755Z 2026-03-07T14:48:10.629Z
9403392 9403392 20260227093334_2mDOg US003M 2026-02-28T14:08:07.911Z 2026-03-07T14:47:50.020Z
9403252 9403252 20260227085113_2v1Kn US003M 2026-02-28T14:07:40.717Z 2026-03-07T14:47:43.322Z
9403124 9403124 20260227080858_qBR7I US003M 2026-02-28T14:07:16.600Z 2026-03-07T14:47:32.213Z
9402724 9402724 20260227042702_TVaha US003M 2026-02-28T14:05:49.876Z 2026-03-07T14:47:01.365Z
9399502 9399502 20260226080058_FSULT US003M 2026-02-27T14:08:00.816Z 2026-03-06T14:44:21.253Z
9399420 9399420 20260226071823_MJpbm US003M 2026-02-27T14:07:46.563Z 2026-03-06T14:44:18.984Z
9399398 9399398 20260226065659_m42rj US003M 2026-02-27T14:07:43.347Z 2026-03-06T14:44:18.367Z
9384019 9384019 20260224095759_Pv5ua US003M 2026-02-25T14:04:16.055Z 2026-03-04T14:17:59.595Z
9231834 9231834 20260119100137_gDfK2 US003M 2026-01-20T14:34:29.149Z 2026-01-27T15:07:01.658Z

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