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

17 rows where record_min_temp = 49

✎ 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, 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
12 12 2014-7-12 74 65 82 64 83 49 98 1888 1953 0.0 0.0 0.05
61 61 2014-8-30 77 65 89 64 85 49 101 1901 1998 0.0 0.0 0.21
63 63 2014-9-1 78 70 85 64 85 49 110 1901 1955 0.0 0.0 0.41
77 77 2014-9-15 84 73 94 63 83 49 103 1895 2012 0.0 0.01 0.03
81 81 2014-9-19 75 67 82 63 83 49 104 1907 1939 0.0 0.01 0.27
82 82 2014-9-20 72 66 78 63 83 49 107 1900 1939 0.0 0.01 0.29
90 90 2014-9-28 72 64 79 62 81 49 106 1901 1963 0.0 0.01 0.74
93 93 2014-10-1 73 64 82 61 81 49 100 1901 1991 0.0 0.01 0.74
338 338 2015-6-3 68 61 74 59 76 49 99 1908 1879 0.0 0.01 0.49
343 343 2015-6-8 73 60 85 59 76 49 99 1894 1890 0.0 0.0 0.02
349 349 2015-6-14 70 63 77 60 78 49 100 1894 1917 0.0 0.01 0.01
351 351 2015-6-16 70 61 79 60 78 49 105 1895 1981 0.0 0.0 0.38
352 352 2015-6-17 70 62 78 61 78 49 105 1885 1917 0.0 0.01 0.02
358 358 2015-6-23 74 63 84 61 80 49 97 1893 1976 0.0 0.0 0.03
360 360 2015-6-25 72 62 81 62 80 49 98 1893 1883 0.0 0.01 0.0
362 362 2015-6-27 70 62 77 62 81 49 109 1894 1990 0.0 0.0 0.39
365 365 2015-6-30 78 67 89 62 81 49 100 1894 1985 0.0 0.0 0.01

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