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

✎ 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
99 99 2014-10-7 79 64 93 60 80 43 98 1884 1971 0.0 0.02 0.17
100 100 2014-10-8 75 63 87 60 80 43 100 1881 1994 0.0 0.02 0.42
104 104 2014-10-12 74 67 81 60 79 43 99 1886 1950 0.0 0.02 0.43
107 107 2014-10-15 71 63 78 59 79 43 102 1881 1961 0.0 0.01 0.27
111 111 2014-10-19 70 62 77 58 78 43 99 1881 1940 0.0 0.02 0.79
112 112 2014-10-20 71 63 79 58 78 43 96 1886 1964 0.0 0.02 3.16
116 116 2014-10-24 74 59 88 57 78 43 99 1886 1909 0.0 0.02 0.55
117 117 2014-10-25 71 61 80 57 77 43 96 1886 1983 0.0 0.03 1.04
121 121 2014-10-29 72 59 85 56 77 43 94 1878 1931 0.0 0.03 0.84
132 132 2014-11-9 68 58 77 54 75 43 94 1886 1996 0.0 0.03 3.41
278 278 2015-4-4 72 59 84 52 72 43 100 1892 1989 0.0 0.04 1.44
289 289 2015-4-15 69 57 80 53 73 43 99 1917 1966 0.0 0.03 0.81
310 310 2015-5-6 63 58 67 56 74 43 97 1892 1990 0.0 0.02 1.53
312 312 2015-5-8 57 50 63 56 74 43 97 1879 1984 0.18 0.01 2.02
314 314 2015-5-10 63 54 72 57 74 43 95 1922 1934 0.0 0.0 0.15
315 315 2015-5-11 67 57 76 57 74 43 93 1890 1996 0.0 0.01 0.29
317 317 2015-5-13 64 58 69 57 74 43 98 1880 1979 0.0 0.01 0.84
325 325 2015-5-21 64 57 71 58 75 43 100 1902 1883 0.0 0.01 1.03

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