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 = "US003N" 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
8687251 8687251 20251204061227_AgtSo US003N 2025-12-05T14:14:30.261Z 2025-12-06T14:22:41.823Z
8687200 8687200 20251204054342_T88Mx US003N 2025-12-05T14:14:22.858Z 2025-12-06T14:22:37.974Z
8687185 8687185 20251204053723_x6Pt8 US003N 2025-12-05T14:14:20.290Z 2025-12-06T14:22:36.435Z
8687131 8687131 20251204051300_5uXu3 US003N 2025-12-05T14:13:59.582Z 2025-12-06T14:22:32.960Z
8686972 8686972 20251203231527_6B2xN US003N 2025-12-05T14:13:17.711Z 2025-12-06T14:22:21.564Z
8684150 8684150 20251204105530_gRmup US003N 2025-12-05T14:02:02.838Z 2025-12-06T14:18:00.428Z
8683784 8683784 20251204080713_7q5o9 US003N 2025-12-05T14:00:34.049Z 2025-12-06T14:18:00.329Z
8683766 8683766 20251204075100_2Som3 US003N 2025-12-05T14:00:30.349Z 2025-12-06T14:18:00.323Z
8683755 8683755 20251204074155_SOXgx US003N 2025-12-05T14:00:28.029Z 2025-12-06T14:18:00.320Z
8683747 8683747 20251204074004_fxDYw US003N 2025-12-05T14:00:26.076Z 2025-12-06T14:18:00.319Z
8674335 8674335 20251202020355_y4WB6 US003N 2025-12-03T14:21:25.747Z 2025-12-06T14:34:04.869Z
8673985 8673985 20251202005702_s6W3j US003N 2025-12-03T14:20:38.035Z 2025-12-06T14:33:43.814Z
8648489 8648489 20251129080621_Avmgp US003N 2025-11-30T14:30:15.295Z 2025-12-06T14:57:45.276Z
8648244 8648244 20251129071215_1i7f2 US003N 2025-11-30T14:29:59.160Z 2025-12-06T14:57:24.703Z
8647301 8647301 20251129041743_qod3S US003N 2025-11-30T14:27:57.470Z 2025-12-06T14:56:36.118Z
8646879 8646879 20251129030558_bgSmP US003N 2025-11-30T14:27:04.242Z 2025-12-06T14:56:27.005Z
8646832 8646832 20251129030011_UcSNc US003N 2025-11-30T14:27:00.900Z 2025-12-06T14:56:26.120Z
8646719 8646719 20251129024157_z26KY US003N 2025-11-30T14:26:42.381Z 2025-12-06T14:56:23.942Z
8646305 8646305 20251129014319_slLF7 US003N 2025-11-30T14:25:48.933Z 2025-12-06T14:55:56.152Z
8646179 8646179 20251129012003_2fxBP US003N 2025-11-30T14:25:22.122Z 2025-12-06T14:55:42.914Z
8646108 8646108 20251129010631_79A3D US003N 2025-11-30T14:25:12.603Z 2025-12-06T14:55:33.841Z
8639511 8639511 20251129111409_mJSHU US003N 2025-11-30T14:05:10.813Z 2025-12-06T14:43:43.211Z
8639253 8639253 20251129104941_OysJU US003N 2025-11-30T14:04:15.968Z 2025-12-06T14:43:37.115Z
8639250 8639250 20251129104925_lz7ne US003N 2025-11-30T14:04:15.510Z 2025-12-06T14:43:37.057Z
8639191 8639191 20251129103812_AN29R US003N 2025-11-30T14:04:05.833Z 2025-12-06T14:43:35.940Z
8639175 8639175 20251129103702_XbhWM US003N 2025-11-30T14:04:03.075Z 2025-12-06T14:43:35.643Z
8639141 8639141 20251129103247_e4c3M US003N 2025-11-30T14:03:51.180Z 2025-12-06T14:43:34.646Z
8639058 8639058 20251129102100_HXxlf US003N 2025-11-30T14:03:36.890Z 2025-12-06T14:43:10.283Z
8639000 8639000 20251129101541_gp88C US003N 2025-11-30T14:03:20.615Z 2025-12-06T14:43:07.751Z
8638941 8638941 20251129100601_B0twx US003N 2025-11-30T14:03:03.198Z 2025-12-06T14:43:06.206Z
8638848 8638848 20251129095320_67MUm US003N 2025-11-30T14:02:35.607Z 2025-12-06T14:43:02.354Z
8638828 8638828 20251129095002_UdwBy US003N 2025-11-30T14:02:32.709Z 2025-12-06T14:43:01.960Z
8638803 8638803 20251129094422_gxH22 US003N 2025-11-30T14:02:28.465Z 2025-12-06T14:43:01.233Z
8638781 8638781 20251129094056_YJk3w US003N 2025-11-30T14:02:21.123Z 2025-12-06T14:43:00.672Z
8638633 8638633 20251129091634_1t7UR US003N 2025-11-30T14:01:45.407Z 2025-12-06T14:42:57.123Z
8638255 8638255 20251129081132_yE2rm US003N 2025-11-30T14:00:13.337Z 2025-12-06T14:42:45.777Z
8638097 8638097 20251128082518_C6FQy US003N 2025-11-29T14:28:29.908Z 2025-12-06T15:04:07.977Z
8638090 8638090 20251128082155_NnrLC US003N 2025-11-29T14:28:29.214Z 2025-12-06T15:04:07.880Z
8638072 8638072 20251128081816_DCsH3 US003N 2025-11-29T14:28:28.056Z 2025-12-06T15:04:07.566Z
8638033 8638033 20251128080856_dQWzB US003N 2025-11-29T14:28:25.687Z 2025-12-06T15:04:07.207Z
8637988 8637988 20251128075009_w0jom US003N 2025-11-29T14:28:22.473Z 2025-12-06T15:04:06.554Z
8637969 8637969 20251128074424_Bftpk US003N 2025-11-29T14:28:21.007Z 2025-12-06T15:04:06.273Z
8637890 8637890 20251128072053_tp3SR US003N 2025-11-29T14:27:58.900Z 2025-12-06T15:04:05.406Z
8626927 8626927 20251128095906_S0iHm US003N 2025-11-29T14:02:05.523Z 2025-12-06T14:51:09.190Z
8626762 8626762 20251128093305_017Jj US003N 2025-11-29T14:01:26.729Z 2025-12-06T14:50:41.933Z
8626739 8626739 20251128093132_JplPA US003N 2025-11-29T14:01:24.995Z 2025-12-06T14:50:41.730Z
8626700 8626700 20251128092154_dNlf7 US003N 2025-11-29T14:01:15.171Z 2025-12-06T14:50:40.894Z
8626517 8626517 20251128085148_Z42At US003N 2025-11-29T14:00:36.591Z 2025-12-06T14:50:35.173Z
8626515 8626515 20251128085138_aasAE US003N 2025-11-29T14:00:36.121Z 2025-12-06T14:50:35.122Z
8626458 8626458 20251128084600_8o22b US003N 2025-11-29T14:00:23.093Z 2025-12-06T14:50:34.396Z
8624482 8624482 20251127050420_eN6Op US003N 2025-11-28T14:24:47.558Z 2025-12-05T15:05:06.631Z
8624380 8624380 20251127043234_ao14F US003N 2025-11-28T14:24:34.312Z 2025-12-05T15:05:01.218Z
8624335 8624335 20251127041800_QUTzz US003N 2025-11-28T14:24:29.099Z 2025-12-05T15:04:59.472Z
8624291 8624291 20251127040242_B2re6 US003N 2025-11-28T14:24:25.078Z 2025-12-05T15:04:57.971Z
8624236 8624236 20251127034536_ALJBe US003N 2025-11-28T14:24:19.679Z 2025-12-05T15:04:55.709Z
8624228 8624228 20251127034509_mSe0y US003N 2025-11-28T14:24:19.027Z 2025-12-05T15:04:55.595Z
8624177 8624177 20251127032638_yD1m7 US003N 2025-11-28T14:23:56.519Z 2025-12-05T15:04:51.710Z
8624137 8624137 20251127031602_JoHhQ US003N 2025-11-28T14:23:51.464Z 2025-12-05T15:04:48.058Z
8624080 8624080 20251127030203_D2vG6 US003N 2025-11-28T14:23:44.467Z 2025-12-05T15:04:43.846Z
8623870 8623870 20251127021823_O3kwW US003N 2025-11-28T14:23:01.818Z 2025-12-05T15:04:23.781Z
8623807 8623807 20251127020542_i5Kvh US003N 2025-11-28T14:22:55.188Z 2025-12-05T15:04:18.037Z
8623803 8623803 20251127020516_b0Kga US003N 2025-11-28T14:22:54.942Z 2025-12-05T15:04:17.825Z
8623787 8623787 20251127020330_rMDfy US003N 2025-11-28T14:22:52.848Z 2025-12-05T15:04:16.843Z
8623764 8623764 20251127015616_L8g3C US003N 2025-11-28T14:22:50.124Z 2025-12-05T15:04:15.249Z
8623577 8623577 20251127011159_0ZCWJ US003N 2025-11-28T14:22:12.358Z 2025-12-05T15:04:03.689Z
8623520 8623520 20251127005749_NKyvS US003N 2025-11-28T14:22:05.465Z 2025-12-05T15:03:58.403Z
8623509 8623509 20251127005610_D7rza US003N 2025-11-28T14:22:04.255Z 2025-12-05T15:03:58.153Z
8623240 8623240 20251126232913_fPDom US003N 2025-11-28T14:21:19.836Z 2025-12-05T15:03:40.188Z
8623196 8623196 20251126231840_5b2pj US003N 2025-11-28T14:21:04.175Z 2025-12-05T15:03:37.961Z
8623147 8623147 20251126230437_In4GU US003N 2025-11-28T14:20:57.660Z 2025-12-05T15:03:32.775Z
8623107 8623107 20251126225402_WTrTk US003N 2025-11-28T14:20:53.404Z 2025-12-05T15:03:30.017Z
8602931 8602931 20251125053406_jYSa2 US003N 2025-11-26T14:26:28.648Z 2025-12-02T15:09:33.594Z
8592813 8592813 20251124092837_Ekkmi US003N 2025-11-25T14:28:02.791Z 2025-11-25T14:28:12.982Z
8592806 8592806 20251124092805_SgyuM US003N 2025-11-25T14:27:52.875Z 2025-12-02T15:13:07.685Z
8592775 8592775 20251124092342_523T8 US003N 2025-11-25T14:27:46.226Z 2025-12-02T15:13:07.394Z
8592709 8592709 20251124090516_VrHjK US003N 2025-11-25T14:27:30.351Z 2025-12-02T15:13:06.660Z
8592704 8592704 20251124090211_RXU40 US003N 2025-11-25T14:27:29.935Z 2025-12-02T15:13:06.543Z
8592689 8592689 20251124090105_RCvDA US003N 2025-11-25T14:27:28.373Z 2025-12-02T15:13:06.419Z
8592681 8592681 20251124085802_YS938 US003N 2025-11-25T14:27:27.279Z 2025-12-02T15:13:06.359Z
8592661 8592661 20251124085348_Anhpl US003N 2025-11-25T14:27:25.133Z 2025-12-02T15:13:06.130Z
8592646 8592646 20251124085128_6arXf US003N 2025-11-25T14:27:23.798Z 2025-12-02T15:13:06.051Z
8592566 8592566 20251124082907_CAyTr US003N 2025-11-25T14:27:14.484Z 2025-12-02T15:13:05.339Z
8592515 8592515 20251124080936_kjeFN US003N 2025-11-25T14:26:53.737Z 2025-12-02T15:13:04.696Z
8592506 8592506 20251124080844_kvdW0 US003N 2025-11-25T14:26:53.180Z 2025-12-02T15:13:04.685Z
8592502 8592502 20251124080642_t4jpj US003N 2025-11-25T14:26:52.911Z 2025-12-02T15:13:04.674Z
8592496 8592496 20251124080426_nPgSJ US003N 2025-11-25T14:26:50.545Z 2025-12-02T15:13:04.603Z
8592487 8592487 20251124075939_pIq9w US003N 2025-11-25T14:26:49.261Z 2025-12-02T15:13:04.574Z
8592445 8592445 20251124074112_Tuh8X US003N 2025-11-25T14:26:44.395Z 2025-12-02T15:13:04.165Z
8592393 8592393 20251124071648_997mh US003N 2025-11-25T14:26:39.523Z 2025-12-02T15:13:03.779Z
8592351 8592351 20251124065607_7lLoM US003N 2025-11-25T14:26:34.413Z 2025-12-02T15:13:03.433Z
8592314 8592314 20251124063912_N6E9t US003N 2025-11-25T14:26:28.821Z 2025-12-02T15:13:03.167Z
8592253 8592253 20251124062212_Ud0yL US003N 2025-11-25T14:26:08.675Z 2025-12-02T15:13:02.639Z
8592250 8592250 20251124061739_u7ybK US003N 2025-11-25T14:26:08.457Z 2025-12-02T15:13:02.626Z
8592244 8592244 20251124061448_StJXc US003N 2025-11-25T14:26:07.928Z 2025-12-02T15:13:02.574Z
8592209 8592209 20251124060421_9w38l US003N 2025-11-25T14:26:03.008Z 2025-12-02T15:13:02.336Z
8592203 8592203 20251124060328_Dkl6C US003N 2025-11-25T14:26:02.137Z 2025-12-02T15:13:02.307Z
8592170 8592170 20251124055610_zDk1d US003N 2025-11-25T14:25:58.640Z 2025-12-02T15:13:02.167Z
8592163 8592163 20251124055527_DoeVu US003N 2025-11-25T14:25:58.128Z 2025-12-02T15:13:02.131Z
8592159 8592159 20251124055516_94z0a US003N 2025-11-25T14:25:57.871Z 2025-12-02T15:13:02.115Z
8592121 8592121 20251124055114_jht1i US003N 2025-11-25T14:25:54.381Z 2025-12-02T15:13:01.946Z

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