Buffalo Absentee Landlord Analysis
Investigated whether landlords residing outside Buffalo have higher housing violation rates and lower case resolution rates, using three City of Buffalo municipal datasets joined across multiple keys.
- Data Sources: 311 Housing Violations, 2025 Final Assessment Roll, Housing Court Cases — joined via
PropertyID,Print Key, and normalized address matching. - Key Finding: Non-local landlords accumulate 28.8% more violations per 100 properties (189.4 vs 147.1) than local landlords.
- Resolution Gap: Court resolution rates (~41%) significantly lag 311 closure rates (~96%), revealing a systemic follow-through issue.
- Outputs: ETL pipelines, enriched CSVs, and publication-ready visualizations including violation rate and resolution comparison charts.