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 = "US0006" 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
9609796 9609796 20260405100824_5ebnz US0006 2026-04-06T12:03:54.785Z 2026-04-06T12:03:54.785Z
9609734 9609734 20260405093636_vX7Da US0006 2026-04-06T12:03:36.227Z 2026-04-06T12:03:36.227Z
9609721 9609721 20260405093115_dp5rX US0006 2026-04-06T12:03:29.417Z 2026-04-06T12:03:29.417Z
9609715 9609715 20260405093052_2huF2 US0006 2026-04-06T12:03:27.993Z 2026-04-06T12:03:27.993Z
9609666 9609666 20260405090242_2BD4f US0006 2026-04-06T12:03:11.100Z 2026-04-06T12:03:11.100Z
9609643 9609643 20260405085801_l2Ppr US0006 2026-04-06T12:03:03.111Z 2026-04-06T12:03:03.111Z
9609508 9609508 20260405073625_c7zc3 US0006 2026-04-06T12:02:15.752Z 2026-04-06T12:02:15.752Z
9609346 9609346 20260405050144_0cTIv US0006 2026-04-06T12:01:21.051Z 2026-04-06T12:01:21.051Z
9608956 9608956 20260404024927_3IKXP US0006 2026-04-05T12:12:23.808Z 2026-04-06T12:20:53.417Z
9607517 9607517 20260404101747_vQiRT US0006 2026-04-05T12:02:45.040Z 2026-04-06T12:16:14.455Z
9607461 9607461 20260404093557_F26go US0006 2026-04-05T12:02:23.806Z 2026-04-06T12:16:14.443Z
9607440 9607440 20260404091817_d73Ru US0006 2026-04-05T12:02:18.711Z 2026-04-06T12:16:14.438Z
9607408 9607408 20260404085207_eE6F3 US0006 2026-04-05T12:02:03.218Z 2026-04-06T12:16:14.429Z
9607333 9607333 20260404075223_GbSsh US0006 2026-04-05T12:01:41.882Z 2026-04-06T12:16:14.413Z
9607314 9607314 20260404072111_yMBK6 US0006 2026-04-05T12:01:33.682Z 2026-04-06T12:16:14.408Z
9607184 9607184 20260404042848_gsW8M US0006 2026-04-05T12:00:47.728Z 2026-04-06T12:16:14.380Z
9607121 9607121 20260404034456_IASLq US0006 2026-04-05T12:00:31.008Z 2026-04-06T12:16:14.367Z
9607075 9607075 20260404032658_3mG32 US0006 2026-04-05T12:00:20.897Z 2026-04-06T12:16:14.355Z
9595935 9595935 20260330101218_DW2KY US0006 2026-03-31T12:02:54.936Z 2026-04-06T12:30:41.806Z
9593489 9593489 20260329111352_dt7EK US0006 2026-03-30T12:04:09.160Z 2026-04-06T12:35:21.816Z
9593350 9593350 20260329093726_TqCnF US0006 2026-03-30T12:03:41.769Z 2026-04-06T12:35:13.754Z
9593323 9593323 20260329091900_dc6Rg US0006 2026-03-30T12:03:37.005Z 2026-04-06T12:35:12.212Z
9593196 9593196 20260329075221_8s10a US0006 2026-03-30T12:03:15.545Z 2026-04-06T12:34:55.828Z
9593163 9593163 20260329072049_hj6ui US0006 2026-03-30T12:03:10.196Z 2026-04-06T12:34:54.179Z
9593133 9593133 20260329065018_01LAU US0006 2026-03-30T12:03:03.729Z 2026-04-06T12:34:52.319Z
9593131 9593131 20260329064930_m7V9U US0006 2026-03-30T12:03:03.217Z 2026-04-06T12:34:52.182Z
9590903 9590903 20260328115108_ToSip US0006 2026-03-29T12:03:28.755Z 2026-04-06T12:38:40.035Z
9590884 9590884 20260328114419_TLz4j US0006 2026-03-29T12:03:26.635Z 2026-04-06T12:38:39.005Z
9590850 9590850 20260328113348_kp2gy US0006 2026-03-29T12:03:23.581Z 2026-04-06T12:38:37.339Z
9590788 9590788 20260328111612_Dqj2N US0006 2026-03-29T12:03:17.981Z 2026-04-06T12:38:34.851Z
9590738 9590738 20260328110325_jwhUe US0006 2026-03-29T12:03:12.054Z 2026-04-06T12:38:32.372Z
9590729 9590729 20260328105803_LvJym US0006 2026-03-29T12:03:11.403Z 2026-04-06T12:38:31.940Z
9590673 9590673 20260328104118_NI94H US0006 2026-03-29T12:03:06.530Z 2026-04-06T12:38:30.114Z
9590612 9590612 20260328102250_O7DQA US0006 2026-03-29T12:03:00.396Z 2026-04-06T12:38:27.171Z
9590559 9590559 20260328100321_tnaX3 US0006 2026-03-29T12:02:54.652Z 2026-04-06T12:38:24.154Z
9590529 9590529 20260328095215_nH5gL US0006 2026-03-29T12:02:52.028Z 2026-04-06T12:38:22.826Z
9590355 9590355 20260328083000_JA8gc US0006 2026-03-29T12:02:28.503Z 2026-04-06T12:38:02.790Z
9590270 9590270 20260328080005_Bx2Ue US0006 2026-03-29T12:02:21.258Z 2026-04-06T12:37:59.213Z
9589128 9589128 20260328022906_F5UU2 US0006 2026-03-29T12:00:44.595Z 2026-04-06T12:37:02.419Z
9587264 9587264 20260327115745_TpuOL US0006 2026-03-28T12:05:09.903Z 2026-04-05T12:34:10.780Z
9587192 9587192 20260327113916_17qUX US0006 2026-03-28T12:04:58.766Z 2026-04-05T12:34:06.357Z
9587187 9587187 20260327113807_iuYCu US0006 2026-03-28T12:04:57.950Z 2026-04-05T12:34:05.898Z
9587131 9587131 20260327112127_aOV4d US0006 2026-03-28T12:04:51.261Z 2026-04-05T12:34:03.497Z
9586721 9586721 20260327091954_yVnNk US0006 2026-03-28T12:03:50.866Z 2026-04-05T12:33:39.200Z
9586579 9586579 20260327082827_GHcnM US0006 2026-03-28T12:03:28.557Z 2026-04-05T12:33:31.352Z
9586437 9586437 20260327073948_spJox US0006 2026-03-28T12:03:06.154Z 2026-04-05T12:33:25.559Z
9586373 9586373 20260327065235_fCq5v US0006 2026-03-28T12:02:56.580Z 2026-04-05T12:33:22.731Z
9586353 9586353 20260327063829_RTSuO US0006 2026-03-28T12:02:53.382Z 2026-04-05T12:33:21.915Z
9586186 9586186 20260327044204_KZXOz US0006 2026-03-28T12:02:28.501Z 2026-04-05T12:33:07.206Z
9585947 9585947 20260327031543_k8PsB US0006 2026-03-28T12:01:49.948Z 2026-04-05T12:32:54.223Z
9583092 9583092 20260326105229_w2HcW US0006 2026-03-27T12:07:40.637Z 2026-04-04T12:40:45.471Z
9583049 9583049 20260326104211_FpB8Y US0006 2026-03-27T12:07:31.793Z 2026-04-04T12:40:43.302Z
9583005 9583005 20260326103432_nyjAG US0006 2026-03-27T12:07:25.676Z 2026-04-04T12:40:39.572Z
9582960 9582960 20260326102045_oIPcx US0006 2026-03-27T12:07:20.572Z 2026-04-04T12:40:38.055Z
9582931 9582931 20260326100224_F81e9 US0006 2026-03-27T12:07:15.849Z 2026-04-04T12:40:36.810Z
9582902 9582902 20260326095908_MtF28 US0006 2026-03-27T12:07:11.023Z 2026-04-04T12:40:35.842Z
9582599 9582599 20260326083722_HGaf8 US0006 2026-03-27T12:06:19.610Z 2026-04-04T12:40:15.310Z
9582528 9582528 20260326081739_egchx US0006 2026-03-27T12:06:04.294Z 2026-04-04T12:40:07.192Z
9582334 9582334 20260326065156_0Mvnc US0006 2026-03-27T12:05:26.596Z 2026-04-04T12:39:51.198Z
9582225 9582225 20260326053200_jEwkD US0006 2026-03-27T12:05:01.697Z 2026-04-04T12:39:43.416Z
9582215 9582215 20260326051832_ZbXmm US0006 2026-03-27T12:04:59.059Z 2026-04-04T12:39:42.594Z
9582024 9582024 20260326042233_iyaPs US0006 2026-03-27T12:04:25.915Z 2026-04-04T12:39:35.185Z
9581906 9581906 20260326041053_Y2R2o US0006 2026-03-27T12:04:07.447Z 2026-04-04T12:39:30.984Z
9578454 9578454 20260325115411_osAHb US0006 2026-03-26T12:07:40.934Z 2026-04-03T12:38:04.282Z
9578214 9578214 20260325104744_anCDV US0006 2026-03-26T12:07:00.626Z 2026-04-03T12:37:43.534Z
9578052 9578052 20260325094510_eTMIs US0006 2026-03-26T12:06:39.233Z 2026-04-03T12:37:35.337Z
9578034 9578034 20260325093530_K1a87 US0006 2026-03-26T12:06:36.755Z 2026-04-03T12:37:34.552Z
9578027 9578027 20260325093447_rD26O US0006 2026-03-26T12:06:36.356Z 2026-04-03T12:37:34.443Z
9577904 9577904 20260325091240_QMqiq US0006 2026-03-26T12:06:19.280Z 2026-04-03T12:37:30.598Z
9577897 9577897 20260325091229_XUfY5 US0006 2026-03-26T12:06:18.721Z 2026-04-03T12:37:30.508Z
9577594 9577594 20260325073854_aN3O3 US0006 2026-03-26T12:05:36.411Z 2026-04-03T12:37:09.892Z
9577446 9577446 20260325061737_zOKM0 US0006 2026-03-26T12:05:10.460Z 2026-04-03T12:37:02.082Z
9577383 9577383 20260325052904_ijehk US0006 2026-03-26T12:04:59.215Z 2026-04-03T12:36:59.642Z
9577366 9577366 20260325051826_AkMRR US0006 2026-03-26T12:04:56.260Z 2026-04-03T12:36:59.020Z
9577111 9577111 20260325035654_4TVup US0006 2026-03-26T12:04:11.042Z 2026-04-03T12:36:34.996Z
9573462 9573462 20260324121602_VTyvc US0006 2026-03-25T12:08:04.319Z 2026-04-02T12:36:10.320Z
9573430 9573430 20260324120725_PiKo5 US0006 2026-03-25T12:07:57.722Z 2026-04-02T12:36:08.605Z
9573190 9573190 20260324113053_iliWo US0006 2026-03-25T12:07:22.938Z 2026-04-02T12:35:59.083Z
9573141 9573141 20260324112319_vOops US0006 2026-03-25T12:07:15.324Z 2026-04-02T12:35:57.232Z
9572948 9572948 20260324105932_mgNiG US0006 2026-03-25T12:06:48.205Z 2026-04-02T12:35:44.573Z
9572906 9572906 20260324104820_30EPu US0006 2026-03-25T12:06:41.947Z 2026-04-02T12:35:43.332Z
9572780 9572780 20260324101742_4UagQ US0006 2026-03-25T12:06:16.229Z 2026-04-02T12:35:37.844Z
9572649 9572649 20260324094400_lbxYl US0006 2026-03-25T12:05:51.494Z 2026-04-02T12:35:32.887Z
9572595 9572595 20260324093608_1bvRw US0006 2026-03-25T12:05:42.474Z 2026-04-02T12:35:31.252Z
9572530 9572530 20260324092339_qCYff US0006 2026-03-25T12:05:29.526Z 2026-04-02T12:35:28.991Z
9572508 9572508 20260324091803_0hj5U US0006 2026-03-25T12:05:24.291Z 2026-04-02T12:35:27.738Z
9572460 9572460 20260324090618_V2IpM US0006 2026-03-25T12:05:15.710Z 2026-04-02T12:35:25.826Z
9572378 9572378 20260324085023_kiWW8 US0006 2026-03-25T12:04:53.084Z 2026-04-02T12:35:22.119Z
9572326 9572326 20260324083331_V6GxO US0006 2026-03-25T12:04:42.387Z 2026-04-02T12:35:14.305Z
9572165 9572165 20260324075850_GyFYE US0006 2026-03-25T12:04:05.547Z 2026-04-02T12:35:06.150Z
9572049 9572049 20260324071640_U8P77 US0006 2026-03-25T12:03:37.057Z 2026-04-02T12:35:01.058Z
9571919 9571919 20260324055758_xHJlD US0006 2026-03-25T12:03:12.539Z 2026-04-02T12:34:55.222Z
9571837 9571837 20260324045521_aQAI3 US0006 2026-03-25T12:02:54.697Z 2026-04-02T12:34:51.239Z
9571714 9571714 20260324034058_6ZtwU US0006 2026-03-25T12:02:28.115Z 2026-04-02T12:34:40.823Z
9564810 9564810 20260323111004_fOcyD US0006 2026-03-24T12:08:50.687Z 2026-03-31T12:27:15.843Z
9564559 9564559 20260323105010_i3aI3 US0006 2026-03-24T12:08:23.317Z 2026-03-31T12:27:11.747Z
9564428 9564428 20260323103436_c8YMm US0006 2026-03-24T12:08:04.283Z 2026-03-31T12:27:09.003Z
9563470 9563470 20260323082439_nqq1j US0006 2026-03-24T12:06:04.703Z 2026-03-31T12:26:43.924Z
9563169 9563169 20260323072807_25gy6 US0006 2026-03-24T12:05:21.006Z 2026-03-31T12:26:37.114Z
9563156 9563156 20260323072226_NiPk3 US0006 2026-03-24T12:05:17.145Z 2026-03-31T12:26:36.699Z

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