Q18, run 2026-11-06-0041-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 (see the JSON), each with a foreign-currency Rating Watch Negative as their latest action on 1 Oct 2026.

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

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

❌ D1 sql run 2 graded by code · query session

30 issuers were on Rating Watch Negative on 1 October 2026 (see the JSON list).

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

✅ D1 sql run 3 graded by code · query session

32 issuers were on Rating Watch Negative on 1 October 2026 (IDs in the JSON). Each has a latest LTIDR action that is a watch.

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

✅ D1 sql run 4 graded by code · query session

32 issuers, listed in the JSON. This includes E1019 and E1059, whose watch is on the local-currency rating only.

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

❌ D1 sql run 5 graded by code · query session

30 issuers, based on foreign-currency ratings only. I did not check hidden local-currency-only watches, such as the E1019 and E1059 local-currency watches.

JSON: {"issuers": ["E06", "E1006", "E1013", "E1037", "E1039", "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"]}

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', 'E1209', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317', 'E1323']

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

32 issuers were on RWN, listed in the JSON. This includes E06 and LC-only watches.

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

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

32 issuers are on RWN, listed in the JSON. This includes E1019 and E1059, which are on watch for LC only.

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

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

32 issuers were on Rating Watch Negative (RWN) on 2026-10-01, listed in the JSON, including E06.

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

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

32 issuers were on Rating Watch Negative on 2026-10-01 (listed in the JSON), including E06.

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

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

32 issuers were on Rating Watch Negative on 2026-10-01 (listed in the JSON, including E06).

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

✅ D4 sparql run 1 graded by code · query session

The 32 issuers on Rating Watch Negative are 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", "E06", "E1297", "E1314", "E1317", "E1323"]}

✅ D4 sparql run 2 graded by code · query session

The JSON list is incomplete. My result set was cut off, so about 9 rows were not shown. It is based on the latest action per entity being a Rating Watch Negative.

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

❌ D4 sparql run 3 graded by code · query session

Incomplete. Visible issuers with a latest foreign-currency action of Rating Watch Negative are listed in the JSON. About 47 further rows were truncated.

JSON: {"issuers": ["E06", "E1006", "E1013", "E1037", "E1039", "E1061", "E1066", "E1088", "E1098", "E1099", "E1109", "E1126", "E1132", "E1133", "E1146", "E1168", "E1181", "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 ['E06', 'E1006', 'E1013', 'E1037', 'E1039', 'E1061', 'E1066', 'E1088', 'E1098', 'E1099', 'E1109', 'E1126', 'E1132', 'E1133', 'E1146', 'E1168', 'E1181', 'E1194']

✅ D4 sparql run 4 graded by code · query session

The issuers whose latest action carries Rating Watch Negative (list in the JSON). It includes E06.

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 5 graded by code · query session

30 entities, listed in the JSON, e.g. E06, E1006.

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

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

32 issuers were on Rating Watch Negative on 2026-10-01, listed in the JSON. They include E1019 and E1059, whose local-currency ratings are on Watch.

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 2 graded by code · query session

Issuers whose latest action by 1 Oct 2026 was a Rating Watch Negative are in the JSON. E1019 and E1059 are on watch for their local-currency ratings.

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

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

32 issuers, listed in the JSON. Each has a Watch as its latest action on its currency basis, with no later action up to 2026-10-01.

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 4 graded by code · query session

31 issuers, listed in the JSON, were on RWN on 1 Oct 2026. Their latest action on the same LEI and basis carries a Watch. Two of them are LC-basis watches, E1019 and E1059.

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 5 graded by code · query session

32 issuers.

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 RWN on 1 October 2026; they are in the JSON.

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

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

32 issuers were on Rating Watch Negative on 1 October 2026; the IDs are 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"]}

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

32 issuers were on RWN on 2026-10-01; they are listed in the JSON.

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

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

32 issuers carry an open Rating Watch Negative, listed in the JSON, including E06.

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

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

32 issuers were on RWN on 1 October 2026, listed in the JSON. This includes E1019 and E1059, whose watch is on the local-currency rating only.

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

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

The 32 issuers below were on RWN. The result was truncated by one row, so one may be missing.

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

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', 'E1194', 'E1203', 'E1210', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317']

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

The 32 entities in the JSON list, with watch-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 3 graded by code · query session

The issuers on Rating Watch Negative on 1 Oct 2026 are listed in the JSON (32 entities).

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

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

The entities carrying a Negative watch in force on 1 Oct 2026 (list 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", "E1210", "E1238", "E1242", "E1260", "E1264", "E1266", "E1267", "E1297", "E1314", "E1317", "E1323"]}

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

The in-force Rating Watch Negative list is in the JSON. One further row was truncated and is not included.

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

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', 'E1194', 'E1203', 'E1210', 'E1238', 'E1242', 'E1260', 'E1264', 'E1266', 'E1267', 'E1297', 'E1314', 'E1317']