CA_LACnty_EPA_Census_Join_Data_2023.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Census Tract	California County	ZIP	Nearby City (to help approximate location only)	Ozone	PM2.5	Diesel PM	Traffic	Asthma	Low Birth Weight	Cardiovascular Disease
2	6001400100	Alameda	94704	Berkeley	0.029592333	8.69794377	27.43693284	929.74	18.5	2.99	3.01
3	6001400200	Alameda	94618	Oakland	0.029592333	8.69794377	42.19	1392.34	24.27	1.24	3.98
4	6001400300	Alameda	94618	Oakland	0.029592333	8.69794377	42.19	1207.3	37.93	4.13	4.42
5	6001400400	Alameda	94609	Oakland	0.029592333	8.69794377	42.19	1153.54	60.86	3.98	4.89
6	6001400500	Alameda	94609	Oakland	0.029592333	8.69794377	42.19	668.28	110.37	5.59	7.55
7	6001400600	Alameda	94609	Oakland	0.029592333	8.69794377	42.19	1743.09	122.34	1.43	8.32
8	6001400700	Alameda	94608	Emeryville	0.029592333	8.69794377	42.0798493	646.61	141.49	5.76	7.65
9	6001400800	Alameda	94608	Emeryville	0.029592333	8.69794377	33.75	384.87	146.75	9.51	7.46
10	6001400900	Alameda	94608	Emeryville	0.029592333	8.69794377	34.28165241	378.29	165.16	7.39	8.32
11	6001401000	Alameda	94608	Emeryville	0.029592333	8.69794377	52.17800092	1720.02	129.47	7.26	7.02
12	6001401100	Alameda	94609	Oakland	0.029592333	8.69794377	50.62159386	1537.35	122.26	8.28	8.32
13	6001401200	Alameda	94609	Oakland	0.029592333	8.69794377	50.63961471	758.13	114.55	3.27	7.85
14	6001401300	Alameda	94609	Oakland	0.029592333	8.69794377	54.34	1341.83	101.64	4.28	5.31
15	6001401400	Alameda	94608	Emeryville	0.029592333	8.69794377	56.11829593	1639.88	105.74	7.86	5.55
16	6001401500	Alameda	94608	Emeryville	0.029592333	8.69794377	76.11	916.65	134.76	8.14	6.61
17	6001401600	Alameda	94607	Oakland	0.029592333	8.69794377	73.41736339	385.52	147.98	8.09	5.79
18	6001401700	Alameda	94607	Oakland	0.029592333	8.69794377	75.68565163	2080.53	159.24	6.22	6.88
19	6001401800	Alameda	94607	Oakland	0.029592333	8.69794377	76.11	180.13	165.52	8.3	6.44
20	6001402200	Alameda	94607	Oakland	0.029592333	8.69794377	76.11	769.38	165.52	6.27	6.44
21	6001402400	Alameda	94607	Oakland	0.029592333	8.69794377	76.11	186.3	165.52	6.7	6.44
22	6001402500	Alameda	94607	Oakland	0.029592333	8.69794377	76.11	531.54	165.52	7.3	6.44
23	6001402600	Alameda	94607	Oakland	0.029592333	8.69794377	76.11	765.85	117.49	3.51	4.63
24	6001402700	Alameda	94612	Oakland	0.029592333	8.69794377	68.35532362	609.13	102.28	10.84	4.13
25	6001402800	Alameda	94612	Oakland	0.029592333	8.69794377	54.34442987	459.86	123.88	5.52	5.26
26	6001402900	Alameda	94612	Oakland	0.029592333	8.69794377	54.34	294.2	124.1	0	5.27
27	6001403000	Alameda	94607	Oakland	0.029592333	8.69794377	54.34	1220.7	133.35	5.43	5.29
28	6001403100	Alameda	94607	Oakland	0.029592333	8.69794377	65.29077384	1052.4	165.44	3.95	6.44
29	6001403300	Alameda	94607	Oakland	0.029592333	8.69794377	48.0701931	1600.1	162.39	5.36	6.32
30	6001403400	Alameda	94612	Oakland	0.029592333	8.69794377	54.34	430.14	122.15	5.09	5.18
31	6001403501	Alameda	94611	Oakland	0.029592333	8.69794377	54.34	1142.45	46.61	4.94	3.81
32	6001403502	Alameda	94610	Oakland	0.029592333	8.69794377	54.34	2935.47	26	5.19	2.45
33	6001403600	Alameda	94610	Oakland	0.029592333	8.69794377	54.34	2123.53	56.26	5.68	5.98
34	6001403701	Alameda	94610	Oakland	0.029592333	8.69794377	54.34	537.97	49.77	2.1	4.14
35	6001403702	Alameda	94610	Oakland	0.029592333	8.69794377	54.34	1418.49	53.34	3.94	5.15
36	6001403800	Alameda	94610	Oakland	0.029592333	8.69794377	54.34	945.68	56.26	4.75	5.98
37	6001403900	Alameda	94610	Oakland	0.029592333	8.69794377	54.34	1896.48	43.06	4.78	4.75
38	6001404000	Alameda	94611	Oakland	0.029592333	8.69794377	54.34	1104.41	32.64	1.95	5.1
39	6001404101	Alameda	94611	Oakland	0.029592333	8.69794377	53.9408119	464.4	30.93	3.95	4.58
40	6001404102	Alameda	94611	Oakland	0.029592333	8.69794377	54.34	421.88	34.14	3.75	5.42
41	6001404200	Alameda	94611	Oakland	0.029592333	8.69794377	37.69521533	547.4	20.18	4.36	3.47
42	6001404300	Alameda	94618	Oakland	0.029592333	8.69794377	40.35162783	1089.96	25.23	4.12	4.4
43	6001404400	Alameda	94611	Oakland	0.029592333	8.69794377	23.83838128	1273.83	23.28	5.63	3.73
44	6001404501	Alameda	94611	Oakland	0.029592333	8.69794377	22.17	723.5	28.07	3.6	4.5
45	6001404502	Alameda	94611	Oakland	0.029592333	8.69794377	23.12817743	586.44	31.98	4.28	5.13
46	6001404600	Alameda	94611	Oakland	0.029592333	8.69794377	18.99328199	423.6	28.37	2.42	4.24
47	6001404700	Alameda	94602	Oakland	0.029592333	8.69794377	22.17	611.54	65.06	4.79	6.76
48	6001404800	Alameda	94602	Oakland	0.029592333	8.69794377	22.17	394.52	80.31	5.39	8.16
49	6001404900	Alameda	94602	Oakland	0.029592333	8.69794377	22.71638938	1306.63	74.94	4.79	7.62
50	6001405000	Alameda	94610	Oakland	0.029592333	8.69794377	33.96044226	1329.47	46.34	3.57	4.8
51	6001405100	Alameda	94610	Oakland	0.029592333	8.69794377	44.40259075	1228.36	49.59	3.3	5.29
52	6001405200	Alameda	94606	Oakland	0.029592333	8.69794377	54.34	1364.82	53.98	5.8	4.59
53	6001405301	Alameda	94606	Oakland	0.029592333	8.69794377	54.34	404.09	97	5.63	7.21
54	6001405302	Alameda	94606	Oakland	0.029592333	8.69794377	54.13974349	326.99	73.61	5.43	5
55	6001405401	Alameda	94606	Oakland	0.029592333	8.69794377	49.32591878	295.33	97	6.77	7.21
56	6001405402	Alameda	94606	Oakland	0.029592333	8.69794377	44.30802967	280.89	97	4.46	7.21
57	6001405500	Alameda	94606	Oakland	0.029592333	8.69794377	52.05272935	264.6	97	6.57	7.21
58	6001405600	Alameda	94610	Oakland	0.029592333	8.69794377	54.33357442	997.19	58.65	7.8	4.93
59	6001405700	Alameda	94606	Oakland	0.029592333	8.69794377	40.53220811	1284.52	52.69	5.98	4.62
60	6001405800	Alameda	94606	Oakland	0.029592333	8.69794377	44.7916937	207.52	86.89	5.33	6.5
61	6001405901	Alameda	94606	Oakland	0.029592333	8.69794377	44.27	235.29	95.23	4.97	7.09
62	6001405902	Alameda	94606	Oakland	0.029592333	8.69794377	44.27	276.41	97	6.65	7.21
63	6001406000	Alameda	94606	Oakland	0.029592333	8.69794377	44.58035829	1732.58	93.8	5.92	6.98
64	6001406100	Alameda	94601	Oakland	0.029592333	8.69794377	41.02840648	1573.2	105.75	3.97	8.54
65	6001406201	Alameda	94601	Oakland	0.029592333	8.69794377	43.22234304	236.09	110.47	6.2	8.93
66	6001406202	Alameda	94601	Oakland	0.029592333	8.69794377	39.46588884	410.99	110.47	3.42	8.93
67	6001406300	Alameda	94601	Oakland	0.029592333	8.69794377	38.78236492	468.88	110.47	4.78	8.93
68	6001406400	Alameda	94602	Oakland	0.029592333	8.69794377	34.76983475	1789.36	58.55	8.98	5.06
69	6001406500	Alameda	94601	Oakland	0.029592333	8.69794377	38.37	598.83	88.63	6.97	7.36
70	6001406601	Alameda	94602	Oakland	0.029592333	8.69794377	37.27197925	1476.8	66.48	5.24	6.53
71	6001406602	Alameda	94602	Oakland	0.029592333	8.69794377	31.99934797	1762.85	80.31	2.27	8.16
72	6001406700	Alameda	94602	Oakland	0.029592333	8.69794377	22.32227999	564.71	80.31	3.89	8.16
73	6001406800	Alameda	94602	Oakland	0.029592333	8.69794377	29.92933741	548.79	72.72	4.32	6.45
74	6001406900	Alameda	94619	Oakland	0.029592333	8.69794377	36.5689492	704.15	84.37	6.87	6.3
75	6001407000	Alameda	94619	Oakland	0.029592333	8.69794377	38.37	1393.73	64.52	7.3	4.94
76	6001407101	Alameda	94601	Oakland	0.029592333	8.69794377	38.37	392.75	110.47	3.96	8.93
77	6001407102	Alameda	94601	Oakland	0.029592333	8.69794377	38.37	441.53	107.51	4.85	8.68
78	6001407200	Alameda	94601	Oakland	0.029592333	8.69794377	38.37	388.04	110.47	4.67	8.93
79	6001407300	Alameda	94601	Oakland	0.029592333	8.69794377	38.35423385	1406.6	99.49	5.92	7.73
80	6001407400	Alameda	94601	Oakland	0.029592333	8.69794377	38.37	256.1	110.47	4.23	8.93
81	6001407500	Alameda	94621	Oakland	0.029592333	8.69794377	38.37	208.82	103.08	7.1	7.04
82	6001407600	Alameda	94601	Oakland	0.029592333	8.69794377	38.37	345.52	97.97	6.01	7.83
83	6001407700	Alameda	94619	Oakland	0.029592333	8.69794377	38.37	325.1	77.14	8.2	5.14
84	6001407800	Alameda	94613	Oakland	0.029592333	8.69794377	33.87723914	2143.41	59.07	4.49	4.09
85	6001407900	Alameda	94619	Oakland	0.029592333	8.69794377	33.44772524	1650.74	82.49	3.42	6.06
86	6001408000	Alameda	94619	Oakland	0.029592333	8.69794377	15.04578496	387.92	48.25	4.49	4.27
87	6001408100	Alameda	94619	Oakland	0.029592333	8.69794377	17.63808283	783.57	82.1	5.19	4.82
88	6001408200	Alameda	94605	Oakland	0.029592333	8.69794377	19.83182204	362.81	170.91	8.16	8.64
89	6001408300	Alameda	94605	Oakland	0.029592333	8.69794377	19.11	2584.77	170.91	6.15	8.64
90	6001408400	Alameda	94605	Oakland	0.029592333	8.69794377	19.25278639	268.99	170.91	8.33	8.64
91	6001408500	Alameda	94621	Oakland	0.029592333	8.69794377	27.6389843	399.03	132.77	7.39	8.77
92	6001408600	Alameda	94605	Oakland	0.029592333	8.69794377	29.60284631	348.72	131.31	9.57	8.08
93	6001408700	Alameda	94605	Oakland	0.029592333	8.69794377	37.95665189	267.33	137.45	7.13	8.16
94	6001408800	Alameda	94621	Oakland	0.029592333	8.69794377	38.31507567	411.44	161.73	8.75	11.56
95	6001408900	Alameda	94621	Oakland	0.029592333	8.69794377	38.04538018	469.47	161.73	4.64	11.56
96	6001409000	Alameda	94621	Oakland	0.029592333	8.69794377	38.28	1419.88	147.84	6.15	11.34
97	6001409100	Alameda	94603	Oakland	0.029592333	8.69794377	37.55004342	2145.76	189.95	8.03	14.44
98	6001409200	Alameda	94603	Oakland	0.029592333	8.69794377	31.07904182	4291.67	106.59	8.38	8.79
99	6001409300	Alameda	94603	Oakland	0.029592333	8.69794377	29.22	329.65	166.1	4.52	12.82
100	6001409400	Alameda	94603	Oakland	0.029592333	8.69794377	31.21028038	318.86	160.69	5.71	12.12