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

← back to the run

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

35 entities (see the JSON). They had a rating that was later withdrawn, with no later rating before 2026-10-01.

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

✅ D1 sql run 2 graded by code · query session

35 entities, including E07, E1225 and E1200. These all have a withdrawn LTIDR; the full list is in the JSON.

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

❌ D1 sql run 3 graded by code · query session

36 entities, listed in the JSON. Their latest foreign-currency issuer action on or before 1 Oct 2026 was a withdrawal.

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

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', 'E1244', 'E1057', 'E1308', 'E1007', 'E1159', 'E1032', 'E1155', 'E1206', 'E1320', 'E1219', 'E1218', 'E1233', 'E1200', 'E1225', 'E1234', 'E1021', 'E1279', 'E07', 'E1166', 'E1084', 'E1048', 'E1062', 'E1121', 'E1205', 'E1107', 'E1041', 'E1140', 'E1138', 'E1063', 'E1002', 'E1076', 'E1277', 'E1254', 'E1172', 'E1124']

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

E07. It had a rating (A18) and then a withdrawal (A19), so it has no issuer rating on 2026-10-01.

JSON: {"entities": ["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 ['E07']

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

35 entities (list in JSON).

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

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

35 entities, listed in the JSON.

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

❌ D4 sparql run 1 graded by code · query session

The known withdrawals are listed in the JSON. Part of the query output was truncated, so the list may be incomplete.

JSON: {"entities": ["E07", "E1007", "E1032", "E1057", "E1155", "E1159", "E1172", "E1218", "E1219", "E1234"]}

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', 'E1007', 'E1032', 'E1057', 'E1155', 'E1159', 'E1172', 'E1218', 'E1219', 'E1234']

❌ D4 sparql run 2 graded by code · query session

The 36 entities whose latest rating is a withdrawal are in the JSON.

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", "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', '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 3 graded by code · query session

Partial list. These entities have a latest action of WD (withdrawn); it is not a full scan.

JSON: {"entities": ["E07", "E1007", "E1032", "E1057", "E1155", "E1159", "E1172"]}

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', 'E1007', 'E1032', 'E1057', 'E1155', 'E1159', 'E1172']

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

36 entities, listed in the JSON. Each one's latest issuer action is a withdrawal, including E07. I left out E1106, which was withdrawn on local currency only and still has a foreign-currency rating.

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", "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', '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 entities whose latest LTIDR action by 1 Oct 2026 was a withdrawal are in the JSON (36 records). I left out E1106, whose LC rating was withdrawn but which still holds an FC rating.

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", "E1279", "E1308", "E1316", "E1320"]}

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', 'E1159', 'E1166', 'E1172', 'E1200', 'E1205', 'E1206', 'E1218', 'E1219', 'E1225', 'E1233', 'E1234', 'E1244', 'E1254', 'E1277', 'E1279', 'E1308', 'E1316', 'E1320']

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

36 entities, listed in the JSON. Each had an LTIDR and has a withdrawal as its latest action. I left out E1106 because its FC rating is still active.

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", "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 ['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', 'E1279', 'E1308', 'E1316', 'E1320', 'E07']

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

35 entities; the IDs are in the JSON and include E07.

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

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

36 entities had an FC LTIDR before but have none in force now (withdrawn or ended); they are listed in the JSON.

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

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 ['E1007', 'E1032', 'E1057', 'E1155', 'E1159', 'E1253', 'E1308', 'E1121', 'E1205', 'E1206', 'E1219', 'E1320', 'E1244', 'E1316', 'E1062', 'E1277', 'E1218', 'E07', 'E1021', 'E1166', 'E1279', 'E1001', 'E1124', 'E1172', 'E1048', 'E1084', 'E1041', 'E1063', 'E1107', 'E1138', 'E1140', 'E1200', 'E1225', 'E1233', 'E1234', 'E1076']

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

35 entities, listed in the JSON, including E07. Each had a non-WD issuer rating at some point but none in force on 1 October 2026.

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

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

The 36 entities listed in the JSON. I excluded E16 and E1340–E1351 because their latest actions look like current ratings that the in-force class failed to pick up. This answer is uncertain.

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

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', 'E1308', 'E1316', 'E1320', 'E07', 'E5170']

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

Taken from the query of entities with an LTIDR action but none in force on 1 Oct 2026. I dropped E02 because it is the same entity as E03, which is still rated.

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", "E1340", "E1341", "E1342", "E1343", "E1344", "E1345", "E1346", "E1347", "E1348", "E1349", "E1350", "E1351", "E07", "E16", "E5170"]}

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', 'E1308', 'E1316', 'E1320', 'E1340', 'E1341', 'E1342', 'E1343', 'E1344', 'E1345', 'E1346', 'E1347', 'E1348', 'E1349', 'E1350', 'E1351', 'E07', 'E16', 'E5170']

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

E07, whose rating was withdrawn on 2026-05-12.

JSON: {"entities": ["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 ['E07']