us-weather-history/KMDW

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
208 2015-1-24 39 32 45 18 31 -16 65 1936 1967 0.0 0.05 0.73
212 2015-1-28 30 24 36 18 32 -13 55 1977 1970 0.03 0.05 0.52
214 2015-1-30 28 23 32 18 32 -15 55 1966 1988 0.0 0.05 1.25
216 2015-2-1 27 21 33 19 32 -9 56 1951 1968 0.12 0.05 0.95
219 2015-2-4 21 12 30 19 33 -12 54 1996 1993 0.0 0.05 0.69
221 2015-2-6 24 15 32 20 33 -12 56 1982 1938 0.0 0.05 1.96
199 2015-1-15 27 17 36 18 31 -19 60 1979 1949 0.0 0.06 0.39
202 2015-1-18 37 31 43 18 31 -20 61 1994 1996 0.0 0.06 1.39
204 2015-1-20 37 33 40 18 31 -25 53 1985 1954 0.01 0.06 0.99
205 2015-1-21 34 31 36 18 31 -17 57 1984 1934 0.0 0.06 0.96
206 2015-1-22 32 30 34 18 31 -17 58 1936 1964 0.0 0.06 1.33
207 2015-1-23 32 30 34 18 31 -19 59 1936 1967 0.0 0.06 0.73
209 2015-1-25 32 26 38 18 32 -10 67 1936 1950 0.06 0.06 1.3
210 2015-1-26 25 21 29 18 32 -10 62 1936 1944 0.04 0.06 1.66
211 2015-1-27 29 24 33 18 32 -10 61 1955 2002 0.0 0.06 0.74
213 2015-1-29 35 31 39 18 32 -16 61 1966 2013 0.0 0.06 0.99
215 2015-1-31 31 23 39 19 32 -9 67 1996 1989 0.13 0.06 0.7
217 2015-2-2 16 9 22 19 32 -15 51 1951 1992 0.0 0.06 1.22
218 2015-2-3 19 8 30 19 33 -17 60 1996 1992 0.05 0.06 0.43
220 2015-2-5 10 3 17 19 33 -17 56 1979 1946 0.0 0.06 0.68
222 2015-2-7 35 25 44 20 33 -5 59 1972 2009 0.0 0.06 0.67
224 2015-2-9 29 26 31 20 34 -20 57 1933 1999 0.0 0.06 0.77
225 2015-2-10 29 25 33 20 34 -12 62 1982 2009 0.0 0.06 0.98
229 2015-2-14 17 4 29 21 35 -5 62 1936 1954 0.0 0.06 0.94
171 2014-12-18 28 25 31 22 34 -9 59 1983 1939 0.0 0.07 1.06
174 2014-12-21 36 34 38 21 34 -13 62 1989 1967 0.0 0.07 1.81
177 2014-12-24 41 38 43 21 33 -20 59 1983 1982 0.12 0.07 2.61
179 2014-12-26 45 38 51 20 33 -9 55 1933 1971 0.0 0.07 0.8
180 2014-12-27 41 32 50 20 33 -12 61 1933 1982 0.0 0.07 2.05
182 2014-12-29 30 24 35 20 32 -8 64 1976 1984 0.0 0.07 0.78
183 2014-12-30 19 13 24 19 32 -8 60 1983 2002 0.0 0.07 1.69
187 2015-1-3 34 31 37 19 32 -12 60 1979 1950 0.55 0.07 0.79
190 2015-1-6 9 5 12 19 32 -15 60 2014 2008 0.0 0.07 0.75
192 2015-1-8 7 -7 20 18 32 -12 63 1942 1965 0.05 0.07 1.48
194 2015-1-10 13 0 26 18 31 -22 60 1982 1975 0.0 0.07 2.29
195 2015-1-11 30 25 34 18 31 -11 54 1977 2013 0.12 0.07 0.34
196 2015-1-12 25 19 30 18 31 -9 62 1974 2005 0.03 0.07 2.76
197 2015-1-13 18 13 23 18 31 -10 56 1929 1932 0.0 0.07 1.37
198 2015-1-14 13 5 21 18 31 -14 56 1979 1952 0.0 0.07 1.0
200 2015-1-16 29 22 35 18 31 -19 56 1977 1990 0.0 0.07 0.43
201 2015-1-17 37 30 44 18 31 -17 58 1982 1952 0.0 0.07 0.68
203 2015-1-19 35 27 43 18 31 -21 57 1985 1933 0.0 0.07 1.09
223 2015-2-8 37 31 42 20 34 -12 61 1933 1990 0.0 0.07 0.81
226 2015-2-11 30 21 38 21 35 -8 71 1955 1999 0.0 0.07 0.82
227 2015-2-12 16 11 21 21 35 -10 61 1981 1984 0.0 0.07 0.5
228 2015-2-13 18 7 29 21 35 -5 63 1988 1938 0.0 0.07 0.78
230 2015-2-15 9 0 17 22 36 -6 69 1936 1954 0.0 0.07 0.78
231 2015-2-16 14 8 19 22 36 -7 53 1958 1981 0.0 0.07 0.75
232 2015-2-17 17 11 22 22 36 -10 58 1936 2011 0.0 0.07 0.84
233 2015-2-18 6 0 11 23 37 -16 62 1936 1961 0.0 0.07 0.84
234 2015-2-19 1 -5 7 23 37 -8 65 1936 1930 0.0 0.07 0.78
236 2015-2-21 26 19 33 23 38 -6 66 1963 1930 0.0 0.07 3.25
165 2014-12-12 32 25 39 24 36 -7 62 1962 1991 0.0 0.08 1.76
166 2014-12-13 43 37 49 23 36 -3 67 2000 1975 0.0 0.08 1.24
167 2014-12-14 50 47 53 23 35 -4 66 1985 1975 0.0 0.08 1.0
168 2014-12-15 46 43 48 23 35 -8 64 1989   0.12 0.08 1.14
169 2014-12-16 40 32 47 22 35 -12 63 1951 1984 0.02 0.08 0.47
170 2014-12-17 29 26 32 22 35 -7 60 1951 1977 0.0 0.08 0.44
172 2014-12-19 32 29 34 22 34 -12 56 1983 1988 0.0 0.08 0.8
173 2014-12-20 34 32 35 21 34 -9 59 1963 1988 0.0 0.08 1.12
175 2014-12-22 38 31 44 21 33 -12 57 1989 1957 0.28 0.08 0.98
176 2014-12-23 46 42 50 21 33 -17 60 1983 1982 0.12 0.08 1.12
178 2014-12-25 40 35 44 20 33 -13 64 1983 1982 0.0 0.08 1.8
181 2014-12-28 31 26 36 20 32 -3 67 1961 1984 0.0 0.08 1.13
184 2014-12-31 13 6 20 19 32 -10 60 1967 1962 0.0 0.08 1.41
185 2015-1-1 25 17 32 19 32 -10 52 1969 2000 0.0 0.08 1.33
186 2015-1-2 28 20 36 19 32 -13 61 1979 2000 0.0 0.08 1.22
188 2015-1-4 21 5 36 19 32 -8 64 1999 1997 0.1 0.08 1.59
189 2015-1-5 5 -1 10 19 32 -15 56 1999 1998 0.11 0.08 0.8
191 2015-1-7 2 -4 8 18 32 -14 65 1942 2008 0.0 0.08 0.69
193 2015-1-9 10 3 16 18 31 -17 57 1982 1939 0.0 0.08 0.76
235 2015-2-20 10 -1 20 23 37 -9 65 1929 1983 0.0 0.08 1.35
237 2015-2-22 19 7 30 24 38 -7 63 1963 1984 0.0 0.08 1.4
239 2015-2-24 19 6 32 24 39 -5 64 1967 1930 0.0 0.08 1.36
241 2015-2-26 15 7 22 25 40 -1 64 1963 2000 0.01 0.08 1.76
243 2015-2-28 12 1 23 26 40 1 59 2015 1965 0.0 0.08 0.77
245 2015-3-2 25 16 34 26 41 -4 71 1913 1974 0.0 0.08 1.02
247 2015-3-4 24 14 33 27 42 -4 74 2002 1983 0.0 0.08 1.42
249 2015-3-6 17 6 27 28 43 2 71 1960 1983 0.0 0.08 0.49
252 2015-3-9 40 28 52 29 44 3 69 1932 1974 0.0 0.08 1.41
253 2015-3-10 46 38 54 29 44 5 70 2003 1955 0.0 0.08 1.12
254 2015-3-11 45 36 54 29 45 3 76 1979 1990 0.0 0.08 0.92
255 2015-3-12 46 33 58 30 45 1 81 1948 1990 0.0 0.08 1.3
256 2015-3-13 53 41 65 30 46 11 74 1948 2007 0.0 0.08 1.02
258 2015-3-15 49 34 64 31 46 12 81 1979 2012 0.0 0.08 1.66
260 2015-3-17 38 31 44 31 47 0 80 1941 2012 0.0 0.08 1.42
267 2015-3-24 33 25 40 34 50 5 79 1974 1939 0.04 0.08 1.26
92 2014-9-30 56 51 61 51 69 34 92 1984 1971 0.0 0.09 0.76
94 2014-10-2 71 66 75 50 68 28 91 1974 1971 0.71 0.09 3.8
100 2014-10-8 58 48 67 48 66 30 88 1952 2007 0.0 0.09 1.32
157 2014-12-4 31 25 37 26 39 3 68 1991 1998 0.0 0.09 1.19
159 2014-12-6 39 34 43 26 38 0 65 1972 1951 0.0 0.09 1.38
160 2014-12-7 35 30 39 25 38 -2 61 1936 1946 0.0 0.09 1.26
161 2014-12-8 37 35 39 25 37 0 64 1958 1946 0.1 0.09 0.77
162 2014-12-9 37 33 40 24 37 -8 61 1958 1946 0.02 0.09 1.31
164 2014-12-11 30 26 34 24 36 -5 61 1972 1949 0.0 0.09 1.73
238 2015-2-23 8 0 15 24 39 0 66 1939 2000 0.0 0.09 0.9
240 2015-2-25 22 16 28 25 39 -5 73 1967 2000 0.06 0.09 0.62
242 2015-2-27 9 0 17 25 40 -6 75 1934 1976 0.0 0.09 0.79
244 2015-3-1 23 18 27 26 41 -5 71 1962 1992 0.01 0.09 1.09

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "us-weather-history/KMDW" (
"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.071ms