Baselight
Sign In

Hospital Provider Cost Report

U.S. Department of Health & Human Services

@usgov.hhs_gov_hospital_provider_cost_report

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-02-03T21:51:39.328727
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.hospital_provider_cost_report_2011_12_02
  • 3.22 MB
  • 6150 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2012_12_02
  • 3.26 MB
  • 6227 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2013_12_02
  • 3.28 MB
  • 6248 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2014_12_02
  • 3.27 MB
  • 6250 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2015_12_02
  • 3.27 MB
  • 6257 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2016_12_02
  • 3.24 MB
  • 6211 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2017_12_02
  • 3.21 MB
  • 6174 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2018_12_02
  • 3.22 MB
  • 6160 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2019_12_02
  • 3.19 MB
  • 6121 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2020_12_02
  • 3.16 MB
  • 6059 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.hospital_provider_cost_report_2021_12_02
  • 3.15 MB
  • 6053 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,
  "number_of_interns_and_residents_fte" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_v_xviii_xix_unknown" DOUBLE,
  "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,
  "number_of_beds_total_for_all_subproviders" DOUBLE,
  "hospital_total_days_title_v_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_days_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_days_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "hospital_number_of_beds_for_adults_peds" DOUBLE,
  "hospital_total_bed_days_available_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_v_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xviii_for_adults_peds" DOUBLE,
  "hospital_total_discharges_title_xix_for_adults_peds" DOUBLE,
  "hospital_total_discharges_v_xviii_xix_unknown_for_adults_peds" DOUBLE,
  "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,
  "wage_related_costs_core" DOUBLE,
  "wage_related_costs_rhc_fqhc" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor_direct_patient_care" DOUBLE,
  "wage_related_costs_for_part_a_teaching_physicians" DOUBLE,
  "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,
  "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,
  "payroll_taxes_payable" DOUBLE,
  "notes_and_loans_payable_short_term" DOUBLE,
  "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.