home / fivethirtyeight

U.S. Weather History: KPHX.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: actual_precipitation, 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 98 86 109 82 107 65 115 1927 1990 0.0 0.02 2.68
2 2014-7-2 98 86 109 82 107 65 118 1911 2011 0.0 0.01 2.81
3 2014-7-3 94 79 108 82 107 64 117 1916 1907 0.0 0.02 0.22
4 2014-7-4 90 81 98 83 107 63 118 1912 1989 0.0 0.02 0.22
5 2014-7-5 94 84 103 83 107 63 116 1912 1983 0.01 0.02 0.18
6 2014-7-6 95 84 105 83 107 65 116 1902 1942 0.0 0.02 0.6
7 2014-7-7 98 88 108 83 107 66 115 1915 1905 0.0 0.02 0.75
8 2014-7-8 96 86 105 83 107 67 115 1955 1985 0.0 0.03 0.53
9 2014-7-9 92 83 101 83 107 66 116 1926 1958 0.0 0.02 0.44
10 2014-7-10 96 87 105 83 107 67 115 1926 1958 0.0 0.03 0.64
11 2014-7-11 98 88 107 84 107 68 118 1944 1958 0.0 0.03 0.48
12 2014-7-12 99 88 110 84 107 69 115 1944 2005 0.0 0.03 1.02
13 2014-7-13 95 80 110 84 107 66 114 1944 1989 0.03 0.03 1.3
14 2014-7-14 92 81 103 84 106 68 116 1962 2003 0.02 0.04 1.24
15 2014-7-15 95 86 103 84 106 66 117 1944 1998 0.0 0.04 0.72
16 2014-7-16 96 84 107 84 106 68 118 1907 1925 0.0 0.04 1.48
17 2014-7-17 96 86 105 84 106 65 116 1908 2005 0.0 0.04 1.31
18 2014-7-18 94 83 105 84 106 68 115 1946 1989 0.0 0.04 1.04
19 2014-7-19 96 88 104 84 106 68 116 1913 1989 0.0 0.04 0.8
20 2014-7-20 96 85 106 84 106 67 114 1900 1978 0.0 0.04 1.7
21 2014-7-21 96 85 107 84 106 65 118 1924 2006 0.0 0.05 1.54
22 2014-7-22 101 89 113 84 106 66 116 1924 2006 0.0 0.04 1.15
23 2014-7-23 104 94 114 84 106 69 114 1913 2006 0.0 0.04 0.41
24 2014-7-24 105 93 116 84 106 68 116 1913 2014 0.0 0.04 1.66
25 2014-7-25 98 87 109 84 106 67 115 1897 1943 0.0 0.05 1.1
26 2014-7-26 96 83 108 84 105 65 116 1952 1995 0.0 0.04 1.38
27 2014-7-27 94 83 104 84 105 65 118 1913 1995 0.0 0.04 1.23
28 2014-7-28 96 85 107 84 105 66 121 1913 1995 0.0 0.05 1.9
29 2014-7-29 101 92 110 84 105 68 115 1913 1995 0.0 0.04 2.05
30 2014-7-30 102 92 111 84 105 66 115 1913 1934 0.0 0.04 1.16
31 2014-7-31 98 87 109 84 105 70 115 1921 1972 0.0 0.04 1.33
32 2014-8-1 90 81 99 84 105 68 116 1950 1972 0.0 0.03 1.48
33 2014-8-2 90 78 102 84 105 70 113 1946 1918 0.0 0.04 1.09
34 2014-8-3 92 80 103 84 105 66 114 1956 1975 0.0 0.04 2.12
35 2014-8-4 92 79 105 84 105 68 116 1956 1975 0.0 0.03 0.78
36 2014-8-5 94 83 105 84 105 69 114 1965 1969 0.0 0.04 1.16
37 2014-8-6 96 84 108 84 105 68 114 1949 1995 0.0 0.03 2.01
38 2014-8-7 94 82 105 83 105 66 112 1928 1905 0.0 0.04 0.87
39 2014-8-8 95 85 105 83 105 67 116 1903 2012 0.0 0.03 0.58
40 2014-8-9 94 84 104 83 105 70 114 1930 2012 0.0 0.03 0.45
41 2014-8-10 94 84 104 83 105 68 116 1949 2003 0.0 0.04 0.32
42 2014-8-11 98 87 109 83 105 65 113 1949 1962 0.0 0.03 0.54
43 2014-8-12 88 77 98 83 105 64 115 1949 2012 0.44 0.03 0.84
44 2014-8-13 84 73 95 83 105 69 115 1949 2012 0.11 0.04 0.3
45 2014-8-14 93 83 102 83 105 69 113 1925 1988 0.0 0.03 1.2
46 2014-8-15 94 83 104 83 105 66 112 1968 1992 0.0 0.03 1.84
47 2014-8-16 97 87 106 83 105 64 113 1918 1992 0.0 0.03 1.32
48 2014-8-17 99 88 109 83 104 64 114 1949 2013 0.0 0.03 0.89
49 2014-8-18 91 83 98 83 104 62 112 1918 2011 0.0 0.03 1.73
50 2014-8-19 83 74 91 83 104 63 113 1918 1986 0.43 0.03 0.78
51 2014-8-20 87 75 98 83 104 58 112 1917 1982 0.0 0.04 1.59
52 2014-8-21 81 71 90 82 104 62 110 1916 2007 0.19 0.03 0.72
53 2014-8-22 83 72 93 82 104 65 113 1917 2011 0.0 0.03 0.5
54 2014-8-23 87 76 97 82 104 61 114 1968 2011 0.0 0.03 0.8
55 2014-8-24 91 79 103 82 104 61 115 1965 1985 0.0 0.04 1.16
56 2014-8-25 92 83 101 82 104 65 113 1965 2011 0.0 0.03 0.9
57 2014-8-26 90 80 100 82 104 65 117 1928 2011 0.0 0.03 0.65
58 2014-8-27 93 83 103 82 104 64 113 1920 1981 0.0 0.03 2.43
59 2014-8-28 95 83 106 82 104 64 113 1920 1998 0.0 0.03 0.94
60 2014-8-29 96 83 108 82 104 64 113 1920 1981 0.0 0.03 0.68
61 2014-8-30 97 83 111 81 104 64 113 1920 2011 0.0 0.03 0.34
62 2014-8-31 96 83 109 81 104 62 113 1962 1950 0.0 0.02 0.61
63 2014-9-1 95 81 108 81 104 63 116 1962 1950 0.0 0.03 1.21
64 2014-9-2 96 82 109 81 103 64 112 1964 1982 0.0 0.02 1.36
65 2014-9-3 96 84 108 81 103 64 112 1964 1983 0.0 0.03 0.35
66 2014-9-4 95 83 107 80 103 60 112 1921 1948 0.0 0.02 2.91
67 2014-9-5 91 80 101 80 103 61 113 1912 1945 0.0 0.03 2.43
68 2014-9-6 96 86 105 80 103 63 111 1921 1986 0.0 0.02 0.43
69 2014-9-7 94 84 104 80 102 61 111 1895 1979 0.0 0.03 0.82
70 2014-9-8 81 71 90 80 102 62 110 1912 1979 3.29 0.02 3.29
71 2014-9-9 86 79 92 79 102 61 110 1920 1974 0.0 0.03 0.66
72 2014-9-10 88 79 97 79 102 59 111 1912 1990 0.0 0.02 1.01
73 2014-9-11 90 79 100 79 102 58 112 1912 1990 0.0 0.02 1.08
74 2014-9-12 91 78 104 78 101 58 110 1920 1971 0.0 0.02 1.9
75 2014-9-13 92 83 100 78 101 55 109 1952 2000 0.0 0.02 1.25
76 2014-9-14 92 81 102 78 101 58 112 1915 2000 0.0 0.02 1.5
77 2014-9-15 96 87 105 77 100 53 110 1915 2000 0.0 0.02 0.07
78 2014-9-16 86 80 92 77 100 56 109 1906 1928 0.01 0.03 1.33
79 2014-9-17 84 78 89 77 100 56 109 1906 1962 0.14 0.01 1.19
80 2014-9-18 86 76 96 76 99 58 109 1950 2010 0.0 0.02 1.46
81 2014-9-19 90 82 98 76 99 54 111 1965 2010 0.0 0.02 1.06
82 2014-9-20 90 81 99 76 99 47 107 1965 2010 0.0 0.02 0.49
83 2014-9-21 90 80 99 75 98 47 107 1965 2003 0.0 0.02 0.63
84 2014-9-22 91 80 101 75 98 47 109 1895 1989 0.0 0.02 0.41
85 2014-9-23 90 77 102 75 98 54 108 1965 1982 0.0 0.02 0.72
86 2014-9-24 91 77 104 74 97 55 108 1968 2002 0.0 0.02 0.68
87 2014-9-25 92 81 103 74 97 49 108 1913 1979 0.0 0.01 0.42
88 2014-9-26 92 82 101 73 96 50 108 1900 1989 0.0 0.02 2.62
89 2014-9-27 82 69 95 73 96 51 107 1920 2009 1.64 0.02 1.64
90 2014-9-28 79 71 87 72 96 50 108 1923 1992 0.02 0.02 1.31
91 2014-9-29 78 67 89 72 95 52 107 1923 2003 0.0 0.02 1.66
92 2014-9-30 78 66 89 72 95 49 107 1965 1980 0.0 0.02 0.31
93 2014-10-1 79 67 91 71 94 49 107 1927 1980 0.0 0.02 0.73
94 2014-10-2 81 69 92 71 94 49 107 1927 1980 0.0 0.02 0.6
95 2014-10-3 83 67 99 70 94 49 105 1907 1988 0.0 0.02 1.29
96 2014-10-4 84 69 99 70 93 46 103 1908 1993 0.0 0.02 0.91
97 2014-10-5 83 69 96 69 93 46 104 1908 1987 0.0 0.02 0.6
98 2014-10-6 82 70 93 69 92 46 105 1913 1917 0.0 0.02 1.17
99 2014-10-7 81 72 90 69 92 44 104 1913 1991 0.0 0.02 0.3
100 2014-10-8 76 69 82 68 92 47 104 1913 1950 0.05 0.02 1.04

Next page

Advanced export

JSON shape: default, array

CSV options:

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