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

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

✅ R1 csv run 1 graded by code

35 entities, listed in the JSON, whose issuer rating was withdrawn (WD) on or before 2026-10-01, for example E07 (A19) and E1032 (A1067).

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

✅ R1 csv run 2 graded by code

35 entities, listed in the JSON, whose latest action is a withdrawal (WD) dated on or before the cutoff, e.g. E07 (A19) and E1001 (A1002 on duplicate E1002).

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

✅ R1 csv run 3 graded by code

35 entities, listed in the JSON. Their last action by 2026-10-01 is a withdrawal. E1279 is excluded because it still has a local-currency rating.

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

❌ R1 csv run 4 graded by code

36 entities had an issuer rating that was later withdrawn (list in the JSON).

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

❌ R1 csv run 5 graded by code

Entities that had an issuer rating but whose latest action by 1 October 2026 was a withdrawal: E07 and 35 others, listed in the JSON. This includes E07 (A19).

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

✅ R4 csv+markdown run 1 graded by code

E07 plus 34 numbered entities, listed in the JSON, whose latest action is a withdrawal. E1279 and E1106 are excluded because their LC ratings are still active.

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

✅ R4 csv+markdown run 2 graded by code

35 entities. These are E07 and 34 others whose last rating action by 2026-10-01 was a WD. The IDs are in the JSON.

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

✅ R4 csv+markdown run 3 graded by code

35 entities. Each was assigned a long-term rating and ended with a withdrawal as its last action. The IDs are in the JSON; E1001 stands in for the E1002 research record.

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

✅ R4 csv+markdown run 4 graded by code

35 entities. Each had an issuer rating whose latest action is a withdrawal. E1279 and E1106 are excluded because they still have an LC rating.

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

✅ R4 csv+markdown run 5 graded by code

35 entities had an issuer rating at some point but none on 2026-10-01, because their last action on every basis is a withdrawal (see the JSON list).

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

✅ R10 executed run 1 graded by code

35 entities, all of them withdrawn with no later rating (WD rows still open).

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

✅ R10 executed run 2 graded by code

35 entities. Each one's last open rating is WD, with no other open rating.

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

✅ R10 executed run 3 graded by code

35 entities had a rating that ended in withdrawal; they are listed in the JSON. E1106 and E1279 are excluded because each still holds a rating on another currency basis.

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

✅ R10 executed run 4 graded by code

35 entities had a rating that was later withdrawn and not replaced (listed in the JSON). E1106 and E1279 are excluded because each keeps an open rating in the other currency basis.

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

✅ R10 executed run 5 graded by code

35 entities (listed in the JSON). Each has a withdrawal as its latest row and no later reinstatement.

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