Q9, run 2026-11-06-0041-sonnet-query
As of 1 October 2026, how many distinct issuers hold an issuer rating?
Tests: Everything at once: identity, withdrawal, instrument versus issuer, ceiling versus rating.
Expected: count = 278
sql run 1
291. This counts distinct LEIs, or entity IDs where there is no LEI, whose latest LTIDR on 1 Oct 2026 was not a withdrawal. It includes the sovereign CV, and the count is 290 without it.
JSON: {"count": 291}
Why: count: expected 278, got 291
sql run 2
291. This counts distinct LEIs with a non-withdrawn latest LTIDR on either currency basis as of 1 October 2026, QA records included. It is 278 if QA records are excluded.
JSON: {"count": 291}
Why: count: expected 278, got 291
sql run 3
291. These are the distinct entities, deduplicated by LEI, whose latest LTIDR action on or before 2026-10-01 was not a withdrawal. The count includes the two sovereigns.
JSON: {"count": 291}
Why: count: expected 278, got 291
sql run 4
291. That is 292 entity IDs with a current non-withdrawn issuer rating, collapsed by shared LEI.
JSON: {"count": 291}
Why: count: expected 278, got 291
sql run 5
291. This counts distinct LEIs with a non-withdrawn LTIDR as of 2026-10-01, so duplicates collapse.
JSON: {"count": 291}
Why: count: expected 278, got 291
sql+markdown run 1
278. This counts distinct LEIs with a latest LTIDR other than WD on 2026-10-01. Same-LEI duplicates are merged and QA records are excluded.
JSON: {"count": 278}
sql+markdown run 2
278 distinct issuers, counted by LEI with QA excluded and withdrawn ratings dropped.
JSON: {"count": 278}
sql+markdown run 3
278. This counts distinct LEIs whose latest LTIDR (either currency basis) on 2026-10-01 is not WD, excluding QA records.
JSON: {"count": 278}
sql+markdown run 4
278 distinct issuers hold an issuer rating as of 2026-10-01, counted by LEI, excluding QA records and withdrawn ratings.
JSON: {"count": 278}
sql+markdown run 5
278 distinct issuers held a non-withdrawn LTIDR on 2026-10-01, with records matched by LEI and QA records excluded.
JSON: {"count": 278}
sparql run 1
289. This is distinct issuers by LEI whose latest long-term issuer rating on 1 Oct 2026 was not WD. It includes the Republic of Corvenia (CV), the only sovereign with an issuer rating.
JSON: {"count": 289}
Why: count: expected 278, got 289
sparql run 2
292 rated entity records, with a caveat. The count is by record and I did not de-duplicate it. Several entities appear twice under one LEI, for example E02/E03, so the distinct-issuer count is lower.
JSON: {"count": 292}
Why: count: expected 278, got 292
sparql run 3
291. These are distinct issuers, with duplicate records merged by LEI, whose latest long-term issuer rating on 1 Oct 2026 was not WD.
JSON: {"count": 291}
Why: count: expected 278, got 291
sparql run 4
291, counting entities that share a LEI once. Some other entities may also be duplicates, so this is approximate.
JSON: {"count": 291}
Why: count: expected 278, got 291
sparql run 5
290. There are 291 entity IDs with a latest issuer action on or before 2026-10-01, but two share an LEI, so I counted them once. That count included withdrawn ratings and I did not exclude them.
JSON: {"count": 290}
Why: count: expected 278, got 290
sparql+ontology run 1
278. This counts distinct LEIs (record ID for sovereigns) whose latest long-term issuer rating on 2026-10-01 was not WD, ignoring QA.
JSON: {"count": 278}
sparql+ontology run 2
278. This counts distinct LEIs (or IDs, for sovereigns) with a non-withdrawn long-term issuer rating on 1 Oct 2026, excluding QA records.
JSON: {"count": 278}
sparql+ontology run 3
261. This counts distinct LEIs (record ID where there is no LEI) whose latest long-term issuer action on or before 2026-10-01 is not a withdrawal.
JSON: {"count": 261}
Why: count: expected 278, got 261
sparql+ontology run 4
278. That is 277 distinct LEIs with a non-withdrawn LTIDR on 1 Oct 2026, plus the sovereign CV, which has no LEI but has LTIDR actions (A38, A39). CO and CC ratings are excluded. The sovereign VD has only a Country Ceiling, no LTIDR.
JSON: {"count": 278}
sparql+ontology run 5
281 distinct issuers, counted by LEI (the two sovereigns by record ID), excluding QA and withdrawn ratings.
JSON: {"count": 281}
Why: count: expected 278, got 281
sql+executed run 1
278 distinct issuers had a non-withdrawn LTIDR in force on 1 October 2026.
JSON: {"count": 278}
sql+executed run 2
278. This is the count of distinct entities with a current long-term or short-term issuer rating on 1 October 2026, excluding withdrawn (WD) ratings.
JSON: {"count": 278}
sql+executed run 3
278. This is the number of distinct entities with a current LTIDR that is not WD. It includes the sovereign CV, and E1279, whose LC rating is still active.
JSON: {"count": 278}
sql+executed run 4
278 distinct entities held a non-withdrawn long-term issuer rating on 1 October 2026.
JSON: {"count": 278}
sql+executed run 5
278. This counts distinct entities with a current non-withdrawn LTIDR, after merging duplicate records, and includes the sovereign CV.
JSON: {"count": 278}
sparql+axioms run 1
278. This counts distinct in-force long-term issuer ratings, excluding withdrawn ones, with same-entity records merged.
JSON: {"count": 278}
sparql+axioms run 2
278. There are 279 entity records with an issuer rating in force, which merge to 278 distinct entities.
JSON: {"count": 278}
sparql+axioms run 3
278 distinct issuers, merging same-entity records.
JSON: {"count": 278}
sparql+axioms run 4
278. This counts distinct entities with an issuer rating in force, merging records that share an LEI.
JSON: {"count": 278}
sparql+axioms run 5
278. This counts distinct entities after merging sameEntityAs records, and it includes sovereigns.
JSON: {"count": 278}