Activity 1 - Wages 2020Census cleaned.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Age	Sex	Marital_status	Number_of_children	Family_size	Education	Race_ethnicity-multi_recode	Immigrate-year	Birthplace_recode	Speaks_English	Employment_status	Income-wages	Region	Region-division_recode	Moved	Year	state
2	30	Male	Married, spouse present	2	4	Master or PhD or professional degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	63000	South	East South Central	Same house	2020	Tennessee
3	28	Female	Married, spouse present	1 child present	3	Master or PhD or professional degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	46000	South	East South Central	Same house	2020	Tennessee
4	34	Male	Married, spouse present	1 child present	3	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	45000	South	East South Central	Same house	2020	Tennessee
5	58	Female	Married, spouse absent	1 child present	2	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	55000	South	East South Central	Same house	2020	Tennessee
6	39	Male	Never married/single	0 children present	1	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	12000	South	East South Central	Same house	2020	Tennessee
7	53	Male	Married, spouse present	0 children present	2	Master or PhD or professional degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	80000	South	East South Central	Same house	2020	Tennessee
8	39	Male	Married, spouse present	2	4	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	75000	South	East South Central	Moved within state	2020	Tennessee
9	33	Female	Divorced	3	4	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	14000	South	East South Central	Same house	2020	Tennessee
10	40	Male	Married, spouse present	1 child present	3	Some schooling, no HS diploma	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	42000	South	East South Central	Same house	2020	Tennessee
11	60	Female	Divorced	1 child present	4	Master or PhD or professional degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	12000	South	East South Central	Same house	2020	Tennessee
12	34	Male	Never married/single	0 children present	1	Some schooling, no HS diploma	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	15500	South	East South Central	Same house	2020	Tennessee
13	43	Male	Never married/single	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	55000	South	East South Central	Same house	2020	Tennessee
14	34	Male	Never married/single	0 children present	1	Some schooling, no HS diploma	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	15500	South	East South Central	Same house	2020	Tennessee
15	60	Female	Divorced	1 child present	4	Master or PhD or professional degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	12000	South	East South Central	Same house	2020	Tennessee
16	52	Female	Married, spouse present	0 children present	2	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	38000	South	East South Central	Same house	2020	Tennessee
17	18	Male	Never married/single	0 children present	4	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	1800	South	East South Central	Same house	2020	Tennessee
18	44	Male	Never married/single	0 children present	3	Master or PhD or professional degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	31200	South	East South Central	Same house	2020	Tennessee
19	47	Male	Never married/single	0 children present	2	1 or more years of college, no degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	3000	South	East South Central	Moved between states	2020	Tennessee
20	49	Female	Married, spouse present	2	4	1 or more years of college, no degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	20800	South	East South Central	Same house	2020	Tennessee
21	30	Female	Never married/single	0 children present	8	Master or PhD or professional degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	1200	South	East South Central	Same house	2020	Tennessee
22	54	Female	Married, spouse present	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	55000	South	East South Central	Same house	2020	Tennessee
23	41	Male	Married, spouse present	2	4	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	70000	South	East South Central	Same house	2020	Tennessee
24	45	Male	Married, spouse present	1 child present	4	1 or more years of college, no degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	45000	South	East South Central	Same house	2020	Tennessee
25	43	Female	Married, spouse present	1 child present	5	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	42000	South	East South Central	Same house	2020	Tennessee
26	28	Female	Never married/single	0 children present	2	Master or PhD or professional degree	Hispanic	1995	Southern Europe, Central/Eastern Europe, or Russia	Yes, speaks only English	Employed	78000	South	East South Central	Same house	2020	Tennessee
27	43	Male	Married, spouse present	2	4	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	35000	South	East South Central	Same house	2020	Tennessee
28	43	Female	Married, spouse present	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	5200	South	East South Central	Same house	2020	Tennessee
29	27	Female	Married, spouse present	0 children present	2	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	30000	South	East South Central	Same house	2020	Tennessee
30	58	Male	Married, spouse present	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	5000	South	East South Central	Same house	2020	Tennessee
31	30	Male	Married, spouse present	3	5	Some schooling, no HS diploma	Hispanic	2007	Mexico, Central America, South America, or the Caribbean	Yes, speaks well	Employed	44000	South	East South Central	Same house	2020	Tennessee
32	52	Female	Married, spouse present	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	33800	South	East South Central	Same house	2020	Tennessee
33	27	Male	Never married/single	0 children present	4	Some schooling, no HS diploma	Hispanic	0	U.S. state, territory, or outlying region	Yes, speaks very well	Employed	36400	South	East South Central	Same house	2020	Tennessee
34	56	Male	Divorced	0 children present	1	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	50000	South	East South Central	Same house	2020	Tennessee
35	20	Male	Never married/single	0 children present	1	1 or more years of college, no degree	Hispanic	2000	Mexico, Central America, South America, or the Caribbean	Yes, speaks very well	Employed	4000	South	East South Central	Moved within state	2020	Tennessee
36	28	Male	Never married/single	0 children present	2	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	24000	South	East South Central	Same house	2020	Tennessee
37	30	Male	Married, spouse present	1 child present	3	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	30000	South	East South Central	Same house	2020	Tennessee
38	31	Male	Married, spouse present	2	5	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	33000	South	East South Central	Same house	2020	Tennessee
39	27	Male	Never married/single	0 children present	2	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	28000	South	East South Central	Moved within state	2020	Tennessee
40	27	Male	Never married/single	0 children present	4	Some schooling, no HS diploma	Hispanic	0	U.S. state, territory, or outlying region	Yes, speaks very well	Employed	36400	South	East South Central	Same house	2020	Tennessee
41	46	Female	Never married/single	0 children present	1	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	60000	South	East South Central	Same house	2020	Tennessee
42	20	Male	Never married/single	0 children present	1	1 or more years of college, no degree	Hispanic	2000	Mexico, Central America, South America, or the Caribbean	Yes, speaks very well	Employed	4000	South	East South Central	Moved within state	2020	Tennessee
43	52	Female	Married, spouse present	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	33800	South	East South Central	Same house	2020	Tennessee
44	59	Male	Never married/single	0 children present	1	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	22600	South	East South Central	Same house	2020	Tennessee
45	43	Female	Married, spouse present	2	4	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	15000	South	East South Central	Same house	2020	Tennessee
46	59	Female	Married, spouse present	0 children present	2	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	17000	South	East South Central	Same house	2020	Tennessee
47	22	Female	Married, spouse present	0 children present	2	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	24000	South	East South Central	Same house	2020	Tennessee
48	31	Male	Never married/single	0 children present	1	1 or more years of college, no degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	34000	South	East South Central	Moved within state	2020	Tennessee
49	29	Female	Divorced	0 children present	3	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	35000	South	East South Central	Same house	2020	Tennessee
50	47	Female	Divorced	2	3	Associate or Bachelor degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	70000	South	East South Central	Same house	2020	Tennessee
51	51	Female	Divorced	0 children present	1	1 or more years of college, no degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	35000	South	East South Central	Same house	2020	Tennessee
52	50	Male	Married, spouse present	1 child present	3	HS diploma or GED	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	60000	South	East South Central	Same house	2020	Tennessee
53	26	Male	Never married/single	0 children present	1	1 or more years of college, no degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	30000	South	East South Central	Same house	2020	Tennessee
54	64	Male	Married, spouse present	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	45000	South	East South Central	Same house	2020	Tennessee
55	57	Female	Married, spouse present	0 children present	2	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	48000	South	East South Central	Same house	2020	Tennessee
56	32	Male	Married, spouse present	2	4	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	110000	South	East South Central	Same house	2020	Tennessee
57	37	Male	Married, spouse present	3	5	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	64000	South	East South Central	Same house	2020	Tennessee
58	71	Male	Married, spouse present	0 children present	3	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	7600	South	East South Central	Same house	2020	Tennessee
59	29	Male	Married, spouse present	1 child present	3	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	55000	South	East South Central	Same house	2020	Tennessee
60	46	Female	Married, spouse present	2	5	Associate or Bachelor degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	50000	South	East South Central	Same house	2020	Tennessee
61	64	Male	Divorced	0 children present	1	Master or PhD or professional degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	19200	South	East South Central	Same house	2020	Tennessee
62	33	Female	Never married/single	2	3	Associate or Bachelor degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	10000	South	East South Central	Same house	2020	Tennessee
63	65	Male	Divorced	0 children present	2	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	458000	South	East South Central	Same house	2020	Tennessee
64	49	Female	Never married/single	1 child present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	25000	South	East South Central	Moved within state	2020	Tennessee
65	59	Female	Divorced	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	45000	South	East South Central	Same house	2020	Tennessee
66	25	Male	Never married/single	0 children present	3	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	60000	South	East South Central	Same house	2020	Tennessee
67	48	Male	Married, spouse present	3	5	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	100000	South	East South Central	Same house	2020	Tennessee
68	24	Female	Never married/single	0 children present	3	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	21800	South	East South Central	Same house	2020	Tennessee
69	45	Male	Divorced	0 children present	1	1 or more years of college, no degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	26000	South	East South Central	Same house	2020	Tennessee
70	54	Female	Married, spouse present	1 child present	3	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	55000	South	East South Central	Same house	2020	Tennessee
71	28	Female	Never married/single	0 children present	3	1 or more years of college, no degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	21900	South	East South Central	Moved within state	2020	Tennessee
72	38	Male	Divorced	3	4	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	50000	South	East South Central	Same house	2020	Tennessee
73	54	Female	Married, spouse present	1 child present	3	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	55000	South	East South Central	Same house	2020	Tennessee
74	28	Female	Never married/single	0 children present	3	1 or more years of college, no degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	21900	South	East South Central	Moved within state	2020	Tennessee
75	27	Male	Never married/single	0 children present	6	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	10000	South	East South Central	Same house	2020	Tennessee
76	41	Male	Married, spouse present	2	4	HS diploma or GED	Hispanic	1995	Mexico, Central America, South America, or the Caribbean	Yes, speaks well	Employed	22900	South	East South Central	Same house	2020	Tennessee
77	18	Male	Never married/single	0 children present	3	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	6200	South	East South Central	Same house	2020	Tennessee
78	17	Male	Never married/single	0 children present	4	Some schooling, no HS diploma	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	3500	South	East South Central	Same house	2020	Tennessee
79	52	Female	Divorced	0 children present	1	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	36000	South	East South Central	Same house	2020	Tennessee
80	32	Male	Never married/single	0 children present	1	Master or PhD or professional degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	153000	South	East South Central	Moved between states	2020	Tennessee
81	40	Male	Never married/single	0 children present	1	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	34000	South	East South Central	Moved within state	2020	Tennessee
82	55	Female	Married, spouse present	2	4	Master or PhD or professional degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	225000	South	East South Central	Same house	2020	Tennessee
83	28	Female	Never married/single	0 children present	5	Associate or Bachelor degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	45000	South	East South Central	Same house	2020	Tennessee
84	33	Male	Never married/single	0 children present	2	Associate or Bachelor degree	Non-Hispanic Black	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	32000	Midwest	West North Central	Same house	2020	Iowa
85	67	Male	Married, spouse present	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	68000	Midwest	West North Central	Same house	2020	Iowa
86	61	Male	Married, spouse present	0 children present	2	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	80000	Midwest	West North Central	Same house	2020	Iowa
87	61	Male	Married, spouse present	0 children present	2	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	80000	Midwest	West North Central	Same house	2020	Iowa
88	54	Male	Divorced	0 children present	1	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	41400	Midwest	West North Central	Same house	2020	Iowa
89	60	Female	Married, spouse present	0 children present	2	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	50000	Midwest	West North Central	Same house	2020	Iowa
90	48	Female	Never married/single	0 children present	1	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	58000	Midwest	West North Central	Moved within state	2020	Iowa
91	31	Female	Married, spouse present	1 child present	3	Associate or Bachelor degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	60000	Midwest	West North Central	Same house	2020	Iowa
92	62	Male	Married, spouse present	0 children present	2	1 or more years of college, no degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	30000	Midwest	West North Central	Same house	2020	Iowa
93	16	Male	Never married/single	0 children present	5	Some schooling, no HS diploma	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	1000	Midwest	West North Central	Same house	2020	Iowa
94	66	Male	Married, spouse present	0 children present	4	Master or PhD or professional degree	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	56000	Midwest	West North Central	Same house	2020	Iowa
95	22	Male	Never married/single	0 children present	5	HS diploma or GED	Non-Hispanic two or more major races	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	13000	Midwest	West North Central	Same house	2020	Iowa
96	59	Male	Married, spouse present	0 children present	2	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	100000	Midwest	West North Central	Same house	2020	Iowa
97	35	Female	Married, spouse present	3	5	HS diploma or GED	Hispanic	2010	Mexico, Central America, South America, or the Caribbean	Yes, but not well	Employed	30000	Midwest	West North Central	Same house	2020	Iowa
98	25	Male	Married, spouse absent	0 children present	1	HS diploma or GED	Non-Hispanic White	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	26500	Midwest	West North Central	Moved between states	2020	Iowa
99	39	Male	Never married/single	3	5	HS diploma or GED	Non-Hispanic Asian and/or Pacific Islander	1986	East, Southeast, or South Asia	Yes, speaks well	Employed	38000	Midwest	West North Central	Same house	2020	Iowa
100	22	Male	Never married/single	0 children present	5	HS diploma or GED	Non-Hispanic two or more major races	0	U.S. state, territory, or outlying region	Yes, speaks only English	Employed	13000	Midwest	West North Central	Same house	2020	Iowa