Q46, run 2026-11-04-2053-sonnet
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
csv run 1
I01. I06 is typed AFF (affiliated), but its parent_id chain leads to I02 and then I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
csv run 2
I01. The chain is I06, then I02, then I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
csv run 3
I01, via I02.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
csv run 4
I01 (I06 → I02 → I01).
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
csv run 5
I01.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
executed run 1
I01, following parent_id from I06 to I02 to I01. I06's works still count only toward I06 itself.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
executed run 2
I01 by the parent_id chain (I06, then I02, then I01). However, I06 is an affiliate, and institution_units does not roll it up into I02 or I01, so for counting it stands alone.
JSON: {"parent": "I01"}
Why: parent: expected I06, got I01
executed run 3
I06. Its parent_id points to I02, but it is an affiliate (AFF) and institution_units counts it only towards itself, so it doesn't roll up to I02 or I01. Read purely from parent_id, the answer would be I01.
JSON: {"parent": "I06"}
executed run 4
I06. Its parent_id is I02, but institution_units shows it counting only towards itself. If parent_id alone is followed, the answer would be I01.
JSON: {"parent": "I06"}
executed run 5
I06. It is listed with parent I02, but its type is AFF (affiliate) and institution_units counts its works only towards itself, so I treat it as having no parent in the hierarchy. If you read parent_id literally, the chain would give I01.
JSON: {"parent": "I06"}