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
Nobody has any idea of what corporate statuses mean. Here's a sample:
REVKD-AUTO AR/$ CORP-NO REPORT AND/OR FEESCONV NATL BANKMERGEDWITHDRAWN(VOL) (CORP)CANC (AUTO-FEE) LLC/LP/BT-FEES NOT PAIDTERM(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:
Do the following:
1_tables