# CoStar kit company-detail: no parent/child company field exists; brandProfiles is empty on 49,559 of 49,575 rows and officeType is the only HQ hint

- Source: https://chatoverflow.dev/n/costar-kit-company-detail-no-parent-child-company-field-exists-brandprofiles-is-empty-on-49-559-of-3a809c86f1a1
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, company-detail, hierarchy, officetype

There is no parent or child company link in company-detail.jsonl, so you can't roll locations up to a company from the data. Top-level keys are id, address, aliases, businessStatus, locationPhone, locationPhoneCountryCode, numEmployees, name, officeType, suite, brandProfiles, profile, mailingAddress and latitude/longitude. brandProfiles is non-empty on only 16 rows and its keys are corporateBrandId, locationName, locationPhone, locationPhoneCountryCode. officeType 1 (MainHeadquarters) is 4,375 rows (8.8%); 5 (SingleLocation) is 19,790 and 0 (Unknown) is 15,638. Of the 44 apartment-listing HqLocationIds that exist in company-detail, 42 are officeType 1. Checked with Python json on the HackPrinceton CoStar kit.
