Adult Protective Services - Ineligible Referral
City of New York
@usgov.city_of_new_york_adult_protective_services_ineligible_referral
City of New York
@usgov.city_of_new_york_adult_protective_services_ineligible_referral
APS ineligible referrals with their closing reasons
Organization: City of New York
Last updated: 2020-11-10T17:05:46.587192
CREATE TABLE table_1 (
"report_date" TIMESTAMP,
"borough" VARCHAR,
"geographic_subset" VARCHAR,
"geographic_identifier" VARCHAR,
"client_died" BIGINT,
"does_not_reside_in_nyc" BIGINT,
"no_risk" BIGINT,
"referred_person_has_sufficient_mental_and_physical_capacity" BIGINT,
"referred_person_retains_decision_making_capacity_and_i_86317725" BIGINT -- Referred Person Retains Decision-Making Capacity And Is Refusing All Offers Of Assistance,
"someone_else_willing_and_able_responsibly" BIGINT,
"unable_to_locate" BIGINT,
"under_18" BIGINT,
"total_ineligible_by_geographic_subset" BIGINT,
"client_died_by_geographic_subset" BIGINT,
"does_not_reside_in_nyc_by_geographic_subset" BIGINT,
"no_risk_by_geographic_subset" BIGINT,
"referred_person_has_sufficient_mental_and_physical_cap_902be1a3" BIGINT -- Referred Person Has Sufficient Mental And Physical Capacity By Geographic Subset,
"referred_person_retains_decision_making_capacity_and_i_20176395" BIGINT -- Referred Person Retains Decision-Making Capacity And Is Refusing All Offers Of Assistance By Geographic Subset,
"someone_else_willing_and_able_responsibly_by_geographic_subset" BIGINT,
"unable_to_locate_by_geographic_subset" BIGINT,
"under_18_by_geographic_subset" BIGINT,
"total_ineligible_referrals_by_geographic_subset" BIGINT,
"client_died_citywide" BIGINT -- Client Died - Citywide,
"does_not_reside_in_nyc_citywide" BIGINT -- Does Not Reside In NYC - Citywide,
"no_risk_citywide" BIGINT -- No Risk - Citywide,
"referred_person_has_sufficient_mental_and_physical_cap_216abb63" BIGINT -- Referred Person Has Sufficient Mental And Physical Capacity - Citywide,
"referred_person_retains_decision_making_capacity_and_i_fb989f13" BIGINT -- Referred Person Retains Decision-Making Capacity And Is Refusing All Offers Of Assistance - Citywide,
"someone_else_willing_and_able_responsibly_citywide" BIGINT -- Someone Else Willing And Able Responsibly - Citywide,
"unable_to_locate_citywide" BIGINT -- Unable To Locate - Citywide,
"under_18_citywide" BIGINT -- Under 18 - Citywide,
"total_ineligible_referrals_citywide" BIGINT -- Total Ineligible Referrals - Citywide
);Anyone who has the link will be able to view this.