Q7, run 2026-11-06-0041-sonnet-query
Which issuers were downgraded in 2026?
Tests: Action types: outlook changes, Watch placements and withdrawals are not downgrades.
Expected: issuers = ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307']
sql run 1
42 issuers had a real downgrade in 2026 (listed in the JSON). I counted a "DG" action only when the rating actually fell, which excludes E1064, E1051 on 2026-06-01, and E1229 on 2026-06-02. This includes QA-sourced entities, since the data doesn't say to exclude them, and actions up to today (2026-11-06).
JSON: {"issuers": ["E1186", "E1243", "E1255", "E08", "E1151", "E1299", "E1307", "E1213", "E1080", "E1285", "E1112", "E1263", "E1347", "E1348", "E1344", "E1163", "E1053", "E1051", "E1300", "E10", "E1034", "E1229", "E16", "E1144", "E1159", "E1057", "E1340", "E1228", "E1294", "E1058", "E1342", "E1093", "E1161", "E1343", "E1290", "E1170", "E1350", "E1167", "E1345", "E1351", "E1349", "E1346"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E1186', 'E1243', 'E1255', 'E08', 'E1151', 'E1299', 'E1307', 'E1213', 'E1080', 'E1285', 'E1112', 'E1263', 'E1347', 'E1348', 'E1344', 'E1163', 'E1053', 'E1051', 'E1300', 'E10', 'E1034', 'E1229', 'E16', 'E1144', 'E1159', 'E1057', 'E1340', 'E1228', 'E1294', 'E1058', 'E1342', 'E1093', 'E1161', 'E1343', 'E1290', 'E1170', 'E1350', 'E1167', 'E1345', 'E1351', 'E1349', 'E1346']
sql run 2
44 issuers had an LTIDR downgrade in 2026. The IDs are in the JSON and include RESEARCH and QA records.
JSON: {"issuers": ["E1343", "E1344", "E1349", "E08", "E1167", "E1263", "E1347", "E1161", "E1170", "E1342", "E1186", "E1159", "E1093", "E1229", "E1053", "E1112", "E1151", "E10", "E1057", "E1064", "E1299", "E1348", "E1034", "E1213", "E1307", "E1345", "E1144", "E1163", "E1294", "E1341", "E1228", "E1351", "E1080", "E1051", "E1243", "E1285", "E1290", "E1300", "E1340", "E1346", "E16", "E1058", "E1255", "E1350"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E1343', 'E1344', 'E1349', 'E08', 'E1167', 'E1263', 'E1347', 'E1161', 'E1170', 'E1342', 'E1186', 'E1159', 'E1093', 'E1229', 'E1053', 'E1112', 'E1151', 'E10', 'E1057', 'E1064', 'E1299', 'E1348', 'E1034', 'E1213', 'E1307', 'E1345', 'E1144', 'E1163', 'E1294', 'E1341', 'E1228', 'E1351', 'E1080', 'E1051', 'E1243', 'E1285', 'E1290', 'E1300', 'E1340', 'E1346', 'E16', 'E1058', 'E1255', 'E1350']
sql run 3
43 issuers were downgraded in 2026 (IDs in the JSON, including E08, E10 and E16). Each has an LTIDR "DG" action dated 2026-01-01 to 2026-11-06.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1160", "E1163", "E1167", "E1169", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1298", "E1300", "E1307", "E1340", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E16']
sql run 4
43 issuers had a DG action on their issuer rating in 2026 (listed in the JSON). E1341's DG is dated 2026-11-09, after today, so I excluded it.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E1340", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1161', 'E1163', 'E1167', 'E1170', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1299', 'E1300', 'E1307', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E16']
sql run 5
44 issuers have a long-term issuer rating (LTIDR) downgrade dated 2026, after mapping research duplicates to their rated entities. I excluded A1720 (E1341), dated 2026-11-09, which is after today.
JSON: {"issuers": ["E1186", "E1243", "E1255", "E08", "E1151", "E1298", "E1307", "E1213", "E1080", "E1285", "E1112", "E1263", "E1064", "E1347", "E1348", "E1344", "E1163", "E1053", "E1051", "E1300", "E10", "E1034", "E1229", "E16", "E1144", "E1159", "E1057", "E1340", "E1228", "E1294", "E1058", "E1342", "E1093", "E1160", "E1343", "E1290", "E1169", "E1350", "E1167", "E1345", "E1351", "E1349", "E1346"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E1186', 'E1243', 'E1255', 'E08', 'E1151', 'E1298', 'E1307', 'E1213', 'E1080', 'E1285', 'E1112', 'E1263', 'E1064', 'E1347', 'E1348', 'E1344', 'E1163', 'E1053', 'E1051', 'E1300', 'E10', 'E1034', 'E1229', 'E16', 'E1144', 'E1159', 'E1057', 'E1340', 'E1228', 'E1294', 'E1058', 'E1342', 'E1093', 'E1160', 'E1343', 'E1290', 'E1169', 'E1350', 'E1167', 'E1345', 'E1351', 'E1349', 'E1346']
sql+markdown run 1
31 issuers had a DG on an issuer rating in 2026, listed in the JSON. They include E08 (A21, A22) and E10 (A27). After merging same-LEI records and excluding QA records, no other issuer qualifies.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1160", "E1163", "E1167", "E1169", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1298", "E1300", "E1307"]}
sql+markdown run 2
31 issuers had a downgrade in 2026, listed in the JSON. QA records are excluded and duplicate records are merged by LEI. I05 is an instrument, not an issuer.
JSON: {"issuers": ["E1186", "E1243", "E1255", "E08", "E1151", "E1298", "E1307", "E1213", "E1080", "E1285", "E1112", "E1263", "E1064", "E1163", "E1053", "E1051", "E1300", "E10", "E1034", "E1229", "E1144", "E1159", "E1057", "E1228", "E1294", "E1058", "E1093", "E1160", "E1290", "E1169", "E1167"]}
sql+markdown run 3
31 issuers had a downgrade (DG) action in 2026, listed in the JSON, including E08 and E10. E01 is not among them.
JSON: {"issuers": ["E1151", "E1294", "E1053", "E1144", "E1299", "E1159", "E1243", "E1057", "E1167", "E1058", "E1080", "E1285", "E1290", "E1034", "E1170", "E1051", "E1093", "E1064", "E08", "E1186", "E1112", "E1228", "E1229", "E1255", "E1263", "E1307", "E10", "E1161", "E1300", "E1163", "E1213"]}
sql+markdown run 4
31 issuers had an LTIDR or STIDR downgrade in 2026 (listed in the JSON). They include E10 (A29's issuer, downgraded in A27) and E08 (A21, A22), but not E01 or E14.
JSON: {"issuers": ["E1159", "E1057", "E1053", "E1144", "E1243", "E1294", "E1151", "E1064", "E1093", "E1034", "E1285", "E1290", "E1058", "E1167", "E10", "E1160", "E1080", "E1213", "E1300", "E1163", "E1186", "E1112", "E1169", "E08", "E1051", "E1229", "E1307", "E1255", "E1263", "E1228", "E1298"]}
sql+markdown run 5
31 issuers had an LTIDR downgrade in 2026 (listed in the JSON, including E08 and E10). Records sharing an LEI are counted once.
JSON: {"issuers": ["E1159", "E1057", "E1243", "E1053", "E1144", "E1080", "E1064", "E1093", "E1151", "E1294", "E1051", "E08", "E1112", "E1169", "E1186", "E1058", "E1167", "E1307", "E1228", "E1263", "E1298", "E1255", "E1229", "E1034", "E1163", "E1213", "E1300", "E1285", "E1290", "E10", "E1160"]}
sparql run 1
The issuers with a downgrade (DG) action in 2026 are listed in the JSON, 44 in all. They include E08, E10 and E16.
JSON: {"issuers": ["E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E1340", "E1341", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E08", "E10", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1161', 'E1163', 'E1167', 'E1170', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1299', 'E1300', 'E1307', 'E1340', 'E1341', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E08', 'E10', 'E16']
sparql run 2
Entities with a 2026 downgrade action (DG) on their issuer rating are listed in the JSON. I excluded E1051 (A+ to A+) and E1229 (BB to BB+). Their DG labels don't match the rating moves, so I could not confirm them as downgrades.
JSON: {"issuers": ["E08", "E10", "E1034", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E1340", "E1342", "E1343", "E1344", "E1345", "E1347", "E1348", "E1350", "E1351", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E08', 'E10', 'E1034', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1161', 'E1163', 'E1167', 'E1170', 'E1186', 'E1213', 'E1228', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1299', 'E1300', 'E1307', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1347', 'E1348', 'E1350', 'E1351', 'E16']
sparql run 3
Incomplete. The 2026 downgrades I could see are E08, E10, E16, E1034, E1080 and E1161. My count query returned 0, so I could not confirm the full list.
JSON: {"issuers": ["E08", "E10", "E16", "E1034", "E1080", "E1161"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E08', 'E10', 'E16', 'E1034', 'E1080', 'E1161']
sparql run 4
These are the issuers with a downgrade action on a long-term issuer rating in 2026 (list in the JSON). It includes E08, E10 and E16.
JSON: {"issuers": ["E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E1340", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E08", "E10", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1161', 'E1163', 'E1167', 'E1170', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1299', 'E1300', 'E1307', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E08', 'E10', 'E16']
sparql run 5
44 entities have a downgrade action in 2026, listed in the JSON, e.g. E08, E10, E16. I did not check whether any of them are duplicate records of the same entity.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E1340", "E1341", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1161', 'E1163', 'E1167', 'E1170', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1299', 'E1300', 'E1307', 'E1340', 'E1341', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E16']
sparql+ontology run 1
31 issuers had long-term issuer downgrades in 2026, excluding QA records. E1051 appears twice with DG to A+ both times, so its second action did not change the rating; I counted it anyway because the action is DG.
JSON: {"issuers": ["E1243", "E1057", "E1144", "E1263", "E1159", "E1064", "E1285", "E10", "E1294", "E1300", "E1167", "E1053", "E1290", "E1213", "E1229", "E1186", "E1163", "E1151", "E1169", "E1255", "E1228", "E1051", "E1034", "E1298", "E1080", "E1307", "E1093", "E08", "E1160", "E1112", "E1058"]}
sparql+ontology run 2
Issuers with a DG action in 2026 are listed in the JSON. I excluded QA records and used the RATINGS record ID where an entity has duplicate records (E1160, E1169, E1298). I took each action's DG label at face value without checking the direction of each rating move, and E1051 shows A+ before and after.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1160", "E1163", "E1167", "E1169", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1298", "E1300", "E1307"]}
sparql+ontology run 3
31 issuers had a downgrade in 2026 (see JSON). I took these from DG actions on issuer ratings dated in 2026, excluding QA records. The query was cut off at 60 seconds in one round, so the list may be incomplete.
JSON: {"issuers": ["E1186", "E1243", "E1255", "E08", "E1151", "E1299", "E1307", "E1213", "E1080", "E1285", "E1112", "E1263", "E1064", "E1163", "E1053", "E1051", "E1300", "E10", "E1034", "E1229", "E1144", "E1159", "E1057", "E1228", "E1294", "E1058", "E1093", "E1161", "E1170", "E1290", "E1167"]}
sparql+ontology run 4
31 issuers had a Downgrade action in 2026 (list in the JSON). E1051 counts because its actions are labelled DG, although the rating shown after each is A+.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307"]}
sparql+ontology run 5
35 issuers had a downgrade (DG) in 2026. I excluded QA records and instrument-only downgrades (I05). The research-record IDs E1170 and E1299 are mapped to E1169 and E1298 by an adjacent-ID pattern I inferred rather than confirmed by LEI.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1160", "E1163", "E1167", "E1169", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1298", "E1300", "E1307"]}
sql+executed run 1
The issuers with downgrade (DG) actions on their issuer ratings in 2026 are listed in the JSON. Downgrades to WD are excluded.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1160", "E1163", "E1167", "E1169", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1298", "E1300", "E1307"]}
sql+executed run 2
31 issuers had a downgrade action in 2026; the IDs are in the JSON. I relied on the action flag "DG" for 2026 long-term rating records.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1160", "E1163", "E1167", "E1169", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1298", "E1300", "E1307"]}
sql+executed run 3
31 issuers had a downgrade effective in 2026; they are listed in the JSON. This counts LTIDR downgrades on the rating scale, including E08 and E10, and excludes withdrawals.
JSON: {"issuers": ["E1058", "E1167", "E1080", "E1151", "E1294", "E1064", "E1093", "E1228", "E1229", "E1255", "E1263", "E1298", "E1307", "E1163", "E1213", "E1300", "E1053", "E1057", "E1144", "E1159", "E1243", "E08", "E1112", "E1169", "E1186", "E10", "E1160", "E1034", "E1285", "E1290", "E1051"]}
sql+executed run 4
30 issuers had a downgrade (DG) action on a long-term rating starting in 2026, listed in the JSON. I excluded E1064, whose 2026 DG shows no change in rating. I counted E1051 once, on its first DG (AA- to A+).
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1160", "E1163", "E1167", "E1169", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1298", "E1300", "E1307"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307']
sql+executed run 5
31 issuers had a downgrade (DG) action in 2026, listed in the JSON. E1051 has two DG rows, both at A+, so one of them may not be a real step down.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1160", "E1163", "E1167", "E1169", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1298", "E1300", "E1307"]}
sparql+axioms run 1
The 44 issuers below have a 2026 downgrade action on a long-term issuer rating. I excluded E1341, whose downgrade is dated 2026-11-09, after today.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E1340", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1161', 'E1163', 'E1167', 'E1170', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1299', 'E1300', 'E1307', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E16']
sparql+axioms run 2
The 2026 downgrades are the issuers in the JSON list, including E08, E10 and E16. This list is not merged across duplicate records of the same entity.
JSON: {"issuers": ["E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E1340", "E1341", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E08", "E10", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1161', 'E1163', 'E1167', 'E1170', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1299', 'E1300', 'E1307', 'E1340', 'E1341', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E08', 'E10', 'E16']
sparql+axioms run 3
The issuers with a downgrade action dated in 2026 are listed in the JSON. E1341 is excluded because its downgrade (A1720) is dated 2026-11-09, after today's date. I05 is excluded because it is an instrument.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E1340", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1161', 'E1163', 'E1167', 'E1170', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1299', 'E1300', 'E1307', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E16']
sparql+axioms run 4
Entities with a long-term downgrade dated in 2026, up to the 1 Oct 2026 reference date (list in the JSON). I used the recorded action type, so a few oddly dated or repeated records (e.g. E1051, E1229) are taken at face value.
JSON: {"issuers": ["E1186", "E1243", "E1255", "E08", "E1151", "E1299", "E1307", "E1213", "E1080", "E1285", "E1112", "E1263", "E1064", "E1347", "E1344", "E1348", "E1163", "E1053", "E1051", "E1300", "E10", "E1034", "E1229", "E16", "E1144", "E1159", "E1057", "E1340", "E1228", "E1294", "E1058", "E1342", "E1093", "E1161", "E1343", "E1170", "E1290", "E1350", "E1167", "E1345", "E1351"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E1186', 'E1243', 'E1255', 'E08', 'E1151', 'E1299', 'E1307', 'E1213', 'E1080', 'E1285', 'E1112', 'E1263', 'E1064', 'E1347', 'E1344', 'E1348', 'E1163', 'E1053', 'E1051', 'E1300', 'E10', 'E1034', 'E1229', 'E16', 'E1144', 'E1159', 'E1057', 'E1340', 'E1228', 'E1294', 'E1058', 'E1342', 'E1093', 'E1161', 'E1343', 'E1170', 'E1290', 'E1350', 'E1167', 'E1345', 'E1351']
sparql+axioms run 5
The list below comes from the downgrade actions dated 2026. I could not confirm that each one is a genuine issuer-level downgrade, and E1341 is dated 2026-11-09, after today's date, so I left it out.
JSON: {"issuers": ["E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1161", "E1163", "E1167", "E1170", "E1186", "E1213", "E1228", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E1340", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E16"]}
Why: issuers: expected ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1160', 'E1163', 'E1167', 'E1169', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1298', 'E1300', 'E1307'], got ['E08', 'E10', 'E1034', 'E1051', 'E1053', 'E1057', 'E1058', 'E1064', 'E1080', 'E1093', 'E1112', 'E1144', 'E1151', 'E1159', 'E1161', 'E1163', 'E1167', 'E1170', 'E1186', 'E1213', 'E1228', 'E1229', 'E1243', 'E1255', 'E1263', 'E1285', 'E1290', 'E1294', 'E1299', 'E1300', 'E1307', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E16']