us-weather-history/KPHX

365 rows sorted by date

View and edit SQL

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
93 2014-10-1 79 67 91 71 94 49 107 1927 1980 0.0 0.02 0.73
102 2014-10-10 79 69 89 67 91 44 105 1961 1991 0.0 0.01 0.56
103 2014-10-11 81 70 92 67 91 45 102 1920 1991 0.0 0.02 0.31
104 2014-10-12 82 70 94 66 90 44 103 1924 1950 0.0 0.02 0.32
105 2014-10-13 78 65 90 66 90 48 101 1969 1989 0.0 0.02 0.16
106 2014-10-14 80 65 94 66 89 43 100 1920 1973 0.0 0.02 2.32
107 2014-10-15 80 69 90 65 89 41 103 1899 1991 0.0 0.02 0.72
108 2014-10-16 80 67 92 65 89 40 101 1899 1991 0.0 0.01 0.32
109 2014-10-17 80 71 89 64 88 42 102 1938 2009 0.0 0.02 0.28
110 2014-10-18 79 68 90 64 88 43 103 1966 2003 0.0 0.02 0.75
111 2014-10-19 82 69 94 64 87 40 101 1917 2003 0.08 0.02 1.69
94 2014-10-2 81 69 92 71 94 49 107 1927 1980 0.0 0.02 0.6
112 2014-10-20 78 66 90 63 87 40 103 1949 2003 0.0 0.02 0.41
113 2014-10-21 80 69 91 63 87 39 103 1949 2003 0.0 0.02 0.4
114 2014-10-22 80 67 93 62 86 37 102 1906 2003 0.0 0.02 0.38
115 2014-10-23 81 67 94 62 86 37 100 1906 2003 0.0 0.01 0.52
116 2014-10-24 82 68 96 62 85 41 96 1920 1959 0.0 0.02 0.22
117 2014-10-25 83 70 96 61 85 40 96 1956 1990 0.0 0.02 0.36
118 2014-10-26 80 71 89 61 85 42 98 1920 2001 0.0 0.02 0.33
119 2014-10-27 80 71 88 60 84 39 98 1918 2001 0.0 0.02 1.12
120 2014-10-28 77 65 88 60 84 41 97 1908 2007 0.0 0.01 0.92
121 2014-10-29 78 64 91 60 83 40 95 1971 2007 0.0 0.02 0.48
95 2014-10-3 83 67 99 70 94 49 105 1907 1988 0.0 0.02 1.29
122 2014-10-30 79 64 94 59 83 34 94 1971 1990 0.0 0.02 1.0
123 2014-10-31 81 67 95 59 83 36 96 1900 1988 0.0 0.02 1.05
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
101 2014-10-9 77 70 84 68 91 48 103 1949 1996 0.0 0.02 0.62
124 2014-11-1 76 69 83 58 82 37 96 1971 1924 0.0 0.02 1.25
133 2014-11-10 72 59 84 55 78 33 91 1948 2009 0.0 0.02 2.24
134 2014-11-11 71 58 84 54 78 35 91 1935 1934 0.0 0.01 1.41
135 2014-11-12 70 60 80 54 77 33 93 1898 1999 0.0 0.02 1.02
136 2014-11-13 71 61 80 54 77 31 91 1938 1999 0.0 0.02 0.96
137 2014-11-14 67 61 73 53 76 28 91 1916 1999 0.0 0.02 1.58
138 2014-11-15 67 57 77 53 76 33 90 1925 1999 0.0 0.02 0.58
139 2014-11-16 62 53 71 52 75 32 89 1916 1999 0.0 0.02 0.94
140 2014-11-17 59 47 71 52 75 32 87 1964 2008 0.0 0.01 0.78
141 2014-11-18 61 47 74 52 74 31 88 1958 2008 0.0 0.02 0.65
142 2014-11-19 62 50 74 51 74 30 88 1921 1897 0.0 0.02 0.65
125 2014-11-2 67 60 73 58 82 34 96 1956 1924 0.0 0.02 0.44
143 2014-11-20 61 48 74 51 73 31 89 1956 2006 0.0 0.03 1.16
144 2014-11-21 63 53 72 51 73 30 88 1948 1924 0.0 0.02 0.6
145 2014-11-22 59 46 72 50 72 30 89 1953 1950 0.0 0.02 1.6
146 2014-11-23 61 48 74 50 72 27 87 1931 1950 0.0 0.03 0.98
147 2014-11-24 57 42 71 49 72 28 88 1931 1950 0.0 0.03 0.54
148 2014-11-25 58 46 69 49 71 32 88 1938 1950 0.0 0.03 0.64
149 2014-11-26 59 44 74 49 71 32 88 1966 1950 0.0 0.02 1.02
150 2014-11-27 67 47 87 48 70 31 87 1966 2014 0.0 0.03 1.29
151 2014-11-28 68 52 84 48 70 32 86 1896 1901 0.0 0.03 0.51
152 2014-11-29 66 51 80 48 70 29 85 1919 1999 0.0 0.03 0.72
126 2014-11-3 64 53 75 58 81 36 96 1956 2009 0.0 0.02 0.31
153 2014-11-30 67 53 80 47 69 30 84 1911 1949 0.0 0.02 1.23
127 2014-11-4 67 53 81 57 81 32 95 1956 2001 0.0 0.02 0.32
128 2014-11-5 73 60 85 57 80 32 93 1922 2007 0.0 0.02 0.63
129 2014-11-6 73 60 86 56 80 34 94 1922 2007 0.0 0.02 0.5
130 2014-11-7 72 59 84 56 79 34 92 1947 2007 0.0 0.02 0.39
131 2014-11-8 74 58 90 56 79 32 91 1897 1906 0.0 0.02 0.36
132 2014-11-9 74 61 87 55 79 31 88 1897 1973 0.0 0.02 0.55
154 2014-12-1 62 51 73 47 69 31 83 1918 1949 0.0 0.03 0.4
163 2014-12-10 66 54 77 45 66 29 87 1967 1950 0.0 0.03 1.12
164 2014-12-11 66 56 76 45 66 26 81 1916 1950 0.0 0.03 0.87
165 2014-12-12 68 57 78 45 66 28 79 1971 2010 0.0 0.03 0.72
166 2014-12-13 59 51 66 45 66 26 82 1911 2010 0.08 0.03 1.04
167 2014-12-14 55 46 63 45 66 24 78 1901 2010 0.0 0.03 1.43
168 2014-12-15 55 46 64 44 66 26 79 1916 1952 0.0 0.03 0.86
169 2014-12-16 57 49 65 44 65 28 86 1931 1980 0.0 0.03 0.26
170 2014-12-17 56 51 61 44 65 28 82 1927 2013 0.07 0.03 1.35
171 2014-12-18 56 50 62 44 65 29 79 1933 1950 0.0 0.03 1.02
172 2014-12-19 55 45 64 44 65 25 79 1968 1917 0.0 0.03 0.98
155 2014-12-2 62 54 70 47 68 30 81 1913 1940 0.03 0.02 0.41
173 2014-12-20 56 45 66 44 65 24 78 1897 1954 0.0 0.02 0.28
174 2014-12-21 56 47 65 44 65 27 77 1897 1985 0.0 0.03 0.52
175 2014-12-22 57 47 66 44 65 23 79 1897 1917 0.0 0.03 0.96
176 2014-12-23 58 47 68 44 65 26 79 1990 1950 0.0 0.02 0.83
177 2014-12-24 55 43 66 44 65 25 81 1953 1955 0.0 0.03 0.93
178 2014-12-25 55 45 64 44 65 27 78 1953 1950 0.0 0.03 0.63
179 2014-12-26 48 38 57 44 65 22 78 1911 1980 0.0 0.02 0.56
180 2014-12-27 48 35 60 44 65 24 82 1911 1980 0.0 0.03 1.05
181 2014-12-28 48 36 60 44 65 24 78 1954 1917 0.0 0.03 0.79
182 2014-12-29 49 36 61 44 65 26 85 1966 1980 0.0 0.03 0.47
156 2014-12-3 68 60 76 47 68 30 81 1934 1940 0.01 0.03 0.69
183 2014-12-30 50 37 63 44 65 23 81 1895 1980 0.0 0.03 1.5
184 2014-12-31 43 36 50 44 66 22 79 1900 1897 0.11 0.03 0.8
157 2014-12-4 64 60 68 46 68 28 83 1909 1979 0.61 0.03 0.91
158 2014-12-5 65 57 72 46 68 25 82 1909 1965 0.0 0.03 0.67
159 2014-12-6 64 57 71 46 67 27 83 1960 1939 0.0 0.03 0.5
160 2014-12-7 64 51 77 46 67 27 83 1948 1939 0.0 0.02 1.08
161 2014-12-8 66 55 76 45 67 24 84 1916 1939 0.0 0.03 1.06
162 2014-12-9 66 54 78 45 67 24 84 1916 1981 0.0 0.03 0.77
1 2014-7-1 98 86 109 82 107 65 115 1927 1990 0.0 0.02 2.68
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

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
);
Powered by Datasette · Query took 46.062ms