us-weather-history/KPHX

365 rows sorted by actual_mean_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
182 2014-12-29 49 36 61 44 65 26 85 1966 1980 0.0 0.03 0.47
183 2014-12-30 50 37 63 44 65 23 81 1895 1980 0.0 0.03 1.5
188 2015-1-4 50 35 65 45 66 23 83 1950 1927 0.0 0.03 0.65
207 2015-1-23 54 43 64 46 68 24 81 1937 2013 0.0 0.03 0.25
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
172 2014-12-19 55 45 64 44 65 25 79 1968 1917 0.0 0.03 0.98
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
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
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
246 2015-3-3 56 47 65 51 74 28 91 1966 1921 0.07 0.04 1.98
147 2014-11-24 57 42 71 49 72 28 88 1931 1950 0.0 0.03 0.54
169 2014-12-16 57 49 65 44 65 28 86 1931 1980 0.0 0.03 0.26
175 2014-12-22 57 47 66 44 65 23 79 1897 1917 0.0 0.03 0.96
189 2015-1-5 57 40 74 45 66 23 80 1950 1927 0.0 0.03 0.31
197 2015-1-13 57 51 63 45 67 20 79 1963 1904 0.11 0.03 0.81
198 2015-1-14 57 46 67 45 67 22 81 1963 2000 0.0 0.04 0.77
206 2015-1-22 57 48 65 46 68 21 81 1937 2013 0.0 0.03 0.35
215 2015-1-31 57 53 60 47 69 27 86 1949 2003 0.07 0.03 0.59
148 2014-11-25 58 46 69 49 71 32 88 1938 1950 0.0 0.03 0.64
176 2014-12-23 58 47 68 44 65 26 79 1990 1950 0.0 0.02 0.83
214 2015-1-30 58 55 60 47 69 28 82 1970 1935 0.35 0.03 1.19
140 2014-11-17 59 47 71 52 75 32 87 1964 2008 0.0 0.01 0.78
145 2014-11-22 59 46 72 50 72 30 89 1953 1950 0.0 0.02 1.6
149 2014-11-26 59 44 74 49 71 32 88 1966 1950 0.0 0.02 1.02
166 2014-12-13 59 51 66 45 66 26 82 1911 2010 0.08 0.03 1.04
239 2015-2-24 59 51 67 50 72 29 91 1964 1904 0.0 0.04 1.46
245 2015-3-2 59 52 66 51 74 30 90 1971 1921 0.23 0.04 0.74
247 2015-3-4 59 47 70 52 74 25 88 1966 1972 0.0 0.04 1.16
194 2015-1-10 60 54 65 45 67 25 84 1964 1990 0.0 0.03 1.51
199 2015-1-15 60 47 72 46 67 23 81 1964 2000 0.0 0.03 0.69
201 2015-1-17 60 47 73 46 67 26 83 1964 1976 0.0 0.03 1.07
216 2015-2-1 60 50 69 47 69 28 83 1985 2003 0.0 0.03 1.13
240 2015-2-25 60 47 72 50 72 29 92 1960 1921 0.0 0.04 0.81
141 2014-11-18 61 47 74 52 74 31 88 1958 2008 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
217 2015-2-2 61 48 73 47 69 29 82 1922 1925 0.0 0.03 0.35
248 2015-3-5 61 46 75 52 74 31 93 1966 1972 0.0 0.03 0.97
139 2014-11-16 62 53 71 52 75 32 89 1916 1999 0.0 0.02 0.94
142 2014-11-19 62 50 74 51 74 30 88 1921 1897 0.0 0.02 0.65
154 2014-12-1 62 51 73 47 69 31 83 1918 1949 0.0 0.03 0.4
155 2014-12-2 62 54 70 47 68 30 81 1913 1940 0.03 0.02 0.41
190 2015-1-6 62 44 79 45 66 17 81 1913 2006 0.0 0.03 0.76
196 2015-1-12 62 56 67 45 67 22 80 1962 1996 0.02 0.03 1.04
200 2015-1-16 62 49 74 46 67 22 83 1964 1976 0.0 0.03 1.05
202 2015-1-18 62 48 75 46 68 27 80 1915 1971 0.0 0.03 0.51
204 2015-1-20 62 48 75 46 68 22 84 1963 1950 0.0 0.03 0.77
210 2015-1-26 62 53 71 46 68 26 81 1950 1987 0.01 0.03 1.18
144 2014-11-21 63 53 72 51 73 30 88 1948 1924 0.0 0.02 0.6
192 2015-1-8 63 54 71 45 66 19 81 1913 2002 0.0 0.03 1.22
193 2015-1-9 63 51 75 45 66 24 84 1964 1923 0.0 0.03 1.18
195 2015-1-11 63 54 72 45 67 20 83 1964 1953 0.01 0.03 1.74
203 2015-1-19 63 50 75 46 68 27 88 1915 1971 0.0 0.03 0.87
209 2015-1-25 63 48 78 46 68 23 83 1898 1951 0.0 0.03 0.71
218 2015-2-3 63 50 76 47 69 28 86 1922 1925 0.0 0.03 1.06
126 2014-11-3 64 53 75 58 81 36 96 1956 2009 0.0 0.02 0.31
157 2014-12-4 64 60 68 46 68 28 83 1909 1979 0.61 0.03 0.91
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
191 2015-1-7 64 47 81 45 66 16 81 1913 2015 0.0 0.03 0.67
205 2015-1-21 64 53 74 46 68 24 81 1922 2014 0.0 0.02 1.33
208 2015-1-24 64 50 77 46 68 24 80 1937 1951 0.0 0.02 0.51
211 2015-1-27 64 53 74 47 68 26 82 1950 2003 0.0 0.03 0.87
212 2015-1-28 64 52 75 47 69 30 83 1937 1971 0.0 0.02 0.57
237 2015-2-22 64 56 72 50 72 26 87 1955 1982 0.0 0.04 0.45
241 2015-2-26 64 51 77 51 73 33 91 1919 1986 0.0 0.04 0.62
242 2015-2-27 64 50 78 51 73 28 92 1964 1986 0.0 0.03 0.57
158 2014-12-5 65 57 72 46 68 25 82 1909 1965 0.0 0.03 0.67
213 2015-1-29 65 58 71 47 69 27 83 1948 1935 0.24 0.03 1.45
219 2015-2-4 65 52 77 47 69 27 85 1955 1963 0.0 0.02 0.89
233 2015-2-18 65 50 79 49 71 29 86 1964 1977 0.0 0.03 0.72
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
262 2015-3-19 65 60 70 54 78 34 92 1898 2004 0.01 0.04 0.54
300 2015-4-26 65 54 75 63 88 42 101 1964 1992 0.14 0.0 0.2
152 2014-11-29 66 51 80 48 70 29 85 1919 1999 0.0 0.03 0.72
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
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
232 2015-2-17 66 55 77 49 71 26 88 1910 2014 0.0 0.04 0.57
234 2015-2-19 66 52 80 49 71 29 88 1955 1977 0.0 0.04 0.93
290 2015-4-16 66 56 75 60 85 40 101 1924 1984 0.0 0.01 0.67
320 2015-5-16 66 57 75 70 95 49 106 1955 1997 0.0 0.0 0.08
125 2014-11-2 67 60 73 58 82 34 96 1956 1924 0.0 0.02 0.44
127 2014-11-4 67 53 81 57 81 32 95 1956 2001 0.0 0.02 0.32
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
150 2014-11-27 67 47 87 48 70 31 87 1966 2014 0.0 0.03 1.29

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.2ms