Mansfield, Ohio — sample government employer and public-servant CSVs
=====================================================================

These files are compiled from official and widely cited public sources (City of Mansfield
city directory, Mansfield Municipal Court contact page, Mansfield City Schools, MRCPL,
Richland County commissioner summaries, and local news mentions for council members).
Verify all fields before relying on them in production; phones, emails, and rosters change.

Import order (recommended)
--------------------------
1) Employer directory CSV (CR Registry → Import CSV, then approve on CSV import queue;
   or use the links under Employer directory → Import employers from CSV)
   File: mansfield-employer-directory.csv

2) Registry / profiles CSV (CR Registry → Import CSV)
   File: mansfield-public-servants-registry-import.csv
   Enable “Merge into existing records” if you re-import or if a person appears with
   multiple employers (e.g. Julie Shoup under both Public Works and Safety-Service).

Employer name matching
----------------------
Profile rows use the same employer_name strings as the employer directory CSV (including
the en dash “–” between “Mansfield” and the department name) so intake autocomplete stays
consistent.

Files
-----
- mansfield-employer-directory.csv — columns: name, address, phone_primary,
  phone_secondary, notes, sort_order, active
- mansfield-public-servants-registry-import.csv — Community Registry person import columns;
  extra context is in employer_notes and notes.

Sources (non-exhaustive)
------------------------
https://ci.mansfield.oh.us/city-directory
https://ci.mansfield.oh.us/city-organizational-chart/
https://mansfieldcourts.com/contact/
https://www.mansfieldschools.org/SuperintendentsOffice.aspx
https://www.mrcpl.org/visit/locations/main-library/
https://ci.mansfield.oh.us/public-works-departments/water-treatment/
https://rctbuses.com/contact/
