{"id":11942,"date":"2008-02-29T14:06:50","date_gmt":"2008-02-29T13:06:50","guid":{"rendered":"http:\/\/192.220.58.236\/blog\/?p=95"},"modified":"2008-02-29T14:06:50","modified_gmt":"2008-02-29T13:06:50","slug":"data_quality_and_bandit_sheep","status":"publish","type":"post","link":"https:\/\/timoelliott.com\/blog\/2008\/02\/data_quality_and_bandit_sheep.html","title":{"rendered":"Data Quality and Bandit Sheep?"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" height=\"184\" alt=\"sheep2 copy\" src=\"https:\/\/i0.wp.com\/timoelliott.com\/blog\/WindowsLiveWriter\/DataQualityandBanditSheep_D376\/sheep2%20copy_3b28aef0-d6f7-4ec8-bb1a-86b6b58972ca.jpg?resize=159%2C184&#038;ssl=1\" width=\"159\" align=\"right\" border=\"0\">It was widely reported this week that more than <a href=\"http:\/\/www.iht.com\/articles\/2008\/02\/29\/america\/29prison.php\">one out of every 100 Americans is a criminal<\/a>.<\/p>\n<p>That&#8217;s nothing&#8230; There&#8217;s a country that I can&#8217;t name (but they play rugby and have lots of sheep). The national police force wanted a &#8220;single view of the criminal&#8221;, and so created a central data warehouse from a variety of operational and legacy systems. The ended up with a database of 4.5 million names. <\/p>\n<p>This was a problem, since the population of the country is only four million. So, either <em>everybody<\/em> in the country is a criminal AND they have half a million bandit sheep&#8230;<\/p>\n<p>&#8230;or they have a data quality problem. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>A country decided to create a central data warehouse to get a &#8220;single view of the criminal&#8221; &#8212; and ended up with more criminals than population&#8230;<\/p>\n","protected":false},"author":2,"featured_media":6233,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[160,204,342,579],"class_list":["post-11942","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-bi","tag-business-intelligence","tag-data-quality","tag-humor"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/timoelliott.com\/blog\/wp-content\/uploads\/2014\/01\/sheep2-copy_3b28aef0-d6f7-4ec8-bb1a-86b6b58972ca-1.jpg?fit=159%2C184&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3X9RF-36C","_links":{"self":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/11942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/comments?post=11942"}],"version-history":[{"count":0,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/posts\/11942\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media\/6233"}],"wp:attachment":[{"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/media?parent=11942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/categories?post=11942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/timoelliott.com\/blog\/wp-json\/wp\/v2\/tags?post=11942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}