Q19, run 2026-11-04-1738-sonnet-query

← back to the run

Which issuers had a Negative outlook on 1 October 2026?

Tests: Outlooks: set by affirmations, without a rating change.

Expected: issuers = ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300']

❌ D1 sql run 1 graded by code · query session

The 37 issuers are in the JSON. Each one's latest issuer-rating action by 1 Oct 2026 carries a Negative outlook.

JSON: {"issuers": ["E1005", "E1080", "E1055", "E1350", "E1294", "E1188", "E1248", "E1034", "E1351", "E1029", "E1342", "E1160", "E1228", "E1345", "E1263", "E1211", "E09", "E1046", "E1348", "E1158", "E1344", "E1105", "E1059", "E1282", "E1056", "E1340", "E1300", "E1347", "E1271", "E1261", "E1343", "E01", "E1118", "E1064", "E1072", "E1190", "E1079"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E1005', 'E1080', 'E1055', 'E1350', 'E1294', 'E1188', 'E1248', 'E1034', 'E1351', 'E1029', 'E1342', 'E1160', 'E1228', 'E1345', 'E1263', 'E1211', 'E09', 'E1046', 'E1348', 'E1158', 'E1344', 'E1105', 'E1059', 'E1282', 'E1056', 'E1340', 'E1300', 'E1347', 'E1271', 'E1261', 'E1343', 'E01', 'E1118', 'E1064', 'E1072', 'E1190', 'E1079']

❌ D1 sql run 2 graded by code · query session

37 entities had a Negative outlook, listed in the JSON.

JSON: {"issuers": ["E1350", "E1055", "E1294", "E1188", "E1248", "E1034", "E1347", "E1271", "E1261", "E1118", "E1064", "E01", "E1343", "E1345", "E1228", "E1263", "E1029", "E1342", "E1351", "E1160", "E09", "E1211", "E1080", "E1005", "E1340", "E1056", "E1059", "E1282", "E1105", "E1344", "E1158", "E1046", "E1348", "E1072", "E1190", "E1079", "E1300"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E1350', 'E1055', 'E1294', 'E1188', 'E1248', 'E1034', 'E1347', 'E1271', 'E1261', 'E1118', 'E1064', 'E01', 'E1343', 'E1345', 'E1228', 'E1263', 'E1029', 'E1342', 'E1351', 'E1160', 'E09', 'E1211', 'E1080', 'E1005', 'E1340', 'E1056', 'E1059', 'E1282', 'E1105', 'E1344', 'E1158', 'E1046', 'E1348', 'E1072', 'E1190', 'E1079', 'E1300']

❌ D1 sql run 3 graded by code · query session

37 records with a Negative outlook as their latest action, listed in the JSON as 37 issuers after mapping duplicates (E1060 to E1059, E1161 to E1160).

JSON: {"issuers": ["E1211", "E1340", "E1350", "E1271", "E1263", "E1248", "E1064", "E1105", "E1345", "E1294", "E1300", "E1079", "E1059", "E1190", "E1262", "E1046", "E1342", "E01", "E1347", "E1282", "E1348", "E1228", "E1344", "E1055", "E1029", "E09", "E1005", "E1034", "E1188", "E1080", "E1158", "E1056", "E1343", "E1351", "E1160", "E1072", "E1118"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E1211', 'E1340', 'E1350', 'E1271', 'E1263', 'E1248', 'E1064', 'E1105', 'E1345', 'E1294', 'E1300', 'E1079', 'E1059', 'E1190', 'E1262', 'E1046', 'E1342', 'E01', 'E1347', 'E1282', 'E1348', 'E1228', 'E1344', 'E1055', 'E1029', 'E09', 'E1005', 'E1034', 'E1188', 'E1080', 'E1158', 'E1056', 'E1343', 'E1351', 'E1160', 'E1072', 'E1118']

❌ D1 sql run 4 graded by code · query session

The 37 issuers listed in the JSON. This uses the latest foreign-currency rating on 2026-10-01 carrying a Negative outlook.

JSON: {"issuers": ["E1055", "E1263", "E1340", "E09", "E1079", "E1105", "E1161", "E1228", "E1262", "E1005", "E1300", "E1072", "E1211", "E1282", "E01", "E1188", "E1190", "E1344", "E1347", "E1029", "E1046", "E1064", "E1248", "E1294", "E1342", "E1060", "E1350", "E1351", "E1056", "E1343", "E1348", "E1034", "E1080", "E1118", "E1158", "E1345", "E1271"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E1055', 'E1263', 'E1340', 'E09', 'E1079', 'E1105', 'E1161', 'E1228', 'E1262', 'E1005', 'E1300', 'E1072', 'E1211', 'E1282', 'E01', 'E1188', 'E1190', 'E1344', 'E1347', 'E1029', 'E1046', 'E1064', 'E1248', 'E1294', 'E1342', 'E1060', 'E1350', 'E1351', 'E1056', 'E1343', 'E1348', 'E1034', 'E1080', 'E1118', 'E1158', 'E1345', 'E1271']

❌ D1 sql run 5 graded by code · query session

37 issuers had a Negative outlook on 2026-10-01, listed in the JSON. This uses each entity's latest rating action.

JSON: {"issuers": ["E1348", "E1046", "E1190", "E1072", "E1350", "E1294", "E1055", "E1105", "E1344", "E1158", "E1079", "E09", "E1211", "E1160", "E1351", "E1029", "E1342", "E1034", "E1248", "E1188", "E1271", "E1347", "E1056", "E1340", "E1059", "E1282", "E1005", "E1080", "E1228", "E1263", "E1345", "E1300", "E1343", "E1064", "E01", "E1261", "E1118"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E1348', 'E1046', 'E1190', 'E1072', 'E1350', 'E1294', 'E1055', 'E1105', 'E1344', 'E1158', 'E1079', 'E09', 'E1211', 'E1160', 'E1351', 'E1029', 'E1342', 'E1034', 'E1248', 'E1188', 'E1271', 'E1347', 'E1056', 'E1340', 'E1059', 'E1282', 'E1005', 'E1080', 'E1228', 'E1263', 'E1345', 'E1300', 'E1343', 'E1064', 'E01', 'E1261', 'E1118']

✅ D2 sql+markdown run 1 graded by code · query session

28 issuers, listed in the JSON, with a latest LTIDR outlook of NEG that had not been withdrawn.

JSON: {"issuers": ["E1211", "E09", "E1046", "E1271", "E1034", "E1188", "E1248", "E1079", "E1263", "E1228", "E1080", "E1005", "E1190", "E1072", "E1059", "E1056", "E1282", "E1055", "E1294", "E1064", "E1261", "E01", "E1118", "E1029", "E1160", "E1158", "E1105", "E1300"]}

✅ D2 sql+markdown run 2 graded by code · query session

28 issuers had a Negative outlook on 2026-10-01 on their latest long-term issuer rating, listed in the JSON below. Withdrawn ratings are excluded.

JSON: {"issuers": ["E1005", "E1055", "E1072", "E1160", "E1211", "E1263", "E1282", "E1271", "E1294", "E1118", "E1080", "E01", "E1064", "E1190", "E1158", "E1228", "E1029", "E1248", "E1188", "E1059", "E1034", "E1079", "E1105", "E1046", "E1261", "E1300", "E09", "E1056"]}

✅ D2 sql+markdown run 3 graded by code · query session

28 issuers had a Negative outlook on 1 October 2026 (E01 and E09 among them), listed in the JSON.

JSON: {"issuers": ["E1271", "E1294", "E1055", "E1188", "E1034", "E1248", "E01", "E1118", "E1064", "E1263", "E1228", "E1261", "E1059", "E1211", "E09", "E1190", "E1072", "E1158", "E1105", "E1046", "E1282", "E1056", "E1029", "E1160", "E1005", "E1080", "E1300", "E1079"]}

✅ D2 sql+markdown run 4 graded by code · query session

Twenty-eight issuers had a Negative outlook on 1 October 2026 (listed in the JSON), including E01 and E09.

JSON: {"issuers": ["E1005", "E1080", "E01", "E1118", "E1064", "E1261", "E1271", "E1046", "E1059", "E1282", "E1056", "E1263", "E1228", "E1211", "E09", "E1105", "E1158", "E1079", "E1160", "E1029", "E1248", "E1034", "E1188", "E1300", "E1055", "E1294", "E1072", "E1190"]}

✅ D2 sql+markdown run 5 graded by code · query session

The list is in the JSON; it covers LTIDRs with a NEG outlook on that date.

JSON: {"issuers": ["E1228", "E1263", "E1271", "E1034", "E1188", "E1248", "E1282", "E1056", "E1059", "E1079", "E1294", "E1055", "E1105", "E1158", "E1160", "E1029", "E01", "E1118", "E1064", "E1261", "E1046", "E1211", "E09", "E1005", "E1080", "E1190", "E1072", "E1300"]}

❌ D4 sparql run 1 graded by code · query session

37 issuers (IDs in the JSON).

JSON: {"issuers": ["E01", "E1005", "E1029", "E1034", "E1046", "E1055", "E1056", "E1060", "E1064", "E1072", "E1079", "E1080", "E1105", "E1118", "E1158", "E1161", "E1188", "E1190", "E1211", "E1228", "E1248", "E1262", "E1263", "E1271", "E1282", "E1294", "E1300", "E1340", "E1342", "E1343", "E1344", "E1345", "E1347", "E1348", "E1350", "E1351", "E09"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E01', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1060', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1161', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1262', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1347', 'E1348', 'E1350', 'E1351', 'E09']

❌ D4 sparql run 2 graded by code · query session

37 issuers have a Negative outlook, listed in the JSON.

JSON: {"issuers": ["E01", "E09", "E1005", "E1029", "E1034", "E1046", "E1055", "E1056", "E1060", "E1064", "E1072", "E1079", "E1080", "E1105", "E1118", "E1158", "E1161", "E1188", "E1190", "E1211", "E1228", "E1248", "E1262", "E1263", "E1271", "E1282", "E1294", "E1300", "E1340", "E1342", "E1343", "E1344", "E1345", "E1347", "E1348", "E1350", "E1351"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1060', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1161', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1262', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1347', 'E1348', 'E1350', 'E1351']

❌ D4 sparql run 3 graded by code · query session

The list in the JSON is incomplete, for the same reason.

JSON: {"issuers": ["E01", "E09", "E1005", "E1029", "E1034", "E1046", "E1055", "E1056", "E1060", "E1064", "E1072", "E1079", "E1080", "E1158"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1060', 'E1064', 'E1072', 'E1079', 'E1080', 'E1158']

❌ D4 sparql run 4 graded by code · query session

37 issuers, listed in the JSON, had a Negative outlook as of their latest foreign-currency action on 1 October 2026.

JSON: {"issuers": ["E01", "E1005", "E1029", "E1034", "E1046", "E1055", "E1056", "E1060", "E1064", "E1072", "E1079", "E1080", "E1105", "E1118", "E1158", "E1161", "E1188", "E1190", "E1211", "E1228", "E1248", "E1262", "E1263", "E1271", "E1282", "E1294", "E1300", "E1340", "E1342", "E1343", "E1344", "E1345", "E1347", "E1348", "E1350", "E1351", "E09"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E01', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1060', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1161', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1262', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1347', 'E1348', 'E1350', 'E1351', 'E09']

❌ D4 sparql run 5 graded by code · query session

37 issuers, listed in the JSON, including E01 and E09.

JSON: {"issuers": ["E01", "E1005", "E1029", "E1034", "E1046", "E1055", "E1056", "E1060", "E1064", "E1072", "E1079", "E1080", "E1105", "E1118", "E1158", "E1161", "E1188", "E1190", "E1211", "E1228", "E1248", "E1262", "E1263", "E1271", "E1282", "E1294", "E1300", "E1340", "E1342", "E1343", "E1344", "E1345", "E1347", "E1348", "E1350", "E1351", "E09"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E01', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1060', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1161', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1262', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300', 'E1340', 'E1342', 'E1343', 'E1344', 'E1345', 'E1347', 'E1348', 'E1350', 'E1351', 'E09']

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

The 28 issuers are in the JSON. They are the entities whose latest long-term action on 2026-10-01 carried a Negative outlook.

JSON: {"issuers": ["E01", "E1005", "E1029", "E1034", "E1046", "E1055", "E1056", "E1060", "E1064", "E1072", "E1079", "E1080", "E1105", "E1118", "E1158", "E1161", "E1188", "E1190", "E1211", "E1228", "E1248", "E1262", "E1263", "E1271", "E1282", "E1294", "E1300", "E09"]}

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

The 29 issuers are in the JSON; each has a Negative outlook on its latest action as of that date. E1059 stands for E1060, the RESEARCH record with the same LEI.

JSON: {"issuers": ["E1211", "E1271", "E1263", "E1248", "E1064", "E1105", "E1294", "E1300", "E1079", "E1059", "E1190", "E1262", "E1046", "E01", "E1282", "E1228", "E1055", "E1029", "E09", "E1005", "E1034", "E1188", "E1080", "E1158", "E1056", "E1161", "E1072", "E1118"]}

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

30 issuers had a Negative outlook, listed in the JSON. I excluded E1172 and E1057 because they were withdrawn.

JSON: {"issuers": ["E01", "E09", "E1005", "E1029", "E1034", "E1046", "E1055", "E1056", "E1059", "E1064", "E1072", "E1079", "E1080", "E1105", "E1118", "E1132", "E1146", "E1158", "E1161", "E1188", "E1190", "E1211", "E1228", "E1248", "E1262", "E1263", "E1271", "E1282", "E1294", "E1300"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1132', 'E1146', 'E1158', 'E1161', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1262', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300']

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

28 issuers had a Negative outlook on 1 Oct 2026, listed in the JSON.

JSON: {"issuers": ["E01", "E1005", "E1029", "E1034", "E1046", "E1055", "E1056", "E1059", "E1064", "E1072", "E1079", "E1080", "E1105", "E1118", "E1158", "E1160", "E1188", "E1190", "E1211", "E1228", "E1248", "E1261", "E1263", "E1271", "E1282", "E1294", "E1300", "E09"]}

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

29 issuers, listed in the JSON. Each has a latest outlook of Negative. I excluded E1057 and E1172 because their ratings were withdrawn.

JSON: {"issuers": ["E01", "E09", "E1005", "E1029", "E1034", "E1046", "E1055", "E1056", "E1060", "E1064", "E1072", "E1079", "E1080", "E1105", "E1118", "E1132", "E1146", "E1158", "E1161", "E1188", "E1190", "E1211", "E1228", "E1248", "E1262", "E1263", "E1271", "E1282", "E1294", "E1300"]}

Why: issuers: expected ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1059', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1158', 'E1160', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1261', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300'], got ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055', 'E1056', 'E1060', 'E1064', 'E1072', 'E1079', 'E1080', 'E1105', 'E1118', 'E1132', 'E1146', 'E1158', 'E1161', 'E1188', 'E1190', 'E1211', 'E1228', 'E1248', 'E1262', 'E1263', 'E1271', 'E1282', 'E1294', 'E1300']