Q18, run 2026-11-05-1515-sonnet-query
Which issuers were on Rating Watch Negative on 1 October 2026?
Tests: Watch over time: Marlow's Watch ended with its 2026 affirmation.
Expected: issuers = ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323']
sql run 1
32 issuers were on Rating Watch Negative on 2026-10-01 (list in JSON). The duplicate research record E1210 is mapped to E1209.
JSON: {"issuers": ["E1264", "E1006", "E1019", "E1099", "E1260", "E1132", "E1061", "E1238", "E1013", "E1297", "E1181", "E1209", "E1133", "E06", "E1126", "E1098", "E1109", "E1168", "E1194", "E1088", "E1266", "E1059", "E1039", "E1267", "E1242", "E1317", "E1037", "E1066", "E1314", "E1146", "E1323", "E1203"]}
sql run 2
The issuers on Rating Watch Negative are in the JSON.
JSON: {"issuers": ["E1006", "E1264", "E1267", "E1013", "E1061", "E1238", "E1297", "E06", "E1133", "E1039", "E1266", "E1098", "E1126", "E1066", "E1146", "E1203", "E1314", "E1323", "E1037", "E1242", "E1317", "E1088", "E1194", "E1109", "E1168", "E1099", "E1132", "E1260", "E1181", "E1210"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E1006', 'E1264', 'E1267', 'E1013', 'E1061', 'E1238', 'E1297', 'E06', 'E1133', 'E1039', 'E1266', 'E1098', 'E1126', 'E1066', 'E1146', 'E1203', 'E1314', 'E1323', 'E1037', 'E1242', 'E1317', 'E1088', 'E1194', 'E1109', 'E1168', 'E1099', 'E1132', 'E1260', 'E1181', 'E1210']
sql run 3
The list is in the JSON (32 issuers whose latest issuer rating was a Rating Watch Negative action).
JSON: {"issuers": ["E1099", "E1260", "E1006", "E1297", "E1132", "E1181", "E1323", "E1266", "E1019", "E1037", "E1203", "E1267", "E06", "E1039", "E1088", "E1098", "E1146", "E1066", "E1314", "E1061", "E1126", "E1133", "E1059", "E1109", "E1168", "E1194", "E1209", "E1242", "E1264", "E1238", "E1317", "E1013"]}
sql run 4
(no answer found)
JSON: {"issuers": ["E1109", "E1168", "E1037", "E1209", "E1242", "E1317", "E1099", "E1260", "E1132", "E1019", "E1264", "E1006", "E1194", "E1088", "E1181", "E1238", "E1061", "E1013", "E1297", "E1203", "E1066", "E1314", "E1323", "E1146", "E1267", "E1133", "E06", "E1126", "E1098", "E1059", "E1266", "E1039"]}
sql run 5
30 entities, listed in the JSON.
JSON: {"issuers": ["E1126", "E1132", "E1168", "E1066", "E1098", "E1266", "E1109", "E1006", "E1133", "E1203", "E1260", "E1317", "E1099", "E1037", "E1209", "E1013", "E1146", "E1181", "E1238", "E06", "E1297", "E1039", "E1242", "E1314", "E1264", "E1267", "E1061", "E1323", "E1088", "E1194"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E1126', 'E1132', 'E1168', 'E1066', 'E1098', 'E1266', 'E1109', 'E1006', 'E1133', 'E1203', 'E1260', 'E1317', 'E1099', 'E1037', 'E1209', 'E1013', 'E1146', 'E1181', 'E1238', 'E06', 'E1297', 'E1039', 'E1242', 'E1314', 'E1264', 'E1267', 'E1061', 'E1323', 'E1088', 'E1194']
sql+markdown run 1
32 issuers were on RWN on 1 Oct 2026, including E06; the list is in the JSON.
JSON: {"issuers": ["E1109", "E1168", "E1061", "E1238", "E1297", "E1013", "E1098", "E1126", "E06", "E1133", "E1088", "E1194", "E1267", "E1181", "E1099", "E1260", "E1132", "E1019", "E1006", "E1264", "E1039", "E1266", "E1059", "E1203", "E1146", "E1323", "E1066", "E1314", "E1317", "E1037", "E1209", "E1242"]}
sql+markdown run 2
32 issuers were on RWN on 2026-10-01, including E06; the IDs are in the JSON.
JSON: {"issuers": ["E1059", "E1266", "E1039", "E1013", "E1297", "E1238", "E1061", "E1099", "E1132", "E1260", "E1267", "E1098", "E1126", "E1019", "E1006", "E1264", "E1194", "E1088", "E1133", "E06", "E1317", "E1242", "E1037", "E1209", "E1168", "E1109", "E1181", "E1146", "E1203", "E1066", "E1314", "E1323"]}
sql+markdown run 3
32 issuers; the list is in the JSON and includes E06.
JSON: {"issuers": ["E1013", "E1297", "E1238", "E1061", "E1317", "E1242", "E1037", "E1209", "E1181", "E1133", "E06", "E1194", "E1088", "E1098", "E1126", "E1019", "E1006", "E1264", "E1146", "E1203", "E1066", "E1314", "E1323", "E1168", "E1109", "E1267", "E1059", "E1266", "E1039", "E1099", "E1132", "E1260"]}
sql+markdown run 4
See the list in the JSON. These are entities whose latest LTIDR action on or before 2026-10-01 carries an RWN watch, including E06 (A17).
JSON: {"issuers": ["E1039", "E1266", "E1059", "E1099", "E1132", "E1260", "E1013", "E1061", "E1297", "E1238", "E06", "E1133", "E1181", "E1037", "E1242", "E1317", "E1209", "E1098", "E1126", "E1088", "E1194", "E1267", "E1006", "E1019", "E1264", "E1066", "E1146", "E1203", "E1314", "E1323", "E1109", "E1168"]}
sql+markdown run 5
32 issuers were on Rating Watch Negative (list in the JSON). It includes E06 (A17).
JSON: {"issuers": ["E1039", "E1098", "E1099", "E1181", "E1088", "E1297", "E1066", "E1238", "E1168", "E1260", "E1061", "E1019", "E1264", "E1146", "E1194", "E1037", "E1132", "E1109", "E1314", "E1126", "E1317", "E1267", "E1203", "E1209", "E1323", "E1266", "E1059", "E1013", "E1242", "E1133", "E06", "E1006"]}
sparql run 1
E06 and a large block of E11xx–E13xx entities (listed in the JSON). I took the latest long-term rating action per currency basis as of 1 October 2026.
JSON: {"issuers": ["E06", "E1130", "E1186", "E1196", "E1202", "E1205", "E1206", "E1207", "E1208", "E1209", "E1210", "E1211", "E1212", "E1213", "E1214", "E1216", "E1217", "E1218", "E1219", "E1220", "E1221", "E1222", "E1223", "E1224", "E1225", "E1226", "E1227", "E1229", "E1230", "E1231", "E1232", "E1235", "E1236", "E1237", "E1238", "E1239", "E1240", "E1242", "E1243", "E1244", "E1245", "E1246", "E1247", "E1248", "E1249", "E1250", "E1251", "E1252", "E1253", "E1254", "E1255", "E1256", "E1257", "E1258", "E1259", "E1260", "E1261", "E1262", "E1263", "E1264", "E1265", "E1266", "E1267", "E1268", "E1269", "E1270", "E1271", "E1272", "E1273", "E1274", "E1275", "E1276", "E1277", "E1278", "E1279", "E1280", "E1281", "E1282", "E1283", "E1284", "E1285", "E1286", "E1287", "E1288", "E1289", "E1290", "E1291", "E1292", "E1293", "E1294", "E1295", "E1296", "E1297", "E1298", "E1299", "E1300", "E1301", "E1302", "E1303", "E1304", "E1305", "E1306", "E1307", "E1308", "E1309", "E1310", "E1311", "E1312", "E1313", "E1314", "E1315", "E1316", "E1317", "E1318", "E1319", "E1320", "E1321", "E1322", "E1323", "E1324"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E06', 'E1130', 'E1186', 'E1196', 'E1202', 'E1205', 'E1206', 'E1207', 'E1208', 'E1209', 'E1210', 'E1211', 'E1212', 'E1213', 'E1214', 'E1216', 'E1217', 'E1218', 'E1219', 'E1220', 'E1221', 'E1222', 'E1223', 'E1224', 'E1225', 'E1226', 'E1227', 'E1229', 'E1230', 'E1231', 'E1232', 'E1235', 'E1236', 'E1237', 'E1238', 'E1239', 'E1240', 'E1242', 'E1243', 'E1244', 'E1245', 'E1246', 'E1247', 'E1248', 'E1249', 'E1250', 'E1251', 'E1252', 'E1253', 'E1254', 'E1255', 'E1256', 'E1257', 'E1258', 'E1259', 'E1260', 'E1261', 'E1262', 'E1263', 'E1264', 'E1265', 'E1266', 'E1267', 'E1268', 'E1269', 'E1270', 'E1271', 'E1272', 'E1273', 'E1274', 'E1275', 'E1276', 'E1277', 'E1278', 'E1279', 'E1280', 'E1281', 'E1282', 'E1283', 'E1284', 'E1285', 'E1286', 'E1287', 'E1288', 'E1289', 'E1290', 'E1291', 'E1292', 'E1293', 'E1294', 'E1295', 'E1296', 'E1297', 'E1298', 'E1299', 'E1300', 'E1301', 'E1302', 'E1303', 'E1304', 'E1305', 'E1306', 'E1307', 'E1308', 'E1309', 'E1310', 'E1311', 'E1312', 'E1313', 'E1314', 'E1315', 'E1316', 'E1317', 'E1318', 'E1319', 'E1320', 'E1321', 'E1322', 'E1323', 'E1324']
sparql run 2
30 issuers (listed in the JSON), found from each entity's latest foreign-currency issuer rating on 1 Oct 2026.
JSON: {"issuers": ["E1006", "E1013", "E1037", "E1039", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323", "E06"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E1006', 'E1013', 'E1037', 'E1039', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1210', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323', 'E06']
sparql run 3
E06 (A17).
JSON: {"issuers": ["E06"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E06']
sparql run 4
E06 (A17). Other watches in the data were not confirmed as still active, so this list may be incomplete.
JSON: {"issuers": ["E06"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E06']
sparql run 5
The issuers on Rating Watch Negative on 1 October 2026 are in the JSON below.
JSON: {"issuers": ["E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323", "E06"]}
sparql+ontology run 1
(no answer found)
JSON: {"issuers": ["E06"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E06']
sparql+ontology run 2
Only partial: the result was truncated, so the JSON lists just the visible issuers on Rating Watch Negative.
JSON: {"issuers": ["E06", "E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181']
sparql+ontology run 3
12 issuers were on Rating Watch Negative on 2026-10-01: E06, E1006, E1013, E1039, E1059, E1066, E1098, E1146, E1158, E1161, E1190 and E1210. This is foreign-currency issuer ratings only.
JSON: {"issuers": ["E06", "E1006", "E1013", "E1039", "E1059", "E1066", "E1098", "E1146", "E1158", "E1161", "E1190", "E1210"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E06', 'E1006', 'E1013', 'E1039', 'E1059', 'E1066', 'E1098', 'E1146', 'E1158', 'E1161', 'E1190', 'E1210']
sparql+ontology run 4
32 issuers; the list is in the JSON.
JSON: {"issuers": ["E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1209", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323", "E06"]}
sparql+ontology run 5
Incomplete: the output was truncated, so these are only the visible entities on Rating Watch Negative, including E06.
JSON: {"issuers": ["E06", "E1006", "E1013", "E1037", "E1039", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323"]}
Why: issuers: expected ['E06', 'E1006', 'E1013', 'E1019', 'E1037', 'E1039', 'E1059', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323'], got ['E06', 'E1006', 'E1013', 'E1037', 'E1039', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194', 'E1203', 'E1210', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323']
sql+executed run 1
32 issuers were on RWN (listed in the JSON).
JSON: {"issuers": ["E1039", "E1059", "E1266", "E1099", "E1132", "E1260", "E1006", "E1019", "E1264", "E1066", "E1146", "E1203", "E1314", "E1323", "E06", "E1133", "E1088", "E1194", "E1098", "E1126", "E1037", "E1209", "E1242", "E1317", "E1267", "E1013", "E1061", "E1238", "E1297", "E1109", "E1168", "E1181"]}
sql+executed run 2
Thirty-two issuers were on Rating Watch Negative (listed in the JSON).
JSON: {"issuers": ["E06", "E1133", "E1006", "E1019", "E1264", "E1013", "E1061", "E1238", "E1297", "E1037", "E1209", "E1242", "E1317", "E1039", "E1059", "E1266", "E1109", "E1168", "E1088", "E1194", "E1099", "E1132", "E1260", "E1066", "E1146", "E1203", "E1314", "E1323", "E1181", "E1098", "E1126", "E1267"]}
sql+executed run 3
32 issuers were on Rating Watch Negative. The list is in the JSON.
JSON: {"issuers": ["E06", "E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1209", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323"]}
sql+executed run 4
32 entities were on Rating Watch Negative (RWN) on 1 Oct 2026, listed in the JSON, including E06 (A17). The list includes E1019, whose RWN is on its LC rating only.
JSON: {"issuers": ["E1317", "E1037", "E1242", "E1209", "E1013", "E1238", "E1061", "E1297", "E1099", "E1132", "E1260", "E1168", "E1109", "E1039", "E1059", "E1266", "E1126", "E1098", "E1194", "E1088", "E1133", "E06", "E1203", "E1146", "E1066", "E1314", "E1323", "E1006", "E1019", "E1264", "E1267", "E1181"]}
sql+executed run 5
32 issuers; see the JSON.
JSON: {"issuers": ["E06", "E1133", "E1066", "E1146", "E1203", "E1314", "E1323", "E1013", "E1061", "E1238", "E1297", "E1181", "E1006", "E1019", "E1264", "E1098", "E1126", "E1039", "E1059", "E1266", "E1099", "E1132", "E1260", "E1267", "E1109", "E1168", "E1088", "E1194", "E1037", "E1209", "E1242", "E1317"]}
sparql+axioms run 1
32 issuers are on RWN (listed in the JSON).
JSON: {"issuers": ["E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323", "E06"]}
sparql+axioms run 2
32 issuers, listed in the JSON.
JSON: {"issuers": ["E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323", "E06"]}
sparql+axioms run 3
The entities on Rating Watch Negative on 1 October 2026 are listed in the JSON; they include E06 and E1059 (an LC rating).
JSON: {"issuers": ["E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323", "E06"]}
sparql+axioms run 4
32 issuers, listed in the JSON.
JSON: {"issuers": ["E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323", "E06"]}
sparql+axioms run 5
The list is in the JSON. The query output was noisy, so treat it as best effort.
JSON: {"issuers": ["E06", "E1006", "E1013", "E1019", "E1037", "E1039", "E1059", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "E1194", "E1203", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323"]}