home / fivethirtyeight

U.S. Weather History: KHOU.csv

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

365 rows

View and edit SQL

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
101 2014-10-9 79 68 90 63 84 40 93 1976 1962 0.0 0.17 3.6
102 2014-10-10 83 75 91 63 84 43 95 1908 1962 0.03 0.17 3.5
103 2014-10-11 76 66 85 62 83 44 94 1990 1962 0.02 0.18 3.02
104 2014-10-12 76 65 87 62 83 42 96 1977 1991 0.35 0.18 3.37
105 2014-10-13 72 59 85 62 83 36 94 1977 1991 0.61 0.18 2.55
106 2014-10-14 67 54 79 61 83 40 92 1977 1954 0.0 0.19 4.91
107 2014-10-15 68 51 84 61 82 40 92 1978 1947 0.0 0.2 4.87
108 2014-10-16 72 57 87 61 82 41 92 1893 1989 0.0 0.21 5.17
109 2014-10-17 73 60 86 61 82 40 93 1977 1895 0.0 0.2 4.31
110 2014-10-18 75 63 86 60 82 39 96 1978 1895 0.5 0.21 4.04
111 2014-10-19 72 62 81 60 81 36 94 1989 2004 0.0 0.21 1.23
112 2014-10-20 71 59 83 60 81 32 93 1989 2004 0.0 0.2 2.54
113 2014-10-21 69 55 82 60 81 33 93 1976 2004 0.0 0.21 2.4
114 2014-10-22 72 61 82 59 80 41 91 1898 2004 0.0 0.2 3.7
115 2014-10-23 69 58 80 59 80 40 91 1996 1988 0.0 0.2 3.79
116 2014-10-24 68 54 82 59 80 39 92 1908 1931 0.0 0.19 2.13
117 2014-10-25 70 55 85 59 80 39 91 1980 1950 0.0 0.2 9.25
118 2014-10-26 71 56 85 58 79 39 92 1892 2010 0.0 0.2 2.43
119 2014-10-27 72 58 86 58 79 36 94 1898 2010 0.0 0.18 2.72
120 2014-10-28 73 60 86 58 79 36 90 1898 1991 0.0 0.18 8.04
121 2014-10-29 73 61 84 57 78 39 90 1910 1991 0.0 0.18 2.45
122 2014-10-30 67 55 79 57 78 33 89 1917 2004 0.0 0.17 5.3
123 2014-10-31 67 55 79 57 78 29 88 1993 2004 0.0 0.16 3.84
124 2014-11-1 55 45 65 57 77 35 89 1993 2010 0.0 0.15 6.25
125 2014-11-2 57 41 72 56 77 34 89 1991 1978 0.0 0.14 4.58
126 2014-11-3 67 53 80 56 77 30 87 1999 1992 0.0 0.15 3.09
127 2014-11-4 72 62 82 56 76 28 89 1991 1988 0.0 0.16 3.2
128 2014-11-5 69 64 74 55 76 31 88 1991 1963 1.12 0.16 5.22
129 2014-11-6 62 58 66 55 76 36 88 1993 1963 0.17 0.15 1.67
130 2014-11-7 57 49 65 55 75 29 88 1993 2002 0.0 0.15 1.46
131 2014-11-8 63 50 75 55 75 34 89 1991 1989 0.0 0.15 1.47
132 2014-11-9 60 47 72 54 75 29 88 1991 1969 0.0 0.15 3.08
133 2014-11-10 63 45 80 54 74 30 88 1977 1988 0.0 0.15 2.85
134 2014-11-11 60 49 71 54 74 32 87 1977 1978 0.01 0.16 1.88
135 2014-11-12 51 43 58 53 74 32 85 1987 2003 0.0 0.15 4.68
136 2014-11-13 41 36 45 53 73 29 86 1907 2005 0.2 0.14 4.53
137 2014-11-14 41 34 47 53 73 28 89 1969 1921 0.0 0.15 1.4
138 2014-11-15 48 43 53 52 73 25 88 1969 1978 0.3 0.14 2.8
139 2014-11-16 50 42 57 52 72 25 85 1970 1948 0.65 0.14 3.03
140 2014-11-17 44 36 52 52 72 31 85 1997 2013 0.0 0.14 5.19
141 2014-11-18 44 32 55 51 72 28 84 1959 1973 0.0 0.14 3.36
142 2014-11-19 50 30 69 51 71 30 85 2014 1985 0.0 0.14 2.1
143 2014-11-20 61 46 76 51 71 27 84 1969 1977 0.04 0.13 1.85
144 2014-11-21 64 61 66 50 71 29 84 1937 1999 0.57 0.14 1.54
145 2014-11-22 63 58 68 50 70 30 87 1975 1973 0.11 0.13 3.09
146 2014-11-23 71 61 80 50 70 24 85 1975 1973 0.23 0.14 3.81
147 2014-11-24 56 45 66 49 70 26 84 1970 1910 0.0 0.13 3.35
148 2014-11-25 54 41 66 49 69 29 86 1950 1967 0.0 0.14 1.7
149 2014-11-26 58 43 73 49 69 27 86 1975 1967 0.0 0.14 3.17
150 2014-11-27 55 43 67 49 69 26 84 1975 1989 0.0 0.14 3.12
151 2014-11-28 55 39 71 48 68 26 83 1976 1977 0.0 0.14 1.82
152 2014-11-29 69 60 78 48 68 22 83 1976 2006 0.0 0.15 3.47
153 2014-11-30 71 61 80 48 68 19 82 1976 1950 0.0 0.15 1.41
154 2014-12-1 57 45 69 47 67 26 83 1979 2012 0.03 0.15 5.8
155 2014-12-2 50 44 56 47 67 28 84 1979 2012 0.0 0.13 3.28
156 2014-12-3 59 52 66 47 67 25 85 1929 1995 0.0 0.14 2.5
157 2014-12-4 63 53 72 47 67 27 83 1897 2012 0.0 0.13 1.96
158 2014-12-5 72 65 79 46 66 26 83 2009 1998 0.07 0.13 2.02
159 2014-12-6 65 58 71 46 66 20 82 1950 1951 0.0 0.13 3.08
160 2014-12-7 57 54 59 46 66 24 84 1950 1998 0.0 0.13 4.95
161 2014-12-8 57 46 67 46 66 25 83 1927 2007 0.0 0.13 1.95
162 2014-12-9 57 43 70 45 65 25 82 1917 2007 0.0 0.13 1.69
163 2014-12-10 56 42 69 45 65 20 83 1978 1939 0.0 0.12 4.41
164 2014-12-11 64 56 72 45 65 26 83 1957 2007 0.02 0.12 2.85
165 2014-12-12 66 57 75 45 65 25 82 1989 1948 0.0 0.13 2.57
166 2014-12-13 64 54 74 45 65 19 82 1989 1921 0.0 0.12 2.85
167 2014-12-14 67 58 76 45 64 25 83 1985 1995 0.0 0.12 5.64
168 2014-12-15 70 59 80 44 64 21 82 1901 1995 0.0 0.12 2.19
169 2014-12-16 57 48 66 44 64 19 82 1989 1971 0.0 0.12 3.05
170 2014-12-17 54 44 64 44 64 20 80 1932 1984 0.0 0.12 2.28
171 2014-12-18 64 57 70 44 64 24 82 1996 1980 0.8 0.11 2.14
172 2014-12-19 56 52 59 44 64 20 81 1929 1978 3.06 0.12 3.06
173 2014-12-20 52 50 54 44 63 21 81 1996 1951 0.0 0.12 2.02
174 2014-12-21 55 48 61 44 63 21 82 1973 2010 0.0 0.12 3.41
175 2014-12-22 64 55 72 44 63 13 81 1989 1981 0.0 0.11 2.21
176 2014-12-23 54 48 60 44 63 7 80 1989 1996 0.69 0.13 1.01
177 2014-12-24 46 37 55 43 63 11 82 1989 1948 0.0 0.11 2.04
178 2014-12-25 50 34 66 43 63 11 82 1983 1964 0.0 0.12 2.09
179 2014-12-26 61 51 71 43 63 18 78 1983 2005 0.04 0.11 2.06
180 2014-12-27 60 46 74 43 63 19 81 1892 1971 0.22 0.11 1.38
181 2014-12-28 44 41 46 43 63 15 80 1894 1996 0.67 0.11 2.7
182 2014-12-29 44 39 48 43 63 15 81 1894 1984 0.0 0.1 2.15
183 2014-12-30 46 38 53 43 63 19 83 1983 1974 0.0 0.1 1.36
184 2014-12-31 42 37 46 43 63 18 82 1983 1974 0.0 0.1 3.35
185 2015-1-1 44 41 47 43 63 18 81 1928 2006 0.15 0.1 3.12
186 2015-1-2 51 47 54 43 63 16 81 1928 2000 0.63 0.1 2.26
187 2015-1-3 47 41 53 43 62 16 83 1911 1989 0.63 0.1 3.44
188 2015-1-4 46 36 56 43 62 18 79 1911 1997 0.0 0.11 2.23
189 2015-1-5 43 31 54 43 62 22 80 1972 1998 0.0 0.11 1.39
190 2015-1-6 50 34 65 43 62 22 80 1972 1989 0.0 0.11 3.7
191 2015-1-7 51 39 62 43 62 19 79 1970 1989 0.0 0.1 2.01
192 2015-1-8 35 28 42 43 62 19 79 1996 1957 0.01 0.11 5.89
193 2015-1-9 39 37 40 43 63 19 80 1976 1974 0.06 0.1 2.49
194 2015-1-10 39 37 41 43 63 18 82 1977 1963 0.08 0.11 1.43
195 2015-1-11 44 39 49 43 63 12 81 1982 1995 0.66 0.1 2.78
196 2015-1-12 46 43 49 43 63 11 81 1918 2000 0.0 0.11 2.27
197 2015-1-13 45 43 46 43 63 17 81 1912 2000 0.05 0.1 1.51
198 2015-1-14 42 39 45 43 63 19 82 1982 1971 0.0 0.11 1.45
199 2015-1-15 47 39 54 43 63 21 79 1892 1996 0.0 0.11 2.82
200 2015-1-16 47 33 61 43 63 22 81 1972 1936 0.0 0.11 2.6

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "us-weather-history/KHOU" (
"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
)
Powered by Datasette · Query took 9.836ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub