us-weather-history/KIND

365 rows sorted by rowid descending

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
365 2015-6-30 73 64 82 65 85 46 97 1943 1933 0.0 0.14 1.5
364 2015-6-29 70 63 77 65 85 48 103 1923 2012 0.21 0.14 1.63
363 2015-6-28 67 55 78 65 85 50 104 1950 2012 0.09 0.15 1.65
362 2015-6-27 66 60 72 65 85 48 100 1926 1934 0.0 0.14 2.79
361 2015-6-26 71 66 76 65 85 49 102 1979 1954 1.57 0.14 3.09
360 2015-6-25 75 66 83 65 84 46 102 1972 1988 0.85 0.15 3.73
359 2015-6-24 71 62 80 64 84 49 98 1887 1933 0.0 0.15 0.92
358 2015-6-23 76 68 83 64 84 44 96 1918 1930 0.0 0.14 2.81
357 2015-6-22 78 69 86 64 84 37 99 1992 1988 0.0 0.15 1.92
356 2015-6-21 75 65 84 64 84 41 98 1992 1988 0.27 0.14 1.95
355 2015-6-20 75 70 79 64 83 44 100 1980 1953 0.0 0.14 2.03
354 2015-6-19 73 68 78 63 83 48 97 1980 1953 0.67 0.14 1.75
353 2015-6-18 77 68 86 63 83 45 96 1960 1962 0.67 0.14 2.05
352 2015-6-17 76 72 79 63 83 46 95 1980 1913 0.75 0.14 1.73
351 2015-6-16 78 71 84 63 82 41 96 1917 1913 0.5 0.13 1.98
350 2015-6-15 79 70 88 62 82 45 94 1917 1952 0.54 0.13 1.82
349 2015-6-14 78 70 86 62 82 45 94 1955 1954 0.13 0.14 2.12
348 2015-6-13 80 71 88 62 82 45 95 1903 1894 0.0 0.14 2.2
347 2015-6-12 81 72 89 61 81 42 96 1903 1894 0.21 0.13 3.04
346 2015-6-11 80 69 90 61 81 41 96 1980 1933 0.0 0.14 2.9
345 2015-6-10 78 65 90 61 81 44 96 1988 1933 0.0 0.14 2.21
344 2015-6-9 70 58 82 60 80 41 94 1885 1914 0.0 0.14 2.11
343 2015-6-8 70 60 79 60 80 44 95 1913 1933 1.9 0.15 2.14
342 2015-6-7 75 62 88 60 80 41 98 1894 1933 0.0 0.14 3.8
341 2015-6-6 69 61 76 60 79 39 96 1894 1933 0.0 0.15 2.62
340 2015-6-5 75 63 87 59 79 40 98 1945 1925 0.0 0.15 1.51
339 2015-6-4 70 57 82 59 79 43 95 1946 2011 0.0 0.14 2.87
338 2015-6-3 61 51 71 59 78 40 100 1929 1895 0.0 0.14 2.89
337 2015-6-2 60 49 70 58 78 39 100 1956 1934 0.0 0.15 3.0
336 2015-6-1 58 52 64 58 78 39 96 2003 1934 0.0 0.14 1.95
335 2015-5-31 61 55 67 58 77 36 96 1889 1895 0.08 0.16 2.61
334 2015-5-30 75 66 84 57 77 37 94 1947 1895 1.28 0.15 3.8
333 2015-5-29 75 65 84 57 77 36 93 1965 1895 0.0 0.16 2.19
332 2015-5-28 72 60 84 57 76 39 96 1907 1911 0.0 0.16 1.5
331 2015-5-27 73 63 82 56 76 31 94 1961 1911 0.07 0.15 1.62
330 2015-5-26 72 64 80 56 76 35 94 1961 1911 0.07 0.16 2.33
329 2015-5-25 73 67 79 56 76 34 93 1925 1965 0.01 0.16 1.35
328 2015-5-24 72 59 85 55 75 37 90 1925 1965 0.0 0.17 1.55
327 2015-5-23 67 55 79 55 75 37 92 1963 1939 0.0 0.16 3.13
326 2015-5-22 60 44 76 55 75 35 93 1883 1941 0.0 0.16 2.16
325 2015-5-21 56 47 64 54 74 36 92 2002 1941 0.0 0.18 2.69
324 2015-5-20 48 43 52 54 74 38 90 1894 1977 0.0 0.16 1.68
323 2015-5-19 57 48 65 54 74 32 90 2002 1977 0.0 0.17 1.36
322 2015-5-18 71 62 79 53 73 35 90 1973 1962 0.0 0.17 2.36
321 2015-5-17 72 64 79 53 73 36 90 1973 1962 0.0 0.17 2.3
320 2015-5-16 68 64 71 53 73 32 90 1997 1900 0.53 0.17 1.6
319 2015-5-15 71 60 82 52 72 35 88 1973 2001 0.12 0.16 1.97
318 2015-5-14 60 49 70 52 72 33 88 1895 1881 0.0 0.17 1.84
317 2015-5-13 55 43 67 52 72 35 88 1878 1956 0.0 0.18 1.96
316 2015-5-12 57 50 64 51 72 33 88 1976 1881 0.0 0.17 2.15
315 2015-5-11 70 61 78 51 71 31 89 1945 1896 0.06 0.17 1.95
314 2015-5-10 74 64 83 51 71 28 92 1966 1896 0.05 0.16 1.92
313 2015-5-9 73 66 80 50 71 29 93 1947 1895 0.05 0.16 1.08
312 2015-5-8 74 63 85 50 70 31 90 1976 1896 0.0 0.16 2.34
311 2015-5-7 75 64 86 50 70 31 87 1974 1926 0.0 0.16 2.1
310 2015-5-6 74 61 86 49 70 31 89 1968 1949 0.0 0.16 2.56
309 2015-5-5 73 62 83 49 70 35 92 1957 1952 0.0 0.16 1.79
308 2015-5-4 67 58 76 49 69 30 88 1976 1949 0.13 0.16 1.47
307 2015-5-3 66 53 78 49 69 29 86 2005 1949 0.0 0.16 1.56
306 2015-5-2 62 49 75 48 69 31 87 1961 1959 0.0 0.15 2.93
305 2015-5-1 55 39 71 48 68 29 89 1963 1942 0.0 0.16 1.76
304 2015-4-30 53 44 61 48 68 31 90 1948 1942 0.0 0.14 1.66
303 2015-4-29 54 41 67 47 68 31 86 1976 1942 0.0 0.14 1.71
302 2015-4-28 51 39 63 47 68 28 86 1976 1894 0.0 0.14 1.71
301 2015-4-27 47 35 58 47 67 30 84 1976 1962 0.0 0.13 1.56
300 2015-4-26 49 39 58 46 67 31 87 1976 1915 0.0 0.13 1.48
299 2015-4-25 50 44 56 46 67 27 87 1919 1915 0.62 0.14 2.56
298 2015-4-24 47 32 62 46 66 28 90 1910 1925 0.0 0.13 1.65
297 2015-4-23 45 32 57 45 66 26 88 1986 1925 0.0 0.13 1.46
296 2015-4-22 44 37 50 45 66 27 85 1936 1960 0.1 0.13 2.34
295 2015-4-21 52 41 62 45 65 28 84 1907 1985 0.0 0.13 1.85
294 2015-4-20 52 45 58 44 65 23 85 1897 1915 0.3 0.12 2.66
293 2015-4-19 62 56 67 44 65 23 85 1983 2002 0.93 0.13 3.06
292 2015-4-18 64 51 76 44 64 19 87 1875 1977 0.0 0.13 2.29
291 2015-4-17 61 46 76 43 64 19 87 1875 1896 0.0 0.13 1.9
290 2015-4-16 61 53 68 43 64 21 87 1875 1896 0.2 0.12 2.08
289 2015-4-15 58 46 69 43 63 24 84 1928 2002 0.07 0.12 1.42
288 2015-4-14 58 51 64 42 63 24 85 1943 1883 0.0 0.13 1.55
287 2015-4-13 64 56 71 42 63 18 86 1950 1941 0.04 0.12 1.13
286 2015-4-12 57 43 70 42 62 20 86 1940 1930 0.0 0.12 0.8
285 2015-4-11 50 38 62 41 62 24 89 1973 1930 0.0 0.12 1.72
284 2015-4-10 56 42 69 41 62 23 84 1989 1930 0.04 0.13 1.97
283 2015-4-9 71 61 80 41 61 18 84 1997 2001 0.24 0.13 1.26
282 2015-4-8 64 55 72 40 61 18 83 1972 2001 0.74 0.13 2.15
281 2015-4-7 61 56 66 40 61 19 83 1982 2001 0.32 0.12 2.08
280 2015-4-6 55 47 62 40 60 22 83 1979 2010 0.0 0.12 1.9
279 2015-4-5 49 34 64 39 60 20 84 1995 1988 0.0 0.12 1.87
278 2015-4-4 43 30 55 39 59 23 80 1975 1929 0.0 0.12 1.48
277 2015-4-3 50 39 61 39 59 21 84 1879 2012 0.11 0.11 1.92
276 2015-4-2 62 52 72 38 59 20 81 1961 2010 0.29 0.12 2.08
275 2015-4-1 53 37 69 38 58 20 82 1923 2010 0.0 0.13 2.85
274 2015-3-31 54 44 63 38 58 13 85 1923 1981 0.0 0.13 1.56
273 2015-3-30 49 36 61 37 58 17 82 1923 1986 0.0 0.13 1.56
272 2015-3-29 38 24 51 37 57 16 82 1887 1895 0.06 0.13 1.46
271 2015-3-28 29 17 40 37 57 16 82 1934 1910 0.0 0.12 1.75
270 2015-3-27 28 21 35 36 56 11 84 1955 1910 0.0 0.13 2.27
269 2015-3-26 40 34 45 36 56 8 80 1955 1907 0.5 0.12 1.98
268 2015-3-25 48 42 54 36 56 5 81 1974 2007 0.63 0.13 4.7
267 2015-3-24 35 26 44 35 55 2 84 1974 1910 0.04 0.13 2.76
266 2015-3-23 36 30 41 35 55 12 80 1885 1939 0.03 0.12 1.48

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