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

15 rows where record_min_temp = 32

✎ 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, actual_precipitation, 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
160 160 2014-12-7 65 54 76 48 68 32 88 1978 1940 0.0 0.06 2.78
162 162 2014-12-9 65 54 76 48 68 32 85 1951 1973 0.0 0.06 1.7
172 172 2014-12-19 58 49 66 47 67 32 86 1897 1917 0.0 0.08 2.8
186 186 2015-1-2 50 39 61 47 68 32 85 1886 1994 0.0 0.1 1.57
192 192 2015-1-8 63 51 75 48 68 32 90 1888 1923 0.0 0.1 1.19
195 195 2015-1-11 60 56 63 48 68 32 89 1949 1996 0.5 0.1 1.57
199 199 2015-1-15 64 51 76 48 68 32 85 1888 2009 0.0 0.11 2.13
203 203 2015-1-19 61 50 72 48 68 32 92 1889 1971 0.0 0.09 2.26
205 205 2015-1-21 63 54 71 48 68 32 81 1937 1912 0.0 0.09 2.98
211 211 2015-1-27 66 57 74 48 68 32 87 1898 1986 0.0 0.09 2.28
215 215 2015-1-31 64 56 71 48 68 32 91 1880 2003 0.0 0.11 3.03
219 219 2015-2-4 64 56 72 49 68 32 91 1883 1995 0.0 0.12 2.55
222 222 2015-2-7 62 54 69 49 68 32 89 1883 1996 0.02 0.13 1.6
229 229 2015-2-14 71 56 86 49 69 32 90 1903 1985 0.0 0.14 2.5
233 233 2015-2-18 65 55 75 50 69 32 89 1882 1981 0.0 0.15 4.26

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
);