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

8,037 rows where station_code = "KR003X" 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
9607664 9607664 20260404113516_RTYaQ KR003X 2026-04-05T12:03:22.307Z 2026-04-06T12:16:14.485Z
9603880 9603880 20260402132002_eP64K KR003X 2026-04-03T12:04:56.598Z 2026-04-06T12:22:39.152Z
9603844 9603844 20260402130751_yE2ns KR003X 2026-04-03T12:04:51.611Z 2026-04-06T12:22:37.158Z
9603808 9603808 20260402124745_f0yCx KR003X 2026-04-03T12:04:45.808Z 2026-04-06T12:22:31.766Z
9591704 9591704 20260328193857_PEXK1 KR003X 2026-03-29T12:04:52.640Z 2026-04-06T12:39:40.691Z
9591672 9591672 20260328184806_Sm2W8 KR003X 2026-03-29T12:04:49.525Z 2026-04-06T12:39:38.400Z
9591646 9591646 20260328180941_4kLaW KR003X 2026-03-29T12:04:46.710Z 2026-04-06T12:39:29.679Z
9588132 9588132 20260327194007_n1cDZ KR003X 2026-03-28T12:07:13.626Z 2026-04-05T12:35:10.313Z
9588121 9588121 20260327192716_CTuLz KR003X 2026-03-28T12:07:12.324Z 2026-04-05T12:35:09.432Z
9588106 9588106 20260327191713_dKwNC KR003X 2026-03-28T12:07:11.212Z 2026-04-05T12:35:08.366Z
9583885 9583885 20260326192856_sogYg KR003X 2026-03-27T12:10:01.576Z 2026-04-04T12:41:50.255Z
9583859 9583859 20260326191421_rCAZB KR003X 2026-03-27T12:09:57.145Z 2026-04-04T12:41:46.781Z
9583820 9583820 20260326185148_5bN3N KR003X 2026-03-27T12:09:51.898Z 2026-04-04T12:41:40.081Z
9583794 9583794 20260326181741_lhB02 KR003X 2026-03-27T12:09:48.637Z 2026-04-04T12:41:39.223Z
9583790 9583790 20260326181557_g9pze KR003X 2026-03-27T12:09:48.007Z 2026-04-04T12:41:39.106Z
9583774 9583774 20260326175711_tc1u3 KR003X 2026-03-27T12:09:43.407Z 2026-04-04T12:41:38.280Z
9583734 9583734 20260326173558_xYAnB KR003X 2026-03-27T12:09:37.410Z 2026-04-04T12:41:34.302Z
9583545 9583545 20260326155725_IXvn6 KR003X 2026-03-27T12:09:05.823Z 2026-04-04T12:41:23.822Z
9583488 9583488 20260326152852_m605L KR003X 2026-03-27T12:08:58.142Z 2026-04-04T12:41:20.886Z
9583466 9583466 20260326151059_wDSkI KR003X 2026-03-27T12:08:53.114Z 2026-04-04T12:41:13.543Z
9579103 9579103 20260325202824_PEosg KR003X 2026-03-26T12:09:19.217Z 2026-04-03T12:39:18.575Z
9578848 9578848 20260325151311_mzfW4 KR003X 2026-03-26T12:08:40.828Z 2026-04-03T12:38:35.924Z
9578758 9578758 20260325141643_B23os KR003X 2026-03-26T12:08:25.625Z 2026-04-03T12:38:30.849Z
9575173 9575173 20260323191034_zDDN0 KR003X 2026-03-25T12:20:27.034Z 2026-03-31T12:28:50.296Z
9575022 9575022 20260323181944_w93D8 KR003X 2026-03-25T12:20:05.395Z 2026-03-31T12:28:46.640Z
9574808 9574808 20260323172212_B3s2X KR003X 2026-03-25T12:19:43.175Z 2026-03-31T12:28:42.437Z
9574632 9574632 20260324192704_stOW1 KR003X 2026-03-25T12:11:10.866Z 2026-04-02T12:37:06.864Z
9570297 9570297 20260322202408_Vgo0b KR003X 2026-03-24T12:22:56.883Z 2026-03-30T12:30:39.095Z
9570220 9570220 20260322195737_2fE1l KR003X 2026-03-24T12:22:49.495Z 2026-03-30T12:30:37.290Z
9570208 9570208 20260322195059_dTSFE KR003X 2026-03-24T12:22:48.292Z 2026-03-30T12:30:33.598Z
9570131 9570131 20260322192028_NXPy6 KR003X 2026-03-24T12:22:37.662Z 2026-03-30T12:30:28.193Z
9570076 9570076 20260322190730_2jz8X KR003X 2026-03-24T12:22:33.165Z 2026-03-30T12:30:27.428Z
9569998 9569998 20260322184850_H1ZeT KR003X 2026-03-24T12:22:26.744Z 2026-03-30T12:30:26.039Z
9569653 9569653 20260322163741_3g50z KR003X 2026-03-24T12:21:38.121Z 2026-03-30T12:30:13.255Z
9569560 9569560 20260322161243_WTWCw KR003X 2026-03-24T12:21:22.376Z 2026-03-30T12:30:08.828Z
9569514 9569514 20260322160014_oF19Y KR003X 2026-03-24T12:21:15.904Z 2026-03-30T12:30:06.524Z
9569417 9569417 20260322152653_2tjEg KR003X 2026-03-24T12:20:54.527Z 2026-03-30T12:29:53.488Z
9569377 9569377 20260322151402_jAPQx KR003X 2026-03-24T12:20:48.298Z 2026-03-30T12:29:51.436Z
9569311 9569311 20260322145018_Hvw5p KR003X 2026-03-24T12:20:30.779Z 2026-03-30T12:29:46.570Z
9569255 9569255 20260322142410_z3iEe KR003X 2026-03-24T12:20:18.713Z 2026-03-30T12:29:41.563Z
9569232 9569232 20260322141759_TOwD5 KR003X 2026-03-24T12:20:14.807Z 2026-03-30T12:29:40.137Z
9568507 9568507 20260323165059_Q9RAF KR003X 2026-03-24T12:15:12.456Z 2026-03-31T12:28:30.021Z
9568312 9568312 20260323163037_LJGF8 KR003X 2026-03-24T12:14:51.752Z 2026-03-31T12:28:27.165Z
9567714 9567714 20260323154246_qeJcM KR003X 2026-03-24T12:14:00.294Z 2026-03-31T12:28:17.741Z
9566296 9566296 20260323132342_9j3ti KR003X 2026-03-24T12:11:36.298Z 2026-03-31T12:27:48.418Z
9564949 9564949 20260323113143_NQqCo KR003X 2026-03-24T12:09:06.659Z 2026-03-31T12:27:19.798Z
9551648 9551648 20260320203915_knQFD KR003X 2026-03-22T12:26:53.403Z 2026-03-28T12:36:59.350Z
9551499 9551499 20260320195724_lnOMZ KR003X 2026-03-22T12:26:43.800Z 2026-03-28T12:36:56.472Z
9551457 9551457 20260320195231_rXF9U KR003X 2026-03-22T12:26:41.626Z 2026-03-28T12:36:53.655Z
9551386 9551386 20260320193956_VCTpR KR003X 2026-03-22T12:26:37.155Z 2026-03-28T12:36:49.025Z
9551352 9551352 20260320192933_3nxf5 KR003X 2026-03-22T12:26:28.147Z 2026-03-28T12:36:46.898Z
9551346 9551346 20260320192702_23GyN KR003X 2026-03-22T12:26:27.530Z 2026-03-28T12:36:46.197Z
9551342 9551342 20260320192633_SR3gc KR003X 2026-03-22T12:26:27.282Z 2026-03-28T12:36:46.101Z
9551327 9551327 20260320192122_YQM4O KR003X 2026-03-22T12:26:25.885Z 2026-03-28T12:36:44.415Z
9551321 9551321 20260320191737_yUFSB KR003X 2026-03-22T12:26:25.367Z 2026-03-28T12:36:44.056Z
9551148 9551148 20260320183521_owaUh KR003X 2026-03-22T12:26:13.053Z 2026-03-28T12:36:40.308Z
9551138 9551138 20260320183406_UnP30 KR003X 2026-03-22T12:26:12.687Z 2026-03-28T12:36:40.293Z
9551073 9551073 20260320180816_C2xcC KR003X 2026-03-22T12:26:08.651Z 2026-03-28T12:36:39.513Z
9550882 9550882 20260320171954_fS2A2 KR003X 2026-03-22T12:25:49.080Z 2026-03-28T12:36:37.206Z
9550592 9550592 20260320165321_pxFkL KR003X 2026-03-22T12:25:31.593Z 2026-03-28T12:36:32.986Z
9550277 9550277 20260320162639_LFhfO KR003X 2026-03-22T12:25:05.908Z 2026-03-28T12:36:29.079Z
9550077 9550077 20260320160642_rDx7n KR003X 2026-03-22T12:24:54.154Z 2026-03-28T12:36:26.902Z
9549937 9549937 20260320155532_rlm61 KR003X 2026-03-22T12:24:38.046Z 2026-03-28T12:36:24.257Z
9549343 9549343 20260320144853_G3LQU KR003X 2026-03-22T12:23:53.264Z 2026-03-28T12:36:01.596Z
9547773 9547773 20260321135723_bf02R KR003X 2026-03-22T12:14:18.042Z 2026-03-29T12:20:21.160Z
9547685 9547685 20260321135114_qwvpa KR003X 2026-03-22T12:14:05.981Z 2026-03-29T12:20:11.135Z
9547242 9547242 20260321130720_egMne KR003X 2026-03-22T12:13:16.582Z 2026-03-22T12:27:38.422Z
9547214 9547214 20260321130540_ClYLx KR003X 2026-03-22T12:13:12.632Z 2026-03-29T12:20:07.914Z
9547104 9547104 20260321125227_MtY8L KR003X 2026-03-22T12:13:00.471Z 2026-03-29T12:20:06.786Z
9546735 9546735 20260321122249_QfjPa KR003X 2026-03-22T12:12:18.322Z 2026-03-29T12:20:03.644Z
9546299 9546299 20260321115014_s07wU KR003X 2026-03-22T12:11:27.091Z 2026-03-29T12:19:49.187Z
9541336 9541336 20260319201734_xlVpo KR003X 2026-03-21T12:28:50.099Z 2026-03-27T12:42:36.563Z
9541151 9541151 20260319194201_DmKfS KR003X 2026-03-21T12:28:39.529Z 2026-03-27T12:42:34.574Z
9540969 9540969 20260319184434_OdeYy KR003X 2026-03-21T12:28:20.065Z 2026-03-27T12:42:32.514Z
9540907 9540907 20260319183033_GIkrf KR003X 2026-03-21T12:28:16.545Z 2026-03-27T12:42:32.020Z
9540829 9540829 20260319181340_680z9 KR003X 2026-03-21T12:28:11.125Z 2026-03-27T12:42:31.261Z
9540810 9540810 20260319180814_zTG3o KR003X 2026-03-21T12:28:10.281Z 2026-03-27T12:42:31.143Z
9540794 9540794 20260319180009_JvXGj KR003X 2026-03-21T12:28:09.401Z 2026-03-27T12:42:31.010Z
9540783 9540783 20260319175515_1NpeX KR003X 2026-03-21T12:28:08.707Z 2026-03-27T12:42:30.879Z
9540715 9540715 20260319173010_MIMHK KR003X 2026-03-21T12:27:56.919Z 2026-03-27T12:42:30.188Z
9540697 9540697 20260319172319_MIAZp KR003X 2026-03-21T12:27:53.064Z 2026-03-27T12:42:29.586Z
9540656 9540656 20260319171010_IOKpy KR003X 2026-03-21T12:27:47.035Z 2026-03-27T12:42:28.849Z
9540555 9540555 20260319162921_wPTkN KR003X 2026-03-21T12:27:17.165Z 2026-03-27T12:42:25.274Z
9540385 9540385 20260319152820_QlaMj KR003X 2026-03-21T12:26:55.789Z 2026-03-27T12:42:20.809Z
9540322 9540322 20260319151119_6Tq3A KR003X 2026-03-21T12:26:49.883Z 2026-03-27T12:42:19.461Z
9540214 9540214 20260319143711_BRCMJ KR003X 2026-03-21T12:26:30.057Z 2026-03-27T12:42:04.008Z
9540148 9540148 20260319133624_krry2 KR003X 2026-03-21T12:26:17.819Z 2026-03-27T12:42:01.040Z
9540140 9540140 20260319133221_gZwuM KR003X 2026-03-21T12:26:12.420Z 2026-03-27T12:42:00.781Z
9540070 9540070 20260319124112_0i4av KR003X 2026-03-21T12:26:00.679Z 2026-03-27T12:41:57.323Z
9539948 9539948 20260319111818_kfCzU KR003X 2026-03-21T12:25:23.322Z 2026-03-27T12:41:48.371Z
9539921 9539921 20260319110344_fI2yx KR003X 2026-03-21T12:25:18.167Z 2026-03-27T12:41:46.822Z
9539035 9539035 20260320140443_NVPk2 KR003X 2026-03-21T12:18:51.779Z 2026-03-28T12:35:56.244Z
9530370 9530370 20260318204211_MQWxs KR003X 2026-03-20T12:24:19.789Z 2026-03-26T12:39:11.535Z
9530200 9530200 20260318202356_wVOWz KR003X 2026-03-20T12:24:11.556Z 2026-03-26T12:39:10.254Z
9529583 9529583 20260318185713_nWZkb KR003X 2026-03-20T12:23:19.898Z 2026-03-26T12:39:04.608Z
9529567 9529567 20260318185401_4nXKS KR003X 2026-03-20T12:23:18.889Z 2026-03-26T12:39:04.356Z
9529329 9529329 20260318174634_1eXD7 KR003X 2026-03-20T12:23:03.999Z 2026-03-26T12:38:58.000Z
9529296 9529296 20260318173913_xqR6F KR003X 2026-03-20T12:23:02.125Z 2026-03-26T12:38:55.241Z
9529140 9529140 20260318172002_TUYgZ KR003X 2026-03-20T12:22:55.293Z 2026-03-26T12:38:47.464Z
9528995 9528995 20260318170457_lxAHs KR003X 2026-03-20T12:22:40.880Z 2026-03-26T12:38:41.512Z

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