us-weather-history/KMDW

365 rows sorted by actual_mean_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
234 2015-2-19 1 -5 7 23 37 -8 65 1936 1930 0.0 0.07 0.78
191 2015-1-7 2 -4 8 18 32 -14 65 1942 2008 0.0 0.08 0.69
189 2015-1-5 5 -1 10 19 32 -15 56 1999 1998 0.11 0.08 0.8
233 2015-2-18 6 0 11 23 37 -16 62 1936 1961 0.0 0.07 0.84
192 2015-1-8 7 -7 20 18 32 -12 63 1942 1965 0.05 0.07 1.48
238 2015-2-23 8 0 15 24 39 0 66 1939 2000 0.0 0.09 0.9
190 2015-1-6 9 5 12 19 32 -15 60 2014 2008 0.0 0.07 0.75
230 2015-2-15 9 0 17 22 36 -6 69 1936 1954 0.0 0.07 0.78
242 2015-2-27 9 0 17 25 40 -6 75 1934 1976 0.0 0.09 0.79
193 2015-1-9 10 3 16 18 31 -17 57 1982 1939 0.0 0.08 0.76
220 2015-2-5 10 3 17 19 33 -17 56 1979 1946 0.0 0.06 0.68
235 2015-2-20 10 -1 20 23 37 -9 65 1929 1983 0.0 0.08 1.35
243 2015-2-28 12 1 23 26 40 1 59 2015 1965 0.0 0.08 0.77
184 2014-12-31 13 6 20 19 32 -10 60 1967 1962 0.0 0.08 1.41
194 2015-1-10 13 0 26 18 31 -22 60 1982 1975 0.0 0.07 2.29
198 2015-1-14 13 5 21 18 31 -14 56 1979 1952 0.0 0.07 1.0
231 2015-2-16 14 8 19 22 36 -7 53 1958 1981 0.0 0.07 0.75
248 2015-3-5 14 8 19 27 42 0 76 1978 1983 0.0 0.09 0.99
241 2015-2-26 15 7 22 25 40 -1 64 1963 2000 0.01 0.08 1.76
217 2015-2-2 16 9 22 19 32 -15 51 1951 1992 0.0 0.06 1.22
227 2015-2-12 16 11 21 21 35 -10 61 1981 1984 0.0 0.07 0.5
141 2014-11-18 17 12 21 34 47 12 72 2014 1999 0.0 0.12 2.23
229 2015-2-14 17 4 29 21 35 -5 62 1936 1954 0.0 0.06 0.94
232 2015-2-17 17 11 22 22 36 -10 58 1936 2011 0.0 0.07 0.84
249 2015-3-6 17 6 27 28 43 2 71 1960 1983 0.0 0.08 0.49
197 2015-1-13 18 13 23 18 31 -10 56 1929 1932 0.0 0.07 1.37
228 2015-2-13 18 7 29 21 35 -5 63 1988 1938 0.0 0.07 0.78
140 2014-11-17 19 13 25 34 48 3 74 1959 1975 0.0 0.11 1.26
183 2014-12-30 19 13 24 19 32 -8 60 1983 2002 0.0 0.07 1.69
218 2015-2-3 19 8 30 19 33 -17 60 1996 1992 0.05 0.06 0.43
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
188 2015-1-4 21 5 36 19 32 -8 64 1999 1997 0.1 0.08 1.59
219 2015-2-4 21 12 30 19 33 -12 54 1996 1993 0.0 0.05 0.69
240 2015-2-25 22 16 28 25 39 -5 73 1967 2000 0.06 0.09 0.62
244 2015-3-1 23 18 27 26 41 -5 71 1962 1992 0.01 0.09 1.09
143 2014-11-20 24 17 30 33 46 14 69 1964 1930 0.0 0.11 1.23
221 2015-2-6 24 15 32 20 33 -12 56 1982 1938 0.0 0.05 1.96
247 2015-3-4 24 14 33 27 42 -4 74 2002 1983 0.0 0.08 1.42
144 2014-11-21 25 13 36 32 46 7 66 1964 1990 0.0 0.12 1.35
150 2014-11-27 25 19 30 29 42 0 70 1930 1990 0.0 0.11 3.34
154 2014-12-1 25 21 29 28 40 5 68 1930 1970 0.0 0.1 1.04
185 2015-1-1 25 17 32 19 32 -10 52 1969 2000 0.0 0.08 1.33
196 2015-1-12 25 19 30 18 31 -9 62 1974 2005 0.03 0.07 2.76
210 2015-1-26 25 21 29 18 32 -10 62 1936 1944 0.04 0.06 1.66
245 2015-3-2 25 16 34 26 41 -4 71 1913 1974 0.0 0.08 1.02
142 2014-11-19 26 19 33 33 47 17 77 1951 1930 0.0 0.11 0.74
148 2014-11-25 26 22 30 30 43 0 61 1950 2006 0.0 0.1 0.76
236 2015-2-21 26 19 33 23 38 -6 66 1963 1930 0.0 0.07 3.25
137 2014-11-14 27 24 29 35 50 12 78 1940 1971 0.0 0.12 1.6
138 2014-11-15 27 21 33 35 49 8 72 1933 1990 0.0 0.12 0.89
149 2014-11-26 27 22 32 30 43 2 68 1930 1990 0.0 0.11 1.2
199 2015-1-15 27 17 36 18 31 -19 60 1979 1949 0.0 0.06 0.39
216 2015-2-1 27 21 33 19 32 -9 56 1951 1968 0.12 0.05 0.95
151 2014-11-28 28 20 36 29 42 -3 69 1930 1998 0.0 0.11 1.56
155 2014-12-2 28 22 33 27 40 -1 69 1942 1982 0.0 0.1 2.78
171 2014-12-18 28 25 31 22 34 -9 59 1983 1939 0.0 0.07 1.06
186 2015-1-2 28 20 36 19 32 -13 61 1979 2000 0.0 0.08 1.22
214 2015-1-30 28 23 32 18 32 -15 55 1966 1988 0.0 0.05 1.25
136 2014-11-13 29 26 31 36 50 7 74 1986 1989 0.0 0.12 1.09
139 2014-11-16 29 25 33 34 48 5 73 1933 1952 0.0 0.12 1.29
170 2014-12-17 29 26 32 22 35 -7 60 1951 1977 0.0 0.08 0.44
200 2015-1-16 29 22 35 18 31 -19 56 1977 1990 0.0 0.07 0.43
211 2015-1-27 29 24 33 18 32 -10 61 1955 2002 0.0 0.06 0.74
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
271 2015-3-28 29 21 37 35 52 9 78 1934 1968 0.0 0.1 1.26
135 2014-11-12 30 27 33 36 51 10 70 1986 1949 0.0 0.12 0.7
164 2014-12-11 30 26 34 24 36 -5 61 1972 1949 0.0 0.09 1.73
182 2014-12-29 30 24 35 20 32 -8 64 1976 1984 0.0 0.07 0.78
195 2015-1-11 30 25 34 18 31 -11 54 1977 2013 0.12 0.07 0.34
212 2015-1-28 30 24 36 18 32 -13 55 1977 1970 0.03 0.05 0.52
226 2015-2-11 30 21 38 21 35 -8 71 1955 1999 0.0 0.07 0.82
270 2015-3-27 30 25 34 35 51 13 82 1965 1945 0.01 0.09 1.06
157 2014-12-4 31 25 37 26 39 3 68 1991 1998 0.0 0.09 1.19
181 2014-12-28 31 26 36 20 32 -3 67 1961 1984 0.0 0.08 1.13
215 2015-1-31 31 23 39 19 32 -9 67 1996 1989 0.13 0.06 0.7
266 2015-3-23 31 30 32 33 50 6 79 1940 1939 0.15 0.09 0.93
165 2014-12-12 32 25 39 24 36 -7 62 1962 1991 0.0 0.08 1.76
172 2014-12-19 32 29 34 22 34 -12 56 1983 1988 0.0 0.08 0.8
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
246 2015-3-3 32 27 37 27 42 -6 80 1873 1974 0.1 0.09 1.21
156 2014-12-3 33 26 39 27 40 -8 72 1940 2012 0.0 0.1 0.68
267 2015-3-24 33 25 40 34 50 5 79 1974 1939 0.04 0.08 1.26
163 2014-12-10 34 31 36 24 37 -8 60 1978 1971 0.0 0.1 2.18
173 2014-12-20 34 32 35 21 34 -9 59 1963 1988 0.0 0.08 1.12
187 2015-1-3 34 31 37 19 32 -12 60 1979 1950 0.55 0.07 0.79
205 2015-1-21 34 31 36 18 31 -17 57 1984 1934 0.0 0.06 0.96
265 2015-3-22 34 30 37 33 49 6 84 1940 2012 0.0 0.09 1.15
160 2014-12-7 35 30 39 25 38 -2 61 1936 1946 0.0 0.09 1.26
203 2015-1-19 35 27 43 18 31 -21 57 1985 1933 0.0 0.07 1.09
213 2015-1-29 35 31 39 18 32 -16 61 1966 2013 0.0 0.06 0.99
222 2015-2-7 35 25 44 20 33 -5 59 1972 2009 0.0 0.06 0.67
174 2014-12-21 36 34 38 21 34 -13 62 1989 1967 0.0 0.07 1.81
250 2015-3-7 36 26 46 28 43 -2 79 1943 2000 0.0 0.09 1.27
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
201 2015-1-17 37 30 44 18 31 -17 58 1982 1952 0.0 0.07 0.68

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