us-weather-history/KIND

365 rows sorted by average_precipitation

View and edit SQL

Suggested facets: 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
206 2015-1-22 31 28 33 20 36 -17 64 1936 1964 0.0 0.07 1.87
221 2015-2-6 25 12 37 22 38 -12 64 1977 1925 0.0 0.07 1.14
195 2015-1-11 28 21 34 20 35 -16 70 1977 1890 0.43 0.08 1.16
198 2015-1-14 13 5 21 20 35 -7 65 1957 1928 0.0 0.08 1.77
199 2015-1-15 25 13 36 20 35 -17 66 1972 1932 0.0 0.08 1.68
200 2015-1-16 32 21 42 20 35 -20 66 1972 1990 0.0 0.08 1.42
202 2015-1-18 36 28 44 20 35 -22 64 1994 1929 0.01 0.08 1.96
203 2015-1-19 35 23 47 20 35 -27 69 1994 1907 0.0 0.08 0.94
204 2015-1-20 40 30 50 20 36 -22 70 1985 1906 0.0 0.08 1.26
205 2015-1-21 37 30 43 20 36 -21 68 1984 1906 0.0 0.08 2.25
207 2015-1-23 29 24 34 20 36 -18 67 1936 1909 0.0 0.08 0.9
208 2015-1-24 30 20 39 20 36 -16 70 1963 1967 0.0 0.08 1.06
209 2015-1-25 29 20 37 20 36 -14 71 1897 1950 0.04 0.08 0.92
210 2015-1-26 22 17 26 20 36 -12 67 1897 1944 0.0 0.08 1.41
211 2015-1-27 25 20 29 21 36 -10 66 1936 1916 0.01 0.08 1.14
212 2015-1-28 25 15 34 21 36 -18 65 1963 2002 0.0 0.08 2.0
213 2015-1-29 38 30 45 21 36 -13 66 1873 2002 0.0 0.08 1.5
214 2015-1-30 26 20 31 21 36 -11 65 1966 2013 0.01 0.08 1.47
215 2015-1-31 26 16 36 21 37 -11 66 2004 1917 0.13 0.08 1.26
216 2015-2-1 30 27 33 21 37 -11 63 1951 1911 0.29 0.08 1.21
218 2015-2-3 26 16 36 21 37 -11 62 1996 1992 0.0 0.08 2.5
219 2015-2-4 29 15 42 21 37 -12 69 1996 1890 0.07 0.08 1.68
222 2015-2-7 42 28 55 22 38 -11 66 1977 1925 0.0 0.08 1.53
223 2015-2-8 47 36 57 22 38 -14 68 1895 1937 0.0 0.08 0.78
224 2015-2-9 31 26 36 22 38 -18 66 1899 1943 0.0 0.08 2.04
226 2015-2-11 32 25 39 23 39 -9 75 1885 1999 0.0 0.08 1.87
227 2015-2-12 20 13 27 23 39 -10 66 1899 1984 0.0 0.08 2.67
228 2015-2-13 20 9 31 23 39 -17 67 1899 1938 0.0 0.08 1.48
230 2015-2-15 12 4 20 24 40 -8 72 1875 1954 0.0 0.08 1.5
231 2015-2-16 11 6 16 24 40 -7 72 1943 1883 0.14 0.08 1.58
232 2015-2-17 14 1 26 24 41 -9 69 1903 1911 0.01 0.08 0.91
233 2015-2-18 9 0 17 25 41 -11 66 1936 1961 0.07 0.08 1.58
234 2015-2-19 2 -5 9 25 41 -8 69 1979 1930 0.0 0.08 1.21
235 2015-2-20 6 -6 18 25 42 -8 67 1885 1983 0.0 0.08 3.02
236 2015-2-21 26 16 35 26 42 -4 68 1963 1930 0.47 0.08 1.53
237 2015-2-22 22 15 29 26 43 -9 70 1963 1922 0.0 0.08 2.09
239 2015-2-24 10 -6 25 26 43 -6 71 2015 2000 0.0 0.08 1.05
39 2014-8-8 70 65 74 65 84 48 98 1989 2012 0.03 0.09 1.51
42 2014-8-11 75 68 82 65 84 52 99 1967 1941 0.1 0.09 2.07
44 2014-8-13 67 55 79 65 84 48 98 1964 1936 0.0 0.09 3.08
45 2014-8-14 70 59 81 65 84 48 95 1964 1871 0.0 0.09 2.72
55 2014-8-24 78 70 86 64 84 49 98 1927 1936 0.0 0.09 1.75
66 2014-9-4 77 66 87 61 82 46 98 1952 1954 0.0 0.09 6.8
78 2014-9-16 59 50 67 56 78 39 96 1984 1939 0.01 0.09 2.53
80 2014-9-18 61 49 72 55 77 39 95 1959 1953 0.0 0.09 1.64
113 2014-10-21 51 44 57 43 64 23 86 1952 1953 0.02 0.09 1.43
115 2014-10-23 49 37 60 43 63 24 86 1969 1963 0.0 0.09 1.57
116 2014-10-24 53 40 66 42 62 20 81 1981 1963 0.0 0.09 1.52
117 2014-10-25 63 50 76 42 62 25 82 1887 1963 0.0 0.09 1.54
167 2014-12-14 45 41 48 25 39 -4 68 1901 1984 0.0 0.09 2.12
171 2014-12-18 25 22 27 24 38 -10 65 1884 1877 0.0 0.09 2.05
190 2015-1-6 14 9 19 21 35 -20 63 1884 2008 0.08 0.09 1.48
191 2015-1-7 3 -6 12 21 35 -17 68 1970 2008 0.0 0.09 1.58
193 2015-1-9 11 1 21 21 35 -18 66 1875 1880 0.0 0.09 1.15
194 2015-1-10 11 -3 24 20 35 -16 62 1982 1975 0.0 0.09 1.29
196 2015-1-12 25 19 31 20 35 -19 69 1918 1890 0.19 0.09 1.28
197 2015-1-13 16 8 23 20 35 -10 64 1997 1950 0.0 0.09 1.47
201 2015-1-17 39 27 51 20 35 -20 67 1977 1952 0.0 0.09 1.11
217 2015-2-2 20 13 27 21 37 -19 59 1951 1911 0.01 0.09 1.24
220 2015-2-5 15 5 24 22 37 -16 66 1979 1927 0.0 0.09 1.83
225 2015-2-10 27 18 36 23 39 -21 73 1982 1932 0.0 0.09 1.56
229 2015-2-14 18 6 30 24 40 -14 65 1905 1954 0.0 0.09 1.37
238 2015-2-23 11 3 19 26 43 -1 71 1889 2000 0.01 0.09 1.1
240 2015-2-25 24 14 33 27 44 -7 76 1900 2000 0.0 0.09 2.35
241 2015-2-26 16 7 25 27 44 -6 68 1963 1998 0.04 0.09 2.49
242 2015-2-27 10 2 18 27 45 -7 73 1963 1996 0.0 0.09 1.11
243 2015-2-28 16 7 25 28 45 2 68 1993 1895 0.23 0.09 1.17
245 2015-3-2 24 14 34 28 46 -7 74 1980 1992 0.0 0.09 1.56
246 2015-3-3 33 26 40 29 46 -5 77 1943 1992 0.28 0.09 2.01
35 2014-8-4 74 62 85 65 84 49 99 1912 1887 0.0 0.1 3.81
36 2014-8-5 73 65 81 65 84 51 103 1974 1918 0.0 0.1 1.65
38 2014-8-7 71 64 78 65 84 49 98 1989 1930 0.0 0.1 1.08
40 2014-8-9 76 68 83 65 84 50 99 1884 1930 0.0 0.1 2.36
41 2014-8-10 77 70 84 65 84 50 99 1972 1911 0.13 0.1 1.25
43 2014-8-12 65 58 71 65 84 47 101 2004 1881 0.0 0.1 1.93
46 2014-8-15 63 49 77 65 84 45 96 1979 2010 0.0 0.1 2.26
47 2014-8-16 67 59 75 65 84 50 102 1979 1988 0.09 0.1 1.43
50 2014-8-19 76 65 86 64 84 50 100 1896 1936 0.5 0.1 1.65
52 2014-8-21 78 70 86 64 84 47 100 1950 1936 0.16 0.1 1.23
53 2014-8-22 80 73 86 64 84 46 101 1950 1936 0.02 0.1 1.9
54 2014-8-23 79 70 88 64 84 46 96 1890 1936 0.81 0.1 2.07
56 2014-8-25 81 71 90 64 84 49 96 1887 1948 0.78 0.1 1.41
58 2014-8-27 79 70 88 63 84 48 97 1968 1948 0.0 0.1 2.6
59 2014-8-28 75 66 84 63 83 43 96 1986 1953 0.0 0.1 2.44
60 2014-8-29 78 68 87 63 83 41 97 1965 1953 0.0 0.1 1.38
61 2014-8-30 75 71 78 63 83 42 95 1986 1953 0.02 0.1 2.16
62 2014-8-31 76 69 83 62 83 44 97 1915 1951 0.01 0.1 2.43
63 2014-9-1 77 71 82 62 83 44 100 1987 1953 0.0 0.1 7.2
64 2014-9-2 72 65 79 62 82 45 100 1885 1953 1.0 0.1 2.1
65 2014-9-3 74 64 83 61 82 45 100 1952 2011 0.0 0.1 2.63
67 2014-9-5 80 70 90 61 82 45 100 1974 1954 0.02 0.1 1.54
68 2014-9-6 67 60 73 60 81 44 99 1988 1954 0.0 0.1 1.19
70 2014-9-8 68 56 79 60 81 38 97 1986 1939 0.0 0.1 2.61
71 2014-9-9 69 57 81 59 80 41 98 1883 1939 0.0 0.1 2.34
79 2014-9-17 56 45 67 56 77 40 93 1984 1955 0.0 0.1 1.07
82 2014-9-20 67 54 80 54 76 36 94 1991 1940 0.02 0.1 2.2
86 2014-9-24 62 47 76 53 74 34 92 1887 2007 0.0 0.1 1.29
88 2014-9-26 69 55 82 52 73 37 91 2001 1891 0.0 0.1 1.62
91 2014-9-29 68 54 82 50 72 34 97 1970 1953 0.0 0.1 2.45
93 2014-10-1 63 49 76 50 71 32 89 1946 1897 0.0 0.1 2.74

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "us-weather-history/KIND" (
"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 83.367ms