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

9,069 rows where station_code = "KR0011" 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
9271349 9271349 20260128214152_S9teW KR0011 2026-01-29T14:16:08.524Z 2026-01-29T14:16:08.524Z
9271343 9271343 20260128213235_eeqGp KR0011 2026-01-29T14:16:07.604Z 2026-01-29T14:16:07.604Z
9271257 9271257 20260128203952_2P724 KR0011 2026-01-29T14:15:42.103Z 2026-01-29T14:15:42.103Z
9271240 9271240 20260128203607_aIcE1 KR0011 2026-01-29T14:15:39.892Z 2026-01-29T14:15:39.892Z
9271210 9271210 20260128202449_tLQlG KR0011 2026-01-29T14:15:35.065Z 2026-01-29T14:15:35.065Z
9271071 9271071 20260128194527_ND32z KR0011 2026-01-29T14:15:07.121Z 2026-01-29T14:15:07.121Z
9271044 9271044 20260128192739_T9f6p KR0011 2026-01-29T14:15:01.930Z 2026-01-29T14:15:01.930Z
9271017 9271017 20260128192416_zPR5f KR0011 2026-01-29T14:14:58.581Z 2026-01-29T14:14:58.581Z
9270980 9270980 20260128190546_zh2lg KR0011 2026-01-29T14:14:43.498Z 2026-01-29T14:14:43.498Z
9270932 9270932 20260128185538_76Hbj KR0011 2026-01-29T14:14:36.578Z 2026-01-29T14:14:36.578Z
9270931 9270931 20260128185415_8G4Nr KR0011 2026-01-29T14:14:36.004Z 2026-01-29T14:14:36.004Z
9270914 9270914 20260128184815_Fcsvj KR0011 2026-01-29T14:14:33.553Z 2026-01-29T14:14:33.553Z
9270860 9270860 20260128182034_2tWfj KR0011 2026-01-29T14:14:16.642Z 2026-01-29T14:14:16.642Z
9270828 9270828 20260128180115_yLQBZ KR0011 2026-01-29T14:14:08.499Z 2026-01-29T14:14:08.499Z
9270802 9270802 20260128174838_U9GjM KR0011 2026-01-29T14:14:01.085Z 2026-01-29T14:14:01.085Z
9270799 9270799 20260128174513_2Rba2 KR0011 2026-01-29T14:14:00.252Z 2026-01-29T14:14:00.252Z
9270766 9270766 20260128173640_vuBX3 KR0011 2026-01-29T14:13:50.392Z 2026-01-29T14:13:50.392Z
9270742 9270742 20260128171412_PBwdz KR0011 2026-01-29T14:13:39.935Z 2026-01-29T14:13:39.935Z
9269241 9269241 20260128125018_EhU2f KR0011 2026-01-29T14:07:05.261Z 2026-01-29T14:07:05.261Z
9268564 9268564 20260128104705_hiMF3 KR0011 2026-01-29T14:03:49.462Z 2026-01-29T14:03:49.462Z
9267964 9267964 20260125190629_XCeTL KR0011 2026-01-28T14:26:51.235Z 2026-01-29T14:38:05.320Z
9266810 9266810 20260127213038_68yMG KR0011 2026-01-28T14:14:38.436Z 2026-01-29T14:30:25.222Z
9266799 9266799 20260127212707_7WFEA KR0011 2026-01-28T14:14:36.913Z 2026-01-29T14:30:25.219Z
9266781 9266781 20260127211647_HzH0g KR0011 2026-01-28T14:14:34.001Z 2026-01-29T14:30:25.215Z
9266759 9266759 20260127210444_72iqS KR0011 2026-01-28T14:14:27.946Z 2026-01-29T14:30:25.212Z
9266666 9266666 20260127203024_2S0Gj KR0011 2026-01-28T14:14:13.889Z 2026-01-29T14:30:25.166Z
9266631 9266631 20260127201032_dAqHK KR0011 2026-01-28T14:14:07.700Z 2026-01-29T14:30:25.143Z
9266625 9266625 20260127200843_l2N2E KR0011 2026-01-28T14:14:07.257Z 2026-01-29T14:30:25.142Z
9266586 9266586 20260127200124_QUFzR KR0011 2026-01-28T14:13:57.139Z 2026-01-29T14:30:25.134Z
9266530 9266530 20260127194414_F8VpI KR0011 2026-01-28T14:13:47.113Z 2026-01-29T14:30:25.069Z
9266454 9266454 20260127192404_4Edb2 KR0011 2026-01-28T14:13:37.170Z 2026-01-29T14:30:25.032Z
9266444 9266444 20260127192334_Z0eWn KR0011 2026-01-28T14:13:36.519Z 2026-01-29T14:30:25.032Z
9266406 9266406 20260127191441_Ay8Jy KR0011 2026-01-28T14:13:25.492Z 2026-01-29T14:30:25.021Z
9266401 9266401 20260127191404_Twk4C KR0011 2026-01-28T14:13:25.146Z 2026-01-29T14:30:25.020Z
9266365 9266365 20260127185908_T80uD KR0011 2026-01-28T14:13:18.566Z 2026-01-28T14:13:18.566Z
9266308 9266308 20260127184805_6dT6P KR0011 2026-01-28T14:13:12.292Z 2026-01-29T14:30:24.991Z
9266263 9266263 20260127183331_NW0id KR0011 2026-01-28T14:13:06.707Z 2026-01-29T14:30:24.969Z
9266158 9266158 20260127174457_2t6Y2 KR0011 2026-01-28T14:12:39.926Z 2026-01-29T14:30:24.900Z
9266148 9266148 20260127174124_HID2r KR0011 2026-01-28T14:12:38.679Z 2026-01-29T14:30:24.896Z
9266141 9266141 20260127173920_8aNgx KR0011 2026-01-28T14:12:37.435Z 2026-01-29T14:30:24.895Z
9266134 9266134 20260127173748_yhSZx KR0011 2026-01-28T14:12:32.725Z 2026-01-29T14:30:24.894Z
9266075 9266075 20260127170914_45U3r KR0011 2026-01-28T14:12:20.306Z 2026-01-29T14:30:24.845Z
9266057 9266057 20260127165906_RlJDV KR0011 2026-01-28T14:12:16.855Z 2026-01-29T14:30:24.837Z
9266047 9266047 20260127165316_WBxqJ KR0011 2026-01-28T14:12:15.528Z 2026-01-29T14:30:24.830Z
9266017 9266017 20260127163607_014KC KR0011 2026-01-28T14:12:08.882Z 2026-01-29T14:30:24.813Z
9266008 9266008 20260127163451_OycvQ KR0011 2026-01-28T14:12:07.970Z 2026-01-29T14:30:24.813Z
9265999 9265999 20260127163216_GiYnN KR0011 2026-01-28T14:12:06.947Z 2026-01-29T14:30:24.811Z
9265466 9265466 20260127151835_28I6g KR0011 2026-01-28T14:10:14.858Z 2026-01-29T14:30:24.556Z
9263809 9263809 20260127101512_M03vN KR0011 2026-01-28T14:02:53.721Z 2026-01-29T14:30:18.946Z
9262498 9262498 20260126213801_SZR5r KR0011 2026-01-27T14:09:20.109Z 2026-01-29T14:34:44.718Z
9262490 9262490 20260126212508_VGdBM KR0011 2026-01-27T14:09:19.603Z 2026-01-29T14:34:44.433Z
9262486 9262486 20260126212255_qXr2k KR0011 2026-01-27T14:09:19.147Z 2026-01-29T14:34:44.248Z
9262477 9262477 20260126211310_2o6xZ KR0011 2026-01-27T14:09:17.073Z 2026-01-29T14:34:37.573Z
9262469 9262469 20260126210326_u0LFw KR0011 2026-01-27T14:09:15.645Z 2026-01-29T14:34:37.084Z
9262452 9262452 20260126204050_PpqKK KR0011 2026-01-27T14:09:06.106Z 2026-01-29T14:34:35.061Z
9262447 9262447 20260126203834_PeVXr KR0011 2026-01-27T14:09:05.439Z 2026-01-29T14:34:34.896Z
9262422 9262422 20260126202321_TK2ye KR0011 2026-01-27T14:08:59.310Z 2026-01-29T14:34:30.143Z
9262415 9262415 20260126202217_Y6gQG KR0011 2026-01-27T14:08:57.975Z 2026-01-29T14:34:29.718Z
9262398 9262398 20260126201942_q5Q62 KR0011 2026-01-27T14:08:55.785Z 2026-01-29T14:34:29.230Z
9262391 9262391 20260126201436_W2Yxx KR0011 2026-01-27T14:08:54.414Z 2026-01-29T14:34:28.519Z
9262371 9262371 20260126200328_hH90H KR0011 2026-01-27T14:08:49.814Z 2026-01-27T14:08:49.814Z
9262369 9262369 20260126200022_fwYBL KR0011 2026-01-27T14:08:49.263Z 2026-01-29T14:34:26.275Z
9262336 9262336 20260126193547_iEt35 KR0011 2026-01-27T14:08:43.828Z 2026-01-29T14:34:21.712Z
9262319 9262319 20260126192048_GfrSU KR0011 2026-01-27T14:08:33.935Z 2026-01-29T14:34:18.691Z
9262315 9262315 20260126190900_2igPZ KR0011 2026-01-27T14:08:33.377Z 2026-01-29T14:34:18.210Z
9262299 9262299 20260126185745_ElYOc KR0011 2026-01-27T14:08:31.117Z 2026-01-27T14:08:31.117Z
9262288 9262288 20260126184838_v5emn KR0011 2026-01-27T14:08:25.976Z 2026-01-27T14:08:25.976Z
9262281 9262281 20260126184756_w4Suu KR0011 2026-01-27T14:08:24.868Z 2026-01-29T14:34:14.865Z
9262273 9262273 20260126184540_gvRmk KR0011 2026-01-27T14:08:23.592Z 2026-01-29T14:34:14.072Z
9262255 9262255 20260126183717_OzCR2 KR0011 2026-01-27T14:08:20.287Z 2026-01-29T14:34:12.164Z
9262252 9262252 20260126183703_QWzwB KR0011 2026-01-27T14:08:19.705Z 2026-01-29T14:34:11.667Z
9259542 9259542 20260124212109_2MFUE KR0011 2026-01-26T14:17:25.632Z 2026-01-29T14:43:05.229Z
9259533 9259533 20260124212004_SWXHQ KR0011 2026-01-26T14:17:24.281Z 2026-01-29T14:43:04.803Z
9259419 9259419 20260124204503_1TBWV KR0011 2026-01-26T14:16:57.559Z 2026-01-29T14:42:53.956Z
9259388 9259388 20260124204019_AVv8i KR0011 2026-01-26T14:16:51.246Z 2026-01-29T14:42:50.757Z
9259349 9259349 20260124203059_UhST0 KR0011 2026-01-26T14:16:40.000Z 2026-01-26T14:23:12.998Z
9259338 9259338 20260124202947_0CHk6 KR0011 2026-01-26T14:16:37.337Z 2026-01-29T14:42:48.662Z
9259315 9259315 20260124201408_3sep7 KR0011 2026-01-26T14:16:30.389Z 2026-01-29T14:42:47.293Z
9259295 9259295 20260124201207_YnQMw KR0011 2026-01-26T14:16:28.404Z 2026-01-29T14:42:46.653Z
9259267 9259267 20260124200608_HNLrC KR0011 2026-01-26T14:16:23.981Z 2026-01-29T14:42:45.527Z
9259263 9259263 20260124200312_jD4Dp KR0011 2026-01-26T14:16:23.412Z 2026-01-29T14:42:45.371Z
9259213 9259213 20260124194126_zLo7M KR0011 2026-01-26T14:16:10.631Z 2026-01-29T14:42:42.893Z
9259144 9259144 20260124190758_3N06G KR0011 2026-01-26T14:15:53.901Z 2026-01-29T14:42:38.629Z
9259134 9259134 20260124190210_27cwn KR0011 2026-01-26T14:15:52.629Z 2026-01-29T14:42:38.145Z
9259100 9259100 20260124185028_tSOMj KR0011 2026-01-26T14:15:41.601Z 2026-01-29T14:42:36.994Z
9259063 9259063 20260124183629_oKngO KR0011 2026-01-26T14:15:33.769Z 2026-01-29T14:42:28.559Z
9258961 9258961 20260124181502_Gn4Je KR0011 2026-01-26T14:15:10.814Z 2026-01-29T14:42:21.393Z
9258937 9258937 20260124180443_fuZcm KR0011 2026-01-26T14:15:07.010Z 2026-01-29T14:42:20.087Z
9258931 9258931 20260124180404_gdXaH KR0011 2026-01-26T14:15:06.198Z 2026-01-29T14:42:19.934Z
9258874 9258874 20260124174653_OADww KR0011 2026-01-26T14:14:52.568Z 2026-01-29T14:42:16.225Z
9258863 9258863 20260124174214_7On23 KR0011 2026-01-26T14:14:50.800Z 2026-01-29T14:42:15.612Z
9258737 9258737 20260124163129_Ltxm8 KR0011 2026-01-26T14:14:05.730Z 2026-01-29T14:41:59.015Z
9258702 9258702 20260124161146_B3Sjm KR0011 2026-01-26T14:13:58.869Z 2026-01-29T14:41:53.959Z
9258684 9258684 20260124160506_pqhCz KR0011 2026-01-26T14:13:53.977Z 2026-01-29T14:41:52.108Z
9258609 9258609 20260124150837_Ju9Hq KR0011 2026-01-26T14:13:19.435Z 2026-01-29T14:41:40.902Z
9258520 9258520 20260124141040_3ovAt KR0011 2026-01-26T14:12:39.138Z 2026-01-29T14:41:21.313Z
9258514 9258514 20260124140726_wiZ1y KR0011 2026-01-26T14:12:38.318Z 2026-01-29T14:41:20.882Z
9258485 9258485 20260124132924_e4YLn KR0011 2026-01-26T14:12:26.959Z 2026-01-29T14:41:14.695Z
9258467 9258467 20260124131632_qZZBi KR0011 2026-01-26T14:12:18.617Z 2026-01-29T14:41:05.878Z
9258440 9258440 20260124125136_augrJ KR0011 2026-01-26T14:12:07.137Z 2026-01-29T14:40:58.994Z

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