{"id":9,"date":"2025-03-30T18:25:38","date_gmt":"2025-03-30T18:25:38","guid":{"rendered":"https:\/\/patrickcdoyle.com\/?page_id=9"},"modified":"2025-12-21T20:15:29","modified_gmt":"2025-12-21T20:15:29","slug":"portfolio","status":"publish","type":"page","link":"https:\/\/patrickcdoyle.com\/","title":{"rendered":"Selected Work"},"content":{"rendered":"\n<div style=\"height:49px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--1\" style=\"font-style:normal;font-weight:700\">A calculator to estimate your new, higher Pittsburgh property taxes<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"910\" height=\"782\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-21-at-3.15.08-PM.png\" alt=\"\" class=\"wp-image-87\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-21-at-3.15.08-PM.png 910w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-21-at-3.15.08-PM-300x258.png 300w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-21-at-3.15.08-PM-768x660.png 768w\" sizes=\"auto, (max-width: 910px) 100vw, 910px\" \/><\/figure>\n\n\n\n<p>Pittsburgh City Council and Pittsburgh Public schools raised property taxes for 2026, so I built a calculator to show how taxes are rising.<\/p>\n\n\n\n<p>View the calculator <a href=\"https:\/\/patrickcdoyle.com\/index.php\/2025\/12\/14\/pgh-property-tax-calculator\/\">here<\/a>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--2\" style=\"font-style:normal;font-weight:700\">Analyzing the impact of NIH funding cuts to the Pittsburgh area<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"649\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/SoeNg-pittsburgh-sees-big-drop-in-nih-funding-during-trump-s-first-four-weeks-in-office-1-1024x649.png\" alt=\"\" class=\"wp-image-12\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/SoeNg-pittsburgh-sees-big-drop-in-nih-funding-during-trump-s-first-four-weeks-in-office-1-1024x649.png 1024w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/SoeNg-pittsburgh-sees-big-drop-in-nih-funding-during-trump-s-first-four-weeks-in-office-1-300x190.png 300w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/SoeNg-pittsburgh-sees-big-drop-in-nih-funding-during-trump-s-first-four-weeks-in-office-1-768x487.png 768w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/SoeNg-pittsburgh-sees-big-drop-in-nih-funding-during-trump-s-first-four-weeks-in-office-1.png 1240w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>I conducted a data analysis and built charts to accompany a story by a WESA reporter about the Trump administration&#8217;s cuts to university scientific funding from the National Institutes of Health.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.wesa.fm\/health-science-tech\/2025-02-21\/nih-grants-indirects-trump-pittsburgh\">wesa.fm<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--3\" style=\"font-style:normal;font-weight:700\">Which Pennsylvania counties buy the most alcohol? (And other data nuggets from the PLCB)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"834\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/8SxaM-pennsylvania-counties-with-the-highest-per-adult-alcohol-sales-1024x834.png\" alt=\"\" class=\"wp-image-13\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/8SxaM-pennsylvania-counties-with-the-highest-per-adult-alcohol-sales-1024x834.png 1024w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/8SxaM-pennsylvania-counties-with-the-highest-per-adult-alcohol-sales-300x244.png 300w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/8SxaM-pennsylvania-counties-with-the-highest-per-adult-alcohol-sales-768x626.png 768w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/8SxaM-pennsylvania-counties-with-the-highest-per-adult-alcohol-sales.png 1240w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>While many Pennsylvanians love to complain about the state\u2019s dominion over liquor and wine sales, that state control&nbsp;<em>does<\/em>&nbsp;have one handy feature \u2014 a rich data set about alcohol sales. I did a deep-dive analysis of the data, sharing the results via maps, charts and a story.<br><br><a href=\"https:\/\/www.wesa.fm\/economy-business\/2025-03-03\/pa-plcb-alcohol-sales-data\">wesa.fm<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--4\" style=\"font-style:normal;font-weight:700\">WESA Voter Guide<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"511\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/voterguide.png\" alt=\"\" class=\"wp-image-14\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/voterguide.png 512w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/voterguide-300x300.png 300w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/voterguide-150x150.png 150w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>I led the creation of the WESA Voter Guide, a primer on who is running for office, for the 2022 primary election. One of the station&#8217;s most popular features, we&#8217;ve grown it annually; in the fall of 2024, we featured 34 races, from U.S. Senator and Congress to Pennsylvania State House.<\/p>\n\n\n\n<p><a href=\"https:\/\/wesa.fm\/voterguide\">wesa.fm<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--5\"><strong>Fish fry fun<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"575\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/2025-Pittsburgh-Fish-Fry-Map.png\" alt=\"\" class=\"wp-image-16\" style=\"width:645px;height:auto\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/2025-Pittsburgh-Fish-Fry-Map.png 600w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/2025-Pittsburgh-Fish-Fry-Map-300x288.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p>To accompany a story by a WESA reporter on the start of fish fry season, I built a map of all the places to indulge.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.wesa.fm\/identity-community\/2025-03-07\/community-kitchen-pittsburgh-fish-fry\">wesa.fm<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--6\"><strong>Allegheny County COVID-19 Dashboard<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"400\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/AC-Vaccinations-Jan-2022.png\" alt=\"\" class=\"wp-image-17\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/AC-Vaccinations-Jan-2022.png 600w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/AC-Vaccinations-Jan-2022-300x200.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p>In the midst of the pandemic, I built a dashboard for Allegheny County residents, charting daily case counts, hospitalizations, vaccination rates and death rates. <\/p>\n\n\n\n<p><a href=\"https:\/\/www.wesa.fm\/health-science-tech\/wesa-covid-19-dashboard\">wesa.fm<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--7\"><strong>The Accidental Senator<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"593\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/senator.jpg\" alt=\"\" class=\"wp-image-18\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/senator.jpg 768w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/senator-300x232.jpg 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<p>A profile of U.S. Senator Michael Bennet of Colorado.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.5280.com\/the-accidental-senator\/\">5280 Magazine<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--8\">Hit the Road<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"540\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/pathfinder.jpg\" alt=\"\" class=\"wp-image-19\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/pathfinder.jpg 960w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/pathfinder-300x169.jpg 300w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/pathfinder-768x432.jpg 768w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/figure>\n\n\n\n<p>An epic, 10,000 mile road trip across America to find the best place to live in the country for <em>Outside<\/em> magazine.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.outsideonline.com\/adventure-travel\/destinations\/north-america\/hit-road-find-your-best-town-ever\/\">Outside<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--9\"><strong>Planning Pittsburgh&#8217;s future<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"768\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/bridge-1024x768.jpg\" alt=\"\" class=\"wp-image-20\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/bridge-1024x768.jpg 1024w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/bridge-300x225.jpg 300w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/bridge-768x576.jpg 768w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/bridge.jpg 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>How will the city&#8217;s new planning director stoke the next generation of developments?<\/p>\n\n\n\n<p><a href=\"https:\/\/www.pittsburghmagazine.com\/what-inspires-ray-gastils-careful-plan-for-pittsburghs-future\/\">Pittsburgh Magazine<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--10\"><strong>An Innovation Case Study: Pittsburgh<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"790\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/steps-1024x790.jpg\" alt=\"\" class=\"wp-image-21\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/steps-1024x790.jpg 1024w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/steps-300x232.jpg 300w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/steps-768x593.jpg 768w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/steps.jpg 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Can a midsize Rust Belt City compete with Silicon Valley?<\/p>\n\n\n\n<p><a href=\"https:\/\/www.technologyreview.com\/2015\/11\/23\/164978\/an-innovation-case-study-pittsburgh\/\">MIT Technology Review<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--11\"><strong>Resurrection<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"504\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/catholic.jpg\" alt=\"\" class=\"wp-image-22\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/catholic.jpg 768w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/catholic-300x197.jpg 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/figure>\n\n\n\n<p>A decade after the clergy sex abuse scandal, the Archdiocese of Boston tries to rebuild.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.bostonmagazine.com\/2012\/10\/30\/archdiocese-catholic-church-rebuild-after-scandal\/\">Boston Magazine<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"is-style-text-subtitle is-style-text-subtitle--12\"><strong>Dry Times<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1158\" height=\"751\" src=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/Screenshot-2025-03-30-at-2.23.23\u202fPM.png\" alt=\"\" class=\"wp-image-25\" srcset=\"https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/Screenshot-2025-03-30-at-2.23.23\u202fPM.png 1158w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/Screenshot-2025-03-30-at-2.23.23\u202fPM-300x195.png 300w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/Screenshot-2025-03-30-at-2.23.23\u202fPM-1024x664.png 1024w, https:\/\/patrickcdoyle.com\/wp-content\/uploads\/2025\/03\/Screenshot-2025-03-30-at-2.23.23\u202fPM-768x498.png 768w\" sizes=\"auto, (max-width: 1158px) 100vw, 1158px\" \/><\/figure>\n\n\n\n<p>Colorado has grown rapidly over recent decades, as more and more people crowd into our borders. Our water, unfortunately is a limited resource. And we\u2019re almost out. Co-written with Natasha Gardner. Winner of the 2011 Knight-Risser Prize for Western Environmental Journalism.<\/p>\n\n\n\n<p><a href=\"https:\/\/drive.google.com\/file\/d\/0B8-46yTnYtLbZTA4N2ZiZmEtMzJmYS00YTQ5LTg5YmYtNDc5ZGExYjI1MGUz\/view?hl=en&amp;resourcekey=0-utC891K5Wsp8nqe9ua4SHg\">5280 Magazine<\/a><\/p>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A calculator to estimate your new, higher Pittsburgh property taxes Pittsburgh City Council and Pittsburgh Public schools raised property taxes for 2026, so I built a calculator to show how taxes are rising. View the calculator here. Analyzing the impact of NIH funding cuts to the Pittsburgh area I conducted a data analysis and built [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-9","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/patrickcdoyle.com\/index.php\/wp-json\/wp\/v2\/pages\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/patrickcdoyle.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/patrickcdoyle.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/patrickcdoyle.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/patrickcdoyle.com\/index.php\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":10,"href":"https:\/\/patrickcdoyle.com\/index.php\/wp-json\/wp\/v2\/pages\/9\/revisions"}],"predecessor-version":[{"id":88,"href":"https:\/\/patrickcdoyle.com\/index.php\/wp-json\/wp\/v2\/pages\/9\/revisions\/88"}],"wp:attachment":[{"href":"https:\/\/patrickcdoyle.com\/index.php\/wp-json\/wp\/v2\/media?parent=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}