U.S. Weather History: KCLT.csv

Table actions

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 Downloads 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 · About: simonw/fivethirtyeight-datasette

365 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
1 1 2014-7-1 81 70 91 67 89 56 104 1919 2012 0.0 0.1 5.91
2 2 2014-7-2 85 74 95 68 89 56 101 2008 1931 0.0 0.1 1.53
3 3 2014-7-3 82 71 93 68 89 56 99 2010 1931 0.14 0.11 2.5
4 4 2014-7-4 75 64 86 68 89 55 99 1933 1955 0.0 0.1 2.63
5 5 2014-7-5 72 60 84 68 89 57 100 1967 1954 0.0 0.1 1.65
6 6 2014-7-6 74 61 87 68 89 57 99 1964 1948 0.0 0.1 1.95
7 7 2014-7-7 79 67 91 68 89 55 100 1972 1954 0.0 0.11 2.37
8 8 2014-7-8 83 72 94 68 89 58 101 1892 2010 0.0 0.11 1.87
9 9 2014-7-9 80 71 89 68 89 57 101 1891 1986 0.15 0.12 3.71
10 10 2014-7-10 78 71 85 68 89 53 101 1961 1926 0.0 0.11 2.45
11 11 2014-7-11 78 68 87 68 89 55 100 1961 1986 0.0 0.12 3.1
12 12 2014-7-12 79 67 91 68 89 59 102 1953 1930 0.0 0.11 1.95
13 13 2014-7-13 81 69 92 68 89 56 100 1918 1986 0.0 0.12 2.09
14 14 2014-7-14 85 74 96 68 89 59 102 2007 1954 0.0 0.12 2.15
15 15 2014-7-15 81 67 94 68 89 58 100 2001 1893 0.87 0.12 4.61
16 16 2014-7-16 76 66 85 68 89 58 100 2001 1887 0.0 0.12 1.47
17 17 2014-7-17 74 63 84 68 89 62 100 1886 1986 0.0 0.12 4.14
18 18 2014-7-18 77 70 83 68 89 62 102 1896 1887 0.0 0.12 1.82
19 19 2014-7-19 70 66 74 68 89 60 103 2009 1986 0.17 0.12 2.3
20 20 2014-7-20 74 65 83 68 89 60 101 1910 1986 0.0 0.12 1.25
21 21 2014-7-21 74 70 77 68 89 57 103 1890 1986 1.3 0.12 3.83
22 22 2014-7-22 79 72 85 68 89 58 103 2001 1926 0.0 0.12 2.56
23 23 2014-7-23 80 69 90 68 89 56 101 2007 1987 0.0 0.13 6.88
24 24 2014-7-24 80 71 89 68 89 59 100 1947 1952 0.06 0.12 2.83
25 25 2014-7-25 77 68 86 68 89 62 101 1947 2010 0.0 0.13 2.34
26 26 2014-7-26 78 66 89 68 89 60 100 1904 2005 0.0 0.13 2.84
27 27 2014-7-27 80 70 90 68 89 57 103 1920 1940 0.18 0.13 2.46
28 28 2014-7-28 79 68 90 68 89 54 102 1962 1952 0.06 0.13 2.98
29 29 2014-7-29 73 62 83 68 89 59 103 1920 1952 0.0 0.14 2.04
30 30 2014-7-30 74 63 85 68 89 58 101 1914 2011 0.0 0.14 4.24
31 31 2014-7-31 72 65 78 68 89 56 100 1914 1999 1.45 0.14 1.45
32 32 2014-8-1 68 65 70 68 89 58 98 1966 1957 2.39 0.14 2.39
33 33 2014-8-2 69 65 72 68 89 59 98 1895 1942 0.0 0.14 2.0
34 34 2014-8-3 77 67 86 68 89 60 98 1998 2011 0.0 0.15 4.51
35 35 2014-8-4 78 69 87 68 89 58 98 1912 1935 0.0 0.15 2.59
36 36 2014-8-5 77 65 88 68 89 55 100 1912 1954 0.0 0.15 3.01
37 37 2014-8-6 78 68 88 68 88 57 102 1912 1956 0.17 0.14 3.19
38 38 2014-8-7 78 67 88 68 88 50 100 2004 1963 0.0 0.13 1.53
39 39 2014-8-8 77 73 81 68 88 55 102 2004 2007 0.0 0.13 1.37
40 40 2014-8-9 76 68 84 68 88 56 104 2002 2007 0.0 0.13 1.26
41 41 2014-8-10 70 67 73 68 88 56 104 1879 2007 0.01 0.13 2.26
42 42 2014-8-11 78 71 85 68 88 58 98 1879 1956 0.58 0.13 3.04
43 43 2014-8-12 81 72 89 68 88 57 100 1890 1925 0.31 0.13 2.25
44 44 2014-8-13 75 65 84 68 88 57 102 1979 1956 0.0 0.14 1.27
45 45 2014-8-14 71 59 83 68 88 57 98 1967 1925 0.0 0.14 2.0
46 46 2014-8-15 73 60 86 68 88 55 99 1964 2007 0.0 0.14 3.17
47 47 2014-8-16 77 68 86 68 88 57 102 1924 1954 0.0 0.14 2.51
48 48 2014-8-17 78 67 89 67 88 55 97 1979 1911 0.0 0.14 2.92
49 49 2014-8-18 81 71 90 67 88 59 101 1976 1988 0.0 0.13 1.76
50 50 2014-8-19 80 70 90 67 87 59 100 1981 1988 0.0 0.14 1.96
51 51 2014-8-20 79 67 91 67 87 56 103 1918 1925 0.0 0.14 1.84
52 52 2014-8-21 80 67 93 67 87 56 103 1998 1983 0.0 0.13 2.22
53 53 2014-8-22 83 70 95 67 87 57 101 1886 1983 0.0 0.15 2.81
54 54 2014-8-23 82 73 91 67 87 53 103 1930 1983 0.08 0.13 2.74
55 55 2014-8-24 74 66 81 67 87 55 97 1888 1968 0.14 0.14 2.35
56 56 2014-8-25 72 60 83 66 87 56 98 1952 1943 0.0 0.14 3.16
57 57 2014-8-26 72 60 84 66 87 55 100 1942 1954 0.0 0.14 5.36
58 58 2014-8-27 72 57 87 66 86 55 101 1952 1954 0.0 0.13 4.39
59 59 2014-8-28 77 61 92 66 86 55 98 1905 1924 0.0 0.13 4.64
60 60 2014-8-29 79 69 88 66 86 54 100 1986 1948 0.0 0.13 1.42
61 61 2014-8-30 79 68 90 66 86 53 101 1965 1932 0.0 0.12 2.54
62 62 2014-8-31 83 74 91 65 86 53 99 1946 1957 0.06 0.12 3.4
63 63 2014-9-1 82 71 93 65 85 51 99 1999 1957 0.0 0.11 2.93
64 64 2014-9-2 82 69 94 65 85 53 99 1967 1932 0.0 0.12 1.2
65 65 2014-9-3 81 68 93 65 85 52 98 1967 1925 0.63 0.11 2.67
66 66 2014-9-4 77 69 85 64 85 54 100 1952 1925 0.82 0.11 1.15
67 67 2014-9-5 79 69 89 64 84 54 101 1967 1954 0.01 0.11 2.46
68 68 2014-9-6 80 70 90 64 84 53 104 1924 1954 0.0 0.11 3.47
69 69 2014-9-7 79 70 88 64 84 53 100 1924 1925 0.09 0.11 2.38
70 70 2014-9-8 70 67 73 63 84 54 99 1988 1925 0.0 0.11 1.96
71 71 2014-9-9 72 66 77 63 83 46 101 1998 1939 0.0 0.11 1.92
72 72 2014-9-10 72 65 79 63 83 47 98 1998 1939 0.0 0.1 3.64
73 73 2014-9-11 77 64 89 62 83 49 96 1956 1925 0.09 0.1 1.8
74 74 2014-9-12 81 72 90 62 83 45 95 1917 1925 0.08 0.09 1.76
75 75 2014-9-13 76 66 86 62 82 49 94 1917 1962 1.56 0.11 4.12
76 76 2014-9-14 66 62 69 61 82 47 97 1985 1897 0.0 0.1 3.23
77 77 2014-9-15 76 65 86 61 81 47 96 2000 1956 0.37 0.11 4.06
78 78 2014-9-16 76 65 86 61 81 47 96 2000 1956 0.37 0.11 4.06
79 79 2014-9-17 69 63 74 60 81 46 96 1984 1954 0.0 0.11 3.14
80 80 2014-9-18 71 62 80 60 81 48 99 2001 1896 0.0 0.11 4.84
81 81 2014-9-19 73 67 79 59 80 46 97 1984 1954 0.02 0.1 2.72
82 82 2014-9-20 71 59 82 59 80 45 98 1929 1925 0.0 0.11 2.82
83 83 2014-9-21 71 57 85 59 80 43 97 1918 1895 0.0 0.11 2.74
84 84 2014-9-22 69 61 76 58 79 43 98 1918 1895 0.0 0.1 2.92
85 85 2014-9-23 59 53 65 58 79 39 97 1999 1931 0.02 0.11 1.69
86 86 2014-9-24 59 53 64 57 79 43 95 1999 1895 0.19 0.1 3.89
87 87 2014-9-25 66 61 70 57 78 40 94 1887 2010 0.01 0.11 1.31
88 88 2014-9-26 67 62 71 57 78 42 94 1950 1961 0.0 0.11 2.54
89 89 2014-9-27 69 59 78 56 78 43 93 1940 1900 0.0 0.11 1.94
90 90 2014-9-28 68 60 76 56 77 41 93 1947 1954 0.0 0.12 3.38
91 91 2014-9-29 67 64 70 55 77 40 93 1942 1941 0.09 0.11 3.59
92 92 2014-9-30 71 59 83 55 77 38 91 1888 1926 0.0 0.12 3.65
93 93 2014-10-1 70 56 84 54 76 39 92 1899 1954 0.0 0.12 3.8
94 94 2014-10-2 72 59 85 54 76 36 92 1899 1954 0.0 0.11 1.6
95 95 2014-10-3 70 61 79 54 76 36 91 1974 1954 0.03 0.12 2.15
96 96 2014-10-4 55 43 67 53 75 33 95 1974 1954 0.0 0.12 4.21
97 97 2014-10-5 52 38 65 53 75 38 97 1974 1954 0.0 0.12 1.16
98 98 2014-10-6 62 47 76 52 75 38 98 1935 1954 0.0 0.12 1.98
99 99 2014-10-7 67 53 80 52 74 34 91 1935 1951 0.0 0.11 2.7
100 100 2014-10-8 72 58 86 52 74 34 93 1889 1941 0.0 0.12 3.82

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "us-weather-history/KCLT" (
"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
);