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

← back to the run

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']

❌ D4 sparql run 1 graded by code · query session

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']

❌ D4 sparql run 2 graded by code · query session

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']

❌ D4 sparql run 3 graded by code · query session

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']

✅ D4 sparql run 4 graded by code · query session

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"]}

✅ D4 sparql run 5 graded by code · query session

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"]}

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

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"]}

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

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"]}

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

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']

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

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']

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

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"]}

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

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"]}

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

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']

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

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"]}

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

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']

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

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"]}