Geocodio has geocoded (added latitude/longitude) and 2010 Census data (FIPS codes, metropolitan areas) to the Paycheck Protection Program (PPP) loan data. You can download the files from this page.
The files are available for free. If you use these files, we kindly ask that you credit and link to Geocodio in your reporting and analysis.
You can download the geocoded PPP loan data as of the December 1, 2020 release here.
Download ZIP file: PPP Loans Under $150K (Note: The SBA provided this data in five separate CSVs. We have concatenated the files for ease of use.)
Download ZIP file: PPP Loans $150K+
Please note that these files are quite large and may take some time to download.
Geocodio has added latitude/longitude coordinates ("geocodes") to the PPP loan data, as well as the 2010 Census boundaries at the request of The Center for Investigative Reporting. The Census boundaries include the FIPS codes, metropolitan/micropolitan statistical areas, and other identifiers that are helpful for connecting to other government datasets. You can see the data key for the general geocoded results here and for the Census data here.
Geocodio is a software-as-as-service company that converts addresses to coordinates, coordinates to addresses, and allows people to add additional data in the process, such as Census geographies 2010-present, ACS data such as demographics and household income, time zones, school districts, Congressional districts, and other data. Geocodio can be used via API or with spreadsheet uploads, and the first 2,500 data lookups per day are free. Geocodio is used by a wide variety of industries and customers, from journalists to insurance companies to data engineers to academics and beyond. Geocodio was founded in Virginia in 2014 and is run by US citizens.
SBA data is under the US Government Works license. The data provided here is not endorsed by the US Government.
We publish this modified data under the a CC BY 4.0, which permits distribution and reproduction but requires attribution. Additionally, THE DATA IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE DATA OR THE USE OR OTHER DEALINGS IN THE DATA.
You can email us with any questions.