U.S. Weather History: KSEA.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
10 rows where average_min_temp = 47
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100 | 100 | 2014-10-8 | 62 | 55 | 69 | 47 | 63 | 39 | 80 | 1949 | 1951 | 0.0 | 0.08 | 1.16 |
101 | 101 | 2014-10-9 | 58 | 52 | 63 | 47 | 62 | 35 | 79 | 1960 | 1996 | 0.0 | 0.09 | 1.27 |
102 | 102 | 2014-10-10 | 58 | 50 | 65 | 47 | 62 | 40 | 77 | 1972 | 1987 | 0.01 | 0.09 | 1.02 |
103 | 103 | 2014-10-11 | 59 | 53 | 65 | 47 | 61 | 37 | 83 | 1969 | 1991 | 0.29 | 0.09 | 0.89 |
104 | 104 | 2014-10-12 | 59 | 53 | 64 | 47 | 61 | 40 | 72 | 2002 | 2006 | 0.0 | 0.09 | 0.7 |
316 | 316 | 2015-5-12 | 56 | 51 | 60 | 47 | 64 | 38 | 81 | 1964 | 1959 | 0.17 | 0.06 | 0.71 |
317 | 317 | 2015-5-13 | 52 | 50 | 54 | 47 | 64 | 37 | 84 | 1956 | 1973 | 0.16 | 0.06 | 0.44 |
318 | 318 | 2015-5-14 | 57 | 49 | 64 | 47 | 65 | 36 | 87 | 1964 | 1973 | 0.01 | 0.06 | 0.97 |
319 | 319 | 2015-5-15 | 59 | 49 | 68 | 47 | 65 | 38 | 85 | 1964 | 2007 | 0.0 | 0.06 | 0.81 |
320 | 320 | 2015-5-16 | 56 | 52 | 60 | 47 | 65 | 40 | 84 | 2003 | 1985 | 0.0 | 0.06 | 0.64 |
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 );