{"id":70,"date":"2017-09-19T02:40:11","date_gmt":"2017-09-19T02:40:11","guid":{"rendered":"http:\/\/lanimcleod.com\/?p=70"},"modified":"2018-05-18T12:00:46","modified_gmt":"2018-05-18T12:00:46","slug":"media-explorer","status":"publish","type":"post","link":"https:\/\/lanimcleod.com\/?p=70","title":{"rendered":"Media Explorer"},"content":{"rendered":"

Skill Summary<\/h2>\n\n\n\n\n\n
Language<\/strong><\/td>\nMethod<\/strong><\/td>\n<\/tr>\n
D3.js v3<\/td>\nInteractive Data Exploration<\/td>\n<\/tr>\n
SQL\/BIGQuery<\/td>\nData Munging<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\"\"This is an interactive visualization I worked on with Dhia Barnes and Pi Lanningham that enables the user to view 2015 average news article tone, and number of news articles identified for each person who died while in police custody in 2015, as reported by The Counted<\/a> project from The Guardian.<\/p>

Selecting each data point brings back the individual\u2019s demographic information and list of source articles. Individuals may be grouped by demographic information and ordered and characterized by their race, avg tone of articles and number of articles identified. The grouping and characterizations allow the user to locate for further review apparent patterns in media coverage, defined as tone and volume of articles, among individuals in the dataset.<\/p>

We used Google Big Query to get the data and then visualized the lookup tool in D3.<\/p>

Demo located [HERE<\/a>]<\/p>

Video located [HERE<\/a>]
\n<\/section>\n","protected":false},"excerpt":{"rendered":"

Skill Summary Language Method D3.js v3 Interactive Data Exploration SQL\/BIGQuery Data Munging This is an interactive visualization I worked on with Dhia Barnes and Pi Lanningham that enables the user to view 2015 average news article tone, and number of news articles identified for each person who died while in police custody in 2015, as […]<\/p>\n","protected":false},"author":2,"featured_media":149,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[2],"tags":[],"class_list":["post-70","post","type-post","status-publish","format-standard","has-post-thumbnail","category-visualization","entry"],"_links":{"self":[{"href":"https:\/\/lanimcleod.com\/index.php?rest_route=\/wp\/v2\/posts\/70","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lanimcleod.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lanimcleod.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lanimcleod.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lanimcleod.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=70"}],"version-history":[{"count":8,"href":"https:\/\/lanimcleod.com\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":469,"href":"https:\/\/lanimcleod.com\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions\/469"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lanimcleod.com\/index.php?rest_route=\/wp\/v2\/media\/149"}],"wp:attachment":[{"href":"https:\/\/lanimcleod.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lanimcleod.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lanimcleod.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}