Table bronze_temperature

Overview for bronze_temperature

Maximum daily temperature for US Zip Code Tabulation Areas

Primary Key: zcta, date

SQL/DDL Statement

CREATE TABLE  bronze_temperature (
	tmmx FLOAT,
	date DATE,
	zcta INT,
	PRIMARY KEY (zcta, date)
);
COMMENT ON table bronze_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.129217';

---

Columns:

Column Name	Column Type	Datatype
date		date
tmmx		float
zcta		int