Q38, run 2026-11-06-0808-sonnet-query
Which institutions is W71 credited to, at every level?
Tests: Local rule on affiliations, then the hierarchy: the Tessel Laboratory is listed last, so Halloran gets nothing.
Expected: institutions = ['I01', 'I02', 'I03', 'I04']
sql run 1
I06, I04, I03, I02, I01.
JSON: {"institutions": ["I06", "I04", "I03", "I02", "I01"]}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got ['I06', 'I04', 'I03', 'I02', 'I01']
sql run 2
I01, I02, I03, I04, I06. I06 and I04 are listed directly; the rest are their ancestors.
JSON: {"institutions": ["I01", "I02", "I03", "I04", "I06"]}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got ['I01', 'I02', 'I03', 'I04', 'I06']
sql run 3
I06, I04, I03, I02, I01.
JSON: {"institutions": ["I06", "I04", "I03", "I02", "I01"]}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got ['I06', 'I04', 'I03', 'I02', 'I01']
sql run 4
I06, I04, I03, I02, I01. W71 lists I06 and I04, and I04 rolls up through I03 and I02 to I01.
JSON: {"institutions": ["I06", "I04", "I03", "I02", "I01"]}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got ['I06', 'I04', 'I03', 'I02', 'I01']
sql run 5
I06, I04, I03, I02, I01.
JSON: {"institutions": ["I06", "I04", "I03", "I02", "I01"]}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got ['I06', 'I04', 'I03', 'I02', 'I01']
sql+markdown run 1
I04, I03, I02, I01. W71's last-listed affiliation is I04, and credit passes up through its parents.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sql+markdown run 2
I04, I03, I02, I01. W71's last-listed affiliation is I04, and its parents are credited too.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sql+markdown run 3
I04, I03, I02, I01. W71's last-listed affiliation is I04.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sql+markdown run 4
I04, I03, I02, I01. A08's last affiliation on W71 is I04, and credit passes up through its parents.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sql+markdown run 5
I04, I03, I02 and I01. W71's credited affiliation is I04 (sequence 2), and the work is also credited up its parent chain.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sql+executed run 1
I04, I03, I02, I01 (I04 and the three levels above it).
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sql+executed run 2
I04, I03, I02, I01.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sql+executed run 3
I04, I03, I02 and I01, from I04's chain of units.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sql+executed run 4
I04, I03, I02 and I01.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sql+executed run 5
I04, I03, I02, I01.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sparql run 1
I04, I03, I02, I01 and I06.
JSON: {"institutions": ["I04", "I03", "I02", "I01", "I06"]}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got ['I04', 'I03', 'I02', 'I01', 'I06']
sparql run 2
(no answer found)
Why: no structured answer
sparql run 3
I01, I02, I03, I04, I06.
JSON: {"institutions": ["I01", "I02", "I03", "I04", "I06"]}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got ['I01', 'I02', 'I03', 'I04', 'I06']
sparql run 4
I06, I04, I03, I02, I01.
JSON: {"institutions": ["I06", "I04", "I03", "I02", "I01"]}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got ['I06', 'I04', 'I03', 'I02', 'I01']
sparql run 5
I04, I06, I03, I02, I01.
JSON: {"institutions": ["I04", "I06", "I03", "I02", "I01"]}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got ['I04', 'I06', 'I03', 'I02', 'I01']
sparql+ontology run 1
I04, I03, I02, I01. W71's last-listed affiliation is I04.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sparql+ontology run 2
I04, I03, I02, I01. For W71 the last-listed affiliation is I04.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sparql+ontology run 3
(no answer found)
JSON: {"institutions": null}
Why: institutions: expected ['I01', 'I02', 'I03', 'I04'], got None
sparql+ontology run 4
I04, I03, I02 and I01. I04 is the last-listed affiliation on W71, and the others sit above it.
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}
sparql+ontology run 5
I04, I03, I02, I01. On W71 the credited affiliation is I04 (seq 2).
JSON: {"institutions": ["I04", "I03", "I02", "I01"]}