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 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 76 68 84 67 84 49 103 1982 1956 0.04 0.11 1.23
2 2014-7-2 66 58 74 67 84 48 99 1930 1970 0.12 0.1 2.5
3 2014-7-3 66 57 75 67 84 50 102 1940 1949 0.05 0.11 1.38
4 2014-7-4 70 60 79 67 84 49 101 1940 2012 0.0 0.11 0.94
5 2014-7-5 71 63 79 67 84 46 103 1972 2012 0.01 0.13 1.18
6 2014-7-6 78 66 89 67 84 49 105 1983 2012 0.0 0.12 3.93
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
13 2014-7-13 79 71 86 68 85 50 106 1940 1995 0.04 0.12 1.49
14 2014-7-14 73 64 81 68 85 52 104 1930 1936 0.37 0.13 1.52
15 2014-7-15 64 57 71 68 85 49 103 1930 1988 0.05 0.13 1.36
16 2014-7-16 65 56 73 68 85 49 100 1945 1931 0.0 0.13 2.48
17 2014-7-17 68 58 78 68 85 51 100 1940 1942 0.0 0.12 5.72
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
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
26 2014-7-26 78 70 85 68 84 53 102 1962 1936 0.0 0.14 1.77
27 2014-7-27 78 66 89 68 84 51 100 1937 1955 0.04 0.14 4.71
28 2014-7-28 68 62 73 68 84 53 100 1981 1983 0.0 0.14 1.25
29 2014-7-29 71 60 81 68 84 50 101 1981 1941 0.0 0.14 1.47
30 2014-7-30 71 61 80 68 84 51 104 1936 1999 0.0 0.14 2.43
31 2014-7-31 74 63 85 67 83 50 99 1936 2006 0.0 0.15 1.2
32 2014-8-1 75 67 83 67 83 52 100 1947 1988 0.21 0.15 2.55
33 2014-8-2 74 63 84 67 83 56 102 1965 1991 0.0 0.14 3.58
34 2014-8-3 77 66 87 67 83 52 101 1950 1930 0.0 0.13 1.95
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
38 2014-8-7 75 69 81 67 83 53 96 1976 1984 0.0 0.14 1.67
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
41 2014-8-10 77 71 82 67 83 49 99 1972 1944 0.0 0.13 2.7
42 2014-8-11 76 68 84 67 83 50 100 1982 1941 1.16 0.12 2.36
43 2014-8-12 67 63 70 67 83 50 100 1930 1995 0.16 0.14 1.18
44 2014-8-13 71 59 83 67 83 52 101 1967 1936 0.0 0.13 1.09
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
47 2014-8-16 73 64 81 67 82 49 101 1976 1988 0.0 0.13 3.79
48 2014-8-17 69 66 72 67 82 48 99 1976 1988 0.0 0.13 2.6
49 2014-8-18 76 67 85 66 82 49 99 1963 1936 0.0 0.13 1.8
50 2014-8-19 80 73 86 66 82 49 99 1933 1983 0.13 0.12 1.39
51 2014-8-20 78 68 87 66 82 47 98 1950 1947 0.0 0.12 1.47
52 2014-8-21 77 71 83 66 82 46 99 1950 1955 1.29 0.13 1.58
53 2014-8-22 81 74 87 66 82 51 103 1928 1936 3.17 0.12 3.17
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
56 2014-8-25 83 73 92 65 81 47 95 1934 1991 0.78 0.11 1.88
57 2014-8-26 79 72 86 65 81 48 97 1982 1973 0.0 0.12 3.66
58 2014-8-27 76 70 81 65 81 46 97 1982 1973 0.0 0.13 1.57
59 2014-8-28 73 69 77 65 81 46 97 1982 1955 0.02 0.12 1.57
60 2014-8-29 81 73 88 64 81 43 98 1965 1953 0.0 0.12 2.02
61 2014-8-30 80 74 86 64 81 47 96 1946 1953 0.0 0.12 1.43
62 2014-8-31 79 71 87 64 80 46 99 1935 1953 0.0 0.13 1.62
63 2014-9-1 80 74 85 63 80 45 101 1949 1953 0.0 0.12 2.92
64 2014-9-2 77 69 85 63 80 44 101 1946 1953 0.0 0.12 1.37
65 2014-9-3 76 67 85 63 80 47 97 1974 1953 0.0 0.11 1.92
66 2014-9-4 80 73 87 62 79 43 95 1938 1960 0.22 0.12 3.05
67 2014-9-5 78 67 89 62 79 48 97 1988 1954 0.43 0.11 1.89
68 2014-9-6 69 62 76 62 79 46 98 1984 1990 0.0 0.12 0.83
69 2014-9-7 69 58 79 61 79 46 101 1986 1939 0.0 0.12 3.51
70 2014-9-8 70 60 79 61 78 45 98 1986 1933 0.0 0.11 1.37
71 2014-9-9 74 66 81 61 78 47 95 1975 1983 0.01 0.11 3.25
72 2014-9-10 70 58 82 60 78 44 96 1943 2013 1.61 0.11 1.61
73 2014-9-11 55 52 58 60 77 44 95 1943 1952 0.0 0.11 4.16
74 2014-9-12 52 46 57 59 77 44 96 1955 1952 0.1 0.11 2.43
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
78 2014-9-16 58 47 69 57 75 39 93 1984 1931 0.0 0.11 1.7
79 2014-9-17 61 49 72 57 75 39 93 1937 1955 0.0 0.1 1.2
80 2014-9-18 63 53 72 57 75 39 94 1929 1955 0.0 0.11 1.95
81 2014-9-19 67 57 76 56 74 37 93 1929 1955 0.0 0.12 0.94
82 2014-9-20 72 63 80 56 74 38 92 1956 1931 0.12 0.12 1.12
83 2014-9-21 61 52 70 55 73 40 92 1930 1970 0.0 0.11 1.67
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
86 2014-9-24 66 54 77 54 72 30 91 1928 2007 0.0 0.11 1.85
87 2014-9-25 68 58 78 53 72 30 91 1942 1986 0.0 0.12 2.0
88 2014-9-26 70 59 81 53 71 30 93 1928 1998 0.0 0.1 2.72
89 2014-9-27 70 61 79 52 71 31 91 1942 1971 0.0 0.1 1.43
90 2014-9-28 69 58 79 52 70 29 92 1942 1953 0.0 0.1 3.65
91 2014-9-29 71 57 84 52 70 33 99 1942 1953 0.0 0.1 1.13
92 2014-9-30 56 51 61 51 69 34 92 1984 1971 0.0 0.09 0.76
93 2014-10-1 63 52 73 51 69 32 92 1974 1971 0.0 0.1 0.73
94 2014-10-2 71 66 75 50 68 28 91 1974 1971 0.71 0.09 3.8
95 2014-10-3 57 46 68 50 68 29 91 1974 1954 1.05 0.1 3.95
96 2014-10-4 43 37 49 50 68 34 90 1989 1951 0.05 0.11 1.89
97 2014-10-5 49 42 56 49 67 31 89 1980 1997 0.0 0.1 2.01
98 2014-10-6 56 48 63 49 67 28 94 1952 1963 0.01 0.1 1.57
99 2014-10-7 59 49 69 48 66 31 88 2000 2007 0.0 0.1 1.26
100 2014-10-8 58 48 67 48 66 30 88 1952 2007 0.0 0.09 1.32

Next page

Advanced export

JSON shape: default, array

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