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

18 rows where record_min_temp = 40

✎ 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, 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
114 114 2014-10-22 72 60 84 58 78 40 100 1892 1965 0.0 0.02 0.77
129 129 2014-11-6 76 61 90 54 75 40 95 1879 2006 0.0 0.02 1.07
131 131 2014-11-8 74 59 89 54 75 40 93 1888 1956 0.0 0.03 1.82
138 138 2014-11-15 65 58 72 52 73 40 93 1968 2008 0.0 0.03 1.64
149 149 2014-11-26 69 53 85 50 70 40 90 1880 1903 0.0 0.04 1.28
240 240 2015-2-25 62 51 72 50 69 40 92 1962 1921 0.0 0.14 2.33
250 250 2015-3-7 70 54 86 51 70 40 89 1893 1914 0.0 0.1 2.52
256 256 2015-3-13 76 61 90 51 70 40 90 1907 2015 0.0 0.09 2.23
274 274 2015-3-31 65 57 73 52 71 40 92 1897 2011 0.0 0.05 1.65
275 275 2015-4-1 66 58 74 52 71 40 93 1897 1985 0.0 0.04 1.01
277 277 2015-4-3 72 57 86 52 71 40 94 1892 1961 0.0 0.04 1.14
280 280 2015-4-6 60 53 67 52 72 40 106 1975 1989 0.0 0.04 0.84
283 283 2015-4-9 65 53 76 53 72 40 94 1900 1890 0.0 0.03 1.71
285 285 2015-4-11 63 53 72 53 72 40 90 1896 1940 0.0 0.03 1.97
291 291 2015-4-17 69 56 81 54 73 40 90 1896 1999 0.0 0.03 1.24
292 292 2015-4-18 69 56 81 54 73 40 91 1882 1939 0.0 0.03 1.27
293 293 2015-4-19 65 55 75 54 73 40 94 1880 2009 0.0 0.02 0.86
320 320 2015-5-16 64 56 71 57 74 40 102 1883 1967 0.0 0.0 0.04

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