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,233 rows where station_code = "KR003C" 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
8663086 8663086 20251130200659_rDLVK KR003C 2025-12-02T14:17:25.059Z 2025-12-05T14:33:56.710Z
8662474 8662474 20251130185556_4gnMI KR003C 2025-12-02T14:15:41.454Z 2025-12-05T14:33:25.562Z
8662383 8662383 20251130184113_T6rB3 KR003C 2025-12-02T14:15:18.698Z 2025-12-05T14:33:19.746Z
8661714 8661714 20251130165707_3c94n KR003C 2025-12-02T14:12:42.567Z 2025-12-05T14:32:32.508Z
8661689 8661689 20251130165429_3OLB6 KR003C 2025-12-02T14:12:37.132Z 2025-12-05T14:32:31.219Z
8661567 8661567 20251130155945_Qu2Z4 KR003C 2025-12-02T14:12:02.810Z 2025-12-05T14:32:15.150Z
8658186 8658186 20251128134120_TPf8s KR003C 2025-12-01T14:40:34.707Z 2025-12-05T14:47:54.841Z
8650519 8650519 20251129203427_nb2Hp KR003C 2025-12-01T14:16:22.570Z 2025-12-05T14:41:09.474Z
8650498 8650498 20251129203237_xEaDY KR003C 2025-12-01T14:16:19.545Z 2025-12-05T14:41:08.935Z
8650475 8650475 20251129202632_VMzAW KR003C 2025-12-01T14:16:17.335Z 2025-12-05T14:41:08.640Z
8650443 8650443 20251129202102_qwJas KR003C 2025-12-01T14:16:12.778Z 2025-12-05T14:41:07.696Z
8650378 8650378 20251129200428_CDenH KR003C 2025-12-01T14:15:56.250Z 2025-12-05T14:41:05.214Z
8648952 8648952 20251129152423_LDLoC KR003C 2025-12-01T14:10:02.174Z 2025-12-05T14:39:24.866Z
8648901 8648901 20251129145640_HcRuD KR003C 2025-12-01T14:09:22.955Z 2025-12-05T14:39:20.406Z
8648713 8648713 20251129095838_12eRg KR003C 2025-12-01T14:01:53.489Z 2025-12-05T14:37:46.571Z
8648707 8648707 20251129095641_JF53I KR003C 2025-12-01T14:01:43.546Z 2025-12-05T14:37:46.087Z
8645089 8645089 20251128203458_yUTWO KR003C 2025-11-30T14:23:02.390Z 2025-12-05T14:50:31.573Z
8645010 8645010 20251128202239_OB33k KR003C 2025-11-30T14:22:57.134Z 2025-12-05T14:50:30.472Z
8644911 8644911 20251128201406_DhCRC KR003C 2025-11-30T14:22:51.563Z 2025-12-05T14:50:29.110Z
8644903 8644903 20251128201359_on3kA KR003C 2025-11-30T14:22:51.397Z 2025-12-05T14:50:29.059Z
8644820 8644820 20251128200201_9uUj3 KR003C 2025-11-30T14:22:44.884Z 2025-12-05T14:50:27.417Z
8644814 8644814 20251128200000_Xazcq KR003C 2025-11-30T14:22:44.422Z 2025-12-05T14:50:27.332Z
8644769 8644769 20251128195610_NmZXA KR003C 2025-11-30T14:22:23.772Z 2025-12-05T14:50:26.813Z
8644592 8644592 20251128193540_mdCox KR003C 2025-11-30T14:22:07.923Z 2025-12-05T14:50:24.195Z
8644523 8644523 20251128193036_UPhc5 KR003C 2025-11-30T14:22:04.201Z 2025-12-05T14:50:23.129Z
8644505 8644505 20251128192855_WcX8i KR003C 2025-11-30T14:22:02.848Z 2025-12-05T14:50:22.874Z
8644440 8644440 20251128192649_9CbGG KR003C 2025-11-30T14:22:00.008Z 2025-12-05T14:50:22.207Z
8644161 8644161 20251128190402_XP8bn KR003C 2025-11-30T14:21:25.575Z 2025-12-05T14:50:17.458Z
8644112 8644112 20251128185903_oInmK KR003C 2025-11-30T14:21:21.318Z 2025-12-05T14:50:16.424Z
8643866 8643866 20251128183256_rBtp0 KR003C 2025-11-30T14:20:45.619Z 2025-12-05T14:49:51.857Z
8643761 8643761 20251128182338_QjCYt KR003C 2025-11-30T14:20:38.930Z 2025-12-05T14:49:44.035Z
8643723 8643723 20251128181901_rS3d2 KR003C 2025-11-30T14:20:36.749Z 2025-12-05T14:49:42.538Z
8643398 8643398 20251128174925_VT3G2 KR003C 2025-11-30T14:19:58.189Z 2025-12-05T14:49:16.982Z
8643354 8643354 20251128174437_t23Wp KR003C 2025-11-30T14:19:55.935Z 2025-12-05T14:49:16.224Z
8643267 8643267 20251128173954_pP3h7 KR003C 2025-11-30T14:19:48.971Z 2025-12-05T14:49:14.704Z
8643147 8643147 20251128172816_wv96S KR003C 2025-11-30T14:19:23.671Z 2025-12-05T14:49:10.447Z
8642746 8642746 20251128164304_clIaU KR003C 2025-11-30T14:18:33.980Z 2025-12-05T14:49:04.072Z
8642546 8642546 20251128161914_RV5xu KR003C 2025-11-30T14:18:10.957Z 2025-12-05T14:49:01.271Z
8642273 8642273 20251128154610_y6qaq KR003C 2025-11-30T14:17:43.171Z 2025-12-05T14:48:57.768Z
8641076 8641076 20251128134120_gV8oG KR003C 2025-11-30T14:14:05.074Z 2025-11-30T14:30:17.978Z
8640839 8640839 20251128115949_7zvMk KR003C 2025-11-30T14:11:09.932Z 2025-12-05T14:47:11.320Z
8640794 8640794 20251128112458_RP6Lc KR003C 2025-11-30T14:10:47.588Z 2025-12-05T14:47:04.101Z
8640776 8640776 20251128110727_9qLrp KR003C 2025-11-30T14:10:37.572Z 2025-12-05T14:47:00.849Z
8640772 8640772 20251128110727_1g7mm KR003C 2025-11-30T14:10:37.326Z 2025-12-05T14:47:00.792Z
8640735 8640735 20251128100240_0OLj3 KR003C 2025-11-30T14:10:01.771Z 2025-12-05T14:46:24.849Z
8632058 8632058 20251127202755_pPfDV KR003C 2025-11-29T14:16:46.396Z 2025-12-05T14:56:15.338Z
8631997 8631997 20251127201905_Exscz KR003C 2025-11-29T14:16:39.183Z 2025-12-05T14:56:14.254Z
8631804 8631804 20251127200221_v9B3c KR003C 2025-11-29T14:16:25.073Z 2025-12-05T14:56:11.850Z
8631544 8631544 20251127192241_JYZSO KR003C 2025-11-29T14:15:43.555Z 2025-12-05T14:56:08.292Z
8631389 8631389 20251127185931_PME3C KR003C 2025-11-29T14:15:13.420Z 2025-12-05T14:56:05.948Z
8631301 8631301 20251127184554_qU3es KR003C 2025-11-29T14:15:04.906Z 2025-12-05T14:56:04.922Z
8631258 8631258 20251127184141_JoSqn KR003C 2025-11-29T14:15:00.734Z 2025-12-05T14:56:04.449Z
8631248 8631248 20251127183954_kegS1 KR003C 2025-11-29T14:14:59.698Z 2025-12-05T14:56:04.303Z
8631215 8631215 20251127183634_lutEW KR003C 2025-11-29T14:14:56.896Z 2025-12-05T14:56:03.775Z
8631196 8631196 20251127183354_7nR5B KR003C 2025-11-29T14:14:54.662Z 2025-12-05T14:56:03.437Z
8631156 8631156 20251127182519_FnfxT KR003C 2025-11-29T14:14:42.734Z 2025-12-05T14:56:02.719Z
8631042 8631042 20251127180733_240bk KR003C 2025-11-29T14:14:27.642Z 2025-12-05T14:56:01.020Z
8630975 8630975 20251127175753_YZ3vT KR003C 2025-11-29T14:14:14.415Z 2025-12-05T14:55:59.988Z
8630963 8630963 20251127175600_8Kg74 KR003C 2025-11-29T14:14:13.323Z 2025-12-05T14:55:59.738Z
8630844 8630844 20251127173422_hN8Q9 KR003C 2025-11-29T14:13:51.412Z 2025-12-05T14:55:57.802Z
8630768 8630768 20251127171905_n8XfO KR003C 2025-11-29T14:13:41.960Z 2025-12-05T14:55:52.845Z
8630505 8630505 20251127162917_xbQrF KR003C 2025-11-29T14:12:49.384Z 2025-12-05T14:55:32.066Z
8630429 8630429 20251127161128_IAgXY KR003C 2025-11-29T14:12:39.612Z 2025-12-05T14:55:23.474Z
8630303 8630303 20251127154223_sPa3r KR003C 2025-11-29T14:12:15.227Z 2025-12-05T14:55:05.510Z
8605726 8605726 20251125162054_iJ8nn KR003C 2025-11-27T14:07:27.341Z 2025-12-04T15:05:37.763Z
8595490 8595490 20251124162426_lXbSQ KR003C 2025-11-26T14:11:15.989Z 2025-12-02T15:05:59.399Z
8578567 8578567 20251122205303_6u5qW KR003C 2025-11-24T14:12:07.282Z 2025-12-01T15:19:48.408Z
8578508 8578508 20251122204543_ia6kE KR003C 2025-11-24T14:11:58.966Z 2025-12-01T15:19:41.785Z
8578417 8578417 20251122203512_8qJax KR003C 2025-11-24T14:11:42.186Z 2025-12-01T15:19:35.091Z
8577016 8577016 20251122170321_Ur5vc KR003C 2025-11-24T14:07:20.819Z 2025-12-01T15:18:42.600Z
8576950 8576950 20251122165023_t4EvQ KR003C 2025-11-24T14:07:04.715Z 2025-12-01T15:18:41.670Z
8576890 8576890 20251122163311_jriRs KR003C 2025-11-24T14:06:55.418Z 2025-12-01T15:18:41.058Z
8576834 8576834 20251122162241_Cy68E KR003C 2025-11-24T14:06:49.998Z 2025-12-01T15:18:40.630Z
8576779 8576779 20251122161137_C5fj3 KR003C 2025-11-24T14:06:44.134Z 2025-12-01T15:18:39.997Z
8576467 8576467 20251122151438_GSVmL KR003C 2025-11-24T14:05:58.235Z 2025-12-01T15:18:37.153Z
8576073 8576073 20251122140828_YWDxC KR003C 2025-11-24T14:04:47.267Z 2025-12-01T15:18:32.869Z
8575694 8575694 20251122131611_VX129 KR003C 2025-11-24T14:03:55.705Z 2025-12-01T15:18:29.986Z
8575558 8575558 20251122125453_WvDgQ KR003C 2025-11-24T14:03:33.097Z 2025-12-01T15:18:27.163Z
8575420 8575420 20251122123200_Tw3Ec KR003C 2025-11-24T14:03:10.056Z 2025-12-01T15:18:22.409Z
8574618 8574618 20251122101315_B8uXB KR003C 2025-11-24T14:00:18.973Z 2025-12-01T15:17:16.767Z
8565671 8565671 20251121205844_iw5UC KR003C 2025-11-23T14:13:51.676Z 2025-11-30T15:05:07.332Z
8565472 8565472 20251121203354_QbSeT KR003C 2025-11-23T14:13:22.333Z 2025-11-30T15:05:03.466Z
8565268 8565268 20251121200929_Nx1en KR003C 2025-11-23T14:12:52.888Z 2025-11-30T15:04:53.419Z
8565161 8565161 20251121195710_DKchI KR003C 2025-11-23T14:12:40.106Z 2025-11-30T15:04:43.793Z
8565133 8565133 20251121195448_2yHfl KR003C 2025-11-23T14:12:37.065Z 2025-11-30T15:04:43.323Z
8565043 8565043 20251121194111_0YTzf KR003C 2025-11-23T14:12:20.226Z 2025-11-30T15:04:39.589Z
8564492 8564492 20251121183517_J2VLG KR003C 2025-11-23T14:10:58.706Z 2025-11-30T15:04:20.904Z
8564218 8564218 20251121180721_laQzF KR003C 2025-11-23T14:10:24.542Z 2025-11-30T15:04:10.342Z
8564203 8564203 20251121180546_8oGoH KR003C 2025-11-23T14:10:22.259Z 2025-11-30T15:04:10.152Z
8563898 8563898 20251121173826_fLMI4 KR003C 2025-11-23T14:09:34.518Z 2025-11-30T15:03:53.833Z
8563688 8563688 20251121170804_C0AKk KR003C 2025-11-23T14:08:59.027Z 2025-11-30T15:03:43.642Z
8563683 8563683 20251121170620_vpegL KR003C 2025-11-23T14:08:57.843Z 2025-11-30T15:03:43.586Z
8563586 8563586 20251121164851_Iviha KR003C 2025-11-23T14:08:45.856Z 2025-11-30T15:03:41.472Z
8563410 8563410 20251121160952_3BfqS KR003C 2025-11-23T14:08:10.626Z 2025-11-30T15:03:39.394Z
8563212 8563212 20251121152953_Kh6yR KR003C 2025-11-23T14:07:37.698Z 2025-11-30T15:03:36.483Z
8562990 8562990 20251121150633_22vsj KR003C 2025-11-23T14:07:01.991Z 2025-11-30T15:03:34.546Z
8562895 8562895 20251121145735_QMTDL KR003C 2025-11-23T14:06:51.127Z 2025-11-30T15:03:33.765Z
8561931 8561931 20251121131535_KUauL KR003C 2025-11-23T14:04:10.298Z 2025-11-30T15:03:14.578Z
8561809 8561809 20251121130501_AEqiz KR003C 2025-11-23T14:03:47.431Z 2025-11-30T15:03:12.719Z
8560948 8560948 20251121112214_HQ3LD KR003C 2025-11-23T14:01:22.817Z 2025-11-30T15:02:41.560Z

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