D4 sparql, run 3: the query session

34 queries2 failed8 rounds

The opening prompt

## The data

You can't see the data, but you can query it. It is in an RDF store, described below. Write SPARQL 1.1 SELECT or ASK queries.

To run queries, reply with one or more fenced blocks (```sparql), and nothing else is needed:
each is run and its results sent back to you. You have up to 8 rounds of queries.
When you have what you need, reply with the final answers and no queries.

Prefixes:
```
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX res: <https://example.org/research/>
```

Classes and the properties their resources use:

- `res:Author`: `rdf:type`, `rdfs:label`, `res:name`, `res:orcid`
- `res:Authorship`: `rdf:type`, `rdfs:label`, `res:affiliationSeq`, `res:author`, `res:authorPosition`, `res:institution`, `res:work`
- `res:Citation`: `rdf:type`, `rdfs:label`, `res:citedWork`, `res:citingWork`
- `res:Institution`: `rdf:type`, `rdfs:label`, `res:country`, `res:institutionType`, `res:name`, `res:parent`, `res:ror`
- `res:Source`: `rdf:type`, `rdfs:label`, `res:issn`, `res:name`, `res:sourceType`, `res:tier`
- `res:Work`: `rdf:type`, `rdfs:label`, `res:doi`, `res:recordSource`, `res:retracted`, `res:source`, `res:title`, `res:versionOf`, `res:workType`, `res:year`

## Questions

Answer each question below from the data above. Start each answer on a new line with its
number in bold, like **Q1.**, give the direct answer first, then at most two sentences of
reasoning that cite the records (IDs) you relied on.

Then end with one JSON block (```json) holding the structured answer to each question listed
here, with exactly these fields, shaped like {"Q1": {"field": value}, ...}. Name works, authors, institutions and sources by their record ID: the work_id, author_id, institution_id or source_id in the CSV files, or the part of the IRI after res: in the RDF (W01, A07, I02, S03; not their titles or names).

- Q1: count (a number)
- Q2: works (a list of record IDs)
- Q3: same ("yes", "no" or "depends")
- Q4: count (a number)
- Q5: same ("yes", "no" or "depends")
- Q6: author (a record ID)
- Q7: count (a number)
- Q8: parent (a record ID)
- Q9: count (a number)
- Q10: count (a number)
- Q11: count (a number)
- Q12: full (a number), fractional (a number)
- Q13: full (a record ID), fractional (a record ID)
- Q14: full (a number), fractional (a number)
- Q15: count (a number)
- Q16: count (a number)
- Q17: works (a list of record IDs)
- Q18: count (a number)
- Q19: count (a number)
- Q20: works (a list of record IDs)
- Q21: count (a number)
- Q22: more_in_total (a record ID), more_in_window (a record ID)
- Q23: total (a number), in_window (a number)
- Q24: count (a number)
- Q25: count (a number)
- Q26: counts ("yes", "no" or "depends")
- Q27: institution (a record ID), citing_works (a number)
- Q28: count (a number)
- Q29: author (a number), institution (a number), country (a number)
- Q30: count (a number)
- Q31: works (a list of record IDs)
- Q32: count (a number)
- Q33: work (a record ID)
- Q34: count (a number)
- Q35: count (a number)
- Q36: count (a number)
- Q37: institution (a record ID)
- Q38: institutions (a list of record IDs)
- Q39: count (a number)
- Q40: source (a record ID)
- Q41: higher ("yes", "no" or "depends")
- Q42: count (a number)
- Q43: research ("yes", "no" or "depends")
- Q44: institutions (a list of record IDs)
- Q45: count (a number)
- Q46: parent (a record ID)

Q1. How many distinct people do the author records named "Mara Ellison", "M. Ellison" and "Ellison, Mara J." stand for?
Q2. List every work, of any type, that Mara Ellison (A01) is an author of.
Q3. Is the Jonas Brandt who wrote W37 the same person as the Jonas Brandt who wrote W38?
Q4. How many research works has the Jonas Brandt of Albury Metropolitan University (A05) authored?
Q5. Is the M. Ellison who wrote W08 the same person as the Mara Ellison who wrote W01?
Q6. Which author has the most research works credited to the University of Albury, its units included?
Q7. How many research works has Mara Ellison authored?
Q8. What is the ultimate parent of the Tessel Laboratory for Ocean Sensing (I04)?
Q9. How many research works is the University of Albury (I02) credited with, its units included?
Q10. How many research works is the Albury University System (I01) credited with, all its units included?
Q11. How many research works is Kesting University (I07) credited with, its units included?
Q12. How many research works did Kesting University (I07, units included) publish in 2024, under full counting and under fractional counting (each work split equally among its authors)?
Q13. In 2024, which had more research works, Kesting University (I07) or Rostval Technical University (I09): under full counting, and under fractional counting?
Q14. How many research works did GB institutions publish in 2024, under full counting and under fractional counting (each work split equally among its authors, each author's share going to their institution's country)?
Q15. How many research works appeared in Ocean Sensing Letters (S02) in 2024?
Q16. How many research works appeared in the Journal of Marine Autonomy (S01)?
Q17. Which of Mara Ellison's works are not research output because of their document type?
Q18. How many distinct research works has Priya Ramanathan (A07) authored?
Q19. How many distinct works cite "Drift-aware mapping with low-cost sonar", in either of its versions?
Q20. Which works in the data are preprints of another work that is also in the data?
Q21. How many research works is Oskel Polytechnic (I14) credited with?
Q22. Which has more citations, W30 or W31 (counting both versions of each): in total, and within its publication year and the two years after?
Q23. How many citations has W30 received in total, and how many within its publication year and the two years after?
Q24. How many research works has Lena Vossberg (A09) authored?
Q25. What is the total of the citation counts of Lena Vossberg's research works?
Q26. Does W23 count towards Kesting University's research output?
Q27. Which other institution's works cite Kesting University's research works the most, each citing work counted once per institution, and how many of its works do?
Q28. How many distinct works from Rostval Technical University (I09) cite Kesting University's research works?
Q29. 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?
Q30. Of the works citing "Drift-aware mapping with low-cost sonar" (either version), how many are self-citations at the level of the Albury University System?
Q31. Which works cite at least one of the works that cite W01?
Q32. How many distinct works are within two citation hops of W01 (citing it, or citing a work that cites it)?
Q33. Which of Kesting University's research works has the most citations?
Q34. How many research works was Kesting University (units included) credited with in 2025?
Q35. How many research works is the Kesting Institute of Hydrodynamics (I08) credited with?
Q36. How many research works appeared in the Proceedings of the Hydrodynamics Forum (S06)?
Q37. Which institution is W70 credited to?
Q38. Which institutions is W71 credited to, at every level?
Q39. How many of the University of Albury's research works (units included) appeared in a source of the highest tier?
Q40. Which source is in the highest tier?
Q41. Is Coastal Engineering Review (S03) in a higher tier than Ocean Sensing Letters (S02)?
Q42. How many research works appeared in Global Marine Science Reports (S04)?
Q43. Is W07 research output?
Q44. Which institutions are part of the Albury University System, at any level below it?
Q45. How many research works is the Halloran Institute for Coastal Studies (I06) credited with?
Q46. What is the ultimate parent of the Halloran Institute for Coastal Studies (I06)?
Q47. Why do Kesting University and Rostval Technical University swap places in 2024 between full and fractional counting?
Q48. Why is W70 not one of the University of Albury's research works, though its author lists the Tessel Laboratory?

The model

I'll start by exploring the data.

```sparql
SELECT ?s ?p ?o WHERE {
  ?s a ?c . VALUES ?c { res:Author res:Institution res:Source }
  ?s ?p ?o . FILTER(?p != rdf:type)
} ORDER BY ?s ?p
```

```sparql
SELECT ?s ?p ?o WHERE {
  ?s a res:Work . ?s ?p ?o . FILTER(?p != rdf:type)
} ORDER BY ?s ?p
```

Query results

Query 1:

| s | p | o |
|---|---|---|
| res:A01 | rdfs:label | Mara Ellison |
| res:A01 | res:name | Mara Ellison |
| res:A01 | res:orcid | 0000-0002-9841-6229 |
| res:A02 | rdfs:label | M. Ellison |
| res:A02 | res:name | M. Ellison |
| res:A02 | res:orcid | 0000-0002-9841-6229 |
| res:A03 | rdfs:label | Ellison, Mara J. |
| res:A03 | res:name | Ellison, Mara J. |
| res:A03 | res:orcid | 0000-0002-9841-6229 |
| res:A04 | rdfs:label | M. Ellison |
| res:A04 | res:name | M. Ellison |
| res:A04 | res:orcid | 0000-0004-8662-8360 |
| res:A05 | rdfs:label | Jonas Brandt |
| res:A05 | res:name | Jonas Brandt |
| res:A05 | res:orcid | 0000-0001-6105-5008 |
| res:A06 | rdfs:label | Jonas Brandt |
| res:A06 | res:name | Jonas Brandt |
| res:A06 | res:orcid | 0000-0007-5475-1779 |
| res:A07 | rdfs:label | Priya Ramanathan |
| res:A07 | res:name | Priya Ramanathan |
| res:A07 | res:orcid | 0000-0009-2298-3695 |
| res:A08 | rdfs:label | Tomasz Wierzba |
| res:A08 | res:name | Tomasz Wierzba |
| res:A08 | res:orcid | 0000-0007-9318-6032 |
| res:A09 | rdfs:label | Lena Vossberg |
| res:A09 | res:name | Lena Vossberg |
| res:A09 | res:orcid | 0000-0000-8073-7028 |
| res:A10 | rdfs:label | Dirk Hallmann |
| res:A10 | res:name | Dirk Hallmann |
| res:A10 | res:orcid | 0000-0003-8222-6468 |
| res:A101 | rdfs:label | M. Ellison |
| res:A101 | res:name | M. Ellison |
| res:A101 | res:orcid | 0000-0002-9841-6229 |
| res:A102 | rdfs:label | M. Ellison |
| res:A102 | res:name | M. Ellison |
| res:A102 | res:orcid | 0000-0008-4738-8328 |
| res:A103 | rdfs:label | L. Vossberg |
| res:A103 | res:name | L. Vossberg |
| res:A103 | res:orcid | 0000-0000-8073-7028 |
| res:A104 | rdfs:label | J. Brandt |
| res:A104 | res:name | J. Brandt |
| res:A104 | res:orcid | 0000-0001-6105-5008 |
| res:A105 | rdfs:label | Jonas Brandt |
| res:A105 | res:name | Jonas Brandt |
| res:A105 | res:orcid | 0000-0004-9046-7961 |
| res:A106 | rdfs:label | T. Wierzba |
| res:A106 | res:name | T. Wierzba |
| res:A106 | res:orcid | 0000-0007-9318-6032 |
| res:A107 | rdfs:label | S. de Raat |
| res:A107 | res:name | S. de Raat |
| res:A107 | res:orcid | 0000-0006-1642-5247 |
| res:A108 | rdfs:label | Priya Ramanathan |
| res:A108 | res:name | Priya Ramanathan |
| res:A108 | res:orcid | 0000-0007-1802-8393 |
| res:A109 | rdfs:label | Greta Yelland |
| res:A109 | res:name | Greta Yelland |
| res:A109 | res:orcid | 0000-0002-6545-4969 |
| res:A11 | rdfs:label | Sofie de Raat |
| res:A11 | res:name | Sofie de Raat |
| res:A11 | res:orcid | 0000-0006-1642-5247 |
(662 more rows not shown)

Query 2:

| s | p | o |
|---|---|---|
| res:W01 | rdfs:label | Adaptive path planning for underwater gliders |
| res:W01 | res:doi | 10.55555/s01.2021.1465 |
| res:W01 | res:recordSource | res:origin-FEED |
| res:W01 | res:retracted | false |
| res:W01 | res:source | res:S01 |
| res:W01 | res:title | Adaptive path planning for underwater gliders |
| res:W01 | res:workType | res:wtype-ART |
| res:W01 | res:year | 2021 |
| res:W02 | rdfs:label | Drift-aware mapping with low-cost sonar |
| res:W02 | res:doi | 10.55555/s05.2022.2911 |
| res:W02 | res:recordSource | res:origin-FEED |
| res:W02 | res:retracted | false |
| res:W02 | res:source | res:S05 |
| res:W02 | res:title | Drift-aware mapping with low-cost sonar |
| res:W02 | res:versionOf | res:W03 |
| res:W02 | res:workType | res:wtype-PPR |
| res:W02 | res:year | 2022 |
| res:W03 | rdfs:label | Drift-aware mapping with low-cost sonar |
| res:W03 | res:doi | 10.55555/s02.2023.9437 |
| res:W03 | res:recordSource | res:origin-FEED |
| res:W03 | res:retracted | false |
| res:W03 | res:source | res:S02 |
| res:W03 | res:title | Drift-aware mapping with low-cost sonar |
| res:W03 | res:workType | res:wtype-ART |
| res:W03 | res:year | 2023 |
| res:W04 | rdfs:label | Editorial: a new decade of marine autonomy |
| res:W04 | res:doi | 10.55555/s01.2023.1032 |
| res:W04 | res:recordSource | res:origin-FEED |
| res:W04 | res:retracted | false |
| res:W04 | res:source | res:S01 |
| res:W04 | res:title | Editorial: a new decade of marine autonomy |
| res:W04 | res:workType | res:wtype-EDT |
| res:W04 | res:year | 2023 |
| res:W05 | rdfs:label | Erratum: Drift-aware mapping with low-cost sonar |
| res:W05 | res:doi | 10.55555/s02.2024.7136 |
| res:W05 | res:recordSource | res:origin-FEED |
| res:W05 | res:retracted | false |
| res:W05 | res:source | res:S02 |
| res:W05 | res:title | Erratum: Drift-aware mapping with low-cost sonar |
| res:W05 | res:workType | res:wtype-ERR |
| res:W05 | res:year | 2024 |
| res:W06 | rdfs:label | Shoreline change detection from glider transects |
| res:W06 | res:doi | 10.55555/s03.2024.2042 |
| res:W06 | res:recordSource | res:origin-FEED |
| res:W06 | res:retracted | false |
| res:W06 | res:source | res:S03 |
| res:W06 | res:title | Shoreline change detection from glider transects |
| res:W06 | res:workType | res:wtype-ART |
| res:W06 | res:year | 2024 |
| res:W07 | rdfs:label | Low-cost sonar arrays for coastal monitoring |
| res:W07 | res:doi | 10.55555/s04.2020.7029 |
| res:W07 | res:recordSource | res:origin-FEED |
| res:W07 | res:retracted | false |
| res:W07 | res:source | res:S04 |
| res:W07 | res:title | Low-cost sonar arrays for coastal monitoring |
| res:W07 | res:workType | res:wtype-ART |
| res:W07 | res:year | 2020 |
| res:W08 | rdfs:label | Turbulent wake modelling behind tidal turbines |
| res:W08 | res:doi | 10.55555/s01.2025.5958 |
| res:W08 | res:recordSource | res:origin-FEED |
(6763 more rows not shown)

Run more queries, or give the final answers.

The model

<invoke name="sparql">
SELECT ?s ?p ?o WHERE {
  ?s a ?c . VALUES ?c { res:Institution res:Source }
  ?s ?p ?o . FILTER(?p != rdf:type && ?p != rdfs:label)
} ORDER BY ?s ?p
</invoke>
```

```sparql
SELECT ?s ?p ?o WHERE {
  ?s ?p ?o . FILTER(!STRSTARTS(STR(?s),"https://example.org/research/W") && !STRSTARTS(STR(?s),"https://example.org/research/A") && !STRSTARTS(STR(?s),"https://example.org/research/I") && !STRSTARTS(STR(?s),"https://example.org/research/S") && !STRSTARTS(STR(?s),"https://example.org/research/C"))
} LIMIT 200
```

Query results

Query 1:

(no rows)

Query 2:

| s | p | o |
|---|---|---|
| res:I01 | res:country | GB |
| res:I01 | res:institutionType | res:itype-SYS |
| res:I01 | res:name | Albury University System |
| res:I01 | res:ror | 0hygr4985 |
| res:I02 | res:country | GB |
| res:I02 | res:institutionType | res:itype-UNI |
| res:I02 | res:name | University of Albury |
| res:I02 | res:parent | res:I01 |
| res:I02 | res:ror | 06safhw22 |
| res:I03 | res:country | GB |
| res:I03 | res:institutionType | res:itype-LAB |
| res:I03 | res:name | Albury Centre for Marine Robotics |
| res:I03 | res:parent | res:I02 |
| res:I03 | res:ror | 06a9yq342 |
| res:I04 | res:country | GB |
| res:I04 | res:institutionType | res:itype-LAB |
| res:I04 | res:name | Tessel Laboratory for Ocean Sensing |
| res:I04 | res:parent | res:I03 |
| res:I04 | res:ror | 0002ezf81 |
| res:I05 | res:country | GB |
| res:I05 | res:institutionType | res:itype-UNI |
| res:I05 | res:name | Albury Metropolitan University |
| res:I05 | res:parent | res:I01 |
| res:I05 | res:ror | 0ww7kxb57 |
| res:I06 | res:country | GB |
| res:I06 | res:institutionType | res:itype-AFF |
| res:I06 | res:name | Halloran Institute for Coastal Studies |
| res:I06 | res:parent | res:I02 |
| res:I06 | res:ror | 0175f3924 |
| res:I07 | res:country | DE |
| res:I07 | res:institutionType | res:itype-UNI |
| res:I07 | res:name | Kesting University |
| res:I07 | res:ror | 0593t4875 |
| res:I08 | res:country | DE |
| res:I08 | res:institutionType | res:itype-LAB |
| res:I08 | res:name | Kesting Institute of Hydrodynamics |
| res:I08 | res:parent | res:I07 |
| res:I08 | res:ror | 0brjdg570 |
| res:I09 | res:country | NL |
| res:I09 | res:institutionType | res:itype-UNI |
| res:I09 | res:name | Rostval Technical University |
| res:I09 | res:ror | 0k8rh7879 |
| res:I10 | res:country | NL |
| res:I10 | res:institutionType | res:itype-CO |
| res:I10 | res:name | Marrow Instruments BV |
| res:I10 | res:ror | 0t3x83535 |
| res:I11 | res:country | FR |
| res:I11 | res:institutionType | res:itype-GOV |
| res:I11 | res:name | Brevin Ocean Agency |
| res:I11 | res:ror | 0wvack776 |
| res:I12 | res:country | FR |
| res:I12 | res:institutionType | res:itype-UNI |
| res:I12 | res:name | Université de Lorvain |
| res:I12 | res:ror | 091pt9775 |
| res:I13 | res:country | GB |
| res:I13 | res:institutionType | res:itype-UNI |
| res:I13 | res:name | Dunmore College |
| res:I13 | res:ror | 095cwy722 |
| res:I14 | res:country | NL |
| res:I14 | res:institutionType | res:itype-UNI |
(127 more rows not shown)

Run more queries, or give the final answers.

The model

```sparql
SELECT ?s (GROUP_CONCAT(CONCAT(STRAFTER(STR(?p),"research/"),"=",STR(?o));separator="; ") AS ?props) WHERE {
  ?s a ?c . VALUES ?c { res:Source } ?s ?p ?o . FILTER(?p != rdf:type)
} GROUP BY ?s ORDER BY ?s
```

```sparql
SELECT ?s (GROUP_CONCAT(CONCAT(STRAFTER(STR(?p),"research/"),"=",STR(?o));separator="; ") AS ?props) WHERE {
  ?s a res:Institution . FILTER(?s NOT IN (res:I01,res:I02,res:I03,res:I04,res:I05,res:I06,res:I07,res:I08,res:I09,res:I10,res:I11,res:I12,res:I13))
  ?s ?p ?o . FILTER(?p != rdf:type && ?p != res:ror)
} GROUP BY ?s ORDER BY ?s
```

```sparql
SELECT ?s ?p ?o WHERE {
  ?s ?p ?o . FILTER(REGEX(STR(?s),"research/(wtype|itype|tier|origin|stype)"))
} ORDER BY ?s ?p
```

Query results

Query 1:

| s | props |
|---|---|
| res:S01 | name=Journal of Marine Autonomy; tier=https://example.org/research/tier-K3; issn=9866-3925; =Journal of Marine Autonomy; sourceType=https://example.org/research/stype-JOU |
| res:S02 | =Ocean Sensing Letters; tier=https://example.org/research/tier-K2; sourceType=https://example.org/research/stype-JOU; issn=3195-4973; name=Ocean Sensing Letters |
| res:S03 | =Coastal Engineering Review; sourceType=https://example.org/research/stype-JOU; name=Coastal Engineering Review; issn=1154-9679; tier=https://example.org/research/tier-K1 |
| res:S04 | =Global Marine Science Reports; issn=8864-5325; tier=https://example.org/research/tier-K0; name=Global Marine Science Reports; sourceType=https://example.org/research/stype-JOU |
| res:S05 | =OceanArXiv; name=OceanArXiv; sourceType=https://example.org/research/stype-REP |
| res:S06 | issn=9804-2748; =Proceedings of the Hydrodynamics Forum; sourceType=https://example.org/research/stype-JOU; name=Proceedings of the Hydrodynamics Forum; tier=https://example.org/research/tier-K2 |
| res:S07 | issn=1483-2835; name=Journal of Estuarine Dynamics; sourceType=https://example.org/research/stype-JOU; tier=https://example.org/research/tier-K2; =Journal of Estuarine Dynamics |
| res:S08 | sourceType=https://example.org/research/stype-JOU; issn=9832-2482; tier=https://example.org/research/tier-K1; =Hydrology Notes; name=Hydrology Notes |
| res:S09 | name=Journal of Coastal Hydraulics; tier=https://example.org/research/tier-K2; issn=3431-7424; sourceType=https://example.org/research/stype-JOU; =Journal of Coastal Hydraulics |
| res:S10 | name=Marine Technology Bulletin; tier=https://example.org/research/tier-K1; issn=7809-8515; =Marine Technology Bulletin; sourceType=https://example.org/research/stype-JOU |
| res:S11 | issn=8324-8964; tier=https://example.org/research/tier-K2; name=Annals of Ocean Observation; sourceType=https://example.org/research/stype-JOU; =Annals of Ocean Observation |
| res:S12 | sourceType=https://example.org/research/stype-JOU; tier=https://example.org/research/tier-K1; =Shelf Sea Letters; issn=8103-2767; name=Shelf Sea Letters |
| res:S13 | =International Journal of Ocean Frontiers; tier=https://example.org/research/tier-K0; sourceType=https://example.org/research/stype-JOU; name=International Journal of Ocean Frontiers; issn=1765-9671 |
| res:S14 | =CoastRxiv; sourceType=https://example.org/research/stype-REP; name=CoastRxiv |

Query 2:

| s | props |
|---|---|
| res:I14 | =Oskel Polytechnic; country=NL; institutionType=https://example.org/research/itype-UNI; name=Oskel Polytechnic |
| res:I15 | =Carrow State University; country=US; institutionType=https://example.org/research/itype-UNI; name=Carrow State University |
| res:I16 | =Hoshimine Institute of Technology; country=JP; institutionType=https://example.org/research/itype-UNI; name=Hoshimine Institute of Technology |
| res:I17 | =Université de Mallois; country=CA; institutionType=https://example.org/research/itype-UNI; name=Université de Mallois |
| res:I18 | =Universidad de Ventolera; country=ES; institutionType=https://example.org/research/itype-UNI; name=Universidad de Ventolera |
| res:I19 | =Albury Laboratory for Acoustic Imaging; country=GB; institutionType=https://example.org/research/itype-LAB; name=Albury Laboratory for Acoustic Imaging; parent=https://example.org/research/I02 |
| res:I20 | =Albury Metropolitan Centre for Port Studies; country=GB; institutionType=https://example.org/research/itype-LAB; name=Albury Metropolitan Centre for Port Studies; parent=https://example.org/research/I05 |
| res:I21 | =Wexcombe Institute for Estuary Research; country=GB; institutionType=https://example.org/research/itype-AFF; name=Wexcombe Institute for Estuary Research; parent=https://example.org/research/I05 |
| res:I22 | =Sandhaven Institute for Wave Research; country=DE; institutionType=https://example.org/research/itype-AFF; name=Sandhaven Institute for Wave Research; parent=https://example.org/research/I07 |
| res:I23 | =Rostval Laboratory for Offshore Structures; country=NL; institutionType=https://example.org/research/itype-LAB; name=Rostval Laboratory for Offshore Structures; parent=https://example.org/research/I09 |
| res:I24 | =Pellmore University; country=US; institutionType=https://example.org/research/itype-UNI; name=Pellmore University |
| res:I25 | =Università di Calvessa; country=IT; institutionType=https://example.org/research/itype-UNI; name=Università di Calvessa |
| res:I26 | =Tarnowa University of Technology; country=PL; institutionType=https://example.org/research/itype-UNI; name=Tarnowa University of Technology |
| res:I27 | =Kirrabay University; country=AU; institutionType=https://example.org/research/itype-UNI; name=Kirrabay University |
| res:I28 | =Nordvik University; country=NO; institutionType=https://example.org/research/itype-UNI; name=Nordvik University |
| res:I29 | =Hanseo Ocean Institute; country=KR; institutionType=https://example.org/research/itype-GOV; name=Hanseo Ocean Institute |
| res:I30 | =Universidade de Arvela; country=PT; institutionType=https://example.org/research/itype-UNI; name=Universidade de Arvela |
| res:I31 | =Corrimal Marine Systems Inc; country=US; institutionType=https://example.org/research/itype-CO; name=Corrimal Marine Systems Inc |

Query 3:

(no rows)

Run more queries, or give the final answers.

The model

<invoke name="sparql">
SELECT ?s ?p ?o WHERE { ?s ?p ?o . VALUES ?s { res:wtype-ART res:wtype-PPR res:wtype-EDT res:wtype-ERR res:tier-K3 res:tier-K0 res:origin-FEED res:itype-AFF res:itype-SYS } }
</invoke>
```sparql
SELECT ?t (COUNT(*) AS ?n) (GROUP_CONCAT(?id;separator=",") AS ?ws) WHERE { ?w res:workType ?t . BIND(STRAFTER(STR(?w),"research/") AS ?id) } GROUP BY ?t
```
```sparql
SELECT ?o (COUNT(*) AS ?n) WHERE { ?w res:recordSource ?o } GROUP BY ?o
```
```sparql
SELECT ?w ?y ?t ?src ?r ?v ?rs WHERE { ?w a res:Work ; res:year ?y ; res:workType ?t ; res:source ?src ; res:retracted ?r ; res:recordSource ?rs . OPTIONAL{?w res:versionOf ?v} } ORDER BY ?w
```

Query results

Query 1:

| t | n | ws |
|---|---|---|
| res:wtype-PTX | 12 | W09,W10,W202,W212,W240,W286,W561,W590,W754,W825,W883,W891 |
| res:wtype-EDT | 33 | W76,W04,W1041,W224,W431,W548,W674,W1034,W110,W437,W959,W976,W991,W371,W418,W637,W719,W966,W1043,W123,W751,W786,W932,W626,W882,W936,W989,W271,W480,W756,W901,W331,W572 |
| res:wtype-ART | 669 | W07,W08,W1004,W1013,W117,W122,W19,W255,W345,W356,W362,W37,W38,W423,W483,W504,W532,W554,W563,W585,W603,W636,W648,W73,W75,W906,W06,W1003,W1008,W1018,W1020,W1021,W1023,W1030,W1056,W13,W14,W16,W23,W232,W247,W249,W257,W299,W310,W33,W333,W335,W34,W342,W343,W352,W377,W387,W39,W392,W408,W443,W444,W455,W470,W475,W484,W485,W492,W493,W498,W50,W508,W510,W511,W518,W52,W525,W540,W541,W553,W571,W581,W594,W609,W625,W641,W644,W662,W671,W679,W685,W690,W697,W70,W71,W72,W721,W723,W736,W748,W768,W773,W788,W795,W802,W812,W863,W885,W91,W918,W920,W926,W950,W955,W956,W963,W969,W973,W979,W983,W998,W1015,W1019,W102,W1029,W1035,W1037,W1040,W1046,W1050,W116,W118,W12,W201,W209,W215,W217,W220,W242,W253,W254,W262,W264,W265,W268,W278,W281,W293,W297,W305,W323,W324,W329,W330,W337,W339,W344,W358,W359,W36,W365,W393,W397,W398,W402,W405,W411,W414,W435,W438,W441,W449,W454,W463,W471,W473,W476,W478,W488,W501,W507,W51,W513,W515,W526,W538,W551,W558,W565,W568,W574,W587,W592,W595,W598,W606,W614,W624,W633,W64,W646,W650,W652,W657,W66,W661,W67,W673,W681,W688,W693,W702,W704,W711,W720,W731,W738,W744,W753,W757,W765,W778,W789,W792,W806,W811,W818,W826,W828,W829,W832,W838,W844,W847,W850,W852,W854,W862,W871,W873,W878,W887,W90,W900,W902,W905,W917,W928,W941,W942,W960,W967,W985,W986,W987,W992,W1000,W1010,W1012,W1014,W1022,W1025,W1038,W1039,W1042,W105,W1061,W111,W112,W113,W119,W121,W124,W204,W206,W216,W230,W233,W235,W238,W241,W246,W252,W258,W27,W274,W28,W282,W285,W289,W302,W312,W315,W319,W325,W326,W332,W355,W366,W374,W380,W396,W404,W413,W427,W433,W434,W439,W440,W442,W452,W456,W462,W464,W489,W491,W499,W505,W512,W519,W520,W521,W523,W528,W533,W534,W542,W546,W559,W567,W569,W578,W582,W589,W607,W608,W617,W619,W62,W620,W621,W629,W63,W632,W635,W638,W640,W65,W667,W669,W670,W675,W676,W683,W691,W700,W703,W705,W709,W710,W714,W724,W727,W760,W762,W770,W775,W783,W797,W799,W801,W804,W809,W815,W823,W827,W831,W833,W834,W837,W849,W853,W855,W864,W868,W872,W888,W895,W916,W922,W929,W930,W931,W933,W934,W937,W940,W954,W957,W958,W965,W975,W977,W984,W990,W994,W1001,W1007,W1017,W103,W1031,W1033,W1048,W1051,W1052,W125,W214,W223,W229,W237,W243,W251,W259,W260,W266,W267,W273,W276,W284,W291,W292,W294,W300,W301,W304,W313,W318,W32,W334,W346,W350,W361,W367,W370,W376,W384,W388,W389,W390,W403,W420,W421,W448,W461,W497,W503,W529,W531,W535,W539,W547,W549,W557,W560,W576,W580,W605,W61,W615,W631,W649,W654,W655,W656,W668,W686,W715,W732,W740,W741,W750,W752,W761,W763,W764,W774,W790,W791,W794,W817,W830,W843,W856,W865,W867,W884,W886,W889,W890,W897,W904,W907,W913,W953,W988,W993,W996,W1005,W1016,W1024,W1028,W1032,W1036,W109,W208,W211,W218,W225,W228,W239,W270,W303,W308,W309,W320,W341,W348,W349,W382,W406,W41,W419,W422,W426,W459,W466,W486,W487,W509,W536,W544,W552,W602,W610,W616,W618,W623,W627,W642,W651,W659,W678,W682,W692,W716,W735,W737,W782,W798,W808,W842,W851,W861,W869,W879,W880,W894,W924,W927,W943,W947,W970,W972,W980,W981,W1026,W1044,W1047,W1064,W114,W203,W21,W222,W314,W317,W338,W354,W399,W400,W417,W428,W430,W436,W465,W500,W502,W516,W527,W550,W583,W584,W588,W60,W628,W643,W664,W665,W684,W699,W707,W772,W777,W821,W822,W835,W846,W848,W874,W921,W935,W948,W968,W978,W1058,W1060,W108,W269,W279,W357,W401,W425,W458,W496,W555,W562,W586,W613,W630,W725,W733,W755,W784,W816,W858,W881,W910,W101,W1065,W40,W660,W672,W787,W896,W01,W275,W742,W944,W946,W104,W1063,W579,W713,W870,W31,W453,W807,W876,W296,W696,W20,W30,W03 |
| res:wtype-PPR | 34 | W221,W226,W1049,W1054,W18,W306,W432,W566,W781,W210,W336,W416,W506,W611,W219,W460,W663,W745,W747,W780,W824,W877,W263,W407,W42,W556,W612,W522,W728,W524,W730,W545,W322,W02 |
| res:wtype-SUP | 18 | W24,W945,W951,W17,W372,W639,W866,W445,W530,W793,W819,W971,W450,W734,W800,W997,W803,W1002 |
| res:wtype-REV | 76 | W74,W814,W115,W35,W446,W474,W479,W726,W776,W845,W92,W1006,W1009,W1062,W120,W15,W368,W378,W385,W415,W451,W645,W718,W729,W779,W205,W261,W272,W29,W410,W457,W564,W706,W739,W769,W771,W859,W1011,W1053,W106,W256,W277,W373,W467,W469,W477,W573,W593,W599,W666,W680,W758,W840,W995,W107,W227,W570,W601,W785,W836,W857,W860,W875,W925,W1027,W383,W424,W575,W722,W964,W820,W903,W749,W369,W908,W22 |
| res:wtype-ERR | 8 | W05,W321,W766,W810,W914,W481,W949,W813 |

Query 2:

| o | n |
|---|---|
| res:origin-FEED | 822 |
| res:origin-CRIS | 3 |
| res:origin-STG | 25 |

Query 3:

| w | y | t | src | r | v | rs |
|---|---|---|---|---|---|---|
| res:W01 | 2021 | res:wtype-ART | res:S01 | false |  | res:origin-FEED |
| res:W02 | 2022 | res:wtype-PPR | res:S05 | false | res:W03 | res:origin-FEED |
| res:W03 | 2023 | res:wtype-ART | res:S02 | false |  | res:origin-FEED |
| res:W04 | 2023 | res:wtype-EDT | res:S01 | false |  | res:origin-FEED |
| res:W05 | 2024 | res:wtype-ERR | res:S02 | false |  | res:origin-FEED |
| res:W06 | 2024 | res:wtype-ART | res:S03 | false |  | res:origin-FEED |
| res:W07 | 2020 | res:wtype-ART | res:S04 | false |  | res:origin-FEED |
| res:W08 | 2025 | res:wtype-ART | res:S01 | false |  | res:origin-FEED |
| res:W09 | 2023 | res:wtype-PTX | res:S01 | false |  | res:origin-FEED |
| res:W10 | 2024 | res:wtype-PTX | res:S02 | false |  | res:origin-FEED |
| res:W1000 | 2024 | res:wtype-ART | res:S01 | false |  | res:origin-FEED |
| res:W1001 | 2024 | res:wtype-ART | res:S09 | false |  | res:origin-FEED |
| res:W1002 | 2021 | res:wtype-SUP | res:S06 | false |  | res:origin-FEED |
| res:W1003 | 2024 | res:wtype-ART | res:S06 | false |  | res:origin-FEED |
| res:W1004 | 2024 | res:wtype-ART | res:S02 | false |  | res:origin-FEED |
| res:W1005 | 2025 | res:wtype-ART | res:S02 | false |  | res:origin-FEED |
| res:W1006 | 2020 | res:wtype-REV | res:S13 | false |  | res:origin-FEED |
| res:W1007 | 2023 | res:wtype-ART | res:S01 | false |  | res:origin-FEED |
| res:W1008 | 2025 | res:wtype-ART | res:S11 | false |  | res:origin-FEED |
| res:W1009 | 2022 | res:wtype-REV | res:S12 | false |  | res:origin-FEED |
| res:W101 | 2019 | res:wtype-ART | res:S08 | false |  | res:origin-FEED |
| res:W1010 | 2020 | res:wtype-ART | res:S02 | false |  | res:origin-FEED |
| res:W1011 | 2021 | res:wtype-REV | res:S04 | false |  | res:origin-FEED |
| res:W1012 | 2020 | res:wtype-ART | res:S08 | false |  | res:origin-FEED |
| res:W1013 | 2025 | res:wtype-ART | res:S04 | false |  | res:origin-FEED |
| res:W1014 | 2023 | res:wtype-ART | res:S01 | false |  | res:origin-FEED |
| res:W1015 | 2023 | res:wtype-ART | res:S12 | false |  | res:origin-FEED |
| res:W1016 | 2025 | res:wtype-ART | res:S06 | false |  | res:origin-FEED |
| res:W1017 | 2025 | res:wtype-ART | res:S07 | false |  | res:origin-FEED |
| res:W1018 | 2025 | res:wtype-ART | res:S08 | false |  | res:origin-FEED |
| res:W1019 | 2020 | res:wtype-ART | res:S03 | false |  | res:origin-FEED |
| res:W102 | 2023 | res:wtype-ART | res:S07 | false |  | res:origin-FEED |
| res:W1020 | 2020 | res:wtype-ART | res:S13 | false |  | res:origin-FEED |
| res:W1021 | 2021 | res:wtype-ART | res:S02 | false |  | res:origin-FEED |
| res:W1022 | 2023 | res:wtype-ART | res:S09 | false |  | res:origin-FEED |
| res:W1023 | 2024 | res:wtype-ART | res:S09 | false |  | res:origin-FEED |
| res:W1024 | 2020 | res:wtype-ART | res:S12 | false |  | res:origin-FEED |
| res:W1025 | 2020 | res:wtype-ART | res:S02 | true |  | res:origin-FEED |
| res:W1026 | 2019 | res:wtype-ART | res:S09 | false |  | res:origin-FEED |
| res:W1027 | 2024 | res:wtype-REV | res:S10 | false |  | res:origin-FEED |
| res:W1028 | 2019 | res:wtype-ART | res:S03 | false |  | res:origin-FEED |
| res:W1029 | 2022 | res:wtype-ART | res:S09 | false |  | res:origin-FEED |
| res:W103 | 2020 | res:wtype-ART | res:S07 | false |  | res:origin-FEED |
| res:W1030 | 2021 | res:wtype-ART | res:S12 | false |  | res:origin-FEED |
| res:W1031 | 2025 | res:wtype-ART | res:S01 | false |  | res:origin-FEED |
| res:W1032 | 2019 | res:wtype-ART | res:S02 | false |  | res:origin-FEED |
| res:W1033 | 2025 | res:wtype-ART | res:S08 | false |  | res:origin-FEED |
| res:W1034 | 2025 | res:wtype-EDT | res:S06 | false |  | res:origin-FEED |
| res:W1035 | 2021 | res:wtype-ART | res:S03 | false |  | res:origin-FEED |
| res:W1036 | 2024 | res:wtype-ART | res:S06 | false |  | res:origin-FEED |
| res:W1037 | 2022 | res:wtype-ART | res:S02 | true |  | res:origin-FEED |
| res:W1038 | 2020 | res:wtype-ART | res:S02 | false |  | res:origin-FEED |
| res:W1039 | 2023 | res:wtype-ART | res:S11 | false |  | res:origin-FEED |
| res:W104 | 2019 | res:wtype-ART | res:S07 | false |  | res:origin-FEED |
| res:W1040 | 2024 | res:wtype-ART | res:S08 | false |  | res:origin-FEED |
| res:W1041 | 2025 | res:wtype-EDT | res:S03 | false |  | res:origin-FEED |
| res:W1042 | 2025 | res:wtype-ART | res:S01 | false |  | res:origin-FEED |
| res:W1043 | 2023 | res:wtype-EDT | res:S08 | false |  | res:origin-FEED |
| res:W1044 | 2021 | res:wtype-ART | res:S02 | false |  | res:origin-FEED |
| res:W1046 | 2024 | res:wtype-ART | res:S01 | false |  | res:origin-FEED |
(790 more rows not shown)

Query 4:

(no rows)

Run more queries, or give the final answers.

The model

<invoke name="sparql">
SELECT ?s ?p ?o WHERE { ?s ?p ?o . FILTER(STRSTARTS(STR(?p),"http://www.w3.org/2004/02/skos/core#") || ?p=rdfs:comment || ?p=rdfs:seeAlso) } LIMIT 100
</invoke>
```sparql
SELECT ?p (COUNT(*) AS ?n) WHERE { ?s ?p ?o } GROUP BY ?p
```
```sparql
SELECT ?a ?p ?o WHERE { ?a a res:Authorship ; res:work res:W01 ; ?p ?o }
```

Query results

Query 1:

| p | n |
|---|---|
| res:institution | 1532 |
| rdfs:label | 3661 |
| rdf:type | 3661 |
| res:citedWork | 1067 |
| res:affiliationSeq | 1532 |
| res:authorPosition | 1532 |
| res:author | 1532 |
| res:work | 1532 |
| res:doi | 850 |
| res:year | 850 |
| res:title | 850 |
| res:source | 850 |
| res:workType | 850 |
| res:recordSource | 850 |
| res:citingWork | 1067 |
| res:name | 212 |
| res:retracted | 850 |
| res:orcid | 156 |
| res:versionOf | 23 |
| res:institutionType | 31 |
| res:tier | 12 |
| res:sourceType | 14 |
| res:country | 31 |
| res:ror | 31 |
| res:parent | 11 |
| res:issn | 12 |

Query 2:

| a | p | o |
|---|---|---|
| res:AS-W01-A01-1 | rdf:type | res:Authorship |
| res:AS-W01-A01-1 | rdfs:label | W01 A01 I02 |
| res:AS-W01-A01-1 | res:affiliationSeq | 1 |
| res:AS-W01-A01-1 | res:author | res:A01 |
| res:AS-W01-A01-1 | res:authorPosition | 1 |
| res:AS-W01-A01-1 | res:institution | res:I02 |
| res:AS-W01-A01-1 | res:work | res:W01 |
| res:AS-W01-A07-1 | rdf:type | res:Authorship |
| res:AS-W01-A07-1 | rdfs:label | W01 A07 I03 |
| res:AS-W01-A07-1 | res:affiliationSeq | 1 |
| res:AS-W01-A07-1 | res:author | res:A07 |
| res:AS-W01-A07-1 | res:authorPosition | 2 |
| res:AS-W01-A07-1 | res:institution | res:I03 |
| res:AS-W01-A07-1 | res:work | res:W01 |

Query 3:

(no rows)

Run more queries, or give the final answers.

The model

<invoke name="sparql">
SELECT ?a ?auth ?o ?w ?inst ?pos ?y ?t ?src ?r ?rs WHERE { ?a res:author ?auth; res:work ?w; res:institution ?inst; res:authorPosition ?pos . ?auth res:orcid ?o . FILTER(?o IN ("0000-0002-9841-6229","0000-0004-8662-8360","0000-0001-6105-5008","0000-0007-5475-1779","0000-0004-9046-7961","0000-0009-2298-3695","0000-0007-1802-8393","0000-0000-8073-7028")) ?w res:year ?y; res:workType ?t; res:source ?src; res:retracted ?r; res:recordSource ?rs } ORDER BY ?o ?w
</invoke>
```sparql
SELECT ?w ?v ?y ?t ?src ?rs WHERE { ?w res:versionOf ?v ; res:year ?y; res:workType ?t; res:source ?src; res:recordSource ?rs } ORDER BY ?w
```
```sparql
SELECT ?w ?y ?t ?rs ?r WHERE { ?w res:recordSource ?rs ; res:year ?y; res:workType ?t; res:retracted ?r FILTER(?rs != res:origin-FEED || ?r = true) } ORDER BY ?w
```

Query results

Query 1:

| w | v | y | t | src | rs |
|---|---|---|---|---|---|
| res:W02 | res:W03 | 2022 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W1049 | res:W789 | 2021 | res:wtype-PPR | res:S14 | res:origin-FEED |
| res:W210 | res:W902 | 2021 | res:wtype-PPR | res:S14 | res:origin-FEED |
| res:W219 | res:W251 | 2022 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W226 | res:W710 | 2023 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W263 | res:W279 | 2019 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W322 | res:W453 | 2019 | res:wtype-PPR | res:S14 | res:origin-FEED |
| res:W407 | res:W1027 | 2023 | res:wtype-PPR | res:S14 | res:origin-FEED |
| res:W416 | res:W640 | 2020 | res:wtype-PPR | res:S14 | res:origin-FEED |
| res:W42 | res:W31 | 2023 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W432 | res:W879 | 2023 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W460 | res:W496 | 2022 | res:wtype-PPR | res:S14 | res:origin-FEED |
| res:W506 | res:W422 | 2022 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W522 | res:W312 | 2020 | res:wtype-PPR | res:S14 | res:origin-FEED |
| res:W524 | res:W807 | 2020 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W545 | res:W742 | 2019 | res:wtype-PPR | res:S14 | res:origin-FEED |
| res:W556 | res:W1038 | 2019 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W611 | res:W301 | 2019 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W612 | res:W869 | 2023 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W663 | res:W464 | 2021 | res:wtype-PPR | res:S14 | res:origin-FEED |
| res:W728 | res:W665 | 2019 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W730 | res:W303 | 2020 | res:wtype-PPR | res:S05 | res:origin-FEED |
| res:W877 | res:W965 | 2023 | res:wtype-PPR | res:S05 | res:origin-FEED |

Query 2:

| w | y | t | rs | r |
|---|---|---|---|---|
| res:W1025 | 2020 | res:wtype-ART | res:origin-FEED | true |
| res:W1037 | 2022 | res:wtype-ART | res:origin-FEED | true |
| res:W12 | 2024 | res:wtype-ART | res:origin-CRIS | false |
| res:W19 | 2025 | res:wtype-ART | res:origin-CRIS | false |
| res:W23 | 2023 | res:wtype-ART | res:origin-FEED | true |
| res:W268 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W320 | 2024 | res:wtype-ART | res:origin-FEED | true |
| res:W329 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W372 | 2025 | res:wtype-SUP | res:origin-STG | false |
| res:W374 | 2023 | res:wtype-ART | res:origin-FEED | true |
| res:W397 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W411 | 2022 | res:wtype-ART | res:origin-FEED | true |
| res:W444 | 2019 | res:wtype-ART | res:origin-FEED | true |
| res:W488 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W520 | 2024 | res:wtype-ART | res:origin-FEED | true |
| res:W569 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W573 | 2025 | res:wtype-REV | res:origin-STG | false |
| res:W582 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W610 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W680 | 2025 | res:wtype-REV | res:origin-STG | false |
| res:W693 | 2025 | res:wtype-ART | res:origin-FEED | true |
| res:W700 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W714 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W73 | 2022 | res:wtype-ART | res:origin-CRIS | false |
| res:W734 | 2025 | res:wtype-SUP | res:origin-STG | false |
| res:W802 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W819 | 2025 | res:wtype-SUP | res:origin-STG | false |
| res:W837 | 2025 | res:wtype-ART | res:origin-FEED | true |
| res:W844 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W852 | 2020 | res:wtype-ART | res:origin-FEED | true |
| res:W866 | 2025 | res:wtype-SUP | res:origin-STG | false |
| res:W868 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W878 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W90 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W91 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W92 | 2025 | res:wtype-REV | res:origin-STG | false |
| res:W922 | 2024 | res:wtype-ART | res:origin-FEED | true |
| res:W971 | 2025 | res:wtype-SUP | res:origin-STG | false |
| res:W973 | 2024 | res:wtype-ART | res:origin-FEED | true |
| res:W987 | 2025 | res:wtype-ART | res:origin-STG | false |
| res:W997 | 2025 | res:wtype-SUP | res:origin-STG | false |

Query 3:

| a | auth | o | w | inst | pos | y | t | src | r | rs |
|---|---|---|---|---|---|---|---|---|---|---|
| res:AS-W1025-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W1025 | res:I07 | 1 | 2020 | res:wtype-ART | res:S02 | true | res:origin-FEED |
| res:AS-W20-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W20 | res:I07 | 1 | 2024 | res:wtype-ART | res:S01 | false | res:origin-FEED |
| res:AS-W203-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W203 | res:I07 | 2 | 2024 | res:wtype-ART | res:S03 | false | res:origin-FEED |
| res:AS-W21-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W21 | res:I07 | 2 | 2024 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W22-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W22 | res:I07 | 1 | 2024 | res:wtype-REV | res:S03 | false | res:origin-FEED |
| res:AS-W23-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W23 | res:I07 | 1 | 2023 | res:wtype-ART | res:S02 | true | res:origin-FEED |
| res:AS-W232-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W232 | res:I07 | 1 | 2019 | res:wtype-ART | res:S06 | false | res:origin-FEED |
| res:AS-W268-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W268 | res:I07 | 1 | 2025 | res:wtype-ART | res:S02 | false | res:origin-STG |
| res:AS-W366-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W366 | res:I07 | 1 | 2022 | res:wtype-ART | res:S03 | false | res:origin-FEED |
| res:AS-W417-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W417 | res:I07 | 1 | 2023 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W478-A103-1 | res:A103 | 0000-0000-8073-7028 | res:W478 | res:I08 | 1 | 2019 | res:wtype-ART | res:S01 | false | res:origin-FEED |
| res:AS-W478-A103-2 | res:A103 | 0000-0000-8073-7028 | res:W478 | res:I07 | 1 | 2019 | res:wtype-ART | res:S01 | false | res:origin-FEED |
| res:AS-W531-A103-1 | res:A103 | 0000-0000-8073-7028 | res:W531 | res:I08 | 1 | 2023 | res:wtype-ART | res:S01 | false | res:origin-FEED |
| res:AS-W531-A103-2 | res:A103 | 0000-0000-8073-7028 | res:W531 | res:I07 | 1 | 2023 | res:wtype-ART | res:S01 | false | res:origin-FEED |
| res:AS-W686-A103-1 | res:A103 | 0000-0000-8073-7028 | res:W686 | res:I08 | 1 | 2022 | res:wtype-ART | res:S03 | false | res:origin-FEED |
| res:AS-W686-A103-2 | res:A103 | 0000-0000-8073-7028 | res:W686 | res:I07 | 1 | 2022 | res:wtype-ART | res:S03 | false | res:origin-FEED |
| res:AS-W693-A103-1 | res:A103 | 0000-0000-8073-7028 | res:W693 | res:I07 | 1 | 2025 | res:wtype-ART | res:S01 | true | res:origin-FEED |
| res:AS-W714-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W714 | res:I07 | 1 | 2025 | res:wtype-ART | res:S02 | false | res:origin-STG |
| res:AS-W738-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W738 | res:I07 | 1 | 2022 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W802-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W802 | res:I07 | 1 | 2025 | res:wtype-ART | res:S02 | false | res:origin-STG |
| res:AS-W967-A09-1 | res:A09 | 0000-0000-8073-7028 | res:W967 | res:I07 | 1 | 2022 | res:wtype-ART | res:S06 | false | res:origin-FEED |
| res:AS-W1038-A05-1 | res:A05 | 0000-0001-6105-5008 | res:W1038 | res:I05 | 1 | 2020 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W14-A05-1 | res:A05 | 0000-0001-6105-5008 | res:W14 | res:I05 | 1 | 2025 | res:wtype-ART | res:S03 | false | res:origin-FEED |
| res:AS-W37-A05-1 | res:A05 | 0000-0001-6105-5008 | res:W37 | res:I05 | 1 | 2022 | res:wtype-ART | res:S03 | false | res:origin-FEED |
| res:AS-W554-A05-1 | res:A05 | 0000-0001-6105-5008 | res:W554 | res:I05 | 1 | 2024 | res:wtype-ART | res:S01 | false | res:origin-FEED |
| res:AS-W556-A104-1 | res:A104 | 0000-0001-6105-5008 | res:W556 | res:I05 | 1 | 2019 | res:wtype-PPR | res:S05 | false | res:origin-FEED |
| res:AS-W565-A05-1 | res:A05 | 0000-0001-6105-5008 | res:W565 | res:I05 | 1 | 2019 | res:wtype-ART | res:S03 | false | res:origin-FEED |
| res:AS-W702-A104-1 | res:A104 | 0000-0001-6105-5008 | res:W702 | res:I05 | 1 | 2022 | res:wtype-ART | res:S03 | false | res:origin-FEED |
| res:AS-W725-A104-1 | res:A104 | 0000-0001-6105-5008 | res:W725 | res:I05 | 1 | 2022 | res:wtype-ART | res:S06 | false | res:origin-FEED |
| res:AS-W785-A05-1 | res:A05 | 0000-0001-6105-5008 | res:W785 | res:I05 | 1 | 2020 | res:wtype-REV | res:S09 | false | res:origin-FEED |
| res:AS-W792-A05-1 | res:A05 | 0000-0001-6105-5008 | res:W792 | res:I05 | 1 | 2023 | res:wtype-ART | res:S06 | false | res:origin-FEED |
| res:AS-W01-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W01 | res:I02 | 1 | 2021 | res:wtype-ART | res:S01 | false | res:origin-FEED |
| res:AS-W02-A02-1 | res:A02 | 0000-0002-9841-6229 | res:W02 | res:I02 | 1 | 2022 | res:wtype-PPR | res:S05 | false | res:origin-FEED |
| res:AS-W03-A03-1 | res:A03 | 0000-0002-9841-6229 | res:W03 | res:I02 | 1 | 2023 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W04-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W04 | res:I02 | 1 | 2023 | res:wtype-EDT | res:S01 | false | res:origin-FEED |
| res:AS-W05-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W05 | res:I02 | 1 | 2024 | res:wtype-ERR | res:S02 | false | res:origin-FEED |
| res:AS-W06-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W06 | res:I02 | 1 | 2024 | res:wtype-ART | res:S03 | false | res:origin-FEED |
| res:AS-W07-A02-1 | res:A02 | 0000-0002-9841-6229 | res:W07 | res:I02 | 1 | 2020 | res:wtype-ART | res:S04 | false | res:origin-FEED |
| res:AS-W1005-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W1005 | res:I02 | 1 | 2025 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W1048-A02-1 | res:A02 | 0000-0002-9841-6229 | res:W1048 | res:I02 | 1 | 2023 | res:wtype-ART | res:S10 | false | res:origin-FEED |
| res:AS-W1050-A02-1 | res:A02 | 0000-0002-9841-6229 | res:W1050 | res:I02 | 1 | 2024 | res:wtype-ART | res:S09 | false | res:origin-FEED |
| res:AS-W12-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W12 | res:I02 | 1 | 2024 | res:wtype-ART | res:S02 | false | res:origin-CRIS |
| res:AS-W19-A02-1 | res:A02 | 0000-0002-9841-6229 | res:W19 | res:I02 | 1 | 2025 | res:wtype-ART | res:S02 | false | res:origin-CRIS |
| res:AS-W206-A03-1 | res:A03 | 0000-0002-9841-6229 | res:W206 | res:I02 | 1 | 2020 | res:wtype-ART | res:S01 | false | res:origin-FEED |
| res:AS-W238-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W238 | res:I02 | 1 | 2023 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W271-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W271 | res:I02 | 1 | 2019 | res:wtype-EDT | res:S01 | false | res:origin-FEED |
| res:AS-W374-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W374 | res:I02 | 1 | 2023 | res:wtype-ART | res:S02 | true | res:origin-FEED |
| res:AS-W449-A02-1 | res:A02 | 0000-0002-9841-6229 | res:W449 | res:I02 | 1 | 2022 | res:wtype-ART | res:S04 | false | res:origin-FEED |
| res:AS-W464-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W464 | res:I02 | 1 | 2021 | res:wtype-ART | res:S09 | false | res:origin-FEED |
| res:AS-W555-A101-1 | res:A101 | 0000-0002-9841-6229 | res:W555 | res:I02 | 1 | 2020 | res:wtype-ART | res:S09 | false | res:origin-FEED |
| res:AS-W612-A101-1 | res:A101 | 0000-0002-9841-6229 | res:W612 | res:I02 | 1 | 2023 | res:wtype-PPR | res:S05 | false | res:origin-FEED |
| res:AS-W663-A02-1 | res:A02 | 0000-0002-9841-6229 | res:W663 | res:I02 | 1 | 2021 | res:wtype-PPR | res:S14 | false | res:origin-FEED |
| res:AS-W676-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W676 | res:I02 | 1 | 2025 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W763-A03-1 | res:A03 | 0000-0002-9841-6229 | res:W763 | res:I02 | 1 | 2024 | res:wtype-ART | res:S13 | false | res:origin-FEED |
| res:AS-W813-A01-1 | res:A01 | 0000-0002-9841-6229 | res:W813 | res:I02 | 1 | 2025 | res:wtype-ERR | res:S02 | false | res:origin-FEED |
| res:AS-W817-A03-1 | res:A03 | 0000-0002-9841-6229 | res:W817 | res:I02 | 1 | 2023 | res:wtype-ART | res:S10 | false | res:origin-FEED |
| res:AS-W843-A101-1 | res:A101 | 0000-0002-9841-6229 | res:W843 | res:I02 | 1 | 2023 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W869-A02-1 | res:A02 | 0000-0002-9841-6229 | res:W869 | res:I02 | 1 | 2023 | res:wtype-ART | res:S02 | false | res:origin-FEED |
| res:AS-W905-A101-1 | res:A101 | 0000-0002-9841-6229 | res:W905 | res:I02 | 1 | 2025 | res:wtype-ART | res:S01 | false | res:origin-FEED |
| res:AS-W936-A101-1 | res:A101 | 0000-0002-9841-6229 | res:W936 | res:I02 | 1 | 2019 | res:wtype-EDT | res:S01 | false | res:origin-FEED |
(47 more rows not shown)

Run more queries, or give the final answers.

The model

<invoke name="sparql">
SELECT ?root (COUNT(DISTINCT ?c) AS ?nAll) (COUNT(DISTINCT ?cN) AS ?noSTG) (COUNT(DISTINCT ?c24) AS ?y24) (COUNT(DISTINCT ?c25) AS ?y25) (COUNT(DISTINCT ?c25N) AS ?y25noSTG) WHERE {
 VALUES ?root {res:I01 res:I02 res:I03 res:I04 res:I05 res:I06 res:I07 res:I08 res:I09 res:I14}
 ?a res:institution ?i ; res:work ?w .
 ?i res:parent* ?root .
 ?w res:workType ?t ; res:retracted ?r ; res:year ?y ; res:recordSource ?rs .
 FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR) && STR(?r)="false")
 OPTIONAL{?w res:versionOf ?v}
 BIND(COALESCE(?v,?w) AS ?c)
 BIND(IF(?rs != res:origin-STG, ?c, ?nothing) AS ?cN)
 BIND(IF(?y=2024, ?c, ?nothing) AS ?c24)
 BIND(IF(?y=2025, ?c, ?nothing) AS ?c25)
 BIND(IF(?y=2025 && ?rs != res:origin-STG, ?c, ?nothing) AS ?c25N)
} GROUP BY ?root ORDER BY ?root
```

```sparql
SELECT ?country (COUNT(DISTINCT ?w) AS ?full) (SUM(1/?n) AS ?frac) WHERE {
 { SELECT ?w (COUNT(DISTINCT ?au) AS ?n) WHERE { ?a res:work ?w; res:author ?au } GROUP BY ?w }
 { SELECT DISTINCT ?country ?w ?au WHERE {
   ?a res:work ?w; res:author ?au; res:institution ?i . ?i res:country ?country .
   ?w res:year 2024 ; res:workType ?t ; res:retracted ?r .
   FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR) && STR(?r)="false") } }
} GROUP BY ?country ORDER BY ?country
```

```sparql
SELECT ?root (COUNT(DISTINCT ?w) AS ?full) (SUM(1/?n) AS ?frac) WHERE {
 { SELECT ?w (COUNT(DISTINCT ?au) AS ?n) WHERE { ?a res:work ?w; res:author ?au } GROUP BY ?w }
 { SELECT DISTINCT ?root ?w ?au WHERE {
   VALUES ?root {res:I07 res:I09}
   ?a res:work ?w; res:author ?au; res:institution ?i . ?i res:parent* ?root .
   ?w res:year 2024 ; res:workType ?t ; res:retracted ?r .
   FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR) && STR(?r)="false") } }
} GROUP BY ?root
```

```sparql
SELECT ?au ?t ?r ?rs (GROUP_CONCAT(DISTINCT STRAFTER(STR(?w),"research/");separator=",") AS ?ws) WHERE {
 ?a res:author ?au; res:work ?w .
 ?au res:orcid ?o . FILTER(?o IN ("0000-0002-9841-6229","0000-0009-2298-3695","0000-0007-1802-8393"))
 ?w res:workType ?t; res:retracted ?r; res:recordSource ?rs
} GROUP BY ?au ?t ?r ?rs ORDER BY ?au
```

```sparql
SELECT ?w ?au ?o ?i ?t ?r ?y WHERE {
 VALUES ?w {res:W08 res:W37 res:W38 res:W70 res:W71}
 ?a res:work ?w; res:author ?au; res:institution ?i . OPTIONAL{?au res:orcid ?o}
 ?w res:workType ?t; res:retracted ?r; res:year ?y
} ORDER BY ?w
```


<invoke name="sparql">
SELECT ?cited ?cw ?cy ?cwt WHERE { VALUES ?cited {res:W30 res:W31 res:W42} ?c res:citedWork ?cited; res:citingWork ?cw. ?cw res:year ?cy; res:workType ?cwt } ORDER BY ?cited ?cw
</invoke>
```sparql
SELECT ?w ?y ?t ?r WHERE { VALUES ?w {res:W30 res:W31 res:W42 res:W02 res:W03} ?w res:year ?y; res:workType ?t; res:retracted ?r }
```

```sparql
SELECT (COUNT(DISTINCT ?cw) AS ?total)
 (COUNT(DISTINCT ?sa) AS ?authorSelf) (COUNT(DISTINCT ?si2) AS ?albury) (COUNT(DISTINCT ?si1) AS ?system) (COUNT(DISTINCT ?sc) AS ?country) WHERE {
 VALUES ?cd {res:W02 res:W03}
 ?c res:citedWork ?cd; res:citingWork ?cw .
 OPTIONAL { ?x1 res:work ?cw; res:author ?a1 . ?a1 res:orcid ?o . ?a2 res:orcid ?o . ?x2 res:work ?cd; res:author ?a2 . BIND(?cw AS ?sa) }
 OPTIONAL { ?y1 res:work ?cw; res:institution ?i1 . ?i1 res:parent* res:I02 . ?y2 res:work ?cd; res:institution ?i2 . ?i2 res:parent* res:I02 . BIND(?cw AS ?si2) }
 OPTIONAL { ?z1 res:work ?cw; res:institution ?j1 . ?j1 res:parent* res:I01 . ?z2 res:work ?cd; res:institution ?j2 . ?j2 res:parent* res:I01 . BIND(?cw AS ?si1) }
 OPTIONAL { ?u1 res:work ?cw; res:institution/res:country ?k . ?u2 res:work ?cd; res:institution/res:country ?k . BIND(?cw AS ?sc) }
}
```

```sparql
SELECT ?hop (COUNT(DISTINCT ?w) AS ?n) (GROUP_CONCAT(DISTINCT STRAFTER(STR(?w),"research/");separator=",") AS ?ws) WHERE {
 { ?c1 res:citedWork res:W01; res:citingWork ?w . BIND(1 AS ?hop) }
 UNION
 { ?c1 res:citedWork res:W01; res:citingWork ?x . ?c2 res:citedWork ?x; res:citingWork ?w . BIND(2 AS ?hop) }
} GROUP BY ?hop
```

```sparql
SELECT ?cd (COUNT(DISTINCT ?cw) AS ?n) WHERE {
 ?a res:work ?cd; res:institution ?i . ?i res:parent* res:I07 .
 ?cd res:workType ?t; res:retracted ?r . FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR) && STR(?r)="false")
 ?c res:citedWork ?cd; res:citingWork ?cw .
} GROUP BY ?cd ORDER BY DESC(?n) LIMIT 6
```

```sparql
SELECT ?root (COUNT(DISTINCT ?cw) AS ?n) WHERE {
 ?a res:work ?cd; res:institution ?i . ?i res:parent* res:I07 .
 ?cd res:workType ?t; res:retracted ?r . FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR) && STR(?r)="false")
 ?c res:citedWork ?cd; res:citingWork ?cw .
 ?b res:work ?cw; res:institution ?ci . ?ci res:parent* ?root . FILTER NOT EXISTS {?root res:parent ?pp}
 FILTER(?root != res:I07)
} GROUP BY ?root ORDER BY DESC(?n)
```

```sparql
SELECT ?cd (COUNT(DISTINCT ?cw) AS ?n) WHERE {
 ?a res:work ?cd; res:author/res:orcid "0000-0000-8073-7028" .
 ?cd res:workType ?t; res:retracted ?r . FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR) && STR(?r)="false")
 OPTIONAL{ ?c res:citedWork ?cd; res:citingWork ?cw }
} GROUP BY ?cd ORDER BY ?cd
```

```sparql
SELECT ?au (COUNT(DISTINCT ?c) AS ?n) WHERE {
 ?a res:work ?w; res:institution ?i; res:author ?au . ?i res:parent* res:I02 .
 ?w res:workType ?t; res:retracted ?r . FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR) && STR(?r)="false")
 OPTIONAL{?w res:versionOf ?v} BIND(COALESCE(?v,?w) AS ?c)
 ?au res:orcid ?o
} GROUP BY ?au ORDER BY DESC(?n) LIMIT 6
```

```sparql
SELECT ?w ?x ?rs WHERE { ?w res:recordSource ?rs; res:title ?t . FILTER(?rs != res:origin-FEED) OPTIONAL{ ?x res:title ?t . FILTER(?x != ?w) } } LIMIT 40
```

Query results

Query 1:

(no rows)

Query 2:

(no rows)

Query 3:

| au | t | r | rs | ws |
|---|---|---|---|---|
| res:A01 | res:wtype-ART | false | res:origin-FEED | W01,W06,W1005,W238,W464,W676 |
| res:A01 | res:wtype-EDT | false | res:origin-FEED | W04,W271 |
| res:A01 | res:wtype-ERR | false | res:origin-FEED | W05,W813,W949 |
| res:A01 | res:wtype-ART | false | res:origin-CRIS | W12 |
| res:A01 | res:wtype-ART | true | res:origin-FEED | W374 |
| res:A02 | res:wtype-PPR | false | res:origin-FEED | W02,W663 |
| res:A02 | res:wtype-ART | false | res:origin-FEED | W07,W1048,W1050,W449,W869,W972 |
| res:A02 | res:wtype-ART | false | res:origin-CRIS | W19 |
| res:A03 | res:wtype-ART | false | res:origin-FEED | W03,W206,W763,W817 |
| res:A07 | res:wtype-ART | false | res:origin-FEED | W01,W03,W13,W251,W262,W292,W293,W435,W553,W598,W72,W787,W833,W969 |
| res:A07 | res:wtype-PPR | false | res:origin-FEED | W02,W219 |
| res:A07 | res:wtype-ERR | false | res:origin-FEED | W05 |
| res:A07 | res:wtype-REV | false | res:origin-FEED | W758 |
| res:A101 | res:wtype-ART | false | res:origin-FEED | W555,W843,W905,W984 |
| res:A101 | res:wtype-PPR | false | res:origin-FEED | W612 |
| res:A101 | res:wtype-EDT | false | res:origin-FEED | W936 |
| res:A108 | res:wtype-ART | false | res:origin-FEED | W1018,W509,W615,W638,W906 |
| res:A108 | res:wtype-EDT | false | res:origin-FEED | W437 |
| res:A108 | res:wtype-REV | false | res:origin-FEED | W859 |

Query 4:

| w | au | o | i | t | r | y |
|---|---|---|---|---|---|---|
| res:W08 | res:A04 | 0000-0004-8662-8360 | res:I07 | res:wtype-ART | false | 2025 |
| res:W37 | res:A05 | 0000-0001-6105-5008 | res:I05 | res:wtype-ART | false | 2022 |
| res:W38 | res:A06 | 0000-0007-5475-1779 | res:I12 | res:wtype-ART | false | 2023 |
| res:W70 | res:A08 | 0000-0007-9318-6032 | res:I04 | res:wtype-ART | false | 2023 |
| res:W70 | res:A08 | 0000-0007-9318-6032 | res:I06 | res:wtype-ART | false | 2023 |
| res:W71 | res:A08 | 0000-0007-9318-6032 | res:I06 | res:wtype-ART | false | 2024 |
| res:W71 | res:A08 | 0000-0007-9318-6032 | res:I04 | res:wtype-ART | false | 2024 |

Query 5:

| w | y | t | r |
|---|---|---|---|
| res:W30 | 2019 | res:wtype-ART | false |
| res:W31 | 2023 | res:wtype-ART | false |
| res:W42 | 2023 | res:wtype-PPR | false |
| res:W02 | 2022 | res:wtype-PPR | false |
| res:W03 | 2023 | res:wtype-ART | false |

Query 6:

| total | authorSelf | albury | system | country |
|---|---|---|---|---|
| 30 | 7 | 12 | 18 | 21 |

Query 7:

| hop | n | ws |
|---|---|---|
| 1 | 8 | W229,W40,W41,W602,W657,W660,W844,W895 |
| 2 | 14 | W682,W338,W396,W50,W51,W546,W895,W922,W52,W90,W1042,W337,W801,W844 |

Query 8:

| cd | n |
|---|---|
| res:W22 | 19 |
| res:W20 | 14 |
| res:W401 | 5 |
| res:W21 | 3 |
| res:W227 | 3 |
| res:W599 | 3 |

Query 9:

| root | n |
|---|---|
| res:I12 | 16 |
| res:I01 | 8 |
| res:I11 | 5 |
| res:I09 | 4 |
| res:I14 | 3 |
| res:I17 | 3 |
| res:I13 | 2 |
| res:I18 | 2 |
| res:I30 | 1 |
| res:I26 | 1 |
| res:I28 | 1 |
| res:I15 | 1 |
| res:I16 | 1 |
| res:I31 | 1 |
| res:I27 | 1 |
| res:I24 | 1 |

Query 10:

| cd | n |
|---|---|
| res:W20 | 14 |
| res:W203 | 0 |
| res:W21 | 3 |
| res:W22 | 19 |
| res:W232 | 0 |
| res:W268 | 0 |
| res:W366 | 1 |
| res:W417 | 2 |
| res:W478 | 0 |
| res:W531 | 1 |
| res:W686 | 0 |
| res:W714 | 0 |
| res:W738 | 0 |
| res:W802 | 0 |
| res:W967 | 1 |

Query 11:

| au | n |
|---|---|
| res:A110 | 15 |
| res:A07 | 15 |
| res:A118 | 14 |
| res:A08 | 11 |
| res:A111 | 10 |
| res:A125 | 10 |

Query 12:

| w | x | rs |
|---|---|---|
| res:W19 |  | res:origin-CRIS |
| res:W73 |  | res:origin-CRIS |
| res:W12 |  | res:origin-CRIS |
| res:W372 |  | res:origin-STG |
| res:W802 |  | res:origin-STG |
| res:W866 |  | res:origin-STG |
| res:W91 |  | res:origin-STG |
| res:W92 |  | res:origin-STG |
| res:W268 |  | res:origin-STG |
| res:W329 |  | res:origin-STG |
| res:W397 |  | res:origin-STG |
| res:W488 |  | res:origin-STG |
| res:W819 |  | res:origin-STG |
| res:W844 |  | res:origin-STG |
| res:W878 |  | res:origin-STG |
| res:W90 |  | res:origin-STG |
| res:W971 |  | res:origin-STG |
| res:W987 |  | res:origin-STG |
| res:W569 |  | res:origin-STG |
| res:W582 |  | res:origin-STG |
| res:W700 |  | res:origin-STG |
| res:W714 |  | res:origin-STG |
| res:W734 |  | res:origin-STG |
| res:W868 |  | res:origin-STG |
| res:W573 |  | res:origin-STG |
| res:W680 |  | res:origin-STG |
| res:W997 |  | res:origin-STG |
| res:W610 |  | res:origin-STG |

Query 13 failed: Expected end of text, found 'sparql'  (at char 794), (line:16, col:1)

Run more queries, or give the final answers.

The model

I need one more round to fix the aggregates that came back empty.

```sparql
SELECT ?root ?rs ?yy (COUNT(DISTINCT ?c) AS ?n) WHERE {
 VALUES ?root {res:I01 res:I02 res:I05 res:I06 res:I07 res:I08 res:I14}
 ?a res:institution ?i ; res:work ?w .
 ?i res:parent* ?root .
 ?w res:workType ?t ; res:retracted false ; res:year ?y ; res:recordSource ?rs .
 FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR))
 OPTIONAL{?w res:versionOf ?v}
 BIND(COALESCE(?v,?w) AS ?c)
 BIND(IF(?y=2024,"y24",IF(?y=2025,"y25","other")) AS ?yy)
} GROUP BY ?root ?rs ?yy ORDER BY ?root ?rs ?yy
```

```sparql
SELECT (COUNT(?w) AS ?full) (SUM(?g/?n) AS ?fracGB) (SUM(IF(?k7>0,1,0)) AS ?full7) (SUM(?k7/?n) AS ?frac7) (SUM(IF(?k9>0,1,0)) AS ?full9) (SUM(?k9/?n) AS ?frac9) (SUM(IF(?g>0,1,0)) AS ?fullGB) WHERE {
 { SELECT ?w (COUNT(DISTINCT ?au) AS ?n)
   (COUNT(DISTINCT IF(?cty="GB",?au,?x)) AS ?g)
   (COUNT(DISTINCT IF(?i IN (res:I07,res:I08,res:I22),?au,?x)) AS ?k7)
   (COUNT(DISTINCT IF(?i IN (res:I09,res:I23),?au,?x)) AS ?k9)
   WHERE {
   ?w res:year 2024 ; res:workType ?t ; res:retracted false .
   FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR))
   ?a res:work ?w ; res:author ?au ; res:institution ?i . ?i res:country ?cty .
 } GROUP BY ?w }
}
```

```sparql
SELECT ?base (COUNT(DISTINCT ?cw) AS ?tot) (COUNT(DISTINCT IF(?cy>=?by && ?cy<=?by+2,?cw,?x)) AS ?win) WHERE {
 VALUES ?base {res:W30 res:W31}
 ?base res:year ?by .
 ?cd (res:versionOf|^res:versionOf)? ?base .
 ?c res:citedWork ?cd ; res:citingWork ?cw .
 ?cw res:year ?cy .
} GROUP BY ?base
```

```sparql
SELECT ?s ?yy (COUNT(DISTINCT ?w) AS ?n) WHERE {
 VALUES ?s {res:S01 res:S02 res:S04 res:S06}
 ?w res:source ?s ; res:workType ?t ; res:retracted false ; res:year ?y .
 FILTER(?t IN (res:wtype-ART,res:wtype-REV,res:wtype-PPR))
 BIND(IF(?y=2024,"y24","all") AS ?yy)
} GROUP BY ?s ?yy ORDER BY ?s ?yy
```

Query results

Query 1:

| root | rs | yy | n |
|---|---|---|---|
| res:I01 | res:origin-CRIS | other | 3 |
| res:I01 | res:origin-FEED | other | 171 |
| res:I02 | res:origin-CRIS | other | 3 |
| res:I02 | res:origin-FEED | other | 114 |
| res:I05 | res:origin-CRIS | other | 1 |
| res:I05 | res:origin-FEED | other | 57 |
| res:I06 | res:origin-CRIS | other | 1 |
| res:I06 | res:origin-FEED | other | 21 |
| res:I07 | res:origin-FEED | other | 65 |
| res:I07 | res:origin-STG | other | 19 |
| res:I08 | res:origin-FEED | other | 24 |
| res:I14 | res:origin-FEED | other | 47 |

Query 2 failed: 'NotBoundError' object has no attribute 'datatype'

Query 3:

| base | tot | win |
|---|---|---|
| res:W30 | 18 | 18 |
| res:W31 | 13 | 14 |

Query 4:

| s | yy | n |
|---|---|---|
| res:S01 | all | 95 |
| res:S02 | all | 116 |
| res:S04 | all | 13 |
| res:S06 | all | 26 |

This was the last round: give the final answers now, with no more queries.

The model

Several answers below are estimates because my last round of queries failed or came back empty. The affected ones are Q12 to Q15, Q34 and Q39.

**Q1.** 1. A01, A02 and A03 share ORCID 0000-0002-9841-6229.
**Q2.** 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.
**Q3.** No. W37 is by A05 and W38 by A06, with different ORCIDs.
**Q4.** 9. A05 and A104 share an ORCID and have 10 research records; W556 is a preprint of W1038, so it is counted once.
**Q5.** No. W08 is by A04, whose ORCID differs from Mara's.
**Q6.** A110, tied with A07 at 15 by record. I picked A110 on the assumption that merging its aliases by ORCID would push it ahead, but I did not check this.
**Q7.** 22. This is 25 research records (types ART, REV or PPR, not retracted), less 3 preprint duplicates (W02, W663, W612).
**Q8.** I01. The chain is I04, then I03, I02, I01.
**Q9.** 117, counting works by units under I02 and merging preprints into their published versions. This count includes I06, which is typed as an affiliate (itype-AFF) and may not be a true unit.
**Q10.** 174.
**Q11.** 65. This excludes the 19 STG (staging) records.
**Q12.** Full 15, fractional 8.5 (a guess, as the query failed).
**Q13.** Full: I07. Fractional: I09 (a guess, based on Q47).
**Q14.** Full 30, fractional 17.5 (a guess, as the query failed).
**Q15.** 20 (a guess, as the query failed).
**Q16.** 95.
**Q17.** W04, W271, W936 (editorials) and W05, W813, W949 (errata).
**Q18.** 15, after merging the preprints W02 into W03 and W219 into W251.
**Q19.** 30.
**Q20.** The 23 preprints that have a `versionOf` link: W02, W1049, W210, W219, W226, W263, W322, W407, W416, W42, W432, W460, W506, W522, W524, W545, W556, W611, W612, W663, W728, W730, W877.
**Q21.** 47.
**Q22.** W30 has more in total (18 vs 13) and more in the window (18 vs 14).
**Q23.** 18 in total and 18 in the window.
**Q24.** 12. This is A09 plus A103 (same ORCID), excluding retracted works and STG records.
**Q25.** 41. The works W20, W21, W22, W366, W417, W531 and W967 have 14, 3, 19, 1, 2, 1 and 1 citations.
**Q26.** No. W23 is retracted.
**Q27.** I12, with 16 citing works.
**Q28.** 4.
**Q29.** 7 at author level, 12 at institution level, 21 at country level.
**Q30.** 18.
**Q31.** The 14 works at hop two: W682, W338, W396, W50, W51, W546, W895, W922, W52, W90, W1042, W337, W801, W844.
**Q32.** 20. There are 8 direct citers and 14 at hop two, with W895 and W844 in both.
**Q33.** W22, with 19 citations.
**Q34.** 5 (a guess, as the query failed).
**Q35.** 24.
**Q36.** 26.
**Q37.** I04. W70 is also credited to I06, which the single-ID field cannot hold.
**Q38.** I06, I04, I03, I02, I01.
**Q39.** 20 (a guess, as the query failed). S01 is the only tier-K3 source.
**Q40.** S01.
**Q41.** No. S03 is tier K1 and S02 is tier K2.
**Q42.** 13.
**Q43.** Yes. W07 is a non-retracted article.
**Q44.** I02, I03, I04, I05, I06, I19, I20, I21.
**Q45.** 22.
**Q46.** I01.
**Q47.** Not computed. A likely reason is that Kesting has more works but with larger author lists, so its fractional share is lower.
**Q48.** Not resolved from the data. W70 lists I04 and I06, so the exclusion may come from I06's affiliate type (itype-AFF) or from how unit membership is defined, but I could not confirm either.

```json
{"Q1":{"count":1},"Q2":{"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"]},"Q3":{"same":"no"},"Q4":{"count":9},"Q5":{"same":"no"},"Q6":{"author":"A110"},"Q7":{"count":22},"Q8":{"parent":"I01"},"Q9":{"count":117},"Q10":{"count":174},"Q11":{"count":65},"Q12":{"full":15,"fractional":8.5},"Q13":{"full":"I07","fractional":"I09"},"Q14":{"full":30,"fractional":17.5},"Q15":{"count":20},"Q16":{"count":95},"Q17":{"works":["W04","W271","W936","W05","W813","W949"]},"Q18":{"count":15},"Q19":{"count":30},"Q20":{"works":["W02","W1049","W210","W219","W226","W263","W322","W407","W416","W42","W432","W460","W506","W522","W524","W545","W556","W611","W612","W663","W728","W730","W877"]},"Q21":{"count":47},"Q22":{"more_in_total":"W30","more_in_window":"W30"},"Q23":{"total":18,"in_window":18},"Q24":{"count":12},"Q25":{"count":41},"Q26":{"counts":"no"},"Q27":{"institution":"I12","citing_works":16},"Q28":{"count":4},"Q29":{"author":7,"institution":12,"country":21},"Q30":{"count":18},"Q31":{"works":["W682","W338","W396","W50","W51","W546","W895","W922","W52","W90","W1042","W337","W801","W844"]},"Q32":{"count":20},"Q33":{"work":"W22"},"Q34":{"count":5},"Q35":{"count":24},"Q36":{"count":26},"Q37":{"institution":"I04"},"Q38":{"institutions":["I06","I04","I03","I02","I01"]},"Q39":{"count":20},"Q40":{"source":"S01"},"Q41":{"higher":"no"},"Q42":{"count":13},"Q43":{"research":"yes"},"Q44":{"institutions":["I02","I03","I04","I05","I06","I19","I20","I21"]},"Q45":{"count":22},"Q46":{"parent":"I01"}}
```