Q40, run 2026-11-04-2024-sonnet-query
How many distinct issuers domiciled in GB held an issuer rating on 1 October 2026?
Tests: Identity and withdrawal: Northwind counted once, Pellam not at all, the QA record ignored.
Expected: count = 79
sql run 1
87 distinct GB-domiciled issuers, counted by LEI.
JSON: {"count": 87}
Why: count: expected 79, got 87
sql run 2
87 distinct LEIs among the GB issuers with a current rating (88 by entity ID).
JSON: {"count": 87}
Why: count: expected 79, got 87
sql run 3
87 distinct GB-domiciled issuers.
JSON: {"count": 87}
Why: count: expected 79, got 87
sql+markdown run 1
61, using the RESEARCH-held country.
JSON: {"count": 61}
Why: count: expected 79, got 61
sql+markdown run 2
79.
JSON: {"count": 79}
sql+markdown run 3
79.
JSON: {"count": 79}
sparql run 1
88.
JSON: {"count": 88}
Why: count: expected 79, got 88
sparql run 2
87. There are 88 GB records with a current issuer rating, minus the E02/E03 duplicate.
JSON: {"count": 87}
Why: count: expected 79, got 87
sparql run 3
About 88. The query that produced this was unreliable.
JSON: {"count": 88}
Why: count: expected 79, got 88
sparql+ontology run 1
79. Country follows the RESEARCH record where records disagree.
JSON: {"count": 79}
sparql+ontology run 2
79. This counts GB-domiciled issuers (RESEARCH country takes precedence) with a rating in force on 1 Oct 2026.
JSON: {"count": 79}
sparql+ontology run 3
79.
JSON: {"count": 79}
sql+executed run 1
79 distinct GB-domiciled issuers held a current issuer rating.
JSON: {"count": 79}
sql+executed run 2
79.
JSON: {"count": 79}
sql+executed run 3
79.
JSON: {"count": 79}
sparql+axioms run 1
79.
JSON: {"count": 79}
sparql+axioms run 2
About 74. The GB-filtered count query failed, so this comes from an earlier non-deduplicated count and is approximate.
JSON: {"count": 74}
Why: count: expected 79, got 74
sparql+axioms run 3
74.
JSON: {"count": 74}
Why: count: expected 79, got 74