About this Dataset

Hospital Encounters For Homeless Patients

This dataset contains counts of inpatient hospitalizations and emergency department visits for persons experiencing homelessness.
Organization: State of California
Last updated: 2024-11-27T01:03:52.044638
Tags: department-of-health-care-access-and-information, emergency-department-visits, hcai, homeless, homelessness, inpatient-hospitalizations, persons-experiencing-homelessness

Tables

Homeless Hospital Encounters: Age, Race, Sex, Expected Payer Statewide

@usgov.ca_gov_hospital_encounters_for_homeless_patients_d6def.homeless_hospital_encounters_age_race_sex_expected_pay_2bb5ddfe

5.48 kB
34 rows
6 columns

CREATE TABLE homeless_hospital_encounters_age_race_sex_expected_pay_2bb5ddfe (
  "encountertype" VARCHAR,
  "demographic" VARCHAR,
  "demographicvalue" VARCHAR,
  "year" VARCHAR,
  "homeless" BIGINT,
  "all" BIGINT
);

2019-2020 Homeless Hospital Encounters: Age, Race, Sex Expected Payer By Facility

@usgov.ca_gov_hospital_encounters_for_homeless_patients_d6def.n_2019_2020_homeless_hospital_encounters_age_race_sex__1e8b0e69

227.66 kB
25,449 rows
17 columns

CREATE TABLE n_2019_2020_homeless_hospital_encounters_age_race_sex__1e8b0e69 (
  "encountertype" VARCHAR,
  "hospitalcounty" VARCHAR,
  "oshpd_id" BIGINT,
  "facilityname" VARCHAR,
  "system" VARCHAR,
  "ownership" VARCHAR,
  "urban_rural" VARCHAR,
  "teaching" VARCHAR,
  "licensedbedsize" VARCHAR,
  "primarycareshortagearea" VARCHAR,
  "mentalhealthshortagearea" VARCHAR,
  "homelessindicator" VARCHAR,
  "demographic" VARCHAR,
  "demographicvalue" VARCHAR,
  "encounters" BIGINT,
  "totalencounters" BIGINT,
  "percent" DOUBLE
);

Data Dictionary Homeless Hospital Encounters: Age, Race, Sex, Expected Payer By Facility

@usgov.ca_gov_hospital_encounters_for_homeless_patients_d6def.n__dictionary_homeless_hospital_encounters_age_race_se_2c246e18

5.93 kB
17 rows
4 columns

CREATE TABLE n__dictionary_homeless_hospital_encounters_age_race_se_2c246e18 (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);

Data Dictionary Homeless Hospital Encounters: Age, Race, Sex Expected Payer Statewide

@usgov.ca_gov_hospital_encounters_for_homeless_patients_d6def.n__dictionary_homeless_hospital_encounters_age_race_se_ed1daca7

4.89 kB
6 rows
4 columns

CREATE TABLE n__dictionary_homeless_hospital_encounters_age_race_se_ed1daca7 (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);