Click on the title links to download the data. Unzip the folder and place it on your desktop.
Contains the following files:
ca_discipline.csv Disciplinary alerts and actions issued by the Medical Board of California from 2008 to 2017. Processed from downloads available here. Contains the following variables:
alert_dateDate alert issued.
last_nameLast name of doctor/health care provider.
first_nameFirst name of doctor/health care provider.
name_suffixName suffix (Jr., II etc)
cityCity of practive location.
stateState of practice location.
licenseCalifornia medical license number.
action_typeType of action.
action_dateDate of action.
ca_medicare_opioids.csv Data on prescriptions of opioid drugs under the Medicare Part D Prescription Drug Program by doctors in California, from 2013 to 2015. Filtered from the national data downloads available here. It contains many variables, including:
npiNational Provider Identifier (NPI) for the doctor/organization making the claim. This is a unique code for each health care provider.
nppes_provider_last_org_nameFor individual doctors, their last name. For organizations, the organziation name.
nppes_provider_first_nameFirst name for individual doctors, blank for organizations.
nppes_provider_cityCity where the provider is located.
nppes_provider_stateState where the provider is located; “CA” for all of these records.
specialty_descriptionProvider’s medical speciality, reported on their medicare claims. For providers that have more than one Medicare specialty code reported on their claims, the code associated with the largest number of services.
drug_nameIncludes both brand names (drugs that have a trademarked name) and generic names (drugs that do not have a trademarked name).
generic_nameThe chemical ingredient of a drug rather than the trademarked brand name under which the drug is sold.
bene_countTotal number of unique Medicare Part D beneficiaries (i.e. patients) with at least one claim for the drug. Counts fewer than 11 are suppressed and are indicated by a blank.
total_claim_countNumber of Medicare Part D claims; includes original prescriptions and refills. If less than 11, counts are not included in the data file.
total_drug_costTotal cost paid for all associated claims; includes ingredient cost, dispensing fee, sales tax, and any applicable fees.
year2013, 2014, or 2015.
npi_license.csv Crosswalk file to join NPI identifiers to state license numbers, processed from the download available here to include license numbers potentially matching California doctors. This will provide one way of joining the precription data to the medical board disciplinary data. As we shall see, problems with the data mean that it is not infallible. Contains the following variables:
npiNational Provider Identifier, as described above.
plicnumState license number, from the original file.
pclicnumto conform to the format of California medical license numbers.