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

✎ 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

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
70 70 2014-9-8 80 71 88 64 84 47 103 1901 1984 0.01 0.0 0.19
83 83 2014-9-21 72 65 79 63 82 47 108 1880 1885 0.0 0.01 0.15
329 329 2015-5-25 64 57 71 58 75 47 103 1916 1896 0.0 0.01 0.42
331 331 2015-5-27 65 58 72 58 75 47 97 1879 1880 0.0 0.0 0.57
335 335 2015-5-31 66 59 73 58 75 47 98 1908 1909 0.0 0.0 0.09
336 336 2015-6-1 67 59 75 58 75 47 100 1908 1879 0.0 0.01 0.57
337 337 2015-6-2 68 60 76 59 76 47 104 1895 1879 0.0 0.0 0.58
339 339 2015-6-4 66 61 70 59 76 47 100 1885 1895 0.0 0.0 0.33
341 341 2015-6-6 65 58 72 59 76 47 102 1887 1890 0.0 0.0 0.02
347 347 2015-6-12 68 63 72 60 77 47 100 1894 1979 0.0 0.0 0.63
353 353 2015-6-18 72 62 81 61 79 47 104 1885 1957 0.0 0.0 0.11

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