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 record_max_temp_year

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
168 2014-12-15 46 43 48 23 35 -8 64 1989   0.12 0.08 1.14
103 2014-10-11 50 40 60 47 65 29 88 2009 1928 0.0 0.1 1.47
278 2015-4-4 46 31 61 38 55 16 80 1975 1929 0.0 0.11 1.9
18 2014-7-18 73 64 81 68 84 53 101 1979 1930 0.0 0.13 2.36
19 2014-7-19 71 62 80 68 84 55 104 1947 1930 0.0 0.13 3.69
34 2014-8-3 77 66 87 67 83 52 101 1950 1930 0.0 0.13 1.95
142 2014-11-19 26 19 33 33 47 17 77 1951 1930 0.0 0.11 0.74
143 2014-11-20 24 17 30 33 46 14 69 1964 1930 0.0 0.11 1.23
234 2015-2-19 1 -5 7 23 37 -8 65 1936 1930 0.0 0.07 0.78
236 2015-2-21 26 19 33 23 38 -6 66 1963 1930 0.0 0.07 3.25
239 2015-2-24 19 6 32 24 39 -5 64 1967 1930 0.0 0.08 1.36
284 2015-4-10 54 42 65 40 57 22 91 1989 1930 0.0 0.13 1.15
285 2015-4-11 52 39 64 40 57 25 91 1973 1930 0.0 0.12 2.26
358 2015-6-23 74 67 81 65 82 46 99 1972 1930 0.0 0.12 2.2
16 2014-7-16 65 56 73 68 85 49 100 1945 1931 0.0 0.13 2.48
78 2014-9-16 58 47 69 57 75 39 93 1984 1931 0.0 0.11 1.7
82 2014-9-20 72 63 80 56 74 38 92 1956 1931 0.12 0.12 1.12
146 2014-11-23 52 50 54 31 45 -1 70 1950 1931 0.62 0.12 1.98
365 2015-6-30 71 61 80 66 84 45 101 1943 1931 0.0 0.11 2.59
197 2015-1-13 18 13 23 18 31 -10 56 1929 1932 0.0 0.07 1.37
70 2014-9-8 70 60 79 61 78 45 98 1986 1933 0.0 0.11 1.37
203 2015-1-19 35 27 43 18 31 -21 57 1985 1933 0.0 0.07 1.09
342 2015-6-7 72 60 83 59 77 45 101 1944 1933 0.44 0.15 3.11
345 2015-6-10 83 71 94 60 78 41 101 1928 1933 0.09 0.14 2.97
346 2015-6-11 72 65 79 61 79 41 100 1972 1933 0.2 0.14 2.08
362 2015-6-27 68 59 77 66 83 50 102 1981 1933 0.0 0.12 2.88
20 2014-7-20 75 66 84 68 84 50 103 1941 1934 0.0 0.13 3.03
21 2014-7-21 78 68 87 68 84 51 108 1970 1934 0.0 0.14 1.43
22 2014-7-22 82 72 91 68 84 49 104 1947 1934 0.19 0.14 1.82
23 2014-7-23 70 64 76 68 84 51 109 1947 1934 0.0 0.14 2.31
24 2014-7-24 68 60 75 68 84 55 107 2000 1934 0.0 0.14 4.77
25 2014-7-25 69 60 77 68 84 58 105 2013 1934 0.0 0.13 1.83
39 2014-8-8 76 70 82 67 83 52 103 1976 1934 0.0 0.13 2.35
40 2014-8-9 74 68 80 67 83 51 104 1972 1934 0.0 0.13 2.13
205 2015-1-21 34 31 36 18 31 -17 57 1984 1934 0.0 0.06 0.96
310 2015-5-6 67 51 82 49 67 34 93 1989 1934 0.0 0.12 1.71
313 2015-5-9 58 49 67 49 68 31 96 1983 1934 0.38 0.13 2.33
323 2015-5-19 49 44 54 52 71 37 95 1937 1934 0.0 0.14 1.54
325 2015-5-21 59 47 70 53 72 34 94 2002 1934 0.0 0.14 1.79
335 2015-5-31 51 44 57 57 75 41 102 1928 1934 0.05 0.15 2.97
336 2015-6-1 55 48 62 57 75 39 107 2003 1934 0.0 0.15 1.88
338 2015-6-3 67 55 79 58 76 37 98 1945 1934 0.0 0.15 1.15
340 2015-6-5 65 56 73 58 77 37 98 1945 1934 0.0 0.15 0.75
363 2015-6-28 70 58 81 66 83 49 104 1938 1934 0.0 0.12 1.66
7 2014-7-7 81 72 89 67 85 48 102 1983 1936 0.48 0.13 1.3
8 2014-7-8 77 70 84 68 85 49 106 1934 1936 0.48 0.13 2.41
9 2014-7-9 73 64 81 68 85 51 100 1941 1936 0.0 0.12 2.43
10 2014-7-10 71 63 78 68 85 51 106 1941 1936 0.0 0.13 0.98
11 2014-7-11 73 63 83 68 85 51 107 1978 1936 0.0 0.13 6.16
12 2014-7-12 76 70 81 68 85 55 100 1975 1936 3.31 0.13 6.16
14 2014-7-14 73 64 81 68 85 52 104 1930 1936 0.37 0.13 1.52
26 2014-7-26 78 70 85 68 84 53 102 1962 1936 0.0 0.14 1.77
44 2014-8-13 71 59 83 67 83 52 101 1967 1936 0.0 0.13 1.09
49 2014-8-18 76 67 85 66 82 49 99 1963 1936 0.0 0.13 1.8
53 2014-8-22 81 74 87 66 82 51 103 1928 1936 3.17 0.12 3.17
311 2015-5-7 72 57 87 49 67 32 89 1974 1936 0.0 0.12 2.01
361 2015-6-26 66 61 70 66 83 52 98 1945 1936 0.7 0.12 2.57
84 2014-9-22 59 48 69 55 73 34 93 1974 1937 0.0 0.11 1.09
85 2014-9-23 63 50 76 54 73 35 93 1974 1937 0.0 0.11 2.09
359 2015-6-24 73 66 79 65 83 48 99 1936 1937 0.0 0.13 2.31
102 2014-10-10 52 44 59 48 65 27 87 1964 1938 0.0 0.1 3.94
221 2015-2-6 24 15 32 20 33 -12 56 1982 1938 0.0 0.05 1.96
228 2015-2-13 18 7 29 21 35 -5 63 1988 1938 0.0 0.07 0.78
69 2014-9-7 69 58 79 61 79 46 101 1986 1939 0.0 0.12 3.51
75 2014-9-13 51 42 60 59 77 40 99 1953 1939 0.01 0.11 3.62
76 2014-9-14 57 46 67 58 76 42 101 1949 1939 0.0 0.11 2.19
77 2014-9-15 58 54 62 58 76 41 102 1949 1939 0.0 0.11 1.07
171 2014-12-18 28 25 31 22 34 -9 59 1983 1939 0.0 0.07 1.06
193 2015-1-9 10 3 16 18 31 -17 57 1982 1939 0.0 0.08 0.76
266 2015-3-23 31 30 32 33 50 6 79 1940 1939 0.15 0.09 0.93
267 2015-3-24 33 25 40 34 50 5 79 1974 1939 0.04 0.08 1.26
119 2014-10-27 67 54 79 42 58 24 82 1942 1940 0.02 0.11 1.56
29 2014-7-29 71 60 81 68 84 50 101 1981 1941 0.0 0.14 1.47
42 2014-8-11 76 68 84 67 83 50 100 1982 1941 1.16 0.12 2.36
287 2015-4-13 61 53 69 41 58 21 83 1950 1941 0.14 0.12 1.84
17 2014-7-17 68 58 78 68 85 51 100 1940 1942 0.0 0.12 5.72
303 2015-4-29 53 42 64 46 65 31 89 1958 1942 0.0 0.13 1.62
304 2015-4-30 47 42 52 47 65 31 92 1931 1942 0.0 0.12 2.15
333 2015-5-29 78 71 84 56 74 36 95 1930 1942 0.18 0.14 0.83
334 2015-5-30 59 45 73 56 75 36 95 1930 1942 0.79 0.14 1.6
41 2014-8-10 77 71 82 67 83 49 99 1972 1944 0.0 0.13 2.7
45 2014-8-14 67 61 73 67 82 48 99 1964 1944 0.0 0.14 1.79
46 2014-8-15 67 55 79 67 82 48 98 1929 1944 0.0 0.14 2.07
210 2015-1-26 25 21 29 18 32 -10 62 1936 1944 0.04 0.06 1.66
337 2015-6-2 58 45 71 57 76 44 92 1946 1944 0.0 0.14 2.35
130 2014-11-7 41 37 45 38 53 16 74 1991 1945 0.0 0.12 1.17
270 2015-3-27 30 25 34 35 51 13 82 1965 1945 0.01 0.09 1.06
160 2014-12-7 35 30 39 25 38 -2 61 1936 1946 0.0 0.09 1.26
161 2014-12-8 37 35 39 25 37 0 64 1958 1946 0.1 0.09 0.77
162 2014-12-9 37 33 40 24 37 -8 61 1958 1946 0.02 0.09 1.31
220 2015-2-5 10 3 17 19 33 -17 56 1979 1946 0.0 0.06 0.68
35 2014-8-4 78 68 88 67 83 52 100 1929 1947 1.79 0.14 2.17
36 2014-8-5 74 68 80 67 83 52 100 1974 1947 0.07 0.13 1.11
37 2014-8-6 73 65 81 67 83 50 101 1948 1947 0.0 0.13 2.17
51 2014-8-20 78 68 87 66 82 47 98 1950 1947 0.0 0.12 1.47
54 2014-8-23 79 71 87 66 82 52 97 1940 1947 0.5 0.11 2.49
55 2014-8-24 81 73 89 65 82 48 100 1942 1947 0.0 0.13 1.2
107 2014-10-15 56 53 58 46 63 29 88 1937 1947 0.07 0.1 1.66
3 2014-7-3 66 57 75 67 84 50 102 1940 1949 0.05 0.11 1.38
135 2014-11-12 30 27 33 36 51 10 70 1986 1949 0.0 0.12 0.7

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