openva / crump

A parser for the Virginia State Corporation Commission's business registration records.
https://vabusinesses.org/
MIT License
20 stars 3 forks source link

Normalize officer titles #111

Open waldoj opened 9 years ago

waldoj commented 9 years ago

Here are the 50 most frequently-used titles in 5_officers:

title uses frequency
PRESIDENT 179760 27.97%
VICE PRESIDENT 89793 13.97%
SECRETARY 62740 9.76%
TREASURER 45240 7.04%
OFFICER 16614 2.58%
S/T 14997 2.33%
DIRECTOR 13669 2.13%
SEC/TREAS 9042 1.41%
CEO 8694 1.35%
P/S/T 8680 1.35%
ASST SECRETARY 7371 1.15%
P/T 6128 0.95%
CHAIRMAN 5816 0.90%
VP/S 5806 0.90%
CFO 4798 0.75%
P/S 4664 0.73%
PRES/DIR 3960 0.62%
PRES/TREAS 3817 0.59%
P/CEO 3553 0.55%
VP/SEC 3364 0.52%
PRES/SEC/TREAS 3348 0.52%
VP/T 2771 0.43%
PRES/SEC 2545 0.40%
PRES/CEO 2542 0.40%
ASST TREASURER 2401 0.37%
SR VP 2104 0.33%
VP/S/T 1855 0.29%
EXEC VP 1838 0.29%
COO 1725 0.27%
VICE CHAIRMAN 1692 0.26%
DIR/PRES 1635 0.25%
ASST SEC 1609 0.25%
VP/TREAS 1436 0.22%
P/D 1331 0.21%
PRESIDENT/CEO 1168 0.18%
OFC/DIR 1101 0.17%
OFFICER/DIR 1064 0.17%
SVP 1049 0.16%
EVP 995 0.15%
VP/SECRETARY 978 0.15%
VP/DIR 963 0.15%
DIR 880 0.14%
VP/SEC/TREAS 869 0.14%
SECRETARY/TREAS 828 0.13%
COB 796 0.12%
SECRE 749 0.12%
T/S 725 0.11%
1ST VP 714 0.11%
CHAIR 714 0.11%
DIR/OFFICER 694 0.11%

This is begging to be normalized. e.g., P/CEO, PRES/CEO, and PRESIDENT/CEO are all the same thing. All of these abbreviations are confusing to people.