Gate 1: Data Import | FlawFinder Outreach

📋 Required CSV Columns

department_id - Unique identifier (e.g., broward-fl)
county - County name (e.g., Broward County)
state - 2-letter state code (e.g., FL)
contact_first_name - First name
contact_last_name - Last name
contact_email - Valid email address
contact_role - One of: admin, public_defender, chief_felonies, chief_misdemeanors, chief_major_crimes, chief_serious_crimes, division_chief, apd

Sample CSV format:

department_id,county,state,contact_first_name,contact_last_name,contact_email,contact_role
broward-fl,Broward County,FL,Mark,Thompson,mthompson@pd17.org,public_defender
broward-fl,Broward County,FL,Sarah,Johnson,sjohnson@pd17.org,admin
broward-fl,Broward County,FL,James,Rodriguez,jrodriguez@pd17.org,chief_felonies