[EPOCH] Side Project_DB Build
Tables (6)
Copy Of Copy Of Copy Of Copy Of Untitled ([Census Bureau] B25003 Homeownership Rate)
- Field (GEO_ID) — VARCHAR
- Field2 (NAME) — VARCHAR
- Field (B25003_001E) — INT
- Field2 (B25003_001M) — INT
- Field (B25003_002E) — INT
- Field (B25003_002M) — INT
- Field (B25003_003E) — INT
- Field (B25003_003M) — INT
Copy Of Copy Of Copy Of Untitled ([Census Bureau] B25064 Median Gross Rent)
- Field (GEO_ID) — VARCHAR
- Field2 (NAME) — VARCHAR
- Field (B25064_001E) — INT
- Field2 (B25064_001M) — INT
Copy Of Copy Of Untitled ([Census Bureau] B25001 Housing Units)
- Field (GEO_ID) — VARCHAR
- Field2 (NAME) — VARCHAR
- Field (B25001_001E) — INT
- Field2 (B25001_001M) — INT
Copy Of Untitled ([Census Bureau] B19013 Median Income)
- Field (GEO_ID) — VARCHAR
- Field2 (NAME) — VARCHAR
- Field (B19013_001E) — INT
- Field2 (B19013_001M) — INT
Untitled ([Census Bureau] B01003 Population)
- Field (GEO_ID) — VARCHAR
- Field2 (NAME) — VARCHAR
- Field (B01003_001E) — INT
- Field2 (B01003_001M) — INT
[Zillow] City_zhvi_uc.csv ([Zillow] City_zhvi)
- RegionID — INT — Primary key — NOT NULL
- SizeRank — INT
- RegionName — VARCHAR
- RegionType — VARCHAR
- StateName — VARCHAR
- State — CHAR(2)
- Metro — VARCHAR
- CountyName — VARCHAR
- Date (DATE) — DATE