Dataset: Medicaid Claims (MAX) - Vision And Eye Health Surveillance

About this Dataset

Medicaid Claims (MAX) - Vision And Eye Health Surveillance

2016-2019. This dataset is a de-identified summary table of prevalence rates for vision and eye health data indicators from the Medicaid Analytic eXtract (MAX) data. Medicaid MAX are a set of de-identified person-level data files with information on Medicaid eligibility, service utilization, diagnoses, and payments. The MAX data contain a convenience sample of claims processed by Medicaid and Children’s Health Insurance Program (CHIP) fee for service and managed care plans. Not all states are included in MAX in all years, and as of November 2019, 2014 data is the latest available. Prevalence estimates are stratified by all available combinations of age group, gender, and state. Detailed information on VEHSS Medicare analyses can be found on the VEHSS Medicaid MAX webpage (cdc.gov/visionhealth/vehss/data/claims/medicaid.html). Information on available Medicare claims data can be found on the ResDac website (www.resdac.org). The VEHSS Medicaid MAX dataset was last updated May 2023.
Organization: U.S. Department of Health & Human Services
Last updated: 2020-11-10T16:17:54.444806
Tags: claims, diagnosed-prevalence, eye-exams, max, medicaid, medical-diagnoses, screening, service-utilization

Tables

Table 1

@usgov.hhs_gov_medicaid_claims_max_vision_and_eye_health_surveillance.table_1

210.98 MB
13593123 rows
37 columns


CREATE TABLE table_1 (
  "yearstart" BIGINT,
  "yearend" DOUBLE,
  "locationabbr" VARCHAR,
  "locationdesc" VARCHAR,
  "datasource" VARCHAR,
  "topic" VARCHAR,
  "category" VARCHAR,
  "question" VARCHAR,
  "response" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "raceethnicity" VARCHAR,
  "riskfactor" VARCHAR,
  "riskfactorresponse" VARCHAR,
  "data_value_unit" VARCHAR,
  "data_value_type" VARCHAR,
  "data_value" DOUBLE,
  "data_value_footnote_symbol" VARCHAR,
  "data_value_footnote" VARCHAR,
  "low_confidence_limit" DOUBLE,
  "high_confidence_limit" DOUBLE,
  "numerator" BIGINT,
  "sample_size" BIGINT,
  "locationid" BIGINT,
  "topicid" VARCHAR,
  "categoryid" VARCHAR,
  "questionid" VARCHAR,
  "responseid" VARCHAR,
  "datavaluetypeid" VARCHAR,
  "ageid" VARCHAR,
  "sexid" VARCHAR,
  "raceethnicityid" VARCHAR,
  "riskfactorid" VARCHAR,
  "riskfactorresponseid" VARCHAR,
  "geolocation" VARCHAR,
  "geographic_level" VARCHAR,
  "stateabbr" VARCHAR
);