About this Dataset

Hospital Staffing, 2009-2013

The dataset contains hours worked by hospital employee classification and by hospital cost center groupings, as well as adjusted patient days for all licensed, comparable hospitals in California. State mental hospitals and psychiatric health facilities are excluded.
Organization: State of California
Last updated: 2024-03-30T04:37:08.858968
Tags: department-of-health-care-access-and-information, hospital, hours, licensed-nurses, registered-nurses, staffing

Tables

Table 1

@usgov.ca_gov_hospital_staffing_2009_2013_fcc36.table_1

302.69 kB
37,604 rows
10 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "facility_number" DOUBLE,
  "facility_name" VARCHAR,
  "begin_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "county_name" VARCHAR,
  "type_of_control" VARCHAR,
  "hours_type" VARCHAR,
  "productive_hours" BIGINT,
  "productive_hours_per_adjusted_patient_day" DOUBLE
);