home / fivethirtyeight

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

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
)
Powered by Datasette · Query took 896.197ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub