Q40, run 2026-11-04-1643-sonnet
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 = 5
csv run 1
6: E01, E02, E09, E12, E14, E16.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv run 2
6: E01, E02, E09, E12, E14 and E16. E07 is withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv run 3
6: E01, E02, E09, E12, E14 and E16. E07 is excluded because it was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv run 4
6. E01, E02, E09, E12, E14 and E16 are the GB entities holding an issuer rating. E07 was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv run 5
6: E01, E02, E09, E12, E14 and E16. E07 is excluded because its rating was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
rdf run 1
6: E01, E02, E09, E12, E14 and E16. E07 is excluded because it was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
rdf run 2
6 (E01, E02, E09, E12, E14, E16). E07 is excluded because it was withdrawn, and E03 is the same entity as E02.
JSON: {"count": 6}
Why: count: expected 5, got 6
rdf run 3
5. They are E01, E02 (=E03), E09, E12 and E14. E07 is excluded because it was withdrawn.
JSON: {"count": 5}
rdf run 4
6: E01, E02, E09, E12, E14 and E16. E16's source system is "QA", so it may be a test record. Without it the count is 5.
JSON: {"count": 6}
Why: count: expected 5, got 6
rdf run 5
6. These are E01, E02 (E03), E09, E12, E14 and E16. E07 is withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
rdf+ontology run 1
5. These are E01, E02 (same entity as E03), E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
rdf+ontology run 2
5: E01, E02, E09, E12 and E14. E07 is excluded because its rating was withdrawn.
JSON: {"count": 5}
rdf+ontology run 3
5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
rdf+ontology run 4
5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
rdf+ontology run 5
5: E01, E02, E09, E12 and E14.
JSON: {"count": 5}
csv+ontology run 1
5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
csv+ontology run 2
5. They are E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
csv+ontology run 3
5. These are E01, E02, E09, E12 and E14. E07 is withdrawn, and E16 is QA.
JSON: {"count": 5}
csv+ontology run 4
5. The GB issuers are E01, E02, E09, E12 and E14. E07 is withdrawn, and E16 is QA.
JSON: {"count": 5}
csv+ontology run 5
5. The GB issuers with a rating were E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
csv+markdown run 1
5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
csv+markdown run 2
5: E01, E02, E09, E12 and E14. E10 is domiciled in DE (the RATINGS record holds), and E07 is withdrawn.
JSON: {"count": 5}
csv+markdown run 3
5: E01, E02, E09, E12 and E14. E16 is QA and E07 is withdrawn.
JSON: {"count": 5}
csv+markdown run 4
5: E01, E02, E09, E12 and E14. E07 is withdrawn and E16 is QA.
JSON: {"count": 5}
csv+markdown run 5
5. These are E01, E02, E09, E12 and E14. E07 is withdrawn and E16 is QA.
JSON: {"count": 5}
csv+padding run 1
6: E01, E02, E09, E12, E14 and E16. E07 is withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv+padding run 2
6. These are E01, E02, E09, E12, E14 and E16. E07 was withdrawn and E10 is in DE.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv+padding run 3
6: E01, E02, E09, E12, E14 and E16.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv+padding run 4
6: E01, E02, E09, E12, E14 and E16. E07 is withdrawn and E10 is domiciled in DE.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv+padding run 5
6: E01, E02, E09, E12, E14 and E16. E07 is withdrawn, and E08 is domiciled in GR.
JSON: {"count": 6}
Why: count: expected 5, got 6