About this Dataset

Scorecard Measure Value V2.12.4 (dev)

This is a dataset created for the Medicaid Scorecard website (https://www.medicaid.gov/state-overviews/scorecard/index.html), and is not intended for use outside that application.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-07-14T15:59:23.897377
Tags: scorecard, utility

Tables

Scorecard Measure Value V3.7.6 (Development)

@usgov.hhs_gov_scorecard_measure_value.scorecard_measure_value_v3_7_6_development

1.92 MB
84867 rows
64 columns


CREATE TABLE scorecard_measure_value_v3_7_6_development (
  "id" BIGINT,
  "measure_id" VARCHAR,
  "state_abbreviation" VARCHAR,
  "strat_tier1_label" VARCHAR,
  "strat_tier1_value" VARCHAR,
  "strat_tier1_order" VARCHAR,
  "strat_tier2_label" VARCHAR,
  "strat_tier2_value" VARCHAR,
  "strat_tier2_order" VARCHAR,
  "strat_tier3_label" VARCHAR,
  "strat_tier3_value" VARCHAR,
  "strat_tier3_order" VARCHAR,
  "group_tier1_label" VARCHAR,
  "group_tier1_value" VARCHAR,
  "group_tier1_order" VARCHAR,
  "cat_label" VARCHAR,
  "cat_order" VARCHAR,
  "cat_value" VARCHAR,
  "data_period" VARCHAR,
  "population" VARCHAR,
  "methodology" VARCHAR,
  "measure_value" VARCHAR,
  "values_direction" VARCHAR,
  "value_type" VARCHAR,
  "value_type_is_default" BOOLEAN,
  "value_indicator" VARCHAR,
  "number_of_states_reporting" VARCHAR,
  "geography_total" VARCHAR,
  "value_label" VARCHAR,
  "analysis_source" VARCHAR,
  "notes" VARCHAR,
  "notes_visualization" VARCHAR,
  "default_multi" VARCHAR,
  "default_single" VARCHAR,
  "legend_order" VARCHAR,
  "map_category" VARCHAR,
  "value_order" BIGINT,
  "alt_bin1" VARCHAR,
  "alt_bin2" VARCHAR,
  "alt_bin3" VARCHAR,
  "alt_bin4" VARCHAR,
  "alt_bin5" VARCHAR,
  "alt_bin6" VARCHAR,
  "alt_bin7" VARCHAR,
  "alt_bin_desc12" VARCHAR,
  "alt_bin_desc23" VARCHAR,
  "alt_bin_desc34" VARCHAR,
  "alt_bin_desc45" VARCHAR,
  "alt_bin_desc56" VARCHAR,
  "alt_bin_desc67" VARCHAR,
  "decimal_places" VARCHAR,
  "dataset" BIGINT,
  "value_type_category" VARCHAR,
  "group_tier2_label" VARCHAR,
  "group_tier2_value" VARCHAR,
  "group_tier2_order" VARCHAR,
  "mean" VARCHAR,
  "q1" VARCHAR,
  "alt_mean" VARCHAR,
  "median" VARCHAR,
  "map_statistic" VARCHAR,
  "max" VARCHAR,
  "min" VARCHAR,
  "q3" VARCHAR
);