Update financial disclosure sheets:

Employer:

~~[x] #198~~
[x] What does the date registered tell us? I think we can drop this column, but if you think I’m missing something about the importance of this, please let me know.
[x] The Reporting Individual column header isn’t great, this is probably a drop-down list in the online form they fill out - maybe change to “Reporting Individual Status” ?
[x] Is the reason some people don’t show up in this workbook because they have no employer, no spouse, and no income? Example: Shannon Pinto. Is it possible to populate the employer column as “blank” anyone who doesn’t fill in an employer, so that this is a comprehensive collection of all filers? There is an automatic blank category that appears now, but those people have spouses or list sources of income. I’d like to capture the folks who report nothing at all, to make it clear - example: Shannon Pinto
[x] Insert “spouse” in front of last name, first name for spouse name columns
[x] There are weird figures where apostrophes appear in spouse columns, anyway to fix that?
[ ] There are two spouse columns in the forms that are being captured as one, in Column X. Probably because of the form itself. Can you insert some commas in the column name and in the content of the column to fix this? Or better, separate them into separate columns?

Lobbyist Spreadsheet:

[x] Drop date registered
[x] Change Reporting Individual header as above
[x] I would flip the client name and represented by columns. And shorten the represented header to “Name of lobbyist or their firm”

Business Spreadsheet:

[x] Drop date registered
[x] Change Reporting Individual header as above
[x] Rename Column J: Name of Other Business
~~[ ] Add: “Source of income over $5,000” column, and a “Receiver of the income” column.~~
[x] (To Check: in the current employer spreadsheet with these sources of income columns, there appear to be duplicates for these two columns)

Real Estate:

Specialization:

[x] Drop date registered
[x] Change Reporting Individual header as above
[x] Column L: Change heading to “Professional Licenses held in NM”
[x] Column N: Change heading to “Board Service Organization”
[x] Can we try that “General Information” as the last column in this spreadsheet?

State Agency:

[x] Drop date registered
[x] Change Reporting Individual header as above
[x] Column L: Change header to “State agency represented client before (other than a court):”

datamade / openness-project-nmid