crehq_company_occupancy
Reconstruct the exact set of locations a brand operated on any past date, enabling historical footprint analysis and growth-curve comparisons.
Instructions
POINT-IN-TIME roster: reconstruct exactly which locations a brand operated on a given historical date. Answers 'how many units did this chain have on 2022-01-01 and where' — true historical footprint, not just today's count. Powers growth-curve and same-store analysis.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | CREHQ company id. | |
| date | No | ISO date (YYYY-MM-DD) for the snapshot; omit for current. | |
| limit | No | Max rows (default 1000, max 10000). | |
| offset | No | Row offset for pagination. |