us-weather-history/KJAX

365 rows sorted by record_max_temp_year

View and edit SQL

Suggested facets: average_max_temp, record_max_temp, 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
27 2014-7-27 86 76 95 73 92 67 100 1978 1872 0.0 0.2 3.01
28 2014-7-28 87 78 96 73 92 67 104 1920 1872 0.0 0.2 4.46
57 2014-8-26 78 70 85 72 90 64 98 1997 1872 0.14 0.26 3.74
344 2015-6-9 82 73 91 69 89 58 101 1987 1872 0.0 0.2 2.36
43 2014-8-12 82 75 89 73 91 65 100 1989 1874 0.01 0.2 3.15
25 2014-7-25 84 74 94 73 92 64 101 1977 1875 0.02 0.22 2.14
29 2014-7-29 85 75 94 73 92 69 100 2000 1875 0.0 0.2 2.88
68 2014-9-6 80 73 86 71 89 61 98 1997 1875 0.58 0.29 5.92
5 2014-7-5 82 73 90 72 92 66 100 2000 1877 0.01 0.21 1.85
8 2014-7-8 82 72 91 72 92 61 100 1972 1879 0.0 0.21 3.78
10 2014-7-10 82 73 91 72 92 65 102 2000 1879 0.31 0.21 1.45
11 2014-7-11 81 72 89 73 92 65 104 1963 1879 0.27 0.21 3.14
12 2014-7-12 76 72 79 73 92 66 102 1890 1879 0.38 0.2 3.97
279 2015-4-5 68 60 75 53 77 35 89 1975 1880 0.0 0.1 2.46
18 2014-7-18 79 71 87 73 92 68 100 2011 1887 0.71 0.21 1.1
198 2015-1-14 50 47 53 41 65 23 81 1964 1888 0.0 0.11 2.35
136 2014-11-13 64 55 73 52 74 31 86 1987 1889 0.0 0.07 0.86
234 2015-2-19 35 27 42 45 69 24 86 1958 1891 0.0 0.12 2.66
79 2014-9-17 80 71 88 70 87 60 96 2001 1896 0.0 0.28 3.82
123 2014-10-31 63 50 75 55 77 38 86 1993 1896 0.0 0.07 2.84
309 2015-5-5 70 59 80 59 83 46 94 1976 1898 0.0 0.07 0.95
314 2015-5-10 78 63 92 61 84 49 93 1984 1899 0.0 0.07 1.18
322 2015-5-18 76 65 87 63 86 46 96 2011 1899 0.0 0.07 4.94
50 2014-8-19 84 73 94 73 91 64 99 1889 1900 0.0 0.21 3.22
51 2014-8-20 84 73 95 73 91 68 101 1960 1900 0.0 0.22 4.44
53 2014-8-22 86 73 99 73 90 64 100 1930 1900 0.0 0.22 6.8
90 2014-9-28 80 73 86 67 85 56 96 1909 1900 0.0 0.24 4.8
52 2014-8-21 85 73 97 73 91 66 101 1961 1901 0.0 0.22 3.83
2 2014-7-2 81 73 89 72 91 65 100 2000 1902 0.0 0.21 2.3
7 2014-7-7 81 70 92 72 92 65 101 1988 1902 0.0 0.21 2.07
222 2015-2-7 50 34 66 43 67 25 80 1988 1904 0.0 0.1 1.89
264 2015-3-21 73 64 82 51 75 30 90 1971 1907 0.53 0.12 0.95
267 2015-3-24 62 57 66 51 75 35 91 1968 1907 0.03 0.11 3.31
95 2014-10-3 78 68 88 65 83 45 94 1876 1911 0.61 0.2 7.83
63 2014-9-1 84 73 94 72 89 62 98 1999 1912 0.0 0.28 6.4
65 2014-9-3 81 70 91 72 89 64 99 1972 1912 0.0 0.29 1.81
106 2014-10-14 79 70 88 61 81 40 91 1977 1912 1.04 0.12 1.99
359 2015-6-24 85 74 95 71 91 63 101 2003 1914 0.0 0.23 4.6
205 2015-1-21 62 48 75 41 65 7 83 1985 1921 0.0 0.12 1.71
288 2015-4-14 78 67 88 54 79 40 90 1907 1922 0.0 0.1 2.42
82 2014-9-20 73 68 78 69 86 48 95 1981 1925 0.23 0.28 4.68
85 2014-9-23 75 69 81 68 86 53 95 1897 1925 0.05 0.26 5.1
86 2014-9-24 68 63 72 68 85 53 94 1990 1925 0.0 0.26 4.46
108 2014-10-16 66 53 78 61 80 39 90 1978 1925 0.0 0.12 6.47
26 2014-7-26 83 73 92 73 92 67 102 2000 1926 0.0 0.22 2.94
265 2015-3-22 70 62 77 51 75 31 90 1876 1935 0.08 0.11 1.77
266 2015-3-23 63 59 67 51 75 33 91 1986 1935 0.47 0.11 2.34
91 2014-9-29 76 72 80 66 84 53 92 1993 1936 3.05 0.24 4.73
202 2015-1-18 56 42 69 41 65 21 83 1977 1937 0.0 0.11 0.62
203 2015-1-19 51 33 68 41 65 19 83 1977 1937 0.0 0.11 2.9
208 2015-1-24 55 40 69 42 65 19 83 2003 1937 0.12 0.12 2.18
224 2015-2-9 55 42 68 44 67 19 88 1895 1937 0.13 0.11 1.64
45 2014-8-14 82 73 91 73 91 66 97 1890 1938 0.04 0.21 3.62
141 2014-11-18 43 33 52 50 73 32 85 2008 1938 0.0 0.07 1.26
325 2015-5-21 82 69 94 64 87 50 99 2002 1938 0.0 0.09 2.61
326 2015-5-22 75 64 86 65 87 47 99 1981 1938 0.0 0.09 7.59
226 2015-2-11 52 40 64 44 68 24 84 1971 1939 0.0 0.11 1.8
9 2014-7-9 83 71 94 72 92 63 101 2006 1941 0.0 0.22 2.07
101 2014-10-9 76 64 88 63 82 46 94 2000 1941 0.0 0.17 1.8
21 2014-7-21 81 73 88 73 92 66 102 1929 1942 0.0 0.23 1.8
22 2014-7-22 81 72 89 73 92 67 101 1965 1942 0.0 0.22 2.5
81 2014-9-19 77 70 84 69 86 48 96 1981 1942 0.37 0.29 2.84
201 2015-1-17 51 35 66 41 65 21 84 1977 1943 0.0 0.11 2.43
340 2015-6-5 77 67 86 68 89 59 100 1972 1943 0.02 0.17 3.31
352 2015-6-17 85 72 97 70 90 61 100 1961 1944 0.0 0.24 2.49
72 2014-9-10 80 71 88 71 88 62 97 1956 1945 0.0 0.27 6.01
251 2015-3-8 54 38 70 48 72 26 88 1899 1945 0.0 0.13 0.93
259 2015-3-16 68 51 84 50 74 30 89 1988 1945 0.0 0.13 2.35
263 2015-3-20 70 61 79 50 75 34 89 1923 1945 0.0 0.12 3.04
334 2015-5-30 73 65 81 67 88 51 97 1971 1945 0.94 0.12 1.82
335 2015-5-31 77 67 86 67 88 50 98 1984 1945 0.0 0.13 3.38
336 2015-6-1 78 66 89 67 88 47 99 1984 1945 0.72 0.16 2.8
149 2014-11-26 52 41 63 48 71 27 84 1950 1946 0.21 0.06 1.48
200 2015-1-16 49 38 60 41 65 22 84 1927 1947 0.0 0.1 1.67
280 2015-4-6 70 60 80 53 77 34 90 1891 1947 0.0 0.09 1.8
61 2014-8-30 82 72 91 72 90 64 98 1896 1948 0.0 0.25 3.88
133 2014-11-10 59 52 65 52 75 33 84 1976 1948 0.0 0.07 2.29
142 2014-11-19 40 27 53 50 73 27 84 2014 1948 0.0 0.07 1.21
145 2014-11-22 62 51 72 49 72 25 84 2000 1948 0.0 0.06 2.08
151 2014-11-28 44 35 53 48 70 26 85 1903 1948 0.0 0.08 3.61
100 2014-10-8 76 63 89 63 82 44 95 1987 1949 0.0 0.17 3.91
116 2014-10-24 61 46 75 58 79 37 87 2006 1949 0.0 0.09 4.69
196 2015-1-12 62 57 66 41 64 15 82 1886 1949 1.07 0.11 2.68
269 2015-3-26 68 58 77 51 76 32 88 1979 1949 0.53 0.12 1.65
210 2015-1-26 52 44 60 42 65 17 82 1905 1950 0.02 0.12 2.31
353 2015-6-18 85 72 97 71 90 59 100 2012 1950 0.0 0.24 2.78
356 2015-6-21 86 76 96 71 91 60 99 1965 1950 0.06 0.23 2.85
360 2015-6-25 81 73 89 71 91 64 99 1889 1950 1.16 0.23 7.36
362 2015-6-27 84 75 92 72 91 65 102 1936 1950 0.0 0.24 1.39
14 2014-7-14 83 73 92 73 92 63 102 1974 1951 0.0 0.2 2.11
66 2014-9-4 79 70 88 72 89 66 97 1972 1951 0.0 0.29 4.08
69 2014-9-7 76 73 78 71 88 63 96 1997 1951 1.31 0.29 3.85
97 2014-10-5 60 47 73 64 83 46 94 1987 1951 0.0 0.18 4.51
98 2014-10-6 64 50 78 64 83 49 95 1979 1951 0.0 0.17 3.48
99 2014-10-7 72 60 84 64 82 47 95 2010 1951 0.0 0.18 6.14
122 2014-10-30 70 59 81 56 77 37 86 1910 1951 0.0 0.08 3.97
23 2014-7-23 83 72 93 73 92 64 99 2007 1952 0.0 0.22 3.19
24 2014-7-24 83 72 93 73 92 68 100 1977 1952 0.0 0.23 2.32
361 2015-6-26 82 73 90 72 91 63 101 1966 1952 0.02 0.23 5.2
247 2015-3-4 74 62 85 48 71 24 86 1980 1953 0.0 0.14 1.31

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