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,768 rows where station_code = "KR0019" 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
9271329 9271329 20260128211435_Hu2Ny KR0019 2026-01-29T14:16:04.384Z 2026-01-29T14:16:04.384Z
9271294 9271294 20260128210213_Beom7 KR0019 2026-01-29T14:15:50.948Z 2026-01-29T14:15:50.948Z
9271192 9271192 20260128202139_BLiyr KR0019 2026-01-29T14:15:32.728Z 2026-01-29T14:15:32.728Z
9271130 9271130 20260128200542_KyYzs KR0019 2026-01-29T14:15:19.917Z 2026-01-29T14:15:19.917Z
9271115 9271115 20260128200218_3lGG0 KR0019 2026-01-29T14:15:17.852Z 2026-01-29T14:15:17.852Z
9271002 9271002 20260128191907_4UiwB KR0019 2026-01-29T14:14:50.496Z 2026-01-29T14:14:50.496Z
9270953 9270953 20260128185941_a8PXF KR0019 2026-01-29T14:14:40.132Z 2026-01-29T14:14:40.132Z
9270920 9270920 20260128184943_2GAkX KR0019 2026-01-29T14:14:34.061Z 2026-01-29T14:14:34.061Z
9270864 9270864 20260128182121_sHcZK KR0019 2026-01-29T14:14:17.181Z 2026-01-29T14:14:17.181Z
9270842 9270842 20260128180524_e0xLI KR0019 2026-01-29T14:14:11.759Z 2026-01-29T14:14:11.759Z
9270794 9270794 20260128174451_sMCCp KR0019 2026-01-29T14:13:59.550Z 2026-01-29T14:13:59.550Z
9270738 9270738 20260128170757_3k2fU KR0019 2026-01-29T14:13:34.134Z 2026-01-29T14:13:34.134Z
9270145 9270145 20260128150118_E8yy7 KR0019 2026-01-29T14:11:06.004Z 2026-01-29T14:11:06.004Z
9269927 9269927 20260128143221_StdAE KR0019 2026-01-29T14:10:14.583Z 2026-01-29T14:10:14.583Z
9269701 9269701 20260128135626_R5C9R KR0019 2026-01-29T14:09:07.468Z 2026-01-29T14:09:07.468Z
9269564 9269564 20260128133547_kY1wZ KR0019 2026-01-29T14:08:29.992Z 2026-01-29T14:08:29.992Z
9268907 9268907 20260128114147_OKuYh KR0019 2026-01-29T14:05:25.783Z 2026-01-29T14:05:25.783Z
9267205 9267205 20260126203140_GP3fZ KR0019 2026-01-28T14:20:18.544Z 2026-01-29T14:34:33.904Z
9266894 9266894 20260126155442_Lx3z2 KR0019 2026-01-28T14:17:19.303Z 2026-01-29T14:33:38.281Z
9266858 9266858 20260126145232_uQNIA KR0019 2026-01-28T14:16:52.170Z 2026-01-29T14:33:19.196Z
9266816 9266816 20260127213716_W7pKC KR0019 2026-01-28T14:14:39.411Z 2026-01-29T14:30:25.223Z
9266722 9266722 20260127205443_F43CU KR0019 2026-01-28T14:14:21.990Z 2026-01-29T14:30:25.195Z
9266709 9266709 20260127205147_iTmIZ KR0019 2026-01-28T14:14:20.861Z 2026-01-29T14:30:25.188Z
9266688 9266688 20260127204006_K5vdN KR0019 2026-01-28T14:14:17.032Z 2026-01-29T14:30:25.173Z
9266599 9266599 20260127200414_f4ex2 KR0019 2026-01-28T14:14:03.058Z 2026-01-28T14:14:03.058Z
9266574 9266574 20260127195930_43fVT KR0019 2026-01-28T14:13:55.480Z 2026-01-28T14:13:55.480Z
9266551 9266551 20260127195030_qhWw1 KR0019 2026-01-28T14:13:50.185Z 2026-01-28T14:13:50.185Z
9266546 9266546 20260127194815_3zihL KR0019 2026-01-28T14:13:49.398Z 2026-01-29T14:30:25.086Z
9266534 9266534 20260127194506_miX23 KR0019 2026-01-28T14:13:47.777Z 2026-01-29T14:30:25.081Z
9266524 9266524 20260127194331_wIOU3 KR0019 2026-01-28T14:13:46.433Z 2026-01-29T14:30:25.068Z
9266482 9266482 20260127192831_kIL4i KR0019 2026-01-28T14:13:40.520Z 2026-01-29T14:30:25.039Z
9266382 9266382 20260127190611_kzoIn KR0019 2026-01-28T14:13:21.738Z 2026-01-29T14:30:25.007Z
9266334 9266334 20260127185716_a7uDA KR0019 2026-01-28T14:13:15.098Z 2026-01-29T14:30:24.998Z
9266331 9266331 20260127185440_wRR2t KR0019 2026-01-28T14:13:14.562Z 2026-01-29T14:30:24.997Z
9266324 9266324 20260127185439_4UODp KR0019 2026-01-28T14:13:14.086Z 2026-01-29T14:30:24.996Z
9266301 9266301 20260127184643_dlBz2 KR0019 2026-01-28T14:13:11.807Z 2026-01-29T14:30:24.984Z
9266244 9266244 20260127182247_hnUV0 KR0019 2026-01-28T14:12:57.168Z 2026-01-29T14:30:24.946Z
9266218 9266218 20260127180825_Chgdp KR0019 2026-01-28T14:12:53.540Z 2026-01-29T14:30:24.927Z
9266184 9266184 20260127175603_72y2E KR0019 2026-01-28T14:12:44.585Z 2026-01-29T14:30:24.906Z
9266122 9266122 20260127172733_3ile0 KR0019 2026-01-28T14:12:29.348Z 2026-01-29T14:30:24.886Z
9265958 9265958 20260127161846_jShLF KR0019 2026-01-28T14:11:51.497Z 2026-01-29T14:30:24.786Z
9265900 9265900 20260127161116_2Of15 KR0019 2026-01-28T14:11:42.910Z 2026-01-29T14:30:24.711Z
9265794 9265794 20260127160104_laj24 KR0019 2026-01-28T14:11:21.860Z 2026-01-29T14:30:24.677Z
9265687 9265687 20260127154916_2dIkc KR0019 2026-01-28T14:10:59.603Z 2026-01-29T14:30:24.654Z
9265230 9265230 20260127144344_5XOu2 KR0019 2026-01-28T14:09:34.157Z 2026-01-29T14:30:24.509Z
9264955 9264955 20260127134104_3v7WH KR0019 2026-01-28T14:08:21.883Z 2026-01-29T14:30:24.398Z
9263333 9263333 20260124180704_gfFuC KR0019 2026-01-27T14:21:19.061Z 2026-01-29T14:42:20.643Z
9263253 9263253 20260124152104_jq73k KR0019 2026-01-27T14:20:10.446Z 2026-01-29T14:41:43.706Z
9263206 9263206 20260124133207_Adj5u KR0019 2026-01-27T14:19:23.287Z 2026-01-29T14:41:14.943Z
9263176 9263176 20260125203455_283wi KR0019 2026-01-27T14:17:21.075Z 2026-01-29T14:38:22.725Z
9262482 9262482 20260126211851_AMbcI KR0019 2026-01-27T14:09:18.468Z 2026-01-29T14:34:44.043Z
9262461 9262461 20260126205050_YJHah KR0019 2026-01-27T14:09:12.602Z 2026-01-29T14:34:36.185Z
9259560 9259560 20260124212809_n2f24 KR0019 2026-01-26T14:17:27.892Z 2026-01-29T14:43:06.094Z
9259553 9259553 20260124212458_Vm3gR KR0019 2026-01-26T14:17:26.391Z 2026-01-29T14:43:05.556Z
9259509 9259509 20260124211301_SwMiS KR0019 2026-01-26T14:17:20.325Z 2026-01-29T14:42:57.813Z
9259505 9259505 20260124211108_1zrlK KR0019 2026-01-26T14:17:19.565Z 2026-01-29T14:42:57.632Z
9259498 9259498 20260124211037_3owLQ KR0019 2026-01-26T14:17:18.076Z 2026-01-29T14:42:57.288Z
9259467 9259467 20260124205728_mPrZS KR0019 2026-01-26T14:17:07.168Z 2026-01-29T14:42:56.201Z
9259446 9259446 20260124205350_QxfhR KR0019 2026-01-26T14:17:01.716Z 2026-01-29T14:42:55.222Z
9259443 9259443 20260124205350_hYITu KR0019 2026-01-26T14:17:01.074Z 2026-01-29T14:42:55.018Z
9259398 9259398 20260124204119_8sBQA KR0019 2026-01-26T14:16:52.763Z 2026-01-29T14:42:51.207Z
9259357 9259357 20260124203220_9XaAn KR0019 2026-01-26T14:16:41.849Z 2026-01-29T14:42:49.630Z
9259333 9259333 20260124202738_pG40n KR0019 2026-01-26T14:16:33.529Z 2026-01-29T14:42:48.522Z
9259280 9259280 20260124200701_Yx92n KR0019 2026-01-26T14:16:25.736Z 2026-01-29T14:42:45.940Z
9259260 9259260 20260124200243_3K3l9 KR0019 2026-01-26T14:16:22.881Z 2026-01-29T14:42:45.244Z
9259225 9259225 20260124194438_B1SYM KR0019 2026-01-26T14:16:11.704Z 2026-01-29T14:42:43.190Z
9259219 9259219 20260124194402_RSMO0 KR0019 2026-01-26T14:16:11.115Z 2026-01-29T14:42:43.024Z
9259194 9259194 20260124193640_HMEgV KR0019 2026-01-26T14:16:04.089Z 2026-01-29T14:42:41.988Z
9259153 9259153 20260124190958_XzalX KR0019 2026-01-26T14:15:54.958Z 2026-01-29T14:42:39.179Z
9259076 9259076 20260124184013_7uT2X KR0019 2026-01-26T14:15:35.805Z 2026-01-29T14:42:29.553Z
9259071 9259071 20260124183709_4e3ZF KR0019 2026-01-26T14:15:34.679Z 2026-01-29T14:42:29.111Z
9259042 9259042 20260124183238_UnLjS KR0019 2026-01-26T14:15:31.062Z 2026-01-29T14:42:27.691Z
9258968 9258968 20260124181534_j7izv KR0019 2026-01-26T14:15:13.590Z 2026-01-26T14:23:12.931Z
9258919 9258919 20260124180129_wSt5t KR0019 2026-01-26T14:15:01.689Z 2026-01-29T14:42:19.334Z
9258778 9258778 20260124165827_yiTmY KR0019 2026-01-26T14:14:23.723Z 2026-01-29T14:42:09.192Z
9258763 9258763 20260124164857_YnM85 KR0019 2026-01-26T14:14:19.537Z 2026-01-29T14:42:06.894Z
9258754 9258754 20260124163950_c8Xhr KR0019 2026-01-26T14:14:13.044Z 2026-01-29T14:42:00.745Z
9258654 9258654 20260124154446_GoWQy KR0019 2026-01-26T14:13:39.420Z 2026-01-29T14:41:48.421Z
9258637 9258637 20260124152904_qmpZX KR0019 2026-01-26T14:13:31.977Z 2026-01-29T14:41:44.827Z
9258628 9258628 20260124152104_1GRcY KR0019 2026-01-26T14:13:29.437Z 2026-01-26T14:23:12.812Z
9258457 9258457 20260124130649_rVq7F KR0019 2026-01-26T14:12:12.136Z 2026-01-29T14:41:03.669Z
9258393 9258393 20260124112237_tG2v2 KR0019 2026-01-26T14:11:30.085Z 2026-01-29T14:40:45.622Z
9258265 9258265 20260125203147_l5J4k KR0019 2026-01-26T14:10:17.394Z 2026-01-29T14:38:22.341Z
9258259 9258259 20260125202227_CFZJg KR0019 2026-01-26T14:10:16.077Z 2026-01-29T14:38:20.306Z
9258237 9258237 20260125200341_yXhoU KR0019 2026-01-26T14:10:09.363Z 2026-01-29T14:38:12.958Z
9258197 9258197 20260125193208_bCGTI KR0019 2026-01-26T14:09:59.629Z 2026-01-29T14:38:07.627Z
9258140 9258140 20260125190451_0S8qI KR0019 2026-01-26T14:09:43.809Z 2026-01-29T14:38:05.180Z
9258098 9258098 20260125183643_QLKcA KR0019 2026-01-26T14:09:35.206Z 2026-01-29T14:38:02.814Z
9258073 9258073 20260125182849_iMn7N KR0019 2026-01-26T14:09:25.981Z 2026-01-29T14:38:01.895Z
9257939 9257939 20260125171357_i6wOB KR0019 2026-01-26T14:08:41.673Z 2026-01-29T14:37:54.191Z
9257904 9257904 20260125170614_6WVm5 KR0019 2026-01-26T14:08:30.890Z 2026-01-29T14:37:52.564Z
9257898 9257898 20260125170443_Cy3Mh KR0019 2026-01-26T14:08:30.161Z 2026-01-29T14:37:52.185Z
9257861 9257861 20260125162942_3mruR KR0019 2026-01-26T14:08:12.653Z 2026-01-29T14:37:45.434Z
9257688 9257688 20260125152606_jCmqI KR0019 2026-01-26T14:07:16.831Z 2026-01-29T14:37:35.140Z
9257686 9257686 20260125152606_4yoPF KR0019 2026-01-26T14:07:15.845Z 2026-01-29T14:37:35.008Z
9257290 9257290 20260125124207_YxEh3 KR0019 2026-01-26T14:04:36.220Z 2026-01-29T14:37:04.021Z
9256999 9256999 20260125113303_rUSCh KR0019 2026-01-26T14:03:08.877Z 2026-01-29T14:36:40.975Z
9256798 9256798 20260125103311_F77lG KR0019 2026-01-26T14:02:05.018Z 2026-01-29T14:36:24.827Z
9256775 9256775 20260125102339_EQFE8 KR0019 2026-01-26T14:01:55.828Z 2026-01-29T14:36:23.701Z
9251599 9251599 20260122212347_nu1V0 KR0019 2026-01-24T14:12:33.315Z 2026-01-29T14:51:52.018Z

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