Q21, run 2026-11-06-0041-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']
sql run 1
37 entities (see the JSON), each of which had an issuer rating that was later withdrawn (WD) before 1 Oct 2026.
JSON: {"entities": ["E1057", "E1063", "E1155", "E1107", "E1007", "E1254", "E1308", "E1032", "E1062", "E1138", "E1159", "E1279", "E1106", "E07", "E1084", "E1200", "E1218", "E1277", "E1172", "E1124", "E1320", "E1121", "E1225", "E1233", "E1002", "E1021", "E1041", "E1140", "E1219", "E1244", "E1076", "E1206", "E1166", "E1205", "E1234", "E1316", "E1048"]}
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 ['E1057', 'E1063', 'E1155', 'E1107', 'E1007', 'E1254', 'E1308', 'E1032', 'E1062', 'E1138', 'E1159', 'E1279', 'E1106', 'E07', 'E1084', 'E1200', 'E1218', 'E1277', 'E1172', 'E1124', 'E1320', 'E1121', 'E1225', 'E1233', 'E1002', 'E1021', 'E1041', 'E1140', 'E1219', 'E1244', 'E1076', 'E1206', 'E1166', 'E1205', 'E1234', 'E1316', 'E1048']
sql run 2
37 entities had their rating withdrawn (WD) by 1 October 2026 (see the JSON list).
JSON: {"entities": ["E1244", "E1316", "E1076", "E07", "E1021", "E1166", "E1279", "E1048", "E1084", "E1200", "E1225", "E1233", "E1234", "E1254", "E1041", "E1063", "E1107", "E1138", "E1140", "E1218", "E1106", "E1121", "E1205", "E1277", "E1206", "E1219", "E1320", "E1002", "E1124", "E1172", "E1007", "E1032", "E1057", "E1155", "E1159", "E1308", "E1062"]}
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 ['E1244', 'E1316', 'E1076', 'E07', 'E1021', 'E1166', 'E1279', 'E1048', 'E1084', 'E1200', 'E1225', 'E1233', 'E1234', 'E1254', 'E1041', 'E1063', 'E1107', 'E1138', 'E1140', 'E1218', 'E1106', 'E1121', 'E1205', 'E1277', 'E1206', 'E1219', 'E1320', 'E1002', 'E1124', 'E1172', 'E1007', 'E1032', 'E1057', 'E1155', 'E1159', 'E1308', 'E1062']
sql run 3
35 entities (IDs in the JSON). Each had an LTIDR before 2026-10-01 but its latest LTIDR action is a withdrawal, as with E07.
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"]}
sql run 4
35 entities, listed in the JSON. Their latest issuer-rating action by 1 October 2026 is a withdrawal, including E07 and the duplicate E1002.
JSON: {"entities": ["E07", "E1021", "E1166", "E1062", "E1316", "E1244", "E1205", "E1121", "E1076", "E1218", "E1234", "E1233", "E1225", "E1200", "E1084", "E1048", "E1124", "E1172", "E1032", "E1159", "E1308", "E1057", "E1007", "E1155", "E1254", "E1002", "E1206", "E1320", "E1219", "E1277", "E1063", "E1140", "E1138", "E1107", "E1041"]}
sql run 5
35 entities had a rating that was later withdrawn. Duplicate research records are mapped to their rated entity.
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"]}
sql+markdown run 1
35 entities, listed in the JSON, have a latest LTIDR of WD and no other current LTIDR. This includes E07.
JSON: {"entities": ["E1032", "E1155", "E1159", "E1007", "E1057", "E1253", "E1308", "E1121", "E1205", "E1076", "E1244", "E1316", "E1166", "E1021", "E07", "E1041", "E1138", "E1063", "E1140", "E1107", "E1277", "E1062", "E1124", "E1001", "E1172", "E1084", "E1048", "E1218", "E1219", "E1320", "E1206", "E1200", "E1225", "E1233", "E1234"]}
sql+markdown run 2
35 entities, listed in the JSON, including E07 (Pellam).
JSON: {"entities": ["E1277", "E07", "E1063", "E1233", "E1219", "E1172", "E1205", "E1320", "E1076", "E1206", "E1234", "E1138", "E1048", "E1107", "E1253", "E1225", "E1121", "E1159", "E1032", "E1166", "E1218", "E1007", "E1155", "E1021", "E1057", "E1001", "E1041", "E1244", "E1200", "E1140", "E1084", "E1308", "E1062", "E1124", "E1316"]}
sql+markdown run 3
39 records across 37 entities had an issuer rating at some point but none on 2026-10-01, listed in the JSON, including E07. Each of these has a latest LTIDR action of WD. Two of the entities (E1001/E1002 and E1021/E1022) appear under two records each.
JSON: {"entities": ["E1218", "E1007", "E1032", "E1057", "E1155", "E1159", "E1253", "E1308", "E1002", "E1277", "E1244", "E1316", "E1048", "E1084", "E1076", "E1254", "E07", "E1021", "E1166", "E1139", "E1200", "E1225", "E1233", "E1234", "E1121", "E1205", "E1001", "E1124", "E1172", "E1022", "E1062", "E1206", "E1219", "E1320", "E1041", "E1063", "E1107", "E1138", "E1140"]}
sql+markdown run 4
35 entities (listed in the JSON) had a rating that was later withdrawn, including E07 (A19).
JSON: {"entities": ["E1244", "E1316", "E1233", "E1234", "E1200", "E1225", "E1076", "E1219", "E1206", "E1320", "E1205", "E1121", "E1166", "E07", "E1021", "E1048", "E1084", "E1277", "E1218", "E1172", "E1001", "E1124", "E1007", "E1253", "E1032", "E1159", "E1057", "E1155", "E1308", "E1062", "E1107", "E1140", "E1063", "E1138", "E1041"]}
sql+markdown run 5
35 entities (listed in the JSON, including E07) had an LTIDR at some point but had it withdrawn by 2026-10-01.
JSON: {"entities": ["E1032", "E1159", "E1057", "E1155", "E1253", "E1007", "E1308", "E1206", "E1320", "E1219", "E1048", "E1084", "E1076", "E1021", "E07", "E1166", "E1138", "E1041", "E1063", "E1107", "E1140", "E1205", "E1121", "E1225", "E1233", "E1234", "E1200", "E1277", "E1218", "E1062", "E1001", "E1172", "E1124", "E1316", "E1244"]}
sparql run 1
Issuers whose latest rating is WD, excluding E1106 and E1279, are in the JSON. Those two still hold a rating on the other currency basis.
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"]}
sparql run 2
Partial list, from withdrawals (WD) I saw: E07, E1002, E1007, E1021. The result set was truncated, so there may be more.
JSON: {"entities": ["E07", "E1002", "E1007", "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 ['E07', 'E1002', 'E1007', 'E1021']
sparql run 3
E07 and the 36 other issuers whose latest long-term action is a withdrawal (WD). Duplicate-LEI records were not reconciled.
JSON: {"entities": ["E07", "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"]}
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', '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']
sparql run 4
These 37 entities have a withdrawn long-term issuer rating as their latest, and E08 is not among them (it is in default, not withdrawn). The list includes E07.
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']
sparql run 5
36 entities whose latest issuer action on or before 2026-10-01 was a withdrawal, e.g. E07, E1002. They are listed in the JSON.
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']
sparql+ontology run 1
35 entities, listed in the JSON, were rated at some point but had their latest rating withdrawn by 2026-10-01 (E07 among them).
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"]}
sparql+ontology run 2
35 entities had a rating at some point but none on 1 Oct 2026, listed in the JSON. Each has only withdrawals as its last actions across all currency bases.
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"]}
sparql+ontology run 3
36 entities, listed in the JSON. Each has a withdrawal as its latest long-term action before 2026-10-01, with no later action under its own record or LEI. E1106 is excluded because only its LC rating was withdrawn.
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']
sparql+ontology run 4
35 entities, listed in the JSON, had a rating at some point but no non-withdrawn LTIDR on 1 Oct 2026. E07 is one of them (A19).
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"]}
sparql+ontology run 5
35 entities.
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"]}
sql+executed run 1
35 entities had an issuer rating that was later withdrawn (WD), leaving no rating in force on 1 October 2026. They are in the JSON and include E07.
JSON: {"entities": ["E07", "E1021", "E1166", "E1121", "E1205", "E1200", "E1225", "E1233", "E1234", "E1206", "E1219", "E1320", "E1244", "E1316", "E1062", "E1277", "E1218", "E1007", "E1032", "E1057", "E1155", "E1159", "E1253", "E1308", "E1041", "E1063", "E1107", "E1138", "E1140", "E1001", "E1124", "E1172", "E1048", "E1084", "E1076"]}
sql+executed run 2
35 entities. Each had an issuer rating at some point and only withdrawn (WD) ratings as the current one on 1 October 2026; E07 is one example.
JSON: {"entities": ["E1076", "E1205", "E1218", "E1159", "E1200", "E1206", "E1234", "E1041", "E1048", "E1107", "E1320", "E1063", "E1140", "E1277", "E1001", "E1244", "E1316", "E1084", "E1032", "E1225", "E1233", "E07", "E1124", "E1219", "E1253", "E1308", "E1057", "E1172", "E1007", "E1121", "E1166", "E1155", "E1021", "E1062", "E1138"]}
sql+executed run 3
35 entities had an issuer rating before but only WD on 2026-10-01; they are listed in the JSON.
JSON: {"entities": ["E1007", "E1032", "E1057", "E1155", "E1159", "E1253", "E1308", "E1076", "E1062", "E1244", "E1316", "E1121", "E1205", "E1277", "E1218", "E1001", "E1124", "E1172", "E1200", "E1225", "E1233", "E1234", "E07", "E1021", "E1166", "E1206", "E1219", "E1320", "E1041", "E1063", "E1107", "E1138", "E1140", "E1048", "E1084"]}
sql+executed run 4
35 entities, listed in the JSON. They had a non-withdrawn issuer rating at some point but none open on 1 October 2026, including E07.
JSON: {"entities": ["E1206", "E1219", "E1320", "E1121", "E1205", "E1244", "E1316", "E1048", "E1084", "E1076", "E1200", "E1225", "E1233", "E1234", "E1001", "E1124", "E1172", "E1007", "E1032", "E1057", "E1155", "E1159", "E1253", "E1308", "E1062", "E1277", "E1218", "E1041", "E1063", "E1107", "E1138", "E1140", "E07", "E1021", "E1166"]}
sql+executed run 5
35 entities had an issuer rating at some point but none in force on 1 October 2026, listed in the JSON. They were all withdrawn, e.g. E07 (A19).
JSON: {"entities": ["E1244", "E1316", "E1007", "E1032", "E1057", "E1155", "E1159", "E1308", "E1138", "E1206", "E1219", "E1320", "E1218", "E1001", "E1200", "E1225", "E1233", "E1234", "E07", "E1166", "E1021", "E1048", "E1084", "E1062", "E1121", "E1205", "E1041", "E1063", "E1107", "E1140", "E1076", "E1277", "E1124", "E1172", "E1253"]}
sparql+axioms run 1
The list below is my best reconstruction and is not confirmed. It is the entities whose long-term issuer ratings were all superseded, which I confirmed only for the withdrawals E07, E1002, E1007, E1041 and E1057. I left out E1340–E1351 and E16, which show a downgrade with no end date but no in-force record, and E02, which is merged with E03.
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"]}
sparql+axioms run 2
The entities in the JSON list. Each had an issuer rating that was later withdrawn, and neither it nor a linked record holds one now.
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"]}
sparql+axioms run 3
The entities that once had an issuer rating but none in force on 1 Oct 2026 are listed in the JSON. E07 (A19, withdrawn) and E16 are among them. The cluster E1340–E1351 is included only because no rating was in force for them; I could not verify why.
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"]}
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']
sparql+axioms run 4
Entities whose latest rating is a withdrawal (WD), so none in force on 1 Oct 2026. I omitted E02, which is covered by its duplicate E03. I also omitted several entities with no in-force record but with actions dated in late 2026 or later.
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"]}
sparql+axioms run 5
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']