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 sorted by actual_mean_temp

View and edit SQL

Suggested facets: 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
192 2015-1-8 35 28 42 43 62 19 79 1996 1957 0.01 0.11 5.89
239 2015-2-24 38 33 43 48 68 26 87 1914 1927 0.0 0.12 1.38
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
238 2015-2-23 40 34 46 48 68 27 88 1976 1996 0.02 0.11 1.6
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
184 2014-12-31 42 37 46 43 63 18 82 1983 1974 0.0 0.1 3.35
198 2015-1-14 42 39 45 43 63 19 82 1982 1971 0.0 0.11 1.45
207 2015-1-23 42 39 44 43 63 14 83 1940 1972 0.03 0.11 2.62
240 2015-2-25 42 33 50 49 68 26 85 1974 1918 0.1 0.1 2.1
242 2015-2-27 42 37 46 49 69 22 86 2002 1954 0.0 0.11 1.85
189 2015-1-5 43 31 54 43 62 22 80 1972 1998 0.0 0.11 1.39
217 2015-2-2 43 36 50 44 64 14 83 1951 1911 0.0 0.11 1.7
241 2015-2-26 43 31 55 49 69 26 86 1974 1986 0.0 0.12 1.51
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
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
185 2015-1-1 44 41 47 43 63 18 81 1928 2006 0.15 0.1 3.12
195 2015-1-11 44 39 49 43 63 12 81 1982 1995 0.66 0.1 2.78
218 2015-2-3 44 41 46 44 64 23 80 1951 2008 0.17 0.1 1.82
232 2015-2-17 44 34 54 47 67 16 86 1895 1907 0.0 0.12 0.87
248 2015-3-5 44 36 51 50 70 25 84 1989 1998 0.15 0.12 2.2
249 2015-3-6 44 30 57 51 71 25 86 1989 1991 0.0 0.12 1.44
197 2015-1-13 45 43 46 43 63 17 81 1912 2000 0.05 0.1 1.51
177 2014-12-24 46 37 55 43 63 11 82 1989 1948 0.0 0.11 2.04
183 2014-12-30 46 38 53 43 63 19 83 1983 1974 0.0 0.1 1.36
188 2015-1-4 46 36 56 43 62 18 79 1911 1997 0.0 0.11 2.23
196 2015-1-12 46 43 49 43 63 11 81 1918 2000 0.0 0.11 2.27
187 2015-1-3 47 41 53 43 62 16 83 1911 1989 0.63 0.1 3.44
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
243 2015-2-28 47 37 57 49 69 28 90 2002 1940 0.02 0.12 1.44
138 2014-11-15 48 43 53 52 73 25 88 1969 1978 0.3 0.14 2.8
220 2015-2-5 48 41 55 45 65 23 83 1996 1957 0.0 0.1 1.8
250 2015-3-7 48 35 60 51 71 28 90 1989 1911 0.0 0.12 1.58
208 2015-1-24 49 35 62 43 63 18 82 1963 1971 0.0 0.11 1.94
221 2015-2-6 49 41 56 45 65 24 81 1989 1969 0.0 0.11 1.09
233 2015-2-18 49 33 64 47 67 19 87 1936 1986 0.0 0.13 2.09
251 2015-3-8 49 45 53 51 71 27 88 1971 1911 1.49 0.11 2.05
139 2014-11-16 50 42 57 52 72 25 85 1970 1948 0.65 0.14 3.03
142 2014-11-19 50 30 69 51 71 30 85 2014 1985 0.0 0.14 2.1
155 2014-12-2 50 44 56 47 67 28 84 1979 2012 0.0 0.13 3.28
178 2014-12-25 50 34 66 43 63 11 82 1983 1964 0.0 0.12 2.09
190 2015-1-6 50 34 65 43 62 22 80 1972 1989 0.0 0.11 3.7
135 2014-11-12 51 43 58 53 74 32 85 1987 2003 0.0 0.15 4.68
186 2015-1-2 51 47 54 43 63 16 81 1928 2000 0.63 0.1 2.26
191 2015-1-7 51 39 62 43 62 19 79 1970 1989 0.0 0.1 2.01
234 2015-2-19 51 37 64 47 67 20 88 1900 1986 0.0 0.12 1.3
173 2014-12-20 52 50 54 44 63 21 81 1996 1951 0.0 0.12 2.02
206 2015-1-22 52 44 60 43 63 15 80 1930 1972 0.87 0.12 2.52
219 2015-2-4 52 42 61 45 65 22 81 1996 1957 0.16 0.1 2.19
201 2015-1-17 53 37 69 43 63 15 80 1930 1974 0.0 0.11 2.39
203 2015-1-19 53 34 72 43 63 10 81 1940 2000 0.0 0.11 2.0
215 2015-1-31 53 42 63 44 64 14 82 1949 1911 0.0 0.11 2.12
222 2015-2-7 53 37 69 45 65 11 80 1895 1957 0.0 0.11 1.46
228 2015-2-13 53 39 66 46 66 6 83 1899 1962 0.0 0.11 2.99
231 2015-2-16 53 37 68 47 66 13 82 1895 1927 0.15 0.12 2.05
148 2014-11-25 54 41 66 49 69 29 86 1950 1967 0.0 0.14 1.7
170 2014-12-17 54 44 64 44 64 20 80 1932 1984 0.0 0.12 2.28
176 2014-12-23 54 48 60 44 63 7 80 1989 1996 0.69 0.13 1.01
244 2015-3-1 54 49 59 50 69 28 84 1980 1975 0.22 0.11 3.32
245 2015-3-2 54 48 60 50 70 22 91 1980 1909 0.01 0.12 1.55
124 2014-11-1 55 45 65 57 77 35 89 1993 2010 0.0 0.15 6.25
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
174 2014-12-21 55 48 61 44 63 21 82 1973 2010 0.0 0.12 3.41
209 2015-1-25 55 40 70 44 63 19 81 1894 1971 0.0 0.11 2.83
214 2015-1-30 55 45 65 44 64 18 84 1949 1911 0.0 0.12 1.64
147 2014-11-24 56 45 66 49 70 26 84 1970 1910 0.0 0.13 3.35
163 2014-12-10 56 42 69 45 65 20 83 1978 1939 0.0 0.12 4.41
172 2014-12-19 56 52 59 44 64 20 81 1929 1978 3.06 0.12 3.06
210 2015-1-26 56 44 67 44 64 23 84 1943 1975 0.0 0.11 2.58
227 2015-2-12 56 46 66 46 66 6 84 1899 1922 0.0 0.12 2.7
125 2014-11-2 57 41 72 56 77 34 89 1991 1978 0.0 0.14 4.58
130 2014-11-7 57 49 65 55 75 29 88 1993 2002 0.0 0.15 1.46
154 2014-12-1 57 45 69 47 67 26 83 1979 2012 0.03 0.15 5.8
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
169 2014-12-16 57 48 66 44 64 19 82 1989 1971 0.0 0.12 3.05
202 2015-1-18 57 43 71 43 63 5 81 1930 2000 0.0 0.12 2.83
253 2015-3-10 57 53 60 51 72 27 89 1932 1980 0.0 0.11 3.23
149 2014-11-26 58 43 73 49 69 27 86 1975 1967 0.0 0.14 3.17
252 2015-3-9 58 50 66 51 71 27 88 1932 2000 1.96 0.11 1.96
254 2015-3-11 58 53 62 52 72 27 87 1948 1911 0.12 0.11 2.81
156 2014-12-3 59 52 66 47 67 25 85 1929 1995 0.0 0.14 2.5
225 2015-2-10 59 43 74 46 65 22 85 1973 1957 0.0 0.12 2.22
255 2015-3-12 59 55 62 52 72 24 89 1948 1904 0.33 0.11 4.28
132 2014-11-9 60 47 72 54 75 29 88 1991 1969 0.0 0.15 3.08
134 2014-11-11 60 49 71 54 74 32 87 1977 1978 0.01 0.16 1.88
180 2014-12-27 60 46 74 43 63 19 81 1892 1971 0.22 0.11 1.38
226 2015-2-11 60 44 75 46 66 20 82 1981 1999 0.0 0.11 1.88
143 2014-11-20 61 46 76 51 71 27 84 1969 1977 0.04 0.13 1.85
179 2014-12-26 61 51 71 43 63 18 78 1983 2005 0.04 0.11 2.06
204 2015-1-20 61 45 76 43 63 20 81 1985 2012 0.0 0.11 1.83
212 2015-1-28 61 43 79 44 64 19 82 1897 1975 0.0 0.12 0.75
229 2015-2-14 61 43 78 46 66 10 83 1899 1911 0.0 0.11 1.9
230 2015-2-15 61 51 71 47 66 18 83 1905 2000 0.02 0.13 2.0

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 388.076ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub