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
!!PLEASE NOTE!! When downloading the data, please select "File Geodatabase" to preserve long field names. Shapefile will truncate field names to 10 characters.
This version of the Racial and Social Equity Index indexes all tracts in the remainder of King County against tracts in the city of Seattle. This index should only be used in direct consultation with the Office of Planning and Community Development, and is intended to be of use for comparing tracts in the remainder of King County within the context of percentiles set by tracts within the city of Seattle.
Version: Current
The Racial and Social Equity Index combines information on race, ethnicity, and related demographics with data on socioeconomic and health disadvantages to identify where priority populations make up relatively large proportions of neighborhood residents.
Click here for a User Guide.
See the City of Seattle RSE Index in action in the Racial and Social Equity Viewer
The Composite Index includes sub-indices of:
**Race, English Language Learners, and Origins Index **
ranks census tracts by an index of three measures weighted as follows:
Persons of color (weight: 1.0)
English language learner (weight: 0.5)
Foreign born (weight: 0.5)
Socioeconomic Disadvantage Index
ranks census tracts by an index of two equally weighted measures:
Income below 200% of poverty level
Educational attainment less than a bachelor’s degree
**Health Disadvantage Index **
ranks census tracts by an index of seven equally weighted measures:
No leisure-time physical activity
Diagnosed diabetes
Obesity
Mental health not good
Asthma
Low life expectancy at birth
Disability
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 With Income Below 200% Of Poverty Level,
"share_of_population_25_and_older_with_less_than_a_bach_71033dea" DOUBLE -- Share Of Population 25 And Older With Less Than A Bachelor's Degree,
"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 Population With Income Under 200 Percent Of Poverty Level,
"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 -- Race, ELL, And Origins Percentile,
"socioeconomic_disadvantage_percentile" DOUBLE,
"health_disadvantage_percentile" DOUBLE,
"composite_percentile" DOUBLE,
"race_ell_and_origins_quintile" VARCHAR -- Race, ELL And Origins Quintile,
"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 -- Race, ELL, And Origins Score,
"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 Who Speak English Less Than Very Well,
"population_5_years_and_older" BIGINT,
"population_25_years_and_older_with_less_than_a_bachelo_e76d45cd" BIGINT -- Population 25 Years And Older With Less Than A Bachelor's Degree,
"population_25_years_and_older" BIGINT,
"population_below_200_poverty" BIGINT -- Population Below 200% Poverty,
"population_for_whom_poverty_is_determined" BIGINT,
"adults_with_disability" BIGINT,
"adult_civilian_noninstitutionalized_population" BIGINT,
"shape_area" DOUBLE -- Shape, Area,
"shape_length" DOUBLE -- Shape, Length
);Anyone who has the link will be able to view this.