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 = "US0007" 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
9609794 9609794 20260405100824_Rt3TT US0007 2026-04-06T12:03:54.368Z 2026-04-06T12:03:54.368Z
9609752 9609752 20260405094257_0WrLv US0007 2026-04-06T12:03:44.214Z 2026-04-06T12:03:44.214Z
9609738 9609738 20260405093637_lOPqf US0007 2026-04-06T12:03:37.044Z 2026-04-06T12:03:37.044Z
9609414 9609414 20260405060751_8cE9M US0007 2026-04-06T12:01:41.808Z 2026-04-06T12:01:41.808Z
9607561 9607561 20260404105806_C9h2A US0007 2026-04-05T12:02:56.317Z 2026-04-06T12:16:14.464Z
9607463 9607463 20260404093557_ZraQj US0007 2026-04-05T12:02:24.501Z 2026-04-06T12:16:14.443Z
9607375 9607375 20260404082041_f3Obl US0007 2026-04-05T12:01:54.369Z 2026-04-06T12:16:14.421Z
9607358 9607358 20260404080936_x2iQS US0007 2026-04-05T12:01:51.767Z 2026-04-06T12:16:14.419Z
9607063 9607063 20260404032353_deKSh US0007 2026-04-05T12:00:18.318Z 2026-04-06T12:16:14.354Z
9605704 9605704 20260403113257_An0mN US0007 2026-04-04T12:03:31.642Z 2026-04-06T12:18:13.971Z
9605479 9605479 20260403101139_KnHK0 US0007 2026-04-04T12:02:30.536Z 2026-04-06T12:17:55.119Z
9603719 9603719 20260402115752_k6jN3 US0007 2026-04-03T12:04:18.352Z 2026-04-06T12:22:24.456Z
9603579 9603579 20260402110912_zDc3B US0007 2026-04-03T12:03:42.848Z 2026-04-06T12:22:14.646Z
9603519 9603519 20260402104627_4ogtB US0007 2026-04-03T12:03:19.679Z 2026-04-06T12:22:07.806Z
9603477 9603477 20260402103153_wwDQr US0007 2026-04-03T12:03:11.282Z 2026-04-06T12:22:04.841Z
9603288 9603288 20260402091803_Dm0ww US0007 2026-04-03T12:02:30.839Z 2026-04-06T12:21:51.062Z
9603271 9603271 20260402091237_dYcqj US0007 2026-04-03T12:02:28.705Z 2026-04-06T12:21:50.387Z
9603157 9603157 20260402081852_MqZgg US0007 2026-04-03T12:02:00.371Z 2026-04-06T12:21:40.549Z
9603072 9603072 20260402073643_NA8HY US0007 2026-04-03T12:01:40.460Z 2026-04-06T12:21:32.607Z
9593351 9593351 20260329093726_TqCnF US0007 2026-03-30T12:03:41.769Z 2026-04-06T12:35:13.754Z
9593292 9593292 20260329085553_ik08q US0007 2026-03-30T12:03:30.524Z 2026-04-06T12:35:02.145Z
9590530 9590530 20260328095215_nH5gL US0007 2026-03-29T12:02:52.028Z 2026-04-06T12:38:22.826Z
9586969 9586969 20260327103514_v4RNR US0007 2026-03-28T12:04:28.763Z 2026-04-05T12:33:56.655Z
9586878 9586878 20260327100355_qbq22 US0007 2026-03-28T12:04:16.593Z 2026-04-05T12:33:52.790Z
9578455 9578455 20260325115411_osAHb US0007 2026-03-26T12:07:40.934Z 2026-04-03T12:38:04.282Z
9578392 9578392 20260325114112_l0b1i US0007 2026-03-26T12:07:29.634Z 2026-04-03T12:38:01.713Z
9578215 9578215 20260325104744_anCDV US0007 2026-03-26T12:07:00.626Z 2026-04-03T12:37:43.534Z
9578092 9578092 20260325095928_zWDFb US0007 2026-03-26T12:06:43.961Z 2026-04-03T12:37:36.834Z
9578028 9578028 20260325093447_rD26O US0007 2026-03-26T12:06:36.356Z 2026-04-03T12:37:34.443Z
9577987 9577987 20260325092607_b5GPp US0007 2026-03-26T12:06:30.943Z 2026-04-03T12:37:33.332Z
9577915 9577915 20260325091353_XjBoO US0007 2026-03-26T12:06:20.602Z 2026-04-03T12:37:30.885Z
9577905 9577905 20260325091240_QMqiq US0007 2026-03-26T12:06:19.280Z 2026-04-03T12:37:30.598Z
9577827 9577827 20260325085415_F1E3w US0007 2026-03-26T12:06:10.269Z 2026-04-03T12:37:28.525Z
9573137 9573137 20260324112319_sKvFX US0007 2026-03-25T12:07:14.957Z 2026-04-02T12:35:57.093Z
9556219 9556219 20260322093549_1qOc2 US0007 2026-03-23T12:04:29.272Z 2026-03-30T12:28:47.634Z
9555232 9555232 20260322042800_W7xGh US0007 2026-03-23T12:03:16.973Z 2026-03-30T12:28:23.447Z
9546238 9546238 20260321114606_EaoPo US0007 2026-03-22T12:11:22.307Z 2026-03-29T12:19:48.746Z
9545424 9545424 20260321103321_j9rIx US0007 2026-03-22T12:09:24.157Z 2026-03-29T12:19:39.996Z
9544886 9544886 20260321093640_wjb7X US0007 2026-03-22T12:08:03.735Z 2026-03-29T12:19:34.891Z
9544007 9544007 20260321065909_UOiKY US0007 2026-03-22T12:05:27.904Z 2026-03-29T12:19:15.173Z
9543993 9543993 20260321065638_3ilO5 US0007 2026-03-22T12:05:24.110Z 2026-03-29T12:19:14.964Z
9543848 9543848 20260321054548_4yuff US0007 2026-03-22T12:04:55.521Z 2026-03-29T12:19:13.012Z
9543711 9543711 20260321045426_Xya5F US0007 2026-03-22T12:04:30.950Z 2026-03-29T12:19:10.418Z
9537551 9537551 20260320114635_45jkQ US0007 2026-03-21T12:15:59.979Z 2026-03-28T12:35:27.091Z
9536125 9536125 20260320091440_cISy4 US0007 2026-03-21T12:12:39.817Z 2026-03-28T12:34:57.887Z
9535100 9535100 20260320053521_LbGSO US0007 2026-03-21T12:09:44.713Z 2026-03-28T12:34:27.256Z
9534789 9534789 20260320042519_x3y6D US0007 2026-03-21T12:08:55.118Z 2026-03-28T12:34:22.171Z
9524446 9524446 20260319115755_oJEIQ US0007 2026-03-20T12:13:00.771Z 2026-03-27T12:41:52.854Z
9524176 9524176 20260319112736_9IGwj US0007 2026-03-20T12:12:34.655Z 2026-03-27T12:41:49.436Z
9523822 9523822 20260319104828_q6aQm US0007 2026-03-20T12:12:03.282Z 2026-03-27T12:41:45.615Z
9522991 9522991 20260319091525_ttg2v US0007 2026-03-20T12:10:42.748Z 2026-03-27T12:41:23.808Z
9522895 9522895 20260319090427_UjC34 US0007 2026-03-20T12:10:32.128Z 2026-03-27T12:41:22.618Z
9522310 9522310 20260319072425_OlhzL US0007 2026-03-20T12:09:35.321Z 2026-03-27T12:41:16.634Z
9522009 9522009 20260319051043_ADFZg US0007 2026-03-20T12:08:50.748Z 2026-03-27T12:41:12.672Z
9521515 9521515 20260319042315_6lbuo US0007 2026-03-20T12:08:09.948Z 2026-03-27T12:40:55.442Z
9514597 9514597 20260318114317_MpRWy US0007 2026-03-19T12:17:53.711Z 2026-03-26T12:38:17.594Z
9514478 9514478 20260318113126_5E9IO US0007 2026-03-19T12:17:37.345Z 2026-03-26T12:38:16.744Z
9514260 9514260 20260318110246_Crbs3 US0007 2026-03-19T12:17:02.457Z 2026-03-26T12:38:14.904Z
9513770 9513770 20260318100144_j3Hyu US0007 2026-03-19T12:16:11.486Z 2026-03-26T12:38:05.887Z
9513321 9513321 20260318085628_9nMD8 US0007 2026-03-19T12:14:54.646Z 2026-03-26T12:37:54.092Z
9513061 9513061 20260318082717_hPKiL US0007 2026-03-19T12:14:15.436Z 2026-03-26T12:37:51.193Z
9512955 9512955 20260318080920_cyb2k US0007 2026-03-19T12:14:00.602Z 2026-03-26T12:37:50.460Z
9512794 9512794 20260318075001_PbB8k US0007 2026-03-19T12:13:36.746Z 2026-03-26T12:37:49.076Z
9512399 9512399 20260318054919_a5kZp US0007 2026-03-19T12:12:25.225Z 2026-03-26T12:37:44.889Z
9504367 9504367 20260317112758_ILt5M US0007 2026-03-18T12:07:53.268Z 2026-03-25T12:42:21.299Z
9503996 9503996 20260317102237_gOqvN US0007 2026-03-18T12:06:56.159Z 2026-03-25T12:42:19.032Z
9503053 9503053 20260317075044_NTbat US0007 2026-03-18T12:04:46.365Z 2026-03-25T12:42:11.263Z
9502789 9502789 20260317062508_iTXbn US0007 2026-03-18T12:04:03.645Z 2026-03-25T12:41:59.447Z
9502684 9502684 20260317053219_UbT2J US0007 2026-03-18T12:03:43.743Z 2026-03-25T12:41:57.336Z
9502501 9502501 20260317041627_HWN9T US0007 2026-03-18T12:03:04.388Z 2026-03-25T12:41:50.623Z
9488677 9488677 20260315120838_YeYjq US0007 2026-03-16T12:15:38.447Z 2026-03-23T12:22:32.128Z
9487375 9487375 20260315100534_Wl6F0 US0007 2026-03-16T12:12:41.582Z 2026-03-23T12:22:14.613Z
9487319 9487319 20260315095352_NGjGU US0007 2026-03-16T12:12:31.386Z 2026-03-23T12:22:13.910Z
9487200 9487200 20260315093532_2jjrq US0007 2026-03-16T12:12:10.777Z 2026-03-23T12:22:10.792Z
9487118 9487118 20260315092718_4LgZD US0007 2026-03-16T12:11:56.123Z 2026-03-23T12:22:09.803Z
9487071 9487071 20260315092335_N66vB US0007 2026-03-16T12:11:51.333Z 2026-03-23T12:22:09.535Z
9486647 9486647 20260315081219_msxVt US0007 2026-03-16T12:10:35.320Z 2026-03-23T12:22:01.799Z
9486378 9486378 20260315070009_eru0I US0007 2026-03-16T12:09:42.435Z 2026-03-23T12:21:56.968Z
9486222 9486222 20260315055315_frS9A US0007 2026-03-16T12:09:10.903Z 2026-03-23T12:21:56.039Z
9486204 9486204 20260315054452_J5oFL US0007 2026-03-16T12:09:07.219Z 2026-03-23T12:21:55.949Z
9486115 9486115 20260315045532_cQ7hi US0007 2026-03-16T12:08:43.290Z 2026-03-23T12:21:55.442Z
9477710 9477710 20260314060737_Hw1Gk US0007 2026-03-15T12:08:54.052Z 2026-03-22T12:42:04.685Z
9477474 9477474 20260314045926_orGj7 US0007 2026-03-15T12:08:22.253Z 2026-03-22T12:42:02.997Z
9471270 9471270 20260313093647_uTkD2 US0007 2026-03-14T12:09:53.910Z 2026-03-21T12:49:19.415Z
9471193 9471193 20260313091957_u9w9z US0007 2026-03-14T12:09:39.071Z 2026-03-21T12:49:18.516Z
9471116 9471116 20260313090858_OC8kL US0007 2026-03-14T12:09:28.735Z 2026-03-21T12:49:17.931Z
9471082 9471082 20260313085717_DS46N US0007 2026-03-14T12:09:23.552Z 2026-03-21T12:49:17.602Z
9471021 9471021 20260313084449_MWalD US0007 2026-03-14T12:09:11.497Z 2026-03-21T12:49:16.913Z
9470849 9470849 20260313075836_ReNl4 US0007 2026-03-14T12:08:38.212Z 2026-03-21T12:49:14.575Z
9470746 9470746 20260313073614_3S2pG US0007 2026-03-14T12:08:18.434Z 2026-03-21T12:49:13.267Z
9466140 9466140 20260312120336_Bn8MW US0007 2026-03-13T12:11:35.592Z 2026-03-20T12:37:07.951Z
9466132 9466132 20260312120335_rG92k US0007 2026-03-13T12:11:35.188Z 2026-03-20T12:37:07.922Z
9466075 9466075 20260312114556_8sFNK US0007 2026-03-13T12:11:24.645Z 2026-03-20T12:37:07.486Z
9465829 9465829 20260312110214_QWoBl US0007 2026-03-13T12:10:47.765Z 2026-03-20T12:37:06.084Z
9464818 9464818 20260312074602_24DhX US0007 2026-03-13T12:08:22.846Z 2026-03-20T12:36:55.888Z
9463972 9463972 20260312031156_7M8Ka US0007 2026-03-13T12:05:45.838Z 2026-03-20T12:36:26.073Z
9458653 9458653 20260311103026_tS2Cl US0007 2026-03-12T12:06:38.426Z 2026-03-19T12:45:00.618Z
9458433 9458433 20260311095256_we0Qz US0007 2026-03-12T12:06:09.059Z 2026-03-19T12:44:58.785Z
9458404 9458404 20260311094702_3PZ7M US0007 2026-03-12T12:06:05.115Z 2026-03-19T12:44:58.577Z
9458111 9458111 20260311083459_MBlSC US0007 2026-03-12T12:05:27.198Z 2026-03-19T12:44:56.028Z

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