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

7,247 rows where station_code = "US003S" 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
9583008 9583008 20260326103432_nyjAG US003S 2026-03-27T12:07:25.676Z 2026-04-04T12:40:39.572Z
9582963 9582963 20260326102821_faO5V US003S 2026-03-27T12:07:20.995Z 2026-04-04T12:40:38.233Z
9582900 9582900 20260326095826_ZTaxE US003S 2026-03-27T12:07:10.547Z 2026-04-04T12:40:35.677Z
9582828 9582828 20260326094238_wJnTC US003S 2026-03-27T12:06:56.301Z 2026-04-04T12:40:30.856Z
9582673 9582673 20260326090119_jUQju US003S 2026-03-27T12:06:30.494Z 2026-04-04T12:40:18.388Z
9582619 9582619 20260326084136_d8czw US003S 2026-03-27T12:06:21.939Z 2026-04-04T12:40:15.861Z
9582601 9582601 20260326083722_HGaf8 US003S 2026-03-27T12:06:19.611Z 2026-04-04T12:40:15.310Z
9582535 9582535 20260326081822_b1jqW US003S 2026-03-27T12:06:04.819Z 2026-04-04T12:40:07.473Z
9582531 9582531 20260326081739_egchx US003S 2026-03-27T12:06:04.294Z 2026-04-04T12:40:07.192Z
9582493 9582493 20260326080148_IPRXU US003S 2026-03-27T12:05:57.913Z 2026-04-04T12:40:04.466Z
9582447 9582447 20260326073342_gEkY2 US003S 2026-03-27T12:05:47.381Z 2026-04-04T12:40:01.355Z
9582420 9582420 20260326072113_8lx8n US003S 2026-03-27T12:05:43.468Z 2026-04-04T12:40:00.330Z
9582402 9582402 20260326071812_AGqgT US003S 2026-03-27T12:05:40.170Z 2026-04-04T12:39:59.609Z
9582263 9582263 20260326055507_7yawr US003S 2026-03-27T12:05:09.683Z 2026-04-04T12:39:47.424Z
9582099 9582099 20260326043627_Rejlu US003S 2026-03-27T12:04:37.192Z 2026-04-04T12:39:37.637Z
9582047 9582047 20260326042330_CK5cn US003S 2026-03-27T12:04:28.447Z 2026-04-04T12:39:35.941Z
9581443 9581443 20260326031409_WgOgu US003S 2026-03-27T12:03:08.715Z 2026-04-04T12:39:06.063Z
9537426 9537426 20260320113656_D2vV3 US003S 2026-03-21T12:15:45.391Z 2026-03-28T12:35:25.916Z
9537302 9537302 20260320112714_PqpSy US003S 2026-03-21T12:15:31.282Z 2026-03-28T12:35:24.494Z
9537158 9537158 20260320111127_lETIT US003S 2026-03-21T12:15:10.732Z 2026-03-28T12:35:22.379Z
9536693 9536693 20260320101934_xK3Dy US003S 2026-03-21T12:14:07.090Z 2026-03-28T12:35:05.282Z
9536314 9536314 20260320093342_ubf3H US003S 2026-03-21T12:13:05.620Z 2026-03-28T12:34:59.616Z
9536236 9536236 20260320092701_DJKzJ US003S 2026-03-21T12:12:53.149Z 2026-03-28T12:34:58.783Z
9536017 9536017 20260320090007_aMcxm US003S 2026-03-21T12:12:23.064Z 2026-03-28T12:34:55.424Z
9535793 9535793 20260320083420_lj7Af US003S 2026-03-21T12:11:53.826Z 2026-03-28T12:34:51.382Z
9535590 9535590 20260320080534_xsmxo US003S 2026-03-21T12:11:16.136Z 2026-03-28T12:34:47.434Z
9535431 9535431 20260320073206_p6oKL US003S 2026-03-21T12:10:45.945Z 2026-03-28T12:34:34.817Z
9535347 9535347 20260320071319_4Fmm4 US003S 2026-03-21T12:10:27.313Z 2026-03-28T12:34:33.353Z
9535169 9535169 20260320055619_bK3wU US003S 2026-03-21T12:09:56.506Z 2026-03-28T12:34:28.689Z
9535134 9535134 20260320054835_CMd2X US003S 2026-03-21T12:09:51.867Z 2026-03-28T12:34:28.047Z
9535035 9535035 20260320051517_bGkvg US003S 2026-03-21T12:09:32.753Z 2026-03-28T12:34:26.083Z
9535013 9535013 20260320050438_kbvcR US003S 2026-03-21T12:09:29.315Z 2026-03-28T12:34:25.355Z
9534983 9534983 20260320045540_dmO3h US003S 2026-03-21T12:09:23.681Z 2026-03-28T12:34:24.696Z
9496304 9496304 20260316111326_WKfAL US003S 2026-03-17T12:09:31.181Z 2026-03-24T12:41:19.134Z
9496172 9496172 20260316105317_opZsI US003S 2026-03-17T12:09:12.825Z 2026-03-24T12:41:18.648Z
9448872 9448872 20260309121441_jqrvZ US003S 2026-03-10T12:11:14.267Z 2026-03-17T12:42:23.865Z
9448628 9448628 20260309111912_56ToK US003S 2026-03-10T12:10:27.292Z 2026-03-17T12:42:21.173Z
9448601 9448601 20260309111717_RsHg6 US003S 2026-03-10T12:10:23.776Z 2026-03-17T12:42:21.107Z
9448509 9448509 20260309110004_OlRJY US003S 2026-03-10T12:10:04.955Z 2026-03-17T12:42:20.343Z
9448344 9448344 20260309102924_o32Lr US003S 2026-03-10T12:09:36.771Z 2026-03-17T12:42:15.442Z
9448208 9448208 20260309100831_fGhLz US003S 2026-03-10T12:09:11.433Z 2026-03-17T12:42:06.554Z
9447982 9447982 20260309093246_ambQi US003S 2026-03-10T12:08:32.408Z 2026-03-17T12:41:58.894Z
9447916 9447916 20260309091843_TxQWh US003S 2026-03-10T12:08:16.951Z 2026-03-17T12:41:58.288Z
9447892 9447892 20260309091428_MIsm6 US003S 2026-03-10T12:08:12.136Z 2026-03-17T12:41:57.855Z
9447889 9447889 20260309091423_W3Xbz US003S 2026-03-10T12:08:11.648Z 2026-03-17T12:41:57.783Z
9367714 9367714 20260222123950_SdZmw US003S 2026-02-23T14:11:04.559Z 2026-02-24T14:17:43.881Z
9367693 9367693 20260222123838_7o6L2 US003S 2026-02-23T14:11:02.622Z 2026-02-24T14:17:43.289Z
9367645 9367645 20260222123240_c6a5n US003S 2026-02-23T14:10:54.034Z 2026-02-24T14:17:39.914Z
9367507 9367507 20260222121642_y6jZz US003S 2026-02-23T14:10:35.533Z 2026-02-24T14:17:29.289Z
9367492 9367492 20260222121602_HI41c US003S 2026-02-23T14:10:33.708Z 2026-02-24T14:17:28.535Z
9367306 9367306 20260222115540_Yh2B3 US003S 2026-02-23T14:10:08.341Z 2026-02-24T14:17:17.903Z
9367246 9367246 20260222114854_Jo8de US003S 2026-02-23T14:09:56.687Z 2026-02-24T14:17:08.121Z
9367094 9367094 20260222112618_KYJZ6 US003S 2026-02-23T14:09:26.720Z 2026-02-24T14:16:57.579Z
9366897 9366897 20260222105334_Lwkqr US003S 2026-02-23T14:08:54.500Z 2026-02-24T14:16:45.703Z
9366739 9366739 20260222102526_rlabv US003S 2026-02-23T14:08:27.273Z 2026-02-24T14:16:35.715Z
9365923 9365923 20260222072821_eTJhG US003S 2026-02-23T14:05:36.936Z 2026-02-24T14:15:46.896Z
9361210 9361210 20260221125013_6yph7 US003S 2026-02-22T14:09:52.793Z 2026-03-02T14:21:39.650Z
9361117 9361117 20260221124254_YyDt3 US003S 2026-02-22T14:09:39.287Z 2026-03-02T14:21:35.184Z
9360956 9360956 20260221122251_iWq8n US003S 2026-02-22T14:09:13.011Z 2026-03-02T14:21:33.423Z
9360542 9360542 20260221113845_K1Qt7 US003S 2026-02-22T14:08:08.771Z 2026-03-02T14:21:28.108Z
9360516 9360516 20260221113601_1cwuJ US003S 2026-02-22T14:08:04.264Z 2026-03-02T14:21:27.853Z
9360418 9360418 20260221112456_gBnsz US003S 2026-02-22T14:07:49.416Z 2026-03-02T14:21:26.794Z
9360368 9360368 20260221111424_8rsAE US003S 2026-02-22T14:07:38.911Z 2026-03-02T14:21:26.271Z
9342039 9342039 20260219120438_W5bNr US003S 2026-02-20T14:00:57.945Z 2026-02-28T14:43:56.934Z
9341960 9341960 20260219114610_0qjyz US003S 2026-02-20T14:00:57.786Z 2026-02-28T14:43:55.664Z
9341874 9341874 20260219111712_IsHQe US003S 2026-02-20T14:00:57.633Z 2026-02-28T14:43:54.833Z
9328072 9328072 20260215095835_Kr77F US003S 2026-02-16T14:07:13.081Z 2026-02-24T14:42:06.500Z
9327965 9327965 20260215093111_PS2mp US003S 2026-02-16T14:06:46.564Z 2026-02-24T14:42:05.331Z
9327925 9327925 20260215091947_XjKF4 US003S 2026-02-16T14:06:33.288Z 2026-02-24T14:42:04.156Z
9327815 9327815 20260215084402_6zxAS US003S 2026-02-16T14:06:04.583Z 2026-02-24T14:42:01.984Z
9327645 9327645 20260215075142_OGYM3 US003S 2026-02-16T14:05:21.947Z 2026-02-24T14:41:58.927Z
9327608 9327608 20260215072640_efN26 US003S 2026-02-16T14:05:13.269Z 2026-02-24T14:41:58.361Z
9327562 9327562 20260215070103_R2hwI US003S 2026-02-16T14:05:01.591Z 2026-02-24T14:41:57.037Z
9327422 9327422 20260215053749_9mO1b US003S 2026-02-16T14:04:16.529Z 2026-02-24T14:41:53.936Z
9327404 9327404 20260215053140_H8A5y US003S 2026-02-16T14:04:10.727Z 2026-02-24T14:41:53.472Z
9327383 9327383 20260215052718_FczPU US003S 2026-02-16T14:04:03.494Z 2026-02-24T14:41:52.959Z
9311944 9311944 20260210052405_Xc4jp US003S 2026-02-11T14:02:24.963Z 2026-02-18T14:55:37.600Z
9300070 9300070 20260207120503_2mSGA US003S 2026-02-08T14:07:44.010Z 2026-02-16T14:57:24.108Z
9300026 9300026 20260207115825_CI2xw US003S 2026-02-08T14:07:36.490Z 2026-02-16T14:57:16.334Z
9300009 9300009 20260207115209_O4x7O US003S 2026-02-08T14:07:32.448Z 2026-02-16T14:57:15.038Z
9299915 9299915 20260207113837_mJ3XW US003S 2026-02-08T14:07:11.411Z 2026-02-16T14:57:08.479Z
9299707 9299707 20260207110124_lIbT3 US003S 2026-02-08T14:06:22.742Z 2026-02-16T14:56:57.165Z
9299671 9299671 20260207105051_Egak7 US003S 2026-02-08T14:06:12.443Z 2026-02-16T14:56:50.144Z
9299496 9299496 20260207101431_0DCC0 US003S 2026-02-08T14:05:28.600Z 2026-02-16T14:56:38.297Z
9299396 9299396 20260207095145_CPKKt US003S 2026-02-08T14:05:02.203Z 2026-02-16T14:56:32.226Z
9299368 9299368 20260207094343_XvxG8 US003S 2026-02-08T14:04:55.700Z 2026-02-16T14:56:25.480Z
9299107 9299107 20260207083242_wDQzy US003S 2026-02-08T14:03:36.276Z 2026-02-16T14:56:08.239Z
9299033 9299033 20260207072658_sHQ6B US003S 2026-02-08T14:03:09.784Z 2026-02-16T14:55:57.192Z
9299020 9299020 20260207071807_cvSCK US003S 2026-02-08T14:03:04.797Z 2026-02-16T14:55:55.889Z
9298994 9298994 20260207070300_MDZry US003S 2026-02-08T14:02:53.065Z 2026-02-16T14:55:53.889Z
9298993 9298993 20260207070228_s80f1 US003S 2026-02-08T14:02:51.824Z 2026-02-16T14:55:52.422Z
9298943 9298943 20260207061733_xN5pt US003S 2026-02-08T14:02:37.499Z 2026-02-16T14:55:48.848Z
9298932 9298932 20260207061241_icTlr US003S 2026-02-08T14:02:29.870Z 2026-02-16T14:55:47.894Z
9298827 9298827 20260207052135_N5P06 US003S 2026-02-08T14:01:55.843Z 2026-02-16T14:55:41.200Z
9298786 9298786 20260207050737_3ZBD7 US003S 2026-02-08T14:01:41.009Z 2026-02-16T14:55:38.383Z
9298449 9298449 20260206024958_763oy US003S 2026-02-07T14:23:26.382Z 2026-02-14T15:06:36.157Z
9298363 9298363 20260206020624_N2JUa US003S 2026-02-07T14:22:54.634Z 2026-02-14T15:06:22.022Z
9298325 9298325 20260206014240_mtPYK US003S 2026-02-07T14:22:44.459Z 2026-02-14T15:06:19.016Z
9298309 9298309 20260206012712_ip35g US003S 2026-02-07T14:22:41.363Z 2026-02-14T15:06:17.954Z
9296103 9296103 20260206111748_oerUt US003S 2026-02-07T14:07:04.431Z 2026-02-15T14:57:15.513Z

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