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

>10,000 rows count all where station_code = "US0005" 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
9609900 9609900 20260405110255_Ndj79 US0005 2026-04-06T12:04:33.545Z 2026-04-06T12:04:33.545Z
9609859 9609859 20260405103932_T4KZ7 US0005 2026-04-06T12:04:21.813Z 2026-04-06T12:04:21.813Z
9609772 9609772 20260405095448_vb1DW US0005 2026-04-06T12:03:49.537Z 2026-04-06T12:03:49.537Z
9609708 9609708 20260405092929_hgM4a US0005 2026-04-06T12:03:26.490Z 2026-04-06T12:03:26.490Z
9609680 9609680 20260405090721_TAtFQ US0005 2026-04-06T12:03:18.280Z 2026-04-06T12:03:18.280Z
9609653 9609653 20260405085957_SRmVQ US0005 2026-04-06T12:03:07.538Z 2026-04-06T12:03:07.538Z
9609626 9609626 20260405084202_9PDae US0005 2026-04-06T12:02:58.049Z 2026-04-06T12:02:58.049Z
9609618 9609618 20260405084100_lXHwI US0005 2026-04-06T12:02:56.443Z 2026-04-06T12:02:56.443Z
9609562 9609562 20260405081135_mB098 US0005 2026-04-06T12:02:34.626Z 2026-04-06T12:02:34.626Z
9609526 9609526 20260405075116_HmBEW US0005 2026-04-06T12:02:21.585Z 2026-04-06T12:02:21.585Z
9609481 9609481 20260405072708_QS8Eu US0005 2026-04-06T12:01:57.779Z 2026-04-06T12:01:57.779Z
9609404 9609404 20260405060428_YfNCz US0005 2026-04-06T12:01:39.955Z 2026-04-06T12:01:39.955Z
9607695 9607695 20260404115523_JjD3N US0005 2026-04-05T12:03:31.478Z 2026-04-06T12:16:14.493Z
9607651 9607651 20260404113219_nhxhA US0005 2026-04-05T12:03:21.127Z 2026-04-06T12:16:14.484Z
9607610 9607610 20260404111541_dc6Oj US0005 2026-04-05T12:03:09.544Z 2026-04-06T12:16:14.474Z
9607601 9607601 20260404111222_ZN3Ej US0005 2026-04-05T12:03:08.703Z 2026-04-06T12:16:14.473Z
9607569 9607569 20260404105946_JzcFX US0005 2026-04-05T12:02:57.495Z 2026-04-06T12:16:14.465Z
9607476 9607476 20260404094540_VKvs0 US0005 2026-04-05T12:02:28.099Z 2026-04-06T12:16:14.446Z
9607430 9607430 20260404090945_UdTB6 US0005 2026-04-05T12:02:15.766Z 2026-04-06T12:16:14.435Z
9607306 9607306 20260404071821_ERfGe US0005 2026-04-05T12:01:31.168Z 2026-04-06T12:16:14.407Z
9607284 9607284 20260404070611_j4iFs US0005 2026-04-05T12:01:25.812Z 2026-04-06T12:16:14.402Z
9607279 9607279 20260404070502_I2Sag US0005 2026-04-05T12:01:24.541Z 2026-04-06T12:16:14.401Z
9607189 9607189 20260404043005_9MssH US0005 2026-04-05T12:00:48.505Z 2026-04-06T12:16:14.380Z
9605723 9605723 20260403114122_78f7b US0005 2026-04-04T12:03:35.910Z 2026-04-06T12:18:15.078Z
9605665 9605665 20260403112342_mXNnJ US0005 2026-04-04T12:03:22.833Z 2026-04-06T12:18:11.166Z
9605595 9605595 20260403105428_As1pM US0005 2026-04-04T12:02:59.946Z 2026-04-06T12:18:06.974Z
9605107 9605107 20260403064543_KK3k5 US0005 2026-04-04T12:00:46.310Z 2026-04-06T12:16:39.804Z
9605097 9605097 20260403063414_twABY US0005 2026-04-04T12:00:44.433Z 2026-04-06T12:16:36.068Z
9605070 9605070 20260403055249_LnEuA US0005 2026-04-04T12:00:36.922Z 2026-04-06T12:16:27.029Z
9605044 9605044 20260403045703_sMyWJ US0005 2026-04-04T12:00:28.179Z 2026-04-06T12:16:24.625Z
9605022 9605022 20260403034301_2kSba US0005 2026-04-04T12:00:20.925Z 2026-04-06T12:16:19.934Z
9605014 9605014 20260403033524_jq52u US0005 2026-04-04T12:00:18.812Z 2026-04-06T12:16:18.469Z
9603646 9603646 20260402113351_lgL24 US0005 2026-04-03T12:03:58.628Z 2026-04-06T12:22:19.482Z
9603030 9603030 20260402064554_CELVR US0005 2026-04-03T12:01:32.022Z 2026-04-06T12:21:29.336Z
9603025 9603025 20260402063215_11hhR US0005 2026-04-03T12:01:31.567Z 2026-04-06T12:21:28.822Z
9603017 9603017 20260402062721_YSTlq US0005 2026-04-03T12:01:30.669Z 2026-04-06T12:21:28.368Z
9602985 9602985 20260402051519_7BJeu US0005 2026-04-03T12:01:25.005Z 2026-04-06T12:21:25.063Z
9598679 9598679 20260331024614_qCIOo US0005 2026-04-01T12:00:30.498Z 2026-04-06T12:26:46.386Z
9596221 9596221 20260330115032_Va93H US0005 2026-03-31T12:03:47.231Z 2026-04-06T12:31:04.376Z
9593604 9593604 20260329120756_tCi96 US0005 2026-03-30T12:04:30.959Z 2026-04-06T12:35:29.860Z
9593543 9593543 20260329114741_Q7qei US0005 2026-03-30T12:04:20.394Z 2026-04-06T12:35:25.275Z
9593532 9593532 20260329114426_1uuN9 US0005 2026-03-30T12:04:17.892Z 2026-04-06T12:35:24.545Z
9593520 9593520 20260329114121_JEXJy US0005 2026-03-30T12:04:15.305Z 2026-04-06T12:35:23.784Z
9593514 9593514 20260329113449_BaPYm US0005 2026-03-30T12:04:13.887Z 2026-04-06T12:35:23.299Z
9593499 9593499 20260329112605_Ab2g2 US0005 2026-03-30T12:04:11.243Z 2026-04-06T12:35:22.328Z
9593445 9593445 20260329104925_XWcHA US0005 2026-03-30T12:03:59.225Z 2026-04-06T12:35:19.264Z
9593439 9593439 20260329104639_qSlAi US0005 2026-03-30T12:03:58.276Z 2026-04-06T12:35:18.910Z
9593425 9593425 20260329103819_5awPj US0005 2026-03-30T12:03:55.290Z 2026-04-06T12:35:18.201Z
9593368 9593368 20260329095128_81tqW US0005 2026-03-30T12:03:44.835Z 2026-04-06T12:35:14.767Z
9593306 9593306 20260329085609_acHEo US0005 2026-03-30T12:03:32.048Z 2026-04-06T12:35:02.506Z
9593291 9593291 20260329085553_ik08q US0005 2026-03-30T12:03:30.524Z 2026-04-06T12:35:02.144Z
9593266 9593266 20260329085158_cd9Ne US0005 2026-03-30T12:03:26.416Z 2026-04-06T12:35:01.049Z
9593254 9593254 20260329083551_mjp2D US0005 2026-03-30T12:03:24.202Z 2026-04-06T12:35:00.180Z
9592999 9592999 20260329041454_LzhPp US0005 2026-03-30T12:02:34.249Z 2026-04-06T12:34:44.592Z
9590897 9590897 20260328114840_9MZ51 US0005 2026-03-29T12:03:27.916Z 2026-04-06T12:38:39.551Z
9590817 9590817 20260328112712_pufvv US0005 2026-03-29T12:03:20.291Z 2026-04-06T12:38:35.839Z
9590797 9590797 20260328111645_2IMSy US0005 2026-03-29T12:03:18.226Z 2026-04-06T12:38:34.931Z
9590779 9590779 20260328111442_JcQsD US0005 2026-03-29T12:03:17.258Z 2026-04-06T12:38:34.362Z
9590689 9590689 20260328104326_0EJIO US0005 2026-03-29T12:03:07.166Z 2026-04-06T12:38:30.492Z
9590635 9590635 20260328103055_7TYnt US0005 2026-03-29T12:03:02.954Z 2026-04-06T12:38:28.233Z
9590597 9590597 20260328102052_XME82 US0005 2026-03-29T12:02:58.894Z 2026-04-06T12:38:26.386Z
9590516 9590516 20260328094831_Qtx04 US0005 2026-03-29T12:02:50.504Z 2026-04-06T12:38:13.867Z
9587322 9587322 20260327120521_7skvl US0005 2026-03-28T12:05:16.618Z 2026-04-05T12:34:13.054Z
9587276 9587276 20260327115856_1yNoQ US0005 2026-03-28T12:05:10.940Z 2026-04-05T12:34:11.147Z
9587136 9587136 20260327112344_byWRd US0005 2026-03-28T12:04:52.231Z 2026-04-05T12:34:03.769Z
9587033 9587033 20260327105521_0yYej US0005 2026-03-28T12:04:39.439Z 2026-04-05T12:33:59.379Z
9587008 9587008 20260327104440_qyy5M US0005 2026-03-28T12:04:33.387Z 2026-04-05T12:33:58.265Z
9586678 9586678 20260327090709_IsgVc US0005 2026-03-28T12:03:45.384Z 2026-04-05T12:33:37.296Z
9586653 9586653 20260327085643_M602J US0005 2026-03-28T12:03:39.836Z 2026-04-05T12:33:36.115Z
9586618 9586618 20260327084316_Q4jt2 US0005 2026-03-28T12:03:33.872Z 2026-04-05T12:33:32.928Z
9586588 9586588 20260327083418_E7SKc US0005 2026-03-28T12:03:30.076Z 2026-04-05T12:33:31.751Z
9586540 9586540 20260327081337_Afc1G US0005 2026-03-28T12:03:22.401Z 2026-04-05T12:33:29.836Z
9586478 9586478 20260327075738_W9tcw US0005 2026-03-28T12:03:13.332Z 2026-04-05T12:33:27.510Z
9586468 9586468 20260327075554_nUuy3 US0005 2026-03-28T12:03:12.174Z 2026-04-05T12:33:27.210Z
9586450 9586450 20260327074414_vUQNv US0005 2026-03-28T12:03:09.235Z 2026-04-05T12:33:26.310Z
9586446 9586446 20260327074409_f6vfL US0005 2026-03-28T12:03:08.777Z 2026-04-05T12:33:26.159Z
9586425 9586425 20260327072702_3noKo US0005 2026-03-28T12:03:03.238Z 2026-04-05T12:33:24.854Z
9586417 9586417 20260327072258_n94PH US0005 2026-03-28T12:03:02.237Z 2026-04-05T12:33:24.524Z
9586405 9586405 20260327071130_u7xgG US0005 2026-03-28T12:03:00.767Z 2026-04-05T12:33:24.014Z
9586342 9586342 20260327063143_unXFp US0005 2026-03-28T12:02:51.945Z 2026-04-05T12:33:21.443Z
9586323 9586323 20260327062215_IDjd3 US0005 2026-03-28T12:02:50.003Z 2026-04-05T12:33:20.711Z
9586242 9586242 20260327051547_9u7Qg US0005 2026-03-28T12:02:35.913Z 2026-04-05T12:33:09.980Z
9585790 9585790 20260327023203_ieG3F US0005 2026-03-28T12:01:20.164Z 2026-04-05T12:32:45.566Z
9583290 9583290 20260326120931_4dMVy US0005 2026-03-27T12:08:18.036Z 2026-04-04T12:41:00.604Z
9583233 9583233 20260326114540_7YB3G US0005 2026-03-27T12:08:08.875Z 2026-04-04T12:40:57.753Z
9583180 9583180 20260326113224_YpAOG US0005 2026-03-27T12:07:57.640Z 2026-04-04T12:40:55.337Z
9583168 9583168 20260326113018_60HJT US0005 2026-03-27T12:07:56.355Z 2026-04-04T12:40:54.962Z
9583149 9583149 20260326112101_Y5bXa US0005 2026-03-27T12:07:52.698Z 2026-04-04T12:40:54.052Z
9582978 9582978 20260326103213_J5EUc US0005 2026-03-27T12:07:23.189Z 2026-04-04T12:40:38.894Z
9582966 9582966 20260326102840_Sxf4H US0005 2026-03-27T12:07:21.405Z 2026-04-04T12:40:38.365Z
9582881 9582881 20260326095548_hJcS4 US0005 2026-03-27T12:07:05.530Z 2026-04-04T12:40:34.267Z
9582872 9582872 20260326095414_MFlNc US0005 2026-03-27T12:07:04.986Z 2026-04-04T12:40:34.089Z
9582778 9582778 20260326092411_8STVo US0005 2026-03-27T12:06:45.258Z 2026-04-04T12:40:27.933Z
9582764 9582764 20260326092122_wRiK4 US0005 2026-03-27T12:06:43.553Z 2026-04-04T12:40:27.511Z
9582717 9582717 20260326091207_1IXD7 US0005 2026-03-27T12:06:35.817Z 2026-04-04T12:40:25.291Z
9582692 9582692 20260326090806_CQf79 US0005 2026-03-27T12:06:33.735Z 2026-04-04T12:40:20.522Z
9582613 9582613 20260326084040_u3Rxw US0005 2026-03-27T12:06:21.511Z 2026-04-04T12:40:15.750Z
9582430 9582430 20260326072457_0wwyy US0005 2026-03-27T12:05:45.075Z 2026-04-04T12:40:00.755Z
9582288 9582288 20260326062151_4UKVQ US0005 2026-03-27T12:05:16.391Z 2026-04-04T12:39:48.718Z
9581923 9581923 20260326041211_lpPbj US0005 2026-03-27T12:04:11.497Z 2026-04-04T12:39:31.512Z

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