us-weather-history/KMDW

365 rows sorted by average_max_temp

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
193 2015-1-9 10 3 16 18 31 -17 57 1982 1939 0.0 0.08 0.76
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
199 2015-1-15 27 17 36 18 31 -19 60 1979 1949 0.0 0.06 0.39
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
202 2015-1-18 37 31 43 18 31 -20 61 1994 1996 0.0 0.06 1.39
203 2015-1-19 35 27 43 18 31 -21 57 1985 1933 0.0 0.07 1.09
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
208 2015-1-24 39 32 45 18 31 -16 65 1936 1967 0.0 0.05 0.73
181 2014-12-28 31 26 36 20 32 -3 67 1961 1984 0.0 0.08 1.13
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
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
187 2015-1-3 34 31 37 19 32 -12 60 1979 1950 0.55 0.07 0.79
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
190 2015-1-6 9 5 12 19 32 -15 60 2014 2008 0.0 0.07 0.75
191 2015-1-7 2 -4 8 18 32 -14 65 1942 2008 0.0 0.08 0.69
192 2015-1-8 7 -7 20 18 32 -12 63 1942 1965 0.05 0.07 1.48
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
212 2015-1-28 30 24 36 18 32 -13 55 1977 1970 0.03 0.05 0.52
213 2015-1-29 35 31 39 18 32 -16 61 1966 2013 0.0 0.06 0.99
214 2015-1-30 28 23 32 18 32 -15 55 1966 1988 0.0 0.05 1.25
215 2015-1-31 31 23 39 19 32 -9 67 1996 1989 0.13 0.06 0.7
216 2015-2-1 27 21 33 19 32 -9 56 1951 1968 0.12 0.05 0.95
217 2015-2-2 16 9 22 19 32 -15 51 1951 1992 0.0 0.06 1.22
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
177 2014-12-24 41 38 43 21 33 -20 59 1983 1982 0.12 0.07 2.61
178 2014-12-25 40 35 44 20 33 -13 64 1983 1982 0.0 0.08 1.8
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
218 2015-2-3 19 8 30 19 33 -17 60 1996 1992 0.05 0.06 0.43
219 2015-2-4 21 12 30 19 33 -12 54 1996 1993 0.0 0.05 0.69
220 2015-2-5 10 3 17 19 33 -17 56 1979 1946 0.0 0.06 0.68
221 2015-2-6 24 15 32 20 33 -12 56 1982 1938 0.0 0.05 1.96
222 2015-2-7 35 25 44 20 33 -5 59 1972 2009 0.0 0.06 0.67
171 2014-12-18 28 25 31 22 34 -9 59 1983 1939 0.0 0.07 1.06
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
174 2014-12-21 36 34 38 21 34 -13 62 1989 1967 0.0 0.07 1.81
223 2015-2-8 37 31 42 20 34 -12 61 1933 1990 0.0 0.07 0.81
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
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
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
229 2015-2-14 17 4 29 21 35 -5 62 1936 1954 0.0 0.06 0.94
164 2014-12-11 30 26 34 24 36 -5 61 1972 1949 0.0 0.09 1.73
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
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
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
163 2014-12-10 34 31 36 24 37 -8 60 1978 1971 0.0 0.1 2.18
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
235 2015-2-20 10 -1 20 23 37 -9 65 1929 1983 0.0 0.08 1.35
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
236 2015-2-21 26 19 33 23 38 -6 66 1963 1930 0.0 0.07 3.25
237 2015-2-22 19 7 30 24 38 -7 63 1963 1984 0.0 0.08 1.4
157 2014-12-4 31 25 37 26 39 3 68 1991 1998 0.0 0.09 1.19
158 2014-12-5 38 35 41 26 39 7 68 2005 2001 0.0 0.1 0.95
238 2015-2-23 8 0 15 24 39 0 66 1939 2000 0.0 0.09 0.9
239 2015-2-24 19 6 32 24 39 -5 64 1967 1930 0.0 0.08 1.36
240 2015-2-25 22 16 28 25 39 -5 73 1967 2000 0.06 0.09 0.62
154 2014-12-1 25 21 29 28 40 5 68 1930 1970 0.0 0.1 1.04
155 2014-12-2 28 22 33 27 40 -1 69 1942 1982 0.0 0.1 2.78
156 2014-12-3 33 26 39 27 40 -8 72 1940 2012 0.0 0.1 0.68
241 2015-2-26 15 7 22 25 40 -1 64 1963 2000 0.01 0.08 1.76
242 2015-2-27 9 0 17 25 40 -6 75 1934 1976 0.0 0.09 0.79
243 2015-2-28 12 1 23 26 40 1 59 2015 1965 0.0 0.08 0.77
152 2014-11-29 44 33 54 28 41 -1 69 1929 1998 0.0 0.11 1.31
153 2014-11-30 43 29 56 28 41 -1 66 1947 1962 0.0 0.11 0.6
244 2015-3-1 23 18 27 26 41 -5 71 1962 1992 0.01 0.09 1.09
245 2015-3-2 25 16 34 26 41 -4 71 1913 1974 0.0 0.08 1.02
150 2014-11-27 25 19 30 29 42 0 70 1930 1990 0.0 0.11 3.34
151 2014-11-28 28 20 36 29 42 -3 69 1930 1998 0.0 0.11 1.56
246 2015-3-3 32 27 37 27 42 -6 80 1873 1974 0.1 0.09 1.21
247 2015-3-4 24 14 33 27 42 -4 74 2002 1983 0.0 0.08 1.42
248 2015-3-5 14 8 19 27 42 0 76 1978 1983 0.0 0.09 0.99
148 2014-11-25 26 22 30 30 43 0 61 1950 2006 0.0 0.1 0.76

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