Q61, run 2026-11-05-1515-sonnet-query

← back to the run

How many members of the Cerid Group plc group, the top included, hold a foreign-currency issuer rating below investment grade?

Tests: Paths and test data: the QA record under the top has a B- rating, and is ignored.

Expected: count = 19

❌ D1 sql run 1 graded by code · query session

18, counting members rated BB+ or lower.

JSON: {"count": 18}

Why: count: expected 19, got 18

❌ D1 sql run 2 graded by code · query session

Not determined; I did not query this.

For Q54 to Q56 and Q61, the JSON holds placeholder values (empty list, "none", 0) that are not data-backed. Q55 and Q58 are partial.

JSON: {"count": 0}

Why: count: expected 19, got 0

❌ D1 sql run 3 graded by code · query session

20.

JSON: {"count": 20}

Why: count: expected 19, got 20

❌ D1 sql run 4 graded by code · query session

20.

Q6 has no JSON field, so I did not answer it. It would be explained by the E05 ratings above, but the data gives no stated reason.

JSON: {"count": 20}

Why: count: expected 19, got 20

❌ D1 sql run 5 graded by code · query session

20. This count merges E5167 into E5005.

JSON: {"count": 20}

Why: count: expected 19, got 20

✅ D2 sql+markdown run 1 graded by code · query session

19.

JSON: {"count": 19}

✅ D2 sql+markdown run 2 graded by code · query session

19.

JSON: {"count": 19}

✅ D2 sql+markdown run 3 graded by code · query session

19.

JSON: {"count": 19}

✅ D2 sql+markdown run 4 graded by code · query session

19. This counts group members whose current FC LTIDR is below BBB-.

JSON: {"count": 19}

✅ D2 sql+markdown run 5 graded by code · query session

19.

JSON: {"count": 19}

❌ D4 sparql run 1 graded by code · query session

Not determined. The query returned nothing usable.

JSON: {"count": null}

Why: count: expected 19, got None

❌ D4 sparql run 2 graded by code · query session

20, which is approximate. There are 18 below investment grade through E5001, plus E5023 (B-) and E5047 (BB) reached via the duplicate. E5011 and E5035 were not checked.

JSON: {"count": 20}

Why: count: expected 19, got 20

❌ D4 sparql run 3 graded by code · query session

(no answer found)

JSON: {"count": null}

Why: count: expected 19, got None

❌ D4 sparql run 4 graded by code · query session

18.

JSON: {"count": 18}

Why: count: expected 19, got 18

❌ D4 sparql run 5 graded by code · query session

18.

JSON: {"count": 18}

Why: count: expected 19, got 18

❌ D5 sparql+ontology run 1 graded by code · query session

(no answer found)

JSON: {"count": null}

Why: count: expected 19, got None

❌ D5 sparql+ontology run 2 graded by code · query session

(no answer found)

JSON: {"count": null}

Why: count: expected 19, got None

❌ D5 sparql+ontology run 3 graded by code · query session

Not determined.

JSON: {"count": 0}

Why: count: expected 19, got 0

❌ D5 sparql+ontology run 4 graded by code · query session

20.

JSON: {"count": 20}

Why: count: expected 19, got 20

❌ D5 sparql+ontology run 5 graded by code · query session

At least 4, but this is a lower bound. The full query timed out; I counted E5012, E5023, E5024 and E5047 from the ceiling list.

JSON: {"count": 4}

Why: count: expected 19, got 4

✅ D3 sql+executed run 1 graded by code · query session

19 members hold a sub-investment-grade FC rating.

JSON: {"count": 19}

✅ D3 sql+executed run 2 graded by code · query session

19 Cerid group members hold a foreign-currency issuer rating below investment grade.

JSON: {"count": 19}

✅ D3 sql+executed run 3 graded by code · query session

19.

JSON: {"count": 19}

✅ D3 sql+executed run 4 graded by code · query session

19.

JSON: {"count": 19}

✅ D3 sql+executed run 5 graded by code · query session

19.

JSON: {"count": 19}

✅ D6 sparql+axioms run 1 graded by code · query session

19.

JSON: {"count": 19}

✅ D6 sparql+axioms run 2 graded by code · query session

19.

JSON: {"count": 19}

✅ D6 sparql+axioms run 3 graded by code · query session

19.

JSON: {"count": 19}

❌ D6 sparql+axioms run 4 graded by code · query session

(no answer found)

JSON: {"count": null}

Why: count: expected 19, got None

✅ D6 sparql+axioms run 5 graded by code · query session

19.

JSON: {"count": 19}