Q9, run 2026-11-04-2024-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 = 377
sql run 1
390. This counts distinct LEIs among entities with a current LTIDR, which merges duplicate records of the same legal entity.
JSON: {"count": 390}
Why: count: expected 377, got 390
sql run 2
390. 393 entity IDs hold a current LTIDR, but duplicate records share LEIs, so I count distinct LEIs. This includes the two sovereign entries.
JSON: {"count": 390}
Why: count: expected 377, got 390
sql run 3
390 distinct issuers held a foreign-currency issuer rating on 1 Oct 2026. Duplicate records sharing an LEI are counted once, and withdrawn ratings are excluded.
JSON: {"count": 390}
Why: count: expected 377, got 390
sql+markdown run 1
209. This counts distinct entities with a non-withdrawn LTIDR on 2026-10-01, after merging records by LEI and excluding QA.
JSON: {"count": 209}
Why: count: expected 377, got 209
sql+markdown run 2
377 distinct entities held a non-withdrawn LTIDR on 1 Oct 2026, after merging records that share an LEI and excluding QA records.
JSON: {"count": 377}
sql+markdown run 3
377 distinct issuers hold an LTIDR or STIDR that was not withdrawn. This merges duplicate records by LEI and excludes QA records.
JSON: {"count": 377}
sparql run 1
393. This counts entities whose latest long-term rating on each basis was not WD. Duplicate records for the same legal entity are not merged, so it may be slightly high.
JSON: {"count": 393}
Why: count: expected 377, got 393
sparql run 2
390. There are 391 entities with a non-withdrawn foreign-currency long-term rating, and E02 and E03 share one LEI.
JSON: {"count": 390}
Why: count: expected 377, got 390
sparql run 3
391, counting entities with a non-withdrawn issuer rating and merging duplicates that share an LEI.
JSON: {"count": 391}
Why: count: expected 377, got 391
sparql+ontology run 1
377. This counts distinct LEIs (or IDs, for sovereigns) whose latest long-term issuer action on or before 2026-10-01 is not a withdrawal, excluding QA records.
JSON: {"count": 377}
sparql+ontology run 2
377. This counts distinct LTIDR holders (merged by LEI, QA excluded, withdrawn ratings excluded) with a rating in force on 1 Oct 2026, on either basis. It includes the sovereign records.
JSON: {"count": 377}
sparql+ontology run 3
377 distinct issuers, counting entities with a non-withdrawn LTIDR on 1 Oct 2026 and merging duplicate records by LEI. This includes the sovereign CV, which holds an LTIDR.
JSON: {"count": 377}
sql+executed run 1
377 distinct entities held a current non-withdrawn LTIDR.
JSON: {"count": 377}
sql+executed run 2
376 distinct rated entities hold a current FC LTIDR (WD excluded). This count includes the sovereign CV.
JSON: {"count": 376}
Why: count: expected 377, got 376
sql+executed run 3
377. This is the count of distinct entities with an LTIDR or STIDR in force on 1 October 2026, excluding withdrawn (WD) ratings. It includes entities that hold only a local-currency rating.
JSON: {"count": 377}
sparql+axioms run 1
377 distinct issuers, after merging same-entity records and excluding withdrawn ratings.
JSON: {"count": 377}
sparql+axioms run 2
377, after collapsing duplicate records of the same entity.
JSON: {"count": 377}
sparql+axioms run 3
366 distinct entities, with same-entity duplicates merged.
JSON: {"count": 366}
Why: count: expected 377, got 366