Q46, run 2026-11-06-0808-sonnet-query
What is the ultimate parent of the Halloran Institute for Coastal Studies (I06)?
Tests: Local type: an affiliated institute's parent link is an agreement, not membership.
Expected: parent = I06
sql run 1
I01 (I06 → I02 → I01).
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql run 2
I01. The chain is I06 → I02 → I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql run 3
I01 (I06 → I02 → I01).
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql run 4
I01 (I06 → I02 → I01).
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql run 5
I01 (I06 → I02 → I01).
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql+markdown run 1
I06. As an affiliated institute, its parent link is not followed.
JSON: {"parent": "I06"}
sql+markdown run 2
I06. It is an affiliated institute, so its parent link is not followed.
JSON: {"parent": "I06"}
sql+markdown run 3
I06. It is an affiliated institute, so its parent link is not followed.
JSON: {"parent": "I06"}
sql+markdown run 4
I06 itself. It is an affiliated institute, so its parent link is not followed.
JSON: {"parent": "I06"}
sql+markdown run 5
I06. As an affiliated institute, it is its own ultimate parent.
JSON: {"parent": "I06"}
sql+executed run 1
I01, going by the parent_id chain I06 → I02 → I01. Caveat: I06 is typed AFF and institution_units gives it no roll-up, so it is not truly part of that hierarchy.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql+executed run 2
I06. It is an affiliated institution (type AFF) whose institution_units row counts only toward itself, so it has no rollup parent. Its parent_id does name I02, so if you read the raw parent chain instead, the ultimate parent would be I01.
JSON: {"parent": "I06"}
sql+executed run 3
I01, following the `parent_id` chain I06 → I02 → I01. This is not a roll-up, since I06's works do not count towards I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql+executed run 4
I06. It is an affiliate whose works count only towards itself, although its parent_id field says I02. If you read parent_id literally, the answer would be I01.
JSON: {"parent": "I06"}
sql+executed run 5
I06. It is an affiliated institution whose institution_units row counts only towards itself. Its parent_id lists I02, but that is an affiliation and not a roll-up. If you read parent_id literally, the answer would be I01.
JSON: {"parent": "I06"}
sparql run 1
I01. I06's parent is I02, whose parent is I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql run 2
(no answer found)
Why: no structured answer
sparql run 3
I01 (I06 → I02 → I01).
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql run 4
I01 (I06 → I02 → I01).
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql run 5
I01, via I06 → I02 → I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql+ontology run 1
I06. For an affiliated institute the parent link is not followed.
JSON: {"parent": "I06"}
sparql+ontology run 2
I06. As an affiliated institute, it is its own ultimate parent.
JSON: {"parent": "I06"}
sparql+ontology run 3
I06. As an affiliated institute (AFF), its parent link is not followed, so it is its own ultimate parent.
JSON: {"parent": "I06"}
sparql+ontology run 4
I06. As an affiliated institute, its ultimate parent is itself.
JSON: {"parent": "I06"}
sparql+ontology run 5
I06. As an affiliated institute, its ultimate parent is itself.
JSON: {"parent": "I06"}