Projects/This Month in GLAM

Some topical projects initiated by the WMSE team to create basic data. See what's been done and how you can help out. Conferences • This Month in GLAM • GLAM events • Support items • OpenRefine • Maintenance

We've created items for This Month in GLAM (Q23369) newsletters. Example: This Month in GLAM - February 2024 (Q31581).

✅ Country reports and special reports up to February 2025 have been created. Example: This Month in GLAM - April 2024, Sweden report (Q23374), This Month in GLAM - February 2015, Open Access report (Q33459)

🚧 Work is ongoing on adding author (P19) and main subject (P15) statements.

🖊️ Help out by adding detailed main subject (P15) statements.

All This Month in GLAM reports

# This Month in GLAM reports with main subjects and authors

PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>

SELECT ?item ?itemLabel (GROUP_CONCAT(DISTINCT ?mainsubjectLabel; SEPARATOR = ", ") AS ?topics) (GROUP_CONCAT(DISTINCT ?authorLabel; SEPARATOR = ", ") AS ?by)
WHERE
{
?item wbt:P5 wb:Q29 .
?item wbt:P17 ?mainitem.
?mainitem wbt:P17 wb:Q23369.
OPTIONAL {?item wbt:P15 ?mainsubject}
OPTIONAL {?item wbt:P19 ?author}
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en".
    ?item rdfs:label ?itemLabel.
    ?author rdfs:label ?authorLabel.
    ?mainsubject rdfs:label ?mainsubjectLabel.
  }
}
GROUP BY ?item ?itemLabel

Try it!

Reports without a disambiguated author

Not all authors have Metabase items yet. Metabase uses temporary free text field (P38) as a more general equivalent of Wikidata's author name string (as we sometimes need it for other purposes than authors).

🖊️ Help out by creating missing Metabase items for This Month in GLAM authors, which you can find using the query below. See Modelling/Humans for specific considerations for humans in Metabase.

# Instances of 'report' with a temp free text field

PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
PREFIX wbp: <https://metabase.wikibase.cloud/prop/>
PREFIX wbpq: <https://metabase.wikibase.cloud/prop/qualifier/>
SELECT DISTINCT ?item ?itemLabel ?val ?qual ?qualLabel
WHERE
{
?item wbt:P38 ?val.
?item wbt:P5 wb:Q29
OPTIONAL {?item wbp:P38 ?statement.
?statement wbpq:P41 ?qual .}
     
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,sv". }
}
ORDER BY ?val

Try it!