Q40, run 2026-11-04-1738-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
74. This counts distinct GB-domiciled LEIs whose latest issuer-rating action by 1 Oct 2026 is not a withdrawal.
JSON: {"count": 74}
Why: count: expected 66, got 74
sql run 2
74. Counted as in Q9, restricted to LEI-deduplicated entities whose country is GB.
JSON: {"count": 74}
Why: count: expected 66, got 74
sql run 3
74. These are distinct GB-domiciled LEIs with a non-withdrawn issuer rating on 1 October 2026.
JSON: {"count": 74}
Why: count: expected 66, got 74
sql run 4
74. These are GB-domiciled issuers with a non-withdrawn issuer rating on 2026-10-01, deduplicated by LEI.
JSON: {"count": 74}
Why: count: expected 66, got 74
sql run 5
74. This is 75 GB entities with a non-withdrawn rating, counting LEI duplicates once.
JSON: {"count": 74}
Why: count: expected 66, got 74
sql+markdown run 1
66 distinct GB issuers.
JSON: {"count": 66}
sql+markdown run 2
66 distinct GB-domiciled issuers had a live issuer rating on 2026-10-01.
JSON: {"count": 66}
sql+markdown run 3
66 distinct GB-domiciled issuers.
JSON: {"count": 66}
sql+markdown run 4
66.
JSON: {"count": 66}
sql+markdown run 5
66.
JSON: {"count": 66}
sparql run 1
74.
JSON: {"count": 74}
Why: count: expected 66, got 74
sparql run 2
74 distinct LEIs.
JSON: {"count": 74}
Why: count: expected 66, got 74
sparql run 3
74, counted as distinct entities by LEI.
JSON: {"count": 74}
Why: count: expected 66, got 74
sparql run 4
74. This counts distinct LEIs among GB-domiciled entities with a current issuer rating.
JSON: {"count": 74}
Why: count: expected 66, got 74
sparql run 5
74. This counts distinct LEIs among GB-domiciled entities with a valid issuer rating as of 2026-10-01.
JSON: {"count": 74}
Why: count: expected 66, got 74
sparql+ontology run 1
66 distinct GB-domiciled issuers (by RATINGS-record country) hold an issuer rating.
JSON: {"count": 66}
sparql+ontology run 2
66 distinct GB-domiciled issuers hold a rating (counted by LEI).
JSON: {"count": 66}
sparql+ontology run 3
66 distinct GB-domiciled issuers.
JSON: {"count": 66}
sparql+ontology run 4
66 distinct GB issuers.
JSON: {"count": 66}
sparql+ontology run 5
66. This is an aggregate query for GB-domiciled issuers on 1 Oct 2026 and I did not inspect individual rows.
JSON: {"count": 66}