us-weather-history/KIND

365 rows

View and edit SQL

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
101 2014-10-9 51 45 56 47 68 30 88 1989 1939 0.02 0.11 1.25
102 2014-10-10 52 49 54 46 67 27 88 1964 2010 0.01 0.1 3.88
103 2014-10-11 50 42 57 46 67 26 86 1906 2010 0.0 0.1 1.56
104 2014-10-12 54 45 62 46 67 26 86 1988 1879 0.3 0.1 3.01
105 2014-10-13 67 58 76 45 66 24 86 1988 1975 0.57 0.1 0.92
106 2014-10-14 61 55 67 45 66 24 86 1979 1899 0.56 0.1 1.71
107 2014-10-15 55 53 56 45 66 27 87 1876 1897 0.18 0.1 1.14
108 2014-10-16 56 51 61 45 65 26 85 1991 1897 0.0 0.1 1.65
109 2014-10-17 59 50 68 44 65 26 86 1948 1950 0.0 0.1 1.45
110 2014-10-18 50 46 54 44 65 22 84 1948 1953 0.09 0.1 2.15
111 2014-10-19 50 43 56 44 64 25 85 1992 1953 0.0 0.1 1.33
112 2014-10-20 57 46 68 44 64 23 86 1972 1953 0.01 0.1 1.33
113 2014-10-21 51 44 57 43 64 23 86 1952 1953 0.02 0.09 1.43
114 2014-10-22 48 38 57 43 63 23 85 1976 1947 0.0 0.1 1.84
115 2014-10-23 49 37 60 43 63 24 86 1969 1963 0.0 0.09 1.57
116 2014-10-24 53 40 66 42 62 20 81 1981 1963 0.0 0.09 1.52
117 2014-10-25 63 50 76 42 62 25 82 1887 1963 0.0 0.09 1.54
118 2014-10-26 55 42 68 42 62 20 82 1962 1963 0.0 0.1 2.45
119 2014-10-27 66 51 80 42 61 24 83 1976 1940 0.0 0.1 1.71
120 2014-10-28 58 46 70 41 61 20 82 1976 1927 0.31 0.1 1.72
121 2014-10-29 47 39 54 41 61 22 81 1952 1922 0.0 0.1 1.16
122 2014-10-30 44 34 53 41 60 22 82 1895 1950 0.0 0.11 1.3
123 2014-10-31 40 33 47 41 60 24 82 1988 1950 0.2 0.1 2.01
124 2014-11-1 36 29 43 40 59 24 81 1949 1950 0.0 0.12 1.95
125 2014-11-2 37 24 50 40 59 16 78 1951 1961 0.0 0.11 3.86
126 2014-11-3 54 42 66 40 59 11 77 1951 1987 0.0 0.12 0.65
127 2014-11-4 51 44 57 39 58 16 78 1951 2003 0.3 0.11 1.6
128 2014-11-5 47 40 54 39 58 15 76 1991 1975 0.0 0.12 1.92
129 2014-11-6 43 39 47 39 57 20 77 1982 1975 0.09 0.12 1.2
130 2014-11-7 40 33 46 38 57 16 76 1971 1915 0.0 0.11 3.51
131 2014-11-8 42 36 48 38 56 13 76 1991 1999 0.0 0.12 1.23
132 2014-11-9 40 29 51 38 56 17 76 1991 1999 0.0 0.11 1.15
133 2014-11-10 50 38 62 37 55 17 75 1957 1949 0.0 0.11 1.54
134 2014-11-11 48 34 61 37 55 18 76 1995 1927 0.06 0.12 1.63
135 2014-11-12 31 27 34 37 54 14 75 1911 1949 0.0 0.12 1.64
136 2014-11-13 24 20 27 36 54 10 77 1986 1955 0.0 0.13 2.02
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
139 2014-11-16 32 28 35 35 52 10 74 1883 1952 0.22 0.13 1.68
140 2014-11-17 21 13 29 35 52 4 77 1959 1958 0.0 0.13 2.48
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
143 2014-11-20 24 17 30 33 50 8 75 1914 1942 0.0 0.13 1.73
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
147 2014-11-24 46 36 55 32 48 -1 65 1950 1973 0.18 0.13 1.23
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
150 2014-11-27 28 24 31 31 46 1 70 1930 1990 0.0 0.12 2.03
151 2014-11-28 27 19 34 30 46 2 69 1930 1909 0.0 0.12 1.82
152 2014-11-29 44 30 57 30 45 -1 70 1872 1927 0.0 0.12 1.0
153 2014-11-30 52 39 64 29 45 -2 68 1958 1927 0.02 0.12 1.81
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
156 2014-12-3 36 28 43 28 43 -2 69 1929 1982 0.01 0.1 3.46
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
159 2014-12-6 35 30 40 27 42 -1 73 1977 1998 0.26 0.1 1.05
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
162 2014-12-9 36 32 39 26 41 -15 65 1876 1952 0.01 0.11 1.39
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
165 2014-12-12 29 22 35 25 40 -7 63 1962 1927 0.0 0.1 1.06
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
168 2014-12-15 43 41 44 24 39 -10 69 1951 1948 0.01 0.1 1.45
169 2014-12-16 39 31 46 24 38 -15 65 1951 1948 0.19 0.1 0.81
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
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
174 2014-12-21 28 20 36 23 37 -21 67 1989 1967 0.0 0.11 2.57
175 2014-12-22 37 27 46 23 37 -23 61 1989 1949 0.04 0.11 1.62
176 2014-12-23 50 45 55 23 37 -15 64 1989 1933 0.17 0.11 1.71
177 2014-12-24 40 34 45 22 37 -17 68 1983 1889 0.52 0.1 1.54
178 2014-12-25 36 31 41 22 36 -15 64 1983 1893 0.01 0.11 1.36
179 2014-12-26 41 30 52 22 36 -5 67 1983 1875 0.0 0.11 1.22
180 2014-12-27 40 33 46 22 36 -7 68 1925 2008 0.2 0.1 1.95
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
183 2014-12-30 23 15 31 21 36 -14 67 1983 1965 0.0 0.1 1.94
184 2014-12-31 16 9 23 21 36 -9 68 1967 1951 0.0 0.1 1.62
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
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
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
191 2015-1-7 3 -6 12 21 35 -17 68 1970 2008 0.0 0.09 1.58
192 2015-1-8 7 -7 20 21 35 -13 63 1970 1965 0.0 0.1 1.41
193 2015-1-9 11 1 21 21 35 -18 66 1875 1880 0.0 0.09 1.15
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
196 2015-1-12 25 19 31 20 35 -19 69 1918 1890 0.19 0.09 1.28
197 2015-1-13 16 8 23 20 35 -10 64 1997 1950 0.0 0.09 1.47
198 2015-1-14 13 5 21 20 35 -7 65 1957 1928 0.0 0.08 1.77
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

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