home / fivethirtyeight

U.S. Weather History: KJAX.csv

This table contains data and code behind the story What 12 Months Of Record-Setting Temperatures Looks Like Across The U.S..

Code

Code file Description
wunderground_scraper.py Downloades weather data web pages from Weather Underground
wunderground_parser.py Parses the weather data from Weather Underground into a flat CSV file
visualize_weather.py Creates the visualization of the weather data

Data

Column Description
date The date of the weather record, formatted YYYY-M-D
actual_mean_temp The measured average temperature for that day
actual_min_temp The measured minimum temperature for that day
actual_max_temp The measured maximum temperature for that day
average_min_temp The average minimum temperature on that day since 1880
average_max_temp The average maximum temperature on that day since 1880
record_min_temp The lowest ever temperature on that day since 1880
record_max_temp The highest ever temperature on that day since 1880
record_min_temp_year The year that the lowest ever temperature occurred
record_max_temp_year The year that the highest ever temperature occurred
actual_precipitation The measured amount of rain or snow for that day
average_precipitation The average amount of rain or snow on that day since 1880
record_precipitation The highest amount of rain or snow on that day since 1880

Source: Weather Underground

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

365 rows

View and edit SQL

Suggested facets: average_max_temp, record_max_temp, average_precipitation

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
1 2014-7-1 82 72 91 72 91 65 100 1981 1990 0.0 0.21 7.26
2 2014-7-2 81 73 89 72 91 65 100 2000 1902 0.0 0.21 2.3
3 2014-7-3 84 71 96 72 92 63 99 2000 1970 0.41 0.22 4.87
4 2014-7-4 81 70 91 72 92 65 99 2000 1954 0.0 0.21 1.4
5 2014-7-5 82 73 90 72 92 66 100 2000 1877 0.01 0.21 1.85
6 2014-7-6 79 70 88 72 92 66 100 1986 1969 0.0 0.21 3.49
7 2014-7-7 81 70 92 72 92 65 101 1988 1902 0.0 0.21 2.07
8 2014-7-8 82 72 91 72 92 61 100 1972 1879 0.0 0.21 3.78
9 2014-7-9 83 71 94 72 92 63 101 2006 1941 0.0 0.22 2.07
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
13 2014-7-13 80 71 88 73 92 66 102 1974 1980 0.02 0.21 2.35
14 2014-7-14 83 73 92 73 92 63 102 1974 1951 0.0 0.2 2.11
15 2014-7-15 82 72 91 73 92 62 102 1974 1981 0.0 0.2 3.16
16 2014-7-16 81 72 89 73 92 67 102 2001 1981 0.62 0.2 3.66
17 2014-7-17 79 69 89 73 92 64 103 1980 1981 0.0 0.21 2.2
18 2014-7-18 79 71 87 73 92 68 100 2011 1887 0.71 0.21 1.1
19 2014-7-19 82 74 89 73 92 65 101 2011 2000 0.0 0.22 2.17
20 2014-7-20 83 73 92 73 92 68 103 2006 2000 0.0 0.22 3.17
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
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
25 2014-7-25 84 74 94 73 92 64 101 1977 1875 0.02 0.22 2.14
26 2014-7-26 83 73 92 73 92 67 102 2000 1926 0.0 0.22 2.94
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
29 2014-7-29 85 75 94 73 92 69 100 2000 1875 0.0 0.2 2.88
30 2014-7-30 81 70 92 73 92 68 102 1894 2010 0.0 0.2 1.74
31 2014-7-31 81 69 93 73 92 69 102 1914 1999 0.0 0.21 2.03
32 2014-8-1 84 74 93 73 92 68 102 1966 1999 0.0 0.21 3.73
33 2014-8-2 82 73 91 73 92 68 101 1997 1999 0.59 0.2 3.38
34 2014-8-3 81 73 89 73 92 69 99 1974 1957 0.7 0.21 2.72
35 2014-8-4 80 75 85 73 92 68 99 2001 2011 0.01 0.19 4.02
36 2014-8-5 83 74 92 73 92 69 99 1989 2011 0.0 0.2 3.23
37 2014-8-6 84 74 94 73 92 67 99 1969 1956 0.0 0.19 3.35
38 2014-8-7 85 74 95 73 92 66 100 1950 1956 0.0 0.2 3.3
39 2014-8-8 84 74 94 73 92 64 98 2002 2007 0.0 0.19 2.66
40 2014-8-9 84 73 95 73 92 63 101 2002 1987 0.0 0.2 2.04
41 2014-8-10 83 74 92 73 92 66 99 1918 1987 0.0 0.21 1.92
42 2014-8-11 82 72 92 73 91 68 98 2002 2011 0.7 0.21 1.46
43 2014-8-12 82 75 89 73 91 65 100 1989 1874 0.01 0.2 3.15
44 2014-8-13 80 74 86 73 91 64 99 1890 1954 0.08 0.21 2.34
45 2014-8-14 82 73 91 73 91 66 97 1890 1938 0.04 0.21 3.62
46 2014-8-15 81 73 89 73 91 67 99 1983 1956 0.0 0.21 3.06
47 2014-8-16 83 73 93 73 91 67 97 1954 1957 0.0 0.2 3.83
48 2014-8-17 83 73 93 73 91 67 99 1993 1954 0.25 0.2 1.4
49 2014-8-18 84 74 93 73 91 67 98 1945 1954 0.02 0.21 3.26
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
52 2014-8-21 85 73 97 73 91 66 101 1961 1901 0.0 0.22 3.83
53 2014-8-22 86 73 99 73 90 64 100 1930 1900 0.0 0.22 6.8
54 2014-8-23 87 75 98 73 90 65 98 1886 1966 0.0 0.24 2.51
55 2014-8-24 82 73 91 73 90 66 99 1996 1987 0.0 0.25 4.46
56 2014-8-25 80 74 86 72 90 65 98 1997 1968 0.49 0.25 3.63
57 2014-8-26 78 70 85 72 90 64 98 1997 1872 0.14 0.26 3.74
58 2014-8-27 77 66 88 72 90 64 99 1984 2011 0.0 0.26 3.42
59 2014-8-28 77 64 90 72 90 64 97 2014 1959 0.0 0.25 7.82
60 2014-8-29 80 67 92 72 90 63 99 1984 1990 0.0 0.26 2.73
61 2014-8-30 82 72 91 72 90 64 98 1896 1948 0.0 0.25 3.88
62 2014-8-31 82 71 93 72 89 64 98 1999 1970 0.0 0.26 2.93
63 2014-9-1 84 73 94 72 89 62 98 1999 1912 0.0 0.28 6.4
64 2014-9-2 83 73 92 72 89 57 98 1999 1970 0.1 0.29 4.13
65 2014-9-3 81 70 91 72 89 64 99 1972 1912 0.0 0.29 1.81
66 2014-9-4 79 70 88 72 89 66 97 1972 1951 0.0 0.29 4.08
67 2014-9-5 79 70 88 72 89 63 98 1997 1999 1.27 0.29 5.56
68 2014-9-6 80 73 86 71 89 61 98 1997 1875 0.58 0.29 5.92
69 2014-9-7 76 73 78 71 88 63 96 1997 1951 1.31 0.29 3.85
70 2014-9-8 80 71 88 71 88 61 98 2011 1990 1.42 0.28 3.11
71 2014-9-9 79 71 86 71 88 62 97 2011 1990 0.55 0.27 6.1
72 2014-9-10 80 71 88 71 88 62 97 1956 1945 0.0 0.27 6.01
73 2014-9-11 80 70 90 71 88 62 96 1998 1954 0.0 0.27 4.12
74 2014-9-12 81 71 90 71 88 61 96 1917 1991 0.0 0.28 5.43
75 2014-9-13 82 72 91 70 88 61 97 1917 1991 0.0 0.28 2.96
76 2014-9-14 82 72 91 70 87 62 96 1956 1991 0.0 0.29 1.9
77 2014-9-15 82 72 92 70 87 62 96 1996 1972 0.12 0.29 3.85
78 2014-9-16 77 72 82 70 87 57 97 2001 1990 0.74 0.28 6.61
79 2014-9-17 80 71 88 70 87 60 96 2001 1896 0.0 0.28 3.82
80 2014-9-18 81 69 92 69 87 58 95 1981 1972 0.0 0.28 3.02
81 2014-9-19 77 70 84 69 86 48 96 1981 1942 0.37 0.29 2.84
82 2014-9-20 73 68 78 69 86 48 95 1981 1925 0.23 0.28 4.68
83 2014-9-21 76 64 87 69 86 49 97 1897 1990 0.0 0.26 5.27
84 2014-9-22 76 62 89 68 86 49 96 1897 1990 0.01 0.26 4.24
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
87 2014-9-25 71 63 78 68 85 51 94 1990 1961 0.0 0.26 4.04
88 2014-9-26 74 66 82 67 85 55 96 1940 1961 0.0 0.25 9.82
89 2014-9-27 75 71 79 67 85 54 94 1940 1970 0.0 0.26 5.26
90 2014-9-28 80 73 86 67 85 56 96 1909 1900 0.0 0.24 4.8
91 2014-9-29 76 72 80 66 84 53 92 1993 1936 3.05 0.24 4.73
92 2014-9-30 74 70 77 66 84 50 94 1967 1959 0.0 0.24 3.25
93 2014-10-1 76 70 82 66 84 48 94 1920 1958 0.0 0.21 5.14
94 2014-10-2 78 70 85 65 84 43 93 1876 1977 0.0 0.2 3.57
95 2014-10-3 78 68 88 65 83 45 94 1876 1911 0.61 0.2 7.83
96 2014-10-4 68 56 80 65 83 47 94 2011 1990 0.15 0.19 2.24
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
100 2014-10-8 76 63 89 63 82 44 95 1987 1949 0.0 0.17 3.91

Next page

Advanced export

JSON shape: default, array

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 31.092ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub