Name: Medicare's Doctor Comparison Scores
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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.82 kB
3,432 rows
7 columns

CREATE TABLE physician_compare_2015_group_public_reporting_patient__5f9bd7f5 (
  "organization_legal_name_or_doing_business_as_name" VARCHAR  -- Organization Legal Name Or \u0027doing Business As\u0027 Name,
  "group_pac_id" BIGINT,
  "n__state" VARCHAR  -- State,
  "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

126.2 kB
11,117 rows
11 columns

CREATE TABLE physician_compare_2015_group_public_reporting_performa_17551025 (
  "organization_legal_name_or_doing_business_as_name" VARCHAR  -- Organization Legal Name Or \u0027doing Business As\u0027 Name,
  "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.38 MB
495,417 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

183.32 MB
2,266,067 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  -- Committed To Heart Health Through The Million Hearts® Initiative.
);