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

>10,000 rows count all where station_code = "KR000H" 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
9609864 9609864 20260405104052_lLFbY KR000H 2026-04-06T12:04:23.329Z 2026-04-06T12:04:23.329Z
9609861 9609861 20260405104052_n2RHO KR000H 2026-04-06T12:04:22.606Z 2026-04-06T12:04:22.606Z
9607841 9607841 20260404170312_I3IqZ KR000H 2026-04-05T12:04:25.982Z 2026-04-06T12:16:14.530Z
9607730 9607730 20260404122040_sRO6i KR000H 2026-04-05T12:03:47.235Z 2026-04-06T12:16:14.503Z
9551584 9551584 20260320202549_D1Qk2 KR000H 2026-03-22T12:26:49.674Z 2026-03-28T12:36:58.388Z
9551453 9551453 20260320195208_OJ2gy KR000H 2026-03-22T12:26:41.379Z 2026-03-28T12:36:53.550Z
9551448 9551448 20260320195207_MNfF7 KR000H 2026-03-22T12:26:41.188Z 2026-03-28T12:36:53.549Z
9551392 9551392 20260320194052_2jAP8 KR000H 2026-03-22T12:26:37.815Z 2026-03-28T12:36:49.927Z
9551266 9551266 20260320190440_Q5zDx KR000H 2026-03-22T12:26:21.438Z 2026-03-28T12:36:41.650Z
9551225 9551225 20260320190028_7Ij3G KR000H 2026-03-22T12:26:19.338Z 2026-03-28T12:36:41.224Z
9551001 9551001 20260320174337_kzaOm KR000H 2026-03-22T12:26:04.241Z 2026-03-28T12:36:38.887Z
9550981 9550981 20260320173321_xpxLC KR000H 2026-03-22T12:26:03.074Z 2026-03-28T12:36:38.571Z
9550958 9550958 20260320172913_0Mrjb KR000H 2026-03-22T12:26:01.101Z 2026-03-28T12:36:38.259Z
9550901 9550901 20260320172206_bks3B KR000H 2026-03-22T12:25:57.474Z 2026-03-28T12:36:37.453Z
9550892 9550892 20260320172137_y821r KR000H 2026-03-22T12:25:49.789Z 2026-03-28T12:36:37.357Z
9550859 9550859 20260320171717_TKrNs KR000H 2026-03-22T12:25:48.461Z 2026-03-28T12:36:37.073Z
9550790 9550790 20260320171157_DsiTd KR000H 2026-03-22T12:25:45.407Z 2026-03-28T12:36:36.102Z
9550726 9550726 20260320170718_3UbAK KR000H 2026-03-22T12:25:40.225Z 2026-03-28T12:36:35.494Z
9550515 9550515 20260320164521_RC88n KR000H 2026-03-22T12:25:27.853Z 2026-03-28T12:36:32.066Z
9550230 9550230 20260320162225_fiHAl KR000H 2026-03-22T12:25:03.265Z 2026-03-28T12:36:28.538Z
9541380 9541380 20260319202702_V6bnI KR000H 2026-03-21T12:28:53.079Z 2026-03-27T12:42:37.072Z
9541290 9541290 20260319201342_PX6xK KR000H 2026-03-21T12:28:48.489Z 2026-03-27T12:42:36.299Z
9541251 9541251 20260319201037_rZVN4 KR000H 2026-03-21T12:28:46.764Z 2026-03-27T12:42:35.938Z
9541246 9541246 20260319201034_ohr5J KR000H 2026-03-21T12:28:46.470Z 2026-03-27T12:42:35.892Z
9541180 9541180 20260319195410_Cp84A KR000H 2026-03-21T12:28:42.086Z 2026-03-27T12:42:35.013Z
9541138 9541138 20260319193932_cpeOW KR000H 2026-03-21T12:28:38.973Z 2026-03-27T12:42:34.436Z
9540925 9540925 20260319183358_3AY9L KR000H 2026-03-21T12:28:17.111Z 2026-03-27T12:42:32.058Z
9540887 9540887 20260319182836_T7RoQ KR000H 2026-03-21T12:28:15.754Z 2026-03-27T12:42:31.883Z
9540853 9540853 20260319181524_y0iCb KR000H 2026-03-21T12:28:13.357Z 2026-03-27T12:42:31.562Z
9540795 9540795 20260319180010_3EsOH KR000H 2026-03-21T12:28:09.694Z 2026-03-27T12:42:31.068Z
9540757 9540757 20260319174952_nseoJ KR000H 2026-03-21T12:28:07.709Z 2026-03-27T12:42:30.727Z
9540698 9540698 20260319172445_RsWZ5 KR000H 2026-03-21T12:27:54.556Z 2026-03-27T12:42:29.728Z
9540496 9540496 20260319155952_KBV47 KR000H 2026-03-21T12:27:05.422Z 2026-03-27T12:42:23.170Z
9540471 9540471 20260319154741_5a1mX KR000H 2026-03-21T12:27:02.633Z 2026-03-27T12:42:22.422Z
9540467 9540467 20260319154735_4CwGQ KR000H 2026-03-21T12:27:02.424Z 2026-03-27T12:42:22.405Z
9540433 9540433 20260319154041_TO887 KR000H 2026-03-21T12:27:00.027Z 2026-03-27T12:42:21.798Z
9540387 9540387 20260319152926_ihCAa KR000H 2026-03-21T12:26:56.547Z 2026-03-27T12:42:20.959Z
9540358 9540358 20260319152526_POCYw KR000H 2026-03-21T12:26:54.197Z 2026-03-27T12:42:20.490Z
9540323 9540323 20260319151501_t2mxC KR000H 2026-03-21T12:26:50.601Z 2026-03-27T12:42:19.636Z
9540294 9540294 20260319150221_O6bH4 KR000H 2026-03-21T12:26:40.869Z 2026-03-27T12:42:13.099Z
9540276 9540276 20260319145515_4Ew6o KR000H 2026-03-21T12:26:37.075Z 2026-03-27T12:42:05.635Z
9540247 9540247 20260319144956_347LT KR000H 2026-03-21T12:26:33.899Z 2026-03-27T12:42:04.945Z
9540222 9540222 20260319144305_iV3EI KR000H 2026-03-21T12:26:31.540Z 2026-03-27T12:42:04.453Z
9540200 9540200 20260319142936_Yq2Ol KR000H 2026-03-21T12:26:28.526Z 2026-03-27T12:42:03.643Z
9540062 9540062 20260319124013_165eD KR000H 2026-03-21T12:26:00.327Z 2026-03-27T12:41:57.102Z
9540019 9540019 20260319123224_3I3zZ KR000H 2026-03-21T12:25:56.581Z 2026-03-27T12:41:56.363Z
9539949 9539949 20260319113010_XBVND KR000H 2026-03-21T12:25:28.678Z 2026-03-27T12:41:49.948Z
9539888 9539888 20260319102941_GV2R3 KR000H 2026-03-21T12:25:02.566Z 2026-03-27T12:41:31.166Z
9538855 9538855 20260320135142_UI1EB KR000H 2026-03-21T12:18:30.493Z 2026-03-28T12:35:53.774Z
9538461 9538461 20260320130613_2coE7 KR000H 2026-03-21T12:17:44.778Z 2026-03-21T12:30:06.483Z
9538350 9538350 20260320125327_EfpOs KR000H 2026-03-21T12:17:33.428Z 2026-03-21T12:30:06.449Z
9538057 9538057 20260320122914_7ERlK KR000H 2026-03-21T12:17:01.246Z 2026-03-28T12:35:34.127Z
9530235 9530235 20260318203004_3TkRs KR000H 2026-03-20T12:24:14.478Z 2026-03-26T12:39:10.673Z
9530057 9530057 20260318200223_awGhC KR000H 2026-03-20T12:23:57.281Z 2026-03-26T12:39:08.858Z
9529624 9529624 20260318190000_VDzhe KR000H 2026-03-20T12:23:24.290Z 2026-03-26T12:39:04.995Z
9529575 9529575 20260318185542_fwGcv KR000H 2026-03-20T12:23:19.572Z 2026-03-26T12:39:04.539Z
9529398 9529398 20260318181134_sPDK1 KR000H 2026-03-20T12:23:08.452Z 2026-03-26T12:39:02.331Z
9529392 9529392 20260318181059_aTMNH KR000H 2026-03-20T12:23:08.269Z 2026-03-26T12:39:02.159Z
9529305 9529305 20260318174004_T6zxp KR000H 2026-03-20T12:23:02.613Z 2026-03-26T12:38:55.865Z
9527696 9527696 20260318150646_I21C6 KR000H 2026-03-20T12:21:38.600Z 2026-03-26T12:38:30.548Z
9527423 9527423 20260318143823_qYB42 KR000H 2026-03-20T12:21:16.584Z 2026-03-26T12:38:28.316Z
9526951 9526951 20260318133825_eg905 KR000H 2026-03-20T12:20:46.445Z 2026-03-26T12:38:24.876Z
9507106 9507106 20260316202257_iw7QK KR000H 2026-03-18T12:19:54.039Z 2026-03-24T12:41:39.873Z
9506700 9506700 20260316185950_ldhLB KR000H 2026-03-18T12:19:14.074Z 2026-03-24T12:41:34.331Z
9506606 9506606 20260316183528_ALSim KR000H 2026-03-18T12:19:04.765Z 2026-03-24T12:41:33.749Z
9506602 9506602 20260316183450_B0e39 KR000H 2026-03-18T12:19:04.440Z 2026-03-24T12:41:33.747Z
9506592 9506592 20260316183252_QWz30 KR000H 2026-03-18T12:19:03.382Z 2026-03-24T12:41:33.698Z
9504695 9504695 20260317121509_6wARF KR000H 2026-03-18T12:08:42.105Z 2026-03-25T12:42:23.956Z
9500223 9500223 20260316175816_3tnxX KR000H 2026-03-17T12:17:00.684Z 2026-03-24T12:41:32.945Z
9500161 9500161 20260316174343_qLeWs KR000H 2026-03-17T12:16:51.980Z 2026-03-24T12:41:32.728Z
9500145 9500145 20260316174000_983mU KR000H 2026-03-17T12:16:49.230Z 2026-03-17T12:25:25.892Z
9500094 9500094 20260316172925_L37S5 KR000H 2026-03-17T12:16:44.449Z 2026-03-17T12:25:25.877Z
9499981 9499981 20260316171014_VxYeM KR000H 2026-03-17T12:16:32.797Z 2026-03-24T12:41:32.101Z
9499839 9499839 20260316165706_SyTs3 KR000H 2026-03-17T12:16:14.352Z 2026-03-24T12:41:31.530Z
9499828 9499828 20260316165354_5osL8 KR000H 2026-03-17T12:16:12.491Z 2026-03-24T12:41:31.484Z
9499356 9499356 20260316161419_QS9K8 KR000H 2026-03-17T12:15:27.995Z 2026-03-24T12:41:29.000Z
9499170 9499170 20260316155732_oPhxE KR000H 2026-03-17T12:15:07.315Z 2026-03-24T12:41:28.259Z
9498729 9498729 20260316152233_CsuGI KR000H 2026-03-17T12:14:21.455Z 2026-03-24T12:41:26.860Z
9498494 9498494 20260316151001_2rM3z KR000H 2026-03-17T12:14:01.773Z 2026-03-24T12:41:26.283Z
9498376 9498376 20260316145930_lz2cG KR000H 2026-03-17T12:13:46.426Z 2026-03-24T12:41:25.814Z
9498121 9498121 20260316143731_UN6M2 KR000H 2026-03-17T12:13:19.451Z 2026-03-24T12:41:25.029Z
9497904 9497904 20260316141932_qU47S KR000H 2026-03-17T12:12:53.444Z 2026-03-24T12:41:24.507Z
9497799 9497799 20260316141102_yJwUi KR000H 2026-03-17T12:12:40.675Z 2026-03-24T12:41:24.315Z
9496980 9496980 20260316123849_C26uU KR000H 2026-03-17T12:11:03.297Z 2026-03-24T12:41:21.927Z
9496658 9496658 20260316120308_9pM2x KR000H 2026-03-17T12:10:18.271Z 2026-03-17T12:25:25.067Z
9496422 9496422 20260316113204_lZrgT KR000H 2026-03-17T12:09:45.187Z 2026-03-17T12:25:24.969Z
9496284 9496284 20260316110741_Rcf6B KR000H 2026-03-17T12:09:27.624Z 2026-03-24T12:41:19.000Z
9496234 9496234 20260316110317_DwTUq KR000H 2026-03-17T12:09:20.337Z 2026-03-24T12:41:18.842Z
9491841 9491841 20260315202907_llXkf KR000H 2026-03-16T12:21:57.833Z 2026-03-23T12:22:42.604Z
9491780 9491780 20260315194502_edy0w KR000H 2026-03-16T12:21:48.623Z 2026-03-23T12:22:41.875Z
9491727 9491727 20260315190320_e2wNS KR000H 2026-03-16T12:21:41.645Z 2026-03-23T12:22:41.182Z
9491499 9491499 20260315170051_xl1T7 KR000H 2026-03-16T12:21:08.589Z 2026-03-23T12:22:39.691Z
9491446 9491446 20260315165022_fIYCn KR000H 2026-03-16T12:20:59.372Z 2026-03-23T12:22:39.555Z
9491325 9491325 20260315163520_7CCF8 KR000H 2026-03-16T12:20:47.078Z 2026-03-23T12:22:39.196Z
9490514 9490514 20260315150200_20A3W KR000H 2026-03-16T12:19:14.252Z 2026-03-23T12:22:36.830Z
9489482 9489482 20260315132433_eeKfs KR000H 2026-03-16T12:17:16.573Z 2026-03-23T12:22:34.149Z
9488127 9488127 20260315111955_JH15X KR000H 2026-03-16T12:14:28.481Z 2026-03-23T12:22:24.505Z
9487607 9487607 20260315103308_r3ywr KR000H 2026-03-16T12:13:18.984Z 2026-03-23T12:22:17.755Z
9481280 9481280 20260314145715_TDhWw KR000H 2026-03-15T12:17:31.470Z 2026-03-22T12:42:44.002Z
9481084 9481084 20260314143808_ngxmV KR000H 2026-03-15T12:17:07.249Z 2026-03-22T12:42:43.210Z

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