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

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

❌ D4 sparql run 1 graded by code · query session

E07 and E1279, whose ratings were withdrawn (A19, and a WD for E1279). This list is partial because I did not check every withdrawal.

JSON: {"entities": ["E07", "E1279"]}

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

✅ D4 sparql run 2 graded by code · query session

See JSON. These are the entities whose latest rating on every basis is WD.

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

❌ D4 sparql run 3 graded by code · query session

E07 is the one I confirmed (withdrawn by A19, 2026-05-12). The check across the other entities did not run.

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

✅ D4 sparql run 4 graded by code · query session

The entities whose latest issuer rating is a withdrawal are listed in the JSON (35 entities, including E07).

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

✅ D4 sparql run 5 graded by code · query session

The 35 entities in the JSON were rated before but had only a WD (withdrawn) rating on 1 Oct 2026.

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

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

35 entities, listed below.

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

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

Listed in the JSON.

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

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

E07 (A19).

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

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

A partial list: 22 entities whose latest action by 1 Oct 2026 was a withdrawal. The query output was truncated, so the list may be incomplete.

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

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', 'E1001', 'E1007', 'E1021', 'E1032', 'E1041', 'E1048', 'E1057', 'E1062', 'E1063', 'E1076', 'E1084', 'E1107', 'E1121', 'E1124', 'E1138', 'E1140', 'E1155', 'E1159', 'E1166', 'E1172', 'E1279']

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

The list is in the JSON; it is issuers whose latest issuer-rating action is a withdrawal. E1106's withdrawal is local-currency only and it may still hold a foreign-currency rating, so I left it out.

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

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

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

E07, whose rating was withdrawn. The check was not exhaustive.

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

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

E07 (?). Its rating was withdrawn (A19). A44 for E16 is oddly not in force, but I excluded it.

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

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

49 entities. They had issuer-rating actions but none in force on 1 October 2026, counting a rating held under a twin record. The list is in the JSON.

JSON: {"entities": ["E1002", "E1084", "E1032", "E1234", "E1219", "E1206", "E1107", "E1244", "E1172", "E1159", "E1057", "E1041", "E1347", "E07", "E1062", "E1343", "E1277", "E1350", "E1345", "E1341", "E1155", "E1349", "E1254", "E1121", "E1063", "E1166", "E1021", "E1342", "E1200", "E1351", "E1048", "E1124", "E1340", "E1076", "E1138", "E16", "E1348", "E1140", "E1316", "E1346", "E1344", "E1308", "E1007", "E1218", "E1225", "E1205", "E1320", "E1233", "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', 'E1084', 'E1032', 'E1234', 'E1219', 'E1206', 'E1107', 'E1244', 'E1172', 'E1159', 'E1057', 'E1041', 'E1347', 'E07', 'E1062', 'E1343', 'E1277', 'E1350', 'E1345', 'E1341', 'E1155', 'E1349', 'E1254', 'E1121', 'E1063', 'E1166', 'E1021', 'E1342', 'E1200', 'E1351', 'E1048', 'E1124', 'E1340', 'E1076', 'E1138', 'E16', 'E1348', 'E1140', 'E1316', 'E1346', 'E1344', 'E1308', 'E1007', 'E1218', 'E1225', 'E1205', 'E1320', 'E1233', 'E5170']

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

E07 is the only one I can confirm (rating withdrawn, A19). The check was truncated, so there may be others.

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

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

The 49 entities in the JSON had an issuer rating at some point but none in force on 1 October 2026. The query excluded records whose same-entity twin still has a rating.

JSON: {"entities": ["E1084", "E1032", "E1234", "E1219", "E1107", "E1244", "E1172", "E1347", "E1062", "E1343", "E1350", "E1345", "E1341", "E1349", "E1155", "E1166", "E1342", "E1200", "E1351", "E1277", "E1124", "E1340", "E1076", "E1138", "E16", "E1348", "E1041", "E1159", "E1140", "E1346", "E1002", "E1344", "E1121", "E1308", "E1007", "E1316", "E07", "E1206", "E1225", "E1057", "E1205", "E1320", "E1063", "E1233", "E1254", "E5170", "E1218", "E1048", "E1021"]}

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 ['E1084', 'E1032', 'E1234', 'E1219', 'E1107', 'E1244', 'E1172', 'E1347', 'E1062', 'E1343', 'E1350', 'E1345', 'E1341', 'E1349', 'E1155', 'E1166', 'E1342', 'E1200', 'E1351', 'E1277', 'E1124', 'E1340', 'E1076', 'E1138', 'E16', 'E1348', 'E1041', 'E1159', 'E1140', 'E1346', 'E1002', 'E1344', 'E1121', 'E1308', 'E1007', 'E1316', 'E07', 'E1206', 'E1225', 'E1057', 'E1205', 'E1320', 'E1063', 'E1233', 'E1254', 'E5170', 'E1218', 'E1048', 'E1021']