Commercial Medical Insurance (MSCANCC) - Vision And Eye Health Surveillance by US Government | Finance and Economics

About this Dataset

Commercial Medical Insurance (MSCANCC) - Vision And Eye Health Surveillance

This dataset is a de-identified summary table of prevalence rates for vision and eye health data indicators from the 2016 MarketScan® Commercial Claims and Encounters Data (CCAE) is produced by Truven Health Analytics, a division of IBM Watson Health. The CCEA data contain a convenience sample of insurance claims information from person with employer-sponsored insurance and their dependents, including 43.6 million person years of data. Prevalence estimates are stratified by all available combinations of age group, gender, and state. Detailed information on VEHSS MarketScan analyses can be found on the VEHSS MarketScan webpage (cdc.gov/visionhealth/vehss/data/claims/marketscan.html). Information on available Medicare claims data can be found on the IBM MarketScan website (https://marketscan.truvenhealth.com). The VEHSS MarketScan summary dataset was last updated November 2019.
Organization: U.S. Department of Health & Human Services
Last updated: 2020-11-10T16:17:53.538689
Tags: claims, diagnosed-prevalence, eye-exams, marketscan, medical-diagnoses, service-utilization, truven

Tables

Table 1

@usgov.hhs_gov_commercial_medical_insurance_mscancc_vision_an_082d2d16.table_1

4.84 MB
757927 rows
37 columns


CREATE TABLE table_1 (
  "yearstart" BIGINT,
  "yearend" BIGINT,
  "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
);