Forrest Hangen
1966
"Defining the ownership of slum tenements is a far from easy task"
566 Parcels
"Defining the ownership of slum tenements is a far from easy task"
566 Parcels
Computing Power
Text-matching algorithms
Digitized Open(ish) Data
Computing Power
Text-matching algorithms
Digitized Open(ish) Data
"Defining the ownership of rental housing is still no easy task!"
-Forrest after reading Sternlieb
Computing Power
Text-matching algorithms
Digitized Open(ish) Data
Rise of the LLC
Accurately link landlords to their properties to Uncover and Quantify the effects of Ownership Obscurity
Property Tax Assessment Records
Boston, MA
2004-2019
Corporation Filing Records
Elmer G Gill
Elmr G Gill
Greystone LLC
Eagle LLC
2 Different Solutions
Deliberate Strategy
Limiting Liability
L.L.C., Lmtd liability co,llc LLC
Fifty-eight Green Street L.L.C.
58 Green st llc
Fifty-eight Green Street L.L.C.
58 Green st llc
L.L.C., Lmtd liability co,llc LLC
Fifty-eight Green Street L.L.C.
58 Green st llc
58 GREEN ST LLC
58 GREEN ST LLC
Elmer G Gill Elmr G Gill
Glynn Realty Assoc IV LLC Glynn Realty Association I LLC
L.L.C., Lmtd liability co,llc LLC
Glynn Realty Assoc IV LLC Glynn Realty Association II LLC
(Probabilistic Matching)
651,612 owners
Elmer G Gill Elmer H Gill
Elmer G Gill Elmer H Gill
Pairs of Names
Glenn Ross 87 Blue Ave
Glenn Ross 4 East St
[' Gl','Gly','lyn','ynn','nn ','n R',' Re','Rea','eal','alt','lty','ty ' ...]
" A" | " Ad" | " Al" | " As" | "El " | "Bar" | "Llc" | . . . | |
---|---|---|---|---|---|---|---|---|
Glynn Realty Assoc IV LLC | 0 | 0 | 0 | .178 | 0 | 0 | .199 | . . . |
. . . | . . . | . . . | . . . | . . . | . . . | . . . | . . . | . . . |
Glynn Realty Assoc IV LLC Glynn Realty Association II LLC
Glynn Realty Assoc IV LLC Glynn Realty Association II LLC
measures similarity between two entities using the cosine of the angle between their two vectors in a multidimensional space
Raw Tax Assessment
Cleaning & Standardization
Fuzzy-Matching
Raw Tax Assessment
Cleaning & Standardization
Fuzzy-Matching
Greystone LLC
Eagle LLC
Not done yet...
Greystone LLC
Eagle LLC
Greystone LLC
Eagle LLC
Corporation Filing Records
Greystone LLC
Eagle LLC
Greystone LLC
Eagle LLC
Corporation Filing Records
Fuzzy Matching
55 GREYSTONE LLC
EAGLE LLC
12 GREEN ST LLC
55 GREYSTONE LLC
EAGLE LLC
12 GREEN ST LLC
55 GREYSTONE LLC
EAGLE LLC
12 GREEN ST LLC
Greystone Realty Corporation
Unique ID
55 GREYSTONE LLC
EAGLE LLC
12 GREEN ST LLC
Unique ID
Landlord Size
Corporate Status
Obscurity
Geographic Scope
Property Types
Property-level Outcomes
Raw Tax Assessment
Raw Tax Assessment
Fuzzy-Matching
Fuzzy-Matching
Corporate Data
Corporate Data
YES!
Herfindahl-Hirschman Index (HHI)
where S = a landlord's share of an outcome
Units
Eviction Filings
Herfindahl-Hirschman Index (HHI)
0-No consolidation to 1-One owner for all properties
Largest Owners of 10% of Units
All other owners
Evictions
Evictions
Takeaways
hangen.f@northeastern.edu
@forresthangen@sciences.social