About this Dataset

Ambulatory Surgery - Characteristics By Patient County Of Residence

This dataset contains annual ambulatory surgery summary data based upon the Patient’s County of Residence. The summary data includes discharge disposition, expected payer, sex, and race group. Physician-owned ambulatory surgery clinics do not report their data to HCAI and, therefore, are not included in the frequencies.
Organization: State of California
Last updated: 2024-11-26T22:28:05.000159
Tags: ambulatory-surgery, as, department-of-health-care-access-and-information, disposition, expected-payer, gender, hcai, hospital, outpatient-surgery, patient-county, race-group, sex

Tables

Ambulatory Surgery Characteristics – Disposition By Patient County Of Residence

@usgov.ca_gov_ambulatory_surgery_characteristics_by_patient_c_34f71094.ambulatory_surgery_characteristics_disposition_by_pati_a65eb492

6.76 kB
683 rows
4 columns

CREATE TABLE ambulatory_surgery_characteristics_disposition_by_pati_a65eb492 (
  "patcnty1" VARCHAR,
  "serv_y" BIGINT,
  "disp1" VARCHAR,
  "encounters" BIGINT
);

Ambulatory Surgery Characteristics – Expected Payer By Patient County Of Residence

@usgov.ca_gov_ambulatory_surgery_characteristics_by_patient_c_34f71094.ambulatory_surgery_characteristics_expected_payer_by_p_cf9a43d5

8.84 kB
1,014 rows
4 columns

CREATE TABLE ambulatory_surgery_characteristics_expected_payer_by_p_cf9a43d5 (
  "patcnty1" VARCHAR,
  "serv_y" BIGINT,
  "payer1" VARCHAR,
  "encounters" BIGINT
);

Ambulatory Surgery Characteristics – Race Group By Patient County Of Residence

@usgov.ca_gov_ambulatory_surgery_characteristics_by_patient_c_34f71094.ambulatory_surgery_characteristics_race_group_by_patie_8f0f5d61

8.75 kB
552 rows
6 columns

CREATE TABLE ambulatory_surgery_characteristics_race_group_by_patie_8f0f5d61 (
  "patcnty1" VARCHAR,
  "serv_y" BIGINT,
  "race_grp1" VARCHAR,
  "encounters" DOUBLE,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);

Ambulatory Surgery Characteristics – Sex By Patient County Of Residence

@usgov.ca_gov_ambulatory_surgery_characteristics_by_patient_c_34f71094.ambulatory_surgery_characteristics_sex_by_patient_coun_9a6fe26d

6.33 kB
161 rows
6 columns

CREATE TABLE ambulatory_surgery_characteristics_sex_by_patient_coun_9a6fe26d (
  "patcnty1" VARCHAR,
  "serv_y" BIGINT,
  "gender" VARCHAR,
  "encounters" BIGINT,
  "annotationcode" VARCHAR,
  "annotationdesc" VARCHAR
);