zipcode_demographics table

zipcode_demographics.sql

CREATE TABLE dbo.zipcode_demographics(
  zip VARCHAR (5) NOT NULL
  , population INT NOT NULL
  , race_pct_white DECIMAL (4, 1) NOT NULL
  , race_pct_black DECIMAL (4, 1) NOT NULL
  , race_pct_asian DECIMAL (4, 1) NOT NULL
  , race_pct_native DECIMAL (4, 1) NOT NULL
  , race_pct_other DECIMAL (4, 1) NOT NULL
  , sex_pct_male DECIMAL (4, 1) NOT NULL
  , sex_pct_female DECIMAL (4, 1) NOT NULL
  , age_pct_0_19 DECIMAL (4, 1) NOT NULL
  , age_pct_20_39 DECIMAL (4, 1) NOT NULL
  , age_pct_40_59 DECIMAL (4, 1) NOT NULL
  , age_pct_60_79 DECIMAL (4, 1) NOT NULL
  , age_pct_80_over DECIMAL (4, 1) NOT NULL
  , age_median DECIMAL (4, 1) NOT NULL
  , households INT NOT NULL
  , home_pct_own DECIMAL (4, 1) NOT NULL
  , home_pct_rent DECIMAL (4, 1) NOT NULL
  , income_median DECIMAL (9, 2) NOT NULL
  , PRIMARY KEY (zip)
)