gravatar

mshields417

Michael Shields

Recently Published

Boston SES Change 2014-2018
This map details the changes in socioeconomic status scores for census tracts across Boston from 2014 to 2018. The socioeconomic score is a composite score of extracted loadings from a factor analysis of median household income, occupational prestige, median property value, and educational attainment.
Philadelphia SES Change 2014-2018
This map details the changes in socioeconomic status scores for census tracts across Philadelphia from 2014 to 2018. The socioeconomic score is a composite score of extracted loadings from a factor analysis of median household income, occupational prestige, median property value, and educational attainment.
Income Distribution of Philadelphia Millennial Households in 2018 by Race
This graph uses five-year estimates of the 2018 American Community Survey to determine the distribution of races across income levels for Millennial households in Philadelphia.
Income Distribution of Philadelphia Millennial Households in 2018 by Ethnicity
This graph uses five-year estimates of the 2018 American Community Survey to determine the distribution of ethnicities across income levels for Millennial households in Philadelphia.
SEPTA's 2020 Service Reductions
This map details the proposed service reductions to SEPTA's transit if critical funding is not achieved by 2030
Greater Philadelphia's Public Transit Use
The map uses 5-year estimates from the American Community Survey top detail public transportation usage in the Greater Philadelphia metropolitan region at the census tract level.
Dissertation Project 1: Regressions of Slopes (Boston)
Visualization of the extracted random effects of the independent SES variable and dependent variables of neighborhood change.
Philadelphia's Digital Divide 2018
Uses five-year estimates of the 2014-2018 ACS to show a spatial relationship of the digital divide in Philadelphia.
Philly's K through 12 Students in Poverty
The map uses five-year estimates from the 2014-2018 ACS to show the relationship between student poverty, race, and ethnicity.
Philadelphia's School-Aged Population in 2018
The map uses the five-year 2018 American Community Survey estimates to show where Philadelphia's 5-to-19-year-olds are highly concentrated. Tracts with group quartering exceeding a third of the total population were excluded.
Income Distribution by Ethnicity in Philadelphia in 2018
This graph uses five-year estimates of the 2014-2018 American Community Survey to show the distribution of household income across ethnic groups in Philadelphia in 2018.
Income Distribution of Philadelphia Households in 2018 by Race
The bar graph uses five-year estimates from the 2014-2018 American Community Survey to show the distribution of household wealth across racial groups. NOTE: All racial groups include both persons of Latinx/Hispanic decent and persons of non-Latinx/Hispanic decent.
Greater Philadelphia Black-Owned Businesses
Map details Philadelphia's Black-owned enterprises by county in 2017.
PPP Loan Coverage in Philadelphia
The PPP coverage rate in Philadelphia with the racial or ethnic majority of the census tract.
The Inequality of COVID-19
These maps compare racial, ethnic, insurance, COVID vulnerability, COVID cases, and COVID deaths in Philadelphia.
Health Disparities in Philadelphia
These maps detail various correlating measures of economic and health indicators that show health disparities in Philadelphia.
Educational and Employment Metrics in Philadelphia in 2018
This map shows various educational and employment metrics from five-year estimates of the U.S. Census Bureau's 2018 American Community Survey.
Philadelphia School Performance and Neighborhood Metrics
The map details the performance of Philadelphia's district and charter schools in the 2016-2017 school year with neighborhood metrics of race and ethnicity, income, and employment.
Total Arrests and Racial/Ethnic Majority Neighborhoods in Philadelphia
This map uses data from the Philadelphia District Attorney's Office and the American Community Survey to show the relationship between crime, race, and place.
Racial/Ethnic Majority and Poverty Rate of Philadelphia Tracts (2018 Five-Year Estimates)
Using 2014-2018 American Community Survey estimates for Philadelphia, the map shows the racial and ethnic majority (residents who identify account for 50 percent of greater of the population) and the tracts poverty rate.
Future Years of Incarceration in Philadelphia from 2014 to 2019 by Census Tract
Data from the Philadelphia District Attorney's Office showing future years of incarceration in Philadelphia from 2014 to 2019 by census tract.
Total Arrests in Philadelphia from 2014 to 2019 by Census Tract
Data from the Philadelphia District Attorney's Office showing all arrests by census tract from 2014 to 2019.
Racial Dot Density Map for Philadelphia in 2018
This is a racial dot density map for Philadelphia in 2018. One dot equals 20 people.
Supplier Business Landscape of Philadelphia (PAGE data)
Data for this map details the number of supplier businesses that are currently working (or have worked) with at least one PAGE-affiliated anchor institution.
Health Disparities Experienced by Philadelphia's Latinx Community (A Comparison)
This map details various correlating measures of health and economics indicators that demonstrate the disproportionate health effects felt by Philadelphia's Latinx/Hispanic population.
Health Disparities Experienced by Philadelphia's Black Community (A Comparison)
This map details various correlating measures of health and economics that demonstrate the disproportionate health effects felt by Philadelphia's African American population.
Health Disparities Experienced by Philadelphia's Black Community
This map details various correlating measures of health and economics that demonstrate the disproportionate health effects felt by Philadelphia's African American population.
Public Transit Commuters by Metro Area (2018)
This table uses five-year estimates from the 2018 American Community Survey to rank the percent of the working population (16+) that primarily commutes via public transit.
Comparing the Empirical Approach
Comparing random slopes extractions from overlapping 5-year ACS estimates to determine the viability of using the mixed effects (or hierarchical linear) model to account for “rolling” estimates from non-independent samples.
Indexed Growth of Philadelphia Employment by Industry (2008-2019)
This table illustrates Philadelphia's job growth by major industry from 2008 to 2019 (indexed to 2008).
Dissertation Project 1: SES Scores and Tract-Level Change Boston
Visualization of socioeconomic status metric using factor analysis and measure of five-year change using a mixed effects model.
Dissertation Project 1: Philly SES Scores and Tract-Level Change
Visualization of socioeconomic status metric using factor analysis and measure of five-year change using a mixed effects model.
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.
Indexed Change to Employment and Wages for Philly and US (2008-2018)
This interactive line graph shows indexed change of annual employment and wages in the City of Philadelphia and the U.S. from 2008 to 2018 (in 2018 real dollars) using 2008 as the reference year. The data were obtained from the Bureau of Labor Statistics' Quarterly Census of Employment and Wages (using only "private" ownership estimates).
Year-Over-Year Change in Employment and Wages for Philly and US (2009-2018)
This interactive line graph shows year-over-year change to annual employment and wage estimates for the City of Philadelphia and the U.S. from 2009 to 2018 in constant dollars. The data were obtained from the Bureau of Labor Statistics' Quarterly Census of Employment and Wages (using only "private" ownership estimates).
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.
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.