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

24 rows where record_min_temp = 36

✎ 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
125 125 2014-11-2 61 51 70 55 76 36 99 1886 1997 0.0 0.03 0.35
137 137 2014-11-14 67 60 73 52 73 36 93 1880 1933 0.0 0.03 1.33
140 140 2014-11-17 65 53 76 52 73 36 91 1886 1945 0.0 0.04 1.58
145 145 2014-11-22 63 52 73 50 71 36 89 1882 1950 0.0 0.04 3.51
147 147 2014-11-24 67 53 80 50 71 36 94 1895 1933 0.0 0.04 2.03
148 148 2014-11-25 66 52 80 50 70 36 92 1879 1977 0.0 0.04 0.78
151 151 2014-11-28 67 53 81 49 70 36 90 1906 1924 0.0 0.04 3.51
155 155 2014-12-2 62 58 66 49 69 36 88 1884 1893 1.21 0.05 1.21
156 156 2014-12-3 63 59 67 48 69 36 89 1897 1958 0.31 0.05 1.59
159 159 2014-12-6 63 55 71 48 68 36 88 1897 1938 0.0 0.06 1.01
163 163 2014-12-10 63 53 73 48 68 36 87 1951 1950 0.0 0.06 1.58
168 168 2014-12-15 56 47 65 47 67 36 85 1901 1998 0.0 0.07 2.26
180 180 2014-12-27 51 39 63 47 68 36 85 1916 2013 0.0 0.1 1.81
181 181 2014-12-28 53 43 63 47 68 36 87 1954 1919 0.0 0.1 5.55
184 184 2014-12-31 49 41 57 47 68 36 86 1882 1897 0.0 0.1 4.86
208 208 2015-1-24 66 49 82 48 68 36 85 1937 1992 0.0 0.09 2.04
209 209 2015-1-25 66 48 83 48 68 36 86 1898 1986 0.0 0.09 3.43
223 223 2015-2-8 68 59 77 49 68 36 85 1899 1996 0.0 0.13 2.43
244 244 2015-3-1 58 50 65 50 69 36 88 1894 1967 0.66 0.11 3.42
255 255 2015-3-12 71 56 86 51 70 36 93 1893 2007 0.0 0.09 1.44
259 259 2015-3-16 78 66 90 51 70 36 91 1880 1914 0.0 0.08 2.53
266 266 2015-3-23 65 57 73 51 71 36 88 1898 1926 0.0 0.06 2.08
273 273 2015-3-30 68 57 78 52 71 36 89 1892 2003 0.0 0.05 1.27
282 282 2015-4-8 60 49 70 53 72 36 92 1901 1989 0.0 0.04 2.19

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