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 = "US000R" 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
9609998 9609998 20260405114501_h5Hk7 US000R 2026-04-06T12:05:12.658Z 2026-04-06T12:05:12.658Z
9609955 9609955 20260405112604_wFnQl US000R 2026-04-06T12:04:55.814Z 2026-04-06T12:04:55.814Z
9609947 9609947 20260405112024_mmUi4 US000R 2026-04-06T12:04:53.691Z 2026-04-06T12:04:53.691Z
9609902 9609902 20260405110255_Ndj79 US000R 2026-04-06T12:04:33.545Z 2026-04-06T12:04:33.545Z
9609852 9609852 20260405103531_Xlq24 US000R 2026-04-06T12:04:20.045Z 2026-04-06T12:04:20.045Z
9609848 9609848 20260405103441_3o61p US000R 2026-04-06T12:04:19.412Z 2026-04-06T12:04:19.412Z
9609774 9609774 20260405095448_vb1DW US000R 2026-04-06T12:03:49.537Z 2026-04-06T12:03:49.537Z
9609741 9609741 20260405093637_lOPqf US000R 2026-04-06T12:03:37.045Z 2026-04-06T12:03:37.045Z
9609682 9609682 20260405090721_TAtFQ US000R 2026-04-06T12:03:18.280Z 2026-04-06T12:03:18.280Z
9609629 9609629 20260405084202_9PDae US000R 2026-04-06T12:02:58.049Z 2026-04-06T12:02:58.049Z
9609622 9609622 20260405084100_lXHwI US000R 2026-04-06T12:02:56.443Z 2026-04-06T12:02:56.443Z
9609592 9609592 20260405082903_Tlzcd US000R 2026-04-06T12:02:49.458Z 2026-04-06T12:02:49.458Z
9609581 9609581 20260405082643_kEgWZ US000R 2026-04-06T12:02:42.037Z 2026-04-06T12:02:42.037Z
9609558 9609558 20260405081047_e2u0T US000R 2026-04-06T12:02:33.070Z 2026-04-06T12:02:33.070Z
9607612 9607612 20260404111541_dc6Oj US000R 2026-04-05T12:03:09.544Z 2026-04-06T12:16:14.474Z
9607605 9607605 20260404111222_ZN3Ej US000R 2026-04-05T12:03:08.703Z 2026-04-06T12:16:14.473Z
9607571 9607571 20260404105946_JzcFX US000R 2026-04-05T12:02:57.495Z 2026-04-06T12:16:14.465Z
9607432 9607432 20260404090945_UdTB6 US000R 2026-04-05T12:02:15.766Z 2026-04-06T12:16:14.435Z
9607398 9607398 20260404083442_UFKq5 US000R 2026-04-05T12:01:59.127Z 2026-04-06T12:16:14.427Z
9605621 9605621 20260403111003_m35mA US000R 2026-04-04T12:03:08.664Z 2026-04-06T12:18:08.504Z
9605316 9605316 20260403083608_WuM7h US000R 2026-04-04T12:01:46.182Z 2026-04-06T12:17:41.792Z
9603084 9603084 20260402074119_obzBY US000R 2026-04-03T12:01:41.717Z 2026-04-06T12:21:33.079Z
9603078 9603078 20260402073643_NA8HY US000R 2026-04-03T12:01:40.492Z 2026-04-06T12:21:32.607Z
9603029 9603029 20260402063215_11hhR US000R 2026-04-03T12:01:31.567Z 2026-04-06T12:21:28.822Z
9602989 9602989 20260402051519_7BJeu US000R 2026-04-03T12:01:25.022Z 2026-04-06T12:21:25.063Z
9602829 9602829 20260402033238_Ge3l9 US000R 2026-04-03T12:00:48.439Z 2026-04-06T12:21:14.861Z
9602710 9602710 20260402024141_0hv2f US000R 2026-04-03T12:00:18.083Z 2026-04-06T12:21:04.945Z
9599133 9599133 20260331115838_AnKOb US000R 2026-04-01T12:02:28.877Z 2026-04-06T12:27:28.141Z
9598736 9598736 20260331040832_L3Zru US000R 2026-04-01T12:00:47.689Z 2026-04-06T12:26:54.487Z
9593572 9593572 20260329115910_0lQ6t US000R 2026-03-30T12:04:25.441Z 2026-04-06T12:35:26.617Z
9593472 9593472 20260329111036_mQNN1 US000R 2026-03-30T12:04:05.652Z 2026-04-06T12:35:20.828Z
9593429 9593429 20260329103819_5awPj US000R 2026-03-30T12:03:55.290Z 2026-04-06T12:35:18.201Z
9593412 9593412 20260329102313_2YNTW US000R 2026-03-30T12:03:52.686Z 2026-04-06T12:35:17.093Z
9590820 9590820 20260328112712_pufvv US000R 2026-03-29T12:03:20.291Z 2026-04-06T12:38:35.839Z
9590802 9590802 20260328111645_2IMSy US000R 2026-03-29T12:03:18.226Z 2026-04-06T12:38:34.932Z
9590694 9590694 20260328104418_Em5bT US000R 2026-03-29T12:03:07.465Z 2026-04-06T12:38:30.622Z
9590683 9590683 20260328104257_hU8Qn US000R 2026-03-29T12:03:06.973Z 2026-04-06T12:38:30.359Z
9590669 9590669 20260328103834_rEAaY US000R 2026-03-29T12:03:06.079Z 2026-04-06T12:38:29.885Z
9589233 9589233 20260328025625_wRcXI US000R 2026-03-29T12:00:56.796Z 2026-04-06T12:37:08.814Z
9587243 9587243 20260327115208_Jtmyf US000R 2026-03-28T12:05:06.079Z 2026-04-05T12:34:09.767Z
9587101 9587101 20260327111208_LdroS US000R 2026-03-28T12:04:46.212Z 2026-04-05T12:34:01.692Z
9587036 9587036 20260327105521_0yYej US000R 2026-03-28T12:04:39.439Z 2026-04-05T12:33:59.379Z
9587013 9587013 20260327104440_qyy5M US000R 2026-03-28T12:04:33.387Z 2026-04-05T12:33:58.265Z
9586986 9586986 20260327103627_qAy33 US000R 2026-03-28T12:04:29.836Z 2026-04-05T12:33:57.159Z
9586973 9586973 20260327103514_v4RNR US000R 2026-03-28T12:04:28.763Z 2026-04-05T12:33:56.655Z
9586684 9586684 20260327090709_IsgVc US000R 2026-03-28T12:03:45.384Z 2026-04-05T12:33:37.296Z
9586657 9586657 20260327085643_M602J US000R 2026-03-28T12:03:39.836Z 2026-04-05T12:33:36.115Z
9586624 9586624 20260327084316_Q4jt2 US000R 2026-03-28T12:03:33.872Z 2026-04-05T12:33:32.928Z
9583174 9583174 20260326113018_60HJT US000R 2026-03-27T12:07:56.355Z 2026-04-04T12:40:54.962Z
9583071 9583071 20260326104909_PW5Z6 US000R 2026-03-27T12:07:35.299Z 2026-04-04T12:40:44.179Z
9582878 9582878 20260326095414_MFlNc US000R 2026-03-27T12:07:04.986Z 2026-04-04T12:40:34.089Z
9582781 9582781 20260326092411_8STVo US000R 2026-03-27T12:06:45.258Z 2026-04-04T12:40:27.934Z
9582697 9582697 20260326090806_CQf79 US000R 2026-03-27T12:06:33.735Z 2026-04-04T12:40:20.523Z
9582508 9582508 20260326080852_wipDL US000R 2026-03-27T12:05:59.927Z 2026-04-04T12:40:05.365Z
9582435 9582435 20260326072457_0wwyy US000R 2026-03-27T12:05:45.075Z 2026-04-04T12:40:00.755Z
9581463 9581463 20260326031552_wMxrB US000R 2026-03-27T12:03:10.840Z 2026-04-04T12:39:06.813Z
9578529 9578529 20260325121101_WA700 US000R 2026-03-26T12:07:49.865Z 2026-04-03T12:38:07.142Z
9578069 9578069 20260325095036_O2u33 US000R 2026-03-26T12:06:40.945Z 2026-04-03T12:37:35.848Z
9577881 9577881 20260325090846_JeCp6 US000R 2026-03-26T12:06:16.929Z 2026-04-03T12:37:29.913Z
9577722 9577722 20260325081314_BQgBq US000R 2026-03-26T12:05:55.606Z 2026-04-03T12:37:24.552Z
9577536 9577536 20260325070917_fxCPN US000R 2026-03-26T12:05:26.635Z 2026-04-03T12:37:05.414Z
9577378 9577378 20260325052426_H7C0X US000R 2026-03-26T12:04:58.369Z 2026-04-03T12:36:59.398Z
9577130 9577130 20260325040042_gHP7J US000R 2026-03-26T12:04:13.699Z 2026-04-03T12:36:35.899Z
9573315 9573315 20260324114759_fdc0F US000R 2026-03-25T12:07:42.410Z 2026-04-02T12:36:04.143Z
9573030 9573030 20260324110924_V32Xb US000R 2026-03-25T12:07:02.862Z 2026-04-02T12:35:53.515Z
9572984 9572984 20260324110429_Nms2X US000R 2026-03-25T12:06:55.242Z 2026-04-02T12:35:45.941Z
9572630 9572630 20260324094020_oBxom US000R 2026-03-25T12:05:48.234Z 2026-04-02T12:35:32.447Z
9572539 9572539 20260324092357_lGVhN US000R 2026-03-25T12:05:30.534Z 2026-04-02T12:35:29.112Z
9572187 9572187 20260324080158_0lFNo US000R 2026-03-25T12:04:09.980Z 2026-04-02T12:35:06.903Z
9571828 9571828 20260324044507_HYX4J US000R 2026-03-25T12:02:52.616Z 2026-04-02T12:34:50.831Z
9565421 9565421 20260323120743_qI8uK US000R 2026-03-24T12:10:04.043Z 2026-03-31T12:27:34.800Z
9564845 9564845 20260323111317_AYkcl US000R 2026-03-24T12:08:53.269Z 2026-03-31T12:27:16.311Z
9564267 9564267 20260323101955_pcB8M US000R 2026-03-24T12:07:44.840Z 2026-03-31T12:27:06.281Z
9563370 9563370 20260323080540_0Ovbz US000R 2026-03-24T12:05:50.685Z 2026-03-31T12:26:41.666Z
9563161 9563161 20260323072234_wCRtU US000R 2026-03-24T12:05:18.616Z 2026-03-31T12:26:36.802Z
9563123 9563123 20260323070252_NVpji US000R 2026-03-24T12:05:09.725Z 2026-03-31T12:26:35.584Z
9556912 9556912 20260322121037_idZrW US000R 2026-03-23T12:05:20.632Z 2026-03-30T12:29:14.743Z
9556604 9556604 20260322111303_wgZii US000R 2026-03-23T12:04:59.618Z 2026-03-30T12:29:06.123Z
9556540 9556540 20260322110231_9KoAL US000R 2026-03-23T12:04:55.583Z 2026-03-30T12:29:04.072Z
9555801 9555801 20260322080507_lpU45 US000R 2026-03-23T12:03:56.832Z 2026-03-30T12:28:35.779Z
9555618 9555618 20260322070432_2meFC US000R 2026-03-23T12:03:41.941Z 2026-03-30T12:28:30.650Z
9555338 9555338 20260322044059_sPPSz US000R 2026-03-23T12:03:21.131Z 2026-03-30T12:28:24.965Z
9555235 9555235 20260322042800_W7xGh US000R 2026-03-23T12:03:16.990Z 2026-03-30T12:28:23.447Z
9554989 9554989 20260322035108_3MJb3 US000R 2026-03-23T12:03:00.654Z 2026-03-30T12:28:12.716Z
9553959 9553959 20260322022915_i6gxB US000R 2026-03-23T12:02:03.663Z 2026-03-30T12:27:56.008Z
9546488 9546488 20260321120241_J7erB US000R 2026-03-22T12:11:51.197Z 2026-03-29T12:20:01.625Z
9546191 9546191 20260321114224_2bTaP US000R 2026-03-22T12:11:14.189Z 2026-03-29T12:19:48.274Z
9545818 9545818 20260321111008_7Waz7 US000R 2026-03-22T12:10:20.087Z 2026-03-29T12:19:44.738Z
9545315 9545315 20260321102054_za0gy US000R 2026-03-22T12:09:06.004Z 2026-03-29T12:19:39.077Z
9545267 9545267 20260321101828_fg6D2 US000R 2026-03-22T12:09:02.178Z 2026-03-29T12:19:38.736Z
9544709 9544709 20260321091226_COcDn US000R 2026-03-22T12:07:33.047Z 2026-03-29T12:19:32.737Z
9544559 9544559 20260321085337_2CJtg US000R 2026-03-22T12:07:09.431Z 2026-03-29T12:19:31.094Z
9544111 9544111 20260321073755_pyAFX US000R 2026-03-22T12:05:45.582Z 2026-03-29T12:19:16.427Z
9544074 9544074 20260321072121_uFux2 US000R 2026-03-22T12:05:38.413Z 2026-03-29T12:19:15.882Z
9543922 9543922 20260321063039_6353U US000R 2026-03-22T12:05:10.797Z 2026-03-29T12:19:14.022Z
9543899 9543899 20260321062559_EDMLf US000R 2026-03-22T12:05:06.196Z 2026-03-29T12:19:13.861Z
9543843 9543843 20260321054544_YDhHH US000R 2026-03-22T12:04:54.828Z 2026-03-29T12:19:12.990Z
9543138 9543138 20260321024450_cTEto US000R 2026-03-22T12:02:46.101Z 2026-03-29T12:19:03.416Z
9537557 9537557 20260320114635_45jkQ US000R 2026-03-21T12:15:59.979Z 2026-03-28T12:35:27.091Z
9537517 9537517 20260320114258_AbcKU US000R 2026-03-21T12:15:57.721Z 2026-03-28T12:35:26.845Z

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