Basic Demographics Age And Gender - Seattle Neighborhoods
City of Seattle
@usgov.city_of_seattle_basic_demographics_age_and_gender_seat_11f14953
City of Seattle
@usgov.city_of_seattle_basic_demographics_age_and_gender_seat_11f14953
CREATE TABLE table_1 (
"objectid" BIGINT,
"neighborhood_type" VARCHAR,
"total" BIGINT,
"male" BIGINT,
"male_under_5_years" BIGINT,
"male_5_to_9_years" BIGINT,
"male_10_to_14_years" BIGINT,
"male_15_to_17years" BIGINT,
"male_18_and_19_years" BIGINT,
"male_20_years" BIGINT,
"male_21_years" BIGINT,
"male_22_to_24_years" BIGINT,
"male_25_to_29_years" BIGINT,
"male_30_to_34_years" BIGINT,
"male_35_to_39_years" BIGINT,
"male_40_to_44_years" BIGINT,
"male_45_to_49_years" BIGINT,
"male_50_to_54_years" BIGINT,
"male_55_to_59_years" BIGINT,
"male_60_and_61_years" BIGINT,
"male_62_to_64_years" BIGINT,
"male_65_and_66_years" BIGINT,
"male_67_to_69_years" BIGINT,
"male_70_to_74_years" BIGINT,
"male_75_to_79_years" BIGINT,
"male_80_to_84_years" BIGINT,
"male_85_years_and_over" BIGINT,
"female" BIGINT,
"female_under_5_years" BIGINT,
"female_5_to_9_years" BIGINT,
"female_10_to_14_years" BIGINT,
"female_15_to_17_years" BIGINT,
"female_18_and_19_years" BIGINT,
"female_20_years" BIGINT,
"female_21_years" BIGINT,
"female_22_to_24_years" BIGINT,
"female_25_to_29_years" BIGINT,
"female_30_to_34_years" BIGINT,
"female_35_to_39_years" BIGINT,
"female_40_to_44_years" BIGINT,
"female_45_to_49_years" BIGINT,
"female_50_to_54_years" BIGINT,
"female_55_to_59_years" BIGINT,
"female_60_and_61_years" BIGINT,
"female_62_to_64_years" BIGINT,
"female_65_and_66_years" BIGINT,
"female_67_to_69_years" BIGINT,
"female_70_to_74_years" BIGINT,
"female_75_to_79_years" BIGINT,
"female_80_to_84_years" BIGINT,
"female_85_years_and_over" BIGINT,
"male_15_to_19_years" BIGINT,
"male_20_to_24_years" BIGINT,
"male_60_to_64_years" BIGINT,
"male_65_to_69_years" BIGINT,
"female_15_to_19_years" BIGINT,
"female_20_to_24_years" BIGINT,
"female_60_to_64_years" BIGINT,
"female_65_to_69_years" BIGINT,
"acs_vintage" VARCHAR,
"neigh_no" DOUBLE,
"neighborhood_subtype" VARCHAR,
"neighborhood_name" VARCHAR,
"children_under_18" BIGINT,
"working_age_adults_18_64" BIGINT,
"older_adults_65_over" BIGINT,
"aggregate_age_total" DOUBLE,
"aggregate_age_male" DOUBLE,
"aggregate_age_female" DOUBLE,
"median_age_total" DOUBLE,
"median_age_male" DOUBLE,
"median_age_female" DOUBLE,
"neighborhood_type_outside_comp_plan_areas_id" VARCHAR
);
Anyone who has the link will be able to view this.