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

• Repertoire des Schauspielhaus Zürich, 1938-1968

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

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Performing_arts/Data_sources/CH
• Performing Arts Ontology
• WikiProject Performing arts
• WikiProject Cultural venues
• Wiki Project Cultural events

Methodology

1. load data in OpenRefine

2. Column after column (starting with the easier ones) :

   1. reconcile against wikidata

   2. manually match entries that matched multiple entries in wikidata

   3. find out what items are missing in wikidata

   4. load them in wikidata using quick statements (quick statements 2 allow you to retrieve the Q numbers of the newly created items)

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

Reconcile in OpenRefine

Choose corresponding type

For Work, you can use the author as an additional property

Manually match multiple matches

Import in Wikidata with quick statements

Step 1

• Len : english label
• P31 : instance of
• Q5 : human
• P106 : occupation
• Q1323191 : costume designer

Step 2

Step 3 (you can get the Q number from there)

Team

• Renate Albrecher
• Julia Beck
• Flor Méchain
• Beat Estermann
• Birk Weiberg
• Lionel Walter