Q37, run 2026-11-06-0519-sonnet-query
Which institution is W70 credited to?
Tests: Local rule: only the affiliation listed last counts.
Expected: institution = I06
sql run 1
I04. Its `affil_seq` is 1 on W70, while I06 is the second affiliation.
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sql run 2
I04, the Tessel Laboratory, which is the first-listed affiliation.
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sql run 3
I04. W70 lists I04 first (affil_seq 1) and I06 second.
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sql run 4
I04 (Tessel Laboratory), listed first on W70. The data also credits W70 to I06, so one institution does not fully settle this.
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sql run 5
I04. W70 lists I04 first and I06 second.
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sql+markdown run 1
I06. The author of W70 (A08) listed I04 first and I06 last, and only the last-listed affiliation counts.
JSON: {"institution": "I06"}
sql+markdown run 2
I06. W70 is credited to the affiliated institute I06, and the data shows the Tessel Laboratory was not the credited affiliation (the last-listed one counts).
JSON: {"institution": "I06"}
sql+markdown run 3
I06. A08 listed I04 first and I06 last, and only the last-listed affiliation counts.
JSON: {"institution": "I06"}
sql+markdown run 4
I06. Its author's last-listed affiliation on W70 (sequence 2) is I06, so the work is credited there.
JSON: {"institution": "I06"}
sql+markdown run 5
I06. W70 lists I04 at sequence 1 and I06 at sequence 2, and only the last one is credited. I06 is an affiliated institute, so nothing above it is credited.
JSON: {"institution": "I06"}
sql+executed run 1
I06.
JSON: {"institution": "I06"}
sql+executed run 2
I06. W70 is credited to I06 through author A08.
JSON: {"institution": "I06"}
sql+executed run 3
I06.
JSON: {"institution": "I06"}
sql+executed run 4
I06, the Halloran Institute for Coastal Studies.
JSON: {"institution": "I06"}
sql+executed run 5
I06. W70 is credited to I06 through author A08.
JSON: {"institution": "I06"}
sparql run 1
I04, though W70 is also credited to I06 on a second authorship line, so the data does not give a single answer.
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sparql run 2
I04. W70 lists I04 and I06.
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sparql run 3
I04. W70 is also credited to I06, which the single-ID field cannot hold.
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sparql run 4
I04, the Tessel Laboratory, though the authorship rows also show I06 on W70. The data I retrieved did not settle why W70 is excluded from Albury's output (see Q48).
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sparql run 5
I04. W70 lists I04 and I06 under the same author, with I04 first.
JSON: {"institution": "I04"}
Why: institution: expected I06, got I04
sparql+ontology run 1
I06. W70's author A08 gave I04 at sequence 1 and I06 at sequence 2, and only the highest sequence counts.
JSON: {"institution": "I06"}
sparql+ontology run 2
I06. The author's highest affiliation sequence on W70 is 2, which is I06.
JSON: {"institution": "I06"}
sparql+ontology run 3
I06. W70's author A08 lists I04 at sequence 1 and I06 at sequence 2, and the last-listed affiliation is the one credited.
JSON: {"institution": "I06"}
sparql+ontology run 4
I06. W70's author listed I04 with sequence 1 and I06 with sequence 2, and the highest sequence is the one credited.
JSON: {"institution": "I06"}
sparql+ontology run 5
I06. A08 lists I04 with sequence 1 and I06 with sequence 2, and only the last-listed affiliation counts.
JSON: {"institution": "I06"}