Lab 1: Census Data Quality for Policy Decisions

Evaluating Data Reliability for Algorithmic Decision-Making

Author

Shubhanga Satyal

Published

March 21, 2026

Assignment Overview

Scenario

You are a data analyst for the California Department of Human Services. The department is considering implementing an algorithmic system to identify communities that should receive priority for social service funding and outreach programs. Your supervisor has asked you to evaluate the quality and reliability of available census data to inform this decision.

Drawing on our Week 2 discussion of algorithmic bias, you need to assess not just what the data shows, but how reliable it is and what communities might be affected by data quality issues.

Learning Objectives

Apply dplyr functions to real census data for policy analysis
Evaluate data quality using margins of error
Connect technical analysis to algorithmic decision-making
Identify potential equity implications of data reliability issues
Create professional documentation for policy stakeholders

Submission Instructions

Submit by posting your updated portfolio link on Canvas. Your assignment should be accessible at your-portfolio-url/labs/lab_1/

Make sure to update your _quarto.yml navigation to include this assignment under an “Labs” menu.

Part 1: Portfolio Integration

Create this assignment in your portfolio repository under an labs/lab_1/ folder structure. Update your navigation menu to include:

- text: Assignments
  menu:
    - href: labs/lab_1/your_file_name.qmd
      text: "Lab 1: Census Data Exploration"

If there is a special character like a colon, you need use double quote mark so that the quarto can identify this as text

Setup

# Load required packages (hint: you need tidycensus, tidyverse, and knitr)
library(tidycensus)
library(tidyverse)
library(knitr)

# Set your Census API key
census_api_key(Sys.getenv("82d6bed7434dbceef02889e5a0d354feff424c8b."))

# Choose your state for analysis - assign it to a variable called my_state
my_state <- "CA"

State Selection: I have chosen California for this analysis because: While I am not from America, California would be a state I would like to visit.

Part 2: County-Level Resource Assessment

2.1 Data Retrieval

Your Task: Use get_acs() to retrieve county-level data for your chosen state.

Requirements: - Geography: county level - Variables: median household income (B19013_001) and total population (B01003_001)
- Year: 2022 - Survey: acs5 - Output format: wide

Hint: Remember to give your variables descriptive names using the variables = c(name = "code") syntax.

# Write your get_acs() code here
ca_county_data <- get_acs(
  geography = "county",
  state = my_state,
  variables = c(
    median_hh_income = "B19013_001",
    total_pop = "B01003_001"
  ),
  year= 2022,
  survey = "acs5",
  output = "wide"
)

head(ca_county_data)%>%
  kable()

GEOID	NAME	median_hh_incomeE	median_hh_incomeM	total_popE	total_popM
06001	Alameda County, California	122488	1231	1663823	NA
06003	Alpine County, California	101125	17442	1515	206
06005	Amador County, California	74853	6048	40577	NA
06007	Butte County, California	66085	2261	213605	NA
06009	Calaveras County, California	77526	3875	45674	NA
06011	Colusa County, California	69619	5745	21811	NA

# Clean the county names to remove state name and "County" 
# Hint: use mutate() with str_remove()

clean_data <- ca_county_data %>%
  mutate(
    NAME = NAME %>%
      str_remove(", California") %>%
      str_remove(" County")
  )%>%
  select(`County` = "NAME",
         `Median Household Income` = "median_hh_incomeE",
         `Median HH Income Margin of Error` = "median_hh_incomeM",
        `Total Population` = "total_popE",
        )

# Display the first few rows
head(clean_data)%>%
  kable()

County	Median Household Income	Median HH Income Margin of Error	Total Population
Alameda	122488	1231	1663823
Alpine	101125	17442	1515
Amador	74853	6048	40577
Butte	66085	2261	213605
Calaveras	77526	3875	45674
Colusa	69619	5745	21811

2.2 Data Quality Assessment

Your Task: Calculate margin of error percentages and create reliability categories.

Requirements: - Calculate MOE percentage: (margin of error / estimate) * 100 - Create reliability categories: - High Confidence: MOE < 5% - Moderate Confidence: MOE 5-10%
- Low Confidence: MOE > 10% - Create a flag for unreliable estimates (MOE > 10%)

Hint: Use mutate() with case_when() for the categories.

# Calculate MOE percentage and reliability categories using mutate()
ca_county_reliability <- clean_data %>%
  mutate(
    moe_pct = (`Median HH Income Margin of Error`/`Median Household Income`)*100,
    category = case_when(
      moe_pct < 5 ~ "High Confidence",
      moe_pct >= 5 & moe_pct <= 10 ~ "Moderate Confidence",
      moe_pct > 10 ~ "Low Confidence"
      ),
    flag = case_when(category == "Low Confidence" ~ "!!!",
                   TRUE ~ "    "  )
)
  

tibble(ca_county_reliability)%>%
  kable()

County	Median Household Income	Median HH Income Margin of Error	Total Population	moe_pct	category	flag
Alameda	122488	1231	1663823	1.0049964	High Confidence
Alpine	101125	17442	1515	17.2479604	Low Confidence	!!!
Amador	74853	6048	40577	8.0798365	Moderate Confidence
Butte	66085	2261	213605	3.4213513	High Confidence
Calaveras	77526	3875	45674	4.9983231	High Confidence
Colusa	69619	5745	21811	8.2520576	Moderate Confidence
Contra Costa	120020	1496	1162648	1.2464589	High Confidence
Del Norte	61149	4376	27462	7.1562904	Moderate Confidence
El Dorado	99246	3330	191713	3.3552990	High Confidence
Fresno	67756	967	1008280	1.4271799	High Confidence
Glenn	64033	3963	28657	6.1889963	Moderate Confidence
Humboldt	57881	2131	136132	3.6816917	High Confidence
Imperial	53847	2214	179578	4.1116497	High Confidence
Inyo	63417	5453	18829	8.5986407	Moderate Confidence
Kern	63883	1325	906883	2.0741042	High Confidence
Kings	68540	2253	152515	3.2871316	High Confidence
Lake	56259	2439	68024	4.3353064	High Confidence
Lassen	59515	3551	31873	5.9665631	Moderate Confidence
Los Angeles	83411	439	9936690	0.5263095	High Confidence
Madera	73543	2844	157243	3.8671254	High Confidence
Marin	142019	4098	260485	2.8855294	High Confidence
Mariposa	60021	5293	17130	8.8185802	Moderate Confidence
Mendocino	61335	2198	91145	3.5835983	High Confidence
Merced	64772	2142	282290	3.3069845	High Confidence
Modoc	54962	5389	8651	9.8049562	Moderate Confidence
Mono	82038	15388	13219	18.7571613	Low Confidence	!!!
Monterey	91043	1900	437609	2.0869260	High Confidence
Napa	105809	2981	137384	2.8173407	High Confidence
Nevada	79395	3823	102322	4.8151647	High Confidence
Orange	109361	882	3175227	0.8065032	High Confidence
Placer	109375	1856	406608	1.6969143	High Confidence
Plumas	67885	7772	19650	11.4487737	Low Confidence	!!!
Riverside	84505	1061	2429487	1.2555470	High Confidence
Sacramento	84010	816	1579211	0.9713129	High Confidence
San Benito	104451	5461	64753	5.2282889	Moderate Confidence
San Bernardino	77423	806	2180563	1.0410343	High Confidence
San Diego	96974	993	3289701	1.0239858	High Confidence
San Francisco	136689	1954	851036	1.4295225	High Confidence
San Joaquin	82837	1448	779445	1.7480112	High Confidence
San Luis Obispo	90158	2311	281712	2.5632778	High Confidence
San Mateo	149907	2621	754250	1.7484174	High Confidence
Santa Barbara	92332	1889	445213	2.0458779	High Confidence
Santa Clara	153792	1545	1916831	1.0046036	High Confidence
Santa Cruz	104409	3173	268571	3.0390100	High Confidence
Shasta	68347	2480	181852	3.6285426	High Confidence
Sierra	61108	9237	2916	15.1158604	Low Confidence	!!!
Siskiyou	53898	2640	44049	4.8981409	High Confidence
Solano	97037	1724	450995	1.7766419	High Confidence
Sonoma	99266	1988	488436	2.0026998	High Confidence
Stanislaus	74872	1371	552063	1.8311251	High Confidence
Sutter	72654	3425	99101	4.7141245	High Confidence
Tehama	59029	4103	65484	6.9508208	Moderate Confidence
Trinity	47317	5890	15889	12.4479574	Low Confidence	!!!
Tulare	64474	1489	473446	2.3094581	High Confidence
Tuolumne	70432	4691	54993	6.6603249	Moderate Confidence
Ventura	102141	1528	842009	1.4959713	High Confidence
Yolo	85097	2333	217141	2.7415773	High Confidence
Yuba	66693	2796	81705	4.1923440	High Confidence

# Create a summary showing count of counties in each reliability category
# Hint: use count() and mutate() to add percentages

count_reliability <- ca_county_reliability %>%
  count(category) %>%
  mutate(
    percent = n/sum(n)*100
  )%>%
  select(`Category of Reliability` ="category",
         `Count`= "n", 
         `Percentage`= "percent")
  tibble(count_reliability)%>%
    kable()

Category of Reliability	Count	Percentage
High Confidence	42	72.41379
Low Confidence	5	8.62069
Moderate Confidence	11	18.96552

2.3 High Uncertainty Counties

Your Task: Identify the 5 counties with the highest MOE percentages.

Requirements: - Sort by MOE percentage (highest first) - Select the top 5 counties - Display: county name, median income, margin of error, MOE percentage, reliability category - Format as a professional table using kable()

Hint: Use arrange(), slice(), and select() functions.

# Create table of top 5 counties by MOE percentage

top_variable <- ca_county_reliability %>%
  arrange(desc(moe_pct))%>%
  slice(1:5) 
  
head(top_variable)%>%
  kable()

County	Median Household Income	Median HH Income Margin of Error	Total Population	moe_pct	category	flag
Mono	82038	15388	13219	18.75716	Low Confidence	!!!
Alpine	101125	17442	1515	17.24796	Low Confidence	!!!
Sierra	61108	9237	2916	15.11586	Low Confidence	!!!
Trinity	47317	5890	15889	12.44796	Low Confidence	!!!
Plumas	67885	7772	19650	11.44877	Low Confidence	!!!

# Format as table with kable() - include appropriate column names and caption
top_variable <- ca_county_reliability %>%
  arrange(desc(moe_pct)) %>%
  slice(1:5)

top_variable %>%
  select(
    County,
    `Median Household Income`,
    `Median HH Income Margin of Error`,
    `Total Population`,
    `Margin of Error for HH Income (%)` = moe_pct,
    `Reliability Category` = category,
    DANGER = flag
  ) %>%
  kable(caption = "Top 5 counties in California by HH Income MOE")

Top 5 counties in California by HH Income MOE
County	Median Household Income	Median HH Income Margin of Error	Total Population	Margin of Error for HH Income (%)	Reliability Category	DANGER
Mono	82038	15388	13219	18.75716	Low Confidence	!!!
Alpine	101125	17442	1515	17.24796	Low Confidence	!!!
Sierra	61108	9237	2916	15.11586	Low Confidence	!!!
Trinity	47317	5890	15889	12.44796	Low Confidence	!!!
Plumas	67885	7772	19650	11.44877	Low Confidence	!!!

Data Quality Commentary: These results show that counties with the highest margins of error for median household income, such as Mono, Alpine, Sierra, Trinity, and Plumas, have less reliable income estimates. Algorithms that rely on this data may therefore poorly serve residents in these counties by producing unstable classifications or inaccurate eligibility decisions. This uncertainty may lead to their exclusion or misrepresentation in planning decisions and program targeting that depend on precise income thresholds.

Part 3: Neighborhood-Level Analysis

3.1 Focus Area Selection

Your Task: Select 2-3 counties from your reliability analysis for detailed tract-level study.

Strategy: Choose counties that represent different reliability levels (e.g., 1 high confidence, 1 moderate, 1 low confidence) to compare how data quality varies.

# Use filter() to select 2-3 counties from your county_reliability data
# Store the selected counties in a variable called selected_counties
# Display the selected counties with their key characteristics
# Show: county name, median income, MOE percentage, reliability category


selected_counties <- ca_county_reliability %>%
  filter(category %in% c("Low Confidence", "Moderate Confidence", "High Confidence")) %>%
  group_by(category) %>%
  slice(1) %>%
  ungroup() %>%
  select(
    County,
    `Median Household Income`,
    `Margin of Error for HH Income (%)` = moe_pct,
    `Reliability Category` = category,
  )

selected_counties %>% 
  kable()

County	Median Household Income	Margin of Error for HH Income (%)	Reliability Category
Alameda	122488	1.004996	High Confidence
Alpine	101125	17.247960	Low Confidence
Amador	74853	8.079837	Moderate Confidence

Comment on the output: The % cateogory of marginal error directly reflects the reliability of the data. Where, lower the % of marginal error, higher reliability of data.

3.2 Tract-Level Demographics

Your Task: Get demographic data for census tracts in your selected counties.

Requirements: - Geography: tract level - Variables: white alone (B03002_003), Black/African American (B03002_004), Hispanic/Latino (B03002_012), total population (B03002_001) - Use the same state and year as before - Output format: wide - Challenge: You’ll need county codes, not names. Look at the GEOID patterns in your county data for hints.

# Define your race/ethnicity variables with descriptive names
race_variables <- c(
  `White Alone` = "B03002_003",
  `Black/African American` = "B03002_004",
  `Hispanic/Latino` = "B03002_012",
  `Total Population` = "B03002_001"
)

# Use get_acs() to retrieve tract-level data
# Hint: You may need to specify county codes in the county parameter

county_levelcode <- c("001","003","005")
  

selected_counties_data <- get_acs(
  geography = "tract",
  variables = race_variables,
  county = county_levelcode,
  state = my_state,
  year = 2022,
  survey = "acs5",
  output = "wide"
)

tibble(selected_counties_data)%>%
  kable()

GEOID	NAME	White AloneE	White AloneM	Black/African AmericanE	Black/African AmericanM	Hispanic/LatinoE	Hispanic/LatinoM	Total PopulationE	Total PopulationM
06001400100	Census Tract 4001; Alameda County; California	2255	444	171	120	167	94	3269	452
06001400200	Census Tract 4002; Alameda County; California	1500	219	38	36	159	98	2147	201
06001400300	Census Tract 4003; Alameda County; California	3290	378	529	216	568	303	5619	571
06001400400	Census Tract 4004; Alameda County; California	2740	606	499	271	306	150	4278	598
06001400500	Census Tract 4005; Alameda County; California	1638	262	993	680	612	212	3949	737
06001400600	Census Tract 4006; Alameda County; California	905	183	539	182	134	62	2058	301
06001400700	Census Tract 4007; Alameda County; California	2293	422	1101	293	470	185	4758	572
06001400800	Census Tract 4008; Alameda County; California	2228	462	643	185	387	202	4335	593
06001400900	Census Tract 4009; Alameda County; California	1052	266	692	304	533	331	2844	496
06001401000	Census Tract 4010; Alameda County; California	2095	531	1478	737	1389	621	6277	896
06001401100	Census Tract 4011; Alameda County; California	2325	455	906	411	658	274	5537	544
06001401200	Census Tract 4012; Alameda County; California	1718	307	239	136	387	144	2994	329
06001401300	Census Tract 4013; Alameda County; California	1657	307	1325	370	393	148	4608	404
06001401400	Census Tract 4014; Alameda County; California	1380	257	1716	418	1175	484	5392	777
06001401500	Census Tract 4015; Alameda County; California	662	167	1666	581	467	264	3035	613
06001401600	Census Tract 4016; Alameda County; California	446	132	788	208	697	319	2403	385
06001401700	Census Tract 4017; Alameda County; California	1487	342	452	295	549	236	3276	493
06001401800	Census Tract 4018; Alameda County; California	417	114	649	166	454	226	1709	273
06001402200	Census Tract 4022; Alameda County; California	747	203	647	272	537	198	2337	393
06001402400	Census Tract 4024; Alameda County; California	349	166	1432	443	228	155	2623	532
06001402500	Census Tract 4025; Alameda County; California	314	239	878	326	235	183	2010	363
06001402600	Census Tract 4026; Alameda County; California	123	53	500	187	76	74	1300	263
06001402700	Census Tract 4027; Alameda County; California	523	196	763	240	347	189	2039	376
06001402801	Census Tract 4028.01; Alameda County; California	869	225	1411	550	148	83	3254	626
06001402802	Census Tract 4028.02; Alameda County; California	329	199	613	255	51	67	1430	248
06001402900	Census Tract 4029; Alameda County; California	365	105	408	147	182	76	1828	259
06001403000	Census Tract 4030; Alameda County; California	250	116	146	183	62	50	2897	466
06001403100	Census Tract 4031; Alameda County; California	767	201	323	137	241	72	1941	284
06001403301	Census Tract 4033.01; Alameda County; California	187	185	51	51	38	34	1830	382
06001403302	Census Tract 4033.02; Alameda County; California	1317	293	123	96	158	105	2556	318
06001403401	Census Tract 4034.01; Alameda County; California	1154	281	447	202	238	143	2717	387
06001403402	Census Tract 4034.02; Alameda County; California	493	166	172	117	135	90	1134	175
06001403501	Census Tract 4035.01; Alameda County; California	1874	607	740	228	387	219	4904	684
06001403502	Census Tract 4035.02; Alameda County; California	939	180	221	130	324	128	1919	262
06001403600	Census Tract 4036; Alameda County; California	1933	391	1174	326	857	275	5056	687
06001403701	Census Tract 4037.01; Alameda County; California	1222	298	632	263	305	104	2909	348
06001403702	Census Tract 4037.02; Alameda County; California	1224	247	369	178	244	135	2238	262
06001403800	Census Tract 4038; Alameda County; California	2471	307	606	330	288	127	4008	438
06001403900	Census Tract 4039; Alameda County; California	2436	599	360	204	433	245	3883	701
06001404000	Census Tract 4040; Alameda County; California	1597	335	377	198	615	217	3145	395
06001404101	Census Tract 4041.01; Alameda County; California	2365	348	269	145	141	85	3208	349
06001404102	Census Tract 4041.02; Alameda County; California	1430	201	155	101	293	141	2701	352
06001404200	Census Tract 4042; Alameda County; California	2606	436	192	208	286	160	3894	388
06001404300	Census Tract 4043; Alameda County; California	2696	388	46	46	214	130	3587	368
06001404400	Census Tract 4044; Alameda County; California	3417	503	142	108	182	111	5823	604
06001404501	Census Tract 4045.01; Alameda County; California	1197	199	94	67	116	75	1820	205
06001404502	Census Tract 4045.02; Alameda County; California	4030	641	353	237	326	143	6110	776
06001404600	Census Tract 4046; Alameda County; California	2872	325	263	227	216	138	4934	605
06001404700	Census Tract 4047; Alameda County; California	1477	245	100	56	198	99	2187	262
06001404800	Census Tract 4048; Alameda County; California	1444	335	315	224	275	148	2744	404
06001404900	Census Tract 4049; Alameda County; California	2530	305	283	167	764	301	4669	462
06001405000	Census Tract 4050; Alameda County; California	2086	328	493	175	376	192	3665	329
06001405100	Census Tract 4051; Alameda County; California	2986	389	255	88	305	125	4508	405
06001405200	Census Tract 4052; Alameda County; California	1670	331	680	277	305	138	4913	1030
06001405301	Census Tract 4053.01; Alameda County; California	1394	306	400	269	480	154	2872	474
06001405302	Census Tract 4053.02; Alameda County; California	876	242	596	192	159	117	2559	347
06001405401	Census Tract 4054.01; Alameda County; California	894	242	444	132	834	336	3541	471
06001405402	Census Tract 4054.02; Alameda County; California	746	346	561	212	862	511	3673	638
06001405500	Census Tract 4055; Alameda County; California	756	151	690	387	520	191	3537	503
06001405600	Census Tract 4056; Alameda County; California	941	204	524	227	677	281	3044	524
06001405700	Census Tract 4057; Alameda County; California	530	148	985	412	876	433	3522	549
06001405800	Census Tract 4058; Alameda County; California	494	218	850	456	864	332	4182	682
06001405901	Census Tract 4059.01; Alameda County; California	189	98	643	350	1266	611	3757	624
06001405902	Census Tract 4059.02; Alameda County; California	389	196	234	96	916	250	3138	431
06001406000	Census Tract 4060; Alameda County; California	830	261	910	436	963	278	4735	518
06001406100	Census Tract 4061; Alameda County; California	897	217	438	266	2345	519	4939	600
06001406201	Census Tract 4062.01; Alameda County; California	284	155	695	327	2455	680	5072	747
06001406202	Census Tract 4062.02; Alameda County; California	316	168	592	287	2955	692	4733	671
06001406300	Census Tract 4063; Alameda County; California	482	183	880	457	1590	524	4556	743
06001406400	Census Tract 4064; Alameda County; California	609	147	430	136	816	551	2598	542
06001406500	Census Tract 4065; Alameda County; California	777	228	861	386	3183	755	6494	812
06001406601	Census Tract 4066.01; Alameda County; California	1034	277	1302	429	1069	340	4531	661
06001406602	Census Tract 4066.02; Alameda County; California	344	112	567	248	866	308	2540	401
06001406700	Census Tract 4067; Alameda County; California	2465	481	366	235	919	340	5380	695
06001406800	Census Tract 4068; Alameda County; California	1127	226	833	515	965	239	3971	510
06001406900	Census Tract 4069; Alameda County; California	1533	263	656	327	323	125	3865	546
06001407000	Census Tract 4070; Alameda County; California	1135	388	970	361	2257	737	6202	893
06001407101	Census Tract 4071.01; Alameda County; California	471	187	749	470	1640	625	4053	794
06001407102	Census Tract 4071.02; Alameda County; California	320	116	1011	554	1591	486	4268	900
06001407200	Census Tract 4072; Alameda County; California	920	419	211	124	4626	924	6544	798
06001407300	Census Tract 4073; Alameda County; California	268	118	207	118	1604	359	2459	430
06001407400	Census Tract 4074; Alameda County; California	253	108	1548	655	1882	454	4242	669
06001407500	Census Tract 4075; Alameda County; California	280	228	910	317	1912	409	3988	662
06001407600	Census Tract 4076; Alameda County; California	1637	626	1617	555	2189	545	6459	849
06001407700	Census Tract 4077; Alameda County; California	1896	444	897	291	769	304	4238	419
06001407800	Census Tract 4078; Alameda County; California	989	211	602	221	671	253	2769	334
06001407900	Census Tract 4079; Alameda County; California	1530	296	398	261	396	189	3088	376
06001408000	Census Tract 4080; Alameda County; California	1736	382	235	171	326	127	2860	395
06001408100	Census Tract 4081; Alameda County; California	2731	393	1828	585	539	199	7313	718
06001408200	Census Tract 4082; Alameda County; California	752	166	1811	503	1300	522	4471	684
06001408300	Census Tract 4083; Alameda County; California	1046	197	1827	503	1007	197	4791	599
06001408400	Census Tract 4084; Alameda County; California	181	149	1610	347	1922	539	4077	613
06001408500	Census Tract 4085; Alameda County; California	149	192	2216	684	2783	753	5634	1069
06001408600	Census Tract 4086; Alameda County; California	398	297	2818	769	2695	644	6519	950
06001408700	Census Tract 4087; Alameda County; California	673	364	2414	544	3788	886	7456	1271
06001408800	Census Tract 4088; Alameda County; California	328	250	2723	733	3644	1165	7968	1019
06001408900	Census Tract 4089; Alameda County; California	171	125	836	215	2694	574	3956	536
06001409000	Census Tract 4090; Alameda County; California	165	103	1477	478	2960	1184	5039	1118
06001409100	Census Tract 4091; Alameda County; California	256	225	516	206	1559	223	2532	369
06001409200	Census Tract 4092; Alameda County; California	45	36	987	285	2249	587	3615	486
06001409300	Census Tract 4093; Alameda County; California	129	91	1357	421	3769	748	5743	681
06001409400	Census Tract 4094; Alameda County; California	217	136	851	427	3107	894	4710	892
06001409500	Census Tract 4095; Alameda County; California	505	441	759	309	2755	599	4291	648
06001409600	Census Tract 4096; Alameda County; California	172	112	1247	440	3599	615	5139	663
06001409700	Census Tract 4097; Alameda County; California	424	208	1875	490	1906	414	5240	1012
06001409800	Census Tract 4098; Alameda County; California	618	233	1762	387	529	320	3511	594
06001409900	Census Tract 4099; Alameda County; California	926	224	1635	451	536	285	3983	563
06001410000	Census Tract 4100; Alameda County; California	1038	212	1502	493	158	94	3177	536
06001410100	Census Tract 4101; Alameda County; California	310	172	1645	308	564	188	3172	401
06001410200	Census Tract 4102; Alameda County; California	343	172	1432	355	1205	481	3238	501
06001410300	Census Tract 4103; Alameda County; California	79	48	642	208	3044	456	3893	418
06001410400	Census Tract 4104; Alameda County; California	218	121	1465	371	2415	717	4687	823
06001410500	Census Tract 4105; Alameda County; California	662	334	1814	319	373	241	3081	417
06001420100	Census Tract 4201; Alameda County; California	1426	222	122	130	350	156	2631	296
06001420200	Census Tract 4202; Alameda County; California	1148	196	185	149	158	116	3275	408
06001420301	Census Tract 4203.01; Alameda County; California	1004	301	64	60	230	186	2645	351
06001420302	Census Tract 4203.02; Alameda County; California	849	188	287	205	171	104	2446	338
06001420401	Census Tract 4204.01; Alameda County; California	427	127	0	13	314	160	1333	213
06001420402	Census Tract 4204.02; Alameda County; California	531	144	52	48	468	177	1661	244
06001420500	Census Tract 4205; Alameda County; California	1245	172	57	27	404	257	2548	254
06001420600	Census Tract 4206; Alameda County; California	2222	276	36	26	272	164	3488	343
06001421100	Census Tract 4211; Alameda County; California	1615	227	35	32	111	76	2108	230
06001421200	Census Tract 4212; Alameda County; California	2473	214	24	26	70	43	3557	542
06001421300	Census Tract 4213; Alameda County; California	2907	368	7	10	115	99	4011	406
06001421400	Census Tract 4214; Alameda County; California	1270	262	31	27	147	81	1638	268
06001421500	Census Tract 4215; Alameda County; California	3312	475	65	69	185	128	4064	530
06001421600	Census Tract 4216; Alameda County; California	2746	376	93	78	150	84	3854	570
06001421700	Census Tract 4217; Alameda County; California	2234	444	140	110	199	117	3421	446
06001421800	Census Tract 4218; Alameda County; California	1584	238	20	25	114	68	2260	266
06001421900	Census Tract 4219; Alameda County; California	2089	491	549	295	298	119	4141	550
06001422000	Census Tract 4220; Alameda County; California	1214	274	119	80	164	81	2453	264
06001422100	Census Tract 4221; Alameda County; California	1495	375	374	188	641	195	3200	359
06001422200	Census Tract 4222; Alameda County; California	2054	626	83	53	239	163	3280	612
06001422300	Census Tract 4223; Alameda County; California	1875	325	444	259	245	117	3567	477
06001422400	Census Tract 4224; Alameda County; California	1580	323	134	119	522	140	4187	757
06001422500	Census Tract 4225; Alameda County; California	1994	410	183	124	585	346	4467	572
06001422700	Census Tract 4227; Alameda County; California	1744	310	186	120	793	209	4803	496
06001422800	Census Tract 4228; Alameda County; California	2486	297	515	172	1671	404	8980	545
06001422901	Census Tract 4229.01; Alameda County; California	820	436	0	13	51	39	2024	627
06001422902	Census Tract 4229.02; Alameda County; California	907	450	203	255	209	117	3022	642
06001423000	Census Tract 4230; Alameda County; California	2605	730	343	229	374	224	4549	851
06001423100	Census Tract 4231; Alameda County; California	1766	281	1015	564	434	208	4275	616
06001423200	Census Tract 4232; Alameda County; California	1176	251	527	319	1004	393	3003	520
06001423300	Census Tract 4233; Alameda County; California	1595	466	690	249	579	188	3476	588
06001423400	Census Tract 4234; Alameda County; California	2613	483	737	347	1237	336	5551	779
06001423500	Census Tract 4235; Alameda County; California	1935	297	357	193	594	329	3540	464
06001423601	Census Tract 4236.01; Alameda County; California	1715	341	102	71	358	156	2738	457
06001423602	Census Tract 4236.02; Alameda County; California	3393	1229	108	82	1006	375	7198	1437
06001423700	Census Tract 4237; Alameda County; California	2179	588	86	77	603	213	3606	591
06001423800	Census Tract 4238; Alameda County; California	2485	336	37	60	189	89	3425	337
06001423901	Census Tract 4239.01; Alameda County; California	1168	285	286	123	444	242	2258	319
06001423902	Census Tract 4239.02; Alameda County; California	1041	174	90	62	107	65	1512	198
06001424001	Census Tract 4240.01; Alameda County; California	1683	373	658	186	593	123	3631	503
06001424002	Census Tract 4240.02; Alameda County; California	1004	270	830	300	453	148	2663	323
06001425101	Census Tract 4251.01; Alameda County; California	797	139	104	92	186	166	1754	225
06001425102	Census Tract 4251.02; Alameda County; California	1170	313	507	236	399	208	3969	344
06001425103	Census Tract 4251.03; Alameda County; California	971	175	826	287	215	133	3103	340
06001425104	Census Tract 4251.04; Alameda County; California	1668	280	624	216	388	170	4014	511
06001426100	Census Tract 4261; Alameda County; California	4288	459	0	19	152	107	6300	506
06001426200	Census Tract 4262; Alameda County; California	3310	465	70	71	281	153	4861	504
06001427100	Census Tract 4271; Alameda County; California	2448	334	51	35	628	285	4222	442
06001427200	Census Tract 4272; Alameda County; California	1468	245	149	107	748	209	4508	617
06001427300	Census Tract 4273; Alameda County; California	1673	366	859	746	430	159	5283	882
06001427600	Census Tract 4276; Alameda County; California	1352	362	738	230	733	284	4740	524
06001427700	Census Tract 4277; Alameda County; California	3052	847	107	80	530	229	5009	796
06001427800	Census Tract 4278; Alameda County; California	2198	327	187	111	402	215	4274	458
06001427900	Census Tract 4279; Alameda County; California	2441	640	31	43	645	200	4686	689
06001428000	Census Tract 4280; Alameda County; California	925	289	350	263	409	259	2906	544
06001428100	Census Tract 4281; Alameda County; California	2495	495	332	231	470	208	4866	701
06001428200	Census Tract 4282; Alameda County; California	3329	544	215	160	852	226	6475	608
06001428301	Census Tract 4283.01; Alameda County; California	1874	561	368	353	684	479	7203	898
06001428302	Census Tract 4283.02; Alameda County; California	3110	557	61	82	480	266	7022	767
06001428400	Census Tract 4284; Alameda County; California	1763	264	343	217	783	276	4756	619
06001428500	Census Tract 4285; Alameda County; California	1376	293	361	270	538	233	3302	393
06001428600	Census Tract 4286; Alameda County; California	1374	362	193	92	362	174	3235	443
06001428700	Census Tract 4287; Alameda County; California	1147	225	899	408	683	248	5078	522
06001430101	Census Tract 4301.01; Alameda County; California	2381	733	206	137	698	289	7034	851
06001430102	Census Tract 4301.02; Alameda County; California	1314	184	22	19	355	159	2459	224
06001430200	Census Tract 4302; Alameda County; California	3950	582	266	166	780	367	7713	712
06001430300	Census Tract 4303; Alameda County; California	1880	333	21	24	1049	343	4290	625
06001430400	Census Tract 4304; Alameda County; California	1004	149	92	69	142	72	2155	248
06001430500	Census Tract 4305; Alameda County; California	1507	389	2328	1130	970	233	6250	1034
06001430600	Census Tract 4306; Alameda County; California	2404	797	245	207	1002	397	6244	965
06001430700	Census Tract 4307; Alameda County; California	1575	244	203	168	741	185	4085	406
06001430800	Census Tract 4308; Alameda County; California	2472	439	49	51	943	679	5814	739
06001430900	Census Tract 4309; Alameda County; California	1463	377	338	188	1475	695	5214	713
06001431000	Census Tract 4310; Alameda County; California	820	204	504	345	492	281	3091	481
06001431100	Census Tract 4311; Alameda County; California	839	291	903	530	856	363	3259	509
06001431200	Census Tract 4312; Alameda County; California	2114	440	830	376	1618	455	5865	521
06001432100	Census Tract 4321; Alameda County; California	1260	140	949	488	961	261	3892	550
06001432200	Census Tract 4322; Alameda County; California	1058	169	389	110	1469	579	3987	615
06001432300	Census Tract 4323; Alameda County; California	1214	289	614	181	1463	310	4874	457
06001432400	Census Tract 4324; Alameda County; California	801	310	280	234	3501	946	6346	929
06001432501	Census Tract 4325.01; Alameda County; California	989	278	183	200	1356	335	4892	663
06001432502	Census Tract 4325.02; Alameda County; California	554	192	993	361	1544	589	5126	801
06001432601	Census Tract 4326.01; Alameda County; California	985	401	907	572	1015	132	4092	780
06001432602	Census Tract 4326.02; Alameda County; California	443	168	790	419	929	303	3123	445
06001432700	Census Tract 4327; Alameda County; California	1445	556	135	83	586	203	2755	563
06001432800	Census Tract 4328; Alameda County; California	1432	450	264	189	535	228	3862	579
06001433000	Census Tract 4330; Alameda County; California	1349	269	309	217	601	236	3799	460
06001433102	Census Tract 4331.02; Alameda County; California	332	125	309	188	1293	289	4445	806
06001433103	Census Tract 4331.03; Alameda County; California	459	192	406	199	1425	483	3552	610
06001433104	Census Tract 4331.04; Alameda County; California	1042	322	766	378	1673	395	4398	590
06001433200	Census Tract 4332; Alameda County; California	829	342	790	427	2671	1234	8120	1285
06001433300	Census Tract 4333; Alameda County; California	1355	366	37	51	2003	745	7367	927
06001433400	Census Tract 4334; Alameda County; California	810	204	514	280	472	186	6040	991
06001433500	Census Tract 4335; Alameda County; California	1078	252	126	126	903	330	4311	732
06001433600	Census Tract 4336; Alameda County; California	1656	554	296	262	1156	269	5844	646
06001433700	Census Tract 4337; Alameda County; California	392	224	85	66	1623	402	3125	470
06001433801	Census Tract 4338.01; Alameda County; California	308	128	472	257	1645	443	3528	607
06001433802	Census Tract 4338.02; Alameda County; California	340	195	541	425	896	331	4301	650
06001433900	Census Tract 4339; Alameda County; California	623	406	1892	644	3058	756	7187	1004
06001434000	Census Tract 4340; Alameda County; California	910	334	679	209	2335	474	5166	602
06001435102	Census Tract 4351.02; Alameda County; California	1519	296	888	176	1655	342	6137	604
06001435103	Census Tract 4351.03; Alameda County; California	2699	743	575	273	487	226	7774	1027
06001435104	Census Tract 4351.04; Alameda County; California	1055	369	506	280	2116	583	6856	1007
06001435200	Census Tract 4352; Alameda County; California	1073	356	1039	349	1261	376	4647	571
06001435300	Census Tract 4353; Alameda County; California	1068	321	728	249	1622	416	4812	534
06001435400	Census Tract 4354; Alameda County; California	1173	366	797	283	1644	309	5048	633
06001435500	Census Tract 4355; Alameda County; California	1098	547	522	207	1986	502	4153	677
06001435601	Census Tract 4356.01; Alameda County; California	666	205	566	316	3092	685	5449	750
06001435602	Census Tract 4356.02; Alameda County; California	1123	316	763	502	2970	554	5671	586
06001435700	Census Tract 4357; Alameda County; California	1015	238	117	66	2414	460	4819	536
06001435800	Census Tract 4358; Alameda County; California	1181	347	256	303	2188	427	5687	539
06001435900	Census Tract 4359; Alameda County; California	1525	370	35	41	1318	270	5290	850
06001436000	Census Tract 4360; Alameda County; California	1385	345	31	34	2067	434	5114	609
06001436100	Census Tract 4361; Alameda County; California	972	181	251	150	1853	432	5765	1012
06001436200	Census Tract 4362; Alameda County; California	437	182	528	308	2631	607	4128	587
06001436301	Census Tract 4363.01; Alameda County; California	325	113	565	255	2413	715	5255	791
06001436302	Census Tract 4363.02; Alameda County; California	672	180	461	179	1793	482	3932	492
06001436402	Census Tract 4364.02; Alameda County; California	1088	185	370	357	640	153	2688	431
06001436403	Census Tract 4364.03; Alameda County; California	1199	308	424	294	1165	699	4519	757
06001436404	Census Tract 4364.04; Alameda County; California	1442	446	365	189	693	315	3232	473
06001436500	Census Tract 4365; Alameda County; California	689	147	508	269	2579	504	5289	631
06001436601	Census Tract 4366.01; Alameda County; California	717	209	704	390	3818	707	6634	774
06001436602	Census Tract 4366.02; Alameda County; California	345	194	324	170	2801	472	5255	660
06001436700	Census Tract 4367; Alameda County; California	382	143	448	282	1603	336	3367	470
06001436800	Census Tract 4368; Alameda County; California	457	159	249	154	2072	585	4196	592
06001436900	Census Tract 4369; Alameda County; California	776	227	446	394	3687	768	6403	687
06001437000	Census Tract 4370; Alameda County; California	750	279	201	136	1310	445	3471	550
06001437101	Census Tract 4371.01; Alameda County; California	817	219	499	286	2184	696	7960	736
06001437102	Census Tract 4371.02; Alameda County; California	437	166	308	231	1894	443	4457	616
06001437200	Census Tract 4372; Alameda County; California	969	231	546	200	2719	651	8491	1021
06001437300	Census Tract 4373; Alameda County; California	403	171	383	228	1051	248	3135	373
06001437400	Census Tract 4374; Alameda County; California	570	258	140	73	1957	344	3733	439
06001437500	Census Tract 4375; Alameda County; California	461	205	246	175	2335	468	4172	508
06001437600	Census Tract 4376; Alameda County; California	396	120	327	149	1080	222	3455	526
06001437701	Census Tract 4377.01; Alameda County; California	358	238	562	245	1786	415	3597	729
06001437702	Census Tract 4377.02; Alameda County; California	215	148	74	71	3298	652	3880	636
06001437800	Census Tract 4378; Alameda County; California	758	262	380	263	1832	523	4940	696
06001437900	Census Tract 4379; Alameda County; California	240	82	230	180	832	217	2032	324
06001438000	Census Tract 4380; Alameda County; California	839	235	418	318	829	129	3645	578
06001438100	Census Tract 4381; Alameda County; California	977	243	502	171	2933	548	7953	1284
06001438201	Census Tract 4382.01; Alameda County; California	360	171	275	198	2732	755	4895	642
06001438203	Census Tract 4382.03; Alameda County; California	1012	481	148	113	860	290	4091	622
06001438204	Census Tract 4382.04; Alameda County; California	604	225	257	143	2277	634	6371	694
06001438300	Census Tract 4383; Alameda County; California	232	99	252	123	1455	384	3899	419
06001438400	Census Tract 4384; Alameda County; California	417	151	290	161	644	233	2671	391
06001440100	Census Tract 4401; Alameda County; California	1077	241	138	114	550	224	2661	262
06001440200	Census Tract 4402; Alameda County; California	148	115	26	29	3971	502	5641	664
06001440301	Census Tract 4403.01; Alameda County; California	2028	821	406	232	2378	871	7074	1071
06001440304	Census Tract 4403.04; Alameda County; California	482	226	370	366	567	235	4662	636
06001440305	Census Tract 4403.05; Alameda County; California	859	311	52	58	551	89	4064	527
06001440306	Census Tract 4403.06; Alameda County; California	346	158	223	118	417	252	3787	383
06001440307	Census Tract 4403.07; Alameda County; California	611	212	259	178	960	408	4481	930
06001440308	Census Tract 4403.08; Alameda County; California	767	245	247	176	1561	354	6011	700
06001440331	Census Tract 4403.31; Alameda County; California	378	170	124	82	520	177	3276	384
06001440332	Census Tract 4403.32; Alameda County; California	258	115	50	46	271	110	3203	343
06001440333	Census Tract 4403.33; Alameda County; California	194	72	22	23	146	131	2732	399
06001440334	Census Tract 4403.34; Alameda County; California	430	156	233	246	514	216	4041	690
06001440336	Census Tract 4403.36; Alameda County; California	624	250	534	312	432	181	4248	487
06001440337	Census Tract 4403.37; Alameda County; California	157	119	140	179	259	148	2852	494
06001440338	Census Tract 4403.38; Alameda County; California	913	752	20	33	386	283	4095	902
06001441100	Census Tract 4411; Alameda County; California	2042	411	2	8	739	202	4632	609
06001441200	Census Tract 4412; Alameda County; California	2346	648	191	118	900	312	7354	905
06001441301	Census Tract 4413.01; Alameda County; California	663	302	363	238	246	172	3330	385
06001441302	Census Tract 4413.02; Alameda County; California	918	244	158	126	662	245	5828	592
06001441401	Census Tract 4414.01; Alameda County; California	1326	453	87	83	742	296	7549	819
06001441402	Census Tract 4414.02; Alameda County; California	944	218	68	59	383	138	5344	560
06001441501	Census Tract 4415.01; Alameda County; California	472	228	287	225	287	282	5723	688
06001441503	Census Tract 4415.03; Alameda County; California	538	295	18	27	320	184	7416	779
06001441521	Census Tract 4415.21; Alameda County; California	687	214	15	18	332	269	6016	706
06001441522	Census Tract 4415.22; Alameda County; California	956	310	138	113	364	151	5275	553
06001441523	Census Tract 4415.23; Alameda County; California	486	227	179	189	280	150	4264	605
06001441524	Census Tract 4415.24; Alameda County; California	215	110	15	18	41	50	4111	511
06001441525	Census Tract 4415.25; Alameda County; California	110	71	56	46	181	206	1603	328
06001441601	Census Tract 4416.01; Alameda County; California	1485	376	390	383	685	264	4774	536
06001441602	Census Tract 4416.02; Alameda County; California	2066	495	635	609	1741	783	7509	963
06001441701	Census Tract 4417.01; Alameda County; California	455	226	18	41	774	538	3884	603
06001441702	Census Tract 4417.02; Alameda County; California	936	305	504	457	816	456	5037	735
06001441800	Census Tract 4418; Alameda County; California	2007	577	110	85	346	224	6209	817
06001441921	Census Tract 4419.21; Alameda County; California	714	278	12	21	924	248	3849	468
06001441923	Census Tract 4419.23; Alameda County; California	694	274	197	147	750	570	5777	781
06001441924	Census Tract 4419.24; Alameda County; California	1191	346	109	102	748	284	7199	931
06001441926	Census Tract 4419.26; Alameda County; California	540	169	137	92	1038	357	4210	457
06001441927	Census Tract 4419.27; Alameda County; California	821	342	158	116	428	177	4229	631
06001441928	Census Tract 4419.28; Alameda County; California	627	228	493	278	292	178	3736	463
06001441929	Census Tract 4419.29; Alameda County; California	657	366	26	29	237	156	3064	520
06001442000	Census Tract 4420; Alameda County; California	438	109	4	8	292	143	2979	433
06001442100	Census Tract 4421; Alameda County; California	464	135	85	49	65	50	5327	668
06001442200	Census Tract 4422; Alameda County; California	948	356	177	228	426	254	7293	795
06001442301	Census Tract 4423.01; Alameda County; California	1061	448	128	85	794	357	5397	624
06001442302	Census Tract 4423.02; Alameda County; California	901	279	350	240	948	528	6186	819
06001442400	Census Tract 4424; Alameda County; California	1573	359	112	90	1601	313	6417	869
06001442501	Census Tract 4425.01; Alameda County; California	438	309	104	90	925	489	3280	685
06001442502	Census Tract 4425.02; Alameda County; California	676	287	164	161	1149	690	3866	756
06001442601	Census Tract 4426.01; Alameda County; California	1090	294	136	140	1091	833	3924	909
06001442602	Census Tract 4426.02; Alameda County; California	1364	258	484	467	812	336	4663	616
06001442700	Census Tract 4427; Alameda County; California	946	187	33	45	356	84	3139	528
06001442800	Census Tract 4428; Alameda County; California	752	142	23	63	484	148	3115	380
06001442900	Census Tract 4429; Alameda County; California	1178	360	401	265	1050	392	7780	1010
06001443001	Census Tract 4430.01; Alameda County; California	497	141	135	99	888	306	2762	351
06001443002	Census Tract 4430.02; Alameda County; California	1035	227	115	150	1153	418	6599	724
06001443102	Census Tract 4431.02; Alameda County; California	509	184	0	13	284	179	4816	511
06001443103	Census Tract 4431.03; Alameda County; California	775	569	50	92	137	107	4125	703
06001443104	Census Tract 4431.04; Alameda County; California	752	258	349	379	113	101	5567	689
06001443105	Census Tract 4431.05; Alameda County; California	489	114	20	23	99	78	4668	606
06001443200	Census Tract 4432; Alameda County; California	516	120	11	17	37	31	3611	679
06001443301	Census Tract 4433.01; Alameda County; California	791	272	45	47	390	230	4399	535
06001443321	Census Tract 4433.21; Alameda County; California	106	70	57	92	237	169	3372	483
06001443322	Census Tract 4433.22; Alameda County; California	621	211	36	32	222	142	3311	340
06001444100	Census Tract 4441; Alameda County; California	2084	587	477	396	1791	452	7211	912
06001444200	Census Tract 4442; Alameda County; California	1450	363	91	92	2049	559	6782	752
06001444301	Census Tract 4443.01; Alameda County; California	1086	167	28	41	956	177	3698	509
06001444303	Census Tract 4443.03; Alameda County; California	0	13	0	13	0	13	0	13
06001444304	Census Tract 4443.04; Alameda County; California	787	272	52	59	2045	759	6408	768
06001444400	Census Tract 4444; Alameda County; California	790	163	154	114	2880	701	5367	660
06001444500	Census Tract 4445; Alameda County; California	1287	398	322	209	3099	752	6988	855
06001444601	Census Tract 4446.01; Alameda County; California	1016	217	73	68	1099	441	6081	670
06001444602	Census Tract 4446.02; Alameda County; California	762	200	287	197	503	229	4935	510
06001450101	Census Tract 4501.01; Alameda County; California	1561	327	204	186	546	198	6883	695
06001450102	Census Tract 4501.02; Alameda County; California	1428	243	1094	436	1015	407	7376	681
06001450200	Census Tract 4502; Alameda County; California	2113	591	188	163	486	267	5272	670
06001450300	Census Tract 4503; Alameda County; California	2542	443	337	222	832	317	5374	597
06001450400	Census Tract 4504; Alameda County; California	2790	689	299	223	1472	327	7886	751
06001450501	Census Tract 4505.01; Alameda County; California	1823	370	0	13	448	214	3400	347
06001450502	Census Tract 4505.02; Alameda County; California	2602	377	41	40	557	175	6266	666
06001450601	Census Tract 4506.01; Alameda County; California	1735	257	27	23	248	110	3666	338
06001450603	Census Tract 4506.03; Alameda County; California	2065	340	21	27	736	375	4897	613
06001450604	Census Tract 4506.04; Alameda County; California	2650	377	22	32	656	181	4993	435
06001450605	Census Tract 4506.05; Alameda County; California	1873	298	10	19	340	143	3814	363
06001450606	Census Tract 4506.06; Alameda County; California	3011	405	0	19	301	133	6028	620
06001450607	Census Tract 4506.07; Alameda County; California	1703	296	89	105	753	409	5182	736
06001450608	Census Tract 4506.08; Alameda County; California	1925	240	78	92	357	224	4658	597
06001450609	Census Tract 4506.09; Alameda County; California	2376	389	100	97	681	322	4928	497
06001450701	Census Tract 4507.01; Alameda County; California	3949	474	145	109	619	286	8738	1015
06001450741	Census Tract 4507.41; Alameda County; California	2585	431	68	78	1228	699	5742	676
06001450742	Census Tract 4507.42; Alameda County; California	2672	487	10	16	503	210	5495	488
06001450743	Census Tract 4507.43; Alameda County; California	1486	272	588	314	944	493	7435	652
06001450744	Census Tract 4507.44; Alameda County; California	2733	483	0	19	757	448	5818	624
06001450745	Census Tract 4507.45; Alameda County; California	2093	566	28	44	436	264	6295	852
06001450746	Census Tract 4507.46; Alameda County; California	1506	254	14	9	600	577	3229	647
06001450750	Census Tract 4507.50; Alameda County; California	1340	229	244	143	473	222	6858	688
06001450751	Census Tract 4507.51; Alameda County; California	1600	389	340	340	658	252	12662	906
06001450752	Census Tract 4507.52; Alameda County; California	1394	328	228	233	685	369	9631	825
06001451102	Census Tract 4511.02; Alameda County; California	2904	579	20	32	290	160	3950	549
06001451103	Census Tract 4511.03; Alameda County; California	1174	515	24	33	163	102	1361	516
06001451104	Census Tract 4511.04; Alameda County; California	3870	772	3	3	1289	607	7164	1085
06001451201	Census Tract 4512.01; Alameda County; California	3620	943	124	143	1881	636	7569	994
06001451202	Census Tract 4512.02; Alameda County; California	2466	319	51	57	925	426	5482	707
06001451300	Census Tract 4513; Alameda County; California	3446	538	78	67	1696	519	6393	677
06001451401	Census Tract 4514.01; Alameda County; California	2426	374	330	384	2344	1004	6166	950
06001451403	Census Tract 4514.03; Alameda County; California	1276	218	35	40	512	133	2184	262
06001451404	Census Tract 4514.04; Alameda County; California	2098	399	70	84	3916	976	6631	910
06001451501	Census Tract 4515.01; Alameda County; California	2660	406	228	153	642	311	4496	487
06001451503	Census Tract 4515.03; Alameda County; California	3113	533	36	45	1213	427	6104	587
06001451504	Census Tract 4515.04; Alameda County; California	706	130	0	13	410	329	1539	338
06001451505	Census Tract 4515.05; Alameda County; California	2095	406	32	48	402	176	3159	473
06001451506	Census Tract 4515.06; Alameda County; California	1322	258	141	160	1294	541	3548	673
06001451601	Census Tract 4516.01; Alameda County; California	3774	490	0	19	497	234	5367	698
06001451602	Census Tract 4516.02; Alameda County; California	4522	919	152	120	1311	434	6909	929
06001451701	Census Tract 4517.01; Alameda County; California	1595	349	125	110	369	137	2936	490
06001451703	Census Tract 4517.03; Alameda County; California	2317	344	28	46	506	140	3827	348
06001451704	Census Tract 4517.04; Alameda County; California	3001	502	10	20	519	187	4320	556
06001981900	Census Tract 9819; Alameda County; California	15	18	0	13	10	15	25	32
06001982000	Census Tract 9820; Alameda County; California	25	17	5	7	0	13	50	19
06001982100	Census Tract 9821; Alameda County; California	261	133	82	90	170	49	923	48
06001983200	Census Tract 9832; Alameda County; California	485	112	124	67	43	29	896	105
06001990000	Census Tract 9900; Alameda County; California	0	13	0	13	0	13	0	13
06003010000	Census Tract 100; Alpine County; California	880	161	0	13	213	129	1515	206
06005000101	Census Tract 1.01; Amador County; California	3431	504	19	24	563	225	4294	553
06005000102	Census Tract 1.02; Amador County; California	1839	359	7	10	182	126	2160	361
06005000201	Census Tract 2.01; Amador County; California	2393	519	20	3	275	159	2791	526
06005000202	Census Tract 2.02; Amador County; California	1367	463	43	52	265	169	1868	450
06005000301	Census Tract 3.01; Amador County; California	2264	258	488	101	1783	264	4934	330
06005000303	Census Tract 3.03; Amador County; California	5191	463	6	14	593	270	6471	351
06005000304	Census Tract 3.04; Amador County; California	4079	642	42	49	552	210	5259	645
06005000401	Census Tract 4.01; Amador County; California	3608	561	32	53	353	173	4570	594
06005000402	Census Tract 4.02; Amador County; California	3776	486	8	19	763	394	4826	592
06005000500	Census Tract 5; Amador County; California	2445	388	3	9	811	321	3404	421

# Calculate percentage of each group using mutate()

percentage_eachgroup <- selected_counties_data %>%
  mutate(
    pct_white = (`White AloneE`/`Total PopulationE`)*100,
    pct_Black = (`Black/African AmericanE`/`Total PopulationE`)*100,
    pct_Hisp = (`Hispanic/LatinoE`/`Total PopulationE`)*100
    ) %>%
  # Create percentages for white, Black, and Hispanic populations
  mutate(`Percentage of White, Black and Hispanic Populations`= pct_white + pct_Black + pct_Hisp, 
 # Add readable tract and county name columns using str_extract() or similar
         Tract =  str_extract(NAME, "[0-9.]+"),
         County = str_extract(NAME, "[A-Za-z ]+ County"))%>% 
  select(County, Tract,
         `White %` = "pct_white",
         `Black %`= "pct_Black",
         `Hispanic or Latino %`="pct_Hisp", 
         `Percentage of White, Black and Hispanic Populations`,
        )
tibble(percentage_eachgroup)%>%
  kable()

County	Tract	White %	Black %	Hispanic or Latino %	Percentage of White, Black and Hispanic Populations
Alameda County	4001	68.981340	5.2309575	5.1085959	79.32089
Alameda County	4002	69.864928	1.7699115	7.4056823	79.04052
Alameda County	4003	58.551344	9.4144866	10.1085602	78.07439
Alameda County	4004	64.048621	11.6643291	7.1528752	82.86583
Alameda County	4005	41.478855	25.1456065	15.4975943	82.12206
Alameda County	4006	43.974733	26.1904762	6.5111759	76.67638
Alameda County	4007	48.192518	23.1399748	9.8781000	81.21059
Alameda County	4008	51.395617	14.8327566	8.9273356	75.15571
Alameda County	4009	36.990155	24.3319269	18.7412096	80.06329
Alameda County	4010	33.375816	23.5462801	22.1284053	79.05050
Alameda County	4011	41.990247	16.3626513	11.8836915	70.23659
Alameda County	4012	57.381430	7.9826319	12.9258517	78.28991
Alameda County	4013	35.959201	28.7543403	8.5286458	73.24219
Alameda County	4014	25.593472	31.8249258	21.7915430	79.20994
Alameda County	4015	21.812191	54.8929160	15.3871499	92.09226
Alameda County	4016	18.560133	32.7923429	29.0054099	80.35789
Alameda County	4017	45.390720	13.7973138	16.7582418	75.94628
Alameda County	4018	24.400234	37.9754242	26.5652428	88.94090
Alameda County	4022	31.964057	27.6850663	22.9781772	82.62730
Alameda County	4024	13.305376	54.5939764	8.6923370	76.59169
Alameda County	4025	15.621890	43.6815920	11.6915423	70.99502
Alameda County	4026	9.461538	38.4615385	5.8461538	53.76923
Alameda County	4027	25.649828	37.4203041	17.0181462	80.08828
Alameda County	4028.01	26.705593	43.3620160	4.5482483	74.61586
Alameda County	4028.02	23.006993	42.8671329	3.5664336	69.44056
Alameda County	4029	19.967177	22.3194748	9.9562363	52.24289
Alameda County	4030	8.629617	5.0396962	2.1401450	15.80946
Alameda County	4031	39.515713	16.6409067	12.4162803	68.57290
Alameda County	4033.01	10.218579	2.7868852	2.0765027	15.08197
Alameda County	4033.02	51.525822	4.8122066	6.1815336	62.51956
Alameda County	4034.01	42.473316	16.4519691	8.7596614	67.68495
Alameda County	4034.02	43.474427	15.1675485	11.9047619	70.54674
Alameda County	4035.01	38.213703	15.0897227	7.8915171	61.19494
Alameda County	4035.02	48.931735	11.5164148	16.8837936	77.33194
Alameda County	4036	38.231804	23.2199367	16.9501582	78.40190
Alameda County	4037.01	42.007563	21.7256789	10.4847026	74.21794
Alameda County	4037.02	54.691689	16.4879357	10.9025916	82.08222
Alameda County	4038	61.651697	15.1197605	7.1856287	83.95709
Alameda County	4039	62.734999	9.2711821	11.1511718	83.15735
Alameda County	4040	50.779014	11.9872814	19.5548490	82.32114
Alameda County	4041.01	73.721945	8.3852868	4.3952618	86.50249
Alameda County	4041.02	52.943354	5.7386153	10.8478341	69.52980
Alameda County	4042	66.923472	4.9306626	7.3446328	79.19877
Alameda County	4043	75.160301	1.2824087	5.9659883	82.40870
Alameda County	4044	58.681092	2.4386055	3.1255367	64.24523
Alameda County	4045.01	65.769231	5.1648352	6.3736264	77.30769
Alameda County	4045.02	65.957447	5.7774141	5.3355155	77.07038
Alameda County	4046	58.208350	5.3303608	4.3777868	67.91650
Alameda County	4047	67.535437	4.5724737	9.0534979	81.16141
Alameda County	4048	52.623907	11.4795918	10.0218659	74.12536
Alameda County	4049	54.187192	6.0612551	16.3632469	76.61169
Alameda County	4050	56.916780	13.4515689	10.2592087	80.62756
Alameda County	4051	66.237799	5.6566105	6.7657498	78.66016
Alameda County	4052	33.991451	13.8408304	6.2080195	54.04030
Alameda County	4053.01	48.537605	13.9275766	16.7130919	79.17827
Alameda County	4053.02	34.232122	23.2903478	6.2133646	63.73583
Alameda County	4054.01	25.247105	12.5388308	23.5526687	61.33860
Alameda County	4054.02	20.310373	15.2736183	23.4685543	59.05255
Alameda County	4055	21.374046	19.5080577	14.7017246	55.58383
Alameda County	4056	30.913272	17.2141919	22.2404731	70.36794
Alameda County	4057	15.048268	27.9670642	24.8722317	67.88756
Alameda County	4058	11.812530	20.3252033	20.6599713	52.79770
Alameda County	4059.01	5.030609	17.1147192	33.6970987	55.84243
Alameda County	4059.02	12.396431	7.4569790	29.1905672	49.04398
Alameda County	4060	17.529039	19.2185850	20.3379092	57.08553
Alameda County	4061	18.161571	8.8681919	47.4792468	74.50901
Alameda County	4062.01	5.599369	13.7026814	48.4029968	67.70505
Alameda County	4062.02	6.676526	12.5079231	62.4339742	81.61842
Alameda County	4063	10.579456	19.3151888	34.8990342	64.79368
Alameda County	4064	23.441108	16.5511932	31.4087760	71.40108
Alameda County	4065	11.964891	13.2583924	49.0144749	74.23776
Alameda County	4066.01	22.820569	28.7353785	23.5930258	75.14897
Alameda County	4066.02	13.543307	22.3228346	34.0944882	69.96063
Alameda County	4067	45.817844	6.8029740	17.0817844	69.70260
Alameda County	4068	28.380761	20.9770839	24.3011836	73.65903
Alameda County	4069	39.663648	16.9728331	8.3570505	64.99353
Alameda County	4070	18.300548	15.6401161	36.3914866	70.33215
Alameda County	4071.01	11.621021	18.4801382	40.4638539	70.56501
Alameda County	4071.02	7.497657	23.6879100	37.2774133	68.46298
Alameda County	4072	14.058680	3.2243276	70.6907090	87.97372
Alameda County	4073	10.898739	8.4180561	65.2297682	84.54656
Alameda County	4074	5.964168	36.4922207	44.3658652	86.82225
Alameda County	4075	7.021063	22.8184554	47.9438315	77.78335
Alameda County	4076	25.344481	25.0348351	33.8906952	84.27001
Alameda County	4077	44.738084	21.1656442	18.1453516	84.04908
Alameda County	4078	35.716865	21.7407006	24.2325749	81.69014
Alameda County	4079	49.546632	12.8886010	12.8238342	75.25907
Alameda County	4080	60.699301	8.2167832	11.3986014	80.31469
Alameda County	4081	37.344455	24.9965814	7.3704362	69.71147
Alameda County	4082	16.819503	40.5054798	29.0762693	86.40125
Alameda County	4083	21.832603	38.1340013	21.0185765	80.98518
Alameda County	4084	4.439539	39.4898209	47.1425067	91.07187
Alameda County	4085	2.644657	39.3326234	49.3965211	91.37380
Alameda County	4086	6.105231	43.2274889	41.3406964	90.67342
Alameda County	4087	9.026288	32.3766094	50.8047210	92.20762
Alameda County	4088	4.116466	34.1741968	45.7329317	84.02359
Alameda County	4089	4.322548	21.1324570	68.0990900	93.55410
Alameda County	4090	3.274459	29.3113713	58.7418139	91.32764
Alameda County	4091	10.110584	20.3791469	61.5718799	92.06161
Alameda County	4092	1.244813	27.3029046	62.2130014	90.76072
Alameda County	4093	2.246213	23.6287655	65.6277207	91.50270
Alameda County	4094	4.607219	18.0679406	65.9660297	88.64119
Alameda County	4095	11.768819	17.6881846	64.2041482	93.66115
Alameda County	4096	3.346955	24.2654213	70.0330804	97.64546
Alameda County	4097	8.091603	35.7824427	36.3740458	80.24809
Alameda County	4098	17.601823	50.1851324	15.0669325	82.85389
Alameda County	4099	23.248807	41.0494602	13.4571931	77.75546
Alameda County	4100	32.672332	47.2773056	4.9732452	84.92288
Alameda County	4101	9.773014	51.8600252	17.7805801	79.41362
Alameda County	4102	10.592959	44.2248301	37.2143298	92.03212
Alameda County	4103	2.029283	16.4911379	78.1916260	96.71205
Alameda County	4104	4.651163	31.2566674	51.5254961	87.43333
Alameda County	4105	21.486530	58.8769880	12.1064589	92.46998
Alameda County	4201	54.199924	4.6370201	13.3029266	72.13987
Alameda County	4202	35.053435	5.6488550	4.8244275	45.52672
Alameda County	4203.01	37.958412	2.4196597	8.6956522	49.07372
Alameda County	4203.02	34.709730	11.7334424	6.9910057	53.43418
Alameda County	4204.01	32.033008	0.0000000	23.5558890	55.58890
Alameda County	4204.02	31.968694	3.1306442	28.1757977	63.27514
Alameda County	4205	48.861852	2.2370487	15.8555730	66.95447
Alameda County	4206	63.704128	1.0321101	7.7981651	72.53440
Alameda County	4211	76.612903	1.6603416	5.2656546	83.53890
Alameda County	4212	69.524880	0.6747259	1.9679505	72.16756
Alameda County	4213	72.475692	0.1745201	2.8671154	75.51733
Alameda County	4214	77.533578	1.8925519	8.9743590	88.40049
Alameda County	4215	81.496063	1.5994094	4.5521654	87.64764
Alameda County	4216	71.250649	2.4130773	3.8920602	77.55579
Alameda County	4217	65.302543	4.0923707	5.8170126	75.21193
Alameda County	4218	70.088496	0.8849558	5.0442478	76.01770
Alameda County	4219	50.446752	13.2576672	7.1963294	70.90075
Alameda County	4220	49.490420	4.8512026	6.6856910	61.02731
Alameda County	4221	46.718750	11.6875000	20.0312500	78.43750
Alameda County	4222	62.621951	2.5304878	7.2865854	72.43902
Alameda County	4223	52.565181	12.4474348	6.8685170	71.88113
Alameda County	4224	37.735849	3.2003821	12.4671603	53.40339
Alameda County	4225	44.638460	4.0967092	13.0960376	61.83121
Alameda County	4227	36.310639	3.8725796	16.5105143	56.69373
Alameda County	4228	27.683742	5.7349666	18.6080178	52.02673
Alameda County	4229.01	40.513834	0.0000000	2.5197628	43.03360
Alameda County	4229.02	30.013236	6.7174057	6.9159497	43.64659
Alameda County	4230	57.265333	7.5401187	8.2215872	73.02704
Alameda County	4231	41.309942	23.7426901	10.1520468	75.20468
Alameda County	4232	39.160839	17.5491175	33.4332334	90.14319
Alameda County	4233	45.886076	19.8504028	16.6570771	82.39356
Alameda County	4234	47.072600	13.2768870	22.2842731	82.63376
Alameda County	4235	54.661017	10.0847458	16.7796610	81.52542
Alameda County	4236.01	62.636961	3.7253470	13.0752374	79.43755
Alameda County	4236.02	47.138094	1.5004168	13.9761045	62.61462
Alameda County	4237	60.427066	2.3849140	16.7221298	79.53411
Alameda County	4238	72.554744	1.0802920	5.5182482	79.15328
Alameda County	4239.01	51.727192	12.6660762	19.6634190	84.05669
Alameda County	4239.02	68.849206	5.9523810	7.0767196	81.87831
Alameda County	4240.01	46.350867	18.1217296	16.3315891	80.80419
Alameda County	4240.02	37.701840	31.1678558	17.0108900	85.88059
Alameda County	4251.01	45.438997	5.9293044	10.6043330	61.97263
Alameda County	4251.02	29.478458	12.7739985	10.0529101	52.30537
Alameda County	4251.03	31.292298	26.6194006	6.9287786	64.84048
Alameda County	4251.04	41.554559	15.5455904	9.6661684	66.76632
Alameda County	4261	68.063492	0.0000000	2.4126984	70.47619
Alameda County	4262	68.092985	1.4400329	5.7807036	75.31372
Alameda County	4271	57.981999	1.2079583	14.8744671	74.06442
Alameda County	4272	32.564330	3.3052351	16.5927240	52.46229
Alameda County	4273	31.667613	16.2597009	8.1393148	56.06663
Alameda County	4276	28.523207	15.5696203	15.4641350	59.55696
Alameda County	4277	60.930325	2.1361549	10.5809543	73.64743
Alameda County	4278	51.427234	4.3752925	9.4057089	65.20824
Alameda County	4279	52.091336	0.6615450	13.7644046	66.51729
Alameda County	4280	31.830695	12.0440468	14.0743290	57.94907
Alameda County	4281	51.274147	6.8228524	9.6588574	67.75586
Alameda County	4282	51.413127	3.3204633	13.1583012	67.89189
Alameda County	4283.01	26.016937	5.1089824	9.4960433	40.62196
Alameda County	4283.02	44.289376	0.8686984	6.8356594	51.99373
Alameda County	4284	37.068965	7.2119428	16.4634146	60.74432
Alameda County	4285	41.671714	10.9327680	16.2931557	68.89764
Alameda County	4286	42.472952	5.9659969	11.1901082	59.62906
Alameda County	4287	22.587633	17.7038204	13.4501772	53.74163
Alameda County	4301.01	33.849872	2.9286324	9.9232300	46.70173
Alameda County	4301.02	53.436356	0.8946726	14.4367629	68.76779
Alameda County	4302	51.212239	3.4487229	10.1127966	64.77376
Alameda County	4303	43.822844	0.4895105	24.4522145	68.76457
Alameda County	4304	46.589327	4.2691415	6.5893271	57.44780
Alameda County	4305	24.112000	37.2480000	15.5200000	76.88000
Alameda County	4306	38.500961	3.9237668	16.0474055	58.47213
Alameda County	4307	38.555692	4.9694002	18.1395349	61.66463
Alameda County	4308	42.518060	0.8427933	16.2194702	59.58032
Alameda County	4309	28.059072	6.4825470	28.2892213	62.83084
Alameda County	4310	26.528631	16.3054028	15.9171789	58.75121
Alameda County	4311	25.744093	27.7078859	26.2657257	79.71770
Alameda County	4312	36.044331	14.1517477	27.5873828	77.78346
Alameda County	4321	32.374101	24.3833505	24.6916752	81.44913
Alameda County	4322	26.536243	9.7567093	36.8447454	73.13770
Alameda County	4323	24.907673	12.5974559	30.0164136	67.52154
Alameda County	4324	12.622124	4.4122282	55.1686101	72.20296
Alameda County	4325.01	20.216680	3.7408013	27.7187244	51.67621
Alameda County	4325.02	10.807647	19.3718299	30.1209520	60.30043
Alameda County	4326.01	24.071359	22.1652004	24.8044966	71.04106
Alameda County	4326.02	14.185078	25.2961896	29.7470381	69.22831
Alameda County	4327	52.450091	4.9001815	21.2704174	78.62069
Alameda County	4328	37.079234	6.8358364	13.8529259	57.76800
Alameda County	4330	35.509345	8.1337194	15.8199526	59.46302
Alameda County	4331.02	7.469066	6.9516310	29.0888639	43.50956
Alameda County	4331.03	12.922297	11.4301802	40.1182432	64.47072
Alameda County	4331.04	23.692587	17.4170077	38.0400182	79.14961
Alameda County	4332	10.209360	9.7290640	32.8940887	52.83251
Alameda County	4333	18.392833	0.5022397	27.1888150	46.08389
Alameda County	4334	13.410596	8.5099338	7.8145695	29.73510
Alameda County	4335	25.005799	2.9227557	20.9464161	48.87497
Alameda County	4336	28.336756	5.0650240	19.7809719	53.18275
Alameda County	4337	12.544000	2.7200000	51.9360000	67.20000
Alameda County	4338.01	8.730159	13.3786848	46.6269841	68.73583
Alameda County	4338.02	7.905138	12.5784701	20.8323646	41.31597
Alameda County	4339	8.668429	26.3253096	42.5490469	77.54279
Alameda County	4340	17.615176	13.1436314	45.1993806	75.95819
Alameda County	4351.02	24.751507	14.4696106	26.9675737	66.18869
Alameda County	4351.03	34.718292	7.3964497	6.2644713	48.37921
Alameda County	4351.04	15.387981	7.3803967	30.8634772	53.63186
Alameda County	4352	23.090166	22.3585109	27.1357865	72.58446
Alameda County	4353	22.194514	15.1288446	33.7073982	71.03076
Alameda County	4354	23.236926	15.7884311	32.5673534	71.59271
Alameda County	4355	26.438719	12.5692271	47.8208524	86.82880
Alameda County	4356.01	12.222426	10.3872270	56.7443568	79.35401
Alameda County	4356.02	19.802504	13.4544172	52.3717157	85.62864
Alameda County	4357	21.062461	2.4278896	50.0933804	73.58373
Alameda County	4358	20.766661	4.5014946	38.4737120	63.74187
Alameda County	4359	28.827977	0.6616257	24.9149338	54.40454
Alameda County	4360	27.082519	0.6061791	40.4184591	68.10716
Alameda County	4361	16.860364	4.3538595	32.1422376	53.35646
Alameda County	4362	10.586240	12.7906977	63.7354651	87.11240
Alameda County	4363.01	6.184586	10.7516651	45.9181732	62.85442
Alameda County	4363.02	17.090539	11.7243133	45.6002035	74.41506
Alameda County	4364.02	40.476191	13.7648810	23.8095238	78.05060
Alameda County	4364.03	26.532419	9.3826068	25.7800398	61.69507
Alameda County	4364.04	44.616337	11.2933168	21.4418317	77.35149
Alameda County	4365	13.027037	9.6048402	48.7615806	71.39346
Alameda County	4366.01	10.807959	10.6119988	57.5520048	78.97196
Alameda County	4366.02	6.565176	6.1655566	53.3016175	66.03235
Alameda County	4367	11.345411	13.3056133	47.6091476	72.26017
Alameda County	4368	10.891325	5.9342231	49.3803622	66.20591
Alameda County	4369	12.119319	6.9654849	57.5823833	76.66719
Alameda County	4370	21.607606	5.7908384	37.7412849	65.13973
Alameda County	4371.01	10.263819	6.2688442	27.4371859	43.96985
Alameda County	4371.02	9.804801	6.9104779	42.4949518	59.21023
Alameda County	4372	11.412083	6.4303380	32.0221411	49.86456
Alameda County	4373	12.854864	12.2169059	33.5247209	58.59649
Alameda County	4374	15.269220	3.7503349	52.4243236	71.44388
Alameda County	4375	11.049856	5.8964525	55.9683605	72.91467
Alameda County	4376	11.461650	9.4645441	31.2590449	52.18524
Alameda County	4377.01	9.952738	15.6241312	49.6524882	75.22936
Alameda County	4377.02	5.541237	1.9072165	85.0000000	92.44845
Alameda County	4378	15.344130	7.6923077	37.0850202	60.12146
Alameda County	4379	11.811024	11.3188976	40.9448819	64.07480
Alameda County	4380	23.017833	11.4677641	22.7434842	57.22908
Alameda County	4381	12.284672	6.3120835	36.8791651	55.47592
Alameda County	4382.01	7.354443	5.6179775	55.8120531	68.78447
Alameda County	4382.03	24.737228	3.6176974	21.0217551	49.37668
Alameda County	4382.04	9.480458	4.0339036	35.7400722	49.25443
Alameda County	4383	5.950244	6.4631957	37.3172608	49.73070
Alameda County	4384	15.612130	10.8573568	24.1108199	50.58031
Alameda County	4401	40.473506	5.1860203	20.6689215	66.32845
Alameda County	4402	2.623648	0.4609112	70.3953200	73.47988
Alameda County	4403.01	28.668363	5.7393271	33.6160588	68.02375
Alameda County	4403.04	10.338910	7.9365079	12.1621622	30.43758
Alameda County	4403.05	21.136811	1.2795276	13.5580709	35.97441
Alameda County	4403.06	9.136520	5.8885661	11.0113546	26.03644
Alameda County	4403.07	13.635349	5.7799598	21.4237893	40.83910
Alameda County	4403.08	12.759940	4.1091333	25.9690567	42.83813
Alameda County	4403.31	11.538462	3.7851038	15.8730159	31.19658
Alameda County	4403.32	8.054949	1.5610365	8.4608180	18.07680
Alameda County	4403.33	7.101025	0.8052709	5.3440703	13.25037
Alameda County	4403.34	10.640930	5.7658995	12.7196239	29.12645
Alameda County	4403.36	14.689265	12.5706215	10.1694915	37.42938
Alameda County	4403.37	5.504909	4.9088359	9.0813464	19.49509
Alameda County	4403.38	22.295482	0.4884005	9.4261294	32.21001
Alameda County	4411	44.084629	0.0431779	15.9542314	60.08204
Alameda County	4412	31.901006	2.5972260	12.2382377	46.73647
Alameda County	4413.01	19.909910	10.9009009	7.3873874	38.19820
Alameda County	4413.02	15.751544	2.7110501	11.3589568	29.82155
Alameda County	4414.01	17.565240	1.1524705	9.8291164	28.54683
Alameda County	4414.02	17.664671	1.2724551	7.1669162	26.10404
Alameda County	4415.01	8.247423	5.0148524	5.0148524	18.27713
Alameda County	4415.03	7.254585	0.2427184	4.3149946	11.81230
Alameda County	4415.21	11.419548	0.2493351	5.5186170	17.18750
Alameda County	4415.22	18.123223	2.6161137	6.9004739	27.63981
Alameda County	4415.23	11.397749	4.1979362	6.5666041	22.16229
Alameda County	4415.24	5.229871	0.3648747	0.9973243	6.59207
Alameda County	4415.25	6.862133	3.4934498	11.2913288	21.64691
Alameda County	4416.01	31.105991	8.1692501	14.3485547	53.62380
Alameda County	4416.02	27.513650	8.4565188	23.1855107	59.15568
Alameda County	4417.01	11.714727	0.4634398	19.9279094	32.10608
Alameda County	4417.02	18.582490	10.0059559	16.2001191	44.78856
Alameda County	4418	32.324046	1.7716218	5.5725560	39.66822
Alameda County	4419.21	18.550273	0.3117693	24.0062354	42.86828
Alameda County	4419.23	12.013156	3.4100744	12.9825169	28.40575
Alameda County	4419.24	16.543964	1.5140992	10.3903320	28.44840
Alameda County	4419.26	12.826603	3.2541568	24.6555819	40.73634
Alameda County	4419.27	19.413573	3.7361078	10.1205959	33.27028
Alameda County	4419.28	16.782655	13.1959315	7.8158458	37.79443
Alameda County	4419.29	21.442559	0.8485640	7.7349869	30.02611
Alameda County	4420	14.702920	0.1342732	9.8019470	24.63914
Alameda County	4421	8.710344	1.5956448	1.2201990	11.52619
Alameda County	4422	12.998766	2.4269848	5.8412176	21.26697
Alameda County	4423.01	19.659070	2.3716880	14.7118770	36.74263
Alameda County	4423.02	14.565147	5.6579373	15.3249273	35.54801
Alameda County	4424	24.513012	1.7453639	24.9493533	51.20773
Alameda County	4425.01	13.353658	3.1707317	28.2012195	44.72561
Alameda County	4425.02	17.485773	4.2421107	29.7206415	51.44853
Alameda County	4426.01	27.777778	3.4658512	27.8032620	59.04689
Alameda County	4426.02	29.251555	10.3795840	17.4136822	57.04482
Alameda County	4427	30.136986	1.0512902	11.3411915	42.52947
Alameda County	4428	24.141252	0.7383628	15.5377207	40.41734
Alameda County	4429	15.141388	5.1542416	13.4961440	33.79177
Alameda County	4430.01	17.994207	4.8877625	32.1506155	55.03259
Alameda County	4430.02	15.684195	1.7426883	17.4723443	34.89923
Alameda County	4431.02	10.568937	0.0000000	5.8970100	16.46595
Alameda County	4431.03	18.787879	1.2121212	3.3212121	23.32121
Alameda County	4431.04	13.508173	6.2690857	2.0298186	21.80708
Alameda County	4431.05	10.475578	0.4284490	2.1208226	13.02485
Alameda County	4432	14.289670	0.3046248	1.0246469	15.61894
Alameda County	4433.01	17.981359	1.0229598	8.8656513	27.86997
Alameda County	4433.21	3.143535	1.6903915	7.0284698	11.86240
Alameda County	4433.22	18.755663	1.0872848	6.7049230	26.54787
Alameda County	4441	28.900291	6.6148939	24.8370545	60.35224
Alameda County	4442	21.380124	1.3417871	30.2123267	52.93424
Alameda County	4443.01	29.367225	0.7571660	25.8518118	55.97620
Alameda County	4443.03	NaN	NaN	NaN	NaN
Alameda County	4443.04	12.281523	0.8114856	31.9132335	45.00624
Alameda County	4444	14.719583	2.8693870	53.6612633	71.25023
Alameda County	4445	18.417287	4.6078993	44.3474528	67.37264
Alameda County	4446.01	16.707778	1.2004605	18.0726854	35.98092
Alameda County	4446.02	15.440729	5.8156028	10.1925025	31.44883
Alameda County	4501.01	22.679064	2.9638239	7.9325875	33.57548
Alameda County	4501.02	19.360087	14.8318872	13.7608460	47.95282
Alameda County	4502	40.079666	3.5660091	9.2185129	52.86419
Alameda County	4503	47.301824	6.2709341	15.4819501	69.05471
Alameda County	4504	35.379153	3.7915293	18.6659904	57.83667
Alameda County	4505.01	53.617647	0.0000000	13.1764706	66.79412
Alameda County	4505.02	41.525694	0.6543249	8.8892435	51.06926
Alameda County	4506.01	47.326787	0.7364975	6.7648663	54.82815
Alameda County	4506.03	42.168675	0.4288340	15.0296100	57.62712
Alameda County	4506.04	53.074304	0.4406169	13.1383938	66.65331
Alameda County	4506.05	49.108548	0.2621919	8.9145254	58.28526
Alameda County	4506.06	49.950232	0.0000000	4.9933643	54.94360
Alameda County	4506.07	32.863759	1.7174836	14.5310691	49.11231
Alameda County	4506.08	41.326750	1.6745384	7.6642336	50.66552
Alameda County	4506.09	48.214286	2.0292208	13.8189935	64.06250
Alameda County	4507.01	45.193408	1.6594186	7.0840009	53.93683
Alameda County	4507.41	45.019157	1.1842564	21.3862766	67.58969
Alameda County	4507.42	48.626024	0.1819836	9.1537762	57.96178
Alameda County	4507.43	19.986550	7.9085407	12.6967048	40.59180
Alameda County	4507.44	46.974905	0.0000000	13.0113441	59.98625
Alameda County	4507.45	33.248610	0.4447975	6.9261319	40.61954
Alameda County	4507.46	46.639827	0.4335708	18.5816042	65.65500
Alameda County	4507.50	19.539224	3.5578886	6.8970545	29.99417
Alameda County	4507.51	12.636234	2.6851998	5.1966514	20.51809
Alameda County	4507.52	14.474094	2.3673554	7.1124494	23.95390
Alameda County	4511.02	73.518987	0.5063291	7.3417722	81.36709
Alameda County	4511.03	86.260103	1.7634093	11.9764879	100.00000
Alameda County	4511.04	54.020100	0.0418760	17.9927415	72.05472
Alameda County	4512.01	47.826661	1.6382613	24.8513674	74.31629
Alameda County	4512.02	44.983583	0.9303174	16.8734039	62.78730
Alameda County	4513	53.902706	1.2200845	26.5290161	81.65181
Alameda County	4514.01	39.344794	5.3519299	38.0149205	82.71164
Alameda County	4514.03	58.424908	1.6025641	23.4432234	83.47070
Alameda County	4514.04	31.639270	1.0556477	59.0559493	91.75087
Alameda County	4515.01	59.163701	5.0711744	14.2793594	78.51423
Alameda County	4515.03	50.999345	0.5897772	19.8722149	71.46134
Alameda County	4515.04	45.873944	0.0000000	26.6406758	72.51462
Alameda County	4515.05	66.318455	1.0129788	12.7255461	80.05698
Alameda County	4515.06	37.260428	3.9740699	36.4712514	77.70575
Alameda County	4516.01	70.318614	0.0000000	9.2602944	79.57891
Alameda County	4516.02	65.450861	2.2000289	18.9752497	86.62614
Alameda County	4517.01	54.325613	4.2574932	12.5681199	71.15123
Alameda County	4517.03	60.543507	0.7316436	13.2218448	74.49699
Alameda County	4517.04	69.467593	0.2314815	12.0138889	81.71296
Alameda County	9819	60.000000	0.0000000	40.0000000	100.00000
Alameda County	9820	50.000000	10.0000000	0.0000000	60.00000
Alameda County	9821	28.277356	8.8840737	18.4182015	55.57963
Alameda County	9832	54.129464	13.8392857	4.7991071	72.76786
Alameda County	9900	NaN	NaN	NaN	NaN
Alpine County	100	58.085809	0.0000000	14.0594059	72.14521
Amador County	1.01	79.902189	0.4424779	13.1113181	93.45599
Amador County	1.02	85.138889	0.3240741	8.4259259	93.88889
Amador County	2.01	85.739878	0.7165890	9.8530992	96.30957
Amador County	2.02	73.179872	2.3019272	14.1862955	89.66809
Amador County	3.01	45.885691	9.8905553	36.1370085	91.91326
Amador County	3.03	80.219441	0.0927214	9.1639623	89.47612
Amador County	3.04	77.562274	0.7986309	10.4962921	88.85720
Amador County	4.01	78.949672	0.7002188	7.7242888	87.37418
Amador County	4.02	78.242851	0.1657688	15.8101948	94.21881
Amador County	5	71.827262	0.0881316	23.8249119	95.74031

3.3 Demographic Analysis

Your Task: Analyze the demographic patterns in your selected areas.

# Find the tract with the highest percentage of Hispanic/Latino residents
# Hint: use arrange() and slice() to get the top tract
hisp_high <- percentage_eachgroup %>%
  arrange(desc(`Hispanic or Latino %`))%>%
  slice_head(n=1)%>%
  select(County,`Hispanic or Latino %`)
tibble(hisp_high)%>%
  kable()

County	Hispanic or Latino %
Alameda County	85

# Calculate average demographics by county using group_by() and summarize()
# Show: number of tracts, average percentage for each racial/ethnic group
county_summary <- percentage_eachgroup %>%
  group_by(County)%>%
  summarise(`Number of Tracts`=n(),
            `Average White Percentage` = mean(`White %`, na.rm = TRUE),
            `Average Black Percentage` = mean(`Black %`, na.rm = TRUE),
            `Average Hispanic Percentage` = mean(`Hispanic or Latino %`, na.rm = TRUE)
    
  )%>%
  select(
    County,
    `Number of Tracts`,
    `Average White Percentage`,
    `Average Black Percentage`,
    `Average Hispanic Percentage`
    )
tibble(county_summary)%>% 
  kable()

County	Number of Tracts	Average White Percentage	Average Black Percentage	Average Hispanic Percentage
Alameda County	379	31.03341	10.70641	21.38505
Alpine County	1	58.08581	0.00000	14.05941
Amador County	10	75.66480	1.55211	14.87333

# Create a nicely formatted table of your results using kable()

Part 4: Comprehensive Data Quality Evaluation

4.1 MOE Analysis for Demographic Variables

Your Task: Examine margins of error for demographic variables to see if some communities have less reliable data.

Requirements: - Calculate MOE percentages for each demographic variable - Flag tracts where any demographic variable has MOE > 15% - Create summary statistics

# Calculate MOE percentages for white, Black, and Hispanic variables
# Hint: use the same formula as before (margin/estimate * 100)
moe_race <- selected_counties_data %>%
  mutate(
    `MOE % White` = (`White AloneM` / `White AloneE`)*100,
    `MOE % Black` = (`Black/African AmericanM` / `Black/African AmericanE`)*100,
    `MOE % Hispanic` = (`Hispanic/LatinoM` / `Hispanic/LatinoE`)*100,

# Create a flag for tracts with high MOE on any demographic variable
# Use logical operators (| for OR) in an ifelse() statement
Flag = ifelse(
     `MOE % White` > 15 | `MOE % Black` > 15 | `MOE % Hispanic` > 15, "UNRELIABLE", "  ")
    )
tibble(moe_race)%>%
  kable()

GEOID	NAME	White AloneE	White AloneM	Black/African AmericanE	Black/African AmericanM	Hispanic/LatinoE	Hispanic/LatinoM	Total PopulationE	Total PopulationM	MOE % White	MOE % Black	MOE % Hispanic	Flag
06001400100	Census Tract 4001; Alameda County; California	2255	444	171	120	167	94	3269	452	19.689579	70.17544	56.28743	UNRELIABLE
06001400200	Census Tract 4002; Alameda County; California	1500	219	38	36	159	98	2147	201	14.600000	94.73684	61.63522	UNRELIABLE
06001400300	Census Tract 4003; Alameda County; California	3290	378	529	216	568	303	5619	571	11.489362	40.83176	53.34507	UNRELIABLE
06001400400	Census Tract 4004; Alameda County; California	2740	606	499	271	306	150	4278	598	22.116788	54.30862	49.01961	UNRELIABLE
06001400500	Census Tract 4005; Alameda County; California	1638	262	993	680	612	212	3949	737	15.995116	68.47936	34.64052	UNRELIABLE
06001400600	Census Tract 4006; Alameda County; California	905	183	539	182	134	62	2058	301	20.220994	33.76623	46.26866	UNRELIABLE
06001400700	Census Tract 4007; Alameda County; California	2293	422	1101	293	470	185	4758	572	18.403838	26.61217	39.36170	UNRELIABLE
06001400800	Census Tract 4008; Alameda County; California	2228	462	643	185	387	202	4335	593	20.736086	28.77138	52.19638	UNRELIABLE
06001400900	Census Tract 4009; Alameda County; California	1052	266	692	304	533	331	2844	496	25.285171	43.93064	62.10131	UNRELIABLE
06001401000	Census Tract 4010; Alameda County; California	2095	531	1478	737	1389	621	6277	896	25.346062	49.86468	44.70842	UNRELIABLE
06001401100	Census Tract 4011; Alameda County; California	2325	455	906	411	658	274	5537	544	19.569893	45.36424	41.64134	UNRELIABLE
06001401200	Census Tract 4012; Alameda County; California	1718	307	239	136	387	144	2994	329	17.869616	56.90377	37.20930	UNRELIABLE
06001401300	Census Tract 4013; Alameda County; California	1657	307	1325	370	393	148	4608	404	18.527459	27.92453	37.65903	UNRELIABLE
06001401400	Census Tract 4014; Alameda County; California	1380	257	1716	418	1175	484	5392	777	18.623188	24.35897	41.19149	UNRELIABLE
06001401500	Census Tract 4015; Alameda County; California	662	167	1666	581	467	264	3035	613	25.226586	34.87395	56.53105	UNRELIABLE
06001401600	Census Tract 4016; Alameda County; California	446	132	788	208	697	319	2403	385	29.596413	26.39594	45.76758	UNRELIABLE
06001401700	Census Tract 4017; Alameda County; California	1487	342	452	295	549	236	3276	493	22.999327	65.26549	42.98725	UNRELIABLE
06001401800	Census Tract 4018; Alameda County; California	417	114	649	166	454	226	1709	273	27.338130	25.57781	49.77974	UNRELIABLE
06001402200	Census Tract 4022; Alameda County; California	747	203	647	272	537	198	2337	393	27.175368	42.04019	36.87151	UNRELIABLE
06001402400	Census Tract 4024; Alameda County; California	349	166	1432	443	228	155	2623	532	47.564470	30.93575	67.98246	UNRELIABLE
06001402500	Census Tract 4025; Alameda County; California	314	239	878	326	235	183	2010	363	76.114650	37.12984	77.87234	UNRELIABLE
06001402600	Census Tract 4026; Alameda County; California	123	53	500	187	76	74	1300	263	43.089431	37.40000	97.36842	UNRELIABLE
06001402700	Census Tract 4027; Alameda County; California	523	196	763	240	347	189	2039	376	37.476099	31.45478	54.46686	UNRELIABLE
06001402801	Census Tract 4028.01; Alameda County; California	869	225	1411	550	148	83	3254	626	25.891830	38.97945	56.08108	UNRELIABLE
06001402802	Census Tract 4028.02; Alameda County; California	329	199	613	255	51	67	1430	248	60.486322	41.59869	131.37255	UNRELIABLE
06001402900	Census Tract 4029; Alameda County; California	365	105	408	147	182	76	1828	259	28.767123	36.02941	41.75824	UNRELIABLE
06001403000	Census Tract 4030; Alameda County; California	250	116	146	183	62	50	2897	466	46.400000	125.34247	80.64516	UNRELIABLE
06001403100	Census Tract 4031; Alameda County; California	767	201	323	137	241	72	1941	284	26.205997	42.41486	29.87552	UNRELIABLE
06001403301	Census Tract 4033.01; Alameda County; California	187	185	51	51	38	34	1830	382	98.930481	100.00000	89.47368	UNRELIABLE
06001403302	Census Tract 4033.02; Alameda County; California	1317	293	123	96	158	105	2556	318	22.247532	78.04878	66.45570	UNRELIABLE
06001403401	Census Tract 4034.01; Alameda County; California	1154	281	447	202	238	143	2717	387	24.350087	45.19016	60.08403	UNRELIABLE
06001403402	Census Tract 4034.02; Alameda County; California	493	166	172	117	135	90	1134	175	33.671400	68.02326	66.66667	UNRELIABLE
06001403501	Census Tract 4035.01; Alameda County; California	1874	607	740	228	387	219	4904	684	32.390608	30.81081	56.58915	UNRELIABLE
06001403502	Census Tract 4035.02; Alameda County; California	939	180	221	130	324	128	1919	262	19.169329	58.82353	39.50617	UNRELIABLE
06001403600	Census Tract 4036; Alameda County; California	1933	391	1174	326	857	275	5056	687	20.227625	27.76831	32.08868	UNRELIABLE
06001403701	Census Tract 4037.01; Alameda County; California	1222	298	632	263	305	104	2909	348	24.386252	41.61392	34.09836	UNRELIABLE
06001403702	Census Tract 4037.02; Alameda County; California	1224	247	369	178	244	135	2238	262	20.179739	48.23848	55.32787	UNRELIABLE
06001403800	Census Tract 4038; Alameda County; California	2471	307	606	330	288	127	4008	438	12.424120	54.45545	44.09722	UNRELIABLE
06001403900	Census Tract 4039; Alameda County; California	2436	599	360	204	433	245	3883	701	24.589491	56.66667	56.58199	UNRELIABLE
06001404000	Census Tract 4040; Alameda County; California	1597	335	377	198	615	217	3145	395	20.976832	52.51989	35.28455	UNRELIABLE
06001404101	Census Tract 4041.01; Alameda County; California	2365	348	269	145	141	85	3208	349	14.714588	53.90335	60.28369	UNRELIABLE
06001404102	Census Tract 4041.02; Alameda County; California	1430	201	155	101	293	141	2701	352	14.055944	65.16129	48.12287	UNRELIABLE
06001404200	Census Tract 4042; Alameda County; California	2606	436	192	208	286	160	3894	388	16.730622	108.33333	55.94406	UNRELIABLE
06001404300	Census Tract 4043; Alameda County; California	2696	388	46	46	214	130	3587	368	14.391691	100.00000	60.74766	UNRELIABLE
06001404400	Census Tract 4044; Alameda County; California	3417	503	142	108	182	111	5823	604	14.720515	76.05634	60.98901	UNRELIABLE
06001404501	Census Tract 4045.01; Alameda County; California	1197	199	94	67	116	75	1820	205	16.624896	71.27660	64.65517	UNRELIABLE
06001404502	Census Tract 4045.02; Alameda County; California	4030	641	353	237	326	143	6110	776	15.905707	67.13881	43.86503	UNRELIABLE
06001404600	Census Tract 4046; Alameda County; California	2872	325	263	227	216	138	4934	605	11.316156	86.31179	63.88889	UNRELIABLE
06001404700	Census Tract 4047; Alameda County; California	1477	245	100	56	198	99	2187	262	16.587678	56.00000	50.00000	UNRELIABLE
06001404800	Census Tract 4048; Alameda County; California	1444	335	315	224	275	148	2744	404	23.199446	71.11111	53.81818	UNRELIABLE
06001404900	Census Tract 4049; Alameda County; California	2530	305	283	167	764	301	4669	462	12.055336	59.01060	39.39791	UNRELIABLE
06001405000	Census Tract 4050; Alameda County; California	2086	328	493	175	376	192	3665	329	15.723873	35.49696	51.06383	UNRELIABLE
06001405100	Census Tract 4051; Alameda County; California	2986	389	255	88	305	125	4508	405	13.027461	34.50980	40.98361	UNRELIABLE
06001405200	Census Tract 4052; Alameda County; California	1670	331	680	277	305	138	4913	1030	19.820359	40.73529	45.24590	UNRELIABLE
06001405301	Census Tract 4053.01; Alameda County; California	1394	306	400	269	480	154	2872	474	21.951220	67.25000	32.08333	UNRELIABLE
06001405302	Census Tract 4053.02; Alameda County; California	876	242	596	192	159	117	2559	347	27.625571	32.21477	73.58491	UNRELIABLE
06001405401	Census Tract 4054.01; Alameda County; California	894	242	444	132	834	336	3541	471	27.069351	29.72973	40.28777	UNRELIABLE
06001405402	Census Tract 4054.02; Alameda County; California	746	346	561	212	862	511	3673	638	46.380697	37.78966	59.28074	UNRELIABLE
06001405500	Census Tract 4055; Alameda County; California	756	151	690	387	520	191	3537	503	19.973545	56.08696	36.73077	UNRELIABLE
06001405600	Census Tract 4056; Alameda County; California	941	204	524	227	677	281	3044	524	21.679065	43.32061	41.50665	UNRELIABLE
06001405700	Census Tract 4057; Alameda County; California	530	148	985	412	876	433	3522	549	27.924528	41.82741	49.42922	UNRELIABLE
06001405800	Census Tract 4058; Alameda County; California	494	218	850	456	864	332	4182	682	44.129555	53.64706	38.42593	UNRELIABLE
06001405901	Census Tract 4059.01; Alameda County; California	189	98	643	350	1266	611	3757	624	51.851852	54.43235	48.26224	UNRELIABLE
06001405902	Census Tract 4059.02; Alameda County; California	389	196	234	96	916	250	3138	431	50.385604	41.02564	27.29258	UNRELIABLE
06001406000	Census Tract 4060; Alameda County; California	830	261	910	436	963	278	4735	518	31.445783	47.91209	28.86812	UNRELIABLE
06001406100	Census Tract 4061; Alameda County; California	897	217	438	266	2345	519	4939	600	24.191750	60.73059	22.13220	UNRELIABLE
06001406201	Census Tract 4062.01; Alameda County; California	284	155	695	327	2455	680	5072	747	54.577465	47.05036	27.69857	UNRELIABLE
06001406202	Census Tract 4062.02; Alameda County; California	316	168	592	287	2955	692	4733	671	53.164557	48.47973	23.41794	UNRELIABLE
06001406300	Census Tract 4063; Alameda County; California	482	183	880	457	1590	524	4556	743	37.966805	51.93182	32.95597	UNRELIABLE
06001406400	Census Tract 4064; Alameda County; California	609	147	430	136	816	551	2598	542	24.137931	31.62791	67.52451	UNRELIABLE
06001406500	Census Tract 4065; Alameda County; California	777	228	861	386	3183	755	6494	812	29.343629	44.83159	23.71976	UNRELIABLE
06001406601	Census Tract 4066.01; Alameda County; California	1034	277	1302	429	1069	340	4531	661	26.789168	32.94931	31.80543	UNRELIABLE
06001406602	Census Tract 4066.02; Alameda County; California	344	112	567	248	866	308	2540	401	32.558140	43.73898	35.56582	UNRELIABLE
06001406700	Census Tract 4067; Alameda County; California	2465	481	366	235	919	340	5380	695	19.513185	64.20765	36.99674	UNRELIABLE
06001406800	Census Tract 4068; Alameda County; California	1127	226	833	515	965	239	3971	510	20.053239	61.82473	24.76684	UNRELIABLE
06001406900	Census Tract 4069; Alameda County; California	1533	263	656	327	323	125	3865	546	17.155904	49.84756	38.69969	UNRELIABLE
06001407000	Census Tract 4070; Alameda County; California	1135	388	970	361	2257	737	6202	893	34.185022	37.21649	32.65397	UNRELIABLE
06001407101	Census Tract 4071.01; Alameda County; California	471	187	749	470	1640	625	4053	794	39.702760	62.75033	38.10976	UNRELIABLE
06001407102	Census Tract 4071.02; Alameda County; California	320	116	1011	554	1591	486	4268	900	36.250000	54.79723	30.54683	UNRELIABLE
06001407200	Census Tract 4072; Alameda County; California	920	419	211	124	4626	924	6544	798	45.543478	58.76777	19.97406	UNRELIABLE
06001407300	Census Tract 4073; Alameda County; California	268	118	207	118	1604	359	2459	430	44.029851	57.00483	22.38155	UNRELIABLE
06001407400	Census Tract 4074; Alameda County; California	253	108	1548	655	1882	454	4242	669	42.687747	42.31266	24.12327	UNRELIABLE
06001407500	Census Tract 4075; Alameda County; California	280	228	910	317	1912	409	3988	662	81.428571	34.83516	21.39121	UNRELIABLE
06001407600	Census Tract 4076; Alameda County; California	1637	626	1617	555	2189	545	6459	849	38.240684	34.32282	24.89721	UNRELIABLE
06001407700	Census Tract 4077; Alameda County; California	1896	444	897	291	769	304	4238	419	23.417721	32.44147	39.53186	UNRELIABLE
06001407800	Census Tract 4078; Alameda County; California	989	211	602	221	671	253	2769	334	21.334681	36.71096	37.70492	UNRELIABLE
06001407900	Census Tract 4079; Alameda County; California	1530	296	398	261	396	189	3088	376	19.346405	65.57789	47.72727	UNRELIABLE
06001408000	Census Tract 4080; Alameda County; California	1736	382	235	171	326	127	2860	395	22.004608	72.76596	38.95706	UNRELIABLE
06001408100	Census Tract 4081; Alameda County; California	2731	393	1828	585	539	199	7313	718	14.390333	32.00219	36.92022	UNRELIABLE
06001408200	Census Tract 4082; Alameda County; California	752	166	1811	503	1300	522	4471	684	22.074468	27.77471	40.15385	UNRELIABLE
06001408300	Census Tract 4083; Alameda County; California	1046	197	1827	503	1007	197	4791	599	18.833652	27.53147	19.56306	UNRELIABLE
06001408400	Census Tract 4084; Alameda County; California	181	149	1610	347	1922	539	4077	613	82.320442	21.55279	28.04370	UNRELIABLE
06001408500	Census Tract 4085; Alameda County; California	149	192	2216	684	2783	753	5634	1069	128.859060	30.86643	27.05713	UNRELIABLE
06001408600	Census Tract 4086; Alameda County; California	398	297	2818	769	2695	644	6519	950	74.623116	27.28886	23.89610	UNRELIABLE
06001408700	Census Tract 4087; Alameda County; California	673	364	2414	544	3788	886	7456	1271	54.086181	22.53521	23.38965	UNRELIABLE
06001408800	Census Tract 4088; Alameda County; California	328	250	2723	733	3644	1165	7968	1019	76.219512	26.91884	31.97036	UNRELIABLE
06001408900	Census Tract 4089; Alameda County; California	171	125	836	215	2694	574	3956	536	73.099415	25.71770	21.30661	UNRELIABLE
06001409000	Census Tract 4090; Alameda County; California	165	103	1477	478	2960	1184	5039	1118	62.424242	32.36290	40.00000	UNRELIABLE
06001409100	Census Tract 4091; Alameda County; California	256	225	516	206	1559	223	2532	369	87.890625	39.92248	14.30404	UNRELIABLE
06001409200	Census Tract 4092; Alameda County; California	45	36	987	285	2249	587	3615	486	80.000000	28.87538	26.10049	UNRELIABLE
06001409300	Census Tract 4093; Alameda County; California	129	91	1357	421	3769	748	5743	681	70.542636	31.02432	19.84611	UNRELIABLE
06001409400	Census Tract 4094; Alameda County; California	217	136	851	427	3107	894	4710	892	62.672811	50.17626	28.77374	UNRELIABLE
06001409500	Census Tract 4095; Alameda County; California	505	441	759	309	2755	599	4291	648	87.326733	40.71146	21.74229	UNRELIABLE
06001409600	Census Tract 4096; Alameda County; California	172	112	1247	440	3599	615	5139	663	65.116279	35.28468	17.08808	UNRELIABLE
06001409700	Census Tract 4097; Alameda County; California	424	208	1875	490	1906	414	5240	1012	49.056604	26.13333	21.72088	UNRELIABLE
06001409800	Census Tract 4098; Alameda County; California	618	233	1762	387	529	320	3511	594	37.702265	21.96368	60.49149	UNRELIABLE
06001409900	Census Tract 4099; Alameda County; California	926	224	1635	451	536	285	3983	563	24.190065	27.58410	53.17164	UNRELIABLE
06001410000	Census Tract 4100; Alameda County; California	1038	212	1502	493	158	94	3177	536	20.423892	32.82290	59.49367	UNRELIABLE
06001410100	Census Tract 4101; Alameda County; California	310	172	1645	308	564	188	3172	401	55.483871	18.72340	33.33333	UNRELIABLE
06001410200	Census Tract 4102; Alameda County; California	343	172	1432	355	1205	481	3238	501	50.145773	24.79050	39.91701	UNRELIABLE
06001410300	Census Tract 4103; Alameda County; California	79	48	642	208	3044	456	3893	418	60.759494	32.39875	14.98029	UNRELIABLE
06001410400	Census Tract 4104; Alameda County; California	218	121	1465	371	2415	717	4687	823	55.504587	25.32423	29.68944	UNRELIABLE
06001410500	Census Tract 4105; Alameda County; California	662	334	1814	319	373	241	3081	417	50.453172	17.58545	64.61126	UNRELIABLE
06001420100	Census Tract 4201; Alameda County; California	1426	222	122	130	350	156	2631	296	15.568022	106.55738	44.57143	UNRELIABLE
06001420200	Census Tract 4202; Alameda County; California	1148	196	185	149	158	116	3275	408	17.073171	80.54054	73.41772	UNRELIABLE
06001420301	Census Tract 4203.01; Alameda County; California	1004	301	64	60	230	186	2645	351	29.980080	93.75000	80.86957	UNRELIABLE
06001420302	Census Tract 4203.02; Alameda County; California	849	188	287	205	171	104	2446	338	22.143698	71.42857	60.81871	UNRELIABLE
06001420401	Census Tract 4204.01; Alameda County; California	427	127	0	13	314	160	1333	213	29.742389	Inf	50.95541	UNRELIABLE
06001420402	Census Tract 4204.02; Alameda County; California	531	144	52	48	468	177	1661	244	27.118644	92.30769	37.82051	UNRELIABLE
06001420500	Census Tract 4205; Alameda County; California	1245	172	57	27	404	257	2548	254	13.815261	47.36842	63.61386	UNRELIABLE
06001420600	Census Tract 4206; Alameda County; California	2222	276	36	26	272	164	3488	343	12.421242	72.22222	60.29412	UNRELIABLE
06001421100	Census Tract 4211; Alameda County; California	1615	227	35	32	111	76	2108	230	14.055728	91.42857	68.46847	UNRELIABLE
06001421200	Census Tract 4212; Alameda County; California	2473	214	24	26	70	43	3557	542	8.653457	108.33333	61.42857	UNRELIABLE
06001421300	Census Tract 4213; Alameda County; California	2907	368	7	10	115	99	4011	406	12.659099	142.85714	86.08696	UNRELIABLE
06001421400	Census Tract 4214; Alameda County; California	1270	262	31	27	147	81	1638	268	20.629921	87.09677	55.10204	UNRELIABLE
06001421500	Census Tract 4215; Alameda County; California	3312	475	65	69	185	128	4064	530	14.341787	106.15385	69.18919	UNRELIABLE
06001421600	Census Tract 4216; Alameda County; California	2746	376	93	78	150	84	3854	570	13.692644	83.87097	56.00000	UNRELIABLE
06001421700	Census Tract 4217; Alameda County; California	2234	444	140	110	199	117	3421	446	19.874664	78.57143	58.79397	UNRELIABLE
06001421800	Census Tract 4218; Alameda County; California	1584	238	20	25	114	68	2260	266	15.025253	125.00000	59.64912	UNRELIABLE
06001421900	Census Tract 4219; Alameda County; California	2089	491	549	295	298	119	4141	550	23.504069	53.73406	39.93289	UNRELIABLE
06001422000	Census Tract 4220; Alameda County; California	1214	274	119	80	164	81	2453	264	22.570017	67.22689	49.39024	UNRELIABLE
06001422100	Census Tract 4221; Alameda County; California	1495	375	374	188	641	195	3200	359	25.083612	50.26738	30.42122	UNRELIABLE
06001422200	Census Tract 4222; Alameda County; California	2054	626	83	53	239	163	3280	612	30.477118	63.85542	68.20084	UNRELIABLE
06001422300	Census Tract 4223; Alameda County; California	1875	325	444	259	245	117	3567	477	17.333333	58.33333	47.75510	UNRELIABLE
06001422400	Census Tract 4224; Alameda County; California	1580	323	134	119	522	140	4187	757	20.443038	88.80597	26.81992	UNRELIABLE
06001422500	Census Tract 4225; Alameda County; California	1994	410	183	124	585	346	4467	572	20.561685	67.75956	59.14530	UNRELIABLE
06001422700	Census Tract 4227; Alameda County; California	1744	310	186	120	793	209	4803	496	17.775229	64.51613	26.35561	UNRELIABLE
06001422800	Census Tract 4228; Alameda County; California	2486	297	515	172	1671	404	8980	545	11.946903	33.39806	24.17714	UNRELIABLE
06001422901	Census Tract 4229.01; Alameda County; California	820	436	0	13	51	39	2024	627	53.170732	Inf	76.47059	UNRELIABLE
06001422902	Census Tract 4229.02; Alameda County; California	907	450	203	255	209	117	3022	642	49.614112	125.61576	55.98086	UNRELIABLE
06001423000	Census Tract 4230; Alameda County; California	2605	730	343	229	374	224	4549	851	28.023033	66.76385	59.89305	UNRELIABLE
06001423100	Census Tract 4231; Alameda County; California	1766	281	1015	564	434	208	4275	616	15.911665	55.56650	47.92627	UNRELIABLE
06001423200	Census Tract 4232; Alameda County; California	1176	251	527	319	1004	393	3003	520	21.343537	60.53131	39.14343	UNRELIABLE
06001423300	Census Tract 4233; Alameda County; California	1595	466	690	249	579	188	3476	588	29.216301	36.08696	32.46978	UNRELIABLE
06001423400	Census Tract 4234; Alameda County; California	2613	483	737	347	1237	336	5551	779	18.484501	47.08277	27.16249	UNRELIABLE
06001423500	Census Tract 4235; Alameda County; California	1935	297	357	193	594	329	3540	464	15.348837	54.06162	55.38721	UNRELIABLE
06001423601	Census Tract 4236.01; Alameda County; California	1715	341	102	71	358	156	2738	457	19.883382	69.60784	43.57542	UNRELIABLE
06001423602	Census Tract 4236.02; Alameda County; California	3393	1229	108	82	1006	375	7198	1437	36.221633	75.92593	37.27634	UNRELIABLE
06001423700	Census Tract 4237; Alameda County; California	2179	588	86	77	603	213	3606	591	26.984855	89.53488	35.32338	UNRELIABLE
06001423800	Census Tract 4238; Alameda County; California	2485	336	37	60	189	89	3425	337	13.521127	162.16216	47.08995	UNRELIABLE
06001423901	Census Tract 4239.01; Alameda County; California	1168	285	286	123	444	242	2258	319	24.400685	43.00699	54.50450	UNRELIABLE
06001423902	Census Tract 4239.02; Alameda County; California	1041	174	90	62	107	65	1512	198	16.714697	68.88889	60.74766	UNRELIABLE
06001424001	Census Tract 4240.01; Alameda County; California	1683	373	658	186	593	123	3631	503	22.162805	28.26748	20.74199	UNRELIABLE
06001424002	Census Tract 4240.02; Alameda County; California	1004	270	830	300	453	148	2663	323	26.892430	36.14458	32.67108	UNRELIABLE
06001425101	Census Tract 4251.01; Alameda County; California	797	139	104	92	186	166	1754	225	17.440402	88.46154	89.24731	UNRELIABLE
06001425102	Census Tract 4251.02; Alameda County; California	1170	313	507	236	399	208	3969	344	26.752137	46.54832	52.13033	UNRELIABLE
06001425103	Census Tract 4251.03; Alameda County; California	971	175	826	287	215	133	3103	340	18.022657	34.74576	61.86047	UNRELIABLE
06001425104	Census Tract 4251.04; Alameda County; California	1668	280	624	216	388	170	4014	511	16.786571	34.61538	43.81443	UNRELIABLE
06001426100	Census Tract 4261; Alameda County; California	4288	459	0	19	152	107	6300	506	10.704291	Inf	70.39474	UNRELIABLE
06001426200	Census Tract 4262; Alameda County; California	3310	465	70	71	281	153	4861	504	14.048338	101.42857	54.44840	UNRELIABLE
06001427100	Census Tract 4271; Alameda County; California	2448	334	51	35	628	285	4222	442	13.643791	68.62745	45.38217	UNRELIABLE
06001427200	Census Tract 4272; Alameda County; California	1468	245	149	107	748	209	4508	617	16.689373	71.81208	27.94118	UNRELIABLE
06001427300	Census Tract 4273; Alameda County; California	1673	366	859	746	430	159	5283	882	21.876868	86.84517	36.97674	UNRELIABLE
06001427600	Census Tract 4276; Alameda County; California	1352	362	738	230	733	284	4740	524	26.775148	31.16531	38.74488	UNRELIABLE
06001427700	Census Tract 4277; Alameda County; California	3052	847	107	80	530	229	5009	796	27.752294	74.76636	43.20755	UNRELIABLE
06001427800	Census Tract 4278; Alameda County; California	2198	327	187	111	402	215	4274	458	14.877161	59.35829	53.48259	UNRELIABLE
06001427900	Census Tract 4279; Alameda County; California	2441	640	31	43	645	200	4686	689	26.218763	138.70968	31.00775	UNRELIABLE
06001428000	Census Tract 4280; Alameda County; California	925	289	350	263	409	259	2906	544	31.243243	75.14286	63.32518	UNRELIABLE
06001428100	Census Tract 4281; Alameda County; California	2495	495	332	231	470	208	4866	701	19.839679	69.57831	44.25532	UNRELIABLE
06001428200	Census Tract 4282; Alameda County; California	3329	544	215	160	852	226	6475	608	16.341244	74.41860	26.52582	UNRELIABLE
06001428301	Census Tract 4283.01; Alameda County; California	1874	561	368	353	684	479	7203	898	29.935966	95.92391	70.02924	UNRELIABLE
06001428302	Census Tract 4283.02; Alameda County; California	3110	557	61	82	480	266	7022	767	17.909968	134.42623	55.41667	UNRELIABLE
06001428400	Census Tract 4284; Alameda County; California	1763	264	343	217	783	276	4756	619	14.974475	63.26531	35.24904	UNRELIABLE
06001428500	Census Tract 4285; Alameda County; California	1376	293	361	270	538	233	3302	393	21.293605	74.79224	43.30855	UNRELIABLE
06001428600	Census Tract 4286; Alameda County; California	1374	362	193	92	362	174	3235	443	26.346434	47.66839	48.06630	UNRELIABLE
06001428700	Census Tract 4287; Alameda County; California	1147	225	899	408	683	248	5078	522	19.616391	45.38376	36.31040	UNRELIABLE
06001430101	Census Tract 4301.01; Alameda County; California	2381	733	206	137	698	289	7034	851	30.785384	66.50485	41.40401	UNRELIABLE
06001430102	Census Tract 4301.02; Alameda County; California	1314	184	22	19	355	159	2459	224	14.003044	86.36364	44.78873	UNRELIABLE
06001430200	Census Tract 4302; Alameda County; California	3950	582	266	166	780	367	7713	712	14.734177	62.40601	47.05128	UNRELIABLE
06001430300	Census Tract 4303; Alameda County; California	1880	333	21	24	1049	343	4290	625	17.712766	114.28571	32.69781	UNRELIABLE
06001430400	Census Tract 4304; Alameda County; California	1004	149	92	69	142	72	2155	248	14.840637	75.00000	50.70423	UNRELIABLE
06001430500	Census Tract 4305; Alameda County; California	1507	389	2328	1130	970	233	6250	1034	25.812873	48.53952	24.02062	UNRELIABLE
06001430600	Census Tract 4306; Alameda County; California	2404	797	245	207	1002	397	6244	965	33.153078	84.48980	39.62076	UNRELIABLE
06001430700	Census Tract 4307; Alameda County; California	1575	244	203	168	741	185	4085	406	15.492064	82.75862	24.96626	UNRELIABLE
06001430800	Census Tract 4308; Alameda County; California	2472	439	49	51	943	679	5814	739	17.758900	104.08163	72.00424	UNRELIABLE
06001430900	Census Tract 4309; Alameda County; California	1463	377	338	188	1475	695	5214	713	25.768968	55.62130	47.11864	UNRELIABLE
06001431000	Census Tract 4310; Alameda County; California	820	204	504	345	492	281	3091	481	24.878049	68.45238	57.11382	UNRELIABLE
06001431100	Census Tract 4311; Alameda County; California	839	291	903	530	856	363	3259	509	34.684148	58.69324	42.40654	UNRELIABLE
06001431200	Census Tract 4312; Alameda County; California	2114	440	830	376	1618	455	5865	521	20.813623	45.30120	28.12114	UNRELIABLE
06001432100	Census Tract 4321; Alameda County; California	1260	140	949	488	961	261	3892	550	11.111111	51.42255	27.15921	UNRELIABLE
06001432200	Census Tract 4322; Alameda County; California	1058	169	389	110	1469	579	3987	615	15.973535	28.27764	39.41457	UNRELIABLE
06001432300	Census Tract 4323; Alameda County; California	1214	289	614	181	1463	310	4874	457	23.805601	29.47883	21.18934	UNRELIABLE
06001432400	Census Tract 4324; Alameda County; California	801	310	280	234	3501	946	6346	929	38.701623	83.57143	27.02085	UNRELIABLE
06001432501	Census Tract 4325.01; Alameda County; California	989	278	183	200	1356	335	4892	663	28.109201	109.28962	24.70501	UNRELIABLE
06001432502	Census Tract 4325.02; Alameda County; California	554	192	993	361	1544	589	5126	801	34.657040	36.35448	38.14767	UNRELIABLE
06001432601	Census Tract 4326.01; Alameda County; California	985	401	907	572	1015	132	4092	780	40.710660	63.06505	13.00493	UNRELIABLE
06001432602	Census Tract 4326.02; Alameda County; California	443	168	790	419	929	303	3123	445	37.923251	53.03797	32.61572	UNRELIABLE
06001432700	Census Tract 4327; Alameda County; California	1445	556	135	83	586	203	2755	563	38.477509	61.48148	34.64164	UNRELIABLE
06001432800	Census Tract 4328; Alameda County; California	1432	450	264	189	535	228	3862	579	31.424581	71.59091	42.61682	UNRELIABLE
06001433000	Census Tract 4330; Alameda County; California	1349	269	309	217	601	236	3799	460	19.940697	70.22654	39.26789	UNRELIABLE
06001433102	Census Tract 4331.02; Alameda County; California	332	125	309	188	1293	289	4445	806	37.650602	60.84142	22.35112	UNRELIABLE
06001433103	Census Tract 4331.03; Alameda County; California	459	192	406	199	1425	483	3552	610	41.830065	49.01478	33.89474	UNRELIABLE
06001433104	Census Tract 4331.04; Alameda County; California	1042	322	766	378	1673	395	4398	590	30.902111	49.34726	23.61028	UNRELIABLE
06001433200	Census Tract 4332; Alameda County; California	829	342	790	427	2671	1234	8120	1285	41.254523	54.05063	46.19993	UNRELIABLE
06001433300	Census Tract 4333; Alameda County; California	1355	366	37	51	2003	745	7367	927	27.011070	137.83784	37.19421	UNRELIABLE
06001433400	Census Tract 4334; Alameda County; California	810	204	514	280	472	186	6040	991	25.185185	54.47471	39.40678	UNRELIABLE
06001433500	Census Tract 4335; Alameda County; California	1078	252	126	126	903	330	4311	732	23.376623	100.00000	36.54485	UNRELIABLE
06001433600	Census Tract 4336; Alameda County; California	1656	554	296	262	1156	269	5844	646	33.454106	88.51351	23.26990	UNRELIABLE
06001433700	Census Tract 4337; Alameda County; California	392	224	85	66	1623	402	3125	470	57.142857	77.64706	24.76895	UNRELIABLE
06001433801	Census Tract 4338.01; Alameda County; California	308	128	472	257	1645	443	3528	607	41.558442	54.44915	26.93009	UNRELIABLE
06001433802	Census Tract 4338.02; Alameda County; California	340	195	541	425	896	331	4301	650	57.352941	78.55823	36.94196	UNRELIABLE
06001433900	Census Tract 4339; Alameda County; California	623	406	1892	644	3058	756	7187	1004	65.168539	34.03805	24.72204	UNRELIABLE
06001434000	Census Tract 4340; Alameda County; California	910	334	679	209	2335	474	5166	602	36.703297	30.78056	20.29979	UNRELIABLE
06001435102	Census Tract 4351.02; Alameda County; California	1519	296	888	176	1655	342	6137	604	19.486504	19.81982	20.66465	UNRELIABLE
06001435103	Census Tract 4351.03; Alameda County; California	2699	743	575	273	487	226	7774	1027	27.528714	47.47826	46.40657	UNRELIABLE
06001435104	Census Tract 4351.04; Alameda County; California	1055	369	506	280	2116	583	6856	1007	34.976303	55.33597	27.55198	UNRELIABLE
06001435200	Census Tract 4352; Alameda County; California	1073	356	1039	349	1261	376	4647	571	33.178006	33.58999	29.81761	UNRELIABLE
06001435300	Census Tract 4353; Alameda County; California	1068	321	728	249	1622	416	4812	534	30.056180	34.20330	25.64735	UNRELIABLE
06001435400	Census Tract 4354; Alameda County; California	1173	366	797	283	1644	309	5048	633	31.202046	35.50816	18.79562	UNRELIABLE
06001435500	Census Tract 4355; Alameda County; California	1098	547	522	207	1986	502	4153	677	49.817851	39.65517	25.27694	UNRELIABLE
06001435601	Census Tract 4356.01; Alameda County; California	666	205	566	316	3092	685	5449	750	30.780781	55.83039	22.15395	UNRELIABLE
06001435602	Census Tract 4356.02; Alameda County; California	1123	316	763	502	2970	554	5671	586	28.138914	65.79292	18.65320	UNRELIABLE
06001435700	Census Tract 4357; Alameda County; California	1015	238	117	66	2414	460	4819	536	23.448276	56.41026	19.05551	UNRELIABLE
06001435800	Census Tract 4358; Alameda County; California	1181	347	256	303	2188	427	5687	539	29.381880	118.35938	19.51554	UNRELIABLE
06001435900	Census Tract 4359; Alameda County; California	1525	370	35	41	1318	270	5290	850	24.262295	117.14286	20.48558	UNRELIABLE
06001436000	Census Tract 4360; Alameda County; California	1385	345	31	34	2067	434	5114	609	24.909747	109.67742	20.99661	UNRELIABLE
06001436100	Census Tract 4361; Alameda County; California	972	181	251	150	1853	432	5765	1012	18.621399	59.76096	23.31355	UNRELIABLE
06001436200	Census Tract 4362; Alameda County; California	437	182	528	308	2631	607	4128	587	41.647597	58.33333	23.07108	UNRELIABLE
06001436301	Census Tract 4363.01; Alameda County; California	325	113	565	255	2413	715	5255	791	34.769231	45.13274	29.63116	UNRELIABLE
06001436302	Census Tract 4363.02; Alameda County; California	672	180	461	179	1793	482	3932	492	26.785714	38.82863	26.88232	UNRELIABLE
06001436402	Census Tract 4364.02; Alameda County; California	1088	185	370	357	640	153	2688	431	17.003677	96.48649	23.90625	UNRELIABLE
06001436403	Census Tract 4364.03; Alameda County; California	1199	308	424	294	1165	699	4519	757	25.688073	69.33962	60.00000	UNRELIABLE
06001436404	Census Tract 4364.04; Alameda County; California	1442	446	365	189	693	315	3232	473	30.929265	51.78082	45.45455	UNRELIABLE
06001436500	Census Tract 4365; Alameda County; California	689	147	508	269	2579	504	5289	631	21.335269	52.95276	19.54246	UNRELIABLE
06001436601	Census Tract 4366.01; Alameda County; California	717	209	704	390	3818	707	6634	774	29.149233	55.39773	18.51755	UNRELIABLE
06001436602	Census Tract 4366.02; Alameda County; California	345	194	324	170	2801	472	5255	660	56.231884	52.46914	16.85112	UNRELIABLE
06001436700	Census Tract 4367; Alameda County; California	382	143	448	282	1603	336	3367	470	37.434555	62.94643	20.96070	UNRELIABLE
06001436800	Census Tract 4368; Alameda County; California	457	159	249	154	2072	585	4196	592	34.792122	61.84739	28.23359	UNRELIABLE
06001436900	Census Tract 4369; Alameda County; California	776	227	446	394	3687	768	6403	687	29.252577	88.34081	20.82994	UNRELIABLE
06001437000	Census Tract 4370; Alameda County; California	750	279	201	136	1310	445	3471	550	37.200000	67.66169	33.96947	UNRELIABLE
06001437101	Census Tract 4371.01; Alameda County; California	817	219	499	286	2184	696	7960	736	26.805386	57.31463	31.86813	UNRELIABLE
06001437102	Census Tract 4371.02; Alameda County; California	437	166	308	231	1894	443	4457	616	37.986270	75.00000	23.38965	UNRELIABLE
06001437200	Census Tract 4372; Alameda County; California	969	231	546	200	2719	651	8491	1021	23.839009	36.63004	23.94263	UNRELIABLE
06001437300	Census Tract 4373; Alameda County; California	403	171	383	228	1051	248	3135	373	42.431762	59.53003	23.59657	UNRELIABLE
06001437400	Census Tract 4374; Alameda County; California	570	258	140	73	1957	344	3733	439	45.263158	52.14286	17.57793	UNRELIABLE
06001437500	Census Tract 4375; Alameda County; California	461	205	246	175	2335	468	4172	508	44.468547	71.13821	20.04283	UNRELIABLE
06001437600	Census Tract 4376; Alameda County; California	396	120	327	149	1080	222	3455	526	30.303030	45.56575	20.55556	UNRELIABLE
06001437701	Census Tract 4377.01; Alameda County; California	358	238	562	245	1786	415	3597	729	66.480447	43.59431	23.23628	UNRELIABLE
06001437702	Census Tract 4377.02; Alameda County; California	215	148	74	71	3298	652	3880	636	68.837209	95.94595	19.76956	UNRELIABLE
06001437800	Census Tract 4378; Alameda County; California	758	262	380	263	1832	523	4940	696	34.564644	69.21053	28.54803	UNRELIABLE
06001437900	Census Tract 4379; Alameda County; California	240	82	230	180	832	217	2032	324	34.166667	78.26087	26.08173	UNRELIABLE
06001438000	Census Tract 4380; Alameda County; California	839	235	418	318	829	129	3645	578	28.009535	76.07655	15.56092	UNRELIABLE
06001438100	Census Tract 4381; Alameda County; California	977	243	502	171	2933	548	7953	1284	24.872057	34.06374	18.68394	UNRELIABLE
06001438201	Census Tract 4382.01; Alameda County; California	360	171	275	198	2732	755	4895	642	47.500000	72.00000	27.63543	UNRELIABLE
06001438203	Census Tract 4382.03; Alameda County; California	1012	481	148	113	860	290	4091	622	47.529644	76.35135	33.72093	UNRELIABLE
06001438204	Census Tract 4382.04; Alameda County; California	604	225	257	143	2277	634	6371	694	37.251656	55.64202	27.84365	UNRELIABLE
06001438300	Census Tract 4383; Alameda County; California	232	99	252	123	1455	384	3899	419	42.672414	48.80952	26.39175	UNRELIABLE
06001438400	Census Tract 4384; Alameda County; California	417	151	290	161	644	233	2671	391	36.211031	55.51724	36.18012	UNRELIABLE
06001440100	Census Tract 4401; Alameda County; California	1077	241	138	114	550	224	2661	262	22.376973	82.60870	40.72727	UNRELIABLE
06001440200	Census Tract 4402; Alameda County; California	148	115	26	29	3971	502	5641	664	77.702703	111.53846	12.64165	UNRELIABLE
06001440301	Census Tract 4403.01; Alameda County; California	2028	821	406	232	2378	871	7074	1071	40.483235	57.14286	36.62742	UNRELIABLE
06001440304	Census Tract 4403.04; Alameda County; California	482	226	370	366	567	235	4662	636	46.887967	98.91892	41.44621	UNRELIABLE
06001440305	Census Tract 4403.05; Alameda County; California	859	311	52	58	551	89	4064	527	36.204889	111.53846	16.15245	UNRELIABLE
06001440306	Census Tract 4403.06; Alameda County; California	346	158	223	118	417	252	3787	383	45.664740	52.91480	60.43165	UNRELIABLE
06001440307	Census Tract 4403.07; Alameda County; California	611	212	259	178	960	408	4481	930	34.697218	68.72587	42.50000	UNRELIABLE
06001440308	Census Tract 4403.08; Alameda County; California	767	245	247	176	1561	354	6011	700	31.942634	71.25506	22.67777	UNRELIABLE
06001440331	Census Tract 4403.31; Alameda County; California	378	170	124	82	520	177	3276	384	44.973545	66.12903	34.03846	UNRELIABLE
06001440332	Census Tract 4403.32; Alameda County; California	258	115	50	46	271	110	3203	343	44.573643	92.00000	40.59041	UNRELIABLE
06001440333	Census Tract 4403.33; Alameda County; California	194	72	22	23	146	131	2732	399	37.113402	104.54545	89.72603	UNRELIABLE
06001440334	Census Tract 4403.34; Alameda County; California	430	156	233	246	514	216	4041	690	36.279070	105.57940	42.02335	UNRELIABLE
06001440336	Census Tract 4403.36; Alameda County; California	624	250	534	312	432	181	4248	487	40.064103	58.42697	41.89815	UNRELIABLE
06001440337	Census Tract 4403.37; Alameda County; California	157	119	140	179	259	148	2852	494	75.796178	127.85714	57.14286	UNRELIABLE
06001440338	Census Tract 4403.38; Alameda County; California	913	752	20	33	386	283	4095	902	82.365827	165.00000	73.31606	UNRELIABLE
06001441100	Census Tract 4411; Alameda County; California	2042	411	2	8	739	202	4632	609	20.127326	400.00000	27.33424	UNRELIABLE
06001441200	Census Tract 4412; Alameda County; California	2346	648	191	118	900	312	7354	905	27.621483	61.78010	34.66667	UNRELIABLE
06001441301	Census Tract 4413.01; Alameda County; California	663	302	363	238	246	172	3330	385	45.550528	65.56474	69.91870	UNRELIABLE
06001441302	Census Tract 4413.02; Alameda County; California	918	244	158	126	662	245	5828	592	26.579521	79.74684	37.00906	UNRELIABLE
06001441401	Census Tract 4414.01; Alameda County; California	1326	453	87	83	742	296	7549	819	34.162896	95.40230	39.89218	UNRELIABLE
06001441402	Census Tract 4414.02; Alameda County; California	944	218	68	59	383	138	5344	560	23.093220	86.76471	36.03133	UNRELIABLE
06001441501	Census Tract 4415.01; Alameda County; California	472	228	287	225	287	282	5723	688	48.305085	78.39721	98.25784	UNRELIABLE
06001441503	Census Tract 4415.03; Alameda County; California	538	295	18	27	320	184	7416	779	54.832714	150.00000	57.50000	UNRELIABLE
06001441521	Census Tract 4415.21; Alameda County; California	687	214	15	18	332	269	6016	706	31.149927	120.00000	81.02410	UNRELIABLE
06001441522	Census Tract 4415.22; Alameda County; California	956	310	138	113	364	151	5275	553	32.426778	81.88406	41.48352	UNRELIABLE
06001441523	Census Tract 4415.23; Alameda County; California	486	227	179	189	280	150	4264	605	46.707819	105.58659	53.57143	UNRELIABLE
06001441524	Census Tract 4415.24; Alameda County; California	215	110	15	18	41	50	4111	511	51.162791	120.00000	121.95122	UNRELIABLE
06001441525	Census Tract 4415.25; Alameda County; California	110	71	56	46	181	206	1603	328	64.545455	82.14286	113.81215	UNRELIABLE
06001441601	Census Tract 4416.01; Alameda County; California	1485	376	390	383	685	264	4774	536	25.319865	98.20513	38.54015	UNRELIABLE
06001441602	Census Tract 4416.02; Alameda County; California	2066	495	635	609	1741	783	7509	963	23.959342	95.90551	44.97415	UNRELIABLE
06001441701	Census Tract 4417.01; Alameda County; California	455	226	18	41	774	538	3884	603	49.670330	227.77778	69.50904	UNRELIABLE
06001441702	Census Tract 4417.02; Alameda County; California	936	305	504	457	816	456	5037	735	32.585470	90.67460	55.88235	UNRELIABLE
06001441800	Census Tract 4418; Alameda County; California	2007	577	110	85	346	224	6209	817	28.749377	77.27273	64.73988	UNRELIABLE
06001441921	Census Tract 4419.21; Alameda County; California	714	278	12	21	924	248	3849	468	38.935574	175.00000	26.83983	UNRELIABLE
06001441923	Census Tract 4419.23; Alameda County; California	694	274	197	147	750	570	5777	781	39.481268	74.61929	76.00000	UNRELIABLE
06001441924	Census Tract 4419.24; Alameda County; California	1191	346	109	102	748	284	7199	931	29.051217	93.57798	37.96791	UNRELIABLE
06001441926	Census Tract 4419.26; Alameda County; California	540	169	137	92	1038	357	4210	457	31.296296	67.15328	34.39306	UNRELIABLE
06001441927	Census Tract 4419.27; Alameda County; California	821	342	158	116	428	177	4229	631	41.656516	73.41772	41.35514	UNRELIABLE
06001441928	Census Tract 4419.28; Alameda County; California	627	228	493	278	292	178	3736	463	36.363636	56.38945	60.95890	UNRELIABLE
06001441929	Census Tract 4419.29; Alameda County; California	657	366	26	29	237	156	3064	520	55.707763	111.53846	65.82278	UNRELIABLE
06001442000	Census Tract 4420; Alameda County; California	438	109	4	8	292	143	2979	433	24.885845	200.00000	48.97260	UNRELIABLE
06001442100	Census Tract 4421; Alameda County; California	464	135	85	49	65	50	5327	668	29.094828	57.64706	76.92308	UNRELIABLE
06001442200	Census Tract 4422; Alameda County; California	948	356	177	228	426	254	7293	795	37.552743	128.81356	59.62441	UNRELIABLE
06001442301	Census Tract 4423.01; Alameda County; California	1061	448	128	85	794	357	5397	624	42.224317	66.40625	44.96222	UNRELIABLE
06001442302	Census Tract 4423.02; Alameda County; California	901	279	350	240	948	528	6186	819	30.965594	68.57143	55.69620	UNRELIABLE
06001442400	Census Tract 4424; Alameda County; California	1573	359	112	90	1601	313	6417	869	22.822632	80.35714	19.55028	UNRELIABLE
06001442501	Census Tract 4425.01; Alameda County; California	438	309	104	90	925	489	3280	685	70.547945	86.53846	52.86486	UNRELIABLE
06001442502	Census Tract 4425.02; Alameda County; California	676	287	164	161	1149	690	3866	756	42.455621	98.17073	60.05222	UNRELIABLE
06001442601	Census Tract 4426.01; Alameda County; California	1090	294	136	140	1091	833	3924	909	26.972477	102.94118	76.35197	UNRELIABLE
06001442602	Census Tract 4426.02; Alameda County; California	1364	258	484	467	812	336	4663	616	18.914956	96.48760	41.37931	UNRELIABLE
06001442700	Census Tract 4427; Alameda County; California	946	187	33	45	356	84	3139	528	19.767442	136.36364	23.59551	UNRELIABLE
06001442800	Census Tract 4428; Alameda County; California	752	142	23	63	484	148	3115	380	18.882979	273.91304	30.57851	UNRELIABLE
06001442900	Census Tract 4429; Alameda County; California	1178	360	401	265	1050	392	7780	1010	30.560272	66.08479	37.33333	UNRELIABLE
06001443001	Census Tract 4430.01; Alameda County; California	497	141	135	99	888	306	2762	351	28.370221	73.33333	34.45946	UNRELIABLE
06001443002	Census Tract 4430.02; Alameda County; California	1035	227	115	150	1153	418	6599	724	21.932367	130.43478	36.25325	UNRELIABLE
06001443102	Census Tract 4431.02; Alameda County; California	509	184	0	13	284	179	4816	511	36.149312	Inf	63.02817	UNRELIABLE
06001443103	Census Tract 4431.03; Alameda County; California	775	569	50	92	137	107	4125	703	73.419355	184.00000	78.10219	UNRELIABLE
06001443104	Census Tract 4431.04; Alameda County; California	752	258	349	379	113	101	5567	689	34.308511	108.59599	89.38053	UNRELIABLE
06001443105	Census Tract 4431.05; Alameda County; California	489	114	20	23	99	78	4668	606	23.312883	115.00000	78.78788	UNRELIABLE
06001443200	Census Tract 4432; Alameda County; California	516	120	11	17	37	31	3611	679	23.255814	154.54545	83.78378	UNRELIABLE
06001443301	Census Tract 4433.01; Alameda County; California	791	272	45	47	390	230	4399	535	34.386852	104.44444	58.97436	UNRELIABLE
06001443321	Census Tract 4433.21; Alameda County; California	106	70	57	92	237	169	3372	483	66.037736	161.40351	71.30802	UNRELIABLE
06001443322	Census Tract 4433.22; Alameda County; California	621	211	36	32	222	142	3311	340	33.977456	88.88889	63.96396	UNRELIABLE
06001444100	Census Tract 4441; Alameda County; California	2084	587	477	396	1791	452	7211	912	28.166987	83.01887	25.23730	UNRELIABLE
06001444200	Census Tract 4442; Alameda County; California	1450	363	91	92	2049	559	6782	752	25.034483	101.09890	27.28160	UNRELIABLE
06001444301	Census Tract 4443.01; Alameda County; California	1086	167	28	41	956	177	3698	509	15.377532	146.42857	18.51464	UNRELIABLE
06001444303	Census Tract 4443.03; Alameda County; California	0	13	0	13	0	13	0	13	Inf	Inf	Inf	UNRELIABLE
06001444304	Census Tract 4443.04; Alameda County; California	787	272	52	59	2045	759	6408	768	34.561626	113.46154	37.11491	UNRELIABLE
06001444400	Census Tract 4444; Alameda County; California	790	163	154	114	2880	701	5367	660	20.632911	74.02597	24.34028	UNRELIABLE
06001444500	Census Tract 4445; Alameda County; California	1287	398	322	209	3099	752	6988	855	30.924631	64.90683	24.26589	UNRELIABLE
06001444601	Census Tract 4446.01; Alameda County; California	1016	217	73	68	1099	441	6081	670	21.358268	93.15068	40.12739	UNRELIABLE
06001444602	Census Tract 4446.02; Alameda County; California	762	200	287	197	503	229	4935	510	26.246719	68.64111	45.52684	UNRELIABLE
06001450101	Census Tract 4501.01; Alameda County; California	1561	327	204	186	546	198	6883	695	20.948110	91.17647	36.26374	UNRELIABLE
06001450102	Census Tract 4501.02; Alameda County; California	1428	243	1094	436	1015	407	7376	681	17.016807	39.85375	40.09852	UNRELIABLE
06001450200	Census Tract 4502; Alameda County; California	2113	591	188	163	486	267	5272	670	27.969711	86.70213	54.93827	UNRELIABLE
06001450300	Census Tract 4503; Alameda County; California	2542	443	337	222	832	317	5374	597	17.427223	65.87537	38.10096	UNRELIABLE
06001450400	Census Tract 4504; Alameda County; California	2790	689	299	223	1472	327	7886	751	24.695341	74.58194	22.21467	UNRELIABLE
06001450501	Census Tract 4505.01; Alameda County; California	1823	370	0	13	448	214	3400	347	20.296215	Inf	47.76786	UNRELIABLE
06001450502	Census Tract 4505.02; Alameda County; California	2602	377	41	40	557	175	6266	666	14.488855	97.56098	31.41831	UNRELIABLE
06001450601	Census Tract 4506.01; Alameda County; California	1735	257	27	23	248	110	3666	338	14.812680	85.18519	44.35484	UNRELIABLE
06001450603	Census Tract 4506.03; Alameda County; California	2065	340	21	27	736	375	4897	613	16.464891	128.57143	50.95109	UNRELIABLE
06001450604	Census Tract 4506.04; Alameda County; California	2650	377	22	32	656	181	4993	435	14.226415	145.45455	27.59146	UNRELIABLE
06001450605	Census Tract 4506.05; Alameda County; California	1873	298	10	19	340	143	3814	363	15.910304	190.00000	42.05882	UNRELIABLE
06001450606	Census Tract 4506.06; Alameda County; California	3011	405	0	19	301	133	6028	620	13.450681	Inf	44.18605	UNRELIABLE
06001450607	Census Tract 4506.07; Alameda County; California	1703	296	89	105	753	409	5182	736	17.381092	117.97753	54.31607	UNRELIABLE
06001450608	Census Tract 4506.08; Alameda County; California	1925	240	78	92	357	224	4658	597	12.467533	117.94872	62.74510	UNRELIABLE
06001450609	Census Tract 4506.09; Alameda County; California	2376	389	100	97	681	322	4928	497	16.372054	97.00000	47.28341	UNRELIABLE
06001450701	Census Tract 4507.01; Alameda County; California	3949	474	145	109	619	286	8738	1015	12.003039	75.17241	46.20355	UNRELIABLE
06001450741	Census Tract 4507.41; Alameda County; California	2585	431	68	78	1228	699	5742	676	16.673114	114.70588	56.92182	UNRELIABLE
06001450742	Census Tract 4507.42; Alameda County; California	2672	487	10	16	503	210	5495	488	18.226048	160.00000	41.74950	UNRELIABLE
06001450743	Census Tract 4507.43; Alameda County; California	1486	272	588	314	944	493	7435	652	18.304172	53.40136	52.22458	UNRELIABLE
06001450744	Census Tract 4507.44; Alameda County; California	2733	483	0	19	757	448	5818	624	17.672887	Inf	59.18098	UNRELIABLE
06001450745	Census Tract 4507.45; Alameda County; California	2093	566	28	44	436	264	6295	852	27.042523	157.14286	60.55046	UNRELIABLE
06001450746	Census Tract 4507.46; Alameda County; California	1506	254	14	9	600	577	3229	647	16.865870	64.28571	96.16667	UNRELIABLE
06001450750	Census Tract 4507.50; Alameda County; California	1340	229	244	143	473	222	6858	688	17.089552	58.60656	46.93446	UNRELIABLE
06001450751	Census Tract 4507.51; Alameda County; California	1600	389	340	340	658	252	12662	906	24.312500	100.00000	38.29787	UNRELIABLE
06001450752	Census Tract 4507.52; Alameda County; California	1394	328	228	233	685	369	9631	825	23.529412	102.19298	53.86861	UNRELIABLE
06001451102	Census Tract 4511.02; Alameda County; California	2904	579	20	32	290	160	3950	549	19.938016	160.00000	55.17241	UNRELIABLE
06001451103	Census Tract 4511.03; Alameda County; California	1174	515	24	33	163	102	1361	516	43.867121	137.50000	62.57669	UNRELIABLE
06001451104	Census Tract 4511.04; Alameda County; California	3870	772	3	3	1289	607	7164	1085	19.948320	100.00000	47.09077	UNRELIABLE
06001451201	Census Tract 4512.01; Alameda County; California	3620	943	124	143	1881	636	7569	994	26.049724	115.32258	33.81180	UNRELIABLE
06001451202	Census Tract 4512.02; Alameda County; California	2466	319	51	57	925	426	5482	707	12.935929	111.76471	46.05405	UNRELIABLE
06001451300	Census Tract 4513; Alameda County; California	3446	538	78	67	1696	519	6393	677	15.612304	85.89744	30.60142	UNRELIABLE
06001451401	Census Tract 4514.01; Alameda County; California	2426	374	330	384	2344	1004	6166	950	15.416323	116.36364	42.83276	UNRELIABLE
06001451403	Census Tract 4514.03; Alameda County; California	1276	218	35	40	512	133	2184	262	17.084640	114.28571	25.97656	UNRELIABLE
06001451404	Census Tract 4514.04; Alameda County; California	2098	399	70	84	3916	976	6631	910	19.018113	120.00000	24.92339	UNRELIABLE
06001451501	Census Tract 4515.01; Alameda County; California	2660	406	228	153	642	311	4496	487	15.263158	67.10526	48.44237	UNRELIABLE
06001451503	Census Tract 4515.03; Alameda County; California	3113	533	36	45	1213	427	6104	587	17.121748	125.00000	35.20198	UNRELIABLE
06001451504	Census Tract 4515.04; Alameda County; California	706	130	0	13	410	329	1539	338	18.413598	Inf	80.24390	UNRELIABLE
06001451505	Census Tract 4515.05; Alameda County; California	2095	406	32	48	402	176	3159	473	19.379475	150.00000	43.78109	UNRELIABLE
06001451506	Census Tract 4515.06; Alameda County; California	1322	258	141	160	1294	541	3548	673	19.515885	113.47518	41.80835	UNRELIABLE
06001451601	Census Tract 4516.01; Alameda County; California	3774	490	0	19	497	234	5367	698	12.983572	Inf	47.08250	UNRELIABLE
06001451602	Census Tract 4516.02; Alameda County; California	4522	919	152	120	1311	434	6909	929	20.322866	78.94737	33.10450	UNRELIABLE
06001451701	Census Tract 4517.01; Alameda County; California	1595	349	125	110	369	137	2936	490	21.880878	88.00000	37.12737	UNRELIABLE
06001451703	Census Tract 4517.03; Alameda County; California	2317	344	28	46	506	140	3827	348	14.846785	164.28571	27.66798	UNRELIABLE
06001451704	Census Tract 4517.04; Alameda County; California	3001	502	10	20	519	187	4320	556	16.727757	200.00000	36.03083	UNRELIABLE
06001981900	Census Tract 9819; Alameda County; California	15	18	0	13	10	15	25	32	120.000000	Inf	150.00000	UNRELIABLE
06001982000	Census Tract 9820; Alameda County; California	25	17	5	7	0	13	50	19	68.000000	140.00000	Inf	UNRELIABLE
06001982100	Census Tract 9821; Alameda County; California	261	133	82	90	170	49	923	48	50.957854	109.75610	28.82353	UNRELIABLE
06001983200	Census Tract 9832; Alameda County; California	485	112	124	67	43	29	896	105	23.092783	54.03226	67.44186	UNRELIABLE
06001990000	Census Tract 9900; Alameda County; California	0	13	0	13	0	13	0	13	Inf	Inf	Inf	UNRELIABLE
06003010000	Census Tract 100; Alpine County; California	880	161	0	13	213	129	1515	206	18.295455	Inf	60.56338	UNRELIABLE
06005000101	Census Tract 1.01; Amador County; California	3431	504	19	24	563	225	4294	553	14.689595	126.31579	39.96448	UNRELIABLE
06005000102	Census Tract 1.02; Amador County; California	1839	359	7	10	182	126	2160	361	19.521479	142.85714	69.23077	UNRELIABLE
06005000201	Census Tract 2.01; Amador County; California	2393	519	20	3	275	159	2791	526	21.688257	15.00000	57.81818	UNRELIABLE
06005000202	Census Tract 2.02; Amador County; California	1367	463	43	52	265	169	1868	450	33.869788	120.93023	63.77358	UNRELIABLE
06005000301	Census Tract 3.01; Amador County; California	2264	258	488	101	1783	264	4934	330	11.395760	20.69672	14.80651	UNRELIABLE
06005000303	Census Tract 3.03; Amador County; California	5191	463	6	14	593	270	6471	351	8.919283	233.33333	45.53120	UNRELIABLE
06005000304	Census Tract 3.04; Amador County; California	4079	642	42	49	552	210	5259	645	15.739152	116.66667	38.04348	UNRELIABLE
06005000401	Census Tract 4.01; Amador County; California	3608	561	32	53	353	173	4570	594	15.548780	165.62500	49.00850	UNRELIABLE
06005000402	Census Tract 4.02; Amador County; California	3776	486	8	19	763	394	4826	592	12.870763	237.50000	51.63827	UNRELIABLE
06005000500	Census Tract 5; Amador County; California	2445	388	3	9	811	321	3404	421	15.869121	300.00000	39.58076	UNRELIABLE

# Create summary statistics showing how many tracts have data quality issues
summary <- moe_race %>% 
  summarise(
  tracts = n(),
  `tracts with issues` = sum(Flag == "UNRELIABLE")
) 
print(summary)%>%
  kable()

# A tibble: 1 × 2
  tracts `tracts with issues`
   <int>                <int>
1    390                  390

tracts	tracts with issues
390	390

4.2 Pattern Analysis

Your Task: Investigate whether data quality problems are randomly distributed or concentrated in certain types of communities.

# Group tracts by whether they have high MOE issues
# Calculate average characteristics for each group:
# - population size, demographic percentages
# Use group_by() and summarize() to create this comparison
# Create a professional table showing the patterns

moe_issuesummary <- moe_race %>%
  group_by(Flag) %>%
  summarise(
    tracts = n(),
    `Average Population` = mean(`Total PopulationE`, na.rm = TRUE),
    `Average White Population %` = mean((`White AloneE` / `Total PopulationE`) * 100, na.rm = TRUE),
    `Average Black Population %` = mean((`Black/African AmericanE` / `Total PopulationE`) * 100, na.rm = TRUE),
    `Average Hispanic Population %` = mean((`Hispanic/LatinoE` / `Total PopulationE`) * 100, na.rm = TRUE)
  )

  tibble(moe_issuesummary) %>%
    kable(
    caption = "Average Tract Characteristics by Data Quality Status"
  )

Average Tract Characteristics by Data Quality Status
Flag	tracts	Average Population	Average White Population %	Average Black Population %	Average Hispanic Population %
UNRELIABLE	390	4374.141	32.25342	10.44288	21.19834

Pattern Analysis: In my selected counties, all 390 census tracts are flagged as unreliable, meaning there is no meaningful contrast between reliable and unreliable areas. These tracts are relatively small, with an average population of about 4,374 residents, which helps explain the uniformly high margins of error. While White, Black, and Hispanic populations are present at non-negligible levels across tracts, the high uncertainty affects all groups similarly, indicating that unreliability is driven primarily by small population sizes and ACS sampling limitations rather than demographic composition. As a result, tract-level estimates in these counties are particularly vulnerable to error, making them risky inputs for algorithmic decision-making that depends on precise demographic thresholds.

Part 5: Policy Recommendations

5.1 Analysis Integration and Professional Summary

Your Task: Write an executive summary that integrates findings from all four analyses.

Executive Summary Requirements: 1. Overall Pattern Identification: What are the systematic patterns across all your analyses? 2. Equity Assessment: Which communities face the greatest risk of algorithmic bias based on your findings? 3. Root Cause Analysis: What underlying factors drive both data quality issues and bias risk? 4. Strategic Recommendations: What should the Department implement to address these systematic issues?

Executive Summary:

The overall analysis focused on the reliability of ACS data for median household income at the county level and racial and ethnic composition at the census-tract level shows a clear understanding of how data reliability varies across measures. Data reliability differs by both variable and geographic or political division. County-level income estimates are mostly reliable, with almost 70 percent of counties providing data where the margin of error falls below 5 percent. In contrast, census-tract-level racial composition data are largely unreliable. For the randomly selected counties, regardless of income data reliability, racial data reliability remained consistently low. Out of 390 census tracts analyzed, all exhibited unreliable racial or ethnic estimates failing the 15% threshold.

Data reliability is especially weak for race and ethnicity variables, primarily because margins of error are high across tracts. This suggests a need to reconsider current data collection approaches. Census tracts in the analysis have relatively small populations, averaging around 4,000 residents. A general inference from the results is that smaller population sizes are associated with higher margins of error. As a result, existing ACS sampling and data collection methods may require revision to produce more reliable tract-level estimates.

The root cause of these issues appears to lie in the sampling design and overall data collection methodology. Capturing a larger effective sample would be necessary to improve reliability. In the long term, reconsidering census tract sizing or adopting alternative aggregation strategies may be necessary to support more stable and reliable data collection in the future.

The Department of Human Services should adopt an uncertainty-aware approach to decision-making by incorporating margins of error directly into analytical and algorithmic processes rather than relying on point estimates alone. Census tract level racial and ethnic composition data should not be used in isolation under current reliability conditions and should instead be aggregated to higher geographies or supplemented with additional data. A tiered framework based on data reliability should guide when automated decisions are appropriate versus when further review is required. Finally, reliability flags and margin of error measures should be clearly documented and carried through all outputs so uncertainty is visible at the point of decision

6.3 Specific Recommendations

Your Task: Create a decision framework for algorithm implementation.

# Create a summary table using your county reliability data
# Include: county name, median income, MOE percentage, reliability category

# Add a new column with algorithm recommendations using case_when():
# - High Confidence: "Safe for algorithmic decisions"
# - Moderate Confidence: "Use with caution - monitor outcomes"  
# - Low Confidence: "Requires manual review or additional data"

# Format as a professional table with kable()

summary_overall <- ca_county_reliability %>%
  select(
    County,
    `Median Household Income`,
    `Margin of Error for HH Income (%)` = moe_pct, 
    `Reliability Category` = category
  )%>%
  mutate(
    `Algorithm Recommendation` = case_when(
    `Reliability Category` == "High Confidence" ~ "Safe for Algorithmic Decisions",
    `Reliability Category` == "Moderate Confidence" ~ "Use with caution - monitor outcomes",
    `Reliability Category` == "Low Confidence" ~ "Requires manual review or additional data"
    )
  )
tibble(summary_overall)%>%
  kable(caption = "County Income Data Reliability and Guide for Data Use - Algorithmic Recommendations <br> <em>For ethnic and race related analysis manual analysis and further data cleaning required")

County Income Data Reliability and Guide for Data Use - Algorithmic Recommendations
*For ethnic and race related analysis manual analysis and further data cleaning required*
County	Median Household Income	Margin of Error for HH Income (%)	Reliability Category	Algorithm Recommendation
Alameda	122488	1.0049964	High Confidence	Safe for Algorithmic Decisions
Alpine	101125	17.2479604	Low Confidence	Requires manual review or additional data
Amador	74853	8.0798365	Moderate Confidence	Use with caution - monitor outcomes
Butte	66085	3.4213513	High Confidence	Safe for Algorithmic Decisions
Calaveras	77526	4.9983231	High Confidence	Safe for Algorithmic Decisions
Colusa	69619	8.2520576	Moderate Confidence	Use with caution - monitor outcomes
Contra Costa	120020	1.2464589	High Confidence	Safe for Algorithmic Decisions
Del Norte	61149	7.1562904	Moderate Confidence	Use with caution - monitor outcomes
El Dorado	99246	3.3552990	High Confidence	Safe for Algorithmic Decisions
Fresno	67756	1.4271799	High Confidence	Safe for Algorithmic Decisions
Glenn	64033	6.1889963	Moderate Confidence	Use with caution - monitor outcomes
Humboldt	57881	3.6816917	High Confidence	Safe for Algorithmic Decisions
Imperial	53847	4.1116497	High Confidence	Safe for Algorithmic Decisions
Inyo	63417	8.5986407	Moderate Confidence	Use with caution - monitor outcomes
Kern	63883	2.0741042	High Confidence	Safe for Algorithmic Decisions
Kings	68540	3.2871316	High Confidence	Safe for Algorithmic Decisions
Lake	56259	4.3353064	High Confidence	Safe for Algorithmic Decisions
Lassen	59515	5.9665631	Moderate Confidence	Use with caution - monitor outcomes
Los Angeles	83411	0.5263095	High Confidence	Safe for Algorithmic Decisions
Madera	73543	3.8671254	High Confidence	Safe for Algorithmic Decisions
Marin	142019	2.8855294	High Confidence	Safe for Algorithmic Decisions
Mariposa	60021	8.8185802	Moderate Confidence	Use with caution - monitor outcomes
Mendocino	61335	3.5835983	High Confidence	Safe for Algorithmic Decisions
Merced	64772	3.3069845	High Confidence	Safe for Algorithmic Decisions
Modoc	54962	9.8049562	Moderate Confidence	Use with caution - monitor outcomes
Mono	82038	18.7571613	Low Confidence	Requires manual review or additional data
Monterey	91043	2.0869260	High Confidence	Safe for Algorithmic Decisions
Napa	105809	2.8173407	High Confidence	Safe for Algorithmic Decisions
Nevada	79395	4.8151647	High Confidence	Safe for Algorithmic Decisions
Orange	109361	0.8065032	High Confidence	Safe for Algorithmic Decisions
Placer	109375	1.6969143	High Confidence	Safe for Algorithmic Decisions
Plumas	67885	11.4487737	Low Confidence	Requires manual review or additional data
Riverside	84505	1.2555470	High Confidence	Safe for Algorithmic Decisions
Sacramento	84010	0.9713129	High Confidence	Safe for Algorithmic Decisions
San Benito	104451	5.2282889	Moderate Confidence	Use with caution - monitor outcomes
San Bernardino	77423	1.0410343	High Confidence	Safe for Algorithmic Decisions
San Diego	96974	1.0239858	High Confidence	Safe for Algorithmic Decisions
San Francisco	136689	1.4295225	High Confidence	Safe for Algorithmic Decisions
San Joaquin	82837	1.7480112	High Confidence	Safe for Algorithmic Decisions
San Luis Obispo	90158	2.5632778	High Confidence	Safe for Algorithmic Decisions
San Mateo	149907	1.7484174	High Confidence	Safe for Algorithmic Decisions
Santa Barbara	92332	2.0458779	High Confidence	Safe for Algorithmic Decisions
Santa Clara	153792	1.0046036	High Confidence	Safe for Algorithmic Decisions
Santa Cruz	104409	3.0390100	High Confidence	Safe for Algorithmic Decisions
Shasta	68347	3.6285426	High Confidence	Safe for Algorithmic Decisions
Sierra	61108	15.1158604	Low Confidence	Requires manual review or additional data
Siskiyou	53898	4.8981409	High Confidence	Safe for Algorithmic Decisions
Solano	97037	1.7766419	High Confidence	Safe for Algorithmic Decisions
Sonoma	99266	2.0026998	High Confidence	Safe for Algorithmic Decisions
Stanislaus	74872	1.8311251	High Confidence	Safe for Algorithmic Decisions
Sutter	72654	4.7141245	High Confidence	Safe for Algorithmic Decisions
Tehama	59029	6.9508208	Moderate Confidence	Use with caution - monitor outcomes
Trinity	47317	12.4479574	Low Confidence	Requires manual review or additional data
Tulare	64474	2.3094581	High Confidence	Safe for Algorithmic Decisions
Tuolumne	70432	6.6603249	Moderate Confidence	Use with caution - monitor outcomes
Ventura	102141	1.4959713	High Confidence	Safe for Algorithmic Decisions
Yolo	85097	2.7415773	High Confidence	Safe for Algorithmic Decisions
Yuba	66693	4.1923440	High Confidence	Safe for Algorithmic Decisions

Key Recommendations:

Your Task: Use your analysis results to provide specific guidance to the department.

Counties suitable for immediate algorithmic implementation: Alameda; Butte; Calaveras; Contra Costa; El Dorado; Fresno; Humboldt; Imperial; Kern; Kings; Lake; Los Angeles; Madera; Marin; Mendocino; Merced; Monterey; Napa; Nevada; Orange; Placer; Riverside; Sacramento; San Bernardino; San Diego; San Francisco; San Joaquin; San Luis Obispo; San Mateo; Santa Barbara; Santa Clara; Santa Cruz; Shasta; Siskiyou; Solano; Sonoma; Stanislaus; Sutter; Tulare; Ventura; Yolo; Yuba.

These are high reliability for income with margin of error below 5%.

Counties requiring additional oversight: Amador; Colusa; Del Norte; Glenn; Inyo; Lassen; Mariposa; Modoc; San Benito; Tehama; Tuolumne.

Frequent audits for analysis required, intervention in terms of surveying residents for the outcomes from decisions made by the planning department.

Counties needing alternative approaches: Alpine; Mono; Plumas; Sierra; Trinity. -Manual review of data- rezoning considerations (redrawing boundaries), frequent surveying and more direct community level engagement required.

Questions for Further Investigation

Are high margins of error clustered in specific types of places, such as rural or low-population areas, rather than being randomly distributed across counties and census tracts?
Is it possible to analyze the spatial patterns and see if rezoning of census tracts is possible for added data reliability.

Technical Notes

Data Sources: - U.S. Census Bureau, American Community Survey 2018-2022 5-Year Estimates - Retrieved via tidycensus R package on 07-09 February 2026

Reproducibility: - All analysis conducted in R - Census API key required for replication - Complete code and documentation available at: https://ssatyal-ux.github.io/shubhanga_satyal_CPLN_20Jan2026/

Methodology Notes: While selecting my counties, I initially attempted to use slice_sample() to randomize the selection. However, to ensure consistency in the data and to avoid issues when referring to the same counties for census tract–level analysis, I used slice() instead.

I used help from the class exercise and additional support from ChatGPT for explanations on how to write code when I was stuck. I also used the dplyr cheatsheet for reference.

Limitations: All census tracts in my selected counties were unrelable for ethnicity and race data. Thus not allowing further investigation.

Submission Checklist

Before submitting your portfolio link on Canvas:

All code chunks run without errors
All “[Fill this in]” prompts have been completed
Tables are properly formatted and readable
Executive summary addresses all four required components
Portfolio navigation includes this assignment
Census API key is properly set
Document renders correctly to HTML

Remember: Submit your portfolio URL on Canvas, not the file itself. Your assignment should be accessible at your-portfolio-url/labs/lab_1/your_file_name.html