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

3,966 rows where station_code = "KR003V" 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
9271545 9271545 20260127174849_wa6OT KR003V 2026-01-29T14:21:16.395Z 2026-01-29T14:30:24.901Z
9271322 9271322 20260128211123_cyq2j KR003V 2026-01-29T14:16:02.154Z 2026-01-29T14:16:02.154Z
9271223 9271223 20260128202653_hF55h KR003V 2026-01-29T14:15:36.885Z 2026-01-29T14:15:36.885Z
9271220 9271220 20260128202641_mHkWQ KR003V 2026-01-29T14:15:36.404Z 2026-01-29T14:15:36.404Z
9271094 9271094 20260128195420_SI3aN KR003V 2026-01-29T14:15:10.993Z 2026-01-29T14:15:10.993Z
9270961 9270961 20260128190351_bdwku KR003V 2026-01-29T14:14:40.607Z 2026-01-29T14:14:40.607Z
9270135 9270135 20260128150019_5TGh1 KR003V 2026-01-29T14:10:58.602Z 2026-01-29T14:10:58.602Z
9269372 9269372 20260128130907_ynzgm KR003V 2026-01-29T14:07:40.407Z 2026-01-29T14:07:40.407Z
9269242 9269242 20260128125018_EhU2f KR003V 2026-01-29T14:07:05.261Z 2026-01-29T14:07:05.261Z
9267247 9267247 20260126213047_mLTck KR003V 2026-01-28T14:20:41.439Z 2026-01-29T14:34:44.541Z
9267133 9267133 20260126193916_0KFE2 KR003V 2026-01-28T14:19:36.037Z 2026-01-29T14:34:22.995Z
9267088 9267088 20260126184931_fxgnZ KR003V 2026-01-28T14:19:07.067Z 2026-01-29T14:34:15.616Z
9267066 9267066 20260126183703_9UvO3 KR003V 2026-01-28T14:18:49.829Z 2026-01-29T14:34:11.924Z
9267048 9267048 20260126182603_G86Ag KR003V 2026-01-28T14:18:40.311Z 2026-01-29T14:34:02.270Z
9267031 9267031 20260126181230_516dW KR003V 2026-01-28T14:18:26.111Z 2026-01-29T14:33:59.231Z
9266920 9266920 20260126162910_e2PM2 KR003V 2026-01-28T14:17:39.561Z 2026-01-29T14:33:44.414Z
9266426 9266426 20260127191948_HVOo3 KR003V 2026-01-28T14:13:32.768Z 2026-01-28T14:13:32.768Z
9266367 9266367 20260127185926_e4ixX KR003V 2026-01-28T14:13:19.073Z 2026-01-28T14:13:19.073Z
9266336 9266336 20260127185716_a7uDA KR003V 2026-01-28T14:13:15.098Z 2026-01-29T14:30:24.998Z
9266285 9266285 20260127183634_YXYFl KR003V 2026-01-28T14:13:09.611Z 2026-01-29T14:30:24.974Z
9266167 9266167 20260127174849_1Dxht KR003V 2026-01-28T14:12:41.396Z 2026-01-28T14:12:41.396Z
9266100 9266100 20260127172055_giEd9 KR003V 2026-01-28T14:12:25.447Z 2026-01-29T14:30:24.869Z
9266052 9266052 20260127165656_Dvw3l KR003V 2026-01-28T14:12:16.288Z 2026-01-29T14:30:24.836Z
9264518 9264518 20260127124031_MNmrs KR003V 2026-01-28T14:06:31.385Z 2026-01-29T14:30:24.192Z
9259321 9259321 20260124201820_CrNVB KR003V 2026-01-26T14:16:30.865Z 2026-01-29T14:42:47.455Z
9259216 9259216 20260124194126_zLo7M KR003V 2026-01-26T14:16:10.631Z 2026-01-29T14:42:42.893Z
9259175 9259175 20260124192318_D9G08 KR003V 2026-01-26T14:16:00.359Z 2026-01-29T14:42:40.607Z
9258982 9258982 20260124181649_7YA2a KR003V 2026-01-26T14:15:18.152Z 2026-01-29T14:42:21.905Z
9258700 9258700 20260124160739_rQXV6 KR003V 2026-01-26T14:13:56.925Z 2026-01-29T14:41:53.055Z
9258573 9258573 20260124144750_2H4pt KR003V 2026-01-26T14:13:05.422Z 2026-01-29T14:41:31.511Z
9258449 9258449 20260124130221_Tdusn KR003V 2026-01-26T14:12:10.420Z 2026-01-29T14:41:02.889Z
9258123 9258123 20260125185939_kPnDn KR003V 2026-01-26T14:09:40.126Z 2026-01-26T14:09:40.126Z
9257997 9257997 20260125174654_2EvRc KR003V 2026-01-26T14:09:01.928Z 2026-01-26T14:09:01.928Z
9257915 9257915 20260125170622_EteaI KR003V 2026-01-26T14:08:33.849Z 2026-01-26T14:08:33.849Z
9257881 9257881 20260125164356_6uq4E KR003V 2026-01-26T14:08:18.473Z 2026-01-26T14:08:18.473Z
9257773 9257773 20260125155325_FVcdD KR003V 2026-01-26T14:07:40.983Z 2026-01-29T14:37:39.026Z
9254781 9254781 20260123211811_e2f3q KR003V 2026-01-25T14:10:43.367Z 2026-01-29T14:46:42.397Z
9254767 9254767 20260123211259_lQY4k KR003V 2026-01-25T14:10:40.200Z 2026-01-29T14:46:41.644Z
9254718 9254718 20260123210228_0toWU KR003V 2026-01-25T14:10:27.756Z 2026-01-29T14:46:37.433Z
9254608 9254608 20260123202055_aI6hh KR003V 2026-01-25T14:10:02.191Z 2026-01-29T14:46:32.121Z
9254553 9254553 20260123201045_iWlEm KR003V 2026-01-25T14:09:47.697Z 2026-01-29T14:46:29.952Z
9254438 9254438 20260123191754_ZhK5D KR003V 2026-01-25T14:09:08.628Z 2026-01-29T14:46:23.609Z
9251590 9251590 20260122211906_XfW9H KR003V 2026-01-24T14:12:30.908Z 2026-01-29T14:51:51.574Z
9251545 9251545 20260122205039_n2acD KR003V 2026-01-24T14:12:12.519Z 2026-01-29T14:51:47.978Z
9251468 9251468 20260122202407_jXHyF KR003V 2026-01-24T14:11:49.959Z 2026-01-29T14:51:43.157Z
9251374 9251374 20260122195137_VuCr1 KR003V 2026-01-24T14:11:28.624Z 2026-01-29T14:51:37.601Z
9251149 9251149 20260122184320_tn2mD KR003V 2026-01-24T14:10:17.417Z 2026-01-29T14:51:13.611Z
9251048 9251048 20260122175755_XatTF KR003V 2026-01-24T14:09:37.027Z 2026-01-29T14:50:57.008Z
9250979 9250979 20260122174054_r4n3O KR003V 2026-01-24T14:09:13.175Z 2026-01-29T14:50:51.015Z
9250918 9250918 20260122170545_RPTtT KR003V 2026-01-24T14:08:45.834Z 2026-01-29T14:50:45.873Z
9250912 9250912 20260122170044_nCmiU KR003V 2026-01-24T14:08:43.882Z 2026-01-29T14:50:45.300Z
9250895 9250895 20260122164007_fcGJp KR003V 2026-01-24T14:08:35.950Z 2026-01-29T14:50:43.555Z
9250876 9250876 20260122162528_9jY1Z KR003V 2026-01-24T14:08:22.815Z 2026-01-29T14:50:41.801Z
9250681 9250681 20260122121557_B1cNL KR003V 2026-01-24T14:05:12.362Z 2026-01-29T14:49:31.641Z
9250651 9250651 20260122115530_dDu2u KR003V 2026-01-24T14:04:57.900Z 2026-01-29T14:49:25.568Z
9250649 9250649 20260122114829_u7QhG KR003V 2026-01-24T14:04:52.677Z 2026-01-29T14:49:24.341Z
9248112 9248112 20260121213546_B4TsW KR003V 2026-01-23T14:11:57.908Z 2026-01-29T14:56:55.178Z
9248095 9248095 20260121213014_P4Xgv KR003V 2026-01-23T14:11:55.260Z 2026-01-29T14:56:54.152Z
9248078 9248078 20260121212458_uqvci KR003V 2026-01-23T14:11:51.163Z 2026-01-29T14:56:53.458Z
9247908 9247908 20260121202834_I8de7 KR003V 2026-01-23T14:11:25.488Z 2026-01-29T14:56:43.282Z
9247788 9247788 20260121194654_kYDbO KR003V 2026-01-23T14:11:07.694Z 2026-01-29T14:56:37.409Z
9247741 9247741 20260121194137_y3Qaa KR003V 2026-01-23T14:11:01.271Z 2026-01-29T14:56:35.046Z
9247634 9247634 20260121192046_j29QO KR003V 2026-01-23T14:10:38.268Z 2026-01-29T14:56:20.937Z
9247596 9247596 20260121191141_uYYy3 KR003V 2026-01-23T14:10:33.081Z 2026-01-29T14:56:16.468Z
9247497 9247497 20260121184747_W2hHx KR003V 2026-01-23T14:10:11.903Z 2026-01-29T14:56:11.809Z
9247456 9247456 20260121183445_RTxWV KR003V 2026-01-23T14:10:06.526Z 2026-01-29T14:56:09.677Z
9247450 9247450 20260121183322_pKC7E KR003V 2026-01-23T14:10:05.639Z 2026-01-29T14:56:09.410Z
9247294 9247294 20260121175425_wLPiq KR003V 2026-01-23T14:09:36.967Z 2026-01-29T14:56:02.509Z
9247119 9247119 20260121170836_gRFfa KR003V 2026-01-23T14:09:04.459Z 2026-01-29T14:55:43.441Z
9246923 9246923 20260121153728_9OLKO KR003V 2026-01-23T14:08:29.386Z 2026-01-29T14:55:20.309Z
9246859 9246859 20260121150410_69eA4 KR003V 2026-01-23T14:08:08.160Z 2026-01-29T14:55:14.864Z
9246681 9246681 20260121133417_63vkq KR003V 2026-01-23T14:07:34.255Z 2026-01-29T14:55:04.461Z
9246676 9246676 20260121133415_AEMJL KR003V 2026-01-23T14:07:33.395Z 2026-01-29T14:55:04.169Z
9246551 9246551 20260121120954_UKfsB KR003V 2026-01-23T14:07:00.469Z 2026-01-29T14:54:38.984Z
9241700 9241700 20260120213833_0uGxx KR003V 2026-01-22T14:14:10.664Z 2026-01-29T15:02:57.530Z
9241629 9241629 20260120212009_xSXc4 KR003V 2026-01-22T14:13:54.155Z 2026-01-29T15:02:55.278Z
9241573 9241573 20260120211004_WTo6v KR003V 2026-01-22T14:13:46.868Z 2026-01-29T15:02:53.687Z
9241432 9241432 20260120202709_O7crN KR003V 2026-01-22T14:13:11.919Z 2026-01-29T15:02:36.380Z
9240990 9240990 20260120184134_cOCum KR003V 2026-01-22T14:11:09.075Z 2026-01-29T15:02:08.261Z
9240875 9240875 20260120180926_U2xEA KR003V 2026-01-22T14:10:34.282Z 2026-01-29T15:01:59.897Z
9240835 9240835 20260120175918_b5xC3 KR003V 2026-01-22T14:10:19.184Z 2026-01-29T15:01:57.201Z
9240791 9240791 20260120174958_5RJIu KR003V 2026-01-22T14:10:08.134Z 2026-01-29T15:01:55.177Z
9240657 9240657 20260120171537_ttiEK KR003V 2026-01-22T14:09:20.852Z 2026-01-29T15:01:36.899Z
9240560 9240560 20260120164523_iX8ST KR003V 2026-01-22T14:08:50.910Z 2026-01-29T15:01:30.445Z
9240517 9240517 20260120163438_arKJw KR003V 2026-01-22T14:08:42.323Z 2026-01-29T15:01:29.053Z
9240478 9240478 20260120162000_VIPL2 KR003V 2026-01-22T14:08:34.038Z 2026-01-29T15:01:27.066Z
9240344 9240344 20260120152201_kYlve KR003V 2026-01-22T14:07:54.118Z 2026-01-29T15:01:18.341Z
9240054 9240054 20260120115024_rfH3h KR003V 2026-01-22T14:05:19.610Z 2026-01-29T14:59:51.489Z
9240048 9240048 20260120115023_fjrlz KR003V 2026-01-22T14:05:19.302Z 2026-01-29T14:59:51.369Z
9234063 9234063 20260119192758_LIEZr KR003V 2026-01-21T14:12:04.687Z 2026-01-28T14:57:02.910Z
9233999 9233999 20260119191018_NeXPD KR003V 2026-01-21T14:11:43.823Z 2026-01-28T14:56:57.717Z
9233947 9233947 20260119185403_DZQIa KR003V 2026-01-21T14:11:29.943Z 2026-01-28T14:56:54.850Z
9222320 9222320 20260117190555_kyUPZ KR003V 2026-01-19T14:14:15.433Z 2026-01-26T15:00:47.712Z
9222177 9222177 20260117183748_eMXKo KR003V 2026-01-19T14:13:37.823Z 2026-01-26T15:00:42.902Z
9218003 9218003 20260116213812_J0L4x KR003V 2026-01-18T14:09:55.457Z 2026-01-25T14:57:54.685Z
9217747 9217747 20260116192813_aJ8WM KR003V 2026-01-18T14:08:46.918Z 2026-01-25T14:57:46.294Z
9217743 9217743 20260116192520_73zfR KR003V 2026-01-18T14:08:45.469Z 2026-01-25T14:57:46.189Z
9217642 9217642 20260116184822_DRs6H KR003V 2026-01-18T14:08:17.942Z 2026-01-25T14:57:29.286Z
9217597 9217597 20260116182137_jPHNb KR003V 2026-01-18T14:08:07.414Z 2026-01-25T14:57:27.540Z
9211807 9211807 20260115175357_kAMfY KR003V 2026-01-17T14:08:35.583Z 2026-01-24T15:09:56.553Z

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