Searchable PPP Loan Data • Hacker News Board

Re: Searchable PPP Loan Data

#21

Post by MattGaiser » Tue, Jul 07, 2020, 5:24 PM UTC

unethical_ban wrote: post #7

There 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, bu…

The law offices and fast food places would just lay people off anyway without this.

One way or another the government is going to pay to keep these people employed.

Re: Searchable PPP Loan Data

#22

Post by bdcravens » Tue, Jul 07, 2020, 5:25 PM UTC

unethical_ban wrote: post #7

There 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, bu…

> 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.

They still have to pay their employees, which is the point of the PPP. Those employees are paid from the funds that come in via donations, which are likely down during the pandemic (especially when many couldn't hold services). Put more simply, their income is down the same way my employer's is, as a result of the pandemic.

> a church outright getting funds without proving it is going to public services

The requirements of the PPP require that at least 60% must go to salaries.

> Churches already don't pay taxes.

Their employees do.

Re: Searchable PPP Loan Data

#23

Post by bjt » Tue, Jul 07, 2020, 5:26 PM UTC

graton wrote: post #15

I was surprised that O'Reilly had a loan for $5-$10 million. https://pppreport.org/company/o+reilly+media+inc They seem like a company where most people can work from home. EDIT: I totally forgot about their conference business. That makes more sense.

Their conferences business took a huge hit.

Re: Searchable PPP Loan Data

#24

Post by rco8786 » Tue, Jul 07, 2020, 5:26 PM UTC

mattbeckman wrote: post #17

You can get a $5-10 Million loan for 14 employees at a nail salon? https://pppreport.org/company/snappy+nails+s+p+a+9+inc Damn.

Worth noting that they will owe this back unless they can show it was used for payroll purposes.

How they got that much money in the first place is a definite mystery though.

Re: Searchable PPP Loan Data

#25

Post by MattGaiser » Tue, Jul 07, 2020, 5:26 PM UTC

graton wrote: post #15

I was surprised that O'Reilly had a loan for $5-$10 million. https://pppreport.org/company/o+reilly+media+inc They seem like a company where most people can work from home. EDIT: I totally forgot about their conference business. That makes more sense.

I think they have live trainers and a fair bit of conference business as well.

Re: Searchable PPP Loan Data

#26

Post by tfandango » Tue, Jul 07, 2020, 5:26 PM UTC

Just looking through my home town for businesses I know about... A fair number of them I know carried on with business as usual and had no financial problems (one I used to work for). Seems wrong when there are lots of people in the same town lining up outside the unemployment office every day...

Re: Searchable PPP Loan Data

#27

Post by fullstop » Tue, Jul 07, 2020, 5:26 PM UTC

mattbeckman wrote: post #17

You can get a $5-10 Million loan for 14 employees at a nail salon? https://pppreport.org/company/snappy+nails+s+p+a+9+inc Damn.

How about this chiropractor?

https://pppreport.org/company/connelly+chiropractic+inc

Re: Searchable PPP Loan Data

#28

Post by bennylope » Tue, Jul 07, 2020, 5:26 PM UTC

simonw published a searchable copy of this via Datasette: https://sba-loans-covid-19.datasettes.com

You can filter by state, city, zipcode, bank, business type, and search by employer name, e.g. https://sba-loans-covid-19.datasettes.com/loans_150k_plus/fo...

Re: Searchable PPP Loan Data

#29

Post by polote » Tue, Jul 07, 2020, 5:27 PM UTC

greatwave1 wrote: post #8

I'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.

Did you try to use the openstreemap database locally ? http://nominatim.org/release-docs/latest/admin/Installation/

Re: Searchable PPP Loan Data

#30

Post by cj » Tue, Jul 07, 2020, 5:27 PM UTC

unethical_ban wrote: post #7

There 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, bu…

> They are asking for taxpayer money to maintain their wealthy lifestyles

The one comforting limitation was that payroll calculations were capped at $100k. So if you had 10 people with a $250k salary, the maximum loan amount is calculated based on having a salary of $100k.

Although you're allowed to add in the cost of healthcare and 401k contributions without limitation.

I think the $100k cap was quite generous and probably too high.