U.S. Weather History: KSEA.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
11 rows where average_min_temp = 45
This data as json, copyable, CSV (advanced)
Suggested facets: actual_mean_temp, actual_min_temp, actual_max_temp, average_max_temp, record_min_temp, record_max_temp, record_min_temp_year, record_max_temp_year, actual_precipitation, average_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
110 | 110 | 2014-10-18 | 62 | 57 | 67 | 45 | 59 | 32 | 70 | 1949 | 1974 | 0.59 | 0.11 | 1.19 |
111 | 111 | 2014-10-19 | 64 | 55 | 72 | 45 | 58 | 28 | 72 | 1949 | 2014 | 0.0 | 0.12 | 1.05 |
112 | 112 | 2014-10-20 | 58 | 54 | 61 | 45 | 58 | 29 | 69 | 1949 | 1987 | 0.46 | 0.12 | 5.02 |
113 | 113 | 2014-10-21 | 57 | 53 | 61 | 45 | 58 | 32 | 72 | 1949 | 1965 | 0.04 | 0.13 | 1.29 |
114 | 114 | 2014-10-22 | 57 | 53 | 60 | 45 | 57 | 34 | 70 | 1950 | 1965 | 1.26 | 0.12 | 1.26 |
115 | 115 | 2014-10-23 | 53 | 47 | 58 | 45 | 57 | 32 | 73 | 1953 | 1965 | 0.37 | 0.14 | 1.24 |
306 | 306 | 2015-5-2 | 56 | 46 | 65 | 45 | 62 | 33 | 74 | 1952 | 1966 | 0.0 | 0.06 | 0.47 |
307 | 307 | 2015-5-3 | 58 | 46 | 69 | 45 | 62 | 35 | 77 | 1950 | 1992 | 0.0 | 0.07 | 1.31 |
308 | 308 | 2015-5-4 | 54 | 45 | 63 | 45 | 62 | 33 | 85 | 1962 | 1992 | 0.0 | 0.06 | 0.66 |
309 | 309 | 2015-5-5 | 52 | 45 | 58 | 45 | 63 | 36 | 86 | 1965 | 1953 | 0.24 | 0.07 | 0.59 |
310 | 310 | 2015-5-6 | 54 | 45 | 62 | 45 | 63 | 36 | 87 | 1965 | 2013 | 0.0 | 0.07 | 0.89 |
Advanced export
JSON shape: default, array, newline-delimited
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 );