us-weather-history/KIND

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

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