Wisconsin State Climatology Office
 John Young, Director & Professor Emeritus
Your climate information resource for Wisconsin
Wisconsin State Climatology Office

Wisconsin Climate Watch

Wisconsin Seasons

Past  Wisconsin Climate

Other Climate Data Links & Maps


Wisconsin Climate Impacts

Climate Change

Climate News

Climate Education & Outreach
-- Data Portal

 


Who We Are

SCO Site Map

ACCESSING WEATHER AND CLIMATE DATA
 FILES FROM
WISCONSIN STATE CLIMATOLOGY OFFICE
BY EDUCATORS

Prepared by Edward J. Hopkins, PhD,
Assistant Wisconsin State Climatologist
as of 17 April 2010


Introduction

Statewide
 

US-National


Introduction

This document identifies some of the data files that we have posted on the Wisconsin State Climatology Office website that you can use to assess the current and past climate of Wisconsin, as well as other neighboring states. 
Many of the files that have been posted are in the comma-delimited text format (as noted by the csv file name extender), which means that you can save the file and then you can import these easily into a spreadsheet environment (e.g., Excel or xls format) for data analysis.  If you have questions, please feel free to contact us.

Edward J. Hopkins
John A. Young
Lyle J. Anderson

Statewide and Divisional Data

Wisconsin has nine climate divisions, arranged according to

(Map from http://www.aos.wisc.edu/~sco/images/wis-divisions.GIF)

You can access the divisional and statewide climate data generated by the National Climatic Data Center (NCDC) for all months running from 1895 to the present for your data analysis and for generation of graphics such as found at
http://www.aos.wisc.edu/~sco/clim-history/state/graphics/WI-temp-annual.gif :

The format for these data sets includes columns that are arranged as:

Year        –   from 1895 to present,

Months    – 12 columns for data, arranged from January to December, except for snowfall data (where July-June sequence is used),

ANNUAL  – The 12-month annual average temperature or precipitation (snowfall) totals,

MAX         – Maximum monthly value for the year;

MIN           – Minimum monthly value for the year,

COUNT    – The number of monthly values for the year,

Seasonal averages (or totals) and 5-year running averages (centered on the year) for
        MAM   –Spring (March, April, May)
       JJA –  Summer (June, July, August)
       SON – Autumn  (September, October, November)
       DJF – Winter (December, January, February of following year)
       ANN (5yr) – Annual
       GRW SEA (AMJJAS) Growing Season (April through September)
        NONGRW (ONDJFM) Non-growing Season (October through
                            following March)
       WATER YEAR (Oct-Sep),
       Jan-Jun—First half of calendar year
       Jul-Dec—Second half of calendar year
       Jul-Jun –Year arranged for snow or heating season,

Multiple year Summaries:  Under the last year of data, summaries are available that include such statistics as  multi-year averages, medians, standard deviation data, extremes and counts  for the following groups of time:

1895 to present, 1901-2000, 1951-2000, 1971-2000, 1961-1990, 1951-1980,…1901-1930


 

TEMPERATURE (1895-present) :
Statewide:        --  comma-delimited  or spreadsheet 

Northwest          -- comma-delimited or spreadsheet

North central      -- comma-delimited or spreadsheet

Northeast          -- comma-delimited or spreadsheet

West central      -- comma-delimited or spreadsheet

Central               -- comma-delimited or spreadsheet

East central       -- comma-delimited or spreadsheet

Southwest         -- comma-delimited or spreadsheet

South central     -- comma-delimited or spreadsheet

Southeast         -- comma-delimited or spreadsheet

 

PRECIPITATION (1895-present) :
Statewide:         --  comma-delimited or spreadsheet

Northwest          -- comma-delimited or spreadsheet

North central      -- comma-delimited or spreadsheet

Northeast          -- comma-delimited or spreadsheet

West central      -- comma-delimited or spreadsheet

Central               -- comma-delimited or spreadsheet

East central       -- comma-delimited or spreadsheet

Southwest         -- comma-delimited or spreadsheet

South central     -- comma-delimited or spreadsheet

Southeast         -- comma-delimited or spreadsheet


 

SNOW:

MONTHLY SNOW*
Statewide:      --  comma-delimited or spreadsheet

Northwest          --comma-delimited

North central      -- comma-delimited

Northeast          -- comma-delimited

West central      -- comma-delimited

Central              -- comma-delimited

East central       -- comma-delimited

Southwest         -- comma-delimited

South central     -- comma-delimited

Southeast         -- comma-delimited

* For statewide averages, snowfall 1895-present; for divisions  – 1950 to present

Note: Data arranged according to snow season (July to June),

Palmer Drought Severity Index (PDSI)

Northwest                     -- comma-delimited

North central                 -- comma-delimited

Northeast                      -- comma-delimited

West central                 -- comma-delimited

Central                          -- comma-delimited

East central                  -- comma-delimited

Southwest                      -- comma-delimited

South central                 -- comma-delimited

Southeast                     -- comma-delimited

Statewide:                     -- comma-delimited

No five-year running means for seasons or annual.


DEGREE DAYS
(1895-present) (area weighted)
HEATING
DEGREE DAY UNITS (area weighted)
Statewide:         --  comma-delimited or spreadsheet

Northwest          -- comma-delimited

North central      --comma-delimited

Northeast          -- comma-delimited

West central      -- comma-delimited

Central              -- comma-delimited

East central       -- comma-delimited

Southwest         -- comma-delimited

South central     -- comma-delimited

Southeast         -- comma-delimited

 

COOLING DEGREE DAY UNITS   (area weighted)
Statewide:         --  comma-delimited or spreadsheet

Northwest          -- comma-delimited

North central      -- comma-delimited

Northeast          -- comma-delimited

West central      -- comma-delimited

Central              -- comma-delimited

East central       -- comma-delimited

Southwest         -- comma-delimited

South central     -- comma-delimited

Southeast         -- comma-delimited

 

1971-2000 NORMAL DATA

NORMALS: see below
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-81-7100norms-temp.csv
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-81-7100norms-precp.csv
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-81-7100norms-ddu.csv
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-81-7100norms-Snowfall.csv

Comma-delimited files containing 1971-2000 normal data for liquid equivalent precipitation in inches:
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-81-7100norms-precp.csv
along with the "normal" number of days that have precip totals exceeding, 0.01 inches (measurable), 0.10 inches, 0.50 inches and 1.00 inches.
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-precipdaysGE001.csv
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-precipdaysGE010.csv
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-precipdaysGE050.csv
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-precipdaysGE100.csv

Normal maximum, minimum and average temperatures in degrees Fahrenheit (but for a smaller number of stations):
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-81-7100norms-temp.csv

Normal heating and cooling degree days in degrees Fahrenheit
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-81-7100norms-ddu.csv

Normal monthly and seasonal snowfall in Wisconsin
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-81-7100norms-Snowfall.csv

Normal number of days that a certain threshold for snow cover is met and exceeded.
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-snwcovdays.csv
http://www.aos.wisc.edu/~sco/clim-history/sta-data/normals/WI-snwdays.csv

 
STATEWIDE EXTREMES DATA

Comma-delimited files of statewide monthly temperature extremes (1885- present):
Highest monthly temperatures: http://www.aos.wisc.edu/~sco/clim-history/state/wi-ex-t-max.csv 
Lowest monthly  temperatures: http://www.aos.wisc.edu/~sco/clim-history/state/wi-ex-t-min.csv 

Comma-delimited files of statewide monthly precipitation extremes (1885- present):
Max monthly precipitation: http://www.aos.wisc.edu/~sco/clim-history/state/wi-r-mo-max.csv 
Min monthly precipitation: http://www.aos.wisc.edu/~sco/clim-history/state/wi-r-mo-min.csv 
24-hr max precipitation: http://www.aos.wisc.edu/~sco/clim-history/state/wi-r-24h-max.csv 

Comma-delimited files of monthly snow extremes:
Max monthly snowfall: http://www.aos.wisc.edu/~sco/clim-history/state/wi-s-maxmo.csv  (1896/97- present)
Max monthly snow cover: http://www.aos.wisc.edu/~sco/clim-history/state/wi-scov-maxmo.csv  (1948/49-present)


 

US-National

Monthly and annual area-average temperature and precipitation data are available for the nine regions of the continental United States. 

Map from http://www.aos.wisc.edu/~sco/clim-history/national/usrgns_pg.gif

In addition, monthly data are available for the entire US. 

 

Data files for temperature  (1895-present)

Northeast -  comma-delimited or spreadsheet

East North Central -comma-delimited or spreadsheet

Central -- comma-delimited or spreadsheet

Southeast -- comma-delimited or spreadsheet

West North Central -- comma-delimited or spreadsheet

South -- comma-delimited or spreadsheet

Southwest -- comma-delimited or spreadsheet

Northwest -- comma-delimited or spreadsheet

West -- comma-delimited or spreadsheet

CONUS (Lower 48) -- comma-delimited or spreadsheet
 

Data files for precipitation  (1895-present)

Northeast -   comma-delimited or spreadsheet

East North Central -  comma-delimited or spreadsheet

Central --  comma-delimited or spreadsheet

Southeast --  comma-delimited or spreadsheet

West North Central --  comma-delimited or spreadsheet

South --  comma-delimited or spreadsheet

Southwest --  comma-delimited or spreadsheet

Northwest -- comma-delimited or spreadsheet

West --  comma-delimited or spreadsheet

CONUS (Lower 48) --  comma-delimited or spreadsheet