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.3", "url": "https://github.com/ForomePlatform/dorieh", "commit": "d5d46ee8f87cba7c46356cc5105c37d98eb99086"}. Created at 2026-07-12 23:59:23.778934';

---

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