home / fivethirtyeight

U.S. Weather History: KSEA.csv

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 Downloades 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

365 rows

View and edit SQL

Suggested facets: average_min_temp, average_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 2014-7-1 77 60 94 54 73 45 94 1948 2014 0.0 0.03 0.75
2 2014-7-2 70 58 81 54 73 43 93 1954 2015 0.0 0.03 0.5
3 2014-7-3 64 57 71 54 74 44 92 1954 2015 0.0 0.03 0.47
4 2014-7-4 66 57 75 54 74 43 92 1949 2015 0.0 0.03 0.57
5 2014-7-5 66 56 76 55 74 47 91 1951 1958 0.0 0.03 0.64
6 2014-7-6 72 59 84 55 74 45 94 1949 1960 0.0 0.03 0.44
7 2014-7-7 73 64 81 55 74 47 90 1955 2010 0.0 0.03 0.58
8 2014-7-8 73 60 86 55 75 47 95 1950 2010 0.0 0.03 0.8
9 2014-7-9 69 57 80 55 75 48 93 1960 2010 0.0 0.02 0.81
10 2014-7-10 70 55 84 55 75 46 90 1960 1945 0.0 0.03 0.38
11 2014-7-11 74 59 88 55 75 49 98 1960 2007 0.0 0.03 0.25
12 2014-7-12 76 62 90 55 75 47 97 1954 1961 0.0 0.02 0.64
13 2014-7-13 72 59 85 56 76 50 93 2010 1961 0.0 0.02 0.85
14 2014-7-14 71 59 82 56 76 50 91 1982 1996 0.0 0.03 0.74
15 2014-7-15 73 57 88 56 76 49 92 1982 1958 0.0 0.02 0.11
16 2014-7-16 73 58 88 56 76 50 98 1968 1979 0.0 0.02 0.65
17 2014-7-17 69 57 80 56 76 48 96 1950 1979 0.0 0.02 0.35
18 2014-7-18 64 53 75 56 76 47 93 1952 1995 0.0 0.02 0.29
19 2014-7-19 69 59 78 56 77 48 95 1962 1988 0.0 0.02 0.45
20 2014-7-20 63 58 67 56 77 50 100 1953 1994 0.0 0.02 0.6
21 2014-7-21 66 56 75 56 77 48 97 1951 2006 0.0 0.01 0.29
22 2014-7-22 63 56 70 56 77 49 96 1973 2006 0.01 0.02 0.33
23 2014-7-23 61 56 66 56 77 47 99 1955 1991 0.76 0.02 0.76
24 2014-7-24 62 55 69 56 77 43 95 1953 2004 0.0 0.02 0.28
25 2014-7-25 64 54 73 56 77 47 94 1954 1988 0.0 0.02 0.4
26 2014-7-26 68 56 79 56 77 49 92 1952 1971 0.0 0.02 0.73
27 2014-7-27 71 59 83 57 77 46 95 1956 1958 0.0 0.01 0.3
28 2014-7-28 73 59 87 57 77 47 97 1953 1958 0.0 0.02 0.22
29 2014-7-29 73 60 86 57 77 45 103 1954 2009 0.0 0.02 0.17
30 2014-7-30 72 58 85 57 77 48 96 1951 2009 0.0 0.01 0.39
31 2014-7-31 76 64 87 57 77 47 93 1954 1959 0.0 0.02 0.26
32 2014-8-1 72 59 84 57 77 50 92 1954 1949 0.0 0.02 0.52
33 2014-8-2 73 60 85 57 77 46 89 1953 1977 0.02 0.02 0.76
34 2014-8-3 74 58 89 57 77 46 90 1956 1988 0.0 0.01 0.47
35 2014-8-4 76 61 91 57 77 44 95 1950 1993 0.0 0.02 0.61
36 2014-8-5 67 57 77 57 77 49 93 1950 2012 0.0 0.02 0.36
37 2014-8-6 69 59 79 57 77 50 91 1974 1972 0.0 0.02 0.57
38 2014-8-7 67 56 78 56 77 48 95 1948 1972 0.0 0.02 0.95
39 2014-8-8 67 56 78 56 77 47 98 1974 1960 0.0 0.02 0.13
40 2014-8-9 71 60 81 56 77 47 99 1950 1960 0.0 0.03 0.61
41 2014-8-10 72 57 87 56 77 46 98 1954 1981 0.0 0.02 0.28
42 2014-8-11 80 64 96 56 77 46 96 1954 2014 0.02 0.03 0.32
43 2014-8-12 72 63 81 56 77 49 96 1949 1977 0.5 0.02 0.56
44 2014-8-13 67 59 74 56 77 44 92 1955 2002 0.85 0.03 0.85
45 2014-8-14 67 63 70 56 77 44 95 1955 2010 0.0 0.03 1.6
46 2014-8-15 69 62 76 56 77 47 96 1955 2010 0.04 0.03 1.2
47 2014-8-16 69 60 78 56 77 50 98 1986 1967 0.0 0.03 0.41
48 2014-8-17 71 59 82 56 76 45 96 1951 1977 0.0 0.03 0.93
49 2014-8-18 73 60 85 56 76 47 88 1951 1991 0.0 0.03 1.63
50 2014-8-19 71 60 81 56 76 48 88 1959 1967 0.0 0.03 0.88
51 2014-8-20 64 57 71 56 76 47 87 1952 1966 0.0 0.03 0.7
52 2014-8-21 61 52 70 56 76 46 88 1973 1966 0.0 0.03 0.7
53 2014-8-22 66 56 75 56 76 45 86 1960 1956 0.0 0.03 1.41
54 2014-8-23 70 57 82 56 76 46 91 1955 1988 0.0 0.04 1.49
55 2014-8-24 67 56 77 55 76 45 88 1951 1982 0.0 0.03 1.0
56 2014-8-25 71 58 84 55 75 45 87 1954 1982 0.0 0.03 0.59
57 2014-8-26 74 60 88 55 75 46 91 1957 1986 0.0 0.04 0.67
58 2014-8-27 73 61 84 55 75 44 88 1952 1986 0.0 0.04 0.76
59 2014-8-28 66 58 74 55 75 46 95 1952 1967 0.0 0.03 0.47
60 2014-8-29 66 59 73 55 75 44 91 1951 1974 0.0 0.04 0.87
61 2014-8-30 62 59 64 55 75 45 88 1950 1987 0.33 0.04 0.37
62 2014-8-31 64 57 70 55 74 46 92 1950 1987 0.05 0.04 0.56
63 2014-9-1 65 55 74 55 74 46 91 1973 1987 0.0 0.04 0.55
64 2014-9-2 63 57 68 55 74 41 98 1960 1988 0.12 0.03 0.71
65 2014-9-3 62 55 69 54 74 45 92 1956 1988 0.0 0.04 0.46
66 2014-9-4 64 52 75 54 74 42 87 1952 1963 0.0 0.05 0.66
67 2014-9-5 70 57 82 54 74 44 88 1950 1973 0.0 0.04 1.09
68 2014-9-6 75 59 90 54 73 45 90 1948 2014 0.0 0.04 0.93
69 2014-9-7 70 56 83 54 73 45 94 1960 1981 0.0 0.04 0.26
70 2014-9-8 63 56 70 54 73 43 85 1950 1993 0.0 0.05 0.6
71 2014-9-9 64 56 71 53 73 40 89 1952 1963 0.0 0.04 0.61
72 2014-9-10 63 54 72 53 72 39 85 1952 2007 0.0 0.04 0.64
73 2014-9-11 66 55 76 53 72 40 93 1952 2013 0.0 0.05 0.58
74 2014-9-12 66 55 76 53 72 44 85 1949 1961 0.0 0.04 0.6
75 2014-9-13 67 50 83 53 72 39 87 1952 1999 0.0 0.05 0.51
76 2014-9-14 70 53 86 53 71 46 93 1955 1979 0.0 0.04 0.73
77 2014-9-15 71 54 87 52 71 42 93 1952 1967 0.0 0.05 0.69
78 2014-9-16 65 57 72 52 71 44 91 1952 1967 0.0 0.05 0.76
79 2014-9-17 66 58 73 52 70 42 85 1965 1991 0.02 0.04 1.49
80 2014-9-18 63 59 67 52 70 41 85 1955 1991 0.01 0.05 0.78
81 2014-9-19 68 61 75 52 70 40 82 1957 1999 0.0 0.05 0.79
82 2014-9-20 67 58 76 51 69 40 88 1949 1974 0.0 0.06 1.05
83 2014-9-21 67 55 79 51 69 39 88 1955 1952 0.0 0.05 0.94
84 2014-9-22 66 59 72 51 69 37 92 1955 1990 0.01 0.06 1.65
85 2014-9-23 62 58 66 51 68 40 83 1948 1957 0.72 0.05 0.72
86 2014-9-24 62 58 66 50 68 38 89 1948 1974 0.8 0.06 0.99
87 2014-9-25 65 58 71 50 68 36 85 1972 1991 0.17 0.06 0.63
88 2014-9-26 63 57 68 50 67 39 78 1972 1967 0.35 0.07 1.51
89 2014-9-27 61 53 69 50 67 35 89 1972 1967 0.0 0.06 1.04
90 2014-9-28 60 54 66 50 67 38 84 1950 2003 0.0 0.07 1.71
91 2014-9-29 57 52 62 49 66 37 81 1954 1992 0.03 0.06 0.92
92 2014-9-30 61 54 67 49 66 36 82 1950 1992 0.0 0.07 1.65
93 2014-10-1 59 52 65 49 65 35 89 1950 1987 0.0 0.07 0.56
94 2014-10-2 59 50 67 49 65 35 79 1950 1993 0.0 0.07 0.8
95 2014-10-3 60 48 72 48 65 39 80 1949 1993 0.0 0.07 0.67
96 2014-10-4 63 54 71 48 64 38 76 1957 1966 0.0 0.07 0.92
97 2014-10-5 64 53 75 48 64 38 82 1974 1980 0.0 0.08 1.26
98 2014-10-6 67 56 78 48 63 37 78 1955 1952 0.0 0.08 2.72
99 2014-10-7 62 57 66 48 63 37 75 1983 1951 0.0 0.09 0.71
100 2014-10-8 62 55 69 47 63 39 80 1949 1951 0.0 0.08 1.16

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "us-weather-history/KSEA" (
"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
)
Powered by Datasette · Query took 25.456ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub