Data preparation

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

fl_healthcharts.motor_vehicle_traffic_crashes · 2024

Values changed: None

Total rows removed: 28

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: crashes_count

13 of 28 totals were higher than the sum of their rows. The difference, 1,858 in all, was published as Unallocated rows.

Show each reporting year

Reporting year	Florida row	Sum of 67 other rows	Difference	Result
1997	241,093	240,185	908	Unallocated +908
1998	245,683	245,197	486	Unallocated +486
1999	243,536	243,282	254	Unallocated +254
2000	246,597	246,485	112	Unallocated +112
2001	256,177	256,161	16

Values changed0

No source values were changed. The Florida rows removed and the Unallocated rows added 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	crashes_count	int
Denom	population_denominator	int
Rate	crashes_per_100000_population	decimal(12,1)
MOV	rate_measure_of_variability	decimal(12,1)

Loading data preparation...