U.S. Weather History: KPHX.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
2 rows where actual_precipitation = "0.14"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79 | 79 | 2014-9-17 | 84 | 78 | 89 | 77 | 100 | 56 | 109 | 1906 | 1962 | 0.14 | 0.01 | 1.19 |
300 | 300 | 2015-4-26 | 65 | 54 | 75 | 63 | 88 | 42 | 101 | 1964 | 1992 | 0.14 | 0.0 | 0.2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "us-weather-history/KPHX" ( "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 );