Projects/OpenRefine

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

As a proof of concept of how we can work with topics in Metabase (using main subject (P15)), the WMSE team created items for educational material about the usage of OpenRefine (Q21961) in the Wikimedia context. This provided an opportunity to think about how different types of documents (both text and video based) and events, like presentations, can be modelled.

Examples:

• A conference session: OpenRefine workshop (Q23073)
• A slide deck: Wikidata and OpenRefine : (a love story) (Q23238)
• A video: Scraping databáze, zpracování získaných údajů a import do Wikidat (Q23253)
• A blog post: Creating new Wikidata items with OpenRefine and Quickstatements (Q23261)

🖊️ Help out by adding new educational resources about OpenRefine, or doing a focused project about another tool or topic!

Everything published or presented about OpenRefine

# Everything presented or published about OpenRefine

PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?typeLabel ?item ?itemLabel ?time
WHERE
{
?item wbt:P5/wbt:P4* wb:Q21.
?item wbt:P5 ?type.
?item wbt:P15 wb:Q21961.
OPTIONAL {?item wbt:P18 ?time } # publication date
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,sv". }
}
ORDER BY ?type

Try it!

Topics co-occurring with OpenRefine, as a graph

#defaultView:Graph
# Topics co-occurring with OpenRefine, as a graph

PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?topic1 ?topic1Label ?topic2 ?topic2Label
WITH {
  SELECT
    (COUNT(DISTINCT ?item) AS ?count) ?topic1 ?topic2
  WHERE {
    ?item wbt:P15 wb:Q21961. # OPENREFINE
    ?item wbt:P15 ?topic1, ?topic2 . 
    FILTER (wb:Q21961 != ?topic1 && wb:Q21961 != ?topic2 && ?topic1 != ?topic2)
  }
  GROUP BY ?topic1 ?topic2
  ORDER BY DESC(?count)
} AS %results
WHERE {
  INCLUDE %results
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,sv". }
}

Try it!