whoownsphilly / wop-web

https://wop-web.vercel.app
2 stars 1 forks source link

Look into deeds that have no parcel numbers #152

Open ssuffian opened 2 years ago

ssuffian commented 2 years ago

Example:

SELECT * FROM 
rtt_summary where recording_date = '2020-03-06T00:00:00Z'
AND grantees = 'PHILADELPHIA LOTUS 09 LLC'
AND document_type like '%DEED%' AND opa_account_num is null

Returns an entry for 425 E COURTLAND ST that has no account number. But it was a $2 million dollar transaction.