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

1,083 rows where station_code = "US005G" 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
9267926 9267926 20260127065625_Wpvps US005G 2026-01-28T14:23:54.483Z 2026-01-29T14:35:54.413Z
9255424 9255424 20260124032820_rQjQG US005G 2026-01-25T14:13:23.560Z 2026-01-29T14:47:29.880Z
9255368 9255368 20260124030810_9gYtk US005G 2026-01-25T14:13:05.524Z 2026-01-29T14:47:26.296Z
9243493 9243493 20260121044028_5MEcZ US005G 2026-01-22T14:22:04.573Z 2026-01-29T15:05:13.793Z
9243122 9243122 20260121034501_bUmPG US005G 2026-01-22T14:20:42.108Z 2026-01-29T15:04:47.123Z
9242139 9242139 20260121004004_eKY38 US005G 2026-01-22T14:16:30.109Z 2026-01-29T15:03:33.023Z
9242117 9242117 20260121003221_aehF4 US005G 2026-01-22T14:16:25.586Z 2026-01-29T15:03:31.629Z
9239640 9239640 20260121112713_IUe7A US005G 2026-01-22T14:02:22.234Z 2026-01-29T14:54:33.294Z
9239163 9239163 20260121095144_Yk3Ru US005G 2026-01-22T14:00:10.629Z 2026-01-29T14:53:51.556Z
9238338 9238338 20260120082347_0I0Z8 US005G 2026-01-21T14:29:23.770Z 2026-01-28T15:02:29.624Z
9238238 9238238 20260120080621_FPGpm US005G 2026-01-21T14:28:59.150Z 2026-01-28T15:02:15.407Z
9238122 9238122 20260120072827_7P2R3 US005G 2026-01-21T14:28:44.807Z 2026-01-28T15:02:08.475Z
9238027 9238027 20260120070011_0wWRH US005G 2026-01-21T14:28:18.433Z 2026-01-28T15:02:03.787Z
9237893 9237893 20260120061902_bkqSH US005G 2026-01-21T14:28:00.250Z 2026-01-28T15:01:57.721Z
9237473 9237473 20260120052115_5mVGv US005G 2026-01-21T14:26:43.246Z 2026-01-28T15:01:27.340Z
9237344 9237344 20260120050553_q9aeq US005G 2026-01-21T14:26:02.528Z 2026-01-28T15:01:20.725Z
9237091 9237091 20260120043601_8O2KR US005G 2026-01-21T14:25:15.883Z 2026-01-28T15:00:57.838Z
9236519 9236519 20260120033026_KLqzB US005G 2026-01-21T14:23:02.583Z 2026-01-28T15:00:06.884Z
9232433 9232433 20260120112645_8NXlI US005G 2026-01-21T14:01:49.727Z 2026-01-29T14:59:34.088Z
9232392 9232392 20260120112019_jaEUB US005G 2026-01-21T14:01:37.926Z 2026-01-29T14:59:32.212Z
9232281 9232281 20260120105750_BJFy0 US005G 2026-01-21T14:01:06.834Z 2026-01-29T14:59:23.496Z
9232103 9232103 20260120102343_wLakv US005G 2026-01-21T14:00:21.617Z 2026-01-29T14:59:13.570Z
9231956 9231956 20260119102506_3ukX4 US005G 2026-01-20T14:34:54.270Z 2026-01-27T15:07:07.764Z
9231719 9231719 20260119094041_Jghwe US005G 2026-01-20T14:34:02.859Z 2026-01-27T15:06:56.809Z
9231619 9231619 20260119090602_0P1as US005G 2026-01-20T14:33:35.076Z 2026-01-27T15:06:40.925Z
9231536 9231536 20260119083656_Up1Kz US005G 2026-01-20T14:33:13.111Z 2026-01-27T15:06:34.829Z
9231513 9231513 20260119082927_E0AXN US005G 2026-01-20T14:33:08.031Z 2026-01-27T15:06:33.797Z
9231470 9231470 20260119081750_7CwxJ US005G 2026-01-20T14:32:59.295Z 2026-01-27T15:06:31.306Z
9231416 9231416 20260119075614_a3bwb US005G 2026-01-20T14:32:42.249Z 2026-01-27T15:06:28.699Z
9231231 9231231 20260119064309_eCMGA US005G 2026-01-20T14:31:56.615Z 2026-01-27T15:06:08.242Z
9230904 9230904 20260119052847_v27VB US005G 2026-01-20T14:30:19.457Z 2026-01-27T15:05:35.755Z
9230100 9230100 20260119032515_coULT US005G 2026-01-20T14:25:57.530Z 2026-01-27T15:04:25.411Z
9226298 9226298 20260119114335_KGl0t US005G 2026-01-20T14:02:20.885Z 2026-01-28T14:54:53.259Z
9226212 9226212 20260119112944_UAYcT US005G 2026-01-20T14:01:52.356Z 2026-01-28T14:54:48.583Z
9226197 9226197 20260119112732_gqLvS US005G 2026-01-20T14:01:45.079Z 2026-01-28T14:54:47.789Z
9225705 9225705 20260118104349_yQX4b US005G 2026-01-19T14:29:57.935Z 2026-01-26T15:04:42.474Z
9225547 9225547 20260118100635_X2Yfd US005G 2026-01-19T14:29:23.749Z 2026-01-26T15:04:37.729Z
9225096 9225096 20260118073525_3d6Dq US005G 2026-01-19T14:27:33.832Z 2026-01-26T15:04:01.660Z
9219941 9219941 20260118114304_jTX2Q US005G 2026-01-19T14:01:49.116Z 2026-01-27T14:58:43.122Z
9219822 9219822 20260118112719_3koyE US005G 2026-01-19T14:01:05.680Z 2026-01-27T14:58:35.116Z
9219647 9219647 20260117112658_DF5uj US005G 2026-01-18T14:17:19.805Z 2026-01-25T14:59:34.614Z
9219563 9219563 20260117110807_2jtKd US005G 2026-01-18T14:16:59.887Z 2026-01-25T14:59:32.115Z
9213551 9213551 20260116040105_7Ls5N US005G 2026-01-17T14:17:31.007Z 2026-01-24T15:12:21.663Z
9213523 9213523 20260116035353_oq2E0 US005G 2026-01-17T14:17:20.943Z 2026-01-24T15:12:19.665Z
9209134 9209134 20260115083717_6HGHz US005G 2026-01-16T14:15:15.482Z 2026-01-22T15:04:49.821Z
9209124 9209124 20260115083606_R63CM US005G 2026-01-16T14:15:13.785Z 2026-01-22T15:04:49.589Z
9208757 9208757 20260115064339_3ssmJ US005G 2026-01-16T14:13:51.716Z 2026-01-22T15:04:39.140Z
9208681 9208681 20260115062609_969au US005G 2026-01-16T14:13:38.432Z 2026-01-22T15:04:37.221Z
9204885 9204885 20260114093412_BHoqY US005G 2026-01-15T14:29:03.186Z 2026-01-22T15:11:05.235Z
9201215 9201215 20260114015436_HlbXX US005G 2026-01-15T14:17:48.789Z 2026-01-22T15:08:59.662Z
9200482 9200482 20260114001334_CeVZ1 US005G 2026-01-15T14:15:18.364Z 2026-01-22T15:08:16.709Z
9197998 9197998 20260112115618_nfcW6 US005G 2026-01-14T14:35:34.289Z 2026-01-20T15:25:53.758Z
9197981 9197981 20260112101431_bS3KT US005G 2026-01-14T14:34:07.055Z 2026-01-20T15:25:03.789Z
9197977 9197977 20260112091145_IZ499 US005G 2026-01-14T14:33:28.668Z 2026-01-20T15:24:35.274Z
9197975 9197975 20260112082802_7guuf US005G 2026-01-14T14:33:02.081Z 2026-01-20T15:24:12.886Z
9197969 9197969 20260112050443_U56Id US005G 2026-01-14T14:31:47.731Z 2026-01-20T15:23:18.007Z
9197966 9197966 20260112013235_ZuhqP US005G 2026-01-14T14:30:09.557Z 2026-01-20T15:22:08.619Z
9197508 9197508 20260113112718_xhot8 US005G 2026-01-14T14:23:15.663Z 2026-01-21T15:06:19.353Z
9197376 9197376 20260113110323_33TKu US005G 2026-01-14T14:22:39.846Z 2026-01-21T15:06:17.615Z
9197176 9197176 20260113102250_NMLUA US005G 2026-01-14T14:21:46.295Z 2026-01-21T15:06:14.814Z
9197132 9197132 20260113101624_J3IJe US005G 2026-01-14T14:21:38.876Z 2026-01-21T15:06:14.434Z
9196679 9196679 20260113083000_pwn7G US005G 2026-01-14T14:19:31.572Z 2026-01-21T15:05:36.468Z
9196427 9196427 20260113065956_yyTog US005G 2026-01-14T14:18:15.825Z 2026-01-21T15:05:32.885Z
9196378 9196378 20260113064240_GtaR2 US005G 2026-01-14T14:18:05.314Z 2026-01-21T15:05:32.283Z
9183946 9183946 20260111102913_Yp5hE US005G 2026-01-12T14:19:16.196Z 2026-01-19T15:20:17.525Z
9183797 9183797 20260111101618_57p12 US005G 2026-01-12T14:18:49.409Z 2026-01-19T15:20:12.050Z
9183518 9183518 20260111093923_uN21A US005G 2026-01-12T14:17:59.913Z 2026-01-19T15:19:42.763Z
9183398 9183398 20260111092547_OlQVv US005G 2026-01-12T14:17:42.653Z 2026-01-19T15:19:38.060Z
9183029 9183029 20260111081057_QV3xY US005G 2026-01-12T14:16:29.351Z 2026-01-19T15:19:23.055Z
9182844 9182844 20260111065955_vTv8q US005G 2026-01-12T14:15:55.238Z 2026-01-19T15:19:01.682Z
9182744 9182744 20260111062920_Koxk3 US005G 2026-01-12T14:15:38.160Z 2026-01-19T15:18:57.871Z
9162796 9162796 20260107043307_439S1 US005G 2026-01-08T14:06:54.186Z 2026-01-13T15:02:39.490Z
9124510 9124510 20251231094030_Q9Ezq US005G 2026-01-02T14:47:34.601Z 2026-01-08T15:12:40.861Z
9124506 9124506 20251231092852_cJGIy US005G 2026-01-02T14:47:26.643Z 2026-01-08T15:12:39.637Z
9124477 9124477 20251231085247_sYRSN US005G 2026-01-02T14:47:05.338Z 2026-01-08T15:12:26.068Z
9124475 9124475 20251231085244_A2q7D US005G 2026-01-02T14:47:00.149Z 2026-01-08T15:12:25.865Z
9122675 9122675 20260101114239_KXAo9 US005G 2026-01-02T14:14:25.036Z 2026-01-09T14:53:41.394Z
9122673 9122673 20260101114236_KYAec US005G 2026-01-02T14:14:23.864Z 2026-01-09T14:53:41.246Z
9122542 9122542 20260101093233_a3evv US005G 2026-01-02T14:13:33.604Z 2026-01-09T14:53:32.287Z
9031803 9031803 20251225054430_o9N7B US005G 2025-12-28T14:21:36.939Z 2026-01-02T15:45:34.545Z
9030466 9030466 20251225044418_F6Eno US005G 2025-12-28T14:18:51.883Z 2026-01-02T15:44:55.193Z
9020167 9020167 20251220114023_rU1zy US005G 2025-12-27T15:05:12.719Z 2025-12-29T15:24:44.289Z
9020071 9020071 20251220112111_jmlRu US005G 2025-12-27T15:05:09.427Z 2025-12-29T15:24:42.656Z
9019371 9019371 20251220094338_uK5r3 US005G 2025-12-27T15:04:12.119Z 2025-12-29T15:24:32.871Z
9019051 9019051 20251220085741_AUfWy US005G 2025-12-27T15:03:03.835Z 2025-12-29T15:24:28.228Z
9018767 9018767 20251220075804_kaz2O US005G 2025-12-27T15:02:48.912Z 2025-12-29T15:24:09.175Z
9018428 9018428 20251220065013_8vL0j US005G 2025-12-27T15:02:36.944Z 2025-12-29T15:23:40.458Z
9018217 9018217 20251220062937_R377n US005G 2025-12-27T15:02:31.365Z 2025-12-29T15:23:38.545Z
9017386 9017386 20251220051408_3aBNW US005G 2025-12-27T15:01:19.008Z 2025-12-29T15:23:30.674Z
9001937 9001937 20251222105602_rQQ3p US005G 2025-12-27T14:23:36.933Z 2025-12-30T15:48:03.267Z
9001367 9001367 20251222100900_wippO US005G 2025-12-27T14:21:58.161Z 2025-12-30T15:47:57.533Z
8998605 8998605 20251222055958_xgqvs US005G 2025-12-27T14:14:07.892Z 2025-12-30T15:46:48.790Z
8997886 8997886 20251222045947_we5P8 US005G 2025-12-27T14:11:36.474Z 2025-12-30T15:46:41.182Z
8996044 8996044 20251222011615_3S5nI US005G 2025-12-27T14:02:48.508Z 2025-12-30T15:45:41.968Z
8995797 8995797 20251222002821_bjrEL US005G 2025-12-27T14:01:35.000Z 2025-12-30T15:45:39.335Z
8979487 8979487 20251219115036_pTIZM US005G 2025-12-26T14:18:41.904Z 2025-12-28T15:19:21.901Z
8979468 8979468 20251219114417_I4ksm US005G 2025-12-26T14:18:33.437Z 2025-12-28T15:19:18.010Z
8979430 8979430 20251219113834_ggzCl US005G 2025-12-26T14:18:24.808Z 2025-12-28T15:19:09.222Z
8979413 8979413 20251219113614_MMhHn US005G 2025-12-26T14:18:22.535Z 2025-12-28T15:19:00.952Z
8979273 8979273 20251219110708_QvR17 US005G 2025-12-26T14:17:56.884Z 2025-12-28T15:18:18.850Z

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