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

← back to the run

How many entities are in the Cerid Group plc group, the parent included?

Tests: Paths: every level of the tree, the QA record under the top left out, the RESEARCH record not counted twice.

Expected: count = 58

❌ D1 sql run 1 graded by code · query session

55.

JSON: {"count": 55}

Why: count: expected 58, got 55

❌ D1 sql run 2 graded by code · query session

59.

JSON: {"count": 59}

Why: count: expected 58, got 59

❌ D1 sql run 3 graded by code · query session

59, counting E5001 and de-duplicating E5167 (the same LEI as E5005).

JSON: {"count": 59}

Why: count: expected 58, got 59

❌ D1 sql run 4 graded by code · query session

(no answer found)

JSON: {"count": 59}

Why: count: expected 58, got 59

✅ D1 sql run 5 graded by code · query session

58. The recursion returned 59 because it counts the duplicate record E5167 separately.

JSON: {"count": 58}

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

58.

JSON: {"count": 58}

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

58.

JSON: {"count": 58}

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

58.

JSON: {"count": 58}

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

58.

JSON: {"count": 58}

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

58.

JSON: {"count": 58}

❌ D4 sparql run 1 graded by code · query session

166. The group query returned 167 records, one of which is the duplicate E5167.

JSON: {"count": 166}

Why: count: expected 58, got 166

❌ D4 sparql run 2 graded by code · query session

59. There are 55 members through E5001, plus 4 more (E5011, E5023, E5035, E5047) reached via the duplicate E5167.

JSON: {"count": 59}

Why: count: expected 58, got 59

❌ D4 sparql run 3 graded by code · query session

(no answer found)

JSON: {"count": null}

Why: count: expected 58, got None

❌ D4 sparql run 4 graded by code · query session

55.

JSON: {"count": 55}

Why: count: expected 58, got 55

❌ D4 sparql run 5 graded by code · query session

55.

JSON: {"count": 55}

Why: count: expected 58, got 55

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

(no answer found)

JSON: {"count": null}

Why: count: expected 58, got None

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

55, from a parent-chain count rooted at E5001.

JSON: {"count": 55}

Why: count: expected 58, got 55

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

59. The count of 58 descendants, merged by LEI, plus the top; earlier runs gave other figures.

JSON: {"count": 59}

Why: count: expected 58, got 59

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

58.

JSON: {"count": 58}

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

59.

JSON: {"count": 59}

Why: count: expected 58, got 59

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

58, which is 57 members plus the parent.

JSON: {"count": 58}

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

58.

JSON: {"count": 58}

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

58.

JSON: {"count": 58}

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

58.

JSON: {"count": 58}

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

58 (57 members plus the top).

JSON: {"count": 58}

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

58. The group has 59 records, one of which (E5167) is a duplicate of E5005.

JSON: {"count": 58}

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

58, counting the duplicate record E5167 as the same entity as E5005.

JSON: {"count": 58}

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

58.

JSON: {"count": 58}

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

(no answer found)

JSON: {"count": null}

Why: count: expected 58, got None

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

59, uncertain.

JSON: {"count": 59}

Why: count: expected 58, got 59