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

11 rows where record_min_temp = 39

✎ 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, 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
134 134 2014-11-11 66 62 69 53 74 39 94 1881 1900 0.0 0.03 1.55
144 144 2014-11-21 64 55 73 51 71 39 93 1905 1924 0.0 0.04 2.97
146 146 2014-11-23 69 57 80 50 71 39 91 2003 1933 0.0 0.05 0.91
243 243 2015-2-28 59 52 65 50 69 39 88 1962 1901 0.11 0.12 2.85
249 249 2015-3-6 66 49 83 51 70 39 90 1882 1899 0.0 0.11 0.88
257 257 2015-3-14 78 62 93 51 70 39 93 1895 2015 0.0 0.08 1.74
263 263 2015-3-20 69 59 78 51 70 39 93 1898 1997 0.0 0.06 2.42
269 269 2015-3-26 77 61 92 51 71 39 98 1907 1988 0.0 0.06 1.53
276 276 2015-4-2 65 54 75 52 71 39 96 1906 1985 0.0 0.05 1.43
281 281 2015-4-7 59 51 67 52 72 39 100 1975 1989 0.13 0.04 1.21
288 288 2015-4-14 66 58 73 53 73 39 95 1883 1964 0.0 0.03 0.83

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