Q21, run 2026-11-06-0935-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']
sql run 1
E07, whose rating was withdrawn in A19.
JSON: {"entities": ["E07"]}
sql run 2
E07, whose rating was withdrawn (A19).
JSON: {"entities": ["E07"]}
sql run 3
E07, whose rating was withdrawn by A19.
JSON: {"entities": ["E07"]}
sql run 4
E07, whose rating was withdrawn by A19.
JSON: {"entities": ["E07"]}
sql run 5
E07, because of the withdrawal in A19.
JSON: {"entities": ["E07"]}
sql+markdown run 1
E07. Its LTIDR was withdrawn by A19.
JSON: {"entities": ["E07"]}
sql+markdown run 2
E07, whose rating was withdrawn by A19.
JSON: {"entities": ["E07"]}
sql+markdown run 3
E07, withdrawn by A19.
JSON: {"entities": ["E07"]}
sql+markdown run 4
E07 (withdrawn, A19).
JSON: {"entities": ["E07"]}
sql+markdown run 5
E07. It was rated from 2024 and withdrawn by A19.
JSON: {"entities": ["E07"]}
sparql run 1
E07, whose rating was withdrawn (A19).
JSON: {"entities": ["E07"]}
sparql run 2
E07, because its rating was withdrawn in A19.
JSON: {"entities": ["E07"]}
sparql run 3
E07. Its rating was withdrawn (A19).
JSON: {"entities": ["E07"]}
sparql run 4
E07 (A19).
JSON: {"entities": ["E07"]}
sparql run 5
E07, whose rating was withdrawn (A19).
JSON: {"entities": ["E07"]}
sparql+ontology run 1
E07, which was withdrawn by A19.
JSON: {"entities": ["E07"]}
sparql+ontology run 2
E07.
JSON: {"entities": ["E07"]}
sparql+ontology run 3
E07. It was rated BB and then withdrawn in A19.
JSON: {"entities": ["E07"]}
sparql+ontology run 4
E07. Its rating was withdrawn by A19.
JSON: {"entities": ["E07"]}
sparql+ontology run 5
E07.
JSON: {"entities": ["E07"]}
sql+executed run 1
E07, whose rating was withdrawn on 2026-05-12 (A19).
JSON: {"entities": ["E07"]}
sql+executed run 2
E07. Its rating was withdrawn on 2026-05-12 (A19).
JSON: {"entities": ["E07"]}
sql+executed run 3
E07. Its rating was withdrawn (WD, A19).
JSON: {"entities": ["E07"]}
sql+executed run 4
E07, whose rating was withdrawn on 2026-05-12 (A19).
JSON: {"entities": ["E07"]}
sql+executed run 5
E07. Its rating was withdrawn on 2026-05-12 (A19).
JSON: {"entities": ["E07"]}
sparql+axioms run 1
E07.
JSON: {"entities": ["E07"]}
sparql+axioms run 2
E07, whose rating was withdrawn on 2026-05-12.
JSON: {"entities": ["E07"]}
sparql+axioms run 3
E07, whose rating was withdrawn (A19). E02's earlier rating continues under E03.
JSON: {"entities": ["E07"]}
sparql+axioms run 4
E07, whose rating was withdrawn on 2026-05-12 (A19).
JSON: {"entities": ["E07"]}
sparql+axioms run 5
E07, whose rating was withdrawn (A19).
JSON: {"entities": ["E07"]}