Green Jobs - Green New York (GJGNY) Residential Loan Portfolio: Beginning November 2010

The dataset represents information on the performance of the portfolio of loans issued through the GJGNY Residential Loan Fund. The loan performance results of the GJGNY portfolio have shown strong performance to date, with lower levels of delinquencies and defaults/losses than other consumer loan asset classes. This performance data is useful to lender/capital providers, rating agencies, researchers, and interested stakeholders to assist in anticipating performance results for their-party financing products aimed at consumer clean energy financing. Users can access an Interactive Dashboard with charts, graphs, and tables at https://nyserda.ny.gov/Researchers-and-Policymakers/Green-Jobs-Green-New-York/Data-and-Trends

How does your organization use this dataset? What other NYSERDA or energy-related datasets would you like to see on Open NY? Let us know by emailing OpenNY@nyserda.ny.gov.

The New York State Energy Research and Development Authority (NYSERDA) offers objective information and analysis, innovative programs, technical expertise, and support to help New Yorkers increase energy efficiency, save money, use renewable energy, and reduce reliance on fossil fuels. To learn more about NYSERDA’s programs, visit https://nyserda.ny.gov or follow us on Twitter, Facebook, YouTube, or Instagram.

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 \"ny-gov/green-jobs-green-new-york-gjgny-residential-loan-9evn-drxk\".\"green_jobs_green_new_york_gjgny_residential_loan\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.