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,126 rows where station_code = "KR002B" 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
9271318 9271318 20260128210840_Tncib KR002B 2026-01-29T14:16:00.136Z 2026-01-29T14:16:00.136Z
9271104 9271104 20260128195915_w23HZ KR002B 2026-01-29T14:15:16.694Z 2026-01-29T14:15:16.694Z
9271102 9271102 20260128195806_uuPj5 KR002B 2026-01-29T14:15:16.084Z 2026-01-29T14:15:16.084Z
9259344 9259344 20260124203055_SOHri KR002B 2026-01-26T14:16:39.502Z 2026-01-29T14:42:48.983Z
9258842 9258842 20260124172759_OfAfk KR002B 2026-01-26T14:14:40.229Z 2026-01-29T14:42:14.460Z
9258709 9258709 20260124161636_Q2Bgj KR002B 2026-01-26T14:14:00.758Z 2026-01-29T14:41:54.694Z
9258114 9258114 20260125184728_AyNVi KR002B 2026-01-26T14:09:38.269Z 2026-01-29T14:38:03.744Z
9257918 9257918 20260125170638_tfEoL KR002B 2026-01-26T14:08:34.668Z 2026-01-29T14:37:53.091Z
9257866 9257866 20260125163452_z2yTv KR002B 2026-01-26T14:08:14.288Z 2026-01-26T14:08:14.288Z
9257666 9257666 20260125152037_LUr2l KR002B 2026-01-26T14:07:05.835Z 2026-01-29T14:37:33.867Z
9257556 9257556 20260125143227_xdDIL KR002B 2026-01-26T14:06:21.507Z 2026-01-29T14:37:27.292Z
9254593 9254593 20260123201818_HSQB1 KR002B 2026-01-25T14:09:59.608Z 2026-01-29T14:46:31.483Z
9254266 9254266 20260123174456_wnM93 KR002B 2026-01-25T14:08:12.322Z 2026-01-29T14:46:02.510Z
9250803 9250803 20260122151002_ljdrJ KR002B 2026-01-24T14:07:27.563Z 2026-01-29T14:50:20.092Z
9250760 9250760 20260122143002_F9rCJ KR002B 2026-01-24T14:06:55.653Z 2026-01-29T14:50:12.570Z
9247861 9247861 20260121201450_yzHir KR002B 2026-01-23T14:11:16.514Z 2026-01-29T14:56:41.064Z
9246818 9246818 20260121144938_kywy3 KR002B 2026-01-23T14:08:02.960Z 2026-01-29T14:55:13.225Z
9246775 9246775 20260121142208_Epxub KR002B 2026-01-23T14:07:55.626Z 2026-01-29T14:55:10.401Z
9246541 9246541 20260121115327_aTJYk KR002B 2026-01-23T14:06:56.908Z 2026-01-29T14:54:36.472Z
9241341 9241341 20260120200356_2qgQn KR002B 2026-01-22T14:12:44.077Z 2026-01-29T15:02:32.402Z
9240764 9240764 20260120174102_FYdD3 KR002B 2026-01-22T14:09:52.000Z 2026-01-29T15:01:53.424Z
9240041 9240041 20260120114356_W8J2W KR002B 2026-01-22T14:05:14.280Z 2026-01-29T14:59:48.872Z
9239963 9239963 20260120103233_Li6c1 KR002B 2026-01-22T14:04:12.926Z 2026-01-29T14:59:17.152Z
9225590 9225590 20260118101910_QxdRJ KR002B 2026-01-19T14:29:30.700Z 2026-01-19T14:29:30.700Z
9222771 9222771 20260117204540_pS7hl KR002B 2026-01-19T14:16:10.217Z 2026-01-26T15:01:20.159Z
9222194 9222194 20260117183949_OBG0k KR002B 2026-01-19T14:13:41.892Z 2026-01-26T15:00:43.569Z
9222094 9222094 20260117180611_Qq2o9 KR002B 2026-01-19T14:13:16.195Z 2026-01-26T15:00:37.922Z
9221831 9221831 20260117164713_AIyzq KR002B 2026-01-19T14:12:02.677Z 2026-01-26T15:00:11.949Z
9217763 9217763 20260116193528_0SKpV KR002B 2026-01-18T14:08:51.657Z 2026-01-25T14:57:46.731Z
9217586 9217586 20260116181502_lhmrM KR002B 2026-01-18T14:08:05.082Z 2026-01-25T14:57:27.186Z
9217410 9217410 20260116133932_uAywf KR002B 2026-01-18T14:06:40.333Z 2026-01-25T14:57:09.911Z
9216833 9216833 20260117130600_9cWhx KR002B 2026-01-18T14:02:52.292Z 2026-01-26T14:59:31.664Z
9216435 9216435 20260117114816_XCiKl KR002B 2026-01-18T14:00:30.775Z 2026-01-18T14:00:30.775Z
9212342 9212342 20260115203825_wI32n KR002B 2026-01-17T14:11:18.484Z 2026-01-24T15:10:48.176Z
9212185 9212185 20260115194708_PxfRd KR002B 2026-01-17T14:10:27.895Z 2026-01-24T15:10:30.893Z
9212060 9212060 20260115185601_YlyTL KR002B 2026-01-17T14:09:43.689Z 2026-01-24T15:10:21.318Z
9212003 9212003 20260115184056_nvQjY KR002B 2026-01-17T14:09:25.862Z 2026-01-24T15:10:18.326Z
9211805 9211805 20260115175349_B5WOg KR002B 2026-01-17T14:08:34.910Z 2026-01-24T15:09:56.432Z
9211730 9211730 20260115172937_MUPMk KR002B 2026-01-17T14:08:05.038Z 2026-01-24T15:09:49.189Z
9210235 9210235 20260115113648_OesZ3 KR002B 2026-01-16T14:19:12.521Z 2026-01-22T15:05:41.272Z
9210233 9210233 20260115113435_KC7hr KR002B 2026-01-16T14:19:11.891Z 2026-01-22T15:05:40.901Z
9199701 9199701 20260113210443_BeFM2 KR002B 2026-01-15T14:12:05.244Z 2026-01-22T15:08:00.142Z
9199559 9199559 20260113202447_LPDvo KR002B 2026-01-15T14:11:27.923Z 2026-01-22T15:07:30.009Z
9199471 9199471 20260113200337_XxT8c KR002B 2026-01-15T14:11:00.581Z 2026-01-22T15:07:24.950Z
9199429 9199429 20260113195805_mVNd7 KR002B 2026-01-15T14:10:49.082Z 2026-01-22T15:07:24.072Z
9199355 9199355 20260113194930_rqUhM KR002B 2026-01-15T14:10:29.968Z 2026-01-22T15:07:22.488Z
9197626 9197626 20260113115757_zXI5a KR002B 2026-01-14T14:23:46.643Z 2026-01-21T15:06:21.199Z
9194591 9194591 20260112213006_GhP5a KR002B 2026-01-14T14:09:54.963Z 2026-01-21T15:04:19.088Z
9194559 9194559 20260112212521_aCHwE KR002B 2026-01-14T14:09:47.950Z 2026-01-21T15:04:18.671Z
9194518 9194518 20260112210956_R7uVR KR002B 2026-01-14T14:09:33.283Z 2026-01-21T15:04:18.004Z
9194481 9194481 20260112205922_EuBcl KR002B 2026-01-14T14:09:25.063Z 2026-01-21T15:04:16.438Z
9193798 9193798 20260113182451_RZ05Z KR002B 2026-01-14T14:03:21.682Z 2026-01-22T15:07:08.070Z
9193795 9193795 20260113182327_KJNW2 KR002B 2026-01-14T14:03:20.879Z 2026-01-22T15:07:07.793Z
9193775 9193775 20260113180639_cPByQ KR002B 2026-01-14T14:03:15.365Z 2026-01-22T15:07:05.200Z
9193762 9193762 20260113180309_xWuz8 KR002B 2026-01-14T14:03:12.497Z 2026-01-22T15:07:04.515Z
9193730 9193730 20260113174222_N6NYO KR002B 2026-01-14T14:03:03.618Z 2026-01-22T15:07:01.633Z
9193719 9193719 20260113173955_44CDU KR002B 2026-01-14T14:03:01.136Z 2026-01-14T14:03:01.136Z
9193655 9193655 20260113170853_3OR7Z KR002B 2026-01-14T14:02:40.459Z 2026-01-14T14:02:40.459Z
9193650 9193650 20260113170307_phyK9 KR002B 2026-01-14T14:02:38.718Z 2026-01-22T15:06:33.822Z
9193618 9193618 20260113164336_m3tzg KR002B 2026-01-14T14:02:30.192Z 2026-01-22T15:06:31.629Z
9193480 9193480 20260113151803_29E5o KR002B 2026-01-14T14:01:42.532Z 2026-01-22T15:06:20.838Z
9193433 9193433 20260113144723_Xhjgv KR002B 2026-01-14T14:01:26.219Z 2026-01-22T15:06:18.334Z
9193357 9193357 20260113134326_buQmt KR002B 2026-01-14T14:00:50.411Z 2026-01-22T15:06:14.320Z
9187470 9187470 20260111171645_fgMeK KR002B 2026-01-13T14:07:30.305Z 2026-01-20T15:20:30.160Z
9187457 9187457 20260111171323_AWee5 KR002B 2026-01-13T14:07:23.616Z 2026-01-20T15:20:29.426Z
9187320 9187320 20260111160940_0v2i3 KR002B 2026-01-13T14:06:44.046Z 2026-01-20T15:20:23.261Z
9186943 9186943 20260111142804_X2xj0 KR002B 2026-01-13T14:04:24.142Z 2026-01-20T15:19:35.233Z
9174371 9174371 20260109155654_F332w KR002B 2026-01-11T14:02:43.331Z 2026-01-18T15:06:38.635Z
9174339 9174339 20260109151348_E5pdb KR002B 2026-01-11T14:02:18.770Z 2026-01-18T15:06:20.525Z
9171246 9171246 20260108202147_2EcB3 KR002B 2026-01-10T14:06:15.938Z 2026-01-17T15:23:38.841Z
9171188 9171188 20260108194940_s3CxI KR002B 2026-01-10T14:05:50.874Z 2026-01-17T15:23:35.947Z
9170980 9170980 20260108181328_Z34sP KR002B 2026-01-10T14:04:30.082Z 2026-01-17T15:23:14.130Z
9170890 9170890 20260108172825_44x2A KR002B 2026-01-10T14:03:55.355Z 2026-01-17T15:23:09.467Z
9170857 9170857 20260108171923_sRgFm KR002B 2026-01-10T14:03:43.735Z 2026-01-17T15:23:07.843Z
9170817 9170817 20260108165928_CADkx KR002B 2026-01-10T14:03:33.184Z 2026-01-17T15:23:06.457Z
9170710 9170710 20260108162419_IqSe2 KR002B 2026-01-10T14:02:59.574Z 2026-01-17T15:22:55.319Z
9170670 9170670 20260108154357_0yV0C KR002B 2026-01-10T14:02:26.032Z 2026-01-17T15:22:47.551Z
9166831 9166831 20260107203734_4b2FA KR002B 2026-01-09T14:05:07.709Z 2026-01-16T15:10:25.841Z
9166822 9166822 20260107203006_wKC31 KR002B 2026-01-09T14:05:05.000Z 2026-01-16T15:10:25.244Z
9153076 9153076 20260105164014_23yxv KR002B 2026-01-06T14:19:31.593Z 2026-01-13T15:16:59.563Z
9152735 9152735 20260105130442_1QCfY KR002B 2026-01-06T14:18:18.302Z 2026-01-13T15:16:24.571Z
9152169 9152169 20260105095132_5KXyX KR002B 2026-01-06T14:16:06.163Z 2026-01-13T15:15:33.814Z
9121046 9121046 20251231203122_RYt2j KR002B 2026-01-02T14:05:34.070Z 2026-01-09T14:51:43.997Z
9120912 9120912 20251231200200_GeSSG KR002B 2026-01-02T14:04:57.324Z 2026-01-09T14:51:30.326Z
9108931 9108931 20251229195503_2k2J3 KR002B 2025-12-31T14:44:51.711Z 2026-01-06T15:22:07.053Z
9108905 9108905 20251229195153_dYN6T KR002B 2025-12-31T14:44:47.857Z 2026-01-06T15:22:06.024Z
9108431 9108431 20251229184845_Z2UIp KR002B 2025-12-31T14:43:32.104Z 2026-01-06T15:21:34.827Z
9108285 9108285 20251229182909_2JFaM KR002B 2025-12-31T14:43:17.176Z 2026-01-06T15:21:29.787Z
9106642 9106642 20251230183919_Y3KtA KR002B 2025-12-31T14:29:21.240Z 2026-01-01T14:58:01.881Z
9105241 9105241 20251230101837_QYvRb KR002B 2025-12-31T14:24:26.424Z 2026-01-07T15:10:38.782Z
9105221 9105221 20251230101237_L2zK2 KR002B 2025-12-31T14:24:19.281Z 2026-01-07T15:10:29.541Z
9100767 9100767 20251229210907_9S5u2 KR002B 2025-12-31T14:04:39.682Z 2026-01-07T15:05:37.647Z
9100717 9100717 20251229210012_jTpDe KR002B 2025-12-31T14:04:22.019Z 2026-01-07T15:05:35.339Z
9100579 9100579 20251229204219_QGyI2 KR002B 2025-12-31T14:03:44.274Z 2026-01-07T15:05:24.077Z
9100474 9100474 20251229201007_jlID3 KR002B 2025-12-31T14:03:02.453Z 2026-01-07T15:05:18.390Z
9100030 9100030 20251230193543_MjVus KR002B 2025-12-31T14:00:17.637Z 2026-01-08T15:03:49.265Z
9098630 9098630 20251227194310_j6pKZ KR002B 2025-12-30T15:10:41.530Z 2025-12-30T15:10:41.530Z
9098232 9098232 20251227183141_MBkWN KR002B 2025-12-30T15:09:59.218Z 2025-12-30T15:09:59.218Z
9098199 9098199 20251227182533_un43X KR002B 2025-12-30T15:09:56.829Z 2026-01-04T15:34:49.395Z
9098034 9098034 20251227180321_uCjn8 KR002B 2025-12-30T15:09:47.901Z 2025-12-30T15:09:47.901Z

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