States with unprocessed data

[ayyubibrahimi]

A list of states where the data has not been processed/cleaned:
Kansas
Kentucky
Mississippi
North Carolina
North Dakota
New Mexico
Wyoming

[stecklow]

We have new unprocessed Indiana data: https://www.dropbox.com/scl/fi/8h3ocpaps0elrq50o1yny/Officer-Employment-History-7.25.24.xlsx?rlkey=gqv3fn4jojo548kzyn8mtd7yt&dl=0

Emily Hopkins at Mirror Indy has been working on reformatting it — if there is code we can send her, I could forward it along and she could potentially work on processing this file for us.

[stecklow]

Just got new data for Iowa from Ben Grunwald (no use restriction): https://www.dropbox.com/scl/fo/yzb839j16wr4mmxz7azsc/AJhhfoYqRD3W8JBFIimtOQI?rlkey=fo8qtq96z6g7jvpzbq6qhbhnc&dl=0

[stecklow]

States with reason for separation that have not been processed (to my knowledge):

• Iowa
• Indiana* (I shared code that Justin Mayo provided to me with the Mirror Indy reporter to implement on the Indiana data, so I will follow up with her)
• North Dakota
• New Mexico
• Wyoming

[stecklow]

Need a plan of action for:

• ID (Tarak) (Done)
• NM (Ayyub) (Done)
• ND (putting aside for now)
• MN
• IA (Ben is updating IA)
• MS
• NC
• KS

[tarakc02]

The updated Indiana data is ready and in the repo

[ayyubibrahimi]

Just deployed ID and NM