Census Block Group

CREATE TABLE table_1 (
  "tract" DOUBLE,
  "block_group" BIGINT,
  "fips_block_group" BIGINT,
  "fips_tract" BIGINT,
  "total_population" BIGINT,
  "pop_one_race" BIGINT  -- POP. ONE RACE,
  "pop_multi_race" BIGINT  -- POP. MULTI-RACE,
  "pop_white" BIGINT  -- POP. WHITE,
  "pop_black" BIGINT  -- POP. BLACK,
  "pop_native_american" BIGINT  -- POP. NATIVE AMERICAN,
  "pop_asian" BIGINT  -- POP. ASIAN,
  "pop_pacific_islander" BIGINT  -- POP. PACIFIC ISLANDER,
  "pop_other" BIGINT  -- POP. OTHER,
  "population_25_and_older" BIGINT,
  "median_age" BIGINT,
  "median_household_income_2010" DOUBLE,
  "high_school_male" BIGINT,
  "high_school_or_more_male" BIGINT,
  "college_1_year_or_less_male" BIGINT,
  "college_1_year_or_more_male" BIGINT,
  "associates_degree_male" BIGINT,
  "bachelors_degree_male" BIGINT,
  "masters_degree_male" BIGINT,
  "professional_degree_male" BIGINT,
  "doctoral_degree_male" BIGINT,
  "high_school_female" BIGINT,
  "high_school_or_more_female" BIGINT,
  "college_1_year_or_less_female" BIGINT,
  "college_1_year_or_more_female" BIGINT,
  "associates_degree_female" BIGINT,
  "bachelors_degree_female" BIGINT,
  "masters_degree_female" BIGINT,
  "professional_degree_female" BIGINT,
  "doctoral_degree_female" BIGINT,
  "percent_25_and_older_high_school_or_more" DOUBLE,
  "housing_units" BIGINT,
  "occupied_housing_units" BIGINT,
  "owner_occupied_housing" BIGINT,
  "renter_occupied_housing" BIGINT,
  "percent_owner_occupied" DOUBLE,
  "percent_renter_occupied" DOUBLE,
  "median_owner_occupied_house_value" DOUBLE,
  "median_year_built" DOUBLE,
  "vacany_rates" DOUBLE,
  "geometry" VARCHAR,
  "id1" BIGINT
);