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,451 rows where station_code = "KR002G" 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
8689776 8689776 20251205210644_2ekSE KR002G 2025-12-06T14:09:51.589Z 2025-12-06T14:09:51.589Z
8689686 8689686 20251205193948_NeDhI KR002G 2025-12-06T14:09:26.466Z 2025-12-06T14:09:26.466Z
8689680 8689680 20251205193343_YlewL KR002G 2025-12-06T14:09:25.018Z 2025-12-06T14:09:25.018Z
8689664 8689664 20251205191930_jQ9EM KR002G 2025-12-06T14:09:22.456Z 2025-12-06T14:09:22.456Z
8689660 8689660 20251205191712_wCqF1 KR002G 2025-12-06T14:09:21.844Z 2025-12-06T14:09:21.844Z
8689610 8689610 20251205185126_qTs9n KR002G 2025-12-06T14:09:11.216Z 2025-12-06T14:09:11.216Z
8686769 8686769 20251203204752_BMasZ KR002G 2025-12-05T14:12:43.415Z 2025-12-06T14:22:05.440Z
8686737 8686737 20251203204119_ryAlw KR002G 2025-12-05T14:12:40.924Z 2025-12-06T14:22:04.141Z
8686735 8686735 20251203204117_AuMk5 KR002G 2025-12-05T14:12:40.757Z 2025-12-06T14:22:03.963Z
8686728 8686728 20251203204113_hCNak KR002G 2025-12-05T14:12:40.610Z 2025-12-06T14:22:03.866Z
8686709 8686709 20251203203806_aZ54h KR002G 2025-12-05T14:12:39.123Z 2025-12-06T14:22:03.018Z
8686499 8686499 20251203195559_dgLSG KR002G 2025-12-05T14:12:03.256Z 2025-12-06T14:21:55.499Z
8686446 8686446 20251203195230_LT2gw KR002G 2025-12-05T14:11:54.147Z 2025-12-06T14:21:53.027Z
8686374 8686374 20251203193848_lUKaV KR002G 2025-12-05T14:11:49.143Z 2025-12-06T14:21:49.495Z
8686205 8686205 20251203190535_rYhl8 KR002G 2025-12-05T14:11:14.409Z 2025-12-06T14:21:34.108Z
8686192 8686192 20251203190351_YATmU KR002G 2025-12-05T14:11:13.564Z 2025-12-06T14:21:33.667Z
8686166 8686166 20251203185529_FKMiH KR002G 2025-12-05T14:11:09.859Z 2025-12-06T14:21:32.517Z
8686101 8686101 20251203183405_Vq3Je KR002G 2025-12-05T14:11:02.465Z 2025-12-06T14:21:29.615Z
8685848 8685848 20251203171256_3i8Iu KR002G 2025-12-05T14:10:06.833Z 2025-12-06T14:21:07.738Z
8685845 8685845 20251203171223_6d76R KR002G 2025-12-05T14:10:06.245Z 2025-12-06T14:21:07.271Z
8685797 8685797 20251203165233_IPKD1 KR002G 2025-12-05T14:09:58.776Z 2025-12-06T14:21:02.146Z
8685780 8685780 20251203164759_o6JVz KR002G 2025-12-05T14:09:56.524Z 2025-12-06T14:21:00.926Z
8685749 8685749 20251203162856_lM8sH KR002G 2025-12-05T14:09:52.035Z 2025-12-06T14:20:58.485Z
8685747 8685747 20251203162855_gHT69 KR002G 2025-12-05T14:09:51.716Z 2025-12-06T14:20:58.427Z
8685730 8685730 20251203162056_GHcnV KR002G 2025-12-05T14:09:47.796Z 2025-12-06T14:20:57.371Z
8685711 8685711 20251203161830_5M7PH KR002G 2025-12-05T14:09:45.866Z 2025-12-06T14:20:56.654Z
8685691 8685691 20251203160512_ynO3v KR002G 2025-12-05T14:09:42.189Z 2025-12-06T14:20:55.114Z
8680007 8680007 20251202211706_pE0vm KR002G 2025-12-04T14:10:53.237Z 2025-12-06T14:26:47.121Z
8679993 8679993 20251202211513_KEX9J KR002G 2025-12-04T14:10:52.096Z 2025-12-06T14:26:46.710Z
8679989 8679989 20251202211347_1PGjJ KR002G 2025-12-04T14:10:51.755Z 2025-12-06T14:26:46.563Z
8679849 8679849 20251202210049_04Mp7 KR002G 2025-12-04T14:10:30.799Z 2025-12-06T14:26:41.166Z
8679820 8679820 20251202205516_CpfRJ KR002G 2025-12-04T14:10:28.171Z 2025-12-06T14:26:40.417Z
8679815 8679815 20251202205516_luZO2 KR002G 2025-12-04T14:10:27.987Z 2025-12-06T14:26:40.385Z
8679810 8679810 20251202205403_pJWMO KR002G 2025-12-04T14:10:27.769Z 2025-12-06T14:26:40.281Z
8679771 8679771 20251202204842_2Jcxj KR002G 2025-12-04T14:10:24.656Z 2025-12-06T14:26:39.381Z
8679757 8679757 20251202204753_kyQw1 KR002G 2025-12-04T14:10:23.197Z 2025-12-06T14:26:38.786Z
8679709 8679709 20251202204151_ZN93U KR002G 2025-12-04T14:10:17.614Z 2025-12-06T14:26:37.307Z
8679701 8679701 20251202204150_YY5op KR002G 2025-12-04T14:10:17.324Z 2025-12-06T14:26:37.227Z
8679667 8679667 20251202203732_EUWJn KR002G 2025-12-04T14:10:15.056Z 2025-12-06T14:26:30.049Z
8679651 8679651 20251202203605_28THl KR002G 2025-12-04T14:10:13.679Z 2025-12-06T14:26:29.638Z
8679645 8679645 20251202203453_A29N4 KR002G 2025-12-04T14:10:12.794Z 2025-12-06T14:26:29.360Z
8672843 8672843 20251201152741_Drn3T KR002G 2025-12-03T14:16:39.899Z 2025-12-06T14:32:22.371Z
8663600 8663600 20251130210727_2CpuU KR002G 2025-12-02T14:18:33.056Z 2025-12-06T14:40:04.636Z
8663531 8663531 20251130205640_hs7m7 KR002G 2025-12-02T14:18:24.581Z 2025-12-06T14:40:02.180Z
8663407 8663407 20251130204352_lE5bK KR002G 2025-12-02T14:18:15.177Z 2025-12-06T14:40:00.257Z
8663162 8663162 20251130201725_Qh3tn KR002G 2025-12-02T14:17:34.129Z 2025-12-06T14:39:54.857Z
8663015 8663015 20251130195631_r04Lz KR002G 2025-12-02T14:17:17.635Z 2025-12-06T14:39:39.094Z
8662916 8662916 20251130194643_33tST KR002G 2025-12-02T14:17:00.964Z 2025-12-06T14:39:35.249Z
8662908 8662908 20251130194643_rEPWr KR002G 2025-12-02T14:17:00.661Z 2025-12-06T14:39:35.192Z
8662901 8662901 20251130194643_DdfYp KR002G 2025-12-02T14:17:00.157Z 2025-12-06T14:39:35.040Z
8660905 8660905 20251130141010_0lVAB KR002G 2025-12-02T14:09:38.315Z 2025-12-06T14:37:29.237Z
8649206 8649206 20251129163655_0BWAE KR002G 2025-12-01T14:11:26.556Z 2025-12-06T14:44:51.252Z
8649080 8649080 20251129160236_aoxUO KR002G 2025-12-01T14:10:49.630Z 2025-12-06T14:44:47.899Z
8649073 8649073 20251129160135_ZvdVF KR002G 2025-12-01T14:10:48.256Z 2025-12-06T14:44:47.707Z
8648945 8648945 20251129152237_CKMZV KR002G 2025-12-01T14:10:01.234Z 2025-12-06T14:44:42.027Z
8648782 8648782 20251129122734_2s9Lp KR002G 2025-12-01T14:06:15.241Z 2025-12-06T14:43:54.568Z
8645300 8645300 20251128211419_tOk3v KR002G 2025-11-30T14:23:32.577Z 2025-12-06T14:54:53.041Z
8645166 8645166 20251128204521_XQR6e KR002G 2025-11-30T14:23:10.386Z 2025-12-06T14:54:51.115Z
8645151 8645151 20251128204353_cxPrr KR002G 2025-11-30T14:23:09.981Z 2025-12-06T14:54:51.070Z
8645005 8645005 20251128202217_RKKoC KR002G 2025-11-30T14:22:56.747Z 2025-12-06T14:54:49.796Z
8644867 8644867 20251128200732_k8krq KR002G 2025-11-30T14:22:48.579Z 2025-12-06T14:54:48.320Z
8644813 8644813 20251128200000_Xazcq KR002G 2025-11-30T14:22:44.422Z 2025-12-06T14:54:47.652Z
8644741 8644741 20251128194935_0nT7U KR002G 2025-11-30T14:22:21.764Z 2025-12-06T14:54:46.992Z
8644619 8644619 20251128193646_zxecQ KR002G 2025-11-30T14:22:09.700Z 2025-12-06T14:54:45.166Z
8644522 8644522 20251128193036_UPhc5 KR002G 2025-11-30T14:22:04.201Z 2025-12-06T14:54:43.543Z
8644300 8644300 20251128191843_Qyxto KR002G 2025-11-30T14:21:36.987Z 2025-12-06T14:54:40.530Z
8644148 8644148 20251128190332_NsANE KR002G 2025-11-30T14:21:24.361Z 2025-12-06T14:54:38.730Z
8644007 8644007 20251128184902_3XB2d KR002G 2025-11-30T14:21:02.536Z 2025-12-06T14:54:36.737Z
8643963 8643963 20251128184203_MANEB KR002G 2025-11-30T14:20:55.250Z 2025-12-06T14:54:36.015Z
8643946 8643946 20251128184111_PVUxs KR002G 2025-11-30T14:20:52.113Z 2025-12-06T14:54:34.252Z
8643934 8643934 20251128183953_lY6W6 KR002G 2025-11-30T14:20:49.989Z 2025-12-06T14:54:33.601Z
8643904 8643904 20251128183744_DUr3m KR002G 2025-11-30T14:20:47.953Z 2025-12-06T14:54:31.803Z
8643796 8643796 20251128182749_oC0e5 KR002G 2025-11-30T14:20:41.183Z 2025-12-06T14:54:16.024Z
8643687 8643687 20251128181447_l9fUB KR002G 2025-11-30T14:20:33.286Z 2025-12-06T14:54:03.969Z
8643603 8643603 20251128180837_icNYv KR002G 2025-11-30T14:20:15.748Z 2025-12-06T14:53:52.064Z
8643575 8643575 20251128180705_K2WwD KR002G 2025-11-30T14:20:13.712Z 2025-12-06T14:53:51.470Z
8643467 8643467 20251128175950_v0Jc2 KR002G 2025-11-30T14:20:03.341Z 2025-12-06T14:53:49.840Z
8643162 8643162 20251128172924_3VxIy KR002G 2025-11-30T14:19:24.291Z 2025-12-06T14:53:42.152Z
8643067 8643067 20251128171628_07x1H KR002G 2025-11-30T14:19:16.832Z 2025-12-06T14:53:39.980Z
8643057 8643057 20251128171608_2ubj3 KR002G 2025-11-30T14:19:16.567Z 2025-12-06T14:53:39.948Z
8643017 8643017 20251128171215_GyAPo KR002G 2025-11-30T14:19:13.332Z 2025-12-06T14:53:39.433Z
8642992 8642992 20251128171004_NYDRv KR002G 2025-11-30T14:19:12.126Z 2025-12-06T14:53:39.116Z
8642912 8642912 20251128170154_mz2Uv KR002G 2025-11-30T14:18:58.119Z 2025-12-06T14:53:37.769Z
8642903 8642903 20251128170142_xZm0X KR002G 2025-11-30T14:18:57.539Z 2025-12-06T14:53:37.718Z
8642834 8642834 20251128165350_12BjO KR002G 2025-11-30T14:18:41.872Z 2025-12-06T14:53:36.754Z
8642610 8642610 20251128163113_B1Wpy KR002G 2025-11-30T14:18:21.670Z 2025-12-06T14:53:34.054Z
8642368 8642368 20251128155826_XfLPD KR002G 2025-11-30T14:17:50.622Z 2025-12-06T14:53:30.790Z
8641605 8641605 20251128150111_iRIev KR002G 2025-11-30T14:16:34.698Z 2025-12-06T14:52:40.015Z
8641177 8641177 20251128140242_tmiyC KR002G 2025-11-30T14:14:47.538Z 2025-12-06T14:52:26.852Z
8640935 8640935 20251128124840_6m2Vf KR002G 2025-11-30T14:12:22.439Z 2025-12-06T14:51:51.915Z
8640893 8640893 20251128123659_wTfhQ KR002G 2025-11-30T14:11:55.220Z 2025-12-06T14:51:41.695Z
8640810 8640810 20251128113858_B7O1Z KR002G 2025-11-30T14:10:59.287Z 2025-12-06T14:51:25.497Z
8632425 8632425 20251127210516_SIv82 KR002G 2025-11-29T14:17:27.928Z 2025-12-06T15:01:17.214Z
8632401 8632401 20251127210245_8K4c5 KR002G 2025-11-29T14:17:26.111Z 2025-12-06T15:01:14.961Z
8632381 8632381 20251127205658_Rrww4 KR002G 2025-11-29T14:17:22.656Z 2025-12-06T15:01:14.526Z
8632270 8632270 20251127204502_fI1rW KR002G 2025-11-29T14:17:11.962Z 2025-12-06T15:01:07.326Z
8632214 8632214 20251127204151_Kk7LY KR002G 2025-11-29T14:17:08.666Z 2025-12-06T15:01:01.810Z
8632208 8632208 20251127204049_SlTzV KR002G 2025-11-29T14:17:07.686Z 2025-12-06T15:01:01.252Z
8632174 8632174 20251127203826_FfXOb KR002G 2025-11-29T14:17:05.523Z 2025-12-06T15:00:58.282Z
8632057 8632057 20251127202755_pPfDV KR002G 2025-11-29T14:16:46.396Z 2025-12-06T15:00:50.759Z

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