home / fivethirtyeight

U.S. Weather History: KIND.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 66 86 66 85 48 97 1885 1970 0.13 0.16 5.09
2 2014-7-2 71 63 79 66 85 50 99 1904 1970 0.0 0.16 4.5
3 2014-7-3 67 60 73 66 85 49 100 1968 1911 0.0 0.15 1.89
4 2014-7-4 67 54 79 66 85 48 103 1968 1911 0.0 0.15 2.4
5 2014-7-5 69 59 79 66 85 49 103 1972 2012 0.0 0.16 3.27
6 2014-7-6 74 64 83 66 85 48 105 2001 2012 0.03 0.15 1.64
7 2014-7-7 74 68 79 66 85 54 105 1894 2012 0.0 0.16 4.43
8 2014-7-8 74 67 81 66 85 51 104 1984 1936 0.32 0.16 2.6
9 2014-7-9 72 62 81 66 85 52 103 1952 1936 0.0 0.16 2.49
10 2014-7-10 71 61 80 66 85 50 105 1963 1936 0.0 0.16 1.52
11 2014-7-11 71 60 81 66 85 52 104 1945 1936 0.0 0.16 2.49
12 2014-7-12 74 67 80 66 85 53 103 1975 1936 0.07 0.16 2.7
13 2014-7-13 78 72 84 66 85 49 103 1976 1936 0.0 0.17 2.78
14 2014-7-14 75 65 85 66 85 48 106 1975 1936 0.39 0.16 2.96
15 2014-7-15 64 56 71 66 85 51 103 1967 1988 0.0 0.17 2.05
16 2014-7-16 63 53 72 66 85 49 98 1945 1988 0.0 0.15 2.32
17 2014-7-17 65 53 77 66 85 51 101 1976 2012 0.0 0.15 3.71
18 2014-7-18 68 57 78 66 85 51 100 1976 1954 0.0 0.15 2.61
19 2014-7-19 68 58 77 66 85 50 98 1984 1930 0.0 0.14 1.31
20 2014-7-20 71 60 81 66 85 49 103 1947 1934 0.0 0.13 4.0
21 2014-7-21 74 62 85 66 85 46 106 1944 1934 0.0 0.14 1.89
22 2014-7-22 78 67 88 66 85 49 106 1947 1901 0.0 0.14 1.82
23 2014-7-23 69 62 76 66 85 46 102 1947 1934 1.61 0.14 1.61
24 2014-7-24 67 58 76 66 85 52 105 1947 1934 0.0 0.14 1.98
25 2014-7-25 65 56 74 66 85 51 105 1911 1934 0.0 0.13 2.61
26 2014-7-26 75 67 82 66 85 51 98 1911 1941 0.1 0.13 2.41
27 2014-7-27 76 66 85 66 85 51 100 1962 1916 0.22 0.12 1.86
28 2014-7-28 65 57 73 66 85 51 101 2013 1930 0.0 0.12 2.95
29 2014-7-29 64 52 75 66 85 51 100 1881 1941 0.21 0.13 0.8
30 2014-7-30 68 57 78 66 84 51 103 1965 1940 0.02 0.13 1.63
31 2014-7-31 70 59 80 66 84 49 98 1895 1913 0.0 0.12 2.84
32 2014-8-1 72 61 82 65 84 53 97 1971 1887 0.01 0.11 2.86
33 2014-8-2 73 63 82 65 84 52 98 1927 1888 0.0 0.11 2.53
34 2014-8-3 73 61 84 65 84 50 98 1965 1897 0.0 0.11 1.72
35 2014-8-4 74 62 85 65 84 49 99 1912 1887 0.0 0.1 3.81
36 2014-8-5 73 65 81 65 84 51 103 1974 1918 0.0 0.1 1.65
37 2014-8-6 71 63 79 65 84 50 99 1994 1918 0.0 0.11 4.46
38 2014-8-7 71 64 78 65 84 49 98 1989 1930 0.0 0.1 1.08
39 2014-8-8 70 65 74 65 84 48 98 1989 2012 0.03 0.09 1.51
40 2014-8-9 76 68 83 65 84 50 99 1884 1930 0.0 0.1 2.36
41 2014-8-10 77 70 84 65 84 50 99 1972 1911 0.13 0.1 1.25
42 2014-8-11 75 68 82 65 84 52 99 1967 1941 0.1 0.09 2.07
43 2014-8-12 65 58 71 65 84 47 101 2004 1881 0.0 0.1 1.93
44 2014-8-13 67 55 79 65 84 48 98 1964 1936 0.0 0.09 3.08
45 2014-8-14 70 59 81 65 84 48 95 1964 1871 0.0 0.09 2.72
46 2014-8-15 63 49 77 65 84 45 96 1979 2010 0.0 0.1 2.26
47 2014-8-16 67 59 75 65 84 50 102 1979 1988 0.09 0.1 1.43
48 2014-8-17 73 65 81 65 84 52 99 1963 1988 0.03 0.11 3.18
49 2014-8-18 76 65 86 65 84 48 98 1963 1936 0.0 0.11 1.61
50 2014-8-19 76 65 86 64 84 50 100 1896 1936 0.5 0.1 1.65
51 2014-8-20 74 64 83 64 84 50 99 1897 1983 0.0 0.11 2.22
52 2014-8-21 78 70 86 64 84 47 100 1950 1936 0.16 0.1 1.23
53 2014-8-22 80 73 86 64 84 46 101 1950 1936 0.02 0.1 1.9
54 2014-8-23 79 70 88 64 84 46 96 1890 1936 0.81 0.1 2.07
55 2014-8-24 78 70 86 64 84 49 98 1927 1936 0.0 0.09 1.75
56 2014-8-25 81 71 90 64 84 49 96 1887 1948 0.78 0.1 1.41
57 2014-8-26 81 69 93 63 84 48 97 1945 1948 0.26 0.11 1.9
58 2014-8-27 79 70 88 63 84 48 97 1968 1948 0.0 0.1 2.6
59 2014-8-28 75 66 84 63 83 43 96 1986 1953 0.0 0.1 2.44
60 2014-8-29 78 68 87 63 83 41 97 1965 1953 0.0 0.1 1.38
61 2014-8-30 75 71 78 63 83 42 95 1986 1953 0.02 0.1 2.16
62 2014-8-31 76 69 83 62 83 44 97 1915 1951 0.01 0.1 2.43
63 2014-9-1 77 71 82 62 83 44 100 1987 1953 0.0 0.1 7.2
64 2014-9-2 72 65 79 62 82 45 100 1885 1953 1.0 0.1 2.1
65 2014-9-3 74 64 83 61 82 45 100 1952 2011 0.0 0.1 2.63
66 2014-9-4 77 66 87 61 82 46 98 1952 1954 0.0 0.09 6.8
67 2014-9-5 80 70 90 61 82 45 100 1974 1954 0.02 0.1 1.54
68 2014-9-6 67 60 73 60 81 44 99 1988 1954 0.0 0.1 1.19
69 2014-9-7 65 54 76 60 81 42 98 1988 1939 0.0 0.11 2.71
70 2014-9-8 68 56 79 60 81 38 97 1986 1939 0.0 0.1 2.61
71 2014-9-9 69 57 81 59 80 41 98 1883 1939 0.0 0.1 2.34
72 2014-9-10 75 67 82 59 80 40 96 1969 2013 0.9 0.11 2.6
73 2014-9-11 64 56 71 58 80 39 95 1917 1897 0.0 0.11 1.78
74 2014-9-12 59 53 64 58 79 40 96 1955 1897 0.0 0.11 1.08
75 2014-9-13 55 47 63 58 79 39 99 1975 1939 0.0 0.11 1.8
76 2014-9-14 57 46 68 57 79 37 100 1964 1939 0.0 0.11 2.93
77 2014-9-15 57 49 65 57 78 42 100 1974 1939 0.54 0.11 2.21
78 2014-9-16 59 50 67 56 78 39 96 1984 1939 0.01 0.09 2.53
79 2014-9-17 56 45 67 56 77 40 93 1984 1955 0.0 0.1 1.07
80 2014-9-18 61 49 72 55 77 39 95 1959 1953 0.0 0.09 1.64
81 2014-9-19 63 53 73 55 76 38 93 1956 1940 0.0 0.11 2.29
82 2014-9-20 67 54 80 54 76 36 94 1991 1940 0.02 0.1 2.2
83 2014-9-21 65 56 74 54 76 35 96 1875 2010 0.04 0.11 1.61
84 2014-9-22 57 47 66 53 75 37 93 1999 1895 0.0 0.11 1.22
85 2014-9-23 60 47 72 53 75 34 94 1974 2010 0.0 0.11 2.11
86 2014-9-24 62 47 76 53 74 34 92 1887 2007 0.0 0.1 1.29
87 2014-9-25 66 54 78 52 74 35 92 1950 1891 0.0 0.11 2.17
88 2014-9-26 69 55 82 52 73 37 91 2001 1891 0.0 0.1 1.62
89 2014-9-27 69 56 81 51 73 35 93 1991 1998 0.0 0.11 2.59
90 2014-9-28 71 58 83 51 72 33 91 1942 1939 0.0 0.11 1.41
91 2014-9-29 68 54 82 50 72 34 97 1970 1953 0.0 0.1 2.45
92 2014-9-30 62 52 71 50 72 30 89 1899 1971 0.0 0.11 1.88
93 2014-10-1 63 49 76 50 71 32 89 1946 1897 0.0 0.1 2.74
94 2014-10-2 71 60 81 49 71 29 89 1974 1953 0.14 0.11 1.39
95 2014-10-3 59 44 73 49 70 27 90 1974 1954 0.28 0.11 2.61
96 2014-10-4 45 40 49 48 70 31 90 1987 1951 0.0 0.11 1.55
97 2014-10-5 50 40 59 48 69 31 87 1968 1922 0.13 0.1 2.93
98 2014-10-6 55 42 67 48 69 30 89 1980 2007 0.02 0.11 1.45
99 2014-10-7 54 46 62 47 69 27 90 1952 2007 0.33 0.1 1.65
100 2014-10-8 56 43 68 47 68 28 91 1987 2007 0.0 0.1 1.02

Next page

Advanced export

JSON shape: default, array

CSV options:

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