FAQs - Versik

Can the Verisk datasets be joined?

Yes. The ADDRID is usable for linking addresses between TCI Property, TCI Consumer, and Consumer Address History. For matching to the current address, Consumer History listings are not always populated in chronological order. It’d be best to first sort by EFFDATE and use that to identify current address.

The PID can be used to join the TCI Auto and TCI Consumer data.

Can the PID be used to join the Address History and the Total Consumer Insights datasets?

These two identifiers cannot be joined. You'll notice that the strings have different lengths.

You can use the ADDRID as a usable link for addresses in the TCI Property and Address History datasets.

Is the data always in sequential order?

Not necessarily. Consumer Address History listings are not always populated in chronological order. It’d be best to first sort by EFFDATE and use that to identify current address.

How is the data sourced?

VMS data is sourced from wide-ranging authoritative sources, which include:

• Publicly available records (Census, USPS, publications, county assessors, etc.)
• Transactions/purchase data (retail channels, direct marketing, sales/service information, etc.)
• Self-reported information (survey respondents, warranty responders, event sign-ups, etc.)
• Proprietary sources

Does the absence of 'Y' in the PROP_OWNEROCC imply that the property is not owner-occupied — i.e., potentially a rental property?

Not necessarily. This field indicates if the property owner resides on the property. Values of M, O, and S indicate owner occupied (A and T reflect absentee owners). Absentee Owner Indicator Code Descriptions:

• A - ABSENTEE (Mail And Situs Not Equal)
• M - SITUS ADDRESS TAKEN FROM MAIL
• O - OWNER OCCUPIED
• S - SITUS FROM SALE (Occupied)
• T - Situs From Sale (Absentee)