Q21, run 2026-11-04-1738-sonnet-query

Which entities had an issuer rating at some point but no longer had one on 1 October 2026?

Tests: Withdrawals: a withdrawn rating is no rating.

Expected: entities = ['E07', 'E1001', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1253', 'E1277', 'E1308', 'E1316', 'E1320']

✅ D1 sql run 1 graded by code · query session

The 35 entities are in the JSON. They had an issuer rating at some point, but their latest action by 1 Oct 2026 is a withdrawal (WD).

JSON: {"entities": ["E1244", "E1316", "E1205", "E1121", "E1253", "E1032", "E1159", "E1007", "E1308", "E1057", "E1155", "E1277", "E07", "E1166", "E1021", "E1218", "E1076", "E1048", "E1084", "E1233", "E1225", "E1234", "E1200", "E1320", "E1206", "E1219", "E1138", "E1107", "E1063", "E1140", "E1041", "E1062", "E1124", "E1172", "E1001"]}

✅ D1 sql run 2 graded by code · query session

35 entities, listed in the JSON, whose latest action is a withdrawal (WD) and who held a rating earlier.

JSON: {"entities": ["E1057", "E1308", "E1007", "E1032", "E1155", "E1159", "E1253", "E1107", "E1140", "E1138", "E1063", "E1041", "E1218", "E1316", "E1244", "E1121", "E1205", "E1021", "E1166", "E07", "E1084", "E1048", "E1277", "E1225", "E1234", "E1233", "E1200", "E1001", "E1172", "E1124", "E1206", "E1219", "E1320", "E1076", "E1062"]}

✅ D1 sql run 3 graded by code · query session

34 entities, listed in the JSON. Each had an issuer rating that was later withdrawn, and no rating on any currency basis remains on 1 October 2026. I excluded E1106 and E1279, which still hold a rating on the other currency basis, and E08, which holds RD.

JSON: {"entities": ["E07", "E1002", "E1007", "E1021", "E1032", "E1041", "E1048", "E1057", "E1062", "E1063", "E1076", "E1084", "E1107", "E1121", "E1124", "E1138", "E1140", "E1155", "E1159", "E1166", "E1172", "E1200", "E1205", "E1206", "E1218", "E1219", "E1225", "E1233", "E1234", "E1244", "E1254", "E1277", "E1308", "E1316", "E1320"]}

✅ D1 sql run 4 graded by code · query session

The 35 entities listed in the JSON, whose latest issuer rating by 2026-10-01 was a withdrawal. E1279 is excluded because it still had a local-currency rating.

JSON: {"entities": ["E1007", "E1254", "E1308", "E1124", "E1320", "E1002", "E1021", "E1041", "E1140", "E1219", "E1244", "E1172", "E1048", "E1107", "E1032", "E1062", "E1138", "E1159", "E1166", "E1205", "E1234", "E1316", "E1057", "E1063", "E1155", "E07", "E1084", "E1200", "E1218", "E1277", "E1121", "E1225", "E1233", "E1076", "E1206"]}

✅ D1 sql run 5 graded by code · query session

35 entities, listed in the JSON, held an issuer rating at some point but had only a withdrawal as their latest action by 2026-10-01.

JSON: {"entities": ["E1218", "E1107", "E1063", "E1138", "E1041", "E1140", "E1206", "E1320", "E1219", "E1062", "E1316", "E1244", "E1121", "E1205", "E1155", "E1032", "E1007", "E1308", "E1253", "E1057", "E1159", "E1076", "E1084", "E1048", "E1166", "E07", "E1021", "E1277", "E1225", "E1233", "E1234", "E1200", "E1172", "E1001", "E1124"]}

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

35 entities, listed in the JSON. Each held an LTIDR or STIDR at some point but had none on 2026-10-01, mostly through withdrawal.

JSON: {"entities": ["E1206", "E1320", "E1219", "E1076", "E1218", "E1001", "E1172", "E1124", "E1062", "E1225", "E1233", "E1234", "E1200", "E1032", "E1159", "E1057", "E1155", "E1253", "E1007", "E1308", "E1205", "E1121", "E1316", "E1244", "E1021", "E07", "E1166", "E1277", "E1048", "E1084", "E1138", "E1041", "E1063", "E1107", "E1140"]}

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

35 entities had an issuer rating that was later withdrawn, listed in the JSON below. Each had a withdrawn latest rating on 2026-10-01 and no active issuer rating of any basis.

JSON: {"entities": ["E1206", "E1320", "E1219", "E1218", "E1225", "E1233", "E1200", "E1234", "E1076", "E1121", "E1205", "E1062", "E1244", "E1316", "E1063", "E1138", "E1140", "E1041", "E1107", "E1277", "E1166", "E07", "E1021", "E1172", "E1124", "E1001", "E1048", "E1084", "E1007", "E1253", "E1032", "E1308", "E1155", "E1057", "E1159"]}

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

35 entities had an issuer rating that was later withdrawn and not replaced, listed in the JSON (E07 among them).

JSON: {"entities": ["E07", "E1001", "E1007", "E1021", "E1032", "E1041", "E1048", "E1057", "E1062", "E1063", "E1076", "E1084", "E1107", "E1121", "E1124", "E1138", "E1140", "E1155", "E1159", "E1166", "E1172", "E1200", "E1205", "E1206", "E1218", "E1219", "E1225", "E1233", "E1234", "E1244", "E1253", "E1277", "E1308", "E1316", "E1320"]}

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

Thirty-five entities (listed in the JSON), all with a withdrawal as their latest action and no later rating.

JSON: {"entities": ["E1320", "E1206", "E1219", "E1316", "E1244", "E1205", "E1121", "E1048", "E1084", "E1166", "E07", "E1021", "E1277", "E1234", "E1225", "E1233", "E1200", "E1218", "E1063", "E1138", "E1107", "E1041", "E1140", "E1062", "E1007", "E1032", "E1159", "E1253", "E1308", "E1057", "E1155", "E1172", "E1124", "E1001", "E1076"]}

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

The list is in the JSON.

JSON: {"entities": ["E1048", "E1084", "E1206", "E1219", "E1320", "E1062", "E1007", "E1032", "E1057", "E1155", "E1159", "E1253", "E1308", "E07", "E1021", "E1166", "E1041", "E1063", "E1107", "E1138", "E1140", "E1218", "E1277", "E1244", "E1316", "E1200", "E1225", "E1233", "E1234", "E1121", "E1205", "E1001", "E1124", "E1172", "E1076"]}

✅ D4 sparql run 1 graded by code · query session

35 entities (IDs in the JSON). These are entities with a rating history whose last long-term issuer rating on 2026-10-01 is a withdrawal or nothing, shown by LEI.

JSON: {"entities": ["E1002", "E1007", "E1021", "E1032", "E1041", "E1048", "E1057", "E1062", "E1063", "E1076", "E1084", "E1107", "E1121", "E1124", "E1138", "E1140", "E1155", "E1159", "E1166", "E1172", "E1200", "E1205", "E1206", "E1218", "E1219", "E1225", "E1233", "E1234", "E1244", "E1254", "E1277", "E1308", "E1316", "E1320", "E07"]}

✅ D4 sparql run 2 graded by code · query session

35 entities, listed in the JSON. Their latest LTIDR action is WD. I left out E1106 and E1279, which withdrew one currency basis but still hold a rating on the other.

❌ D4 sparql run 3 graded by code · query session

The list in the JSON is incomplete. These are entities whose latest action is a withdrawal.

JSON: {"entities": ["E07", "E1002", "E1007", "E1021", "E1032", "E1041", "E1048", "E1057", "E1062", "E1063", "E1076", "E1084", "E1107", "E1121", "E1124", "E1138", "E1140", "E1155"]}

Why: entities: expected ['E07', 'E1001', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1253', 'E1277', 'E1308', 'E1316', 'E1320'], got ['E07', 'E1002', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155']

❌ D4 sparql run 4 graded by code · query session

36 entities, listed in the JSON, whose latest issuer-rating action by 1 October 2026 was a withdrawal. This includes E07.

Why: entities: expected ['E07', 'E1001', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1253', 'E1277', 'E1308', 'E1316', 'E1320'], got ['E1002', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1254', 'E1277', 'E1279', 'E1308', 'E1316', 'E1320', 'E07']

❌ D4 sparql run 5 graded by code · query session

37 entities, listed in the JSON, including E07. Their latest rating before 2026-10-01 is a withdrawal, or they had no valid rating by that date.

JSON: {"entities": ["E1002", "E1007", "E1021", "E1032", "E1041", "E1048", "E1057", "E1062", "E1063", "E1076", "E1084", "E1106", "E1107", "E1121", "E1124", "E1138", "E1140", "E1155", "E1159", "E1166", "E1172", "E1200", "E1205", "E1206", "E1218", "E1219", "E1225", "E1233", "E1234", "E1244", "E1254", "E1277", "E1279", "E1308", "E1316", "E1320", "E07"]}

Why: entities: expected ['E07', 'E1001', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1253', 'E1277', 'E1308', 'E1316', 'E1320'], got ['E1002', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1106', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1254', 'E1277', 'E1279', 'E1308', 'E1316', 'E1320', 'E07']

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

The 37 entities in the JSON have a latest long-term action of WD. This includes E07 (A19) and excludes E1106, which was withdrawn on local currency only and still has a foreign-currency rating.

Why: entities: expected ['E07', 'E1001', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1253', 'E1277', 'E1308', 'E1316', 'E1320'], got ['E1002', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1254', 'E1277', 'E1279', 'E1308', 'E1316', 'E1320', 'E07']

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

The 36 entities are in the JSON, with E1001 standing for its RESEARCH duplicate E1002. Each has a withdrawal as its latest issuer-rating action by 2026-10-01. E08 is excluded because RD is a default, not a withdrawal.

JSON: {"entities": ["E1316", "E1032", "E1057", "E1159", "E1233", "E1107", "E1001", "E1155", "E1277", "E1205", "E1140", "E1021", "E1084", "E1172", "E1308", "E1041", "E1320", "E1062", "E1225", "E1138", "E1200", "E1076", "E1279", "E1166", "E1234", "E1206", "E1121", "E1007", "E1124", "E1219", "E1048", "E1218", "E1063", "E07", "E1254", "E1244"]}

Why: entities: expected ['E07', 'E1001', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1253', 'E1277', 'E1308', 'E1316', 'E1320'], got ['E1316', 'E1032', 'E1057', 'E1159', 'E1233', 'E1107', 'E1001', 'E1155', 'E1277', 'E1205', 'E1140', 'E1021', 'E1084', 'E1172', 'E1308', 'E1041', 'E1320', 'E1062', 'E1225', 'E1138', 'E1200', 'E1076', 'E1279', 'E1166', 'E1234', 'E1206', 'E1121', 'E1007', 'E1124', 'E1219', 'E1048', 'E1218', 'E1063', 'E07', 'E1254', 'E1244']

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

35 entities had an issuer rating that was later withdrawn and had none on 2026-10-01; they are listed in the JSON.

JSON: {"entities": ["E07", "E1001", "E1032", "E1062", "E1076", "E1124", "E1138", "E1140", "E1200", "E1316", "E1048", "E1121", "E1155", "E1159", "E1205", "E1206", "E1218", "E1219", "E1225", "E1233", "E1254", "E1277", "E1320", "E1007", "E1041", "E1057", "E1063", "E1084", "E1107", "E1166", "E1172", "E1234", "E1244", "E1308", "E1021"]}

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

35 entities, listed in the JSON, are those whose latest rating action is a withdrawal.

JSON: {"entities": ["E1001", "E1007", "E1021", "E1032", "E1041", "E1048", "E1057", "E1062", "E1063", "E1076", "E1084", "E1107", "E1121", "E1124", "E1138", "E1140", "E1155", "E1159", "E1166", "E1172", "E1200", "E1205", "E1206", "E1218", "E1219", "E1225", "E1233", "E1234", "E1244", "E1253", "E1277", "E1308", "E1316", "E1320", "E07"]}

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

35 entities, listed in the JSON. Each had an LTIDR at some point, and its latest action on every basis is a withdrawal.