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

5,904 rows where station_code = "KR003M" 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
8766818 8766818 20251212181325_gW0mz KR003M 2025-12-14T14:55:56.435Z 2025-12-14T15:16:09.101Z
8766750 8766750 20251212180152_ZTWN1 KR003M 2025-12-14T14:55:52.042Z 2025-12-14T15:16:09.080Z
8766734 8766734 20251212175538_NlbtU KR003M 2025-12-14T14:55:50.899Z 2025-12-14T15:16:09.074Z
8766450 8766450 20251212170611_8smaf KR003M 2025-12-14T14:53:32.998Z 2025-12-14T15:16:08.926Z
8766325 8766325 20251212164804_hciDs KR003M 2025-12-14T14:53:09.252Z 2025-12-14T15:16:08.812Z
8766242 8766242 20251212163317_kITpO KR003M 2025-12-14T14:52:48.325Z 2025-12-14T15:16:08.785Z
8766141 8766141 20251212161532_LpMia KR003M 2025-12-14T14:52:12.738Z 2025-12-14T15:16:08.756Z
8751113 8751113 20251209202345_Egfwz KR003M 2025-12-13T15:39:15.374Z 2025-12-14T15:43:57.543Z
8750925 8750925 20251209195140_YfEo7 KR003M 2025-12-13T15:38:50.212Z 2025-12-14T15:43:51.716Z
8750789 8750789 20251209193031_uMJrI KR003M 2025-12-13T15:38:43.281Z 2025-12-14T15:43:46.824Z
8750605 8750605 20251209190051_u25qt KR003M 2025-12-13T15:38:35.317Z 2025-12-14T15:43:21.392Z
8750516 8750516 20251209184454_GuJVi KR003M 2025-12-13T15:38:14.446Z 2025-12-14T15:43:16.334Z
8750432 8750432 20251209182403_qdYcu KR003M 2025-12-13T15:38:02.981Z 2025-12-14T15:43:11.681Z
8750421 8750421 20251209182127_4kuVY KR003M 2025-12-13T15:38:02.154Z 2025-12-14T15:43:11.271Z
8750372 8750372 20251209181359_2PIYB KR003M 2025-12-13T15:37:58.443Z 2025-12-14T15:43:10.074Z
8750359 8750359 20251209181152_hitQd KR003M 2025-12-13T15:37:57.647Z 2025-12-14T15:43:09.599Z
8750252 8750252 20251209175111_Cjpib KR003M 2025-12-13T15:37:52.926Z 2025-12-14T15:43:05.398Z
8750242 8750242 20251209174841_tM4Ee KR003M 2025-12-13T15:37:52.357Z 2025-12-14T15:43:05.006Z
8750105 8750105 20251209171247_sYo3p KR003M 2025-12-13T15:37:44.144Z 2025-12-14T15:42:59.296Z
8750015 8750015 20251209164736_LvIpC KR003M 2025-12-13T15:37:09.258Z 2025-12-14T15:42:38.747Z
8749969 8749969 20251209163613_w3eI5 KR003M 2025-12-13T15:37:07.208Z 2025-12-14T15:42:36.976Z
8749844 8749844 20251209160226_3MbUT KR003M 2025-12-13T15:37:00.534Z 2025-12-14T15:42:31.716Z
8749788 8749788 20251209154304_Ieb23 KR003M 2025-12-13T15:36:58.605Z 2025-12-14T15:42:30.431Z
8749556 8749556 20251209150834_kaFV7 KR003M 2025-12-13T15:36:35.112Z 2025-12-14T15:42:23.109Z
8749469 8749469 20251209145655_ejVuj KR003M 2025-12-13T15:36:22.366Z 2025-12-14T15:42:20.712Z
8749449 8749449 20251209145518_cokzX KR003M 2025-12-13T15:36:21.671Z 2025-12-14T15:42:20.188Z
8749405 8749405 20251209144509_TABuV KR003M 2025-12-13T15:36:17.552Z 2025-12-14T15:42:18.556Z
8749290 8749290 20251209143059_dWd8F KR003M 2025-12-13T15:36:11.938Z 2025-12-14T15:42:06.854Z
8749208 8749208 20251209142201_MMJVB KR003M 2025-12-13T15:36:06.786Z 2025-12-14T15:41:46.280Z
8749123 8749123 20251209141036_Fu4Km KR003M 2025-12-13T15:35:50.366Z 2025-12-14T15:41:43.925Z
8748830 8748830 20251209132429_2LvJf KR003M 2025-12-13T15:35:25.655Z 2025-12-14T15:41:29.904Z
8748482 8748482 20251209123518_Xr3vm KR003M 2025-12-13T15:34:28.507Z 2025-12-14T15:40:54.100Z
8748373 8748373 20251209122222_M6wOG KR003M 2025-12-13T15:34:20.805Z 2025-12-14T15:40:49.502Z
8748345 8748345 20251209121855_V23ew KR003M 2025-12-13T15:34:19.277Z 2025-12-14T15:40:48.377Z
8748304 8748304 20251209121433_dIQPs KR003M 2025-12-13T15:34:16.250Z 2025-12-14T15:40:46.423Z
8748282 8748282 20251209121043_YIME5 KR003M 2025-12-13T15:34:11.666Z 2025-12-14T15:40:43.334Z
8748134 8748134 20251209115135_383Sw KR003M 2025-12-13T15:33:42.132Z 2025-12-14T15:40:14.654Z
8747718 8747718 20251209104512_SnyOR KR003M 2025-12-13T15:32:52.415Z 2025-12-14T15:39:23.472Z
8747696 8747696 20251209104241_jB9ex KR003M 2025-12-13T15:32:51.397Z 2025-12-14T15:39:22.424Z
8747517 8747517 20251209094447_7q42t KR003M 2025-12-13T15:31:58.891Z 2025-12-14T15:38:45.539Z
8739031 8739031 20251210132423_r7OFv KR003M 2025-12-13T15:14:41.313Z 2025-12-14T15:27:21.475Z
8705836 8705836 20251208204740_W2CzI KR003M 2025-12-09T14:17:17.298Z 2025-12-14T15:53:46.068Z
8705730 8705730 20251208203030_ME41L KR003M 2025-12-09T14:17:09.906Z 2025-12-14T15:53:43.356Z
8705680 8705680 20251208202025_3nYaD KR003M 2025-12-09T14:17:04.545Z 2025-12-14T15:53:41.491Z
8705671 8705671 20251208202023_mjClS KR003M 2025-12-09T14:17:04.255Z 2025-12-14T15:53:41.348Z
8705623 8705623 20251208201054_KL0ro KR003M 2025-12-09T14:16:51.884Z 2025-12-14T15:53:39.663Z
8705581 8705581 20251208195338_2cYiM KR003M 2025-12-09T14:16:43.092Z 2025-12-14T15:53:30.758Z
8705503 8705503 20251208193647_3qLzD KR003M 2025-12-09T14:16:36.530Z 2025-12-14T15:53:20.328Z
8705418 8705418 20251208190407_jEQRY KR003M 2025-12-09T14:16:31.174Z 2025-12-14T15:52:58.728Z
8705395 8705395 20251208185939_4hTYn KR003M 2025-12-09T14:16:29.875Z 2025-12-14T15:52:58.117Z
8705351 8705351 20251208185336_XkcWk KR003M 2025-12-09T14:16:27.623Z 2025-12-14T15:52:56.546Z
8705249 8705249 20251208182635_hfn3U KR003M 2025-12-09T14:16:20.223Z 2025-12-14T15:52:49.940Z
8705207 8705207 20251208181813_cJkRy KR003M 2025-12-09T14:16:09.798Z 2025-12-14T15:52:47.155Z
8705199 8705199 20251208181701_2Tgzl KR003M 2025-12-09T14:16:08.923Z 2025-12-14T15:52:47.069Z
8705090 8705090 20251208175344_2LSvk KR003M 2025-12-09T14:16:00.103Z 2025-12-14T15:52:44.506Z
8705008 8705008 20251208173744_4S1PB KR003M 2025-12-09T14:15:53.306Z 2025-12-14T15:52:42.317Z
8704991 8704991 20251208173450_E2m3A KR003M 2025-12-09T14:15:52.442Z 2025-12-14T15:52:42.058Z
8704972 8704972 20251208173240_qEwX8 KR003M 2025-12-09T14:15:51.129Z 2025-12-14T15:52:41.707Z
8704928 8704928 20251208172832_CM3z2 KR003M 2025-12-09T14:15:49.242Z 2025-12-14T15:52:40.948Z
8704902 8704902 20251208172145_on1Jw KR003M 2025-12-09T14:15:47.628Z 2025-12-14T15:52:40.178Z
8704822 8704822 20251208170441_3oMY2 KR003M 2025-12-09T14:15:38.492Z 2025-12-14T15:52:38.217Z
8704791 8704791 20251208165812_3rS8z KR003M 2025-12-09T14:15:24.572Z 2025-12-14T15:52:37.648Z
8704727 8704727 20251208164258_IbdLi KR003M 2025-12-09T14:15:16.447Z 2025-12-14T15:52:36.083Z
8704652 8704652 20251208162809_o4Kjg KR003M 2025-12-09T14:15:09.691Z 2025-12-14T15:52:34.089Z
8704553 8704553 20251208160204_yJFTl KR003M 2025-12-09T14:14:48.266Z 2025-12-14T15:52:14.864Z
8704535 8704535 20251208155818_2tYwu KR003M 2025-12-09T14:14:43.956Z 2025-12-14T15:52:14.528Z
8704528 8704528 20251208155406_fwOas KR003M 2025-12-09T14:14:43.708Z 2025-12-14T15:52:14.412Z
8704262 8704262 20251208151428_D2w7R KR003M 2025-12-09T14:14:04.501Z 2025-12-14T15:52:05.942Z
8703857 8703857 20251208142324_Azl03 KR003M 2025-12-09T14:13:03.245Z 2025-12-14T15:51:34.589Z
8703843 8703843 20251208142211_EQmi7 KR003M 2025-12-09T14:13:02.109Z 2025-12-14T15:51:33.110Z
8703591 8703591 20251208135003_3PtzE KR003M 2025-12-09T14:12:22.385Z 2025-12-14T15:51:21.996Z
8702409 8702409 20251208112036_VZHvs KR003M 2025-12-09T14:08:26.889Z 2025-12-14T15:50:16.242Z
8701585 8701585 20251208100159_Z8wSP KR003M 2025-12-09T14:05:30.976Z 2025-12-14T15:49:28.996Z
8701326 8701326 20251208093540_8Z9zk KR003M 2025-12-09T14:04:36.377Z 2025-12-14T15:49:21.151Z
8698391 8698391 20251207191446_SMGct KR003M 2025-12-08T14:15:03.940Z 2025-12-14T15:58:53.420Z
8698336 8698336 20251207184753_mWb3w KR003M 2025-12-08T14:14:43.557Z 2025-12-14T15:58:49.656Z
8695298 8695298 20251207092051_Z1x6g KR003M 2025-12-08T14:03:22.506Z 2025-12-14T15:55:58.225Z
8692227 8692227 20251206093549_PHFSb KR003M 2025-12-07T14:02:18.179Z 2025-12-14T16:01:53.179Z
8689591 8689591 20251205184029_4GbIO KR003M 2025-12-06T14:09:07.756Z 2025-12-14T16:06:19.464Z
8689585 8689585 20251205183849_P61I6 KR003M 2025-12-06T14:09:06.554Z 2025-12-14T16:06:19.200Z
8688943 8688943 20251205132129_c6zuX KR003M 2025-12-06T14:06:25.113Z 2025-12-14T16:06:01.393Z
8688894 8688894 20251205130751_eiWnV KR003M 2025-12-06T14:06:14.609Z 2025-12-14T16:06:00.164Z
8688609 8688609 20251205120931_w9muE KR003M 2025-12-06T14:05:08.852Z 2025-12-14T16:05:47.829Z
8688417 8688417 20251205112712_LiRsM KR003M 2025-12-06T14:04:30.382Z 2025-12-14T16:05:24.313Z
8686943 8686943 20251203211915_VXPj4 KR003M 2025-12-05T14:13:13.677Z 2025-12-11T14:41:55.445Z
8686873 8686873 20251203210700_8WhGG KR003M 2025-12-05T14:13:08.250Z 2025-12-11T14:41:51.851Z
8686849 8686849 20251203210210_xbxBi KR003M 2025-12-05T14:13:01.809Z 2025-12-11T14:41:45.073Z
8686824 8686824 20251203205817_2Y5WR KR003M 2025-12-05T14:12:52.164Z 2025-12-11T14:41:38.996Z
8686812 8686812 20251203205704_lCV5j KR003M 2025-12-05T14:12:50.924Z 2025-12-11T14:41:36.528Z
8686730 8686730 20251203204113_hCNak KR003M 2025-12-05T14:12:40.610Z 2025-12-11T14:41:32.747Z
8686704 8686704 20251203203707_oAftO KR003M 2025-12-05T14:12:38.727Z 2025-12-11T14:41:32.371Z
8686579 8686579 20251203200642_LgeRo KR003M 2025-12-05T14:12:25.824Z 2025-12-11T14:41:29.827Z
8686558 8686558 20251203200123_lbKqg KR003M 2025-12-05T14:12:17.264Z 2025-12-11T14:41:27.640Z
8686376 8686376 20251203193848_lUKaV KR003M 2025-12-05T14:11:49.143Z 2025-12-11T14:41:23.385Z
8686318 8686318 20251203193121_ZKNGy KR003M 2025-12-05T14:11:43.286Z 2025-12-11T14:41:21.651Z
8686200 8686200 20251203190504_iuh0s KR003M 2025-12-05T14:11:13.971Z 2025-12-11T14:41:18.891Z
8686168 8686168 20251203185529_FKMiH KR003M 2025-12-05T14:11:09.859Z 2025-12-11T14:41:17.879Z
8686138 8686138 20251203185005_TwbeI KR003M 2025-12-05T14:11:07.796Z 2025-12-11T14:41:17.432Z
8685424 8685424 20251203121738_dEeun KR003M 2025-12-05T14:08:03.808Z 2025-12-11T14:39:57.155Z
8685418 8685418 20251203121410_1Jyuc KR003M 2025-12-05T14:08:00.854Z 2025-12-11T14:39:56.735Z

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