Scorecard Measure V2.11.9 (prod)
U.S. Department of Health & Human Services
@usgov.hhs_gov_scorecard_measure_v0_3_42_prod
U.S. Department of Health & Human Services
@usgov.hhs_gov_scorecard_measure_v0_3_42_prod
CREATE TABLE scorecard_measure_v3_3_1_prod (
"id" VARCHAR,
"measure_abbreviation" VARCHAR,
"display_name" VARCHAR,
"description" VARCHAR,
"data_source_link" VARCHAR,
"data_period_type" VARCHAR,
"data_range" VARCHAR,
"num_states_denom" VARCHAR,
"keywords" VARCHAR,
"data_source" VARCHAR,
"median_label" VARCHAR,
"median_type" DOUBLE,
"mean_label" VARCHAR,
"mean_type" DOUBLE,
"trend_indicator" BIGINT,
"bar_chart_indicator" BIGINT,
"has_national_view" BIGINT,
"has_state_view" BIGINT,
"is_bar_chart_sortable" VARCHAR,
"pillar_name" VARCHAR,
"pillar_id" BIGINT,
"has_state_data" BOOLEAN,
"has_any_national_data" BOOLEAN,
"states_reporting" VARCHAR,
"possible_charts" VARCHAR,
"display_order" BIGINT,
"state_data_type" VARCHAR,
"key_metrics" VARCHAR
);
Anyone who has the link will be able to view this.