Q51, run 2026-11-04-2024-sonnet-query
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
sql run 1
59, with duplicate records merged by LEI.
JSON: {"count": 59}
Why: count: expected 58, got 59
sql run 2
55.
JSON: {"count": 55}
Why: count: expected 58, got 55
sql run 3
55.
JSON: {"count": 55}
Why: count: expected 58, got 55
sql+markdown run 1
29.
JSON: {"count": 29}
Why: count: expected 58, got 29
sql+markdown run 2
58.
JSON: {"count": 58}
sql+markdown run 3
58.
JSON: {"count": 58}
sparql run 1
(no answer found)
JSON: {"count": 0}
Why: count: expected 58, got 0
sparql run 2
59. There are 55 members, plus 4 more reached through the E5167/E5005 duplicate.
JSON: {"count": 59}
Why: count: expected 58, got 59
sparql run 3
(no answer found)
JSON: {"count": 0}
Why: count: expected 58, got 0
sparql+ontology run 1
58, counting by LEI so duplicate records are not double-counted.
JSON: {"count": 58}
sparql+ontology run 2
59.
JSON: {"count": 59}
Why: count: expected 58, got 59
sparql+ontology run 3
58 distinct LEIs, after excluding the QA record E5170.
JSON: {"count": 58}
sql+executed run 1
58 entities: 57 with E5001 as ultimate parent, plus E5001.
JSON: {"count": 58}
sql+executed run 2
58.
JSON: {"count": 58}
sql+executed run 3
58.
JSON: {"count": 58}
sparql+axioms run 1
58 distinct entities (59 records, with E5167 a duplicate of E5005).
JSON: {"count": 58}
sparql+axioms run 2
(no answer found)
JSON: {"count": 50}
Why: count: expected 58, got 50
sparql+axioms run 3
58 distinct entities (59 records, with E5005 and E5167 merged).
JSON: {"count": 58}