Data preparation

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

fl_healthcharts.murder · 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	1,883	1,883	Matched
2002	1,741	1,741	Matched
2003	1,586	1,586	Matched
2004	1,801	1,801	Matched
2005	1,910	1,910

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