us-weather-history/KIND

365 rows sorted by record_min_temp_year

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
152 2014-11-29 44 30 57 30 45 -1 70 1872 1927 0.0 0.12 1.0
213 2015-1-29 38 30 45 21 36 -13 66 1873 2002 0.0 0.08 1.5
247 2015-3-4 27 19 35 29 47 2 78 1873 1983 0.07 0.1 3.0
83 2014-9-21 65 56 74 54 76 35 96 1875 2010 0.04 0.11 1.61
193 2015-1-9 11 1 21 21 35 -18 66 1875 1880 0.0 0.09 1.15
230 2015-2-15 12 4 20 24 40 -8 72 1875 1954 0.0 0.08 1.5
290 2015-4-16 61 53 68 43 64 21 87 1875 1896 0.2 0.12 2.08
291 2015-4-17 61 46 76 43 64 19 87 1875 1896 0.0 0.13 1.9
292 2015-4-18 64 51 76 44 64 19 87 1875 1977 0.0 0.13 2.29
107 2014-10-15 55 53 56 45 66 27 87 1876 1897 0.18 0.1 1.14
162 2014-12-9 36 32 39 26 41 -15 65 1876 1952 0.01 0.11 1.39
264 2015-3-21 49 34 63 34 54 11 84 1876 2012 0.0 0.12 1.06
317 2015-5-13 55 43 67 52 72 35 88 1878 1956 0.0 0.18 1.96
187 2015-1-3 43 33 52 21 36 -22 65 1879 1950 0.79 0.1 2.82
188 2015-1-4 28 12 44 21 36 -15 66 1879 1998 0.01 0.1 2.44
277 2015-4-3 50 39 61 39 59 21 84 1879 2012 0.11 0.11 1.92
141 2014-11-18 14 9 19 34 51 5 73 1880 1941 0.0 0.14 4.3
142 2014-11-19 26 14 37 34 51 -3 76 1880 1930 0.0 0.13 2.74
144 2014-11-21 23 12 33 33 49 2 73 1880 1990 0.0 0.14 3.71
145 2014-11-22 43 30 56 33 49 -5 74 1880 1900 0.02 0.13 1.68
146 2014-11-23 50 44 55 32 48 1 73 1880 1999 1.91 0.13 1.91
182 2014-12-29 29 20 37 22 36 -13 66 1880 1889 0.0 0.1 1.36
29 2014-7-29 64 52 75 66 85 51 100 1881 1941 0.21 0.13 0.8
160 2014-12-7 33 26 39 27 41 -7 65 1882 1951 0.0 0.1 1.15
161 2014-12-8 36 31 41 26 41 -10 66 1882 1966 0.06 0.11 1.58
71 2014-9-9 69 57 81 59 80 41 98 1883 1939 0.0 0.1 2.34
139 2014-11-16 32 28 35 35 52 10 74 1883 1952 0.22 0.13 1.68
326 2015-5-22 60 44 76 55 75 35 93 1883 1941 0.0 0.16 2.16
40 2014-8-9 76 68 83 65 84 50 99 1884 1930 0.0 0.1 2.36
171 2014-12-18 25 22 27 24 38 -10 65 1884 1877 0.0 0.09 2.05
172 2014-12-19 24 19 29 23 38 -12 67 1884 1877 0.0 0.1 1.49
189 2015-1-5 9 4 14 21 35 -25 61 1884 1955 0.11 0.1 2.7
190 2015-1-6 14 9 19 21 35 -20 63 1884 2008 0.08 0.09 1.48
1 2014-7-1 76 66 86 66 85 48 97 1885 1970 0.13 0.16 5.09
64 2014-9-2 72 65 79 62 82 45 100 1885 1953 1.0 0.1 2.1
226 2015-2-11 32 25 39 23 39 -9 75 1885 1999 0.0 0.08 1.87
235 2015-2-20 6 -6 18 25 42 -8 67 1885 1983 0.0 0.08 3.02
263 2015-3-20 44 39 48 34 54 3 83 1885 2012 0.03 0.12 2.13
266 2015-3-23 36 30 41 35 55 12 80 1885 1939 0.03 0.12 1.48
344 2015-6-9 70 58 82 60 80 41 94 1885 1914 0.0 0.14 2.11
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
158 2014-12-5 37 34 40 27 42 8 70 1886 2001 0.98 0.11 1.14
56 2014-8-25 81 71 90 64 84 49 96 1887 1948 0.78 0.1 1.41
86 2014-9-24 62 47 76 53 74 34 92 1887 2007 0.0 0.1 1.29
117 2014-10-25 63 50 76 42 62 25 82 1887 1963 0.0 0.09 1.54
186 2015-1-2 32 25 39 21 36 -12 65 1887 2006 0.0 0.1 1.58
272 2015-3-29 38 24 51 37 57 16 82 1887 1895 0.06 0.13 1.46
359 2015-6-24 71 62 80 64 84 49 98 1887 1933 0.0 0.15 0.92
265 2015-3-22 44 36 52 35 54 9 82 1888 1907 0.0 0.13 2.36
238 2015-2-23 11 3 19 26 43 -1 71 1889 2000 0.01 0.09 1.1
335 2015-5-31 61 55 67 58 77 36 96 1889 1895 0.08 0.16 2.61
54 2014-8-23 79 70 88 64 84 46 96 1890 1936 0.81 0.1 2.07
257 2015-3-14 51 43 59 32 51 10 81 1891 2012 0.43 0.11 3.02
7 2014-7-7 74 68 79 66 85 54 105 1894 2012 0.0 0.16 4.43
324 2015-5-20 48 43 52 54 74 38 90 1894 1977 0.0 0.16 1.68
341 2015-6-6 69 61 76 60 79 39 96 1894 1933 0.0 0.15 2.62
342 2015-6-7 75 62 88 60 80 41 98 1894 1933 0.0 0.14 3.8
31 2014-7-31 70 59 80 66 84 49 98 1895 1913 0.0 0.12 2.84
122 2014-10-30 44 34 53 41 60 22 82 1895 1950 0.0 0.11 1.3
223 2015-2-8 47 36 57 22 38 -14 68 1895 1937 0.0 0.08 0.78
318 2015-5-14 60 49 70 52 72 33 88 1895 1881 0.0 0.17 1.84
50 2014-8-19 76 65 86 64 84 50 100 1896 1936 0.5 0.1 1.65
51 2014-8-20 74 64 83 64 84 50 99 1897 1983 0.0 0.11 2.22
209 2015-1-25 29 20 37 20 36 -14 71 1897 1950 0.04 0.08 0.92
210 2015-1-26 22 17 26 20 36 -12 67 1897 1944 0.0 0.08 1.41
294 2015-4-20 52 45 58 44 65 23 85 1897 1915 0.3 0.12 2.66
149 2014-11-26 30 26 34 31 47 3 70 1898 1984 0.0 0.12 1.16
92 2014-9-30 62 52 71 50 72 30 89 1899 1971 0.0 0.11 1.88
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
228 2015-2-13 20 9 31 23 39 -17 67 1899 1938 0.0 0.08 1.48
240 2015-2-25 24 14 33 27 44 -7 76 1900 2000 0.0 0.09 2.35
259 2015-3-16 61 47 74 33 52 3 79 1900 1945 0.0 0.11 1.36
260 2015-3-17 47 33 60 33 52 2 77 1900 2012 0.0 0.12 1.35
167 2014-12-14 45 41 48 25 39 -4 68 1901 1984 0.0 0.09 2.12
232 2015-2-17 14 1 26 24 41 -9 69 1903 1911 0.01 0.08 0.91
347 2015-6-12 81 72 89 61 81 42 96 1903 1894 0.21 0.13 3.04
348 2015-6-13 80 71 88 62 82 45 95 1903 1894 0.0 0.14 2.2
2 2014-7-2 71 63 79 66 85 50 99 1904 1970 0.0 0.16 4.5
229 2015-2-14 18 6 30 24 40 -14 65 1905 1954 0.0 0.09 1.37
103 2014-10-11 50 42 57 46 67 26 86 1906 2010 0.0 0.1 1.56
295 2015-4-21 52 41 62 45 65 28 84 1907 1985 0.0 0.13 1.85
332 2015-5-28 72 60 84 57 76 39 96 1907 1911 0.0 0.16 1.5
298 2015-4-24 47 32 62 46 66 28 90 1910 1925 0.0 0.13 1.65
25 2014-7-25 65 56 74 66 85 51 105 1911 1934 0.0 0.13 2.61
26 2014-7-26 75 67 82 66 85 51 98 1911 1941 0.1 0.13 2.41
135 2014-11-12 31 27 34 37 54 14 75 1911 1949 0.0 0.12 1.64
35 2014-8-4 74 62 85 65 84 49 99 1912 1887 0.0 0.1 3.81
343 2015-6-8 70 60 79 60 80 44 95 1913 1933 1.9 0.15 2.14
143 2014-11-20 24 17 30 33 50 8 75 1914 1942 0.0 0.13 1.73
62 2014-8-31 76 69 83 62 83 44 97 1915 1951 0.01 0.1 2.43
73 2014-9-11 64 56 71 58 80 39 95 1917 1897 0.0 0.11 1.78
163 2014-12-10 33 30 35 26 40 -8 66 1917 1971 0.0 0.1 1.37
350 2015-6-15 79 70 88 62 82 45 94 1917 1952 0.54 0.13 1.82
351 2015-6-16 78 71 84 63 82 41 96 1917 1913 0.5 0.13 1.98
196 2015-1-12 25 19 31 20 35 -19 69 1918 1890 0.19 0.09 1.28
358 2015-6-23 76 68 83 64 84 44 96 1918 1930 0.0 0.14 2.81
299 2015-4-25 50 44 56 46 67 27 87 1919 1915 0.62 0.14 2.56
262 2015-3-19 45 40 50 34 53 7 82 1923 2012 0.02 0.12 1.9

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