Q29, run 2026-11-06-0519-sonnet-query
Of the works citing "Drift-aware mapping with low-cost sonar" (either version), how many are self-citations at the level of authors, of the University of Albury (units included), and of countries?
Tests: Self-citation depends on the level; W12 is Mara Ellison under another record, W13 her co-author; W16 is the other M. Ellison.
Expected: author = 7 institution = 10 country = 20
sql run 1
7 works are author self-citations, 12 are University of Albury self-citations, and 21 are country self-citations.
JSON: {"author": 7, "institution": 12, "country": 21}
Why: institution: expected 10, got 12; country: expected 20, got 21
sql run 2
Self-citations at author level: 7, at University of Albury level: 11, and at country level: 21, out of 30 citing works.
JSON: {"author": 7, "institution": 11, "country": 21}
Why: institution: expected 10, got 11; country: expected 20, got 21
sql run 3
Author level 7, University of Albury level 12, country level 21. Of 30 citing works, 21 have a GB-affiliated author. This counts any citing work with a GB affiliation, assuming the cited work is also GB.
JSON: {"author": 7, "institution": 12, "country": 21}
Why: institution: expected 10, got 12; country: expected 20, got 21
sql run 4
Author level 7, University of Albury 12, country 21, out of 30 citing works.
JSON: {"author": 7, "institution": 12, "country": 21}
Why: institution: expected 10, got 12; country: expected 20, got 21
sql run 5
Author level 7, institution level (I02) 12, country level 21.
JSON: {"author": 7, "institution": 12, "country": 21}
Why: institution: expected 10, got 12; country: expected 20, got 21
sql+markdown run 1
Of the 27 citing works, 7 are author self-citations, 10 are University of Albury self-citations and 20 are country self-citations.
JSON: {"author": 7, "institution": 10, "country": 20}
sql+markdown run 2
Author level 7, University of Albury level 6, country level 20.
JSON: {"author": 7, "institution": 6, "country": 20}
Why: institution: expected 10, got 6
sql+markdown run 3
Author 1, institution 2, country 4.
JSON: {"author": 1, "institution": 2, "country": 4}
Why: author: expected 7, got 1; institution: expected 10, got 2; country: expected 20, got 4
sql+markdown run 4
Author 7, University of Albury 10, country 20.
JSON: {"author": 7, "institution": 10, "country": 20}
sql+markdown run 5
Author 7, institution 10, country 20.
JSON: {"author": 7, "institution": 10, "country": 20}
sql+executed run 1
Author 7, institution 10, country 20.
JSON: {"author": 7, "institution": 10, "country": 20}
sql+executed run 2
Of the 27 citing works, 7 are author self-citations, 10 are I02 self-citations and 20 are country self-citations.
JSON: {"author": 7, "institution": 10, "country": 20}
sql+executed run 3
Authors: 7. University of Albury: 10. Countries (GB): 20.
JSON: {"author": 7, "institution": 10, "country": 20}
sql+executed run 4
7 are author self-citations, 10 are University of Albury self-citations, and 20 are country self-citations.
JSON: {"author": 7, "institution": 10, "country": 20}
sql+executed run 5
Author level: 7. University of Albury level: 10. Country level: 20.
JSON: {"author": 7, "institution": 10, "country": 20}
sparql run 1
Among the 30 citing works, 7 are self-citations at the author level, 12 at the University of Albury level (units included) and 21 at the country level.
JSON: {"author": 7, "institution": 12, "country": 21}
Why: institution: expected 10, got 12; country: expected 20, got 21
sparql run 2
(no answer found)
JSON: {"author": 0, "institution": 0, "country": 0}
Why: author: expected 7, got 0; institution: expected 10, got 0; country: expected 20, got 0
sparql run 3
7 at author level, 12 at institution level, 21 at country level.
JSON: {"author": 7, "institution": 12, "country": 21}
Why: institution: expected 10, got 12; country: expected 20, got 21
sparql run 4
Author level 7, institution level 12 (University of Albury), country level 21 (GB).
JSON: {"author": 7, "institution": 12, "country": 21}
Why: institution: expected 10, got 12; country: expected 20, got 21
sparql run 5
(no answer found)
JSON: {"author": null, "institution": null, "country": null}
Why: author: expected 7, got None; institution: expected 10, got None; country: expected 20, got None
sparql+ontology run 1
Author 7, institution 10, country 20, out of the 27 valid citing works.
JSON: {"author": 7, "institution": 10, "country": 20}
sparql+ontology run 2
Not computable from the rows I saw. Rough estimates only: author 8, institution 10, country 12.
JSON: {"author": 8, "institution": 10, "country": 12}
Why: author: expected 7, got 8; country: expected 20, got 12
sparql+ontology run 3
Author 7, institution 10, country 20.
JSON: {"author": 7, "institution": 10, "country": 20}
sparql+ontology run 4
Author level 7, institution level 10 and country level 20.
JSON: {"author": 7, "institution": 10, "country": 20}
sparql+ontology run 5
Author 7, institution 10, country 19.
JSON: {"author": 7, "institution": 10, "country": 19}
Why: country: expected 20, got 19