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

20 rows where record_min_temp = 48

✎ 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
68 68 2014-9-6 76 65 86 64 84 48 102 1898 1955 0.0 0.0 0.17
71 71 2014-9-9 80 68 91 64 84 48 102 1884 1956 0.0 0.01 0.01
73 73 2014-9-11 78 67 89 64 84 48 101 1901 1983 0.0 0.01 0.33
74 74 2014-9-12 80 68 91 64 84 48 102 1884 1971 0.0 0.01 0.13
75 75 2014-9-13 82 69 94 64 84 48 106 1884 1971 0.0 0.0 0.07
76 76 2014-9-14 85 71 98 63 84 48 100 1898 2012 0.0 0.01 0.04
78 78 2014-9-16 90 76 103 63 83 48 103 1884 1909 0.0 0.01 0.07
80 80 2014-9-18 74 67 81 63 83 48 103 1884 1939 0.0 0.01 1.39
84 84 2014-9-22 72 63 80 63 82 48 104 1895 1883 0.0 0.02 0.4
87 87 2014-9-25 76 67 85 62 82 48 107 1879 1978 0.0 0.01 3.96
88 88 2014-9-26 74 65 83 62 82 48 109 1893 1963 0.0 0.01 0.24
92 92 2014-9-30 75 64 85 62 81 48 105 1886 1906 0.0 0.02 1.58
332 332 2015-5-28 66 57 75 58 75 48 101 1895 1973 0.0 0.01 1.14
334 334 2015-5-30 68 59 77 58 75 48 95 1878 1972 0.0 0.01 0.14
342 342 2015-6-7 69 60 77 59 76 48 105 1887 1890 0.0 0.01 0.1
346 346 2015-6-11 69 62 75 60 77 48 105 1892 1979 0.0 0.01 0.11
350 350 2015-6-15 70 62 78 60 78 48 102 1892 1981 0.0 0.0 0.22
354 354 2015-6-19 70 58 82 61 79 48 101 1892 1973 0.0 0.0 0.01
355 355 2015-6-20 74 63 85 61 79 48 106 1881 1973 0.0 0.0 0.05
361 361 2015-6-26 69 60 78 62 80 48 112 1894 1990 0.0 0.0 0.19

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