Selected Social Characteristics (DP02)

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid" BIGINT,
  "households" BIGINT,
  "family_households_families" BIGINT  -- Family Households (families),
  "family_households_with_own_children_under_18_years" BIGINT,
  "married_couple_family" BIGINT,
  "married_couple_family_with_own_children_under_18_years" BIGINT,
  "male_householder_no_wife_present" BIGINT,
  "male_householder_no_wife_present_with_own_children_und_116971f6" BIGINT  -- Male Householder No Wife Present With Own Children Under 18 Years,
  "female_householder_no_husband_present" BIGINT,
  "female_householder_no_husband_present_with_own_childre_fc86a231" BIGINT  -- Female Householder No Husband Present With Own Children Under 18 Years,
  "nonfamily_households" BIGINT,
  "householder_living_alone" BIGINT,
  "householder_living_alone_65_years_and_over" DOUBLE,
  "households_with_one_or_more_people_under_18_years" BIGINT,
  "households_with_one_or_more_people_65_years_and_over" BIGINT,
  "average_household_size" DOUBLE,
  "average_family_size" DOUBLE,
  "population_in_households" BIGINT,
  "population_in_families" BIGINT,
  "population_in_nonfamilies" BIGINT,
  "householder" BIGINT,
  "spouse" BIGINT,
  "child" BIGINT,
  "other_relatives" BIGINT,
  "nonrelatives" BIGINT,
  "unmarried_partner" BIGINT,
  "males_15_and_over" BIGINT,
  "males_never_married" BIGINT,
  "males_now_married_except_separated" BIGINT,
  "males_separated" BIGINT,
  "males_widowed" BIGINT,
  "males_divorced" BIGINT,
  "females_15_and_over" BIGINT,
  "females_never_married" BIGINT,
  "females_married_except_separated" BIGINT,
  "females_separated" BIGINT,
  "females_widowed" BIGINT,
  "females_divorced" BIGINT,
  "number_of_women_15_to_50_years_old_who_had_a_birth_in__34a37730" BIGINT  -- Number Of Women 15 To 50 Years Old Who Had A Birth In The Past 12 Months,
  "unmarried_women_who_had_a_birth_in_the_past_12_months" BIGINT,
  "unmarried_women_who_had_a_birth_in_the_past_12_months__7eed8725" BIGINT  -- Unmarried Women Who Had A Birth In The Past 12 Months Per 1,000 Women,
  "women_15_to_50_years_who_had_a_birth_in_the_past_12_mo_3e8eb85e" BIGINT  -- Women 15 To 50 Years Who Had A Birth In The Past 12 Months Per 1,000 Women,
  "women_15_to_19_years_who_had_a_birth_in_the_past_12_mo_ccb459d8" DOUBLE  -- Women 15 To 19 Years Who Had A Birth In The Past 12 Months Per 1,000 Women,
  "women_20_to_34_years_who_had_a_birth_in_the_past_12_mo_efb794db" BIGINT  -- Women 20 To 34 Years Who Had A Birth In The Past 12 Months Per 1,000 Women,
  "women_35_to_50_years_who_had_a_birth_in_the_past_12_mo_9f9d040b" DOUBLE  -- Women 35 To 50 Years Who Had A Birth In The Past 12 Months Per 1,000 Women,
  "number_of_grandparents_living_with_own_grandchildren_u_6e2ca6e0" BIGINT  -- Number Of Grandparents Living With Own Grandchildren Under 18 Years,
  "number_of_grandparents_responsible_for_own_grandchildr_19ac41b4" BIGINT  -- Number Of Grandparents Responsible For Own Grandchildren Under 18 Years,
  "number_of_grandparents_responsible_for_own_grandchildr_0b222f96" BIGINT  -- Number Of Grandparents Responsible For Own Grandchildren Less Than 1 Year,
  "number_of_grandparents_responsible_for_own_grandchildr_3166b3e6" BIGINT  -- Number Of Grandparents Responsible For Own Grandchildren 1 To 2 Years,
  "number_of_grandparents_responsible_for_own_grandchildr_b6892e76" BIGINT  -- Number Of Grandparents Responsible For Own Grandchildren 3 To 4 Years,
  "number_of_grandparents_responsible_for_own_grandchildr_58c4c60a" BIGINT  -- Number Of Grandparents Responsible For Own Grandchildren 5 Or More Years,
  "number_of_grandparents_responsible_for_own_grandchildr_3845100f" BIGINT  -- Number Of Grandparents Responsible For Own Grandchildren Under 18 Years Who Are Female,
  "number_of_grandparents_responsible_for_own_grandchildr_2a4a5c94" BIGINT  -- Number Of Grandparents Responsible For Own Grandchildren Under 18 Years Who Are Married,
  "population_3_years_and_over_enrolled_in_school" BIGINT,
  "enrolled_in_nursery_school_or_preschool" BIGINT,
  "enrolled_in_kindergarten" BIGINT,
  "enrolled_in_elementary_school_grades_1_8" BIGINT  -- Enrolled In Elementary School (grades 1-8),
  "enrolled_in_high_school_grades_9_12" BIGINT  -- Enrolled In High School (grades 9-12),
  "enrolled_in_college_or_graduate_school" BIGINT,
  "population_25_years_and_over" BIGINT,
  "less_than_9th_grade" BIGINT,
  "n_9th_to_12th_grade_no_diploma" BIGINT  -- 9th To 12th Grade No Diploma,
  "high_school_graduate_includes_equivalency" BIGINT  -- High School Graduate (includes Equivalency),
  "some_college_no_degree" BIGINT,
  "associate_degree" BIGINT,
  "bachelor_degree" BIGINT,
  "graduate_or_professional_degree" BIGINT,
  "high_school_graduate_or_higher" BIGINT,
  "percent_high_school_graduate_or_higher" DOUBLE,
  "bachelors_degree_or_higher" BIGINT,
  "percent_bachelor_degree_or_higher" DOUBLE,
  "civilian_population_18_years_and_over" BIGINT,
  "civilian_veterans" BIGINT,
  "population_1_year_and_over" BIGINT,
  "residence_1_year_ago_same_house" BIGINT  -- Residence 1 Year Ago - Same House,
  "residence_1_year_ago_different_house_in_the_us" BIGINT  -- Residence 1 Year Ago - Different House In The US,
  "residence_1_year_ago_same_county" BIGINT  -- Residence 1 Year Ago - Same County,
  "residence_1_year_ago_different_county" BIGINT  -- Residence 1 Year Ago - Different County,
  "residence_1_year_ago_different_county_same_state" BIGINT  -- Residence 1 Year Ago - Different County Same State,
  "residence_1_year_ago_different_county_different_state" BIGINT  -- Residence 1 Year Ago - Different County Different State,
  "residence_1_year_ago_abroad" BIGINT  -- Residence 1 Year Ago - Abroad,
  "native_born" BIGINT,
  "native_born_in_the_us" BIGINT,
  "native_born_in_state_of_residence" BIGINT,
  "native_born_in_different_state" BIGINT,
  "born_abroad_to_american_parents" BIGINT,
  "foreign_born_population" BIGINT,
  "naturalized_us_citizen" BIGINT,
  "not_a_us_citizen" BIGINT,
  "population_born_outside_the_us" BIGINT,
  "born_in_puerto_rico_us_island_areas_or_born_abroad_to__93641ecd" BIGINT  -- Born In Puerto Rico US Island Areas Or Born Abroad To American Parents,
  "native_born_outside_the_us_entered_2000_or_later" DOUBLE,
  "native_born_outside_the_us_entered_before_2000" DOUBLE,
  "native_born_outside_the_us_entered_2010_or_later" DOUBLE,
  "native_born_outside_the_us_entered_before_2010" DOUBLE,
  "foreign_born_population_fdeaf7" BIGINT  -- Foreign Born Population,
  "foreign_born_entered_2000_or_later" DOUBLE,
  "foreign_born_entered_before_2000" DOUBLE,
  "foreign_born_entered_2010_or_later" DOUBLE
);