Q9, run 2026-11-05-1819-sonnet-query-graphdb
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 = 377
sparql run 1
393. This counts distinct rated entities, including the sovereigns; I did not separate them out.
JSON: {"count": 393}
Why: count: expected 377, got 393
sparql run 2
391. This counts distinct LEIs whose latest issuer rating on either currency basis is not WD.
JSON: {"count": 391}
Why: count: expected 377, got 391
sparql run 3
190, counting distinct issuers by LEI. This is the latest long-term rating per entity as of 2026-10-01, excluding withdrawn ratings.
JSON: {"count": 190}
Why: count: expected 377, got 190
sparql run 4
393. This counts rated entities whose latest issuer rating is not WD as of 2026-10-01. Duplicate records sharing an LEI could make the true count slightly lower.
JSON: {"count": 393}
Why: count: expected 377, got 393
sparql run 5
391. This counts distinct issuers, merged by LEI, whose latest issuer rating on 1 Oct 2026 is not WD, and it includes the sovereign CV. It is 390 without CV.
JSON: {"count": 391}
Why: count: expected 377, got 391
sparql+ontology run 1
377 distinct issuers, counted by LEI, across LTIDR and STIDR ratings still in force. QA records are excluded and withdrawals are not counted as ratings.
JSON: {"count": 377}
sparql+ontology run 2
377, counting distinct LEIs with a non-withdrawn issuer rating on 1 Oct 2026.
JSON: {"count": 377}
sparql+ontology run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 377, got None
sparql+ontology run 4
377 distinct issuers, counted by LEI with QA records excluded. This count may be unreliable, because the query that produced it was not cross-checked.
JSON: {"count": 377}
sparql+ontology run 5
377. This counts distinct non-QA entities (by LEI) whose latest long-term issuer rating on 1 October 2026 is not a withdrawal.
JSON: {"count": 377}
sparql+axioms run 1
378. This is a raw count that may include duplicate records for the same entity.
JSON: {"count": 378}
Why: count: expected 377, got 378
sparql+axioms run 2
378 (?). This is the count of long-term issuer ratings in force. It may include duplicate records of one entity and sovereigns.
JSON: {"count": 378}
Why: count: expected 377, got 378
sparql+axioms run 3
377. This is 378 records with an issuer long-term rating in force, less one pair of records for the same entity. I could not check for QA test records.
JSON: {"count": 377}
sparql+axioms run 4
377 distinct issuers hold a non-withdrawn long-term issuer rating.
JSON: {"count": 377}
sparql+axioms run 5
377 distinct issuers hold a long-term issuer rating in force.
JSON: {"count": 377}