About this Dataset

CDPH Mental Health Resources (Deprecated November 2023)

OUTDATED. See the current data at https://data.cityofchicago.org/d/wust-ytyg.

This dataset was replaced in November 2023. It is retained as a deprecated / historical version because it contains additional data elements that were difficult to maintain over time and therefore are not shown in the replacement dataset.

Comprehensive information about the Chicago Department of Public Health (CDPH)'s mental health clinics and community partners. Providers on this site offer free mental health services to Chicagoans regardless of ability to pay, immigration status, or health insurance. Information includes location of site(s), hours of operation, populations served, specific service types, and contact information.
Organization: City of Chicago
Last updated: 2022-12-23T12:04:29.090106
Tags: clinics, deprecated, facilities, health, mental-health, public-health

Tables

Table 1

@usgov.city_of_chicago_cdph_mental_health_resources.table_1

87.89 KB
171 rows
46 columns


CREATE TABLE table_1 (
  "organization" VARCHAR,
  "site_name" VARCHAR,
  "site_type" VARCHAR,
  "address" VARCHAR,
  "zip" BIGINT,
  "main_phone" VARCHAR,
  "service_request_phone" VARCHAR,
  "service_request_alternative_availability" VARCHAR,
  "service_request_alternative_detail" VARCHAR,
  "hours" VARCHAR,
  "evening_hours_availability" BOOLEAN,
  "evening_hours_detail" VARCHAR,
  "weekend_hours_availability" BOOLEAN,
  "weekend_hours_detail" VARCHAR,
  "ticc_site" BOOLEAN,
  "ticc_areas_served" VARCHAR,
  "all_community_areas_served" VARCHAR,
  "wards_served" VARCHAR,
  "police_districts_served" VARCHAR,
  "accepts_uninsured_patients" BOOLEAN,
  "sliding_scale_fees" VARCHAR,
  "insurance_accepted" VARCHAR,
  "age_range_served" VARCHAR,
  "primary_care_availability" BOOLEAN,
  "bhs_service_availability_primarycare" BOOLEAN,
  "telehealth_services_availability" BOOLEAN,
  "other_languages" VARCHAR,
  "language_line_availability" BOOLEAN,
  "behavioral_services_types" VARCHAR,
  "crisis_services" BOOLEAN,
  "crisis_intake_phone" VARCHAR,
  "crisis_services_hours" VARCHAR,
  "crisis_services_types" VARCHAR,
  "mental_health_services_type_special_needs_availability" VARCHAR,
  "mental_health_services_type_special_needs_detail" VARCHAR,
  "school_based_services_availability" BOOLEAN,
  "grief_services_availability" VARCHAR,
  "grief_bereavement_services_types" VARCHAR,
  "first_episode_psychosis_programming_availability" VARCHAR,
  "first_episode_psychosis_programming_detail" VARCHAR,
  "substance_use_services_availability" BOOLEAN,
  "substance_use_service_type" VARCHAR,
  "mar_medications_opioid" VARCHAR,
  "mar_medications_alcohol" VARCHAR,
  "harm_reduction_services" VARCHAR,
  "location" VARCHAR
);