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

86 rows where average_precipitation = "0.14"

✎ 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
8 8 2014-7-8 81 71 91 69 84 56 100 1894 1993 0.39 0.14 1.8
9 9 2014-7-9 80 71 88 69 84 54 106 1963 1936 0.09 0.14 1.09
22 22 2014-7-22 79 71 86 69 84 55 104 1873 2011 0.0 0.14 1.86
41 41 2014-8-10 78 68 88 69 83 55 98 1879 1949 0.0 0.14 4.64
42 42 2014-8-11 79 71 87 69 83 56 102 1962 1944 0.0 0.14 2.39
43 43 2014-8-12 75 70 79 68 83 55 97 1889 1944 0.19 0.14 3.62
44 44 2014-8-13 75 68 82 68 83 55 99 1930 2005 0.53 0.14 2.7
46 46 2014-8-15 67 61 73 68 83 54 97 1964 1988 0.0 0.14 1.52
48 48 2014-8-17 74 66 82 68 83 56 95 1979 1944 0.01 0.14 2.86
49 49 2014-8-18 72 63 81 68 83 55 94 1915 2002 0.0 0.14 3.95
51 51 2014-8-20 77 70 84 68 82 55 97 1949 1955 0.0 0.14 3.63
53 53 2014-8-22 72 65 79 67 82 52 95 1895 1916 0.06 0.14 1.85
54 54 2014-8-23 72 67 77 67 82 51 92 1923 1916 0.01 0.14 3.03
55 55 2014-8-24 72 64 80 67 82 52 94 1890 1972 0.0 0.14 3.61
56 56 2014-8-25 76 64 88 67 82 52 95 1940 1948 0.0 0.14 1.86
66 66 2014-9-4 78 69 87 65 79 47 97 1883 1929 0.0 0.14 3.48
69 69 2014-9-7 73 65 81 64 78 46 101 1888 1881 0.0 0.14 2.07
74 74 2014-9-12 70 62 78 62 77 46 94 1917 1961 0.0 0.14 2.35
75 75 2014-9-13 64 58 69 62 76 46 94 1963 1952 0.26 0.14 3.94
76 76 2014-9-14 62 53 71 62 76 46 93 1975 1931 0.0 0.14 3.82
85 85 2014-9-23 62 52 71 58 73 41 97 1947 1895 0.0 0.14 8.28
87 87 2014-9-25 61 57 64 57 72 40 90 1887 1970 0.32 0.14 2.36
94 94 2014-10-2 66 61 70 55 69 39 90 1886 1927 0.0 0.14 2.16
95 95 2014-10-3 64 56 71 54 68 38 87 1974 1919 0.0 0.14 1.55
98 98 2014-10-6 60 50 69 53 67 36 90 1881 1941 0.0 0.14 2.39
100 100 2014-10-8 68 62 73 52 67 37 87 1988 2007 0.04 0.14 4.3
104 104 2014-10-12 56 48 63 51 65 35 86 1876 1954 0.0 0.14 4.26
105 105 2014-10-13 59 52 65 51 65 33 87 1875 1954 0.05 0.14 2.75
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
109 109 2014-10-17 65 59 71 50 63 33 90 1886 1938 0.0 0.14 2.28
110 110 2014-10-18 63 56 70 49 63 35 82 1974 1928 0.0 0.14 2.45
111 111 2014-10-19 50 44 56 49 63 30 83 1940 1963 0.0 0.14 4.35
112 112 2014-10-20 51 42 60 49 62 31 80 1974 1969 0.0 0.14 2.78
113 113 2014-10-21 61 55 67 48 62 32 84 1974 1920 0.11 0.14 2.17
115 115 2014-10-23 52 50 53 48 61 32 85 1969 1947 0.61 0.14 2.97
116 116 2014-10-24 57 51 63 48 61 31 79 1969 2001 0.0 0.14 2.51
119 119 2014-10-27 56 48 63 47 60 28 82 1936 1963 0.0 0.14 1.88
121 121 2014-10-29 62 51 72 46 60 31 78 1925 1971 0.0 0.14 3.67
123 123 2014-10-31 50 45 55 46 59 29 81 1925 1946 0.05 0.14 2.41
124 124 2014-11-1 45 42 47 46 59 30 84 1885 1950 0.35 0.14 1.69
125 125 2014-11-2 45 41 48 45 58 30 83 1887 1950 0.0 0.14 1.7
129 129 2014-11-6 53 48 57 44 57 27 74 1879 1948 0.37 0.14 1.47
140 140 2014-11-17 46 40 52 41 53 19 71 1933 1953 1.54 0.14 1.54
141 141 2014-11-18 35 24 45 41 53 18 73 1936 1928 0.0 0.14 1.24
142 142 2014-11-19 29 22 36 41 53 18 72 1936 1921 0.0 0.14 1.95
144 144 2014-11-21 33 28 37 40 52 16 74 1879 1900 0.0 0.14 1.33
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
149 149 2014-11-26 43 34 51 39 50 16 67 1938 1946 1.24 0.14 1.91
151 151 2014-11-28 33 29 37 38 49 15 70 1930 2011 0.0 0.14 2.14
152 152 2014-11-29 36 27 45 38 49 15 69 1872 1990 0.0 0.14 2.01
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
157 157 2014-12-4 41 37 45 36 47 10 74 1882 1998 0.0 0.14 1.84
158 158 2014-12-5 39 34 44 35 47 11 70 1926 2001 0.51 0.14 1.28
160 160 2014-12-7 36 30 42 35 46 10 75 1926 1998 0.04 0.14 1.98
161 161 2014-12-8 31 24 37 34 45 10 65 1882 1927 0.0 0.14 1.54
163 163 2014-12-10 36 32 40 34 45 3 70 1876 1946 0.08 0.14 1.62
164 164 2014-12-11 35 31 38 33 44 6 64 1880 1879 0.01 0.14 2.41
251 251 2015-3-8 43 37 49 33 47 8 76 1883 1987 0.0 0.14 1.78
257 257 2015-3-14 46 40 51 35 49 15 75 1896 1946 0.81 0.14 1.02
258 258 2015-3-15 40 36 44 35 49 14 77 1993 1990 0.0 0.14 1.81
259 259 2015-3-16 44 35 52 35 50 13 82 1911 1990 0.0 0.14 2.03
261 261 2015-3-18 34 29 39 36 50 7 77 1916 1989 0.0 0.14 3.1
290 290 2015-4-16 58 52 64 45 62 29 92 1928 2002 0.0 0.14 3.29
292 292 2015-4-18 70 59 80 46 62 25 96 1875 1976 0.0 0.14 2.19
294 294 2015-4-20 52 46 57 46 63 24 90 1897 1927 1.37 0.14 1.96
295 295 2015-4-21 59 52 65 47 63 26 87 1875 1923 0.2 0.14 2.28
296 296 2015-4-22 59 48 69 47 64 33 86 1947 2001 0.05 0.14 2.45
297 297 2015-4-23 47 41 52 47 64 32 86 1930 2007 0.0 0.14 2.34
298 298 2015-4-24 46 39 52 48 64 31 87 1930 2001 0.0 0.14 2.17
299 299 2015-4-25 50 38 62 48 65 29 91 1919 1915 0.0 0.14 1.68
300 300 2015-4-26 55 46 64 48 65 31 92 1919 2009 0.0 0.14 1.88
301 301 2015-4-27 56 49 62 48 65 36 92 1932 1915 0.0 0.14 2.04
303 303 2015-4-29 64 50 78 49 66 32 89 1874 1974 0.0 0.14 0.91
311 311 2015-5-7 68 56 80 51 68 37 93 1891 2000 0.0 0.14 3.82
324 324 2015-5-20 61 54 67 55 72 43 96 2002 1996 0.0 0.14 2.03
325 325 2015-5-21 57 52 62 55 72 40 93 1907 1996 0.0 0.14 1.94
331 331 2015-5-27 78 70 85 57 74 41 96 1961 1880 0.08 0.14 2.62
332 332 2015-5-28 78 70 85 58 74 43 94 1961 1959 0.0 0.14 1.16
353 353 2015-6-18 68 64 71 65 80 48 95 1950 1929 0.0 0.14 2.3
354 354 2015-6-19 78 68 87 65 80 52 98 1920 1994 0.0 0.14 2.16
356 356 2015-6-21 80 71 88 65 81 49 97 1897 1988 0.64 0.14 1.7
360 360 2015-6-25 74 65 83 66 82 50 99 1873 1952 0.0 0.14 1.28

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