U.S. Weather History: KCQT.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

31 rows where record_min_temp = 52

✎ 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_max_temp, record_min_temp_year, record_max_temp_year, actual_precipitation, average_precipitation, record_precipitation

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
1 1 2014-7-1 70 63 77 63 82 52 107 1886 1985 0.0 0.0 0.09
3 3 2014-7-3 72 63 81 63 82 52 100 1902 1985 0.0 0.0 0.0
9 9 2014-7-9 75 67 82 63 83 52 100 1901 1985 0.0 0.0 0.05
11 11 2014-7-11 73 65 80 64 83 52 97 1878 1959 0.0 0.0 0.04
14 14 2014-7-14 74 68 80 64 83 52 98 1908 1984 0.0 0.0 0.24
16 16 2014-7-16 74 66 81 64 83 52 96 1894 1930 0.0 0.01 0.02
17 17 2014-7-17 73 65 80 64 83 52 98 1894 1998 0.0 0.0 0.01
19 19 2014-7-19 71 66 75 64 84 52 97 1884 1960 0.0 0.0 0.02
20 20 2014-7-20 73 66 80 64 84 52 100 1892 1960 0.0 0.0 0.0
22 22 2014-7-22 75 65 85 64 84 52 101 1880 2006 0.0 0.0 0.1
24 24 2014-7-24 79 65 92 64 84 52 103 1882 1891 0.0 0.0 0.0
25 25 2014-7-25 79 69 88 64 84 52 109 1903 1891 0.0 0.0 0.04
26 26 2014-7-26 77 68 86 64 84 52 100 1886 1891 0.0 0.0 0.04
27 27 2014-7-27 76 67 84 64 84 52 102 1903 1972 0.0 0.0 0.0
28 28 2014-7-28 78 68 88 64 84 52 101 1883 1995 0.0 0.0 0.01
31 31 2014-7-31 77 67 87 64 84 52 100 1885 1972 0.0 0.0 0.01
34 34 2014-8-3 79 72 85 64 84 52 100 1913 1918 0.02 0.0 0.02
35 35 2014-8-4 76 65 87 64 84 52 94 1912 1971 0.0 0.0 0.05
36 36 2014-8-5 73 63 82 64 84 52 100 1887 1997 0.0 0.0 0.09
43 43 2014-8-12 75 66 84 64 84 52 104 1894 1994 0.0 0.0 0.32
46 46 2014-8-15 76 63 89 64 84 52 98 1894 1994 0.0 0.0 0.4
47 47 2014-8-16 78 66 90 64 84 52 98 1883 1890 0.0 0.0 0.19
48 48 2014-8-17 78 66 89 64 85 52 104 1887 1885 0.0 0.0 2.06
49 49 2014-8-18 76 65 86 64 85 52 102 1887 1885 0.0 0.0 0.44
53 53 2014-8-22 74 66 81 64 85 52 102 1901 1972 0.0 0.01 0.04
56 56 2014-8-25 72 64 80 64 85 52 102 1909 1985 0.0 0.0 0.01
59 59 2014-8-28 80 68 91 64 85 52 99 1902 1995 0.0 0.01 0.1
62 62 2014-8-31 78 69 87 64 85 52 103 1895 1967 0.0 0.0 0.61
66 66 2014-9-4 73 66 80 64 85 52 110 1892 1988 0.0 0.01 0.3
72 72 2014-9-10 76 64 87 64 84 52 103 1893 1983 0.0 0.0 1.74
363 363 2015-6-28 77 67 86 62 81 52 98 1887 1980 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "us-weather-history/KCQT" (
"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
);