Hospital Annual Financial Data - Selected Data & Pivot Tables
State of California
@usgov.ca_gov_hospital_annual_financial_selected_pivot_tables_92074
State of California
@usgov.ca_gov_hospital_annual_financial_selected_pivot_tables_92074
CREATE TABLE n_2012_2017_cy_hospital_annual_selected_machine_readab_f3c9bd18 (
"fac_no" BIGINT,
"fac_name" VARCHAR,
"beg_date" VARCHAR,
"end_date" VARCHAR,
"day_per" BIGINT,
"data_ind" VARCHAR,
"audit_ind" VARCHAR,
"county" VARCHAR,
"hsa" BIGINT,
"hfpa" BIGINT,
"type_cntrl" VARCHAR,
"type_care" VARCHAR,
"type_hosp" VARCHAR,
"teach_rurl" VARCHAR,
"phone" VARCHAR,
"address" VARCHAR,
"city" VARCHAR,
"zip_code" VARCHAR,
"ceo" VARCHAR,
"ceo_title" VARCHAR,
"web_site" VARCHAR,
"owner" VARCHAR,
"rpt_prep" VARCHAR,
"org_name" VARCHAR,
"er_desig" DOUBLE,
"mcar_pro" VARCHAR,
"mcal_pro" VARCHAR,
"reg_mcal" VARCHAR,
"bed_lic" DOUBLE,
"bed_avl" DOUBLE,
"bed_stf" DOUBLE,
"variable" VARCHAR,
"amount" DOUBLE,
"web_site_26adaa" VARCHAR,
"org_name_079c89" VARCHAR
);
Anyone who has the link will be able to view this.