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

1,400 rows where station_code = "KR001K" 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
9569939 9569939 20260322182758_j3pZn KR001K 2026-03-24T12:22:22.348Z 2026-03-30T12:30:25.141Z
9529894 9529894 20260318193920_nFtFO KR001K 2026-03-20T12:23:47.746Z 2026-03-26T12:39:07.282Z
9468443 9468443 20260312205545_Kta7N KR001K 2026-03-13T12:21:49.675Z 2026-03-20T12:37:16.244Z
9468363 9468363 20260312194821_JuSwC KR001K 2026-03-13T12:21:42.667Z 2026-03-20T12:37:15.070Z
9440463 9440463 20260307183356_80PyQ KR001K 2026-03-08T12:13:39.892Z 2026-03-15T12:42:06.567Z
9440400 9440400 20260307175007_mJ2H1 KR001K 2026-03-08T12:13:32.214Z 2026-03-15T12:42:05.708Z
9396508 9396508 20260225194558_LJMwV KR001K 2026-02-26T14:23:22.631Z 2026-03-05T14:38:43.252Z
9396036 9396036 20260225180053_m3Y6C KR001K 2026-02-26T14:22:43.894Z 2026-03-05T14:38:24.931Z
9395996 9395996 20260225175608_CrC26 KR001K 2026-02-26T14:22:42.249Z 2026-03-05T14:38:24.234Z
9379999 9379999 20260222184049_Tp1ed KR001K 2026-02-24T14:22:30.930Z 2026-02-24T14:22:30.930Z
9379979 9379979 20260222183705_AF6Mj KR001K 2026-02-24T14:22:29.315Z 2026-02-24T14:22:29.315Z
9379288 9379288 20260222163558_82PLH KR001K 2026-02-24T14:21:08.314Z 2026-02-24T14:21:08.314Z
9379113 9379113 20260222161130_2NdWL KR001K 2026-02-24T14:20:44.075Z 2026-02-24T14:20:44.075Z
9350528 9350528 20260218205740_Gqaco KR001K 2026-02-20T14:02:01.024Z 2026-02-27T14:36:01.116Z
9350520 9350520 20260218205724_4JFY3 KR001K 2026-02-20T14:02:01.016Z 2026-02-27T14:36:01.094Z
9350475 9350475 20260218204637_4Xego KR001K 2026-02-20T14:02:00.900Z 2026-02-27T14:36:00.680Z
9350291 9350291 20260218201537_b6aGb KR001K 2026-02-20T14:02:00.405Z 2026-02-27T14:35:58.447Z
9350283 9350283 20260218201426_rlQDM KR001K 2026-02-20T14:02:00.398Z 2026-02-27T14:35:58.410Z
9350117 9350117 20260218194804_PHioD KR001K 2026-02-20T14:02:00.038Z 2026-02-27T14:35:56.762Z
9349734 9349734 20260218185434_YnQAD KR001K 2026-02-20T14:01:58.689Z 2026-02-27T14:35:52.912Z
9349246 9349246 20260218173605_2i47v KR001K 2026-02-20T14:01:57.234Z 2026-02-27T14:35:47.904Z
9349071 9349071 20260218170436_3Mzeg KR001K 2026-02-20T14:01:56.456Z 2026-02-27T14:35:46.127Z
9349047 9349047 20260218170213_PA772 KR001K 2026-02-20T14:01:56.401Z 2026-02-27T14:35:45.939Z
9348624 9348624 20260218160644_gpBis KR001K 2026-02-20T14:01:55.050Z 2026-02-27T14:35:33.644Z
9348347 9348347 20260218153245_LKna8 KR001K 2026-02-20T14:01:54.195Z 2026-02-27T14:35:20.062Z
9348191 9348191 20260218151734_V2Y1T KR001K 2026-02-20T14:01:53.676Z 2026-02-27T14:35:14.879Z
9338687 9338687 20260217164651_hIbop KR001K 2026-02-18T14:12:06.226Z 2026-02-26T14:39:46.291Z
9333646 9333646 20260216205845_kXs3F KR001K 2026-02-17T14:16:32.676Z 2026-02-25T14:42:45.743Z
9333616 9333616 20260216204252_mVYCZ KR001K 2026-02-17T14:16:27.053Z 2026-02-25T14:42:45.255Z
9333591 9333591 20260216204007_rzbin KR001K 2026-02-17T14:16:25.017Z 2026-02-25T14:42:45.146Z
9333525 9333525 20260216202105_rRTsq KR001K 2026-02-17T14:16:13.801Z 2026-02-25T14:42:43.809Z
9333516 9333516 20260216201750_IJoow KR001K 2026-02-17T14:16:11.939Z 2026-02-25T14:42:43.767Z
9199383 9199383 20260113195512_wM3D8 KR001K 2026-01-15T14:10:39.835Z 2026-01-22T15:07:23.268Z
9193557 9193557 20260113161243_0kf44 KR001K 2026-01-14T14:02:11.652Z 2026-01-22T15:06:26.215Z
9187250 9187250 20260111155333_yY5DZ KR001K 2026-01-13T14:06:24.385Z 2026-01-20T15:20:11.714Z
9170970 9170970 20260108180907_YWPPE KR001K 2026-01-10T14:04:25.449Z 2026-01-17T15:23:13.804Z
9170951 9170951 20260108175535_GU2rt KR001K 2026-01-10T14:04:21.159Z 2026-01-17T15:23:13.218Z
9170904 9170904 20260108173310_BI8xG KR001K 2026-01-10T14:04:01.841Z 2026-01-17T15:23:10.656Z
9170867 9170867 20260108172508_tq6VX KR001K 2026-01-10T14:03:48.285Z 2026-01-17T15:23:08.419Z
9170747 9170747 20260108163225_7yaDY KR001K 2026-01-10T14:03:12.572Z 2026-01-17T15:22:57.007Z
9170685 9170685 20260108161525_MvuT6 KR001K 2026-01-10T14:02:49.255Z 2026-01-17T15:22:54.377Z
9157766 9157766 20260105184455_zThbz KR001K 2026-01-07T14:03:30.900Z 2026-01-13T15:06:28.549Z
9148695 9148695 20260105205048_Hoe97 KR001K 2026-01-06T14:01:48.547Z 2026-01-13T15:07:02.376Z
9148547 9148547 20260105184455_G2u5S KR001K 2026-01-06T14:01:01.809Z 2026-01-06T14:01:01.809Z
9148527 9148527 20260105182209_VM6hp KR001K 2026-01-06T14:00:56.032Z 2026-01-13T15:06:23.867Z
9148486 9148486 20260105173254_Qzu2w KR001K 2026-01-06T14:00:33.872Z 2026-01-13T15:06:07.414Z
9125531 9125531 20251231181438_2moyF KR001K 2026-01-02T14:55:28.984Z 2026-01-08T15:15:45.176Z
9125239 9125239 20251231171301_VSJ9X KR001K 2026-01-02T14:54:35.693Z 2026-01-08T15:15:20.039Z
9125186 9125186 20251231170147_zOlH3 KR001K 2026-01-02T14:54:25.685Z 2026-01-08T15:15:17.061Z
9125092 9125092 20251231163312_l6rrx KR001K 2026-01-02T14:54:12.831Z 2026-01-08T15:15:11.158Z
9124944 9124944 20251231155049_IfCDf KR001K 2026-01-02T14:53:44.470Z 2026-01-08T15:14:52.533Z
9121139 9121139 20251231204827_b6Ed3 KR001K 2026-01-02T14:05:54.563Z 2026-01-09T14:51:46.634Z
9121052 9121052 20251231203130_5neT3 KR001K 2026-01-02T14:05:35.059Z 2026-01-09T14:51:44.052Z
9120680 9120680 20251231191834_C9O3l KR001K 2026-01-02T14:03:42.283Z 2026-01-09T14:51:18.622Z
9108945 9108945 20251229195630_bJi2k KR001K 2025-12-31T14:45:00.378Z 2026-01-06T15:22:07.576Z
9108789 9108789 20251229193741_miGr3 KR001K 2025-12-31T14:44:32.210Z 2026-01-06T15:22:01.849Z
9108600 9108600 20251229191152_ZWoio KR001K 2025-12-31T14:44:00.521Z 2026-01-06T15:21:40.171Z
9108453 9108453 20251229185131_NfgSw KR001K 2025-12-31T14:43:36.873Z 2026-01-06T15:21:35.676Z
9108412 9108412 20251229184418_EaVyF KR001K 2025-12-31T14:43:30.407Z 2026-01-06T15:21:34.194Z
9108367 9108367 20251229183807_hYYmL KR001K 2025-12-31T14:43:26.184Z 2026-01-06T15:21:32.941Z
9100924 9100924 20251229213837_eroKk KR001K 2025-12-31T14:05:26.474Z 2026-01-07T15:05:44.305Z
9100911 9100911 20251229213623_ySWzq KR001K 2025-12-31T14:05:23.948Z 2026-01-07T15:05:43.850Z
9100685 9100685 20251229205706_lYlp8 KR001K 2025-12-31T14:04:14.155Z 2026-01-07T15:05:33.889Z
9100402 9100402 20251229195820_DFVJQ KR001K 2025-12-31T14:02:34.818Z 2026-01-07T15:05:15.083Z
9090890 9090890 20251228171329_V5BuJ KR001K 2025-12-30T14:51:23.834Z 2026-01-05T15:13:43.488Z
9090676 9090676 20251228161655_zgQMV KR001K 2025-12-30T14:50:52.111Z 2026-01-05T15:13:33.771Z
9071253 9071253 20251226181420_hf7A9 KR001K 2025-12-29T14:49:04.005Z 2026-01-03T15:42:44.693Z
9022749 9022749 20251220183610_SSisg KR001K 2025-12-27T15:08:38.410Z 2025-12-29T15:26:13.271Z
9015442 9015442 20251221214350_UgqgE KR001K 2025-12-27T14:54:18.778Z 2025-12-27T14:54:18.778Z
9015198 9015198 20251221211308_JBSbz KR001K 2025-12-27T14:54:10.633Z 2025-12-27T14:54:10.633Z
9015002 9015002 20251221205321_R7v7m KR001K 2025-12-27T14:53:34.512Z 2025-12-27T14:53:34.512Z
9014935 9014935 20251221204059_gr77u KR001K 2025-12-27T14:53:26.081Z 2025-12-27T14:53:26.081Z
9014661 9014661 20251221200405_77yg2 KR001K 2025-12-27T14:53:17.208Z 2025-12-27T14:53:17.208Z
9014602 9014602 20251221195755_3VxSN KR001K 2025-12-27T14:53:15.016Z 2025-12-27T14:53:15.016Z
9014276 9014276 20251221192930_HlHwl KR001K 2025-12-27T14:52:37.859Z 2025-12-27T14:52:37.859Z
9014186 9014186 20251221191901_mpgub KR001K 2025-12-27T14:52:16.234Z 2025-12-27T14:52:16.234Z
9014043 9014043 20251221190637_YUaVf KR001K 2025-12-27T14:51:54.924Z 2025-12-27T14:51:54.924Z
9013919 9013919 20251221185356_6PuK3 KR001K 2025-12-27T14:51:48.628Z 2025-12-27T14:51:48.628Z
9013607 9013607 20251221182556_13Ixk KR001K 2025-12-27T14:51:35.822Z 2025-12-27T14:51:35.822Z
9013499 9013499 20251221181304_Mjhq5 KR001K 2025-12-27T14:51:30.726Z 2025-12-27T14:51:30.726Z
9013206 9013206 20251221173348_c2R3o KR001K 2025-12-27T14:50:42.798Z 2025-12-27T14:50:42.798Z
9012686 9012686 20251221163316_aWxjm KR001K 2025-12-27T14:49:46.451Z 2025-12-27T14:49:46.451Z
9012646 9012646 20251221162314_EiHn2 KR001K 2025-12-27T14:49:40.693Z 2025-12-27T14:49:40.693Z
9012516 9012516 20251221155830_fbpDU KR001K 2025-12-27T14:49:34.576Z 2025-12-27T14:49:34.576Z
9012470 9012470 20251221155137_JVWvK KR001K 2025-12-27T14:49:30.761Z 2025-12-27T14:49:30.761Z
9012328 9012328 20251221153439_YDkYO KR001K 2025-12-27T14:49:25.161Z 2025-12-27T14:49:25.161Z
9011972 9011972 20251221150839_iHWcw KR001K 2025-12-27T14:48:44.714Z 2025-12-27T14:48:44.714Z
9011533 9011533 20251221144650_mkup7 KR001K 2025-12-27T14:48:16.753Z 2025-12-27T14:48:16.753Z
9004604 9004604 20251222174838_yXSKZ KR001K 2025-12-27T14:31:47.132Z 2025-12-28T15:03:08.945Z
9004237 9004237 20251222160956_3EjT1 KR001K 2025-12-27T14:30:32.130Z 2025-12-30T15:48:59.709Z
8992206 8992206 20251218184423_d2IXa KR001K 2025-12-26T14:50:40.109Z 2025-12-27T15:25:54.504Z
8991280 8991280 20251218161942_Z6zuq KR001K 2025-12-26T14:48:26.488Z 2025-12-27T15:24:51.923Z
8990988 8990988 20251218153455_IEPhq KR001K 2025-12-26T14:47:39.181Z 2025-12-27T15:24:27.313Z
8990939 8990939 20251218153015_yTJYJ KR001K 2025-12-26T14:47:34.749Z 2025-12-27T15:24:26.905Z
8766887 8766887 20251212182748_FclzW KR001K 2025-12-14T14:56:08.915Z 2025-12-21T14:17:26.553Z
8766849 8766849 20251212181906_XcG3t KR001K 2025-12-14T14:56:01.623Z 2025-12-21T14:17:26.508Z
8766766 8766766 20251212180539_GiaBK KR001K 2025-12-14T14:55:53.100Z 2025-12-21T14:17:26.433Z
8766508 8766508 20251212171308_97gCq KR001K 2025-12-14T14:53:41.302Z 2025-12-21T14:17:26.176Z
8765541 8765541 20251212151708_pVu6C KR001K 2025-12-14T14:50:29.961Z 2025-12-21T14:17:25.702Z
8765183 8765183 20251212150134_3LHLx KR001K 2025-12-14T14:49:20.356Z 2025-12-21T14:17:25.608Z

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