About this Dataset

DYCD Participant Demographics By Zip Code

This dataset provides a Demographic breakdown of only DYCD-funded participants within a Zip Code of NYC. The data displays the counts, and percentages of the participants in each of the following categories:
● Gender (Male, Female, Unknown)
● Ethnicity (Hispanic/Latino, non-Hispanic/non-Latino)
● Race (Pacific Islander, American Indian, Asian, White, Black, Other, Unknown)
This data is used to measure the numbers of the different population groups that are served by DYCD for a Borough, and Community.
Organization: City of New York
Last updated: 2020-11-10T17:03:19.484927
Tags: dycd-demographics-by-zip-code

Tables

Table 1

@usgov.city_of_new_york_demographics_by_zip_code.table_1

177.53 kB
4,913 rows
51 columns

CREATE TABLE table_1 (
  "data_os_of_date" TIMESTAMP,
  "zip_code" BIGINT,
  "program_type" VARCHAR,
  "female_count" BIGINT,
  "female_percentage" DOUBLE,
  "male_count" BIGINT,
  "male_percentage" DOUBLE,
  "gender_nonconforming_count" BIGINT,
  "gender_nonconforming_percentage" DOUBLE,
  "american_indian_or_alaskan_native_count" BIGINT,
  "american_indian_or_alaskan_native_percentage" DOUBLE,
  "asian_count" BIGINT,
  "asian_percentage" DOUBLE,
  "black_or_african_american_count" BIGINT,
  "black_or_african_american_percentage" DOUBLE,
  "multi_race_count" BIGINT,
  "multi_race_percentage" DOUBLE,
  "native_hawaiian_or_other_pacific_islander_count" BIGINT,
  "native_hawaiian_or_other_pacific_islander_percentage" DOUBLE,
  "white_or_caucasian_count" BIGINT,
  "white_or_caucasian_percentage" DOUBLE,
  "hispanic_or_latinx_count" BIGINT,
  "hispanic_or_latinx_percentage" DOUBLE,
  "not_hispanic_or_latinx_count" BIGINT,
  "not_hispanic_or_latinx_percentage" DOUBLE,
  "not_sure_count" DOUBLE,
  "not_sure_percentage" DOUBLE,
  "x_not_male_or_female_count" DOUBLE  -- X (Not Male Or Female) Count,
  "x_not_male_or_female_percentage" DOUBLE  -- X (Not Male Or Female) Percentage,
  "another_gender_count" DOUBLE,
  "another_gender_percentage" DOUBLE,
  "decline_to_answer_count" DOUBLE,
  "decline_to_answer_percentage" DOUBLE,
  "do_not_understand_the_question_count" DOUBLE,
  "do_not_understand_the_question_percentage" DOUBLE,
  "female_gender_identity_count" DOUBLE,
  "female_gender_identity_percentage" DOUBLE,
  "male_gender_identity_count" DOUBLE,
  "male_gender_identity_percentage" DOUBLE,
  "multi_gender_identity_count" DOUBLE,
  "multi_gender_identity_percentage" DOUBLE,
  "non_binary_not_female_or_male_count" DOUBLE  -- Non-Binary (not Female Or Male) Count,
  "non_binary_not_female_or_male_percentage" DOUBLE  -- Non-Binary (not Female Or Male) Percentage,
  "not_sure_gender_identity_count" DOUBLE,
  "not_sure_gender_identity_percentage" DOUBLE,
  "two_spirit_native_american_first_nations_count" DOUBLE  -- Two Spirit (Native American/First Nations) Count,
  "two_spirit_native_american_first_nations_percentage" DOUBLE  -- Two Spirit (Native American/First Nations) Percentage,
  "middle_eastern_and_north_african_count" DOUBLE,
  "middle_eastern_and_north_african_percentage" DOUBLE,
  "other_count" DOUBLE,
  "other_percentage" DOUBLE
);