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,451 rows where station_code = "KR003K" 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
9613140 9613140 20260406194949_kMGyE KR003K 2026-04-07T12:03:57.680Z 2026-04-07T12:03:57.680Z
9607944 9607944 20260404200109_yY1a4 KR003K 2026-04-05T12:05:00.637Z 2026-04-07T12:15:13.280Z
9607919 9607919 20260404185539_x5dQl KR003K 2026-04-05T12:04:53.998Z 2026-04-07T12:15:08.372Z
9607878 9607878 20260404181602_jqng6 KR003K 2026-04-05T12:04:40.814Z 2026-04-07T12:15:04.842Z
9591633 9591633 20260328175307_SW66k KR003K 2026-03-29T12:04:46.185Z 2026-04-06T12:39:26.106Z
9583895 9583895 20260326195956_CrgtB KR003K 2026-03-27T12:10:03.756Z 2026-04-04T12:41:51.790Z
9583880 9583880 20260326192446_38LRN KR003K 2026-03-27T12:10:00.364Z 2026-04-04T12:41:49.705Z
9570105 9570105 20260322191139_xGMay KR003K 2026-03-24T12:22:34.636Z 2026-03-30T12:30:27.786Z
9569882 9569882 20260322181508_3Tg1C KR003K 2026-03-24T12:22:17.418Z 2026-03-30T12:30:22.880Z
9568602 9568602 20260323170102_HECtC KR003K 2026-03-24T12:15:21.599Z 2026-03-31T12:28:38.423Z
9568499 9568499 20260323165045_deS9J KR003K 2026-03-24T12:15:12.033Z 2026-03-24T12:24:25.468Z
9568348 9568348 20260323163325_Jql2Y KR003K 2026-03-24T12:14:55.701Z 2026-03-31T12:28:27.671Z
9567985 9567985 20260323160349_GH8pm KR003K 2026-03-24T12:14:21.733Z 2026-03-24T12:24:25.373Z
9567014 9567014 20260323143203_C3Lyd KR003K 2026-03-24T12:12:51.022Z 2026-03-31T12:28:07.140Z
9551323 9551323 20260320191835_2KNOn KR003K 2026-03-22T12:26:25.580Z 2026-03-28T12:36:44.220Z
9551096 9551096 20260320182028_G3Uuf KR003K 2026-03-22T12:26:10.291Z 2026-03-28T12:36:39.920Z
9547627 9547627 20260321134728_j5jPa KR003K 2026-03-22T12:14:00.484Z 2026-03-29T12:20:10.743Z
9541202 9541202 20260319200048_2rwWH KR003K 2026-03-21T12:28:43.608Z 2026-03-27T12:42:35.354Z
9541193 9541193 20260319195815_u4215 KR003K 2026-03-21T12:28:42.791Z 2026-03-27T12:42:35.181Z
9541161 9541161 20260319194606_JwRpg KR003K 2026-03-21T12:28:40.325Z 2026-03-27T12:42:34.738Z
9541004 9541004 20260319185245_ukJDu KR003K 2026-03-21T12:28:22.604Z 2026-03-27T12:42:32.837Z
9540816 9540816 20260319181143_XHJ79 KR003K 2026-03-21T12:28:10.782Z 2026-03-27T12:42:31.198Z
9540499 9540499 20260319155952_KBV47 KR003K 2026-03-21T12:27:05.422Z 2026-03-27T12:42:23.170Z
9540477 9540477 20260319154741_5a1mX KR003K 2026-03-21T12:27:02.633Z 2026-03-27T12:42:22.422Z
9540329 9540329 20260319151501_t2mxC KR003K 2026-03-21T12:26:50.601Z 2026-03-27T12:42:19.636Z
9527699 9527699 20260318150646_I21C6 KR003K 2026-03-20T12:21:38.644Z 2026-03-26T12:38:30.548Z
9499983 9499983 20260316171014_VxYeM KR003K 2026-03-17T12:16:32.797Z 2026-03-24T12:41:32.101Z
9499600 9499600 20260316163316_B7oIo KR003K 2026-03-17T12:15:49.959Z 2026-03-17T12:25:25.770Z
9491792 9491792 20260315194927_RxOJu KR003K 2026-03-16T12:21:50.133Z 2026-03-23T12:22:42.074Z
9491738 9491738 20260315191202_MxJUU KR003K 2026-03-16T12:21:43.184Z 2026-03-23T12:22:41.327Z
9491700 9491700 20260315184033_QfhDO KR003K 2026-03-16T12:21:37.720Z 2026-03-23T12:22:41.011Z
9490979 9490979 20260315155100_YjEQk KR003K 2026-03-16T12:20:08.504Z 2026-03-23T12:22:38.178Z
9481950 9481950 20260314161231_mhRnu KR003K 2026-03-15T12:18:49.259Z 2026-03-22T12:42:46.292Z
9473507 9473507 20260313170718_vR6Gg KR003K 2026-03-14T12:15:10.958Z 2026-03-21T12:49:58.192Z
9473476 9473476 20260313170348_KpQIw KR003K 2026-03-14T12:15:08.650Z 2026-03-21T12:49:58.043Z
9472280 9472280 20260313132942_Ny2nl KR003K 2026-03-14T12:12:48.923Z 2026-03-21T12:49:47.318Z
9455178 9455178 20260310191038_8Myqp KR003K 2026-03-11T12:10:33.973Z 2026-03-18T12:39:56.601Z
9454968 9454968 20260310174706_XpZws KR003K 2026-03-11T12:10:08.191Z 2026-03-18T12:39:51.075Z
9454935 9454935 20260310173917_Lv0HB KR003K 2026-03-11T12:10:04.913Z 2026-03-18T12:39:50.747Z
9454698 9454698 20260310164643_rv0is KR003K 2026-03-11T12:09:42.465Z 2026-03-18T12:39:48.431Z
9440443 9440443 20260307181952_YmNTg KR003K 2026-03-08T12:13:37.820Z 2026-03-15T12:42:06.159Z
9440437 9440437 20260307181040_XjPUi KR003K 2026-03-08T12:13:37.022Z 2026-03-15T12:42:06.072Z
9440144 9440144 20260307161744_XCpiq KR003K 2026-03-08T12:12:45.548Z 2026-03-15T12:42:03.504Z
9439907 9439907 20260307152147_CchKD KR003K 2026-03-08T12:12:01.022Z 2026-03-15T12:42:01.257Z
9439821 9439821 20260307150135_NFGLU KR003K 2026-03-08T12:11:42.325Z 2026-03-15T12:42:00.552Z
9439282 9439282 20260307130255_puwSH KR003K 2026-03-08T12:10:01.423Z 2026-03-15T12:41:41.351Z
9425366 9425366 20260303203026_lC7tB KR003K 2026-03-05T14:14:48.178Z 2026-03-11T12:28:58.663Z
9408651 9408651 20260227201629_pXojk KR003K 2026-02-28T14:26:16.261Z 2026-03-07T14:51:03.260Z
9394343 9394343 20260224195653_W6CrX KR003K 2026-02-26T14:19:38.411Z 2026-03-04T14:19:20.708Z
9389687 9389687 20260224195653_28xoZ KR003K 2026-02-25T14:25:19.582Z 2026-03-04T14:19:20.648Z
9389480 9389480 20260224185620_HSTG3 KR003K 2026-02-25T14:24:57.075Z 2026-03-04T14:19:17.239Z
9381098 9381098 20260222205858_qpZ6Z KR003K 2026-02-24T14:24:15.571Z 2026-02-24T14:24:15.571Z
9380338 9380338 20260222192557_966O1 KR003K 2026-02-24T14:23:02.738Z 2026-02-24T14:23:02.738Z
9380134 9380134 20260222185738_Uww9k KR003K 2026-02-24T14:22:41.536Z 2026-02-24T14:22:41.536Z
9380065 9380065 20260222184849_I6u7z KR003K 2026-02-24T14:22:35.563Z 2026-02-24T14:22:35.563Z
9379708 9379708 20260222174712_XtdSF KR003K 2026-02-24T14:22:02.097Z 2026-02-24T14:22:02.097Z
9379628 9379628 20260222173609_5I9fb KR003K 2026-02-24T14:21:54.701Z 2026-02-24T14:21:54.701Z
9379603 9379603 20260222173424_0eTQw KR003K 2026-02-24T14:21:48.752Z 2026-02-24T14:21:48.752Z
9378719 9378719 20260222145834_Yr8K9 KR003K 2026-02-24T14:19:35.128Z 2026-02-24T14:19:35.128Z
9378434 9378434 20260222135114_IEEct KR003K 2026-02-24T14:18:36.310Z 2026-02-24T14:18:36.310Z
9363808 9363808 20260220171939_OsddK KR003K 2026-02-22T14:20:01.012Z 2026-03-01T14:22:48.001Z
9356404 9356404 20260219115915_KKbiE KR003K 2026-02-21T14:11:54.645Z 2026-02-28T14:43:56.698Z
9351518 9351518 20260217202811_WK3eE KR003K 2026-02-20T14:02:44.988Z 2026-02-26T14:40:08.615Z
9351258 9351258 20260217185308_MBTE3 KR003K 2026-02-20T14:02:42.497Z 2026-02-26T14:40:04.582Z
9349394 9349394 20260218180420_ARioy KR003K 2026-02-20T14:01:57.619Z 2026-02-27T14:35:49.366Z
9339180 9339180 20260216143931_6byiZ KR003K 2026-02-18T14:18:43.333Z 2026-02-25T14:42:16.508Z
9333800 9333800 20260215155844_le601 KR003K 2026-02-17T14:21:18.374Z 2026-02-24T14:42:37.080Z
9329410 9329410 20260214153507_5vnP8 KR003K 2026-02-16T14:18:42.372Z 2026-02-23T14:47:09.990Z
9329349 9329349 20260214115204_Aq2uN KR003K 2026-02-16T14:17:01.405Z 2026-02-23T14:47:00.465Z
9319131 9319131 20260211185604_COhMU KR003K 2026-02-13T14:20:41.726Z 2026-02-20T14:05:28.999Z
9319101 9319101 20260211181936_3Fa3i KR003K 2026-02-13T14:20:13.536Z 2026-02-20T14:05:28.655Z
9319007 9319007 20260211160353_XXfjd KR003K 2026-02-13T14:18:42.205Z 2026-02-20T14:05:25.582Z
9318843 9318843 20260212195458_UWPjE KR003K 2026-02-13T14:13:34.644Z 2026-02-21T14:37:36.518Z
9318556 9318556 20260212155250_LI1Ea KR003K 2026-02-13T14:11:52.763Z 2026-02-21T14:37:25.621Z
9316680 9316680 20260210210209_74Q96 KR003K 2026-02-12T14:18:28.107Z 2026-02-18T14:57:53.254Z
9313958 9313958 20260208200917_xyQLS KR003K 2026-02-11T14:27:03.339Z 2026-02-16T14:54:26.242Z
9307097 9307097 20260207185115_kOIZw KR003K 2026-02-09T14:26:28.831Z 2026-02-16T14:59:29.939Z
9307086 9307086 20260207171055_o2gbD KR003K 2026-02-09T14:26:24.176Z 2026-02-16T14:59:09.437Z
9307081 9307081 20260207164815_RERQS KR003K 2026-02-09T14:26:23.195Z 2026-02-16T14:59:04.846Z
9288548 9288548 20260202210738_67r0L KR003K 2026-02-04T14:10:36.986Z 2026-02-11T14:50:58.525Z
9288515 9288515 20260202203752_fVHcQ KR003K 2026-02-04T14:10:26.898Z 2026-02-11T14:50:56.490Z
9288499 9288499 20260202203114_E0enS KR003K 2026-02-04T14:10:22.365Z 2026-02-11T14:50:55.349Z
9288472 9288472 20260202200546_M37Hs KR003K 2026-02-04T14:10:14.121Z 2026-02-11T14:50:52.766Z
9288442 9288442 20260202193613_Xf48u KR003K 2026-02-04T14:10:03.280Z 2026-02-11T14:50:49.823Z
9288397 9288397 20260202181331_kHSf6 KR003K 2026-02-04T14:09:43.738Z 2026-02-11T14:50:40.015Z
9288388 9288388 20260202175639_Rd8Dq KR003K 2026-02-04T14:09:40.794Z 2026-02-11T14:50:39.242Z
9286785 9286785 20260202191339_7WZwm KR003K 2026-02-03T14:03:13.237Z 2026-02-11T14:50:49.130Z
9285960 9285960 20260131160259_YPfOM KR003K 2026-02-02T14:09:17.320Z 2026-02-09T14:51:57.898Z
9280957 9280957 20260129154840_9oEw7 KR003K 2026-01-31T14:15:46.847Z 2026-02-07T14:52:53.644Z
9280941 9280941 20260129152003_VQA6L KR003K 2026-01-31T14:15:23.432Z 2026-02-07T14:52:35.429Z
9277301 9277301 20260128201321_YHGkN KR003K 2026-01-30T14:20:54.022Z 2026-02-06T14:47:16.903Z
9277033 9277033 20260128161344_L2oZO KR003K 2026-01-30T14:18:30.500Z 2026-02-06T14:46:09.228Z
9276957 9276957 20260128130805_htvF5 KR003K 2026-01-30T14:16:23.017Z 2026-02-06T14:44:32.386Z
9271856 9271856 20260127210904_hBdPu KR003K 2026-01-29T14:24:35.568Z 2026-02-05T14:49:01.529Z
9271681 9271681 20260127191047_ljlfr KR003K 2026-01-29T14:22:22.113Z 2026-02-05T14:48:28.402Z
9271498 9271498 20260127171203_NWFua KR003K 2026-01-29T14:20:57.112Z 2026-02-05T14:47:53.723Z
9267014 9267014 20260126175357_38wL2 KR003K 2026-01-28T14:18:18.451Z 2026-02-04T14:48:07.987Z
9263377 9263377 20260124205257_GQ3pw KR003K 2026-01-27T14:22:09.680Z 2026-02-02T14:48:33.243Z
9263372 9263372 20260124192853_GRR5d KR003K 2026-01-27T14:21:47.635Z 2026-02-02T14:48:20.550Z
9263368 9263368 20260124192554_UI87i KR003K 2026-01-27T14:21:46.568Z 2026-02-02T14:48:20.220Z

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