PPP Cares Act Loan Totals to New Jersey Businesses

The Paycheck Protection Program (PPP) loans provide small businesses with the resources they need to maintain their payroll, hire back employees who may have been laid off, and cover applicable overhead. This data set includes businesses in New Jersey who received PPP funding, how much funding the employer received & how many jobs the employer claims they saved. The NAICS (National Industry Classification) was provided by the loan recipient.

Note: As per SBA, The Paycheck Protection Program (PPP) ended on May 31, 2021 so no updates has been made on this dataset.

Please see attached document on landing page for more details.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"nj-gov/ppp-cares-act-loan-totals-to-new-jersey-businesses-riep-z5cp\".\"ppp_cares_act_loan_totals_to_new_jersey_businesses\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.