Data preparation

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

fl_healthcharts.robbery · 2025

Values changed: None

Total rows removed: 25

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 25 reporting years. No Unallocated rows were added.

Show each reporting year

Reporting year	Florida row	Sum of 67 other rows	Result
2001	10,940	10,940	Matched
2002	11,086	11,086	Matched
2003	10,194	10,194	Matched
2004	10,194	10,194	Matched
2005	10,258	10,258

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...