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 record_min_temp_year

✎ 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
83 83 2014-9-21 71 67 75 59 73 40 95 1871 1895 0.15 0.15 5.54
159 159 2014-12-6 45 39 50 35 46 11 71 1871 2001 1.22 0.13 1.6
63 63 2014-9-1 82 75 88 66 80 51 97 1872 1953 0.0 0.13 3.84
152 152 2014-11-29 36 27 45 38 49 15 69 1872 1990 0.0 0.14 2.01
175 175 2014-12-22 40 35 44 30 41 2 71 1872 2013 0.04 0.12 2.18
180 180 2014-12-27 50 44 55 29 40 6 63 1872 1949 0.0 0.12 2.14
248 248 2015-3-5 30 19 40 32 46 3 72 1872 1880 0.76 0.13 1.81
249 249 2015-3-6 20 12 27 32 46 6 68 1872 1935 0.0 0.13 2.63
22 22 2014-7-22 79 71 86 69 84 55 104 1873 2011 0.0 0.14 1.86
136 136 2014-11-13 42 36 48 43 55 22 73 1873 1931 0.2 0.13 2.06
143 143 2014-11-20 38 31 45 40 52 20 77 1873 1985 0.0 0.13 3.37
213 213 2015-1-29 28 19 36 27 39 0 69 1873 2002 0.02 0.11 1.03
214 214 2015-1-30 29 19 38 27 39 2 64 1873 2006 0.06 0.11 1.19
239 239 2015-2-24 14 4 24 30 44 -4 75 1873 1985 0.0 0.12 1.69
360 360 2015-6-25 74 65 83 66 82 50 99 1873 1952 0.0 0.14 1.28
168 168 2014-12-15 43 37 48 32 43 6 67 1874 2008 0.0 0.13 1.34
278 278 2015-4-4 51 42 60 41 57 21 80 1874 1892 0.01 0.16 1.99
279 279 2015-4-5 52 42 61 41 57 20 80 1874 1928 0.0 0.16 2.76
286 286 2015-4-12 55 43 66 44 60 22 90 1874 1977 0.0 0.16 2.12
287 287 2015-4-13 59 50 68 44 60 25 88 1874 1977 0.0 0.16 1.26
303 303 2015-4-29 64 50 78 49 66 32 89 1874 1974 0.0 0.14 0.91
307 307 2015-5-3 66 51 80 50 67 36 90 1874 2001 0.0 0.13 1.66
105 105 2014-10-13 59 52 65 51 65 33 87 1875 1954 0.05 0.14 2.75
126 126 2014-11-3 50 39 61 45 58 28 79 1875 2003 0.0 0.13 2.6
153 153 2014-11-30 50 45 55 37 49 7 70 1875 1991 0.0 0.15 1.11
154 154 2014-12-1 54 42 65 37 48 9 70 1875 2006 0.09 0.14 1.72
155 155 2014-12-2 39 35 43 37 48 12 66 1875 1970 0.08 0.14 2.16
194 194 2015-1-10 20 16 23 27 38 -6 60 1875 1876 0.0 0.12 1.72
203 203 2015-1-19 39 36 42 27 38 -3 64 1875 1951 0.0 0.12 2.39
266 266 2015-3-23 31 23 38 37 52 12 76 1875 1923 0.0 0.16 1.6
291 291 2015-4-17 63 55 71 45 62 28 96 1875 2002 0.08 0.15 1.29
292 292 2015-4-18 70 59 80 46 62 25 96 1875 1976 0.0 0.14 2.19
293 293 2015-4-19 56 48 64 46 63 21 92 1875 1976 0.0 0.15 1.96
295 295 2015-4-21 59 52 65 47 63 26 87 1875 1923 0.2 0.14 2.28
304 304 2015-4-30 58 48 67 49 66 30 91 1875 1942 0.0 0.13 4.97
349 349 2015-6-14 77 66 88 63 79 49 99 1875 1956 0.36 0.16 2.54
104 104 2014-10-12 56 48 63 51 65 35 86 1876 1954 0.0 0.14 4.26
107 107 2014-10-15 73 69 77 50 64 32 84 1876 1956 0.69 0.14 1.7
108 108 2014-10-16 66 61 71 50 64 34 87 1876 1897 1.11 0.14 2.15
162 162 2014-12-9 39 36 42 34 45 7 66 1876 1966 2.54 0.13 2.54
163 163 2014-12-10 36 32 40 34 45 3 70 1876 1946 0.08 0.14 1.62
169 169 2014-12-16 44 38 49 32 43 7 63 1876 1971 0.2 0.12 2.25
268 268 2015-3-25 42 34 49 38 53 13 79 1878 1963 0.05 0.15 4.25
318 318 2015-5-14 62 50 73 53 70 40 88 1878 1900 0.0 0.12 3.38
320 320 2015-5-16 66 57 75 54 71 42 90 1878 1951 0.3 0.13 2.66
41 41 2014-8-10 78 68 88 69 83 55 98 1879 1949 0.0 0.14 4.64
117 117 2014-10-25 59 50 67 47 61 29 79 1879 1963 0.01 0.15 3.3
118 118 2014-10-26 58 53 63 47 61 30 78 1879 1964 0.0 0.13 3.4
127 127 2014-11-4 61 53 68 45 58 25 78 1879 1975 0.0 0.13 1.44
128 128 2014-11-5 60 56 64 45 57 23 78 1879 1961 0.0 0.13 1.94
129 129 2014-11-6 53 48 57 44 57 27 74 1879 1948 0.37 0.14 1.47
144 144 2014-11-21 33 28 37 40 52 16 74 1879 1900 0.0 0.14 1.33
187 187 2015-1-3 38 33 42 28 39 -4 64 1879 2000 0.71 0.12 2.42
47 47 2014-8-16 71 63 78 68 83 55 96 1880 1944 0.0 0.15 4.8
145 145 2014-11-22 36 28 44 40 52 13 72 1880 1931 0.0 0.14 2.03
146 146 2014-11-23 50 43 57 40 51 14 72 1880 1931 0.0 0.14 1.84
147 147 2014-11-24 61 53 69 39 51 14 73 1880 1979 0.7 0.14 1.95
164 164 2014-12-11 35 31 38 33 44 6 64 1880 1879 0.01 0.14 2.41
305 305 2015-5-1 56 49 63 50 67 35 87 1880 2001 0.0 0.12 2.48
97 97 2014-10-5 54 46 61 54 68 35 94 1881 1941 0.0 0.15 1.99
98 98 2014-10-6 60 50 69 53 67 36 90 1881 1941 0.0 0.14 2.39
217 217 2015-2-2 24 14 34 27 39 -3 59 1881 1988 1.02 0.11 2.98
157 157 2014-12-4 41 37 45 36 47 10 74 1882 1998 0.0 0.14 1.84
161 161 2014-12-8 31 24 37 34 45 10 65 1882 1927 0.0 0.14 1.54
208 208 2015-1-24 36 33 39 27 38 -6 68 1882 1967 0.72 0.11 2.18
66 66 2014-9-4 78 69 87 65 79 47 97 1883 1929 0.0 0.14 3.48
71 71 2014-9-9 68 63 73 63 78 48 94 1883 1915 0.0 0.13 0.86
72 72 2014-9-10 72 63 80 63 77 43 97 1883 1983 0.0 0.13 1.38
176 176 2014-12-23 45 43 46 30 41 -1 66 1883 1990 0.16 0.13 1.61
251 251 2015-3-8 43 37 49 33 47 8 76 1883 1987 0.0 0.14 1.78
172 172 2014-12-19 35 31 38 31 42 -1 58 1884 1931 0.0 0.12 1.58
244 244 2015-3-1 28 24 31 31 45 5 73 1884 1972 0.52 0.13 2.95
334 334 2015-5-30 76 67 85 58 75 42 97 1884 1987 0.0 0.15 2.19
58 58 2014-8-27 80 70 90 67 81 50 101 1885 1948 0.0 0.13 4.16
59 59 2014-8-28 74 66 82 66 81 50 100 1885 1948 0.0 0.13 3.99
124 124 2014-11-1 45 42 47 46 59 30 84 1885 1950 0.35 0.14 1.69
263 263 2015-3-20 34 29 38 36 51 11 83 1885 1945 0.4 0.15 1.93
264 264 2015-3-21 38 29 47 37 51 10 84 1885 1921 0.0 0.15 2.37
265 265 2015-3-22 36 28 43 37 52 12 78 1885 2012 0.0 0.15 3.44
35 35 2014-8-4 77 70 84 69 84 56 100 1886 1944 0.0 0.16 3.25
64 64 2014-9-2 85 77 92 65 80 51 102 1886 1953 0.0 0.13 2.12
94 94 2014-10-2 66 61 70 55 69 39 90 1886 1927 0.0 0.14 2.16
109 109 2014-10-17 65 59 71 50 63 33 90 1886 1938 0.0 0.14 2.28
131 131 2014-11-8 42 36 48 44 57 29 76 1886 1975 0.0 0.12 7.4
57 57 2014-8-26 80 70 89 67 81 53 103 1887 1948 0.0 0.12 3.24
87 87 2014-9-25 61 57 64 57 72 40 90 1887 1970 0.32 0.14 2.36
125 125 2014-11-2 45 41 48 45 58 30 83 1887 1950 0.0 0.14 1.7
273 273 2015-3-30 45 36 54 39 55 16 82 1887 1998 0.0 0.16 2.45
13 13 2014-7-13 78 72 83 69 84 54 101 1888 1966 0.03 0.17 3.16
69 69 2014-9-7 73 65 81 64 78 46 101 1888 1881 0.0 0.14 2.07
96 96 2014-10-4 61 52 69 54 68 37 88 1888 1941 1.18 0.13 4.05
102 102 2014-10-10 58 52 64 52 66 35 91 1888 1939 0.0 0.16 2.16
206 206 2015-1-22 36 31 40 27 38 0 61 1888 1959 0.0 0.12 1.7
231 231 2015-2-16 12 3 21 29 42 1 71 1888 1954 0.0 0.12 1.4
255 255 2015-3-12 42 36 47 34 48 8 71 1888 1890 0.0 0.13 2.33
256 256 2015-3-13 37 31 43 34 49 6 85 1888 1990 0.0 0.12 3.86
267 267 2015-3-24 36 26 45 37 52 12 76 1888 1988 0.0 0.15 2.05
43 43 2014-8-12 75 70 79 68 83 55 97 1889 1944 0.19 0.14 3.62
238 238 2015-2-23 23 8 38 30 43 5 70 1889 1985 0.0 0.12 1.38
10 10 2014-7-10 78 72 83 69 84 55 102 1890 1993 0.0 0.15 1.79

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