Load Flint and Genesee on a Map

Population Decline Over Years

Create a Dataframe with Relevant Census Variables for Genesee County

## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |                                                                      |   1%
  |                                                                            
  |=                                                                     |   1%
  |                                                                            
  |=                                                                     |   2%
  |                                                                            
  |==                                                                    |   2%
  |                                                                            
  |==                                                                    |   3%
  |                                                                            
  |===                                                                   |   4%
  |                                                                            
  |===                                                                   |   5%
  |                                                                            
  |====                                                                  |   5%
  |                                                                            
  |=============                                                         |  18%
  |                                                                            
  |=============                                                         |  19%
  |                                                                            
  |==============                                                        |  19%
  |                                                                            
  |==============                                                        |  20%
  |                                                                            
  |===============                                                       |  21%
  |                                                                            
  |===============                                                       |  22%
  |                                                                            
  |================                                                      |  23%
  |                                                                            
  |================                                                      |  24%
  |                                                                            
  |=================                                                     |  24%
  |                                                                            
  |=================                                                     |  25%
  |                                                                            
  |==================                                                    |  25%
  |                                                                            
  |==================                                                    |  26%
  |                                                                            
  |===================                                                   |  26%
  |                                                                            
  |===================                                                   |  27%
  |                                                                            
  |===================                                                   |  28%
  |                                                                            
  |====================                                                  |  28%
  |                                                                            
  |====================                                                  |  29%
  |                                                                            
  |=====================                                                 |  30%
  |                                                                            
  |=====================                                                 |  31%
  |                                                                            
  |======================                                                |  31%
  |                                                                            
  |======================                                                |  32%
  |                                                                            
  |=======================                                               |  32%
  |                                                                            
  |=======================                                               |  33%
  |                                                                            
  |=======================                                               |  34%
  |                                                                            
  |========================                                              |  34%
  |                                                                            
  |========================                                              |  35%
  |                                                                            
  |=========================                                             |  35%
  |                                                                            
  |=========================                                             |  36%
  |                                                                            
  |==========================                                            |  36%
  |                                                                            
  |==========================                                            |  37%
  |                                                                            
  |====================================                                  |  51%
  |                                                                            
  |====================================                                  |  52%
  |                                                                            
  |=====================================                                 |  53%
  |                                                                            
  |======================================                                |  54%
  |                                                                            
  |===============================================                       |  67%
  |                                                                            
  |===============================================                       |  68%
  |                                                                            
  |================================================                      |  68%
  |                                                                            
  |================================================                      |  69%
  |                                                                            
  |=================================================                     |  69%
  |                                                                            
  |=================================================                     |  70%
  |                                                                            
  |==================================================                    |  71%
  |                                                                            
  |==================================================                    |  72%
  |                                                                            
  |===================================================                   |  72%
  |                                                                            
  |===================================================                   |  73%
  |                                                                            
  |====================================================                  |  74%
  |                                                                            
  |====================================================                  |  75%
  |                                                                            
  |=====================================================                 |  75%
  |                                                                            
  |=====================================================                 |  76%
  |                                                                            
  |======================================================                |  77%
  |                                                                            
  |=======================================================               |  78%
  |                                                                            
  |=======================================================               |  79%
  |                                                                            
  |========================================================              |  80%
  |                                                                            
  |============================================================          |  85%
  |                                                                            
  |==============================================================        |  88%
  |                                                                            
  |================================================================      |  92%
  |                                                                            
  |===================================================================   |  96%
  |                                                                            
  |======================================================================| 100%

Map the Black Population in Genesee for 2017 - 2021

Map the White Population in Genesee from 2017 - 2021

Map Poverty Rates across Genesee 2017 - 2021

Map Median Income Across Genessee 2017- 2021

Correlation Table for Genesee Outcomes

term percentWhite percentBlack povertyrate median income medianPropVal
percentWhite NA -0.9898237 -0.7011985 0.6545362 0.1631993
percentBlack -0.9898237 NA 0.6823537 -0.6202516 -0.1715044
povertyrate -0.7011985 0.6823537 NA -0.7183280 -0.0688734
median income 0.6545362 -0.6202516 -0.7183280 NA 0.1347727
medianPropVal 0.1631993 -0.1715044 -0.0688734 0.1347727 NA

Perform Linear Regressions on Tables

## 
## Call:
## lm(formula = povertyrate ~ percentBlack, data = genesee_outcomes)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -4.4504 -1.4856 -0.6965  0.9970  9.8133 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  1.865976   0.257558   7.245 3.41e-11 ***
## percentBlack 0.067659   0.006357  10.643  < 2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 2.316 on 130 degrees of freedom
## Multiple R-squared:  0.4656, Adjusted R-squared:  0.4615 
## F-statistic: 113.3 on 1 and 130 DF,  p-value: < 2.2e-16
## 
## Call:
## lm(formula = povertyrate ~ percentWhite, data = genesee_outcomes)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -4.1895 -1.4334 -0.5287  0.9721 10.0013 
## 
## Coefficients:
##               Estimate Std. Error t value Pr(>|t|)    
## (Intercept)   8.253396   0.461401   17.89   <2e-16 ***
## percentWhite -0.068749   0.006131  -11.21   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 2.259 on 130 degrees of freedom
## Multiple R-squared:  0.4917, Adjusted R-squared:  0.4878 
## F-statistic: 125.7 on 1 and 130 DF,  p-value: < 2.2e-16
## 
## Call:
## lm(formula = `median income` ~ percentBlack, data = genesee_outcomes)
## 
## Residuals:
##      Min       1Q   Median       3Q      Max 
## -17399.9  -5754.6   -578.9   5461.6  23513.7 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  34463.74     865.49  39.820  < 2e-16 ***
## percentBlack  -192.60      21.36  -9.016 2.17e-15 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 7782 on 130 degrees of freedom
## Multiple R-squared:  0.3847, Adjusted R-squared:   0.38 
## F-statistic: 81.28 on 1 and 130 DF,  p-value: 2.17e-15
## 
## Call:
## lm(formula = `median income` ~ percentWhite, data = genesee_outcomes)
## 
## Residuals:
##      Min       1Q   Median       3Q      Max 
## -15979.8  -5032.1   -351.7   5000.9  23526.8 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  15922.21    1532.25  10.391   <2e-16 ***
## percentWhite   200.97      20.36   9.871   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 7500 on 130 degrees of freedom
## Multiple R-squared:  0.4284, Adjusted R-squared:  0.424 
## F-statistic: 97.44 on 1 and 130 DF,  p-value: < 2.2e-16
## 
## Call:
## lm(formula = medianPropVal ~ percentBlack, data = genesee_outcomes)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -650206706    -363052    2440682   15525782   41828580 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)  
## (Intercept)   1126036    8993377   0.125   0.9006  
## percentBlack  -440610     221985  -1.985   0.0493 *
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 80860000 on 130 degrees of freedom
## Multiple R-squared:  0.02941,    Adjusted R-squared:  0.02195 
## F-statistic:  3.94 on 1 and 130 DF,  p-value: 0.04927
X Flint Genesee.County Michigan United.States
Population Estimates, July 1, 2022, (V2022) 79,854 401,983 10,034,113 333,287,557
Population estimates base, April 1, 2020, (V2022) 81,268 406,217 10,077,325 331,449,520
Population, percent change - April 1, 2020 (estimates base) to July 1, 2022, (V2022) -1.70% -1.00% -0.40% 0.60%
Population, Census, April 1, 2020 81252 406211 10077331 331449281
Population, Census, April 1, 2010 102434 425790 9883640 308745538
Age and Sex
Persons under 5 years, percent 7.10% 5.70% 5.50% 5.70%
Persons under 18 years, percent 24.60% 22.30% 21.40% 22.20%
Persons 65 years and over, percent 13.20% 18.20% 18.10% 16.80%
Female persons, percent 50.50% 51.50% 50.40% 50.50%
Race and Hispanic Origin
White alone, percent 34.70% 75.00% 79.00% 75.80%
Black or African American alone, percent(a) 56.70% 20.30% 14.10% 13.60%
American Indian and Alaska Native alone, percent(a) 0.50% 0.60% 0.70% 1.30%
Asian alone, percent(a) 0.50% 1.10% 3.40% 6.10%
Native Hawaiian and Other Pacific Islander alone, percent(a) 0.00% Z Z 0.30%
Two or More Races, percent 6.80% 3.10% 2.70% 2.90%
Hispanic or Latino, percent(b) 4.50% 3.90% 5.60% 18.90%
White alone, not Hispanic or Latino, percent 33.20% 71.80% 74.20% 59.30%
Population Characteristics
Veterans, 2017-2021 3685 22795 516924 17431290
Foreign born persons, percent, 2017-2021 0.026 0.028 0.069 0.136
Housing
Housing units, July 1, 2022, (V2022) X 183981 4611660 143786655
Owner-occupied housing unit rate, 2017-2021 0.551 0.705 0.722 0.646
Median value of owner-occupied housing units, 2017-2021 35000 133700 172100 244900
Median selected monthly owner costs -with a mortgage, 2017-2021 940 1272 1374 1697
Median selected monthly owner costs -without a mortgage, 2017-2021 420 504 520 538
Median gross rent, 2017-2021 777 829 946 1163
Building permits, 2022 X 410 219831 1665088
Families & Living Arrangements
Households, 2017-2021 33767 164905 3976729 124010992
Persons per household, 2017-2021 2.39 2.43 2.48 2.6
Living in same house 1 year ago, percent of persons age 1 year+, 2017-2021 0.85 0.879 0.873 0.866
Language other than English spoken at home, percent of persons age 5 years+, 2017-2021 0.04 0.039 0.099 0.217
Computer and Internet Use
Households with a computer, percent, 2017-2021 0.838 0.908 0.924 0.931
Households with a broadband Internet subscription, percent, 2017-2021 0.71 0.837 0.864 0.87
Education
High school graduate or higher, percent of persons age 25 years+, 2017-2021 0.848 0.912 0.916 0.889
Bachelor’s degree or higher, percent of persons age 25 years+, 2017-2021 0.121 0.222 0.306 0.337
Health
With a disability, under age 65 years, percent, 2017-2021 0.202 0.137 0.101 0.087
Persons without health insurance, under age 65 years, percent 7.70% 6.20% 6.00% 9.80%
Economy
In civilian labor force, total, percent of population age 16 years+, 2017-2021 0.536 0.579 0.615 0.631
In civilian labor force, female, percent of population age 16 years+, 2017-2021 0.532 0.543 0.574 0.587
Total accommodation and food services sales, 2017 ($1,000)(c) 142056 707341 23056352 938237077
Total health care and social assistance receipts/revenue, 2017 ($1,000)(c) 1278819 3165657 74194505 2527903275
Total transportation and warehousing receipts/revenue, 2017 ($1,000)(c) 173734 457204 25019797 895225411
Total retail sales, 2017 ($1,000)(c) 3230906 8429666 143437054 4949601481
Total retail sales per capita, 2017(c) 33483 20678 14377 15224
Transportation
Mean travel time to work (minutes), workers age 16 years+, 2017-2021 21.9 26.6 24.5 26.8
Income & Poverty
Median household income (in 2021 dollars), 2017-2021 32358 54052 63202 69021
Per capita income in past 12 months (in 2021 dollars), 2017-2021 18719 30561 34768 37638
Persons in poverty, percent 35.50% 16.30% 13.10% 11.60%
Businesses
Total employer establishments, 2021 X 7646 224676 8148606
Total employment, 2021 X 112624 3768321 128346299
Total annual payroll, 2021 ($1,000) X 5502758 216772518 8278573947
Total employment, percent change, 2020-2021 X -0.054 -0.058 -0.043
Total nonemployer establishments, 2019 X 28457 741509 27104006
All employer firms, Reference year 2017 1205 5970 165460 5744643
Men-owned employer firms, Reference year 2017 772 3738 106137 3480438
Women-owned employer firms, Reference year 2017 139 1050 29706 1134549
Minority-owned employer firms, Reference year 2017 143 499 13091 1014958
Nonminority-owned employer firms, Reference year 2017 810 4799 141153 4371152
Veteran-owned employer firms, Reference year 2017 43 275 8714 351237
Nonveteran-owned employer firms, Reference year 2017 904 4961 142782 4968606
Geography
Population per square mile, 2020 2429.8 637.8 178 93.8
Population per square mile, 2010 3065.4 668.5 174.8 87.4
Land area in square miles, 2020 33.44 636.94 56608.22 3533038.28
Land area in square miles, 2010 33.42 636.98 56538.9 3531905.43
FIPS Code 2629000 26049 26 1