home / fivethirtyeight

U.S. Weather History: KNYC.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

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 62 55 68 52 66 37 86 2000 1916 0.0 0.15 7.33
102 2014-10-10 58 52 64 52 66 35 91 1888 1939 0.0 0.16 2.16
103 2014-10-11 55 50 60 51 65 34 85 1964 1949 0.33 0.15 3.06
104 2014-10-12 56 48 63 51 65 35 86 1876 1954 0.0 0.14 4.26
105 2014-10-13 59 52 65 51 65 33 87 1875 1954 0.05 0.14 2.75
106 2014-10-14 70 63 76 50 64 37 84 1988 1920 0.0 0.15 1.76
107 2014-10-15 73 69 77 50 64 32 84 1876 1956 0.69 0.14 1.7
108 2014-10-16 66 61 71 50 64 34 87 1876 1897 1.11 0.14 2.15
109 2014-10-17 65 59 71 50 63 33 90 1886 1938 0.0 0.14 2.28
110 2014-10-18 63 56 70 49 63 35 82 1974 1928 0.0 0.14 2.45
111 2014-10-19 50 44 56 49 63 30 83 1940 1963 0.0 0.14 4.35
112 2014-10-20 51 42 60 49 62 31 80 1974 1969 0.0 0.14 2.78
113 2014-10-21 61 55 67 48 62 32 84 1974 1920 0.11 0.14 2.17
114 2014-10-22 54 50 58 48 62 30 88 1940 1979 1.51 0.15 1.51
115 2014-10-23 52 50 53 48 61 32 85 1969 1947 0.61 0.14 2.97
116 2014-10-24 57 51 63 48 61 31 79 1969 2001 0.0 0.14 2.51
117 2014-10-25 59 50 67 47 61 29 79 1879 1963 0.01 0.15 3.3
118 2014-10-26 58 53 63 47 61 30 78 1879 1964 0.0 0.13 3.4
119 2014-10-27 56 48 63 47 60 28 82 1936 1963 0.0 0.14 1.88
120 2014-10-28 63 53 72 47 60 29 83 1976 1919 0.0 0.13 2.49
121 2014-10-29 62 51 72 46 60 31 78 1925 1971 0.0 0.14 3.67
122 2014-10-30 53 47 59 46 59 31 82 1925 1961 0.0 0.13 1.64
123 2014-10-31 50 45 55 46 59 29 81 1925 1946 0.05 0.14 2.41
124 2014-11-1 45 42 47 46 59 30 84 1885 1950 0.35 0.14 1.69
125 2014-11-2 45 41 48 45 58 30 83 1887 1950 0.0 0.14 1.7
126 2014-11-3 50 39 61 45 58 28 79 1875 2003 0.0 0.13 2.6
127 2014-11-4 61 53 68 45 58 25 78 1879 1975 0.0 0.13 1.44
128 2014-11-5 60 56 64 45 57 23 78 1879 1961 0.0 0.13 1.94
129 2014-11-6 53 48 57 44 57 27 74 1879 1948 0.37 0.14 1.47
130 2014-11-7 47 40 53 44 57 29 78 1930 1938 0.0 0.13 2.96
131 2014-11-8 42 36 48 44 57 29 76 1886 1975 0.0 0.12 7.4
132 2014-11-9 52 46 57 44 56 24 75 1976 1975 0.0 0.13 3.65
133 2014-11-10 53 44 61 43 56 27 73 1914 1985 0.0 0.13 1.7
134 2014-11-11 57 49 64 43 56 28 74 1933 1949 0.0 0.12 1.41
135 2014-11-12 56 47 65 43 55 26 76 1926 1879 0.0 0.12 2.39
136 2014-11-13 42 36 48 43 55 22 73 1873 1931 0.2 0.13 2.06
137 2014-11-14 39 35 42 42 55 20 72 1905 1993 0.06 0.13 2.23
138 2014-11-15 38 33 42 42 54 20 80 1967 1993 0.0 0.13 2.43
139 2014-11-16 40 35 45 42 54 17 72 1933 1928 0.03 0.13 2.39
140 2014-11-17 46 40 52 41 53 19 71 1933 1953 1.54 0.14 1.54
141 2014-11-18 35 24 45 41 53 18 73 1936 1928 0.0 0.14 1.24
142 2014-11-19 29 22 36 41 53 18 72 1936 1921 0.0 0.14 1.95
143 2014-11-20 38 31 45 40 52 20 77 1873 1985 0.0 0.13 3.37
144 2014-11-21 33 28 37 40 52 16 74 1879 1900 0.0 0.14 1.33
145 2014-11-22 36 28 44 40 52 13 72 1880 1931 0.0 0.14 2.03
146 2014-11-23 50 43 57 40 51 14 72 1880 1931 0.0 0.14 1.84
147 2014-11-24 61 53 69 39 51 14 73 1880 1979 0.7 0.14 1.95
148 2014-11-25 60 51 68 39 50 19 73 1938 1979 0.0 0.13 1.36
149 2014-11-26 43 34 51 39 50 16 67 1938 1946 1.24 0.14 1.91
150 2014-11-27 36 34 38 38 50 12 72 1932 1896 0.02 0.13 2.15
151 2014-11-28 33 29 37 38 49 15 70 1930 2011 0.0 0.14 2.14
152 2014-11-29 36 27 45 38 49 15 69 1872 1990 0.0 0.14 2.01
153 2014-11-30 50 45 55 37 49 7 70 1875 1991 0.0 0.15 1.11
154 2014-12-1 54 42 65 37 48 9 70 1875 2006 0.09 0.14 1.72
155 2014-12-2 39 35 43 37 48 12 66 1875 1970 0.08 0.14 2.16
156 2014-12-3 44 41 46 36 47 9 69 1976 1998 0.06 0.15 1.63
157 2014-12-4 41 37 45 36 47 10 74 1882 1998 0.0 0.14 1.84
158 2014-12-5 39 34 44 35 47 11 70 1926 2001 0.51 0.14 1.28
159 2014-12-6 45 39 50 35 46 11 71 1871 2001 1.22 0.13 1.6
160 2014-12-7 36 30 42 35 46 10 75 1926 1998 0.04 0.14 1.98
161 2014-12-8 31 24 37 34 45 10 65 1882 1927 0.0 0.14 1.54
162 2014-12-9 39 36 42 34 45 7 66 1876 1966 2.54 0.13 2.54
163 2014-12-10 36 32 40 34 45 3 70 1876 1946 0.08 0.14 1.62
164 2014-12-11 35 31 38 33 44 6 64 1880 1879 0.01 0.14 2.41
165 2014-12-12 35 32 38 33 44 5 68 1988 1931 0.0 0.13 1.6
166 2014-12-13 39 34 44 33 44 8 64 1960 1923 0.0 0.13 3.03
167 2014-12-14 42 38 46 32 43 12 67 1976 1881 0.0 0.13 2.22
168 2014-12-15 43 37 48 32 43 6 67 1874 2008 0.0 0.13 1.34
169 2014-12-16 44 38 49 32 43 7 63 1876 1971 0.2 0.12 2.25
170 2014-12-17 48 42 54 32 42 1 62 1919 2000 0.02 0.13 2.28
171 2014-12-18 40 37 42 31 42 -1 63 1919 1984 0.0 0.12 1.3
172 2014-12-19 35 31 38 31 42 -1 58 1884 1931 0.0 0.12 1.58
173 2014-12-20 32 30 33 31 42 -4 60 1942 2002 0.0 0.12 1.82
174 2014-12-21 34 31 36 30 41 -1 65 1942 2013 0.0 0.13 2.49
175 2014-12-22 40 35 44 30 41 2 71 1872 2013 0.04 0.12 2.18
176 2014-12-23 45 43 46 30 41 -1 66 1883 1990 0.16 0.13 1.61
177 2014-12-24 51 44 58 30 41 6 63 1983 1996 0.8 0.13 1.42
178 2014-12-25 53 44 62 29 40 -1 64 1980 1982 0.09 0.13 1.3
179 2014-12-26 45 40 50 29 40 3 63 1914 1982 0.0 0.12 1.66
180 2014-12-27 50 44 55 29 40 6 63 1872 1949 0.0 0.12 2.14
181 2014-12-28 49 43 54 29 40 8 65 1917 1982 0.1 0.12 1.35
182 2014-12-29 39 34 44 28 39 -6 70 1917 1984 0.0 0.11 2.52
183 2014-12-30 31 28 34 28 39 -13 65 1917 1984 0.0 0.12 1.69
184 2014-12-31 30 27 32 28 39 -7 63 1917 1965 0.0 0.11 2.31
185 2015-1-1 33 27 39 28 39 -4 62 1918 1966 0.0 0.12 2.05
186 2015-1-2 39 35 42 28 39 2 68 1918 1876 0.0 0.12 1.92
187 2015-1-3 38 33 42 28 39 -4 64 1879 2000 0.71 0.12 2.42
188 2015-1-4 49 41 56 27 39 -3 66 1918 1950 0.3 0.12 2.73
189 2015-1-5 35 21 49 27 38 -4 64 1904 1993 0.0 0.12 1.5
190 2015-1-6 21 19 22 27 38 -2 72 1896 2007 0.05 0.13 1.65
191 2015-1-7 16 9 23 27 38 4 64 2014 1907 0.0 0.12 2.67
192 2015-1-8 15 8 21 27 38 2 65 1968 1998 0.0 0.11 1.25
193 2015-1-9 26 19 33 27 38 -1 64 1968 1937 0.07 0.13 1.42
194 2015-1-10 20 16 23 27 38 -6 60 1875 1876 0.0 0.12 1.72
195 2015-1-11 28 18 37 27 38 3 63 1968 1975 0.0 0.12 1.46
196 2015-1-12 37 35 39 27 38 2 64 1981 1890 0.36 0.13 2.35
197 2015-1-13 27 17 36 27 38 -3 68 1914 1932 0.0 0.12 1.44
198 2015-1-14 24 16 32 27 38 -5 70 1914 1932 0.0 0.12 2.06
199 2015-1-15 30 25 35 27 38 0 67 1957 1932 0.0 0.13 1.27
200 2015-1-16 32 20 43 27 38 1 58 2004 1995 0.0 0.12 1.44

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "us-weather-history/KNYC" (
"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 2.272ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub