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 actual_min_temp

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
153 2014-11-30 30 23 37 37 48 21 59 1985 2012 0.0 0.22 1.5
152 2014-11-29 32 24 40 37 48 18 59 2006 1999 0.14 0.23 1.08
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
185 2015-1-1 34 26 42 36 46 10 58 1952 2006 0.0 0.18 1.37
184 2014-12-31 33 27 38 36 46 13 56 1968 1963 0.0 0.16 1.3
137 2014-11-14 37 28 45 40 51 9 65 1955 1995 0.0 0.23 2.61
139 2014-11-16 39 28 49 40 51 21 68 1955 1965 0.0 0.23 1.08
140 2014-11-17 40 28 51 40 51 23 61 1955 1995 0.0 0.23 1.06
183 2014-12-30 33 28 38 36 45 6 56 1968 1958 0.0 0.16 1.06
138 2014-11-15 38 29 47 40 51 6 62 1955 2001 0.0 0.23 1.09
141 2014-11-18 38 31 45 40 50 29 59 2000 1965 0.0 0.23 2.06
205 2015-1-21 38 31 45 37 48 13 62 1962 1981 0.0 0.17 1.64
247 2015-3-4 43 31 55 38 52 11 68 1955 1965 0.0 0.13 0.92
135 2014-11-12 38 32 44 41 52 13 60 1955 1953 0.0 0.23 1.52
156 2014-12-3 41 32 50 36 47 27 60 1994 1965 0.0 0.2 3.77
186 2015-1-2 37 32 42 36 46 6 56 1950 2003 0.06 0.18 1.77
246 2015-3-3 42 32 51 38 52 20 69 1989 1965 0.0 0.12 2.08
136 2014-11-13 39 33 45 41 51 14 62 1955 1997 0.0 0.23 1.68
182 2014-12-29 38 33 43 36 45 8 54 1968 1949 0.0 0.16 1.92
198 2015-1-14 38 33 43 37 47 8 59 1950 1968 0.0 0.19 1.61
238 2015-2-23 44 33 55 37 51 27 61 2011 1983 0.0 0.11 1.16
134 2014-11-11 40 34 46 41 52 15 65 1955 1990 0.0 0.23 1.48
199 2015-1-15 40 34 46 37 47 15 58 1950 1974 0.38 0.19 1.68
214 2015-1-30 41 34 47 37 49 7 59 1950 1992 0.0 0.15 1.0
244 2015-3-1 43 34 52 38 52 23 62 1971 1968 0.0 0.13 0.84
167 2014-12-14 45 35 55 35 45 22 59 2008 2002 0.0 0.17 1.67
179 2014-12-26 39 35 42 36 45 22 62 1948 1980 0.0 0.17 2.14
187 2015-1-3 38 35 41 36 46 6 58 1950 1984 0.0 0.19 1.01
192 2015-1-8 41 35 46 37 46 18 54 1949 1953 0.0 0.2 1.13
142 2014-11-19 44 36 52 39 50 25 60 1977 2008 0.0 0.24 2.13
239 2015-2-24 44 36 52 37 51 24 62 2011 1949 0.0 0.12 1.55
178 2014-12-25 42 37 46 35 45 24 60 1995 1980 0.0 0.17 1.06
181 2014-12-28 41 37 44 36 45 12 56 1990 1980 0.16 0.16 0.89
197 2015-1-13 43 37 49 37 47 11 56 1950 1986 0.0 0.18 1.63
248 2015-3-5 47 37 56 38 52 13 66 1955 1965 0.0 0.13 2.7
279 2015-4-5 50 37 62 41 57 29 73 1975 1966 0.0 0.1 0.79
288 2015-4-14 45 37 53 42 58 33 83 1955 1984 0.13 0.1 0.52
151 2014-11-28 47 38 55 37 48 17 59 1952 1999 1.35 0.21 1.55
188 2015-1-4 45 38 51 36 46 14 61 1950 1984 0.4 0.19 1.56
193 2015-1-9 44 38 50 37 46 13 56 1949 2003 0.01 0.19 2.83
201 2015-1-17 47 38 56 37 47 15 56 1950 2015 1.03 0.19 2.39
204 2015-1-20 44 38 50 37 48 16 64 1954 1981 0.0 0.19 1.66
213 2015-1-29 46 38 54 37 49 6 60 1950 1992 0.0 0.16 1.63
215 2015-1-31 42 38 45 37 49 0 61 1950 1960 0.0 0.16 1.93
237 2015-2-22 46 38 53 37 51 30 64 2005 1966 0.0 0.12 0.71
243 2015-2-28 46 38 54 38 51 24 68 1971 1968 0.0 0.12 1.46
249 2015-3-6 49 38 59 38 52 26 68 1951 2007 0.0 0.12 1.18
289 2015-4-15 48 38 57 42 58 33 74 1967 1999 0.0 0.09 0.75
131 2014-11-8 47 39 55 42 53 27 64 1948 1952 0.0 0.22 0.85
157 2014-12-4 43 39 47 36 47 21 57 1994 1989 0.03 0.19 1.41
166 2014-12-13 45 39 50 35 46 19 59 1972 1952 0.0 0.17 1.63
177 2014-12-24 42 39 45 35 45 16 62 1948 2005 0.21 0.17 0.75
230 2015-2-15 47 39 54 37 50 13 65 1956 1996 0.0 0.12 0.94
250 2015-3-7 51 39 62 38 52 26 66 1951 2001 0.0 0.12 0.67
251 2015-3-8 51 39 63 38 53 28 67 1951 2005 0.0 0.12 1.27
278 2015-4-4 47 39 55 41 57 31 75 1948 1966 0.0 0.11 2.64
287 2015-4-13 46 39 53 42 58 33 75 1968 1980 0.55 0.09 1.45
290 2015-4-16 52 39 64 42 59 34 81 1960 1999 0.0 0.09 0.95
147 2014-11-24 47 40 53 38 49 14 59 2010 1974 0.05 0.23 2.93
180 2014-12-27 45 40 49 36 45 20 58 1968 1994 0.13 0.17 1.53
196 2015-1-12 46 40 52 37 47 13 59 1963 1986 0.0 0.19 1.3
216 2015-2-1 45 40 49 37 49 1 63 1950 1962 0.06 0.13 1.34
219 2015-2-4 46 40 51 37 49 7 63 1989 1993 0.33 0.13 0.91
232 2015-2-17 51 40 61 37 50 23 61 1990 2015 0.0 0.12 0.68
233 2015-2-18 47 40 54 37 50 20 62 1990 1977 0.0 0.11 1.63
245 2015-3-2 46 40 52 38 52 22 64 1989 1990 0.0 0.14 1.16
252 2015-3-9 49 40 58 39 53 28 67 1951 1995 0.0 0.12 1.47
260 2015-3-17 48 40 56 40 54 27 65 1951 1972 0.03 0.12 1.05
300 2015-4-26 50 40 60 44 61 32 78 1948 1987 0.0 0.08 0.37
176 2014-12-23 48 41 54 35 45 9 58 1983 1950 0.81 0.17 1.14
212 2015-1-28 48 41 54 37 48 7 57 1950 1976 0.0 0.16 1.23
217 2015-2-2 47 41 52 37 49 8 64 1950 1962 0.29 0.13 1.32
253 2015-3-10 49 41 56 39 53 20 68 1956 1979 0.03 0.12 0.87
277 2015-4-3 47 41 52 41 56 32 71 1948 2004 0.06 0.11 1.46
296 2015-4-22 51 41 60 43 60 35 78 1950 1977 0.0 0.08 1.28
133 2014-11-10 47 42 52 41 52 30 63 1948 1997 0.0 0.22 1.08
143 2014-11-20 47 42 52 39 50 25 64 1985 1987 0.14 0.23 3.41
146 2014-11-23 49 42 55 38 49 10 58 1985 1959 0.47 0.22 2.49
191 2015-1-7 44 42 46 37 46 19 59 1973 2002 0.0 0.19 2.29
200 2015-1-16 48 42 53 37 47 13 55 1950 2011 0.0 0.2 1.78
218 2015-2-3 46 42 50 37 49 8 63 1950 1992 0.05 0.14 1.29
226 2015-2-11 49 42 55 37 50 23 62 1948 1963 0.0 0.13 0.81
231 2015-2-16 51 42 59 37 50 13 59 1956 2015 0.0 0.12 1.83
236 2015-2-21 48 42 54 37 51 25 67 1957 1973 0.0 0.12 0.97
266 2015-3-23 47 42 52 40 55 28 68 1954 1979 0.32 0.12 0.94
275 2015-4-1 49 42 55 41 56 29 82 1953 1987 0.2 0.11 1.13
276 2015-4-2 49 42 56 41 56 30 76 1963 1992 0.0 0.11 0.92
285 2015-4-11 48 42 53 42 58 35 80 1991 2004 0.0 0.1 1.04
286 2015-4-12 49 42 56 42 58 33 79 1968 2008 0.0 0.09 0.83
299 2015-4-25 49 42 56 43 60 34 77 1948 1992 0.05 0.07 0.52
160 2014-12-7 51 43 58 36 46 18 58 1972 2014 0.0 0.19 0.88
170 2014-12-17 46 43 48 35 45 11 57 1964 1994 0.11 0.16 1.61
175 2014-12-22 47 43 51 35 45 14 57 1983 2005 0.0 0.17 1.28
190 2015-1-6 49 43 54 37 46 14 57 1982 2003 0.0 0.19 1.22
194 2015-1-10 45 43 46 37 47 12 59 1949 1981 0.23 0.2 0.94
203 2015-1-19 47 43 50 37 48 18 62 1954 2005 0.02 0.18 2.26
206 2015-1-22 46 43 49 37 48 19 60 1962 1981 0.03 0.17 1.29
210 2015-1-26 52 43 61 37 48 9 61 1957 2015 0.0 0.16 1.03
258 2015-3-15 47 43 51 39 54 30 65 1955 2010 2.2 0.12 2.2

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