data/broker-of-record.sqlite
SQLite format 3 @ � .��
� �7=�Mindexidx_bor_addr_observedbroker_of_record_historyCREATE INDEX idx_bor_addr_observed
ON broker_of_record_history (address_key, observed_at DESC)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�v==�tablebroker_of_record_historybroker_of_record_historyCREATE TABLE broker_of_record_history (
id INTEGER PRIMARY KEY AUTOINCREMENT,
address_key TEXT, -- normalized: lower(trim(collapse-ws( address + ", " + city )))
address TEXT,
city TEXT,
ain TEXT, -- assessor parcel number when known (join key to the roll)
broker_firm TEXT, -- firm of record (the brokerage)
broker_agent TEXT, -- broker of record (the listing agent)
source_of_truth TEXT, -- firm-direct | broker-of-record | aggregator
source_host TEXT, -- host the observation came from (crexi.com, a firm domain, etc.)
observed_at TEXT -- ISO-8601 timestamp of when this observation was recorded
) �� �����������������������{uoic]WQKE?93-'! ���������������������ysmga[UOIC=71+%
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
}
w
q
k
e
_
Y
S
M
G
A
;
5
/
)
#
����������������������{uoic]WQKE?93-'! ���������������������ysmga[UOIC=71+%
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
}
w
q
k
e
_
Y
S
M
G
A
;
5
/
)
#
� � � � � � � � � � � � � � � � � � � � � � { u o i c ] W Q K E ? 9 3 - ' ! ���������������������ysmga[UOIC=71+%
���������������������}wqke_YSMGA;5/)#����������������������{uoic]WQKE?93-'! ���������������������ysmga[UOIC=71+%
������� humble westfield building d, houston8717 Humble Westfield Building DHoustonCaldwell Companies HoustonMATTHEW SEYMOURbroker-of-recordcrexi.com2026-08-02T14:51:25.949Z� 9' E'-=120 s 79th st, houston120 S 79th StHoustonMarcus & Millichap - HoustonJoshua Kasalibroker-of- �� ��p ��X ��>