About this Dataset

Patient Demographics

Department of State Hospitals
Patient Population Demographic
(Fiscal Effective Dates: 2010-2020)
Organization: State of California
Last updated: 2021-09-08T16:05:01.465787
Tags: age, california-department-of-state-hospitals, citizenship, demographics, education, ethnicity, hospital, language-spoken-at-home, level-of-care, marital-status, patient-counts-by-hospital, region, sex

Tables

Age-Data-Dictionary

@usgov.ca_gov_patient_demographics.age_data_dictionary

3.63 KB
3 rows
4 columns


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

Citizenship Status

@usgov.ca_gov_patient_demographics.citizenship_status

3.27 KB
33 rows
3 columns


CREATE TABLE citizenship_status (
  "fiscal_year" BIGINT,
  "citizenship_status" VARCHAR,
  "patient_counts" BIGINT
);

Citizenship Status-Data Dictionary

@usgov.ca_gov_patient_demographics.citizenship_status_data_dictionary

3.71 KB
3 rows
4 columns


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

Education

@usgov.ca_gov_patient_demographics.education

3.29 KB
33 rows
3 columns


CREATE TABLE education (
  "fiscal_year" BIGINT,
  "education" VARCHAR,
  "patient_counts" BIGINT
);

Education-Data Dictionary

@usgov.ca_gov_patient_demographics.education_data_dictionary

3.64 KB
3 rows
4 columns


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

Ethnicity

@usgov.ca_gov_patient_demographics.ethnicity

3.36 KB
55 rows
3 columns


CREATE TABLE ethnicity (
  "fiscal_year" BIGINT,
  "ethnicity" VARCHAR,
  "patient_counts" BIGINT
);

Ethnicity-Data Dictionary

@usgov.ca_gov_patient_demographics.ethnicity_data_dictionary

3.64 KB
3 rows
4 columns


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

Language Spoken At Home

@usgov.ca_gov_patient_demographics.language_spoken_at_home

3.42 KB
55 rows
3 columns


CREATE TABLE language_spoken_at_home (
  "fiscal_year" BIGINT,
  "language_spoken_at_home" VARCHAR,
  "patient_counts" VARCHAR
);

Language Spoken At Home-Data Dictionary

@usgov.ca_gov_patient_demographics.language_spoken_at_home_data_dictionary

3.63 KB
3 rows
4 columns


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

Level Of Care

@usgov.ca_gov_patient_demographics.level_of_care

3.31 KB
47 rows
3 columns


CREATE TABLE level_of_care (
  "fiscal_year" BIGINT,
  "level_of_care" VARCHAR,
  "count_of_caseid" VARCHAR
);

Level Of Care-Data Dictionary

@usgov.ca_gov_patient_demographics.level_of_care_data_dictionary

3.64 KB
3 rows
4 columns


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

Marital Status

@usgov.ca_gov_patient_demographics.marital_status

3.46 KB
55 rows
3 columns


CREATE TABLE marital_status (
  "fiscal_year" BIGINT,
  "marital_status" VARCHAR,
  "patient_counts" BIGINT
);

Marital Status-Data Dictionary

@usgov.ca_gov_patient_demographics.marital_status_data_dictionary

3.64 KB
3 rows
4 columns


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

Patient Counts By Hospital

@usgov.ca_gov_patient_demographics.patient_counts_by_hospital

3.56 KB
72 rows
3 columns


CREATE TABLE patient_counts_by_hospital (
  "fiscal_year" BIGINT,
  "hospital" VARCHAR,
  "patient_counts" BIGINT
);

Patient Counts By Hospital-Data Dictionary

@usgov.ca_gov_patient_demographics.patient_counts_by_hospital_data_dictionary

3.62 KB
3 rows
4 columns


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

Region

@usgov.ca_gov_patient_demographics.region

3.54 KB
77 rows
3 columns


CREATE TABLE region (
  "years" BIGINT,
  "region" VARCHAR,
  "patient_counts" DOUBLE
);

Region-Data Dictionary

@usgov.ca_gov_patient_demographics.region_data_dictionary

3.54 KB
3 rows
4 columns


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

Sex-Data Dictionary

@usgov.ca_gov_patient_demographics.sex_data_dictionary

3.51 KB
3 rows
4 columns


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

Table 19

@usgov.ca_gov_patient_demographics.table_19

3.04 KB
22 rows
3 columns


CREATE TABLE table_19 (
  "fiscal_year" BIGINT,
  "sex" VARCHAR,
  "patient_counts" BIGINT
);