Data Catalog
Welcome to the Data Catalog, where you'll find an overview of all datasets currently ingested in the mimi_ws_1
workspace,
which operates as our data lakehouse.
In most cases, we have preserved the original table formats from the source systems.
However, we’ve made a few adjustments to ensure consistency and clarity.
For example, all column names have been transformed to follow the snake case naming convention.
This means spaces and special characters are replaced with underscores, and all letters are lowercase.
For instance, a column like Provider Name is now standardized as provider_name.
Please see the Data Engineering section for more information.
Data Sources and Tables. Below is a comprehensive list of the data sources and tables available within the mimi_ws_1
workspace:
AHRQ - mimi_ws_1.ahrq
- Description: Datasets from Agency for Healthcare Research and Quality (AHRQ)
- Tables:
compendium_grouppractice_linkage
: Compendium of U.S. Health Systems - Group Practice Linkage - multiyearcompendium_homehealth_linkage
: Compendium of U.S. Health Systems - Home Health Linkage - multiyearcompendium_hospital_linkage
: Compendium of U.S. Health Systems - Hospital Linkage - multiyearcompendium_nursinghome_linkage
: Compendium of U.S. Health Systems - Nursing Home Linkage - multiyearcompendium_outpatient_linkage
: Compendium of U.S. Health Systems - Outpatient Linkage - multiyearcompendium_us_health_systems
: Compendium of U.S. Health Systems - multiyearmeps_consol_label_dictionary
: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Consolidated Files; Variable Values and Descriptionsmeps_consol_metadata
: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Consolidated Files Metadata; Variable Names and Descriptionsmeps_event_dentalvisits
: MEPS HC Event Files Dental Visits - multiyear, 2015-2022meps_event_ervisits
: MEPS HC Event Files Emergency Room Visits - multiyear, 2015-2022meps_event_homehealth
: MEPS HC Event Files Home Health - multiyear, 2015-2022meps_event_inpatientstays
: MEPS HC Event Files Inpatient Stays - multiyear, 2015-2022meps_event_label_dictionary
: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Event Files; Variable Values and Descriptionsmeps_event_metadata
: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Event Files Metadata; Variable Names and Descriptionsmeps_event_officevisits
: MEPS HC Event Files Office-based Visits - multiyear, 2015-2022meps_event_othermedicalexp
: MEPS HC Event Files Other Medical Expenditures - multiyear, 2015-2022meps_event_outpatientvisits
: MEPS HC Event Files Outpatient Visits - multiyearmeps_event_prescribedmeds
: MEPS HC Event Files Prescribed Medicines - multiyear, 2015-2022meps_fyc
: MEPS HC Full Year Consolidated Files - multiyear, 2015-2021sdohdb_county
: SDoH Database at county-level - multiyearsdohdb_tract
: SDoH Database at tract-level - multiyearsdohdb_zipcode
: SDoH Database at ZIP-level - multiyear
CDC - mimi_ws_1.cdc
- Description: Datasets from the Centers for Disease Control and Prevention (CDC)
- Tables:
nhanes_demo_demographic_variables_sample_weights
: CDC NHANES DEMO Demographic Variables & Sample Weightsnhanes_exam_blood_pressure
: CDC NHANES EXAM Blood Pressurenhanes_exam_body_measures
: CDC NHANES EXAM Body Measuresnhanes_lab_albumin_creatinine_urine
: CDC NHANES LAB Albumin & Creatinine - Urinenhanes_lab_alpha1acid_glycoprotein_serum_surplus
: CDC NHANES LAB Alpha-1-Acid Glycoprotein - Serum (Surplus)nhanes_lab_cholesterol_hdl
: CDC NHANES LAB Cholesterol - HDLnhanes_lab_cholesterol_ldl_triglycerides
: CDC NHANES LAB Cholesterol - LDL & Triglyceridesnhanes_lab_cholesterol_total
: CDC NHANES LAB Cholesterol - Totalnhanes_lab_fasting_questionnaire
: CDC NHANES LAB Fasting Questionnairenhanes_lab_glycohemoglobin
: CDC NHANES LAB Glycohemoglobinnhanes_lab_glyphosate_glyp_urine
: CDC NHANES LAB Glyphosate (GLYP) - Urinenhanes_lab_highsensitivity_creactive_protein
: CDC NHANES LAB High-Sensitivity C-Reactive Proteinnhanes_lab_insulin
: CDC NHANES LAB Insulinnhanes_lab_oral_glucose_tolerance_test
: CDC NHANES LAB Oral Glucose Tolerance Testnhanes_lab_plasma_fasting_glucose
: CDC NHANES LAB Plasma Fasting Glucosenhanes_lab_standard_biochemistry_profile
: CDC NHANES LAB Standard Biochemistry Profilenhanes_metadata
: National Health and Nutrition Examination Survey (NHANES) Metadatanhanes_mortality
: CDC NHANES Mortality Datasetnhanes_qre_acculturation
: CDC NHANES QRE Acculturationnhanes_qre_air_quality
: CDC NHANES QRE Air Qualitynhanes_qre_alcohol_use
: CDC NHANES QRE Alcohol Usenhanes_qre_blood_pressure_cholesterol
: CDC NHANES QRE Blood Pressure & Cholesterolnhanes_qre_bowel_health
: CDC NHANES QRE Bowel Healthnhanes_qre_cardiovascular_health
: CDC NHANES QRE Cardiovascular Healthnhanes_qre_diabetes
: CDC NHANES QRE Diabetesnhanes_qre_hospital_utilization_access_to_care
: CDC NHANES QRE Hospital Utilization & Access to Carenhanes_qre_income
: CDC NHANES QRE Incomenhanes_qre_kidney_conditions
: CDC NHANES QRE Kidney Conditionsnhanes_qre_medical_conditions
: CDC NHANES QRE Medical Conditionsnhanes_qre_preventive_aspirin_use
: CDC NHANES QRE Preventive Aspirin Usenhanes_qre_smoking_adult_recent_tobacco_use_youth_cigarettetobacco_use
: CDC NHANES QRE Smoking - Adult Recent Tobacco Use & Youth Cigarette/Tobacco Usenhanes_qre_smoking_cigarette_use
: CDC NHANES QRE Smoking - Cigarette Usenhanes_qre_smoking_household_smokers
: CDC NHANES QRE Smoking - Household Smokersnhanes_qre_smoking_recent_tobacco_use
: CDC NHANES QRE Smoking - Recent Tobacco Usenndss
: National Notifiable Diseases Surveillance System (NNDSS)nwss_covid
: National Wastewater Surveillance System (NWSS) for Covidnwss_mpox
: National Wastewater Surveillance System (NWSS) for Mpoxplaces_censustract
: PLACES: Local Data for Better Health - censustract-level, multiyearplaces_county
: PLACES: Local Data for Better Health - county-level, multiyearplaces_zcta
: PLACES: Local Data for Better Health - zcta-level, multiyearsvi_censustract_multiyears
: Social Vulnerability Index at Census Tract-Level - multiyearsvi_censustract_y2000
: Social Vulnerability Index at Census Tract-Level - Year 2000svi_censustract_y2010
: Social Vulnerability Index at Census Tract-Level - Year 2010svi_censustract_y2014
: Social Vulnerability Index at Census Tract-Level - Year 2014svi_censustract_y2016
: Social Vulnerability Index at Census Tract-Level - Year 2016svi_censustract_y2018
: Social Vulnerability Index at Census Tract-Level - Year 2018svi_censustract_y2020
: Social Vulnerability Index at Census Tract-Level - Year 2020svi_censustract_y2022
: Social Vulnerability Index at County-Level - Year 2022svi_county_multiyears
: Social Vulnerability Index at County-Level - multiyearsvi_county_y2000
: Social Vulnerability Index at County-Level - Year 2000svi_county_y2010
: Social Vulnerability Index at County-Level - Year 2010svi_county_y2014
: Social Vulnerability Index at County-Level - Year 2014svi_county_y2016
: Social Vulnerability Index at County-Level - Year 2016svi_county_y2018
: Social Vulnerability Index at County-Level - Year 2018svi_county_y2020
: Social Vulnerability Index at County-Level - Year 2020svi_county_y2022
: Social Vulnerability Index at County-Level - Year 2022urbanrural_classification
: NCHS Urban-Rural Classification Scheme for Countiesvsrr_drugoverdose
: Vital Statistics Rapid Reporting (VSRR) for Drug Overdose
Census - mimi_ws_1.census
- Description: Datasets from the US Census Bureau
- Tables:
centerofpop_bg
: The Centers of Population for each Census Block Groupcenterofpop_co
: The Centers of Population for each Countycenterofpop_st
: The Centers of Population for each Statecenterofpop_tr
: The Centers of Population for each Census Tractcenterofpop_us
: The Center of Population of the USpop_est_zcta
: Population Size by ZCTA
CMS Coding & Billing Section - mimi_ws_1.cmscoding
- Description: Datasets from the Coding & Billing section of the CMS website.
- Tables:
hcpcs
: HCPCS Codes and Descriptions - multiquartericd10cm
: ICD-10-CM Codes and Descriptions - multiyearicd10cm_poa_exempt
: ICD-10-CM Present on Admission (POA) Exempt Codes and Descriptions - multiyearicd10pcs
: ICD-10-PCS Codes and Descriptions - multiyearnicc_mue
: Medicare National Correct Coding Initiative (NICC) Medically Unlikely Edit (MUE) Codes and Descriptions - multiquarter
CMS Data & Research Section - mimi_ws_1.cmsdataresearch
- Description: Datasets from the [Data and Research section of the CMS website](https://www.cms.gov/data-research.
- Tables:
costreport_mimi_hha
: Home Health Agency Cost Reports 1728-2020 mimi Versioncostreport_mimi_hos
: Hospital Cost Reports 2552-2010 mimi Versioncostreport_mimi_snf
: Skilled Nursing Facility Cost Reports 2540-2010 mimi Versioncostreport_raw_hha_alpha
: Home Health Agency 1728-2929 form (original) Alphnumeric Table - multiyearcostreport_raw_hha_nmrc
: Home Health Agency 1728-2929 form (original) Numeric Table - multiyearcostreport_raw_hha_rpt
: Home Health Agency 1728-2929 form (original) Report Table - multiyearcostreport_raw_hos_alpha
: Hospital 2552-2010 form (original) Alphnumeric Table - multiyearcostreport_raw_hos_nmrc
: Hospital 2552-2010 form (original) Numeric Table - multiyearcostreport_raw_hos_rpt
: Hospital 2552-2010 form (original) Report Table - multiyearcostreport_raw_snf_alpha
: Skilled Nursing Facility 2540-2010 form (original) Alphnumeric Table - multiyearcostreport_raw_snf_nmrc
: Skilled Nursing Facility 2540-2010 form (original) Numeric Table - multiyearcostreport_raw_snf_rpt
: Skilled Nursing Facility 2540-2010 form (original) Report Table - multiyearcostreport_sas_hos
: Hospital Cost Reports 2552-2010 SAS Versionhosp_id_info
: Hospital Provider ID-Name Crosswalk for the Cost Reportspartb_national_summary_bess
: Part B National Summary Data File (Previously known as BESS)
CMS Payment Section - mimi_ws_1.cmspayment
- Description: Datasets from the Payment section of the CMS website.
- Tables:
mac_locality
: MAC (Medicare Administrative Contractor) Locality Codes - multiyearopps_addendum_a
: Outpatient Prospective Payment System (OPPS) Addendum A - multiquarteropps_addendum_b
: Outpatient Prospective Payment System (OPPS) Addendum B - multiquarterpartb_drug_asp_ndc_to_hcpcs
: ASP NDC-HCPCS Crosswalk - multiquarterpartb_drug_asp_pricing
: Average Sales Pricing (ASP) - Pricing File - multiquarterpartb_drug_awp_ndc_to_hcpcs
: AWP NDC-HCPCS Crosswalk - multiquarterpartb_drug_noc_ndc_to_hcpcs
: NOC NDC-HCPCS Crosswalk - multiquarterpartb_drug_noc_pricing
: Not Otherwie Classified (NOC) - Pricing File - multiquarterpartb_drug_opps_ndc_to_hcpcs
: OPPS NDC-HCPCS Crosswalk - multiquarterphysicianfeeschedule
: Physician Fee Schedules National Payment Amount File - multiquarterphysicianfeeschedule_metadata
: Physician Fee Schedules Download Metadata, e.g. webpage URL, dataset name, comment
Data.CMS.gov - mimi_ws_1.datacmsgov
- Description: Datasets from the data.cms.gov site by the Centers for Medicare & Medicaid Services (CMS)
- Tables:
betos
: Restructured BETOS Classification System (RBCS)covid19nursinghomes
: COVID-19 Nursing Home Datadatacatalog
: The Data Catalog of the data.cms.gov site (https://data.cms.gov/data.json)geovariation
: Medicare Geographic Variation - by National, State & County - multiyearmcbs_fall
: Medicare Current Beneficiary Survey (MCBS) - fall, multiyearmcbs_summer
: Medicare Current Beneficiary Survey (MCBS) - summer, multiyearmcbs_winter
: Medicare Current Beneficiary Survey (MCBS) - winter, multiyearmupdme
: Medicare Durable Medical Equipment, Devices & Supplies - by Referring Provider and Service - multiyearmupdme_geo
: Medicare Durable Medical Equipment, Devices & Supplies - by Geography and Service - multiyearmupdme_prvdr
: Medicare Durable Medical Equipment, Devices & Supplies - by Referring Provider - multiyearmupdme_sup
: Medicare Durable Medical Equipment, Devices & Supplies - by Supplier - multiyearmupdme_suphpr
: Medicare Durable Medical Equipment, Devices & Supplies - by Supplier and Service - multiyearmupdpr
: Medicare Part D Prescribers - by Prescriber and Drug - multiyearmupdpr_geo
: Medicare Part D Prescribers - by Geography and Drug - multiyearmupdpr_prvdr
: Medicare Part D Prescribers - by Prescriber - multiyearmupihp
: Medicare Inpatient Hospitals - by Provider and Service - multiyearmupihp_geo
: Medicare Inpatient Hospitals - by Geography and Service - multiyearmupihp_prvdr
: Medicare Inpatient Hospitals - by Provider - multiyearmupohp
: Medicare Outpatient Hospitals - by Provider and Service - multiyearmupohp_geo
: Medicare Outpatient Hospitals - by Geography and Service - multiyearmuppac_geo
: Medicare Post-Acute Care and Hospice - by Geography & Provider - multiyearmupphy
: Medicare Physician & Other Practitioners - by Provider and Service - multiyearmupphy_geo
: Medicare Physician & Other Practitioners - by Geography and Service - multiyearmupphy_prvdr
: Medicare Physician & Other Practitioners - by Provider - multiyearnursinghome_ae_perf
: Nursing Home Affiliated Entity Performance - multimonthoptout
: Opt Out Affidavits - multimonthorderandreferring
: Order and Referring - multiweekotpp
: Opioid Treatment Program Providers - multiweekpc_fqhc
: Federally Qualified Health Center Enrollments - multiquarterpc_fqhc_owner
: FQHC All Ownership Information - mu;tiquarterpc_homehealth
: Home Health Agency Enrollments - multiquarterpc_homehealth_owner
: Home Health All Ownership Information - multiquarterpc_homeinfusion
: Home Infusion Therapy Provider Enrollments - multiweekpc_hospice
: Hospice Enrollments - multiquarterpc_hospice_owner
: Hospice All Ownership Information - multiquarterpc_hospital
: Hospital Enrollments - multimonthpc_hospital_owner
: Hospital All Ownership Information - multiquarterpc_provider
: Medicare Fee-For-Service Public Provider Enrollment - multiquarterpc_ruralhealthclinic
: Rural Health Clinic Enrollments - multiquarterpc_ruralhealthclinic_owner
: Rural Health Clinic All Ownership Information - multiquarterpc_snf
: Skilled Nursing Facility Enrollments - multimonthpc_snf_owner
: SNF All Ownership Information - multiquarterpendingilt
: Pending Initial Logging and Tracking - multiweekqpp
: Quality Payment Program, e.g., MIPS, APMs, Performance Results - multiyearrevalidation
: Revalidation Clinic Group Practice Reassignment - multimonth
Data Commons - mimi_ws_1.datacommons
- Description: Datasets from the Data Commons project
- Tables:
Data.Healthcare.gov - mimi_ws_1.datahealthcaregov
- Description: Datasets from the data.healthcare.gov site
- Tables:
formulary_details
: Plan Formulary Details, e.g., Drug Name, RxNorm ID - multimonthmrf_xlsx
: Machine Readable File (MRF) URLs - multimonthplan
: Plan Information, e.g., Plan Name, ID - multimonthplan_formulary_base
: Plan Formulary Base Information - multimonthprovider_addresses
: Provider Addresses from the Provider Directories - multimonthprovider_base
: Provider Directory (base/master) - multimonthprovider_plans
: Provider to Contracted Plans from the Provider Directories - multimonth
Data.Medicaid.gov - mimi_ws_1.datamedicaidgov
- Description: Datasets from the data.medicaid.gov site
- Tables:
drugutilization
: Medicaid State Drug Utilization - multiyearnadac
: NADAC (National Average Drug Acquisition Cost) - multiyearquality
: Child and Adult Health Care Quality Measures Quality - multiyear
CMS DE-SynPUF - mimi_ws_1.desynpuf
- Description: CMS Data Entrepreneurs' Synthetic Public Use File (DE-SynPUF)
- Tables:
beneficiary_summary
: Beneficiary Summary from 2008 to 2010carrier_claims
: Carrier Claims from 2008 to 2010inpatient_claims
: Inpatient Claims from 2008 to 2010outpatient_claims
: Outpatient Claims from 2008 to 2010prescription_drug_events
: Prescription Drug Events from 2008 to 2010
Environmental Protection Agency - mimi_ws_1.epa
- Description: Datasets from the U.S. Environmental Protection Agency
- Tables:
airdata_daily
: Pre-generated Daily Data by Monitorairdata_daily_cbsa
: Pre-generated Daily AQI by CBSAairdata_daily_county
: Pre-generated Daily AQI by Countyairdata_yearly
: Pre-generated Yearly Data by Monitorairdata_yearly_cbsa
: Pre-generated Yearly AQI by CBSAairdata_yearly_county
: Pre-generated Yearly AQI by County
FDA - mimi_ws_1.fda
- Description: Datasets from the U.S. Food & Drug Administration (FDA)
- Tables:
adverse_event_base
: Drug Adverse Event - Base Table - multiquarteradverse_event_drug
: Drug Adverse Event - Drug Table, a part of the Drug Adverse Event Base tableadverse_event_reaction
: Drug Adverse Event - Reaction Table, a part of the Drug Adverse Event Base tableenforcement
: Drug Recall Enforcement - Base Tableenforcement_ndc_detail
: Drug Recall Enforcement - Package NDC Table, a part of the Drug Recall Enforcement Base tablendc_directory
: NDC Directory - multiweekndc_label
: Drug Package Labels - full text datandc_to_active_ingredients
: NDC to Active Ingredients Mapping - a part of the NDC Directoryndc_to_pharm_class
: NDC to Pharmacologic Class Mapping - a part of the NDC Directoryndc_to_rxcui
: NDC to RxCUI Mapping - a part of the NDC Directoryorangebook_exclusivity
: Approved Drug Products with Therapeutic Equivalence Evaluations, aka Orange Book - exclusivity info, multiweekorangebook_patent
: Approved Drug Products with Therapeutic Equivalence Evaluations, aka Orange Book - patent info, multiweekorangebook_products
: Approved Drug Products with Therapeutic Equivalence Evaluations, aka Orange Book - products, multiweekpurplebook
: All FDA-licensed (approved) biological products regulated by the Center for Drug Evaluation and Research (CDER), aka Purple Book - multimonth
Graham Center - mimi_ws_1.grahamcenter
- Description: Datasets from the Robert Graham Center - a research arm of AAFP
- Tables:
gme
: Graduate Medical Education Dataset - multiyearsdi_censustract
: Social Deprivation Index (SDI) at Census Tract Level - multiyearsdi_county
: Social Deprivation Index (SDI) at County Level - multiyearsdi_pcsa
: Social Deprivation Index (SDI) at PCSA (Primary Care Service Area) Level - multiyearsdi_zcta
: Social Deprivation Index (SDI) at ZIP-code Level - multiyear
HealthIT - mimi_ws_1.healthit
- Description: Datasets from the HealthIT.gov - the official website of the Office of the National Coordinator for Health Information Technology (ONC)
- Tables:
HHS-OIG - mimi_ws_1.hhsoig
- Description: Datasets from the HHS Office of Inspector General
- Tables:
buprenorphine_countydata
: Buprenorphine-Waivered Providers — County Dataleie
: List of Excluded Individuals/Entities (LEIE)
HRSA - mimi_ws_1.hrsa
- Description: Datasets from the Health Resources & Services Administration (HRSA)
- Tables:
HUDUser - mimi_ws_1.huduser
- Description: Datasets from huduser.gov - a part of the Office of Policy Development and Research, PD&R
- Tables:
cbsa_to_zip
: Core-Based Statistical Area (CBSA) to ZIP Code Crosswalk (raw data) - multiyearcbsa_to_zip_otm
: CBSA to ZIP crosswalk, one-to-many (otm) mapping based on the residential size - derived, latestcounty_to_zip
: County to ZIP Code Crosswalk (raw data) - multiyearcounty_to_zip_otm
: County to ZIP crosswalk, one-to-many (otm) mapping based on the residential size - derived, latesttract_to_zip
: Census Tract to ZIP Code Crosswalk (raw data) - multiyeartract_to_zip_mto
: Census Tract to ZIP crosswalk, many-to-one (mto) mapping based on the residential size - derived, latestzip_to_cbsa
: ZIP Code to Core-Based Statistical Area (CBSA) (raw data) - multiyearzip_to_cbsa_mto
: ZIP to CBSA crosswalk, many-to-one (mto) mapping based on the residential size - derived, latestzip_to_county
: ZIP Code to County Crosswalk (raw data) - multiyearzip_to_county_mto
: ZIP to County crosswalk, many-to-one (mto) mapping based on the residential size - derived, latestzip_to_tract
: ZIP Code to Census Tract Crosswalk (raw data) - multiyearzip_to_tract_otm
: ZIP to Census Tract crosswalk, one-to-many (otm) mapping based on the residential size - derived, latest
MedlinePlus - mimi_ws_1.medlineplus
- Description: Datasets from MedlinePlus - knowledge base, XML
- Tables:
also_called
: Alternative names or terms for health topicshealth_topic
: Main information for each individual health topicinformation_category
: Categories of information for each sitelanguage_mapped_topic
: Information about topic translations or language variantsmesh_heading
: Medical Subject Headings (MeSH) descriptors for topicsmesh_qualifier
: MeSH qualifiers associated with MeSH descriptorsorganization
: Organizations associated with each siteother_language
: Information about the topic in other languagesprimary_institute
: Information about the primary institute associated with a topicrelated_topic
: Information about topics related to the main topicsee_reference
: Cross-references or "see also" type informationsite
: Information about external sites related to the topicstandard_description
: Standard descriptions for each sitetopic_group
: Group information associated with health topics
mimilabs - mimi_ws_1.mimilabs
- Description: Datasets from mimilabs.
- Tables:
cmsemails
: CMS Email Subscriptions
NBER - mimi_ws_1.nber
- Description: Datasets from the National Bureau of Economic Research
- Tables:
ssa2fips_state_and_county
: SSA to FIPS crowsswalk
Neighborhood Atlas - mimi_ws_1.neighborhoodatlas
- Description: Datasets from the Neighborhood Atlas - Area Deprivation Index
- Tables:
adi_censusblock
: Area Deprivation Index (ADI) Original (Census Block Group Level)adi_censustract
: Area Deprivation Index (ADI) Aggregated (Census Tract Level, USE WITH CAUTION)adi_county
: Area Deprivation Index (ADI) Aggregated (Census Block Group Level, USE WITH CAUTION)
National Library of Medicine - mimi_ws_1.nlm
- Description: Datasets from the National Library of Medicine.
- Tables:
rxn_all_pathways
: RxNorm All Pathways - inspired by the Google Health's all pathways dataset - latest onlyrxnconso
: RxNorm Concept Names and Soruces (RXNCONSO), Prescribable Content - multimonthrxnorm_paths
: RxNorm Default Pathsrxnrel
: RxNorm Related Concepts (RXNREL), Prescribable Content - multimonthrxnsat
: RxNorm Simple Concept and Atom Attributes (RXNSAT), Prescribable Content - multimonth
NPPES - mimi_ws_1.nppes
- Description: Datasets from NPPES (National Plan and Provider Enumeration System)
- Tables:
address_census_geocoder_dedup
: De-duplicated Geocoding Results for theaddress_key
tableaddress_census_geocoder_raw
: Raw Geocoding Results from the US Census Geocoder, derived from the `address_key``address_key
: Address Key, A collection of Unique Address Strings for all providers and timesdeactivated
: Deactived Provider Listendpoint
: Health Information Exchange (HIE) Endpoints, i.e., provider HIE contact address - multiyearendpoint_se
: HIE Endpoints formatted with Start and End dateslicense_se
: Provider License Data with Start and End dates, derived fromnpidata
mongodb_export
: Data Extract fornpi-db.org
(a demo project)npi_to_address
: NPI to Geocoded Address (both practice and mail address), only for the latest npidata batchnpidata
: NPIDATA - the base NPI directory, multiyearopenpayments
: Open Payment Summaries fornpi-db.org
, derived from theopenpayments
schemaotherid_ccn_se
: CCNs (CMS Certification Number, often used for facilities) with Start and End datesotherid_se
: Other Provider IDs with Start and End dates, derived fromnpidata
othername
: Other Business Names such as DBA - multiyearothername_se
: Other Business Names formatted with Start and End datespl
: Other Practice Locations - multiyearpl_se
: Other Practice Locations formatted with Start and End datestaxonomy_se
: Provider Taxonomies with Start and End dates
Open Payments - mimi_ws_1.openpayments
- Description: Datasets from the https://openpaymentsdata.cms.gov/ site
- Tables:
deleted
: The table contains records that have been deletedgeneral
: General Payments Details - multiyearownership
: Physician Ownership Details - multiyearresearch
: Research Payments Details - multiyear
Palmetto GBA - mimi_ws_1.palmettogba
- Description: Datasets from Palmetto GBA
- Tables:
dmecs
: DME Coding System (DMECS) Update Listingndc_hcpcs_xwalk
: NDC/HCPCS Crosswalk
Part C/D - mimi_ws_1.partcd
- Description: Datasets regarding Medicare Part C/D Enrollment and Perforamnce
- Tables:
cpsc_combined
: Medicare Advantage CPSC Enrollment with Directory Info - derived, multimonthcpsc_contract
: Medicare Advantage Contract Information from the CPSC bundle - multimonthcpsc_enrollment
: Medicare Advantage Enrollment by Contract/Plan/State/County (CPSC) - multimonthhedis_general
: HEDIS Public Use Files - Contract Information, multiyearhedis_measures
: HEDIS Public Use Files - Contract-level Performance, multiyearhedis_national_rates
: HEDIS Public Use Files - National Rates, multiyearhedis_rau_measures
: HEDIS Public Use Files - Risk Adjusted Measures, multiyearlandscape_medicare_advantage
: MAPD Coverage Landscape File - Medicare Advantage - multiyearlandscape_plan_premium_report
: MAPD Coverage Landscape File - Premium Report - multiyearlandscape_prescription_drug_plan
: MAPD Coverage Landscape File - Prescription Drug Plan - multiyearlandscape_special_needs_plan
: MAPD Coverage Landscape File - Special Needs Plan - multiyearpbp_b13i_b19b_services_vbid_ssbci
: Medicare Advantage Benefits Information Section B13I-B19B VBID - Non-Primarily Health Related Benefits for the Chronically III, Food and Produce, Meals, Pest Control, Transportation for Non-Medical Needs, Indoor Air Quality Equipment and Services and Other data.; multiquarterpbp_b14c_b19b_preventive_vbid_uf
: Medicare Advantage Benefits Information Section B14C-B19B VBID - Contains Supplemental Benefits Preventive Services VBID and UF data for Health Education/Wellness, Fitness Benefit, Counseling Services.; multiquarterpbp_b15_partb_rx_drugs
: Medicare Advantage Benefits Information Section B15 PartB Rx - Medicare Part B prescription drugs.; multiquarterpbp_b16_b19b_dental_vbid_uf
: Medicare Advantage Benefits Information Section B16-B19B Dental VBID UF - Preventive and Comprehensive Dental VBID and UF data, multiquarterpbp_b16_dental
: Medicare Advantage Benefits Information Section B16 Dental - Preventive and Comprehensive Dental data, multiquarterpbp_metadata
: Medicare Advantage Benefits Information Metadata - Contains the list of tables, columns, and their descriptions.; multiquarterpbp_mrx
: Medicare Advantage Benefits Information Section MRX - Contains Medicare Part D prescription drug benefits data, multiquarterpbp_mrx_gapcoverage
: Medicare Advantage Benefits Information Section MRX Gap Coverage - Contains information on coverage of either tier(s) or specific drugs through the entire gap (ICL to catastrophic), multiquarterpbp_mrx_p
: Medicare Advantage Benefits Information Section B14C-B19B MRX P - Contains Medicare Part D prescription drug benefits (post OOP threshold) data, multiquarterpbp_mrx_p_vbid
: Medicare Advantage Benefits Information Section MRX P VBID - Contains Medicare Part D prescription drug benefits (post OOP threshold) VBID data, multiquarterpbp_mrx_tier
: Medicare Advantage Benefits Information Section MRX TIER - Contains Medicare Part D prescription drug benefits (tiering) data, multiquarterpbp_mrx_tier_vbid
: Medicare Advantage Benefits Information Section MRX TIER VBID VBID - Contains Medicare Part D prescription drug benefits (tiering) data, multiquarterpbp_mrx_vbid
: Medicare Advantage Benefits Information Section MRX VBID - Contains Medicare Part D prescription drug benefits VBID data, multiquarterpbp_section_a
: Medicare Advantage Benefits Information Section A - Contains general plan information.; multiquarterpbp_section_d_opt
: Medicare Advantage Benefits Information Section D Optional - Contains plan-level benefit data descriptions of optional supplemental offerings including the optional benefit premium amounts, multiquarterstarrating_display_hedis_measure
: Part C & D Performance Data (Star Rating), Display and HEDIS values - multiyearstarrating_measure_star
: Part C & D Performance Data (Star Rating), Stars - multiyearstarrating_measure_value
: Part C & D Performance Data (Star Rating), raw measure values - multiyear
Payer MRF - mimi_ws_1.payermrf
- Description: Price Transparency Files from various Payers - currently loaded: UnitedHealthcare, Medica, planned: Aetna - aka Payer TiC files, commercial or employer rates.
- Tables:
allowed_amounts
: Allowed Amounts Data (Out-of-Network) - Out-of-Network pricing data, Currently, UHC and Medica data are loaded. multimonthin_network_rates
: In-Network Rates Data - Some of UHC data, and all Medica in-network files are loaded.medica_toc
: Medica Table of Contents - multimonthmolina_provider_directory
: Molina Healthcare Provider Directory at county-level - multimonthprovider_references
: Provider Reference Dataunh_toc
: UnitedHealthcare Table of Contents - multimonth
Prescription Drug Plan - mimi_ws_1.prescriptiondrugplan
- Description: Datasets from the Part-D Formularies and Networks section - a subsection of the data.cms.gov site
- Tables:
basic_drugs_formulary
: Basic Drugs Formulary File - multiquarterbeneficiary_cost
: Beneficiary Cost File - multiquarterexcluded_drugs_formulary
: Excluded Drugs Formulary File - multiquartergeographic_locator
: Geographic Locator File - multiquarterindication_based_coverage_formulary
: Indication Based Coverage (IBC) Formulary File - multiquarterinsulin_beneficiary_cost
: Insulin Beneficiary Cost File - multiquarterpartial_gap_coverage
: Partial Gap File - multiquarterpharmacy_networks
: Pharmacy Networks File - multiquarterplan_information
: Plan Information File - multiquarterpricing
: Pricing File - multiquarter
Provider Data Catalog - mimi_ws_1.provdatacatalog
- Description: Datasets from the CMS Provider Data Catalog section - a subsection of the data.cms.gov site
- Tables:
dac_ec_public_reporting
: Doctors and Clinicians - Clinician Public Reporting: MIPS Measures and Attestations - multimonthdac_ec_score_file
: Doctors and Clinicians - Clinician Public Reporting: Overall MIPS Performance - multimonthdac_fa
: Doctors and Clinicians - Facility Affiliations - multimonthdac_grp_public_reporting
: Doctors and Clinicians - Group Public Reporting: MIPS Measures and Attestations - multimonthdac_grp_public_reporting_cahps
: Doctors and Clinicians - Group Public Reporting: Patient Experience - multimonthdac_ndf
: Doctors and Clinicians - National Downloadable Files - multimonthdac_utilization
: Doctors and Clinicians - Utilization - multimonthdac_vg_public_reporting
: Doctors and Clinicians - Virtual Group Public Reporting: MIPS Measures and Attestations - multimonthnursinghomes_mds
: Nursing Home Minimum Data Set (MDS) Files - multimonth
State Government Databases - mimi_ws_1.stategov
- Description: Datasets from State Governments
- Tables:
california_medicaid_provider_directory
: California Medicaid Provider Directory - multimonthgeorgia_medicaid_provider_directory
: Gerogia Medicaid Provider Directory - multimonthnewyork_medicaid_provider_directory
: New York Medicaid Provider Directory - multimonth
Surgo Ventures - mimi_ws_1.surgoventures
- Description: Datasets from Surgo Ventures
- Tables:
ccvi_county
: THE U.S. COVID COMMUNITY VULNERABILITY INDEX (CCVI) - county-levelccvi_state
: THE U.S. COVID COMMUNITY VULNERABILITY INDEX (CCVI) - state-levelmvi_county
: The U.S. Maternal Vulnerability Index by Surgo Ventures
CMS Synthetic Medicare PUF - mimi_ws_1.synmedpuf
- Description: CMS Synthetic Medicare PUF
- Tables:
beneficiary
: Beneficiary Summarycarrier
: Carrier Claimsdme
: Durable Medical Equipment Claimshha
: Home Health Agency Claimshospice
: Hospice Claimsinpatient
: Inpatient Claimsoutpatient
: Outpatient Claimspde
: Prescription Drug Events from 2008 to 2010snf
: Skilled Nursing Facility Claims
Synthea - mimi_ws_1.synthea
- Description: Datasets from the MITRE Synthea project - 1.1M synthetic patients
- Tables:
allergies
: Patient allergy data.careplans
: Patient care plan data, including goals.conditions
: Patient conditions or diagnoses.devices
: Patient-affixed permanent and semi-permanent devices.encounters
: Patient encounter data.imaging_studies
: Patient imaging metadata.immunizations
: Patient immunization data.medications
: Patient medication data.observations
: Patient observations including vital signs and lab reports.organizations
: Provider organizations including hospitals.patients
: Patient demographic data.payer_transitions
: Payer Transition data (i.e. changes in health insurance).payers
: Payer organization data.procedures
: Patient procedure data including surgeries.providers
: Clinicians that provide patient care.supplies
: Supplies used in the provision of care.
Zillow - mimi_ws_1.zillow
- Description: Datasets from Zillow (a real-estate marketplace company)
- Tables:
homevalue_zip
: Home Values by Zillow - time-seriesrent_zip
: Rentals by Zillow - time-series