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

4,752 rows where station_code = "KR003U" 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
9613074 9613074 20260406191333_NHR8B KR003U 2026-04-07T12:03:44.237Z 2026-04-07T12:03:44.237Z
9613067 9613067 20260406190746_tPNz9 KR003U 2026-04-07T12:03:43.189Z 2026-04-07T12:03:43.189Z
9613044 9613044 20260406185535_fp6p2 KR003U 2026-04-07T12:03:38.814Z 2026-04-07T12:03:38.814Z
9612979 9612979 20260406181445_agQU2 KR003U 2026-04-07T12:03:25.866Z 2026-04-07T12:03:25.866Z
9612968 9612968 20260406180722_8Omqp KR003U 2026-04-07T12:03:19.653Z 2026-04-07T12:03:19.653Z
9612880 9612880 20260406173641_EJLBt KR003U 2026-04-07T12:03:07.815Z 2026-04-07T12:03:07.815Z
9612856 9612856 20260406172558_Rq2zb KR003U 2026-04-07T12:03:04.427Z 2026-04-07T12:03:04.427Z
9612833 9612833 20260406170208_dsK12 KR003U 2026-04-07T12:03:00.545Z 2026-04-07T12:03:00.545Z
9612808 9612808 20260406164130_266Oi KR003U 2026-04-07T12:02:53.335Z 2026-04-07T12:02:53.335Z
9612798 9612798 20260406163545_lUmBl KR003U 2026-04-07T12:02:50.569Z 2026-04-07T12:02:50.569Z
9612781 9612781 20260406162514_anssC KR003U 2026-04-07T12:02:44.209Z 2026-04-07T12:02:44.209Z
9612758 9612758 20260406155906_6LG4S KR003U 2026-04-07T12:02:41.255Z 2026-04-07T12:02:41.255Z
9612726 9612726 20260406154640_Mx5h3 KR003U 2026-04-07T12:02:38.366Z 2026-04-07T12:02:38.366Z
9612623 9612623 20260406143424_3qUYU KR003U 2026-04-07T12:02:18.787Z 2026-04-07T12:02:18.787Z
9612600 9612600 20260406142346_4ZcTH KR003U 2026-04-07T12:02:13.703Z 2026-04-07T12:02:13.703Z
9612567 9612567 20260406140936_vgCvB KR003U 2026-04-07T12:02:09.240Z 2026-04-07T12:02:09.240Z
9612500 9612500 20260406131043_Opn2a KR003U 2026-04-07T12:02:00.028Z 2026-04-07T12:02:00.028Z
9612434 9612434 20260406113203_Q2eHL KR003U 2026-04-07T12:01:47.456Z 2026-04-07T12:01:47.456Z
9607754 9607754 20260404125327_9KdbJ KR003U 2026-04-05T12:03:52.349Z 2026-04-07T12:14:57.101Z
9607646 9607646 20260404112858_12Byc KR003U 2026-04-05T12:03:19.802Z 2026-04-07T12:14:47.358Z
9590988 9590988 20260328121201_1H3LQ KR003U 2026-03-29T12:03:35.531Z 2026-04-06T12:38:45.330Z
9588130 9588130 20260327193243_TWacd KR003U 2026-03-28T12:07:13.266Z 2026-04-05T12:35:09.789Z
9588092 9588092 20260327184036_x6URY KR003U 2026-03-28T12:07:09.212Z 2026-04-05T12:35:07.647Z
9570256 9570256 20260322201547_IoU74 KR003U 2026-03-24T12:22:52.805Z 2026-03-30T12:30:38.074Z
9570070 9570070 20260322190547_eKUay KR003U 2026-03-24T12:22:32.624Z 2026-03-30T12:30:27.312Z
9569861 9569861 20260322181047_mQ2Em KR003U 2026-03-24T12:22:15.758Z 2026-03-30T12:30:22.424Z
9569852 9569852 20260322180339_EYe4e KR003U 2026-03-24T12:22:15.024Z 2026-03-30T12:30:22.287Z
9569513 9569513 20260322160014_oF19Y KR003U 2026-03-24T12:21:15.904Z 2026-03-30T12:30:06.524Z
9569455 9569455 20260322154124_X9fwD KR003U 2026-03-24T12:21:01.811Z 2026-03-30T12:30:03.580Z
9568683 9568683 20260323171144_wRfI5 KR003U 2026-03-24T12:15:33.248Z 2026-03-24T12:24:25.506Z
9568364 9568364 20260323163457_vUZHq KR003U 2026-03-24T12:14:57.520Z 2026-03-31T12:28:28.231Z
9567928 9567928 20260323160043_4duuU KR003U 2026-03-24T12:14:17.816Z 2026-03-31T12:28:20.764Z
9567905 9567905 20260323155825_7tyWl KR003U 2026-03-24T12:14:16.559Z 2026-03-31T12:28:20.368Z
9567794 9567794 20260323154938_PRjhK KR003U 2026-03-24T12:14:09.015Z 2026-03-31T12:28:18.894Z
9567749 9567749 20260323154558_qX3IO KR003U 2026-03-24T12:14:06.082Z 2026-03-31T12:28:18.264Z
9551596 9551596 20260320202735_rDfQt KR003U 2026-03-22T12:26:50.392Z 2026-03-28T12:36:58.515Z
9551081 9551081 20260320181120_dDbaE KR003U 2026-03-22T12:26:09.301Z 2026-03-28T12:36:39.741Z
9551009 9551009 20260320174358_ZflZp KR003U 2026-03-22T12:26:04.436Z 2026-03-28T12:36:38.892Z
9547367 9547367 20260321132056_LZtUK KR003U 2026-03-22T12:13:30.858Z 2026-03-29T12:20:09.024Z
9545804 9545804 20260321110901_tHnM1 KR003U 2026-03-22T12:10:18.179Z 2026-03-29T12:19:44.593Z
9541352 9541352 20260319202025_JcMMb KR003U 2026-03-21T12:28:51.133Z 2026-03-27T12:42:36.770Z
9541200 9541200 20260319195944_OzCzt KR003U 2026-03-21T12:28:43.290Z 2026-03-27T12:42:35.321Z
9540950 9540950 20260319183938_f40SF KR003U 2026-03-21T12:28:18.668Z 2026-03-27T12:42:32.340Z
9540914 9540914 20260319183142_IAZKi KR003U 2026-03-21T12:28:16.812Z 2026-03-27T12:42:32.033Z
9540898 9540898 20260319182953_RyXMn KR003U 2026-03-21T12:28:16.346Z 2026-03-27T12:42:31.966Z
9540875 9540875 20260319182328_fDOHs KR003U 2026-03-21T12:28:14.982Z 2026-03-27T12:42:31.757Z
9540828 9540828 20260319181340_680z9 KR003U 2026-03-21T12:28:11.125Z 2026-03-27T12:42:31.261Z
9540815 9540815 20260319180945_ZdETM KR003U 2026-03-21T12:28:10.496Z 2026-03-27T12:42:31.174Z
9540603 9540603 20260319165411_1KzKa KR003U 2026-03-21T12:27:36.703Z 2026-03-27T12:42:27.070Z
9540571 9540571 20260319163641_Nx2lT KR003U 2026-03-21T12:27:28.574Z 2026-03-27T12:42:25.842Z
9540384 9540384 20260319152820_QlaMj KR003U 2026-03-21T12:26:55.789Z 2026-03-27T12:42:20.809Z
9540266 9540266 20260319145131_Ursm2 KR003U 2026-03-21T12:26:34.841Z 2026-03-27T12:42:05.162Z
9538653 9538653 20260320133000_GYofT KR003U 2026-03-21T12:18:06.375Z 2026-03-28T12:35:51.221Z
9538231 9538231 20260320124259_Rb779 KR003U 2026-03-21T12:17:21.640Z 2026-03-28T12:35:36.138Z
9537844 9537844 20260320120654_rghqQ KR003U 2026-03-21T12:16:34.124Z 2026-03-28T12:35:29.898Z
9537548 9537548 20260320114533_DZFX3 KR003U 2026-03-21T12:15:59.644Z 2026-03-28T12:35:27.010Z
9529904 9529904 20260318193925_4xs5p KR003U 2026-03-20T12:23:48.049Z 2026-03-26T12:39:07.315Z
9529670 9529670 20260318190659_wUV4r KR003U 2026-03-20T12:23:31.898Z 2026-03-26T12:39:05.368Z
9529636 9529636 20260318190005_f9lM6 KR003U 2026-03-20T12:23:29.900Z 2026-03-26T12:39:05.006Z
9529606 9529606 20260318185836_y2EJF KR003U 2026-03-20T12:23:20.841Z 2026-03-26T12:39:04.771Z
9529507 9529507 20260318183931_CR6LE KR003U 2026-03-20T12:23:14.582Z 2026-03-26T12:39:03.540Z
9506743 9506743 20260316191434_2KTRg KR003U 2026-03-18T12:19:17.453Z 2026-03-24T12:41:34.487Z
9506638 9506638 20260316184243_57tu2 KR003U 2026-03-18T12:19:07.797Z 2026-03-24T12:41:33.892Z
9504885 9504885 20260317124058_YxbOW KR003U 2026-03-18T12:09:07.494Z 2026-03-25T12:42:25.287Z
9499860 9499860 20260316165821_oSd6z KR003U 2026-03-17T12:16:16.648Z 2026-03-24T12:41:31.672Z
9499803 9499803 20260316164950_0bbsD KR003U 2026-03-17T12:16:10.112Z 2026-03-24T12:41:31.392Z
9499799 9499799 20260316164934_NOu13 KR003U 2026-03-17T12:16:09.751Z 2026-03-17T12:25:25.805Z
9499671 9499671 20260316164041_rERDC KR003U 2026-03-17T12:15:59.997Z 2026-03-24T12:41:31.065Z
9498388 9498388 20260316150046_kwyE3 KR003U 2026-03-17T12:13:50.558Z 2026-03-24T12:41:25.933Z
9497752 9497752 20260316140605_Spes2 KR003U 2026-03-17T12:12:34.514Z 2026-03-24T12:41:24.202Z
9497710 9497710 20260316135946_JdCxL KR003U 2026-03-17T12:12:29.626Z 2026-03-24T12:41:23.932Z
9497239 9497239 20260316130657_bF6De KR003U 2026-03-17T12:11:33.828Z 2026-03-17T12:25:25.219Z
9491173 9491173 20260315161349_ikuHY KR003U 2026-03-16T12:20:26.879Z 2026-03-23T12:22:38.738Z
9491168 9491168 20260315161249_AIEw8 KR003U 2026-03-16T12:20:26.494Z 2026-03-23T12:22:38.734Z
9490902 9490902 20260315154417_lJJ52 KR003U 2026-03-16T12:19:58.655Z 2026-03-23T12:22:38.042Z
9488329 9488329 20260315114314_IP8v1 KR003U 2026-03-16T12:14:54.747Z 2026-03-23T12:22:27.341Z
9479714 9479714 20260314121204_lSD6p KR003U 2026-03-15T12:14:23.366Z 2026-03-22T12:42:38.998Z
9473186 9473186 20260313160513_2JtWN KR003U 2026-03-14T12:14:36.087Z 2026-03-21T12:49:54.749Z
9468314 9468314 20260312191928_4AZmt KR003U 2026-03-13T12:21:38.761Z 2026-03-20T12:37:14.498Z
9461896 9461896 20260311191411_TVc4l KR003U 2026-03-12T12:18:08.819Z 2026-03-19T12:45:45.568Z
9461825 9461825 20260311185901_UxtGp KR003U 2026-03-12T12:18:02.907Z 2026-03-19T12:45:44.485Z
9461403 9461403 20260311160408_Ah2d6 KR003U 2026-03-12T12:17:07.423Z 2026-03-19T12:45:20.374Z
9461243 9461243 20260311151802_xYYSg KR003U 2026-03-12T12:16:46.096Z 2026-03-19T12:45:15.644Z
9461102 9461102 20260311140008_G14oM KR003U 2026-03-12T12:16:21.036Z 2026-03-19T12:45:12.335Z
9461075 9461075 20260311135506_oblcs KR003U 2026-03-12T12:16:18.138Z 2026-03-19T12:45:11.105Z
9460969 9460969 20260311124805_xyGD3 KR003U 2026-03-12T12:16:02.219Z 2026-03-19T12:45:08.425Z
9460963 9460963 20260311124235_mOcGc KR003U 2026-03-12T12:16:01.282Z 2026-03-19T12:45:08.256Z
9460912 9460912 20260311120534_WTmSG KR003U 2026-03-12T12:15:46.736Z 2026-03-19T12:45:06.492Z
9454960 9454960 20260310174303_G5aVs KR003U 2026-03-11T12:10:07.261Z 2026-03-18T12:39:51.021Z
9454912 9454912 20260310173236_bE6eJ KR003U 2026-03-11T12:10:03.374Z 2026-03-18T12:39:50.500Z
9454684 9454684 20260310164526_A8SN2 KR003U 2026-03-11T12:09:41.637Z 2026-03-18T12:39:48.366Z
9454613 9454613 20260310163504_s50zc KR003U 2026-03-11T12:09:34.250Z 2026-03-18T12:39:47.694Z
9454549 9454549 20260310162820_Wq0Jb KR003U 2026-03-11T12:09:28.638Z 2026-03-18T12:39:46.956Z
9454235 9454235 20260310154205_BCulU KR003U 2026-03-11T12:08:57.917Z 2026-03-18T12:39:44.445Z
9453958 9453958 20260310150523_4Jw4Q KR003U 2026-03-11T12:08:29.055Z 2026-03-18T12:39:42.055Z
9453421 9453421 20260310134030_U63i4 KR003U 2026-03-11T12:07:33.326Z 2026-03-18T12:39:29.325Z
9453246 9453246 20260310130837_RdEBb KR003U 2026-03-11T12:07:10.925Z 2026-03-18T12:39:21.790Z
9453242 9453242 20260310130836_Ie0Pb KR003U 2026-03-11T12:07:10.566Z 2026-03-18T12:39:21.747Z
9453181 9453181 20260310125324_XHot7 KR003U 2026-03-11T12:07:03.582Z 2026-03-18T12:39:21.296Z
9453027 9453027 20260310122042_uXNye KR003U 2026-03-11T12:06:42.793Z 2026-03-18T12:39:19.736Z

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