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

6,643 rows where station_code = "KR003J" 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
9271855 9271855 20260127210904_hBdPu KR003J 2026-01-29T14:24:35.568Z 2026-01-29T14:30:25.214Z
9271571 9271571 20260127180400_I64K3 KR003J 2026-01-29T14:21:34.109Z 2026-01-29T14:30:24.924Z
9271524 9271524 20260127172733_VGtJ9 KR003J 2026-01-29T14:21:09.521Z 2026-01-29T14:30:24.886Z
9267244 9267244 20260126211851_DLCaa KR003J 2026-01-28T14:20:39.424Z 2026-01-29T14:34:43.904Z
9267230 9267230 20260126205050_9YFCJ KR003J 2026-01-28T14:20:26.882Z 2026-01-29T14:34:36.062Z
9267220 9267220 20260126204251_dQjU3 KR003J 2026-01-28T14:20:23.395Z 2026-01-29T14:34:35.218Z
9267207 9267207 20260126203140_GP3fZ KR003J 2026-01-28T14:20:18.544Z 2026-01-29T14:34:33.904Z
9267181 9267181 20260126201720_uG3Vv KR003J 2026-01-28T14:20:03.427Z 2026-01-29T14:34:28.981Z
9267127 9267127 20260126193524_O3OMB KR003J 2026-01-28T14:19:27.482Z 2026-01-29T14:34:21.525Z
9267122 9267122 20260126193123_HSURs KR003J 2026-01-28T14:19:24.909Z 2026-01-29T14:34:20.564Z
9267075 9267075 20260126184157_EFasm KR003J 2026-01-28T14:18:56.160Z 2026-01-29T14:34:13.485Z
9267046 9267046 20260126182603_G86Ag KR003J 2026-01-28T14:18:40.311Z 2026-01-29T14:34:02.270Z
9267012 9267012 20260126174752_0ogw2 KR003J 2026-01-28T14:18:16.032Z 2026-01-29T14:33:54.533Z
9267004 9267004 20260126174555_WvwDk KR003J 2026-01-28T14:18:13.644Z 2026-01-29T14:33:53.671Z
9263379 9263379 20260124211641_WNsXP KR003J 2026-01-27T14:22:14.703Z 2026-01-29T14:43:04.281Z
9263348 9263348 20260124183824_kJv0L KR003J 2026-01-27T14:21:30.146Z 2026-01-29T14:42:29.394Z
9263334 9263334 20260124180704_gfFuC KR003J 2026-01-27T14:21:19.061Z 2026-01-29T14:42:20.643Z
9263254 9263254 20260124152104_jq73k KR003J 2026-01-27T14:20:10.446Z 2026-01-29T14:41:43.706Z
9263241 9263241 20260124144437_EdPzv KR003J 2026-01-27T14:19:54.183Z 2026-01-29T14:41:31.246Z
9263235 9263235 20260124143521_xThsZ KR003J 2026-01-27T14:19:50.851Z 2026-01-29T14:41:27.226Z
9263230 9263230 20260124142400_lBF0r KR003J 2026-01-27T14:19:43.707Z 2026-01-29T14:41:24.118Z
9263180 9263180 20260125204522_sRa8z KR003J 2026-01-27T14:17:21.570Z 2026-01-29T14:38:24.178Z
9263177 9263177 20260125203455_283wi KR003J 2026-01-27T14:17:21.075Z 2026-01-29T14:38:22.725Z
9263164 9263164 20260125190348_lUGhc KR003J 2026-01-27T14:17:19.091Z 2026-01-29T14:38:04.864Z
9263157 9263157 20260125171357_Xq6Fk KR003J 2026-01-27T14:17:17.133Z 2026-01-29T14:37:54.048Z
9263155 9263155 20260125170354_e0iVI KR003J 2026-01-27T14:17:16.613Z 2026-01-29T14:37:47.137Z
9254791 9254791 20260123212359_PJxQd KR003J 2026-01-25T14:10:45.761Z 2026-01-29T14:46:42.847Z
9254650 9254650 20260123203848_QTJ2i KR003J 2026-01-25T14:10:15.141Z 2026-01-29T14:46:33.883Z
9251603 9251603 20260122212602_sNUaI KR003J 2026-01-24T14:12:34.068Z 2026-01-29T14:51:52.217Z
9251600 9251600 20260122212347_nu1V0 KR003J 2026-01-24T14:12:33.315Z 2026-01-29T14:51:52.018Z
9251589 9251589 20260122211906_XfW9H KR003J 2026-01-24T14:12:30.908Z 2026-01-29T14:51:51.574Z
9251556 9251556 20260122205911_mr8lD KR003J 2026-01-24T14:12:14.322Z 2026-01-29T14:51:48.555Z
9251491 9251491 20260122202823_aBJ0u KR003J 2026-01-24T14:11:53.425Z 2026-01-29T14:51:44.147Z
9251474 9251474 20260122202532_KP6Rn KR003J 2026-01-24T14:11:51.299Z 2026-01-29T14:51:43.443Z
9251467 9251467 20260122202407_jXHyF KR003J 2026-01-24T14:11:49.959Z 2026-01-29T14:51:43.157Z
9251449 9251449 20260122201652_28utS KR003J 2026-01-24T14:11:46.656Z 2026-01-29T14:51:42.183Z
9251441 9251441 20260122201511_eNIWQ KR003J 2026-01-24T14:11:45.309Z 2026-01-29T14:51:41.702Z
9251400 9251400 20260122200153_PAsP4 KR003J 2026-01-24T14:11:36.611Z 2026-01-29T14:51:39.004Z
9251277 9251277 20260122192928_LcBrz KR003J 2026-01-24T14:11:06.047Z 2026-01-29T14:51:26.259Z
9251270 9251270 20260122192420_WuLG2 KR003J 2026-01-24T14:11:03.085Z 2026-01-29T14:51:23.504Z
9251266 9251266 20260122192341_dnqfx KR003J 2026-01-24T14:11:00.310Z 2026-01-29T14:51:22.928Z
9251148 9251148 20260122184320_tn2mD KR003J 2026-01-24T14:10:17.417Z 2026-01-29T14:51:13.611Z
9251143 9251143 20260122184050_lIkCR KR003J 2026-01-24T14:10:15.416Z 2026-01-29T14:51:12.888Z
9251092 9251092 20260122182549_rbxd7 KR003J 2026-01-24T14:09:57.334Z 2026-01-29T14:51:09.488Z
9251072 9251072 20260122181911_R336Q KR003J 2026-01-24T14:09:50.901Z 2026-01-29T14:51:02.628Z
9251047 9251047 20260122175755_XatTF KR003J 2026-01-24T14:09:37.026Z 2026-01-29T14:50:57.008Z
9250996 9250996 20260122174232_dwzjR KR003J 2026-01-24T14:09:19.002Z 2026-01-29T14:50:51.825Z
9250985 9250985 20260122174117_4vimU KR003J 2026-01-24T14:09:13.857Z 2026-01-29T14:50:51.127Z
9250962 9250962 20260122173430_saB2B KR003J 2026-01-24T14:09:09.147Z 2026-01-29T14:50:50.189Z
9250954 9250954 20260122173057_xQZUR KR003J 2026-01-24T14:09:04.142Z 2026-01-29T14:50:49.275Z
9250941 9250941 20260122172551_e0gnU KR003J 2026-01-24T14:09:00.011Z 2026-01-29T14:50:48.138Z
9250863 9250863 20260122161612_LRW6c KR003J 2026-01-24T14:08:14.188Z 2026-01-29T14:50:40.326Z
9250851 9250851 20260122161144_UOlUS KR003J 2026-01-24T14:08:07.626Z 2026-01-29T14:50:39.276Z
9250806 9250806 20260122151806_bIvij KR003J 2026-01-24T14:07:30.153Z 2026-01-29T14:50:20.915Z
9250722 9250722 20260122132701_PGt3D KR003J 2026-01-24T14:06:06.946Z 2026-01-29T14:49:51.802Z
9250680 9250680 20260122121557_B1cNL KR003J 2026-01-24T14:05:12.362Z 2026-01-29T14:49:31.641Z
9250666 9250666 20260122121321_YzviZ KR003J 2026-01-24T14:05:09.147Z 2026-01-29T14:49:30.387Z
9250657 9250657 20260122120116_oYfjN KR003J 2026-01-24T14:05:03.020Z 2026-01-29T14:49:28.360Z
9247945 9247945 20260121203911_UcbkG KR003J 2026-01-23T14:11:35.734Z 2026-01-29T14:56:45.015Z
9247787 9247787 20260121194654_kYDbO KR003J 2026-01-23T14:11:07.693Z 2026-01-29T14:56:37.409Z
9247595 9247595 20260121191141_uYYy3 KR003J 2026-01-23T14:10:33.081Z 2026-01-29T14:56:16.468Z
9247434 9247434 20260121182923_ADxRQ KR003J 2026-01-23T14:10:03.076Z 2026-01-29T14:56:08.330Z
9246863 9246863 20260121150617_6gs3Y KR003J 2026-01-23T14:08:08.807Z 2026-01-29T14:55:15.053Z
9246508 9246508 20260121104527_xP9d6 KR003J 2026-01-23T14:06:32.036Z 2026-01-29T14:54:15.192Z
9241644 9241644 20260120212323_SMPBE KR003J 2026-01-22T14:13:59.230Z 2026-01-29T15:02:56.121Z
9240744 9240744 20260120173821_dUEEV KR003J 2026-01-22T14:09:49.131Z 2026-01-29T15:01:52.883Z
9240675 9240675 20260120172126_uEN15 KR003J 2026-01-22T14:09:28.474Z 2026-01-29T15:01:38.149Z
9217994 9217994 20260116212553_V38ul KR003J 2026-01-18T14:09:53.273Z 2026-01-25T14:57:54.302Z
9212045 9212045 20260115185245_Lo029 KR003J 2026-01-17T14:09:41.190Z 2026-01-24T15:10:20.762Z
9211867 9211867 20260115181052_5TaXI KR003J 2026-01-17T14:08:50.639Z 2026-01-24T15:10:07.114Z
9211684 9211684 20260115171541_Qq4qq KR003J 2026-01-17T14:07:55.569Z 2026-01-24T15:09:45.996Z
9211629 9211629 20260115170031_WYLjA KR003J 2026-01-17T14:07:34.374Z 2026-01-24T15:09:41.817Z
9211610 9211610 20260115165345_qjzyI KR003J 2026-01-17T14:07:29.352Z 2026-01-24T15:09:39.302Z
9211591 9211591 20260115164420_n8wSh KR003J 2026-01-17T14:07:24.805Z 2026-01-24T15:09:37.848Z
9211428 9211428 20260115153325_GCZP5 KR003J 2026-01-17T14:06:35.883Z 2026-01-24T15:09:14.062Z
9211409 9211409 20260115152211_fiBPS KR003J 2026-01-17T14:06:30.649Z 2026-01-24T15:09:12.580Z
9211289 9211289 20260115142752_Qr1Wc KR003J 2026-01-17T14:05:58.929Z 2026-01-24T15:09:00.325Z
9205627 9205627 20260113100042_wR37s KR003J 2026-01-15T14:39:30.437Z 2026-01-21T15:06:13.103Z
9199600 9199600 20260113203416_HLKAh KR003J 2026-01-15T14:11:36.137Z 2026-01-22T15:07:47.240Z
9199568 9199568 20260113202917_VMHrh KR003J 2026-01-15T14:11:30.765Z 2026-01-22T15:07:32.153Z
9199543 9199543 20260113201923_Gjp82 KR003J 2026-01-15T14:11:25.225Z 2026-01-22T15:07:26.448Z
9199507 9199507 20260113201253_hYH5o KR003J 2026-01-15T14:11:14.949Z 2026-01-22T15:07:25.643Z
9199499 9199499 20260113201101_0h7Xr KR003J 2026-01-15T14:11:13.067Z 2026-01-22T15:07:25.433Z
9199490 9199490 20260113200703_RapzE KR003J 2026-01-15T14:11:04.755Z 2026-01-22T15:07:25.216Z
9199380 9199380 20260113195441_6D460 KR003J 2026-01-15T14:10:39.220Z 2026-01-22T15:07:23.186Z
9199316 9199316 20260113194405_3MGT4 KR003J 2026-01-15T14:10:20.722Z 2026-01-22T15:07:21.432Z
9199304 9199304 20260113194300_U0VGY KR003J 2026-01-15T14:10:18.826Z 2026-01-22T15:07:20.916Z
9199239 9199239 20260113193246_T2Ulf KR003J 2026-01-15T14:10:04.919Z 2026-01-22T15:07:17.775Z
9198904 9198904 20260113182750_iVElp KR003J 2026-01-15T14:08:06.342Z 2026-01-22T15:07:08.569Z
9198828 9198828 20260113181138_7U6EU KR003J 2026-01-15T14:07:32.112Z 2026-01-22T15:07:05.843Z
9198753 9198753 20260113175154_rBK09 KR003J 2026-01-15T14:06:54.706Z 2026-01-22T15:07:03.057Z
9198715 9198715 20260113174229_8NNmJ KR003J 2026-01-15T14:06:41.486Z 2026-01-22T15:07:01.674Z
9198698 9198698 20260113173845_3V2kC KR003J 2026-01-15T14:06:32.707Z 2026-01-22T15:07:01.154Z
9198682 9198682 20260113173451_j8x5w KR003J 2026-01-15T14:06:23.927Z 2026-01-22T15:07:00.617Z
9198639 9198639 20260113172504_r2C6g KR003J 2026-01-15T14:06:02.045Z 2026-01-22T15:06:59.368Z
9198631 9198631 20260113172217_gxkp2 KR003J 2026-01-15T14:06:00.137Z 2026-01-22T15:06:59.170Z
9198629 9198629 20260113171836_WP7Vi KR003J 2026-01-15T14:05:55.936Z 2026-01-22T15:06:58.722Z
9198586 9198586 20260113171139_3fqmm KR003J 2026-01-15T14:05:40.127Z 2026-01-22T15:06:41.968Z
9198553 9198553 20260113170500_Pz953 KR003J 2026-01-15T14:05:27.248Z 2026-01-22T15:06:34.123Z
9198376 9198376 20260113160509_35fRi KR003J 2026-01-15T14:03:45.208Z 2026-01-22T15:06:25.150Z

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