Racial And Social Equity Composite Index Current For Countywide Comparisons
City of Seattle
@usgov.city_of_seattle_racial_and_social_equity_composite_ind_9689e27b
City of Seattle
@usgov.city_of_seattle_racial_and_social_equity_composite_ind_9689e27b
CREATE TABLE table_1 (
"objectid" BIGINT,
"geoid" BIGINT,
"gross_acres" DOUBLE,
"share_of_population_who_are_people_of_color" DOUBLE,
"share_of_population_who_speak_english_less_than_very_well" DOUBLE,
"share_of_population_who_are_foreign_born" DOUBLE,
"share_of_population_with_income_below_200_of_poverty_level" DOUBLE,
"share_of_population_25_and_older_with_less_than_a_bach_71033dea" DOUBLE,
"share_of_adults_with_no_leisure_time_physical_activity" DOUBLE,
"share_of_adults_with_diagnosed_diabetes" DOUBLE,
"share_of_adults_with_obesity" DOUBLE,
"share_of_adults_reporting_mental_health_is_not_good" DOUBLE,
"share_of_adults_with_asthma" DOUBLE,
"life_expectancy_at_birth" DOUBLE,
"share_of_adults_with_disability" DOUBLE,
"percentile_people_of_color" DOUBLE,
"percentile_speak_english_less_than_very_well" DOUBLE,
"percentile_foreign_born" DOUBLE,
"percentile_population_with_income_under_200_percent_of_de95d927" DOUBLE,
"percentile_less_than_a_bachelor_s_degree" DOUBLE,
"percentile_adults_with_no_leisure_time_physical_activity" DOUBLE,
"percentile_adults_with_diagnoses_diabetes" DOUBLE,
"percentile_adults_with_obesity" DOUBLE,
"percentile_adults_with_mental_health_not_good" DOUBLE,
"percentile_adults_with_asthma" DOUBLE,
"percentile_low_life_expectancy_at_birth" DOUBLE,
"percentile_adults_with_disability" DOUBLE,
"race_ell_and_origins_percentile" DOUBLE,
"socioeconomic_disadvantage_percentile" DOUBLE,
"health_disadvantage_percentile" DOUBLE,
"composite_percentile" DOUBLE,
"race_ell_and_origins_quintile" VARCHAR,
"socioeconomic_disadvantage_quintile" VARCHAR,
"health_disadvantage_quintile" VARCHAR,
"composite_quintile" VARCHAR,
"tractce" BIGINT,
"tract_name" DOUBLE,
"tract_name_long" VARCHAR,
"race_ell_and_origins_score" DOUBLE,
"socioeconomic_disadvantage_score" DOUBLE,
"health_disadvantage_score" DOUBLE,
"composite_score" DOUBLE,
"people_of_color" BIGINT,
"total_population_denominator_for_poc_share" BIGINT,
"foreign_born" BIGINT,
"total_population_denominator_for_foreign_born" BIGINT,
"population_5_years_and_older_who_speak_english_less_th_5daa692c" BIGINT,
"population_5_years_and_older" BIGINT,
"population_25_years_and_older_with_less_than_a_bachelo_e76d45cd" BIGINT,
"population_25_years_and_older" BIGINT,
"population_below_200_poverty" BIGINT,
"population_for_whom_poverty_is_determined" BIGINT,
"adults_with_disability" BIGINT,
"adult_civilian_noninstitutionalized_population" BIGINT,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.