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,535 rows where station_code = "KR001X" 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
9266819 9266819 20260127214022_w2NN4 KR001X 2026-01-28T14:14:39.955Z 2026-01-29T14:30:25.225Z
9266766 9266766 20260127210710_yBm52 KR001X 2026-01-28T14:14:31.757Z 2026-01-29T14:30:25.213Z
9266635 9266635 20260127201839_KKFd8 KR001X 2026-01-28T14:14:08.809Z 2026-01-29T14:30:25.149Z
9266351 9266351 20260127185758_3rKoS KR001X 2026-01-28T14:13:16.674Z 2026-01-29T14:30:24.999Z
9258349 9258349 20260124100004_yOg90 KR001X 2026-01-26T14:10:54.451Z 2026-01-29T14:40:24.449Z
9258303 9258303 20260125211054_tZGtH KR001X 2026-01-26T14:10:23.494Z 2026-01-29T14:38:25.882Z
9257801 9257801 20260125155939_JNWg3 KR001X 2026-01-26T14:07:48.144Z 2026-01-29T14:37:41.693Z
9257543 9257543 20260125142638_xPH03 KR001X 2026-01-26T14:06:13.741Z 2026-01-29T14:37:26.595Z
9254230 9254230 20260123170710_0gTUw KR001X 2026-01-25T14:07:58.935Z 2026-01-29T14:45:59.595Z
9240069 9240069 20260120120638_33lBz KR001X 2026-01-22T14:05:31.980Z 2026-01-29T14:59:56.481Z
9227556 9227556 20260119210528_NfVCw KR001X 2026-01-20T14:08:59.540Z 2026-01-28T14:57:34.231Z
9222617 9222617 20260117200739_mqfzh KR001X 2026-01-19T14:15:36.438Z 2026-01-26T15:01:15.244Z
9222517 9222517 20260117194944_n6dWc KR001X 2026-01-19T14:15:07.189Z 2026-01-26T15:01:12.277Z
9222216 9222216 20260117184400_sm5kD KR001X 2026-01-19T14:13:50.246Z 2026-01-26T15:00:44.176Z
9221902 9221902 20260117171150_VZdc6 KR001X 2026-01-19T14:12:24.102Z 2026-01-26T15:00:29.731Z
9221890 9221890 20260117170821_eBOV2 KR001X 2026-01-19T14:12:22.802Z 2026-01-26T15:00:29.485Z
9221796 9221796 20260117163036_d0xKW KR001X 2026-01-19T14:11:57.223Z 2026-01-26T15:00:10.201Z
9217430 9217430 20260116143821_vEr82 KR001X 2026-01-18T14:07:00.517Z 2026-01-25T14:57:14.487Z
9217414 9217414 20260116134942_XxxI2 KR001X 2026-01-18T14:06:44.095Z 2026-01-25T14:57:10.840Z
9217399 9217399 20260116132253_DoOyl KR001X 2026-01-18T14:06:34.199Z 2026-01-25T14:57:08.093Z
9217280 9217280 20260117155442_5sETd KR001X 2026-01-18T14:05:09.916Z 2026-01-26T15:00:04.620Z
9211195 9211195 20260115133526_XKfA7 KR001X 2026-01-17T14:05:29.301Z 2026-01-24T15:08:52.998Z
9199856 9199856 20260113213321_oHUA7 KR001X 2026-01-15T14:12:46.099Z 2026-01-22T15:08:04.146Z
9199815 9199815 20260113212723_4rVn4 KR001X 2026-01-15T14:12:36.051Z 2026-01-22T15:08:03.094Z
9199735 9199735 20260113210902_C4r4x KR001X 2026-01-15T14:12:13.080Z 2026-01-22T15:08:00.782Z
9199586 9199586 20260113203337_Fxe3L KR001X 2026-01-15T14:11:34.449Z 2026-01-22T15:07:40.090Z
9199384 9199384 20260113195512_wM3D8 KR001X 2026-01-15T14:10:39.835Z 2026-01-22T15:07:23.268Z
9199210 9199210 20260113192326_8zvKY KR001X 2026-01-15T14:09:49.754Z 2026-01-22T15:07:16.972Z
9193791 9193791 20260113182102_Q53Tj KR001X 2026-01-14T14:03:20.242Z 2026-01-22T15:07:07.409Z
9193700 9193700 20260113173139_53239 KR001X 2026-01-14T14:02:55.250Z 2026-01-22T15:07:00.244Z
9193656 9193656 20260113170911_YN35S KR001X 2026-01-14T14:02:41.211Z 2026-01-22T15:06:34.485Z
9193646 9193646 20260113170307_phyK9 KR001X 2026-01-14T14:02:38.717Z 2026-01-22T15:06:33.822Z
9193558 9193558 20260113161243_0kf44 KR001X 2026-01-14T14:02:11.672Z 2026-01-22T15:06:26.215Z
9193550 9193550 20260113160904_z6R19 KR001X 2026-01-14T14:02:10.715Z 2026-01-22T15:06:26.056Z
9193527 9193527 20260113155453_qWt7Y KR001X 2026-01-14T14:02:00.106Z 2026-01-22T15:06:24.289Z
9193403 9193403 20260113143428_AW0aM KR001X 2026-01-14T14:01:13.085Z 2026-01-22T15:06:17.101Z
9193364 9193364 20260113135202_UjpPG KR001X 2026-01-14T14:00:54.231Z 2026-01-22T15:06:14.614Z
9179483 9179483 20260110160139_QzzxB KR001X 2026-01-12T14:02:50.746Z 2026-01-19T15:14:47.162Z
9179421 9179421 20260110153148_qcwUd KR001X 2026-01-12T14:02:14.126Z 2026-01-19T15:14:35.753Z
9174340 9174340 20260109151435_a7ECa KR001X 2026-01-11T14:02:19.860Z 2026-01-18T15:06:20.794Z
9171206 9171206 20260108200201_oEbkg KR001X 2026-01-10T14:05:56.894Z 2026-01-17T15:23:36.549Z
9171202 9171202 20260108200034_yFM82 KR001X 2026-01-10T14:05:56.148Z 2026-01-17T15:23:36.438Z
9170686 9170686 20260108161525_MvuT6 KR001X 2026-01-10T14:02:49.283Z 2026-01-17T15:22:54.377Z
9169924 9169924 20260108124252_qGgD5 KR001X 2026-01-09T14:15:16.600Z 2026-01-16T15:13:20.723Z
9167006 9167006 20260107213217_7j5EW KR001X 2026-01-09T14:05:48.832Z 2026-01-16T15:10:35.352Z
9157767 9157767 20260105184455_zThbz KR001X 2026-01-07T14:03:30.900Z 2026-01-13T15:06:28.549Z
9153079 9153079 20260105164545_3Z4rV KR001X 2026-01-06T14:19:32.353Z 2026-01-13T15:16:59.793Z
9152852 9152852 20260105140706_wNK9R KR001X 2026-01-06T14:18:43.238Z 2026-01-13T15:16:33.994Z
9152214 9152214 20260105100733_oZH2r KR001X 2026-01-06T14:16:15.259Z 2026-01-13T15:15:36.767Z
9148548 9148548 20260105184455_G2u5S KR001X 2026-01-06T14:01:01.810Z 2026-01-06T14:01:01.810Z
9148542 9148542 20260105184108_ezRza KR001X 2026-01-06T14:01:00.713Z 2026-01-13T15:06:27.120Z
9148528 9148528 20260105182209_VM6hp KR001X 2026-01-06T14:00:56.032Z 2026-01-13T15:06:23.867Z
9125725 9125725 20251231184016_CSBAu KR001X 2026-01-02T14:55:59.057Z 2026-01-08T15:15:56.237Z
9121344 9121344 20251231213352_gkTql KR001X 2026-01-02T14:06:54.346Z 2026-01-09T14:51:54.249Z
9121246 9121246 20251231211227_PLoqB KR001X 2026-01-02T14:06:23.584Z 2026-01-09T14:51:50.728Z
9120842 9120842 20251231194856_Rvv8z KR001X 2026-01-02T14:04:31.844Z 2026-01-09T14:51:25.859Z
9120681 9120681 20251231191834_C9O3l KR001X 2026-01-02T14:03:42.297Z 2026-01-09T14:51:18.622Z
9108790 9108790 20251229193741_miGr3 KR001X 2025-12-31T14:44:32.210Z 2026-01-06T15:22:01.849Z
9108765 9108765 20251229193440_8aVYg KR001X 2025-12-31T14:44:28.876Z 2026-01-06T15:21:55.365Z
9108601 9108601 20251229191152_ZWoio KR001X 2025-12-31T14:44:00.521Z 2026-01-06T15:21:40.171Z
9107930 9107930 20251229173201_fZQPC KR001X 2025-12-31T14:42:20.892Z 2026-01-06T15:21:05.709Z
9107564 9107564 20251229162502_b0lBN KR001X 2025-12-31T14:41:19.202Z 2026-01-06T15:20:52.055Z
9107117 9107117 20251229134100_Z3c8R KR001X 2025-12-31T14:39:40.140Z 2026-01-06T15:20:13.915Z
9100912 9100912 20251229213623_ySWzq KR001X 2025-12-31T14:05:23.948Z 2026-01-07T15:05:43.850Z
9100686 9100686 20251229205706_lYlp8 KR001X 2025-12-31T14:04:14.155Z 2026-01-07T15:05:33.889Z
9100571 9100571 20251229203913_6Hol5 KR001X 2025-12-31T14:03:41.741Z 2026-01-07T15:05:23.768Z
9100403 9100403 20251229195820_DFVJQ KR001X 2025-12-31T14:02:34.841Z 2026-01-07T15:05:15.083Z
9091912 9091912 20251228201441_hyGSE KR001X 2025-12-30T14:53:31.983Z 2026-01-05T15:14:44.354Z
9091902 9091902 20251228201259_DgrFF KR001X 2025-12-30T14:53:30.366Z 2026-01-05T15:14:44.188Z
9091668 9091668 20251228194252_08rkN KR001X 2025-12-30T14:52:59.809Z 2026-01-05T15:14:22.839Z
9091501 9091501 20251228190831_krCAy KR001X 2025-12-30T14:52:46.043Z 2026-01-05T15:14:15.171Z
9090891 9090891 20251228171329_V5BuJ KR001X 2025-12-30T14:51:23.834Z 2026-01-05T15:13:43.488Z
9090677 9090677 20251228161655_zgQMV KR001X 2025-12-30T14:50:52.126Z 2026-01-05T15:13:33.771Z
9049503 9049503 20251222211517_XqerT KR001X 2025-12-28T15:04:23.835Z 2025-12-30T15:49:15.545Z
9049405 9049405 20251222204117_z9Gms KR001X 2025-12-28T15:04:20.588Z 2025-12-30T15:49:14.642Z
9049320 9049320 20251222201510_zUG0w KR001X 2025-12-28T15:04:17.189Z 2025-12-30T15:49:14.033Z
9049234 9049234 20251222195532_PGkzR KR001X 2025-12-28T15:04:14.851Z 2025-12-30T15:49:13.606Z
9049153 9049153 20251222194520_93g2J KR001X 2025-12-28T15:04:12.885Z 2025-12-30T15:49:12.779Z
9049070 9049070 20251222193134_Ra5ci KR001X 2025-12-28T15:04:10.625Z 2025-12-30T15:49:12.119Z
9048121 9048121 20251222121406_U84Xa KR001X 2025-12-28T15:01:43.828Z 2025-12-30T15:48:22.603Z
9043352 9043352 20251224201819_hh0qQ KR001X 2025-12-28T14:47:27.723Z 2026-01-01T15:57:17.975Z
9043335 9043335 20251224201444_XS1Wr KR001X 2025-12-28T14:47:26.261Z 2026-01-01T15:57:17.703Z
9043131 9043131 20251224194628_dxJb5 KR001X 2025-12-28T14:46:55.902Z 2026-01-01T15:57:15.142Z
9043111 9043111 20251224194054_sKh9T KR001X 2025-12-28T14:46:54.030Z 2026-01-01T15:57:14.718Z
9043027 9043027 20251224193202_WKu7e KR001X 2025-12-28T14:46:49.244Z 2026-01-01T15:57:13.725Z
9042803 9042803 20251224190557_HDpOg KR001X 2025-12-28T14:46:24.042Z 2026-01-01T15:57:10.556Z
9040454 9040454 20251224134746_lekvc KR001X 2025-12-28T14:42:17.154Z 2026-01-01T15:55:50.199Z
9015459 9015459 20251221214711_NEaEF KR001X 2025-12-27T14:54:19.398Z 2025-12-27T14:54:19.398Z
9015272 9015272 20251221212156_79zNm KR001X 2025-12-27T14:54:12.629Z 2025-12-27T14:54:12.629Z
9014936 9014936 20251221204059_gr77u KR001X 2025-12-27T14:53:26.081Z 2025-12-27T14:53:26.081Z
9014853 9014853 20251221203217_KE5iC KR001X 2025-12-27T14:53:23.323Z 2025-12-27T14:53:23.323Z
9014694 9014694 20251221200806_iw0F5 KR001X 2025-12-27T14:53:17.740Z 2025-12-27T14:53:17.740Z
9014662 9014662 20251221200405_77yg2 KR001X 2025-12-27T14:53:17.208Z 2025-12-27T14:53:17.208Z
9014603 9014603 20251221195755_3VxSN KR001X 2025-12-27T14:53:15.016Z 2025-12-27T14:53:15.016Z
9014486 9014486 20251221194734_8AFF4 KR001X 2025-12-27T14:53:09.917Z 2025-12-27T14:53:09.917Z
9014457 9014457 20251221194532_gaWoh KR001X 2025-12-27T14:53:08.951Z 2025-12-27T14:53:08.951Z
9014332 9014332 20251221193527_hCUbt KR001X 2025-12-27T14:52:53.851Z 2025-12-27T14:52:53.851Z
9014117 9014117 20251221191306_VGhR7 KR001X 2025-12-27T14:52:03.722Z 2025-12-27T14:52:03.722Z
9014090 9014090 20251221191123_SI3c2 KR001X 2025-12-27T14:51:59.686Z 2025-12-27T14:51:59.686Z
9014044 9014044 20251221190637_YUaVf KR001X 2025-12-27T14:51:54.924Z 2025-12-27T14:51:54.924Z

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