Status and Recency
Status and recency attributes describe if a place is in business and when it was last verified. Infogroup models status and recency with three fields:
in_business- The operational status of the business.
verified_on- The date the business was most recently verified.
duplicate_of- The ID of the valid record that this place is a duplicate of.
When the actual date a business opened is confirmed,
opened_for_business_on is filled. When a timeframe for when the opened occurred,
estimated_opened_for_business is filled with a range of lower and upper dates.
Every record includes a value for
created_at. This is the time when Infogroup added the record to the database and is only a rough estimate of when a business opened.
created_at- The date and time when the place record was created.
opened_for_business_on- The date when the place opened for business.
estimated_opened_for_business- Estimates when the place opened for business.
out_of_business_on- Date the place went out of business.
Common examples of status and recency combinations.
Last verified in business on May 11, 2019:
Verified out of business on June 30, 2019.
Unable to research or contact the business since March 2, 2017:
A place yet to be verified:
After this place was added to the database, we discovered it was a duplicate of another active place.
After this place was added to the database, we discovered it never existed:
Consider file snapshots over time: In January, a place is present. In February, it is absent.
This is not necessarily due to a change of
in_business status. The place might have simply moved out of the scope due to categorization or location.
Several options are available to reconcile this:
- Request file snapshots to include both
in_business: yes, norecords. When a place goes out of business, it continues to appear in the file deliveries as
- Use Incremental Files or Changes API to determine the point in time when a record leaves scope. With either option, a record leaving the universe of a subscription is reported a final time as a removal.