us-weather-history/KJAX

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 76 64 88 63 82 46 94 2000 1941 0.0 0.17 1.8
102 2014-10-10 76 65 87 63 82 46 93 2000 2009 0.0 0.16 3.56
103 2014-10-11 75 62 88 62 82 45 91 1906 1959 0.0 0.16 4.3
104 2014-10-12 74 62 86 62 81 46 92 1971 2009 0.0 0.15 2.31
105 2014-10-13 76 66 86 62 81 43 89 1977 1986 0.03 0.14 1.82
106 2014-10-14 79 70 88 61 81 40 91 1977 1912 1.04 0.12 1.99
107 2014-10-15 69 59 78 61 81 40 90 1977 1990 0.04 0.13 2.24
108 2014-10-16 66 53 78 61 80 39 90 1978 1925 0.0 0.12 6.47
109 2014-10-17 66 52 80 60 80 37 91 1977 1989 0.0 0.11 3.86
110 2014-10-18 69 54 84 60 80 36 91 1977 1980 0.0 0.11 7.47
111 2014-10-19 67 57 76 59 80 43 91 1981 1980 0.0 0.1 9.21
112 2014-10-20 69 56 82 59 80 40 89 1981 2006 0.0 0.09 3.87
113 2014-10-21 71 59 83 59 79 36 89 1989 1993 0.0 0.09 3.18
114 2014-10-22 63 52 74 58 79 39 92 1976 2006 0.0 0.09 5.26
115 2014-10-23 61 49 73 58 79 40 88 1976 2007 0.0 0.08 3.6
116 2014-10-24 61 46 75 58 79 37 87 2006 1949 0.0 0.09 4.69
117 2014-10-25 62 47 77 57 78 38 89 2006 2010 0.0 0.08 4.76
118 2014-10-26 65 47 83 57 78 38 89 1980 2010 0.0 0.07 1.79
119 2014-10-27 71 54 87 57 78 40 90 1926 2010 0.0 0.07 2.64
120 2014-10-28 70 55 84 56 78 37 89 2008 2010 0.0 0.08 1.93
121 2014-10-29 72 58 85 56 78 33 87 2008 1984 0.0 0.07 1.76
122 2014-10-30 70 59 81 56 77 37 86 1910 1951 0.0 0.08 3.97
123 2014-10-31 63 50 75 55 77 38 86 1993 1896 0.0 0.07 2.84
124 2014-11-1 50 42 57 55 77 33 88 1993 1961 0.0 0.07 2.75
125 2014-11-2 50 37 62 55 77 35 87 1993 1961 0.0 0.08 1.37
126 2014-11-3 52 36 68 54 76 30 86 1954 2004 0.0 0.07 2.5
127 2014-11-4 61 47 74 54 76 31 87 1966 1992 0.0 0.08 2.68
128 2014-11-5 67 56 78 54 76 35 87 1976 2003 0.0 0.07 1.51
129 2014-11-6 69 56 82 53 76 32 86 1976 2003 0.0 0.08 1.92
130 2014-11-7 55 43 67 53 76 36 87 1976 1986 0.0 0.07 1.64
131 2014-11-8 56 41 70 53 75 30 85 1976 1986 0.0 0.08 1.86
132 2014-11-9 62 54 70 53 75 25 88 1976 1986 0.0 0.08 1.28
133 2014-11-10 59 52 65 52 75 33 84 1976 1948 0.0 0.07 2.29
134 2014-11-11 66 52 80 52 75 35 87 1977 1986 0.0 0.07 2.79
135 2014-11-12 61 45 77 52 74 31 87 2011 1986 0.0 0.07 1.3
136 2014-11-13 64 55 73 52 74 31 86 1987 1889 0.0 0.07 0.86
137 2014-11-14 53 44 61 51 74 31 84 1984 2008 0.0 0.07 2.21
138 2014-11-15 50 40 60 51 74 29 85 1969 1958 0.0 0.07 1.5
139 2014-11-16 62 47 77 51 73 25 85 1940 2011 0.0 0.07 2.1
140 2014-11-17 67 52 81 50 73 29 85 1970 1957 0.95 0.06 1.28
141 2014-11-18 43 33 52 50 73 32 85 2008 1938 0.0 0.07 1.26
142 2014-11-19 40 27 53 50 73 27 84 2014 1948 0.0 0.07 1.21
143 2014-11-20 45 24 65 50 73 24 86 2014 1988 0.0 0.06 2.17
144 2014-11-21 51 33 68 49 72 26 84 1937 1962 0.0 0.06 1.16
145 2014-11-22 62 51 72 49 72 25 84 2000 1948 0.0 0.06 2.08
146 2014-11-23 73 68 78 49 72 28 84 2000 1992 1.11 0.06 2.01
147 2014-11-24 78 70 86 49 72 25 86 1970 2014 0.0 0.06 1.21
148 2014-11-25 66 61 71 48 71 21 85 1970 1992 1.69 0.07 1.69
149 2014-11-26 52 41 63 48 71 27 84 1950 1946 0.21 0.06 1.48
150 2014-11-27 51 40 61 48 71 30 83 1903 1973 0.0 0.07 0.94
151 2014-11-28 44 35 53 48 70 26 85 1903 1948 0.0 0.08 3.61
152 2014-11-29 51 34 68 47 70 30 85 1959 1978 0.0 0.08 2.24
153 2014-11-30 58 41 74 47 70 26 84 1959 1982 0.0 0.08 1.81
154 2014-12-1 63 49 77 47 70 28 84 1979 1981 0.0 0.08 3.43
155 2014-12-2 66 52 79 47 69 25 84 1876 1991 0.0 0.09 1.12
156 2014-12-3 66 56 76 47 69 24 83 1876 1991 0.0 0.09 2.7
157 2014-12-4 65 54 76 46 69 25 84 1876 1994 0.0 0.09 3.81
158 2014-12-5 63 60 65 46 69 25 83 1876 2013 0.0 0.09 1.28
159 2014-12-6 70 60 79 46 69 26 83 1876 2013 0.0 0.09 1.38
160 2014-12-7 59 54 63 46 68 21 83 1937 2013 0.01 0.09 2.03
161 2014-12-8 53 49 56 45 68 24 83 2010 1978 0.0 0.08 1.8
162 2014-12-9 50 40 60 45 68 28 84 1984 2004 0.0 0.09 3.29
163 2014-12-10 48 36 59 45 68 25 82 1974 1961 0.0 0.08 2.86
164 2014-12-11 47 34 59 45 67 23 83 1981 1961 0.0 0.09 1.34
165 2014-12-12 50 35 64 45 67 22 83 1962 1961 0.0 0.09 2.72
166 2014-12-13 50 31 68 44 67 12 83 1962 1956 0.0 0.09 2.86
167 2014-12-14 51 31 71 44 67 20 82 2010 1956 0.0 0.08 2.07
168 2014-12-15 52 34 70 44 67 21 84 2010 2009 0.0 0.09 1.59
169 2014-12-16 55 34 76 44 66 26 83 1968 1956 0.0 0.09 1.86
170 2014-12-17 53 40 66 44 66 26 81 1943 1961 0.0 0.09 3.96
171 2014-12-18 52 39 64 43 66 25 81 1988 1961 0.0 0.1 1.54
172 2014-12-19 56 41 70 43 66 23 83 1975 1967 0.0 0.1 2.14
173 2014-12-20 60 51 69 43 66 19 82 1981 1990 0.0 0.1 2.86
174 2014-12-21 57 56 58 43 66 20 83 1901 2013 0.16 0.1 4.69
175 2014-12-22 63 56 70 43 65 25 84 1973 2013 2.59 0.1 2.89
176 2014-12-23 68 62 74 43 65 24 84 1989 1956 0.74 0.09 1.41
177 2014-12-24 72 64 79 42 65 18 81 1983 1981 0.22 0.1 1.65
178 2014-12-25 53 42 64 42 65 11 81 1983 1984 0.0 0.09 2.72
179 2014-12-26 53 38 67 42 65 13 83 1983 1987 0.0 0.1 1.59
180 2014-12-27 62 49 74 42 65 23 81 1935 2008 0.0 0.08 1.63
181 2014-12-28 68 54 82 42 65 20 83 2010 1971 0.0 0.09 2.61
182 2014-12-29 69 58 79 42 65 14 82 1894 1990 0.02 0.08 2.06
183 2014-12-30 64 56 71 42 65 19 83 1909 1990 0.0 0.09 1.12
184 2014-12-31 53 49 57 42 65 19 82 1917 1973 0.0 0.09 1.83
185 2015-1-1 55 48 61 41 65 21 81 1918 1967 0.0 0.09 1.2
186 2015-1-2 53 48 57 42 65 21 82 1928 1988 0.0 0.09 1.83
187 2015-1-3 71 60 81 41 64 19 81 1979 2015 0.0 0.09 1.97
188 2015-1-4 72 65 79 41 64 22 82 1887 1973 0.27 0.09 1.74
189 2015-1-5 56 45 66 41 64 23 81 1999 1972 0.0 0.09 2.4
190 2015-1-6 56 40 71 41 64 21 83 1999 2007 0.0 0.09 1.97
191 2015-1-7 52 39 65 41 64 21 82 1924 2007 0.0 0.1 2.96
192 2015-1-8 34 27 40 41 64 21 82 1970 2005 0.0 0.09 3.09
193 2015-1-9 45 35 55 41 64 19 83 1970 1974 0.0 0.11 2.1
194 2015-1-10 47 38 56 41 64 21 82 1970 1957 0.0 0.1 2.11
195 2015-1-11 56 48 63 41 64 17 83 1982 1972 0.07 0.11 2.69
196 2015-1-12 62 57 66 41 64 15 82 1886 1949 1.07 0.11 2.68
197 2015-1-13 58 52 64 41 64 13 82 1981 1972 0.0 0.11 2.23
198 2015-1-14 50 47 53 41 65 23 81 1964 1888 0.0 0.11 2.35
199 2015-1-15 45 42 48 41 65 22 83 1979 1989 0.19 0.11 0.89
200 2015-1-16 49 38 60 41 65 22 84 1927 1947 0.0 0.1 1.67

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "us-weather-history/KJAX" (
"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.903ms