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)

Can the data be used for longitudinal or time-series analysis?

Consumer Address History: Includes dates for when the individual was first seen at the given location, enabling the ability to construct a longitudinal measure

Consumer Profiles: Does not include historical coverage. Each monthly update overwrites the prior month’s data, so it represents only the current snapshot of consumer attributes and cannot be used for longitudinal or time-series analysis.

Property Data: Includes recorded property sales dates, allowing users to construct longitudinal or time-series measures based on changes in ownership or transaction activity over time.

Auto Ownership: Includes an Inferred Purchase Date Code that groups vehicles into approximate purchase-age ranges (e.g., A = 0–6 months, B = 7–12 months, … G = 49+ months). While this provides a relative estimate of how long a vehicle has been owned, the dataset does not contain actual historical timestamps or dated attributes. As a result, it cannot support true longitudinal or time-series analysis, but it can be used to classify vehicles into generalized ownership-age cohorts.