us-weather-history/KPHX

365 rows sorted by record_min_temp_year

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
69 2014-9-7 94 84 104 80 102 61 111 1895 1979 0.0 0.03 0.82
84 2014-9-22 91 80 101 75 98 47 109 1895 1989 0.0 0.02 0.41
183 2014-12-30 50 37 63 44 65 23 81 1895 1980 0.0 0.03 1.5
151 2014-11-28 68 52 84 48 70 32 86 1896 1901 0.0 0.03 0.51
292 2015-4-18 75 59 90 61 86 38 100 1896 1962 0.0 0.0 0.21
302 2015-4-28 81 68 93 64 89 45 104 1896 1992 0.0 0.0 0.65
311 2015-5-7 76 65 86 67 92 45 108 1896 1989 0.0 0.01 0.15
25 2014-7-25 98 87 109 84 106 67 115 1897 1943 0.0 0.05 1.1
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
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
265 2015-3-22 75 60 89 55 78 32 94 1897 1990 0.0 0.03 0.81
266 2015-3-23 75 61 88 55 79 31 93 1897 1990 0.0 0.03 0.52
274 2015-3-31 82 68 95 56 81 32 95 1897 2015 0.0 0.02 0.27
135 2014-11-12 70 60 80 54 77 33 93 1898 1999 0.0 0.02 1.02
209 2015-1-25 63 48 78 46 68 23 83 1898 1951 0.0 0.03 0.71
262 2015-3-19 65 60 70 54 78 34 92 1898 2004 0.01 0.04 0.54
263 2015-3-20 71 61 81 54 78 35 95 1898 2004 0.0 0.03 0.86
270 2015-3-27 79 63 95 55 80 33 98 1898 1986 0.0 0.02 0.65
271 2015-3-28 80 64 95 56 80 34 95 1898 1986 0.0 0.02 0.91
273 2015-3-30 83 70 96 56 81 38 97 1898 2004 0.0 0.02 0.14
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
222 2015-2-7 67 53 81 48 70 24 89 1899 1963 0.0 0.03 0.74
254 2015-3-11 73 59 87 53 76 33 94 1899 1900 0.0 0.03 1.4
307 2015-5-3 86 75 96 66 91 39 109 1899 1947 0.0 0.0 0.09
308 2015-5-4 75 65 85 66 91 45 106 1899 1947 0.24 0.01 0.91
20 2014-7-20 96 85 106 84 106 67 114 1900 1978 0.0 0.04 1.7
88 2014-9-26 92 82 101 73 96 50 108 1900 1989 0.0 0.02 2.62
123 2014-10-31 81 67 95 59 83 36 96 1900 1988 0.0 0.02 1.05
184 2014-12-31 43 36 50 44 66 22 79 1900 1897 0.11 0.03 0.8
167 2014-12-14 55 46 63 45 66 24 78 1901 2010 0.0 0.03 1.43
6 2014-7-6 95 84 105 83 107 65 116 1902 1942 0.0 0.02 0.6
324 2015-5-20 80 67 93 71 96 49 108 1902 2008 0.0 0.01 0.73
325 2015-5-21 82 72 91 71 96 48 109 1902 2005 0.0 0.0 0.42
39 2014-8-8 95 85 105 83 105 67 116 1903 2012 0.0 0.03 0.58
322 2015-5-18 78 65 90 70 95 44 107 1903 1970 0.0 0.0 0.06
323 2015-5-19 76 65 87 70 96 48 110 1903 2008 0.0 0.0 0.23
275 2015-4-1 79 67 91 56 81 37 100 1904 2011 0.0 0.02 0.46
296 2015-4-22 77 65 89 62 87 39 105 1904 2012 0.0 0.01 0.9
315 2015-5-11 82 67 96 68 93 43 110 1905 1934 0.0 0.0 0.17
316 2015-5-12 81 70 91 68 94 48 109 1905 1996 0.0 0.01 0.22
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
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
277 2015-4-3 73 60 86 57 82 38 97 1906 1943 0.0 0.02 0.69
16 2014-7-16 96 84 107 84 106 68 118 1907 1925 0.0 0.04 1.48
95 2014-10-3 83 67 99 70 94 49 105 1907 1988 0.0 0.02 1.29
272 2015-3-29 81 65 97 56 80 36 97 1907 2015 0.0 0.02 0.42
318 2015-5-14 79 70 87 69 94 50 107 1907 1927 0.0 0.0 0.21
344 2015-6-9 89 83 95 76 103 54 114 1907 1985 0.0 0.0 0.07
350 2015-6-15 99 86 112 78 104 54 115 1907 1974 0.0 0.0 0.08
351 2015-6-16 99 85 112 78 104 54 115 1907 1974 0.0 0.0 0.01
17 2014-7-17 96 86 105 84 106 65 116 1908 2005 0.0 0.04 1.31
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
120 2014-10-28 77 65 88 60 84 41 97 1908 2007 0.0 0.01 0.92
339 2015-6-4 85 73 97 75 101 49 113 1908 1990 0.0 0.0 0.16
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
255 2015-3-12 77 68 86 53 76 34 94 1909 1900 0.0 0.04 1.1
280 2015-4-6 74 61 86 57 82 38 102 1909 1989 0.0 0.02 0.56
232 2015-2-17 66 55 77 49 71 26 88 1910 2014 0.0 0.04 0.57
2 2014-7-2 98 86 109 82 107 65 118 1911 2011 0.0 0.01 2.81
153 2014-11-30 67 53 80 47 69 30 84 1911 1949 0.0 0.02 1.23
166 2014-12-13 59 51 66 45 66 26 82 1911 2010 0.08 0.03 1.04
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
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
67 2014-9-5 91 80 101 80 103 61 113 1912 1945 0.0 0.03 2.43
70 2014-9-8 81 71 90 80 102 62 110 1912 1979 3.29 0.02 3.29
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
19 2014-7-19 96 88 104 84 106 68 116 1913 1989 0.0 0.04 0.8
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
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
87 2014-9-25 92 81 103 74 97 49 108 1913 1979 0.0 0.01 0.42
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
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
191 2015-1-7 64 47 81 45 66 16 81 1913 2015 0.0 0.03 0.67
192 2015-1-8 63 54 71 45 66 19 81 1913 2002 0.0 0.03 1.22
269 2015-3-26 77 64 89 55 79 35 100 1913 1988 0.0 0.03 1.19
346 2015-6-11 91 82 100 76 103 55 114 1913 1918 0.0 0.0 0.02
347 2015-6-12 91 78 104 77 103 59 112 1913 1974 0.0 0.0 0.92
364 2015-6-29 98 86 110 81 107 59 119 1913 2013 0.05 0.0 0.09
365 2015-6-30 96 85 107 82 107 64 115 1913 1950 0.0 0.0 0.21
7 2014-7-7 98 88 108 83 107 66 115 1915 1905 0.0 0.02 0.75
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

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