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:
  • ccs_cpt: Clinical Classifications Software (CCS) CPT - PLEASE REVIEW THE CPT AGREEMENT BEFORE USING | resolution: code, interval: yearly
  • ccsr_dx: Clinical Classifications Software Refined (CCSR) Diagnosis (Dx) | resolution: code, interval: yearly
  • ccsr_pr: Clinical Classifications Software Refined (CCSR) Procedure (Pr) | resolution: code, interval: yearly
  • compendium_grouppractice_linkage: Compendium of U.S. Health Systems, Group Practice Linkage | resolution: group_practice, interval: yearly
  • compendium_homehealth_linkage: Compendium of U.S. Health Systems, Home Health Linkage | resolution: home_health_organization, interval: yearly
  • compendium_hospital_linkage: Compendium of U.S. Health Systems, Hospital Linkage | resolution: hospital, interval: yearly
  • compendium_nursinghome_linkage: Compendium of U.S. Health Systems, Nursing Home Linkage | resolution: nursing_home, interval: yearly
  • compendium_outpatient_linkage: Compendium of U.S. Health Systems, Outpatient Linkage | resolution: outpatient_site, interval: yearly
  • compendium_us_health_systems: Compendium of U.S. Health Systems | resolution: health_system, interval: yearly
  • meps_consol_label_dictionary: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Consolidated Files; Variable Values and Descriptions | resolution: code, interval: yearly
  • meps_consol_metadata: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Consolidated Files Metadata; Variable Names and Descriptions | resolution: variable, interval: yearly
  • meps_event_dentalvisits: MEPS HC Event Files Dental Visits | resolution: event, interval: yearly
  • meps_event_ervisits: MEPS HC Event Files Emergency Room Visits | resolution: event, interval: yearly
  • meps_event_homehealth: MEPS HC Event Files Home Health | resolution: event, interval: yearly
  • meps_event_inpatientstays: MEPS HC Event Files Inpatient Stays | resolution: event, interval: yearly
  • meps_event_label_dictionary: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Event Files; Variable Values and Descriptions | resolution: code, interval: yearly
  • meps_event_metadata: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Event Files Metadata; Variable Names and Descriptions | resolution: variable, interval: yearly
  • meps_event_officevisits: MEPS HC Event Files Office-based Visits | resolution: event, interval: yearly
  • meps_event_othermedicalexp: MEPS HC Event Files Other Medical Expenditures | resolution: event, interval: yearly
  • meps_event_outpatientvisits: MEPS HC Event Files Outpatient Visits | resolution: event, interval: yearly
  • meps_event_prescribedmeds: MEPS HC Event Files Prescribed Medicines | resolution: event, interval: yearly
  • meps_fyc: MEPS HC Full Year Consolidated Files | resolution: respondent, interval: yearly
  • sdohdb_county: SDoH Database | resolution: county, interval: yearly
  • sdohdb_tract: SDoH Database | resolution: tract, interval: yearly
  • sdohdb_zipcode: SDoH Database | resolution: zip, interval: yearly

CMS Blue Button - mimi_ws_1.bluebutton

• Description: Sample Data, Documentation, Valuesets from the CMS Blue Button Programs
• Tables:

Canada Drug Agency - mimi_ws_1.cdaamc

• Description: Datasets from Canada's Drug Agency (CDA-AMC, formerly known as CADTH)
• Tables:
  • cda_reports: Canada's Drug Agency Reports | resolution: drug, interval: monthly

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 Weights | resolution: respondent, interval: yearly
  • nhanes_exam_blood_pressure: CDC NHANES EXAM Blood Pressure | resolution: respondent, interval: yearly
  • nhanes_exam_body_measures: CDC NHANES EXAM Body Measures | resolution: respondent, interval: yearly
  • nhanes_lab_albumin_creatinine_urine: CDC NHANES LAB Albumin & Creatinine - Urine | resolution: respondent, interval: yearly
  • nhanes_lab_alpha1acid_glycoprotein_serum_surplus: CDC NHANES LAB Alpha-1-Acid Glycoprotein - Serum (Surplus) | resolution: respondent, interval: yearly
  • nhanes_lab_cholesterol_hdl: CDC NHANES LAB Cholesterol - HDL | resolution: respondent, interval: yearly
  • nhanes_lab_cholesterol_ldl_triglycerides: CDC NHANES LAB Cholesterol - LDL & Triglycerides | resolution: respondent, interval: yearly
  • nhanes_lab_cholesterol_total: CDC NHANES LAB Cholesterol - Total | resolution: respondent, interval: yearly
  • nhanes_lab_fasting_questionnaire: CDC NHANES LAB Fasting Questionnaire | resolution: respondent, interval: yearly
  • nhanes_lab_glycohemoglobin: CDC NHANES LAB Glycohemoglobin | resolution: respondent, interval: yearly
  • nhanes_lab_glyphosate_glyp_urine: CDC NHANES LAB Glyphosate (GLYP) - Urine | resolution: respondent, interval: yearly
  • nhanes_lab_highsensitivity_creactive_protein: CDC NHANES LAB High-Sensitivity C-Reactive Protein | resolution: respondent, interval: yearly
  • nhanes_lab_insulin: CDC NHANES LAB Insulin | resolution: respondent, interval: yearly
  • nhanes_lab_oral_glucose_tolerance_test: CDC NHANES LAB Oral Glucose Tolerance Test | resolution: respondent, interval: yearly
  • nhanes_lab_plasma_fasting_glucose: CDC NHANES LAB Plasma Fasting Glucose | resolution: respondent, interval: yearly
  • nhanes_lab_standard_biochemistry_profile: CDC NHANES LAB Standard Biochemistry Profile | resolution: respondent, interval: yearly
  • nhanes_metadata: National Health and Nutrition Examination Survey (NHANES) Metadata | resolution: variable, interval: yearly
  • nhanes_mortality: CDC NHANES Mortality Dataset | resolution: respondent, interval: yearly
  • nhanes_qre_acculturation: CDC NHANES QRE Acculturation | resolution: respondent, interval: yearly
  • nhanes_qre_air_quality: CDC NHANES QRE Air Quality | resolution: respondent, interval: yearly
  • nhanes_qre_alcohol_use: CDC NHANES QRE Alcohol Use | resolution: respondent, interval: yearly
  • nhanes_qre_blood_pressure_cholesterol: CDC NHANES QRE Blood Pressure & Cholesterol | resolution: respondent, interval: yearly
  • nhanes_qre_bowel_health: CDC NHANES QRE Bowel Health | resolution: respondent, interval: yearly
  • nhanes_qre_cardiovascular_health: CDC NHANES QRE Cardiovascular Health | resolution: respondent, interval: yearly
  • nhanes_qre_diabetes: CDC NHANES QRE Diabetes | resolution: respondent, interval: yearly
  • nhanes_qre_hospital_utilization_access_to_care: CDC NHANES QRE Hospital Utilization & Access to Care | resolution: respondent, interval: yearly
  • nhanes_qre_income: CDC NHANES QRE Income | resolution: respondent, interval: yearly
  • nhanes_qre_kidney_conditions: CDC NHANES QRE Kidney Conditions | resolution: respondent, interval: yearly
  • nhanes_qre_medical_conditions: CDC NHANES QRE Medical Conditions | resolution: respondent, interval: yearly
  • nhanes_qre_preventive_aspirin_use: CDC NHANES QRE Preventive Aspirin Use | resolution: respondent, interval: yearly
  • nhanes_qre_smoking_adult_recent_tobacco_use_youth_cigarettetobacco_use: CDC NHANES QRE Smoking - Adult Recent Tobacco Use & Youth Cigarette/Tobacco Use | resolution: respondent, interval: yearly
  • nhanes_qre_smoking_cigarette_use: CDC NHANES QRE Smoking - Cigarette Use | resolution: respondent, interval: yearly
  • nhanes_qre_smoking_household_smokers: CDC NHANES QRE Smoking - Household Smokers | resolution: respondent, interval: yearly
  • nhanes_qre_smoking_recent_tobacco_use: CDC NHANES QRE Smoking - Recent Tobacco Use | resolution: respondent, interval: yearly
  • nndss: National Notifiable Diseases Surveillance System (NNDSS) | resolution: state, interval: weekly
  • nssp_edvisits: NSSP Emergency Department Visit Trajectories by State and Sub State Regions- COVID-19, Flu, RSV, Combined | resolution: county, interval: weekly
  • nwss_covid: National Wastewater Surveillance System (NWSS) for Covid | resolution: monitoring_site, interval: weekly
  • nwss_mpox: National Wastewater Surveillance System (NWSS) for Mpox | resolution: monitoring_site, interval: weekly
  • places_censustract: PLACES: Local Data for Better Health | resolution: tract, interval: yearly
  • places_county: PLACES: Local Data for Better Health | resolution: county, interval: yearly
  • places_zcta: PLACES: Local Data for Better Health | resolution: zcta, interval: yearly
  • svi_censustract_multiyears: Social Vulnerability Index at Census Tract-Level | resolution: tract, interval: yearly
  • svi_censustract_y2000: Social Vulnerability Index at Census Tract-Level | year: 2000, resolution: tract, interval: snapshot
  • svi_censustract_y2010: Social Vulnerability Index at Census Tract-Level | year: 2010, resolution: tract, interval: snapshot
  • svi_censustract_y2014: Social Vulnerability Index at Census Tract-Level | year: 2014, resolution: tract, interval: snapshot
  • svi_censustract_y2016: Social Vulnerability Index at Census Tract-Level | year: 2016, resolution: tract, interval: snapshot
  • svi_censustract_y2018: Social Vulnerability Index at Census Tract-Level | year: 2018, resolution: tract, interval: snapshot
  • svi_censustract_y2020: Social Vulnerability Index at Census Tract-Level | year: 2020, resolution: tract, interval: snapshot
  • svi_censustract_y2022: Social Vulnerability Index at County-Level | year: 2022, resolution: tract, interval: snapshot
  • svi_county_multiyears: Social Vulnerability Index at County-Level | resolution: county, interval: yearly
  • svi_county_y2000: Social Vulnerability Index at County-Level | year: 2000, resolution: county, interval: snapshot
  • svi_county_y2010: Social Vulnerability Index at County-Level | year: 2010, resolution: county, interval: snapshot
  • svi_county_y2014: Social Vulnerability Index at County-Level | year: 2014, resolution: county, interval: snapshot
  • svi_county_y2016: Social Vulnerability Index at County-Level | year: 2016, resolution: county, interval: snapshot
  • svi_county_y2018: Social Vulnerability Index at County-Level | year: 2018, resolution: county, interval: snapshot
  • svi_county_y2020: Social Vulnerability Index at County-Level | year: 2020, resolution: county, interval: snapshot
  • svi_county_y2022: Social Vulnerability Index at County-Level | year: 2022, resolution: county, interval: snapshot
  • urbanrural_classification: NCHS Urban-Rural Classification Scheme for Counties | resolution: county, interval: yearly
  • vsrr_drugoverdose: Vital Statistics Rapid Reporting (VSRR) for Drug Overdose | resolution: state, interval: monthly

Census - mimi_ws_1.census

• Description: Datasets from the US Census Bureau
• Tables:
  • acs5_table_shells: American Community Survey (ACS) 5 Years Table Shells | resolution: variable, interval: yearly
  • cbsa_to_metro_div_csa: Core based statistical areas (CBSAs), metropolitan divisions, and combined statistical areas (CSAs) | resolution: cbsa, interval: yearly
  • cbsa_to_principal_city_fips: Principal cities of metropolitan and micropolitan statistical areas | resolution: cbsa, interval: yearly
  • centerofpop_bg: The Centers of Population for each Census Block Group | resolution: census_block_group, interval: yearly
  • centerofpop_co: The Centers of Population for each County | resolution: county, interval: yearly
  • centerofpop_st: The Centers of Population for each State | resolution: state, interval: yearly
  • centerofpop_tr: The Centers of Population for each Census Tract | resolution: tract, interval: yearly
  • centerofpop_us: The Center of Population of the US | resolution: us, interval: yearly
  • pop_est_zcta: Population Size by ZCTA | resolution: zcta, interval: yearly

ClinicalTrials.gov - mimi_ws_1.clinicaltrialsgov

• Description: Datasets from ClinicalTrials.gov
• Tables:
  • baseline_counts: baseline_counts | resolution: study, interval: daily
  • baseline_measurements: baseline_measurements | resolution: study, interval: daily
  • brief_summaries: brief_summaries | resolution: study, interval: daily
  • browse_conditions: browse_conditions | resolution: study, interval: daily
  • browse_interventions: browse_interventions | resolution: study, interval: daily
  • calculated_values: calculated_values | resolution: study, interval: daily
  • central_contacts: central_contacts | resolution: study, interval: daily
  • conditions: conditions | resolution: study, interval: daily
  • countries: countries | resolution: study, interval: daily
  • design_group_interventions: design_group_interventions | resolution: study, interval: daily
  • design_groups: design_groups | resolution: study, interval: daily
  • design_outcomes: design_outcomes | resolution: study, interval: daily
  • designs: designs | resolution: study, interval: daily
  • detailed_descriptions: detailed_descriptions | resolution: study, interval: daily
  • documents: documents | resolution: study, interval: daily
  • drop_withdrawals: drop_withdrawals | resolution: study, interval: daily
  • eligibilities: eligibilities | resolution: study, interval: daily
  • facilities: facilities | resolution: study, interval: daily
  • facility_contacts: facility_contacts | resolution: study, interval: daily
  • facility_investigators: facility_investigators | resolution: study, interval: daily
  • id_information: Id_Information | resolution: study, interval: daily
  • intervention_other_names: intervention_other_names | resolution: study, interval: daily
  • interventions: interventions | resolution: study, interval: daily
  • ipd_information_types: ipd_information_types | resolution: study, interval: daily
  • keywords: keywords | resolution: study, interval: daily
  • links: links | resolution: study, interval: daily
  • milestones: milestones | resolution: study, interval: daily
  • outcome_analyses: outcome_analyses | resolution: study, interval: daily
  • outcome_analysis_groups: outcome_analysis_groups | resolution: study, interval: daily
  • outcome_counts: outcome_counts | resolution: study, interval: daily
  • outcome_measurements: outcome_measurements | resolution: study, interval: daily
  • outcomes: outcomes | resolution: study, interval: daily
  • overall_officials: overall_officials | resolution: study, interval: daily
  • participant_flows: participant_flows | resolution: study, interval: daily
  • pending_results: pending_results | resolution: study, interval: daily
  • provided_documents: provided_documents | resolution: study, interval: daily
  • reported_event_totals: reported_event_totals | resolution: study, interval: daily
  • reported_events: reported_events | resolution: study, interval: daily
  • responsible_parties: responsible_parties | resolution: study, interval: daily
  • result_agreements: result_agreements | resolution: study, interval: daily
  • result_contacts: result_contacts | resolution: study, interval: daily
  • result_groups: result_groups | resolution: study, interval: daily
  • retractions: retractions | resolution: study, interval: daily
  • search_results: search_results | resolution: study, interval: daily
  • sponsors: sponsors | resolution: study, interval: daily
  • studies: studies | resolution: study, interval: daily
  • study_references: study_references | resolution: study, interval: daily

CMS Coding & Billing Section - mimi_ws_1.cmscoding

• Description: Datasets from the CMS Coding & Billing.
• Tables:
  • hcpcs: HCPCS Codes and Descriptions | resolution: code, interval: quarterly
  • hcpcs_decisions_parsed: HCPCS Level II Coding Decisions - Extracted | resolution: application, interval: quarterly
  • hcpcs_decisions_rawtext: HCPCS Level II Coding Decisions - Raw Text | resolution: application, interval: quarterly
  • icd10cm: ICD-10-CM Codes and Descriptions | resolution: code, interval: yearly
  • icd10cm_poa_exempt: ICD-10-CM Present on Admission (POA) Exempt Codes and Descriptions | resolution: code, interval: yearly
  • icd10pcs: ICD-10-PCS Codes and Descriptions | resolution: code, interval: yearly
  • medicaid_ncci_mue: Medicaid National Correct Coding Initiative (NCCI) Medically Unlikely Edit (MUE) Codes and Descriptions | resolution: code, interval: quarterly
  • ncci_mue: Medicare National Correct Coding Initiative (NCCI) Medically Unlikely Edit (MUE) Codes and Descriptions | resolution: code, interval: quarterly
  • ncci_ptp: Medicare National Correct Coding Initiative (NCCI) Procedure to Procedure Edit (PTP) Codes and Descriptions | resolution: code, interval: quarterly

CMS Data & Research Section - mimi_ws_1.cmsdataresearch

• Description: Datasets from the CMS Data and Research.
• Tables:
  • costreport_mimi_cmhc: CMHC 2088-2017 mimi Analytics-Friendly Version | resolution: community_health_center, interval: yearly
  • costreport_mimi_fqhc: FQHC 224-2014 mimi Analytics-Friendly Version | resolution: hospital, interval: yearly
  • costreport_mimi_hha: Home Health Agency Cost Reports 1728-2020 mimi Analytics-Friendly Version | resolution: home_health_organization, interval: yearly
  • costreport_mimi_hosp: Hospital Cost Reports 2552-2010 mimi Analytics-Friendly Version | resolution: hospital, interval: yearly
  • costreport_mimi_hospice: Hospice 1984-2014 mimi Analytics-Friendly Version | resolution: hospital, interval: yearly
  • costreport_mimi_rhc: Rural Health Center 222-2017 mimi Analytics-Friendly Version | resolution: rurally_health_center, interval: yearly
  • costreport_mimi_snf: Skilled Nursing Facility Cost Reports 2540-2010 mimi Analytics-Friendly Version | resolution: skilled_nursing_facility, interval: yearly
  • costreport_raw_cmhc_alpha: Community Mental Health Center 2088-2017 form (original) Alphnumeric Table | resolution: community_mental_health_center, interval: yearly
  • costreport_raw_cmhc_nmrc: Community Mental Health Center 2088-2017 form (original) Numeric Table | resolution: community_mental_health_center, interval: yearly
  • costreport_raw_cmhc_rpt: Community Mental Health Center 2088-2017 form (original) Report Table | resolution: community_mental_health_center, interval: yearly
  • costreport_raw_fqhc_alpha: Federally Qualified Health Center 224-2014 form (original) Alphnumeric Table | resolution: fqhc, interval: yearly
  • costreport_raw_fqhc_nmrc: Federally Qualified Health Center 224-2014 form (original) Numeric Table | resolution: fqhc, interval: yearly
  • costreport_raw_fqhc_rpt: Federally Qualified Health Center 224-2014 form (original) Report Table | resolution: fqhc, interval: yearly
  • costreport_raw_hha_alpha: Home Health Agency 1728-2929 form (original) Alphnumeric Table | resolution: home_health_organization, interval: yearly
  • costreport_raw_hha_nmrc: Home Health Agency 1728-2929 form (original) Numeric Table | resolution: home_health_organization, interval: yearly
  • costreport_raw_hha_rpt: Home Health Agency 1728-2929 form (original) Report Table | resolution: home_health_organization, interval: yearly
  • costreport_raw_hosp_alpha: Hospital 2552-2010 form (original) Alphnumeric Table | resolution: hospital, interval: yearly
  • costreport_raw_hosp_nmrc: Hospital 2552-2010 form (original) Numeric Table | resolution: hospital, interval: yearly
  • costreport_raw_hosp_rpt: Hospital 2552-2010 form (original) Report Table | resolution: hospital, interval: yearly
  • costreport_raw_hospice_alpha: Hospice 1984-2014 form (original) Alphnumeric Table | resolution: hospice_agency, interval: yearly
  • costreport_raw_hospice_nmrc: Hospice 1984-2014 form (original) Numeric Table | resolution: hospice_agency, interval: yearly
  • costreport_raw_hospice_rpt: Hospice 1984-2014form (original) Report Table | resolution: hospice_agency, interval: yearly
  • costreport_raw_rhc_alpha: Rural Health Center 222-2017 form (original) Alphnumeric Table | resolution: rural_health_center, interval: yearly
  • costreport_raw_rhc_nmrc: Rural Health Center 222-2017 form (original) Numeric Table | resolution: rural_health_center, interval: yearly
  • costreport_raw_rhc_rpt: Rural Health Center 222-2017 form (original) Report Table | resolution: rural_health_center, interval: yearly
  • costreport_raw_snf_alpha: Skilled Nursing Facility 2540-2010 form (original) Alphnumeric Table | resolution: skilled_nursing_facility, interval: yearly
  • costreport_raw_snf_nmrc: Skilled Nursing Facility 2540-2010 form (original) Numeric Table | resolution: skilled_nursing_facility, interval: yearly
  • costreport_raw_snf_rpt: Skilled Nursing Facility 2540-2010 form (original) Report Table | resolution: skilled_nursing_facility, interval: yearly
  • costreport_sas_hosp: Hospital Cost Reports 2552-2010 SAS Version | resolution: hospital, interval: yearly
  • hosp_id_info: Hospital Provider ID-Name Crosswalk for the Cost Reports | resolution: hospital, interval: yearly
  • marketplace_enrollment_county: OEP ZIP-Code Level Public Use File | resolution: county, interval: yearly
  • marketplace_enrollment_state: OEP State-Level Public Use File | resolution: state, interval: yearly
  • marketplace_enrollment_state_metal: OEP State, Metal Level, and Enrollment Status Public Use File | resolution: state x metal level, interval: yearly
  • marketplace_enrollment_zip: OEP County-Level Public Use File | resolution: zip, interval: yearly
  • partb_national_summary_bess: Part B National Summary Data File (Previously known as BESS) | resolution: code, interval: yearly
  • rac_approved_topics_index: Approved RAC Topics - index | resolution: topic, interval: monthly
  • rac_proposed_topics_index: Proposed RAC Topics - index | resolution: topic, interval: monthly
  • rac_topic_details: Detailed RAC Topics - both approved and proposed | resolution: topic, interval: monthly

CMS Innovation Center - mimi_ws_1.cmsinnovation

• Description: Datasets from the CMS Innovation Center.
• Tables:
  • ckcc_performance: CKCC/KCF Performance Results | resolution: ckcc, interval: yearly
  • dc_ratebook: ACO REACH (DCE) and CKCC/KCF Ratebook | resolution: aco, interval: yearly
  • gdpc_performance: ACO REACH (DCE) Performance Results | resolution: aco, interval: yearly
  • makingcareprimary_participants: Making Care Primary (MCP) Participant List | resolution: provider, interval: snapshot
  • makingcareprimary_participants_with_npi: Making Care Primary (MCP) Participant List with NPI (mimi-augmented) | resolution: provider, interval: snapshot
  • primarycarefirst_participants: Primary Care First (PCF) Participant List | resolution: provider, interval: snapshot
  • primarycarefirst_participants_with_npi: Primary Care First (PCF) Participant List with NPI (mimi-augmented) | resolution: provider, interval: snapshot
  • primarycarefirst_results: Primary Care First (PCF) Results | resolution: provider, interval: snapshot
  • reach_orgs: ACO REACH Organizations | resolution: aco, interval: yearly

CMS Information Technology - mimi_ws_1.cmsit

• Description: Datasets from the CMS Information Systems page
• Tables:
  • hpms_memos: Health Plan Management System (HPMS) weekly memo archives | resolution: memo, interval: weekly

CMS Insurance Marketplace - mimi_ws_1.cmsmarketplace

• Description: Datasets from the CMS Health Insurance Marketplace section - a subsection of the data.cms.gov site
• Tables:
  • enrollment: Issuer Level Enrollment Data | resolution: health_plan, interval: yearly
  • issuer_details: Issuer Details | resolution: health_plan, interval: quarterly
  • mlr_part12_summary: MLR PART1 2 SUMMARY DATA PREMIUM CLAIMS | resolution: health_plan, interval: yearly
  • mlr_part3_mlr_rebate: MLR PART1 2 SUMMARY DATA PREMIUM CLAIMS | resolution: health_plan, interval: yearly
  • product_details: Product Details | resolution: health_plan, interval: quarterly
  • puf_benefits_and_cost_sharing: Benefits and Cost Sharing PUF | resolution: plan, interval: yearly
  • puf_transparency_in_coverage: Transparency in Coverage PUF | resolution: plan, interval: yearly
  • rate_review_wksh1: Unified Rate Review Public Use File Worksheet 1 | resolution: health_plan, interval: yearly
  • rate_review_wksh2: Unified Rate Review Public Use File Worksheet 2 | resolution: health_plan, interval: yearly

CMS Office of Minority Health - mimi_ws_1.cmsomh

• Description: Datasets from the CMS Office of Minority Health site
• Tables:
  • archive_index: Office of Minority Health reports and URLs | resolution: report, interval: snapshot
  • text_from_pdfs: Parsed Text from PDFs, Office of Minority Health Reports | resolution: reports, interval: snapshot

CMS Payment Section - mimi_ws_1.cmspayment

• Description: Datasets from the CMS Payment Section.
• Tables:
  • bpt_ma_1: Bid Pricing Tool MA Worksheet 1 Base Period Experience and Projection Assumptions | resolution: health_plan, interval: yearly
  • bpt_ma_2: Bid Pricing Tool MA Worksheet 2 Projected Allowed Costs PMPM | resolution: health_plan, interval: yearly
  • bpt_ma_3: Bid Pricing Tool MA Worksheet 3 Projected Cost Sharing PMPM | resolution: health_plan, interval: yearly
  • bpt_ma_4: Bid Pricing Tool MA Worksheet 4 Projected Revenue Requirement PMPM | resolution: health_plan, interval: yearly
  • bpt_ma_5: Bid Pricing Tool MA Worksheet 5 Benchmark PMPM | resolution: health_plan, interval: yearly
  • bpt_ma_6: Bid Pricing Tool MA Worksheet 6 Bid Summary | resolution: health_plan, interval: yearly
  • bpt_ma_7: Bid Pricing Tool MA Worksheet 7 Optional Supplemental Benefits | resolution: health_plan, interval: yearly
  • ffs_data: Medicare FFS Data summarized by county | resolution: county, interval: yearly
  • ipsf_hha: Provider Specific File (PSF) Home Health Agency | interval: monthly, resolution: facility
  • ipsf_hos: Provider Specific File (PSF) Hospice | interval: monthly, resolution: facility
  • ipsf_inp: Provider Specific File (PSF) Inpatient | interval: monthly, resolution: facility
  • ipsf_ipf: Provider Specific File (PSF) Inpatient Psychiatric Facility | interval: monthly, resolution: facility
  • ipsf_irf: Provider Specific File (PSF) Inpatient Rehab | interval: monthly, resolution: facility
  • ipsf_ltch: Provider Specific File (PSF) Long Term Care | interval: monthly, resolution: facility
  • ipsf_snf: Provider Specific File (PSF) Skilled Nursing Facility | interval: monthly, resolution: facility
  • ma_ratebook: Medicare Advantage Rate Book by county | resolution: county, interval: yearly
  • mac_locality: MAC (Medicare Administrative Contractor) Locality Codes | resolution: mac, interval: yearly
  • msdrg_cc: MS-DRG List of Complications or Comorbidities (CCs) | resolution: code, interval: yearly
  • msdrg_dx2drg: MS-DRG Diagnosis-to-DRG Mapping | resolution: code, interval: yearly
  • msdrg_index: MS-DRG Names, Descriptions, and Versions | resolution: code, interval: yearly
  • msdrg_mcc: MS-DRG List of Major Complications or Comorbidities (MCCs) | resolution: code, interval: yearly
  • opps_addendum_a: Outpatient Prospective Payment System (OPPS) Addendum A | resolution: code, interval: quarterly
  • opps_addendum_b: Outpatient Prospective Payment System (OPPS) Addendum B | resolution: code, interval: quarterly
  • opsf_full: Provider Specific File (PSF) Outpatient | interval: monthly, resolution: facility
  • pace_ratebook: PACE Rate Book by county | resolution: county, interval: yearly
  • partb_drug_asp_ndc_to_hcpcs: ASP NDC-HCPCS Crosswalk | resolution: code, interval: quarterly
  • partb_drug_asp_pricing: Average Sales Pricing (ASP) - Pricing File | resolution: code, interval: quarterly
  • partb_drug_awp_ndc_to_hcpcs: AWP NDC-HCPCS Crosswalk | resolution: code, interval: quarterly
  • partb_drug_noc_ndc_to_hcpcs: NOC NDC-HCPCS Crosswalk | resolution: code, interval: quarterly
  • partb_drug_noc_pricing: Not Otherwie Classified (NOC) - Pricing File | resolution: code, interval: quarterly
  • partb_drug_opps_ndc_to_hcpcs: OPPS NDC-HCPCS Crosswalk | resolution: code, interval: quarterly
  • physicianfeeschedule: Physician Fee Schedules National Payment Amount File | resolution: code, interval: quarterly
  • physicianfeeschedule_metadata: Physician Fee Schedules Download Metadata, e.g. webpage URL, dataset name, comment | resolution: variable, interval: quarterly
  • ra_coefficients: Risk Adjustment Coefficient Values | resolution: code, interval: yearly
  • ra_dx_to_cc_mapping: ICD-10-CM to CC mapping | resolution: code, interval: yearly
  • ra_eligible_cpt_hcpcs: Eligible CPT/HCPCS Codes for Risk Adjustment | resolution: code, interval: yearly
  • ra_hierarchies: Hierarchies of Condition Categories (CCs) | resolution: code, interval: yearly
  • ra_labels: Labels for Condition Categories | resolution: code, interval: yearly
  • ra_report_to_congress: Risk Adjustment Report-to-Congress Data | resolution: code, interval: yearly
  • rvu_gpci: Geographic Practice Cost Index (GPCI) | resolution: code, interval: quarterly
  • rvu_oppscap: Outpatient Prospective Payment System Caps for RVUs | resolution: code, interval: quarterly
  • rvu_pprrvu: Physician Procedure RVU (PPRRVU) | resolution: code, interval: quarterly
  • zip5_to_carrier: ZIPCODE TO CARRIER LOCALITY FILE | resolution: zipcode, interval: yearly

CMS Health & Safety Standards - mimi_ws_1.cmssafetystandards

• Description: Datasets from CMS Health Saftey Standards
• Tables:
  • termination_notices: Medicare Termination Notices | resolution: provider, interval: monthly

CSSC Operations - mimi_ws_1.csscoperations

• Description: Datasets from CMS Customer Servie Support Center (CSSC)
• Tables:
  • 277ca_edit_lookup: 277CA Edit Lookup | resolution: code, interval: snapshot
  • acceptable_physician_specialties: Acceptable Physician Specialty Types | resolution: code, interval: yearly
  • cem_837_edit_lookup: Combined Common Edit Module (CEM) 837 Edit Lookup | resolution: code, interval: snapshot
  • ed_control_segments: Ecounter Data Control Segments | resolution: code, interval: yearly
  • ed_deactivated_edits: Ecounter Data Deactivated Edits | resolution: code, interval: yearly
  • ed_loops_segments: Ecounter Data Loops and Segments | resolution: code, interval: yearly
  • edps_edit_lookup: EDPS Edit Lookup | resolution: code, interval: snapshot
  • feras_edit_lookup: Front End Risk Adjustment System (FERAS) Edit Lookup | resolution: code, interval: snapshot
  • listservs: ListServs | resolution: email, interval: snapshot
  • outpatient_cpt_exlusions: Outpatient CPT/HCPCS Exclusion List | resolution: code, interval: yearly
  • raps_edit_lookup: Risk Adjustment Processing System (RAPS) Edit Lookup | resolution: code, interval: snapshot
  • references_index: Reference Files Index Table, PartC, FAI, PartD | resolution: files, interval: snapshot
  • sbsc_codes: Supplemental Benefit Services Category Codes | resolution: code, interval: yearly
  • sbsc_minimum_data_elements: Supplemental Benefit Services Category Minimum Data Elements | resolution: code, interval: yearly
  • ta1_edit_lookup: The Interchange Acknowledgement (TA1) Edit Lookup | resolution: code, interval: snapshot

Dartmouth - mimi_ws_1.dartmouth

• Description: Dartmouth Atlas Project
• Tables:
  • cardiac_care: Cardiac Care Hospital Data, 1996-2014 | resolution: hospital, interval: snapshot
  • hosp_cost: Hospital Cost File, 1998-2012 | resolution: hospital, interval: snapshot
  • hosp_tracking_file: Hospoital Profile Tracking, 1992-2019 | resolution: hospital, interval: snapshot
  • medpar_dgns_cd10: Coding Trends, Inpatient, 2015-2018 | resolution: code, interval: snapshot
  • op_dgns_cd10: Coding Trends, Outpatient, 2015-2018 | resolution: code, interval: snapshot
  • ptb_dgns_cd10: Coding Trends, PartB, 2015-2018 | resolution: code, interval: snapshot
  • ziphsahrr: ZIP HSA HRR Crosswalk | resolution: zipcode, interval: snapshot

Data.CMS.gov - mimi_ws_1.datacmsgov

• Description: Datasets from the CMS Open Data Site, data.cms.gov, by the Centers for Medicare & Medicaid Services (CMS)
• Tables:
  • acoreach_eligible_beneficiaries: ACO REACH Eligible Beneficiaries | resolution: county, interval: yearly
  • acoreach_providers: ACO REACH Providers | resolution: provider, interval: yearly
  • betos: Restructured BETOS Classification System (RBCS) | resolution: code, interval: yearly
  • cmmi_participants: Innovation Center Model Participants | resolution: provider, interval: snapshot
  • cmmi_reports: Innovation Center Data and Reports | resolution: program, interval: snapshot
  • covid19nursinghomes: COVID-19 Nursing Home Data | resolution: nursing_home, interval: weekly
  • datacatalog: The Data Catalog (metadata) of the data.cms.gov site | resolution: dataset, interval: weekly
  • geovariation: Medicare Geographic Variation - by National, State & County | resolution: county, interval: yearly
  • market_saturation_cbsa: Market Saturation & Utilization CBSA | resolution: cbsa, interval: yearly
  • market_saturation_state_county: Market Saturation & Utilization State-County | resolution: county, interval: yearly
  • mcbs_fall: Medicare Current Beneficiary Survey (MCBS), Fall | resolution: respondent, interval: yearly
  • mcbs_summer: Medicare Current Beneficiary Survey (MCBS), Summer | resolution: respondent, interval: yearly
  • mcbs_winter: Medicare Current Beneficiary Survey (MCBS), Winter | resolution: respondent, interval: yearly
  • mssp_county_lvl_expenditures: Medicare Shared Savings Program County-level Aggregate Expenditure and Risk Score Data | resolution: county, interval: yearly
  • mssp_orgs: MSSP Accountable Care Organizations | resolution: aco, interval: yearly
  • mssp_participants: MSSP Accountable Care Organization Participants | resolution: aco, interval: yearly
  • mssp_regional_trend_factors: MSSP Regional Trend Factor derived from mssp_county_lvl_expenditures | resolution: county, interval: yearly
  • mssp_results: Medicare Shared Savings Program (MSSP) Performance Year Financial and Quality Results | resolution: aco, interval: yearly
  • mupdme: Medicare Durable Medical Equipment, Devices & Supplies by Referring Provider and Service | resolution: provider x service, interval: yearly
  • mupdme_geo: Medicare Durable Medical Equipment, Devices & Supplies by Geography and Service | resolution: state x dme, interval: yearly
  • mupdme_prvdr: Medicare Durable Medical Equipment, Devices & Supplies by Referring Provider | resolution: provider, interval: yearly
  • mupdme_sup: Medicare Durable Medical Equipment, Devices & Supplies by Supplier | resolution: supplier, interval: yearly
  • mupdme_suphpr: Medicare Durable Medical Equipment, Devices & Supplies by Supplier and Service | resolution: supplier x service, interval: yearly
  • mupdpr: Medicare Part D Prescribers by Prescriber and Drug | resolution: provider x drug, interval: yearly
  • mupdpr_geo: Medicare Part D Prescribers by Geography and Drug | resolution: state x drug, interval: yearly
  • mupdpr_prvdr: Medicare Part D Prescribers by Prescriber | resolution: provider, interval: yearly
  • mupihp: Medicare Inpatient Hospitals by Provider and Service | resolution: hospital, interval: yearly
  • mupihp_geo: Medicare Inpatient Hospitals by Geography and Service | resolution: state x service, interval: yearly
  • mupihp_prvdr: Medicare Inpatient Hospitals by Provider | resolution: hospital, interval: yearly
  • mupohp: Medicare Outpatient Hospitals by Provider and Service | resolution: outpatient_hospital x service, interval: yearly
  • mupohp_geo: Medicare Outpatient Hospitals by Geography and Service | resolution: state x service, interval: yearly
  • muppac_geo_legacy: Medicare Post-Acute Care and Hospice by Geography & Provider | resolution: post_acute_care_site, interval: yearly
  • muppac_hh_geo: Medicare Post-Acute Care Utilization - Home Health Agencies and their Geographic Summaries | resolution: home_health_agency, interval: yearly
  • muppac_hh_geo_w_casemix: Medicare Post-Acute Care Utilization - Home Health Agency by Geography/Provider and Case-Mix Grouping | resolution: home_health_agency, interval: yearly
  • muppac_hos_geo: Medicare Post-Acute Care Utilization - Hospices and their Geographic Summaries | resolution: hospice_agency, interval: yearly
  • muppac_irf_geo: Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facilities and their Geographic Summaries | resolution: facility, interval: yearly
  • muppac_irf_geo_w_casemix: Medicare Post-Acute Care Utilization - Inpatient Rehabilitation Facility by Geography/Provider and Case-Mix Grouping | resolution: facility, interval: yearly
  • muppac_ltc_geo: Medicare Post-Acute Care Utilization - Long-Term Care Hospitals and their Geographic Summaries | resolution: facility, interval: yearly
  • muppac_snf_geo: Medicare Post-Acute Care Utilization - Skilled Nursing Facilities and their Geographic Summaries | resolution: nursing_facility, interval: yearly
  • muppac_snf_geo_w_casemix: Medicare Post-Acute Care Utilization - Skilled Nursing Facility by Geography/Provider and Case-Mix Grouping | resolution: nursing_facility, interval: yearly
  • mupphy: Medicare Physician & Other Practitioners by Provider and Service | resolution: provider x service, interval: yearly
  • mupphy_geo: Medicare Physician & Other Practitioners by Geography and Service | resolution: state x service, interval: yearly
  • mupphy_prvdr: Medicare Physician & Other Practitioners by Provider | resolution: provider, interval: yearly
  • nursinghome_ae_perf: Nursing Home Affiliated Entity Performance | resolution: nursing_home, interval: monthly
  • optout: Medicare Opt Out Affidavits | resolution: provider, interval: monthly
  • orderandreferring: Medicare Order and Referring Eligible Providers | resolution: provider, interval: weekly
  • otpp: Medicare Opioid Treatment Program Providers | resolution: provider, interval: weekly
  • partb_discarded_drugs: Medicare Part B Discarded Drug Units | resolution: drug, interval: yearly
  • pbj_nonnurse: Payroll Based Journal Daily Non-Nurse Staffing | resolution: nursing_home, interval: quarterly
  • pbj_nurse: Payroll Based Journal Daily Nurse Staffing | resolution: nursing_home, interval: quarterly
  • pc_fqhc: Federally Qualified Health Center Medicare Enrollments | resolution: fqhc, interval: quarterly
  • pc_fqhc_owner: FQHC All Ownership Information | resolution: fqhc, interval: quarterly
  • pc_homehealth: Home Health Agency Medicare Enrollments | resolution: home_health_organization, interval: quarterly
  • pc_homehealth_owner: Home Health All Ownership Information | resolution: home_health_agency, interval: quarterly
  • pc_homeinfusion: Home Infusion Therapy Provider Medicare Enrollments | resolution: home_infusion_provider, interval: weekly
  • pc_hospice: Hospice Medicare Enrollments | resolution: hospice_agency, interval: quarterly
  • pc_hospice_owner: Hospice All Ownership Information | resolution: hospice_agency, interval: quarterly
  • pc_hospital: Hospital Medicare Enrollments | resolution: hospital, interval: monthly
  • pc_hospital_owner: Hospital All Ownership Information | resolution: hospital, interval: quarterly
  • pc_provider: Medicare Fee-For-Service Public Provider Medicare Enrollment | resolution: provider, interval: quarterly
  • pc_ruralhealthclinic: Rural Health Clinic Medicare Enrollments | resolution: rural_health_clinic, interval: quarterly
  • pc_ruralhealthclinic_owner: Rural Health Clinic All Ownership Information | resolution: rural_health_clinic, interval: quarterly
  • pc_snf: Skilled Nursing Facility Medicare Enrollments | resolution: skilled_nursing_facility, interval: monthly
  • pc_snf_owner: SNF All Ownership Information | resolution: skilled_nursing_facility, interval: quarterly
  • pendingilt: Medicare Enrollment, Pending Initial Logging and Tracking | resolution: provider, interval: weekly
  • psps: Physician/Supplier Procedure Summary | resolution: code, interval: yearly
  • qpp: Quality Payment Program, e.g., MIPS, APMs, Performance Results | resolution: provider, interval: yearly
  • revalidation: Medicare Revalidation Clinic Group Practice Reassignment | resolution: provider, interval: monthly
  • taxonomy_crosswalk: Medicare Provider and Supplier Taxonomy Crosswalk | interval: quarterly, resolution: code

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 Healthcare.gov Open Data Site, data.healthcare.gov
• Tables:
  • formulary_details: Plan Formulary Details, e.g., Drug Name, RxNorm ID from the MRF Provider Directories | resolution: health_plan, interval: monthly
  • mrf_xlsx: Machine Readable File (MRF) URLs | resolution: dataset, interval: monthly
  • plan: Plan Information from the MRF Provider Directories | resolution: health_plan, interval: monthly
  • plan_formulary_base: Plan Formulary Base Information from the MRF Provider Directories | resolution: health_plan, interval: monthly
  • provider_addresses: Provider Addresses from the MRF Provider Directories | resolution: provider, interval: monthly
  • provider_base: Provider Directory (base table) from the MRF Provider Directories | resolution: provider, interval: monthly
  • provider_plans: Provider to Contracted Plans from the MRF Provider Directories | resolution: provider, interval: monthly

Data.Medicaid.gov - mimi_ws_1.datamedicaidgov

• Description: Datasets from the Medicaid Open Data Site, data.medicaid.gov
• Tables:
  • drugutilization: Medicaid State Drug Utilization | resolution: state, interval: quarterly
  • medicaid_app_det: State Medicaid and CHIP Applications, Eligibility Determinations, and Enrollment Data | resolution: state, interval: monthly
  • medicaid_elig_proc: State Medicaid and CHIP Eligibility Processing Data | resolution: state, interval: monthly
  • mlrsummary: MLR Summary Report | resolution: health_plan, interval: yearly
  • nadac: NADAC (National Average Drug Acquisition Cost) | resolution: drug, interval: weekly
  • quality: Child and Adult Health Care Quality Measures Quality | resolution: state, interval: yearly

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 2010, DE-SynPUF | resolution: synthetic_beneficiary, interval: snapshot
  • carrier_claims: Carrier Claims from 2008 to 2010, DE-SynPUF | resolution: synthetic_event, interval: snapshot
  • inpatient_claims: Inpatient Claims from 2008 to 2010, DE-SynPUF | resolution: synthetic_event, interval: snapshot
  • outpatient_claims: Outpatient Claims from 2008 to 2010, DE-SynPUF | resolution: synthetic_event, interval: snapshot
  • prescription_drug_events: Prescription Drug Events from 2008 to 2010, DE-SynPUF | resolution: synthetic_event, interval: snapshot

Environmental Protection Agency - mimi_ws_1.epa

• Description: Datasets from the U.S. Environmental Protection Agency
• Tables:
  • airdata_daily: Pre-generated Daily Data by Monitor | resolution: monitoring_site, interval: daily
  • airdata_daily_cbsa: Pre-generated Daily AQI by CBSA | resolution: cbsa, interval: daily
  • airdata_daily_county: Pre-generated Daily AQI by County | resolution: county, interval: daily
  • airdata_yearly: Pre-generated Yearly Data by Monitor | resolution: monitoring_site, interval: yearly
  • airdata_yearly_cbsa: Pre-generated Yearly AQI by CBSA | resolution: cbsa, interval: yearly
  • airdata_yearly_county: Pre-generated Yearly AQI by County | resolution: county, interval: yearly

Federal Communications Commision - mimi_ws_1.fcc

• Description: Datasets from the Federal Communications Commision (FCC)
• Tables:
  • c2h_maternal_counties: Connect2Health Broadband and Maternal Health, County Level | resolution: county, interval: snapshot
  • c2h_maternal_states: Connect2Health Broadband and Maternal Health, State Level | resolution: state, interval: snapshot
  • c2h_opioids_chronic_counties: Connect2Health Broadband and Opioids and Chronic Conditions, County Level | resolution: county, interval: snapshot
  • c2h_opioids_chronic_states: Connect2Health Broadband and Opioids and Chronic Conditions, State Level | resolution: state, interval: snapshot

FDA - mimi_ws_1.fda

• Description: Datasets from the U.S. Food & Drug Administration (FDA)
• Tables:
  • adverse_event_base: Drug Adverse Event, Base Table | resolution: event, interval: quarterly
  • adverse_event_drug: Drug Table, a part of the Drug Adverse Event Base table | resolution: event, interval: quarterly
  • adverse_event_reaction: Reaction Table, a part of the Drug Adverse Event Base table | resolution: event, interval: quarterly
  • approved_drugs: Drug Approval Reports by Month | resolution: drug, interval: monthly
  • device_510k: Device 510k | resolution: device, interval: monthly
  • device_registrationlisting: Device Registrations and Listings | resolution: device, interval: monthly
  • enforcement: Drug Recall Enforcement, Base Table | resolution: event, interval: monthly
  • enforcement_ndc_detail: Package NDC Table, a part of the Drug Recall Enforcement, Base Table | resolution: event, interval: monthly
  • foiclass: Product Code Classification | resolution: product_code, interval: snapshot
  • ndc_directory: NDC Directory | resolution: drug, interval: monthly
  • ndc_label: Drug Package Labels, full text | resolution: drug, interval: monthly
  • ndc_to_active_ingredients: NDC to Active Ingredients Mapping, a part of the NDC Directory | resolution: drug, interval: monthly
  • ndc_to_pharm_class: NDC to Pharmacologic Class Mapping, a part of the NDC Directory | resolution: drug, interval: monthly
  • ndc_to_rxcui: NDC to RxCUI Mapping, a part of the NDC Directory | resolution: drug, interval: monthly
  • novel_drugs: Novel Drug Approvals | resolution: drug, interval: monthly
  • orangebook_exclusivity: Exclusivity info from the Approved Drug Products with Therapeutic Equivalence Evaluations, aka Orange Book | resolution: drug, interval: weekly
  • orangebook_patent: Patent info from the Approved Drug Products with Therapeutic Equivalence Evaluations, aka Orange Book | resolution: drug, interval: weekly
  • orangebook_products: Product info from the Approved Drug Products with Therapeutic Equivalence Evaluations, aka Orange Book | resolution: drug, interval: weekly
  • orphan_drugs: Orphan Drug Designations and Approvals | resolution: drug, interval: monthly
  • purplebook: All FDA-licensed (approved) biological products regulated by the Center for Drug Evaluation and Research (CDER), aka Purple Book | resolution: drug, interval: monthly

Foursquare - mimi_ws_1.foursquare

• Description: Datasets from Foursquare Labs, Inc. (aka Foursquare)
• Tables:
  • categories: FSQ Categories | resolution: place_category, interval: snapshot
  • places: FSQ Places | resolution: place, interval: monthly

Graham Center - mimi_ws_1.grahamcenter

• Description: Datasets from the Robert Graham Center - a research arm of AAFP
• Tables:
  • gme: Graduate Medical Education Dataset | resolution: hospital, interval: yearly
  • sdi_censustract: Social Deprivation Index (SDI) at Census Tract Level | resolution: tract, interval: yearly
  • sdi_county: Social Deprivation Index (SDI) at County Level | resolution: county, interval: yearly
  • sdi_pcsa: Social Deprivation Index (SDI) at PCSA (Primary Care Service Area) Level | resolution: pcsa, interval: yearly
  • sdi_zcta: Social Deprivation Index (SDI) at ZIP-code Level | resolution: zcta, interval: yearly

Grants.gov - mimi_ws_1.grants

• Description: Data from the HHS Open Grants Data site, grants.gov
• Tables:
  • grants_xml_extracts: Grants Daily XML Extracts | resolution: grant, interval: daily

HealthIT - mimi_ws_1.healthit

• Description: Datasets from the Assistant Secretary for Technology Policy, formerly known as the Office of National Coordinator for Health Information Technology (ONC), HealthIT.gov - the official website of the Office of the National Coordinator for Health Information Technology (ONC)
• Tables:
  • chit_cpip: Certified Health Information Technology Reported by Clinicians for Promoting Interoperability Performance | resolution: provider, interval: yearly

HHS-OIG - mimi_ws_1.hhsoig

• Description: Datasets from the HHS Office of Inspector General
• Tables:
  • buprenorphine_countydata: Buprenorphine-Waivered Providers, County Data | resolution: county, interval: snapshot
  • enforcement_details: OIG Enforcement Details Raw Text | resolution: case, interval: daily
  • enforcement_details_enriched: OIG Enforcement Details LLM Extracted | resolution: case, interval: daily
  • enforcement_summaries: OIG Enforcement Summaries | resolution: case, interval: daily
  • leie: List of Excluded Individuals/Entities (LEIE) | resolution: provider, interval: monthly
  • risk_adjustment_toolkit_2023: Risk Adjustment Toolkit Target Codes | resolution: code, interval: snapshot
  • workplans: Work Plans | resolution: workplan, interval: monthly

HRSA - mimi_ws_1.hrsa

• Description: Datasets from the Health Resources & Services Administration (HRSA)
• Tables:
  • hpsa_fct_det_dh: Health Professional Shortage Areas (HPSA) for Dental Health | resolution: hpsa_area, interval: yearly
  • hpsa_fct_det_mh: Health Professional Shortage Areas (HPSA) for Mental Health | resolution: hpsa_area, interval: yearly
  • hpsa_fct_det_pc: Health Professional Shortage Areas (HPSA) for Primary Care | resolution: hpsa_area, interval: yearly
  • mua_det: Medically Underserved Areas/Populations (MUA/P) | resolution: muap_area | interval: yearly
  • unmet_need_score: Unmet Need Score | resolution: zip, interval: yearly

HUDUser - mimi_ws_1.huduser

• Description: Datasets from the Department of Housing and Urban Development - 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) | reslution: cbsa, interval: yearly
  • cbsa_to_zip_otm: CBSA to ZIP crosswalk, one-to-many (otm) mapping based on the residential size, mimi-derived data | resolution: cbsa, interval: latest
  • county_to_zip: County to ZIP Code Crosswalk (raw data) | resolution: county, interval: yearly
  • county_to_zip_otm: County to ZIP crosswalk, one-to-many (otm) mapping based on the residential size, mimi-derived data | resolution: county, interval: latest
  • tract_to_zip: Census Tract to ZIP Code Crosswalk (raw data) | resolution: tract, interval: yearly
  • tract_to_zip_mto: Census Tract to ZIP crosswalk, many-to-one (mto) mapping based on the residential size, mimi-derived data | resolution: tract, interval: latest
  • zip_to_cbsa: ZIP Code to Core-Based Statistical Area (CBSA) (raw data) | resolution: zip, interval: yearly
  • zip_to_cbsa_mto: ZIP to CBSA crosswalk, many-to-one (mto) mapping based on the residential size, mimi-derived data | resolution: zip, interval: latest
  • zip_to_county: ZIP Code to County Crosswalk (raw data) | resolution: zip, interval: yearly
  • zip_to_county_mto: ZIP to County crosswalk, many-to-one (mto) mapping based on the residential size, mimi-derived data | resolution: zip, interval: latest
  • zip_to_tract: ZIP Code to Census Tract Crosswalk (raw data) | resolution: zip, interval: yearly
  • zip_to_tract_otm: ZIP to Census Tract crosswalk, one-to-many (otm) mapping based on the residential size, mimi-derived data | resolution: zip, interval: latest

Internal Revenue Service - mimi_ws_1.irs

• Description: Datasets from the Internal Revenue Service
• Tables:
  • zpallagi: Individual income tax statistics - ZIP Code data (SOI) | resolution: zip, interval: yearly

Legacy.com - mimi_ws_1.legacycom

• Description: Datasets from Legacy.com, Inc.
• Tables:
  • obituaries: Scraped Obituaries | resolution: person, interval: weekly

CMS Medicare Coverage Database - mimi_ws_1.mcd

• Description: Datasets from the CMS Medicare Coverage Database
• Tables:
  • article: ARTICLE | resolution: article, interval: monthly
  • article_future_retire: ARTICLE_FUTURE_RETIRE | resolution: article, interval: monthly
  • article_related_documents: ARTICLE_RELATED_DOCUMENTS | resolution: article, interval: monthly
  • article_related_ncd_documents: ARTICLE_RELATED_NCD_DOCUMENTS | resolution: article, interval: monthly
  • article_related_source_icd9: ARTICLE_RELATED_SOURCE_ICD9 | resolution: article, interval: monthly
  • article_type_lookup: ARTICLE_TYPE_LOOKUP | resolution: article, interval: monthly
  • article_url_type_lookup: ARTICLE_URL_TYPE_LOOKUP | resolution: article, interval: monthly
  • article_x_bill_code: ARTICLE_X_BILL_CODE | resolution: article, interval: monthly
  • article_x_code_table: ARTICLE_X_CODE_TABLE | resolution: article, interval: monthly
  • article_x_contractor: ARTICLE_X_CONTRACTOR | resolution: article, interval: monthly
  • article_x_hcpc_code: ARTICLE_X_HCPC_CODE | resolution: article, interval: monthly
  • article_x_hcpc_code_group: ARTICLE_X_HCPC_CODE_GROUP | resolution: article, interval: monthly
  • article_x_hcpc_modifier: ARTICLE_X_HCPC_MODIFIER | resolution: article, interval: monthly
  • article_x_hcpc_modifier_group: ARTICLE_X_HCPC_MODIFIER_GROUP | resolution: article, interval: monthly
  • article_x_icd10_covered: ARTICLE_X_ICD10_COVERED | resolution: article, interval: monthly
  • article_x_icd10_covered_group: ARTICLE_X_ICD10_COVERED_GROUP | resolution: article, interval: monthly
  • article_x_icd10_noncovered: ARTICLE_X_ICD10_NONCOVERED | resolution: article, interval: monthly
  • article_x_icd10_noncovered_group: ARTICLE_X_ICD10_NONCOVERED_GROUP | resolution: article, interval: monthly
  • article_x_icd10_pcs_code: ARTICLE_X_ICD10_PCS_CODE | resolution: article, interval: monthly
  • article_x_icd10_pcs_code_group: ARTICLE_X_ICD10_PCS_CODE_GROUP | resolution: article, interval: monthly
  • article_x_other_coding_group: ARTICLE_X_OTHER_CODING_GROUP | resolution: article, interval: monthly
  • article_x_primary_jurisdiction: ARTICLE_X_PRIMARY_JURISDICTION | resolution: article, interval: monthly
  • article_x_response_to_comment: ARTICLE_X_RESPONSE_TO_COMMENT | resolution: article, interval: monthly
  • article_x_revenue_code: ARTICLE_X_REVENUE_CODE | resolution: article, interval: monthly
  • article_x_revision_history: ARTICLE_X_REVISION_HISTORY | resolution: article, interval: monthly
  • article_x_sticky_note: ARTICLE_X_STICKY_NOTE | resolution: article, interval: monthly
  • article_x_urls: ARTICLE_X_URLS | resolution: article, interval: monthly
  • contractor: CONTRACTOR | resolution: contractor, interval: monthly
  • contractor_jurisdiction: CONTRACTOR_JURISDICTION | resolution: contractor, interval: monthly
  • contractor_oversight: CONTRACTOR_OVERSIGHT | | resolution: contractor, interval: monthly
  • contractor_subtype_lookup: CONTRACTOR_SUBTYPE_LOOKUP | resolution: contractor, interval: monthly
  • contractor_type_lookup: CONTRACTOR_TYPE_LOOKUP | resolution: contractor, interval: monthly
  • dmerc_region_lookup: DMERC_REGION_LOOKUP | resolution: region, interval: monthly
  • lcd: LCD | resolution: article, interval: monthly
  • lcd_future_retire: LCD_FUTURE_RETIRE | resolution: article, interval: monthly
  • lcd_related_documents: LCD_RELATED_DOCUMENTS | resolution: article, interval: monthly
  • lcd_related_ncd_documents: LCD_RELATED_NCD_DOCUMENTS | resolution: article, interval: monthly
  • lcd_related_source_icd9: LCD_RELATED_SOURCE_ICD9 | resolution: article, interval: monthly
  • lcd_url_type_lookup: LCD_URL_TYPE_LOOKUP | resolution: article, interval: monthly
  • lcd_x_advisory_committee: LCD_X_ADVISORY_COMMITTEE | resolution: article, interval: monthly
  • lcd_x_contractor: LCD_X_CONTRACTOR | resolution: article, interval: monthly
  • lcd_x_hcpc_code: LCD_X_HCPC_CODE | resolution: article, interval: monthly
  • lcd_x_hcpc_code_group: LCD_X_HCPC_CODE_GROUP | resolution: article, interval: monthly
  • lcd_x_primary_jurisdiction: LCD_X_PRIMARY_JURISDICTION | resolution: article, interval: monthly
  • lcd_x_reason_change: LCD_X_REASON_CHANGE | resolution: article, interval: monthly
  • lcd_x_requestor_letters: LCD_X_REQUESTOR_LETTERS | resolution: article, interval: monthly
  • lcd_x_revision_history: LCD_X_REVISION_HISTORY | resolution: article, interval: monthly
  • lcd_x_sticky_note: LCD_X_STICKY_NOTE | resolution: article, interval: monthly
  • lcd_x_synopsis_changes_fields: LCD_X_SYNOPSIS_CHANGES_FIELDS | resolution: article, interval: monthly
  • lcd_x_urls: LCD_X_URLS | resolution: article, interval: monthly
  • ncd_bnft_ctgry_ref: NCD Benefit Category Reference | resolution: benefit_code, interval: monthly
  • ncd_pblctn_ref: NCD Publication Reference | resolution: publication, interval: monthly
  • ncd_trkg: National Coverage Determination (main table) | resolution: article, interval: monthly
  • ncd_trkg_bnft_xref: NCD Main Table to Benefit Category XREF Table | resolution: benefit_code, interval: monthly
  • region_lookup: REGION_LOOKUP | resolution: article, interval: monthly
  • state_lookup: STATE_LOOKUP | resolution: state, interval: monthly
  • state_x_region: STATE_X_REGION | resolution: article, interval: monthly
  • update_period: UPDATE_PERIOD | resolution: article, interval: monthly

State Medical Boards - mimi_ws_1.medicalboard

• Description: Datasets from Various State Medical Boards - currently CA, FL, NY
• Tables:
  • ca_disciplinary_actions: California Medical Board Disciplinary Actions | resolution: provider, interval: weekly
  • fl_disciplinary_actions: Florida Medical Board Disciplinary Actions | resolution: provider, interval: daily
  • ny_disciplinary_actions: New York Department of Health Disciplinary Actions | resolution: provider, interval: weekly
  • ny_ed_enforcement_actions: New York Board of Regents Enforcement Actions | resolution: provider, interval: weekly

MedlinePlus - mimi_ws_1.medlineplus

• Description: Datasets from MedlinePlus by the National Library of Medicine
• Tables:
  • also_called: Alternative names or terms for health topics from MedlinePlus | resolution: term, interval: latest
  • health_topic: Main information for each individual health topic from MedlinePlus | resolution: health_topic, interval: latest
  • information_category: Categories of information for each site from MedlinePlus | resolution: health_topic, interval: latest
  • language_mapped_topic: Information about topic translations or language variants from MedlinePlus | resolution: health_topic, interval: latest
  • mesh_heading: Medical Subject Headings (MeSH) descriptors for topics from MedlinePlus | resolution: health_topic, interval: latest
  • mesh_qualifier: MeSH qualifiers associated with MeSH descriptors from MedlinePlus | resolution: mesh, interval: latest
  • organization: Organizations associated with each site from MedlinePlus | resolution: organization, interval: latest
  • other_language: Information about the topic in other languages from MedlinePlus | resolution: health_topic, interval: latest
  • primary_institute: Information about the primary institute associated with a topic from MedlinePlus | resolution: health_topic, interval: latest
  • related_topic: Information about topics related to the main topic from MedlinePlus | resolution: health_topic, interval: latest
  • see_reference: Cross-references or "see also" type information from MedlinePlus | resolution: health_topic, interval: latest
  • site: Information about external sites related to the topic from MedlinePlus | resolution: website, interval: latest
  • standard_description: Standard descriptions for each site from MedlinePlus | resolution: website, interval: latest
  • topic_group: Group information associated with health topics from MedlinePlus | resolution: health_topic, interval: latest

mimilabs - mimi_ws_1.mimilabs

• Description: Datasets from mimilabs.
• Tables:
  • cms_emails_extracts: CMS Email ListServ Subscriptions (Extracts) | resolution: email, interval: daily
  • cms_emails_raw: CMS Email ListServ Subscriptions (Raw) | resolution: email, interval: daily
  • columnstats: ColumnStats provides a snapshot of the column details for each table in the mimilabs data warehouse | resolution: variable, interval: daily
  • google_emails_raw: Google Alert Email Subscriptions, Keyword: Centers for Medicare & Medicaid Services | resolution: email, interval: daily
  • kff_emails_raw: Kaiser Family Foundation Email Subscriptions | resolution: email, interval: daily
  • tablestats: TableStats provides a snapshot of the table source date, load date, data statistics for each table in the mimilabs workspace. | resolution: table, interval: daily

National Association of State Budget Officers - mimi_ws_1.nasbo

• Description: Datasets from the National Association of State Budget Officers.
• Tables:
  • general_fund_revenue: State General Fund Revenue data ($ in Millions). | resolution: state, interval: yearly
  • rainy_day_fund_balances: State Rainy Day Balances data ($ in Millions). | resolution: state, interval: yearly
  • state_expenditure: State Expenditure Report data ($ in Millions). | resolution: state, interval: yearly

NBER - mimi_ws_1.nber

• Description: Datasets from the National Bureau of Economic Research
• Tables:
  • ssa2fips_state_and_county: SSA to FIPS crowsswalk | resolution: ssa, interval: snapshot

Neighborhood Atlas - mimi_ws_1.neighborhoodatlas

• Description: Datasets from the Neighborhood Atlas Area by UW-Madison
• Tables:
  • adi_censusblock: Area Deprivation Index (ADI) Original (Census Block Group Level) | resolution: census_block_group, interval: yearly
  • adi_censustract: Area Deprivation Index (ADI) Aggregated (Census Tract Level, mimi-derived data, USE WITH CAUTION) | resolution: tract, interval: yearly
  • adi_county: Area Deprivation Index (ADI) Aggregated (Census Block Group Level, mimi-derived data, USE WITH CAUTION) | resolution: county, interval: yearly

National Library of Medicine - mimi_ws_1.nlm

• Description: Datasets from the National Library of Medicine.
• Tables:
  • historical_ndcs: Historical NDCs for RxCUI | resolution: ndc, interval: monthly
  • rxn_all_pathways: RxNorm All Pathways, inspired by the Google Health's all pathways dataset, mimi-derived data | resolution: rxcui, interval: latest
  • rxnconso: RxNorm Concept Names and Soruces (RXNCONSO), Prescribable Content | resolution: rxcui, interval: monthly
  • rxnorm_paths: RxNorm Default Paths | resolution: rx_concept_path, interval: snapshot
  • rxnrel: RxNorm Related Concepts (RXNREL), Prescribable Content | resolution: rxcui, interval: monthly
  • rxnsat: RxNorm Simple Concept and Atom Attributes (RXNSAT), Prescribable Content | resolution: rxcui, interval: monthly

Noridian - mimi_ws_1.noridian

• Description: Datasets from the Noridian Healthcare Solutions, LLC - A Medicare Admnistrative Contractor (MAC)
• Tables:
  • discharge_codes: Patient Discharge Codes | resolution: code, interval: snapshot
  • modifiers: Claim Modifiers | resolution: code, interval: snapshot
  • revenue_codes: Revenue Codes | resolution: code, interval: snapshot
  • smrc_completed_projects: Supplemental Medical Review Contractor (SMRC) Completed Projects, Base | resolution: project, interval: monthly
  • smrc_completed_projects_denials: Supplemental Medical Review Contractor (SMRC) Completed Projects, Denials | resolution: project, interval: monthly
  • smrc_completed_projects_references: Supplemental Medical Review Contractor (SMRC) Completed Projects, References | resolution: project, interval: monthly
  • smrc_current_projects: Supplemental Medical Review Contractor (SMRC) Current Projects, Base | resolution: project, interval: monthly
  • smrc_current_projects_codes: Supplemental Medical Review Contractor (SMRC) Current Projects, Codes | resolution: project, interval: monthly
  • smrc_current_projects_doc_reqs: Supplemental Medical Review Contractor (SMRC) Current Projects, Documentation Requirements | resolution: project, interval: monthly
  • smrc_current_projects_references: Supplemental Medical Review Contractor (SMRC) Current Projects, References | resolution: project, interval: monthly
  • type_of_bill_by_facility: Type of Bill By Facility | resolution: code, interval: snapshot
  • type_of_bill_structure: Type of Bill Code Structure | resolution: code, interval: snapshot

NPPES - mimi_ws_1.nppes

• Description: Datasets from National Plan & Provider Enumeration System (NPPES)
• Tables:
  • address_census_geocoder_dedup: De-duplicated Geocoding Results for the address_key table, mimi-derived data | resolution: address_key, interval: monthly
  • address_census_geocoder_raw: Raw Geocoding Results from the US Census Geocoder, derived from the address_key, mimi-derived data | resolution: address_key, interval: monthly
  • address_key: Address Key, A collection of Unique Address Strings for all providers and times, mimi-derived data | resolution: address_key, interval: monthly
  • deactivated: Deactived Provider List from the monthly NPPES batch | resolution: provider, interval: monthly
  • endpoint: Health Information Exchange (HIE) Endpoints, i.e., provider HIE contact address from the monthly NPPES batch | resolution: provider, interval: monthly
  • fhir_address: NPPES-in-FHIR address component, mimi-derived data | resolution: provider, interval: monthly
  • fhir_export: NPPES-in-FHIR database for the https://nppesfhir.mimilabs.ai/ site, mimi-derived data | resolution: provider, interval: monthly
  • fhir_identifier: NPPES-in-FHIR identifier component, mimi-derived data | resolution: provider, interval: monthly
  • fhir_name: NPPES-in-FHIR name component, mimi-derived data | resolution: provider, interval: monthly
  • fhir_qualification: NPPES-in-FHIR qualification component, mimi-derived data | resolution: provider, interval: monthly
  • fhir_telecom: NPPES-in-FHIR telecom component, mimi-derived data | resolution: provider, interval: monthly
  • npi_to_address: NPI to Geocoded Address (both practice and mail address), mimi-derived data | resolution: provider, interval: latest
  • npidata: NPIDATA, the base table for the NPI directory | resolution: provider, interval: monthly
  • nucc_taxonomy_codes: NUCC Taxonomy Code Description | resolution: code, interval: yearly
  • othername: Other Business Names such as DBA from the monthly NPPES batch | resolution: provider, interval: monthly
  • pl: Other Practice Locations from the monthly NPPES batch | resolution: provider, interval: monthly
  • placekey: NPIDATA with Placekey | resolution: provider, interval: monthly

New York University - mimi_ws_1.nyu

• Description: Datasets from the New York University.
• Tables:
  • ed_avoidable_original_icd10cm: The original NYU Avoidable Emergency Room Visit Algorithm, ICD-10-CM | resolution: code, interval: snapshot
  • ed_avoidable_original_icd9cm: The original NYU Avoidable Emergency Room Visit Algorithm, ICD-9-CM | resolution: code, interval: snapshot
  • ed_avoidable_patch_icd10cm: A "patch" to the NYU Avoidable Emergency Room Visit Algorithm, ICD-10-CM | resolution: code, interval: snapshot
  • ed_avoidable_patch_icd9cm: A "patch" to the NYU Avoidable Emergency Room Visit Algorithm, ICD-9-CM | resolution: code, interval: snapshot

opencanadaca - mimi_ws_1.opencanadaca

• Description: Datasets from the Canada Open Data Site, open.canada.ca
• Tables:
  • bchealth_spending_by_spec_hsda: Health Spending per Specialty and Area in British Columnbia, Canada | resolution: provider, interval: snapshot
  • dpd_biosimilar: Biosimilars | resolution: drug, interval: monthly
  • dpd_comp: Companies | resolution: company, interval: monthly
  • dpd_drug: Drug Products | resolution: drug, interval: monthly
  • dpd_form: Pharmaceutical Forms | resolution: drug, interval: monthly
  • dpd_ingred: Active Ingredients | resolution: drug, interval: monthly
  • dpd_package: Packaging | resolution: drug, interval: monthly
  • dpd_pharm: Pharmaceutical Standards | resolution: drug, interval: monthly
  • dpd_route: Routes of Administration | resolution: drug, interval: monthly
  • dpd_schedule: Drug Schedule | resolution: drug, interval: monthly
  • dpd_status: Product Status | resolution: drug, interval: monthly
  • dpd_ther: Therapeutic Classification | resolution: drug, interval: monthly
  • dpd_vet: Veterinary Species | resolution: drug, interval: monthly
  • msp_bluebook: BC Health MSP Blue Book - Payment Amount to Practitioners in British Columnbia, Canada | resolution: provider, interval: yearly

Open Payments - mimi_ws_1.openpayments

• Description: Datasets from the CMS Open Payments site
• Tables:
  • deleted: Deleted Entries from the Open Payment datasets | resolution: record, interval: yearly
  • general: General Payments Details | resolution: provider x event, interval: yearly
  • ownership: Physician Ownership Details | resolution: provider x event, interval: yearly
  • research: Research Payments Details | resolution: provider x event, interval: yearly
  • teaching_hospital_list: Teaching Hospital List, CCN x Tax ID | resolution: hospital, interval: yearly

Palmetto GBA - mimi_ws_1.palmettogba

• Description: Datasets from Palmetto GBA, LLC
• Tables:
  • dmecs: DME Coding System (DMECS) Update Listing | resolution: dme_product, interval: monthly
  • ndc_hcpcs_xwalk: NDC/HCPCS Crosswalk | resolution: drug, interval: monthly

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, mimi-derived data | resolution: county x health_plan, interval: monthly
  • cpsc_contract: Medicare Advantage Contract Information from the CPSC bundle | resolution: county x health_plan, interval: monthly
  • cpsc_enrollment: Medicare Advantage Enrollment by Contract/Plan/State/County (CPSC) | resolution: health_plan, interval: monthly
  • hedis_general: Contract Information from the HEDIS Public Use Files (PUFs) | resolution: health_plan, interval: yearly
  • hedis_measures: Contract-level Performance from the HEDIS Public Use Files (PUFs) | resolution: health_plan, interval: yearly
  • hedis_national_rates: National Rates from the HEDIS Public Use Files (PUFs) | resolution: nation, interval: yearly
  • hedis_rau_measures: Risk Adjusted Measures from the HEDIS Public Use Files (PUFs) | resolution: health_plan, interval: yearly
  • landscape_medicare_advantage: Medicare Advantage section from the MAPD Coverage Landscape files | resolution: health_plan, interval: yearly
  • landscape_plan_premium_report: Premium Report form the MAPD Coverage Landscape files | resolution: health_plan, interval: yearly
  • landscape_prescription_drug_plan: Prescription Drug Plan from the MAPD Coverage Landscape files | resolution: health_plan, interval: yearly
  • landscape_special_needs_plan: Special Needs Plan section from the MAPD Coverage Landscape files | resolution: health_plan, interval: yearly
  • lis_enrollment_by_plan: LIS Enrollment by Plan | resolution: health_plan, interval: yearly
  • mapd_plan_directory: MAPD Plan Directory | resolution: health_plan, interval: yearly
  • mpf_benefit_summary: Marketplace Plan Finder (MPF) Benefit Summary | resolution: health_plan, interval: yearly
  • partc_payment_county_level: Part C Risk Score and Payment Data - County Level | resolution: county, interval: yearly
  • partc_payment_plan_level: Part C Risk Score and Payment Data - Plan Level | resolution: health_plan, interval: yearly
  • partd_payment_plan_level: Part D Risk Score and Payment Data - Plan Level | resolution: health_plan, interval: yearly
  • partd_reconciliation_contract_level: Part D Reconciliation Data - Contract Level | resolution: health_plan, interval: yearly
  • partd_reconciliation_parent_level: Part D Reconciliation Data - Parent Org Level | resolution: health_plan, interval: yearly
  • pbp_b10_amb_trans: Medicare Advantage Benefits Information Section B10 Ambulance/Transportation data, Ambulance/Transportation data benefits (tiering) data | resolution: health_plan, interval: quarterly
  • pbp_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. | resolution: health_plan, interval: quarterly
  • pbp_b14c_b19b_preventive_vbid_uf: Medicare Advantage Benefits Information Section B14C-B19B VBID, Supplemental Benefits Preventive Services VBID and UF data for Health Education/Wellness, Fitness Benefit, Counseling Services. | resolution: health_plan, interval: quarterly
  • pbp_b15_partb_rx_drugs: Medicare Advantage Benefits Information Section B15 PartB Rx, Medicare Part B prescription drugs | resolution: health_plan, interval: quarterly
  • pbp_b16_b19b_dental_vbid_uf: Medicare Advantage Benefits Information Section B16-B19B Dental VBID UF, Preventive and Comprehensive Dental VBID and UF data | resolution: health_plan, interval: quarterly
  • pbp_b16_dental: Medicare Advantage Benefits Information Section B16 Dental, Preventive and Comprehensive Dental data | resolution: health_plan, interval: quarterly
  • pbp_b17_b19b_eye_exams_wear_vbid_uf: Medicare Advantage Benefits Information Section B17 B19b Eye Exams Wear VBID UF, Eye Exams and Eye Wear VBID and UF data | resolution: health_plan, interval: quarterly
  • pbp_b17_eye_exams_wear: Medicare Advantage Benefits Information Section B17 Eye Exams Wear data, Eye Exams and Eye Wear data | resolution: health_plan, interval: quarterly
  • pbp_b18_b19b_hearing_exams_aids_vbid_uf: Medicare Advantage Benefits Information Section B18 B19b Hearing Exams Aids VBID UF, Hearing Exams and Hearing Aids VBID and UF data | resolution: health_plan, interval: quarterly
  • pbp_b18_hearing_exams_aids: Medicare Advantage Benefits Information Section B18 Hearing Exams Aids data, Hearing Exams and Hearing Aids data | resolution: health_plan, interval: quarterly
  • pbp_metadata: Medicare Advantage Benefits Information Metadata, the list of tables, columns, and their descriptions. | resolution: variable, interval: quarterly
  • pbp_mrx: Medicare Advantage Benefits Information Section MRX, Medicare Part D prescription drug benefits data | resolution: health_plan, interval: quarterly
  • pbp_mrx_gapcoverage: Medicare Advantage Benefits Information Section MRX Gap Coverage, information on coverage of either tier(s) or specific drugs through the entire gap (ICL to catastrophic) | resolution: health_plan, interval: quarterly
  • pbp_mrx_p: Medicare Advantage Benefits Information Section B14C-B19B MRX P, Medicare Part D prescription drug benefits (post OOP threshold) data | resolution: health_plan, interval: quarterly
  • pbp_mrx_p_vbid: Medicare Advantage Benefits Information Section MRX P VBID, Medicare Part D prescription drug benefits (post OOP threshold) VBID data | resolution: health_plan, interval: quarterly
  • pbp_mrx_tier: Medicare Advantage Benefits Information Section MRX TIER, Medicare Part D prescription drug benefits (tiering) data | resolution: health_plan, interval: quarterly
  • pbp_mrx_tier_vbid: Medicare Advantage Benefits Information Section MRX TIER VBID VBID, Medicare Part D prescription drug benefits (tiering) data | resolution: health_plan, interval: quarterly
  • pbp_mrx_vbid: Medicare Advantage Benefits Information Section MRX VBID, Medicare Part D prescription drug benefits VBID data | resolution: health_plan, interval: quarterly
  • pbp_plan_area: Medicare Advantage Benefits Information Section PlanArea Files, Contains Service Area data by plan (includes EGHP service areas) | resolution: health_plan, interval: quarterly
  • pbp_plan_region_area: Medicare Advantage Benefits Information Section PlanRegionArea Files, Contains Service Region Area data by plan (Regional MA plans and PDPs) | resolution: health_plan, interval: quarterly
  • pbp_section_a: Medicare Advantage Benefits Information Section A, general plan information. | resolution: health_plan, interval: quarterly
  • pbp_section_d: Medicare Advantage Benefits Information Section D data, plan-level financial data such as plan premiums, global max plan benefit and out-of-pocket limits, and global deductible data | resolution: health_plan, interval: quarterly
  • pbp_section_d_opt: Medicare Advantage Benefits Information Section D Optional, plan-level benefit data descriptions of optional supplemental offerings including the optional benefit premium amounts | resolution: health_plan, interval: quarterly
  • plan_crosswalk: Plan Crosswalk Data | resolution: health_plan, interval: yearly
  • snpdata: Special Needs Plan Data | resolution: health_plan, interval: monthly
  • starrating_display_hedis_measure: Display and HEDIS values from the Part C & D Performance Data (Star Rating) files | resolution: health_plan, interval: yearly
  • starrating_measure_star: Stars from the Part C & D Performance Data (Star Rating) files | resolution: health_plan, interval: yearly
  • starrating_measure_value: Raw measure values from the Part C & D Performance Data (Star Rating) files | resolution: health_plan, interval: yearly

Payer MRF - mimi_ws_1.payermrf

• Description: Payer MRF - Price Transparency Files from various Payers.
• Tables:
  • aetna_toc: CVS/Aetna Table of Contents | resolution: health_plan, interval: monthly
  • allowed_amounts: Allowed Amounts Data (Out-of-Network), Out-of-Network pricing data, Currently, UHC and Medica data are loaded. | resolution: procedure x provider, interval: monthly
  • bcbsaz_toc: BCBS Arizona Table of Contents - contains BCBS plans from other states | resolution: health_plan, interval: monthly
  • bcbsmn_toc: BCBS Minnesota Table of Contents - contains BCBS plans from other states | resolution: health_plan, interval: monthly
  • blueshieldca_toc: Blue Shield California Table of Contents - contains BCBS plans from other states | resolution: health_plan, interval: monthly
  • cigna_toc: Cigna Table of Contents | resolution: health_plan, interval: monthly
  • in_network_rates_aetna: In-Network Rates Data, Aetna | resolution: procedure x provider, interval: monthly
  • in_network_rates_bcbsal: In-Network Rates Data, BCBS Alabama | resolution: procedure x provider, interval: monthly
  • in_network_rates_bcbsaz: In-Network Rates Data, BCBS AZ | resolution: procedure x provider, interval: monthly
  • in_network_rates_bcbsmn: In-Network Rates Data, BCBS MN | resolution: procedure x provider, interval: monthly
  • in_network_rates_blueshieldca: In-Network Rates Data, Blue Shield California | resolution: procedure x provider, interval: monthly
  • in_network_rates_cigna: In-Network Rates Data, Cigna | resolution: procedure x provider, interval: monthly
  • in_network_rates_healthpartners: In-Network Rates Data, HealthPartners | resolution: procedure x provider, interval: monthly
  • in_network_rates_medica: In-Network Rates Data, Medica | resolution: procedure x provider, interval: monthly
  • in_network_rates_premera: In-Network Rates Data, Premera | resolution: procedure x provider, interval: monthly
  • in_network_rates_ucare: In-Network Rates Data, UCare | resolution: procedure x provider, interval: monthly
  • in_network_rates_unitedhealth: In-Network Rates Data, UnitedHealthcare | resolution: procedure x provider, interval: monthly
  • medica_toc: Medica Table of Contents | resolution: health_plan, interval: monthly
  • molina_provider_directory: Molina Healthcare Provider Directory | resolution: provider, interval: monthly
  • npi_tin_extracts: NPI TIN Pairs from all provider reference files | resolution: provider, interval: monthly
  • npi_to_tin: NPI to TIN Mapping Table | resolution: provider, interval: monthly
  • premera_toc: Premera Table of Contents | resolution: health_plan, interval: monthly
  • provider_references_aetna: Provider Reference Data, Aetna | resolution: provider, interval: monthly
  • provider_references_bcbsal: Provider Reference Data, BCBS Alabama | resolution: provider, interval: monthly
  • provider_references_bcbsaz: Provider Reference Data, BCBS AZ | resolution: provider, interval: monthly
  • provider_references_bcbsmn: Provider Reference Data, BCBS MN | resolution: provider, interval: monthly
  • provider_references_blueshieldca: Provider Reference Data, Blue Shield California | resolution: provider, interval: monthly
  • provider_references_cigna: Provider Reference Data, Cigna | resolution: provider, interval: monthly
  • provider_references_healthpartners: Provider Reference Data, Health Partners | resolution: provider, interval: monthly
  • provider_references_medica: Provider Reference Data, Medica | resolution: provider, interval: monthly
  • provider_references_premera: Provider Reference Data, Premera | resolution: provider, interval: monthly
  • provider_references_ucare: Provider Reference Data, UCare | resolution: provider, interval: monthly
  • provider_references_unitedhealth: Provider Reference Data, UnitedHealthcare | resolution: provider, interval: monthly
  • unh_toc: UnitedHealthcare Table of Contents | resolution: health_plan, interval: monthly

pan-Canadian Pharma Alliance - mimi_ws_1.pcpa

• Description: Datasets from pan-Canadian Pharmaceutical Alliance (pCPA)
• Tables:
  • pcpa_engagement_letters_last_4_weeks: pCPA Engagement Letters in the last 4 weeks | resolution: drug, interval: weekly
  • pcpa_negotiation_status: pCPA Brand Name Drug Negotiations Status | resolution: drug, interval: weekly
  • pcpa_negotiations_completed_with_loi_last_4_weeks: pCPA Negotiations Completed with Letter of Intent in the last 4 weeks | resolution: drug, interval: weekly

Placekey - mimi_ws_1.placekey

• Description: Datasets from Placekey by Safegraph, Inc.
• Tables:
  • dac_ndf_with_placekey: Medicare Provider with Placekey | resolution: provider, interval: monthly
  • npidata_with_placekey: NPIDATA with Placekey | resolution: provider, interval: monthly
  • pc_fqhc_with_placekey: FQHC with Placekey | resolution: provider, interval: monthly
  • pc_homehealth_with_placekey: Homehealth with Placekey | resolution: provider, interval: monthly
  • pc_homeinfusion_with_placekey: Home Infusion with Placekey | resolution: provider, interval: monthly
  • pc_hospice_with_placekey: Hospice with Placekey | resolution: provider, interval: monthly
  • pc_hospital_with_placekey: Hospital with Placekey | resolution: provider, interval: monthly
  • pc_ruralhealthclinic_with_placekey: Rural Health Clinic with Placekey | resolution: provider, interval: monthly
  • pc_snf_with_placekey: SNF with Placekey | resolution: provider, interval: monthly

Prescription Drug Plan - mimi_ws_1.prescriptiondrugplan

• Description: Datasets from the CMS Medicare Part-D Formularies and Networks section - a subsection of the data.cms.gov site
• Tables:
  • basic_drugs_formulary: Basic Drugs Formulary File from the Part-D Formularies and Networks files | resolution: drug, interval: quarterly
  • beneficiary_cost: Beneficiary Cost File from the Part-D Formularies and Networks files | resolution: health_plan, interval: quarterly
  • excluded_drugs_formulary: Excluded Drugs Formulary File from the Part-D Formularies and Networks files | resolution: drug, interval: quarterly
  • geographic_locator: Geographic Locator File from the Part-D Formularies and Networks files | resolution: county, interval: quarterly
  • indication_based_coverage_formulary: Indication Based Coverage (IBC) Formulary File from the Part-D Formularies and Networks files | resolution: health_plan, interval: quarterly
  • insulin_beneficiary_cost: Insulin Beneficiary Cost File from the Part-D Formularies and Networks files | resolution: health_plan, interval: quarterly
  • partial_gap_coverage: Partial Gap File from the Part-D Formularies and Networks files | resolution: health_plan x drug, interval: quarterly
  • pharmacy_networks: Pharmacy Networks File from the Part-D Formularies and Networks files | resolution: health_plan x pharmacy, interval: quarterly
  • plan_information: Plan Information File from the Part-D Formularies and Networks files | resolution: health_plan, interval: quarterly
  • pricing: Pricing File from the Part-D Formularies and Networks files | resolution: health_plan x drug, interval: quarterly

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:
  • asc_quality: Ambulatory Surgial Center Quality Measures | resolution: hospital, interval: quarterly
  • dac_ec_public_reporting: Clinician Public Reporting: MIPS Measures and Attestations from the Doctors and Clinicians Data section | resolution: provider, interval: monthly
  • dac_ec_score_file: Clinician Public Reporting: Overall MIPS Performance from the Doctors and Clinicians Data section | resolution: provider, interval: monthly
  • dac_fa: Facility Affiliations from the Doctors and Clinicians Data section | resolution: provider, interval: monthly
  • dac_grp_public_reporting: Group Public Reporting: MIPS Measures and Attestations from the Doctors and Clinicians Data section | resolution: provider, interval: monthly
  • dac_grp_public_reporting_cahps: Group Public Reporting: Patient Experience from the Doctors and Clinicians Data section | resolution: provider, interval: monthly
  • dac_ndf: National Downloadable Files from the Doctors and Clinicians Data section | resolution: provider, interval: monthly
  • dac_utilization: Utilization from the Doctors and Clinicians Data section | resolution: provider, interval: monthly
  • dac_vg_public_reporting: Virtual Group Public Reporting: MIPS Measures and Attestations from the Doctors and Clinicians Data section | resolution: provider, interval: monthly
  • dialysis_cahps: Dialysis Facility Patient Survey (ICH CAHPS) | resolution: dialysis_facility, interval: monthly
  • dialysis_facilities: Dialysis Facility - Listing by Facility | resolution: dialysis_facility, interval: monthly
  • home_health_care_agencies: Home Health Care Agencies | resolution: home_health, interval: monthly
  • home_health_care_cahps: Home Health Patient Survey HHCAHPS | resolution: home_health, interval: monthly
  • hospice_cahps: Hospice Patient Survey CAHPS | resolution: hospice_agency, interval: monthly
  • hospice_general_info: Hospice - General Information | resolution: hospice_agency, interval: monthly
  • hospice_quality_measures: Hospice Care Qualitiy Measures | resolution: hospice_agency, interval: monthly
  • hospital_cad: Complications and Deaths from the Hospital Data section | resolution: hospital, interval: quarterly
  • hospital_general: Hospital General Information from the Hospital Data section | resolution: hospital, interval: quarterly
  • hospital_hai: Healthcare Associated Infections from the Hospital Data section | resolution: hospital, interval: quarterly
  • hospital_hcahps: Patient survey (HCAHPS) from the Hospital Data section | resolution: hospital, interval: quarterly
  • hospital_hsc: Medicare Hospital Spending by Claim from the Hospital Data section | resolution: hospital, interval: quarterly
  • hospital_psi: CMS Medicare PSI-90 and component measures, six-digit estimate dataset from the Hospital Data section | resolution: hospital, interval: quarterly
  • hospital_pvc: Payment and value of care from the Hospital Data section | resolution: hospital, interval: quarterly
  • hospital_tec: Timely and Effective Care from the Hospital Data section | resolution: hospital, interval: quarterly
  • hospital_uhv: Unplanned Hospital Visits from the Hospital Data section | resolution: hospital, interval: quarterly
  • nursinghomes_health_citations: Nursing Home Health Citations | resolution: nursing_home, interval: monthly
  • nursinghomes_mds: Nursing Home Minimum Data Set (MDS) Files | resolution: nursing_home, interval: monthly

QCOR CMS - mimi_ws_1.qcorcms

• Description: Datasets from CMS Quality, Certifications, and Oversite Reports (QCOR)
• Tables:
  • clia_listing: CLIA ())Clinical Laboratory Improvement Amendments) Lab Listing | resolution: provider, interval: monthly

ResDAC - mimi_ws_1.resdac

• Description: Datasets from CMS Research Data Assistance Center (ResDAC) by the University of Minnesota
• Tables:
  • all_tables_variables: All Tables and Variables from ResDAC | resolution: variable, interval: yearly
  • betos_nch_version: BETOS NCH Version - prior to the revision | resolution: variable, interval: snapshot
  • carrier_or_mac_number: Carrier or MAC Number | resolution: code, interval: yearly
  • claim_frequency_code: Claim Frequency Code | resolution: code, interval: yearly
  • claim_medicare_non_payment_reason_code: Claim Medicare Non Payment Reason Code | resolution: code, interval: yearly
  • claim_occurrence_span_code: Claim Occurrence Span Code | resolution: code, interval: yearly
  • claim_outpatient_transaction_type: Claim Outpatient Transaction Type | resolution: code, interval: yearly
  • claim_related_condition_code: Claim Related Condition Code | resolution: code, interval: yearly
  • claim_related_occurrence_code: Claim Related Occurrence Code | resolution: code, interval: yearly
  • claim_value_code: Claim Value Code | resolution: code, interval: yearly
  • demonstration_number: Demonstration Number | resolution: code, interval: yearly
  • line_cms_type_service_code: Line CMS Type Service Code | resolution: code, interval: yearly
  • line_other_applied_indicator_code: Line Other Applied Indicator Code | resolution: code, interval: yearly
  • line_place_service_code_ffs: Line Place Service Code (Place of Service, POS) | resolution: code, interval: yearly
  • nch_claim_type_code: NCH Claim Type Code | resolution: code, interval: yearly
  • ng_aco_indicator_code: NextGen ACO Indicator Code | resolution: code, interval: yearly
  • patient_discharge_status_code: Patient Discharge Status Code | resolution: code, interval: yearly
  • physician_specialty_code: Physician Specialty Code | resolution: code, interval: yearly
  • revenue_center_1st_ansi_code: Revenue Center 1st ANSI Code (X12) | resolution: code, interval: yearly
  • revenue_center_code: Revenue Center Code | resolution: code, interval: yearly
  • revenue_center_pricing_indicator_code: Revenue Center Pricing Indicator Code | resolution: code, interval: yearly
  • revenue_center_status_indicator_code: Revenue Center Status Indicator Code | resolution: code, interval: yearly
  • therapy_cap_indicator_code: Therapy Cap Indicator Code | resolution: code, interval: yearly

State Government Databases - mimi_ws_1.stategov

• Description: Datasets from Various State Government Health Departments - currently CA, FL, GA, NY, TX
• Tables:
  • california_medicaid_provider_directory: California Medicaid Provider Directory | resolution: provider, interval: monthly
  • california_suspended_ineligible_list: California Department of Health Care Services Suspended and Ineligible Provider List | resolution: provider, interval: monthly
  • florida_ahca_orders: Florica Agency for Health Care Administration (AHCA) Orders | resolution: provider, interval: monthly
  • florida_licensedb: Florida Licensure Database | resolution: provider, interval: monthly
  • georgia_medicaid_provider_directory: Gerogia Medicaid Provider Directory | resolution: provider, interval: monthly
  • georgia_medicaid_provider_exclusions: Georgia Office of Inspector General Exclusions List | resolution: provider, interval: monthly
  • hospital_inpatient_discharges_sparcs: New York Hospital Inpatient Discharges (SPARCS De-Identified) | resolution: event, interval: yearly
  • nevada_medicaid_provider_exclusions: Nevada Department of Health and Human Services Excluded/Sanctioned Providers | resolution: provider, interval: monthly
  • newyork_medicaid_provider_directory: New York Medicaid Provider Directory | resolution: provider, interval: monthly
  • newyork_medicaid_provider_exclusions: New York Office of the Medicaid Inspector General List of Exclusions | resolution: provider, interval: monthly
  • pennsylvania_medicheck_preclusions: Pennsylvania Department of Human Services Medicheck Precluded Providers List | resolution: provider, interval: monthly
  • texas_medicaid_provider_exclusions: Texas Health and Human Services Commission Office of the Inspector General Exclusions | resolution: provider, interval: monthly

Surgo Ventures - mimi_ws_1.surgoventures

• Description: Datasets from Surgo Ventures, Inc.
• Tables:
  • ccvi_county: THE U.S. COVID COMMUNITY VULNERABILITY INDEX (CCVI) | resolution: county, interval: snapshot
  • ccvi_state: THE U.S. COVID COMMUNITY VULNERABILITY INDEX (CCVI) | resolution: state, interval: snapshot
  • mvi_county: The U.S. Maternal Vulnerability Index by Surgo Ventures | resolution: county, interval: snapshot

CMS Synthetic Medicare PUF - mimi_ws_1.synmedpuf

• Description: CMS Synthetic Medicare PUF
• Tables:
  • beneficiary: Beneficiary Summary | resolution: synthetic_beneficiary, interval: snapshot
  • carrier: Carrier Claims from CMS Synthetic Medicare PUF | resolution: synthetic_event, interval: snapshot
  • dme: Durable Medical Equipment Claims from CMS Synthetic Medicare PUF | resolution: synthetic_event, interval: snapshot
  • hha: Home Health Agency Claims from CMS Synthetic Medicare PUF | resolution: synthetic_event, interval: snapshot
  • hospice: Hospice Claims from CMS Synthetic Medicare PUF | resolution: synthetic_event, interval: snapshot
  • inpatient: Inpatient Claims from CMS Synthetic Medicare PUF | resolution: synthetic_event, interval: snapshot
  • outpatient: Outpatient Claims from CMS Synthetic Medicare PUF | resolution: synthetic_event, interval: snapshot
  • pde: Prescription Drug Events from 2008 to 2010 from CMS Synthetic Medicare PUF | resolution: synthetic_event, interval: snapshot
  • snf: Skilled Nursing Facility Claims from CMS Synthetic Medicare PUF | resolution: synthetic_event, interval: snapshot

Synthea - mimi_ws_1.synthea

• Description: Datasets from the Synthea Project by the MITRE Corporation - 1.1M synthetic patients
• Tables:
  • allergies: Patient allergy data, MITRE Synthea | resolution: synthetic_patient, interval: snapshot
  • careplans: Patient care plan data, including goals, MITRE Synthea | resolution: synthetic_patient, interval: snapshot
  • conditions: Patient conditions or diagnoses, MITRE Synthea | resolution: synthetic_patient, interval: snapshot
  • devices: Patient-affixed permanent and semi-permanent devices, MITRE Synthea | resolution: synthetic_patient, interval: snapshot
  • encounters: Patient encounter data, MITRE Synthea | resolution: synthetic_event, interval: snapshot
  • imaging_studies: Patient imaging metadata, MITRE Synthea | resolution: synthetic_event, interval: snapshot
  • immunizations: Patient immunization data, MITRE Synthea | resolution: synthetic_event, interval: snapshot
  • medications: Patient medication data, MITRE Synthea | resolution: synthetic_event, interval: snapshot
  • observations: Patient observations including vital signs and lab reports, MITRE Synthea | resolution: synthetic_event, interval: snapshot
  • organizations: Provider organizations including hospitals, MITRE Synthea | resolution: synthetic_organization, interval: snapshot
  • patients: Patient demographic data, MITRE Synthea | resolution: synthetic_patient, interval: snapshot
  • payer_transitions: Payer Transition data (i.e. changes in health insurance), MITRE Synthea | resolution: synthetic_event, interval: snapshot
  • payers: Payer organization data, MITRE Synthea | resolution: synthetic_health_plan, interval: snapshot
  • procedures: Patient procedure data including surgeries, MITRE Synthea | resolution: synthetic_event, interval: snapshot
  • providers: Clinicians that provide patient care, MITRE Synthea | resolution: synthetic_provider, interval: snapshot
  • supplies: Supplies used in the provision of care, MITRE Synthea | resolution: synthetic_patient, interval: snapshot

Tuva Health - mimi_ws_1.tuvahealth

• Description: Tuva Health, Inc.
• Tables:
  • cclf1_parta_claims_header: CCLF1 Part A Claims Header File | resolution: synthetic_event, interval: snapshot
  • cclf2_parta_claims_revenue_center_detail: CCLF2 Part A Claims Revenue Center Detail | resolution: synthetic_event, interval: snapshot
  • cclf3_parta_procedure_code: CCLF3 Part A Claims Procedure Code | resolution: synthetic_event, interval: snapshot
  • cclf4_parta_diagnosis_code: CCLF4 Part A Claims Diagnosis Code | resolution: synthetic_event, interval: snapshot
  • cclf5_partb_physicians: CCLF5 Part B Physician | resolution: synthetic_event, interval: snapshot
  • cclf6_partb_dme: CCLF6 Part B Part B DME | resolution: synthetic_event, interval: snapshot
  • cclf7_partd_claims: CCLF7 Part D Claims | resolution: synthetic_event, interval: snapshot
  • cclf8_beneficiary_demographics: CCLF8 Beneficiary Demographics | resolution: synthetic_beneficiary, interval: snapshot
  • cclf9_beneficiary_xref: CCLF9 Beneficiary XREF | resolution: synthetic_beneficiary, interval: snapshot
  • cclfx_enrollment: CCLFX ACO Enrollment File | resolution: synthetic_beneficiary, interval: snapshot
  • condition: Condition | resolution: synthetic_event, interval: snapshot
  • eligibility: Eligibility | resolution: synthetic_patient, interval: snapshot
  • encounter: Encounter | resolution: synthetic_event, interval: snapshot
  • lab_result: Lab Result | resolution: synthetic_event, interval: snapshot
  • location: Location | resolution: synthetic_event, interval: snapshot
  • medical_claim: Medical Claim | resolution: synthetic_event, interval: snapshot
  • medication: Medication | resolution: synthetic_event, interval: snapshot
  • observation: Observation | resolution: synthetic_event, interval: snapshot
  • patient: Patient | resolution: synthetic_patient, interval: snapshot
  • pharmacy_claim: Pharmacy Claim | resolution: synthetic_event, interval: snapshot
  • practitioner: Practitioner | resolution: synthetic_provider, interval: snapshot
  • procedure: Procedure | resolution: synthetic_event, interval: snapshot

UMN IHDC - mimi_ws_1.umn_ihdc

• Description: UMN Interdisciplinary Health Data Competition (IHDC)
• Tables:
  • competition_dataset_2025: UMN Interdisciplinary Health Data Competition Data | resolution: provider, interval: snapshot
  • competition_dataset_2025_archived_20250208: UMN Data Competition Dataset Draft | resolution: provider, interval: snapshot
  • competition_dataset_2025_v2: UMN Data Competition Dataset Draft V2 | resolution: provider, interval: snapshot

United Nations (UN) - mimi_ws_1.unitednations

• Description: Datasets from the United Nations (UN)
• Tables:
  • unspsc: United Nations Standard Products and Services Code (UNSPSC) | resolution: product, interval: monthly

USA Spending - mimi_ws_1.usaspending

• Description: Datasets from the Department of Treasury Open Government Spending Data via USASpending.gov
• Tables:
  • assistance: All Assistance Data | resolution: contract, interval: yearly
  • contracts: All Contracts Data | resolution: contract, interval: yearly

USDA - mimi_ws_1.usda

• Description: Datasets from US Department of Agriculture (USDA)
• Tables:
  • ruca_tract_2010: 2010 Rural-Urban Commuting Area Codes - Census Tract Level | resolution: tract, interval: snapshot
  • ruca_tract_2020: 2020 Rural-Urban Commuting Area Codes - Census Tract Level | resolution: tract, interval: snapshot
  • ruca_zipcode_2010: 2010 Rural-Urban Commuting Area Codes - ZIP Code Level | resolution: zipcode, interval: snapshot
  • ruca_zipcode_2020: 2020 Rural-Urban Commuting Area Codes - Zip Code Level | resolution: zipcode, interval: snapshot

Veterans Affairs (VA) - mimi_ws_1.va

• Description: Datasets from the Veteran Affairs (VA)
• Tables:
  • formulary_monthly_decisions_pdf: VA PBM Formulary Decision Letters (PDF) | resolution: drug, interval: monthly
  • pbm_drug_class_list: VA PBM Drug Class List | resolution: drug, interval: monthly
  • pbm_national_drug_code_extract: VA PBM National Drug Code (NDC) Extract | resolution: drug, interval: monthly
  • pbm_national_formulary: VA PBM National Formulary | resolution: drug, interval: monthly
  • pbm_product_name_list: VA PBM Product Name List | resolution: drug, interval: monthly

X12 - mimi_ws_1.x12

• Description: Datasets from the Accredited Standards Committee X12, commonly known as ASC X12
• Tables:
  • claim_adjustment_group_codes: Claim Adjustment Group Codes | resolution: code, interval: yearly
  • claim_adjustment_reason_codes: Claim Adjustment Reason Codes | resolution: code, interval: yearly
  • claim_status_category_codes: Claim Status Category Codes | resolution: code, interval: yearly
  • claim_status_codes: Claim Status Codes | resolution: code, interval: yearly
  • edi_examples: EDI Examples | resolution: claim, interval: snapshot
  • error_reason_codes: Error Reason Codes | resolution: code, interval: yearly
  • industry_specific_remark_codes: Industry Specific Remark Codes | resolution: code, interval: yearly
  • insurance_business_process_application_error_codes: Insurance Business Process Application Error Codes | resolution: code, interval: yearly
  • insurance_descriptor_codes: Insurance Descriptor Codes | resolution: code, interval: yearly
  • payment_type_codes: Payment Type Codes | resolution: code, interval: yearly
  • property_casualty_code_lists: Property & Casualty Code Lists | resolution: code, interval: yearly
  • provider_adjustment_reason_codes: Provider Adjustment Reason Codes | resolution: code, interval: yearly
  • remittance_advice_remark_codes: Remittance Advice Remark Codes | resolution: code, interval: yearly
  • report_type_codes: Report Type Codes | resolution: code, interval: yearly
  • service_review_decision_reason_codes: Service Review Decision Reason Codes | resolution: code, interval: yearly
  • service_type_codes: Service Type Codes | resolution: code, interval: yearly
  • service_type_descriptor_codes: Service Type Descriptor Codes | resolution: code, interval: yearly

Zillow - mimi_ws_1.zillow

• Description: Datasets from Zillow Group, Inc. (a real-estate marketplace company)
• Tables:
  • homevalue_zip: Home Values by Zillow | resolution: zip, interval: monthly
  • rent_zip: Rentals by Zillow | resolution: zip, interval: monthly

---