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

✎ 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
235 235 2015-2-20 11 2 19 30 43 2 69 2015 1939 0.0 0.11 3.07
231 231 2015-2-16 12 3 21 29 42 1 71 1888 1954 0.0 0.12 1.4
239 239 2015-2-24 14 4 24 30 44 -4 75 1873 1985 0.0 0.12 1.69
192 192 2015-1-8 15 8 21 27 38 2 65 1968 1998 0.0 0.11 1.25
228 228 2015-2-13 15 8 21 29 41 -1 64 1914 1951 0.0 0.1 2.42
230 230 2015-2-15 15 4 25 29 42 -8 73 1943 1949 0.0 0.1 1.73
191 191 2015-1-7 16 9 23 27 38 4 64 2014 1907 0.0 0.12 2.67
234 234 2015-2-19 18 8 27 30 42 1 66 1936 1997 0.0 0.11 2.15
194 194 2015-1-10 20 16 23 27 38 -6 60 1875 1876 0.0 0.12 1.72
215 215 2015-1-31 20 13 26 27 39 -1 63 1920 1947 0.0 0.12 1.51
218 218 2015-2-3 20 13 26 27 39 0 64 1955 1991 0.0 0.11 1.55
221 221 2015-2-6 20 12 27 28 40 -4 68 1895 2008 0.0 0.11 2.74
249 249 2015-3-6 20 12 27 32 46 6 68 1872 1935 0.0 0.13 2.63
190 190 2015-1-6 21 19 22 27 38 -2 72 1896 2007 0.05 0.13 1.65
232 232 2015-2-17 21 14 27 29 42 -5 67 1896 1976 0.14 0.11 1.49
243 243 2015-2-28 21 13 29 31 45 5 67 1934 1976 0.0 0.12 1.21
236 236 2015-2-21 23 13 32 30 43 4 68 1896 1930 0.61 0.11 1.86
238 238 2015-2-23 23 8 38 30 43 5 70 1889 1985 0.0 0.12 1.38
198 198 2015-1-14 24 16 32 27 38 -5 70 1914 1932 0.0 0.12 2.06
217 217 2015-2-2 24 14 34 27 39 -3 59 1881 1988 1.02 0.11 2.98
229 229 2015-2-14 24 16 32 29 41 2 63 1916 1946 0.02 0.11 1.59
242 242 2015-2-27 24 18 30 31 44 5 72 1900 1997 0.0 0.12 1.56
201 201 2015-1-17 25 17 32 27 38 -2 63 1977 1990 0.0 0.12 1.36
211 211 2015-1-27 25 20 30 27 39 -1 69 1927 1916 0.36 0.11 1.94
212 212 2015-1-28 25 16 34 27 39 -2 66 1925 1916 0.0 0.11 1.87
193 193 2015-1-9 26 19 33 27 38 -1 64 1968 1937 0.07 0.13 1.42
233 233 2015-2-18 26 19 33 29 42 0 68 1979 1981 0.0 0.11 1.5
197 197 2015-1-13 27 17 36 27 38 -3 68 1914 1932 0.0 0.12 1.44
210 210 2015-1-26 27 22 31 27 39 3 72 1927 1950 0.48 0.11 2.19
224 224 2015-2-9 27 25 29 28 40 -15 63 1934 1990 0.09 0.1 1.74
241 241 2015-2-26 27 21 32 31 44 7 65 1990 1890 0.0 0.12 1.87
195 195 2015-1-11 28 18 37 27 38 3 63 1968 1975 0.0 0.12 1.46
213 213 2015-1-29 28 19 36 27 39 0 69 1873 2002 0.02 0.11 1.03
216 216 2015-2-1 28 20 36 27 39 -2 67 1920 1989 0.03 0.11 2.12
220 220 2015-2-5 28 14 42 28 40 -6 70 1918 1991 0.0 0.11 1.43
226 226 2015-2-11 28 22 34 28 41 -2 65 1899 1960 0.0 0.1 2.74
227 227 2015-2-12 28 16 40 28 41 -3 62 1914 1999 0.0 0.11 1.66
244 244 2015-3-1 28 24 31 31 45 5 73 1884 1972 0.52 0.13 2.95
250 250 2015-3-7 28 18 38 33 47 7 74 1890 1946 0.0 0.13 1.87
142 142 2014-11-19 29 22 36 41 53 18 72 1936 1921 0.0 0.14 1.95
214 214 2015-1-30 29 19 38 27 39 2 64 1873 2006 0.06 0.11 1.19
240 240 2015-2-25 29 20 37 31 44 1 75 1914 1930 0.0 0.11 2.11
184 184 2014-12-31 30 27 32 28 39 -7 63 1917 1965 0.0 0.11 2.31
199 199 2015-1-15 30 25 35 27 38 0 67 1957 1932 0.0 0.13 1.27
246 246 2015-3-3 30 22 37 32 45 11 65 2003 1991 0.67 0.12 2.25
248 248 2015-3-5 30 19 40 32 46 3 72 1872 1880 0.76 0.13 1.81
161 161 2014-12-8 31 24 37 34 45 10 65 1882 1927 0.0 0.14 1.54
183 183 2014-12-30 31 28 34 28 39 -13 65 1917 1984 0.0 0.12 1.69
205 205 2015-1-21 31 25 36 27 38 -2 63 1985 2006 0.0 0.12 3.45
266 266 2015-3-23 31 23 38 37 52 12 76 1875 1923 0.0 0.16 1.6
173 173 2014-12-20 32 30 33 31 42 -4 60 1942 2002 0.0 0.12 1.82
200 200 2015-1-16 32 20 43 27 38 1 58 2004 1995 0.0 0.12 1.44
144 144 2014-11-21 33 28 37 40 52 16 74 1879 1900 0.0 0.14 1.33
151 151 2014-11-28 33 29 37 38 49 15 70 1930 2011 0.0 0.14 2.14
185 185 2015-1-1 33 27 39 28 39 -4 62 1918 1966 0.0 0.12 2.05
222 222 2015-2-7 33 25 40 28 40 1 54 1910 1938 0.02 0.11 2.96
223 223 2015-2-8 33 29 37 28 40 -7 61 1934 1965 0.0 0.11 1.15
225 225 2015-2-10 33 26 40 28 41 -6 61 1899 2001 0.01 0.11 2.63
245 245 2015-3-2 33 27 39 32 45 9 72 1891 1972 0.0 0.12 2.41
271 271 2015-3-28 33 26 40 39 54 13 84 1923 1945 0.0 0.15 2.98
174 174 2014-12-21 34 31 36 30 41 -1 65 1942 2013 0.0 0.13 2.49
207 207 2015-1-23 34 28 39 27 38 -3 62 1936 1906 0.0 0.11 2.55
219 219 2015-2-4 34 24 43 28 40 0 68 1918 1991 0.0 0.1 2.1
261 261 2015-3-18 34 29 39 36 50 7 77 1916 1989 0.0 0.14 3.1
263 263 2015-3-20 34 29 38 36 51 11 83 1885 1945 0.4 0.15 1.93
141 141 2014-11-18 35 24 45 41 53 18 73 1936 1928 0.0 0.14 1.24
164 164 2014-12-11 35 31 38 33 44 6 64 1880 1879 0.01 0.14 2.41
165 165 2014-12-12 35 32 38 33 44 5 68 1988 1931 0.0 0.13 1.6
172 172 2014-12-19 35 31 38 31 42 -1 58 1884 1931 0.0 0.12 1.58
189 189 2015-1-5 35 21 49 27 38 -4 64 1904 1993 0.0 0.12 1.5
145 145 2014-11-22 36 28 44 40 52 13 72 1880 1931 0.0 0.14 2.03
150 150 2014-11-27 36 34 38 38 50 12 72 1932 1896 0.02 0.13 2.15
152 152 2014-11-29 36 27 45 38 49 15 69 1872 1990 0.0 0.14 2.01
160 160 2014-12-7 36 30 42 35 46 10 75 1926 1998 0.04 0.14 1.98
163 163 2014-12-10 36 32 40 34 45 3 70 1876 1946 0.08 0.14 1.62
204 204 2015-1-20 36 32 40 27 38 0 61 1994 2006 0.0 0.11 1.41
206 206 2015-1-22 36 31 40 27 38 0 61 1888 1959 0.0 0.12 1.7
208 208 2015-1-24 36 33 39 27 38 -6 68 1882 1967 0.72 0.11 2.18
262 262 2015-3-19 36 29 43 36 51 8 76 1967 1918 0.0 0.15 2.19
265 265 2015-3-22 36 28 43 37 52 12 78 1885 2012 0.0 0.15 3.44
267 267 2015-3-24 36 26 45 37 52 12 76 1888 1988 0.0 0.15 2.05
272 272 2015-3-29 36 25 46 39 54 10 86 1923 1945 0.0 0.15 2.03
196 196 2015-1-12 37 35 39 27 38 2 64 1981 1890 0.36 0.13 2.35
202 202 2015-1-18 37 31 42 27 38 0 66 1982 1990 2.1 0.11 2.1
209 209 2015-1-25 37 31 42 27 38 2 60 1945 1967 0.0 0.11 1.8
256 256 2015-3-13 37 31 43 34 49 6 85 1888 1990 0.0 0.12 3.86
138 138 2014-11-15 38 33 42 42 54 20 80 1967 1993 0.0 0.13 2.43
143 143 2014-11-20 38 31 45 40 52 20 77 1873 1985 0.0 0.13 3.37
187 187 2015-1-3 38 33 42 28 39 -4 64 1879 2000 0.71 0.12 2.42
237 237 2015-2-22 38 32 43 30 43 8 69 1963 1997 0.1 0.11 2.39
264 264 2015-3-21 38 29 47 37 51 10 84 1885 1921 0.0 0.15 2.37
137 137 2014-11-14 39 35 42 42 55 20 72 1905 1993 0.06 0.13 2.23
155 155 2014-12-2 39 35 43 37 48 12 66 1875 1970 0.08 0.14 2.16
158 158 2014-12-5 39 34 44 35 47 11 70 1926 2001 0.51 0.14 1.28
162 162 2014-12-9 39 36 42 34 45 7 66 1876 1966 2.54 0.13 2.54
166 166 2014-12-13 39 34 44 33 44 8 64 1960 1923 0.0 0.13 3.03
182 182 2014-12-29 39 34 44 28 39 -6 70 1917 1984 0.0 0.11 2.52
186 186 2015-1-2 39 35 42 28 39 2 68 1918 1876 0.0 0.12 1.92
203 203 2015-1-19 39 36 42 27 38 -3 64 1875 1951 0.0 0.12 2.39
139 139 2014-11-16 40 35 45 42 54 17 72 1933 1928 0.03 0.13 2.39

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
);