gravatar

mshields417

Michael Shields

Recently Published

Year-Over-Year Change in Philadelphia Employment and Wages (2009-2018)
This interactive line graph shows year-over-year change of Philadelphia's annual employment and wages from 2009 to 2018 in constant dollars. The data were obtained from the Bureau of Labor Statistics' Quarterly Census of Employment and Wages.
Total Year-Over-Year Change in Revenue Funds (2009-2019)
This interactive line graph shows year-over-year changes to total tax revenue funds of Philadelphia and a list of National League of Cities municipalities from 2009 to 2019 in constant dollars. The data were obtained from monthly revenue collection records from the City of Philadelphia's Department of Revenue and the NLC's Fiscal Conditions 2019 report.
Year-Over-Year Change in Philadelphia Tax Revenue (2009-2019)
This interactive line graph shows year-over-year change of Philadelphia tax revenue funds from 2009 to 2019 in constant dollars. The data were obtained from monthly revenue collection records from the City of Philadelphia's Department of Revenue and detail fiscal-year-to-date revenue funds for June of the given calendar year.
Indexed Change of Philly Tax Revenue (2008-2019)
This interactive line graph shows the indexed growth of the City of Philadelphia's tax revenue funds from 2009 to 2019. The data were obtained from monthly revenue collection records from the City of Philadelphia's Department of Revenue and use 2008 as the comparative year (except for the "Philadelphia Beverage Tax" which uses its initial collection year of 2017).
Growth in Biotechnology among U.S. Metros
The following interactive table details various growth metrics of success in the biotech field. Data were obtained from the National Institutes of Health, PwC Moneytree Report, U.S. Patent and Trademark Office, and the Bureau of Labor Statistics' Quarterly Census of Employment and Wages.
Early Stage Venture Capital Investment in Biotechnology
This interactive graph details the amount of Seed/Angel, Series A, and Series B venture capital funding local biotechnology firms received between 2002 and 2018. Data were obtained from PwC Moneytree Report.
Life Expectancy and Median Household Income by Neighborhood in Greater Philadelphia
The following choropleth details the life expectancy and median household income of census tracts within Greater Philadelphia. Life expectancy data comes from the National Center of Health Statistics' U.S. Small-Area Life Expectancy Estimates Project's 2010-2015 estimates.
Southeastern Pennsylvania Population's High Frequency of Emergency Room Visits
This table uses data from Public Health Management Corporation's Household Health Survey's question asking how many times a respondent visited an emergency room for care in the past 12 month. Data are comprised of a composite measure from 2015 and 2018 survey waves.
Demolition Permits - City of Philadelphia 2008-2018 - Tioga and Harrowgate
This density heatmap displays all major demolition building and zoning permits in the City of Philadelphia from 2008 to 2018. The permits are dummy-coded per individual parcel per year and are used as a proxy for development activity.
Basemap of Nicetown-Tioga and Harrowgate Neighborhoods in Philadelphia
Visualization of the neighborhoods of Nicetown-Tioga and Harrowgate within Philadelphia. This map is for reference.
Dissertation Update - May 16, 2019: Philadelphia SES Maps and SES-Rise Measure
Visualization of socioeconomic status metric using factor analysis and measure of five-year change using a mixed effects model.
Dissertation Update - May 16, 2019: Boston SES Maps
Visualization of socioeconomic status metric using factor analysis and measure of five-year change using a mixed effects model.