REFERENCE / 02 / DATA DICTIONARY
Every field.
In plain language.
City facts and computed interpretation are kept distinct. A missing field stays missing; it is not a license to invent a value.
address
normalized street address. (city records)
zip_code
five-digit ZIP. (city records)
year_built
recorded year of construction. (OPA)
square_footage
recorded building area. (OPA)
zoning
recorded zoning classification. (OPA)
violation_type
the city's category for the cited condition. (L&I)
violation_code
official code attached to the violation. (L&I)
issue_date
date the city issued the violation. (L&I)
correction_deadline
the city's stated deadline to correct. (L&I)
days_remaining
days between today and the correction deadline. (computed)
unsafe_designation
whether L&I formally applied unsafe or imminently dangerous status. (L&I)
open_violation_count
currently open violations in the stack. (computed)
signal_stack
every verified signal on the property. (L&I + vacancy indicators)
heat_band
Hot or Standard. Hot = 3+ signals OR any unsafe/imminently dangerous designation.
distress_score
1–100 overall property-distress score. Measures distress only, not lead quality. (computed)
demo_risk_flag
Identifies a likely city-demolition candidate. Excluded from restoration delivery and routed to the demo/investor track. (computed)
score_trend
rising, stable, or cooling.
first_signal_date
earliest verified signal. (computed)
latest_signal_date
most recent verified signal. (computed)
assessed_value
official assessed value. (OPA)
market_value_estimate
market value estimate in the record. (OPA)
value_band
value grouped into a usable range. (computed)
owner_name
owner of record. (OPA)
owner_mailing_address
recorded mailing address. (OPA)
absentee_flag
true when mailing address differs from property address. (computed)
owner_type
individual, LLC, or estate. (computed)
portfolio_size
count of other distressed properties matched to the same owner. (computed)
city_case_number
official identifier for verification. (L&I)
public_record_link
city portal link where the event can be checked. (city portal)
suggested_first_move
The single recommended opening action for the property. (computed)
zip_composite_rank
the ZIP's 1–35 rank. (computed)
zip_tier
Prime, Standard, or Emerging. (computed)