Q40, run 2026-11-04-1711-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 and 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.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv run 4
6: E01, E02, E09, E12, E14 and E16. E07 is withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv run 5
6: E01, E02, E09, E12, E14 and E16. E07 is withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
rdf run 1
6: E01, E02/E03, 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 and E16.
JSON: {"count": 6}
Why: count: expected 5, got 6
rdf run 3
6: E01, E02, E09, E12, E14 and E16. E07 was withdrawn, and E03 is E02.
JSON: {"count": 6}
Why: count: expected 5, got 6
rdf run 4
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 5
6 (E01, E02, E09, E12, E14, E16). E07 was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6
rdf+ontology run 1
5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
rdf+ontology run 2
5: E01, E02 (with E03), E09, E12 and E14. E07 is withdrawn and E16 is QA.
JSON: {"count": 5}
rdf+ontology run 3
5: E01, E02, E09, E12 and E14. E07 is withdrawn and E16 is QA.
JSON: {"count": 5}
rdf+ontology run 4
5. These are E01, E02, E09, E12 and E14. E07 is withdrawn and E16 is QA.
JSON: {"count": 5}
rdf+ontology run 5
5: E01, E02 (with E03), E09, E12 and E14. E07 is withdrawn and E16 is a QA record.
JSON: {"count": 5}
csv+ontology run 1
5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA. E10 is DE in the RATINGS record, which holds over E17's LU.
JSON: {"count": 5}
csv+ontology run 2
5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
csv+ontology run 3
5: E01, E02, E09, E12 and E14. E07 was withdrawn, E16 is QA, and E10 is domiciled in DE.
JSON: {"count": 5}
csv+ontology run 4
5: E01, E02, E09, E12 and E14. E07 was withdrawn, and E10 is domiciled in DE per the RATINGS record.
JSON: {"count": 5}
csv+ontology run 5
5: E01, E02, E09, E12 and E14. E10 is DE in the RATINGS record, and E07 and E16 are excluded.
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. E07's rating was withdrawn, and E16 is QA.
JSON: {"count": 5}
csv+markdown run 3
5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA data.
JSON: {"count": 5}
csv+markdown run 4
5. These are E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.
JSON: {"count": 5}
csv+markdown run 5
5: E01, E02, E09, E12 and E14.
JSON: {"count": 5}
csv+padding run 1
6: E01, E02, E09, E12, E14 and E16. E07 was 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 domiciled in DE.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv+padding run 3
6: E01, E02, E09, E12, E14 and E16. E07 is withdrawn, and E10 is in DE.
JSON: {"count": 6}
Why: count: expected 5, got 6
csv+padding run 4
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
csv+padding run 5
6: E01, E02, E09, E12, E14 and E16. E07 was withdrawn.
JSON: {"count": 6}
Why: count: expected 5, got 6