{"id":7598,"date":"2021-11-01T11:00:00","date_gmt":"2021-11-01T15:00:00","guid":{"rendered":"https:\/\/masspirates.org\/blog\/?p=7598"},"modified":"2021-10-30T16:01:25","modified_gmt":"2021-10-30T20:01:25","slug":"plumb-the-depths-of-the-mass-campaign-finance-database-2","status":"publish","type":"post","link":"https:\/\/masspirates.org\/blog\/2021\/11\/01\/plumb-the-depths-of-the-mass-campaign-finance-database-2\/","title":{"rendered":"Plumb the depths of the Mass. campaign finance database!"},"content":{"rendered":"\n<p>Nick Roy showed off&nbsp;his splunking into the&nbsp;<a href=\"https:\/\/www.ocpf.us\/\" target=\"_blank\" rel=\"noreferrer noopener\">Massachusetts Office of Campaign and Political Finance (OCPF)<\/a>&nbsp;database at our <a href=\"https:\/\/masspirates.org\/wiki\/October_16th,_2021_Democracy\/Tech_Meeting\">last Democracy and Dog Food meeting<\/a>.&nbsp; He moved the data over to&nbsp;Google Data Studio and is working on a better system of keeping the data up to date. This setup should be easier&nbsp;to maintain and share, and it handles a lot of data pretty easily. Here are&nbsp;the two dashboards he setup:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>OCPF Data &#8211; Recipients:&nbsp;<a href=\"https:\/\/datastudio.google.com\/reporting\/5f3e9dad-83ac-42a8-9e10-c1d6d8f5e117\" rel=\"noreferrer noopener\" target=\"_blank\">https:\/\/datastudio.google.com\/reporting\/5f3e9dad-83ac-42a8-9e10-c1d6d8f5e117<\/a><\/li><li>OCPF Data &#8211; Contributor:&nbsp;<a href=\"https:\/\/datastudio.google.com\/reporting\/9c3ce626-a743-44e8-b47a-4f85ac388d8b\" rel=\"noreferrer noopener\" target=\"_blank\">https:\/\/datastudio.google.com\/reporting\/9c3ce626-a743-44e8-b47a-4f85ac388d8b<\/a><\/li><\/ul>\n\n\n\n<p>If you want to help him find needles in the OCPF haystack or have other suggestions, email him at&nbsp;Nick&nbsp;Roy&nbsp;&lt;<a href=\"mailto:me@nickroy.org\" target=\"_blank\" rel=\"noreferrer noopener\">me@nickroy.org<\/a>&gt;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nick Roy showed off&nbsp;his splunking into the&nbsp;Massachusetts Office of Campaign and Political Finance (OCPF)&nbsp;database at our last Democracy and Dog Food meeting.&nbsp; He&hellip;<\/p>\n","protected":false},"author":2,"featured_media":2194,"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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[23,43,32,13],"tags":[],"class_list":["post-7598","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-elections","category-help-needed","category-slider","category-transparency"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/masspirates.org\/blog\/wp-content\/uploads\/2013\/11\/massvoterregform.png","jetpack_shortlink":"https:\/\/wp.me\/p1W8mg-1Yy","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/posts\/7598","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/comments?post=7598"}],"version-history":[{"count":1,"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/posts\/7598\/revisions"}],"predecessor-version":[{"id":7599,"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/posts\/7598\/revisions\/7599"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/media\/2194"}],"wp:attachment":[{"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/media?parent=7598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/categories?post=7598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masspirates.org\/blog\/wp-json\/wp\/v2\/tags?post=7598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}