Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ===== 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}} project/schauspielhauswikidata.txt Last modified: 2020/03/17 11:55by birk