Credit Rating Agency Ratings History Data

---

Under SEC Regulation 17g-7, Nationally Recognized Statistical Rating Organizations (NRSRSOs) are required to report their historical rating assignments, upgrades, downgrades and withdrawals since 2010. The files must be updated monthly, formatted in XBRL and posted to each rating agency's website. Rating data are generally reported on a one year delay.

Because most researchers are unfamiliar with XBRL and cannot easily locate the history files, this valuable resource has seen limited use. On this web page, we provide histories from multiple agencies converted to CSV format - which may be directly loaded into Microsoft Excel or Access.

The files linked below are named to denote the date provided, rating agency name and asset category.

---

• 20171215 Moody's Investors Service ABCP.csv (387 rows)
• 20171215 Moody's Investors Service CDO.csv (6450 rows)
• 20171215 Moody's Investors Service CLO.csv (168 rows)
• 20171215 Moody's Investors Service CMBS.csv (24727 rows)
• 20171215 Moody's Investors Service Corporate.csv (66412 rows)
• 20171215 Moody's Investors Service Financial.csv (68840 rows)
• 20171215 Moody's Investors Service INT Public.csv (29954 rows)
• 20171215 Moody's Investors Service Other ABS.csv (24689 rows)
• 20171215 Moody's Investors Service Other SFP.csv (145824 rows)
• 20171215 Moody's Investors Service RMBS.csv (66371 rows)
• 20171215 Moody's Investors Service US Public.csv (3139836 rows)
• 20180101 Standard & Poor's Ratings Services ABCP.csv (309 rows)
• 20180101 Standard & Poor's Ratings Services CDO.csv (1655 rows)
• 20180101 Standard & Poor's Ratings Services CLO.csv (14213 rows)
• 20180101 Standard & Poor's Ratings Services CMBS.csv (9457 rows)
• 20180101 Standard & Poor's Ratings Services Corporate.csv (192491 rows)
• 20180101 Standard & Poor's Ratings Services Financial.csv (137628 rows)
• 20180101 Standard & Poor's Ratings Services INT Public.csv (28709 rows)
• 20180101 Standard & Poor's Ratings Services Insurance.csv (47807 rows)
• 20180101 Standard & Poor's Ratings Services Other ABS.csv (18178 rows)
• 20180101 Standard & Poor's Ratings Services Other SFP.csv (4087 rows)
• 20180101 Standard & Poor's Ratings Services RMBS.csv (102282 rows)
• 20180101 Standard & Poor's Ratings Services Sovereign.csv (32263 rows)
• 20180101 Standard & Poor's Ratings Services US Public.csv (3306310 rows)
• 20171101 Fitch Ratings ABCP.csv (58 rows)
• 20171101 Fitch Ratings CDO.csv (6298 rows)
• 20171101 Fitch Ratings CLO.csv (609 rows)
• 20171101 Fitch Ratings CMBS.csv (15662 rows)
• 20171101 Fitch Ratings Corporate.csv (25122 rows)
• 20171101 Fitch Ratings Financial.csv (124275 rows)
• 20171101 Fitch Ratings INT Public.csv (7583 rows)
• 20171101 Fitch Ratings Insurance.csv (4227 rows)
• 20171101 Fitch Ratings Other ABS.csv (7313 rows)
• 20171101 Fitch Ratings RMBS.csv (52584 rows)
• 20171101 Fitch Ratings Sovereign.csv (27394 rows)
• 20171101 Fitch Ratings US Public.csv (336721 rows)
• 20161208 A.M.BEST COMPANY CDO.csv (32 rows)
• 20161208 A.M.BEST COMPANY Corporate.csv (1735 rows)
• 20161208 A.M.BEST COMPANY Insurance.csv (20108 rows)
• 20161208 A.M.BEST COMPANY Other SFP.csv (10 rows)
• 20161209 A.M.BEST COMPANY CDO.csv (3 rows)
• 20161209 A.M.BEST COMPANY Corporate.csv (594 rows)
• 20161209 A.M.BEST COMPANY Insurance.csv (8843 rows)
• 20161209 A.M.BEST COMPANY Other SFP.csv (4 rows)
• 20171111 DBRS ABCP.csv (172 rows)
• 20171111 DBRS CDO.csv (395 rows)
• 20171111 DBRS CLO.csv (1231 rows)
• 20171111 DBRS CMBS.csv (6192 rows)
• 20171111 DBRS Corporate.csv (1760 rows)
• 20171111 DBRS Financial.csv (4509 rows)
• 20171111 DBRS INT Public.csv (302 rows)
• 20171111 DBRS Insurance.csv (113 rows)
• 20171111 DBRS Other ABS.csv (5029 rows)
• 20171111 DBRS Other SFP.csv (3069 rows)
• 20171111 DBRS RMBS.csv (40318 rows)
• 20171111 DBRS Sovereign.csv (169 rows)
• 20171130 Japan Credit Rating Agency,Ltd. Corporate.csv (11704 rows)
• 20171130 Japan Credit Rating Agency,Ltd. Financial.csv (4442 rows)
• 20171130 Japan Credit Rating Agency,Ltd. INT Public.csv (1840 rows)
• 20171130 Japan Credit Rating Agency,Ltd. Insurance.csv (302 rows)
• 20171130 Japan Credit Rating Agency,Ltd. Sovereign.csv (432 rows)
• 20171231 Japan Credit Rating Agency,Ltd. Corporate.csv (11888 rows)
• 20171231 Japan Credit Rating Agency,Ltd. Financial.csv (4473 rows)
• 20171231 Japan Credit Rating Agency,Ltd. INT Public.csv (1974 rows)
• 20171231 Japan Credit Rating Agency,Ltd. Insurance.csv (304 rows)
• 20171231 Japan Credit Rating Agency,Ltd. Sovereign.csv (435 rows)
• 20180108 Kroll Bond Rating Agency, Inc. CMBS.csv (7362 rows)
• 20180108 Kroll Bond Rating Agency, Inc. Corporate.csv (25 rows)
• 20180108 Kroll Bond Rating Agency, Inc. Financial.csv (3752 rows)
• 20180108 Kroll Bond Rating Agency, Inc. Insurance.csv (25 rows)
• 20180108 Kroll Bond Rating Agency, Inc. Other ABS.csv (1815 rows)
• 20180108 Kroll Bond Rating Agency, Inc. RMBS.csv (5316 rows)
• 20180108 Kroll Bond Rating Agency, Inc. US Public.csv (80731 rows)
• 20180111 Egan-Jones Ratings Company Corporate.csv (66340 rows)
• 20180111 Egan-Jones Ratings Company Financial.csv (89634 rows)
• 20180111 Egan-Jones Ratings Company Insurance.csv (4144 rows)
• 20180111 Egan-Jones Ratings Company NA.csv (5 rows)
• 20180111 Egan-Jones Ratings Company Real Estate.csv (3 rows)
• 20180111 Egan-Jones Ratings Company Sovereign.csv (10428 rows)
• 20180111 HR Ratings de Mexico S.A. de C.V. Corporate.csv (967 rows)
• 20180111 HR Ratings de Mexico S.A. de C.V. Financial.csv (3337 rows)
• 20180111 HR Ratings de Mexico S.A. de C.V. INT Public.csv (1896 rows)
• 20180111 HR Ratings de Mexico S.A. de C.V. Insurance.csv (46 rows)
• 20180111 HR Ratings de Mexico S.A. de C.V. Other ABS.csv (313 rows)
• 20180111 HR Ratings de Mexico S.A. de C.V. Sovereign.csv (24 rows)
• 20180111 HR Ratings de Mexico S.A. de C.V. US Public.csv (34 rows)
• 20180111 Morningstar Credit Ratings, LLC. CMBS.csv (14122 rows)
• 20180111 Morningstar Credit Ratings, LLC. Corporate.csv (2033 rows)
• 20180111 Morningstar Credit Ratings, LLC. Other ABS.csv (19 rows)
• 20180111 Morningstar Credit Ratings, LLC. RMBS.csv (429 rows)

---

Abbreviations in these files are explained in Section 2.4 of the SEC's Rating History Publication Guide.

Download and parsing script available on Github.

---

This resource was created by the Center for Municipal Finance with the generous support from the Center for Corporate and Securities Law at the University of San Diego School of Law.

---