{ "type": "record", "name": "Root", "fields": [ { "name": "__id", "type": { "type": "string" } }, { "default": null, "name": "total_deductions_from_revenue", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_charity_care", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "number_of_charity_care", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_contractual_adjustments", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "negotiated_rate_", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "workers_comp_", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "medicaid_contractuals", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "provision_for_bad_debt", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_licenses___taxes", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "license_fees", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_insurance_other", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_insurance_malpractice", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_ending_balance", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_38", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_37", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_35", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_34", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_31", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_30", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_29", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_28", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_27", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_26", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_22", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_20", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_18", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_17", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_16", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_15", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_12", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_11", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_10", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_9", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_8", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_6", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_4", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_2", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_1", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_total_ending", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_total_retirememts", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_total_additions", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_total_beginning", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_retirememts_8", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_additions_4", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_beginning_balance_7", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_ending_balance_7", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_retirememts_7", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_additions_3", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_retirememts_6", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_additions_2", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_beginning_balance_5", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_ending_balance_5", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_retirememts_5", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_additions_1", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_ending_balance_4", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_retirememts_4", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_beginning_balance_3", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_ending_balance_3", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_additions_fixed", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_additions", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_beginning_balance_1", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_ending_balance_1", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_additions_land_1", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_retirememts", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_additions_land", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_depreciation", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "equipment_rent_lease", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "building_rent_lease", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_employee_benefits", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "pension___retirement", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "group_life_insurance", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "group_health_insurance", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fica", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "city", "type": [ "null", { "type": "string" } ] }, { "default": null, "name": "hospital_name", "type": [ "null", { "type": "string" } ] }, { "default": null, "name": "other_contractuals", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "other_government_programs", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_interest_expense", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "other_licenses___taxes", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_21", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_13", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_3", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_beginning_balance_2", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_ending_balance_2", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_retirememts_1", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_beginning_balance", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "year", "type": [ "null", { "type": "string" } ] }, { "default": null, "name": "medicare_contractuals_", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_interest_other", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "taxes_other_than_income", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_32", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_25", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_24", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_23", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_19", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_14", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_5", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_ending_balance_8", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_beginning_balance_6", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_additions_fixed_1", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_retirememts_3", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_ending_balance", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "worker_s_compensation", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "other_deductions", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_interest_working_cap", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_insurance", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_33", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_7", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "total_rent_lease", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "other_employee_benefits", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "state_unemployment", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_beginning_balance_4", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "accumulated_depreciation_36", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_retirememts_2", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "license_number", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] }, { "default": null, "name": "fixed_assets_ending_balance_6", "type": [ "null", { "logicalType": "decimal", "precision": 38, "scale": 9, "type": "bytes" } ] } ] }