{"id":15711,"date":"2015-11-21T13:52:21","date_gmt":"2015-11-21T19:52:21","guid":{"rendered":"http:\/\/bucktownbell.com\/?p=15711"},"modified":"2016-01-06T19:29:55","modified_gmt":"2016-01-07T01:29:55","slug":"exploring-the-wall-street-journals-pulitzer-winning-medicare-investigation-with-sql","status":"publish","type":"post","link":"http:\/\/bucktownbell.com\/?p=15711","title":{"rendered":"Exploring the Wall Street Journal&#8217;s Pulitzer-Winning Medicare Investigation with SQL"},"content":{"rendered":"<blockquote><p>This is a SQL-based introduction to the data and analysis behind the <a href=\"http:\/\/graphics.wsj.com\/medicare-billing\/\">Wall Street Journal&#8217;s Pulitzer-winning &#8220;Medicare Unmasked&#8221; investigative project<\/a>. It also doubles as a helpful guide if you&#8217;re attempting <a href=\"http:\/\/2015.padjo.org\/assignments\/midterm-wsj-medicare-walkthrough\/\">the midterm based on the WSJ Medicare&#8217;s investigation<\/a>.<\/p><\/blockquote>\n<p>Source: <em><a href=\"http:\/\/fall2015.padjo.org\/tutorials\/sql-walks\/exploring-wsj-medicare-investigation-with-sql\/\">Exploring the Wall Street Journal&#8217;s Pulitzer-Winning Medicare Investigation with SQL | Public Affairs Data Journalism at Stanford University<\/a><\/em><\/p>\n<blockquote><p>To follow along in this walkthrough, you can download my SQLite database here:<\/p><\/blockquote>\n<ul>\n<li>\n<blockquote><p><a class=\"url\" href=\"http:\/\/stash.padjo.org\/dumps\/2015\/medicare_providers_2012.sqlite.zip\">medicare_providers_2012.sqlite.zip<\/a> Be warned: it is nearly 700MB zipped and expands to more than 2 gigabytes.<\/p><\/blockquote>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This is a SQL-based introduction to the data and analysis behind the Wall Street Journal&#8217;s Pulitzer-winning &#8220;Medicare Unmasked&#8221; investigative project. It also doubles as a helpful guide if you&#8217;re attempting the midterm based on the WSJ Medicare&#8217;s investigation. Source: Exploring &hellip; <a href=\"http:\/\/bucktownbell.com\/?p=15711\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[170,1112,651,783,494],"class_list":["post-15711","post","type-post","status-publish","format-standard","hentry","category-programming","tag-data-modeling","tag-data-sets","tag-sql","tag-stanford","tag-tutorial"],"_links":{"self":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/15711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15711"}],"version-history":[{"count":1,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/15711\/revisions"}],"predecessor-version":[{"id":15712,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/15711\/revisions\/15712"}],"wp:attachment":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15711"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}