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

3,063 rows where station_code = "KR001J" 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
9271282 9271282 20260128205104_AV2gd KR001J 2026-01-29T14:15:49.083Z 2026-01-29T14:15:49.083Z
9271175 9271175 20260128201938_Omsn3 KR001J 2026-01-29T14:15:31.213Z 2026-01-29T14:15:31.213Z
9271124 9271124 20260128200225_22qtm KR001J 2026-01-29T14:15:18.846Z 2026-01-29T14:15:18.846Z
9270972 9270972 20260128190538_sLQBc KR001J 2026-01-29T14:14:42.625Z 2026-01-29T14:14:42.625Z
9270928 9270928 20260128185406_o7BH3 KR001J 2026-01-29T14:14:35.247Z 2026-01-29T14:14:35.247Z
9270749 9270749 20260128171659_VpnwH KR001J 2026-01-29T14:13:41.994Z 2026-01-29T14:13:41.994Z
9270715 9270715 20260128164822_qa23h KR001J 2026-01-29T14:13:30.606Z 2026-01-29T14:13:30.606Z
9262435 9262435 20260126203331_2ErUr KR001J 2026-01-27T14:09:03.331Z 2026-01-27T14:09:03.331Z
9262385 9262385 20260126201332_heqbG KR001J 2026-01-27T14:08:52.491Z 2026-01-29T14:34:28.045Z
9259382 9259382 20260124203958_QQjzS KR001J 2026-01-26T14:16:50.666Z 2026-01-29T14:42:50.592Z
9259376 9259376 20260124203954_4XXmy KR001J 2026-01-26T14:16:50.020Z 2026-01-29T14:42:50.471Z
9259161 9259161 20260124191523_5wd2p KR001J 2026-01-26T14:15:56.851Z 2026-01-29T14:42:39.872Z
9259105 9259105 20260124185055_IH00g KR001J 2026-01-26T14:15:42.162Z 2026-01-29T14:42:37.136Z
9258894 9258894 20260124175157_nKJPC KR001J 2026-01-26T14:14:55.305Z 2026-01-29T14:42:17.254Z
9258832 9258832 20260124172137_wTRYM KR001J 2026-01-26T14:14:37.572Z 2026-01-29T14:42:13.520Z
9258729 9258729 20260124162812_CLejK KR001J 2026-01-26T14:14:04.725Z 2026-01-29T14:41:58.180Z
9258248 9258248 20260125202115_zK8ld KR001J 2026-01-26T14:10:14.957Z 2026-01-29T14:38:17.784Z
9258215 9258215 20260125195424_imBoR KR001J 2026-01-26T14:10:05.762Z 2026-01-27T14:13:21.431Z
9258202 9258202 20260125194307_zJ0YL KR001J 2026-01-26T14:10:00.991Z 2026-01-29T14:38:10.605Z
9258148 9258148 20260125190705_zbKe1 KR001J 2026-01-26T14:09:50.544Z 2026-01-29T14:38:05.467Z
9258116 9258116 20260125185104_MA23l KR001J 2026-01-26T14:09:38.897Z 2026-01-29T14:38:03.923Z
9257983 9257983 20260125174107_Td5Os KR001J 2026-01-26T14:08:53.850Z 2026-01-29T14:37:56.089Z
9257702 9257702 20260125152922_wuKlu KR001J 2026-01-26T14:07:20.467Z 2026-01-29T14:37:35.732Z
9254050 9254050 20260123140726_aqVbz KR001J 2026-01-25T14:06:39.734Z 2026-01-29T14:45:28.757Z
9251550 9251550 20260122205429_JZZ7Z KR001J 2026-01-24T14:12:13.445Z 2026-01-29T14:51:48.350Z
9251540 9251540 20260122204938_G22JM KR001J 2026-01-24T14:12:11.453Z 2026-01-29T14:51:47.662Z
9251172 9251172 20260122185020_D7Qzw KR001J 2026-01-24T14:10:24.642Z 2026-01-29T14:51:15.666Z
9250975 9250975 20260122173822_Tr1GA KR001J 2026-01-24T14:09:12.497Z 2026-01-29T14:50:50.893Z
9250887 9250887 20260122163100_2HD7w KR001J 2026-01-24T14:08:28.629Z 2026-01-29T14:50:42.722Z
9250686 9250686 20260122122642_7IcLf KR001J 2026-01-24T14:05:22.757Z 2026-01-29T14:49:40.397Z
9247883 9247883 20260121202138_XqppS KR001J 2026-01-23T14:11:21.547Z 2026-01-29T14:56:42.187Z
9247848 9247848 20260121200651_7VGBG KR001J 2026-01-23T14:11:15.128Z 2026-01-29T14:56:40.368Z
9247825 9247825 20260121200153_LwyC2 KR001J 2026-01-23T14:11:12.875Z 2026-01-29T14:56:39.499Z
9247715 9247715 20260121193449_Bmwim KR001J 2026-01-23T14:10:58.094Z 2026-01-29T14:56:29.699Z
9247195 9247195 20260121173424_28xcZ KR001J 2026-01-23T14:09:22.740Z 2026-01-29T14:55:48.995Z
9246477 9246477 20260121101030_CxiGx KR001J 2026-01-23T14:06:15.683Z 2026-01-29T14:53:57.013Z
9241445 9241445 20260120202736_GPYNR KR001J 2026-01-22T14:13:13.186Z 2026-01-29T15:02:36.680Z
9241438 9241438 20260120202736_BHFfJ KR001J 2026-01-22T14:13:12.721Z 2026-01-29T15:02:36.462Z
9240304 9240304 20260120150425_QVyMo KR001J 2026-01-22T14:07:41.448Z 2026-01-29T15:01:04.261Z
9222861 9222861 20260117210712_3H1XE KR001J 2026-01-19T14:16:36.012Z 2026-01-26T15:01:23.651Z
9222395 9222395 20260117192500_yd2eO KR001J 2026-01-19T14:14:37.393Z 2026-01-26T15:00:52.330Z
9222358 9222358 20260117191719_4gnM7 KR001J 2026-01-19T14:14:29.149Z 2026-01-26T15:00:51.288Z
9221908 9221908 20260117171513_T1mpL KR001J 2026-01-19T14:12:25.349Z 2026-01-26T15:00:30.054Z
9217932 9217932 20260116204955_PTx3T KR001J 2026-01-18T14:09:38.669Z 2026-01-25T14:57:52.406Z
9217912 9217912 20260116204311_t27pj KR001J 2026-01-18T14:09:34.380Z 2026-01-25T14:57:51.711Z
9217542 9217542 20260116172701_cDgbe KR001J 2026-01-18T14:07:47.622Z 2026-01-25T14:57:25.053Z
9217523 9217523 20260116170444_8GLDF KR001J 2026-01-18T14:07:41.386Z 2026-01-25T14:57:24.012Z
9217518 9217518 20260116163513_R2wqm KR001J 2026-01-18T14:07:38.860Z 2026-01-25T14:57:22.681Z
9217453 9217453 20260116151502_wqB5V KR001J 2026-01-18T14:07:12.810Z 2026-01-25T14:57:17.507Z
9217372 9217372 20260116125038_Jfvl5 KR001J 2026-01-18T14:06:12.227Z 2026-01-25T14:56:51.614Z
9212424 9212424 20260115211442_9eQfI KR001J 2026-01-17T14:11:44.701Z 2026-01-24T15:10:52.174Z
9212336 9212336 20260115203713_3LL31 KR001J 2026-01-17T14:11:17.905Z 2026-01-24T15:10:48.066Z
9212332 9212332 20260115203656_2SS57 KR001J 2026-01-17T14:11:17.250Z 2026-01-24T15:10:47.907Z
9212293 9212293 20260115201912_tcnyn KR001J 2026-01-17T14:11:04.248Z 2026-01-24T15:10:46.408Z
9212272 9212272 20260115201328_b595s KR001J 2026-01-17T14:10:58.161Z 2026-01-24T15:10:45.584Z
9212247 9212247 20260115200636_g2v9t KR001J 2026-01-17T14:10:50.560Z 2026-01-24T15:10:44.432Z
9211759 9211759 20260115173752_GaEYh KR001J 2026-01-17T14:08:20.739Z 2026-01-24T15:09:53.416Z
9210225 9210225 20260115101807_4Rg47 KR001J 2026-01-16T14:19:10.293Z 2026-01-22T15:05:31.388Z
9199719 9199719 20260113210627_Sr5je KR001J 2026-01-15T14:12:07.908Z 2026-01-22T15:08:00.499Z
9198999 9198999 20260113184740_tPvZT KR001J 2026-01-15T14:08:44.354Z 2026-01-22T15:07:11.255Z
9194507 9194507 20260112210717_C30oK KR001J 2026-01-14T14:09:31.822Z 2026-01-21T15:04:17.856Z
9193712 9193712 20260113173803_kKc1C KR001J 2026-01-14T14:03:00.325Z 2026-01-22T15:07:00.981Z
9193215 9193215 20260112101201_kisjr KR001J 2026-01-13T14:30:43.683Z 2026-01-20T15:24:53.923Z
9188095 9188095 20260111202800_MzTHn KR001J 2026-01-13T14:10:27.282Z 2026-01-20T15:21:12.499Z
9187907 9187907 20260111192820_SEH2c KR001J 2026-01-13T14:09:28.839Z 2026-01-20T15:21:00.380Z
9187603 9187603 20260111175452_X6BJi KR001J 2026-01-13T14:07:59.688Z 2026-01-20T15:20:35.165Z
9187571 9187571 20260111174832_ZWRbh KR001J 2026-01-13T14:07:53.723Z 2026-01-20T15:20:33.924Z
9187524 9187524 20260111173541_JFR5K KR001J 2026-01-13T14:07:37.945Z 2026-01-20T15:20:31.808Z
9180434 9180434 20260110202616_ykK92 KR001J 2026-01-12T14:07:06.001Z 2026-01-19T15:16:01.983Z
9180353 9180353 20260110200733_0cA3B KR001J 2026-01-12T14:06:50.536Z 2026-01-19T15:15:58.880Z
9180211 9180211 20260110193808_0B147 KR001J 2026-01-12T14:06:14.870Z 2026-01-19T15:15:51.703Z
9179944 9179944 20260110182025_qQHC1 KR001J 2026-01-12T14:05:03.956Z 2026-01-19T15:15:37.505Z
9179940 9179940 20260110181740_xEfPA KR001J 2026-01-12T14:05:02.400Z 2026-01-19T15:15:37.430Z
9179807 9179807 20260110174622_y1zib KR001J 2026-01-12T14:04:25.334Z 2026-01-19T15:15:18.380Z
9179648 9179648 20260110171148_E2336 KR001J 2026-01-12T14:03:43.027Z 2026-01-19T15:15:09.574Z
9179593 9179593 20260110165401_Lg0WW KR001J 2026-01-12T14:03:26.309Z 2026-01-19T15:15:06.855Z
9179591 9179591 20260110165249_vlTVH KR001J 2026-01-12T14:03:25.647Z 2026-01-19T15:15:06.773Z
9174363 9174363 20260109154157_k8SaJ KR001J 2026-01-11T14:02:36.491Z 2026-01-18T15:06:27.671Z
9171331 9171331 20260108210705_oqmZs KR001J 2026-01-10T14:06:47.048Z 2026-01-17T15:23:44.410Z
9171271 9171271 20260108203520_SLqGk KR001J 2026-01-10T14:06:24.110Z 2026-01-17T15:23:40.281Z
9171216 9171216 20260108200823_cLxRy KR001J 2026-01-10T14:06:00.169Z 2026-01-17T15:23:37.046Z
9171164 9171164 20260108194417_lFHnd KR001J 2026-01-10T14:05:38.889Z 2026-01-17T15:23:34.714Z
9170754 9170754 20260108163520_CFVmy KR001J 2026-01-10T14:03:14.118Z 2026-01-17T15:23:03.647Z
9169742 9169742 20260108101340_FhaK0 KR001J 2026-01-09T14:14:32.499Z 2026-01-16T15:12:23.427Z
9166840 9166840 20260107204239_FdJbX KR001J 2026-01-09T14:05:10.693Z 2026-01-16T15:10:26.447Z
9166794 9166794 20260107202404_tRbfs KR001J 2026-01-09T14:04:57.871Z 2026-01-16T15:10:24.289Z
9166748 9166748 20260107201023_U8xgW KR001J 2026-01-09T14:04:45.301Z 2026-01-16T15:10:22.044Z
9166649 9166649 20260107194043_Gyubl KR001J 2026-01-09T14:04:14.763Z 2026-01-16T15:10:08.433Z
9166449 9166449 20260107183428_8jfxM KR001J 2026-01-09T14:03:17.792Z 2026-01-16T15:09:55.542Z
9166415 9166415 20260107182013_UaUxi KR001J 2026-01-09T14:03:08.034Z 2026-01-16T15:09:53.412Z
9166409 9166409 20260107181944_9A8LP KR001J 2026-01-09T14:03:06.760Z 2026-01-16T15:09:53.082Z
9166389 9166389 20260107181049_K6Fwu KR001J 2026-01-09T14:02:59.585Z 2026-01-16T15:09:51.494Z
9166347 9166347 20260107175702_Jib5l KR001J 2026-01-09T14:02:47.296Z 2026-01-16T15:09:48.778Z
9166127 9166127 20260107164435_ajwrU KR001J 2026-01-09T14:01:41.032Z 2026-01-16T15:09:25.502Z
9165744 9165744 20260107154321_Z9i7i KR001J 2026-01-08T14:17:55.933Z 2026-01-13T15:05:53.909Z
9165587 9165587 20260107130750_qqH03 KR001J 2026-01-08T14:16:59.610Z 2026-01-13T15:04:33.045Z
9165491 9165491 20260107110651_DutIx KR001J 2026-01-08T14:16:41.293Z 2026-01-13T15:03:45.405Z
9148737 9148737 20260105212733_mc1oP KR001J 2026-01-06T14:02:00.028Z 2026-01-13T15:07:14.663Z
9126180 9126180 20260102205054_Wi1XV KR001J 2026-01-03T14:00:52.766Z 2026-01-10T14:57:27.349Z
9125277 9125277 20251231172443_ZrFQG KR001J 2026-01-02T14:54:49.746Z 2026-01-08T15:15:23.370Z

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