State of Rhode Island and Providence Plantations Office of the Secretary of State |
Tab delimiated table structure for Weekly Corporations Export file |
Format last updated: Wednesday, August 15, 2007 |
| Columns |
| Name | Type | Size |
| corp_id | Long Integer | 4 |
| corp_name | Text | 175 |
| elected_name | Text | 175 |
| incorp_dt | Date/Time | 12 |
| effect_dt | Date/Time | 12 |
| chapter | Text | 175 |
| charter | Text | 255 |
| purpose | Text | 5000 |
| state_of_incorp | Text | 2 |
| agent | Text | 175 |
| CO_address | Text | 55 |
| agent_street | Text | 55 |
| agent_city | Text | 30 |
| agent_state | Text | 2 |
| agent_zip | Text | 15 |
| officer_fname | Text | 25 |
| officer_lname | Text | 35 |
| officer_minit | Text | 25 |
| officer_suffix | Text | 10 |
| officer_type | Text | 60 |
| officer_street | Text | 55 |
| officer_city | Text | 30 |
| officer_state | Text | 2 |
| officer_zip | Text | 15 |
| officer_country | Text | 3 |