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,726 rows where station_code = "KR000S" 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
9583883 9583883 20260326192856_sogYg KR000S 2026-03-27T12:10:01.575Z 2026-04-04T12:41:50.255Z
9583825 9583825 20260326185339_ZwdQX KR000S 2026-03-27T12:09:53.155Z 2026-04-04T12:41:40.384Z
9583775 9583775 20260326180026_E1E4o KR000S 2026-03-27T12:09:43.845Z 2026-04-04T12:41:38.434Z
9583707 9583707 20260326172605_0uvIK KR000S 2026-03-27T12:09:34.208Z 2026-04-04T12:41:32.600Z
9583677 9583677 20260326170820_C3646 KR000S 2026-03-27T12:09:29.259Z 2026-04-04T12:41:30.925Z
9583499 9583499 20260326153750_Kg5i1 KR000S 2026-03-27T12:09:00.077Z 2026-04-04T12:41:21.426Z
9583465 9583465 20260326151059_wDSkI KR000S 2026-03-27T12:08:53.114Z 2026-04-04T12:41:13.543Z
9583415 9583415 20260326144435_QdQyV KR000S 2026-03-27T12:08:43.862Z 2026-04-04T12:41:10.472Z
9578901 9578901 20260325154628_V4Q6G KR000S 2026-03-26T12:08:47.739Z 2026-04-03T12:38:39.820Z
9578867 9578867 20260325151916_advRG KR000S 2026-03-26T12:08:43.809Z 2026-04-03T12:38:37.179Z
9578846 9578846 20260325151311_mzfW4 KR000S 2026-03-26T12:08:40.777Z 2026-04-03T12:38:35.924Z
9575209 9575209 20260323193050_ENKJp KR000S 2026-03-25T12:20:32.536Z 2026-03-31T12:28:51.119Z
9575170 9575170 20260323191034_zDDN0 KR000S 2026-03-25T12:20:27.034Z 2026-03-31T12:28:50.296Z
9575017 9575017 20260323181944_w93D8 KR000S 2026-03-25T12:20:05.378Z 2026-03-31T12:28:46.640Z
9574631 9574631 20260324192704_stOW1 KR000S 2026-03-25T12:11:10.844Z 2026-04-02T12:37:06.864Z
9570249 9570249 20260322201547_IoU74 KR000S 2026-03-24T12:22:52.805Z 2026-03-30T12:30:38.074Z
9570221 9570221 20260322200249_IJ23R KR000S 2026-03-24T12:22:49.715Z 2026-03-30T12:30:37.416Z
9570128 9570128 20260322192028_NXPy6 KR000S 2026-03-24T12:22:37.662Z 2026-03-30T12:30:28.193Z
9569989 9569989 20260322184850_H1ZeT KR000S 2026-03-24T12:22:26.744Z 2026-03-30T12:30:26.039Z
9569858 9569858 20260322181047_mQ2Em KR000S 2026-03-24T12:22:15.758Z 2026-03-30T12:30:22.424Z
9569800 9569800 20260322174620_mGWmO KR000S 2026-03-24T12:22:07.542Z 2026-03-30T12:30:21.520Z
9569680 9569680 20260322165202_l4Dne KR000S 2026-03-24T12:21:47.716Z 2026-03-30T12:30:15.456Z
9569553 9569553 20260322161243_WTWCw KR000S 2026-03-24T12:21:22.376Z 2026-03-30T12:30:08.828Z
9569509 9569509 20260322160014_oF19Y KR000S 2026-03-24T12:21:15.904Z 2026-03-30T12:30:06.524Z
9569230 9569230 20260322141759_TOwD5 KR000S 2026-03-24T12:20:14.807Z 2026-03-30T12:29:40.137Z
9568903 9568903 20260322111454_grdJV KR000S 2026-03-24T12:18:54.320Z 2026-03-30T12:29:06.600Z
9568876 9568876 20260322105204_mPVMR KR000S 2026-03-24T12:18:45.880Z 2026-03-30T12:29:03.159Z
9568653 9568653 20260323170920_EFFQW KR000S 2026-03-24T12:15:28.094Z 2026-03-31T12:28:39.723Z
9567790 9567790 20260323154938_PRjhK KR000S 2026-03-24T12:14:09.015Z 2026-03-31T12:28:18.893Z
9567712 9567712 20260323154246_qeJcM KR000S 2026-03-24T12:14:00.294Z 2026-03-31T12:28:17.741Z
9565039 9565039 20260323114048_I1y3i KR000S 2026-03-24T12:09:18.203Z 2026-03-31T12:27:21.734Z
9564499 9564499 20260323104218_Enlb2 KR000S 2026-03-24T12:08:12.422Z 2026-03-31T12:27:10.237Z
9551455 9551455 20260320195231_rXF9U KR000S 2026-03-22T12:26:41.626Z 2026-03-28T12:36:53.655Z
9551381 9551381 20260320193956_VCTpR KR000S 2026-03-22T12:26:37.155Z 2026-03-28T12:36:49.024Z
9551312 9551312 20260320191737_yUFSB KR000S 2026-03-22T12:26:25.367Z 2026-03-28T12:36:44.056Z
9551231 9551231 20260320190107_pssUR KR000S 2026-03-22T12:26:19.546Z 2026-03-28T12:36:41.269Z
9551188 9551188 20260320185028_aQ2U9 KR000S 2026-03-22T12:26:16.495Z 2026-03-28T12:36:40.872Z
9551159 9551159 20260320183935_vDG9R KR000S 2026-03-22T12:26:13.969Z 2026-03-28T12:36:40.423Z
9551142 9551142 20260320183521_owaUh KR000S 2026-03-22T12:26:13.053Z 2026-03-28T12:36:40.308Z
9551025 9551025 20260320174715_M79Fu KR000S 2026-03-22T12:26:05.287Z 2026-03-28T12:36:38.993Z
9550075 9550075 20260320160642_rDx7n KR000S 2026-03-22T12:24:54.154Z 2026-03-28T12:36:26.902Z
9549201 9549201 20260320120655_LvywQ KR000S 2026-03-22T12:21:52.619Z 2026-03-28T12:35:29.932Z
9549194 9549194 20260320120148_Nopr6 KR000S 2026-03-22T12:21:49.067Z 2026-03-28T12:35:29.232Z
9549184 9549184 20260320114534_kUP19 KR000S 2026-03-22T12:21:31.544Z 2026-03-28T12:35:27.037Z
9548184 9548184 20260321143926_XAxz0 KR000S 2026-03-22T12:15:01.089Z 2026-03-29T12:20:24.551Z
9547769 9547769 20260321135723_bf02R KR000S 2026-03-22T12:14:18.042Z 2026-03-29T12:20:21.160Z
9547362 9547362 20260321132056_LZtUK KR000S 2026-03-22T12:13:30.850Z 2026-03-29T12:20:09.024Z
9546733 9546733 20260321122249_QfjPa KR000S 2026-03-22T12:12:18.307Z 2026-03-29T12:20:03.644Z
9541329 9541329 20260319201734_xlVpo KR000S 2026-03-21T12:28:50.098Z 2026-03-27T12:42:36.563Z
9540901 9540901 20260319183033_GIkrf KR000S 2026-03-21T12:28:16.545Z 2026-03-27T12:42:32.020Z
9540871 9540871 20260319182328_fDOHs KR000S 2026-03-21T12:28:14.982Z 2026-03-27T12:42:31.757Z
9540831 9540831 20260319181407_qT5iR KR000S 2026-03-21T12:28:11.455Z 2026-03-27T12:42:31.271Z
9540823 9540823 20260319181340_680z9 KR000S 2026-03-21T12:28:11.124Z 2026-03-27T12:42:31.261Z
9540789 9540789 20260319180009_JvXGj KR000S 2026-03-21T12:28:09.400Z 2026-03-27T12:42:31.009Z
9540713 9540713 20260319173010_MIMHK KR000S 2026-03-21T12:27:56.918Z 2026-03-27T12:42:30.188Z
9540650 9540650 20260319171010_IOKpy KR000S 2026-03-21T12:27:47.035Z 2026-03-27T12:42:28.849Z
9540600 9540600 20260319165411_1KzKa KR000S 2026-03-21T12:27:36.703Z 2026-03-27T12:42:27.070Z
9540552 9540552 20260319162921_wPTkN KR000S 2026-03-21T12:27:17.165Z 2026-03-27T12:42:25.274Z
9540376 9540376 20260319152820_QlaMj KR000S 2026-03-21T12:26:55.789Z 2026-03-27T12:42:20.808Z
9540210 9540210 20260319143711_BRCMJ KR000S 2026-03-21T12:26:30.057Z 2026-03-27T12:42:04.008Z
9540067 9540067 20260319124112_0i4av KR000S 2026-03-21T12:26:00.679Z 2026-03-27T12:41:57.323Z
9539966 9539966 20260319115604_HHqOn KR000S 2026-03-21T12:25:39.621Z 2026-03-27T12:41:52.659Z
9539902 9539902 20260319104054_QggDx KR000S 2026-03-21T12:25:08.113Z 2026-03-27T12:41:44.866Z
9538228 9538228 20260320124259_Rb779 KR000S 2026-03-21T12:17:21.640Z 2026-03-28T12:35:36.138Z
9537836 9537836 20260320120654_rghqQ KR000S 2026-03-21T12:16:34.123Z 2026-03-28T12:35:29.898Z
9537771 9537771 20260320120147_Qst4K KR000S 2026-03-21T12:16:27.585Z 2026-03-28T12:35:29.187Z
9537541 9537541 20260320114533_DZFX3 KR000S 2026-03-21T12:15:59.573Z 2026-03-28T12:35:27.009Z
9530039 9530039 20260318195721_BpWiK KR000S 2026-03-20T12:23:56.117Z 2026-03-26T12:39:08.600Z
9529947 9529947 20260318194449_SAR5H KR000S 2026-03-20T12:23:50.901Z 2026-03-26T12:39:07.678Z
9529903 9529903 20260318193925_4xs5p KR000S 2026-03-20T12:23:48.049Z 2026-03-26T12:39:07.315Z
9529581 9529581 20260318185713_nWZkb KR000S 2026-03-20T12:23:19.898Z 2026-03-26T12:39:04.608Z
9529503 9529503 20260318183931_CR6LE KR000S 2026-03-20T12:23:14.582Z 2026-03-26T12:39:03.540Z
9529499 9529499 20260318183910_3vBBV KR000S 2026-03-20T12:23:14.341Z 2026-03-26T12:39:03.470Z
9529485 9529485 20260318183721_ikhVB KR000S 2026-03-20T12:23:13.737Z 2026-03-26T12:39:03.314Z
9529421 9529421 20260318181558_R2K92 KR000S 2026-03-20T12:23:09.423Z 2026-03-26T12:39:02.440Z
9529328 9529328 20260318174634_1eXD7 KR000S 2026-03-20T12:23:03.999Z 2026-03-26T12:38:58.000Z
9529215 9529215 20260318172740_YIpUo KR000S 2026-03-20T12:22:58.257Z 2026-03-26T12:38:50.761Z
9529186 9529186 20260318172448_FBwOr KR000S 2026-03-20T12:22:56.870Z 2026-03-26T12:38:49.516Z
9529138 9529138 20260318172002_TUYgZ KR000S 2026-03-20T12:22:55.293Z 2026-03-26T12:38:47.464Z
9529074 9529074 20260318171159_pwhGj KR000S 2026-03-20T12:22:52.086Z 2026-03-26T12:38:44.242Z
9529044 9529044 20260318170922_ZAkOv KR000S 2026-03-20T12:22:49.896Z 2026-03-26T12:38:42.726Z
9515137 9515137 20260318124830_pwGb0 KR000S 2026-03-19T12:19:08.843Z 2026-03-26T12:38:22.052Z
9514817 9514817 20260318121011_P1bez KR000S 2026-03-19T12:18:26.543Z 2026-03-26T12:38:19.632Z
9507191 9507191 20260316203020_lBijq KR000S 2026-03-18T12:19:59.197Z 2026-03-24T12:41:41.603Z
9507076 9507076 20260316201518_29G8Y KR000S 2026-03-18T12:19:51.070Z 2026-03-24T12:41:38.941Z
9506957 9506957 20260316195750_hqokZ KR000S 2026-03-18T12:19:42.252Z 2026-03-24T12:41:36.489Z
9506786 9506786 20260316192659_dNfRp KR000S 2026-03-18T12:19:21.360Z 2026-03-24T12:41:34.699Z
9506741 9506741 20260316191434_2KTRg KR000S 2026-03-18T12:19:17.453Z 2026-03-24T12:41:34.487Z
9506555 9506555 20260316182106_hJ3Ef KR000S 2026-03-18T12:18:55.710Z 2026-03-24T12:41:33.459Z
9506495 9506495 20260316180622_WPYhz KR000S 2026-03-18T12:18:49.295Z 2026-03-24T12:41:33.149Z
9506484 9506484 20260316180507_DdlkT KR000S 2026-03-18T12:18:48.506Z 2026-03-24T12:41:33.088Z
9504875 9504875 20260317123832_i6zcc KR000S 2026-03-18T12:09:04.450Z 2026-03-25T12:42:25.195Z
9504770 9504770 20260317122154_TrSce KR000S 2026-03-18T12:08:50.151Z 2026-03-25T12:42:24.427Z
9504736 9504736 20260317121912_0Uxci KR000S 2026-03-18T12:08:46.212Z 2026-03-25T12:42:24.187Z
9500200 9500200 20260316175230_uqMC7 KR000S 2026-03-17T12:16:55.250Z 2026-03-24T12:41:32.876Z
9499835 9499835 20260316165622_ug3GL KR000S 2026-03-17T12:16:13.605Z 2026-03-24T12:41:31.488Z
9499669 9499669 20260316164041_rERDC KR000S 2026-03-17T12:15:59.997Z 2026-03-24T12:41:31.065Z
9499541 9499541 20260316162954_btSY5 KR000S 2026-03-17T12:15:46.017Z 2026-03-24T12:41:30.670Z
9499503 9499503 20260316162808_pHFdF KR000S 2026-03-17T12:15:42.232Z 2026-03-24T12:41:30.502Z
9499493 9499493 20260316162703_T6HBy KR000S 2026-03-17T12:15:40.365Z 2026-03-24T12:41:30.418Z

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