Data Catalog
You can find the datasets currently ingested in the mimi_ws_1
, a data lakehouse workspace. For most cases, we tried to preserve the original table formats with some exceptions:
We transformed column names to use the Snake case naming scheme, e.g., Provider Name
becomes provider_name.
We added three variables to all tables:
mimi_src_file_name
: This column shows the source file's name for the data.mimi_src_file_date
: This column shows the date mark of the source file. For example, the monthly NPPES data files have the date postamble in their file names. We extract the date mark of the file name and store the value in this column. The date mark can be either the creation date or the measurement cut-off date. Please read the table description for more details.mimi_dlt_load_date
: This column shows when the data is loaded to the lake house as a delta table.
The Catalog section of the workspace provides more details of these tables and columns. Please log in to the workspace and navigate to the Catalog menu to learn more about the datasets.
-- The first level maps to {schema}
-- and the next level maps to {table} fields.
SELECT * FROM mimi_ws_1.{schema}.{table} LIMIT 10;
See the list of schemas and tables below:
AHRQ - mimi_ws_1.ahrq
- Description: Datasets from Agency for Healthcare Research and Quality (AHRQ)
- Tables:
meps_consol_label_dictionary
: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Consolidated Files; Variable Values and Descriptionsmeps_consol_metadata
: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Consolidated Files Metadata; Variable Names and Descriptionsmeps_event_dentalvisits
: MEPS HC Event Files Dental Visits - multiyear, 2015-2022meps_event_ervisits
: MEPS HC Event Files Emergency Room Visits - multiyear, 2015-2022meps_event_homehealth
: MEPS HC Event Files Home Health - multiyear, 2015-2022meps_event_inpatientstays
: MEPS HC Event Files Inpatient Stays - multiyear, 2015-2022meps_event_label_dictionary
: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Event Files; Variable Values and Descriptionsmeps_event_metadata
: MEPS (Medical Expenditure Panel Survey) Household Component (HC) Event Files Metadata; Variable Names and Descriptionsmeps_event_officevisits
: MEPS HC Event Files Office-based Visits - multiyear, 2015-2022meps_event_othermedicalexp
: MEPS HC Event Files Other Medical Expenditures - multiyear, 2015-2022meps_event_outpatientvisits
: MEPS HC Event Files Outpatient Visits - multiyearmeps_event_prescribedmeds
: MEPS HC Event Files Prescribed Medicines - multiyear, 2015-2022meps_fyc
: MEPS HC Full Year Consolidated Files - multiyear, 2015-2021sdohdb_county
: SDoH Database at county-level - multiyearsdohdb_tract
: SDoH Database at tract-level - multiyearsdohdb_zipcode
: SDoH Database at ZIP-level - multiyear
CDC - mimi_ws_1.cdc
- Description: Datasets from the Centers for Disease Control and Prevention (CDC)
- Tables:
nhanes_demo_demographic_variables_sample_weights
: CDC NHANES DEMO Demographic Variables & Sample Weightsnhanes_exam_blood_pressure
: CDC NHANES EXAM Blood Pressurenhanes_exam_body_measures
: CDC NHANES EXAM Body Measuresnhanes_lab_albumin_creatinine_urine
: CDC NHANES LAB Albumin & Creatinine - Urinenhanes_lab_alpha1acid_glycoprotein_serum_surplus
: CDC NHANES LAB Alpha-1-Acid Glycoprotein - Serum (Surplus)nhanes_lab_cholesterol_hdl
: CDC NHANES LAB Cholesterol - HDLnhanes_lab_cholesterol_ldl_triglycerides
: CDC NHANES LAB Cholesterol - LDL & Triglyceridesnhanes_lab_cholesterol_total
: CDC NHANES LAB Cholesterol - Totalnhanes_lab_fasting_questionnaire
: CDC NHANES LAB Fasting Questionnairenhanes_lab_glycohemoglobin
: CDC NHANES LAB Glycohemoglobinnhanes_lab_glyphosate_glyp_urine
: CDC NHANES LAB Glyphosate (GLYP) - Urinenhanes_lab_highsensitivity_creactive_protein
: CDC NHANES LAB High-Sensitivity C-Reactive Proteinnhanes_lab_insulin
: CDC NHANES LAB Insulinnhanes_lab_oral_glucose_tolerance_test
: CDC NHANES LAB Oral Glucose Tolerance Testnhanes_lab_plasma_fasting_glucose
: CDC NHANES LAB Plasma Fasting Glucosenhanes_lab_standard_biochemistry_profile
: CDC NHANES LAB Standard Biochemistry Profilenhanes_metadata
: National Health and Nutrition Examination Survey (NHANES) Metadatanhanes_qre_acculturation
: CDC NHANES QRE Acculturationnhanes_qre_air_quality
: CDC NHANES QRE Air Qualitynhanes_qre_alcohol_use
: CDC NHANES QRE Alcohol Usenhanes_qre_blood_pressure_cholesterol
: CDC NHANES QRE Blood Pressure & Cholesterolnhanes_qre_bowel_health
: CDC NHANES QRE Bowel Healthnhanes_qre_cardiovascular_health
: CDC NHANES QRE Cardiovascular Healthnhanes_qre_diabetes
: CDC NHANES QRE Diabetesnhanes_qre_hospital_utilization_access_to_care
: CDC NHANES QRE Hospital Utilization & Access to Carenhanes_qre_income
: CDC NHANES QRE Incomenhanes_qre_kidney_conditions
: CDC NHANES QRE Kidney Conditionsnhanes_qre_medical_conditions
: CDC NHANES QRE Medical Conditionsnhanes_qre_preventive_aspirin_use
: CDC NHANES QRE Preventive Aspirin Usenhanes_qre_smoking_adult_recent_tobacco_use_youth_cigarettetobacco_use
: CDC NHANES QRE Smoking - Adult Recent Tobacco Use & Youth Cigarette/Tobacco Usenhanes_qre_smoking_cigarette_use
: CDC NHANES QRE Smoking - Cigarette Usenhanes_qre_smoking_household_smokers
: CDC NHANES QRE Smoking - Household Smokersnhanes_qre_smoking_recent_tobacco_use
: CDC NHANES QRE Smoking - Recent Tobacco Usenndss
: National Notifiable Diseases Surveillance System (NNDSS)nwss_covid
: National Wastewater Surveillance System (NWSS) for Covidnwss_mpox
: National Wastewater Surveillance System (NWSS) for Mpoxplaces_censustract
: PLACES: Local Data for Better Health - censustract-level, multiyearplaces_county
: PLACES: Local Data for Better Health - county-level, multiyearplaces_zcta
: PLACES: Local Data for Better Health - zcta-level, multiyearsvi_censustract_multiyears
: Social Vulnerability Index at Census Tract-Level - multiyearsvi_censustract_y2000
: Social Vulnerability Index at Census Tract-Level - Year 2000svi_censustract_y2010
: Social Vulnerability Index at Census Tract-Level - Year 2010svi_censustract_y2014
: Social Vulnerability Index at Census Tract-Level - Year 2014svi_censustract_y2016
: Social Vulnerability Index at Census Tract-Level - Year 2016svi_censustract_y2018
: Social Vulnerability Index at Census Tract-Level - Year 2018svi_censustract_y2020
: Social Vulnerability Index at Census Tract-Level - Year 2020svi_censustract_y2022
: Social Vulnerability Index at County-Level - Year 2022svi_county_multiyears
: Social Vulnerability Index at County-Level - multiyearsvi_county_y2000
: Social Vulnerability Index at County-Level - Year 2000svi_county_y2010
: Social Vulnerability Index at County-Level - Year 2010svi_county_y2014
: Social Vulnerability Index at County-Level - Year 2014svi_county_y2016
: Social Vulnerability Index at County-Level - Year 2016svi_county_y2018
: Social Vulnerability Index at County-Level - Year 2018svi_county_y2020
: Social Vulnerability Index at County-Level - Year 2020svi_county_y2022
: Social Vulnerability Index at County-Level - Year 2022urbanrural_classification
: NCHS Urban-Rural Classification Scheme for Countiesvsrr_drugoverdose
: Vital Statistics Rapid Reporting (VSRR) for Drug Overdose
Census - mimi_ws_1.census
- Description: Datasets from the US Census Bureau
- Tables:
centerofpop_bg
: The Centers of Population for each Census Block Groupcenterofpop_co
: The Centers of Population for each Countycenterofpop_st
: The Centers of Population for each Statecenterofpop_tr
: The Centers of Population for each Census Tractcenterofpop_us
: The Center of Population of the USpop_est_zcta
: Population Size by ZCTA
CMS Coding & Billing Section - mimi_ws_1.cmscoding
- Description: Datasets from the Coding & Billing section of the CMS website.
- Tables:
hcpcs
: HCPCS Codes and Descriptions - multiquartericd10cm
: ICD-10-CM Codes and Descriptions - multiyearicd10cm_poa_exempt
: ICD-10-CM Present on Admission (POA) Exempt Codes and Descriptions - multiyearicd10pcs
: ICD-10-PCS Codes and Descriptions - multiyearnicc_mue
: Medicare National Correct Coding Initiative (NICC) Medically Unlikely Edit (MUE) Codes and Descriptions - multiquarter
CMS Payment Section - mimi_ws_1.cmspayment
- Description: Datasets from the Payment section of the CMS website.
- Tables:
mac_locality
: MAC (Medicare Administrative Contractor) Locality Codes - multiyearopps_addendum_a
: Outpatient Prospective Payment System (OPPS) Addendum A - multiquarteropps_addendum_b
: Outpatient Prospective Payment System (OPPS) Addendum B - multiquarterpartb_drug_asp_ndc_to_hcpcs
: ASP NDC-HCPCS Crosswalk - multiquarterpartb_drug_asp_pricing
: Average Sales Pricing (ASP) - Pricing File - multiquarterpartb_drug_awp_ndc_to_hcpcs
: AWP NDC-HCPCS Crosswalk - multiquarterpartb_drug_noc_ndc_to_hcpcs
: NOC NDC-HCPCS Crosswalk - multiquarterpartb_drug_noc_pricing
: Not Otherwie Classified (NOC) - Pricing File - multiquarterpartb_drug_opps_ndc_to_hcpcs
: OPPS NDC-HCPCS Crosswalk - multiquarterphysicianfeeschedule
: Physician Fee Schedules National Payment Amount File - multiquarterphysicianfeeschedule_metadata
: Physician Fee Schedules Download Metadata, e.g. webpage URL, dataset name, comment
Data.CMS.gov - mimi_ws_1.datacmsgov
- Description: Datasets from the data.cms.gov site by the Centers for Medicare & Medicaid Services (CMS)
- Tables:
betos
: Restructured BETOS Classification System (RBCS)covid19nursinghomes
: COVID-19 Nursing Home Datadatacatalog
: The Data Catalog of the data.cms.gov site (https://data.cms.gov/data.json)geovariation
: Medicare Geographic Variation - by National, State & County - multiyearmcbs_fall
: Medicare Current Beneficiary Survey (MCBS) - fall, multiyearmcbs_summer
: Medicare Current Beneficiary Survey (MCBS) - summer, multiyearmcbs_winter
: Medicare Current Beneficiary Survey (MCBS) - winter, multiyearmupdme
: Medicare Durable Medical Equipment, Devices & Supplies - by Referring Provider and Service - multiyearmupdme_geo
: Medicare Durable Medical Equipment, Devices & Supplies - by Geography and Service - multiyearmupdme_prvdr
: Medicare Durable Medical Equipment, Devices & Supplies - by Referring Provider - multiyearmupdme_sup
: Medicare Durable Medical Equipment, Devices & Supplies - by Supplier - multiyearmupdme_suphpr
: Medicare Durable Medical Equipment, Devices & Supplies - by Supplier and Service - multiyearmupdpr
: Medicare Part D Prescribers - by Prescriber and Drug - multiyearmupdpr_geo
: Medicare Part D Prescribers - by Geography and Drug - multiyearmupdpr_prvdr
: Medicare Part D Prescribers - by Prescriber - multiyearmupihp
: Medicare Inpatient Hospitals - by Provider and Service - multiyearmupihp_geo
: Medicare Inpatient Hospitals - by Geography and Service - multiyearmupihp_prvdr
: Medicare Inpatient Hospitals - by Provider - multiyearmupohp
: Medicare Outpatient Hospitals - by Provider and Service - multiyearmupohp_geo
: Medicare Outpatient Hospitals - by Geography and Service - multiyearmuppac_geo
: Medicare Post-Acute Care and Hospice - by Geography & Provider - multiyearmupphy
: Medicare Physician & Other Practitioners - by Provider and Service - multiyearmupphy_geo
: Medicare Physician & Other Practitioners - by Geography and Service - multiyearmupphy_prvdr
: Medicare Physician & Other Practitioners - by Provider - multiyearoptout
: Opt Out Affidavits - multimonthorderandreferring
: Order and Referring - multiweekotpp
: Opioid Treatment Program Providers - multiweekpc_fqhc
: Federally Qualified Health Center Enrollments - multiquarterpc_fqhc_owner
: FQHC All Ownership Information - mu;tiquarterpc_homehealth
: Home Health Agency Enrollments - multiquarterpc_homehealth_owner
: Home Health All Ownership Information - multiquarterpc_hospice
: Hospice Enrollments - multiquarterpc_hospice_owner
: Hospice All Ownership Information - multiquarterpc_hospital
: Hospital Enrollments - multimonthpc_hospital_owner
: Hospital All Ownership Information - multiquarterpc_provider
: Medicare Fee-For-Service Public Provider Enrollment - multiquarterpc_ruralhealthclinic
: Rural Health Clinic Enrollments - multiquarterpc_ruralhealthclinic_owner
: Rural Health Clinic All Ownership Information - multiquarterpc_snf
: Skilled Nursing Facility Enrollments - multimonthpc_snf_owner
: SNF All Ownership Information - multiquarterpendingilt
: Pending Initial Logging and Tracking - multiweekqpp
: Quality Payment Program, e.g., MIPS, APMs, Performance Results - multiyearrevalidation
: Revalidation Clinic Group Practice Reassignment - multimonth
Data Commons - mimi_ws_1.datacommons
- Description: Datasets from the Data Commons project
- Tables:
Data.Healthcare.gov - mimi_ws_1.datahealthcaregov
- Description: Datasets from the data.healthcare.gov site
- Tables:
formulary_details
: Plan Formulary Details, e.g., Drug Name, RxNorm ID - multimonthmrf_xlsx
: Machine Readable File (MRF) URLs - multimonthplan
: Plan Information, e.g., Plan Name, ID - multimonthplan_formulary_base
: Plan Formulary Base Information - multimonthprovider_addresses
: Provider Addresses from the Provider Directories - multimonthprovider_base
: Provider Directory (base/master) - multimonthprovider_plans
: Provider to Contracted Plans from the Provider Directories - multimonth
Data.Medicaid.gov - mimi_ws_1.datamedicaidgov
- Description: Datasets from the data.medicaid.gov site
- Tables:
drugutilization
: Medicaid State Drug Utilization - multiyearnadac
: NADAC (National Average Drug Acquisition Cost) - multiyearquality
: Child and Adult Health Care Quality Measures Quality - multiyear
CMS DE-SynPUF - mimi_ws_1.desynpuf
- Description: CMS Data Entrepreneurs' Synthetic Public Use File (DE-SynPUF)
- Tables:
beneficiary_summary
: Beneficiary Summary from 2008 to 2010carrier_claims
: Carrier Claims from 2008 to 2010inpatient_claims
: Inpatient Claims from 2008 to 2010outpatient_claims
: Outpatient Claims from 2008 to 2010prescription_drug_events
: Prescription Drug Events from 2008 to 2010
Environmental Protection Agency - mimi_ws_1.epa
- Description: Datasets from the U.S. Environmental Protection Agency
- Tables:
airdata_daily
: Pre-generated Daily Data by Monitorairdata_daily_cbsa
: Pre-generated Daily AQI by CBSAairdata_daily_county
: Pre-generated Daily AQI by Countyairdata_yearly
: Pre-generated Yearly Data by Monitorairdata_yearly_cbsa
: Pre-generated Yearly AQI by CBSAairdata_yearly_county
: Pre-generated Yearly AQI by County
FDA - mimi_ws_1.fda
- Description: Datasets from the U.S. Food & Drug Administration (FDA)
- Tables:
adverse_event_base
: Drug Adverse Event - Base Table - multiquarteradverse_event_drug
: Drug Adverse Event - Drug Table, a part of the Drug Adverse Event Base tableadverse_event_reaction
: Drug Adverse Event - Reaction Table, a part of the Drug Adverse Event Base tableenforcement
: Drug Recall Enforcement - Base Tableenforcement_ndc_detail
: Drug Recall Enforcement - Package NDC Table, a part of the Drug Recall Enforcement Base tablendc_directory
: NDC Directory - multiweekndc_label
: Drug Package Labels - full text datandc_to_active_ingredients
: NDC to Active Ingredients Mapping - a part of the NDC Directoryndc_to_pharm_class
: NDC to Pharmacologic Class Mapping - a part of the NDC Directoryndc_to_rxcui
: NDC to RxCUI Mapping - a part of the NDC Directoryorangebook_exclusivity
: Approved Drug Products with Therapeutic Equivalence Evaluations, aka Orange Book - exclusivity info, multiweekorangebook_patent
: Approved Drug Products with Therapeutic Equivalence Evaluations, aka Orange Book - patent info, multiweekorangebook_products
: Approved Drug Products with Therapeutic Equivalence Evaluations, aka Orange Book - products, multiweekpurplebook
: All FDA-licensed (approved) biological products regulated by the Center for Drug Evaluation and Research (CDER), aka Purple Book - multimonth
Graham Center - mimi_ws_1.grahamcenter
- Description: Datasets from the Robert Graham Center - a research arm of AAFP
- Tables:
gme
: Graduate Medical Education Dataset - multiyearsdi_censustract
: Social Deprivation Index (SDI) at Census Tract Level - multiyearsdi_county
: Social Deprivation Index (SDI) at County Level - multiyearsdi_pcsa
: Social Deprivation Index (SDI) at PCSA (Primary Care Service Area) Level - multiyearsdi_zcta
: Social Deprivation Index (SDI) at ZIP-code Level - multiyear
HealthIT - mimi_ws_1.healthit
- Description: Datasets from the HealthIT.gov - the official website of the Office of the National Coordinator for Health Information Technology (ONC)
- Tables:
HHS-OIG - mimi_ws_1.hhsoig
- Description: Datasets from the HHS Office of Inspector General
- Tables:
buprenorphine_countydata
: Buprenorphine-Waivered Providers — County Dataleie
: List of Excluded Individuals/Entities (LEIE)
HRSA - mimi_ws_1.hrsa
- Description: Datasets from the Health Resources & Services Administration (HRSA)
- Tables:
HUDUser - mimi_ws_1.huduser
- Description: Datasets from huduser.gov - a part of the Office of Policy Development and Research, PD&R
- Tables:
cbsa_to_zip
: Core-Based Statistical Area (CBSA) to ZIP Code Crosswalk (raw data) - multiyearcbsa_to_zip_otm
: CBSA to ZIP crosswalk, one-to-many (otm) mapping based on the residential size - derived, latestcounty_to_zip
: County to ZIP Code Crosswalk (raw data) - multiyearcounty_to_zip_otm
: County to ZIP crosswalk, one-to-many (otm) mapping based on the residential size - derived, latesttract_to_zip
: Census Tract to ZIP Code Crosswalk (raw data) - multiyeartract_to_zip_mto
: Census Tract to ZIP crosswalk, many-to-one (mto) mapping based on the residential size - derived, latestzip_to_cbsa
: ZIP Code to Core-Based Statistical Area (CBSA) (raw data) - multiyearzip_to_cbsa_mto
: ZIP to CBSA crosswalk, many-to-one (mto) mapping based on the residential size - derived, latestzip_to_county
: ZIP Code to County Crosswalk (raw data) - multiyearzip_to_county_mto
: ZIP to County crosswalk, many-to-one (mto) mapping based on the residential size - derived, latestzip_to_tract
: ZIP Code to Census Tract Crosswalk (raw data) - multiyearzip_to_tract_otm
: ZIP to Census Tract crosswalk, one-to-many (otm) mapping based on the residential size - derived, latest
MedlinePlus - mimi_ws_1.medlineplus
- Description: Datasets from MedlinePlus - knowledge base, XML
- Tables:
NBER - mimi_ws_1.nber
- Description: Datasets from the National Bureau of Economic Research
- Tables:
ssa2fips_state_and_county
: SSA to FIPS crowsswalk
Neighborhood Atlas - mimi_ws_1.neighborhoodatlas
- Description: Datasets from the Neighborhood Atlas - Area Deprivation Index
- Tables:
adi_censusblock
: Area Deprivation Index (ADI) Original (Census Block Group Level)adi_censustract
: Area Deprivation Index (ADI) Aggregated (Census Tract Level, USE WITH CAUTION)adi_county
: Area Deprivation Index (ADI) Aggregated (Census Block Group Level, USE WITH CAUTION)
NPPES - mimi_ws_1.nppes
- Description: Datasets from NPPES (National Plan and Provider Enumeration System)
- Tables:
address_census_geocoder_dedup
: De-duplicated Geocoding Results for theaddress_key
tableaddress_census_geocoder_raw
: Raw Geocoding Results from the US Census Geocoder, derived from the `address_key``address_key
: Address Key, A collection of Unique Address Strings for all providers and timesdeactivated
: Deactived Provider Listendpoint
: Health Information Exchange (HIE) Endpoints, i.e., provider HIE contact address - multiyearendpoint_se
: HIE Endpoints formatted with Start and End dateslicense_se
: Provider License Data with Start and End dates, derived fromnpidata
mongodb_export
: Data Extract fornpi-db.org
(a demo project)npi_to_address
: NPI to Geocoded Address (both practice and mail address), only for the latest npidata batchnpidata
: NPIDATA - the base NPI directory, multiyearopenpayments
: Open Payment Summaries fornpi-db.org
, derived from theopenpayments
schemaotherid_ccn_se
: CCNs (CMS Certification Number, often used for facilities) with Start and End datesotherid_se
: Other Provider IDs with Start and End dates, derived fromnpidata
othername
: Other Business Names such as DBA - multiyearothername_se
: Other Business Names formatted with Start and End datespl
: Other Practice Locations - multiyearpl_se
: Other Practice Locations formatted with Start and End datestaxonomy_se
: Provider Taxonomies with Start and End dates
Open Payments - mimi_ws_1.openpayments
- Description: Datasets from the https://openpaymentsdata.cms.gov/ site
- Tables:
deleted
: The table contains records that have been deletedgeneral
: General Payments Details - multiyearownership
: Physician Ownership Details - multiyearresearch
: Research Payments Details - multiyear
Palmetto GBA - mimi_ws_1.palmettogba
- Description: Datasets from Palmetto GBA
- Tables:
dmecs
: DME Coding System (DMECS) Update Listingndc_hcpcs_xwalk
: NDC/HCPCS Crosswalk
Part C/D - mimi_ws_1.partcd
- Description: Datasets regarding Medicare Part C/D Enrollment and Perforamnce
- Tables:
cpsc_combined
: Medicare Advantage CPSC Enrollment with Directory Info - derived, multimonthcpsc_contract
: Medicare Advantage Contract Information from the CPSC bundle - multimonthcpsc_enrollment
: Medicare Advantage Enrollment by Contract/Plan/State/County (CPSC) - multimonthhedis_general
: HEDIS Public Use Files - Contract Information, multiyearhedis_measures
: HEDIS Public Use Files - Contract-level Performance, multiyearhedis_national_rates
: HEDIS Public Use Files - National Rates, multiyearhedis_rau_measures
: HEDIS Public Use Files - Risk Adjusted Measures, multiyearpbp_b13i_b19b_services_vbid_ssbci
: Medicare Advantage Benefits Information Section B13I-B19B VBID - Non-Primarily Health Related Benefits for the Chronically III, Food and Produce, Meals, Pest Control, Transportation for Non-Medical Needs, Indoor Air Quality Equipment and Services and Other data.; multiquarterpbp_b14c_b19b_preventive_vbid_uf
: Medicare Advantage Benefits Information Section B14C-B19B VBID - Contains Supplemental Benefits Preventive Services VBID and UF data for Health Education/Wellness, Fitness Benefit, Counseling Services.; multiquarterpbp_b15_partb_rx_drugs
: Medicare Advantage Benefits Information Section B15 PartB Rx - Medicare Part B prescription drugs.; multiquarterpbp_section_a
: Medicare Advantage Benefits Information Section A - Contains general plan information.; multiquarterpbp_section_d_opt
: Medicare Advantage Benefits Information Section D Optional - Contains plan-level benefit data descriptions of optional supplemental offerings including the optional benefit premium amounts, multiquarter
Payer MRF - mimi_ws_1.payermrf
- Description: Price Transparency Files from various Payers - currently loaded: UnitedHealthcare, Medica, planned: Aetna - aka Payer TiC files, commercial or employer rates.
- Tables:
allowed_amounts
: Allowed Amounts Data (Out-of-Network) - Out-of-Network pricing data, Currently, UHC and Medica data are loaded. multimonthin_network_rates
: In-Network Rates Data - Some of UHC data, and all Medica in-network files are loaded.medica_toc
: Medica Table of Contents - multimonthmolina_provider_directory
: Molina Healthcare Provider Directory at county-level - multimonthprovider_references
: Provider Reference Dataunh_toc
: UnitedHealthcare Table of Contents - multimonth
Prescription Drug Plan - mimi_ws_1.prescriptiondrugplan
- Description: Datasets from the Part-D Formularies and Networks section - a subsection of the data.cms.gov site
- Tables:
basic_drugs_formulary
: Basic Drugs Formulary File - multiquarterbeneficiary_cost
: Beneficiary Cost File - multiquarterexcluded_drugs_formulary
: Excluded Drugs Formulary File - multiquartergeographic_locator
: Geographic Locator File - multiquarterindication_based_coverage_formulary
: Indication Based Coverage (IBC) Formulary File - multiquarterinsulin_beneficiary_cost
: Insulin Beneficiary Cost File - multiquarterpartial_gap_coverage
: Partial Gap File - multiquarterpharmacy_networks
: Pharmacy Networks File - multiquarterplan_information
: Plan Information File - multiquarterpricing
: Pricing File - multiquarter
Provider Data Catalog - mimi_ws_1.provdatacatalog
- Description: Datasets from the CMS Provider Data Catalog section - a subsection of the data.cms.gov site
- Tables:
dac_ec_public_reporting
: Doctors and Clinicians - Clinician Public Reporting: MIPS Measures and Attestations - multimonthdac_ec_score_file
: Doctors and Clinicians - Clinician Public Reporting: Overall MIPS Performance - multimonthdac_fa
: Doctors and Clinicians - Facility Affiliations - multimonthdac_grp_public_reporting
: Doctors and Clinicians - Group Public Reporting: MIPS Measures and Attestations - multimonthdac_grp_public_reporting_cahps
: Doctors and Clinicians - Group Public Reporting: Patient Experience - multimonthdac_ndf
: Doctors and Clinicians - National Downloadable Files - multimonthdac_utilization
: Doctors and Clinicians - Utilization - multimonthdac_vg_public_reporting
: Doctors and Clinicians - Virtual Group Public Reporting: MIPS Measures and Attestations - multimonthnursinghomes_mds
: Nursing Home Minimum Data Set (MDS) Files - multimonth
State Government Databases - mimi_ws_1.stategov
- Description: Datasets from State Governments
- Tables:
california_medicaid_provider_directory
: California Medicaid Provider Directory - multimonthgeorgia_medicaid_provider_directory
: Gerogia Medicaid Provider Directory - multimonthnewyork_medicaid_provider_directory
: New York Medicaid Provider Directory - multimonth
Surgo Ventures - mimi_ws_1.surgoventures
- Description: Datasets from Surgo Ventures
- Tables:
ccvi_county
: THE U.S. COVID COMMUNITY VULNERABILITY INDEX (CCVI) - county-levelccvi_state
: THE U.S. COVID COMMUNITY VULNERABILITY INDEX (CCVI) - state-levelmvi_county
: The U.S. Maternal Vulnerability Index by Surgo Ventures
CMS Synthetic Medicare PUF - mimi_ws_1.synmedpuf
- Description: CMS Synthetic Medicare PUF
- Tables:
beneficiary
: Beneficiary Summarycarrier
: Carrier Claimsdme
: Durable Medical Equipment Claimshha
: Home Health Agency Claimshospice
: Hospice Claimsinpatient
: Inpatient Claimsoutpatient
: Outpatient Claimspde
: Prescription Drug Events from 2008 to 2010snf
: Skilled Nursing Facility Claims
Synthea - mimi_ws_1.synthea
- Description: Datasets from the MITRE Synthea project - 1.1M synthetic patients
- Tables:
allergies
: Patient allergy data.careplans
: Patient care plan data, including goals.conditions
: Patient conditions or diagnoses.devices
: Patient-affixed permanent and semi-permanent devices.encounters
: Patient encounter data.imaging_studies
: Patient imaging metadata.immunizations
: Patient immunization data.medications
: Patient medication data.observations
: Patient observations including vital signs and lab reports.organizations
: Provider organizations including hospitals.patients
: Patient demographic data.payer_transitions
: Payer Transition data (i.e. changes in health insurance).payers
: Payer organization data.procedures
: Patient procedure data including surgeries.providers
: Clinicians that provide patient care.supplies
: Supplies used in the provision of care.
Zillow - mimi_ws_1.zillow
- Description: Datasets from Zillow (a real-estate marketplace company)
- Tables:
homevalue_zip
: Home Values by Zillow - time-seriesrent_zip
: Rentals by Zillow - time-series