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 = "US0009" 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
9272609 9272609 20260128024837_lP2Wj US0009 2026-01-29T14:27:14.305Z 2026-01-29T14:30:25.382Z
9272555 9272555 20260128023543_eULBT US0009 2026-01-29T14:27:10.241Z 2026-01-29T14:30:25.377Z
9269271 9269271 20260128125445_wdnpj US0009 2026-01-29T14:07:14.232Z 2026-01-29T14:07:14.232Z
9268978 9268978 20260128115722_ZUbXC US0009 2026-01-29T14:05:50.181Z 2026-01-29T14:05:50.181Z
9268960 9268960 20260128115128_kJH2q US0009 2026-01-29T14:05:43.532Z 2026-01-29T14:05:43.532Z
9268823 9268823 20260128113043_rcgQC US0009 2026-01-29T14:05:04.826Z 2026-01-29T14:05:04.826Z
9268817 9268817 20260128112845_q64w5 US0009 2026-01-29T14:05:01.202Z 2026-01-29T14:05:01.202Z
9268363 9268363 20260128100142_mLVvr US0009 2026-01-29T14:02:40.987Z 2026-01-29T14:02:40.987Z
9268162 9268162 20260128090613_a5jpf US0009 2026-01-29T14:01:28.049Z 2026-01-29T14:01:28.049Z
9268093 9268093 20260128084740_vMNlA US0009 2026-01-29T14:01:04.058Z 2026-01-29T14:01:04.058Z
9268066 9268066 20260128082928_e9T0P US0009 2026-01-29T14:00:51.668Z 2026-01-29T14:00:51.668Z
9267582 9267582 20260127032710_9qj5K US0009 2026-01-28T14:22:24.513Z 2026-01-29T14:35:19.718Z
9264834 9264834 20260127132005_pudhv US0009 2026-01-28T14:07:54.311Z 2026-01-29T14:30:24.309Z
9264573 9264573 20260127124802_qrxec US0009 2026-01-28T14:06:43.757Z 2026-01-29T14:30:24.222Z
9264269 9264269 20260127115319_ZWxb1 US0009 2026-01-28T14:05:14.582Z 2026-01-29T14:30:20.573Z
9264109 9264109 20260127111522_qBaT9 US0009 2026-01-28T14:04:28.088Z 2026-01-29T14:30:20.054Z
9263668 9263668 20260127093847_WXD97 US0009 2026-01-28T14:02:06.742Z 2026-01-29T14:30:17.620Z
9263643 9263643 20260127093427_XTjDx US0009 2026-01-28T14:01:57.408Z 2026-01-29T14:30:17.611Z
9263136 9263136 20260126073626_abmH3 US0009 2026-01-27T14:17:09.997Z 2026-01-29T14:39:18.668Z
9262982 9262982 20260126054805_SulTu US0009 2026-01-27T14:16:23.713Z 2026-01-29T14:39:07.821Z
9262948 9262948 20260126052621_bZlYO US0009 2026-01-27T14:16:14.476Z 2026-01-29T14:39:05.624Z
9261766 9261766 20260126131234_VCvYL US0009 2026-01-27T14:05:29.249Z 2026-01-29T14:32:56.575Z
9261474 9261474 20260126115053_y81tU US0009 2026-01-27T14:03:55.256Z 2026-01-29T14:32:27.464Z
9261461 9261461 20260126114801_Fe2LH US0009 2026-01-27T14:03:49.122Z 2026-01-29T14:32:26.218Z
9261261 9261261 20260126104941_ZLe4A US0009 2026-01-27T14:02:52.446Z 2026-01-29T14:32:08.765Z
9261128 9261128 20260126095717_qY02v US0009 2026-01-27T14:02:07.788Z 2026-01-29T14:31:58.201Z
9261101 9261101 20260126095207_JSmF0 US0009 2026-01-27T14:01:53.296Z 2026-01-29T14:31:55.368Z
9261086 9261086 20260126095050_nT9hm US0009 2026-01-27T14:01:49.719Z 2026-01-29T14:31:48.940Z
9260987 9260987 20260126091245_Hic3T US0009 2026-01-27T14:01:15.950Z 2026-01-29T14:31:17.529Z
9260966 9260966 20260126090303_HXbud US0009 2026-01-27T14:01:10.936Z 2026-01-29T14:31:16.552Z
9260877 9260877 20260126082740_DBZy1 US0009 2026-01-27T14:00:35.706Z 2026-01-29T14:31:04.032Z
9260835 9260835 20260126080739_voaXN US0009 2026-01-27T14:00:25.572Z 2026-01-29T14:30:44.970Z
9260786 9260786 20260126074918_rtZhl US0009 2026-01-27T14:00:09.754Z 2026-01-29T14:30:30.642Z
9252834 9252834 20260123064734_BU8it US0009 2026-01-24T14:17:27.023Z 2026-01-29T14:53:36.322Z
9252714 9252714 20260123053555_LfPi0 US0009 2026-01-24T14:16:53.380Z 2026-01-29T14:53:18.010Z
9249761 9249761 20260122082507_BlLzo US0009 2026-01-23T14:16:11.667Z 2026-01-29T14:58:54.000Z
9249699 9249699 20260122070914_Kd1tO US0009 2026-01-23T14:15:56.556Z 2026-01-29T14:58:50.148Z
9249329 9249329 20260122045115_RVJ8w US0009 2026-01-23T14:15:11.219Z 2026-01-29T14:58:26.273Z
9245477 9245477 20260122123900_YVN0x US0009 2026-01-23T14:02:06.589Z 2026-01-29T14:49:42.905Z
9244950 9244950 20260117083940_0Xvnx US0009 2026-01-22T14:55:20.545Z 2026-01-25T14:59:04.592Z
9244622 9244622 20260121092042_hLFfe US0009 2026-01-22T14:26:13.564Z 2026-01-29T15:06:28.071Z
9244331 9244331 20260121074040_msPm2 US0009 2026-01-22T14:25:10.755Z 2026-01-29T15:06:01.763Z
9244299 9244299 20260121072211_ZfUOC US0009 2026-01-22T14:24:55.655Z 2026-01-29T15:06:00.006Z
9244214 9244214 20260121064825_RFFvn US0009 2026-01-22T14:24:37.603Z 2026-01-29T15:05:56.126Z
9242561 9242561 20260121021437_CfHmC US0009 2026-01-22T14:18:25.396Z 2026-01-29T15:04:11.149Z
9242371 9242371 20260121014015_rXKAp US0009 2026-01-22T14:17:29.705Z 2026-01-29T15:03:52.414Z
9242320 9242320 20260121012711_762l0 US0009 2026-01-22T14:17:19.765Z 2026-01-29T15:03:44.008Z
9239943 9239943 20260120102425_aYTQH US0009 2026-01-22T14:04:04.858Z 2026-01-29T14:59:13.847Z
9239909 9239909 20260121130639_5y70Y US0009 2026-01-22T14:03:43.576Z 2026-01-29T14:55:01.221Z
9239836 9239836 20260121124354_OryBI US0009 2026-01-22T14:03:26.540Z 2026-01-29T14:54:46.901Z
9239814 9239814 20260121123754_SiQT8 US0009 2026-01-22T14:03:24.662Z 2026-01-29T14:54:43.882Z
9239802 9239802 20260121123606_B6gkA US0009 2026-01-22T14:03:12.496Z 2026-01-29T14:54:43.030Z
9239694 9239694 20260121114716_5wW5m US0009 2026-01-22T14:02:40.377Z 2026-01-29T14:54:35.796Z
9239526 9239526 20260121110408_2xr7H US0009 2026-01-22T14:01:50.523Z 2026-01-29T14:54:21.416Z
9239513 9239513 20260121110027_h3Azp US0009 2026-01-22T14:01:47.447Z 2026-01-29T14:54:20.628Z
9239506 9239506 20260121105851_lXcBM US0009 2026-01-22T14:01:46.583Z 2026-01-29T14:54:20.541Z
9239497 9239497 20260121105825_txnRM US0009 2026-01-22T14:01:45.309Z 2026-01-29T14:54:20.288Z
9239420 9239420 20260121104526_TRoYD US0009 2026-01-22T14:01:23.834Z 2026-01-29T14:54:14.819Z
9239329 9239329 20260121102811_QKysa US0009 2026-01-22T14:00:59.595Z 2026-01-29T14:54:09.372Z
9239231 9239231 20260121100704_w0nM6 US0009 2026-01-22T14:00:29.017Z 2026-01-29T14:53:55.191Z
9239223 9239223 20260121100619_LFVno US0009 2026-01-22T14:00:27.075Z 2026-01-29T14:53:54.887Z
9239178 9239178 20260121095732_mklTe US0009 2026-01-22T14:00:17.582Z 2026-01-29T14:53:53.111Z
9239157 9239157 20260115122046_utGyF US0009 2026-01-21T14:57:22.417Z 2026-01-22T15:05:50.142Z
9239096 9239096 20260115131818_lRDGy US0009 2026-01-21T14:49:27.936Z 2026-01-24T15:08:45.969Z
9238542 9238542 20260120085630_8qUpJ US0009 2026-01-21T14:29:55.438Z 2026-01-28T15:02:37.903Z
9238431 9238431 20260120083907_bDmD4 US0009 2026-01-21T14:29:33.174Z 2026-01-28T15:02:33.168Z
9238296 9238296 20260120081719_q3AEP US0009 2026-01-21T14:29:07.403Z 2026-01-28T15:02:25.111Z
9238171 9238171 20260120074424_wlwDE US0009 2026-01-21T14:28:51.618Z 2026-01-28T15:02:11.353Z
9238160 9238160 20260120073928_76h2p US0009 2026-01-21T14:28:50.258Z 2026-01-28T15:02:10.563Z
9238107 9238107 20260120072430_4v5rr US0009 2026-01-21T14:28:42.333Z 2026-01-28T15:02:07.663Z
9238103 9238103 20260120072407_HXdsJ US0009 2026-01-21T14:28:41.853Z 2026-01-28T15:02:07.552Z
9238048 9238048 20260120070950_lXSkd US0009 2026-01-21T14:28:24.612Z 2026-01-28T15:02:05.140Z
9238042 9238042 20260120070858_sttMY US0009 2026-01-21T14:28:23.946Z 2026-01-28T15:02:04.716Z
9238019 9238019 20260120065722_iPVs5 US0009 2026-01-21T14:28:17.370Z 2026-01-28T15:02:03.473Z
9237806 9237806 20260120060727_Kss00 US0009 2026-01-21T14:27:40.547Z 2026-01-28T15:01:43.024Z
9232744 9232744 20260120122118_z0R3q US0009 2026-01-21T14:03:06.106Z 2026-01-29T15:00:01.721Z
9232680 9232680 20260120121025_Ymf3V US0009 2026-01-21T14:02:52.273Z 2026-01-29T14:59:57.111Z
9232627 9232627 20260120120145_ClmP2 US0009 2026-01-21T14:02:37.249Z 2026-01-29T14:59:54.075Z
9232606 9232606 20260120115743_SRUPJ US0009 2026-01-21T14:02:32.722Z 2026-01-29T14:59:53.177Z
9232359 9232359 20260120111230_3XFQU US0009 2026-01-21T14:01:28.527Z 2026-01-29T14:59:30.209Z
9232352 9232352 20260120111145_xp4Vc US0009 2026-01-21T14:01:27.814Z 2026-01-29T14:59:30.026Z
9232094 9232094 20260120102235_7DZxW US0009 2026-01-21T14:00:19.453Z 2026-01-29T14:59:12.943Z
9231947 9231947 20260119102029_4Uu04 US0009 2026-01-20T14:34:52.682Z 2026-01-27T15:07:07.227Z
9231936 9231936 20260119101828_rWv7x US0009 2026-01-20T14:34:50.341Z 2026-01-27T15:07:06.564Z
9231744 9231744 20260119094523_Ok38J US0009 2026-01-20T14:34:13.146Z 2026-01-27T15:06:58.094Z
9231720 9231720 20260119094111_B7gqx US0009 2026-01-20T14:34:03.512Z 2026-01-27T15:06:56.940Z
9231623 9231623 20260119090627_AwFBm US0009 2026-01-20T14:33:36.304Z 2026-01-27T15:06:41.262Z
9231548 9231548 20260119083935_3Q3iX US0009 2026-01-20T14:33:18.423Z 2026-01-27T15:06:35.570Z
9231462 9231462 20260119081408_qXzC7 US0009 2026-01-20T14:32:57.622Z 2026-01-27T15:06:30.869Z
9231427 9231427 20260119075709_77q54 US0009 2026-01-20T14:32:44.030Z 2026-01-27T15:06:29.166Z
9231410 9231410 20260119075544_zrSHw US0009 2026-01-20T14:32:41.096Z 2026-01-27T15:06:28.427Z
9231337 9231337 20260119072517_TOwOb US0009 2026-01-20T14:32:24.774Z 2026-01-27T15:06:24.632Z
9230552 9230552 20260119043228_4ksE3 US0009 2026-01-20T14:28:29.450Z 2026-01-27T15:05:02.815Z
9230405 9230405 20260119041524_attUg US0009 2026-01-20T14:27:40.033Z 2026-01-27T15:04:52.973Z
9229670 9229670 20260119021551_OBUVZ US0009 2026-01-20T14:23:39.676Z 2026-01-27T15:03:48.372Z
9229411 9229411 20260119014229_e3e1n US0009 2026-01-20T14:22:25.655Z 2026-01-27T15:03:22.782Z
9229390 9229390 20260119013919_o6fVj US0009 2026-01-20T14:22:19.848Z 2026-01-27T15:03:21.534Z
9226068 9226068 20260119110058_08esX US0009 2026-01-20T14:00:53.899Z 2026-01-28T14:54:33.039Z
9225817 9225817 20260118110431_GWJfj US0009 2026-01-19T14:30:27.736Z 2026-01-26T15:04:46.380Z
9225727 9225727 20260118104604_dZD2B US0009 2026-01-19T14:30:00.607Z 2026-01-26T15:04:43.066Z

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