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

5,832 rows where station_code = "US0066" 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
9633174 9633174 20260408030745_ZjW1h US0066 2026-04-09T12:27:18.481Z 2026-04-09T12:28:35.172Z
9632921 9632921 20260408024725_3XC77 US0066 2026-04-09T12:26:45.679Z 2026-04-09T12:28:35.113Z
9632800 9632800 20260408023749_boadH US0066 2026-04-09T12:26:35.063Z 2026-04-09T12:28:35.081Z
9625551 9625551 20260408111738_GglKu US0066 2026-04-09T12:05:50.906Z 2026-04-09T12:05:50.906Z
9625456 9625456 20260408105611_DOX3R US0066 2026-04-09T12:05:35.908Z 2026-04-09T12:05:35.908Z
9625441 9625441 20260408105214_v1EJ6 US0066 2026-04-09T12:05:33.302Z 2026-04-09T12:05:33.302Z
9625395 9625395 20260408104616_CGM58 US0066 2026-04-09T12:05:19.182Z 2026-04-09T12:05:19.182Z
9625071 9625071 20260408092810_t6L8f US0066 2026-04-09T12:04:06.398Z 2026-04-09T12:04:06.398Z
9625053 9625053 20260408092403_VPzI0 US0066 2026-04-09T12:04:02.742Z 2026-04-09T12:04:02.742Z
9624963 9624963 20260408090423_BlrFJ US0066 2026-04-09T12:03:35.010Z 2026-04-09T12:03:35.010Z
9624959 9624959 20260408090423_TNyGd US0066 2026-04-09T12:03:34.463Z 2026-04-09T12:03:34.463Z
9624835 9624835 20260408084137_ECsTv US0066 2026-04-09T12:03:05.838Z 2026-04-09T12:03:05.838Z
9624699 9624699 20260408081014_63w00 US0066 2026-04-09T12:02:32.575Z 2026-04-09T12:02:32.575Z
9624661 9624661 20260408080330_zDr25 US0066 2026-04-09T12:02:25.381Z 2026-04-09T12:02:25.381Z
9624611 9624611 20260408075159_PcERC US0066 2026-04-09T12:02:08.602Z 2026-04-09T12:02:08.602Z
9624604 9624604 20260408075100_NiliP US0066 2026-04-09T12:02:07.224Z 2026-04-09T12:02:07.224Z
9624551 9624551 20260408073619_RCRYf US0066 2026-04-09T12:01:57.352Z 2026-04-09T12:01:57.352Z
9624385 9624385 20260408063734_2RRnQ US0066 2026-04-09T12:01:15.690Z 2026-04-09T12:01:15.690Z
9624367 9624367 20260408062629_32lWS US0066 2026-04-09T12:01:11.129Z 2026-04-09T12:01:11.129Z
9624328 9624328 20260408061538_loOPB US0066 2026-04-09T12:00:57.623Z 2026-04-09T12:00:57.623Z
9624285 9624285 20260408060137_3Z2Cu US0066 2026-04-09T12:00:48.633Z 2026-04-09T12:00:48.633Z
9616880 9616880 20260407071025_OgXdG US0066 2026-04-08T12:00:51.453Z 2026-04-09T12:28:33.452Z
9612396 9612396 20260406104534_BUI2f US0066 2026-04-07T12:01:39.909Z 2026-04-09T12:29:52.718Z
9612388 9612388 20260406104231_i2TpV US0066 2026-04-07T12:01:38.991Z 2026-04-09T12:29:51.629Z
9612361 9612361 20260406100806_EYIb7 US0066 2026-04-07T12:01:35.411Z 2026-04-09T12:29:47.677Z
9612325 9612325 20260406094729_YubUK US0066 2026-04-07T12:01:30.771Z 2026-04-09T12:29:44.013Z
9612249 9612249 20260406090719_LIKNF US0066 2026-04-07T12:01:12.493Z 2026-04-09T12:29:21.639Z
9612220 9612220 20260406084352_n2uVv US0066 2026-04-07T12:01:07.203Z 2026-04-09T12:29:07.642Z
9612185 9612185 20260406075035_Re6EP US0066 2026-04-07T12:01:02.122Z 2026-04-09T12:29:01.157Z
9612139 9612139 20260406073033_wgk9b US0066 2026-04-07T12:00:55.164Z 2026-04-09T12:28:52.682Z
9612120 9612120 20260406071223_NfzWb US0066 2026-04-07T12:00:51.641Z 2026-04-09T12:28:49.960Z
9612081 9612081 20260406063453_3fNAT US0066 2026-04-07T12:00:44.160Z 2026-04-09T12:28:48.797Z
9612079 9612079 20260406063356_uX79Y US0066 2026-04-07T12:00:43.752Z 2026-04-09T12:28:48.683Z
9612006 9612006 20260406044748_SDKXG US0066 2026-04-07T12:00:26.071Z 2026-04-09T12:28:45.477Z
9611851 9611851 20260402050934_P8vWA US0066 2026-04-06T12:21:24.679Z 2026-04-09T12:43:17.794Z
9599089 9599089 20260331113245_32RZo US0066 2026-04-01T12:02:19.704Z 2026-04-09T12:46:41.244Z
9598971 9598971 20260331100434_1YjtM US0066 2026-04-01T12:01:50.144Z 2026-04-09T12:46:39.138Z
9598962 9598962 20260331094803_0HWm8 US0066 2026-04-01T12:01:47.383Z 2026-04-09T12:46:38.968Z
9598929 9598929 20260331091520_HowG9 US0066 2026-04-01T12:01:37.970Z 2026-04-09T12:46:38.314Z
9598911 9598911 20260331084856_ceQAt US0066 2026-04-01T12:01:32.008Z 2026-04-09T12:46:37.816Z
9598844 9598844 20260331074816_TwpIm US0066 2026-04-01T12:01:17.098Z 2026-04-09T12:46:36.739Z
9593539 9593539 20260329114508_88O85 US0066 2026-03-30T12:04:19.335Z 2026-04-07T12:27:13.732Z
9593527 9593527 20260329114355_WQbwX US0066 2026-03-30T12:04:16.790Z 2026-04-07T12:27:13.451Z
9593525 9593525 20260329114245_z6m7I US0066 2026-03-30T12:04:16.187Z 2026-04-07T12:27:13.364Z
9593490 9593490 20260329111352_dt7EK US0066 2026-03-30T12:04:09.161Z 2026-04-07T12:27:11.520Z
9593421 9593421 20260329103549_6PBeU US0066 2026-03-30T12:03:54.412Z 2026-04-07T12:27:09.716Z
9593375 9593375 20260329095319_kHjcx US0066 2026-03-30T12:03:46.007Z 2026-04-07T12:27:08.544Z
9593370 9593370 20260329095308_m3BGJ US0066 2026-03-30T12:03:45.381Z 2026-04-07T12:27:08.472Z
9593356 9593356 20260329094134_aQBFU US0066 2026-03-30T12:03:42.819Z 2026-04-07T12:27:08.103Z
9593286 9593286 20260329085539_vNa3Q US0066 2026-03-30T12:03:30.027Z 2026-04-07T12:27:06.559Z
9593252 9593252 20260329083308_XcMTl US0066 2026-03-30T12:03:23.814Z 2026-04-07T12:27:05.649Z
9593246 9593246 20260329083007_vMXq3 US0066 2026-03-30T12:03:22.428Z 2026-04-07T12:27:05.454Z
9593190 9593190 20260329074930_2lu0m US0066 2026-03-30T12:03:14.595Z 2026-04-07T12:27:04.111Z
9593167 9593167 20260329072049_hj6ui US0066 2026-03-30T12:03:10.196Z 2026-04-07T12:27:03.498Z
9593137 9593137 20260329065018_xK6mp US0066 2026-03-30T12:03:04.107Z 2026-04-07T12:27:02.823Z
9593064 9593064 20260329050046_IiEMI US0066 2026-03-30T12:02:48.877Z 2026-04-07T12:27:00.563Z
9592773 9592773 20260329032018_m3QQe US0066 2026-03-30T12:01:55.034Z 2026-04-07T12:26:40.789Z
9590964 9590964 20260328120614_CLMvL US0066 2026-03-29T12:03:33.156Z 2026-04-06T12:38:42.298Z
9590915 9590915 20260328115246_ANQsR US0066 2026-03-29T12:03:29.508Z 2026-04-06T12:38:40.501Z
9590874 9590874 20260328113705_L2EmX US0066 2026-03-29T12:03:25.441Z 2026-04-06T12:38:38.327Z
9590853 9590853 20260328113348_kp2gy US0066 2026-03-29T12:03:23.581Z 2026-04-06T12:38:37.339Z
9590825 9590825 20260328112714_a8NNN US0066 2026-03-29T12:03:20.607Z 2026-04-06T12:38:35.968Z
9590794 9590794 20260328111612_Dqj2N US0066 2026-03-29T12:03:17.981Z 2026-04-06T12:38:34.851Z
9590774 9590774 20260328111303_p9DvM US0066 2026-03-29T12:03:16.838Z 2026-04-06T12:38:34.213Z
9590767 9590767 20260328111239_zFulE US0066 2026-03-29T12:03:16.029Z 2026-04-06T12:38:33.948Z
9590743 9590743 20260328110325_jwhUe US0066 2026-03-29T12:03:12.054Z 2026-04-06T12:38:32.372Z
9590678 9590678 20260328104118_NI94H US0066 2026-03-29T12:03:06.530Z 2026-04-06T12:38:30.114Z
9590626 9590626 20260328102743_0UlFQ US0066 2026-03-29T12:03:02.070Z 2026-04-06T12:38:27.881Z
9590571 9590571 20260328100614_YdUh3 US0066 2026-03-29T12:02:55.797Z 2026-04-06T12:38:24.681Z
9590561 9590561 20260328100321_tnaX3 US0066 2026-03-29T12:02:54.652Z 2026-04-06T12:38:24.154Z
9590415 9590415 20260328090230_e7aBM US0066 2026-03-29T12:02:35.839Z 2026-04-06T12:38:06.777Z
9590363 9590363 20260328083117_JnGab US0066 2026-03-29T12:02:28.982Z 2026-04-06T12:38:03.063Z
9590341 9590341 20260328081957_BYZc4 US0066 2026-03-29T12:02:26.586Z 2026-04-06T12:38:01.991Z
9587267 9587267 20260327115745_TpuOL US0066 2026-03-28T12:05:09.903Z 2026-04-05T12:34:10.780Z
9587196 9587196 20260327113916_17qUX US0066 2026-03-28T12:04:58.766Z 2026-04-05T12:34:06.357Z
9587132 9587132 20260327112127_aOV4d US0066 2026-03-28T12:04:51.261Z 2026-04-05T12:34:03.497Z
9586897 9586897 20260327100917_62pT2 US0066 2026-03-28T12:04:18.799Z 2026-04-05T12:33:53.370Z
9586861 9586861 20260327100024_A6i54 US0066 2026-03-28T12:04:14.837Z 2026-04-05T12:33:52.247Z
9586790 9586790 20260327093606_B2IL8 US0066 2026-03-28T12:04:00.743Z 2026-04-05T12:33:48.543Z
9586727 9586727 20260327091954_yVnNk US0066 2026-03-28T12:03:50.866Z 2026-04-05T12:33:39.201Z
9586571 9586571 20260327082622_c1OLk US0066 2026-03-28T12:03:26.973Z 2026-04-05T12:33:30.928Z
9586561 9586561 20260327082044_F2Bg9 US0066 2026-03-28T12:03:25.189Z 2026-04-05T12:33:30.501Z
9586499 9586499 20260327080234_djmQv US0066 2026-03-28T12:03:17.271Z 2026-04-05T12:33:28.247Z
9586379 9586379 20260327065235_fCq5v US0066 2026-03-28T12:02:56.580Z 2026-04-05T12:33:22.731Z
9586358 9586358 20260327063829_RTSuO US0066 2026-03-28T12:02:53.382Z 2026-04-05T12:33:21.915Z
9586291 9586291 20260327055329_Z2jJY US0066 2026-03-28T12:02:43.904Z 2026-04-05T12:33:19.226Z
9586203 9586203 20260327045412_DIXV4 US0066 2026-03-28T12:02:31.300Z 2026-04-05T12:33:08.052Z
9583258 9583258 20260326115930_rGGoE US0066 2026-03-27T12:08:12.345Z 2026-04-04T12:40:58.630Z
9583196 9583196 20260326113628_YQsai US0066 2026-03-27T12:08:00.793Z 2026-04-04T12:40:56.001Z
9583108 9583108 20260326110137_cXuBS US0066 2026-03-27T12:07:45.188Z 2026-04-04T12:40:52.230Z
9583098 9583098 20260326105705_1qgKh US0066 2026-03-27T12:07:41.739Z 2026-04-04T12:40:46.007Z
9583087 9583087 20260326105211_nRSAg US0066 2026-03-27T12:07:39.470Z 2026-04-04T12:40:45.057Z
9583052 9583052 20260326104211_FpB8Y US0066 2026-03-27T12:07:31.793Z 2026-04-04T12:40:43.302Z
9583031 9583031 20260326103707_6vYl2 US0066 2026-03-27T12:07:27.453Z 2026-04-04T12:40:41.666Z
9583018 9583018 20260326103513_4VU5d US0066 2026-03-27T12:07:26.100Z 2026-04-04T12:40:39.650Z
9582906 9582906 20260326095908_MtF28 US0066 2026-03-27T12:07:11.023Z 2026-04-04T12:40:35.842Z
9582886 9582886 20260326095556_FeHPu US0066 2026-03-27T12:07:06.099Z 2026-04-04T12:40:34.401Z
9582670 9582670 20260326090039_Pl3zU US0066 2026-03-27T12:06:30.020Z 2026-04-04T12:40:18.226Z
9582625 9582625 20260326084150_H35OL US0066 2026-03-27T12:06:22.426Z 2026-04-04T12:40:16.020Z
9582561 9582561 20260326082740_x29hT US0066 2026-03-27T12:06:09.932Z 2026-04-04T12:40:10.068Z

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