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

76 rows where average_precipitation = "0.13"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: average_min_temp, actual_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
2 2 2014-7-2 82 72 91 68 83 56 100 2001 1966 0.96 0.13 1.79
4 4 2014-7-4 70 65 74 68 84 55 102 1986 1949 0.14 0.13 1.76
6 6 2014-7-6 75 66 84 68 84 54 103 1979 2010 0.0 0.13 1.97
7 7 2014-7-7 81 72 90 68 84 56 100 1914 2010 0.04 0.13 3.13
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
63 63 2014-9-1 82 75 88 66 80 51 97 1872 1953 0.0 0.13 3.84
64 64 2014-9-2 85 77 92 65 80 51 102 1886 1953 0.0 0.13 2.12
65 65 2014-9-3 79 72 86 65 80 50 99 1893 1929 0.0 0.13 3.32
67 67 2014-9-5 80 72 87 64 79 51 94 1963 1985 0.0 0.13 2.45
68 68 2014-9-6 79 67 91 64 79 48 97 1924 1881 0.11 0.13 3.26
70 70 2014-9-8 70 65 75 64 78 54 93 1955 1919 0.0 0.13 4.86
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
73 73 2014-9-11 76 69 83 63 77 43 99 1917 1983 0.0 0.13 2.9
96 96 2014-10-4 61 52 69 54 68 37 88 1888 1941 1.18 0.13 4.05
118 118 2014-10-26 58 53 63 47 61 30 78 1879 1964 0.0 0.13 3.4
120 120 2014-10-28 63 53 72 47 60 29 83 1976 1919 0.0 0.13 2.49
122 122 2014-10-30 53 47 59 46 59 31 82 1925 1961 0.0 0.13 1.64
126 126 2014-11-3 50 39 61 45 58 28 79 1875 2003 0.0 0.13 2.6
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
130 130 2014-11-7 47 40 53 44 57 29 78 1930 1938 0.0 0.13 2.96
132 132 2014-11-9 52 46 57 44 56 24 75 1976 1975 0.0 0.13 3.65
133 133 2014-11-10 53 44 61 43 56 27 73 1914 1985 0.0 0.13 1.7
136 136 2014-11-13 42 36 48 43 55 22 73 1873 1931 0.2 0.13 2.06
137 137 2014-11-14 39 35 42 42 55 20 72 1905 1993 0.06 0.13 2.23
138 138 2014-11-15 38 33 42 42 54 20 80 1967 1993 0.0 0.13 2.43
139 139 2014-11-16 40 35 45 42 54 17 72 1933 1928 0.03 0.13 2.39
143 143 2014-11-20 38 31 45 40 52 20 77 1873 1985 0.0 0.13 3.37
148 148 2014-11-25 60 51 68 39 50 19 73 1938 1979 0.0 0.13 1.36
150 150 2014-11-27 36 34 38 38 50 12 72 1932 1896 0.02 0.13 2.15
159 159 2014-12-6 45 39 50 35 46 11 71 1871 2001 1.22 0.13 1.6
162 162 2014-12-9 39 36 42 34 45 7 66 1876 1966 2.54 0.13 2.54
165 165 2014-12-12 35 32 38 33 44 5 68 1988 1931 0.0 0.13 1.6
166 166 2014-12-13 39 34 44 33 44 8 64 1960 1923 0.0 0.13 3.03
167 167 2014-12-14 42 38 46 32 43 12 67 1976 1881 0.0 0.13 2.22
168 168 2014-12-15 43 37 48 32 43 6 67 1874 2008 0.0 0.13 1.34
170 170 2014-12-17 48 42 54 32 42 1 62 1919 2000 0.02 0.13 2.28
174 174 2014-12-21 34 31 36 30 41 -1 65 1942 2013 0.0 0.13 2.49
176 176 2014-12-23 45 43 46 30 41 -1 66 1883 1990 0.16 0.13 1.61
177 177 2014-12-24 51 44 58 30 41 6 63 1983 1996 0.8 0.13 1.42
178 178 2014-12-25 53 44 62 29 40 -1 64 1980 1982 0.09 0.13 1.3
190 190 2015-1-6 21 19 22 27 38 -2 72 1896 2007 0.05 0.13 1.65
193 193 2015-1-9 26 19 33 27 38 -1 64 1968 1937 0.07 0.13 1.42
196 196 2015-1-12 37 35 39 27 38 2 64 1981 1890 0.36 0.13 2.35
199 199 2015-1-15 30 25 35 27 38 0 67 1957 1932 0.0 0.13 1.27
244 244 2015-3-1 28 24 31 31 45 5 73 1884 1972 0.52 0.13 2.95
247 247 2015-3-4 40 35 45 32 46 7 70 1943 1974 0.25 0.13 1.65
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
250 250 2015-3-7 28 18 38 33 47 7 74 1890 1946 0.0 0.13 1.87
252 252 2015-3-9 47 40 54 33 47 11 69 1996 2000 0.01 0.13 1.82
253 253 2015-3-10 46 39 53 33 48 12 74 1929 2006 0.46 0.13 1.62
254 254 2015-3-11 52 44 59 34 48 14 73 1960 1977 0.01 0.13 2.94
255 255 2015-3-12 42 36 47 34 48 8 71 1888 1890 0.0 0.13 2.33
304 304 2015-4-30 58 48 67 49 66 30 91 1875 1942 0.0 0.13 4.97
307 307 2015-5-3 66 51 80 50 67 36 90 1874 2001 0.0 0.13 1.66
308 308 2015-5-4 71 57 85 50 68 38 92 1917 2001 0.0 0.13 2.02
309 309 2015-5-5 76 66 85 51 68 34 90 1891 1980 0.0 0.13 1.55
310 310 2015-5-6 66 59 73 51 68 32 92 1891 1986 0.0 0.13 1.46
313 313 2015-5-9 64 57 70 52 69 35 94 1947 1979 0.0 0.13 1.42
314 314 2015-5-10 72 61 83 52 69 36 94 1966 1979 0.0 0.13 2.1
316 316 2015-5-12 75 64 86 53 70 40 93 1907 1881 0.0 0.13 1.84
319 319 2015-5-15 65 55 75 54 71 42 90 1947 1900 0.0 0.13 1.16
320 320 2015-5-16 66 57 75 54 71 42 90 1878 1951 0.3 0.13 2.66
321 321 2015-5-17 74 64 83 54 71 39 92 1956 1974 0.02 0.13 1.05
322 322 2015-5-18 68 60 75 55 71 41 90 1973 1936 0.0 0.13 2.18
323 323 2015-5-19 70 59 80 55 72 38 99 1976 1962 0.0 0.13 2.02
355 355 2015-6-20 70 64 75 65 81 49 98 1914 1923 0.0 0.13 1.39
357 357 2015-6-22 79 70 87 66 81 52 98 1940 1988 0.0 0.13 1.96
358 358 2015-6-23 83 75 90 66 81 49 96 1918 1888 0.02 0.13 1.75
359 359 2015-6-24 76 68 84 66 82 52 96 1932 1888 0.0 0.13 1.46
361 361 2015-6-26 75 69 81 67 82 56 100 1979 1952 0.0 0.13 4.29
363 363 2015-6-28 68 62 73 67 83 54 96 1995 1991 0.29 0.13 1.69
365 365 2015-6-30 75 68 82 67 83 53 99 1919 1964 0.0 0.13 3.07

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