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 Downloades 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

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
1 2014-7-1 84 74 94 75 93 66 102 1985 1980 0.0 0.16 1.4
2 2014-7-2 84 74 94 75 93 66 104 1924 1894 0.0 0.16 5.43
3 2014-7-3 84 73 94 75 93 66 100 1977 1980 0.0 0.16 1.29
4 2014-7-4 82 72 91 75 93 66 101 1910 2009 0.48 0.15 3.49
5 2014-7-5 82 73 90 75 93 66 102 1924 2009 0.31 0.16 3.04
6 2014-7-6 81 72 89 75 93 63 101 1970 2005 0.01 0.15 1.73
7 2014-7-7 84 74 93 75 93 62 100 1972 1980 0.08 0.15 2.32
8 2014-7-8 83 74 92 75 93 68 104 1892 1980 0.0 0.15 1.49
9 2014-7-9 85 74 95 75 93 64 102 1905 1980 0.0 0.14 2.39
10 2014-7-10 83 73 93 75 93 65 101 1893 1980 0.0 0.14 1.75
11 2014-7-11 83 72 94 75 93 64 103 1905 1980 0.0 0.13 3.08
12 2014-7-12 84 74 94 75 93 65 104 1891 1980 0.0 0.12 5.19
13 2014-7-13 87 77 96 75 94 66 102 1895 1980 0.0 0.13 5.4
14 2014-7-14 86 76 96 75 94 62 103 1990 1980 0.0 0.12 2.94
15 2014-7-15 82 75 89 75 94 64 103 1967 2000 0.06 0.12 4.32
16 2014-7-16 82 73 90 75 94 66 104 1895 1980 0.0 0.12 2.04
17 2014-7-17 83 76 89 75 94 67 104 1974 1980 0.39 0.1 2.23
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
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
23 2014-7-23 86 76 95 75 94 64 101 1970 1980 0.07 0.11 2.36
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
26 2014-7-26 87 78 95 75 94 68 105 1972 1954 0.0 0.11 2.35
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
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
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
35 2014-8-4 83 73 92 75 95 63 102 1976 1951 0.0 0.11 2.94
36 2014-8-5 83 74 92 75 95 64 103 1976 1964 0.0 0.1 2.81
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
39 2014-8-8 87 77 97 75 95 68 104 1990 1962 0.1 0.1 1.66
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
42 2014-8-11 86 75 97 75 95 65 102 1989 2011 0.25 0.1 2.72
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
47 2014-8-16 89 80 98 75 95 63 102 2004 1925 0.0 0.12 3.95
48 2014-8-17 88 78 97 75 95 60 104 1992 1909 0.0 0.12 3.57
49 2014-8-18 86 76 96 75 95 62 108 1992 1909 0.0 0.13 6.69
50 2014-8-19 85 76 94 75 95 69 107 2000 1909 0.0 0.13 1.85
51 2014-8-20 85 74 96 75 95 65 107 1976 1909 0.01 0.13 1.8
52 2014-8-21 87 76 98 75 94 63 106 1940 1909 0.0 0.13 2.0
53 2014-8-22 87 75 98 75 94 64 106 1976 1980 0.0 0.13 3.25
54 2014-8-23 87 75 98 75 94 64 107 1973 1980 0.0 0.13 2.46
55 2014-8-24 86 74 98 75 94 54 105 1891 1980 0.0 0.14 2.48
56 2014-8-25 87 76 97 75 94 55 103 1891 1924 0.0 0.13 1.9
57 2014-8-26 86 74 97 74 94 57 104 1891 2011 0.0 0.14 1.66
58 2014-8-27 85 75 94 74 94 59 109 1891 2011 0.0 0.14 8.32
59 2014-8-28 83 76 90 74 94 63 107 1992 2011 0.0 0.14 3.88
60 2014-8-29 83 75 91 74 93 61 107 1992 2011 0.02 0.15 2.89
61 2014-8-30 84 75 92 74 93 62 104 1986 2000 0.0 0.15 2.56
62 2014-8-31 79 74 84 74 93 62 107 1893 2000 0.83 0.16 5.98
63 2014-9-1 84 74 93 74 93 63 107 1915 2000 0.36 0.15 2.22
64 2014-9-2 85 76 94 73 93 60 104 1893 2000 0.0 0.14 1.81
65 2014-9-3 84 75 93 73 93 60 105 1987 2000 0.0 0.14 3.2
66 2014-9-4 85 76 93 73 92 59 109 1974 2000 0.0 0.14 2.75
67 2014-9-5 84 75 93 73 92 55 108 1891 2000 0.03 0.14 2.07
68 2014-9-6 85 75 95 73 92 56 99 1974 1909 0.16 0.14 2.9
69 2014-9-7 84 73 95 72 92 59 98 1891 1963 0.42 0.15 4.55
70 2014-9-8 82 72 92 72 92 58 100 1988 1907 0.0 0.15 0.87
71 2014-9-9 85 74 95 72 91 59 100 1988 1909 0.0 0.15 4.22
72 2014-9-10 87 78 95 72 91 59 99 1988 1993 0.0 0.16 1.82
73 2014-9-11 87 76 97 71 91 56 99 1907 1893 0.0 0.15 4.81
74 2014-9-12 82 75 89 71 91 56 101 1907 1909 0.02 0.15 2.25
75 2014-9-13 72 67 77 71 90 56 102 1907 2011 0.01 0.15 7.73
76 2014-9-14 71 65 77 70 90 55 100 1940 2011 0.0 0.15 4.11
77 2014-9-15 80 68 92 70 90 55 98 1892 1980 0.0 0.14 3.23
78 2014-9-16 83 75 91 70 90 53 98 1979 1995 0.12 0.13 1.72
79 2014-9-17 82 75 89 70 89 55 100 2000 1995 0.25 0.13 1.85
80 2014-9-18 77 73 81 69 89 54 99 2000 1927 2.31 0.13 2.53
81 2014-9-19 79 73 84 69 89 51 97 1981 1995 0.2 0.12 6.92
82 2014-9-20 81 73 89 69 89 54 99 1901 1999 0.0 0.13 7.66
83 2014-9-21 82 73 91 68 88 53 100 1983 2005 0.0 0.13 3.07
84 2014-9-22 83 72 93 68 88 49 100 1983 2005 0.0 0.12 3.14
85 2014-9-23 74 64 84 68 88 49 96 1999 1993 0.0 0.13 2.37
86 2014-9-24 75 64 85 67 88 48 95 1975 2013 0.0 0.13 2.22
87 2014-9-25 74 68 80 67 87 50 99 1994 2005 0.0 0.13 3.05
88 2014-9-26 77 68 86 67 87 49 99 2000 2005 0.0 0.13 2.86
89 2014-9-27 79 71 86 66 87 45 100 1942 2005 0.0 0.13 3.46
90 2014-9-28 81 72 89 66 87 48 98 1909 1998 0.0 0.13 1.25
91 2014-9-29 80 70 89 66 86 47 96 1908 2011 0.0 0.12 2.51
92 2014-9-30 80 71 89 65 86 47 95 1890 1998 0.0 0.13 2.55
93 2014-10-1 83 72 93 65 86 44 99 1984 1900 0.09 0.15 4.62
94 2014-10-2 82 71 93 65 86 47 97 1984 1938 0.78 0.16 2.25
95 2014-10-3 74 63 84 65 85 45 95 1975 1994 0.32 0.17 3.24
96 2014-10-4 68 59 77 64 85 43 95 1975 2002 0.0 0.17 3.6
97 2014-10-5 69 53 85 64 85 41 94 1975 2006 0.0 0.17 2.9
98 2014-10-6 75 65 84 64 85 44 94 1975 1928 0.69 0.17 4.42
99 2014-10-7 78 65 90 63 84 46 95 1889 1956 0.0 0.17 5.76
100 2014-10-8 80 69 90 63 84 42 96 1952 1962 0.06 0.17 2.07

Next page

Advanced export

JSON shape: default, array

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