us-weather-history/KIND

365 rows sorted by record_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 ▼
126 2014-11-3 54 42 66 40 59 11 77 1951 1987 0.0 0.12 0.65
223 2015-2-8 47 36 57 22 38 -14 68 1895 1937 0.0 0.08 0.78
29 2014-7-29 64 52 75 66 85 51 100 1881 1941 0.21 0.13 0.8
286 2015-4-12 57 43 70 42 62 20 86 1940 1930 0.0 0.12 0.8
169 2014-12-16 39 31 46 24 38 -15 65 1951 1948 0.19 0.1 0.81
173 2014-12-20 29 25 32 23 37 -12 66 1963 1949 0.0 0.1 0.82
207 2015-1-23 29 24 34 20 36 -18 67 1936 1909 0.0 0.08 0.9
232 2015-2-17 14 1 26 24 41 -9 69 1903 1911 0.01 0.08 0.91
105 2014-10-13 67 58 76 45 66 24 86 1988 1975 0.57 0.1 0.92
209 2015-1-25 29 20 37 20 36 -14 71 1897 1950 0.04 0.08 0.92
359 2015-6-24 71 62 80 64 84 49 98 1887 1933 0.0 0.15 0.92
203 2015-1-19 35 23 47 20 35 -27 69 1994 1907 0.0 0.08 0.94
157 2014-12-4 32 29 35 28 43 5 70 1991 1998 0.06 0.1 0.98
152 2014-11-29 44 30 57 30 45 -1 70 1872 1927 0.0 0.12 1.0
100 2014-10-8 56 43 68 47 68 28 91 1987 2007 0.0 0.1 1.02
159 2014-12-6 35 30 40 27 42 -1 73 1977 1998 0.26 0.1 1.05
239 2015-2-24 10 -6 25 26 43 -6 71 2015 2000 0.0 0.08 1.05
165 2014-12-12 29 22 35 25 40 -7 63 1962 1927 0.0 0.1 1.06
208 2015-1-24 30 20 39 20 36 -16 70 1963 1967 0.0 0.08 1.06
264 2015-3-21 49 34 63 34 54 11 84 1876 2012 0.0 0.12 1.06
79 2014-9-17 56 45 67 56 77 40 93 1984 1955 0.0 0.1 1.07
38 2014-8-7 71 64 78 65 84 49 98 1989 1930 0.0 0.1 1.08
74 2014-9-12 59 53 64 58 79 40 96 1955 1897 0.0 0.11 1.08
313 2015-5-9 73 66 80 50 71 29 93 1947 1895 0.05 0.16 1.08
238 2015-2-23 11 3 19 26 43 -1 71 1889 2000 0.01 0.09 1.1
201 2015-1-17 39 27 51 20 35 -20 67 1977 1952 0.0 0.09 1.11
242 2015-2-27 10 2 18 27 45 -7 73 1963 1996 0.0 0.09 1.11
287 2015-4-13 64 56 71 42 63 18 86 1950 1941 0.04 0.12 1.13
107 2014-10-15 55 53 56 45 66 27 87 1876 1897 0.18 0.1 1.14
158 2014-12-5 37 34 40 27 42 8 70 1886 2001 0.98 0.11 1.14
211 2015-1-27 25 20 29 21 36 -10 66 1936 1916 0.01 0.08 1.14
221 2015-2-6 25 12 37 22 38 -12 64 1977 1925 0.0 0.07 1.14
132 2014-11-9 40 29 51 38 56 17 76 1991 1999 0.0 0.11 1.15
160 2014-12-7 33 26 39 27 41 -7 65 1882 1951 0.0 0.1 1.15
193 2015-1-9 11 1 21 21 35 -18 66 1875 1880 0.0 0.09 1.15
121 2014-10-29 47 39 54 41 61 22 81 1952 1922 0.0 0.1 1.16
149 2014-11-26 30 26 34 31 47 3 70 1898 1984 0.0 0.12 1.16
195 2015-1-11 28 21 34 20 35 -16 70 1977 1890 0.43 0.08 1.16
243 2015-2-28 16 7 25 28 45 2 68 1993 1895 0.23 0.09 1.17
68 2014-9-6 67 60 73 60 81 44 99 1988 1954 0.0 0.1 1.19
129 2014-11-6 43 39 47 39 57 20 77 1982 1975 0.09 0.12 1.2
216 2015-2-1 30 27 33 21 37 -11 63 1951 1911 0.29 0.08 1.21
234 2015-2-19 2 -5 9 25 41 -8 69 1979 1930 0.0 0.08 1.21
249 2015-3-6 16 2 30 30 47 -6 75 1960 1973 0.0 0.11 1.21
84 2014-9-22 57 47 66 53 75 37 93 1999 1895 0.0 0.11 1.22
179 2014-12-26 41 30 52 22 36 -5 67 1983 1875 0.0 0.11 1.22
52 2014-8-21 78 70 86 64 84 47 100 1950 1936 0.16 0.1 1.23
131 2014-11-8 42 36 48 38 56 13 76 1991 1999 0.0 0.12 1.23
147 2014-11-24 46 36 55 32 48 -1 65 1950 1973 0.18 0.13 1.23
217 2015-2-2 20 13 27 21 37 -19 59 1951 1911 0.01 0.09 1.24
41 2014-8-10 77 70 84 65 84 50 99 1972 1911 0.13 0.1 1.25
101 2014-10-9 51 45 56 47 68 30 88 1989 1939 0.02 0.11 1.25
204 2015-1-20 40 30 50 20 36 -22 70 1985 1906 0.0 0.08 1.26
215 2015-1-31 26 16 36 21 37 -11 66 2004 1917 0.13 0.08 1.26
283 2015-4-9 71 61 80 41 61 18 84 1997 2001 0.24 0.13 1.26
196 2015-1-12 25 19 31 20 35 -19 69 1918 1890 0.19 0.09 1.28
86 2014-9-24 62 47 76 53 74 34 92 1887 2007 0.0 0.1 1.29
194 2015-1-10 11 -3 24 20 35 -16 62 1982 1975 0.0 0.09 1.29
122 2014-10-30 44 34 53 41 60 22 82 1895 1950 0.0 0.11 1.3
19 2014-7-19 68 58 77 66 85 50 98 1984 1930 0.0 0.14 1.31
111 2014-10-19 50 43 56 44 64 25 85 1992 1953 0.0 0.1 1.33
112 2014-10-20 57 46 68 44 64 23 86 1972 1953 0.01 0.1 1.33
260 2015-3-17 47 33 60 33 52 2 77 1900 2012 0.0 0.12 1.35
329 2015-5-25 73 67 79 56 76 34 93 1925 1965 0.01 0.16 1.35
178 2014-12-25 36 31 41 22 36 -15 64 1983 1893 0.01 0.11 1.36
182 2014-12-29 29 20 37 22 36 -13 66 1880 1889 0.0 0.1 1.36
259 2015-3-16 61 47 74 33 52 3 79 1900 1945 0.0 0.11 1.36
323 2015-5-19 57 48 65 54 74 32 90 2002 1977 0.0 0.17 1.36
163 2014-12-10 33 30 35 26 40 -8 66 1917 1971 0.0 0.1 1.37
229 2015-2-14 18 6 30 24 40 -14 65 1905 1954 0.0 0.09 1.37
60 2014-8-29 78 68 87 63 83 41 97 1965 1953 0.0 0.1 1.38
94 2014-10-2 71 60 81 49 71 29 89 1974 1953 0.14 0.11 1.39
154 2014-12-1 33 26 39 29 44 4 70 1886 1970 0.02 0.1 1.39
162 2014-12-9 36 32 39 26 41 -15 65 1876 1952 0.01 0.11 1.39
56 2014-8-25 81 71 90 64 84 49 96 1887 1948 0.78 0.1 1.41
90 2014-9-28 71 58 83 51 72 33 91 1942 1939 0.0 0.11 1.41
192 2015-1-8 7 -7 20 21 35 -13 63 1970 1965 0.0 0.1 1.41
210 2015-1-26 22 17 26 20 36 -12 67 1897 1944 0.0 0.08 1.41
200 2015-1-16 32 21 42 20 35 -20 66 1972 1990 0.0 0.08 1.42
289 2015-4-15 58 46 69 43 63 24 84 1928 2002 0.07 0.12 1.42
47 2014-8-16 67 59 75 65 84 50 102 1979 1988 0.09 0.1 1.43
113 2014-10-21 51 44 57 43 64 23 86 1952 1953 0.02 0.09 1.43
98 2014-10-6 55 42 67 48 69 30 89 1980 2007 0.02 0.11 1.45
109 2014-10-17 59 50 68 44 65 26 86 1948 1950 0.0 0.1 1.45
168 2014-12-15 43 41 44 24 39 -10 69 1951 1948 0.01 0.1 1.45
250 2015-3-7 32 21 42 30 48 -1 78 1943 1974 0.0 0.11 1.45
272 2015-3-29 38 24 51 37 57 16 82 1887 1895 0.06 0.13 1.46
297 2015-4-23 45 32 57 45 66 26 88 1986 1925 0.0 0.13 1.46
197 2015-1-13 16 8 23 20 35 -10 64 1997 1950 0.0 0.09 1.47
214 2015-1-30 26 20 31 21 36 -11 65 1966 2013 0.01 0.08 1.47
308 2015-5-4 67 58 76 49 69 30 88 1976 1949 0.13 0.16 1.47
190 2015-1-6 14 9 19 21 35 -20 63 1884 2008 0.08 0.09 1.48
228 2015-2-13 20 9 31 23 39 -17 67 1899 1938 0.0 0.08 1.48
266 2015-3-23 36 30 41 35 55 12 80 1885 1939 0.03 0.12 1.48
278 2015-4-4 43 30 55 39 59 23 80 1975 1929 0.0 0.12 1.48
300 2015-4-26 49 39 58 46 67 31 87 1976 1915 0.0 0.13 1.48
172 2014-12-19 24 19 29 23 38 -12 67 1884 1877 0.0 0.1 1.49
213 2015-1-29 38 30 45 21 36 -13 66 1873 2002 0.0 0.08 1.5
230 2015-2-15 12 4 20 24 40 -8 72 1875 1954 0.0 0.08 1.5
332 2015-5-28 72 60 84 57 76 39 96 1907 1911 0.0 0.16 1.5

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