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

22 rows where record_min_temp = 35

✎ 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
136 136 2014-11-13 63 55 70 53 74 35 96 1880 1933 0.0 0.03 0.99
139 139 2014-11-16 65 55 74 52 73 35 93 1880 1924 0.0 0.04 2.01
171 171 2014-12-18 55 48 62 47 67 35 86 1885 1917 0.0 0.08 2.18
173 173 2014-12-20 57 50 64 47 67 35 83 1887 1985 0.0 0.08 4.19
179 179 2014-12-26 53 42 63 47 68 35 85 1987 1980 0.0 0.09 1.2
182 182 2014-12-29 52 41 63 47 68 35 89 1882 1897 0.0 0.11 3.84
185 185 2015-1-1 48 37 59 47 68 35 84 1884 1898 0.0 0.11 3.12
212 212 2015-1-28 66 56 75 48 68 35 90 1957 1971 0.0 0.1 2.81
214 214 2015-1-30 65 59 70 48 68 35 85 1880 1992 0.03 0.11 2.19
226 226 2015-2-11 70 55 85 49 68 35 88 1894 1971 0.0 0.13 2.12
227 227 2015-2-12 71 56 85 49 68 35 91 1949 1971 0.0 0.14 2.45
228 228 2015-2-13 73 57 88 49 69 35 90 1903 1985 0.0 0.14 2.71
231 231 2015-2-16 63 56 70 49 69 35 88 1903 1896 0.0 0.15 3.03
236 236 2015-2-21 63 57 69 50 69 35 88 1897 2002 0.0 0.15 2.08
237 237 2015-2-22 59 53 64 50 69 35 90 1897 2002 0.7 0.15 2.19
238 238 2015-2-23 58 50 65 50 69 35 90 1894 1954 0.0 0.14 2.11
239 239 2015-2-24 60 46 74 50 69 35 94 1890 1986 0.0 0.13 4.8
245 245 2015-3-2 56 49 63 50 69 35 87 1896 1994 0.21 0.11 5.88
247 247 2015-3-4 60 48 72 51 70 35 94 1976 1972 0.0 0.1 2.54
248 248 2015-3-5 64 51 77 51 70 35 87 1896 1899 0.0 0.11 1.98
251 251 2015-3-8 66 53 78 51 70 35 93 1882 2004 0.0 0.09 1.71
264 264 2015-3-21 69 62 75 51 71 35 93 1894 1931 0.0 0.06 1.34

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