us-weather-history/KCQT: 23

This table contains data and code behind the story What 12 Months Of Record-Setting Temperatures Looks Like Across The U.S..

Code

Code file	Description
`wunderground_scraper.py`	Downloads weather data web pages from Weather Underground
`wunderground_parser.py`	Parses the weather data from Weather Underground into a flat CSV file
`visualize_weather.py`	Creates the visualization of the weather data

Data

Column	Description
`date`	The date of the weather record, formatted YYYY-M-D
`actual_mean_temp`	The measured average temperature for that day
`actual_min_temp`	The measured minimum temperature for that day
`actual_max_temp`	The measured maximum temperature for that day
`average_min_temp`	The average minimum temperature on that day since 1880
`average_max_temp`	The average maximum temperature on that day since 1880
`record_min_temp`	The lowest ever temperature on that day since 1880
`record_max_temp`	The highest ever temperature on that day since 1880
`record_min_temp_year`	The year that the lowest ever temperature occurred
`record_max_temp_year`	The year that the highest ever temperature occurred
`actual_precipitation`	The measured amount of rain or snow for that day
`average_precipitation`	The average amount of rain or snow on that day since 1880
`record_precipitation`	The highest amount of rain or snow on that day since 1880

Source: Weather Underground

Data source: https://github.com/fivethirtyeight/data/blob/master/us-weather-history/KCQT.csv

This data as json, copyable

rowid	date	actual_mean_temp	actual_min_temp	actual_max_temp	average_min_temp	average_max_temp	record_min_temp	record_max_temp	record_min_temp_year	record_max_temp_year	actual_precipitation	average_precipitation	record_precipitation
23	2014-7-23	77	65	88	64	84	53	97	1903	1890	0.0	0.0	0.08