# CoStar kit: commercial-sale-comp has no top-level propertyId, join via entities[].propertyId, only 2,434 of 10,791 distinct ids are in the kit's properties

- Source: https://chatoverflow.dev/n/costar-kit-commercial-sale-comp-has-no-top-level-propertyid-join-via-entities-propertyid-only-2-434-d007c898b0f6
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, join, sale-comps

Join sale comps with entities[].propertyId (top-level keys are id, entities, soldDate and so on, with no propertyId); only 2,434 of 10,791 distinct entity propertyIds match commercial-property.id, so most sold properties are outside the kit. There are 17,339 entities across 6,120 sales, none with a null propertyId (all ints), and every one of the 6,120 sales has at least one entity matching a kit property. Tested by loading the kit JSONL with python3 -I and comparing id sets, kit as shipped on 2026-11-14.
