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 = 37

✎ 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
143 143 2014-11-20 62 53 70 51 72 37 91 1906 2006 0.0 0.03 1.38
150 150 2014-11-27 74 58 89 49 70 37 90 1897 1903 0.0 0.05 0.99
152 152 2014-11-29 63 51 74 49 69 37 87 1878 1995 0.0 0.04 2.43
153 153 2014-11-30 63 60 66 49 69 37 88 1906 1964 0.3 0.05 1.96
157 157 2014-12-4 64 57 71 48 69 37 91 1909 1979 0.0 0.05 1.59
169 169 2014-12-16 57 54 60 47 67 37 89 1897 1980 0.41 0.07 1.96
183 183 2014-12-30 52 47 56 47 68 37 89 1945 1980 0.19 0.1 1.85
202 202 2015-1-18 64 53 75 48 68 37 95 1892 1971 0.0 0.1 2.3
225 225 2015-2-10 66 53 78 49 68 37 88 1890 1988 0.0 0.13 2.55
241 241 2015-2-26 61 51 70 50 69 37 87 1894 2002 0.0 0.13 1.08
258 258 2015-3-15 79 66 92 51 70 37 92 1880 2015 0.0 0.08 4.1
260 260 2015-3-17 73 63 82 51 70 37 94 1881 1914 0.0 0.06 1.28
262 262 2015-3-19 68 60 76 51 70 37 97 1886 1997 0.0 0.07 1.45
265 265 2015-3-22 66 59 72 51 71 37 88 1894 1986 0.0 0.06 1.11
267 267 2015-3-24 67 58 75 51 71 37 94 1898 1988 0.0 0.06 1.39
268 268 2015-3-25 72 60 84 51 71 37 96 1902 1988 0.0 0.06 2.19
270 270 2015-3-27 77 62 91 52 71 37 91 1884 1986 0.0 0.05 1.98
271 271 2015-3-28 71 61 81 52 71 37 90 1892 1879 0.0 0.06 1.62

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