Name: HASA Facts
Creator: US Government
License: https://www.usa.gov/government-works
About this Dataset

HASA Facts

Monthly HIV/AIDS Services Administration Report.
Organization: City of New York
Last updated: 2020-11-10T17:05:58.981751
Tables

Table 1

@usgov.city_of_new_york_hasa_facts.table_1
103.06 kB
88 rows
92 columns
CREATE TABLE table_1 (
  "datadate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "reporting_month" VARCHAR,
  "information_and_referral_inquiries" BIGINT,
  "applications_received" BIGINT,
  "applications_ineligible" BIGINT,
  "applications_pending" BIGINT,
  "applications_withdrawn_by_referral_source" BIGINT,
  "application_eligible" BIGINT,
  "reopened_cases" BIGINT,
  "cases_assigned_to_field_office" BIGINT,
  "cases_closed" BIGINT,
  "cases_served" BIGINT,
  "clients_served" BIGINT,
  "acm_served" BIGINT,
  "single_cases" BIGINT,
  "family_cases" BIGINT,
  "intake_cases" BIGINT,
  "male_adults" BIGINT,
  "female_adults" BIGINT,
  "male_children" BIGINT,
  "female_children" BIGINT,
  "african_american" BIGINT,
  "latino" BIGINT,
  "white" BIGINT,
  "asian_pacific_native_american" BIGINT,
  "unknown_ethnicity" BIGINT,
  "bronx" BIGINT,
  "brooklyn" BIGINT,
  "manhattan" BIGINT,
  "queens" BIGINT,
  "staten_island" BIGINT,
  "unknown_residency" BIGINT,
  "hospital_referrals" BIGINT,
  "corrections_referrals" BIGINT,
  "cbo_referrals" BIGINT,
  "self_referrals" BIGINT,
  "other_referrals" BIGINT,
  "commercial_mou_sro_hotels_bronx" BIGINT  -- Commercial MOU/SRO Hotels - Bronx,
  "commercial_mou_sro_hotels_brooklyn" BIGINT  -- Commercial MOU/SRO Hotels - Brooklyn,
  "commercial_mou_sro_hotels_manhattan" BIGINT  -- Commercial MOU/SRO Hotels - Manhattan,
  "commercial_mou_sro_hotels_queens" BIGINT  -- Commercial MOU/SRO Hotels - Queens,
  "commercial_mou_sro_hotels_staten_island" BIGINT  -- Commercial MOU/SRO Hotels - Staten Island,
  "transitional_congregate_facility_bronx" BIGINT  -- Transitional Congregate Facility - Bronx,
  "transitional_congregate_facility_brooklyn" BIGINT  -- Transitional Congregate Facility - Brooklyn,
  "transitional_congregate_facility_manhattan" BIGINT  -- Transitional Congregate Facility - Manhattan,
  "transitional_congregate_facility_queens" BIGINT  -- Transitional Congregate Facility - Queens,
  "transitional_congregate_facility_staten_island" BIGINT  -- Transitional Congregate Facility - Staten Island,
  "scatter_site_bronx" BIGINT  -- Scatter Site - Bronx,
  "scatter_site_brooklyn" BIGINT  -- Scatter Site - Brooklyn,
  "scatter_site_manhattan" BIGINT  -- Scatter Site - Manhattan,
  "scatter_site_queens" BIGINT  -- Scatter Site - Queens,
  "scatter_site_staten_island" BIGINT  -- Scatter Site - Staten Island,
  "rental_assist_bronx" BIGINT  -- Rental Assist - Bronx,
  "rental_assist_brooklyn" BIGINT  -- Rental Assist - Brooklyn,
  "rental_assist_manhattan" BIGINT  -- Rental Assist - Manhattan,
  "rental_assist_queens" BIGINT  -- Rental Assist - Queens,
  "rental_assist_staten_island" BIGINT  -- Rental Assist - Staten Island,
  "permanent_congregate_bronx" BIGINT  -- Permanent Congregate - Bronx,
  "permanent_congregate_brooklyn" BIGINT  -- Permanent Congregate - Brooklyn,
  "permanent_congregate_manhattan" BIGINT  -- Permanent Congregate - Manhattan,
  "permanent_congregate_queens" BIGINT  -- Permanent Congregate - Queens,
  "permanent_congregate_staten_island" BIGINT  -- Permanent Congregate - Staten Island,
  "nycha_bronx" BIGINT  -- NYCHA - Bronx,
  "nycha_brooklyn" BIGINT  -- NYCHA - Brooklyn,
  "nycha_manhattan" BIGINT  -- NYCHA - Manhattan,
  "nycha_queens" BIGINT  -- NYCHA - Queens,
  "nycha_staten_island" BIGINT  -- NYCHA - Staten Island,
  "homemaking" BIGINT,
  "private_market_rental_assistance_standard" BIGINT  -- Private Market Rental Assistance - Standard,
  "private_market_rental_assistance_enhanced" BIGINT  -- Private Market Rental Assistance - Enhanced,
  "private_market_rental_assistance_above_enhanced" BIGINT  -- Private Market Rental Assistance - Above Enhanced,
  "tanf_cases" BIGINT,
  "safety_net_cases" BIGINT,
  "ssi_cases" BIGINT,
  "ssd_cases" BIGINT,
  "receiving_both_ssi_ssd" BIGINT  -- Receiving Both SSI & SSD,
  "veterans_administration_cases" BIGINT,
  "clients_with_earned_income" BIGINT,
  "rental_assist_enhanced_bronx" BIGINT  -- Rental Assist Enhanced- Bronx,
  "rental_assist_enhanced_brooklyn" BIGINT  -- Rental Assist Enhanced - Brooklyn,
  "rental_assist_enhanced_manhattan" BIGINT  -- Rental Assist Enhanced - Manhattan,
  "rental_assist_enhanced_queens" BIGINT  -- Rental Assist Enhanced - Queens,
  "rental_assist_enhanced_staten_island" BIGINT  -- Rental Assist Enhanced - Staten Island,
  "rental_assist_above_enhanced_bronx" BIGINT  -- Rental Assist Above Enhanced- Bronx,
  "rental_assist_above_enhanced_brooklyn" BIGINT  -- Rental Assist Above Enhanced - Brooklyn,
  "rental_assist_above_enhanced_manhattan" BIGINT  -- Rental Assist Above Enhanced - Manhattan,
  "rental_assist_above_enhanced_queens" BIGINT  -- Rental Assist Above Enhanced - Queens,
  "rental_assist_above_enhanced_staten_island" BIGINT  -- Rental Assist Above Enhanced - Staten Island,
  "cases_last_12_months" BIGINT  -- Cases - Last 12 Months,
  "clients_served_last_12_months" BIGINT  -- Clients Served - Last 12 Months,
  "acms_served_last_12_months" BIGINT  -- ACMs Served - Last 12 Months
);