Products, AVS, Data & Publications

PUBLICATIONS & DATA



CONTACT US

Need Help?

Contact one of our dedicated Customer Service
Representatives at:

Publications

Email: prodserv@naic.org
Phone: 816.783.8300

Financial Statement Data

Email: idp@naic.org
Phone: 816.783.8300

Automated Valuation Service (AVS)

Email: securitiessupport@naic.org
Phone: 816.783.8707

 

CSR Hours: Monday — Friday
8:30 a.m. to 5 p.m. Central Time

FINANCIAL DATA

Reference Materials

FAQ

2017 Annual Record Layouts

2018 Quarterly Record Layouts

not yet available

 

Comparison of 2016 Annual File Names to 2017 Annual File Names

Comparison of 2017 Quarterly File Names to 2018 Quarterly File Names not yet available

Spreadsheet showing Column/Row changes from 2016 Annual to 2017 Annual

There are two worksheets to review for the annual tables—one to identify changes in columns, and one to identify changes in the rows.

Using the auto filter capabilities in Excel, scroll to the last column of each worksheet, which is labeled "Difference"—in order to highlight the differences—and click on the down arrow in order to change the options to display only non-blank rows. This filter will only include results where changes have occurred between the two years. You might find it useful to also filter by the blank type you are working on.

These worksheet are sorted by blank type and then base table name. However you have the option to sort all data to your liking.

As you go through report specifications, you might find it helpful to click the down arrow on the base table name and then start typing the name of table that concerns you in the search box.  If you get no results, then there were no changes to the table you are concerned with if you set the filter in the difference columns as described above.

Note, the search feature is not case sensitive.

If you find a row in the worksheet where data is present for 2016 but not 2017, or visa-versa, this might indicate the information was deleted (or added) in 2017.

Spreadsheet showing Column/Row changes from 2017 Quarterly to 2018 Quarterly not yet available