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,250 rows where station_code = "KR0021" 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
9266800 9266800 20260127212757_H3ieG KR0021 2026-01-28T14:14:37.450Z 2026-01-29T14:30:25.220Z
9266725 9266725 20260127205534_m9VQC KR0021 2026-01-28T14:14:22.568Z 2026-01-29T14:30:25.207Z
9266473 9266473 20260127192728_SxMsN KR0021 2026-01-28T14:13:39.757Z 2026-01-29T14:30:25.037Z
9258373 9258373 20260124105005_OPRGg KR0021 2026-01-26T14:11:14.830Z 2026-01-29T14:40:36.151Z
9258326 9258326 20260125212349_7Im3l KR0021 2026-01-26T14:10:26.946Z 2026-01-29T14:38:26.992Z
9258321 9258321 20260125212058_ye0jZ KR0021 2026-01-26T14:10:26.350Z 2026-01-29T14:38:26.834Z
9258292 9258292 20260125205653_Z7Oum KR0021 2026-01-26T14:10:22.523Z 2026-01-29T14:38:24.813Z
9258217 9258217 20260125195524_UdbKr KR0021 2026-01-26T14:10:06.832Z 2026-01-29T14:38:11.811Z
9258111 9258111 20260125184728_AyNVi KR0021 2026-01-26T14:09:38.269Z 2026-01-29T14:38:03.744Z
9258036 9258036 20260125181133_Fztvk KR0021 2026-01-26T14:09:12.975Z 2026-01-29T14:37:59.538Z
9256693 9256693 20260125100234_1auDR KR0021 2026-01-26T14:01:27.725Z 2026-01-29T14:36:16.910Z
9240129 9240129 20260120123213_O3J0M KR0021 2026-01-22T14:05:59.216Z 2026-01-29T15:00:16.787Z
9240065 9240065 20260120120454_401ge KR0021 2026-01-22T14:05:30.141Z 2026-01-29T14:59:55.283Z
9239978 9239978 20260120110118_4MwMH KR0021 2026-01-22T14:04:37.984Z 2026-01-29T14:59:24.540Z
9222843 9222843 20260117210438_CA5yv KR0021 2026-01-19T14:16:28.747Z 2026-01-26T15:01:23.027Z
9222768 9222768 20260117204540_pS7hl KR0021 2026-01-19T14:16:10.217Z 2026-01-26T15:01:20.159Z
9222478 9222478 20260117194534_WCPIZ KR0021 2026-01-19T14:15:01.393Z 2026-01-26T15:00:55.433Z
9222476 9222476 20260117194504_LCzgs KR0021 2026-01-19T14:15:00.626Z 2026-01-26T15:00:55.339Z
9222381 9222381 20260117192232_LKL2A KR0021 2026-01-19T14:14:35.125Z 2026-01-26T15:00:51.747Z
9221825 9221825 20260117164410_Necfa KR0021 2026-01-19T14:12:02.067Z 2026-01-26T15:00:11.759Z
9219362 9219362 20260117100700_uOsaX KR0021 2026-01-18T14:16:05.996Z 2026-01-18T14:16:05.996Z
9217356 9217356 20260116123208_OpXAp KR0021 2026-01-18T14:05:55.026Z 2026-01-25T14:56:46.461Z
9217281 9217281 20260117155442_5sETd KR0021 2026-01-18T14:05:09.916Z 2026-01-26T15:00:04.620Z
9217104 9217104 20260117143534_GecbF KR0021 2026-01-18T14:04:18.056Z 2026-01-26T14:59:56.579Z
9216995 9216995 20260117135820_kSImr KR0021 2026-01-18T14:03:45.273Z 2026-01-26T14:59:51.677Z
9199603 9199603 20260113203441_ybvHs KR0021 2026-01-15T14:11:36.791Z 2026-01-22T15:07:47.429Z
9199469 9199469 20260113200337_XxT8c KR0021 2026-01-15T14:11:00.572Z 2026-01-22T15:07:24.950Z
9198780 9198780 20260113175741_47mjF KR0021 2026-01-15T14:07:12.700Z 2026-01-22T15:07:04.145Z
9197247 9197247 20260113103706_hyDpT KR0021 2026-01-14T14:22:01.547Z 2026-01-21T15:06:15.783Z
9194589 9194589 20260112213006_GhP5a KR0021 2026-01-14T14:09:54.963Z 2026-01-21T15:04:19.088Z
9193779 9193779 20260113180652_2ueYY KR0021 2026-01-14T14:03:16.267Z 2026-01-22T15:07:05.259Z
9193765 9193765 20260113180516_sbNO2 KR0021 2026-01-14T14:03:13.369Z 2026-01-22T15:07:04.811Z
9193755 9193755 20260113175741_wy2io KR0021 2026-01-14T14:03:11.288Z 2026-01-22T15:07:04.112Z
9193596 9193596 20260113163641_Lkpg4 KR0021 2026-01-14T14:02:26.177Z 2026-01-22T15:06:30.884Z
9173706 9173706 20260109145350_rrmxu KR0021 2026-01-10T14:19:16.326Z 2026-01-17T15:26:52.471Z
9173700 9173700 20260109144059_2j9RU KR0021 2026-01-10T14:19:14.796Z 2026-01-17T15:26:48.781Z
9173695 9173695 20260109143538_FjYgB KR0021 2026-01-10T14:19:10.525Z 2026-01-17T15:26:46.851Z
9173683 9173683 20260109134256_Lc12t KR0021 2026-01-10T14:19:00.892Z 2026-01-17T15:26:39.660Z
9171143 9171143 20260108193702_KgyUd KR0021 2026-01-10T14:05:33.249Z 2026-01-17T15:23:33.902Z
9170698 9170698 20260108162243_39yaU KR0021 2026-01-10T14:02:55.635Z 2026-01-17T15:22:54.876Z
9169879 9169879 20260108121022_CM0gR KR0021 2026-01-09T14:15:04.843Z 2026-01-16T15:13:02.991Z
9169725 9169725 20260108093306_62xBB KR0021 2026-01-09T14:14:29.932Z 2026-01-16T15:12:15.794Z
9166868 9166868 20260107204811_ZPrk7 KR0021 2026-01-09T14:05:14.942Z 2026-01-16T15:10:27.443Z
9152200 9152200 20260105100236_Cr2R0 KR0021 2026-01-06T14:16:12.733Z 2026-01-13T15:15:36.025Z
9148696 9148696 20260105205048_Hoe97 KR0021 2026-01-06T14:01:48.547Z 2026-01-13T15:07:02.376Z
9126216 9126216 20260102212006_ltLyh KR0021 2026-01-03T14:01:06.744Z 2026-01-10T14:57:31.365Z
9126212 9126212 20260102211947_qqHiZ KR0021 2026-01-03T14:01:05.735Z 2026-01-10T14:57:30.952Z
9126182 9126182 20260102205141_mzdnG KR0021 2026-01-03T14:00:55.450Z 2026-01-10T14:57:27.617Z
9126159 9126159 20260102200931_Ehdwt KR0021 2026-01-03T14:00:41.697Z 2026-01-10T14:57:21.116Z
9125728 9125728 20251231184029_pussW KR0021 2026-01-02T14:55:59.448Z 2026-01-08T15:15:56.361Z
9125240 9125240 20251231171301_VSJ9X KR0021 2026-01-02T14:54:35.693Z 2026-01-08T15:15:20.039Z
9124915 9124915 20251231154540_f2zfs KR0021 2026-01-02T14:53:40.204Z 2026-01-08T15:14:49.562Z
9124817 9124817 20251231150310_EosPr KR0021 2026-01-02T14:52:52.240Z 2026-01-08T15:14:37.174Z
9121320 9121320 20251231212559_x6DWC KR0021 2026-01-02T14:06:49.039Z 2026-01-09T14:51:53.212Z
9121296 9121296 20251231212406_k0Paf KR0021 2026-01-02T14:06:44.716Z 2026-01-09T14:51:52.551Z
9121141 9121141 20251231204827_b6Ed3 KR0021 2026-01-02T14:05:54.563Z 2026-01-09T14:51:46.634Z
9121097 9121097 20251231203926_2dkTY KR0021 2026-01-02T14:05:47.495Z 2026-01-09T14:51:45.516Z
9121076 9121076 20251231203637_C05NQ KR0021 2026-01-02T14:05:40.713Z 2026-01-09T14:51:44.757Z
9121028 9121028 20251231202757_23gpC KR0021 2026-01-02T14:05:31.672Z 2026-01-09T14:51:43.556Z
9120965 9120965 20251231201454_zfrYt KR0021 2026-01-02T14:05:14.927Z 2026-01-09T14:51:33.487Z
9108946 9108946 20251229195630_bJi2k KR0021 2025-12-31T14:45:00.378Z 2026-01-06T15:22:07.576Z
9108910 9108910 20251229195201_zF3YP KR0021 2025-12-31T14:44:48.455Z 2026-01-06T15:22:06.401Z
9108883 9108883 20251229194848_3i6hg KR0021 2025-12-31T14:44:43.152Z 2026-01-06T15:22:05.271Z
9108847 9108847 20251229194433_Ag6dv KR0021 2025-12-31T14:44:38.849Z 2026-01-06T15:22:03.771Z
9108715 9108715 20251229192451_hRDeW KR0021 2025-12-31T14:44:15.428Z 2026-01-06T15:21:45.689Z
9107461 9107461 20251229155651_x89Fh KR0021 2025-12-31T14:41:03.388Z 2026-01-06T15:20:47.777Z
9100578 9100578 20251229204219_QGyI2 KR0021 2025-12-31T14:03:44.274Z 2026-01-07T15:05:24.077Z
9091914 9091914 20251228201441_hyGSE KR0021 2025-12-30T14:53:31.983Z 2026-01-05T15:14:44.354Z
9091670 9091670 20251228194252_08rkN KR0021 2025-12-30T14:52:59.809Z 2026-01-05T15:14:22.839Z
9091279 9091279 20251228182928_GZojE KR0021 2025-12-30T14:52:13.597Z 2026-01-05T15:14:07.673Z
9091104 9091104 20251228175700_M7Gvm KR0021 2025-12-30T14:51:45.216Z 2026-01-05T15:14:01.978Z
9091044 9091044 20251228174332_2hvQm KR0021 2025-12-30T14:51:38.484Z 2026-01-05T15:13:58.759Z
9090744 9090744 20251228164424_7Wl7U KR0021 2025-12-30T14:50:59.605Z 2026-01-05T15:13:36.902Z
9070802 9070802 20251226171659_Uksw5 KR0021 2025-12-29T14:48:21.834Z 2026-01-03T15:42:13.101Z
9067620 9067620 20251226100935_NMQZ6 KR0021 2025-12-29T14:42:24.511Z 2026-01-03T15:38:59.780Z
9049498 9049498 20251222211238_9BFZd KR0021 2025-12-28T15:04:23.619Z 2025-12-30T15:49:15.483Z
9049390 9049390 20251222203753_l22cb KR0021 2025-12-28T15:04:20.227Z 2025-12-28T15:04:20.227Z
9049355 9049355 20251222202153_InThR KR0021 2025-12-28T15:04:18.447Z 2025-12-30T15:49:14.266Z
9049291 9049291 20251222200317_1G2Fo KR0021 2025-12-28T15:04:16.526Z 2025-12-30T15:49:13.793Z
9049205 9049205 20251222195133_WAIln KR0021 2025-12-28T15:04:14.217Z 2025-12-30T15:49:13.305Z
9049198 9049198 20251222195059_N9JZx KR0021 2025-12-28T15:04:13.974Z 2025-12-30T15:49:13.225Z
9043856 9043856 20251224213056_8miHQ KR0021 2025-12-28T14:48:10.739Z 2026-01-01T15:57:23.682Z
9043764 9043764 20251224211642_e2ACs KR0021 2025-12-28T14:47:57.982Z 2026-01-01T15:57:22.526Z
9043639 9043639 20251224205805_ShcZb KR0021 2025-12-28T14:47:43.239Z 2026-01-01T15:57:21.080Z
9043336 9043336 20251224201444_XS1Wr KR0021 2025-12-28T14:47:26.261Z 2026-01-01T15:57:17.703Z
9042905 9042905 20251224191558_ZYOBJ KR0021 2025-12-28T14:46:42.368Z 2026-01-01T15:57:11.873Z
9042300 9042300 20251224174242_srr94 KR0021 2025-12-28T14:45:20.810Z 2026-01-01T15:56:38.213Z
9015127 9015127 20251221210657_CGsqP KR0021 2025-12-27T14:54:01.391Z 2025-12-27T14:54:01.391Z
9015004 9015004 20251221205321_R7v7m KR0021 2025-12-27T14:53:34.512Z 2025-12-27T14:53:34.512Z
9014886 9014886 20251221203436_PE7PT KR0021 2025-12-27T14:53:24.264Z 2025-12-27T14:53:24.264Z
9014688 9014688 20251221200703_LGWF3 KR0021 2025-12-27T14:53:17.589Z 2025-12-27T14:53:17.589Z
9014613 9014613 20251221195848_vud7k KR0021 2025-12-27T14:53:15.235Z 2025-12-27T14:53:15.235Z
9014585 9014585 20251221195608_y6Dw7 KR0021 2025-12-27T14:53:14.037Z 2025-12-27T14:53:14.037Z
9014578 9014578 20251221195531_6WvAY KR0021 2025-12-27T14:53:13.695Z 2025-12-27T14:53:13.695Z
9014488 9014488 20251221194734_8AFF4 KR0021 2025-12-27T14:53:09.917Z 2025-12-27T14:53:09.917Z
9014262 9014262 20251221192828_zoDNz KR0021 2025-12-27T14:52:31.524Z 2025-12-27T14:52:31.524Z
9014233 9014233 20251221192459_nM3AM KR0021 2025-12-27T14:52:22.300Z 2025-12-27T14:52:22.300Z
9013493 9013493 20251221181255_EufUY KR0021 2025-12-27T14:51:30.576Z 2025-12-27T14:51:30.576Z
9012517 9012517 20251221155830_fbpDU KR0021 2025-12-27T14:49:34.576Z 2025-12-27T14:49:34.576Z
9012411 9012411 20251221154404_IJnjz KR0021 2025-12-27T14:49:28.385Z 2025-12-27T14:49:28.385Z

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