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

44 rows where average_precipitation = "0.16"

✎ 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_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
14 14 2014-7-14 78 72 84 69 84 58 100 1926 1954 0.46 0.16 1.6
16 16 2014-7-16 75 68 81 69 84 56 99 1946 1980 0.0 0.16 1.38
19 19 2014-7-19 72 68 76 69 84 57 102 1924 1977 0.0 0.16 1.82
26 26 2014-7-26 75 69 81 69 84 55 98 1920 1940 0.0 0.16 3.8
27 27 2014-7-27 78 71 85 69 84 55 98 1920 1963 0.02 0.16 2.65
32 32 2014-8-1 78 71 84 69 84 59 100 1964 1933 0.0 0.16 2.85
33 33 2014-8-2 69 63 74 69 84 58 100 1924 1955 0.41 0.16 2.49
35 35 2014-8-4 77 70 84 69 84 56 100 1886 1944 0.0 0.16 3.25
36 36 2014-8-5 81 71 90 69 84 56 101 1951 1944 0.0 0.16 1.44
37 37 2014-8-6 77 70 83 69 84 57 97 1994 1955 0.0 0.16 3.31
90 90 2014-9-28 74 64 84 56 70 41 88 1947 1881 0.0 0.16 3.84
91 91 2014-9-29 73 67 79 56 70 42 88 1942 1945 0.0 0.16 2.18
92 92 2014-9-30 67 62 71 55 70 39 89 1912 1986 0.0 0.16 2.64
102 102 2014-10-10 58 52 64 52 66 35 91 1888 1939 0.0 0.16 2.16
266 266 2015-3-23 31 23 38 37 52 12 76 1875 1923 0.0 0.16 1.6
270 270 2015-3-27 43 39 46 38 54 20 83 1894 1998 0.27 0.16 1.79
273 273 2015-3-30 45 36 54 39 55 16 82 1887 1998 0.0 0.16 2.45
275 275 2015-4-1 42 32 51 40 56 12 83 1923 1917 0.0 0.16 1.89
276 276 2015-4-2 54 41 67 40 56 22 81 1919 1967 0.0 0.16 1.93
277 277 2015-4-3 62 59 64 41 56 24 81 1954 1981 0.04 0.16 1.9
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
281 281 2015-4-7 52 42 62 42 58 21 92 1982 2010 0.15 0.16 1.35
283 283 2015-4-9 40 37 43 43 59 25 86 1977 1991 0.0 0.16 3.42
285 285 2015-4-11 51 44 57 43 60 24 84 1909 1955 0.0 0.16 1.1
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
288 288 2015-4-14 60 55 65 44 61 26 85 1950 1941 0.01 0.16 2.72
333 333 2015-5-29 75 65 85 58 74 43 97 1902 1969 0.0 0.16 3.99
336 336 2015-6-1 55 51 58 59 75 44 96 1945 1895 0.72 0.16 2.6
337 337 2015-6-2 53 50 55 59 76 48 96 1946 1895 0.37 0.16 2.79
338 338 2015-6-3 61 52 70 60 76 45 95 1929 1895 0.0 0.16 3.01
339 339 2015-6-4 60 54 65 60 76 48 99 1926 1925 0.0 0.16 2.75
340 340 2015-6-5 63 55 70 60 76 47 99 1945 1925 0.13 0.16 2.8
341 341 2015-6-6 68 60 76 61 77 47 98 1945 1925 0.19 0.16 2.62
342 342 2015-6-7 65 55 74 61 77 47 96 1897 1925 0.0 0.16 4.16
343 343 2015-6-8 71 63 79 61 77 47 95 1932 1933 0.06 0.16 1.47
344 344 2015-6-9 76 68 83 62 78 47 97 1980 1933 0.01 0.16 2.55
345 345 2015-6-10 74 65 82 62 78 49 96 1972 2008 0.0 0.16 2.07
346 346 2015-6-11 81 72 89 62 78 46 95 1972 1973 0.0 0.16 1.14
347 347 2015-6-12 81 73 88 63 78 48 93 1979 1973 0.0 0.16 2.18
348 348 2015-6-13 79 72 86 63 79 51 96 1953 1961 0.0 0.16 1.71
349 349 2015-6-14 77 66 88 63 79 49 99 1875 1956 0.36 0.16 2.54
352 352 2015-6-17 74 66 82 64 80 51 96 1926 1957 0.0 0.16 1.82

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