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,660 rows where station_code = "KR003L" 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
9607945 9607945 20260404200109_yY1a4 KR003L 2026-04-05T12:05:00.637Z 2026-04-06T12:16:14.583Z
9607938 9607938 20260404193921_3mFsj KR003L 2026-04-05T12:04:59.010Z 2026-04-06T12:16:14.572Z
9583917 9583917 20260326201036_FafTT KR003L 2026-03-27T12:10:07.076Z 2026-04-04T12:41:53.042Z
9583875 9583875 20260326192215_Yf6fw KR003L 2026-03-27T12:09:59.310Z 2026-04-04T12:41:49.217Z
9583761 9583761 20260326174409_42TsM KR003L 2026-03-27T12:09:41.791Z 2026-04-04T12:41:37.488Z
9583736 9583736 20260326173641_Yjeb2 KR003L 2026-03-27T12:09:37.950Z 2026-04-04T12:41:34.611Z
9583629 9583629 20260326164351_bE520 KR003L 2026-03-27T12:09:21.213Z 2026-04-04T12:41:28.801Z
9575147 9575147 20260323185905_1S0a6 KR003L 2026-03-25T12:20:24.246Z 2026-03-31T12:28:49.604Z
9575061 9575061 20260323182848_Q69jV KR003L 2026-03-25T12:20:12.570Z 2026-03-31T12:28:47.384Z
9570090 9570090 20260322190900_flNGQ KR003L 2026-03-24T12:22:34.099Z 2026-03-30T12:30:27.627Z
9570055 9570055 20260322190125_tR3jy KR003L 2026-03-24T12:22:31.452Z 2026-03-30T12:30:27.098Z
9570013 9570013 20260322185152_3QsG1 KR003L 2026-03-24T12:22:28.080Z 2026-03-30T12:30:26.358Z
9569973 9569973 20260322183852_GbyFN KR003L 2026-03-24T12:22:24.476Z 2026-03-30T12:30:25.523Z
9569870 9569870 20260322181230_HuS6F KR003L 2026-03-24T12:22:16.270Z 2026-03-30T12:30:22.596Z
9569854 9569854 20260322180413_T1lH5 KR003L 2026-03-24T12:22:15.275Z 2026-03-30T12:30:22.333Z
9551097 9551097 20260320182028_G3Uuf KR003L 2026-03-22T12:26:10.291Z 2026-03-28T12:36:39.920Z
9545528 9545528 20260321104502_W04wv KR003L 2026-03-22T12:09:38.660Z 2026-03-29T12:19:41.037Z
9541303 9541303 20260319201401_k3ZRe KR003L 2026-03-21T12:28:48.679Z 2026-03-27T12:42:36.334Z
9541067 9541067 20260319191737_4RBGi KR003L 2026-03-21T12:28:28.124Z 2026-03-27T12:42:33.586Z
9541005 9541005 20260319185245_ukJDu KR003L 2026-03-21T12:28:22.604Z 2026-03-27T12:42:32.837Z
9540971 9540971 20260319184520_6RwF5 KR003L 2026-03-21T12:28:20.253Z 2026-03-27T12:42:32.566Z
9540922 9540922 20260319183306_JngYR KR003L 2026-03-21T12:28:16.958Z 2026-03-27T12:42:32.037Z
9540850 9540850 20260319181523_E1Zsl KR003L 2026-03-21T12:28:13.138Z 2026-03-27T12:42:31.499Z
9540516 9540516 20260319160625_l02nX KR003L 2026-03-21T12:27:07.743Z 2026-03-27T12:42:23.495Z
9540466 9540466 20260319154615_hN7cE KR003L 2026-03-21T12:27:01.669Z 2026-03-27T12:42:22.271Z
9529966 9529966 20260318194747_ZuP0T KR003L 2026-03-20T12:23:52.121Z 2026-03-26T12:39:07.850Z
9473838 9473838 20260313200751_Fi3d2 KR003L 2026-03-14T12:16:02.793Z 2026-03-21T12:50:15.551Z
9473836 9473836 20260313200727_nc2Ko KR003L 2026-03-14T12:16:02.386Z 2026-03-21T12:50:14.680Z
9473822 9473822 20260313195607_dtNnq KR003L 2026-03-14T12:16:00.375Z 2026-03-21T12:50:11.675Z
9473814 9473814 20260313194843_DugcZ KR003L 2026-03-14T12:15:59.327Z 2026-03-21T12:50:09.994Z
9473652 9473652 20260313174748_63ziL KR003L 2026-03-14T12:15:32.042Z 2026-03-21T12:49:59.116Z
9473573 9473573 20260313172325_dLbh5 KR003L 2026-03-14T12:15:20.221Z 2026-03-21T12:49:58.680Z
9473562 9473562 20260313172159_3CxXq KR003L 2026-03-14T12:15:19.003Z 2026-03-21T12:49:58.643Z
9473467 9473467 20260313170200_FXNGZ KR003L 2026-03-14T12:15:07.529Z 2026-03-21T12:49:57.975Z
9473298 9473298 20260313163222_HtvTw KR003L 2026-03-14T12:14:47.830Z 2026-03-21T12:49:55.659Z
9473059 9473059 20260313154325_0Q3Zl KR003L 2026-03-14T12:14:26.050Z 2026-03-21T12:49:53.812Z
9473015 9473015 20260313153634_UHe4T KR003L 2026-03-14T12:14:18.825Z 2026-03-21T12:49:53.298Z
9472743 9472743 20260313145533_MAtBK KR003L 2026-03-14T12:13:49.201Z 2026-03-21T12:49:51.633Z
9454621 9454621 20260310163601_wbjle KR003L 2026-03-11T12:09:35.164Z 2026-03-18T12:39:47.753Z
9454404 9454404 20260310161036_Rfeq0 KR003L 2026-03-11T12:09:13.122Z 2026-03-18T12:39:45.666Z
9454306 9454306 20260310155650_qse19 KR003L 2026-03-11T12:09:03.136Z 2026-03-18T12:39:44.861Z
9454231 9454231 20260310154201_PHFzq KR003L 2026-03-11T12:08:57.431Z 2026-03-18T12:39:44.419Z
9454195 9454195 20260310153753_sOrXa KR003L 2026-03-11T12:08:55.158Z 2026-03-18T12:39:44.182Z
9444487 9444487 20260308141124_kveZG KR003L 2026-03-09T12:11:01.057Z 2026-03-16T12:44:29.951Z
9439363 9439363 20260307133023_DS0R2 KR003L 2026-03-08T12:10:13.015Z 2026-03-15T12:41:42.076Z
9439342 9439342 20260307132335_wHGYp KR003L 2026-03-08T12:10:09.017Z 2026-03-15T12:41:41.831Z
9439256 9439256 20260307125646_oHOqo KR003L 2026-03-08T12:09:56.564Z 2026-03-15T12:41:41.153Z
9408559 9408559 20260227194055_mi5zd KR003L 2026-02-28T14:26:02.859Z 2026-03-07T14:50:58.092Z
9408530 9408530 20260227193433_NOt7l KR003L 2026-02-28T14:25:59.618Z 2026-03-07T14:50:56.868Z
9389502 9389502 20260224190403_oA4Lr KR003L 2026-02-25T14:24:59.560Z 2026-03-04T14:19:17.749Z
9389341 9389341 20260224183034_C3WaW KR003L 2026-02-25T14:24:42.098Z 2026-03-04T14:19:15.591Z
9389221 9389221 20260224180501_qRhLj KR003L 2026-02-25T14:24:30.064Z 2026-03-04T14:19:14.124Z
9381151 9381151 20260222210739_JvyFJ KR003L 2026-02-24T14:24:19.454Z 2026-02-24T14:24:19.454Z
9380973 9380973 20260222204021_3qjsg KR003L 2026-02-24T14:23:59.387Z 2026-02-24T14:23:59.387Z
9380592 9380592 20260222200116_MiTqg KR003L 2026-02-24T14:23:28.636Z 2026-02-24T14:23:28.636Z
9380567 9380567 20260222195926_FSqvz KR003L 2026-02-24T14:23:27.088Z 2026-02-24T14:23:27.088Z
9380107 9380107 20260222185421_gia23 KR003L 2026-02-24T14:22:39.083Z 2026-02-24T14:22:39.083Z
9380066 9380066 20260222184849_I6u7z KR003L 2026-02-24T14:22:35.563Z 2026-02-24T14:22:35.563Z
9380005 9380005 20260222184212_v0eSv KR003L 2026-02-24T14:22:31.265Z 2026-02-24T14:22:31.265Z
9379906 9379906 20260222182539_lp8iY KR003L 2026-02-24T14:22:20.359Z 2026-02-24T14:22:20.359Z
9379888 9379888 20260222182321_8KRIZ KR003L 2026-02-24T14:22:18.674Z 2026-02-24T14:22:18.674Z
9379469 9379469 20260222171351_nzXpC KR003L 2026-02-24T14:21:35.903Z 2026-02-24T14:21:35.903Z
9379303 9379303 20260222163721_b7aR1 KR003L 2026-02-24T14:21:09.477Z 2026-02-24T14:21:09.477Z
9378351 9378351 20260222132916_3GKD1 KR003L 2026-02-24T14:18:22.870Z 2026-02-24T14:18:22.870Z
9378342 9378342 20260222132622_t7JRD KR003L 2026-02-24T14:18:19.924Z 2026-02-24T14:18:19.924Z
9378190 9378190 20260222122236_nfO93 KR003L 2026-02-24T14:17:33.993Z 2026-02-24T14:17:33.993Z
9375117 9375117 20260223104250_oHqBj KR003L 2026-02-24T14:08:01.595Z 2026-03-03T14:31:41.102Z
9375088 9375088 20260223103840_WTk8A KR003L 2026-02-24T14:07:58.576Z 2026-03-03T14:31:40.800Z
9371887 9371887 20260221200551_sTT4W KR003L 2026-02-23T14:25:29.297Z 2026-03-02T14:22:17.056Z
9371739 9371739 20260221192822_CtOSS KR003L 2026-02-23T14:25:07.435Z 2026-03-02T14:22:14.920Z
9371684 9371684 20260221191410_yRRvQ KR003L 2026-02-23T14:24:54.953Z 2026-03-02T14:22:14.188Z
9371498 9371498 20260221182557_XMi7y KR003L 2026-02-23T14:24:29.224Z 2026-03-02T14:22:11.022Z
9371492 9371492 20260221182512_Na9L2 KR003L 2026-02-23T14:24:25.104Z 2026-03-02T14:22:10.937Z
9371413 9371413 20260221180522_8ylUW KR003L 2026-02-23T14:24:12.429Z 2026-03-02T14:22:10.196Z
9357765 9357765 20260219195250_uhJZq KR003L 2026-02-21T14:16:46.670Z 2026-02-28T14:44:42.074Z
9357763 9357763 20260219195247_IYiXl KR003L 2026-02-21T14:16:46.175Z 2026-02-28T14:44:42.041Z
9357008 9357008 20260219160329_Li5vz KR003L 2026-02-21T14:14:45.854Z 2026-02-28T14:44:16.103Z
9351515 9351515 20260217202656_3jtCz KR003L 2026-02-20T14:02:44.974Z 2026-02-26T14:40:08.597Z
9351446 9351446 20260217201038_Pp4kx KR003L 2026-02-20T14:02:44.664Z 2026-02-26T14:40:07.544Z
9351259 9351259 20260217185308_MBTE3 KR003L 2026-02-20T14:02:42.497Z 2026-02-26T14:40:04.582Z
9351006 9351006 20260217161740_3XgYx KR003L 2026-02-20T14:02:36.604Z 2026-02-26T14:39:41.134Z
9350897 9350897 20260217141901_tYAF4 KR003L 2026-02-20T14:02:31.745Z 2026-02-26T14:39:37.600Z
9350360 9350360 20260218202753_YuKXM KR003L 2026-02-20T14:02:00.646Z 2026-02-27T14:35:59.136Z
9348771 9348771 20260218162156_7yZrd KR003L 2026-02-20T14:01:55.445Z 2026-02-27T14:35:35.029Z
9347998 9347998 20260218145755_2YYpb KR003L 2026-02-20T14:01:53.318Z 2026-02-27T14:35:13.020Z
9347773 9347773 20260218142843_Kn6m3 KR003L 2026-02-20T14:01:52.839Z 2026-02-27T14:35:09.818Z
9339388 9339388 20260216182735_mUmEf KR003L 2026-02-18T14:20:29.906Z 2026-02-25T14:42:39.175Z
9339358 9339358 20260216180122_LFZWU KR003L 2026-02-18T14:20:16.755Z 2026-02-25T14:42:37.054Z
9329741 9329741 20260214194742_OAtlC KR003L 2026-02-16T14:20:51.211Z 2026-02-23T14:47:35.085Z
9329724 9329724 20260214192822_0JMUA KR003L 2026-02-16T14:20:46.064Z 2026-02-23T14:47:34.771Z
9329644 9329644 20260214190513_dz3k1 KR003L 2026-02-16T14:20:23.954Z 2026-02-23T14:47:33.075Z
9329601 9329601 20260214184147_VYI1t KR003L 2026-02-16T14:20:11.624Z 2026-02-23T14:47:32.232Z
9329283 9329283 20260215183821_vfXf8 KR003L 2026-02-16T14:12:33.225Z 2026-02-24T14:42:42.501Z
9319081 9319081 20260211180652_HH0qF KR003L 2026-02-13T14:20:03.765Z 2026-02-20T14:05:28.259Z
9318946 9318946 20260211140559_yYOPn KR003L 2026-02-13T14:17:07.536Z 2026-02-20T14:05:18.551Z
9318890 9318890 20260212202458_IbuAH KR003L 2026-02-13T14:13:57.086Z 2026-02-21T14:37:38.197Z
9318844 9318844 20260212195458_UWPjE KR003L 2026-02-13T14:13:34.644Z 2026-02-21T14:37:36.518Z
9318793 9318793 20260212191428_5EQz3 KR003L 2026-02-13T14:13:16.804Z 2026-02-21T14:37:34.197Z
9318765 9318765 20260212185746_23dRm KR003L 2026-02-13T14:13:06.590Z 2026-02-21T14:37:32.405Z
9318739 9318739 20260212184200_Cdndy KR003L 2026-02-13T14:12:59.399Z 2026-02-21T14:37:30.792Z

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