Q9, run 2026-11-05-1515-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. By LEI there are 390 distinct entities with a current issuer rating on 2026-10-01, against 393 rated IDs, so 3 IDs are duplicates.
JSON: {"count": 390}
Why: count: expected 377, got 390
sql run 2
390. This is the count of distinct LEIs with a non-withdrawn FC issuer rating on 2026-10-01.
JSON: {"count": 390}
Why: count: expected 377, got 390
sql run 3
391. This counts distinct de-duplicated entities (same LEI) whose latest long-term issuer rating on 1 Oct 2026 was not a withdrawal.
JSON: {"count": 391}
Why: count: expected 377, got 391
sql run 4
391 distinct issuers hold a non-withdrawn LTIDR as of 2026-10-01, with duplicate records merged.
JSON: {"count": 391}
Why: count: expected 377, got 391
sql run 5
391. This counts distinct issuers by LEI whose latest LTIDR is not a withdrawal.
JSON: {"count": 391}
Why: count: expected 377, got 391
sql+markdown run 1
377 distinct issuers held an issuer rating on 1 Oct 2026, with duplicate records merged by LEI and QA records excluded.
JSON: {"count": 377}
sql+markdown run 2
377. This is the number of distinct entities, merged by LEI and excluding QA, whose latest issuer rating on 2026-10-01 is not a withdrawal.
JSON: {"count": 377}
sql+markdown run 3
377. This counts distinct entities (records merged by LEI, QA excluded) whose latest LTIDR on 1 Oct 2026 was not a withdrawal.
JSON: {"count": 377}
sql+markdown run 4
377. This counts distinct entities (merged by LEI) whose latest LTIDR on or before 2026-10-01 is not WD, excluding QA records.
JSON: {"count": 377}
sql+markdown run 5
377. This counts distinct LEIs whose latest long-term rating on 1 Oct 2026 was not a withdrawal, with QA records excluded.
JSON: {"count": 377}
sparql run 1
391. I counted distinct LEIs that had a long-term issuer rating on 1 October 2026 that was not withdrawn, which merges alias records. This includes the sovereign CV and excludes the withdrawn E07.
JSON: {"count": 391}
Why: count: expected 377, got 391
sparql run 2
389. This counts distinct LEI-based issuers whose latest long-term issuer rating on 1 Oct 2026 was not a withdrawal.
JSON: {"count": 389}
Why: count: expected 377, got 389
sparql run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 377, got None
sparql run 4
393, though this may count duplicate records of the same LEI. It is the number of distinct rated entity records whose latest long-term rating on 2026-10-01 was not a withdrawal.
JSON: {"count": 393}
Why: count: expected 377, got 393
sparql run 5
390. This is the count of distinct LEIs with a current issuer rating that is not withdrawn.
JSON: {"count": 390}
Why: count: expected 377, got 390
sparql+ontology run 1
(no answer found)
JSON: {"count": null}
Why: count: expected 377, got None
sparql+ontology run 2
376. This counts distinct LEIs holding a non-withdrawn long-term issuer rating on 1 Oct 2026.
JSON: {"count": 376}
Why: count: expected 377, got 376
sparql+ontology run 3
377 distinct issuers (merged by LEI, excluding QA) had a latest issuer rating that was not WD on 2026-10-01.
JSON: {"count": 377}
sparql+ontology run 4
376. This counts distinct LEIs with a non-withdrawn long-term issuer rating in force on 1 October 2026.
JSON: {"count": 376}
Why: count: expected 377, got 376
sparql+ontology run 5
377 distinct issuers, counted by LEI, excluding QA records and withdrawn ratings.
JSON: {"count": 377}
sql+executed run 1
377 distinct entities hold an issuer rating in force, excluding WD.
JSON: {"count": 377}
sql+executed run 2
377. This counts distinct rated entities with a non-withdrawn issuer rating in force on 1 October 2026. I could not check whether it includes the two sovereigns.
JSON: {"count": 377}
sql+executed run 3
377 distinct entities held a non-withdrawn LTIDR on 2026-10-01. This count includes any sovereigns with a rating in force, as the data doesn't separate them.
JSON: {"count": 377}
sql+executed run 4
377 distinct entities held an LTIDR (excluding withdrawn) on 1 Oct 2026.
JSON: {"count": 377}
sql+executed run 5
377 distinct rated entities, counting those with an LTIDR in force that is not WD. This includes the sovereigns.
JSON: {"count": 377}
sparql+axioms run 1
377 distinct issuers hold an in-force LTIDR other than WD, merging sameEntityAs duplicates.
JSON: {"count": 377}
sparql+axioms run 2
378. This is the count of entity records with a long-term issuer rating in force. It may slightly overcount records of the same entity.
JSON: {"count": 378}
Why: count: expected 377, got 378
sparql+axioms run 3
377. This is 376 distinct LEIs with a long-term issuer rating in force, plus the Republic of Corvenia (CV), which has no LEI but holds FC and LC ratings.
JSON: {"count": 377}
sparql+axioms run 4
378, counted as rated records. I did not collapse duplicate records, so this may be too high.
JSON: {"count": 378}
Why: count: expected 377, got 378
sparql+axioms run 5
376 distinct LEIs hold an in-force long-term issuer rating, counting LEIs so that duplicate records of one entity count once.
JSON: {"count": 376}
Why: count: expected 377, got 376