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