us-weather-history/KIND

365 rows sorted by record_min_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
203 2015-1-19 35 23 47 20 35 -27 69 1994 1907 0.0 0.08 0.94
189 2015-1-5 9 4 14 21 35 -25 61 1884 1955 0.11 0.1 2.7
175 2014-12-22 37 27 46 23 37 -23 61 1989 1949 0.04 0.11 1.62
187 2015-1-3 43 33 52 21 36 -22 65 1879 1950 0.79 0.1 2.82
202 2015-1-18 36 28 44 20 35 -22 64 1994 1929 0.01 0.08 1.96
204 2015-1-20 40 30 50 20 36 -22 70 1985 1906 0.0 0.08 1.26
174 2014-12-21 28 20 36 23 37 -21 67 1989 1967 0.0 0.11 2.57
205 2015-1-21 37 30 43 20 36 -21 68 1984 1906 0.0 0.08 2.25
225 2015-2-10 27 18 36 23 39 -21 73 1982 1932 0.0 0.09 1.56
190 2015-1-6 14 9 19 21 35 -20 63 1884 2008 0.08 0.09 1.48
200 2015-1-16 32 21 42 20 35 -20 66 1972 1990 0.0 0.08 1.42
201 2015-1-17 39 27 51 20 35 -20 67 1977 1952 0.0 0.09 1.11
196 2015-1-12 25 19 31 20 35 -19 69 1918 1890 0.19 0.09 1.28
217 2015-2-2 20 13 27 21 37 -19 59 1951 1911 0.01 0.09 1.24
193 2015-1-9 11 1 21 21 35 -18 66 1875 1880 0.0 0.09 1.15
207 2015-1-23 29 24 34 20 36 -18 67 1936 1909 0.0 0.08 0.9
212 2015-1-28 25 15 34 21 36 -18 65 1963 2002 0.0 0.08 2.0
224 2015-2-9 31 26 36 22 38 -18 66 1899 1943 0.0 0.08 2.04
177 2014-12-24 40 34 45 22 37 -17 68 1983 1889 0.52 0.1 1.54
191 2015-1-7 3 -6 12 21 35 -17 68 1970 2008 0.0 0.09 1.58
199 2015-1-15 25 13 36 20 35 -17 66 1972 1932 0.0 0.08 1.68
206 2015-1-22 31 28 33 20 36 -17 64 1936 1964 0.0 0.07 1.87
228 2015-2-13 20 9 31 23 39 -17 67 1899 1938 0.0 0.08 1.48
194 2015-1-10 11 -3 24 20 35 -16 62 1982 1975 0.0 0.09 1.29
195 2015-1-11 28 21 34 20 35 -16 70 1977 1890 0.43 0.08 1.16
208 2015-1-24 30 20 39 20 36 -16 70 1963 1967 0.0 0.08 1.06
220 2015-2-5 15 5 24 22 37 -16 66 1979 1927 0.0 0.09 1.83
162 2014-12-9 36 32 39 26 41 -15 65 1876 1952 0.01 0.11 1.39
169 2014-12-16 39 31 46 24 38 -15 65 1951 1948 0.19 0.1 0.81
176 2014-12-23 50 45 55 23 37 -15 64 1989 1933 0.17 0.11 1.71
178 2014-12-25 36 31 41 22 36 -15 64 1983 1893 0.01 0.11 1.36
188 2015-1-4 28 12 44 21 36 -15 66 1879 1998 0.01 0.1 2.44
183 2014-12-30 23 15 31 21 36 -14 67 1983 1965 0.0 0.1 1.94
209 2015-1-25 29 20 37 20 36 -14 71 1897 1950 0.04 0.08 0.92
223 2015-2-8 47 36 57 22 38 -14 68 1895 1937 0.0 0.08 0.78
229 2015-2-14 18 6 30 24 40 -14 65 1905 1954 0.0 0.09 1.37
181 2014-12-28 28 22 33 22 36 -13 65 1924 1984 0.0 0.1 2.02
182 2014-12-29 29 20 37 22 36 -13 66 1880 1889 0.0 0.1 1.36
192 2015-1-8 7 -7 20 21 35 -13 63 1970 1965 0.0 0.1 1.41
213 2015-1-29 38 30 45 21 36 -13 66 1873 2002 0.0 0.08 1.5
172 2014-12-19 24 19 29 23 38 -12 67 1884 1877 0.0 0.1 1.49
173 2014-12-20 29 25 32 23 37 -12 66 1963 1949 0.0 0.1 0.82
185 2015-1-1 26 18 34 21 36 -12 69 1968 1876 0.0 0.1 3.81
186 2015-1-2 32 25 39 21 36 -12 65 1887 2006 0.0 0.1 1.58
210 2015-1-26 22 17 26 20 36 -12 67 1897 1944 0.0 0.08 1.41
219 2015-2-4 29 15 42 21 37 -12 69 1996 1890 0.07 0.08 1.68
221 2015-2-6 25 12 37 22 38 -12 64 1977 1925 0.0 0.07 1.14
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
222 2015-2-7 42 28 55 22 38 -11 66 1977 1925 0.0 0.08 1.53
233 2015-2-18 9 0 17 25 41 -11 66 1936 1961 0.07 0.08 1.58
161 2014-12-8 36 31 41 26 41 -10 66 1882 1966 0.06 0.11 1.58
168 2014-12-15 43 41 44 24 39 -10 69 1951 1948 0.01 0.1 1.45
170 2014-12-17 27 23 31 24 38 -10 64 1989 1984 0.0 0.1 1.64
171 2014-12-18 25 22 27 24 38 -10 65 1884 1877 0.0 0.09 2.05
197 2015-1-13 16 8 23 20 35 -10 64 1997 1950 0.0 0.09 1.47
211 2015-1-27 25 20 29 21 36 -10 66 1936 1916 0.01 0.08 1.14
227 2015-2-12 20 13 27 23 39 -10 66 1899 1984 0.0 0.08 2.67
164 2014-12-11 31 25 37 25 40 -9 66 1977 1931 0.0 0.1 1.87
184 2014-12-31 16 9 23 21 36 -9 68 1967 1951 0.0 0.1 1.62
226 2015-2-11 32 25 39 23 39 -9 75 1885 1999 0.0 0.08 1.87
232 2015-2-17 14 1 26 24 41 -9 69 1903 1911 0.01 0.08 0.91
237 2015-2-22 22 15 29 26 43 -9 70 1963 1922 0.0 0.08 2.09
163 2014-12-10 33 30 35 26 40 -8 66 1917 1971 0.0 0.1 1.37
230 2015-2-15 12 4 20 24 40 -8 72 1875 1954 0.0 0.08 1.5
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
160 2014-12-7 33 26 39 27 41 -7 65 1882 1951 0.0 0.1 1.15
165 2014-12-12 29 22 35 25 40 -7 63 1962 1927 0.0 0.1 1.06
180 2014-12-27 40 33 46 22 36 -7 68 1925 2008 0.2 0.1 1.95
198 2015-1-14 13 5 21 20 35 -7 65 1957 1928 0.0 0.08 1.77
231 2015-2-16 11 6 16 24 40 -7 72 1943 1883 0.14 0.08 1.58
240 2015-2-25 24 14 33 27 44 -7 76 1900 2000 0.0 0.09 2.35
242 2015-2-27 10 2 18 27 45 -7 73 1963 1996 0.0 0.09 1.11
245 2015-3-2 24 14 34 28 46 -7 74 1980 1992 0.0 0.09 1.56
239 2015-2-24 10 -6 25 26 43 -6 71 2015 2000 0.0 0.08 1.05
241 2015-2-26 16 7 25 27 44 -6 68 1963 1998 0.04 0.09 2.49
249 2015-3-6 16 2 30 30 47 -6 75 1960 1973 0.0 0.11 1.21
251 2015-3-8 38 27 49 30 48 -6 80 1943 1974 0.0 0.1 2.28
145 2014-11-22 43 30 56 33 49 -5 74 1880 1900 0.02 0.13 1.68
179 2014-12-26 41 30 52 22 36 -5 67 1983 1875 0.0 0.11 1.22
246 2015-3-3 33 26 40 29 46 -5 77 1943 1992 0.28 0.09 2.01
255 2015-3-12 46 31 60 32 50 -5 76 1948 1990 0.0 0.11 1.97
166 2014-12-13 40 34 46 25 39 -4 65 1962 1975 0.0 0.1 1.73
167 2014-12-14 45 41 48 25 39 -4 68 1901 1984 0.0 0.09 2.12
236 2015-2-21 26 16 35 26 42 -4 68 1963 1930 0.47 0.08 1.53
244 2015-3-1 27 22 31 28 45 -4 71 1960 1976 0.53 0.1 1.9
142 2014-11-19 26 14 37 34 51 -3 76 1880 1930 0.0 0.13 2.74
155 2014-12-2 30 26 33 29 44 -3 74 1886 1982 0.01 0.11 1.84
148 2014-11-25 31 26 36 31 47 -2 69 1950 1908 0.0 0.12 2.19
153 2014-11-30 52 39 64 29 45 -2 68 1958 1927 0.02 0.12 1.81
156 2014-12-3 36 28 43 28 43 -2 69 1929 1982 0.01 0.1 3.46
147 2014-11-24 46 36 55 32 48 -1 65 1950 1973 0.18 0.13 1.23
152 2014-11-29 44 30 57 30 45 -1 70 1872 1927 0.0 0.12 1.0
159 2014-12-6 35 30 40 27 42 -1 73 1977 1998 0.26 0.1 1.05
238 2015-2-23 11 3 19 26 43 -1 71 1889 2000 0.01 0.09 1.1
248 2015-3-5 16 8 23 29 47 -1 75 1978 1956 0.0 0.1 3.06
250 2015-3-7 32 21 42 30 48 -1 78 1943 1974 0.0 0.11 1.45

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