home / fivethirtyeight

U.S. Weather History: KMDW.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_min_temp

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
192 2015-1-8 7 -7 20 18 32 -12 63 1942 1965 0.05 0.07 1.48
234 2015-2-19 1 -5 7 23 37 -8 65 1936 1930 0.0 0.07 0.78
191 2015-1-7 2 -4 8 18 32 -14 65 1942 2008 0.0 0.08 0.69
189 2015-1-5 5 -1 10 19 32 -15 56 1999 1998 0.11 0.08 0.8
235 2015-2-20 10 -1 20 23 37 -9 65 1929 1983 0.0 0.08 1.35
194 2015-1-10 13 0 26 18 31 -22 60 1982 1975 0.0 0.07 2.29
230 2015-2-15 9 0 17 22 36 -6 69 1936 1954 0.0 0.07 0.78
233 2015-2-18 6 0 11 23 37 -16 62 1936 1961 0.0 0.07 0.84
238 2015-2-23 8 0 15 24 39 0 66 1939 2000 0.0 0.09 0.9
242 2015-2-27 9 0 17 25 40 -6 75 1934 1976 0.0 0.09 0.79
243 2015-2-28 12 1 23 26 40 1 59 2015 1965 0.0 0.08 0.77
193 2015-1-9 10 3 16 18 31 -17 57 1982 1939 0.0 0.08 0.76
220 2015-2-5 10 3 17 19 33 -17 56 1979 1946 0.0 0.06 0.68
229 2015-2-14 17 4 29 21 35 -5 62 1936 1954 0.0 0.06 0.94
188 2015-1-4 21 5 36 19 32 -8 64 1999 1997 0.1 0.08 1.59
190 2015-1-6 9 5 12 19 32 -15 60 2014 2008 0.0 0.07 0.75
198 2015-1-14 13 5 21 18 31 -14 56 1979 1952 0.0 0.07 1.0
184 2014-12-31 13 6 20 19 32 -10 60 1967 1962 0.0 0.08 1.41
239 2015-2-24 19 6 32 24 39 -5 64 1967 1930 0.0 0.08 1.36
249 2015-3-6 17 6 27 28 43 2 71 1960 1983 0.0 0.08 0.49
228 2015-2-13 18 7 29 21 35 -5 63 1988 1938 0.0 0.07 0.78
237 2015-2-22 19 7 30 24 38 -7 63 1963 1984 0.0 0.08 1.4
241 2015-2-26 15 7 22 25 40 -1 64 1963 2000 0.01 0.08 1.76
218 2015-2-3 19 8 30 19 33 -17 60 1996 1992 0.05 0.06 0.43
231 2015-2-16 14 8 19 22 36 -7 53 1958 1981 0.0 0.07 0.75
248 2015-3-5 14 8 19 27 42 0 76 1978 1983 0.0 0.09 0.99
217 2015-2-2 16 9 22 19 32 -15 51 1951 1992 0.0 0.06 1.22
227 2015-2-12 16 11 21 21 35 -10 61 1981 1984 0.0 0.07 0.5
232 2015-2-17 17 11 22 22 36 -10 58 1936 2011 0.0 0.07 0.84
141 2014-11-18 17 12 21 34 47 12 72 2014 1999 0.0 0.12 2.23
219 2015-2-4 21 12 30 19 33 -12 54 1996 1993 0.0 0.05 0.69
140 2014-11-17 19 13 25 34 48 3 74 1959 1975 0.0 0.11 1.26
144 2014-11-21 25 13 36 32 46 7 66 1964 1990 0.0 0.12 1.35
183 2014-12-30 19 13 24 19 32 -8 60 1983 2002 0.0 0.07 1.69
197 2015-1-13 18 13 23 18 31 -10 56 1929 1932 0.0 0.07 1.37
247 2015-3-4 24 14 33 27 42 -4 74 2002 1983 0.0 0.08 1.42
221 2015-2-6 24 15 32 20 33 -12 56 1982 1938 0.0 0.05 1.96
240 2015-2-25 22 16 28 25 39 -5 73 1967 2000 0.06 0.09 0.62
245 2015-3-2 25 16 34 26 41 -4 71 1913 1974 0.0 0.08 1.02
143 2014-11-20 24 17 30 33 46 14 69 1964 1930 0.0 0.11 1.23
185 2015-1-1 25 17 32 19 32 -10 52 1969 2000 0.0 0.08 1.33
199 2015-1-15 27 17 36 18 31 -19 60 1979 1949 0.0 0.06 0.39
244 2015-3-1 23 18 27 26 41 -5 71 1962 1992 0.01 0.09 1.09
142 2014-11-19 26 19 33 33 47 17 77 1951 1930 0.0 0.11 0.74
150 2014-11-27 25 19 30 29 42 0 70 1930 1990 0.0 0.11 3.34
196 2015-1-12 25 19 30 18 31 -9 62 1974 2005 0.03 0.07 2.76
236 2015-2-21 26 19 33 23 38 -6 66 1963 1930 0.0 0.07 3.25
151 2014-11-28 28 20 36 29 42 -3 69 1930 1998 0.0 0.11 1.56
186 2015-1-2 28 20 36 19 32 -13 61 1979 2000 0.0 0.08 1.22
138 2014-11-15 27 21 33 35 49 8 72 1933 1990 0.0 0.12 0.89
154 2014-12-1 25 21 29 28 40 5 68 1930 1970 0.0 0.1 1.04
210 2015-1-26 25 21 29 18 32 -10 62 1936 1944 0.04 0.06 1.66
216 2015-2-1 27 21 33 19 32 -9 56 1951 1968 0.12 0.05 0.95
226 2015-2-11 30 21 38 21 35 -8 71 1955 1999 0.0 0.07 0.82
271 2015-3-28 29 21 37 35 52 9 78 1934 1968 0.0 0.1 1.26
148 2014-11-25 26 22 30 30 43 0 61 1950 2006 0.0 0.1 0.76
149 2014-11-26 27 22 32 30 43 2 68 1930 1990 0.0 0.11 1.2
155 2014-12-2 28 22 33 27 40 -1 69 1942 1982 0.0 0.1 2.78
200 2015-1-16 29 22 35 18 31 -19 56 1977 1990 0.0 0.07 0.43
214 2015-1-30 28 23 32 18 32 -15 55 1966 1988 0.0 0.05 1.25
215 2015-1-31 31 23 39 19 32 -9 67 1996 1989 0.13 0.06 0.7
137 2014-11-14 27 24 29 35 50 12 78 1940 1971 0.0 0.12 1.6
182 2014-12-29 30 24 35 20 32 -8 64 1976 1984 0.0 0.07 0.78
211 2015-1-27 29 24 33 18 32 -10 61 1955 2002 0.0 0.06 0.74
212 2015-1-28 30 24 36 18 32 -13 55 1977 1970 0.03 0.05 0.52
139 2014-11-16 29 25 33 34 48 5 73 1933 1952 0.0 0.12 1.29
157 2014-12-4 31 25 37 26 39 3 68 1991 1998 0.0 0.09 1.19
165 2014-12-12 32 25 39 24 36 -7 62 1962 1991 0.0 0.08 1.76
171 2014-12-18 28 25 31 22 34 -9 59 1983 1939 0.0 0.07 1.06
195 2015-1-11 30 25 34 18 31 -11 54 1977 2013 0.12 0.07 0.34
222 2015-2-7 35 25 44 20 33 -5 59 1972 2009 0.0 0.06 0.67
225 2015-2-10 29 25 33 20 34 -12 62 1982 2009 0.0 0.06 0.98
267 2015-3-24 33 25 40 34 50 5 79 1974 1939 0.04 0.08 1.26
270 2015-3-27 30 25 34 35 51 13 82 1965 1945 0.01 0.09 1.06
136 2014-11-13 29 26 31 36 50 7 74 1986 1989 0.0 0.12 1.09
156 2014-12-3 33 26 39 27 40 -8 72 1940 2012 0.0 0.1 0.68
164 2014-12-11 30 26 34 24 36 -5 61 1972 1949 0.0 0.09 1.73
170 2014-12-17 29 26 32 22 35 -7 60 1951 1977 0.0 0.08 0.44
181 2014-12-28 31 26 36 20 32 -3 67 1961 1984 0.0 0.08 1.13
209 2015-1-25 32 26 38 18 32 -10 67 1936 1950 0.06 0.06 1.3
224 2015-2-9 29 26 31 20 34 -20 57 1933 1999 0.0 0.06 0.77
250 2015-3-7 36 26 46 28 43 -2 79 1943 2000 0.0 0.09 1.27
135 2014-11-12 30 27 33 36 51 10 70 1986 1949 0.0 0.12 0.7
147 2014-11-24 39 27 51 31 44 -2 69 1950 1966 0.35 0.12 0.75
203 2015-1-19 35 27 43 18 31 -21 57 1985 1933 0.0 0.07 1.09
246 2015-3-3 32 27 37 27 42 -6 80 1873 1974 0.1 0.09 1.21
252 2015-3-9 40 28 52 29 44 3 69 1932 1974 0.0 0.08 1.41
272 2015-3-29 40 28 51 35 52 17 86 1969 1986 0.04 0.09 1.33
125 2014-11-2 41 29 53 40 56 14 78 1951 1974 0.0 0.11 1.2
153 2014-11-30 43 29 56 28 41 -1 66 1947 1962 0.0 0.11 0.6
172 2014-12-19 32 29 34 22 34 -12 56 1983 1988 0.0 0.08 0.8
160 2014-12-7 35 30 39 25 38 -2 61 1936 1946 0.0 0.09 1.26
201 2015-1-17 37 30 44 18 31 -17 58 1982 1952 0.0 0.07 0.68
206 2015-1-22 32 30 34 18 31 -17 58 1936 1964 0.0 0.06 1.33
207 2015-1-23 32 30 34 18 31 -19 59 1936 1967 0.0 0.06 0.73
261 2015-3-18 40 30 50 32 48 3 81 1941 2012 0.0 0.09 1.04
265 2015-3-22 34 30 37 33 49 6 84 1940 2012 0.0 0.09 1.15
266 2015-3-23 31 30 32 33 50 6 79 1940 1939 0.15 0.09 0.93
163 2014-12-10 34 31 36 24 37 -8 60 1978 1971 0.0 0.1 2.18
175 2014-12-22 38 31 44 21 33 -12 57 1989 1957 0.28 0.08 0.98

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "us-weather-history/KMDW" (
"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 69.536ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub