Q18, run 2026-11-05-1819-sonnet-query-graphdb
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']
sparql run 1
30 issuers were on Rating Watch Negative on 1 October 2026 (see JSON).
JSON: {"issuers": ["E1203", "E1314", "E1194", "E1210", "E1260", "E1133", "E1146", "E1242", "E1066", "E1168", "E1297", "E1109", "E1061", "E1132", "E1088", "E06", "E1098", "E1266", "E1006", "E1267", "E1037", "E1013", "E1317", "E1181", "E1323", "E1099", "E1238", "E1264", "E1039", "E1126"]}
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 ['E1203', 'E1314', 'E1194', 'E1210', 'E1260', 'E1133', 'E1146', 'E1242', 'E1066', 'E1168', 'E1297', 'E1109', 'E1061', 'E1132', 'E1088', 'E06', 'E1098', 'E1266', 'E1006', 'E1267', 'E1037', 'E1013', 'E1317', 'E1181', 'E1323', 'E1099', 'E1238', 'E1264', 'E1039', 'E1126']
sparql run 2
E06 (A17). This list may be incomplete, because my query mishandled watch rows.
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 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
The entities whose latest rating on 1 October 2026 carried Rating Watch Negative are listed in the JSON, including E06.
JSON: {"issuers": ["E1203", "E1314", "E1194", "E1210", "E1260", "E1133", "E1146", "E1242", "E1066", "E1168", "E1297", "E1109", "E1061", "E1132", "E1088", "E06", "E1098", "E1266", "E1006", "E1267", "E1037", "E1013", "E1317", "E1181", "E1323", "E1059", "E1099", "E1238", "E1264", "E1039", "E1126", "E1019"]}
sparql run 5
The 32 entities in the JSON have a latest rating with Rating Watch Negative on 1 Oct 2026.
JSON: {"issuers": ["E1203", "E1314", "E1194", "E1210", "E1260", "E1133", "E1146", "E1242", "E1066", "E1168", "E1297", "E1109", "E1061", "E1132", "E1088", "E06", "E1098", "E1266", "E1006", "E1267", "E1037", "E1013", "E1317", "E1181", "E1323", "E1059", "E1099", "E1238", "E1264", "E1039", "E1126", "E1019"]}
sparql+ontology run 1
32 issuers, listed below.
JSON: {"issuers": ["E1203", "E1314", "E1194", "E1210", "E1260", "E1133", "E1146", "E1242", "E1066", "E1168", "E1297", "E1109", "E1061", "E1132", "E1088", "E06", "E1098", "E1266", "E1006", "E1267", "E1037", "E1013", "E1317", "E1181", "E1323", "E1059", "E1099", "E1238", "E1264", "E1039", "E1126", "E1019"]}
sparql+ontology run 2
Listed in the JSON.
JSON: {"issuers": ["E1181", "E1109", "E1203", "E1088", "E1238", "E1314", "E1194", "E1209", "E1099", "E1260", "E1297", "E1242", "E1006", "E1133", "E1146", "E1066", "E1168", "E1019", "E1061", "E1132", "E06", "E1098", "E1266", "E1126", "E1267", "E1037", "E1013", "E1317", "E1323", "E1059", "E1039", "E1264"]}
sparql+ontology run 3
E06 (A17). E14's Watch was resolved by the affirmation A33 on 2026-05-01.
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 4
27 issuers. This list is uncertain, because two query variants disagreed on membership.
JSON: {"issuers": ["E06", "E1088", "E1006", "E1066", "E1019", "E1061", "E1098", "E1013", "E1059", "E1039", "E1181", "E1109", "E1194", "E1133", "E1146", "E1132", "E1126", "E1238", "E1209", "E1260", "E1297", "E1242", "E1266", "E1264", "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', 'E1088', 'E1006', 'E1066', 'E1019', 'E1061', 'E1098', 'E1013', 'E1059', 'E1039', 'E1181', 'E1109', 'E1194', 'E1133', 'E1146', 'E1132', 'E1126', 'E1238', 'E1209', 'E1260', 'E1297', 'E1242', 'E1266', 'E1264', 'E1314', 'E1317', 'E1323']
sparql+ontology run 5
The list is in the JSON; it is the issuers whose latest action carries a Rating Watch Negative flag.
JSON: {"issuers": ["E1181", "E1109", "E1203", "E1088", "E1238", "E1314", "E1194", "E1210", "E1099", "E1260", "E1297", "E1242", "E1006", "E1133", "E1146", "E1066", "E1168", "E1019", "E1061", "E1132", "E06", "E1098", "E1266", "E1126", "E1267", "E1037", "E1013", "E1317", "E1323", "E1059", "E1039", "E1264"]}
sparql+axioms run 1
The 31 issuers returned are listed in the JSON, including E06. The list may be incomplete.
JSON: {"issuers": ["E1203", "E1314", "E1194", "E1210", "E1260", "E1133", "E1146", "E1242", "E1066", "E1168", "E1297", "E1109", "E1061", "E1132", "E1088", "E06", "E1098", "E1266", "E1006", "E1267", "E1037", "E1013", "E1317", "E1181", "E1323", "E1059", "E1099", "E1238", "E1264", "E1039", "E1126", "E1019"]}
sparql+axioms run 2
E06 (?), from A17; other entities not seen may be on watch too.
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+axioms run 3
32 issuers were on Rating Watch Negative. E1019 and E1059 are on watch for their local-currency ratings only. The list is in the JSON.
JSON: {"issuers": ["E1203", "E1314", "E1194", "E1210", "E1260", "E1133", "E1146", "E1242", "E1066", "E1168", "E1297", "E1109", "E1061", "E1132", "E1088", "E06", "E1098", "E1266", "E1006", "E1267", "E1037", "E1013", "E1317", "E1181", "E1323", "E1099", "E1238", "E1264", "E1039", "E1126", "E1059", "E1019"]}
sparql+axioms run 4
E06 is confirmed. My query for other issuers on watch was truncated, so the 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+axioms run 5
The 32 entities with a Rating Watch Negative in force are in the JSON.
JSON: {"issuers": ["E1203", "E1314", "E1194", "E1210", "E1260", "E1133", "E1146", "E1242", "E1066", "E1168", "E1297", "E1109", "E1061", "E1132", "E1088", "E06", "E1098", "E1266", "E1006", "E1267", "E1037", "E1013", "E1317", "E1181", "E1323", "E1059", "E1099", "E1238", "E1264", "E1039", "E1126", "E1019"]}