Q40, run 2026-11-05-1515-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. This counts distinct LEIs among GB entities with a current issuer rating.
JSON: {"count": 87}
Why: count: expected 79, got 87
sql run 2
87. This counts distinct GB-domiciled LEIs with an active FC issuer rating.
JSON: {"count": 87}
Why: count: expected 79, got 87
sql run 3
87. This counts distinct GB-domiciled de-duplicated issuers with an issuer rating on 1 Oct 2026.
JSON: {"count": 87}
Why: count: expected 79, got 87
sql run 4
87.
JSON: {"count": 87}
Why: count: expected 79, got 87
sql run 5
87.
JSON: {"count": 87}
Why: count: expected 79, got 87
sql+markdown run 1
79.
JSON: {"count": 79}
sql+markdown run 2
79. These are distinct GB-domiciled issuers, using RESEARCH country where records disagree.
JSON: {"count": 79}
sql+markdown run 3
79, after taking country from the RESEARCH record where records disagree.
JSON: {"count": 79}
sql+markdown run 4
79. This counts distinct entities rated on 2026-10-01 and domiciled in GB.
JSON: {"count": 79}
sql+markdown run 5
79. This counts GB-domiciled LEIs with a long-term issuer rating that was not withdrawn on 1 Oct 2026, using the RESEARCH country where records disagree.
JSON: {"count": 79}
sparql run 1
87. This is distinct LEIs among non-sovereign GB-domiciled issuers rated on 1 October 2026.
JSON: {"count": 87}
Why: count: expected 79, got 87
sparql run 2
87, counting distinct LEI-based entities with country GB.
JSON: {"count": 87}
Why: count: expected 79, got 87
sparql run 3
(no answer found)
JSON: {"count": null}
Why: count: expected 79, got None
sparql run 4
88. This may include duplicate records of the same LEI.
JSON: {"count": 88}
Why: count: expected 79, got 88
sparql run 5
87.
JSON: {"count": 87}
Why: count: expected 79, got 87
sparql+ontology run 1
(no answer found)
JSON: {"count": null}
Why: count: expected 79, got None
sparql+ontology run 2
79. This counts GB-domiciled LEIs holding a non-withdrawn issuer rating on 1 Oct 2026; I did not check the RESEARCH country override for this query.
JSON: {"count": 79}
sparql+ontology run 3
Not determined; I did not run the GB count, so 0 is a placeholder.
JSON: {"count": 0}
Why: count: expected 79, got 0
sparql+ontology run 4
79.
JSON: {"count": 79}
sparql+ontology run 5
Not determined. I did not complete that query.
JSON: {"count": null}
Why: count: expected 79, got None
sql+executed run 1
79.
JSON: {"count": 79}
sql+executed run 2
79 distinct GB issuers.
JSON: {"count": 79}
sql+executed run 3
79 GB-domiciled issuers.
JSON: {"count": 79}
sql+executed run 4
79.
JSON: {"count": 79}
sql+executed run 5
79.
JSON: {"count": 79}
sparql+axioms run 1
79.
JSON: {"count": 79}
sparql+axioms run 2
79. This counts entity records, so it may include a few duplicate records of the same entity.
JSON: {"count": 79}
sparql+axioms run 3
79.
JSON: {"count": 79}
sparql+axioms run 4
79, counted as records, so duplicates may inflate it.
JSON: {"count": 79}
sparql+axioms run 5
79.
JSON: {"count": 79}