Accountable Care Organization Skilled Nursing Facility Affiliates
U.S. Department of Health & Human Services
@usgov.hhs_gov_accountable_care_organization_skilled_nursing__e39d63c4
U.S. Department of Health & Human Services
@usgov.hhs_gov_accountable_care_organization_skilled_nursing__e39d63c4
The Accountable Care Organization (ACO) Skilled Nursing Facility (SNF) Affiliates data presents overview information on ACO SNF affiliates in the Medicare Shared Savings Program (Shared Savings Program), including their name, track status, number of years in the program, and contact information of key personnel.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:23:22.617137
Tags: accountable-care-organizations, coordinated-care, medicare, payment-models, value-based-care
CREATE TABLE accountable_care_organization_skilled_nursing_facility_3816725d (
"aco_id" VARCHAR,
"aff_lbn" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"re_entering_aco" BIGINT,
"basic_track" BIGINT,
"basic_track_level" VARCHAR,
"enhanced_track" BIGINT,
"high_revenue_aco" BIGINT,
"low_revenue_aco" BIGINT,
"adv_pay" BIGINT,
"aim" BIGINT,
"snf_3_day_rule_waiver" BIGINT,
"prospective_assignment" BIGINT,
"retrospective_assignment" BIGINT,
"aco_address" VARCHAR,
"aco_public_reporting_website" VARCHAR,
"aco_exec_name" VARCHAR,
"aco_exec_email" VARCHAR,
"aco_exec_phone" VARCHAR,
"aco_public_name" VARCHAR,
"aco_public_email" VARCHAR,
"aco_public_phone" VARCHAR,
"aco_compliance_contact_name" VARCHAR,
"aco_medical_director_name" VARCHAR
);CREATE TABLE accountable_care_organization_skilled_nursing_facility_b2b0be16 (
"aco_id" VARCHAR,
"aff_lbn" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"re_entering_aco" BIGINT,
"basic_track" BIGINT,
"basic_track_level" VARCHAR,
"enhanced_track" BIGINT,
"high_revenue_aco" BIGINT,
"low_revenue_aco" BIGINT,
"adv_pay" BIGINT,
"aim" BIGINT,
"aip" BIGINT,
"snf_3_day_rule_waiver" BIGINT,
"prospective_assignment" BIGINT,
"retrospective_assignment" BIGINT,
"aco_address" VARCHAR,
"aco_public_reporting_website" VARCHAR,
"aco_exec_name" VARCHAR,
"aco_exec_email" VARCHAR,
"aco_exec_phone" VARCHAR,
"aco_public_name" VARCHAR,
"aco_public_email" VARCHAR,
"aco_public_phone" VARCHAR,
"aco_compliance_contact_name" VARCHAR,
"aco_medical_director_name" VARCHAR,
"pc_flex_agreement_status" BIGINT
);CREATE TABLE accountable_care_organization_skilled_nursing_facility_b65dd18d (
"aco_id" VARCHAR,
"aff_lbn" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"re_entering_aco" BIGINT,
"basic_track" BIGINT,
"basic_track_level" VARCHAR,
"enhanced_track" BIGINT,
"high_revenue_aco" BIGINT,
"low_revenue_aco" BIGINT,
"adv_pay" BIGINT,
"aim" BIGINT,
"aip" BIGINT,
"snf_3_day_rule_waiver" BIGINT,
"prospective_assignment" BIGINT,
"retrospective_assignment" BIGINT,
"aco_address" VARCHAR,
"aco_public_reporting_website" VARCHAR,
"aco_exec_name" VARCHAR,
"aco_exec_email" VARCHAR,
"aco_exec_phone" VARCHAR,
"aco_public_name" VARCHAR,
"aco_public_email" VARCHAR,
"aco_public_phone" VARCHAR,
"aco_compliance_contact_name" VARCHAR,
"aco_medical_director_name" VARCHAR
);CREATE TABLE accountable_care_organization_skilled_nursing_facility_fdd42de9 (
"aco_id" VARCHAR,
"aff_lbn" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"re_entering_aco" BIGINT,
"basic_track" BIGINT,
"basic_track_level" VARCHAR,
"enhanced_track" BIGINT,
"high_revenue_aco" BIGINT,
"low_revenue_aco" BIGINT,
"adv_pay" BIGINT,
"aim" BIGINT,
"snf_3_day_rule_waiver" BIGINT,
"prospective_assignment" BIGINT,
"retrospective_assignment" BIGINT,
"aco_address" VARCHAR,
"aco_public_reporting_website" VARCHAR,
"aco_exec_name" VARCHAR,
"aco_exec_email" VARCHAR,
"aco_exec_phone" VARCHAR,
"aco_public_name" VARCHAR,
"aco_public_email" VARCHAR,
"aco_public_phone" VARCHAR,
"aco_compliance_contact_name" VARCHAR,
"aco_medical_director_name" VARCHAR
);Anyone who has the link will be able to view this.