Differences

This shows you the differences between two versions of the page.

--- project:schauspielhauswikidata [2017/09/16 16:11] – created liowalter
+++ project:schauspielhauswikidata [2020/03/17 11:55] (current) – [Data] birk
@@ Line 1: / Line 1: @@
-===== Schauspielhaus performances in Wikidata =====
+===== Schauspielhaus Zürich performances in Wikidata =====
 The goal of the project is to try to ingest all performances of the Schauspielhaus Theater in Zurich held between 1938 and 1968 in Wikidata. In a further step, data from the [[http://www.performing-arts.eu|www.performing-arts.eu Platform]], [[http://www.theatersammlung.ch|Swiss Theatre Collection]] and other data providers could be ingested as well.
@@ Line 5: / Line 5: @@
 ===== Data =====
-* [[Repertoire des Schauspielhaus Zürich, 1938-1968 |https://opendata.swiss/de/dataset/repertoire-des-schauspielhaus-zurich-1938-1968]]
+  * [[https://opendata.swiss/de/dataset/repertoire-des-schauspielhaus-zurich-1938-19682|Repertoire des Schauspielhaus Zürich, 1938-1968]]
 ===== Tools =====
   * OpenRefine to clean and reconcile data with wikidata
-  * Wikidata Quick Statements to add new item to wikidata
+  * [[https://tools.wmflabs.org/wikidata-todo/quick_statements.php|Wikidata Quick Statements]] to add new items to wikidata
-  *
+  * [[https://tools.wmflabs.org/quickstatements/|Wikidata Quick Statements 2 Beta]] to add new items to wikidata in batch mode
-===== Performing arts and Wikidata =====
+===== References =====
+  * [[https://www.wikidata.org/wiki/Wikidata:WikiProject_Performing_arts/Data_sources/CH]]
+  * [[http://make.opendata.ch/wiki/project:performing_arts_ontology|Performing Arts Ontology]]
   * [[https://www.wikidata.org/wiki/Wikidata:WikiProject_Performing_arts|WikiProject Performing arts]]
   * [[https://www.wikidata.org/wiki/Wikidata:WikiProject_Cultural_venues|WikiProject Cultural venues]]
@@ Line 23: / Line 27: @@
-===== Ontology & Data Model =====
+===== Methodology =====
+  - load data in OpenRefine
+  - Column after column (starting with the easier ones) :
+    - reconcile against wikidata
+    - manually match entries that matched multiple entries in wikidata
+    - find out what items are missing in wikidata
+    - load them in wikidata using quick statements (quick statements 2 allow you to retrieve the Q numbers of the newly created items)
+    - reconcile again in OpenRefine
+===== Results =====
+  * https://www.wikidata.org/wiki/Q39907209
+  * Code to transform csv into quick statements : https://github.com/j4lib/performing-arts/blob/master/create_quick_statements.php
+===== Screenshots =====
+====== Raw Data ======
+{{:project:screenshot_132.png?direct&1000|}}
+====== Reconcile in OpenRefine ======
+{{:project:screenshot_133.png?direct&1000|}}
+====== Choose corresponding type ======
+For Work, you can use the author as an additional property
+{{:project:screenshot_134.png?direct&1000|}}
+====== Manually match multiple matches ======
+{{:project:screenshot_136.png?direct&1000|}}
+====== Import in Wikidata with quick statements ======
+Step 1
+{{:project:screenshot_138.png?direct&1000|}}
+  * Len : english label
+  * P31 : instance of
+  * Q5 : human
+  * P106 : occupation
+  * Q1323191 : costume designer
+Step 2
+{{:project:screenshot_139.png?direct&1000|}}
+Step 3 (you can get the Q number from there)
+{{:project:screenshot_140.png?direct&1000|}}
-  * [[http://make.opendata.ch/wiki/project:performing_arts_ontology|Performing Arts Ontology]]
-  * [[https://www.wikidata.org/wiki/Wikidata:WikiProject_Performing_arts/Data_sources/CH]]
 ===== Team =====