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

13 rows where record_min_temp = 34

✎ 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, 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
141 141 2014-11-18 65 52 77 51 72 34 94 1881 1895 0.0 0.03 1.5
142 142 2014-11-19 64 53 74 51 72 34 92 1886 2006 0.0 0.04 3.61
164 164 2014-12-11 64 60 67 48 68 34 86 1898 1895 0.01 0.07 1.65
165 165 2014-12-12 59 52 65 47 68 34 86 1878 1895 1.6 0.06 4.3
170 170 2014-12-17 58 51 65 47 67 34 85 1895 1998 0.15 0.08 1.97
197 197 2015-1-13 61 54 68 48 68 34 86 1950 1986 0.0 0.1 1.45
198 198 2015-1-14 60 47 73 48 68 34 88 2013 1975 0.0 0.1 1.56
201 201 2015-1-17 64 50 78 48 68 34 90 1888 1971 0.0 0.11 2.74
206 206 2015-1-22 61 47 75 48 68 34 84 1937 1994 0.0 0.09 3.69
216 216 2015-2-1 63 49 76 48 68 34 88 1880 1995 0.0 0.12 2.26
217 217 2015-2-2 65 51 78 48 68 34 94 1901 1995 0.0 0.11 2.84
234 234 2015-2-19 65 57 72 50 69 34 91 1880 1995 0.0 0.15 2.32
235 235 2015-2-20 63 56 70 50 69 34 95 1882 1995 0.0 0.15 3.6

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