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

2,807 rows where station_code = "KR0016" 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
9570107 9570107 20260322191145_xDpAJ KR0016 2026-03-24T12:22:35.616Z 2026-03-30T12:30:27.848Z
9569910 9569910 20260322182457_XKuYQ KR0016 2026-03-24T12:22:20.616Z 2026-03-30T12:30:24.780Z
9569874 9569874 20260322181307_qtX94 KR0016 2026-03-24T12:22:16.898Z 2026-03-30T12:30:22.754Z
9569805 9569805 20260322174719_X9ZmA KR0016 2026-03-24T12:22:07.768Z 2026-03-30T12:30:21.621Z
9568082 9568082 20260323161146_gGKB0 KR0016 2026-03-24T12:14:30.010Z 2026-03-31T12:28:22.747Z
9566684 9566684 20260323140412_ZrH9D KR0016 2026-03-24T12:12:18.555Z 2026-03-31T12:27:55.560Z
9541392 9541392 20260319202944_4vbX7 KR0016 2026-03-21T12:28:53.480Z 2026-03-27T12:42:37.213Z
9540366 9540366 20260319152650_RBgJA KR0016 2026-03-21T12:26:55.072Z 2026-03-27T12:42:20.661Z
9539232 9539232 20260320142609_XgxBx KR0016 2026-03-21T12:19:10.382Z 2026-03-28T12:35:58.550Z
9538537 9538537 20260320131933_MZP7B KR0016 2026-03-21T12:17:54.910Z 2026-03-28T12:35:49.683Z
9468182 9468182 20260312180914_xwwV5 KR0016 2026-03-13T12:21:26.005Z 2026-03-20T12:37:13.348Z
9467957 9467957 20260312155608_rNnTb KR0016 2026-03-13T12:20:40.119Z 2026-03-20T12:37:11.057Z
9454915 9454915 20260310173254_3Ijzh KR0016 2026-03-11T12:10:03.716Z 2026-03-18T12:39:50.549Z
9454723 9454723 20260310165026_i37Ei KR0016 2026-03-11T12:09:46.813Z 2026-03-18T12:39:48.527Z
9454712 9454712 20260310165024_fdWnU KR0016 2026-03-11T12:09:46.450Z 2026-03-18T12:39:48.520Z
9454592 9454592 20260310163402_opJEM KR0016 2026-03-11T12:09:33.301Z 2026-03-18T12:39:47.559Z
9454483 9454483 20260310162047_wdKHB KR0016 2026-03-11T12:09:22.792Z 2026-03-18T12:39:46.398Z
9453585 9453585 20260310140646_uAPnK KR0016 2026-03-11T12:07:53.619Z 2026-03-18T12:39:38.672Z
9453311 9453311 20260310132033_cfd5F KR0016 2026-03-11T12:07:22.909Z 2026-03-18T12:39:22.670Z
9449511 9449511 20260309153459_4HSZG KR0016 2026-03-10T12:13:10.860Z 2026-03-17T12:42:29.402Z
9440621 9440621 20260307203108_S8Yo5 KR0016 2026-03-08T12:14:05.096Z 2026-03-15T12:42:11.084Z
9438952 9438952 20260307120240_W9hAO KR0016 2026-03-08T12:09:06.264Z 2026-03-15T12:41:37.224Z
9438431 9438431 20260307102554_lcB29 KR0016 2026-03-08T12:07:29.719Z 2026-03-15T12:41:32.018Z
9396736 9396736 20260225210710_CNw6w KR0016 2026-02-26T14:23:40.692Z 2026-03-05T14:38:53.502Z
9396721 9396721 20260225210510_7bEvZ KR0016 2026-02-26T14:23:40.101Z 2026-03-05T14:38:53.219Z
9396564 9396564 20260225201235_qVOj0 KR0016 2026-02-26T14:23:25.427Z 2026-03-05T14:38:45.680Z
9396289 9396289 20260225185811_6zE96 KR0016 2026-02-26T14:23:02.729Z 2026-03-05T14:38:36.888Z
9395610 9395610 20260225152600_GUcDV KR0016 2026-02-26T14:22:02.600Z 2026-03-05T14:38:00.798Z
9395582 9395582 20260225151727_3kopW KR0016 2026-02-26T14:22:01.113Z 2026-03-05T14:38:00.193Z
9395438 9395438 20260225131106_ahAQh KR0016 2026-02-26T14:21:39.940Z 2026-03-05T14:37:51.086Z
9371965 9371965 20260221203503_5Nk7H KR0016 2026-02-23T14:25:44.924Z 2026-03-02T14:22:19.371Z
9371726 9371726 20260221192659_D3NvS KR0016 2026-02-23T14:25:05.844Z 2026-03-02T14:22:14.806Z
9371125 9371125 20260221165841_LKP7H KR0016 2026-02-23T14:23:30.696Z 2026-03-02T14:22:07.050Z
9370963 9370963 20260221161601_zTC2L KR0016 2026-02-23T14:22:36.100Z 2026-03-02T14:22:03.506Z
9370681 9370681 20260221142029_1hH0A KR0016 2026-02-23T14:20:40.476Z 2026-03-02T14:21:55.921Z
9364491 9364491 20260220211118_UOnFU KR0016 2026-02-22T14:21:32.689Z 2026-03-01T14:22:54.584Z
9364213 9364213 20260220195512_9nd0i KR0016 2026-02-22T14:21:01.371Z 2026-03-01T14:22:51.960Z
9364177 9364177 20260220194653_2N3Tt KR0016 2026-02-22T14:20:54.292Z 2026-03-01T14:22:51.610Z
9364056 9364056 20260220185453_NMHh6 KR0016 2026-02-22T14:20:38.798Z 2026-03-01T14:22:50.445Z
9364047 9364047 20260220185240_7OAst KR0016 2026-02-22T14:20:38.134Z 2026-03-01T14:22:50.377Z
9363867 9363867 20260220174643_qc3Rv KR0016 2026-02-22T14:20:14.231Z 2026-03-01T14:22:48.691Z
9357996 9357996 20260219212302_AQT3E KR0016 2026-02-21T14:17:20.890Z 2026-02-28T14:44:46.222Z
9357719 9357719 20260219194014_ep1gk KR0016 2026-02-21T14:16:41.162Z 2026-02-28T14:44:41.126Z
9356697 9356697 20260219142300_q0aen KR0016 2026-02-21T14:13:25.166Z 2026-02-28T14:44:04.642Z
9351507 9351507 20260217202605_ytqKF KR0016 2026-02-20T14:02:44.946Z 2026-02-26T14:40:08.531Z
9350516 9350516 20260218205724_4JFY3 KR0016 2026-02-20T14:02:01.016Z 2026-02-27T14:36:01.094Z
9350503 9350503 20260218205037_IflGq KR0016 2026-02-20T14:02:00.971Z 2026-02-27T14:36:00.979Z
9350114 9350114 20260218194804_PHioD KR0016 2026-02-20T14:02:00.038Z 2026-02-27T14:35:56.762Z
9350076 9350076 20260218194358_2PVYG KR0016 2026-02-20T14:01:59.966Z 2026-02-27T14:35:56.567Z
9349807 9349807 20260218190409_EbYE6 KR0016 2026-02-20T14:01:59.164Z 2026-02-27T14:35:53.446Z
9349245 9349245 20260218173605_2i47v KR0016 2026-02-20T14:01:57.234Z 2026-02-27T14:35:47.904Z
9349045 9349045 20260218170213_PA772 KR0016 2026-02-20T14:01:56.401Z 2026-02-27T14:35:45.939Z
9348366 9348366 20260218153445_L5JVm KR0016 2026-02-20T14:01:54.337Z 2026-02-27T14:35:23.714Z
9348190 9348190 20260218151734_V2Y1T KR0016 2026-02-20T14:01:53.676Z 2026-02-27T14:35:14.879Z
9339050 9339050 20260217202605_xqG7y KR0016 2026-02-18T14:13:40.847Z 2026-02-18T14:13:40.847Z
9339041 9339041 20260217201728_luUQ4 KR0016 2026-02-18T14:13:37.929Z 2026-02-18T14:13:37.929Z
9338994 9338994 20260217193955_YimLY KR0016 2026-02-18T14:13:29.668Z 2026-02-26T14:40:06.144Z
9338967 9338967 20260217190155_Vbtgy KR0016 2026-02-18T14:13:20.920Z 2026-02-26T14:40:04.648Z
9338954 9338954 20260217185038_hvWDd KR0016 2026-02-18T14:13:18.243Z 2026-02-26T14:40:04.401Z
9338901 9338901 20260217180913_Vw9LX KR0016 2026-02-18T14:13:05.697Z 2026-02-26T14:40:02.461Z
9338685 9338685 20260217164651_hIbop KR0016 2026-02-18T14:12:06.226Z 2026-02-26T14:39:46.291Z
9338553 9338553 20260217160434_DIXNA KR0016 2026-02-18T14:11:35.913Z 2026-02-26T14:39:40.837Z
9338293 9338293 20260217143838_3oP3Q KR0016 2026-02-18T14:10:31.113Z 2026-02-26T14:39:38.196Z
9338099 9338099 20260217125206_U8Hb4 KR0016 2026-02-18T14:09:44.317Z 2026-02-26T14:39:34.718Z
9333685 9333685 20260216210413_YallY KR0016 2026-02-17T14:16:37.088Z 2026-02-25T14:42:46.282Z
9333553 9333553 20260216202712_w3Lob KR0016 2026-02-17T14:16:19.122Z 2026-02-25T14:42:44.438Z
9333537 9333537 20260216202606_373Au KR0016 2026-02-17T14:16:16.872Z 2026-02-25T14:42:44.258Z
9333515 9333515 20260216201750_IJoow KR0016 2026-02-17T14:16:11.939Z 2026-02-25T14:42:43.767Z
9333469 9333469 20260216200320_u5B37 KR0016 2026-02-17T14:16:05.608Z 2026-02-25T14:42:43.103Z
9333416 9333416 20260216194318_fL3Xk KR0016 2026-02-17T14:15:57.214Z 2026-02-25T14:42:42.516Z
9333397 9333397 20260216193607_2P792 KR0016 2026-02-17T14:15:54.414Z 2026-02-25T14:42:41.810Z
9332683 9332683 20260216141918_LcXuv KR0016 2026-02-17T14:12:58.872Z 2026-02-25T14:42:14.595Z
9316222 9316222 20260211174326_4JFVZ KR0016 2026-02-12T14:12:45.886Z 2026-02-20T14:05:27.917Z
9315357 9315357 20260211135710_S3BaT KR0016 2026-02-12T14:08:42.140Z 2026-02-20T14:05:17.899Z
9315322 9315322 20260211135043_jlhdM KR0016 2026-02-12T14:08:35.043Z 2026-02-20T14:05:17.874Z
9310578 9310578 20260208155219_ci6H2 KR0016 2026-02-10T14:20:23.013Z 2026-02-16T14:53:07.064Z
9310103 9310103 20260208101122_uGnGW KR0016 2026-02-10T14:16:22.985Z 2026-02-16T14:50:28.319Z
9308942 9308942 20260209113617_fBFyq KR0016 2026-02-10T14:09:43.969Z 2026-02-18T15:00:41.578Z
9305900 9305900 20260208202737_x9lP3 KR0016 2026-02-09T14:14:13.790Z 2026-02-16T14:54:29.675Z
9305887 9305887 20260208191040_oo9Dz KR0016 2026-02-09T14:14:08.866Z 2026-02-16T14:54:11.529Z
9280863 9280863 20260130213125_MhSKy KR0016 2026-01-31T14:11:21.762Z 2026-02-08T14:49:53.460Z
9280772 9280772 20260130202923_EXsfD KR0016 2026-01-31T14:11:06.407Z 2026-02-08T14:49:49.431Z
9280756 9280756 20260130201056_yfxVz KR0016 2026-01-31T14:11:01.088Z 2026-02-08T14:49:46.498Z
9280648 9280648 20260130174715_eT3Ri KR0016 2026-01-31T14:10:37.402Z 2026-02-08T14:49:37.695Z
9276807 9276807 20260129201945_V1bwS KR0016 2026-01-30T14:13:45.741Z 2026-02-07T14:54:00.530Z
8622061 8622061 20251126174145_Ntjrp KR0016 2025-11-28T14:17:35.324Z 2025-12-05T15:02:51.351Z
8621791 8621791 20251126162627_Wol22 KR0016 2025-11-28T14:16:37.304Z 2025-12-05T15:02:47.903Z
8621745 8621745 20251126162014_hFoya KR0016 2025-11-28T14:16:30.496Z 2025-12-05T15:02:47.517Z
8621705 8621705 20251126161034_48zty KR0016 2025-11-28T14:16:25.685Z 2025-12-05T15:02:47.123Z
8621673 8621673 20251126160052_U3sn2 KR0016 2025-11-28T14:16:22.198Z 2025-12-05T15:02:46.713Z
8565596 8565596 20251121205031_OCdzw KR0016 2025-11-23T14:13:43.599Z 2025-11-30T15:05:06.313Z
8564975 8564975 20251121193537_GV1zG KR0016 2025-11-23T14:12:12.003Z 2025-11-30T15:04:36.934Z
8564884 8564884 20251121192819_uf3ig KR0016 2025-11-23T14:11:54.723Z 2025-11-30T15:04:31.430Z
8564148 8564148 20251121175726_UWWKW KR0016 2025-11-23T14:10:10.038Z 2025-11-30T15:04:07.653Z
8564013 8564013 20251121174805_KX3nt KR0016 2025-11-23T14:09:53.778Z 2025-11-30T15:03:59.026Z
8563966 8563966 20251121174244_JWkkV KR0016 2025-11-23T14:09:41.361Z 2025-11-30T15:03:56.983Z
8563792 8563792 20251121172214_sTYlq KR0016 2025-11-23T14:09:20.606Z 2025-11-30T15:03:46.558Z
8563735 8563735 20251121171725_tsOs9 KR0016 2025-11-23T14:09:07.423Z 2025-11-30T15:03:43.960Z
8563664 8563664 20251121170427_5Hmmy KR0016 2025-11-23T14:08:55.738Z 2025-11-30T15:03:43.467Z
8563635 8563635 20251121170141_yL2Nk KR0016 2025-11-23T14:08:54.065Z 2025-11-30T15:03:42.974Z

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