Live data from Hacker News

Searchable PPP Loan Data

pppreport.org

241–250 of 354 posts

Re: Searchable PPP Loan Data

#241

Earlier quoted context omitted.

No business can survive under those conditions and that is not a valid critique of their viability under a range of ordinary conditions. Tax payer do own businesses due process under law and a respect for private property rights. In America, the government can’t seize a business without compensation. Mandatory shut downs, in the absence of financial assistance, is arguably a “taking” under the constitution and a viol…

> Mandatory shut downs, in the absence of financial assistance, is arguably a “taking” under the constitution False, government does this to businesses all the time and compensation isn’t due. Take hurricanes in Florida and mandatory shutdown/evacuation orders, there is no promised compensation. Besides under imminent domain cases, I’d like to see some case law to support taxpayers bailing out businesses.

Actually there is promised compensation in hurricane emergencies in the form of SBA EIDL (economic injury disaster loans).

The existence of imminent domain proves my point, there are circumstances where tax payers owe An obligation to property owners and their actions are restricted by that obligation. Now we can argue about whether this specific act is a taking but I destroyed your blanket argument that tax payers don’t own business anything.

Own a business with a plot of land, tax payers want to expand a road and tear down your office and take the land? Can’t do it without paying.

Re: Searchable PPP Loan Data

#242

Earlier quoted context omitted.

Why should taxpayers have bailed out businesses that couldn’t keep employees on payroll though? There is no end in sight to either corona virus or the economic downturn, so it’s just throwing 8 weeks worth of taxpayer money into bad investments. What’s going to happen within 8 weeks to ensure these employees won’t just be let go again?

>There is no end in sight to either corona virus or the economic downturn Most states are re-opening, ill-advised or not, and businesses are being allowed to operate again.

I didn’t say shutdown I said economic downturn. Whether the open or not has no bearing if they will remain in business.

Re: Searchable PPP Loan Data

#243

Peripherally related, but this tweet by @dataeditor at the Washington Post was amusing ( https://twitter.com/dataeditor/status/1280278987797942272 ): >Philadelphia, to its own credit, is spelled at least 57 different ways in the PPP loan data (an image is included, with various items, such as "PHIADELPHIA", "PHILADELPHIA,", and "PHILLY") Pretty well sums up data science. He also notes that Chicago is spelled 31 ways…

Data's all sorts of messed up in this. My friend's company is in this and 3 columns are flat out wrong and different from what he submitted. There's only 7 applicant submitted columns!

But remember where it came from: thousands of lenders hand keying this stuff in with minimal guidance.

Re: Searchable PPP Loan Data

#244

Earlier quoted context omitted.

So will your employer be paying the "loan" back?

Most of the loan isn't designed to be paid back. So what are you getting at?

If it's not designed to be paid back, is it a loan?

noun: loan; plural noun: loans

    a thing that is borrowed, especially a sum of money that is expected to be paid back with interest.

Is it just called a loan because that sounds better than just calling it a subsidy?

Re: Searchable PPP Loan Data

#246
I have a Datasette running of this here: https://sba-loans-covid-19.datasettes.com/loans_150k_plus/fo...

You can run your own SQL queries against it. Here's a query I wrote that shows the most common NAICS codes (industry categorization from the census):

https://sba-loans-covid-19.datasettes.com/loans_150k_plus?sq...

You can click through from there to get faceted search of e.g. every loan made to a dentist:

https://sba-loans-covid-19.datasettes.com/loans_150k_plus/fo...

I have full notes about how I built this here: https://github.com/simonw/sba-loans-covid-19-datasette

Re: Searchable PPP Loan Data

#247

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.

One thing I noticed is that my local Domino's got $150-300k, but that it was behind a different LLC name.

Is it possible to add a ggogle maps business name listing based on address next to the reported company name?

Re: Searchable PPP Loan Data

#248
post #220

Earlier quoted context omitted.

>"what about the nail salon who has 14 employees and took 5-10M?!?!". If true that is an obvious case of fraud and you are making my point, the only time a loan will be repaid is if the money was spent on things other than payroll...which amounts to fraud. Who cares if its a nail salon? Math is math, if you have 14 employees the maximum eligibility would be 8 weeks of payroll with a cap at $100k salary + up to an add…

I know lots of folks who got PPP loans. I don't know anyone who's getting 100% of their loan forgiven. Mainly because they took 2.5x monthly payroll as a loan - but then did an 8 week covered period (2x monthly payroll). Most of them will owe ~20% of the loan back to their lender since they had minimal other expenses.

> I don't know anyone who's getting 100% of their loan forgiven.

I don't think you know that many people then. I don't know a ton, but everyone I know is expecting to get 100% of the loan forgiven. Main reason being you just need to show that money is spent on payroll, mortgage interest and utilities. For a lot of businesses it isn't that hard to shift accounts around to show those costs are higher than their PPP amounts.

Re: Searchable PPP Loan Data

#249

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.

Make sure to prioritize Delaware ;)

Re: Searchable PPP Loan Data

#250

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

My version of this here lets you search by bank: https://sba-loans-covid-19.datasettes.com/loans_150k_plus/Le...

You'll need to click on the ID link and then click to see the loans from that institution - e.g. from https://sba-loans-covid-19.datasettes.com/loans_150k_plus/Le...

Post reply on HN