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

14 rows where record_min_temp = 42

✎ 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, 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
103 103 2014-10-11 73 64 81 60 79 42 100 1879 1971 0.0 0.02 0.34
105 105 2014-10-13 74 65 82 59 79 42 104 1886 1950 0.0 0.02 1.09
123 123 2014-10-31 66 60 71 56 76 42 96 1886 1918 0.25 0.03 1.64
133 133 2014-11-10 66 62 70 53 74 42 93 1880 1990 0.0 0.02 1.95
279 279 2015-4-5 64 57 71 52 72 42 105 1921 1989 0.0 0.04 2.74
286 286 2015-4-12 67 57 77 53 72 42 97 1887 1888 0.0 0.03 1.9
290 290 2015-4-16 68 54 81 54 73 42 91 1917 2011 0.0 0.03 2.1
297 297 2015-4-23 62 55 69 55 74 42 100 1896 1910 0.0 0.02 0.98
299 299 2015-4-25 61 56 66 55 74 42 94 1882 1898 0.0 0.02 0.5
300 300 2015-4-26 66 54 77 55 74 42 99 1894 2004 0.0 0.02 1.62
307 307 2015-5-3 66 58 74 56 74 42 101 1883 2004 0.0 0.01 1.76
311 311 2015-5-7 60 54 65 56 74 42 97 1892 1941 0.03 0.01 1.0
319 319 2015-5-15 61 55 66 57 74 42 102 1883 2014 0.03 0.01 1.46
321 321 2015-5-17 65 58 72 57 74 42 96 1880 1892 0.0 0.01 0.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
);