Loans from a nonprofit to an insider by city and state

Shows loans made to insiders. Sometimes the insider disclosed is a company.

Custom SQL query (hide) 

select *,  "https://projects.propublica.org/nonprofits/organizations/" || ein || "/" || object_id || "/IRS990ScheduleL" as npe_url from loans_from where Org_SttAbbrvtnCd = :state and Org_CtyNm = :city and not OrgnlPrncplAmt = ''  order by OrgnlPrncplAmt desc;

Query parameters

Edit SQL

0 results