Q40, run 2026-11-04-1643-sonnet

← back to the run

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

❌ R1 csv run 1 graded by code

6: E01, E02, E09, E12, E14, E16.

JSON: {"count": 6}

Why: count: expected 5, got 6

❌ R1 csv run 2 graded by code

6: E01, E02, E09, E12, E14 and E16. E07 is withdrawn.

JSON: {"count": 6}

Why: count: expected 5, got 6

❌ R1 csv run 3 graded by code

6: E01, E02, E09, E12, E14 and E16. E07 is excluded because it was withdrawn.

JSON: {"count": 6}

Why: count: expected 5, got 6

❌ R1 csv run 4 graded by code

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

❌ R1 csv run 5 graded by code

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

❌ R2 rdf run 1 graded by code

6: E01, E02, E09, E12, E14 and E16. E07 is excluded because it was withdrawn.

JSON: {"count": 6}

Why: count: expected 5, got 6

❌ R2 rdf run 2 graded by code

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

✅ R2 rdf run 3 graded by code

5. They are E01, E02 (=E03), E09, E12 and E14. E07 is excluded because it was withdrawn.

JSON: {"count": 5}

❌ R2 rdf run 4 graded by code

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

❌ R2 rdf run 5 graded by code

6. These are E01, E02 (E03), E09, E12, E14 and E16. E07 is withdrawn.

JSON: {"count": 6}

Why: count: expected 5, got 6

✅ R6 rdf+ontology run 1 graded by code

5. These are E01, E02 (same entity as E03), E09, E12 and E14. E07 was withdrawn and E16 is QA.

JSON: {"count": 5}

✅ R6 rdf+ontology run 2 graded by code

5: E01, E02, E09, E12 and E14. E07 is excluded because its rating was withdrawn.

JSON: {"count": 5}

✅ R6 rdf+ontology run 3 graded by code

5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.

JSON: {"count": 5}

✅ R6 rdf+ontology run 4 graded by code

5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.

JSON: {"count": 5}

✅ R6 rdf+ontology run 5 graded by code

5: E01, E02, E09, E12 and E14.

JSON: {"count": 5}

✅ R5 csv+ontology run 1 graded by code

5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.

JSON: {"count": 5}

✅ R5 csv+ontology run 2 graded by code

5. They are E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.

JSON: {"count": 5}

✅ R5 csv+ontology run 3 graded by code

5. These are E01, E02, E09, E12 and E14. E07 is withdrawn, and E16 is QA.

JSON: {"count": 5}

✅ R5 csv+ontology run 4 graded by code

5. The GB issuers are E01, E02, E09, E12 and E14. E07 is withdrawn, and E16 is QA.

JSON: {"count": 5}

✅ R5 csv+ontology run 5 graded by code

5. The GB issuers with a rating were E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.

JSON: {"count": 5}

✅ R4 csv+markdown run 1 graded by code

5: E01, E02, E09, E12 and E14. E07 was withdrawn and E16 is QA.

JSON: {"count": 5}

✅ R4 csv+markdown run 2 graded by code

5: E01, E02, E09, E12 and E14. E10 is domiciled in DE (the RATINGS record holds), and E07 is withdrawn.

JSON: {"count": 5}

✅ R4 csv+markdown run 3 graded by code

5: E01, E02, E09, E12 and E14. E16 is QA and E07 is withdrawn.

JSON: {"count": 5}

✅ R4 csv+markdown run 4 graded by code

5: E01, E02, E09, E12 and E14. E07 is withdrawn and E16 is QA.

JSON: {"count": 5}

✅ R4 csv+markdown run 5 graded by code

5. These are E01, E02, E09, E12 and E14. E07 is withdrawn and E16 is QA.

JSON: {"count": 5}

❌ R3 csv+padding run 1 graded by code

6: E01, E02, E09, E12, E14 and E16. E07 is withdrawn.

JSON: {"count": 6}

Why: count: expected 5, got 6

❌ R3 csv+padding run 2 graded by code

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

❌ R3 csv+padding run 3 graded by code

6: E01, E02, E09, E12, E14 and E16.

JSON: {"count": 6}

Why: count: expected 5, got 6

❌ R3 csv+padding run 4 graded by code

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

❌ R3 csv+padding run 5 graded by code

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