NYC Office of The Comptroller: Board of Education Retirement System (BERS) Holdings Data

This dataset sets forth the Board of Education Retirement System (BERS) holdings (both equity and fixed income) of the identified pension/retirement system as of the close of the fiscal year.</p>

<b>Notice: To accurately use this data, please first sort this report to the latest fiscal year date using the "Period End" column. (e.g 'Period End' is 6/30/2018)

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 \"cityofnewyork-us/nyc-office-of-the-comptroller-board-of-education-fypi-ruxh\".\"nyc_office_of_the_comptroller_board_of_education\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.