Q2, run 2026-11-06-0808-sonnet-query
List every work, of any type, that Mara Ellison (A01) is an author of.
Tests: Identity: her works are spread over three author records, and A04's works (W08, W16) are not hers.
Expected: works = ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19']
sql run 1
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are the works of A01 (W01, W04, W05, W06, W12), A02 (W02, W07, W19) and A03 (W03).
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql run 2
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are all works credited to A01, A02 or A03.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql run 3
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are A01's works plus those under A02 and A03, the same person by ORCID.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql run 4
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are A01's works plus those of A02 (W02, W07, W19) and A03 (W03), who are the same person by ORCID.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql run 5
W01, W02, W03, W04, W05, W06, W07, W12, W19. This takes Mara Ellison as the one person behind A01, A02 and A03 (same ORCID); A01 alone is on W01, W04, W05, W06 and W12.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql+markdown run 1
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are the works of A01 (W01, W04, W05, W06, W12), A02 (W02, W07, W19) and A03 (W03), all the same person. W08 belongs to A04, a different person.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql+markdown run 2
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are all works recorded against A01, A02 or A03.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql+markdown run 3
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are the works recorded against A01, A02 and A03.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql+markdown run 4
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are the works of A01, A02 and A03, who are the same person.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql+markdown run 5
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are the works of A01, A02 and A03, the same person.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sql+executed run 1
W01, W03, W04, W05, W06, W07, W12, W19. These are all A01's credited works (W03 also covers W02).
JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19']
sql+executed run 2
W01, W03, W04, W05, W06, W07, W12, W19. These are all credited to A01; W03 also merges record W02.
JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19']
sql+executed run 3
W01, W03, W04, W05, W06, W07, W12, W19. These are all of A01's credits; W03 is merged with W02.
JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19']
sql+executed run 4
W01, W03, W04, W05, W06, W07, W12 and W19. These are all of A01's credited works, whatever their type.
JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19']
sql+executed run 5
W01, W03, W04, W05, W06, W07, W12, W19. These are the credits for A01. W03 also stands for the merged record W02.
JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19']
sparql run 1
W01, W02, W03, W04, W05, W06, W07, W12, W19. A01 authored W01, W04, W05, W06 and W12, and her alias records A02 and A03 add W02, W03, W07 and W19. Strictly under the A01 record alone, the list is W01, W04, W05, W06, W12.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sparql run 2
(no answer found)
Why: no structured answer
sparql run 3
W01, W02, W03, W04, W05, W06, W07, W12, W19, covering A01, A02 and A03 as one person.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sparql run 4
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are the authorships of A01, A02 and A03 combined.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sparql run 5
W01, W02, W03, W04, W05, W06, W07, W12, W19, covering any document type, under A01, A02 and A03.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sparql+ontology run 1
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are the works recorded against A01, A02 and A03, which all stand for Mara Ellison.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sparql+ontology run 2
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are the works of A01, A02 and A03, the same person. A04 (M. Ellison) has a different ORCID and is excluded.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sparql+ontology run 3
Not fully answered. A01 appears on W01–W08 and on many later works (W12–W35), but the output was truncated, so I can't give the complete list.
JSON: {"works": null}
Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19'], got None
sparql+ontology run 4
W01, W02, W03, W04, W05, W06, W07, W12, W19. These are the works of A01, A02 and A03, who are one person.
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}
sparql+ontology run 5
W01, W02, W03, W04, W05, W06, W07, W12, W19, counting the works of all three records (A01, A02, A03).
JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}