Q21, run 2026-11-04-2028-haiku
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']
csv run 1
E07. Its last LTIDR action was a withdrawal (A19, 2026-05-12). VD and E11 never had an LTIDR.
JSON: {"entities": ["E07"]}
csv run 2
E07. Its rating was withdrawn by A19 (2026-05-12). E11 is excluded because its only record is type CO, which the data does not define as an issuer rating.
JSON: {"entities": ["E07"]}
csv run 3
E07. Its rating was withdrawn on 2026-05-12 (A19), and no other entity with an LTIDR lost it.
JSON: {"entities": ["E07"]}
csv run 4
E07. Its rating was withdrawn on 2026-05-12 (A19). E11's CO rating is not an LTIDR, so it is excluded.
JSON: {"entities": ["E07"]}
csv run 5
Pellam Retail (E07), which was withdrawn by A19 (2026-05-12). E11 has only a CO record (A46), which doesn't appear to be an issuer rating.
JSON: {"entities": ["E07"]}
csv+ontology run 1
E07
E07 had a rating (BB, A18) that was withdrawn (A19). E11 and VD never had an issuer rating.
JSON: {"entities": ["E07"]}
csv+ontology run 2
E07. It was withdrawn (A19, 2026-05-12) and has no rating after that. E11 and VD never had an issuer rating.
JSON: {"entities": ["E07"]}
csv+ontology run 3
E07. It had a BB rating (A18) that was withdrawn (A19) and has no issuer rating on 1 October 2026. E11 never had an issuer rating, since A46 is a credit opinion.
JSON: {"entities": ["E07"]}
csv+ontology run 4
E07. It had a BB rating (A18) and was withdrawn (A19). E11 and VD never had an issuer rating (only a credit opinion and a Country Ceiling).
JSON: {"entities": ["E07"]}
csv+ontology run 5
E07. It had a rating (A18) and was withdrawn (A19), so it no longer has one. E11 and E04 never had issuer ratings.
JSON: {"entities": ["E07"]}
csv+markdown run 1
E07 (Pellam Retail), which was withdrawn (A19). E11 never had an issuer rating, because its CO (A46) does not count.
JSON: {"entities": ["E07"]}
csv+markdown run 2
E07. Pellam had a BB rating that was withdrawn on 2026-05-12 (A19). E11 has only a Credit Opinion, which is not an issuer rating.
JSON: {"entities": ["E07"]}
csv+markdown run 3
E07. Its rating was withdrawn on 2026-05-12 (A19). E11 never had an issuer rating, only a credit opinion (A46).
JSON: {"entities": ["E07"]}
csv+markdown run 4
E07 (Pellam Retail), withdrawn by A19 (2026-05-12). E11 and VD never held an issuer rating, since their only records are a CO and a CC.
JSON: {"entities": ["E07"]}
csv+markdown run 5
E07. It had a rating (A18, BB) and was withdrawn (A19), and it has no issuer rating on 1 October 2026. E11 never had an issuer rating; its only action is a credit opinion.
JSON: {"entities": ["E07"]}
csv+axioms run 1
E07, whose rating was withdrawn (A19). E16 had LTIDR actions, but it is a QA test record and is excluded.
JSON: {"entities": ["E07"]}
csv+axioms run 2
E07, which withdrew its rating (A19, 2026-05-12). E16 also had LTIDR actions, but as a QA test record it is excluded.
JSON: {"entities": ["E07"]}
csv+axioms run 3
E07. Its BB rating (A18) ended with the withdrawal in A19. E16 is excluded as QA test data.
JSON: {"entities": ["E07"]}
csv+axioms run 4
E07. It had BB (A18) and was withdrawn (A19). E11 never had an issuer rating (only a CO, A46), and E16 is a QA record.
JSON: {"entities": ["E07"]}
csv+axioms run 5
E07. Pellam had an LTIDR (A18), which was withdrawn in A19. E16 also had issuer-rating actions but is a QA test record, so I excluded it.
JSON: {"entities": ["E07"]}