About this Dataset

Global Summary Of The Year (GSOY), Version 1

This Global Summaries dataset, known as GSOY for Yearly, contains a yearly resolution of meteorological elements from 1763 to present with updates applied weekly. The major parameters are: â average annual temperature, average annual minimum and maximum temperatures; total annual precipitation and snowfall; departure from normal of the mean temperature and total precipitation; heating and cooling degree days; number of days that temperatures and precipitation are above or below certain thresholds; extreme annual minimum and maximum temperatures; number of days with fog; and number of days with thunderstorms. The primary input data source is the Global Historical Climatology Network - Daily (GHCN-Daily) dataset. The Global Summaries datasets also include a monthly resolution of meteorological elements in the GSOM (for Monthly) dataset. See associated resources for more information. These datasets are not to be confused with "GHCN-Monthly", "Annual Summaries" or "NCDC Summary of the Month". There are unique elements that are produced globally within the GSOM and GSOY data files. There are also bias corrected temperature data in GHCN-Monthly, which are not available in GSOM and GSOY. The GSOM and GSOY datasets replace the legacy U.S. COOP Summaries (DSI-3220), and have been expanded to include non-U.S. (global) stations. U.S. COOP Summaries (DSI-3220) only includes National Weather Service (NWS) COOP Published, or "Published in CD", sites.
Organization: National Oceanic and Atmospheric Administration, Department of Commerce
Last updated: 2023-09-19T21:47:02.256476
Tags: anemometers, annual, atmosphere, atmospheric - surface - air pressure, atmospheric - surface - air temperature, atmospheric - surface - precipitation, atmospheric - surface - wind speed and direction, atmospheric pressure, atmospheric temperature, atmospheric temperature indices, atmospheric winds, barometers, cooling degree days, doc/noaa/nesdis/ncei, doc/noaa/nws, earth science, fog, freezing index, geographic region, ghcn, global historical climatology network, global land, global summaries, global summary of the year (gsoy), heating degree days, liquid precipitation, maximum/minimum temperature, national centers for environmental information, national weather service, nesdis, noaa, precipitation, precipitation amount, rain, rain gauges, rain storms, snow, solid precipitation, surface pressure, surface temperature, surface winds, thermometers, tropospheric/low level clouds (observed/analyzed), u.s. department of commerce, weather events, yearly

Tables

Table 1

@usgov.noaa_gov_global_summary_of_the_year_gsoy_version_12.table_1

50.38 kB
2 rows
78 columns

CREATE TABLE table_1 (
  "station" VARCHAR,
  "name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation" DOUBLE,
  "date" BIGINT,
  "cldd" BIGINT,
  "cldd_attributes" VARCHAR,
  "htdd" BIGINT,
  "htdd_attributes" VARCHAR,
  "dx32" BIGINT,
  "dx32_attributes" VARCHAR,
  "dx70" BIGINT,
  "dx70_attributes" VARCHAR,
  "dx90" BIGINT,
  "dx90_attributes" VARCHAR,
  "dt00" BIGINT,
  "dt00_attributes" VARCHAR,
  "dt32" BIGINT,
  "dt32_attributes" VARCHAR,
  "dp01" BIGINT,
  "dp01_attributes" VARCHAR,
  "dp05" BIGINT,
  "dp05_attributes" VARCHAR,
  "dp10" BIGINT,
  "dp10_attributes" VARCHAR,
  "fzf2" DOUBLE,
  "fzf2_attributes" DOUBLE,
  "fzf1" BIGINT,
  "fzf1_attributes" VARCHAR,
  "fzf0" BIGINT,
  "fzf0_attributes" VARCHAR,
  "fzf9" BIGINT,
  "fzf9_attributes" VARCHAR,
  "fzf8" BIGINT,
  "fzf8_attributes" VARCHAR,
  "fzf7" BIGINT,
  "fzf7_attributes" VARCHAR,
  "fzf6" BIGINT,
  "fzf6_attributes" VARCHAR,
  "fzf5" BIGINT,
  "fzf5_attributes" VARCHAR,
  "emxp" DOUBLE,
  "emxp_attributes" VARCHAR,
  "emsd" DOUBLE,
  "emsd_attributes" VARCHAR,
  "emsn" DOUBLE,
  "emsn_attributes" VARCHAR,
  "dsnd" BIGINT,
  "dsnd_attributes" VARCHAR,
  "dsnw" BIGINT,
  "dsnw_attributes" VARCHAR,
  "prcp" DOUBLE,
  "prcp_attributes" VARCHAR,
  "snow" DOUBLE,
  "snow_attributes" VARCHAR,
  "cdsd" BIGINT,
  "cdsd_attributes" VARCHAR,
  "emxt" BIGINT,
  "emxt_attributes" VARCHAR,
  "emnt" BIGINT,
  "emnt_attributes" VARCHAR,
  "hdsd" BIGINT,
  "hdsd_attributes" VARCHAR,
  "tmax" BIGINT,
  "tmax_attributes" VARCHAR,
  "tmin" BIGINT,
  "tmin_attributes" VARCHAR,
  "awnd" DOUBLE,
  "awnd_attributes" VARCHAR,
  "wdf2" DOUBLE,
  "wdf2_attributes" VARCHAR,
  "wdf5" DOUBLE,
  "wdf5_attributes" VARCHAR,
  "wsf2" DOUBLE,
  "wsf2_attributes" VARCHAR,
  "wsf5" DOUBLE,
  "wsf5_attributes" VARCHAR
);