Baselight
Sign In

Hospital Provider Cost Report

U.S. Department of Health & Human Services

@usgov.hhs_gov_hospital_provider_cost_report_7c92c

Loading...
Loading...

About this Dataset

Hospital Provider Cost Report

The Hospital Provider Cost Report dataset provides select measures from the hospital annual cost report. This data includes provider information such as facility characteristics, utilization data, cost and charges by cost center (in total and for Medicare), Medicare settlement data, and financial statement data organized by CMS Certification Number.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:25:27.479528
Tags: financials, health-care-use-payments, hospitals-facilities, inpatient, medicare, original-medicare, value-based-care

Tables

Hospital Provider Cost Report : 2011-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2011_12_02
  • 3.38 MB
  • 6,150 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2011_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" DOUBLE,
  "drg_amounts_before_october_1" VARCHAR,
  "drg_amounts_after_october_1" VARCHAR,
  "outlier_payments_for_discharges" DOUBLE,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2012-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2012_12_02
  • 3.41 MB
  • 6,227 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2012_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" DOUBLE,
  "drg_amounts_before_october_1" VARCHAR,
  "drg_amounts_after_october_1" VARCHAR,
  "outlier_payments_for_discharges" DOUBLE,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2013-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2013_12_02
  • 3.44 MB
  • 6,248 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2013_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" DOUBLE,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" DOUBLE,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2014-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2014_12_02
  • 3.43 MB
  • 6,250 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2014_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" VARCHAR,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" DOUBLE,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2015-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2015_12_02
  • 3.43 MB
  • 6,257 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2015_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" VARCHAR,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" DOUBLE,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2016-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2016_12_02
  • 3.4 MB
  • 6,211 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2016_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" VARCHAR,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" DOUBLE,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2017-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2017_12_02
  • 3.37 MB
  • 6,174 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2017_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" VARCHAR,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" DOUBLE,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2018-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2018_12_02
  • 3.37 MB
  • 6,160 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2018_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" VARCHAR,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" DOUBLE,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2019-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2019_12_02
  • 3.34 MB
  • 6,121 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2019_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" VARCHAR,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" VARCHAR,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2020-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2020_12_02
  • 3.32 MB
  • 6,059 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2020_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" VARCHAR,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" VARCHAR,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2021-12-02

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2021_12_02
  • 3.31 MB
  • 6,053 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2021_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" VARCHAR,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" VARCHAR,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Hospital Provider Cost Report : 2022-12-01

@usgov.hhs_gov_hospital_provider_cost_report_7c92c.hospital_provider_cost_report_2022_12_01
  • 3.32 MB
  • 6,064 rows
  • 117 columns
Loading... 
CREATE TABLE hospital_provider_cost_report_2022_12_01 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "hospital_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "ccn_facility_type" VARCHAR,
  "provider_type" BIGINT,
  "type_of_control" BIGINT,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "fte_employees_on_payroll" DOUBLE  -- FTE - Employees On Payroll,
  "number_of_interns_and_residents_fte" DOUBLE  -- Number Of Interns And Residents (FTE),
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE  -- Total Days (V + XVIII + XIX + Unknown),
  "number_of_beds" DOUBLE,
  "total_bed_days_available" DOUBLE,
  "total_discharges_title_v" DOUBLE,
  "total_discharges_title_xviii" DOUBLE,
  "total_discharges_title_xix" DOUBLE,
  "total_discharges_v_xviii_xix_unknown" DOUBLE  -- Total Discharges (V + XVIII + XIX + Unknown),
  "number_of_beds_total_for_all_subproviders" DOUBLE  -- Number Of Beds + Total For All Subproviders,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE  -- Hospital Total Days Title V For Adults & Peds,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Days Title XVIII For Adults & Peds,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Days Title XIX For Adults & Peds,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Days (V + XVIII + XIX + Unknown) For Adults & Peds,
  "hospital_number_of_beds_for_adults_peds" DOUBLE  -- Hospital Number Of Beds For Adults & Peds,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE  -- Hospital Total Bed Days Available For Adults & Peds,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title V For Adults & Peds,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XVIII For Adults & Peds,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE  -- Hospital Total Discharges Title XIX For Adults & Peds,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE  -- Hospital Total Discharges (V + XVIII + XIX + Unknown) For Adults & Peds,
  "cost_of_charity_care" DOUBLE,
  "total_bad_debt_expense" DOUBLE,
  "cost_of_uncompensated_care" DOUBLE,
  "total_unreimbursed_and_uncompensated_care" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "depreciation_cost" DOUBLE,
  "total_costs" DOUBLE,
  "inpatient_total_charges" DOUBLE,
  "outpatient_total_charges" DOUBLE,
  "combined_outpatient_inpatient_total_charges" DOUBLE  -- Combined Outpatient + Inpatient Total Charges,
  "wage_related_costs_core" DOUBLE  -- Wage-Related Costs (Core),
  "wage_related_costs_rhc_fqhc" DOUBLE  -- Wage-Related Costs (RHC/FQHC),
  "total_salaries_adjusted" DOUBLE  -- Total Salaries (adjusted),
  "contract_labor_direct_patient_care" DOUBLE  -- Contract Labor: Direct Patient Care,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE  -- Wage Related Costs For Part - A Teaching Physicians,
  "wage_related_costs_for_interns_and_residents" DOUBLE,
  "cash_on_hand_and_in_banks" DOUBLE,
  "temporary_investments" DOUBLE,
  "notes_receivable" DOUBLE,
  "accounts_receivable" DOUBLE,
  "less_allowances_for_uncollectible_notes_and_accounts_receivable" DOUBLE  -- Less: Allowances For Uncollectible Notes And Accounts Receivable,
  "inventory" DOUBLE,
  "prepaid_expenses" DOUBLE,
  "other_current_assets" DOUBLE,
  "total_current_assets" DOUBLE,
  "land" DOUBLE,
  "land_improvements" DOUBLE,
  "buildings" DOUBLE,
  "leasehold_improvements" DOUBLE,
  "fixed_equipment" DOUBLE,
  "major_movable_equipment" DOUBLE,
  "minor_equipment_depreciable" DOUBLE,
  "health_information_technology_designated_assets" DOUBLE,
  "total_fixed_assets" DOUBLE,
  "investments" DOUBLE,
  "other_assets" DOUBLE,
  "total_other_assets" DOUBLE,
  "total_assets" DOUBLE,
  "accounts_payable" DOUBLE,
  "salaries_wages_and_fees_payable" DOUBLE  -- Salaries, Wages, And Fees Payable,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE  -- Notes And Loans Payable (Short Term),
  "deferred_income" DOUBLE,
  "other_current_liabilities" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "mortgage_payable" DOUBLE,
  "notes_payable" DOUBLE,
  "unsecured_loans" DOUBLE,
  "other_long_term_liabilities" DOUBLE,
  "total_long_term_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "general_fund_balance" DOUBLE,
  "total_fund_balances" DOUBLE,
  "total_liabilities_and_fund_balances" DOUBLE,
  "drg_amounts_other_than_outlier_payments" VARCHAR,
  "drg_amounts_before_october_1" DOUBLE,
  "drg_amounts_after_october_1" DOUBLE,
  "outlier_payments_for_discharges" VARCHAR,
  "disproportionate_share_adjustment" DOUBLE,
  "allowable_dsh_percentage" DOUBLE,
  "managed_care_simulated_payments" DOUBLE
);

Share link

Anyone who has the link will be able to view this.