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

← 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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156']

❌ D4 sparql run 1 graded by code · query session

57 issuers had a Negative outlook on 1 October 2026 (see JSON).

JSON: {"issuers": ["E1300", "E5099", "E1080", "E1105", "E5113", "E1034", "E1347", "E1343", "E1118", "E1056", "E1064", "E1350", "E1342", "E1055", "E5097", "E1351", "E1046", "E5059", "E5020", "E1340", "E1161", "E1263", "E1282", "E01", "E5131", "E5023", "E5141", "E5116", "E09", "E1271", "E5039", "E5102", "E1344", "E1228", "E1060", "E5073", "E1079", "E5019", "E5050", "E5062", "E1348", "E1072", "E1190", "E1005", "E1345", "E1248", "E5057", "E1294", "E1188", "E5119", "E5170", "E1029", "E5013", "E1262", "E1158", "E5156", "E1211"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E1300', 'E5099', 'E1080', 'E1105', 'E5113', 'E1034', 'E1347', 'E1343', 'E1118', 'E1056', 'E1064', 'E1350', 'E1342', 'E1055', 'E5097', 'E1351', 'E1046', 'E5059', 'E5020', 'E1340', 'E1161', 'E1263', 'E1282', 'E01', 'E5131', 'E5023', 'E5141', 'E5116', 'E09', 'E1271', 'E5039', 'E5102', 'E1344', 'E1228', 'E1060', 'E5073', 'E1079', 'E5019', 'E5050', 'E5062', 'E1348', 'E1072', 'E1190', 'E1005', 'E1345', 'E1248', 'E5057', 'E1294', 'E1188', 'E5119', 'E5170', 'E1029', 'E5013', 'E1262', 'E1158', 'E5156', 'E1211']

❌ D4 sparql run 2 graded by code · query session

See JSON. These are the entities whose latest foreign-currency or local-currency rating action carried a Negative outlook.

JSON: {"issuers": ["E1300", "E5099", "E1064", "E5113", "E5039", "E1161", "E5141", "E1080", "E1105", "E1072", "E1211", "E1005", "E1034", "E1347", "E1343", "E1271", "E1118", "E1158", "E1056", "E1248", "E1350", "E1345", "E5062", "E1342", "E5057", "E1055", "E5097", "E1351", "E1046", "E5059", "E5020", "E1340", "E1263", "E1348", "E5073", "E1188", "E1282", "E01", "E5102", "E1029", "E5131", "E5023", "E5116", "E09", "E1344", "E1228", "E1060", "E1079", "E5019", "E5050", "E1262", "E5013", "E1190", "E5119", "E1294", "E5170", "E5156"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E1300', 'E5099', 'E1064', 'E5113', 'E5039', 'E1161', 'E5141', 'E1080', 'E1105', 'E1072', 'E1211', 'E1005', 'E1034', 'E1347', 'E1343', 'E1271', 'E1118', 'E1158', 'E1056', 'E1248', 'E1350', 'E1345', 'E5062', 'E1342', 'E5057', 'E1055', 'E5097', 'E1351', 'E1046', 'E5059', 'E5020', 'E1340', 'E1263', 'E1348', 'E5073', 'E1188', 'E1282', 'E01', 'E5102', 'E1029', 'E5131', 'E5023', 'E5116', 'E09', 'E1344', 'E1228', 'E1060', 'E1079', 'E5019', 'E5050', 'E1262', 'E5013', 'E1190', 'E5119', 'E1294', 'E5170', 'E5156']

❌ D4 sparql run 3 graded by code · query session

Incomplete. The ones I could see with a latest Negative outlook are E01, E09, E5013, E5019, E5020, E5039, E5050 and E5057. The one query meant to list them returned an implausible result (E08, which has no outlook), so I discarded it.

JSON: {"issuers": ["E01", "E09", "E5013", "E5019", "E5020", "E5039", "E5050", "E5057"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E01', 'E09', 'E5013', 'E5019', 'E5020', 'E5039', 'E5050', 'E5057']

❌ D4 sparql run 4 graded by code · query session

The entities whose latest rating had a Negative outlook are listed in the JSON, including E01 and E09.

JSON: {"issuers": ["E1300", "E5099", "E1080", "E1105", "E5113", "E1034", "E1347", "E1343", "E1118", "E1056", "E1064", "E1350", "E1342", "E1055", "E5097", "E1351", "E1046", "E5059", "E5020", "E1340", "E1161", "E1263", "E1282", "E01", "E5131", "E5023", "E5141", "E5116", "E09", "E1271", "E5039", "E5102", "E1344", "E1228", "E1060", "E5073", "E1079", "E5019", "E5050", "E5062", "E1348", "E1072", "E1190", "E1005", "E1345", "E1248", "E5057", "E1294", "E1188", "E5119", "E5170", "E1029", "E5013", "E1262", "E1158", "E5156", "E1211"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E1300', 'E5099', 'E1080', 'E1105', 'E5113', 'E1034', 'E1347', 'E1343', 'E1118', 'E1056', 'E1064', 'E1350', 'E1342', 'E1055', 'E5097', 'E1351', 'E1046', 'E5059', 'E5020', 'E1340', 'E1161', 'E1263', 'E1282', 'E01', 'E5131', 'E5023', 'E5141', 'E5116', 'E09', 'E1271', 'E5039', 'E5102', 'E1344', 'E1228', 'E1060', 'E5073', 'E1079', 'E5019', 'E5050', 'E5062', 'E1348', 'E1072', 'E1190', 'E1005', 'E1345', 'E1248', 'E5057', 'E1294', 'E1188', 'E5119', 'E5170', 'E1029', 'E5013', 'E1262', 'E1158', 'E5156', 'E1211']

❌ D4 sparql run 5 graded by code · query session

The 57 entities in the JSON had a Negative outlook on that date.

JSON: {"issuers": ["E1300", "E5099", "E1080", "E1105", "E5113", "E1034", "E1347", "E1343", "E1118", "E1056", "E1064", "E1350", "E1342", "E1055", "E5097", "E1351", "E1046", "E5059", "E5020", "E1340", "E1161", "E1263", "E1282", "E01", "E5131", "E5023", "E5141", "E5116", "E09", "E1271", "E5039", "E5102", "E1344", "E1228", "E1060", "E5073", "E1079", "E5019", "E5050", "E5062", "E1348", "E1072", "E1190", "E1005", "E1345", "E1248", "E5057", "E1294", "E1188", "E5119", "E5170", "E1029", "E5013", "E1262", "E1158", "E5156", "E1211"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E1300', 'E5099', 'E1080', 'E1105', 'E5113', 'E1034', 'E1347', 'E1343', 'E1118', 'E1056', 'E1064', 'E1350', 'E1342', 'E1055', 'E5097', 'E1351', 'E1046', 'E5059', 'E5020', 'E1340', 'E1161', 'E1263', 'E1282', 'E01', 'E5131', 'E5023', 'E5141', 'E5116', 'E09', 'E1271', 'E5039', 'E5102', 'E1344', 'E1228', 'E1060', 'E5073', 'E1079', 'E5019', 'E5050', 'E5062', 'E1348', 'E1072', 'E1190', 'E1005', 'E1345', 'E1248', 'E5057', 'E1294', 'E1188', 'E5119', 'E5170', 'E1029', 'E5013', 'E1262', 'E1158', 'E5156', 'E1211']

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

47 issuers, listed below. The query also returned three entities (E1106, E1218, E1308) with neither a Watch nor an outlook value, which I did not count.

JSON: {"issuers": ["E1300", "E5099", "E1080", "E1105", "E5113", "E1034", "E1118", "E1056", "E1064", "E1055", "E5097", "E1046", "E5059", "E5020", "E1161", "E1263", "E1282", "E01", "E5131", "E5023", "E5141", "E5116", "E09", "E1271", "E5039", "E5102", "E1228", "E1060", "E5073", "E1079", "E5019", "E5050", "E5062", "E1072", "E1190", "E1005", "E1248", "E5057", "E1294", "E1188", "E5119", "E1029", "E5013", "E1262", "E1158", "E5156", "E1211"]}

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

Listed in the JSON.

JSON: {"issuers": ["E1300", "E5099", "E1064", "E5113", "E5039", "E1160", "E5141", "E1080", "E1105", "E1072", "E1211", "E1005", "E1034", "E1271", "E1118", "E1158", "E1056", "E1248", "E5062", "E5057", "E1055", "E5097", "E1046", "E5059", "E5020", "E1263", "E5073", "E1188", "E1282", "E01", "E5102", "E1029", "E5131", "E5023", "E5116", "E09", "E1228", "E1059", "E1079", "E5019", "E5050", "E1261", "E5013", "E1190", "E5119", "E1294", "E5156"]}

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

E01 and E09 (A03, A25).

JSON: {"issuers": ["E01", "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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E01', 'E09']

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

46 issuers. The same caveat applies.

JSON: {"issuers": ["E01", "E09", "E1064", "E1080", "E1072", "E1005", "E1034", "E1055", "E1046", "E1029", "E1059", "E1079", "E1160", "E1105", "E1118", "E1158", "E1188", "E1190", "E1211", "E1271", "E1248", "E1263", "E1282", "E1228", "E1261", "E1294", "E1300", "E5099", "E5039", "E5062", "E5057", "E5097", "E5059", "E5020", "E5073", "E5023", "E5019", "E5050", "E5013", "E5113", "E5141", "E5102", "E5131", "E5116", "E5119", "E5156"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E01', 'E09', 'E1064', 'E1080', 'E1072', 'E1005', 'E1034', 'E1055', 'E1046', 'E1029', 'E1059', 'E1079', 'E1160', 'E1105', 'E1118', 'E1158', 'E1188', 'E1190', 'E1211', 'E1271', 'E1248', 'E1263', 'E1282', 'E1228', 'E1261', 'E1294', 'E1300', 'E5099', 'E5039', 'E5062', 'E5057', 'E5097', 'E5059', 'E5020', 'E5073', 'E5023', 'E5019', 'E5050', 'E5013', 'E5113', 'E5141', 'E5102', 'E5131', 'E5116', 'E5119', 'E5156']

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

The list is in the JSON; it is issuers whose latest action has a Negative outlook and no Watch.

JSON: {"issuers": ["E1300", "E5099", "E1064", "E5113", "E5039", "E1161", "E5141", "E1080", "E1105", "E1072", "E1211", "E1005", "E1034", "E1271", "E1118", "E1158", "E1056", "E1248", "E5062", "E5057", "E1055", "E5097", "E1046", "E5059", "E5020", "E1263", "E5073", "E1188", "E1282", "E01", "E5102", "E1029", "E5131", "E5023", "E5116", "E09", "E1228", "E1060", "E1079", "E5019", "E5050", "E1262", "E5013", "E1190", "E5119", "E1294", "E5156"]}

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

The query returned about 260 rows and only 27 were visible, so the JSON holds a partial list (including E01 and E09).

JSON: {"issuers": ["E1300", "E5099", "E1080", "E1105", "E5113", "E1034", "E1118", "E1056", "E1064", "E1055", "E5097", "E1046", "E5059", "E5020", "E1161", "E1263", "E1282", "E01", "E5131", "E5023", "E5141", "E5116", "E09", "E1271", "E5039", "E5102", "E1228", "E1060"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E1300', 'E5099', 'E1080', 'E1105', 'E5113', 'E1034', 'E1118', 'E1056', 'E1064', 'E1055', 'E5097', 'E1046', 'E5059', 'E5020', 'E1161', 'E1263', 'E1282', 'E01', 'E5131', 'E5023', 'E5141', 'E5116', 'E09', 'E1271', 'E5039', 'E5102', 'E1228', 'E1060']

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

E01, E09 (?), from A03 and A25; other entities not seen may also qualify.

JSON: {"issuers": ["E01", "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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E01', 'E09']

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

50 issuers had a Negative outlook on their foreign-currency long-term rating. The list is in the JSON.

JSON: {"issuers": ["E1300", "E5099", "E1080", "E1105", "E5113", "E1034", "E1118", "E1056", "E1064", "E1055", "E5097", "E1046", "E5059", "E5020", "E1161", "E1263", "E1282", "E01", "E5131", "E5023", "E5141", "E5116", "E09", "E1271", "E5039", "E5102", "E1228", "E1060", "E5073", "E5033", "E1079", "E5019", "E5050", "E5062", "E1072", "E1190", "E1005", "E1248", "E5057", "E1294", "E1188", "E5119", "E1029", "E5013", "E1262", "E1158", "E5156", "E1211"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E1300', 'E5099', 'E1080', 'E1105', 'E5113', 'E1034', 'E1118', 'E1056', 'E1064', 'E1055', 'E5097', 'E1046', 'E5059', 'E5020', 'E1161', 'E1263', 'E1282', 'E01', 'E5131', 'E5023', 'E5141', 'E5116', 'E09', 'E1271', 'E5039', 'E5102', 'E1228', 'E1060', 'E5073', 'E5033', 'E1079', 'E5019', 'E5050', 'E5062', 'E1072', 'E1190', 'E1005', 'E1248', 'E5057', 'E1294', 'E1188', 'E5119', 'E1029', 'E5013', 'E1262', 'E1158', 'E5156', 'E1211']

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

The JSON lists the seven I saw: E01, E09, E1005, E1029, E1034, E1046 and E1055. About 120 more rows were truncated, so the list is incomplete.

JSON: {"issuers": ["E01", "E09", "E1005", "E1029", "E1034", "E1046", "E1055"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E01', 'E09', 'E1005', 'E1029', 'E1034', 'E1046', 'E1055']

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

The 48 entities with a Negative outlook in force are in the JSON.

JSON: {"issuers": ["E1300", "E5099", "E1080", "E1105", "E5113", "E1034", "E1118", "E1056", "E1064", "E1055", "E5097", "E1046", "E5059", "E5020", "E1161", "E1263", "E1282", "E01", "E5131", "E5023", "E5141", "E5116", "E09", "E1271", "E5039", "E5102", "E1228", "E1060", "E5073", "E5033", "E1079", "E5019", "E5050", "E5062", "E1072", "E1190", "E1005", "E1248", "E5057", "E1294", "E1188", "E5119", "E1029", "E5013", "E1262", "E1158", "E5156", "E1211"]}

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', 'E5013', 'E5019', 'E5020', 'E5023', 'E5039', 'E5050', 'E5057', 'E5059', 'E5062', 'E5073', 'E5097', 'E5099', 'E5102', 'E5113', 'E5116', 'E5119', 'E5131', 'E5141', 'E5156'], got ['E1300', 'E5099', 'E1080', 'E1105', 'E5113', 'E1034', 'E1118', 'E1056', 'E1064', 'E1055', 'E5097', 'E1046', 'E5059', 'E5020', 'E1161', 'E1263', 'E1282', 'E01', 'E5131', 'E5023', 'E5141', 'E5116', 'E09', 'E1271', 'E5039', 'E5102', 'E1228', 'E1060', 'E5073', 'E5033', 'E1079', 'E5019', 'E5050', 'E5062', 'E1072', 'E1190', 'E1005', 'E1248', 'E5057', 'E1294', 'E1188', 'E5119', 'E1029', 'E5013', 'E1262', 'E1158', 'E5156', 'E1211']