us-weather-history/KPHX

365 rows sorted by record_precipitation

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 ▼
334 2015-5-30 90 74 105 73 99 51 114 1918 1910 0.0 0.01 0.01
351 2015-6-16 99 85 112 78 104 54 115 1907 1974 0.0 0.0 0.01
336 2015-6-1 92 78 105 74 100 50 111 1917 2012 0.0 0.0 0.02
346 2015-6-11 91 82 100 76 103 55 114 1913 1918 0.0 0.0 0.02
349 2015-6-14 95 83 107 77 104 56 115 1922 1974 0.0 0.0 0.02
348 2015-6-13 93 80 105 77 104 59 114 1917 1936 0.0 0.0 0.04
362 2015-6-27 99 90 108 81 106 55 118 1965 1990 0.01 0.0 0.04
329 2015-5-25 80 67 92 72 98 48 108 1965 2001 0.0 0.0 0.05
331 2015-5-27 85 73 97 72 98 48 111 1917 1951 0.0 0.0 0.05
322 2015-5-18 78 65 90 70 95 44 107 1903 1970 0.0 0.0 0.06
342 2015-6-7 86 71 100 75 102 56 115 1963 1985 0.0 0.0 0.06
77 2014-9-15 96 87 105 77 100 53 110 1915 2000 0.0 0.02 0.07
344 2015-6-9 89 83 95 76 103 54 114 1907 1985 0.0 0.0 0.07
361 2015-6-26 98 89 107 81 106 62 122 1963 1990 0.0 0.0 0.07
317 2015-5-13 80 69 91 69 94 48 108 1962 1978 0.0 0.0 0.08
320 2015-5-16 66 57 75 70 95 49 106 1955 1997 0.0 0.0 0.08
333 2015-5-29 88 73 103 73 99 50 112 1918 1910 0.0 0.0 0.08
350 2015-6-15 99 86 112 78 104 54 115 1907 1974 0.0 0.0 0.08
307 2015-5-3 86 75 96 66 91 39 109 1899 1947 0.0 0.0 0.09
321 2015-5-17 75 64 86 70 95 49 108 1943 1970 0.0 0.01 0.09
364 2015-6-29 98 86 110 81 107 59 119 1913 2013 0.05 0.0 0.09
335 2015-5-31 93 78 107 73 100 54 109 1918 2001 0.0 0.0 0.1
341 2015-6-6 85 73 97 75 102 58 110 1967 2002 0.03 0.0 0.11
310 2015-5-6 80 69 90 67 92 44 105 1964 1947 0.0 0.0 0.12
312 2015-5-8 68 61 75 67 92 40 110 1965 1989 0.0 0.0 0.12
327 2015-5-23 74 64 83 71 97 49 109 1965 2001 0.0 0.01 0.12
273 2015-3-30 83 70 96 56 81 38 97 1898 2004 0.0 0.02 0.14
330 2015-5-26 84 71 96 72 98 48 112 1916 1951 0.0 0.01 0.14
337 2015-6-2 90 76 104 74 100 53 110 1917 1977 0.0 0.0 0.14
311 2015-5-7 76 65 86 67 92 45 108 1896 1989 0.0 0.01 0.15
343 2015-6-8 92 78 105 76 102 55 115 1950 1985 0.0 0.0 0.15
355 2015-6-20 96 80 112 79 105 61 115 1964 1968 0.0 0.0 0.15
105 2014-10-13 78 65 90 66 90 48 101 1969 1989 0.0 0.02 0.16
287 2015-4-13 77 63 90 59 84 39 99 1927 1962 0.0 0.01 0.16
339 2015-6-4 85 73 97 75 101 49 113 1908 1990 0.0 0.0 0.16
340 2015-6-5 81 72 90 75 101 55 112 1932 1990 0.16 0.0 0.16
298 2015-4-24 70 62 78 63 88 41 99 1923 1987 0.02 0.0 0.17
304 2015-4-30 85 70 99 65 90 39 102 1967 1943 0.0 0.0 0.17
315 2015-5-11 82 67 96 68 93 43 110 1905 1934 0.0 0.0 0.17
5 2014-7-5 94 84 103 83 107 63 116 1912 1983 0.01 0.02 0.18
281 2015-4-7 71 58 84 58 83 38 104 1922 1989 0.0 0.02 0.19
352 2015-6-17 100 86 114 78 105 54 114 1965 1896 0.0 0.0 0.19
354 2015-6-19 100 85 114 79 105 61 115 1965 1968 0.0 0.0 0.19
300 2015-4-26 65 54 75 63 88 42 101 1964 1992 0.14 0.0 0.2
292 2015-4-18 75 59 90 61 86 38 100 1896 1962 0.0 0.0 0.21
318 2015-5-14 79 70 87 69 94 50 107 1907 1927 0.0 0.0 0.21
365 2015-6-30 96 85 107 82 107 64 115 1913 1950 0.0 0.0 0.21
3 2014-7-3 94 79 108 82 107 64 117 1916 1907 0.0 0.02 0.22
4 2014-7-4 90 81 98 83 107 63 118 1912 1989 0.0 0.02 0.22
116 2014-10-24 82 68 96 62 85 41 96 1920 1959 0.0 0.02 0.22
185 2015-1-1 41 35 46 44 66 24 81 1919 1981 0.0 0.03 0.22
303 2015-4-29 84 71 96 64 89 43 105 1970 1992 0.0 0.01 0.22
316 2015-5-12 81 70 91 68 94 48 109 1905 1996 0.0 0.01 0.22
323 2015-5-19 76 65 87 70 96 48 110 1903 2008 0.0 0.0 0.23
207 2015-1-23 54 43 64 46 68 24 81 1937 2013 0.0 0.03 0.25
261 2015-3-18 72 62 81 54 77 36 94 1954 2007 0.02 0.03 0.25
353 2015-6-18 101 86 115 78 105 54 115 1921 1989 0.0 0.01 0.25
169 2014-12-16 57 49 65 44 65 28 86 1931 1980 0.0 0.03 0.26
345 2015-6-10 88 80 95 76 103 55 111 1965 1978 0.0 0.0 0.26
359 2015-6-24 100 87 112 80 106 62 118 1945 1929 0.0 0.0 0.26
363 2015-6-28 99 87 110 81 106 59 118 1965 1990 0.0 0.01 0.26
264 2015-3-21 73 60 85 54 78 35 97 1955 2004 0.0 0.02 0.27
274 2015-3-31 82 68 95 56 81 32 95 1897 2015 0.0 0.02 0.27
286 2015-4-12 76 65 86 59 84 40 99 1967 1936 0.0 0.01 0.27
305 2015-5-1 86 70 101 65 90 42 103 1915 1985 0.0 0.0 0.27
332 2015-5-28 85 71 98 73 99 53 113 1929 1983 0.0 0.0 0.27
356 2015-6-21 99 88 109 79 105 57 115 1923 1968 0.0 0.0 0.27
109 2014-10-17 80 71 89 64 88 42 102 1938 2009 0.0 0.02 0.28
173 2014-12-20 56 45 66 44 65 24 78 1897 1954 0.0 0.02 0.28
326 2015-5-22 74 66 82 71 97 48 109 1962 2000 0.0 0.0 0.28
44 2014-8-13 84 73 95 83 105 69 115 1949 2012 0.11 0.04 0.3
99 2014-10-7 81 72 90 69 92 44 104 1913 1991 0.0 0.02 0.3
289 2015-4-15 75 65 84 60 85 40 101 1970 1962 0.0 0.0 0.3
92 2014-9-30 78 66 89 72 95 49 107 1965 1980 0.0 0.02 0.31
103 2014-10-11 81 70 92 67 91 45 102 1920 1991 0.0 0.02 0.31
126 2014-11-3 64 53 75 58 81 36 96 1956 2009 0.0 0.02 0.31
189 2015-1-5 57 40 74 45 66 23 80 1950 1927 0.0 0.03 0.31
41 2014-8-10 94 84 104 83 105 68 116 1949 2003 0.0 0.04 0.32
104 2014-10-12 82 70 94 66 90 44 103 1924 1950 0.0 0.02 0.32
108 2014-10-16 80 67 92 65 89 40 101 1899 1991 0.0 0.01 0.32
127 2014-11-4 67 53 81 57 81 32 95 1956 2001 0.0 0.02 0.32
118 2014-10-26 80 71 89 61 85 42 98 1920 2001 0.0 0.02 0.33
299 2015-4-25 69 56 81 63 88 41 102 1964 1898 0.02 0.01 0.33
61 2014-8-30 97 83 111 81 104 64 113 1920 2011 0.0 0.03 0.34
301 2015-4-27 72 57 87 64 89 45 104 1963 1992 0.0 0.01 0.34
328 2015-5-24 76 66 85 72 97 52 109 1944 1983 0.0 0.0 0.34
360 2015-6-25 100 90 110 80 106 60 120 1965 1990 0.0 0.0 0.34
65 2014-9-3 96 84 108 81 103 64 112 1964 1983 0.0 0.03 0.35
206 2015-1-22 57 48 65 46 68 21 81 1937 2013 0.0 0.03 0.35
217 2015-2-2 61 48 73 47 69 29 82 1922 1925 0.0 0.03 0.35
117 2014-10-25 83 70 96 61 85 40 96 1956 1990 0.0 0.02 0.36
131 2014-11-8 74 58 90 56 79 32 91 1897 1906 0.0 0.02 0.36
283 2015-4-9 69 54 83 58 83 40 102 1953 1989 0.0 0.02 0.36
114 2014-10-22 80 67 93 62 86 37 102 1906 2003 0.0 0.02 0.38
288 2015-4-14 81 67 94 60 85 40 103 1945 1925 0.0 0.01 0.38
130 2014-11-7 72 59 84 56 79 34 92 1947 2007 0.0 0.02 0.39
113 2014-10-21 80 69 91 63 87 39 103 1949 2003 0.0 0.02 0.4
154 2014-12-1 62 51 73 47 69 31 83 1918 1949 0.0 0.03 0.4
267 2015-3-24 73 59 86 55 79 36 94 1949 1990 0.0 0.03 0.4
23 2014-7-23 104 94 114 84 106 69 114 1913 2006 0.0 0.04 0.41

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