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

3,559 rows where station_code = "KR002T" 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
8686557 8686557 20251203200123_lbKqg KR002T 2025-12-05T14:12:17.240Z 2025-12-06T14:21:57.442Z
8679901 8679901 20251202210657_20izf KR002T 2025-12-04T14:10:37.812Z 2025-12-06T14:26:42.958Z
8663521 8663521 20251130205635_xgRjW KR002T 2025-12-02T14:18:24.184Z 2025-12-06T14:40:02.138Z
8663326 8663326 20251130203057_8Nd5c KR002T 2025-12-02T14:17:58.770Z 2025-12-06T14:39:57.909Z
8663190 8663190 20251130202019_LP25K KR002T 2025-12-02T14:17:37.680Z 2025-12-06T14:39:55.816Z
8663051 8663051 20251130200016_EHTU9 KR002T 2025-12-02T14:17:20.814Z 2025-12-06T14:39:45.020Z
8662953 8662953 20251130195015_xwkwP KR002T 2025-12-02T14:17:09.552Z 2025-12-06T14:39:36.466Z
8662254 8662254 20251130182319_Wp1ah KR002T 2025-12-02T14:14:50.636Z 2025-12-06T14:38:57.166Z
8649623 8649623 20251129175738_kDrOr KR002T 2025-12-01T14:13:21.803Z 2025-12-06T14:45:34.732Z
8643841 8643841 20251128183055_iqW8v KR002T 2025-11-30T14:20:44.180Z 2025-12-06T14:54:24.186Z
8643156 8643156 20251128172910_pnCmX KR002T 2025-11-30T14:19:23.929Z 2025-12-06T14:53:42.105Z
8643133 8643133 20251128172704_04daJ KR002T 2025-11-30T14:19:22.171Z 2025-12-06T14:53:41.398Z
8642916 8642916 20251128170207_1rJsB KR002T 2025-11-30T14:18:58.783Z 2025-12-06T14:53:37.800Z
8642853 8642853 20251128165527_DFCOK KR002T 2025-11-30T14:18:43.559Z 2025-12-06T14:53:36.937Z
8642826 8642826 20251128165346_22ktm KR002T 2025-11-30T14:18:41.692Z 2025-12-06T14:53:36.730Z
8642681 8642681 20251128163628_WfWWj KR002T 2025-11-30T14:18:27.628Z 2025-12-06T14:53:34.900Z
8642567 8642567 20251128162403_UP7SE KR002T 2025-11-30T14:18:18.915Z 2025-12-06T14:53:33.649Z
8642499 8642499 20251128161306_1yFQx KR002T 2025-11-30T14:18:02.885Z 2025-12-06T14:53:32.759Z
8642077 8642077 20251128153003_oo7Dx KR002T 2025-11-30T14:17:19.426Z 2025-12-06T14:53:15.149Z
8641571 8641571 20251128145928_HzW22 KR002T 2025-11-30T14:16:33.076Z 2025-12-06T14:52:38.853Z
8641351 8641351 20251128143526_lqMID KR002T 2025-11-30T14:15:47.264Z 2025-12-06T14:52:32.228Z
8641303 8641303 20251128142217_CnerE KR002T 2025-11-30T14:15:26.287Z 2025-12-06T14:52:30.246Z
8641056 8641056 20251128133154_EVOVU KR002T 2025-11-30T14:13:58.823Z 2025-12-06T14:52:21.059Z
8621481 8621481 20251126152125_rvdne KR002T 2025-11-28T14:15:47.877Z 2025-12-05T15:02:44.642Z
8621462 8621462 20251126151415_3s5Ar KR002T 2025-11-28T14:15:44.689Z 2025-12-05T15:02:44.457Z
8620964 8620964 20251126140415_L1flR KR002T 2025-11-28T14:14:26.359Z 2025-12-05T15:02:39.184Z
8619899 8619899 20251126111326_GmL6y KR002T 2025-11-28T14:10:55.041Z 2025-12-05T15:01:11.280Z
8619850 8619850 20251126110722_l1GPO KR002T 2025-11-28T14:10:37.799Z 2025-12-05T15:01:10.362Z
8619594 8619594 20251126103043_wMd5v KR002T 2025-11-28T14:09:34.455Z 2025-12-05T15:01:02.502Z
8619216 8619216 20251126092852_RVq7f KR002T 2025-11-28T14:07:52.277Z 2025-12-05T15:00:53.574Z
8565240 8565240 20251121200621_XtzrJ KR002T 2025-11-23T14:12:50.176Z 2025-11-30T15:04:53.207Z
8564503 8564503 20251121183600_GepAs KR002T 2025-11-23T14:10:59.549Z 2025-11-30T15:04:23.407Z
8564446 8564446 20251121183015_VlV73 KR002T 2025-11-23T14:10:49.873Z 2025-11-30T15:04:18.941Z
8564094 8564094 20251121175239_RFiez KR002T 2025-11-23T14:10:02.943Z 2025-11-30T15:04:05.518Z
8564007 8564007 20251121174726_mhAGF KR002T 2025-11-23T14:09:52.583Z 2025-11-30T15:03:58.755Z
8563917 8563917 20251121173926_CCce7 KR002T 2025-11-23T14:09:36.175Z 2025-11-30T15:03:53.952Z
8563756 8563756 20251121171734_z87Iz KR002T 2025-11-23T14:09:07.794Z 2025-11-30T15:03:43.984Z
8563488 8563488 20251121162638_DuxI5 KR002T 2025-11-23T14:08:24.779Z 2025-11-30T15:03:39.934Z
8562546 8562546 20251121142535_jhHXl KR002T 2025-11-23T14:05:57.761Z 2025-11-30T15:03:30.751Z
8562007 8562007 20251121132351_dQ22D KR002T 2025-11-23T14:04:21.299Z 2025-11-30T15:03:21.037Z
8561235 8561235 20251121115203_P1D72 KR002T 2025-11-23T14:02:07.209Z 2025-11-30T15:02:52.011Z
8560957 8560957 20251121112430_3DcK3 KR002T 2025-11-23T14:01:24.566Z 2025-11-30T15:02:41.772Z
8545977 8545977 20251120174430_MndKb KR002T 2025-11-22T14:11:40.553Z 2025-11-29T14:54:07.640Z
8545946 8545946 20251120174206_uMZBP KR002T 2025-11-22T14:11:35.927Z 2025-11-29T14:54:07.345Z
8545741 8545741 20251120172557_QOkuX KR002T 2025-11-22T14:11:07.571Z 2025-11-29T14:54:05.796Z
8545590 8545590 20251120170929_tdSCJ KR002T 2025-11-22T14:10:52.275Z 2025-11-29T14:54:03.899Z
8545577 8545577 20251120170715_hCeEY KR002T 2025-11-22T14:10:51.818Z 2025-11-29T14:54:03.850Z
8545464 8545464 20251120165415_OjF7f KR002T 2025-11-22T14:10:33.961Z 2025-11-29T14:54:03.234Z
8545426 8545426 20251120165205_Lb4tJ KR002T 2025-11-22T14:10:31.074Z 2025-11-29T14:54:02.909Z
8545314 8545314 20251120163939_0Mtj1 KR002T 2025-11-22T14:10:17.990Z 2025-11-29T14:54:02.414Z
8545303 8545303 20251120163910_IIJPT KR002T 2025-11-22T14:10:17.510Z 2025-11-29T14:54:02.402Z
8545295 8545295 20251120163729_zmeCD KR002T 2025-11-22T14:10:16.442Z 2025-11-29T14:54:02.397Z
8544577 8544577 20251120152142_uhxMe KR002T 2025-11-22T14:08:23.414Z 2025-11-29T14:53:48.183Z
8543917 8543917 20251120143445_4tKh3 KR002T 2025-11-22T14:06:27.727Z 2025-11-29T14:53:31.307Z
8543758 8543758 20251120142131_hKEEv KR002T 2025-11-22T14:06:05.747Z 2025-11-29T14:53:29.172Z
8543648 8543648 20251120141016_nE6Hl KR002T 2025-11-22T14:05:45.578Z 2025-11-29T14:53:27.765Z
8542970 8542970 20251120131559_SIfej KR002T 2025-11-22T14:03:45.379Z 2025-11-29T14:53:17.196Z
8542931 8542931 20251120131016_BZTM8 KR002T 2025-11-22T14:03:34.098Z 2025-11-29T14:53:16.674Z
8542462 8542462 20251120121628_9mg6F KR002T 2025-11-22T14:02:16.006Z 2025-11-29T14:53:12.137Z
8533915 8533915 20251119210432_cv3Pa KR002T 2025-11-21T14:12:32.408Z 2025-11-28T14:55:23.529Z
8525453 8525453 20251118105439_MGjqp KR002T 2025-11-20T14:36:57.661Z 2025-11-26T15:08:29.290Z
8506235 8506235 20251117211307_NeO3K KR002T 2025-11-19T14:12:27.810Z 2025-11-26T15:07:41.087Z
8506203 8506203 20251117210942_n3AtH KR002T 2025-11-19T14:12:24.199Z 2025-11-26T15:07:41.013Z
8490793 8490793 20251116202803_KcQyQ KR002T 2025-11-18T14:15:19.340Z 2025-11-25T15:08:26.356Z
8490625 8490625 20251116200301_5xIHe KR002T 2025-11-18T14:14:53.789Z 2025-11-25T15:08:24.665Z
8490502 8490502 20251116194055_isFUI KR002T 2025-11-18T14:14:21.049Z 2025-11-25T15:08:20.547Z
8490014 8490014 20251116181901_9XjaE KR002T 2025-11-18T14:12:18.431Z 2025-11-25T15:07:56.370Z
8489938 8489938 20251116180646_oKj3b KR002T 2025-11-18T14:12:07.509Z 2025-11-25T15:07:54.254Z
8489842 8489842 20251116174623_iii2k KR002T 2025-11-18T14:11:41.061Z 2025-11-25T15:07:45.316Z
8489805 8489805 20251116174117_Cqcks KR002T 2025-11-18T14:11:34.488Z 2025-11-25T15:07:41.822Z
8489727 8489727 20251116172900_27qTy KR002T 2025-11-18T14:11:12.896Z 2025-11-25T15:07:40.747Z
8472079 8472079 20251114104514_xr6Dw KR002T 2025-11-16T14:32:59.771Z 2025-11-22T15:24:00.604Z
8472004 8472004 20251114103505_f0VFs KR002T 2025-11-16T14:32:53.679Z 2025-11-22T15:23:56.034Z
8471975 8471975 20251114102926_35Si4 KR002T 2025-11-16T14:32:28.089Z 2025-11-22T15:23:52.883Z
8467167 8467167 20251114194534_v0Fmy KR002T 2025-11-16T14:13:58.342Z 2025-11-23T15:17:07.297Z
8467094 8467094 20251114193728_dagl7 KR002T 2025-11-16T14:13:49.377Z 2025-11-23T15:17:06.619Z
8467061 8467061 20251114193106_7pav7 KR002T 2025-11-16T14:13:45.122Z 2025-11-23T15:17:06.354Z
8467020 8467020 20251114192712_RiP6V KR002T 2025-11-16T14:13:31.851Z 2025-11-23T15:17:06.177Z
8466926 8466926 20251114191834_5uybB KR002T 2025-11-16T14:13:21.206Z 2025-11-23T15:17:05.744Z
8466830 8466830 20251114190631_YuWgM KR002T 2025-11-16T14:13:12.264Z 2025-11-23T15:17:05.183Z
8466750 8466750 20251114185621_im6vB KR002T 2025-11-16T14:12:58.482Z 2025-11-23T15:17:04.713Z
8466090 8466090 20251114174912_9PqYi KR002T 2025-11-16T14:11:04.406Z 2025-11-23T15:17:00.530Z
8465987 8465987 20251114173604_gs9cM KR002T 2025-11-16T14:10:50.406Z 2025-11-23T15:16:59.936Z
8465706 8465706 20251114170031_Xo1ER KR002T 2025-11-16T14:09:53.712Z 2025-11-23T15:16:57.743Z
8465679 8465679 20251114165924_FmsFK KR002T 2025-11-16T14:09:51.693Z 2025-11-23T15:16:57.564Z
8465358 8465358 20251114162638_2VZRi KR002T 2025-11-16T14:09:08.995Z 2025-11-23T15:16:54.569Z
8465134 8465134 20251114155616_v2H92 KR002T 2025-11-16T14:08:27.709Z 2025-11-23T15:16:48.947Z
8465117 8465117 20251114155157_0FNp9 KR002T 2025-11-16T14:08:24.752Z 2025-11-23T15:16:43.798Z
8465099 8465099 20251114155044_0ggO2 KR002T 2025-11-16T14:08:21.609Z 2025-11-23T15:16:43.151Z
8464865 8464865 20251114152548_DBMoB KR002T 2025-11-16T14:07:37.297Z 2025-11-23T15:16:32.347Z
8464355 8464355 20251114144103_r028n KR002T 2025-11-16T14:05:59.804Z 2025-11-23T15:16:17.060Z
8464338 8464338 20251114144020_sb2aB KR002T 2025-11-16T14:05:58.458Z 2025-11-23T15:16:17.000Z
8464089 8464089 20251114141520_9kwOL KR002T 2025-11-16T14:05:13.710Z 2025-11-23T15:16:09.935Z
8463955 8463955 20251114140140_yProk KR002T 2025-11-16T14:04:50.935Z 2025-11-23T15:16:06.477Z
8457471 8457471 20251113203016_i4A93 KR002T 2025-11-15T14:13:38.188Z 2025-11-22T15:20:51.699Z
8457078 8457078 20251113195049_KiKk8 KR002T 2025-11-15T14:12:42.200Z 2025-11-22T15:20:48.934Z
8456695 8456695 20251113191353_IUQW8 KR002T 2025-11-15T14:11:57.105Z 2025-11-22T15:20:45.855Z
8456111 8456111 20251113180719_9jAWk KR002T 2025-11-15T14:10:33.000Z 2025-11-22T15:20:39.580Z
8456042 8456042 20251113180109_QQ9tV KR002T 2025-11-15T14:10:18.866Z 2025-11-22T15:20:37.158Z
8456028 8456028 20251113175726_13RV0 KR002T 2025-11-15T14:10:17.158Z 2025-11-22T15:20:36.676Z

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