Census Tract Top 50 American Community Survey Data

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid" BIGINT,
  "tract_name" VARCHAR,
  "tract_label" DOUBLE,
  "land_acres" DOUBLE,
  "jurisdiction" VARCHAR,
  "community_reporting_area_id" DOUBLE,
  "community_reporting_area_group" DOUBLE,
  "community_reporting_area_name" VARCHAR,
  "community_reporting_area_neighborhoods" VARCHAR,
  "total_population" BIGINT,
  "population_under_18" BIGINT,
  "percent_of_population_under_18_years" DOUBLE,
  "population_18_years_and_over" BIGINT,
  "percent_of_population_18_years_and_over" DOUBLE,
  "population_65_years_and_over" BIGINT,
  "percent_of_population_65_years_and_over" DOUBLE,
  "median_age_years" DOUBLE  -- Median Age (years),
  "white_alone_not_hispanic_or_latino" BIGINT  -- White Alone (Not Hispanic Or Latino),
  "percent_white_alone_not_hispanic_or_latino" DOUBLE  -- Percent White Alone (Not Hispanic Or Latino),
  "black_or_african_american_alone_not_hispanic_or_latino" BIGINT  -- Black Or African American Alone (Not Hispanic Or Latino),
  "percent_black_or_african_american_alone_not_hispanic_or_latino" DOUBLE  -- Percent Black Or African American Alone (Not Hispanic Or Latino),
  "american_indian_and_alaska_native_alone_not_hispanic_or_latino" BIGINT  -- American Indian And Alaska Native Alone (Not Hispanic Or Latino),
  "percent_american_indian_and_alaska_native_alone_not_hi_702cf6b0" DOUBLE  -- Percent American Indian And Alaska Native Alone (Not Hispanic Or Latino),
  "asian_alone_not_hispanic_or_latino" BIGINT  -- Asian Alone (Not Hispanic Or Latino),
  "percent_asian_alone_not_hispanic_or_latino" DOUBLE  -- Percent Asian Alone (Not Hispanic Or Latino),
  "native_hawaiian_and_other_pacific_islander_alone_not_h_b4ab4aa6" BIGINT  -- Native Hawaiian And Other Pacific Islander Alone (Not Hispanic Or Latino),
  "percent_native_hawaiian_and_other_pacific_islander_alo_9a8e6250" DOUBLE  -- Percent Native Hawaiian And Other Pacific Islander Alone (Not Hispanic Or Latino),
  "some_other_race_alone_not_hispanic_or_latino" BIGINT  -- Some Other Race Alone (Not Hispanic Or Latino),
  "percent_some_other_race_alone_not_hispanic_or_latino" DOUBLE  -- Percent Some Other Race Alone (Not Hispanic Or Latino),
  "two_or_more_races_not_hispanic_or_latino" BIGINT  -- Two Or More Races (Not Hispanic Or Latino),
  "percent_two_or_more_races_not_hispanic_or_latino" DOUBLE  -- Percent Two Or More Races (Not Hispanic Or Latino),
  "hispanic_or_latino_of_any_race" BIGINT  -- Hispanic Or Latino (of Any Race),
  "percent_hispanic_or_latino_of_any_race" DOUBLE  -- Percent Hispanic Or Latino (of Any Race),
  "person_of_color" BIGINT,
  "percent_of_population_of_color" DOUBLE,
  "total_households" BIGINT,
  "population_in_households" BIGINT,
  "percent_population_in_households" DOUBLE,
  "average_household_size" DOUBLE,
  "population_in_group_quarters" BIGINT,
  "percent_population_in_group_quarters" DOUBLE,
  "family_households_families" BIGINT  -- Family Households (families),
  "population_in_families" BIGINT,
  "percent_family_households_families" DOUBLE  -- Percent Family Households (families),
  "percent_population_in_families" DOUBLE,
  "average_family_size" DOUBLE,
  "nonfamily_households" BIGINT,
  "percent_nonfamily_households" DOUBLE,
  "householder_living_alone" BIGINT,
  "total_housing_units" BIGINT,
  "occupied_housing_units" BIGINT,
  "percent_occupied_housing_units" DOUBLE,
  "vacant_housing_units" BIGINT,
  "percent_vacant_housing_units" DOUBLE,
  "owner_occupied_housing_units" BIGINT,
  "percent_owner_occupied_housing_units" DOUBLE,
  "population_in_owner_occupied_housing_units" BIGINT,
  "renter_occupied_housing_units" BIGINT,
  "percent_renter_occupied_housing_units" DOUBLE,
  "population_in_renter_occupied_housing_units" BIGINT,
  "population_25_years_and_over" BIGINT,
  "high_school_graduate_includes_equivalency_or_higher" BIGINT  -- High School Graduate (includes Equivalency) Or Higher,
  "bachelor_degree_or_higher" BIGINT,
  "percent_high_school_graduate_or_higher" DOUBLE,
  "percent_bachelor_degree_or_higher" DOUBLE,
  "population_5_years_and_over" BIGINT,
  "speak_language_other_than_english" BIGINT,
  "percent_of_population_that_speaks_language_other_than_english" DOUBLE,
  "speak_english_less_than_very_well" BIGINT,
  "percent_speak_english_less_than_very_well" DOUBLE,
  "median_owner_occupied_housing_unit_value_dollars" DOUBLE  -- Median Owner-occupied Housing Unit Value (dollars),
  "housing_unit_value_less_than_50_000" BIGINT  -- Housing Unit Value Less Than $50,000,
  "housing_unit_value_50_000_to_99_999" BIGINT  -- Housing Unit Value $50,000 To $99,999,
  "housing_unit_value_100_000_to_149_999" BIGINT  -- Housing Unit Value $100,000 To $149,999,
  "housing_unit_value_150_000_to_199_999" BIGINT  -- Housing Unit Value $150,000 To $199,999,
  "housing_unit_value_200_000_to_299_999" BIGINT  -- Housing Unit Value $200,000 To $299,999,
  "housing_unit_value_300_000_to_499_999" BIGINT  -- Housing Unit Value $300,000 To $499,999,
  "housing_unit_value_500_000_to_999_999" BIGINT  -- Housing Unit Value $500,000 To $999,999,
  "housing_unit_value_1_000_000_or_more" BIGINT  -- Housing Unit Value $1,000,000 Or More,
  "median_selected_monthly_owner_with_a_mortgage_costs_dollars" DOUBLE  -- Median Selected Monthly Owner With A Mortgage Costs (dollars),
  "housing_units_with_a_mortgage_where_selected_monthly_o_427d603b" BIGINT  -- Housing Units With A Mortgage Where Selected Monthly Onwer Costs A S A Percentage Of Household Income Can Be Computed,
  "selected_monthly_owner_costs_as_a_percentage_of_househ_68e68731" BIGINT  -- Selected Monthly Owner Costs As A Percentage Of Household Income Less Than 20.0 Percent,
  "selected_monthly_owner_costs_as_a_percentage_of_househ_09026e39" BIGINT  -- Selected Monthly Owner Costs As A Percentage Of Household Income 20.0 To 24.9 Percent,
  "selected_monthly_owner_costs_as_a_percentage_of_househ_ed2f8e1e" BIGINT  -- Selected Monthly Owner Costs As A Percentage Of Household Income 25.0 To 29.9 Percent,
  "selected_monthly_owner_costs_as_a_percentage_of_househ_f5c8f542" BIGINT  -- Selected Monthly Owner Costs As A Percentage Of Household Income 30.0 To 34.9 Percent,
  "selected_monthly_owner_costs_as_a_percentage_of_househ_0e0f437f" BIGINT  -- Selected Monthly Owner Costs As A Percentage Of Household Income 35.0 Percent Or More,
  "housing_units_with_a_mortgage_where_selected_monthly_o_6403be1b" BIGINT  -- Housing Units With A Mortgage Where Selected Monthly Onwer Costs A S A Percentage Of Household Income Not Computed,
  "percent_of_owner_occupied_housing_units_with_a_mortgag_e9423ef4" DOUBLE  -- Percent Of Owner-occupied Housing Units With A Mortgage Whose Selected Monthly Costs Are 30% Or More Of Household Income,
  "median_gross_rent_dollars" DOUBLE  -- Median Gross Rent (dollars),
  "occupied_units_paying_rent_where_gross_rent_as_a_perce_66392746" BIGINT  -- Occupied Units Paying Rent Where Gross Rent As A Percentage Of Household Income Can Be Computed,
  "gross_rent_as_a_percentage_of_household_income_less_th_a17b9107" BIGINT  -- Gross Rent As A Percentage Of Household Income Less Than 15.0 Percent,
  "gross_rent_as_a_percentage_of_household_income_15_0_to_7dee3eff" BIGINT  -- Gross Rent As A Percentage Of Household Income 15.0 To 19.9 Percent,
  "gross_rent_as_a_percentage_of_household_income_20_0_to_1265db68" BIGINT  -- Gross Rent As A Percentage Of Household Income 20.0 To 24.9 Percent,
  "gross_rent_as_a_percentage_of_household_income_25_0_to_e9075d0b" BIGINT  -- Gross Rent As A Percentage Of Household Income 25.0 To 29.9 Percent,
  "gross_rent_as_a_percentage_of_household_income_30_0_to_2d9c9600" BIGINT  -- Gross Rent As A Percentage Of Household Income 30.0 To 34.9 Percent,
  "gross_rent_as_a_percentage_of_household_income_35_0_pe_b9ca2f34" BIGINT  -- Gross Rent As A Percentage Of Household Income 35.0 Percent Or More,
  "occupied_units_paying_rent_where_gross_rent_as_a_perce_87c5d57f" BIGINT  -- Occupied Units Paying Rent Where Gross Rent As A Percentage Of Household Income Not Computed,
  "percent_of_renter_occupied_housing_units_whose_gross_r_dda2e769" DOUBLE  -- Percent Of Renter-occupied Housing Units Whose Gross Rent Is 30% Or More Of Household Income,
  "population_16_years_and_over" BIGINT
);