us-weather-history/KIND

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

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