2 ms·
I have a Datasette running of this here: https://sba-loans-covid-19.datasettes.com/loans_150k_plus/foia_150k_plus https://sba-loans-covid-19.datasettes.com/loan
by simonw 6y ago
I have a Datasette running of this here: https://sba-loans-covid-19.datasettes.com/loans_150k_plus/foia_150k_plus 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?sql=with+counts+as+%28select+NAICSCode%2C+count%28*%29+as+num_loan_recipients+from+foia_150k_plus+group+by+NAICSCode+order+by+num_loan_recipients+desc%29%0D%0Aselect+counts.NAICSCode%2C+counts.num_loan_recipients%2C+naics_2017.name%2C+%27https%3A%2F%2Fsba-loans-covid-19.datasettes.com%2Floans_150k_plus%2Ffoia_150k_plus%3F_facet%3DCity%26_facet%3DState%26_facet%3DRaceEthnicity%26_facet%3DBusinessType%26_facet%3DGender%26_facet%3DVeteran%26NAICSCode%3D%27+%7C%7C+NAICSCode+as+view_them+from+counts+join+naics_2017+on+counts.NAICSCode+%3D+naics_2017.id 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/foia_150k_plus?_facet=City&_facet=State&_facet=RaceEthnicity&_facet=BusinessType&_facet=Gender&_facet=Veteran&NAICSCode=621210 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 https://github.com/simonw/sba-loans-covid-19-datasette