Q7, run 2026-11-05-1819-sonnet-query-graphdb

← back to the run

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156']

❌ D4 sparql run 1 graded by code · query session

51 entities received a long-term downgrade in 2026 (the list is in the JSON). I excluded E1341 and E5033, whose downgrades are dated after today (2026-11-09 and 2026-11-06).

JSON: {"issuers": ["E1285", "E1300", "E1151", "E1167", "E1080", "E5113", "E1051", "E10", "E1034", "E1347", "E1343", "E1290", "E1350", "E1229", "E1342", "E5097", "E1351", "E5059", "E1255", "E1340", "E16", "E1186", "E1161", "E1263", "E1058", "E1349", "E1112", "E08", "E5116", "E1170", "E1344", "E1228", "E1163", "E1243", "E1299", "E5019", "E1053", "E1348", "E1213", "E1346", "E1159", "E1057", "E1345", "E1064", "E1294", "E1093", "E1144", "E1307", "E5156"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E1285', 'E1300', 'E1151', 'E1167', 'E1080', 'E5113', 'E1051', 'E10', 'E1034', 'E1347', 'E1343', 'E1290', 'E1350', 'E1229', 'E1342', 'E5097', 'E1351', 'E5059', 'E1255', 'E1340', 'E16', 'E1186', 'E1161', 'E1263', 'E1058', 'E1349', 'E1112', 'E08', 'E5116', 'E1170', 'E1344', 'E1228', 'E1163', 'E1243', 'E1299', 'E5019', 'E1053', 'E1348', 'E1213', 'E1346', 'E1159', 'E1057', 'E1345', 'E1064', 'E1294', 'E1093', 'E1144', 'E1307', 'E5156']

❌ D4 sparql run 2 graded by code · query session

See JSON. These are the entities with a 2026 downgrade action on a long-term rating.

JSON: {"issuers": ["E1285", "E1300", "E1151", "E1167", "E1080", "E5113", "E1051", "E10", "E1034", "E1347", "E1343", "E1290", "E1350", "E1341", "E1229", "E1342", "E5097", "E1351", "E5059", "E1255", "E1340", "E16", "E1186", "E1161", "E1263", "E1058", "E1349", "E1112", "E08", "E5116", "E1170", "E1344", "E1228", "E1163", "E1243", "E5033", "E1299", "E5019", "E1053", "E1348", "E1213", "E1346", "E1159", "E1057", "E1345", "E1064", "E1294", "E1093", "E1144", "E1307", "E5156"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E1285', 'E1300', 'E1151', 'E1167', 'E1080', 'E5113', 'E1051', 'E10', 'E1034', 'E1347', 'E1343', 'E1290', 'E1350', 'E1341', 'E1229', 'E1342', 'E5097', 'E1351', 'E5059', 'E1255', 'E1340', 'E16', 'E1186', 'E1161', 'E1263', 'E1058', 'E1349', 'E1112', 'E08', 'E5116', 'E1170', 'E1344', 'E1228', 'E1163', 'E1243', 'E5033', 'E1299', 'E5019', 'E1053', 'E1348', 'E1213', 'E1346', 'E1159', 'E1057', 'E1345', 'E1064', 'E1294', 'E1093', 'E1144', 'E1307', 'E5156']

❌ D4 sparql run 3 graded by code · query session

Incomplete. The downgrades I could confirm are E08 (A21, A22), E10 (A27), E16 (A44) and E5019 (A5012). I did not get a complete list for the large block of E1xxx and E5xxx entities.

JSON: {"issuers": ["E08", "E10", "E16", "E5019"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E08', 'E10', 'E16', 'E5019']

❌ D4 sparql run 4 graded by code · query session

These are the entities with a downgrade action dated in 2026 up to today. I excluded E1341 and E5033, whose actions are dated after 2026-11-05. I did not filter by rating type or currency basis, so the list may include non-issuer-rating downgrades.

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", "E5019", "E5059", "E5097", "E5113", "E5116", "E5156"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], 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', 'E5019', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156']

❌ D4 sparql run 5 graded by code · query session

The 2026 long-term issuer downgrades are in the JSON. The list includes records that duplicate another entity by LEI (E1170, E1161, E1299). I did not exclude downgrades dated after today.

JSON: {"issuers": ["E1285", "E1300", "E1151", "E1167", "E1080", "E5113", "E1051", "E10", "E1034", "E1347", "E1343", "E1290", "E1350", "E1341", "E1229", "E1342", "E5097", "E1351", "E5059", "E1255", "E1340", "E16", "E1186", "E1161", "E1263", "E1058", "E1349", "E1112", "E08", "E5116", "E1170", "E1344", "E1228", "E1163", "E1243", "E5033", "E1299", "E5019", "E1053", "E1348", "E1213", "E1346", "E1159", "E1057", "E1345", "E1064", "E1294", "E1093", "E1144", "E1307", "E5156"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E1285', 'E1300', 'E1151', 'E1167', 'E1080', 'E5113', 'E1051', 'E10', 'E1034', 'E1347', 'E1343', 'E1290', 'E1350', 'E1341', 'E1229', 'E1342', 'E5097', 'E1351', 'E5059', 'E1255', 'E1340', 'E16', 'E1186', 'E1161', 'E1263', 'E1058', 'E1349', 'E1112', 'E08', 'E5116', 'E1170', 'E1344', 'E1228', 'E1163', 'E1243', 'E5033', 'E1299', 'E5019', 'E1053', 'E1348', 'E1213', 'E1346', 'E1159', 'E1057', 'E1345', 'E1064', 'E1294', 'E1093', 'E1144', 'E1307', 'E5156']

✅ D5 sparql+ontology run 1 graded by code · query session

There are 38 issuers with a Downgrade action dated in 2026, listed below. The query counted any rating type and used the record IDs that carried the actions.

JSON: {"issuers": ["E1285", "E1300", "E1151", "E1167", "E1080", "E5113", "E1051", "E10", "E1034", "E1290", "E1229", "E5097", "E5059", "E1255", "E1186", "E1161", "E1263", "E1058", "E1112", "E08", "E5116", "E1170", "E1228", "E1163", "E1243", "E5033", "E1299", "E5019", "E1053", "E1213", "E1159", "E1057", "E1064", "E1294", "E1093", "E1144", "E1307", "E5156"]}

❌ D5 sparql+ontology run 2 graded by code · query session

The 2026 downgrades are listed in the JSON. E5033's downgrade is dated 2026-11-06, which is after today, so I excluded it. QA record E16 is also excluded.

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", "E5019", "E5059", "E5097", "E5113", "E5116", "E5156"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], 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', 'E5019', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156']

❌ D5 sparql+ontology run 3 graded by code · query session

E08 and E10 (A21, A22, A27); E16's downgrade is QA data and is ignored.

JSON: {"issuers": ["E08", "E10"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E08', 'E10']

✅ D5 sparql+ontology run 4 graded by code · query session

38 issuers (the list is in the JSON). It is built from the 2026 DG actions on non-QA records, merged by LEI. It includes E5033, whose downgrade is dated 2026-11-06, after today.

JSON: {"issuers": ["E1161", "E1163", "E1167", "E1170", "E1229", "E1243", "E1255", "E1263", "E1285", "E1290", "E1294", "E1299", "E1300", "E1307", "E5019", "E5033", "E5059", "E5097", "E5113", "E5116", "E5156", "E08", "E10", "E1034", "E1051", "E1053", "E1057", "E1058", "E1064", "E1080", "E1093", "E1112", "E1144", "E1151", "E1159", "E1186", "E1213", "E1228"]}

❌ D5 sparql+ontology run 5 graded by code · query session

E08 (A21) and E10 (A27) were downgraded in 2026; E16 is a QA record and is ignored. My downgrade search covered only the E-series records I listed, so this list is incomplete.

JSON: {"issuers": ["E08", "E10"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E08', 'E10']

❌ D6 sparql+axioms run 1 graded by code · query session

E10 (A27, 2026-04-15) and E16 (A44, 2026-06-01). The query was truncated, so other issuers may be missing.

JSON: {"issuers": ["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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E10', 'E16']

❌ D6 sparql+axioms run 2 graded by code · query session

E08, E10, E16 (?). These are the downgrades seen in 2026 (A21/A22, A27, A44); entities I did not see may add to the list.

JSON: {"issuers": ["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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E08', 'E10', 'E16']

❌ D6 sparql+axioms run 3 graded by code · query session

I found 53 downgrade records dated 2026 for issuer long-term ratings. They include E10, E16 and E08, and are listed in the JSON. I did not de-duplicate records that describe the same entity.

JSON: {"issuers": ["E1285", "E1300", "E1151", "E1167", "E1080", "E5113", "E1051", "E10", "E1034", "E1347", "E1343", "E1290", "E1350", "E1341", "E1229", "E1342", "E5097", "E1351", "E5059", "E1255", "E1340", "E16", "E1186", "E1161", "E1263", "E1058", "E1349", "E1112", "E08", "E5116", "E1170", "E1344", "E1228", "E1163", "E1243", "E5033", "E1299", "E5019", "E1053", "E1348", "E1213", "E1346", "E1159", "E1057", "E1345", "E1064", "E1294", "E1093", "E1144", "E1307", "E5156"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E1285', 'E1300', 'E1151', 'E1167', 'E1080', 'E5113', 'E1051', 'E10', 'E1034', 'E1347', 'E1343', 'E1290', 'E1350', 'E1341', 'E1229', 'E1342', 'E5097', 'E1351', 'E5059', 'E1255', 'E1340', 'E16', 'E1186', 'E1161', 'E1263', 'E1058', 'E1349', 'E1112', 'E08', 'E5116', 'E1170', 'E1344', 'E1228', 'E1163', 'E1243', 'E5033', 'E1299', 'E5019', 'E1053', 'E1348', 'E1213', 'E1346', 'E1159', 'E1057', 'E1345', 'E1064', 'E1294', 'E1093', 'E1144', 'E1307', 'E5156']

❌ D6 sparql+axioms run 4 graded by code · query session

The 28 entities downgraded in 2026 are in the JSON. The count may be incomplete.

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", "E1341", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E16", "E5019", "E5033", "E5059", "E5097", "E5113", "E5116", "E5156"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], 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', 'E1341', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E16', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156']

❌ D6 sparql+axioms run 5 graded by code · query session

The 51 entities are listed in the JSON. They are entities with a Downgraded long-term issuer action dated in 2026, including E08, E10 and E16.

JSON: {"issuers": ["E1285", "E1300", "E1151", "E1167", "E1080", "E5113", "E1051", "E10", "E1034", "E1347", "E1343", "E1290", "E1350", "E1341", "E1229", "E1342", "E5097", "E1351", "E5059", "E1255", "E1340", "E16", "E1186", "E1161", "E1263", "E1058", "E1349", "E1112", "E08", "E5116", "E1170", "E1344", "E1228", "E1163", "E1243", "E5033", "E1299", "E5019", "E1053", "E1348", "E1213", "E1346", "E1159", "E1057", "E1345", "E1064", "E1294", "E1093", "E1144", "E1307", "E5156"]}

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', 'E5019', 'E5033', 'E5059', 'E5097', 'E5113', 'E5116', 'E5156'], got ['E1285', 'E1300', 'E1151', 'E1167', 'E1080', 'E5113', 'E1051', 'E10', 'E1034', 'E1347', 'E1343', 'E1290', 'E1350', 'E1341', 'E1229', 'E1342', 'E5097', 'E1351', 'E5059', 'E1255', 'E1340', 'E16', 'E1186', 'E1161', 'E1263', 'E1058', 'E1349', 'E1112', 'E08', 'E5116', 'E1170', 'E1344', 'E1228', 'E1163', 'E1243', 'E5033', 'E1299', 'E5019', 'E1053', 'E1348', 'E1213', 'E1346', 'E1159', 'E1057', 'E1345', 'E1064', 'E1294', 'E1093', 'E1144', 'E1307', 'E5156']