Searchable PPP Loan Data
pppreport.org
Searchable PPP Loan Data
1–10 of 354 posts
Re: Searchable PPP Loan Data
#2Where is this data sourced from?
Edit: I tried accessing some common endpoints like /about to see if there are any unlinked pages, but could not find any. Hence why I asked the question.
Re: Searchable PPP Loan Data
#3Where is this data sourced from? Edit: I tried accessing some common endpoints like /about to see if there are any unlinked pages, but could not find any. Hence why I asked the question.
About page is a work-in-progress.
Data source is: https://home.treasury.gov/policy-issues/cares-act/assistance...
Re: Searchable PPP Loan Data
#4Where is this data sourced from? Edit: I tried accessing some common endpoints like /about to see if there are any unlinked pages, but could not find any. Hence why I asked the question.
About page is a work-in-progress. Data source is: https://home.treasury.gov/policy-issues/cares-act/assistance...
Looks like I edited my comment at the same time that you posted yours. Thanks for the link and confirmation!
Re: Searchable PPP Loan Data
#5Where is this data sourced from? Edit: I tried accessing some common endpoints like /about to see if there are any unlinked pages, but could not find any. Hence why I asked the question.
About page is a work-in-progress. Data source is: https://home.treasury.gov/policy-issues/cares-act/assistance...
As long as you have Excel, Sheets, Numbers etc, it's a lot more pleasant to navigate the original csv, with filters, sort, etc.
Re: Searchable PPP Loan Data
#6OP, could you add to the About page the total amount of loans issued where the loan amount was $150k+? It would provide a lot of context for this data.
Re: Searchable PPP Loan Data
#7There are several scenarios that frustrate me.
Examples like law firms or physicians' offices. These are relatively small firms with very wealthy principals. They are asking for taxpayer money to maintain their wealthy lifestyles, so they don't have to sacrifice their Bentleys to pay staffers. Examples: Thomas J Henry in San Antonio.
LLCs and franchisees that probably have millions of dollars in holdings and cash, but act under the guise of "small business" because they operate fast food or something.
Religious organizations. It's one thing if something like a local YMCA gets funds, but a church outright getting funds without proving it is going to public services (why don't we just have better public services?) is not proper. Churches already don't pay taxes.
Re: Searchable PPP Loan Data
#8I'm working on a dashboard to map each of these loans geographically: https://www.quiverquant.com/sources/sbaloans
It's a slow process (as I've been respectful of the rate-limit on the reverse geocoding API I'm using), but I finished mapping four states and hope to complete the other 46 by the end of this week.
Re: Searchable PPP Loan Data
#9Where is this data sourced from? Edit: I tried accessing some common endpoints like /about to see if there are any unlinked pages, but could not find any. Hence why I asked the question.
The SBA uploaded a database of all recipients to Box yesterday.
Direct link: https://sba.app.box.com/s/tvb0v5i57oa8gc6b5dcm9cyw7y2ms6pp
CNBC article: https://www.cnbc.com/2020/07/06/coronavirus-stimulus-list-of...
It appears the database may include applicants who submitted partial applications but may not have actually received funds. For example, Index Ventures is in the database but claims they didn't take any loans. From the cnbc article:
> The venture capital firms Index Ventures and Foundation Capital, along with the scooter company Bird, said that they did not apply for the Payroll Protection Program, despite being listed in the database as having been approved for millions of dollars of funds from banks under that federally run program.
Re: Searchable PPP Loan Data
#10This is great! I wish it was searchable by bank though. I heard that a local bank was making some interesting choices about who they helped through the PPP program and I'd love to pull up all the results by Lender.