{"id":841,"date":"2026-06-05T12:01:28","date_gmt":"2026-06-05T11:01:28","guid":{"rendered":"http:\/\/magnusmanske.de\/wordpress\/?p=841"},"modified":"2026-06-11T11:43:49","modified_gmt":"2026-06-11T10:43:49","slug":"freeform-statements","status":"publish","type":"post","link":"http:\/\/magnusmanske.de\/wordpress\/archives\/841","title":{"rendered":"Freeform statements"},"content":{"rendered":"<p>My <a href=\"https:\/\/mix-n-match.toolforge.org\/\">Mix&#8217;n&#8217;match<\/a> tool has a little-known feature that I think deserves a little attention.<\/p>\n<p>A catalog in Mix&#8217;n&#8217;match is a list of entries in other datasets that should be matched to Wikidata. Besides some required core data for each entry, the user importing the catalog can add key-value-pairs for Wikidata statements that can help to match the entry (e.g. VIAF ID), or can be nice-to-have for item creation (e.g. occupation).<\/p>\n<p>Now, many datasets contain such additional information, but often in free-form text. That person here was born in Berlin &#8211; but is it the Berlin in Germany, or the one in <a href=\"https:\/\/en.wikipedia.org\/wiki\/Berlin,_New_Hampshire\">New Hampshire<\/a>? This often depends on the context of the dataset. This makes conversion from free-form text to proper Wikidata IDs difficult and time-consuming, and a hurdle before import into Mix&#8217;n&#8217;match. So often such data gets thrown away.<\/p>\n<p>But there is another way: If you know the Wikidata property for a &#8220;factoid&#8221; in your dataset (e.g. &#8220;place of birth&#8221;), you can import it as a &#8220;statement text&#8221;. It is still a key-value-pair, but while the key is a Wikidata property ID, the value can be anything you like.<\/p>\n<p><iframe style=\"float:right; margin-left:1rem;\" src=\"https:\/\/commons.wikimedia.org\/wiki\/File:Mix%27n%27match_statement_text.webm?embedplayer=yes\" width=\"240\"  frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>So that &#8220;statement text&#8221; is now sitting in the Mix&#8217;n&#8217;match database (~1.4 million rows, at the time of writing this). But what can you do with that? You can convert it to &#8220;normal&#8221; auxiliary statement data via a handy web interface! But wait, do you have to do this for every single &#8220;statement text&#8221;? Not necessarily! As it turns out, within a catalog and a property, there are often repeat values. As you can see in the video, a taxon rank called &#8220;form&#8221; is used over 300 times in this catalog. <em>In this context<\/em>, they all refer to the same thing. Search results for this value are presented to you, and in this case, it happens to be the first hit on the list. One click, and all 328 taxon ranks are converted into the appropriate Wikidata item value.<\/p>\n<p>The link to &#8220;statement text&#8221; in the action drop-down will appear only if the catalog has any (unmatched) statement text for you to work on. So, feel free to import free (-form text) with your next catalog!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>My Mix&#8217;n&#8217;match tool has a little-known feature that I think deserves a little attention. A catalog in Mix&#8217;n&#8217;match is a list of entries in other datasets that should be matched to Wikidata. Besides some required core data for each entry, the user importing the catalog can add key-value-pairs for Wikidata statements that can help to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-841","post","type-post","status-publish","format-standard","hentry","category-wikidata"],"_links":{"self":[{"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/posts\/841","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/comments?post=841"}],"version-history":[{"count":6,"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/posts\/841\/revisions"}],"predecessor-version":[{"id":847,"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/posts\/841\/revisions\/847"}],"wp:attachment":[{"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/media?parent=841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/categories?post=841"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/magnusmanske.de\/wordpress\/wp-json\/wp\/v2\/tags?post=841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}