us-weather-history/KIND

365 rows sorted by actual_mean_temp 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
56 2014-8-25 81 71 90 64 84 49 96 1887 1948 0.78 0.1 1.41
57 2014-8-26 81 69 93 63 84 48 97 1945 1948 0.26 0.11 1.9
347 2015-6-12 81 72 89 61 81 42 96 1903 1894 0.21 0.13 3.04
53 2014-8-22 80 73 86 64 84 46 101 1950 1936 0.02 0.1 1.9
67 2014-9-5 80 70 90 61 82 45 100 1974 1954 0.02 0.1 1.54
346 2015-6-11 80 69 90 61 81 41 96 1980 1933 0.0 0.14 2.9
348 2015-6-13 80 71 88 62 82 45 95 1903 1894 0.0 0.14 2.2
54 2014-8-23 79 70 88 64 84 46 96 1890 1936 0.81 0.1 2.07
58 2014-8-27 79 70 88 63 84 48 97 1968 1948 0.0 0.1 2.6
350 2015-6-15 79 70 88 62 82 45 94 1917 1952 0.54 0.13 1.82
13 2014-7-13 78 72 84 66 85 49 103 1976 1936 0.0 0.17 2.78
22 2014-7-22 78 67 88 66 85 49 106 1947 1901 0.0 0.14 1.82
52 2014-8-21 78 70 86 64 84 47 100 1950 1936 0.16 0.1 1.23
55 2014-8-24 78 70 86 64 84 49 98 1927 1936 0.0 0.09 1.75
60 2014-8-29 78 68 87 63 83 41 97 1965 1953 0.0 0.1 1.38
345 2015-6-10 78 65 90 61 81 44 96 1988 1933 0.0 0.14 2.21
349 2015-6-14 78 70 86 62 82 45 94 1955 1954 0.13 0.14 2.12
351 2015-6-16 78 71 84 63 82 41 96 1917 1913 0.5 0.13 1.98
357 2015-6-22 78 69 86 64 84 37 99 1992 1988 0.0 0.15 1.92
41 2014-8-10 77 70 84 65 84 50 99 1972 1911 0.13 0.1 1.25
63 2014-9-1 77 71 82 62 83 44 100 1987 1953 0.0 0.1 7.2
66 2014-9-4 77 66 87 61 82 46 98 1952 1954 0.0 0.09 6.8
353 2015-6-18 77 68 86 63 83 45 96 1960 1962 0.67 0.14 2.05
1 2014-7-1 76 66 86 66 85 48 97 1885 1970 0.13 0.16 5.09
27 2014-7-27 76 66 85 66 85 51 100 1962 1916 0.22 0.12 1.86
40 2014-8-9 76 68 83 65 84 50 99 1884 1930 0.0 0.1 2.36
49 2014-8-18 76 65 86 65 84 48 98 1963 1936 0.0 0.11 1.61
50 2014-8-19 76 65 86 64 84 50 100 1896 1936 0.5 0.1 1.65
62 2014-8-31 76 69 83 62 83 44 97 1915 1951 0.01 0.1 2.43
352 2015-6-17 76 72 79 63 83 46 95 1980 1913 0.75 0.14 1.73
358 2015-6-23 76 68 83 64 84 44 96 1918 1930 0.0 0.14 2.81
14 2014-7-14 75 65 85 66 85 48 106 1975 1936 0.39 0.16 2.96
26 2014-7-26 75 67 82 66 85 51 98 1911 1941 0.1 0.13 2.41
42 2014-8-11 75 68 82 65 84 52 99 1967 1941 0.1 0.09 2.07
59 2014-8-28 75 66 84 63 83 43 96 1986 1953 0.0 0.1 2.44
61 2014-8-30 75 71 78 63 83 42 95 1986 1953 0.02 0.1 2.16
72 2014-9-10 75 67 82 59 80 40 96 1969 2013 0.9 0.11 2.6
311 2015-5-7 75 64 86 50 70 31 87 1974 1926 0.0 0.16 2.1
333 2015-5-29 75 65 84 57 77 36 93 1965 1895 0.0 0.16 2.19
334 2015-5-30 75 66 84 57 77 37 94 1947 1895 1.28 0.15 3.8
340 2015-6-5 75 63 87 59 79 40 98 1945 1925 0.0 0.15 1.51
342 2015-6-7 75 62 88 60 80 41 98 1894 1933 0.0 0.14 3.8
355 2015-6-20 75 70 79 64 83 44 100 1980 1953 0.0 0.14 2.03
356 2015-6-21 75 65 84 64 84 41 98 1992 1988 0.27 0.14 1.95
360 2015-6-25 75 66 83 65 84 46 102 1972 1988 0.85 0.15 3.73
6 2014-7-6 74 64 83 66 85 48 105 2001 2012 0.03 0.15 1.64
7 2014-7-7 74 68 79 66 85 54 105 1894 2012 0.0 0.16 4.43
8 2014-7-8 74 67 81 66 85 51 104 1984 1936 0.32 0.16 2.6
12 2014-7-12 74 67 80 66 85 53 103 1975 1936 0.07 0.16 2.7
21 2014-7-21 74 62 85 66 85 46 106 1944 1934 0.0 0.14 1.89
35 2014-8-4 74 62 85 65 84 49 99 1912 1887 0.0 0.1 3.81
51 2014-8-20 74 64 83 64 84 50 99 1897 1983 0.0 0.11 2.22
65 2014-9-3 74 64 83 61 82 45 100 1952 2011 0.0 0.1 2.63
310 2015-5-6 74 61 86 49 70 31 89 1968 1949 0.0 0.16 2.56
312 2015-5-8 74 63 85 50 70 31 90 1976 1896 0.0 0.16 2.34
314 2015-5-10 74 64 83 51 71 28 92 1966 1896 0.05 0.16 1.92
33 2014-8-2 73 63 82 65 84 52 98 1927 1888 0.0 0.11 2.53
34 2014-8-3 73 61 84 65 84 50 98 1965 1897 0.0 0.11 1.72
36 2014-8-5 73 65 81 65 84 51 103 1974 1918 0.0 0.1 1.65
48 2014-8-17 73 65 81 65 84 52 99 1963 1988 0.03 0.11 3.18
309 2015-5-5 73 62 83 49 70 35 92 1957 1952 0.0 0.16 1.79
313 2015-5-9 73 66 80 50 71 29 93 1947 1895 0.05 0.16 1.08
329 2015-5-25 73 67 79 56 76 34 93 1925 1965 0.01 0.16 1.35
331 2015-5-27 73 63 82 56 76 31 94 1961 1911 0.07 0.15 1.62
354 2015-6-19 73 68 78 63 83 48 97 1980 1953 0.67 0.14 1.75
365 2015-6-30 73 64 82 65 85 46 97 1943 1933 0.0 0.14 1.5
9 2014-7-9 72 62 81 66 85 52 103 1952 1936 0.0 0.16 2.49
32 2014-8-1 72 61 82 65 84 53 97 1971 1887 0.01 0.11 2.86
64 2014-9-2 72 65 79 62 82 45 100 1885 1953 1.0 0.1 2.1
321 2015-5-17 72 64 79 53 73 36 90 1973 1962 0.0 0.17 2.3
328 2015-5-24 72 59 85 55 75 37 90 1925 1965 0.0 0.17 1.55
330 2015-5-26 72 64 80 56 76 35 94 1961 1911 0.07 0.16 2.33
332 2015-5-28 72 60 84 57 76 39 96 1907 1911 0.0 0.16 1.5
2 2014-7-2 71 63 79 66 85 50 99 1904 1970 0.0 0.16 4.5
10 2014-7-10 71 61 80 66 85 50 105 1963 1936 0.0 0.16 1.52
11 2014-7-11 71 60 81 66 85 52 104 1945 1936 0.0 0.16 2.49
20 2014-7-20 71 60 81 66 85 49 103 1947 1934 0.0 0.13 4.0
37 2014-8-6 71 63 79 65 84 50 99 1994 1918 0.0 0.11 4.46
38 2014-8-7 71 64 78 65 84 49 98 1989 1930 0.0 0.1 1.08
90 2014-9-28 71 58 83 51 72 33 91 1942 1939 0.0 0.11 1.41
94 2014-10-2 71 60 81 49 71 29 89 1974 1953 0.14 0.11 1.39
283 2015-4-9 71 61 80 41 61 18 84 1997 2001 0.24 0.13 1.26
319 2015-5-15 71 60 82 52 72 35 88 1973 2001 0.12 0.16 1.97
322 2015-5-18 71 62 79 53 73 35 90 1973 1962 0.0 0.17 2.36
359 2015-6-24 71 62 80 64 84 49 98 1887 1933 0.0 0.15 0.92
361 2015-6-26 71 66 76 65 85 49 102 1979 1954 1.57 0.14 3.09
31 2014-7-31 70 59 80 66 84 49 98 1895 1913 0.0 0.12 2.84
39 2014-8-8 70 65 74 65 84 48 98 1989 2012 0.03 0.09 1.51
45 2014-8-14 70 59 81 65 84 48 95 1964 1871 0.0 0.09 2.72
315 2015-5-11 70 61 78 51 71 31 89 1945 1896 0.06 0.17 1.95
339 2015-6-4 70 57 82 59 79 43 95 1946 2011 0.0 0.14 2.87
343 2015-6-8 70 60 79 60 80 44 95 1913 1933 1.9 0.15 2.14
344 2015-6-9 70 58 82 60 80 41 94 1885 1914 0.0 0.14 2.11
364 2015-6-29 70 63 77 65 85 48 103 1923 2012 0.21 0.14 1.63
5 2014-7-5 69 59 79 66 85 49 103 1972 2012 0.0 0.16 3.27
23 2014-7-23 69 62 76 66 85 46 102 1947 1934 1.61 0.14 1.61
71 2014-9-9 69 57 81 59 80 41 98 1883 1939 0.0 0.1 2.34
88 2014-9-26 69 55 82 52 73 37 91 2001 1891 0.0 0.1 1.62
89 2014-9-27 69 56 81 51 73 35 93 1991 1998 0.0 0.11 2.59
341 2015-6-6 69 61 76 60 79 39 96 1894 1933 0.0 0.15 2.62

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.066ms