U.S. Weather History: KPHX.csv

Table actions

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 · About: simonw/fivethirtyeight-datasette

365 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
);