Dataset: Medicare's Doctor Comparison Scores

About this Dataset

Medicare's Doctor Comparison Scores

The Physician Compare website was created by the Centers for Medicare & Medicaid Services (CMS) in December 2010 as required by the Affordable Care Act (ACA) of 2010 to help patients assess and find doctors and hospitals. This dataset contains the information supplied to patients via that website, including patient satisfaction surveys and performance scores across over 100 metrics.

Acknowledgements

This dataset was kindly released by the Centers for Medicare & Medicaid Services. You can find the original copy of the dataset here.

Tables

Physician Compare 2015 Group Public Reporting Patient, 5f9bd7f5

@kaggle.cms_medicares_doctor_comparison_scores.physician_compare_2015_group_public_reporting_patient__5f9bd7f5

25.21 KB
3432 rows
7 columns


CREATE TABLE physician_compare_2015_group_public_reporting_patient__5f9bd7f5 (
  "organization_legal_name_or_doing_business_as_name" VARCHAR,
  "group_pac_id" BIGINT,
  "n__state" VARCHAR,
  "measure_identifier" VARCHAR,
  "measure_title" VARCHAR,
  "measure_performance_rate" DOUBLE,
  "footnote" DOUBLE
);

Physician Compare 2015 Group Public Reporting Performa 17551025

@kaggle.cms_medicares_doctor_comparison_scores.physician_compare_2015_group_public_reporting_performa_17551025

123.25 KB
11117 rows
11 columns


CREATE TABLE physician_compare_2015_group_public_reporting_performa_17551025 (
  "organization_legal_name_or_doing_business_as_name" VARCHAR,
  "group_pac_id" BIGINT,
  "state" VARCHAR,
  "participating_in_pqrs" VARCHAR,
  "measure_identifier" VARCHAR,
  "measure_title" VARCHAR,
  "inverse_measure" VARCHAR,
  "measure_performance_rate" DOUBLE,
  "footnote" DOUBLE,
  "reporting_mechanism" VARCHAR,
  "reported_on_pc_live_site" VARCHAR
);

Physician Compare 2015 Individual Ep Public Reporting, 15744868

@kaggle.cms_medicares_doctor_comparison_scores.physician_compare_2015_individual_ep_public_reporting__15744868

7.04 MB
495417 rows
10 columns


CREATE TABLE physician_compare_2015_individual_ep_public_reporting__15744868 (
  "npi" BIGINT,
  "pac_id" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "measure_identifier" VARCHAR,
  "measure_title" VARCHAR,
  "inverse_measure" VARCHAR,
  "measure_performance_rate" BIGINT,
  "reporting_mechanism" VARCHAR,
  "reported_on_pc_live_site" VARCHAR
);

Physician Compare National Downloadable File

@kaggle.cms_medicares_doctor_comparison_scores.physician_compare_national_downloadable_file

174.83 MB
2266067 rows
41 columns


CREATE TABLE physician_compare_national_downloadable_file (
  "npi" BIGINT,
  "pac_id" BIGINT,
  "professional_enrollment_id" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_name" VARCHAR,
  "suffix" VARCHAR,
  "gender" VARCHAR,
  "credential" VARCHAR,
  "medical_school_name" VARCHAR,
  "graduation_year" DOUBLE,
  "primary_specialty" VARCHAR,
  "secondary_specialty_1" VARCHAR,
  "secondary_specialty_2" VARCHAR,
  "secondary_specialty_3" VARCHAR,
  "secondary_specialty_4" VARCHAR,
  "all_secondary_specialties" VARCHAR,
  "organization_legal_name" VARCHAR,
  "group_practice_pac_id" DOUBLE,
  "number_of_group_practice_members" DOUBLE,
  "line_1_street_address" VARCHAR,
  "line_2_street_address" VARCHAR,
  "marker_of_address_line_2_suppression" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "phone_number" VARCHAR,
  "hospital_affiliation_ccn_1" DOUBLE,
  "hospital_affiliation_lbn_1" VARCHAR,
  "hospital_affiliation_ccn_2" VARCHAR,
  "hospital_affiliation_lbn_2" VARCHAR,
  "hospital_affiliation_ccn_3" VARCHAR,
  "hospital_affiliation_lbn_3" VARCHAR,
  "hospital_affiliation_ccn_4" VARCHAR,
  "hospital_affiliation_lbn_4" VARCHAR,
  "hospital_affiliation_ccn_5" DOUBLE,
  "hospital_affiliation_lbn_5" VARCHAR,
  "professional_accepts_medicare_assignment" VARCHAR,
  "reported_quality_measures" VARCHAR,
  "used_electronic_health_records" VARCHAR,
  "committed_to_heart_health_through_the_million_hearts_i_527c387a" VARCHAR
);