us-weather-history/KPHX

365 rows sorted by average_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
289 2015-4-15 75 65 84 60 85 40 101 1970 1962 0.0 0.0 0.3
292 2015-4-18 75 59 90 61 86 38 100 1896 1962 0.0 0.0 0.21
295 2015-4-21 78 65 91 62 87 42 103 1967 1989 0.0 0.0 0.44
297 2015-4-23 73 62 83 62 87 40 103 1923 2012 0.0 0.0 0.57
298 2015-4-24 70 62 78 63 88 41 99 1923 1987 0.02 0.0 0.17
300 2015-4-26 65 54 75 63 88 42 101 1964 1992 0.14 0.0 0.2
302 2015-4-28 81 68 93 64 89 45 104 1896 1992 0.0 0.0 0.65
304 2015-4-30 85 70 99 65 90 39 102 1967 1943 0.0 0.0 0.17
305 2015-5-1 86 70 101 65 90 42 103 1915 1985 0.0 0.0 0.27
307 2015-5-3 86 75 96 66 91 39 109 1899 1947 0.0 0.0 0.09
309 2015-5-5 77 67 86 66 91 45 105 1964 1989 0.0 0.0 0.46
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
313 2015-5-9 67 57 77 68 93 45 108 1950 1934 0.0 0.0 0.46
315 2015-5-11 82 67 96 68 93 43 110 1905 1934 0.0 0.0 0.17
317 2015-5-13 80 69 91 69 94 48 108 1962 1978 0.0 0.0 0.08
318 2015-5-14 79 70 87 69 94 50 107 1907 1927 0.0 0.0 0.21
320 2015-5-16 66 57 75 70 95 49 106 1955 1997 0.0 0.0 0.08
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
325 2015-5-21 82 72 91 71 96 48 109 1902 2005 0.0 0.0 0.42
326 2015-5-22 74 66 82 71 97 48 109 1962 2000 0.0 0.0 0.28
328 2015-5-24 76 66 85 72 97 52 109 1944 1983 0.0 0.0 0.34
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
332 2015-5-28 85 71 98 73 99 53 113 1929 1983 0.0 0.0 0.27
333 2015-5-29 88 73 103 73 99 50 112 1918 1910 0.0 0.0 0.08
335 2015-5-31 93 78 107 73 100 54 109 1918 2001 0.0 0.0 0.1
336 2015-6-1 92 78 105 74 100 50 111 1917 2012 0.0 0.0 0.02
337 2015-6-2 90 76 104 74 100 53 110 1917 1977 0.0 0.0 0.14
338 2015-6-3 88 74 102 74 101 51 112 1965 2006 0.0 0.0 0.41
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
341 2015-6-6 85 73 97 75 102 58 110 1967 2002 0.03 0.0 0.11
342 2015-6-7 86 71 100 75 102 56 115 1963 1985 0.0 0.0 0.06
343 2015-6-8 92 78 105 76 102 55 115 1950 1985 0.0 0.0 0.15
344 2015-6-9 89 83 95 76 103 54 114 1907 1985 0.0 0.0 0.07
345 2015-6-10 88 80 95 76 103 55 111 1965 1978 0.0 0.0 0.26
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
348 2015-6-13 93 80 105 77 104 59 114 1917 1936 0.0 0.0 0.04
349 2015-6-14 95 83 107 77 104 56 115 1922 1974 0.0 0.0 0.02
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
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
355 2015-6-20 96 80 112 79 105 61 115 1964 1968 0.0 0.0 0.15
356 2015-6-21 99 88 109 79 105 57 115 1923 1968 0.0 0.0 0.27
357 2015-6-22 97 85 109 80 106 56 116 1965 1988 0.0 0.0 1.37
358 2015-6-23 99 87 111 80 106 61 116 1923 1974 0.0 0.0 0.84
359 2015-6-24 100 87 112 80 106 62 118 1945 1929 0.0 0.0 0.26
360 2015-6-25 100 90 110 80 106 60 120 1965 1990 0.0 0.0 0.34
361 2015-6-26 98 89 107 81 106 62 122 1963 1990 0.0 0.0 0.07
362 2015-6-27 99 90 108 81 106 55 118 1965 1990 0.01 0.0 0.04
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
2 2014-7-2 98 86 109 82 107 65 118 1911 2011 0.0 0.01 2.81
79 2014-9-17 84 78 89 77 100 56 109 1906 1962 0.14 0.01 1.19
87 2014-9-25 92 81 103 74 97 49 108 1913 1979 0.0 0.01 0.42
102 2014-10-10 79 69 89 67 91 44 105 1961 1991 0.0 0.01 0.56
108 2014-10-16 80 67 92 65 89 40 101 1899 1991 0.0 0.01 0.32
115 2014-10-23 81 67 94 62 86 37 100 1906 2003 0.0 0.01 0.52
120 2014-10-28 77 65 88 60 84 41 97 1908 2007 0.0 0.01 0.92
134 2014-11-11 71 58 84 54 78 35 91 1935 1934 0.0 0.01 1.41
140 2014-11-17 59 47 71 52 75 32 87 1964 2008 0.0 0.01 0.78
276 2015-4-2 76 64 87 57 81 37 98 1917 1943 0.0 0.01 0.68
279 2015-4-5 75 61 89 57 82 37 98 1921 1989 0.0 0.01 1.3
282 2015-4-8 70 61 78 58 83 39 104 1929 1989 0.0 0.01 0.99
284 2015-4-10 72 57 87 58 84 35 100 1922 1989 0.0 0.01 0.83
285 2015-4-11 73 60 86 59 84 39 98 1979 1989 0.0 0.01 1.05
286 2015-4-12 76 65 86 59 84 40 99 1967 1936 0.0 0.01 0.27
287 2015-4-13 77 63 90 59 84 39 99 1927 1962 0.0 0.01 0.16
288 2015-4-14 81 67 94 60 85 40 103 1945 1925 0.0 0.01 0.38
290 2015-4-16 66 56 75 60 85 40 101 1924 1984 0.0 0.01 0.67
291 2015-4-17 69 55 82 61 86 38 100 1924 1987 0.0 0.01 0.45
293 2015-4-19 77 62 92 61 86 37 103 1968 1989 0.0 0.01 0.82
294 2015-4-20 79 65 93 61 87 38 105 1933 1989 0.0 0.01 0.41
296 2015-4-22 77 65 89 62 87 39 105 1904 2012 0.0 0.01 0.9
299 2015-4-25 69 56 81 63 88 41 102 1964 1898 0.02 0.01 0.33
301 2015-4-27 72 57 87 64 89 45 104 1963 1992 0.0 0.01 0.34
303 2015-4-29 84 71 96 64 89 43 105 1970 1992 0.0 0.01 0.22
306 2015-5-2 85 72 98 65 90 40 107 1967 1947 0.0 0.01 0.47
308 2015-5-4 75 65 85 66 91 45 106 1899 1947 0.24 0.01 0.91
311 2015-5-7 76 65 86 67 92 45 108 1896 1989 0.0 0.01 0.15
314 2015-5-10 75 61 89 68 93 46 111 1930 1934 0.0 0.01 0.78
316 2015-5-12 81 70 91 68 94 48 109 1905 1996 0.0 0.01 0.22
319 2015-5-15 67 57 76 69 95 50 107 1968 1937 0.93 0.01 0.93
321 2015-5-17 75 64 86 70 95 49 108 1943 1970 0.0 0.01 0.09
324 2015-5-20 80 67 93 71 96 49 108 1902 2008 0.0 0.01 0.73
327 2015-5-23 74 64 83 71 97 49 109 1965 2001 0.0 0.01 0.12
330 2015-5-26 84 71 96 72 98 48 112 1916 1951 0.0 0.01 0.14
334 2015-5-30 90 74 105 73 99 51 114 1918 1910 0.0 0.01 0.01
353 2015-6-18 101 86 115 78 105 54 115 1921 1989 0.0 0.01 0.25
363 2015-6-28 99 87 110 81 106 59 118 1965 1990 0.0 0.01 0.26
1 2014-7-1 98 86 109 82 107 65 115 1927 1990 0.0 0.02 2.68
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
5 2014-7-5 94 84 103 83 107 63 116 1912 1983 0.01 0.02 0.18
6 2014-7-6 95 84 105 83 107 65 116 1902 1942 0.0 0.02 0.6
7 2014-7-7 98 88 108 83 107 66 115 1915 1905 0.0 0.02 0.75

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