U.S. Weather History: KCQT.csv

Table actions

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 license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

14 rows where record_min_temp = 41

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: actual_mean_temp, actual_min_temp, actual_max_temp, average_min_temp, average_max_temp, record_max_temp, record_min_temp_year, record_max_temp_year, average_precipitation, record_precipitation, date (date)

Link 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
115 115 2014-10-23 73 60 85 57 78 41 98 1892 1965 0.0 0.03 1.87
119 119 2014-10-27 70 62 77 57 77 41 99 1886 1890 0.0 0.03 1.37
122 122 2014-10-30 71 60 81 56 77 41 99 1971 1939 0.0 0.03 1.02
126 126 2014-11-3 65 52 77 55 76 41 97 1886 2010 0.0 0.02 0.35
128 128 2014-11-5 69 53 85 55 75 41 94 1881 1898 0.0 0.03 0.56
130 130 2014-11-7 75 60 89 54 75 41 97 1890 2006 0.0 0.03 3.85
254 254 2015-3-11 67 60 73 51 70 41 93 1969 1916 0.0 0.09 1.45
272 272 2015-3-29 67 56 78 52 71 41 99 1880 1879 0.0 0.05 1.04
284 284 2015-4-10 63 54 71 53 72 41 96 1927 1904 0.0 0.04 0.63
287 287 2015-4-13 67 58 75 53 73 41 99 1893 1898 0.0 0.02 0.49
301 301 2015-4-27 70 57 82 55 74 41 102 1900 2004 0.0 0.02 0.82
302 302 2015-4-28 77 61 92 55 74 41 96 1900 2008 0.0 0.03 1.02
305 305 2015-5-1 71 57 84 56 74 41 92 1915 2014 0.0 0.02 0.76
327 327 2015-5-23 64 57 71 58 75 41 92 1881 1932 0.0 0.01 0.1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "us-weather-history/KCQT" (
"date" TEXT,
  "actual_mean_temp" INTEGER,
  "actual_min_temp" INTEGER,
  "actual_max_temp" INTEGER,
  "average_min_temp" INTEGER,
  "average_max_temp" INTEGER,
  "record_min_temp" INTEGER,
  "record_max_temp" INTEGER,
  "record_min_temp_year" INTEGER,
  "record_max_temp_year" INTEGER,
  "actual_precipitation" REAL,
  "average_precipitation" REAL,
  "record_precipitation" REAL
);