Baselight
Sign In

Skilled Nursing Facility Cost Report

U.S. Department of Health & Human Services

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7

Loading...
Loading...

About this Dataset

Skilled Nursing Facility Cost Report

The Skilled Nursing Facility (SNF) Cost Report dataset is a public use file that provides select measures from the skilled nursing facility 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:56:49.641513
Tags: financials, health-care-use-payments, hospitals-facilities, medicare, original-medicare, skilled-nursing, value-based-care

Tables

Skilled Nursing Facility Cost Report : 2022-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2022_12_02
  • 6.21 MB
  • 14960 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2022_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" DOUBLE,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" DOUBLE,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" DOUBLE,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" VARCHAR,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2021-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2021_12_02
  • 6.23 MB
  • 15069 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2021_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" DOUBLE,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" DOUBLE,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" DOUBLE,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" VARCHAR,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2020-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2020_12_02
  • 6.22 MB
  • 14955 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2020_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" VARCHAR,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" VARCHAR,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" VARCHAR,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" VARCHAR,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" VARCHAR,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2019-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2019_12_02
  • 6.31 MB
  • 15185 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2019_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" VARCHAR,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" VARCHAR,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" VARCHAR,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2018-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2018_12_02
  • 6.28 MB
  • 15143 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2018_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" VARCHAR,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" VARCHAR,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" VARCHAR,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2017-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2017_12_02
  • 6.4 MB
  • 15437 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2017_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" DOUBLE,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" DOUBLE,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" DOUBLE,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2016-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2016_12_02
  • 6.23 MB
  • 15107 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2016_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" DOUBLE,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" DOUBLE,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" DOUBLE,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2015-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2015_12_02
  • 6.33 MB
  • 15404 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2015_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" VARCHAR,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" DOUBLE,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" DOUBLE,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" DOUBLE,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2014-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2014_12_02
  • 6.17 MB
  • 14953 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2014_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" VARCHAR,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" DOUBLE,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" DOUBLE,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" DOUBLE,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2013-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2013_12_02
  • 6.11 MB
  • 14709 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2013_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" DOUBLE,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" DOUBLE,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" DOUBLE,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2012-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2012_12_02
  • 6.1 MB
  • 14687 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2012_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" DOUBLE,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" DOUBLE,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" DOUBLE,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" DOUBLE,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Skilled Nursing Facility Cost Report : 2011-12-02

@usgov.hhs_gov_skilled_nursing_facility_cost_report_cd2b7.skilled_nursing_facility_cost_report_2011_12_02
  • 5.38 MB
  • 12839 rows
  • 122 columns
Loading... 

CREATE TABLE skilled_nursing_facility_cost_report_2011_12_02 (
  "rpt_rec_num" BIGINT,
  "provider_ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" VARCHAR,
  "county" VARCHAR,
  "medicare_cbsa_number" VARCHAR,
  "rural_versus_urban" VARCHAR,
  "fiscal_year_begin_date" TIMESTAMP,
  "fiscal_year_end_date" TIMESTAMP,
  "type_of_control" DOUBLE,
  "total_days_title_v" DOUBLE,
  "total_days_title_xviii" DOUBLE,
  "total_days_title_xix" DOUBLE,
  "total_days_other" DOUBLE,
  "total_days_total" 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_title_other" DOUBLE,
  "total_discharges_total" DOUBLE,
  "snf_average_length_of_stay_title_v" DOUBLE,
  "snf_average_length_of_stay_title_xviii" DOUBLE,
  "snf_average_length_of_stay_title_xix" DOUBLE,
  "snf_average_length_of_stay_total" DOUBLE,
  "snf_admissions_title_v" DOUBLE,
  "snf_admissions_title_xviii" DOUBLE,
  "snf_admissions_title_xix" DOUBLE,
  "snf_admissions_other" DOUBLE,
  "snf_admissions_total" DOUBLE,
  "snf_days_title_v" DOUBLE,
  "snf_days_title_xviii" DOUBLE,
  "snf_days_title_xix" DOUBLE,
  "snf_days_other" DOUBLE,
  "snf_days_total" DOUBLE,
  "snf_number_of_beds" DOUBLE,
  "snf_bed_days_available" DOUBLE,
  "snf_discharges_title_v" DOUBLE,
  "snf_discharges_title_xviii" DOUBLE,
  "snf_discharges_title_xix" DOUBLE,
  "snf_discharges_title_other" DOUBLE,
  "snf_discharges_total" DOUBLE,
  "nf_number_of_beds" DOUBLE,
  "nf_bed_days_available" DOUBLE,
  "nf_days_title_v" DOUBLE,
  "nf_days_title_xix" DOUBLE,
  "nf_days_other" DOUBLE,
  "nf_days_total" DOUBLE,
  "nf_discharges_title_v" DOUBLE,
  "nf_discharges_title_xix" DOUBLE,
  "nf_discharges_title_other" DOUBLE,
  "nf_discharges_total" DOUBLE,
  "nf_average_length_of_stay_title_v" DOUBLE,
  "nf_average_length_of_stay_title_xix" DOUBLE,
  "nf_average_length_of_stay_total" DOUBLE,
  "nf_admissions_title_v" DOUBLE,
  "nf_admissions_title_xix" DOUBLE,
  "nf_admissions_other" DOUBLE,
  "nf_admissions_total" DOUBLE,
  "total_rug_days" DOUBLE,
  "total_salaries_from_worksheet_a" DOUBLE,
  "overhead_non_salary_costs" DOUBLE,
  "total_charges" DOUBLE,
  "total_costs" DOUBLE,
  "wage_related_costs_core" DOUBLE,
  "total_salaries_adjusted" DOUBLE,
  "contract_labor" 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,
  "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
);

Share link

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