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,931 rows where station_code = "KR002R" 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
8686932 8686932 20251203211705_Eejpb KR002R 2025-12-05T14:13:12.763Z 2025-12-06T14:22:12.254Z
8680048 8680048 20251202212717_SkbvP KR002R 2025-12-04T14:10:59.020Z 2025-12-06T14:26:48.934Z
8680044 8680044 20251202212418_BzBgB KR002R 2025-12-04T14:10:58.183Z 2025-12-06T14:26:48.576Z
8679928 8679928 20251202211128_dzH0l KR002R 2025-12-04T14:10:47.104Z 2025-12-06T14:26:44.512Z
8679910 8679910 20251202211052_IeXUS KR002R 2025-12-04T14:10:45.835Z 2025-12-06T14:26:43.662Z
8670662 8670662 20251201095424_UQ3Dx KR002R 2025-12-03T14:09:40.758Z 2025-12-06T14:30:14.873Z
8670607 8670607 20251201094029_hOwoh KR002R 2025-12-03T14:09:29.426Z 2025-12-06T14:30:11.435Z
8644790 8644790 20251128195744_pLMbH KR002R 2025-11-30T14:22:33.601Z 2025-12-06T14:54:47.359Z
8644017 8644017 20251128185007_r362v KR002R 2025-11-30T14:21:11.815Z 2025-12-06T14:54:36.933Z
8643333 8643333 20251128174355_nhcnu KR002R 2025-11-30T14:19:54.220Z 2025-12-06T14:53:47.833Z
8643188 8643188 20251128173137_mKfS7 KR002R 2025-11-30T14:19:25.826Z 2025-12-06T14:53:42.847Z
8643181 8643181 20251128173041_S925x KR002R 2025-11-30T14:19:25.292Z 2025-12-06T14:53:42.512Z
8643095 8643095 20251128172033_HAxIu KR002R 2025-11-30T14:19:19.231Z 2025-12-06T14:53:40.477Z
8643024 8643024 20251128171247_KYTtj KR002R 2025-11-30T14:19:13.937Z 2025-12-06T14:53:39.485Z
8642508 8642508 20251128161411_NGQoZ KR002R 2025-11-30T14:18:03.673Z 2025-12-06T14:53:32.995Z
8642429 8642429 20251128160318_iK3yG KR002R 2025-11-30T14:17:53.989Z 2025-12-06T14:53:31.487Z
8642375 8642375 20251128155905_DgRg0 KR002R 2025-11-30T14:17:50.880Z 2025-12-06T14:53:30.806Z
8640823 8640823 20251128115245_MluF0 KR002R 2025-11-30T14:11:06.841Z 2025-12-06T14:51:27.801Z
8640814 8640814 20251128113954_w9R6R KR002R 2025-11-30T14:11:00.042Z 2025-12-06T14:51:25.559Z
8620879 8620879 20251126134958_1DobO KR002R 2025-11-28T14:14:17.536Z 2025-12-05T15:02:38.355Z
8565323 8565323 20251121201919_hPyMj KR002R 2025-11-23T14:12:59.419Z 2025-11-30T15:04:54.457Z
8565187 8565187 20251121200131_Nynjy KR002R 2025-11-23T14:12:43.319Z 2025-11-30T15:04:44.925Z
8565004 8565004 20251121193728_5pFxi KR002R 2025-11-23T14:12:14.448Z 2025-11-30T15:04:38.968Z
8564825 8564825 20251121191614_T87Ef KR002R 2025-11-23T14:11:46.782Z 2025-11-30T15:04:29.190Z
8564793 8564793 20251121191311_IuuUu KR002R 2025-11-23T14:11:43.483Z 2025-11-30T15:04:28.698Z
8563993 8563993 20251121174442_xjUQA KR002R 2025-11-23T14:09:43.028Z 2025-11-30T15:03:57.343Z
8563916 8563916 20251121173926_CCce7 KR002R 2025-11-23T14:09:36.175Z 2025-11-30T15:03:53.952Z
8563828 8563828 20251121172810_EfMx8 KR002R 2025-11-23T14:09:25.558Z 2025-11-30T15:03:46.979Z
8562664 8562664 20251121143633_FtY5r KR002R 2025-11-23T14:06:18.907Z 2025-11-30T15:03:32.229Z
8548546 8548546 20251120210031_0xH7C KR002R 2025-11-22T14:17:14.181Z 2025-11-29T14:54:22.816Z
8548523 8548523 20251120205941_3G2Fb KR002R 2025-11-22T14:17:07.375Z 2025-11-29T14:54:22.794Z
8548170 8548170 20251120204014_2YEl2 KR002R 2025-11-22T14:16:25.672Z 2025-11-29T14:54:22.082Z
8548072 8548072 20251120203456_crxH3 KR002R 2025-11-22T14:16:15.568Z 2025-11-29T14:54:21.776Z
8547996 8547996 20251120202825_YSMwE KR002R 2025-11-22T14:16:09.571Z 2025-11-29T14:54:21.618Z
8547073 8547073 20251120191927_Vh1Sk KR002R 2025-11-22T14:14:15.453Z 2025-11-29T14:54:18.519Z
8546553 8546553 20251120183824_xgbpP KR002R 2025-11-22T14:13:06.151Z 2025-11-29T14:54:16.044Z
8546474 8546474 20251120183312_ctYot KR002R 2025-11-22T14:12:49.115Z 2025-11-29T14:54:15.530Z
8546470 8546470 20251120183312_nCgGq KR002R 2025-11-22T14:12:48.883Z 2025-11-29T14:54:15.528Z
8546343 8546343 20251120182212_268eW KR002R 2025-11-22T14:12:35.106Z 2025-11-29T14:54:12.960Z
8545771 8545771 20251120172927_wahnT KR002R 2025-11-22T14:11:11.664Z 2025-11-29T14:54:06.241Z
8545552 8545552 20251120170431_ChPz3 KR002R 2025-11-22T14:10:49.053Z 2025-11-29T14:54:03.592Z
8545504 8545504 20251120165638_79XpP KR002R 2025-11-22T14:10:36.403Z 2025-11-29T14:54:03.500Z
8545291 8545291 20251120163612_cBqnI KR002R 2025-11-22T14:10:15.302Z 2025-11-29T14:54:02.391Z
8545237 8545237 20251120162944_ALckF KR002R 2025-11-22T14:10:01.350Z 2025-11-29T14:54:02.099Z
8545194 8545194 20251120162438_GVvyS KR002R 2025-11-22T14:09:56.169Z 2025-11-29T14:54:01.730Z
8545040 8545040 20251120160253_02Dfg KR002R 2025-11-22T14:09:32.859Z 2025-11-29T14:53:57.601Z
8545037 8545037 20251120160140_cXmBe KR002R 2025-11-22T14:09:32.351Z 2025-11-29T14:53:57.574Z
8544901 8544901 20251120154456_v02x4 KR002R 2025-11-22T14:09:13.096Z 2025-11-29T14:53:56.624Z
8544862 8544862 20251120154116_eX9RP KR002R 2025-11-22T14:09:09.014Z 2025-11-29T14:53:56.466Z
8544766 8544766 20251120153137_w421F KR002R 2025-11-22T14:08:49.396Z 2025-11-29T14:53:51.257Z
8544460 8544460 20251120151434_uc5BU KR002R 2025-11-22T14:08:00.568Z 2025-11-29T14:53:46.632Z
8543827 8543827 20251120142807_cMk87 KR002R 2025-11-22T14:06:16.253Z 2025-11-29T14:53:30.946Z
8543634 8543634 20251120140833_a5MpP KR002R 2025-11-22T14:05:44.144Z 2025-11-29T14:53:27.561Z
8543240 8543240 20251120133716_YCuXo KR002R 2025-11-22T14:04:28.381Z 2025-11-29T14:53:21.293Z
8542629 8542629 20251120123414_Oo7zl KR002R 2025-11-22T14:02:42.865Z 2025-11-29T14:53:13.748Z
8542388 8542388 20251120120858_8lcaN KR002R 2025-11-22T14:01:59.163Z 2025-11-29T14:53:11.192Z
8525486 8525486 20251118105950_r1qDY KR002R 2025-11-20T14:37:00.012Z 2025-11-26T15:08:29.940Z
8505768 8505768 20251117204225_6BfUo KR002R 2025-11-19T14:11:19.685Z 2025-11-26T15:07:39.652Z
8490555 8490555 20251116195017_w9uEu KR002R 2025-11-18T14:14:28.798Z 2025-11-25T15:08:21.403Z
8490416 8490416 20251116192815_qMX03 KR002R 2025-11-18T14:13:57.384Z 2025-11-25T15:08:15.735Z
8490342 8490342 20251116191516_BgIeZ KR002R 2025-11-18T14:13:43.310Z 2025-11-25T15:08:13.488Z
8490105 8490105 20251116183245_29W3Y KR002R 2025-11-18T14:12:45.411Z 2025-11-25T15:07:57.802Z
8489987 8489987 20251116181501_EETvl KR002R 2025-11-18T14:12:15.120Z 2025-11-25T15:07:56.278Z
8489937 8489937 20251116180646_oKj3b KR002R 2025-11-18T14:12:07.509Z 2025-11-25T15:07:54.254Z
8489640 8489640 20251116171436_BGgSx KR002R 2025-11-18T14:10:56.741Z 2025-11-25T15:07:34.742Z
8486136 8486136 20251115111839_tgsd3 KR002R 2025-11-17T14:34:11.487Z 2025-11-23T15:20:23.501Z
8484472 8484472 20251115094500_VKV3E KR002R 2025-11-17T14:32:48.381Z 2025-11-23T15:19:37.550Z
8473241 8473241 20251115120445_LDTCD KR002R 2025-11-17T14:01:37.305Z 2025-11-24T15:02:33.476Z
8467544 8467544 20251114203009_r28oE KR002R 2025-11-16T14:14:59.849Z 2025-11-23T15:17:09.837Z
8467297 8467297 20251114200108_smybU KR002R 2025-11-16T14:14:21.918Z 2025-11-23T15:17:08.041Z
8466809 8466809 20251114190412_7ULfT KR002R 2025-11-16T14:13:09.549Z 2025-11-23T15:17:05.120Z
8466702 8466702 20251114185315_5nI3u KR002R 2025-11-16T14:12:45.241Z 2025-11-23T15:17:04.441Z
8466333 8466333 20251114182050_GQjv9 KR002R 2025-11-16T14:11:52.624Z 2025-11-23T15:17:02.304Z
8466315 8466315 20251114181848_laWcP KR002R 2025-11-16T14:11:49.564Z 2025-11-23T15:17:02.171Z
8466304 8466304 20251114181746_jI2zF KR002R 2025-11-16T14:11:48.039Z 2025-11-23T15:17:02.077Z
8466282 8466282 20251114181447_fnmQa KR002R 2025-11-16T14:11:44.441Z 2025-11-23T15:17:01.956Z
8466173 8466173 20251114180400_7xC9B KR002R 2025-11-16T14:11:14.961Z 2025-11-23T15:17:01.146Z
8466140 8466140 20251114175918_abYbb KR002R 2025-11-16T14:11:10.459Z 2025-11-23T15:17:00.853Z
8466121 8466121 20251114175332_bEHAR KR002R 2025-11-16T14:11:08.169Z 2025-11-23T15:17:00.724Z
8466051 8466051 20251114174408_b3JV3 KR002R 2025-11-16T14:11:01.250Z 2025-11-23T15:17:00.257Z
8465459 8465459 20251114163403_Y2P9T KR002R 2025-11-16T14:09:17.460Z 2025-11-23T15:16:56.164Z
8465146 8465146 20251114155806_Q3elg KR002R 2025-11-16T14:08:29.295Z 2025-11-23T15:16:49.060Z
8465008 8465008 20251114153915_DWYiP KR002R 2025-11-16T14:07:56.245Z 2025-11-23T15:16:38.179Z
8464985 8464985 20251114153621_WWtGs KR002R 2025-11-16T14:07:53.000Z 2025-11-23T15:16:34.823Z
8464690 8464690 20251114151406_vnEs6 KR002R 2025-11-16T14:07:07.843Z 2025-11-23T15:16:29.993Z
8464199 8464199 20251114142535_2I4iN KR002R 2025-11-16T14:05:29.088Z 2025-11-23T15:16:12.757Z
8463879 8463879 20251114135338_QsiVl KR002R 2025-11-16T14:04:36.156Z 2025-11-23T15:16:05.278Z
8463781 8463781 20251114134159_RDI2U KR002R 2025-11-16T14:04:23.961Z 2025-11-23T15:16:04.140Z
8463252 8463252 20251114124802_bFeH3 KR002R 2025-11-16T14:02:35.216Z 2025-11-23T15:15:47.945Z
8463182 8463182 20251114123917_tC7E3 KR002R 2025-11-16T14:02:18.655Z 2025-11-23T15:15:45.931Z
8462713 8462713 20251114115212_5S6sh KR002R 2025-11-16T14:00:20.603Z 2025-11-23T15:15:29.578Z
8447779 8447779 20251112204206_eP2Eg KR002R 2025-11-14T14:15:18.033Z 2025-11-21T15:11:21.986Z
8447352 8447352 20251112193513_WKFkZ KR002R 2025-11-14T14:13:54.767Z 2025-11-21T15:11:17.951Z
8447347 8447347 20251112193417_xVoNx KR002R 2025-11-14T14:13:54.045Z 2025-11-21T15:11:17.910Z
8447161 8447161 20251112190432_kM8Ui KR002R 2025-11-14T14:13:15.735Z 2025-11-21T15:11:16.548Z
8446625 8446625 20251112180013_lOYa9 KR002R 2025-11-14T14:11:25.480Z 2025-11-21T15:11:12.296Z
8446581 8446581 20251112175338_BkXPN KR002R 2025-11-14T14:11:19.953Z 2025-11-21T15:11:11.843Z
8446486 8446486 20251112173526_RBRKB KR002R 2025-11-14T14:10:58.339Z 2025-11-21T15:11:11.104Z
8446393 8446393 20251112172332_OK0dp KR002R 2025-11-14T14:10:39.951Z 2025-11-21T15:11:09.859Z
8446286 8446286 20251112171004_1lhB5 KR002R 2025-11-14T14:10:07.297Z 2025-11-21T15:11:08.926Z

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