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 • This Month in GLAM • 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 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!