Baselight

Adult Protective Services - Ineligible Referral

City of New York

@usgov.city_of_new_york_adult_protective_services_ineligible_referral

Loading...
Loading...

About this Dataset

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

Tables

Table 1

@usgov.city_of_new_york_adult_protective_services_ineligible_referral.table_1
  • 63.33 kB
  • 3,853 rows
  • 31 columns
Loading...
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
);

Share link

Anyone who has the link will be able to view this.