...
| field | type | attributes | notes | example |
|---|---|---|---|---|
| measure_id | int(11) | NOT NULL | from Measures | 12345 |
| entity_id | bigint(20) | unsigned NOT NULL | from Entities | 123456 |
| date_start | date | NOT NULL | YYYY-MM-DD | 2008-01-01 |
| date_end | date | NOT NULL | YYYY-MM-DD | 2008-12-31 |
| source_id | int(11) | NOT NULL DEFAULT '0' | from Value sources | |
| is_comparator | tinyint(1) | NOT NULL DEFAULT '0' | Values can either be (0) reported or (1) calculated by aggregating multiple entities into comparator values, for example state average or average of the top quartile. If the value is a comparator value this field is set to "1" | |
| is_private | tinyint(1) | NOT NULL DEFAULT '0' | Values can either be (0) public domain or (1) private property. If the value is private this field is set to "1" | |
| value | decimal(16,5) | DEFAULT NULL | ||
| unit | enum('percent','per 1000','per 100000','cases','ratio','days','hours','patients','dollars','na','minutes','people','square miles','years','households','per 100','per 10000','micrograms') | NOT NULL DEFAULT 'na' | ||
| numerator | decimal(16,5) | DEFAULT NULL | ||
| denominator | decimal(16,5) | DEFAULT NULL |
| |
| letter_grade | varchar(3) | DEFAULT NULL | ||
| range5 | decimal(16,5) | DEFAULT NULL | ||
| sig_var_state | enum('-1','0','1') | DEFAULT NULL | Subject to Minimum sample the value is tested for statistically significant variation from the state average.
For more information about this field and the methodology used please read Statistical significance. | |
| sig_var_nation | enum('-1','0','1') | DEFAULT NULL | Subject to Minimum sample the value is tested for statistically significant variation from the national average.
For more information about this field and the methodology used please read Statistical significance. | |
| sig_change | enum('-1','0','1') | DEFAULT NULL | Subject to Minimum sample the value is tested for statistically significant improvement from the previous measurement point.
For more information about this field and the methodology used please read Statistical significance. | |
| std_dev_from_state | decimal (16,5) | DEFAULT NULL | standard deviation from state value | 1.96 |
| std_dev_from_nation | decimal (16,5) | DEFAULT NULL | standard deviation from national value | 2.21 |
| std_dev | decimal (16,5) | DEFAULT NULL | standard deviation for the measure set | 5.12 |
| lower_ci | decimal (16,5) | DEFAULT NULL | lower confidence interval for statistical analysis | |
| upper_ci | decimal(16,5) | DEFAULT NULL | upper confidence interval for statistical analysis AFTER lower_ci | |
| percentile_nation | smallint(3) | DEFAULT NULL | Subject to Minimum sample the value is percentile ranked against all eligible values (of the same entity type) in the national set. For more information about this field and the methodology used please read Percentile ranking. Not all values are ranked. | |
| percentile_state | smallint(3) | DEFAULT NULL | Subject to Minimum sample the value is percentile ranked against all eligible values (of the same entity type) in the relevant state set. For more information about this field and the methodology used please read Percentile ranking. Not all values are ranked. | |
| rank_place_nation | smallint(6) | DEFAULT NULL | Subject to Minimum sample the value is competitively ranked against all eligible values (of the same entity type) in the national set. For more information about this field and the methodology used please read Competitive ranking. | |
| rank_denominator_nation | smallint(6) | DEFAULT NULL | If the value was competitively ranked, this field holds the denominator of the ranked set. | |
| rank_place_state | smallint(6) | DEFAULT NULL | Subject to Minimum sample the value is competitively ranked against all eligible values (of the same entity type) in the relevant state set. For more information about this field and the methodology used please read Competitive ranking. | |
| rank_denominator_state | smallint(6) | DEFAULT NULL | If the value was competitively ranked intra-state, this field holds the denominator of the ranked (state) set. | |
| Created | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' | The timestamp of row INSERTion | |
| Modified | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE | The timestamp of latest row UPDATE | |
| batch_id | varchar(64) | DEFAULT NULL | Denotes the data run the row was a part of |
...