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

30 rows where average_precipitation = "0.11"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: 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, 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
182 182 2014-12-29 39 34 44 28 39 -6 70 1917 1984 0.0 0.11 2.52
184 184 2014-12-31 30 27 32 28 39 -7 63 1917 1965 0.0 0.11 2.31
192 192 2015-1-8 15 8 21 27 38 2 65 1968 1998 0.0 0.11 1.25
202 202 2015-1-18 37 31 42 27 38 0 66 1982 1990 2.1 0.11 2.1
204 204 2015-1-20 36 32 40 27 38 0 61 1994 2006 0.0 0.11 1.41
207 207 2015-1-23 34 28 39 27 38 -3 62 1936 1906 0.0 0.11 2.55
208 208 2015-1-24 36 33 39 27 38 -6 68 1882 1967 0.72 0.11 2.18
209 209 2015-1-25 37 31 42 27 38 2 60 1945 1967 0.0 0.11 1.8
210 210 2015-1-26 27 22 31 27 39 3 72 1927 1950 0.48 0.11 2.19
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
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
216 216 2015-2-1 28 20 36 27 39 -2 67 1920 1989 0.03 0.11 2.12
217 217 2015-2-2 24 14 34 27 39 -3 59 1881 1988 1.02 0.11 2.98
218 218 2015-2-3 20 13 26 27 39 0 64 1955 1991 0.0 0.11 1.55
220 220 2015-2-5 28 14 42 28 40 -6 70 1918 1991 0.0 0.11 1.43
221 221 2015-2-6 20 12 27 28 40 -4 68 1895 2008 0.0 0.11 2.74
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
227 227 2015-2-12 28 16 40 28 41 -3 62 1914 1999 0.0 0.11 1.66
229 229 2015-2-14 24 16 32 29 41 2 63 1916 1946 0.02 0.11 1.59
232 232 2015-2-17 21 14 27 29 42 -5 67 1896 1976 0.14 0.11 1.49
233 233 2015-2-18 26 19 33 29 42 0 68 1979 1981 0.0 0.11 1.5
234 234 2015-2-19 18 8 27 30 42 1 66 1936 1997 0.0 0.11 2.15
235 235 2015-2-20 11 2 19 30 43 2 69 2015 1939 0.0 0.11 3.07
236 236 2015-2-21 23 13 32 30 43 4 68 1896 1930 0.61 0.11 1.86
237 237 2015-2-22 38 32 43 30 43 8 69 1963 1997 0.1 0.11 2.39
240 240 2015-2-25 29 20 37 31 44 1 75 1914 1930 0.0 0.11 2.11

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