New York City Pension System Equity and Fixed Income Holdings

New York City's Board of Education Retirement System holdings data details equity and fixed income investments as of each fiscal year's end. The dataset is published by the NYC Office of the Comptroller via the city's open data portal. It includes holdings information for the fiscal year ending on dates such as June 30, 2018.

Use Cases

• Analyze asset allocation trends using the Asset Class and Investment Type Name columns over different Period End Dates.
• Assess credit risk by correlating Moody's Quality Rating and S and P Quality Rating with Interest Rate and Maturity Date for fixed income holdings.
• Calculate unrealized gains/losses for portfolio segments by aggregating Local Unrealized Gain/Loss values filtered by Major Industry Name.
• Expose geographic investment concentration by grouping Base Market Value by Trade Country Name.
• Identify holding types and sizes by filtering Security Description and Shares/Par Value for specific Direct/Group Trust Holding categories.

Strengths

• Contains 25 detailed columns covering security ratings, valuations, and descriptive metadata.
• Provides both local (Local Market Value) and base currency (Base Market Value) valuations for cross-border analysis.

Limitations

• The dataset's total size and row count are unknown, limiting assessment of statistical power.
• Data is a point-in-time snapshot per fiscal year, requiring manual joins for time-series analysis.
• Potential geographic bias as holdings are for a single U.S. city pension fund.

Provenance

Source

NYC Office of the Comptroller, published on data.cityofnewyork.us.

Collection Method

Official reporting of pension system holdings as of the fiscal year end.

Time Range

Covers specific fiscal year-end dates, e.g., June 30,  2018.

Freshness

Last updated on the platform in March 2026, but the underlying data covers specific fiscal year-end dates.

Geography

Holdings of the New York City Board of Education Retirement System (BERS).