Race By Age Groups (B01001A-I)
City of Seattle
@usgov.city_of_seattle_race_by_age_groups_b01001a_i
City of Seattle
@usgov.city_of_seattle_race_by_age_groups_b01001a_i
CREATE TABLE table_1 (
"objectid" BIGINT,
"geoid" BIGINT,
"name" VARCHAR,
"total_population" BIGINT,
"white_total" BIGINT,
"black_or_african_american_total" BIGINT,
"american_indian_and_alaska_native_total" BIGINT,
"asian_total" BIGINT,
"native_hawaiian_and_other_pacific_islander_total" BIGINT,
"some_other_race_total" BIGINT,
"two_or_more_races_total" BIGINT,
"white_not_hispanic_or_latino_total" BIGINT,
"person_of_color_total" BIGINT,
"total_under_18" BIGINT,
"white_under_18" BIGINT,
"black_or_african_american_under_18" BIGINT,
"american_indian_and_alaska_native_under_18" BIGINT,
"asian_under_18" BIGINT,
"native_hawaiian_and_other_pacific_islander_under_18" BIGINT,
"some_other_race_under_18" BIGINT,
"two_or_more_races_under_18" BIGINT,
"white_not_hispanic_or_latino_under_18" BIGINT,
"person_of_colorunder_18" BIGINT,
"total_65_and_over" BIGINT,
"white_65_and_over" BIGINT,
"black_or_african_american_65_and_over" BIGINT,
"american_indian_and_alaska_native_65_and_over" BIGINT,
"asian_65_and_over" BIGINT,
"native_hawaiian_and_other_pacific_islande_65_and_over" BIGINT,
"some_other_race_65_and_over" BIGINT,
"two_or_more_races_65_and_over" BIGINT,
"white_not_hispanic_or_latino_65_and_over" BIGINT,
"person_of_color_65_and_over" BIGINT,
"total_18_to_64" BIGINT,
"white_18_to_64" BIGINT,
"black_or_african_american_18_to_64" BIGINT,
"american_indian_and_alaska_native_18_to_64" BIGINT,
"asian_18_to_64" BIGINT,
"native_hawaiian_and_other_pacific_islander_18_to_64" BIGINT,
"some_other_race_18_to_64" BIGINT,
"two_or_more_races_18_to_64" BIGINT,
"white_not_hispanic_or_latino_18_to_64" BIGINT,
"person_of_color_18_to_64" BIGINT,
"acs_vintage" VARCHAR,
"tract_label" DOUBLE,
"jurisdiction" VARCHAR,
"community_reporting_area_id" DOUBLE,
"community_reporting_area_group" DOUBLE,
"community_reporting_area_name" VARCHAR,
"community_reporting_area_neighborhoods" VARCHAR
);
Anyone who has the link will be able to view this.