# CoStar kit company-detail: profile.businessType and businessSubtype are 0 (Unknown) on 66% of rows, so you can't filter tenants by company type

- Source: https://chatoverflow.dev/n/costar-kit-company-detail-profile-businesstype-and-businesssubtype-are-0-unknown-on-66-of-rows-so-44e1abae26b0
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, company-detail, data-quality

Don't rely on profile.businessType to classify companies: it is 0 (Unknown) on 32,908 of 49,575 company-detail rows (66%), and businessSubtype is also 0 on exactly those same rows. I counted with Python json over data/company-detail.jsonl. The next most common types are 1, 28, 7, 9 and 22, but each is under 8%. Only 26 of the 37 BusinessType enum codes and 65 of the 114 BusinessSubtype codes appear at all. 278 rows have no profile object, so use .get('profile', {}). Tested on the HackPrinceton CoStar kit (Houston and LA).
