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,967 rows where station_code = "KR001A" 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
8679700 8679700 20251202204150_YY5op KR001A 2025-12-04T14:10:17.324Z 2025-12-05T14:19:54.262Z
8679377 8679377 20251202195745_jIwB3 KR001A 2025-12-04T14:09:41.191Z 2025-12-05T14:19:40.483Z
8678496 8678496 20251202142650_wluoG KR001A 2025-12-04T14:07:06.601Z 2025-12-05T14:18:20.991Z
8678463 8678463 20251202134455_6uPWw KR001A 2025-12-04T14:07:00.644Z 2025-12-05T14:18:16.295Z
8672930 8672930 20251201154033_L9MuR KR001A 2025-12-03T14:16:57.655Z 2025-12-05T14:25:47.514Z
8671532 8671532 20251201123023_uA6mZ KR001A 2025-12-03T14:12:56.436Z 2025-12-05T14:24:33.020Z
8671264 8671264 20251201115015_9KMIV KR001A 2025-12-03T14:11:57.809Z 2025-12-05T14:24:20.819Z
8658183 8658183 20251128134120_TPf8s KR001A 2025-12-01T14:40:34.701Z 2025-12-05T14:47:54.841Z
8645177 8645177 20251128204821_RQRfW KR001A 2025-11-30T14:23:10.933Z 2025-12-05T14:50:32.621Z
8645084 8645084 20251128203458_yUTWO KR001A 2025-11-30T14:23:02.390Z 2025-12-05T14:50:31.573Z
8644766 8644766 20251128195610_NmZXA KR001A 2025-11-30T14:22:23.772Z 2025-12-05T14:50:26.813Z
8644647 8644647 20251128193905_EXgwC KR001A 2025-11-30T14:22:11.772Z 2025-12-05T14:50:25.125Z
8644518 8644518 20251128193036_UPhc5 KR001A 2025-11-30T14:22:04.201Z 2025-12-05T14:50:23.129Z
8644499 8644499 20251128192855_WcX8i KR001A 2025-11-30T14:22:02.848Z 2025-12-05T14:50:22.874Z
8644437 8644437 20251128192649_9CbGG KR001A 2025-11-30T14:22:00.008Z 2025-12-05T14:50:22.207Z
8643927 8643927 20251128183953_lY6W6 KR001A 2025-11-30T14:20:49.989Z 2025-12-05T14:50:06.953Z
8643899 8643899 20251128183744_DUr3m KR001A 2025-11-30T14:20:47.953Z 2025-12-05T14:50:01.381Z
8643790 8643790 20251128182749_oC0e5 KR001A 2025-11-30T14:20:41.183Z 2025-12-05T14:49:46.850Z
8643654 8643654 20251128181155_r2RLY KR001A 2025-11-30T14:20:31.083Z 2025-12-05T14:49:32.775Z
8643263 8643263 20251128173954_pP3h7 KR001A 2025-11-30T14:19:48.971Z 2025-12-05T14:49:14.704Z
8642998 8642998 20251128171027_HQFI7 KR001A 2025-11-30T14:19:12.348Z 2025-12-05T14:49:08.297Z
8642742 8642742 20251128164304_clIaU KR001A 2025-11-30T14:18:33.980Z 2025-12-05T14:49:04.072Z
8642573 8642573 20251128162503_sMmIw KR001A 2025-11-30T14:18:19.329Z 2025-12-05T14:49:01.576Z
8641558 8641558 20251128145922_KL507 KR001A 2025-11-30T14:16:32.327Z 2025-12-05T14:48:45.469Z
8641383 8641383 20251128143938_xNbq3 KR001A 2025-11-30T14:15:52.232Z 2025-12-05T14:48:21.734Z
8641234 8641234 20251128141048_r3uK2 KR001A 2025-11-30T14:15:06.612Z 2025-12-05T14:48:05.452Z
8641073 8641073 20251128134120_gV8oG KR001A 2025-11-30T14:14:05.074Z 2025-11-30T14:30:17.978Z
8640996 8640996 20251128131337_wsMPu KR001A 2025-11-30T14:13:24.017Z 2025-12-05T14:47:51.111Z
8640914 8640914 20251128124327_7OOoz KR001A 2025-11-30T14:12:04.280Z 2025-12-05T14:47:42.484Z
8640835 8640835 20251128115949_7zvMk KR001A 2025-11-30T14:11:09.917Z 2025-12-05T14:47:11.320Z
8640793 8640793 20251128112458_RP6Lc KR001A 2025-11-30T14:10:47.578Z 2025-12-05T14:47:04.101Z
8632212 8632212 20251127204151_Kk7LY KR001A 2025-11-29T14:17:08.666Z 2025-12-05T14:56:18.509Z
8631756 8631756 20251127195822_HXx6f KR001A 2025-11-29T14:16:21.627Z 2025-12-05T14:56:11.514Z
8630699 8630699 20251127170741_7CH4M KR001A 2025-11-29T14:13:29.366Z 2025-12-05T14:55:48.601Z
8621256 8621256 20251126144752_AbvCY KR001A 2025-11-28T14:15:10.394Z 2025-12-05T15:02:42.417Z
8576049 8576049 20251122140459_z5qA2 KR001A 2025-11-24T14:04:43.359Z 2025-12-01T15:18:32.734Z
8575820 8575820 20251122133612_ByCz6 KR001A 2025-11-24T14:04:08.208Z 2025-12-01T15:18:30.872Z
8575815 8575815 20251122133612_UVM8x KR001A 2025-11-24T14:04:07.843Z 2025-12-01T15:18:30.820Z
8548243 8548243 20251120204553_e85d1 KR001A 2025-11-22T14:16:38.462Z 2025-11-29T14:54:22.251Z
8547048 8547048 20251120191844_jNSZU KR001A 2025-11-22T14:14:14.127Z 2025-11-29T14:54:18.480Z
8546783 8546783 20251120185519_eBEEg KR001A 2025-11-22T14:13:38.583Z 2025-11-29T14:54:17.620Z
8546653 8546653 20251120184554_jx0Be KR001A 2025-11-22T14:13:17.619Z 2025-11-29T14:54:17.343Z
8546440 8546440 20251120183156_242ku KR001A 2025-11-22T14:12:46.058Z 2025-11-29T14:54:15.465Z
8546419 8546419 20251120183058_3Viya KR001A 2025-11-22T14:12:43.153Z 2025-11-29T14:54:15.321Z
8546111 8546111 20251120175545_iVbex KR001A 2025-11-22T14:11:59.525Z 2025-11-29T14:54:09.163Z
8545816 8545816 20251120173323_pTcLp KR001A 2025-11-22T14:11:23.747Z 2025-11-29T14:54:06.359Z
8545776 8545776 20251120172959_MPXoc KR001A 2025-11-22T14:11:17.165Z 2025-11-29T14:54:06.246Z
8545687 8545687 20251120172351_1ss2t KR001A 2025-11-22T14:11:04.616Z 2025-11-29T14:54:05.555Z
8545497 8545497 20251120165526_mi58H KR001A 2025-11-22T14:10:35.975Z 2025-11-29T14:54:03.496Z
8545485 8545485 20251120165519_QVZRq KR001A 2025-11-22T14:10:35.627Z 2025-11-29T14:54:03.494Z
8545381 8545381 20251120164758_n5u44 KR001A 2025-11-22T14:10:26.759Z 2025-11-29T14:54:02.586Z
8545023 8545023 20251120160035_OktfZ KR001A 2025-11-22T14:09:31.186Z 2025-11-29T14:53:57.551Z
8544990 8544990 20251120155350_IrVWV KR001A 2025-11-22T14:09:25.964Z 2025-11-29T14:53:57.381Z
8544263 8544263 20251120150111_EaJjH KR001A 2025-11-22T14:07:22.125Z 2025-11-29T14:53:43.242Z
8542883 8542883 20251120130545_F3i0l KR001A 2025-11-22T14:03:25.484Z 2025-11-29T14:53:16.358Z
8542604 8542604 20251120123214_V3qEr KR001A 2025-11-22T14:02:39.086Z 2025-11-29T14:53:13.441Z
8542318 8542318 20251120115738_JQKPq KR001A 2025-11-22T14:01:47.733Z 2025-11-29T14:53:09.593Z
8533089 8533089 20251119174808_8oUfx KR001A 2025-11-21T14:09:40.613Z 2025-11-28T14:54:14.914Z
8532914 8532914 20251119171801_H42Ns KR001A 2025-11-21T14:09:08.824Z 2025-11-28T14:54:02.874Z
8532833 8532833 20251119170323_jtuni KR001A 2025-11-21T14:08:59.056Z 2025-11-28T14:54:01.883Z
8532810 8532810 20251119165906_iwu35 KR001A 2025-11-21T14:08:57.800Z 2025-11-28T14:54:01.834Z
8532482 8532482 20251119161317_ls352 KR001A 2025-11-21T14:08:10.553Z 2025-11-28T14:53:57.039Z
8532321 8532321 20251119155504_T6xdd KR001A 2025-11-21T14:07:44.734Z 2025-11-28T14:53:55.798Z
8532117 8532117 20251119153122_v0X2H KR001A 2025-11-21T14:07:13.382Z 2025-11-28T14:53:52.745Z
8531858 8531858 20251119150959_A3Xbf KR001A 2025-11-21T14:06:28.929Z 2025-11-28T14:53:45.371Z
8531642 8531642 20251119144736_zj1dC KR001A 2025-11-21T14:05:51.793Z 2025-11-28T14:53:42.085Z
8531381 8531381 20251119142314_nMk9T KR001A 2025-11-21T14:04:57.891Z 2025-11-28T14:53:33.970Z
8530867 8530867 20251119130925_NOL6g KR001A 2025-11-21T14:03:16.460Z 2025-11-28T14:53:24.716Z
8519514 8519514 20251118172341_T1jLa KR001A 2025-11-20T14:07:04.913Z 2025-11-27T15:11:27.533Z
8519501 8519501 20251118172217_5Jrsi KR001A 2025-11-20T14:06:54.693Z 2025-11-27T15:11:27.486Z
8519448 8519448 20251118171920_hnXCG KR001A 2025-11-20T14:06:44.194Z 2025-11-27T15:11:27.206Z
8519225 8519225 20251118164830_Galv8 KR001A 2025-11-20T14:06:08.355Z 2025-11-27T15:11:26.006Z
8518875 8518875 20251118155155_ymlZK KR001A 2025-11-20T14:04:58.643Z 2025-11-27T15:11:18.718Z
8518853 8518853 20251118154951_OiwE6 KR001A 2025-11-20T14:04:55.385Z 2025-11-27T15:11:18.561Z
8518834 8518834 20251118154625_RLnZm KR001A 2025-11-20T14:04:53.061Z 2025-11-27T15:11:15.958Z
8518663 8518663 20251118151310_sobex KR001A 2025-11-20T14:04:19.934Z 2025-11-27T15:11:07.749Z
8518520 8518520 20251118143027_fZshC KR001A 2025-11-20T14:03:42.860Z 2025-11-27T15:11:04.816Z
8518026 8518026 20251118125158_oct2j KR001A 2025-11-20T14:02:20.219Z 2025-11-27T15:10:57.927Z
8504848 8504848 20251117192819_VOLGy KR001A 2025-11-19T14:08:56.725Z 2025-11-26T15:07:34.191Z
8503653 8503653 20251117174854_xcf2s KR001A 2025-11-19T14:05:58.819Z 2025-11-26T15:06:40.278Z
8502860 8502860 20251117155805_qHE1V KR001A 2025-11-19T14:03:58.909Z 2025-11-26T15:06:16.512Z
8502851 8502851 20251117155551_7gsG2 KR001A 2025-11-19T14:03:54.679Z 2025-11-26T15:06:16.478Z
8502789 8502789 20251117154701_YRHz2 KR001A 2025-11-19T14:03:41.987Z 2025-11-26T15:06:15.397Z
8502538 8502538 20251117145514_7OBnk KR001A 2025-11-19T14:02:55.818Z 2025-11-26T15:06:11.214Z
8502457 8502457 20251117143533_B2n9i KR001A 2025-11-19T14:02:40.248Z 2025-11-26T15:06:10.653Z
8502281 8502281 20251117134613_3wPtr KR001A 2025-11-19T14:02:08.089Z 2025-11-26T15:06:08.544Z
8501300 8501300 20251116104502_ypkux KR001A 2025-11-18T14:47:19.598Z 2025-11-24T15:06:28.152Z
8490741 8490741 20251116201816_pnJlv KR001A 2025-11-18T14:15:09.115Z 2025-11-25T15:08:25.408Z
8479814 8479814 20251115195925_Iq6Pt KR001A 2025-11-17T14:16:57.316Z 2025-11-24T15:04:48.109Z
8479048 8479048 20251115183205_2ZOI3 KR001A 2025-11-17T14:14:54.060Z 2025-11-24T15:04:31.699Z
8479000 8479000 20251115182803_xLfyJ KR001A 2025-11-17T14:14:50.835Z 2025-11-24T15:04:31.312Z
8478877 8478877 20251115181342_FXCSz KR001A 2025-11-17T14:14:29.765Z 2025-11-24T15:04:25.174Z
8478859 8478859 20251115181129_6Wsx0 KR001A 2025-11-17T14:14:28.814Z 2025-11-24T15:04:24.961Z
8478748 8478748 20251115175220_sxBjc KR001A 2025-11-17T14:14:14.076Z 2025-11-24T15:04:19.661Z
8478679 8478679 20251115174434_8JTQj KR001A 2025-11-17T14:14:02.795Z 2025-11-24T15:04:19.187Z
8478598 8478598 20251115173453_8VuNQ KR001A 2025-11-17T14:13:50.909Z 2025-11-24T15:04:16.762Z
8478099 8478099 20251115164753_6tTII KR001A 2025-11-17T14:12:45.826Z 2025-11-24T15:04:00.364Z
8478084 8478084 20251115164647_iKU3v KR001A 2025-11-17T14:12:45.155Z 2025-11-24T15:04:00.079Z
8477858 8477858 20251115161328_zCA7F KR001A 2025-11-17T14:12:05.624Z 2025-11-24T15:03:50.536Z
8477014 8477014 20251115151056_cgl2X KR001A 2025-11-17T14:10:12.121Z 2025-11-24T15:03:22.519Z

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