Selected Economic Characteristics (DP03)

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid" BIGINT,
  "tract_label" DOUBLE,
  "population_16_years_and_over" BIGINT,
  "in_labor_force" BIGINT,
  "civilian_labor_force" BIGINT,
  "civilian_labor_force_employed" BIGINT,
  "civilian_labor_force_unemployd" BIGINT,
  "armed_forces" BIGINT,
  "not_in_labor_force" BIGINT,
  "percent_civilian_labor_force_that_is_unemployed" DOUBLE,
  "females_16_years_and_over" BIGINT,
  "females_16_years_and_over_in_labor_force" BIGINT,
  "females_16_years_and_over_civilian_labor_force" BIGINT,
  "females_16_years_and_over_civilian_labor_force_employed" BIGINT,
  "own_children_under_6_years" BIGINT,
  "own_children_under_6_years_all_parents_in_labor_force" BIGINT,
  "own_children_6_to_17_years" BIGINT,
  "own_children_6_to_17_years_all_parents_in_labor_force" BIGINT,
  "workers_16_years_and_over" BIGINT,
  "car_truck_or_van_drove_alone" BIGINT  -- Car Truck Or Van - Drove Alone,
  "car_truck_or_van_carpooled" BIGINT  -- Car Truck Or Van - Carpooled,
  "public_transportation_excluding_taxicab" BIGINT  -- Public Transportation (excluding Taxicab),
  "walked" BIGINT,
  "other_means" BIGINT,
  "worked_at_home" BIGINT,
  "mean_travel_time_to_work_minutes" DOUBLE  -- Mean Travel Time To Work (minutes),
  "civilian_employed_population_16_years_and_over" BIGINT,
  "management_business_science_and_arts" BIGINT,
  "service" BIGINT,
  "sales_and_office" BIGINT,
  "natural_resources_construction_and_maintenance" BIGINT,
  "production_transportation_and_material_moving" BIGINT,
  "agriculture_forestry_fishing_and_hunting_and_mining" BIGINT,
  "construction" BIGINT,
  "manufacturing" BIGINT,
  "wholesale_trade" BIGINT,
  "retail_trade" BIGINT,
  "transportation_and_warehousing_and_utilities" BIGINT,
  "information" BIGINT,
  "finance_and_insurance_and_real_estate_and_rental_and_leasing" BIGINT,
  "professional_scientific_and_management_and_adminstrati_6bc2d1ef" BIGINT  -- Professional Scientific And Management And Adminstrative And Waste Management Services,
  "educational_services_and_health_care_and_social_assistance" BIGINT,
  "arts_entertainment_and_recreation_and_accommodation_an_ee30eb30" BIGINT  -- Arts Entertainment And Recreation And Accommodation And Food Servce,
  "other_services_except_public_administration" BIGINT,
  "public_administration" BIGINT,
  "private_wage_and_salary_workers" BIGINT,
  "government_workers" BIGINT,
  "self_employed_in_own_not_incorporated_business_workers" BIGINT,
  "unpaid_family_workers" BIGINT,
  "total_households" BIGINT,
  "household_income_less_than_10_000" BIGINT  -- Household Income Less Than $10,000,
  "household_income_10_000_to_14_999" BIGINT  -- Household Income $10,000 To $14,999,
  "household_income_15_000_to_24_999" BIGINT  -- Household Income $15,000 To $24,999,
  "household_income_25_000_to_34_999" BIGINT  -- Household Income $25,000 To $34,999,
  "household_income_35_000_to_49_999" BIGINT  -- Household Income $35,000 To $49,999,
  "household_income_50_000_to_74_999" BIGINT  -- Household Income $50,000 To $74,999,
  "household_income_75_000_to_99_999" BIGINT  -- Household Income $75,000 To $99,999,
  "household_income_100_000_to_149_999" BIGINT  -- Household Income $100,000 To $149,999,
  "household_income_150_000_to_199_999" BIGINT  -- Household Income $150,000 To $199,999,
  "household_income_200_000_or_more" BIGINT  -- Household Income $200,000 Or More,
  "median_household_income_dollars" DOUBLE  -- Median Household Income (dollars),
  "mean_household_income_dollars" BIGINT  -- Mean Household Income (dollars),
  "households_with_earnings" BIGINT,
  "mean_earnings_dollars" BIGINT  -- Mean Earnings (dollars),
  "households_wth_social_security_income" BIGINT,
  "mean_social_security_income_dollars" DOUBLE  -- Mean Social Security Income (dollars),
  "households_with_retirement_income" BIGINT,
  "mean_retirement_income_dollars" DOUBLE  -- Mean Retirement Income (dollars),
  "households_with_supplemental_security_income" BIGINT,
  "mean_supplemental_security_income_dollars" DOUBLE  -- Mean Supplemental Security Income (dollars),
  "households_with_cash_public_assitance_income" BIGINT,
  "mean_cash_public_assitance_income_dollars" BIGINT  -- Mean Cash Public Assitance Income (dollars),
  "households_with_food_stamps_snap_benefits_in_the_past_12_months" BIGINT,
  "total_families" BIGINT,
  "family_income_less_than_10_000" BIGINT  -- Family Income Less Than $10,000,
  "family_income_10_000_to_14_999" BIGINT  -- Family Income $10,000 To $14,999,
  "family_income_15_000_to_24_999" BIGINT  -- Family Income $15,000 To $24,999,
  "family_income_25_000_to_34_999" BIGINT  -- Family Income $25,000 To $34,999,
  "family_income_35_000_to_49_999" BIGINT  -- Family Income $35,000 To $49,999,
  "family_income_50_000_to_74_999" BIGINT  -- Family Income $50,000 To $74,999,
  "family_income_75_000_to_99_999" BIGINT  -- Family Income $75,000 To $99,999,
  "family_income_100_000_to_149_999" BIGINT  -- Family Income $100,000 To $149,999,
  "family_income_150_000_to_199_999" BIGINT  -- Family Income $150,000 To $199,999,
  "family_income_200_000_or_more" BIGINT  -- Family Income $200,000 Or More,
  "median_family_income_dollars" DOUBLE  -- Median Family Income (dollars),
  "mean_family_income_dollars" DOUBLE  -- Mean Family Income (dollars),
  "per_capita_income_dollars" BIGINT  -- Per Capita Income (dollars),
  "nonfamily_households" BIGINT,
  "median_nonfamily_income_dollars" DOUBLE  -- Median Nonfamily Income (dollars),
  "mean_nonfamily_income_dollars" DOUBLE  -- Mean Nonfamily Income (dollars),
  "median_earnings_for_workers_dollars" BIGINT  -- Median Earnings For Workers (dollars),
  "median_earnings_for_male_full_time_year_round_workers_dollars" DOUBLE  -- Median Earnings For Male Full-time Year-round Workers (dollars),
  "median_earnings_for_female_full_time_year_round_worker_c6ea06b5" DOUBLE  -- Median Earnings For Female Full-time Year-round Workers (dollars),
  "percentage_of_all_families_whose_income_in_the_past_12_b3161df6" DOUBLE  -- Percentage Of All Families Whose Income In The Past 12 Months Is Below Poverty,
  "with_related_children_under_18_years" DOUBLE,
  "with_related_children_under_5_years_only" DOUBLE,
  "married_couple_families" DOUBLE,
  "married_couple_families_with_related_children_under_18_years" DOUBLE,
  "married_couple_families_with_related_children_under_5__cca42f09" DOUBLE  -- Married Couple Families With Related Children Under 5 Years Only
);