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

7,257 rows where station_code = "KR003S" 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
9271692 9271692 20260127191636_d7b2L KR003S 2026-01-29T14:22:33.118Z 2026-01-29T14:30:25.025Z
9271310 9271310 20260128210615_BX3WM KR003S 2026-01-29T14:15:52.323Z 2026-01-29T14:15:52.323Z
9271295 9271295 20260128210213_Beom7 KR003S 2026-01-29T14:15:50.948Z 2026-01-29T14:15:50.948Z
9271289 9271289 20260128205407_0SHzC KR003S 2026-01-29T14:15:50.382Z 2026-01-29T14:15:50.382Z
9271265 9271265 20260128204259_ksSHa KR003S 2026-01-29T14:15:43.017Z 2026-01-29T14:15:43.017Z
9271253 9271253 20260128203742_Yjf5M KR003S 2026-01-29T14:15:41.535Z 2026-01-29T14:15:41.535Z
9271193 9271193 20260128202139_BLiyr KR003S 2026-01-29T14:15:32.728Z 2026-01-29T14:15:32.728Z
9271187 9271187 20260128202106_aBBTn KR003S 2026-01-29T14:15:32.328Z 2026-01-29T14:15:32.328Z
9271144 9271144 20260128201023_tNmVB KR003S 2026-01-29T14:15:25.959Z 2026-01-29T14:15:25.959Z
9271132 9271132 20260128200542_KyYzs KR003S 2026-01-29T14:15:19.917Z 2026-01-29T14:15:19.917Z
9271117 9271117 20260128200218_3lGG0 KR003S 2026-01-29T14:15:17.852Z 2026-01-29T14:15:17.852Z
9270990 9270990 20260128190740_s0Wdk KR003S 2026-01-29T14:14:45.210Z 2026-01-29T14:14:45.210Z
9270988 9270988 20260128190636_4hWde KR003S 2026-01-29T14:14:44.728Z 2026-01-29T14:14:44.728Z
9270975 9270975 20260128190538_sLQBc KR003S 2026-01-29T14:14:42.625Z 2026-01-29T14:14:42.625Z
9270956 9270956 20260128185941_a8PXF KR003S 2026-01-29T14:14:40.133Z 2026-01-29T14:14:40.133Z
9270929 9270929 20260128185406_o7BH3 KR003S 2026-01-29T14:14:35.247Z 2026-01-29T14:14:35.247Z
9270884 9270884 20260128182935_hem3G KR003S 2026-01-29T14:14:25.317Z 2026-01-29T14:14:25.317Z
9270866 9270866 20260128182121_sHcZK KR003S 2026-01-29T14:14:17.181Z 2026-01-29T14:14:17.181Z
9270809 9270809 20260128174941_Vlyit KR003S 2026-01-29T14:14:03.786Z 2026-01-29T14:14:03.786Z
9270797 9270797 20260128174451_sMCCp KR003S 2026-01-29T14:13:59.550Z 2026-01-29T14:13:59.550Z
9270740 9270740 20260128170757_3k2fU KR003S 2026-01-29T14:13:34.134Z 2026-01-29T14:13:34.134Z
9270649 9270649 20260128161809_q2K1I KR003S 2026-01-29T14:13:11.818Z 2026-01-29T14:13:11.818Z
9270624 9270624 20260128161352_Casb9 KR003S 2026-01-29T14:13:02.660Z 2026-01-29T14:13:02.660Z
9269565 9269565 20260128133547_kY1wZ KR003S 2026-01-29T14:08:29.992Z 2026-01-29T14:08:29.992Z
9267223 9267223 20260126204252_FYu0s KR003S 2026-01-28T14:20:23.851Z 2026-01-29T14:34:35.384Z
9267214 9267214 20260126203527_fCJH3 KR003S 2026-01-28T14:20:19.699Z 2026-01-29T14:34:34.208Z
9267212 9267212 20260126203423_FKJ2k KR003S 2026-01-28T14:20:19.130Z 2026-01-29T14:34:34.039Z
9266739 9266739 20260127205546_lSGBM KR003S 2026-01-28T14:14:24.993Z 2026-01-29T14:30:25.208Z
9266735 9266735 20260127205536_YWwXt KR003S 2026-01-28T14:14:24.261Z 2026-01-29T14:30:25.207Z
9266731 9266731 20260127205536_W8cFy KR003S 2026-01-28T14:14:23.701Z 2026-01-28T14:14:23.701Z
9266715 9266715 20260127205323_NfGeM KR003S 2026-01-28T14:14:21.535Z 2026-01-29T14:30:25.189Z
9266692 9266692 20260127204500_BDRwC KR003S 2026-01-28T14:14:17.649Z 2026-01-28T14:14:17.649Z
9266576 9266576 20260127195930_43fVT KR003S 2026-01-28T14:13:55.480Z 2026-01-28T14:13:55.480Z
9266512 9266512 20260127194052_sjp3B KR003S 2026-01-28T14:13:45.139Z 2026-01-29T14:30:25.066Z
9266483 9266483 20260127192831_kIL4i KR003S 2026-01-28T14:13:40.520Z 2026-01-29T14:30:25.039Z
9266434 9266434 20260127192147_0QNh8 KR003S 2026-01-28T14:13:34.793Z 2026-01-29T14:30:25.028Z
9266430 9266430 20260127192103_jB9rd KR003S 2026-01-28T14:13:33.927Z 2026-01-29T14:30:25.027Z
9266423 9266423 20260127191635_hWWhv KR003S 2026-01-28T14:13:31.693Z 2026-01-28T14:13:31.693Z
9266397 9266397 20260127191048_9Bg1Q KR003S 2026-01-28T14:13:24.417Z 2026-01-28T14:13:24.417Z
9266386 9266386 20260127190611_kzoIn KR003S 2026-01-28T14:13:21.738Z 2026-01-29T14:30:25.007Z
9266327 9266327 20260127185439_4UODp KR003S 2026-01-28T14:13:14.086Z 2026-01-29T14:30:24.996Z
9266304 9266304 20260127184643_dlBz2 KR003S 2026-01-28T14:13:11.807Z 2026-01-29T14:30:24.985Z
9266297 9266297 20260127184621_3Cap6 KR003S 2026-01-28T14:13:11.286Z 2026-01-29T14:30:24.984Z
9265902 9265902 20260127161116_2Of15 KR003S 2026-01-28T14:11:42.910Z 2026-01-29T14:30:24.711Z
9263378 9263378 20260124205257_GQ3pw KR003S 2026-01-27T14:22:09.680Z 2026-01-29T14:42:54.887Z
9259572 9259572 20260124213337_lIKUD KR003S 2026-01-26T14:17:29.278Z 2026-01-29T14:43:06.824Z
9259507 9259507 20260124211108_1zrlK KR003S 2026-01-26T14:17:19.565Z 2026-01-29T14:42:57.632Z
9259499 9259499 20260124211037_3owLQ KR003S 2026-01-26T14:17:18.076Z 2026-01-29T14:42:57.288Z
9259468 9259468 20260124205728_mPrZS KR003S 2026-01-26T14:17:07.168Z 2026-01-29T14:42:56.201Z
9259399 9259399 20260124204119_8sBQA KR003S 2026-01-26T14:16:52.763Z 2026-01-29T14:42:51.207Z
9259362 9259362 20260124203312_5F2iR KR003S 2026-01-26T14:16:42.457Z 2026-01-29T14:42:49.845Z
9259359 9259359 20260124203220_9XaAn KR003S 2026-01-26T14:16:41.849Z 2026-01-29T14:42:49.630Z
9259336 9259336 20260124202738_pG40n KR003S 2026-01-26T14:16:33.529Z 2026-01-29T14:42:48.522Z
9259326 9259326 20260124202420_IqwGW KR003S 2026-01-26T14:16:31.805Z 2026-01-29T14:42:47.913Z
9259220 9259220 20260124194402_RSMO0 KR003S 2026-01-26T14:16:11.115Z 2026-01-29T14:42:43.024Z
9259196 9259196 20260124193640_HMEgV KR003S 2026-01-26T14:16:04.089Z 2026-01-29T14:42:41.988Z
9259150 9259150 20260124190806_N2Zdq KR003S 2026-01-26T14:15:54.473Z 2026-01-29T14:42:38.913Z
9259077 9259077 20260124184013_7uT2X KR003S 2026-01-26T14:15:35.805Z 2026-01-29T14:42:29.553Z
9259072 9259072 20260124183709_4e3ZF KR003S 2026-01-26T14:15:34.679Z 2026-01-29T14:42:29.111Z
9258970 9258970 20260124181534_j7izv KR003S 2026-01-26T14:15:13.590Z 2026-01-26T14:23:12.931Z
9258839 9258839 20260124172421_GyE8Z KR003S 2026-01-26T14:14:38.793Z 2026-01-29T14:42:13.950Z
9258833 9258833 20260124172137_wTRYM KR003S 2026-01-26T14:14:37.572Z 2026-01-29T14:42:13.520Z
9258801 9258801 20260124171250_Q9QTj KR003S 2026-01-26T14:14:29.250Z 2026-01-29T14:42:11.444Z
9258764 9258764 20260124164857_YnM85 KR003S 2026-01-26T14:14:19.537Z 2026-01-29T14:42:06.894Z
9258755 9258755 20260124163950_c8Xhr KR003S 2026-01-26T14:14:13.044Z 2026-01-29T14:42:00.746Z
9258747 9258747 20260124163731_eIrdA KR003S 2026-01-26T14:14:11.765Z 2026-01-29T14:42:00.237Z
9258667 9258667 20260124154952_d0yWm KR003S 2026-01-26T14:13:44.596Z 2026-01-29T14:41:49.536Z
9258655 9258655 20260124154446_GoWQy KR003S 2026-01-26T14:13:39.420Z 2026-01-29T14:41:48.421Z
9258650 9258650 20260124154446_g1pCi KR003S 2026-01-26T14:13:38.827Z 2026-01-29T14:41:48.213Z
9258559 9258559 20260124143030_XTH7M KR003S 2026-01-26T14:12:57.892Z 2026-01-29T14:41:25.458Z
9258548 9258548 20260124142400_0j2Y3 KR003S 2026-01-26T14:12:49.712Z 2026-01-29T14:41:24.252Z
9258362 9258362 20260124101238_QNqZ1 KR003S 2026-01-26T14:10:59.253Z 2026-01-29T14:40:27.022Z
9258357 9258357 20260124100405_2VcyG KR003S 2026-01-26T14:10:56.486Z 2026-01-29T14:40:25.614Z
9257924 9257924 20260125170644_G3Gh5 KR003S 2026-01-26T14:08:35.522Z 2026-01-26T14:08:35.522Z
9256800 9256800 20260125103311_F77lG KR003S 2026-01-26T14:02:05.018Z 2026-01-29T14:36:24.827Z
9256792 9256792 20260125103308_YCva7 KR003S 2026-01-26T14:02:04.416Z 2026-01-29T14:36:24.646Z
9256776 9256776 20260125102339_EQFE8 KR003S 2026-01-26T14:01:55.828Z 2026-01-29T14:36:23.701Z
9254779 9254779 20260123211554_QcIGu KR003S 2026-01-25T14:10:42.825Z 2026-01-29T14:46:42.236Z
9254714 9254714 20260123210107_OxwY7 KR003S 2026-01-25T14:10:26.596Z 2026-01-29T14:46:37.135Z
9254649 9254649 20260123203756_S4eF1 KR003S 2026-01-25T14:10:12.051Z 2026-01-29T14:46:33.736Z
9254641 9254641 20260123203611_nTj8K KR003S 2026-01-25T14:10:08.092Z 2026-01-29T14:46:33.421Z
9254558 9254558 20260123201120_SbW7P KR003S 2026-01-25T14:09:48.649Z 2026-01-29T14:46:30.096Z
9254470 9254470 20260123193205_qTDRS KR003S 2026-01-25T14:09:22.893Z 2026-01-29T14:46:25.454Z
9254465 9254465 20260123193053_scP4m KR003S 2026-01-25T14:09:15.631Z 2026-01-29T14:46:25.115Z
9254426 9254426 20260123191459_retXi KR003S 2026-01-25T14:09:06.656Z 2026-01-29T14:46:22.846Z
9254387 9254387 20260123184719_Js05e KR003S 2026-01-25T14:08:56.284Z 2026-01-29T14:46:13.267Z
9254354 9254354 20260123183437_7tITr KR003S 2026-01-25T14:08:41.029Z 2026-01-29T14:46:11.402Z
9254301 9254301 20260123175937_XE8YW KR003S 2026-01-25T14:08:23.889Z 2026-01-29T14:46:04.800Z
9254261 9254261 20260123173853_jmHIw KR003S 2026-01-25T14:08:10.255Z 2026-01-29T14:46:02.048Z
9251561 9251561 20260122210009_nLzFB KR003S 2026-01-24T14:12:15.701Z 2026-01-29T14:51:48.995Z
9251465 9251465 20260122202152_u7fMs KR003S 2026-01-24T14:11:49.229Z 2026-01-29T14:51:42.994Z
9251442 9251442 20260122201511_eNIWQ KR003S 2026-01-24T14:11:45.309Z 2026-01-29T14:51:41.702Z
9251416 9251416 20260122200522_Z6U6N KR003S 2026-01-24T14:11:40.978Z 2026-01-29T14:51:40.035Z
9251398 9251398 20260122200017_SUvvZ KR003S 2026-01-24T14:11:36.009Z 2026-01-29T14:51:38.863Z
9251390 9251390 20260122195316_dkgOs KR003S 2026-01-24T14:11:32.680Z 2026-01-29T14:51:38.155Z
9251385 9251385 20260122195308_yL63h KR003S 2026-01-24T14:11:31.946Z 2026-01-29T14:51:37.955Z
9251340 9251340 20260122194545_gXAWk KR003S 2026-01-24T14:11:21.462Z 2026-01-29T14:51:29.518Z
9251318 9251318 20260122194109_kqCZi KR003S 2026-01-24T14:11:13.290Z 2026-01-29T14:51:28.343Z
9251263 9251263 20260122191928_TqrFF KR003S 2026-01-24T14:10:59.153Z 2026-01-29T14:51:22.762Z
9251258 9251258 20260122191912_1MJSE KR003S 2026-01-24T14:10:58.757Z 2026-01-29T14:51:22.412Z

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