Bulk Data File Formats and Descriptions

File Formats

File Descriptions

The following is a description for all of the data files available for download through this service. Depending on your subscription settings you may or may not actually have access to all of the files listed below.​

Business Entity Data
File Name Description
All Companies All Companies contains a listing of all businesses on file with the Secretary of State. The file is generated monthly and is tab delimited. This file can be extended to link the initial officers associated with the business contained in 'All Initial Officers' with the field 'ID'. Additionally, all current officers associated with a business contained in 'All Officers' may be joined by using the combination of 'ID' with 'comptype' and 'compseq'.
All Initial Officers All Initial Officers contains a listing of all officer records originally associated with a business filing when it was registered with the Secretary of State and is updated monthly. This file is tab delimited and is directly associated with the file 'All Companies' by joining records with the field 'ID'.
All Officers All Officers contains a listing of all current officers on file with the Secretary of State associated with a business and is updated monthly. This file is tab delimited and is directly associated with the file 'All Companies' by joining records with the fields 'ID', 'comptype', and 'compseq'.
New Companies Weekly New Companies Weekly contains a listing of all the new businesses registered with the Secretary of State the previous week. The file is generated every Monday and is tab delimited. This file can be extended by joining 'New Company Officers Weekly' with the field 'ID'.
New Company Officers Weekly New Company Officers Weekly contains a listing of all new officers associated with a company registered with the Secretary of State the previous week. The file is generated every Monday and is tab delimited. This file can be extended by joining 'New Companies Weekly' with the field 'ID'.
New Companies New Companies contains a listing of all the new businesses registered with the Secretary of State the previous business day. The file is generated daily and is tab delimited. This file can be extended by joining 'New Company Officers' with the field 'ID'.
New Company Officers New Company Officers contains a listing of all new officers associated with a company registered with the Secretary of State the previous business day. The file is generated daily and is tab delimited. This file can be extended by joining 'New Companies' with the field 'ID'.
Company Changes Company Changes contains a listing of all the businesses registered with the Secretary of State that changed the previous business day. Changes consist of things such as address changes, registered agent changes, officer changes, status changes, etc. The file is generated daily and is tab delimited. This file can be extended by joining 'Company Officer Changes' with the fields 'ID', 'comptype', and 'compseq'.
Company Officer Changes Company Officer Changes contains a listing of all the officers registered with the Secretary of State that changed the previous business day. Changes consist of things such as address changes, registered agent changes, officer changes, status changes, etc. The file is generated daily and is tab delimited. This file can be extended by joining 'Company Changes' with the fields 'ID', 'comptype', and 'compseq'.
UCC Filing Data
File Name Description
All UCC Filings This file contains a listing of all UCC Filings on record with the Secretary of State and is generated the first day of each month.
All UCC Collateral This file contains a listing of all UCC Filing collateral descriptions on file with the Secretary of State and is generated the first day of each month.
All UCC Secured Parties and Debtors This file contains a listing of all secured parties and debtors associated with a UCC Filing on file with the Secretary of State and is generated the first day of each month.
UCC Filings Weekly This file contains a listing of new UCC Filings on record with the Secretary of State for a specific week (Mon-Sun). The file is generated every Monday.
UCC Collateral Weekly This file contains a listing of new UCC Filing collateral descriptions on file with the Secretary of State for a specific date. The file is tied to "Weekly UCC Filings." This file is generated every Monday.
UCC Secured Parties and Debtors Weekly his file contains a listing of new secured parties and debtors associated with a UCC Filing on file with the Secretary of State for a specific week (Mon-Sun). The file is generated every Monday.
New UCC Filings This file contains a listing of new UCC Filings on record with the Secretary of State for a specific date. The file is generated daily.
New UCC Collateral This file contains a listing of new UCC Filing collateral descriptions on file with the Secretary of State for a specific date. The file is tied to "Daily UCC Filings." This file is generated daily.
New UCC Secured Parties and Debtors This file contains a listing of new secured parties, debtors, and filers associated with a UCC Filing on file with the Secretary of State for a specific date. This file is generated daily.
UCC Images
File Name Description
Daily UCC Images This file contains images of all the UCC Filings filed with the Secretary of State the previous business day. This file is generated daily.
​​​​