Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
project:schauspielhauswikidata [2017/09/16 16:14] – [Ontology & Data Model] liowalter | project:schauspielhauswikidata [2020/03/17 11:55] (current) – [Data] birk | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Schauspielhaus performances in Wikidata ===== | + | ===== Schauspielhaus |
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:// | 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:// | ||
Line 5: | Line 5: | ||
===== Data ===== | ===== Data ===== | ||
- | * [[https:// | + | * [[https:// |
===== Tools ===== | ===== Tools ===== | ||
+ | |||
* OpenRefine to clean and reconcile data with wikidata | * OpenRefine to clean and reconcile data with wikidata | ||
- | * Wikidata Quick Statements to add new item to wikidata | + | * [[https:// |
- | * | + | * [[https:// |
- | |||
- | ===== Performing arts and Wikidata ===== | ||
- | |||
- | * [[https:// | ||
- | * [[https:// | ||
- | * [[https:// | ||
===== References ===== | ===== References ===== | ||
- | * [[http:// | ||
* [[https:// | * [[https:// | ||
+ | * [[http:// | ||
* [[https:// | * [[https:// | ||
* [[https:// | * [[https:// | ||
Line 33: | Line 28: | ||
| | ||
+ | ===== 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:// | ||
+ | * Code to transform csv into quick statements : https:// | ||
+ | ===== 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 ===== | ===== Team ===== | ||