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,641 rows where station_code = "KR000D" 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
9271347 9271347 20260128214152_S9teW KR000D 2026-01-29T14:16:08.524Z 2026-01-29T14:16:08.524Z
9271333 9271333 20260128212433_6mMDA KR000D 2026-01-29T14:16:05.558Z 2026-01-29T14:16:05.558Z
9271319 9271319 20260128210844_82yVt KR000D 2026-01-29T14:16:01.579Z 2026-01-29T14:16:01.579Z
9271305 9271305 20260128210615_BX3WM KR000D 2026-01-29T14:15:52.323Z 2026-01-29T14:15:52.323Z
9271272 9271272 20260128204707_imJvK KR000D 2026-01-29T14:15:44.799Z 2026-01-29T14:15:44.799Z
9271262 9271262 20260128204259_ksSHa KR000D 2026-01-29T14:15:43.017Z 2026-01-29T14:15:43.017Z
9271246 9271246 20260128203726_bP6Op KR000D 2026-01-29T14:15:41.133Z 2026-01-29T14:15:41.133Z
9271229 9271229 20260128203242_4hD13 KR000D 2026-01-29T14:15:38.325Z 2026-01-29T14:15:38.325Z
9271204 9271204 20260128202410_32bal KR000D 2026-01-29T14:15:34.461Z 2026-01-29T14:15:34.461Z
9271198 9271198 20260128202307_3MUgR KR000D 2026-01-29T14:15:33.781Z 2026-01-29T14:15:33.781Z
9271177 9271177 20260128202017_hVola KR000D 2026-01-29T14:15:31.741Z 2026-01-29T14:15:31.741Z
9271160 9271160 20260128201626_go50G KR000D 2026-01-29T14:15:29.195Z 2026-01-29T14:15:29.195Z
9271122 9271122 20260128200225_22qtm KR000D 2026-01-29T14:15:18.846Z 2026-01-29T14:15:18.846Z
9271086 9271086 20260128195044_VuNch KR000D 2026-01-29T14:15:10.056Z 2026-01-29T14:15:10.056Z
9271077 9271077 20260128194805_3exd1 KR000D 2026-01-29T14:15:09.069Z 2026-01-29T14:15:09.069Z
9271026 9271026 20260128192630_i6lsP KR000D 2026-01-29T14:15:00.299Z 2026-01-29T14:15:00.299Z
9270969 9270969 20260128190538_sLQBc KR000D 2026-01-29T14:14:42.625Z 2026-01-29T14:14:42.625Z
9270902 9270902 20260128184425_toI2L KR000D 2026-01-29T14:14:32.496Z 2026-01-29T14:14:32.496Z
9270889 9270889 20260128183247_CNj5r KR000D 2026-01-29T14:14:30.322Z 2026-01-29T14:14:30.322Z
9270805 9270805 20260128174941_Vlyit KR000D 2026-01-29T14:14:03.786Z 2026-01-29T14:14:03.786Z
9270778 9270778 20260128173920_LMWC0 KR000D 2026-01-29T14:13:54.165Z 2026-01-29T14:13:54.165Z
9268562 9268562 20260128104705_hiMF3 KR000D 2026-01-29T14:03:49.440Z 2026-01-29T14:03:49.440Z
9266797 9266797 20260127212707_7WFEA KR000D 2026-01-28T14:14:36.913Z 2026-01-29T14:30:25.219Z
9266778 9266778 20260127211647_HzH0g KR000D 2026-01-28T14:14:34.001Z 2026-01-29T14:30:25.215Z
9266755 9266755 20260127210444_72iqS KR000D 2026-01-28T14:14:27.946Z 2026-01-29T14:30:25.212Z
9266670 9266670 20260127203322_ZmKeG KR000D 2026-01-28T14:14:14.474Z 2026-01-29T14:30:25.168Z
9266655 9266655 20260127202747_T2fLV KR000D 2026-01-28T14:14:12.637Z 2026-01-29T14:30:25.165Z
9266639 9266639 20260127201927_1Zfpz KR000D 2026-01-28T14:14:09.450Z 2026-01-29T14:30:25.151Z
9266605 9266605 20260127200441_kGq1N KR000D 2026-01-28T14:14:04.767Z 2026-01-29T14:30:25.138Z
9266536 9266536 20260127194522_FpVEz KR000D 2026-01-28T14:13:48.303Z 2026-01-29T14:30:25.082Z
9266450 9266450 20260127192404_4Edb2 KR000D 2026-01-28T14:13:37.169Z 2026-01-29T14:30:25.032Z
9266439 9266439 20260127192334_Z0eWn KR000D 2026-01-28T14:13:36.519Z 2026-01-29T14:30:25.032Z
9266411 9266411 20260127191508_3VIEJ KR000D 2026-01-28T14:13:26.812Z 2026-01-29T14:30:25.023Z
9266387 9266387 20260127190900_TV0wA KR000D 2026-01-28T14:13:22.593Z 2026-01-29T14:30:25.017Z
9266369 9266369 20260127190142_K76Ye KR000D 2026-01-28T14:13:19.785Z 2026-01-29T14:30:25.002Z
9266347 9266347 20260127185758_3rKoS KR000D 2026-01-28T14:13:16.674Z 2026-01-29T14:30:24.999Z
9266338 9266338 20260127185750_LRAhW KR000D 2026-01-28T14:13:15.690Z 2026-01-29T14:30:24.999Z
9266315 9266315 20260127185033_QlSx9 KR000D 2026-01-28T14:13:12.972Z 2026-01-29T14:30:24.993Z
9266173 9266173 20260127175151_WuGcv KR000D 2026-01-28T14:12:42.969Z 2026-01-29T14:30:24.904Z
9266155 9266155 20260127174457_2t6Y2 KR000D 2026-01-28T14:12:39.926Z 2026-01-29T14:30:24.900Z
9266108 9266108 20260127172524_nncAn KR000D 2026-01-28T14:12:27.988Z 2026-01-29T14:30:24.882Z
9266103 9266103 20260127172135_vLeuB KR000D 2026-01-28T14:12:26.647Z 2026-01-28T14:12:26.647Z
9266053 9266053 20260127165906_RlJDV KR000D 2026-01-28T14:12:16.855Z 2026-01-29T14:30:24.837Z
9266005 9266005 20260127163451_OycvQ KR000D 2026-01-28T14:12:07.947Z 2026-01-29T14:30:24.813Z
9265997 9265997 20260127163216_GiYnN KR000D 2026-01-28T14:12:06.947Z 2026-01-29T14:30:24.811Z
9265450 9265450 20260127151639_pt3IW KR000D 2026-01-28T14:10:12.307Z 2026-01-29T14:30:24.552Z
9265145 9265145 20260127142442_wN6um KR000D 2026-01-28T14:09:12.679Z 2026-01-29T14:30:24.467Z
9262507 9262507 20260125164120_141VQ KR000D 2026-01-27T14:11:51.288Z 2026-01-29T14:37:45.977Z
9262502 9262502 20260126214039_wQIjh KR000D 2026-01-27T14:09:21.472Z 2026-01-29T14:34:45.954Z
9262488 9262488 20260126212508_VGdBM KR000D 2026-01-27T14:09:19.603Z 2026-01-29T14:34:44.433Z
9262483 9262483 20260126212255_qXr2k KR000D 2026-01-27T14:09:19.147Z 2026-01-29T14:34:44.248Z
9262419 9262419 20260126202321_TK2ye KR000D 2026-01-27T14:08:59.310Z 2026-01-29T14:34:30.143Z
9262411 9262411 20260126202217_Y6gQG KR000D 2026-01-27T14:08:57.975Z 2026-01-29T14:34:29.717Z
9262394 9262394 20260126201942_q5Q62 KR000D 2026-01-27T14:08:55.785Z 2026-01-29T14:34:29.230Z
9262354 9262354 20260126195509_uHthM KR000D 2026-01-27T14:08:47.764Z 2026-01-29T14:34:25.439Z
9262304 9262304 20260126190213_zRXAZ KR000D 2026-01-27T14:08:32.186Z 2026-01-29T14:34:17.672Z
9262277 9262277 20260126184756_w4Suu KR000D 2026-01-27T14:08:24.868Z 2026-01-29T14:34:14.865Z
9262228 9262228 20260126182451_xuqPV KR000D 2026-01-27T14:08:16.131Z 2026-01-29T14:34:02.028Z
9262152 9262152 20260126170822_q1JNH KR000D 2026-01-27T14:07:52.480Z 2026-01-29T14:33:47.078Z
9262145 9262145 20260126170209_QKowl KR000D 2026-01-27T14:07:50.661Z 2026-01-27T14:07:50.661Z
9259578 9259578 20260124214408_ldgNF KR000D 2026-01-26T14:17:30.304Z 2026-01-29T14:43:07.122Z
9259539 9259539 20260124212109_2MFUE KR000D 2026-01-26T14:17:25.632Z 2026-01-29T14:43:05.229Z
9259529 9259529 20260124212004_SWXHQ KR000D 2026-01-26T14:17:24.281Z 2026-01-29T14:43:04.803Z
9259482 9259482 20260124210939_GyXSB KR000D 2026-01-26T14:17:10.916Z 2026-01-29T14:42:57.064Z
9259384 9259384 20260124204019_AVv8i KR000D 2026-01-26T14:16:51.246Z 2026-01-29T14:42:50.757Z
9259373 9259373 20260124203954_4XXmy KR000D 2026-01-26T14:16:50.020Z 2026-01-29T14:42:50.471Z
9259311 9259311 20260124201408_3sep7 KR000D 2026-01-26T14:16:30.389Z 2026-01-29T14:42:47.293Z
9259299 9259299 20260124201221_n2Dil KR000D 2026-01-26T14:16:28.840Z 2026-01-29T14:42:46.805Z
9259264 9259264 20260124200608_HNLrC KR000D 2026-01-26T14:16:23.981Z 2026-01-29T14:42:45.527Z
9259241 9259241 20260124195510_o1v2M KR000D 2026-01-26T14:16:19.560Z 2026-01-29T14:42:44.271Z
9259141 9259141 20260124190758_3N06G KR000D 2026-01-26T14:15:53.901Z 2026-01-29T14:42:38.629Z
9259118 9259118 20260124190051_Zic0N KR000D 2026-01-26T14:15:50.868Z 2026-01-29T14:42:37.802Z
9259107 9259107 20260124185437_VSoNO KR000D 2026-01-26T14:15:42.661Z 2026-01-29T14:42:37.288Z
9259078 9259078 20260124184148_yx1ac KR000D 2026-01-26T14:15:36.674Z 2026-01-29T14:42:29.711Z
9259024 9259024 20260124182643_TVg3c KR000D 2026-01-26T14:15:27.897Z 2026-01-29T14:42:26.800Z
9258979 9258979 20260124181636_PsScC KR000D 2026-01-26T14:15:17.601Z 2026-01-29T14:42:21.772Z
9258972 9258972 20260124181634_LMlBz KR000D 2026-01-26T14:15:16.908Z 2026-01-29T14:42:21.490Z
9258958 9258958 20260124181502_Gn4Je KR000D 2026-01-26T14:15:10.814Z 2026-01-29T14:42:21.392Z
9258927 9258927 20260124180404_gdXaH KR000D 2026-01-26T14:15:06.198Z 2026-01-29T14:42:19.934Z
9258891 9258891 20260124175157_nKJPC KR000D 2026-01-26T14:14:55.304Z 2026-01-29T14:42:17.254Z
9258870 9258870 20260124174653_OADww KR000D 2026-01-26T14:14:52.568Z 2026-01-29T14:42:16.225Z
9258859 9258859 20260124174214_7On23 KR000D 2026-01-26T14:14:50.800Z 2026-01-29T14:42:15.612Z
9258819 9258819 20260124171901_38UEk KR000D 2026-01-26T14:14:33.457Z 2026-01-29T14:42:12.807Z
9258806 9258806 20260124171531_3dgqK KR000D 2026-01-26T14:14:30.798Z 2026-01-29T14:42:11.955Z
9258679 9258679 20260124160506_pqhCz KR000D 2026-01-26T14:13:53.976Z 2026-01-29T14:41:52.108Z
9258673 9258673 20260124160132_ssUGM KR000D 2026-01-26T14:13:51.512Z 2026-01-29T14:41:50.925Z
9258606 9258606 20260124150837_Ju9Hq KR000D 2026-01-26T14:13:19.435Z 2026-01-29T14:41:40.902Z
9258578 9258578 20260124145029_FbsT9 KR000D 2026-01-26T14:13:06.433Z 2026-01-29T14:41:31.836Z
9258564 9258564 20260124143602_deom2 KR000D 2026-01-26T14:13:01.437Z 2026-01-29T14:41:27.409Z
9258516 9258516 20260124141040_3ovAt KR000D 2026-01-26T14:12:39.138Z 2026-01-29T14:41:21.313Z
9258497 9258497 20260124135320_WkV7G KR000D 2026-01-26T14:12:32.417Z 2026-01-29T14:41:17.636Z
9258470 9258470 20260124131807_4w5Nf KR000D 2026-01-26T14:12:19.236Z 2026-01-29T14:41:11.815Z
9258353 9258353 20260124100405_2VcyG KR000D 2026-01-26T14:10:56.486Z 2026-01-29T14:40:25.614Z
9258176 9258176 20260125192152_Q3ywn KR000D 2026-01-26T14:09:56.075Z 2026-01-29T14:38:07.100Z
9258087 9258087 20260125183431_SVt9q KR000D 2026-01-26T14:09:33.826Z 2026-01-29T14:38:02.640Z
9258077 9258077 20260125183243_2v8K1 KR000D 2026-01-26T14:09:32.953Z 2026-01-29T14:38:02.463Z
9258011 9258011 20260125175852_Ftf3c KR000D 2026-01-26T14:09:08.558Z 2026-01-29T14:37:57.947Z
9257963 9257963 20260125173406_XRfAA KR000D 2026-01-26T14:08:49.327Z 2026-01-29T14:37:55.730Z
9257941 9257941 20260125171440_GKwGb KR000D 2026-01-26T14:08:42.599Z 2026-01-29T14:37:54.353Z
9257868 9257868 20260125164116_kjDDI KR000D 2026-01-26T14:08:15.150Z 2026-01-29T14:37:45.783Z

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