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 = "US000K" 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
9273505 9273505 20260128064426_8Ft6G US000K 2026-01-29T14:30:02.157Z 2026-01-29T14:30:25.826Z
9273265 9273265 20260128052038_Mpkmy US000K 2026-01-29T14:29:14.206Z 2026-01-29T14:30:25.779Z
9273104 9273104 20260128044425_3CTO5 US000K 2026-01-29T14:28:45.077Z 2026-01-29T14:30:25.750Z
9269226 9269226 20260128124826_lLzk8 US000K 2026-01-29T14:07:03.051Z 2026-01-29T14:07:03.051Z
9269187 9269187 20260128124411_qywlz US000K 2026-01-29T14:06:55.407Z 2026-01-29T14:06:55.407Z
9269162 9269162 20260128123904_gQygD US000K 2026-01-29T14:06:46.603Z 2026-01-29T14:06:46.603Z
9269130 9269130 20260128123403_Cgp38 US000K 2026-01-29T14:06:38.631Z 2026-01-29T14:06:38.631Z
9269002 9269002 20260128115955_fl8B8 US000K 2026-01-29T14:05:58.440Z 2026-01-29T14:05:58.440Z
9268909 9268909 20260128114256_NRN2L US000K 2026-01-29T14:05:26.502Z 2026-01-29T14:05:26.502Z
9268826 9268826 20260128113043_rcgQC US000K 2026-01-29T14:05:04.826Z 2026-01-29T14:05:04.826Z
9268366 9268366 20260128100142_mLVvr US000K 2026-01-29T14:02:40.987Z 2026-01-29T14:02:40.987Z
9268165 9268165 20260128090613_a5jpf US000K 2026-01-29T14:01:28.049Z 2026-01-29T14:01:28.049Z
9268149 9268149 20260128090325_hmnXB US000K 2026-01-29T14:01:24.611Z 2026-01-29T14:01:24.611Z
9268069 9268069 20260128082928_e9T0P US000K 2026-01-29T14:00:51.669Z 2026-01-29T14:00:51.669Z
9268013 9268013 20260128074326_S9d27 US000K 2026-01-29T14:00:25.683Z 2026-01-29T14:00:25.683Z
9264816 9264816 20260127131644_gV94K US000K 2026-01-28T14:07:49.183Z 2026-01-29T14:30:24.298Z
9263128 9263128 20260126073418_cDHzW US000K 2026-01-27T14:17:08.299Z 2026-01-29T14:39:18.220Z
9263095 9263095 20260126070809_V5sQh US000K 2026-01-27T14:16:57.542Z 2026-01-29T14:39:16.180Z
9263082 9263082 20260126070211_4UOrI US000K 2026-01-27T14:16:55.579Z 2026-01-29T14:39:13.530Z
9262875 9262875 20260126040532_yr71H US000K 2026-01-27T14:15:49.319Z 2026-01-29T14:38:57.835Z
9261778 9261778 20260126131746_w0Lb6 US000K 2026-01-27T14:05:36.595Z 2026-01-29T14:32:57.311Z
9261726 9261726 20260126125936_KpMfC US000K 2026-01-27T14:05:15.942Z 2026-01-29T14:32:53.298Z
9261687 9261687 20260126124835_yV2ds US000K 2026-01-27T14:05:06.497Z 2026-01-29T14:32:48.481Z
9261574 9261574 20260126121731_ePCgJ US000K 2026-01-27T14:04:23.132Z 2026-01-29T14:32:40.590Z
9261566 9261566 20260126121447_gQ5u5 US000K 2026-01-27T14:04:21.782Z 2026-01-29T14:32:40.106Z
9261428 9261428 20260126113315_AIYl3 US000K 2026-01-27T14:03:40.478Z 2026-01-29T14:32:23.892Z
9261367 9261367 20260126111457_mTCMc US000K 2026-01-27T14:03:18.889Z 2026-01-29T14:32:13.426Z
9261347 9261347 20260126111035_WXaVx US000K 2026-01-27T14:03:15.993Z 2026-01-29T14:32:12.789Z
9261334 9261334 20260126111016_EdVnL US000K 2026-01-27T14:03:14.774Z 2026-01-29T14:32:12.490Z
9261310 9261310 20260126110456_5hzLO US000K 2026-01-27T14:03:08.803Z 2026-01-29T14:32:11.170Z
9261264 9261264 20260126104941_ZLe4A US000K 2026-01-27T14:02:52.446Z 2026-01-29T14:32:08.765Z
9261223 9261223 20260126103351_RsFJn US000K 2026-01-27T14:02:40.682Z 2026-01-29T14:32:05.569Z
9261148 9261148 20260126100127_mL8RT US000K 2026-01-27T14:02:12.759Z 2026-01-29T14:31:59.405Z
9261139 9261139 20260126095940_31Esy US000K 2026-01-27T14:02:11.072Z 2026-01-29T14:31:58.911Z
9260985 9260985 20260126091003_phXVg US000K 2026-01-27T14:01:15.078Z 2026-01-29T14:31:17.289Z
9260959 9260959 20260126090129_9XPaB US000K 2026-01-27T14:01:08.446Z 2026-01-29T14:31:16.072Z
9260847 9260847 20260126081127_YMZ6I US000K 2026-01-27T14:00:27.798Z 2026-01-29T14:30:52.193Z
9260831 9260831 20260126080549_IK3dd US000K 2026-01-27T14:00:23.201Z 2026-01-29T14:30:38.970Z
9245433 9245433 20260122122401_Ked8x US000K 2026-01-23T14:01:56.426Z 2026-01-29T14:49:39.389Z
9244626 9244626 20260121092042_hLFfe US000K 2026-01-22T14:26:13.564Z 2026-01-29T15:06:28.072Z
9244602 9244602 20260121091356_EjoO1 US000K 2026-01-22T14:26:05.415Z 2026-01-29T15:06:27.178Z
9244575 9244575 20260121091139_cVBhg US000K 2026-01-22T14:26:02.901Z 2026-01-29T15:06:26.464Z
9244467 9244467 20260121083459_ch73H US000K 2026-01-22T14:25:46.352Z 2026-01-29T15:06:10.454Z
9244218 9244218 20260121064825_RFFvn US000K 2026-01-22T14:24:37.603Z 2026-01-29T15:05:56.126Z
9243973 9243973 20260121054508_L8Rof US000K 2026-01-22T14:23:41.179Z 2026-01-29T15:05:37.093Z
9243834 9243834 20260121052432_sAnxj US000K 2026-01-22T14:23:19.622Z 2026-01-29T15:05:29.361Z
9243490 9243490 20260121043909_3bR2r US000K 2026-01-22T14:22:04.074Z 2026-01-29T15:05:06.120Z
9243135 9243135 20260121034629_QcAL0 US000K 2026-01-22T14:20:44.422Z 2026-01-29T15:04:47.667Z
9242564 9242564 20260121021437_CfHmC US000K 2026-01-22T14:18:25.396Z 2026-01-29T15:04:11.149Z
9242373 9242373 20260121014015_rXKAp US000K 2026-01-22T14:17:29.706Z 2026-01-29T15:03:52.414Z
9239899 9239899 20260121130324_AWmbh US000K 2026-01-22T14:03:39.697Z 2026-01-29T14:55:00.848Z
9239895 9239895 20260121130205_NYO8p US000K 2026-01-22T14:03:39.056Z 2026-01-29T14:55:00.680Z
9239866 9239866 20260121125557_h13Z2 US000K 2026-01-22T14:03:33.109Z 2026-01-29T14:54:51.154Z
9239829 9239829 20260121124328_SU2uF US000K 2026-01-22T14:03:25.927Z 2026-01-29T14:54:44.857Z
9239705 9239705 20260121115134_WkhdX US000K 2026-01-22T14:02:42.018Z 2026-01-29T14:54:36.337Z
9239630 9239630 20260121112525_j3128 US000K 2026-01-22T14:02:19.654Z 2026-01-29T14:54:32.806Z
9239515 9239515 20260121110027_h3Azp US000K 2026-01-22T14:01:47.447Z 2026-01-29T14:54:20.628Z
9239508 9239508 20260121105851_lXcBM US000K 2026-01-22T14:01:46.583Z 2026-01-29T14:54:20.541Z
9239501 9239501 20260121105825_txnRM US000K 2026-01-22T14:01:45.309Z 2026-01-29T14:54:20.288Z
9239469 9239469 20260121105409_OhMzV US000K 2026-01-22T14:01:35.527Z 2026-01-29T14:54:19.204Z
9239227 9239227 20260121100619_LFVno US000K 2026-01-22T14:00:27.075Z 2026-01-29T14:53:54.887Z
9239205 9239205 20260121100014_U6VVd US000K 2026-01-22T14:00:21.106Z 2026-01-29T14:53:53.746Z
9239198 9239198 20260121095904_LbuZR US000K 2026-01-22T14:00:19.968Z 2026-01-29T14:53:53.445Z
9239152 9239152 20260115105140_OusCl US000K 2026-01-21T14:56:37.625Z 2026-01-22T15:05:35.701Z
9239150 9239150 20260115103720_4h1QA US000K 2026-01-21T14:56:36.620Z 2026-01-22T15:05:34.453Z
9239065 9239065 20260118082614_UdwD9 US000K 2026-01-21T14:45:20.943Z 2026-01-26T15:04:06.798Z
9239058 9239058 20260118070622_0ETAf US000K 2026-01-21T14:45:14.998Z 2026-01-26T15:03:57.245Z
9238995 9238995 20260119081916_Xf9Y4 US000K 2026-01-21T14:40:06.217Z 2026-01-27T15:06:31.619Z
9238989 9238989 20260119071158_1mxWZ US000K 2026-01-21T14:39:58.723Z 2026-01-27T15:06:22.307Z
9238847 9238847 20260120095836_5FlUU US000K 2026-01-21T14:30:41.418Z 2026-01-28T15:03:03.846Z
9238716 9238716 20260120093829_P0WGq US000K 2026-01-21T14:30:27.037Z 2026-01-28T15:02:47.396Z
9238556 9238556 20260120090035_O55eu US000K 2026-01-21T14:29:56.884Z 2026-01-28T15:02:38.580Z
9238410 9238410 20260120083649_8rLdX US000K 2026-01-21T14:29:31.013Z 2026-01-28T15:02:32.511Z
9238286 9238286 20260120081541_T4J3S US000K 2026-01-21T14:29:06.296Z 2026-01-28T15:02:18.047Z
9238075 9238075 20260120071526_eMNj6 US000K 2026-01-21T14:28:26.884Z 2026-01-28T15:02:06.384Z
9238051 9238051 20260120070950_lXSkd US000K 2026-01-21T14:28:24.612Z 2026-01-28T15:02:05.140Z
9237942 9237942 20260120063217_Dxs68 US000K 2026-01-21T14:28:06.793Z 2026-01-28T15:02:00.000Z
9237882 9237882 20260120061619_ozJ2i US000K 2026-01-21T14:27:52.163Z 2026-01-28T15:01:55.948Z
9233007 9233007 20260120130522_dqOJU US000K 2026-01-21T14:04:12.714Z 2026-01-29T15:00:35.345Z
9232943 9232943 20260120125413_j3R2o US000K 2026-01-21T14:03:52.674Z 2026-01-29T15:00:28.545Z
9232869 9232869 20260120124322_ApDUi US000K 2026-01-21T14:03:36.546Z 2026-01-29T15:00:21.431Z
9232810 9232810 20260120123145_AxZFC US000K 2026-01-21T14:03:19.541Z 2026-01-29T15:00:15.973Z
9232738 9232738 20260120122045_ulxIG US000K 2026-01-21T14:03:04.942Z 2026-01-29T15:00:01.141Z
9232719 9232719 20260120121430_xSlyD US000K 2026-01-21T14:03:01.234Z 2026-01-29T15:00:00.226Z
9232715 9232715 20260120121356_gHny6 US000K 2026-01-21T14:02:56.765Z 2026-01-29T15:00:00.029Z
9232610 9232610 20260120115743_SRUPJ US000K 2026-01-21T14:02:32.722Z 2026-01-29T14:59:53.177Z
9232496 9232496 20260120113752_LGbyX US000K 2026-01-21T14:02:04.070Z 2026-01-29T14:59:46.644Z
9232441 9232441 20260120112850_Q8HA2 US000K 2026-01-21T14:01:53.619Z 2026-01-29T14:59:42.700Z
9232424 9232424 20260120112413_Z6THd US000K 2026-01-21T14:01:47.091Z 2026-01-29T14:59:33.530Z
9232318 9232318 20260120110513_7WCyp US000K 2026-01-21T14:01:17.668Z 2026-01-29T14:59:25.914Z
9232267 9232267 20260120105452_yqds2 US000K 2026-01-21T14:01:02.524Z 2026-01-29T14:59:22.289Z
9232232 9232232 20260120104725_VKAtS US000K 2026-01-21T14:00:54.070Z 2026-01-29T14:59:20.668Z
9232208 9232208 20260120104232_ifN00 US000K 2026-01-21T14:00:50.228Z 2026-01-29T14:59:20.171Z
9232138 9232138 20260120102919_1xqtN US000K 2026-01-21T14:00:27.687Z 2026-01-29T14:59:15.335Z
9232121 9232121 20260120102513_31Ed1 US000K 2026-01-21T14:00:24.629Z 2026-01-29T14:59:14.395Z
9231904 9231904 20260119101323_F4kEl US000K 2026-01-20T14:34:45.270Z 2026-01-27T15:07:05.093Z
9231389 9231389 20260119074722_zNYZn US000K 2026-01-20T14:32:35.959Z 2026-01-27T15:06:27.412Z
9231341 9231341 20260119072517_K3my9 US000K 2026-01-20T14:32:25.214Z 2026-01-27T15:06:24.794Z
9229414 9229414 20260119014229_B6MsT US000K 2026-01-20T14:22:26.312Z 2026-01-27T15:03:24.053Z
9226422 9226422 20260119115857_mdLel US000K 2026-01-20T14:03:07.123Z 2026-01-28T14:54:59.429Z

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