Accountable Care Organization Participants
U.S. Department of Health & Human Services
@usgov.hhs_gov_accountable_care_organization_participants_4940d
U.S. Department of Health & Human Services
@usgov.hhs_gov_accountable_care_organization_participants_4940d
CREATE TABLE accountable_care_organization_participants_2024_01_24 (
"aco_id" VARCHAR,
"par_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_participants_2023_01_13 (
"aco_id" VARCHAR,
"par_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_participants_2022_01_01 (
"aco_id" VARCHAR,
"par_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.