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

8,480 rows where station_code = "US0039" 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
9273409 9273409 20260128060630_8mNhH US0039 2026-01-29T14:29:41.416Z 2026-01-29T14:30:25.804Z
9256403 9256403 20260124081804_jVHeG US0039 2026-01-25T14:16:57.206Z 2026-01-29T14:48:47.873Z
9256382 9256382 20260124080431_nhuPc US0039 2026-01-25T14:16:51.305Z 2026-01-29T14:48:46.639Z
9256354 9256354 20260124073821_PBPwU US0039 2026-01-25T14:16:45.934Z 2026-01-29T14:48:44.467Z
9256328 9256328 20260124072430_r338d US0039 2026-01-25T14:16:41.385Z 2026-01-29T14:48:41.629Z
9256103 9256103 20260124055627_34aed US0039 2026-01-25T14:15:51.979Z 2026-01-29T14:48:23.530Z
9255843 9255843 20260124050832_fRCir US0039 2026-01-25T14:14:57.779Z 2026-01-29T14:48:01.230Z
9255672 9255672 20260124042919_7byS4 US0039 2026-01-25T14:14:15.117Z 2026-01-29T14:47:50.380Z
9255391 9255391 20260124031743_Iz4cw US0039 2026-01-25T14:13:10.969Z 2026-01-29T14:47:27.813Z
9255172 9255172 20260124012758_kWbxh US0039 2026-01-25T14:12:09.241Z 2026-01-29T14:47:06.231Z
9253163 9253163 20260124094810_mr8ff US0039 2026-01-25T14:01:03.725Z 2026-01-29T14:40:22.306Z
9253154 9253154 20260124094558_hAJCQ US0039 2026-01-25T14:01:00.653Z 2026-01-29T14:40:21.640Z
9253078 9253078 20260124090425_v17pb US0039 2026-01-25T14:00:32.833Z 2026-01-29T14:40:13.869Z
9253043 9253043 20260124085100_ZdmZy US0039 2026-01-25T14:00:19.446Z 2026-01-29T14:40:12.031Z
9252994 9252994 20260123085352_ukWuh US0039 2026-01-24T14:18:07.605Z 2026-01-29T14:53:47.218Z
9252941 9252941 20260123083308_Ou19B US0039 2026-01-24T14:17:56.901Z 2026-01-29T14:53:43.512Z
9252899 9252899 20260123074232_M2h2P US0039 2026-01-24T14:17:40.596Z 2026-01-29T14:53:40.820Z
9252882 9252882 20260123073417_83HXH US0039 2026-01-24T14:17:36.559Z 2026-01-29T14:53:39.741Z
9252847 9252847 20260123070135_cUAIw US0039 2026-01-24T14:17:29.010Z 2026-01-29T14:53:37.216Z
9252702 9252702 20260123052819_CxokX US0039 2026-01-24T14:16:51.443Z 2026-01-29T14:53:17.374Z
9252506 9252506 20260123034240_y8OhF US0039 2026-01-24T14:15:54.850Z 2026-01-29T14:53:04.963Z
9252495 9252495 20260123033241_HFR6c US0039 2026-01-24T14:15:52.944Z 2026-01-29T14:53:04.309Z
9252427 9252427 20260123030352_mbhLc US0039 2026-01-24T14:15:33.265Z 2026-01-29T14:52:52.981Z
9252416 9252416 20260123025550_t4TYs US0039 2026-01-24T14:15:28.538Z 2026-01-29T14:52:52.192Z
9250022 9250022 20260123094644_lUXM6 US0039 2026-01-24T14:00:41.441Z 2026-01-29T14:44:52.732Z
9249994 9249994 20260123093017_hlXbO US0039 2026-01-24T14:00:30.844Z 2026-01-29T14:44:46.901Z
9249738 9249738 20260122080600_BR4bV US0039 2026-01-23T14:16:03.087Z 2026-01-29T14:58:52.672Z
9248444 9248444 20260121234843_LmPAZ US0039 2026-01-23T14:12:48.725Z 2026-01-29T14:57:19.279Z
9248433 9248433 20260121234459_F0sYL US0039 2026-01-23T14:12:47.236Z 2026-01-29T14:57:18.704Z
9244644 9244644 20260121092425_Mgg3V US0039 2026-01-22T14:26:15.637Z 2026-01-29T15:06:28.581Z
9244642 9244642 20260121092356_OLDWq US0039 2026-01-22T14:26:15.099Z 2026-01-29T15:06:28.468Z
9244405 9244405 20260121081557_vqF4C US0039 2026-01-22T14:25:24.063Z 2026-01-29T15:06:07.496Z
9244249 9244249 20260121070117_bsGP3 US0039 2026-01-22T14:24:43.747Z 2026-01-29T15:05:57.543Z
9244188 9244188 20260121064157_6r0sj US0039 2026-01-22T14:24:34.235Z 2026-01-29T15:05:55.437Z
9243938 9243938 20260121053726_syszj US0039 2026-01-22T14:23:37.037Z 2026-01-29T15:05:35.481Z
9243676 9243676 20260121050453_HzUW2 US0039 2026-01-22T14:22:43.828Z 2026-01-29T15:05:23.061Z
9243627 9243627 20260121045343_Hu0U8 US0039 2026-01-22T14:22:27.156Z 2026-01-29T15:05:20.503Z
9239973 9239973 20260120105248_82TMN US0039 2026-01-22T14:04:32.206Z 2026-01-29T14:59:21.906Z
9239403 9239403 20260121104050_gk2fJ US0039 2026-01-22T14:01:20.517Z 2026-01-29T14:54:13.931Z
9239380 9239380 20260121103711_222tV US0039 2026-01-22T14:01:14.544Z 2026-01-29T14:54:12.518Z
9239127 9239127 20260116111459_vXNxS US0039 2026-01-21T14:53:23.039Z 2026-01-24T15:15:15.718Z
9239104 9239104 20260116071211_NHvNm US0039 2026-01-21T14:52:29.121Z 2026-01-24T15:13:56.738Z
9238970 9238970 20260119040042_EZ9mp US0039 2026-01-21T14:38:38.246Z 2026-01-27T15:04:48.608Z
9238935 9238935 20260120084815_qiHW5 US0039 2026-01-21T14:31:36.897Z 2026-01-28T15:02:36.190Z
9238915 9238915 20260119232125_wi9KV US0039 2026-01-21T14:31:11.090Z 2026-01-28T14:58:09.673Z
9238597 9238597 20260120091213_1OkTa US0039 2026-01-21T14:30:02.113Z 2026-01-28T15:02:40.350Z
9238397 9238397 20260120083121_NJzdl US0039 2026-01-21T14:29:30.100Z 2026-01-28T15:02:32.107Z
9238280 9238280 20260120081528_tqaWg US0039 2026-01-21T14:29:05.915Z 2026-01-28T15:02:17.930Z
9238166 9238166 20260120074207_WWv8R US0039 2026-01-21T14:28:50.966Z 2026-01-28T15:02:10.967Z
9238067 9238067 20260120071510_ezK0L US0039 2026-01-21T14:28:26.419Z 2026-01-28T15:02:06.165Z
9237995 9237995 20260120065210_nkDNf US0039 2026-01-21T14:28:13.924Z 2026-01-28T15:02:02.331Z
9237992 9237992 20260120065134_4CuE8 US0039 2026-01-21T14:28:13.641Z 2026-01-28T15:02:02.193Z
9237914 9237914 20260120062424_lfc2a US0039 2026-01-21T14:28:03.797Z 2026-01-28T15:01:59.007Z
9237910 9237910 20260120062344_F52qQ US0039 2026-01-21T14:28:03.055Z 2026-01-28T15:01:58.719Z
9237891 9237891 20260120061835_rZrxH US0039 2026-01-21T14:27:59.692Z 2026-01-28T15:01:57.580Z
9237748 9237748 20260120055900_cX3yM US0039 2026-01-21T14:27:34.328Z 2026-01-28T15:01:39.107Z
9237563 9237563 20260120053642_SZ0x3 US0039 2026-01-21T14:27:01.111Z 2026-01-28T15:01:31.290Z
9237499 9237499 20260120052505_iaKcS US0039 2026-01-21T14:26:48.686Z 2026-01-28T15:01:28.455Z
9237387 9237387 20260120051038_NTCRZ US0039 2026-01-21T14:26:23.556Z 2026-01-28T15:01:23.089Z
9237183 9237183 20260120044715_zfPtu US0039 2026-01-21T14:25:29.312Z 2026-01-28T15:01:01.583Z
9236896 9236896 20260120041543_svIcb US0039 2026-01-21T14:24:27.471Z 2026-01-28T15:00:45.225Z
9236724 9236724 20260120035206_mfi1F US0039 2026-01-21T14:23:46.093Z 2026-01-28T15:00:32.015Z
9235667 9235667 20260120014523_2D2sX US0039 2026-01-21T14:19:51.471Z 2026-01-28T14:59:15.250Z
9235560 9235560 20260120013412_fALZ5 US0039 2026-01-21T14:19:25.794Z 2026-01-28T14:59:02.402Z
9235273 9235273 20260120004959_IFW01 US0039 2026-01-21T14:18:20.329Z 2026-01-28T14:58:47.021Z
9235253 9235253 20260120004804_ebsDC US0039 2026-01-21T14:18:15.294Z 2026-01-28T14:58:45.916Z
9235104 9235104 20260120003028_5bEgz US0039 2026-01-21T14:17:37.309Z 2026-01-28T14:58:30.921Z
9234960 9234960 20260119235602_3CqY0 US0039 2026-01-21T14:16:50.315Z 2026-01-28T14:58:22.418Z
9232416 9232416 20260120112409_Z3rry US0039 2026-01-21T14:01:46.412Z 2026-01-29T14:59:33.396Z
9232329 9232329 20260120110624_BDEPY US0039 2026-01-21T14:01:19.459Z 2026-01-29T14:59:26.353Z
9232253 9232253 20260120105248_PEPOd US0039 2026-01-21T14:00:59.889Z 2026-01-21T14:00:59.889Z
9231973 9231973 20260119102852_NCrtl US0039 2026-01-20T14:34:57.564Z 2026-01-27T15:07:08.674Z
9231709 9231709 20260119093622_kCwO8 US0039 2026-01-20T14:33:59.525Z 2026-01-27T15:06:56.328Z
9231667 9231667 20260119092037_HMEe4 US0039 2026-01-20T14:33:50.302Z 2026-01-27T15:06:43.638Z
9228934 9228934 20260119002203_l2I3s US0039 2026-01-20T14:20:13.421Z 2026-01-27T15:02:43.814Z
9223476 9223476 20260118005112_NzOZF US0039 2026-01-19T14:19:29.831Z 2026-01-26T15:02:08.342Z
9215800 9215800 20260116110155_xdouQ US0039 2026-01-17T14:26:53.286Z 2026-01-24T15:15:13.615Z
9215424 9215424 20260116100927_8D832 US0039 2026-01-17T14:25:31.844Z 2026-01-24T15:14:44.953Z
9214743 9214743 20260116075307_77533 US0039 2026-01-17T14:23:03.079Z 2026-01-24T15:14:03.890Z
9214446 9214446 20260116063652_1c2b7 US0039 2026-01-17T14:21:35.228Z 2026-01-24T15:13:38.086Z
9214292 9214292 20260116061000_RkFCO US0039 2026-01-17T14:20:59.735Z 2026-01-24T15:13:28.821Z
9214269 9214269 20260116060536_U82E1 US0039 2026-01-17T14:20:50.864Z 2026-01-24T15:13:27.342Z
9214023 9214023 20260116052115_tmdwk US0039 2026-01-17T14:19:41.616Z 2026-01-24T15:12:58.322Z
9209550 9209550 20260115100738_j32tR US0039 2026-01-16T14:16:42.961Z 2026-01-22T15:05:28.674Z
9197505 9197505 20260113112655_BPLAk US0039 2026-01-14T14:23:14.725Z 2026-01-21T15:06:19.321Z
9197275 9197275 20260113104043_h21jh US0039 2026-01-14T14:22:11.907Z 2026-01-21T15:06:16.107Z
9197248 9197248 20260113103752_PYW2Z US0039 2026-01-14T14:22:02.065Z 2026-01-21T15:06:15.794Z
9197195 9197195 20260113102607_o3UW0 US0039 2026-01-14T14:21:50.882Z 2026-01-21T15:06:15.052Z
9196260 9196260 20260113054732_HKm8w US0039 2026-01-14T14:17:26.457Z 2026-01-21T15:05:30.500Z
9196182 9196182 20260113051039_XKFyL US0039 2026-01-14T14:17:00.356Z 2026-01-21T15:05:29.152Z
9196179 9196179 20260113051018_Fu9tF US0039 2026-01-14T14:16:59.807Z 2026-01-21T15:05:29.121Z
9196153 9196153 20260113045926_QUu05 US0039 2026-01-14T14:16:52.869Z 2026-01-21T15:05:28.790Z
9196139 9196139 20260113045339_Ngt51 US0039 2026-01-14T14:16:49.253Z 2026-01-21T15:05:28.636Z
9196100 9196100 20260113043901_MMpI7 US0039 2026-01-14T14:16:36.534Z 2026-01-21T15:05:28.059Z
9196053 9196053 20260113042044_uGwZS US0039 2026-01-14T14:16:21.648Z 2026-01-21T15:05:15.933Z
9195943 9195943 20260113033512_lFvok US0039 2026-01-14T14:15:40.840Z 2026-01-21T15:04:50.489Z
9195862 9195862 20260113031200_r3WSY US0039 2026-01-14T14:15:17.940Z 2026-01-21T15:04:48.725Z
9195815 9195815 20260113025828_F3D08 US0039 2026-01-14T14:15:05.297Z 2026-01-21T15:04:48.167Z
9195484 9195484 20260113013521_lDd21 US0039 2026-01-14T14:13:34.422Z 2026-01-21T15:04:41.306Z
9195045 9195045 20260113000638_UoqHk US0039 2026-01-14T14:11:49.245Z 2026-01-21T15:04:35.505Z

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