===== 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.

===== Data =====

  * [[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
  * [[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





===== 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]]
  * [[https://www.wikidata.org/wiki/Wikidata:WikiProject_Cultural_events|Wiki Project Cultural events]]


  
===== 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|}}




===== Team =====

  * Renate Albrecher
  * Julia Beck
  * Flor Méchain
  * Beat Estermann
  * Birk Weiberg
  * Lionel Walter
  
{{tag>status:concept needs:dev needs:design needs:data needs:expert glam semantic}}