 
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 www.performing-arts.eu Platform, Swiss Theatre Collection and other data providers could be ingested as well.
Data
Tools
- 
OpenRefine to clean and reconcile data with wikidata
- 
Wikidata Quick Statements to add new items to wikidata
- 
Wikidata Quick Statements 2 Beta to add new items to wikidata in batch mode
References
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
- 
Code to transform csv into quick statements : https://github.com/j4lib/performing-arts/blob/master/create_quick_statements.php
Screenshots
Raw Data
Reconcile in OpenRefine
Choose corresponding type
Manually match multiple matches
Import in Wikidata with quick statements
- 
Len : english label
- 
P31 : instance of
- 
Q5 : human
- 
P106 : occupation
- 
Q1323191 : costume designer
Step 3 (you can get the Q number from there)
Team
- 
Renate Albrecher
- 
Julia Beck
- 
Flor Méchain
- 
Beat Estermann
- 
Birk Weiberg
- 
Lionel Walter
Evènement
              3rd Swiss Open Cultural Data Hackathon
          Date
              Lieu
              Bern
          





