us-weather-history/KIND

365 rows sorted by actual_precipitation

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
2 2014-7-2 71 63 79 66 85 50 99 1904 1970 0.0 0.16 4.5
3 2014-7-3 67 60 73 66 85 49 100 1968 1911 0.0 0.15 1.89
4 2014-7-4 67 54 79 66 85 48 103 1968 1911 0.0 0.15 2.4
5 2014-7-5 69 59 79 66 85 49 103 1972 2012 0.0 0.16 3.27
7 2014-7-7 74 68 79 66 85 54 105 1894 2012 0.0 0.16 4.43
9 2014-7-9 72 62 81 66 85 52 103 1952 1936 0.0 0.16 2.49
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
13 2014-7-13 78 72 84 66 85 49 103 1976 1936 0.0 0.17 2.78
15 2014-7-15 64 56 71 66 85 51 103 1967 1988 0.0 0.17 2.05
16 2014-7-16 63 53 72 66 85 49 98 1945 1988 0.0 0.15 2.32
17 2014-7-17 65 53 77 66 85 51 101 1976 2012 0.0 0.15 3.71
18 2014-7-18 68 57 78 66 85 51 100 1976 1954 0.0 0.15 2.61
19 2014-7-19 68 58 77 66 85 50 98 1984 1930 0.0 0.14 1.31
20 2014-7-20 71 60 81 66 85 49 103 1947 1934 0.0 0.13 4.0
21 2014-7-21 74 62 85 66 85 46 106 1944 1934 0.0 0.14 1.89
22 2014-7-22 78 67 88 66 85 49 106 1947 1901 0.0 0.14 1.82
24 2014-7-24 67 58 76 66 85 52 105 1947 1934 0.0 0.14 1.98
25 2014-7-25 65 56 74 66 85 51 105 1911 1934 0.0 0.13 2.61
28 2014-7-28 65 57 73 66 85 51 101 2013 1930 0.0 0.12 2.95
31 2014-7-31 70 59 80 66 84 49 98 1895 1913 0.0 0.12 2.84
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
35 2014-8-4 74 62 85 65 84 49 99 1912 1887 0.0 0.1 3.81
36 2014-8-5 73 65 81 65 84 51 103 1974 1918 0.0 0.1 1.65
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
40 2014-8-9 76 68 83 65 84 50 99 1884 1930 0.0 0.1 2.36
43 2014-8-12 65 58 71 65 84 47 101 2004 1881 0.0 0.1 1.93
44 2014-8-13 67 55 79 65 84 48 98 1964 1936 0.0 0.09 3.08
45 2014-8-14 70 59 81 65 84 48 95 1964 1871 0.0 0.09 2.72
46 2014-8-15 63 49 77 65 84 45 96 1979 2010 0.0 0.1 2.26
49 2014-8-18 76 65 86 65 84 48 98 1963 1936 0.0 0.11 1.61
51 2014-8-20 74 64 83 64 84 50 99 1897 1983 0.0 0.11 2.22
55 2014-8-24 78 70 86 64 84 49 98 1927 1936 0.0 0.09 1.75
58 2014-8-27 79 70 88 63 84 48 97 1968 1948 0.0 0.1 2.6
59 2014-8-28 75 66 84 63 83 43 96 1986 1953 0.0 0.1 2.44
60 2014-8-29 78 68 87 63 83 41 97 1965 1953 0.0 0.1 1.38
63 2014-9-1 77 71 82 62 83 44 100 1987 1953 0.0 0.1 7.2
65 2014-9-3 74 64 83 61 82 45 100 1952 2011 0.0 0.1 2.63
66 2014-9-4 77 66 87 61 82 46 98 1952 1954 0.0 0.09 6.8
68 2014-9-6 67 60 73 60 81 44 99 1988 1954 0.0 0.1 1.19
69 2014-9-7 65 54 76 60 81 42 98 1988 1939 0.0 0.11 2.71
70 2014-9-8 68 56 79 60 81 38 97 1986 1939 0.0 0.1 2.61
71 2014-9-9 69 57 81 59 80 41 98 1883 1939 0.0 0.1 2.34
73 2014-9-11 64 56 71 58 80 39 95 1917 1897 0.0 0.11 1.78
74 2014-9-12 59 53 64 58 79 40 96 1955 1897 0.0 0.11 1.08
75 2014-9-13 55 47 63 58 79 39 99 1975 1939 0.0 0.11 1.8
76 2014-9-14 57 46 68 57 79 37 100 1964 1939 0.0 0.11 2.93
79 2014-9-17 56 45 67 56 77 40 93 1984 1955 0.0 0.1 1.07
80 2014-9-18 61 49 72 55 77 39 95 1959 1953 0.0 0.09 1.64
81 2014-9-19 63 53 73 55 76 38 93 1956 1940 0.0 0.11 2.29
84 2014-9-22 57 47 66 53 75 37 93 1999 1895 0.0 0.11 1.22
85 2014-9-23 60 47 72 53 75 34 94 1974 2010 0.0 0.11 2.11
86 2014-9-24 62 47 76 53 74 34 92 1887 2007 0.0 0.1 1.29
87 2014-9-25 66 54 78 52 74 35 92 1950 1891 0.0 0.11 2.17
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
90 2014-9-28 71 58 83 51 72 33 91 1942 1939 0.0 0.11 1.41
91 2014-9-29 68 54 82 50 72 34 97 1970 1953 0.0 0.1 2.45
92 2014-9-30 62 52 71 50 72 30 89 1899 1971 0.0 0.11 1.88
93 2014-10-1 63 49 76 50 71 32 89 1946 1897 0.0 0.1 2.74
96 2014-10-4 45 40 49 48 70 31 90 1987 1951 0.0 0.11 1.55
100 2014-10-8 56 43 68 47 68 28 91 1987 2007 0.0 0.1 1.02
103 2014-10-11 50 42 57 46 67 26 86 1906 2010 0.0 0.1 1.56
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
111 2014-10-19 50 43 56 44 64 25 85 1992 1953 0.0 0.1 1.33
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
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
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
128 2014-11-5 47 40 54 39 58 15 76 1991 1975 0.0 0.12 1.92
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
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
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
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
160 2014-12-7 33 26 39 27 41 -7 65 1882 1951 0.0 0.1 1.15
163 2014-12-10 33 30 35 26 40 -8 66 1917 1971 0.0 0.1 1.37

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