data integrity of pretrial snapshot

[ghonk]

The data here don't appear to be consistent re: use of missing data labels and have a number of other issues that warrant discussion.

For example on the RacialEthnic Data tab the data contain N/A, blanks, replied "unknown", and unknown for missing values. There are comments in the data that indicate that multi-racial individuals are assigned one of their reported races.

The Hold Breakdowns tab has a similar problem, there are also non-integer data (despite being a count for inmates).

It would be good to document these issues and try to get clarity from the project partner (ACLU?)

[charlottemcclintock]

Definitely something we should run by the ACLU contact! I'll make a doc in the Google Drive with questions.

[akelleh]

The Racial/Ethnic tab also has non-integer data for Pueblo! Looks like Pueblo is the only one with non-integer values, across all tabs.

[ghonk]

2/3 of the meaningful datasets in this xlxs doc have been converted to usable format (needs review)