
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