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

View and edit SQL

Suggested facets: average_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
30 2014-7-30 83 72 94 75 95 68 102 1994 1914 0.0 0.09 2.11
31 2014-7-31 84 73 94 75 95 67 103 1936 1998 3.91 0.09 3.91
262 2015-3-19 73 66 79 53 74 27 89 1923 1908 0.49 0.09 4.2
17 2014-7-17 83 76 89 75 94 67 104 1974 1980 0.39 0.1 2.23
21 2014-7-21 87 77 96 75 94 65 101 1989 2000 0.0 0.1 1.09
22 2014-7-22 87 77 96 75 94 67 101 1988 2000 0.0 0.1 2.78
24 2014-7-24 84 73 94 75 94 68 101 1972 1954 0.01 0.1 2.09
25 2014-7-25 85 74 95 75 94 65 102 1894 1964 0.0 0.1 3.74
27 2014-7-27 87 77 97 75 95 66 101 1902 1995 0.0 0.1 5.22
28 2014-7-28 88 77 99 75 95 66 103 1891 1995 0.0 0.1 2.52
29 2014-7-29 83 74 92 75 95 64 101 1994 1907 0.03 0.1 4.7
32 2014-8-1 80 73 87 75 95 67 103 1984 1998 0.01 0.1 2.1
33 2014-8-2 77 71 82 75 95 68 104 1891 1998 0.0 0.1 1.65
34 2014-8-3 81 72 89 75 95 66 103 1949 1998 0.0 0.1 1.77
36 2014-8-5 83 74 92 75 95 64 103 1976 1964 0.0 0.1 2.81
39 2014-8-8 87 77 97 75 95 68 104 1990 1962 0.1 0.1 1.66
42 2014-8-11 86 75 97 75 95 65 102 1989 2011 0.25 0.1 2.72
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
191 2015-1-7 51 39 62 43 62 19 79 1970 1989 0.0 0.1 2.01
193 2015-1-9 39 37 40 43 63 19 80 1976 1974 0.06 0.1 2.49
195 2015-1-11 44 39 49 43 63 12 81 1982 1995 0.66 0.1 2.78
197 2015-1-13 45 43 46 43 63 17 81 1912 2000 0.05 0.1 1.51
218 2015-2-3 44 41 46 44 64 23 80 1951 2008 0.17 0.1 1.82
219 2015-2-4 52 42 61 45 65 22 81 1996 1957 0.16 0.1 2.19
220 2015-2-5 48 41 55 45 65 23 83 1996 1957 0.0 0.1 1.8
240 2015-2-25 42 33 50 49 68 26 85 1974 1918 0.1 0.1 2.1
256 2015-3-13 61 55 66 52 72 27 88 1932 1942 0.34 0.1 1.96
260 2015-3-17 70 58 82 53 73 30 88 1900 1908 0.0 0.1 2.57
261 2015-3-18 74 65 82 53 74 27 90 1892 2013 0.11 0.1 1.6
264 2015-3-21 65 64 66 54 74 30 87 1996 1907 1.01 0.1 1.38
272 2015-3-29 70 57 82 55 76 35 90 1894 1974 0.0 0.1 1.75
274 2015-3-31 74 64 83 56 77 30 88 1987 1946 0.0 0.1 1.44
275 2015-4-1 74 69 79 56 77 39 89 1987 1936 0.01 0.1 2.26
276 2015-4-2 77 69 84 56 77 38 89 1996 1939 0.0 0.1 4.75
277 2015-4-3 77 71 82 56 77 31 87 1987 2006 0.0 0.1 3.09
278 2015-4-4 67 61 73 56 77 34 88 1987 1897 0.0 0.1 3.35
279 2015-4-5 62 57 67 57 78 38 91 1973 1982 0.02 0.1 2.61
280 2015-4-6 75 67 82 57 78 37 88 1970 1909 0.0 0.1 1.9
281 2015-4-7 79 70 87 57 78 32 91 1971 1907 0.0 0.1 2.28
282 2015-4-8 78 71 84 57 78 35 92 1971 1986 0.0 0.1 3.26
283 2015-4-9 78 70 86 58 78 36 92 1973 1963 0.0 0.1 2.68
285 2015-4-11 70 63 77 58 79 38 89 1989 1934 0.13 0.1 1.67
286 2015-4-12 74 68 80 58 79 41 89 1900 1981 0.14 0.1 4.04
287 2015-4-13 79 71 86 59 79 39 92 1940 1996 0.32 0.1 6.43
289 2015-4-15 71 60 81 59 80 38 90 1928 1944 0.0 0.1 3.05
18 2014-7-18 81 75 87 75 94 67 102 1974 1980 0.04 0.11 2.85
19 2014-7-19 79 72 85 75 94 68 102 1974 1980 0.0 0.11 1.51
20 2014-7-20 83 73 93 75 94 69 102 1970 2000 0.01 0.11 2.08
23 2014-7-23 86 76 95 75 94 64 101 1970 1980 0.07 0.11 2.36
26 2014-7-26 87 78 95 75 94 68 105 1972 1954 0.0 0.11 2.35
35 2014-8-4 83 73 92 75 95 63 102 1976 1951 0.0 0.11 2.94
37 2014-8-6 85 75 94 75 95 64 101 1891 1947 0.0 0.11 1.2
38 2014-8-7 87 79 95 75 95 63 104 1891 2003 0.0 0.11 2.61
40 2014-8-9 86 77 94 75 95 62 106 1989 1962 0.0 0.11 1.83
41 2014-8-10 86 78 94 75 95 62 104 1989 1962 0.0 0.11 2.88
43 2014-8-12 87 76 97 75 95 64 105 1989 1962 0.0 0.11 1.41
44 2014-8-13 84 73 94 75 95 64 104 2004 1962 0.0 0.11 1.82
45 2014-8-14 83 73 93 75 95 65 102 2004 2007 0.02 0.11 2.8
46 2014-8-15 86 75 96 75 95 61 101 2004 1994 0.0 0.11 2.74
171 2014-12-18 64 57 70 44 64 24 82 1996 1980 0.8 0.11 2.14
175 2014-12-22 64 55 72 44 63 13 81 1989 1981 0.0 0.11 2.21
177 2014-12-24 46 37 55 43 63 11 82 1989 1948 0.0 0.11 2.04
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
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
192 2015-1-8 35 28 42 43 62 19 79 1996 1957 0.01 0.11 5.89
194 2015-1-10 39 37 41 43 63 18 82 1977 1963 0.08 0.11 1.43
196 2015-1-12 46 43 49 43 63 11 81 1918 2000 0.0 0.11 2.27
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
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
204 2015-1-20 61 45 76 43 63 20 81 1985 2012 0.0 0.11 1.83
205 2015-1-21 62 57 67 43 63 16 81 1985 1911 0.0 0.11 2.05
207 2015-1-23 42 39 44 43 63 14 83 1940 1972 0.03 0.11 2.62
208 2015-1-24 49 35 62 43 63 18 82 1963 1971 0.0 0.11 1.94
209 2015-1-25 55 40 70 44 63 19 81 1894 1971 0.0 0.11 2.83
210 2015-1-26 56 44 67 44 64 23 84 1943 1975 0.0 0.11 2.58
211 2015-1-27 64 47 81 44 64 19 83 1897 1975 0.0 0.11 2.86
213 2015-1-29 62 49 75 44 64 22 82 1897 1975 0.0 0.11 1.93
215 2015-1-31 53 42 63 44 64 14 82 1949 1911 0.0 0.11 2.12
217 2015-2-2 43 36 50 44 64 14 83 1951 1911 0.0 0.11 1.7
221 2015-2-6 49 41 56 45 65 24 81 1989 1969 0.0 0.11 1.09
222 2015-2-7 53 37 69 45 65 11 80 1895 1957 0.0 0.11 1.46
223 2015-2-8 66 54 77 45 65 10 82 1895 1932 0.0 0.11 1.84
224 2015-2-9 69 54 83 45 65 15 86 1933 1962 0.0 0.11 2.0
226 2015-2-11 60 44 75 46 66 20 82 1981 1999 0.0 0.11 1.88
228 2015-2-13 53 39 66 46 66 6 83 1899 1962 0.0 0.11 2.99
229 2015-2-14 61 43 78 46 66 10 83 1899 1911 0.0 0.11 1.9
238 2015-2-23 40 34 46 48 68 27 88 1976 1996 0.02 0.11 1.6
242 2015-2-27 42 37 46 49 69 22 86 2002 1954 0.0 0.11 1.85

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