Q40, run 2026-11-06-0041-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 = 66
sql run 1
66. This counts distinct GB-domiciled LEIs with a non-withdrawn issuer rating on 1 Oct 2026, and includes QA-sourced entities.
JSON: {"count": 66}
sql run 2
74. This is the same basis as Q9, restricted to GB; it is 66 with QA records excluded.
JSON: {"count": 74}
Why: count: expected 66, got 74
sql run 3
74. These are distinct GB-domiciled entities, deduplicated by LEI, with an active issuer rating on 1 October 2026.
JSON: {"count": 74}
Why: count: expected 66, got 74
sql run 4
74.
JSON: {"count": 74}
Why: count: expected 66, got 74
sql run 5
74. This counts distinct LEIs among GB issuers with a non-withdrawn issuer rating.
JSON: {"count": 74}
Why: count: expected 66, got 74
sql+markdown run 1
66. This is distinct GB-domiciled issuers with a current LTIDR on 2026-10-01, using the RESEARCH country where records disagree.
JSON: {"count": 66}
sql+markdown run 2
66.
JSON: {"count": 66}
sql+markdown run 3
66. This counts distinct LEIs rated on 2026-10-01 with GB domicile, using the RESEARCH record for country where records disagree.
JSON: {"count": 66}
sql+markdown run 4
66 distinct GB issuers, using the RESEARCH country where records disagree.
JSON: {"count": 66}
sql+markdown run 5
66 distinct GB-domiciled issuers, with RESEARCH records deciding the country.
JSON: {"count": 66}
sparql run 1
74, counted by distinct LEI.
JSON: {"count": 74}
Why: count: expected 66, got 74
sparql run 2
75 records with country GB, not de-duplicated for entities that share an LEI.
JSON: {"count": 75}
Why: count: expected 66, got 75
sparql run 3
74. This counts distinct GB issuers, merged by LEI, with a latest long-term rating on 1 Oct 2026 that was not WD.
JSON: {"count": 74}
Why: count: expected 66, got 74
sparql run 4
308, but this is low confidence. The same query returned a lower total of 291, so it is internally inconsistent.
JSON: {"count": 308}
Why: count: expected 66, got 308
sparql run 5
74. This is the count of distinct GB issuers by LEI, using the same latest-action basis as Q9.
JSON: {"count": 74}
Why: count: expected 66, got 74
sparql+ontology run 1
66, using the RESEARCH record's country where there is one. This matches the Q25 count by coincidence.
JSON: {"count": 66}
sparql+ontology run 2
66. This is the same count as Q9, restricted to entities whose record shows GB. I did not apply the RESEARCH-country override to duplicates here.
JSON: {"count": 66}
sparql+ontology run 3
66.
JSON: {"count": 66}
sparql+ontology run 4
66.
JSON: {"count": 66}
sparql+ontology run 5
67.
JSON: {"count": 67}
Why: count: expected 66, got 67
sql+executed run 1
66 distinct GB-domiciled issuers held an issuer rating on 1 October 2026.
JSON: {"count": 66}
sql+executed run 2
66 GB issuers held a current issuer rating on 1 October 2026, excluding withdrawn ratings.
JSON: {"count": 66}
sql+executed run 3
66. This counts GB-domiciled entities with a current non-WD LTIDR.
JSON: {"count": 66}
sql+executed run 4
66 distinct GB-domiciled entities held a non-withdrawn issuer rating on 1 October 2026.
JSON: {"count": 66}
sql+executed run 5
66 distinct GB-domiciled entities held a non-withdrawn issuer rating.
JSON: {"count": 66}
sparql+axioms run 1
66, counting same-entity records once.
JSON: {"count": 66}
sparql+axioms run 2
66 distinct GB-domiciled entities hold an issuer rating, merging duplicate records.
JSON: {"count": 66}
sparql+axioms run 3
66.
JSON: {"count": 66}
sparql+axioms run 4
66.
JSON: {"count": 66}
sparql+axioms run 5
68, which is an estimate. The result list was truncated by 7 rows, and I assumed those were GB.
JSON: {"count": 68}
Why: count: expected 66, got 68