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

10 rows where record_min_temp = 33

✎ 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, 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
175 175 2014-12-22 63 50 75 47 67 33 80 1990 1960 0.0 0.09 2.63
176 176 2014-12-23 67 51 83 47 67 33 86 1905 1989 0.0 0.08 1.84
177 177 2014-12-24 64 53 75 47 67 33 87 1879 1985 0.0 0.09 2.64
187 187 2015-1-3 52 40 63 47 68 33 87 1949 1902 0.0 0.11 2.27
196 196 2015-1-12 60 53 66 48 68 33 88 1949 2009 0.0 0.11 1.4
207 207 2015-1-23 63 50 75 48 68 33 84 1937 1968 0.0 0.1 1.05
220 220 2015-2-5 68 53 82 49 68 33 89 1899 2007 0.0 0.13 2.3
224 224 2015-2-9 66 58 73 49 68 33 85 1891 2006 0.0 0.14 1.92
230 230 2015-2-15 67 54 80 49 69 33 88 1903 1985 0.0 0.14 2.78
232 232 2015-2-17 64 57 71 50 69 33 89 1889 1890 0.0 0.16 2.18

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