us-weather-history/KIND

365 rows sorted by actual_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
234 2015-2-19 2 -5 9 25 41 -8 69 1979 1930 0.0 0.08 1.21
191 2015-1-7 3 -6 12 21 35 -17 68 1970 2008 0.0 0.09 1.58
189 2015-1-5 9 4 14 21 35 -25 61 1884 1955 0.11 0.1 2.7
231 2015-2-16 11 6 16 24 40 -7 72 1943 1883 0.14 0.08 1.58
233 2015-2-18 9 0 17 25 41 -11 66 1936 1961 0.07 0.08 1.58
235 2015-2-20 6 -6 18 25 42 -8 67 1885 1983 0.0 0.08 3.02
242 2015-2-27 10 2 18 27 45 -7 73 1963 1996 0.0 0.09 1.11
141 2014-11-18 14 9 19 34 51 5 73 1880 1941 0.0 0.14 4.3
190 2015-1-6 14 9 19 21 35 -20 63 1884 2008 0.08 0.09 1.48
238 2015-2-23 11 3 19 26 43 -1 71 1889 2000 0.01 0.09 1.1
192 2015-1-8 7 -7 20 21 35 -13 63 1970 1965 0.0 0.1 1.41
230 2015-2-15 12 4 20 24 40 -8 72 1875 1954 0.0 0.08 1.5
193 2015-1-9 11 1 21 21 35 -18 66 1875 1880 0.0 0.09 1.15
198 2015-1-14 13 5 21 20 35 -7 65 1957 1928 0.0 0.08 1.77
184 2014-12-31 16 9 23 21 36 -9 68 1967 1951 0.0 0.1 1.62
197 2015-1-13 16 8 23 20 35 -10 64 1997 1950 0.0 0.09 1.47
248 2015-3-5 16 8 23 29 47 -1 75 1978 1956 0.0 0.1 3.06
194 2015-1-10 11 -3 24 20 35 -16 62 1982 1975 0.0 0.09 1.29
220 2015-2-5 15 5 24 22 37 -16 66 1979 1927 0.0 0.09 1.83
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
243 2015-2-28 16 7 25 28 45 2 68 1993 1895 0.23 0.09 1.17
210 2015-1-26 22 17 26 20 36 -12 67 1897 1944 0.0 0.08 1.41
232 2015-2-17 14 1 26 24 41 -9 69 1903 1911 0.01 0.08 0.91
136 2014-11-13 24 20 27 36 54 10 77 1986 1955 0.0 0.13 2.02
171 2014-12-18 25 22 27 24 38 -10 65 1884 1877 0.0 0.09 2.05
217 2015-2-2 20 13 27 21 37 -19 59 1951 1911 0.01 0.09 1.24
227 2015-2-12 20 13 27 23 39 -10 66 1899 1984 0.0 0.08 2.67
140 2014-11-17 21 13 29 35 52 4 77 1959 1958 0.0 0.13 2.48
172 2014-12-19 24 19 29 23 38 -12 67 1884 1877 0.0 0.1 1.49
211 2015-1-27 25 20 29 21 36 -10 66 1936 1916 0.01 0.08 1.14
237 2015-2-22 22 15 29 26 43 -9 70 1963 1922 0.0 0.08 2.09
143 2014-11-20 24 17 30 33 50 8 75 1914 1942 0.0 0.13 1.73
229 2015-2-14 18 6 30 24 40 -14 65 1905 1954 0.0 0.09 1.37
249 2015-3-6 16 2 30 30 47 -6 75 1960 1973 0.0 0.11 1.21
150 2014-11-27 28 24 31 31 46 1 70 1930 1990 0.0 0.12 2.03
170 2014-12-17 27 23 31 24 38 -10 64 1989 1984 0.0 0.1 1.64
183 2014-12-30 23 15 31 21 36 -14 67 1983 1965 0.0 0.1 1.94
196 2015-1-12 25 19 31 20 35 -19 69 1918 1890 0.19 0.09 1.28
214 2015-1-30 26 20 31 21 36 -11 65 1966 2013 0.01 0.08 1.47
228 2015-2-13 20 9 31 23 39 -17 67 1899 1938 0.0 0.08 1.48
244 2015-3-1 27 22 31 28 45 -4 71 1960 1976 0.53 0.1 1.9
137 2014-11-14 25 17 32 36 53 11 76 1986 1971 0.0 0.14 4.15
173 2014-12-20 29 25 32 23 37 -12 66 1963 1949 0.0 0.1 0.82
144 2014-11-21 23 12 33 33 49 2 73 1880 1990 0.0 0.14 3.71
155 2014-12-2 30 26 33 29 44 -3 74 1886 1982 0.01 0.11 1.84
181 2014-12-28 28 22 33 22 36 -13 65 1924 1984 0.0 0.1 2.02
206 2015-1-22 31 28 33 20 36 -17 64 1936 1964 0.0 0.07 1.87
216 2015-2-1 30 27 33 21 37 -11 63 1951 1911 0.29 0.08 1.21
240 2015-2-25 24 14 33 27 44 -7 76 1900 2000 0.0 0.09 2.35
135 2014-11-12 31 27 34 37 54 14 75 1911 1949 0.0 0.12 1.64
138 2014-11-15 26 17 34 36 53 12 74 1933 1971 0.0 0.13 2.55
149 2014-11-26 30 26 34 31 47 3 70 1898 1984 0.0 0.12 1.16
151 2014-11-28 27 19 34 30 46 2 69 1930 1909 0.0 0.12 1.82
185 2015-1-1 26 18 34 21 36 -12 69 1968 1876 0.0 0.1 3.81
195 2015-1-11 28 21 34 20 35 -16 70 1977 1890 0.43 0.08 1.16
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
245 2015-3-2 24 14 34 28 46 -7 74 1980 1992 0.0 0.09 1.56
139 2014-11-16 32 28 35 35 52 10 74 1883 1952 0.22 0.13 1.68
157 2014-12-4 32 29 35 28 43 5 70 1991 1998 0.06 0.1 0.98
163 2014-12-10 33 30 35 26 40 -8 66 1917 1971 0.0 0.1 1.37
165 2014-12-12 29 22 35 25 40 -7 63 1962 1927 0.0 0.1 1.06
236 2015-2-21 26 16 35 26 42 -4 68 1963 1930 0.47 0.08 1.53
247 2015-3-4 27 19 35 29 47 2 78 1873 1983 0.07 0.1 3.0
270 2015-3-27 28 21 35 36 56 11 84 1955 1910 0.0 0.13 2.27
148 2014-11-25 31 26 36 31 47 -2 69 1950 1908 0.0 0.12 2.19
174 2014-12-21 28 20 36 23 37 -21 67 1989 1967 0.0 0.11 2.57
199 2015-1-15 25 13 36 20 35 -17 66 1972 1932 0.0 0.08 1.68
215 2015-1-31 26 16 36 21 37 -11 66 2004 1917 0.13 0.08 1.26
218 2015-2-3 26 16 36 21 37 -11 62 1996 1992 0.0 0.08 2.5
224 2015-2-9 31 26 36 22 38 -18 66 1899 1943 0.0 0.08 2.04
225 2015-2-10 27 18 36 23 39 -21 73 1982 1932 0.0 0.09 1.56
142 2014-11-19 26 14 37 34 51 -3 76 1880 1930 0.0 0.13 2.74
164 2014-12-11 31 25 37 25 40 -9 66 1977 1931 0.0 0.1 1.87
182 2014-12-29 29 20 37 22 36 -13 66 1880 1889 0.0 0.1 1.36
209 2015-1-25 29 20 37 20 36 -14 71 1897 1950 0.04 0.08 0.92
221 2015-2-6 25 12 37 22 38 -12 64 1977 1925 0.0 0.07 1.14
154 2014-12-1 33 26 39 29 44 4 70 1886 1970 0.02 0.1 1.39
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
186 2015-1-2 32 25 39 21 36 -12 65 1887 2006 0.0 0.1 1.58
208 2015-1-24 30 20 39 20 36 -16 70 1963 1967 0.0 0.08 1.06
226 2015-2-11 32 25 39 23 39 -9 75 1885 1999 0.0 0.08 1.87
158 2014-12-5 37 34 40 27 42 8 70 1886 2001 0.98 0.11 1.14
159 2014-12-6 35 30 40 27 42 -1 73 1977 1998 0.26 0.1 1.05
246 2015-3-3 33 26 40 29 46 -5 77 1943 1992 0.28 0.09 2.01
271 2015-3-28 29 17 40 37 57 16 82 1934 1910 0.0 0.12 1.75
161 2014-12-8 36 31 41 26 41 -10 66 1882 1966 0.06 0.11 1.58
178 2014-12-25 36 31 41 22 36 -15 64 1983 1893 0.01 0.11 1.36
266 2015-3-23 36 30 41 35 55 12 80 1885 1939 0.03 0.12 1.48
200 2015-1-16 32 21 42 20 35 -20 66 1972 1990 0.0 0.08 1.42
219 2015-2-4 29 15 42 21 37 -12 69 1996 1890 0.07 0.08 1.68
250 2015-3-7 32 21 42 30 48 -1 78 1943 1974 0.0 0.11 1.45
124 2014-11-1 36 29 43 40 59 24 81 1949 1950 0.0 0.12 1.95
156 2014-12-3 36 28 43 28 43 -2 69 1929 1982 0.01 0.1 3.46
205 2015-1-21 37 30 43 20 36 -21 68 1984 1906 0.0 0.08 2.25
168 2014-12-15 43 41 44 24 39 -10 69 1951 1948 0.01 0.1 1.45
188 2015-1-4 28 12 44 21 36 -15 66 1879 1998 0.01 0.1 2.44
202 2015-1-18 36 28 44 20 35 -22 64 1994 1929 0.01 0.08 1.96

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