us-weather-history/KPHX

365 rows sorted by actual_max_temp

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
185 2015-1-1 41 35 46 44 66 24 81 1919 1981 0.0 0.03 0.22
184 2014-12-31 43 36 50 44 66 22 79 1900 1897 0.11 0.03 0.8
186 2015-1-2 43 31 54 45 66 23 81 1919 1981 0.0 0.03 0.99
187 2015-1-3 44 34 54 45 66 25 79 1950 1956 0.0 0.03 0.82
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
214 2015-1-30 58 55 60 47 69 28 82 1970 1935 0.35 0.03 1.19
215 2015-1-31 57 53 60 47 69 27 86 1949 2003 0.07 0.03 0.59
170 2014-12-17 56 51 61 44 65 28 82 1927 2013 0.07 0.03 1.35
182 2014-12-29 49 36 61 44 65 26 85 1966 1980 0.0 0.03 0.47
171 2014-12-18 56 50 62 44 65 29 79 1933 1950 0.0 0.03 1.02
167 2014-12-14 55 46 63 45 66 24 78 1901 2010 0.0 0.03 1.43
183 2014-12-30 50 37 63 44 65 23 81 1895 1980 0.0 0.03 1.5
197 2015-1-13 57 51 63 45 67 20 79 1963 1904 0.11 0.03 0.81
168 2014-12-15 55 46 64 44 66 26 79 1916 1952 0.0 0.03 0.86
172 2014-12-19 55 45 64 44 65 25 79 1968 1917 0.0 0.03 0.98
178 2014-12-25 55 45 64 44 65 27 78 1953 1950 0.0 0.03 0.63
207 2015-1-23 54 43 64 46 68 24 81 1937 2013 0.0 0.03 0.25
169 2014-12-16 57 49 65 44 65 28 86 1931 1980 0.0 0.03 0.26
174 2014-12-21 56 47 65 44 65 27 77 1897 1985 0.0 0.03 0.52
188 2015-1-4 50 35 65 45 66 23 83 1950 1927 0.0 0.03 0.65
194 2015-1-10 60 54 65 45 67 25 84 1964 1990 0.0 0.03 1.51
206 2015-1-22 57 48 65 46 68 21 81 1937 2013 0.0 0.03 0.35
246 2015-3-3 56 47 65 51 74 28 91 1966 1921 0.07 0.04 1.98
166 2014-12-13 59 51 66 45 66 26 82 1911 2010 0.08 0.03 1.04
173 2014-12-20 56 45 66 44 65 24 78 1897 1954 0.0 0.02 0.28
175 2014-12-22 57 47 66 44 65 23 79 1897 1917 0.0 0.03 0.96
177 2014-12-24 55 43 66 44 65 25 81 1953 1955 0.0 0.03 0.93
245 2015-3-2 59 52 66 51 74 30 90 1971 1921 0.23 0.04 0.74
196 2015-1-12 62 56 67 45 67 22 80 1962 1996 0.02 0.03 1.04
198 2015-1-14 57 46 67 45 67 22 81 1963 2000 0.0 0.04 0.77
239 2015-2-24 59 51 67 50 72 29 91 1964 1904 0.0 0.04 1.46
157 2014-12-4 64 60 68 46 68 28 83 1909 1979 0.61 0.03 0.91
176 2014-12-23 58 47 68 44 65 26 79 1990 1950 0.0 0.02 0.83
148 2014-11-25 58 46 69 49 71 32 88 1938 1950 0.0 0.03 0.64
216 2015-2-1 60 50 69 47 69 28 83 1985 2003 0.0 0.03 1.13
155 2014-12-2 62 54 70 47 68 30 81 1913 1940 0.03 0.02 0.41
238 2015-2-23 65 59 70 50 72 29 89 1955 1989 0.01 0.03 0.94
243 2015-2-28 65 60 70 51 73 30 89 1962 1986 0.0 0.04 0.75
247 2015-3-4 59 47 70 52 74 25 88 1966 1972 0.0 0.04 1.16
262 2015-3-19 65 60 70 54 78 34 92 1898 2004 0.01 0.04 0.54
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
147 2014-11-24 57 42 71 49 72 28 88 1931 1950 0.0 0.03 0.54
159 2014-12-6 64 57 71 46 67 27 83 1960 1939 0.0 0.03 0.5
192 2015-1-8 63 54 71 45 66 19 81 1913 2002 0.0 0.03 1.22
210 2015-1-26 62 53 71 46 68 26 81 1950 1987 0.01 0.03 1.18
213 2015-1-29 65 58 71 47 69 27 83 1948 1935 0.24 0.03 1.45
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
158 2014-12-5 65 57 72 46 68 25 82 1909 1965 0.0 0.03 0.67
195 2015-1-11 63 54 72 45 67 20 83 1964 1953 0.01 0.03 1.74
199 2015-1-15 60 47 72 46 67 23 81 1964 2000 0.0 0.03 0.69
237 2015-2-22 64 56 72 50 72 26 87 1955 1982 0.0 0.04 0.45
240 2015-2-25 60 47 72 50 72 29 92 1960 1921 0.0 0.04 0.81
125 2014-11-2 67 60 73 58 82 34 96 1956 1924 0.0 0.02 0.44
137 2014-11-14 67 61 73 53 76 28 91 1916 1999 0.0 0.02 1.58
154 2014-12-1 62 51 73 47 69 31 83 1918 1949 0.0 0.03 0.4
201 2015-1-17 60 47 73 46 67 26 83 1964 1976 0.0 0.03 1.07
217 2015-2-2 61 48 73 47 69 29 82 1922 1925 0.0 0.03 0.35
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
143 2014-11-20 61 48 74 51 73 31 89 1956 2006 0.0 0.03 1.16
146 2014-11-23 61 48 74 50 72 27 87 1931 1950 0.0 0.03 0.98
149 2014-11-26 59 44 74 49 71 32 88 1966 1950 0.0 0.02 1.02
189 2015-1-5 57 40 74 45 66 23 80 1950 1927 0.0 0.03 0.31
200 2015-1-16 62 49 74 46 67 22 83 1964 1976 0.0 0.03 1.05
205 2015-1-21 64 53 74 46 68 24 81 1922 2014 0.0 0.02 1.33
211 2015-1-27 64 53 74 47 68 26 82 1950 2003 0.0 0.03 0.87
126 2014-11-3 64 53 75 58 81 36 96 1956 2009 0.0 0.02 0.31
193 2015-1-9 63 51 75 45 66 24 84 1964 1923 0.0 0.03 1.18
202 2015-1-18 62 48 75 46 68 27 80 1915 1971 0.0 0.03 0.51
203 2015-1-19 63 50 75 46 68 27 88 1915 1971 0.0 0.03 0.87
204 2015-1-20 62 48 75 46 68 22 84 1963 1950 0.0 0.03 0.77
212 2015-1-28 64 52 75 47 69 30 83 1937 1971 0.0 0.02 0.57
248 2015-3-5 61 46 75 52 74 31 93 1966 1972 0.0 0.03 0.97
290 2015-4-16 66 56 75 60 85 40 101 1924 1984 0.0 0.01 0.67
300 2015-4-26 65 54 75 63 88 42 101 1964 1992 0.14 0.0 0.2
312 2015-5-8 68 61 75 67 92 40 110 1965 1989 0.0 0.0 0.12
320 2015-5-16 66 57 75 70 95 49 106 1955 1997 0.0 0.0 0.08
156 2014-12-3 68 60 76 47 68 30 81 1934 1940 0.01 0.03 0.69
161 2014-12-8 66 55 76 45 67 24 84 1916 1939 0.0 0.03 1.06
164 2014-12-11 66 56 76 45 66 26 81 1916 1950 0.0 0.03 0.87
218 2015-2-3 63 50 76 47 69 28 86 1922 1925 0.0 0.03 1.06
319 2015-5-15 67 57 76 69 95 50 107 1968 1937 0.93 0.01 0.93
138 2014-11-15 67 57 77 53 76 33 90 1925 1999 0.0 0.02 0.58
160 2014-12-7 64 51 77 46 67 27 83 1948 1939 0.0 0.02 1.08
163 2014-12-10 66 54 77 45 66 29 87 1967 1950 0.0 0.03 1.12
208 2015-1-24 64 50 77 46 68 24 80 1937 1951 0.0 0.02 0.51
219 2015-2-4 65 52 77 47 69 27 85 1955 1963 0.0 0.02 0.89
232 2015-2-17 66 55 77 49 71 26 88 1910 2014 0.0 0.04 0.57
241 2015-2-26 64 51 77 51 73 33 91 1919 1986 0.0 0.04 0.62
244 2015-3-1 69 61 77 51 73 31 89 1964 1986 0.0 0.04 0.94
313 2015-5-9 67 57 77 68 93 45 108 1950 1934 0.0 0.0 0.46
162 2014-12-9 66 54 78 45 67 24 84 1916 1981 0.0 0.03 0.77
165 2014-12-12 68 57 78 45 66 28 79 1971 2010 0.0 0.03 0.72
209 2015-1-25 63 48 78 46 68 23 83 1898 1951 0.0 0.03 0.71
227 2015-2-12 68 58 78 48 70 28 84 1965 1971 0.0 0.02 0.74
242 2015-2-27 64 50 78 51 73 28 92 1964 1986 0.0 0.03 0.57

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 45.27ms