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

365 rows sorted by record_max_temp_year

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
10 2014-7-10 70 55 84 55 75 46 90 1960 1945 0.0 0.03 0.38
343 2015-6-8 73 58 87 51 69 42 87 2002 1948 0.0 0.07 0.81
32 2014-8-1 72 59 84 57 77 50 92 1954 1949 0.0 0.02 0.52
123 2014-10-31 51 47 55 43 55 30 71 2003 1949 0.67 0.17 1.04
127 2014-11-4 55 51 58 42 54 30 74 1957 1949 0.16 0.2 1.91
148 2014-11-25 53 49 57 38 49 18 59 1985 1949 0.72 0.22 3.04
149 2014-11-26 57 54 59 38 48 25 61 1952 1949 0.01 0.22 1.34
182 2014-12-29 38 33 43 36 45 8 54 1968 1949 0.0 0.16 1.92
239 2015-2-24 44 36 52 37 51 24 62 2011 1949 0.0 0.12 1.55
176 2014-12-23 48 41 54 35 45 9 58 1983 1950 0.81 0.17 1.14
293 2015-4-19 59 47 70 42 59 33 74 1961 1950 0.0 0.09 1.85
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
262 2015-3-19 54 47 60 40 54 27 63 1965 1951 0.0 0.11 1.27
83 2014-9-21 67 55 79 51 69 39 88 1955 1952 0.0 0.05 0.94
98 2014-10-6 67 56 78 48 63 37 78 1955 1952 0.0 0.08 2.72
131 2014-11-8 47 39 55 42 53 27 64 1948 1952 0.0 0.22 0.85
166 2014-12-13 45 39 50 35 46 19 59 1972 1952 0.0 0.17 1.63
211 2015-1-27 50 47 52 37 48 11 58 1957 1952 0.03 0.16 1.61
135 2014-11-12 38 32 44 41 52 13 60 1955 1953 0.0 0.23 1.52
192 2015-1-8 41 35 46 37 46 18 54 1949 1953 0.0 0.2 1.13
309 2015-5-5 52 45 58 45 63 36 86 1965 1953 0.24 0.07 0.59
144 2014-11-21 50 47 52 39 50 21 62 1977 1954 0.6 0.23 1.26
145 2014-11-22 47 44 49 39 49 14 58 1985 1954 0.02 0.22 1.76
158 2014-12-5 50 44 55 36 47 23 55 1956 1954 0.12 0.19 1.67
344 2015-6-9 71 58 84 51 69 44 96 1971 1955 0.0 0.06 0.72
53 2014-8-22 66 56 75 56 76 45 86 1960 1956 0.0 0.03 1.41
334 2015-5-30 62 50 73 50 67 36 87 1951 1956 0.0 0.07 1.06
85 2014-9-23 62 58 66 51 68 40 83 1948 1957 0.72 0.05 0.72
161 2014-12-8 53 48 58 36 46 13 59 1972 1957 0.36 0.18 1.61
5 2014-7-5 66 56 76 55 74 47 91 1951 1958 0.0 0.03 0.64
15 2014-7-15 73 57 88 56 76 49 92 1982 1958 0.0 0.02 0.11
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
154 2014-12-1 33 26 40 37 47 20 57 1985 1958 0.0 0.2 1.52
155 2014-12-2 34 26 42 37 47 25 57 1985 1958 0.0 0.2 1.75
171 2014-12-18 47 44 49 35 45 18 54 1964 1958 0.51 0.16 1.23
183 2014-12-30 33 28 38 36 45 6 56 1968 1958 0.0 0.16 1.06
322 2015-5-18 66 54 78 48 65 37 89 1950 1958 0.0 0.06 0.72
31 2014-7-31 76 64 87 57 77 47 93 1954 1959 0.0 0.02 0.26
146 2014-11-23 49 42 55 38 49 10 58 1985 1959 0.47 0.22 2.49
283 2015-4-9 53 43 63 41 57 34 73 1982 1959 0.0 0.1 0.96
316 2015-5-12 56 51 60 47 64 38 81 1964 1959 0.17 0.06 0.71
6 2014-7-6 72 59 84 55 74 45 94 1949 1960 0.0 0.03 0.44
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
128 2014-11-5 55 51 59 42 53 31 65 2003 1960 0.19 0.2 1.01
165 2014-12-12 49 45 52 35 46 22 60 1972 1960 0.0 0.16 2.19
215 2015-1-31 42 38 45 37 49 0 61 1950 1960 0.0 0.16 1.93
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
74 2014-9-12 66 55 76 53 72 44 85 1949 1961 0.0 0.04 0.6
105 2014-10-13 60 50 70 46 61 35 75 1954 1961 0.3 0.1 0.66
106 2014-10-14 58 53 62 46 60 36 80 1949 1961 0.28 0.11 0.77
351 2015-6-16 63 52 73 52 70 42 88 1954 1961 0.0 0.06 0.52
120 2014-10-28 54 49 59 44 56 30 66 1971 1962 0.5 0.16 1.53
216 2015-2-1 45 40 49 37 49 1 63 1950 1962 0.06 0.13 1.34
217 2015-2-2 47 41 52 37 49 8 64 1950 1962 0.29 0.13 1.32
292 2015-4-18 57 47 66 42 59 34 77 1950 1962 0.0 0.09 0.4
66 2014-9-4 64 52 75 54 74 42 87 1952 1963 0.0 0.05 0.66
71 2014-9-9 64 56 71 53 73 40 89 1952 1963 0.0 0.04 0.61
184 2014-12-31 33 27 38 36 46 13 56 1968 1963 0.0 0.16 1.3
222 2015-2-7 52 49 54 37 49 20 66 1989 1963 0.93 0.14 2.58
223 2015-2-8 53 47 59 37 49 22 68 1994 1963 0.14 0.13 3.06
225 2015-2-10 51 47 55 37 49 24 65 1982 1963 0.01 0.13 0.96
226 2015-2-11 49 42 55 37 50 23 62 1948 1963 0.0 0.13 0.81
227 2015-2-12 56 49 62 37 50 21 66 1949 1963 0.04 0.12 1.23
323 2015-5-19 62 53 71 48 65 38 88 1975 1963 0.0 0.06 0.7
324 2015-5-20 63 51 74 48 66 40 92 1960 1963 0.0 0.06 0.56
325 2015-5-21 66 53 78 48 66 39 93 1960 1963 0.0 0.06 0.55
350 2015-6-15 74 61 86 52 70 43 88 1949 1963 0.0 0.05 0.37
335 2015-5-31 65 53 77 50 67 35 90 1953 1964 0.0 0.06 0.97
113 2014-10-21 57 53 61 45 58 32 72 1949 1965 0.04 0.13 1.29
114 2014-10-22 57 53 60 45 57 34 70 1950 1965 1.26 0.12 1.26
115 2014-10-23 53 47 58 45 57 32 73 1953 1965 0.37 0.14 1.24
116 2014-10-24 53 48 58 44 57 33 72 1954 1965 0.16 0.14 1.1
117 2014-10-25 55 47 62 44 57 31 67 1954 1965 0.24 0.14 1.16
139 2014-11-16 39 28 49 40 51 21 68 1955 1965 0.0 0.23 1.08
141 2014-11-18 38 31 45 40 50 29 59 2000 1965 0.0 0.23 2.06
156 2014-12-3 41 32 50 36 47 27 60 1994 1965 0.0 0.2 3.77
159 2014-12-6 50 46 53 36 46 19 57 1956 1965 0.29 0.18 1.39
246 2015-3-3 42 32 51 38 52 20 69 1989 1965 0.0 0.12 2.08
247 2015-3-4 43 31 55 38 52 11 68 1955 1965 0.0 0.13 0.92
248 2015-3-5 47 37 56 38 52 13 66 1955 1965 0.0 0.13 2.7
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
96 2014-10-4 63 54 71 48 64 38 76 1957 1966 0.0 0.07 0.92
237 2015-2-22 46 38 53 37 51 30 64 2005 1966 0.0 0.12 0.71
278 2015-4-4 47 39 55 41 57 31 75 1948 1966 0.0 0.11 2.64
279 2015-4-5 50 37 62 41 57 29 73 1975 1966 0.0 0.1 0.79
306 2015-5-2 56 46 65 45 62 33 74 1952 1966 0.0 0.06 0.47
47 2014-8-16 69 60 78 56 77 50 98 1986 1967 0.0 0.03 0.41
50 2014-8-19 71 60 81 56 76 48 88 1959 1967 0.0 0.03 0.88
59 2014-8-28 66 58 74 55 75 46 95 1952 1967 0.0 0.03 0.47
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
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
122 2014-10-30 56 52 60 43 55 30 66 1991 1967 1.0 0.17 1.36
119 2014-10-27 52 44 60 44 56 31 67 1970 1968 0.03 0.15 1.23

Next page

Advanced export

JSON shape: default, array, newline-delimited

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 662.331ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub