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,297 rows where station_code = "KR003T" 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
9271693 9271693 20260127191636_d7b2L KR003T 2026-01-29T14:22:33.118Z 2026-01-29T14:30:25.025Z
9271346 9271346 20260128213708_Ma2l3 KR003T 2026-01-29T14:16:08.042Z 2026-01-29T14:16:08.042Z
9271316 9271316 20260128210838_c1Taq KR003T 2026-01-29T14:15:53.871Z 2026-01-29T14:15:53.871Z
9271311 9271311 20260128210615_BX3WM KR003T 2026-01-29T14:15:52.323Z 2026-01-29T14:15:52.323Z
9271302 9271302 20260128210315_h8SWt KR003T 2026-01-29T14:15:51.667Z 2026-01-29T14:15:51.667Z
9271278 9271278 20260128204707_imJvK KR003T 2026-01-29T14:15:44.799Z 2026-01-29T14:15:44.799Z
9271249 9271249 20260128203726_bP6Op KR003T 2026-01-29T14:15:41.134Z 2026-01-29T14:15:41.134Z
9271237 9271237 20260128203444_2oL9G KR003T 2026-01-29T14:15:39.090Z 2026-01-29T14:15:39.090Z
9271207 9271207 20260128202410_32bal KR003T 2026-01-29T14:15:34.461Z 2026-01-29T14:15:34.461Z
9271202 9271202 20260128202307_3MUgR KR003T 2026-01-29T14:15:33.781Z 2026-01-29T14:15:33.781Z
9271188 9271188 20260128202106_aBBTn KR003T 2026-01-29T14:15:32.328Z 2026-01-29T14:15:32.328Z
9271181 9271181 20260128202017_hVola KR003T 2026-01-29T14:15:31.741Z 2026-01-29T14:15:31.741Z
9271166 9271166 20260128201626_go50G KR003T 2026-01-29T14:15:29.196Z 2026-01-29T14:15:29.196Z
9271125 9271125 20260128200225_22qtm KR003T 2026-01-29T14:15:18.846Z 2026-01-29T14:15:18.846Z
9271120 9271120 20260128200220_yiiu8 KR003T 2026-01-29T14:15:18.313Z 2026-01-29T14:15:18.313Z
9271082 9271082 20260128194805_3exd1 KR003T 2026-01-29T14:15:09.069Z 2026-01-29T14:15:09.069Z
9271033 9271033 20260128192630_i6lsP KR003T 2026-01-29T14:15:00.309Z 2026-01-29T14:15:00.309Z
9271020 9271020 20260128192416_zPR5f KR003T 2026-01-29T14:14:58.581Z 2026-01-29T14:14:58.581Z
9270976 9270976 20260128190538_sLQBc KR003T 2026-01-29T14:14:42.625Z 2026-01-29T14:14:42.625Z
9270942 9270942 20260128185611_9YY2v KR003T 2026-01-29T14:14:37.924Z 2026-01-29T14:14:37.924Z
9270909 9270909 20260128184425_toI2L KR003T 2026-01-29T14:14:32.496Z 2026-01-29T14:14:32.496Z
9270894 9270894 20260128183247_CNj5r KR003T 2026-01-29T14:14:30.323Z 2026-01-29T14:14:30.323Z
9270810 9270810 20260128174941_Vlyit KR003T 2026-01-29T14:14:03.786Z 2026-01-29T14:14:03.786Z
9270768 9270768 20260128173640_vuBX3 KR003T 2026-01-29T14:13:50.392Z 2026-01-29T14:13:50.392Z
9270743 9270743 20260128171412_PBwdz KR003T 2026-01-29T14:13:39.935Z 2026-01-29T14:13:39.935Z
9270720 9270720 20260128165203_bB9T5 KR003T 2026-01-29T14:13:31.879Z 2026-01-29T14:13:31.879Z
9270301 9270301 20260128152923_gJhyB KR003T 2026-01-29T14:11:41.891Z 2026-01-29T14:11:41.891Z
9269730 9269730 20260128140101_H5hrm KR003T 2026-01-29T14:09:19.931Z 2026-01-29T14:09:19.931Z
9269305 9269305 20260128125941_ZnOfL KR003T 2026-01-29T14:07:25.237Z 2026-01-29T14:07:25.237Z
9268567 9268567 20260128104705_hiMF3 KR003T 2026-01-29T14:03:49.462Z 2026-01-29T14:03:49.462Z
9268478 9268478 20260128102728_o09Lt KR003T 2026-01-29T14:03:17.627Z 2026-01-29T14:03:17.627Z
9267241 9267241 20260126211742_3or8F KR003T 2026-01-28T14:20:38.285Z 2026-01-29T14:34:43.563Z
9267215 9267215 20260126203527_fCJH3 KR003T 2026-01-28T14:20:19.699Z 2026-01-29T14:34:34.208Z
9267192 9267192 20260126202321_fSNKk KR003T 2026-01-28T14:20:12.626Z 2026-01-29T14:34:30.299Z
9267184 9267184 20260126202217_jEG7S KR003T 2026-01-28T14:20:10.086Z 2026-01-29T14:34:29.546Z
9267157 9267157 20260126195758_cLJ1O KR003T 2026-01-28T14:19:46.865Z 2026-01-29T14:34:25.764Z
9267155 9267155 20260126195509_HaKx9 KR003T 2026-01-28T14:19:46.352Z 2026-01-29T14:34:25.616Z
9267081 9267081 20260126184756_JsbmJ KR003T 2026-01-28T14:19:04.067Z 2026-01-29T14:34:14.689Z
9267045 9267045 20260126182451_OmR57 KR003T 2026-01-28T14:18:38.744Z 2026-01-29T14:34:01.845Z
9266987 9266987 20260126173821_yLdXZ KR003T 2026-01-28T14:18:09.196Z 2026-01-29T14:33:52.694Z
9266956 9266956 20260126171530_DLZKb KR003T 2026-01-28T14:17:51.024Z 2026-01-29T14:33:48.232Z
9266946 9266946 20260126170822_BLUyx KR003T 2026-01-28T14:17:48.468Z 2026-01-29T14:33:47.431Z
9266785 9266785 20260127211647_HzH0g KR003T 2026-01-28T14:14:34.001Z 2026-01-29T14:30:25.215Z
9266763 9266763 20260127210444_72iqS KR003T 2026-01-28T14:14:27.946Z 2026-01-29T14:30:25.212Z
9266750 9266750 20260127210423_8V2dY KR003T 2026-01-28T14:14:26.895Z 2026-01-29T14:30:25.211Z
9266728 9266728 20260127205534_m9VQC KR003T 2026-01-28T14:14:22.568Z 2026-01-29T14:30:25.207Z
9266716 9266716 20260127205323_NfGeM KR003T 2026-01-28T14:14:21.535Z 2026-01-29T14:30:25.189Z
9266705 9266705 20260127204910_3q6VA KR003T 2026-01-28T14:14:20.244Z 2026-01-29T14:30:25.187Z
9266675 9266675 20260127203322_ZmKeG KR003T 2026-01-28T14:14:14.474Z 2026-01-29T14:30:25.168Z
9266659 9266659 20260127202747_T2fLV KR003T 2026-01-28T14:14:12.637Z 2026-01-29T14:30:25.165Z
9266610 9266610 20260127200441_kGq1N KR003T 2026-01-28T14:14:04.767Z 2026-01-29T14:30:25.138Z
9266598 9266598 20260127200413_qZtT4 KR003T 2026-01-28T14:14:02.297Z 2026-01-29T14:30:25.136Z
9266566 9266566 20260127195439_v1ilo KR003T 2026-01-28T14:13:53.823Z 2026-01-29T14:30:25.104Z
9266541 9266541 20260127194522_FpVEz KR003T 2026-01-28T14:13:48.303Z 2026-01-29T14:30:25.082Z
9266513 9266513 20260127194052_sjp3B KR003T 2026-01-28T14:13:45.139Z 2026-01-29T14:30:25.066Z
9266499 9266499 20260127193216_N0WX4 KR003T 2026-01-28T14:13:42.474Z 2026-01-29T14:30:25.049Z
9266478 9266478 20260127192728_SxMsN KR003T 2026-01-28T14:13:39.758Z 2026-01-29T14:30:25.038Z
9266460 9266460 20260127192404_4Edb2 KR003T 2026-01-28T14:13:37.170Z 2026-01-29T14:30:25.032Z
9266449 9266449 20260127192334_Z0eWn KR003T 2026-01-28T14:13:36.519Z 2026-01-29T14:30:25.032Z
9266424 9266424 20260127191635_hWWhv KR003T 2026-01-28T14:13:31.693Z 2026-01-28T14:13:31.693Z
9266416 9266416 20260127191508_3VIEJ KR003T 2026-01-28T14:13:26.812Z 2026-01-29T14:30:25.023Z
9266392 9266392 20260127190900_TV0wA KR003T 2026-01-28T14:13:22.593Z 2026-01-29T14:30:25.017Z
9266356 9266356 20260127185758_3rKoS KR003T 2026-01-28T14:13:16.675Z 2026-01-29T14:30:24.999Z
9266342 9266342 20260127185750_LRAhW KR003T 2026-01-28T14:13:15.690Z 2026-01-29T14:30:24.999Z
9266319 9266319 20260127185033_QlSx9 KR003T 2026-01-28T14:13:12.972Z 2026-01-29T14:30:24.993Z
9266276 9266276 20260127183358_19YYS KR003T 2026-01-28T14:13:07.318Z 2026-01-29T14:30:24.970Z
9266266 9266266 20260127183331_NW0id KR003T 2026-01-28T14:13:06.707Z 2026-01-29T14:30:24.969Z
9266241 9266241 20260127182032_IuoQd KR003T 2026-01-28T14:12:56.724Z 2026-01-29T14:30:24.945Z
9266234 9266234 20260127182014_lmww1 KR003T 2026-01-28T14:12:56.141Z 2026-01-29T14:30:24.945Z
9266205 9266205 20260127180316_Ot0qB KR003T 2026-01-28T14:12:49.490Z 2026-01-29T14:30:24.923Z
9266176 9266176 20260127175151_WuGcv KR003T 2026-01-28T14:12:42.969Z 2026-01-29T14:30:24.904Z
9266160 9266160 20260127174457_2t6Y2 KR003T 2026-01-28T14:12:39.926Z 2026-01-29T14:30:24.900Z
9266117 9266117 20260127172524_nncAn KR003T 2026-01-28T14:12:27.988Z 2026-01-29T14:30:24.882Z
9266106 9266106 20260127172135_vLeuB KR003T 2026-01-28T14:12:26.647Z 2026-01-28T14:12:26.647Z
9266061 9266061 20260127165906_RlJDV KR003T 2026-01-28T14:12:16.856Z 2026-01-29T14:30:24.837Z
9266044 9266044 20260127165025_TSyuY KR003T 2026-01-28T14:12:14.893Z 2026-01-29T14:30:24.829Z
9266011 9266011 20260127163451_OycvQ KR003T 2026-01-28T14:12:07.971Z 2026-01-29T14:30:24.813Z
9266003 9266003 20260127163216_GiYnN KR003T 2026-01-28T14:12:06.965Z 2026-01-29T14:30:24.811Z
9265981 9265981 20260127162703_GcTYW KR003T 2026-01-28T14:11:57.575Z 2026-01-29T14:30:24.805Z
9265968 9265968 20260127162405_53zME KR003T 2026-01-28T14:11:53.395Z 2026-01-29T14:30:24.801Z
9265940 9265940 20260127161642_ztGMb KR003T 2026-01-28T14:11:48.595Z 2026-01-29T14:30:24.740Z
9265599 9265599 20260127153715_Ipax1 KR003T 2026-01-28T14:10:39.517Z 2026-01-29T14:30:24.619Z
9265453 9265453 20260127151639_pt3IW KR003T 2026-01-28T14:10:12.316Z 2026-01-29T14:30:24.552Z
9265147 9265147 20260127142442_wN6um KR003T 2026-01-28T14:09:12.709Z 2026-01-29T14:30:24.467Z
9264285 9264285 20260127115651_XBhOD KR003T 2026-01-28T14:05:18.681Z 2026-01-29T14:30:20.577Z
9262511 9262511 20260125164120_141VQ KR003T 2026-01-27T14:11:51.289Z 2026-01-29T14:37:45.977Z
9259545 9259545 20260124212109_2MFUE KR003T 2026-01-26T14:17:25.632Z 2026-01-29T14:43:05.229Z
9259524 9259524 20260124211543_DvxKo KR003T 2026-01-26T14:17:22.968Z 2026-01-29T14:43:03.576Z
9259488 9259488 20260124210939_GyXSB KR003T 2026-01-26T14:17:10.916Z 2026-01-29T14:42:57.064Z
9259421 9259421 20260124204503_1TBWV KR003T 2026-01-26T14:16:57.559Z 2026-01-29T14:42:53.956Z
9259391 9259391 20260124204019_AVv8i KR003T 2026-01-26T14:16:51.246Z 2026-01-29T14:42:50.757Z
9259379 9259379 20260124203954_4XXmy KR003T 2026-01-26T14:16:50.020Z 2026-01-29T14:42:50.471Z
9259317 9259317 20260124201408_3sep7 KR003T 2026-01-26T14:16:30.389Z 2026-01-29T14:42:47.293Z
9259305 9259305 20260124201221_n2Dil KR003T 2026-01-26T14:16:28.841Z 2026-01-29T14:42:46.805Z
9259271 9259271 20260124200608_HNLrC KR003T 2026-01-26T14:16:23.981Z 2026-01-29T14:42:45.527Z
9259245 9259245 20260124195510_o1v2M KR003T 2026-01-26T14:16:19.560Z 2026-01-29T14:42:44.271Z
9259240 9259240 20260124195418_50pBE KR003T 2026-01-26T14:16:18.931Z 2026-01-29T14:42:44.114Z
9259146 9259146 20260124190758_3N06G KR003T 2026-01-26T14:15:53.901Z 2026-01-29T14:42:38.629Z
9259125 9259125 20260124190051_Zic0N KR003T 2026-01-26T14:15:50.868Z 2026-01-29T14:42:37.802Z
9259113 9259113 20260124185437_VSoNO KR003T 2026-01-26T14:15:42.661Z 2026-01-29T14:42:37.288Z

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