Q18, run 2026-11-04-2024-sonnet-query

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

❌ D1 sql run 1 graded by code · query session

30 issuers were on RWN on 2026-10-01 (see the JSON). I mapped the research duplicate E1210 to E1209.

JSON: {"issuers": ["E1099", "E1260", "E1132", "E1264", "E1006", "E1039", "E1266", "E1317", "E1037", "E1242", "E1267", "E1297", "E1061", "E1238", "E1013", "E1066", "E1314", "E1203", "E1146", "E1323", "E1133", "E06", "E1088", "E1194", "E1126", "E1098", "E1209", "E1181", "E1109", "E1168"]}

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 ['E1099', 'E1260', 'E1132', 'E1264', 'E1006', 'E1039', 'E1266', 'E1317', 'E1037', 'E1242', 'E1267', 'E1297', 'E1061', 'E1238', 'E1013', 'E1066', 'E1314', 'E1203', 'E1146', 'E1323', 'E1133', 'E06', 'E1088', 'E1194', 'E1126', 'E1098', 'E1209', 'E1181', 'E1109', 'E1168']

✅ D1 sql run 2 graded by code · query session

32 issuers were on RWN on 1 Oct 2026, including E06, E1006 and E1266. The full list is in the JSON.

JSON: {"issuers": ["E1266", "E1039", "E1059", "E1006", "E1264", "E1019", "E1109", "E1168", "E1317", "E1037", "E1242", "E1066", "E1314", "E1146", "E1203", "E1323", "E1238", "E1297", "E1061", "E1013", "E1210", "E1181", "E1133", "E06", "E1088", "E1194", "E1126", "E1098", "E1267", "E1132", "E1099", "E1260"]}

✅ D1 sql run 3 graded by code · query session

32 issuers were on RWN; they are listed in the JSON.

JSON: {"issuers": ["E06", "E1133", "E1006", "E1264", "E1019", "E1297", "E1238", "E1013", "E1061", "E1037", "E1317", "E1242", "E1039", "E1266", "E1059", "E1109", "E1168", "E1194", "E1088", "E1099", "E1260", "E1132", "E1066", "E1146", "E1323", "E1203", "E1314", "E1181", "E1210", "E1098", "E1126", "E1267"]}

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

E06. A17 (2026-09-03) put it on RWN.

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

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

32 issuers had a latest action carrying RWN on 1 Oct 2026 (list in JSON).

JSON: {"issuers": ["E1059", "E1109", "E1168", "E1194", "E1209", "E1242", "E06", "E1039", "E1088", "E1098", "E1146", "E1013", "E1061", "E1126", "E1133", "E1317", "E1019", "E1037", "E1203", "E1267", "E1006", "E1297", "E1099", "E1260", "E1132", "E1181", "E1323", "E1238", "E1066", "E1314", "E1264", "E1266"]}

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

32 issuers were on Rating Watch Negative, listed in the JSON.

JSON: {"issuers": ["E1006", "E1297", "E1264", "E1266", "E1132", "E1181", "E1323", "E1317", "E1066", "E1314", "E1013", "E1061", "E1126", "E1133", "E06", "E1039", "E1088", "E1098", "E1146", "E1099", "E1260", "E1019", "E1037", "E1203", "E1267", "E1059", "E1109", "E1168", "E1194", "E1209", "E1242", "E1238"]}

✅ D4 sparql run 1 graded by code · query session

The issuers on Rating Watch Negative are 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"]}

❌ D4 sparql run 2 graded by code · query session

The 30 issuers on Rating Watch Negative are in the JSON.

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

✅ D4 sparql run 3 graded by code · query session

(no answer found)

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", "E06", "E1297", "E1314", "E1317", "E1323"]}

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

32 issuers, listed in the JSON. Their latest action on or before 2026-10-01 carries an RWN watch, including E06 and E1006.

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

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

The issuers whose latest LTIDR action on 1 Oct 2026 carried Rating Watch Negative are in the JSON (32 records).

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

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

32 issuers, listed in the JSON. These are entities whose latest LTIDR action on or before 1 Oct 2026 carries RWN.

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

✅ D3 sql+executed run 1 graded by code · query session

32 issuers were on Rating Watch Negative; the IDs are in the JSON.

JSON: {"issuers": ["E1039", "E1059", "E1266", "E1037", "E1209", "E1242", "E1317", "E1181", "E1006", "E1019", "E1264", "E1099", "E1132", "E1260", "E1267", "E1109", "E1168", "E1066", "E1146", "E1203", "E1314", "E1323", "E06", "E1133", "E1088", "E1194", "E1098", "E1126", "E1013", "E1061", "E1238", "E1297"]}

✅ D3 sql+executed run 2 graded by code · query session

32 issuers are on RWN; they are listed in the JSON.

JSON: {"issuers": ["E1013", "E1061", "E1238", "E1297", "E1109", "E1168", "E1099", "E1132", "E1260", "E1006", "E1019", "E1264", "E06", "E1133", "E1088", "E1194", "E1066", "E1146", "E1203", "E1314", "E1323", "E1037", "E1209", "E1242", "E1317", "E1181", "E1098", "E1126", "E1267", "E1039", "E1059", "E1266"]}

✅ D3 sql+executed run 3 graded by code · query session

32 issuers, listed in the JSON, including E06.

JSON: {"issuers": ["E06", "E1133", "E1109", "E1168", "E1006", "E1019", "E1264", "E1037", "E1209", "E1242", "E1317", "E1039", "E1059", "E1266", "E1098", "E1126", "E1181", "E1013", "E1061", "E1238", "E1297", "E1267", "E1088", "E1194", "E1066", "E1146", "E1203", "E1314", "E1323", "E1099", "E1132", "E1260"]}

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

The 32 entities with an issuer rating on RWN in force.

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

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

Only the in-force RWN issuers I could see are listed. About 20 more rows were truncated, so the list is incomplete.

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

❌ D6 sparql+axioms 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']