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. Affiliates' reports and official documents • Conferences • EduWiki Hub collaboration • This Month in GLAM • Global GLAM Calls • GLAM events • Support items • OpenRefine • Wikipediapodden • 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 January 2026 have been created. Example: 100 000 bildminnen; Metabase (Q23374), Tracking recent uploads; Wikidata for research meetups; Ant-decapitating flies, Lego and a new frog (Q33459)

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

🖊️ Help out by adding detailed keyword (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:Q44583 .
?item wbt:P107 ?mainitem.
?mainitem wbt:P118 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:Q44583
OPTIONAL {?item wbp:P38 ?statement.
?statement wbpq:P41 ?qual .}
     
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,sv". }
}
ORDER BY ?val

Try it!