Accountable Care Organizations
U.S. Department of Health & Human Services
@usgov.hhs_gov_accountable_care_organizations_d0f82
U.S. Department of Health & Human Services
@usgov.hhs_gov_accountable_care_organizations_d0f82
CREATE TABLE accountable_care_organizations_2025_02_01 (
"aco_id" 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,
"lat" DOUBLE,
"long" DOUBLE,
"pc_flex_agreement_status" BIGINT
);
CREATE TABLE accountable_care_organizations_2024_01_24 (
"aco_id" 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,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2023_01_13 (
"aco_id" 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,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2022_01_01 (
"aco_id" 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,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2021_01_11 (
"aco_id" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"re_entering_acos" BIGINT,
"track_1" BIGINT,
"track_1_ff3800" BIGINT,
"track_2" 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,
"aco_zip" BIGINT,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2020_01_07 (
"aco_id" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"track_1" BIGINT,
"track_1_ff3800" BIGINT,
"track_2" 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,
"aco_zip" BIGINT,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2019_07_31oc1 (
"aco_id" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"track_1" BIGINT,
"track_1_ff3800" BIGINT,
"track_2" BIGINT,
"enhanced_track" BIGINT,
"basic_track" BIGINT,
"basic_track_level" VARCHAR,
"high_revenue_aco" BIGINT,
"low_revenue_aco" BIGINT,
"adv_pay" BIGINT,
"aim" BIGINT,
"snf_3_day_rule_waiver" 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,
"aco_zip" BIGINT,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2019_01_01 (
"aco_id" VARCHAR,
"aco_num" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"track_1" BIGINT,
"track_1_ff3800" BIGINT,
"track_2" BIGINT,
"track_3" BIGINT,
"adv_pay" BIGINT,
"aim" BIGINT,
"snf_3_day_rule_waiver" 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,
"aco_zip" BIGINT,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2018_01_01 (
"aco_id" VARCHAR,
"aco_num" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"aco_agreement_type" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"track_1" BIGINT,
"track_1_ff3800" BIGINT,
"track_2" BIGINT,
"track_3" BIGINT,
"adv_pay" BIGINT,
"aim" BIGINT,
"snf_3_day_rule_waiver" 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_zip" BIGINT,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2017_01_01 (
"aco_id" VARCHAR,
"aco_num" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"aco_agreement_type" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"track_1" BIGINT,
"track_2" BIGINT,
"track_3" BIGINT,
"adv_pay" BIGINT,
"aim" BIGINT,
"snf_3_day_rule_waiver" 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_zip" BIGINT,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2016_12_31 (
"aco_id" VARCHAR,
"aco_num" VARCHAR,
"aco_name" VARCHAR,
"aco_service_area" VARCHAR,
"aco_agreement_type" VARCHAR,
"agreement_period_num" BIGINT,
"initial_start_date" TIMESTAMP,
"current_start_date" TIMESTAMP,
"track_1" BIGINT,
"track_2" BIGINT,
"track_3" BIGINT,
"adv_pay" BIGINT,
"aim" 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_zip" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2015_12_31 (
"aco_name" VARCHAR,
"aco_address" VARCHAR,
"aco_service_area" VARCHAR,
"aco_website_address" VARCHAR,
"aco_executive_name" VARCHAR,
"aco_executive_email" VARCHAR,
"aco_executive_phone" VARCHAR,
"public_contact_name" VARCHAR,
"public_contact_email" VARCHAR,
"public_contact_phone" VARCHAR,
"aco_zip" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE
);
CREATE TABLE accountable_care_organizations_2014_12_31 (
"aco_name" VARCHAR,
"aco_address" VARCHAR,
"aco_service_area" VARCHAR,
"aco_website_address" VARCHAR,
"aco_executive_name" VARCHAR,
"aco_executive_email" VARCHAR,
"aco_executive_phone" VARCHAR,
"aco_public_contact_name" VARCHAR,
"aco_public_contact_email" VARCHAR,
"aco_public_contact_phone" VARCHAR
);
Anyone who has the link will be able to view this.