Data preparation

What Metrka changed between the original source and this published version.

fl_healthcharts.violent_crime · 2024

Values changed: None

Total rows removed: 24

Columns renamed: 5 of 6

Checked totals1

Florida row checked and removed

For each reporting year, the source has a Florida row holding the total. Metrka added up the 67 other rows and compared the sum with the Florida row, then removed the Florida row so it is not counted twice.

Row: geography_name = Florida
Total of: arrests_count

The Florida row matched the sum of the other rows in all 24 reporting years. No Unallocated rows were added.

Show each reporting year

Reporting year	Florida row	Sum of 67 other rows	Result
2001	53,239	53,239	Matched
2002	50,384	50,384	Matched
2003	46,776	46,776	Matched
2004	47,217	47,217	Matched
2005	48,554	48,554

Values changed0

No source values were changed. The Florida rows removed are listed under Checked totals.

Columns6

Each source column is published under the name and type its contract declares.

Source column	Published as	Type
County	geography_name	string
Count	arrests_count	int
Denom	population_denominator	int
Rate	arrests_per_100000_population	decimal(12,1)
MOV	rate_measure_of_variability	decimal(12,1)

Loading data preparation...