Q46, run 2026-11-06-0519-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. The chain is I06 → I02 → I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql run 2
I01, via I02. I06 is typed as an affiliate (AFF), so it is not a full member of the system.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql run 3
I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql run 4
I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql run 5
I01. I06 sits under I02, which sits under I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql+markdown run 1
I06. It is an affiliated institute, so its parent link is not followed and it is its own ultimate parent.
JSON: {"parent": "I06"}
sql+markdown run 2
I06. It is an affiliated institute, so its parent link is not followed and its ultimate parent is itself.
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. It is an affiliated institute, so its parent link is not followed and its ultimate parent is itself.
JSON: {"parent": "I06"}
sql+markdown run 5
I06. It is an affiliated institute, so it is its own ultimate parent.
JSON: {"parent": "I06"}
sql+executed run 1
I01, going by parent_id (I06 → I02 → I01). However, I06 is an affiliate (AFF) that does not count towards I02 or I01, so it could also be read as having no counted parent.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql+executed run 2
I01, following the parent_id chain I06 to I02 to I01. This is ambiguous, because I06 is an affiliate whose works count only towards itself.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql+executed run 3
I01, going by the parent chain I06 → I02 → I01. I06 is only an affiliate: its works do not count towards I02 or I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sql+executed run 4
I06. It is linked to I02 only as an affiliate, and its works count towards no one else.
JSON: {"parent": "I06"}
sql+executed run 5
I01, going by the parent chain I06 → I02 → I01. However, institution_units has I06 counting only towards itself, so this is a nominal parent that does not count.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql run 1
I01. I06 → I02 → I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql run 2
I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql run 3
I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql run 4
I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql run 5
I01. The chain is I06 → I02 → I01.
**Q47, Q48.** Unresolved. I did not retrieve the data needed to explain these.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
sparql+ontology run 1
I06. It is an affiliated institute, so its parent link is not followed.
JSON: {"parent": "I06"}
sparql+ontology run 2
I06. As an affiliated institute (AFF), it is its own ultimate parent.
JSON: {"parent": "I06"}
sparql+ontology run 3
I06. It is an affiliated institute, so its ultimate parent is itself.
JSON: {"parent": "I06"}
sparql+ontology run 4
I06. It is an affiliated institute, so its ultimate parent is itself.
JSON: {"parent": "I06"}
sparql+ontology run 5
I06. It is an affiliated institute, so its parent link is not followed.
JSON: {"parent": "I06"}