ZBW Labs - Open data //zbw.eu/labs/en/tag/open-data en 20th Century Press Archives: Data donation to Wikidata //zbw.eu/labs/en/blog/20th-century-press-archives-data-donation-to-wikidata <div class="field field-name-body field-type-text-with-summary field-label-hidden"><div class="field-items"><div class="field-item even" property="schema:articleBody content:encoded"><p>ZBW is donating a large open dataset from the <a href="http://webopac.hwwa.de/pressemappe20">20th Century Press Archives</a> to Wikidata, in order to make it better accessible to various scientific disciplines such as contemporary, economic and business history, media and information science, to journalists, teachers, students, and the general public.</p> <p>The 20th Century Press Archives (PM20) is a large public newspaper clippings archive, extracted from more than 1500 different sources published in Germany and all over the world, covering roughly a full century (1908-2005). The clippings are organized in thematic folders about persons, companies and institutions, general subjects, and wares. During a project originally funded by the German Research Foundation (DFG), the material up to 1960 has been digitized. 25,000 folders with more than two million pages up to 1949 are freely accessible online.  The fine-grained thematic access and the public nature of the archives makes it to our best knowledge <a href="https://www.wikidata.org/wiki/Wikidata:WikiProject_20th_Century_Press_Archives/List_of_newspaper_clippings_archives">unique </a>across the world (more information on <a href="https://en.wikipedia.org/wiki/20th_Century_Press_Archives%20">Wikipedia</a>) and an essential research data fund for some of the disciplines mentioned above.</p> <p>The data donation does not only mean that ZBW has assigned a CC0 license to all PM20 metadata, which makes it compatible with Wikidata. (Due to intellectual property rights, only the metadata can be licensed by ZBW - all legal rights on the press articles themselves remain with their original creators.) The donation also includes investing a substantial amount of working time (during, as planned, two years) devoted to the integration of this data into Wikidata. Here we want to share our experiences regarding the integration of the persons archive metadata.</p> <p><!--break--></p><p><img alt="Folders from the person archive, 2015 (Credit: Max-Michael Wannags)" title="Folders from the person archive, 2015 (Credit: Max-Michael Wannags)" height="853" width="1280" class="media-element file-default" data-delta="2" typeof="foaf:Image" src="//zbw.eu/labs/sites/default/files/media/1280px-ZBW-Personenarchiv_2015.jpg" /></p> <p style="text-align: center;">Folders from the persons archive, in 2015 <small>(Credit: Max-Michael Wannags)</small></p> <p><strong>Linking our folders to Wikidata</strong><br /><br />The essential bit for linking the digitized folders was in place before the project even started: an external identifier property (PM20 folder ID, <a href="https://www.wikidata.org/wiki/Property:P4293">P4293</a>), proposed by an administrator of the German Wikipedia in order to link to PM20 person and company folders. We participated in the property proposal discussion and made sure that the links did not have to reference our legacy Coldfusion application. Instead, we created a "partial redirect" on the <a href="https://archive.org/services/purl">purl.org</a> service (maintained formerly by OCLC, now by the Internet Archive) for persistent URLs which may redirect to another application on another server in future. Secondly, the identifier and URL format was extended to include subject and ware folders, which are defined by a combination of two keys, one for the country and another for the topic. The format of the links in Wikidata is <a href="https://www.wikidata.org/wiki/Property:P4293#P1793">controlled by a regular expression</a>, which covers all four archives mentioned above. That works pretty well -  <a href="https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P4293#%22Format%22_violations">very few format errors</a> occurred so far -, and it relieved us from creating four different archive-specific properties.<br /><br />Shortly after the property creation, Magnus Manske, the author of the original Mediawiki software and lots of related tools, scraped our web site and created a <a href="https://tools.wmflabs.org/mix-n-match/#/catalog/581">Mix-n-Match catalog</a> from it. During the following two years, more than 60 Wikidata users contributed to matching Wikidata items for humans to PM20 folder IDs. <br /><br /><strong>For a start, deriving links from GND</strong></p> <p>Many of the PM20 person and company folders were already identified by an identifier from the German Integrated Authority File (GND). So, our first step was creating PM20 links for all Wikidata items which had matching GND IDs. For all these items and folders, disambiguation had already taken place, and we could safely add all these links automatically.</p> <p>I<strong>nfrastructure: PM20 endpoint, federated queries and QuickStatements</strong></p> <p>To make this work, we relied heavily on Linked Data technologies. A <a href="http://zbw.eu/beta/sparql-lab/?endpoint=http://zbw.eu/beta/sparql/pm20/query&amp;queryRef=https://api.github.com/repos/jneubert/sparql-queries/contents/pm20/search_folders_by_text.rq">PM20 SPARQL endpoint</a> had already been set up for our <a href="/blog/zbws-contribution-to-coding-da-vinci-dossiers-about-persons-and-companies-from-20th-century-press-archives">contribution to Coding da Vinci</a> (a "Kultur-Hackathon" in Germany). Almost all automated changes to Wikidata we made are based on <a href="https://www.w3.org/TR/sparql11-federated-query/">federated queries</a> on our own endpoint, reaching out to the <a href="https://query.wikidata.org">Wikidata endpoint</a>, or vice versa, from Wikidata to PM20. In the latter case, the external endpoint has to be <a href="https://www.mediawiki.org/wiki/Wikidata_Query_Service/User_Manual/SPARQL_Federation_endpoints">registered </a>at Wikidata. Wikidata maintains a <a href="https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Federated_queries">help page</a> for this type of queries.</p> <p>For our purposes, federated queries allow extracting current data from both endpoints. In the case of the above-mentioned <a href="https://github.com/zbw/sparql-queries/blob/master/wikidata/missing_pm20_id_via_gnd.rq">missing_pm20_id_via_gnd.rq</a> query, this way we can skip all items, where a link to PM20 already exists.</p> <p>Within the query itself, we create a statement string which we can feed into the <a href="https://tools.wmflabs.org/quickstatements/#/">QuickStatements </a>tool. That includes, for every single statement, a reference to PM20 with link to the actual folder, so that the provenance of these statements is always clear and traceable. Via <a href="https://github.com/zbw/sparql-queries/blob/master/bin/make_qs_input.pl">script</a>, a statement file is extracted and saved with a timestamp. Data imports via QuickStatements are executed in batch mode, and an <a href="https://www.wikidata.org/wiki/Wikidata:WikiProject_20th_Century_Press_Archives/Tools_%26_Tasks/Log">activity log</a> keeps track of all data imports and other activities related to PM20.</p> <p><strong>Creating missing items</strong></p> <p>After the matching of about 93 % of the person folders which include free documents in Mix-n-Match, and some efforts to discover more pre-existing Wikidata items, we decided to create the 346 missing person items, again <a href="https://www.wikidata.org/wiki/Wikidata:WikiProject_20th_Century_Press_Archives/Tools_%26_tasks#Add_items_for_all_un-linked_person_folders">via QuickStatements</a> input. We used the description field in Wikidata by importing the content of the free-text "occupation" field in PM20 for better disambiguation of the newly created items. (Here a rather minimal <a href="https://www.wikidata.org/wiki/Q64589732">example</a> of such an item created from PM20 metadata.) Thus, all PM20 person folders which have digitized content were linked to Wikidata in June 2019.</p> <p><strong>Supplementing Wikidata with PM20 metadata</strong></p> <p>A second part of the integration of PM20 metadata into Wikidata was the import of missing property values to the according items. This comprised simple facts like "date of birth/death", occupations such as "economist", "business economist", "social scientist", "earth scientist", which we could derive from the "field of activity" in PM20, up to relations between existing items, e.g. a family member to the according family, or a board member to the according company. A few other source properties have been postponed, because alternative solutions exist, and the best one may depend on the intended use in future applications. The steps of this enrichment process and links to the code used - including the automatic generation of references - <a href="https://www.wikidata.org/wiki/Wikidata:WikiProject_20th_Century_Press_Archives/Tools_%26_tasks#Add_person_information_from_PM20_to_WD">are online</a>, too.</p> <p><img alt="Addition to Wikidata item &quot;Friedrich Krupp AG&quot; (Q679201) from PM20 metadata" title="Addition to Wikidata item &quot;Friedrich Krupp AG&quot; (Q679201) from PM20 metadata" height="375" width="971" class="media-element file-default" data-delta="3" typeof="foaf:Image" src="//zbw.eu/labs/sites/default/files/media/krupp_advisory_board_2.png" /></p> <p style="text-align: center;">Complex statement added to Wikidata item for <a href="https://www.wikidata.org/wiki/Q679201">Friedrich Krupp AG</a></p> <p>Again, we used federated queries. Often the target of a Wikidata property is an item in itself. Sometimes, we could directly get this via the target item's PM20 folder ID (families, companies); sometimes we had to create lookup tables. For the latter, we used "values" clauses in the query (in case of "occupation"), or (in case of "country of citizenship"), we have to match countries from our internal classification in advance - a process for which we use OpenRefine. Other than PM20 folder IDs, which we avoided adding when folders do not contain digitized content, we added the metadata to <em>all</em> items which were linked to PM20, and intend to repeat this process periodically when more items (e.g., companies) are identified by PM20 folder IDs. In some housekeeping activity, we also add periodically the numbers of documents (online and total) and the exact folder names as qualifiers to newly emerging PM20 links in items.</p> <p><strong>Results of the data donation so far</strong></p> <p>With all 5266 persons folder with digitized documents linked to Wikidata, the data donation of the person folders metadata is completed. Besides the folder links, which have already heavily been used to create links in Wikipedia articles, we have got</p> <p>- more than 6000 statements which are <a href="http://zbw.eu/beta/sparql-lab/?endpoint=https://query.wikidata.org/sparql&amp;queryRef=https://api.github.com/repos/zbw/sparql-queries/contents/wikidata/pm20_references.rq">sourced in PM20</a> (from "date of birth" to the track gauge of a Brazilian railway line)</p> <p>- more than 1000 items, for which PM20 ID is the <a href="https://query.wikidata.org/#%23%20items%20with%20property%20P4293%20and%20no%20other%20identifiers%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fvalue%20%3Fst%0A%7B%0A%20%20%7B%0A%20%20%20%20%20%20%20SELECT%20%2a%0A%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Fitem%20wdt%3AP4293%20%3Fvalue%20%3B%20wikibase%3Aidentifiers%201%0A%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20LIMIT%201000%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fst%29%20%3Fitem">only external identifier</a></p> <p>The data donation will be presented on the WikidataCon in Berlin (24.-26.10.2019) as a "birthday present" on the occasion Wikidata's seventh birthday. ZBW will further keep the digital content available, amended with a static landing page for every folder, which also will serve as source link for the metadata we have integrated into Wikidata. But in future, Wikidata will be the primary access path to our data, providing further metadata in multiple languages and links to a plethora of other external sources. And the best is, different from our current application, everybody will be able to enhance this open data through the interactive tools and data interfaces provided by Wikidata.<br /><br /><strong>Participate in WikiProject 20th Century Press Archives<br /></strong></p> <p>For the topics, wares and companies archives, there is still a long way to go. The best structure for representing these archives and their folders - often defined by the combination of a country within a geographical hierarchy with a subject heading in a deeply nested topic classification -, has to be figured out. Existing items have to be matched, and lots of other work is to be done. Therefore, we have created the <a href="https://www.wikidata.org/wiki/Wikidata:WikiProject_20th_Century_Press_Archives">WikiProject 20th Century Press Archives in Wikidata</a> to keep track of discussions and decisions, and to create a focal point for participation. Everybody on Wikidata is invited to participate - or just kibitz. It could be challenging particularly for information scientists, and people interested in historic systems for the organization of knowledge about the whole world, to take part in the mapping of one of these systems to the emerging Wikidata knowledge graph.</p> <p> </p> </div></div></div><div class="field field-name-field-dbpedia-tags field-type-taxonomy-term-reference field-label-hidden"> <div class="field-items"> <span class="field-item even" rel="schema:about dc:subject doap:category"><a href="/labs/en/tag/linked-data" typeof="skos:Concept" property="rdfs:label skos:prefLabel" datatype="">Linked data</a></span> &#160; <span class="field-item odd" rel="schema:about dc:subject doap:category"><a href="/labs/en/tag/open-data" typeof="skos:Concept" property="rdfs:label skos:prefLabel" datatype="">Open data</a></span> &#160; </div> </div> Thu, 24 Oct 2019 09:43:18 +0000 Joachim Neubert 58 at //zbw.eu/labs //zbw.eu/labs/en/blog/20th-century-press-archives-data-donation-to-wikidata#comments
https://zbw.eu/labs/en/taxonomy/term/94/feed
zbw.eu
crawl=CC-MAIN-2021-25
17802
application/http; msgtype=response
sha1:3RS47O2G2VARBLU2LL2DUNVONMVIAZDC
<urn:uuid:7cf8be5d-be85-48c4-81ad-fd8f9ea21bea>
2021-06-16T11:42:13Z
134.245.10.101
application/rss+xml
sha1:QM5RIKHWUAZCM56ZQN7QSI4XAV3JWB27
<urn:uuid:e5815e07-7e80-4044-8cb5-10e73c559835>
https://zbw.eu/labs/en/taxonomy/term/94/feed
response
<urn:uuid:9cdc9aee-cee7-4f3e-87dc-21987f895267>
isPartOf: CC-MAIN-2021-25
publisher: Common Crawl
description: Wide crawl of the web for June 2021
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-93.ec2.internal
software: Apache Nutch 1.18 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.2-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: https://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/