U.S. Weather History: KNYC.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
7 rows where average_precipitation = "0.17"
This data as json, copyable, CSV (advanced)
Suggested facets: 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, actual_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13 | 13 | 2014-7-13 | 78 | 72 | 83 | 69 | 84 | 54 | 101 | 1888 | 1966 | 0.03 | 0.17 | 3.16 |
28 | 28 | 2014-7-28 | 75 | 68 | 82 | 69 | 84 | 57 | 97 | 1903 | 1999 | 0.19 | 0.17 | 3.11 |
29 | 29 | 2014-7-29 | 70 | 64 | 76 | 69 | 84 | 59 | 99 | 1914 | 1949 | 0.0 | 0.17 | 3.47 |
30 | 30 | 2014-7-30 | 72 | 63 | 80 | 69 | 84 | 57 | 98 | 1956 | 1988 | 0.0 | 0.17 | 3.56 |
31 | 31 | 2014-7-31 | 75 | 68 | 82 | 69 | 84 | 57 | 102 | 1914 | 1933 | 0.0 | 0.17 | 2.29 |
34 | 34 | 2014-8-3 | 71 | 66 | 76 | 69 | 84 | 55 | 97 | 1927 | 2005 | 0.07 | 0.17 | 2.71 |
284 | 284 | 2015-4-10 | 48 | 39 | 56 | 43 | 59 | 28 | 86 | 1997 | 1922 | 0.17 | 0.17 | 4.31 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "us-weather-history/KNYC" ( "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 );