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

4,504 rows where station_code = "KR000F" 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
9271348 9271348 20260128214152_S9teW KR000F 2026-01-29T14:16:08.524Z 2026-01-29T14:16:08.524Z
9271260 9271260 20260128204039_20lHJ KR000F 2026-01-29T14:15:42.600Z 2026-01-29T14:15:42.600Z
9270977 9270977 20260128190546_zh2lg KR000F 2026-01-29T14:14:43.498Z 2026-01-29T14:14:43.498Z
9270913 9270913 20260128184815_Fcsvj KR000F 2026-01-29T14:14:33.553Z 2026-01-29T14:14:33.553Z
9270763 9270763 20260128173640_vuBX3 KR000F 2026-01-29T14:13:50.391Z 2026-01-29T14:13:50.391Z
9270741 9270741 20260128171412_PBwdz KR000F 2026-01-29T14:13:39.935Z 2026-01-29T14:13:39.935Z
9269593 9269593 20260128134024_ivCCl KR000F 2026-01-29T14:08:39.744Z 2026-01-29T14:08:39.744Z
9269371 9269371 20260128130907_ynzgm KR000F 2026-01-29T14:07:40.407Z 2026-01-29T14:07:40.407Z
9269239 9269239 20260128125018_EhU2f KR000F 2026-01-29T14:07:05.234Z 2026-01-29T14:07:05.234Z
9267028 9267028 20260126181230_516dW KR000F 2026-01-28T14:18:26.111Z 2026-01-29T14:33:59.231Z
9266793 9266793 20260127212706_rQlt7 KR000F 2026-01-28T14:14:36.307Z 2026-01-29T14:30:25.219Z
9266764 9266764 20260127210710_yBm52 KR000F 2026-01-28T14:14:31.757Z 2026-01-29T14:30:25.213Z
9266756 9266756 20260127210444_72iqS KR000F 2026-01-28T14:14:27.946Z 2026-01-29T14:30:25.212Z
9266681 9266681 20260127203934_CmhMB KR000F 2026-01-28T14:14:16.341Z 2026-01-29T14:30:25.172Z
9266629 9266629 20260127201032_dAqHK KR000F 2026-01-28T14:14:07.700Z 2026-01-29T14:30:25.143Z
9266618 9266618 20260127200800_2mBtN KR000F 2026-01-28T14:14:06.530Z 2026-01-29T14:30:25.141Z
9266591 9266591 20260127200140_RnG5u KR000F 2026-01-28T14:13:57.745Z 2026-01-29T14:30:25.134Z
9266584 9266584 20260127200124_QUFzR KR000F 2026-01-28T14:13:57.139Z 2026-01-29T14:30:25.134Z
9266490 9266490 20260127193157_NOGoK KR000F 2026-01-28T14:13:42.074Z 2026-01-29T14:30:25.049Z
9266462 9266462 20260127192415_QyrJs KR000F 2026-01-28T14:13:37.839Z 2026-01-29T14:30:25.033Z
9266440 9266440 20260127192334_Z0eWn KR000F 2026-01-28T14:13:36.519Z 2026-01-29T14:30:25.032Z
9266403 9266403 20260127191441_Ay8Jy KR000F 2026-01-28T14:13:25.491Z 2026-01-29T14:30:25.021Z
9266363 9266363 20260127185908_T80uD KR000F 2026-01-28T14:13:18.566Z 2026-01-28T14:13:18.566Z
9266145 9266145 20260127174124_HID2r KR000F 2026-01-28T14:12:38.679Z 2026-01-29T14:30:24.896Z
9266139 9266139 20260127173920_8aNgx KR000F 2026-01-28T14:12:37.434Z 2026-01-29T14:30:24.895Z
9266045 9266045 20260127165316_WBxqJ KR000F 2026-01-28T14:12:15.528Z 2026-01-29T14:30:24.830Z
9265998 9265998 20260127163216_GiYnN KR000F 2026-01-28T14:12:06.947Z 2026-01-29T14:30:24.811Z
9265618 9265618 20260127154202_YVKiR KR000F 2026-01-28T14:10:45.262Z 2026-01-29T14:30:24.624Z
9265434 9265434 20260127151558_E38pF KR000F 2026-01-28T14:10:10.589Z 2026-01-29T14:30:24.549Z
9263800 9263800 20260127101500_JUaSV KR000F 2026-01-28T14:02:52.547Z 2026-01-29T14:30:18.940Z
9263221 9263221 20260124141041_2OHkY KR000F 2026-01-27T14:19:38.543Z 2026-01-29T14:41:21.477Z
9262494 9262494 20260126213801_SZR5r KR000F 2026-01-27T14:09:20.109Z 2026-01-29T14:34:44.718Z
9262466 9262466 20260126205732_J7zIu KR000F 2026-01-27T14:09:14.833Z 2026-01-29T14:34:36.728Z
9262464 9262464 20260126205709_M7sP9 KR000F 2026-01-27T14:09:14.095Z 2026-01-27T14:09:14.095Z
9262462 9262462 20260126205201_KaYd3 KR000F 2026-01-27T14:09:13.374Z 2026-01-29T14:34:36.371Z
9262445 9262445 20260126203834_PeVXr KR000F 2026-01-27T14:09:05.439Z 2026-01-29T14:34:34.896Z
9262408 9262408 20260126202144_2AMzI KR000F 2026-01-27T14:08:57.365Z 2026-01-29T14:34:29.409Z
9262388 9262388 20260126201436_W2Yxx KR000F 2026-01-27T14:08:54.414Z 2026-01-29T14:34:28.519Z
9262367 9262367 20260126200022_fwYBL KR000F 2026-01-27T14:08:49.263Z 2026-01-29T14:34:26.275Z
9262334 9262334 20260126193547_iEt35 KR000F 2026-01-27T14:08:43.828Z 2026-01-29T14:34:21.712Z
9262294 9262294 20260126185526_6sAXY KR000F 2026-01-27T14:08:30.443Z 2026-01-29T14:34:16.922Z
9262285 9262285 20260126184838_v5emn KR000F 2026-01-27T14:08:25.975Z 2026-01-27T14:08:25.975Z
9262257 9262257 20260126183845_7tL0N KR000F 2026-01-27T14:08:20.895Z 2026-01-29T14:34:12.503Z
9262253 9262253 20260126183717_OzCR2 KR000F 2026-01-27T14:08:20.287Z 2026-01-29T14:34:12.164Z
9262234 9262234 20260126182620_C37og KR000F 2026-01-27T14:08:17.279Z 2026-01-29T14:34:02.685Z
9262214 9262214 20260126181552_2cc33 KR000F 2026-01-27T14:08:13.043Z 2026-01-29T14:34:00.228Z
9262208 9262208 20260126181420_bYGXy KR000F 2026-01-27T14:08:11.766Z 2026-01-29T14:33:59.711Z
9262203 9262203 20260126181415_o3fZT KR000F 2026-01-27T14:08:11.105Z 2026-01-29T14:33:59.537Z
9259561 9259561 20260124212929_UsHEP KR000F 2026-01-26T14:17:28.312Z 2026-01-29T14:43:06.244Z
9259530 9259530 20260124212004_SWXHQ KR000F 2026-01-26T14:17:24.281Z 2026-01-29T14:43:04.803Z
9259429 9259429 20260124204610_3p4pp KR000F 2026-01-26T14:16:58.535Z 2026-01-29T14:42:54.285Z
9259416 9259416 20260124204503_1TBWV KR000F 2026-01-26T14:16:57.559Z 2026-01-29T14:42:53.956Z
9259385 9259385 20260124204019_AVv8i KR000F 2026-01-26T14:16:51.246Z 2026-01-29T14:42:50.757Z
9259345 9259345 20260124203059_UhST0 KR000F 2026-01-26T14:16:40.000Z 2026-01-26T14:23:12.998Z
9259312 9259312 20260124201408_3sep7 KR000F 2026-01-26T14:16:30.389Z 2026-01-29T14:42:47.293Z
9259210 9259210 20260124194126_zLo7M KR000F 2026-01-26T14:16:10.631Z 2026-01-29T14:42:42.893Z
9259183 9259183 20260124193108_32pFl KR000F 2026-01-26T14:16:02.629Z 2026-01-29T14:42:41.730Z
9259130 9259130 20260124190210_27cwn KR000F 2026-01-26T14:15:52.629Z 2026-01-29T14:42:38.145Z
9259066 9259066 20260124183630_K87GL KR000F 2026-01-26T14:15:34.182Z 2026-01-29T14:42:28.769Z
9259061 9259061 20260124183629_oKngO KR000F 2026-01-26T14:15:33.769Z 2026-01-29T14:42:28.559Z
9258945 9258945 20260124180614_7bAdg KR000F 2026-01-26T14:15:08.020Z 2026-01-29T14:42:20.377Z
9258934 9258934 20260124180443_fuZcm KR000F 2026-01-26T14:15:07.010Z 2026-01-29T14:42:20.087Z
9258928 9258928 20260124180404_gdXaH KR000F 2026-01-26T14:15:06.198Z 2026-01-29T14:42:19.934Z
9258871 9258871 20260124174653_OADww KR000F 2026-01-26T14:14:52.568Z 2026-01-29T14:42:16.225Z
9258860 9258860 20260124174214_7On23 KR000F 2026-01-26T14:14:50.800Z 2026-01-29T14:42:15.612Z
9258680 9258680 20260124160506_pqhCz KR000F 2026-01-26T14:13:53.977Z 2026-01-29T14:41:52.108Z
9258668 9258668 20260124155759_j9ADt KR000F 2026-01-26T14:13:46.008Z 2026-01-29T14:41:50.282Z
9258656 9258656 20260124154543_ZCfY1 KR000F 2026-01-26T14:13:40.208Z 2026-01-29T14:41:48.747Z
9258604 9258604 20260124150836_m9ckJ KR000F 2026-01-26T14:13:18.417Z 2026-01-29T14:41:40.780Z
9258551 9258551 20260124142717_VvEQa KR000F 2026-01-26T14:12:56.077Z 2026-01-29T14:41:25.139Z
9258517 9258517 20260124141040_3ovAt KR000F 2026-01-26T14:12:39.138Z 2026-01-29T14:41:21.313Z
9258463 9258463 20260124131632_qZZBi KR000F 2026-01-26T14:12:18.617Z 2026-01-29T14:41:05.878Z
9258166 9258166 20260125191931_kQtK1 KR000F 2026-01-26T14:09:53.842Z 2026-01-29T14:38:06.491Z
9258120 9258120 20260125185939_kPnDn KR000F 2026-01-26T14:09:40.126Z 2026-01-26T14:09:40.126Z
9258071 9258071 20260125182238_ARGm4 KR000F 2026-01-26T14:09:25.434Z 2026-01-29T14:38:01.797Z
9258022 9258022 20260125180708_FzupH KR000F 2026-01-26T14:09:10.890Z 2026-01-26T14:09:10.890Z
9257971 9257971 20260125173630_zO4iZ KR000F 2026-01-26T14:08:50.276Z 2026-01-26T14:08:50.276Z
9257798 9257798 20260125155939_JNWg3 KR000F 2026-01-26T14:07:48.144Z 2026-01-29T14:37:41.693Z
9256832 9256832 20260125104019_vYnDt KR000F 2026-01-26T14:02:11.539Z 2026-01-29T14:36:26.362Z
9254805 9254805 20260123213052_maxyU KR000F 2026-01-25T14:10:47.567Z 2026-01-29T14:46:43.241Z
9254800 9254800 20260123212534_wMtcj KR000F 2026-01-25T14:10:47.079Z 2026-01-29T14:46:43.120Z
9254715 9254715 20260123210222_El32B KR000F 2026-01-25T14:10:27.302Z 2026-01-29T14:46:37.324Z
9254652 9254652 20260123203910_ALSaH KR000F 2026-01-25T14:10:15.777Z 2026-01-29T14:46:34.077Z
9254585 9254585 20260123201608_AqFCV KR000F 2026-01-25T14:09:58.553Z 2026-01-29T14:46:31.209Z
9254524 9254524 20260123195554_cWhll KR000F 2026-01-25T14:09:38.372Z 2026-01-29T14:46:28.521Z
9254507 9254507 20260123194947_x1qi8 KR000F 2026-01-25T14:09:32.765Z 2026-01-29T14:46:27.451Z
9254472 9254472 20260123193356_3eTBl KR000F 2026-01-25T14:09:23.433Z 2026-01-29T14:46:25.543Z
9254432 9254432 20260123191730_a7GHL KR000F 2026-01-25T14:09:08.134Z 2026-01-29T14:46:23.508Z
9254399 9254399 20260123185745_LWQxN KR000F 2026-01-25T14:08:59.962Z 2026-01-29T14:46:14.019Z
9254388 9254388 20260123184951_3mIoM KR000F 2026-01-25T14:08:57.228Z 2026-01-29T14:46:13.370Z
9251402 9251402 20260122200157_OprOp KR000F 2026-01-24T14:11:37.288Z 2026-01-29T14:51:39.226Z
9251287 9251287 20260122193551_pXD3s KR000F 2026-01-24T14:11:09.077Z 2026-01-29T14:51:27.176Z
9251230 9251230 20260122191559_Bf5Mw KR000F 2026-01-24T14:10:49.049Z 2026-01-29T14:51:21.382Z
9250998 9250998 20260122174246_Tz3z1 KR000F 2026-01-24T14:09:20.217Z 2026-01-29T14:50:51.978Z
9250916 9250916 20260122170545_RPTtT KR000F 2026-01-24T14:08:45.834Z 2026-01-29T14:50:45.873Z
9250843 9250843 20260122160559_rH2h1 KR000F 2026-01-24T14:08:01.830Z 2026-01-29T14:50:38.540Z
9250644 9250644 20260122114829_u7QhG KR000F 2026-01-24T14:04:52.672Z 2026-01-29T14:49:24.341Z
9248020 9248020 20260121211101_VuXbQ KR000F 2026-01-23T14:11:44.330Z 2026-01-29T14:56:48.747Z
9248000 9248000 20260121210602_uZ3sl KR000F 2026-01-23T14:11:42.345Z 2026-01-29T14:56:47.955Z
9247957 9247957 20260121204702_f3r6i KR000F 2026-01-23T14:11:37.325Z 2026-01-29T14:56:45.657Z

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