[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