Convert all statuses to English

[waldoj]

Nobody has any idea of what corporate statuses mean. Here's a sample:

• REVKD-AUTO AR/$ CORP-NO REPORT AND/OR FEES
• CONV NATL BANK
• MERGED
• WITHDRAWN(VOL) (CORP)
• CANC (AUTO-FEE) LLC/LP/BT-FEES NOT PAID
• TERM(VOLUNTARY) (CORP)

When transforming the data, don't just substitute the SCC's terminology—instead expand them into English. These are all of the possible statuses, typos and all:

• FEE DELINQUENT
• FEE DELINQUENT FOLLOWING REINSTATEMENT
• CANC INVOL
• TERM INVOL
• TERM(AUTO AR/$) CORP-NO REPORT AND/OR FEES
• TERM(AUTO R/A) CORP-FAILURE TO MAINTAIN R/A
• TERM(EXPIRED) CORP-DATE OF DURATION EXPIRED
• TERM(VOLUNTARY) (CORP)
• DISSOLVING
• CANC(VOLUNTARY) (LLC/LP/BT)
• INVDISS/COURT
• CANC/DOM (CORP)
• SURRENDERED (CORP)
• CANC (AUTO-FEE) LLC/LP/BT-FEES NOT PAID
• MERGED
• MERGED - DELINQUENT
• CONV NATL BANK
• GP EXPIRED AUTO
• CANCBYDIS
• CANC/DOM (LLC)
• SURRENDERED (LLC)
• REVKD-AUTO AR/$ CORP-NO REPORT AND/OR FEES
• REVOKED-AUTO RA CORP-FAILURE TO MAINTAIN R/A
• REVOKED (EXP) CORP-DATE OF DURATION EXPIRED
• WITHDRAWN(VOL) (CORP)
• WTHDRWN-MERGER
• WTHDRWN-CNVRSION
• CANCELED-CNVRSION
• CONVERTED ADM
• CONVERTED
• LLP STATUS ONLY
• LLP STATUS CANCELLED
• REPEALED
• CANC(AUTO R/A) LLC/LP/BT-FAILED MAINTAIN R/A
• CONV FOREIGN/DOMESTIC
• VOID

Do the following:

• Create a YAML file that will store the replacement text
• Rewrite the text of each of these in plain English
• Modify Crump to use the YAML file to make replacements, using the same unique identifier within the YAML as is used within 1_tables