View silver_temperature

Overview for silver_temperature

Maximum daily temperature for US Zip Code Tabulation Areas, enriched and harmonized

Transformed from bronze_temperature

SQL/DDL Statement

CREATE view  silver_temperature AS
SELECT
    tmmx,
	date,
	zcta,
	(tmmx - 273.15) AS temperature_in_C,
	((tmmx - 273.15)*9/5 + 32) AS temperature_in_F,
	public.zip_to_state(EXTRACT(YEAR FROM date)::INT, zcta) AS us_state,
	public.zip_to_city(EXTRACT(YEAR FROM date)::INT, zcta) AS city
FROM bronze_temperature;
COMMENT ON view silver_temperature IS 'CREATED BY Dorieh: {"version": "0.4.4", "url": "file:///Users/misha/harvard/projects/github/dorieh", "commit": null}. Created at 2025-12-22 18:20:47.235163';

---

Columns:

Column Name	Column Type	Datatype
city	computed	VARCHAR(128)
date		string
temperature_in_c	computed	float
temperature_in_f	computed	float
tmmx		string
us_state	computed	VARCHAR(2)
zcta		string