Q2, run 2026-11-06-0519-sonnet-query

← back to the run

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', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984']

✅ D1 sql run 1 graded by code · query session

32 works, listed in the JSON: all works of A01, A02, A03 and A101, including the editorials, errata and preprints.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

✅ D1 sql run 2 graded by code · query session

32 works. These are every work linked to that ORCID (A01, A02, A03, A101), including the editorials, errata and preprints: W01, W02, W03, W04, W05, W06, W07, W12, W19, W206, W238, W271, W374, W449, W464, W555, W612, W663, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984, W1005, W1048, W1050.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984", "W1005", "W1048", "W1050"]}

✅ D1 sql run 3 graded by code · query session

32 works, found by ORCID across A01, A02, A03 and A101. The IDs are W01, W03, W06, W07, W12, W19, W206, W238, W374, W449, W464, W676, W763, W817, W843, W869, W905, W972, W984, W1005, W1048, W1050, W555 (articles), W04, W271, W936 (editorials), W05, W813, W949 (errata) and W02, W612, W663 (preprints).

JSON: {"works": ["W01", "W03", "W06", "W07", "W12", "W19", "W206", "W238", "W374", "W449", "W464", "W676", "W763", "W817", "W843", "W869", "W905", "W972", "W984", "W1005", "W1048", "W1050", "W555", "W04", "W271", "W936", "W05", "W813", "W949", "W02", "W612", "W663"]}

✅ D1 sql run 4 graded by code · query session

32 works (listed in the JSON), found by pooling the author records that share that ORCID (A01, A02, A03, A101). The list includes editorials, errata, preprints and the retracted W374.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

✅ D1 sql run 5 graded by code · query session

32 works, found through every author record with Mara's ORCID (A01, A02, A03, A101):
- A01: W01, W04, W05, W06, W1005, W12, W238, W271, W374, W464, W676, W813, W949
- A02: W02, W07, W1048, W1050, W19, W449, W663, W869, W972
- A03: W03, W206, W763, W817
- A101: W555, W612, W843, W905, W936, W984

JSON: {"works": ["W01", "W04", "W05", "W06", "W1005", "W12", "W238", "W271", "W374", "W464", "W676", "W813", "W949", "W02", "W07", "W1048", "W1050", "W19", "W449", "W663", "W869", "W972", "W03", "W206", "W763", "W817", "W555", "W612", "W843", "W905", "W936", "W984"]}

✅ D2 sql+markdown run 1 graded by code · query session

32 works: W01, W02, W03, W04, W05, W06, W07, W1005, W1048, W1050, W12, W19, W206, W238, W271, W374, W449, W464, W555, W612, W663, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984. These are the works on any of her four author records, including editorials, errata, a retracted work and works in delisted sources.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

✅ D2 sql+markdown run 2 graded by code · query session

32 works: W01, W02, W03, W04, W05, W06, W07, W12, W19, W206, W238, W271, W374, W449, W464, W555, W612, W663, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984, W1005, W1048, W1050. I took every record sharing ORCID 0000-0002-9841-6229.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984", "W1005", "W1048", "W1050"]}

❌ D2 sql+markdown run 3 graded by code · query session

W01, W04, W06, W09, W10, W11, W12. These are the works on A01, A02, A03 and A101, which share the ORCID.

JSON: {"works": ["W01", "W04", "W06", "W09", "W10", "W11", "W12"]}

Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984'], got ['W01', 'W04', 'W06', 'W09', 'W10', 'W11', 'W12']

✅ D2 sql+markdown run 4 graded by code · query session

32 works, listed in the JSON. They are every work against A01, A02, A03 or A101, since all share that ORCID, and they include the editorials, errata and the retracted W374. I did not check whether any of W555, W843, W905 and W984 is a staging record. The list is "of any type", so I kept them.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

✅ D2 sql+markdown run 5 graded by code · query session

32 works: the 29 listed below plus W01, W02, W03 and the rest of the list. They come from A01, A02, A03 and A101, which share one ORCID. A04 is a different ORCID, so W08 is excluded.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984", "W1005", "W1048", "W1050"]}

❌ D3 sql+executed run 1 graded by code · query session

29 works: W01, W03, W04, W05, W06, W07, W1005, W1048, W1050, W12, W19, W206, W238, W271, W374, W449, W464, W555, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984. These are all the credits for A01.

JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984']

❌ D3 sql+executed run 2 graded by code · query session

29 works: W01, W03, W04, W05, W06, W07, W1005, W1048, W1050, W12, W19, W206, W238, W271, W374, W449, W464, W555, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984. The list comes from credits for A01, and W03 is the merged W02/W03.

JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984']

❌ D3 sql+executed run 3 graded by code · query session

29 works: W01, W03, W04, W05, W06, W07, W1005, W1048, W1050, W12, W19, W206, W238, W271, W374, W449, W464, W555, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984. These are all works credited to A01, whatever their type.

JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984']

❌ D3 sql+executed run 4 graded by code · query session

29 works: W01, W03, W04, W05, W06, W07, W1005, W1048, W1050, W12, W19, W206, W238, W271, W374, W449, W464, W555, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984. These are all works credited to A01, any type.

JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984']

❌ D3 sql+executed run 5 graded by code · query session

29 works: W01, W03, W04, W05, W06, W07, W1005, W1048, W1050, W12, W19, W206, W238, W271, W374, W449, W464, W555, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984. These are the credits for A01.

JSON: {"works": ["W01", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984'], got ['W01', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984']

✅ D4 sparql run 1 graded by code · query session

32 works. Mara Ellison's records A01, A02, A03 and A101 all share one ORCID, and I included every document type, retracted ones too. The list is in the JSON.

JSON: {"works": ["W03", "W206", "W763", "W817", "W555", "W612", "W843", "W905", "W936", "W984", "W02", "W07", "W1048", "W1050", "W19", "W449", "W663", "W869", "W972", "W01", "W04", "W05", "W06", "W1005", "W12", "W238", "W271", "W374", "W464", "W676", "W813", "W949"]}

✅ D4 sparql run 2 graded by code · query session

The 32 works of that ORCID (A01, A02, A03 and A101), including the retracted W374 and the preprints. See the JSON.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

✅ D4 sparql run 3 graded by code · query session

32 works across Mara's records A01, A02, A03 and A101, which share one ORCID: W01, W02, W03, W04, W05, W06, W07, W12, W19, W206, W238, W271, W374, W449, W464, W555, W612, W663, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984, W1005, W1048, W1050.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984", "W1005", "W1048", "W1050"]}

✅ D4 sparql run 4 graded by code · query session

32 works are listed in the JSON, found by pooling A01, A02, A03 and A101 (same ORCID) across all work types.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

❌ D4 sparql run 5 graded by code · query session

26 works, using A01, A02 and A03 as one person: W01, W04, W05, W06, W1005, W12, W238, W271, W374, W464, W676, W813, W949 (A01); W02, W07, W1048, W1050, W19, W449, W663, W869, W972 (A02); W03, W206, W763, W817 (A03). Another record with that ORCID, A101, may add more, but its rows were not shown.

JSON: {"works": ["W01", "W04", "W05", "W06", "W1005", "W12", "W238", "W271", "W374", "W464", "W676", "W813", "W949", "W02", "W07", "W1048", "W1050", "W19", "W449", "W663", "W869", "W972", "W03", "W206", "W763", "W817"]}

Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984'], got ['W01', 'W04', 'W05', 'W06', 'W1005', 'W12', 'W238', 'W271', 'W374', 'W464', 'W676', 'W813', 'W949', 'W02', 'W07', 'W1048', 'W1050', 'W19', 'W449', 'W663', 'W869', 'W972', 'W03', 'W206', 'W763', 'W817']

❌ D5 sparql+ontology run 1 graded by code · query session

The works recorded against A01, A02 and A03, which are one person, include W01, W02, W03, W04, W05, W06, W07, W12 and W19. The result for this ORCID was truncated, so the list may be incomplete.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}

Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984'], got ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19']

❌ D5 sparql+ontology run 2 graded by code · query session

W01, W02, W03, W04, W05, W06, W07, W12, W19, via A01, A02 and A03. Further works on A101 were not listed.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19"]}

Why: works: expected ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W1005', 'W1048', 'W1050', 'W12', 'W19', 'W206', 'W238', 'W271', 'W374', 'W449', 'W464', 'W555', 'W612', 'W663', 'W676', 'W763', 'W813', 'W817', 'W843', 'W869', 'W905', 'W936', 'W949', 'W972', 'W984'], got ['W01', 'W02', 'W03', 'W04', 'W05', 'W06', 'W07', 'W12', 'W19']

✅ D5 sparql+ontology run 3 graded by code · query session

32 works: W01, W02, W03, W04, W05, W06, W07, W12, W19, W206, W238, W271, W374, W449, W464, W555, W612, W663, W676, W763, W813, W817, W843, W869, W905, W936, W949, W972, W984, W1005, W1048, W1050. These are the works of every author record with her ORCID. A04 (M. Ellison, a different ORCID) is excluded.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984", "W1005", "W1048", "W1050"]}

✅ D5 sparql+ontology run 4 graded by code · query session

The works found under that ORCID (A01, A02, A03, A101) are listed in the JSON. Up to 18 rows of the query were hidden, so the list may be incomplete.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}

✅ D5 sparql+ontology run 5 graded by code · query session

32 works: every work recorded against A01, A02, A03 or A101, which share that ORCID. They include editorials, errata, a retracted work and K0-source works.

JSON: {"works": ["W01", "W02", "W03", "W04", "W05", "W06", "W07", "W1005", "W1048", "W1050", "W12", "W19", "W206", "W238", "W271", "W374", "W449", "W464", "W555", "W612", "W663", "W676", "W763", "W813", "W817", "W843", "W869", "W905", "W936", "W949", "W972", "W984"]}