_id	line_number	contest_name	choice_name	party_name	total_votes	percent_of_votes	registered_voters	ballots_cast	total_number_of_precincts	number_of_precincts_reporting	over_votes	under_votes
1	1	Presidential Electors (Vote For 1)	Kamala D. Harris	DEM	429916	59.4	952539	726058	1327	1327	0	0
2	2	Presidential Electors (Vote For 1)	Donald J. Trump	REP	283595	39.18	952539	726058	1327	1327	0	0
3	3	Presidential Electors (Vote For 1)	Jill Stein	GRN	3691	0.51	952539	726058	1327	1327	0	0
4	4	Presidential Electors (Vote For 1)	Chase Oliver	LIB	3302	0.46	952539	726058	1327	1327	0	0
5	5	Presidential Electors (Vote For 1)	Write-in	NON	3295	0.46	952539	726058	1327	1327	0	0
6	6	United States Senator (Vote For 1)	Robert P. Casey, Jr.	DEM	425280	59.34	952539	726058	1327	1327	0	0
7	7	United States Senator (Vote For 1)	Dave McCormick	REP	272861	38.07	952539	726058	1327	1327	0	0
8	8	United States Senator (Vote For 1)	John C. Thomas	LIB	8409	1.17	952539	726058	1327	1327	0	0
9	9	United States Senator (Vote For 1)	Leila Hazou	GRN	7462	1.04	952539	726058	1327	1327	0	0
10	10	United States Senator (Vote For 1)	Marty Selker	CON	1910	0.27	952539	726058	1327	1327	0	0
11	11	United States Senator (Vote For 1)	Write-in	NON	719	0.1	952539	726058	1327	1327	0	0
12	12	Attorney General (Vote For 1)	Eugene DePasquale	DEM	414666	58.7	952539	726058	1327	1327	0	0
13	13	Attorney General (Vote For 1)	Dave Sunday	REP	269179	38.1	952539	726058	1327	1327	0	0
14	14	Attorney General (Vote For 1)	Robert Cowburn	LIB	8985	1.27	952539	726058	1327	1327	0	0
15	15	Attorney General (Vote For 1)	Richard L. Weiss	GRN	7955	1.13	952539	726058	1327	1327	0	0
16	16	Attorney General (Vote For 1)	Justin L. Magill	CON	2927	0.41	952539	726058	1327	1327	0	0
17	17	Attorney General (Vote For 1)	Eric L. Settle	FWD	1996	0.28	952539	726058	1327	1327	0	0
18	18	Attorney General (Vote For 1)	Write-in	NON	707	0.1	952539	726058	1327	1327	0	0
19	19	Auditor General (Vote For 1)	Malcolm Kenyatta	DEM	396467	56.87	952539	726058	1327	1327	0	0
20	20	Auditor General (Vote For 1)	Tim DeFoor	REP	278483	39.95	952539	726058	1327	1327	0	0
21	21	Auditor General (Vote For 1)	Reece Smith	LIB	13169	1.89	952539	726058	1327	1327	0	0
22	22	Auditor General (Vote For 1)	Bob Goodrich	CON	5754	0.83	952539	726058	1327	1327	0	0
23	23	Auditor General (Vote For 1)	Eric K. Anton	ASO	2269	0.33	952539	726058	1327	1327	0	0
24	24	Auditor General (Vote For 1)	Write-in	NON	955	0.14	952539	726058	1327	1327	0	0
25	25	State Treasurer (Vote For 1)	Erin McClelland	DEM	395886	56.52	952539	726058	1327	1327	0	0
26	26	State Treasurer (Vote For 1)	Stacy Garrity	REP	284446	40.61	952539	726058	1327	1327	0	0
27	27	State Treasurer (Vote For 1)	Nickolas Ciesielski	LIB	12046	1.72	952539	726058	1327	1327	0	0
28	28	State Treasurer (Vote For 1)	Troy Bowman	CON	3798	0.54	952539	726058	1327	1327	0	0
29	29	State Treasurer (Vote For 1)	Chris Foster	FWD	3307	0.47	952539	726058	1327	1327	0	0
30	30	State Treasurer (Vote For 1)	Write-in	NON	964	0.14	952539	726058	1327	1327	0	0
31	31	Representative in Congress District 12 (Vote For 1)	Summer Lee	DEM	211948	60.85	500408	361239	780	780	0	0
32	32	Representative in Congress District 12 (Vote For 1)	James Hayes	REP	135159	38.8	500408	361239	780	780	0	0
33	33	Representative in Congress District 12 (Vote For 1)	Write-in	NON	1201	0.34	500408	361239	780	780	0	0
34	34	Representative in Congress District 17 (Vote For 1)	Chris Deluzio	DEM	202423	56.69	452875	365307	548	548	0	0
35	35	Representative in Congress District 17 (Vote For 1)	Rob Mercuri	REP	154022	43.14	452875	365307	548	548	0	0
36	36	Representative in Congress District 17 (Vote For 1)	Write-in	NON	594	0.17	452875	365307	548	548	0	0
37	37	Senator in the General Assembly District 37 (Vote For 1)	Devlin Robinson	REP	79826	52.76	188393	155522	187	187	0	0
38	38	Senator in the General Assembly District 37 (Vote For 1)	Nicole Ruscitto	DEM	71275	47.11	188393	155522	187	187	0	0
39	39	Senator in the General Assembly District 37 (Vote For 1)	Write-in	NON	188	0.12	188393	155522	187	187	0	0
40	40	Senator in the General Assembly District 43 (Vote For 1)	Jay Costa, Jr.	DEM	116722	97.39	205041	138408	316	316	0	0
41	41	Senator in the General Assembly District 43 (Vote For 1)	Write-in	NON	3130	2.61	205041	138408	316	316	0	0
42	42	Senator in the General Assembly District 45 (Vote For 1)	Nick Pisciottano	DEM	69248	53	177701	135180	283	283	0	0
43	43	Senator in the General Assembly District 45 (Vote For 1)	Jen Dintini	REP	61189	46.83	177701	135180	283	283	0	0
44	44	Senator in the General Assembly District 45 (Vote For 1)	Write-in	NON	218	0.17	177701	135180	283	283	0	0
45	45	Representative in the General Assembly District 19 (Vote For 1)	Aerion Andrew Abney	DEM	22645	97.22	46476	27318	80	80	0	0
46	46	Representative in the General Assembly District 19 (Vote For 1)	Write-in	NON	647	2.78	46476	27318	80	80	0	0
47	47	Representative in the General Assembly District 20 (Vote For 1)	Emily Kinkead	DEM	21322	59.12	45857	37067	62	62	0	0
48	48	Representative in the General Assembly District 20 (Vote For 1)	Matt Kruth	REP	14678	40.7	45857	37067	62	62	0	0
49	49	Representative in the General Assembly District 20 (Vote For 1)	Write-in	NON	66	0.18	45857	37067	62	62	0	0
50	50	Representative in the General Assembly District 21 (Vote For 1)	Lindsay Powell	DEM	29301	94.45	50603	39951	79	79	0	0
51	51	Representative in the General Assembly District 21 (Vote For 1)	Write-in	NON	1722	5.55	50603	39951	79	79	0	0
52	52	Representative in the General Assembly District 23 (Vote For 1)	Dan Frankel	DEM	29844	97.71	54148	35234	64	64	0	0
53	53	Representative in the General Assembly District 23 (Vote For 1)	Write-in	NON	699	2.29	54148	35234	64	64	0	0
54	54	Representative in the General Assembly District 24 (Vote For 1)	La'Tasha D. Mayes	DEM	27962	98.03	51159	32118	98	98	0	0
55	55	Representative in the General Assembly District 24 (Vote For 1)	Write-in	NON	563	1.97	51159	32118	98	98	0	0
56	56	Representative in the General Assembly District 25 (Vote For 1)	Brandon J. Markosek	DEM	20865	59.5	46986	36155	66	66	0	0
57	57	Representative in the General Assembly District 25 (Vote For 1)	John Ritter	REP	14140	40.32	46986	36155	66	66	0	0
58	58	Representative in the General Assembly District 25 (Vote For 1)	Write-in	NON	62	0.18	46986	36155	66	66	0	0
59	59	Representative in the General Assembly District 27 (Vote For 1)	Daniel J. Deasy	DEM	26101	95.2	43568	33916	69	69	0	0
60	60	Representative in the General Assembly District 27 (Vote For 1)	Write-in	NON	1317	4.8	43568	33916	69	69	0	0
61	61	Representative in the General Assembly District 28 (Vote For 1)	Jeremy Shaffer	REP	23228	56.96	49212	41604	40	40	0	0
62	62	Representative in the General Assembly District 28 (Vote For 1)	Bill Petulla	DEM	17514	42.94	49212	41604	40	40	0	0
63	63	Representative in the General Assembly District 28 (Vote For 1)	Write-in	NON	41	0.1	49212	41604	40	40	0	0
64	64	Representative in the General Assembly District 30 (Vote For 1)	Arvind Venkat	DEM	21896	54.26	48744	41175	44	44	0	0
65	65	Representative in the General Assembly District 30 (Vote For 1)	Nathan Wolfe	REP	17748	43.98	48744	41175	44	44	0	0
66	66	Representative in the General Assembly District 30 (Vote For 1)	William Johnson Baierl	LIB	676	1.68	48744	41175	44	44	0	0
67	67	Representative in the General Assembly District 30 (Vote For 1)	Write-in	NON	34	0.08	48744	41175	44	44	0	0
68	68	Representative in the General Assembly District 32 (Vote For 1)	Joe McAndrew	D/R	31207	97.26	48798	38019	68	68	0	0
69	69	Representative in the General Assembly District 32 (Vote For 1)	Write-in	NON	879	2.74	48798	38019	68	68	0	0
70	70	Representative in the General Assembly District 33 (Vote For 1)	Mandy Steele	DEM	20030	55.7	45630	36885	61	61	0	0
71	71	Representative in the General Assembly District 33 (Vote For 1)	Gary Lotz	REP	15867	44.12	45630	36885	61	61	0	0
72	72	Representative in the General Assembly District 33 (Vote For 1)	Write-in	NON	63	0.18	45630	36885	61	61	0	0
73	73	Representative in the General Assembly District 34 (Vote For 1)	Abigail Salisbury	DEM	30209	97.45	51015	35751	81	81	0	0
74	74	Representative in the General Assembly District 34 (Vote For 1)	Write-in	NON	789	2.55	51015	35751	81	81	0	0
75	75	Representative in the General Assembly District 35 (Vote For 1)	Matthew R. Gergely	DEM	23550	95.43	45006	31087	97	97	0	0
76	76	Representative in the General Assembly District 35 (Vote For 1)	Write-in	NON	1128	4.57	45006	31087	97	97	0	0
77	77	Representative in the General Assembly District 36 (Vote For 1)	Jessica Benham	DEM	22253	77.83	44468	31867	77	77	0	0
78	78	Representative in the General Assembly District 36 (Vote For 1)	Ross Sylvester	LIB	5981	20.92	44468	31867	77	77	0	0
79	79	Representative in the General Assembly District 36 (Vote For 1)	Write-in	NON	359	1.26	44468	31867	77	77	0	0
80	80	Representative in the General Assembly District 38 (Vote For 1)	John Inglis	DEM	19559	55.42	45858	36783	68	68	0	0
81	81	Representative in the General Assembly District 38 (Vote For 1)	Stone Sobieralski	REP	15675	44.42	45858	36783	68	68	0	0
82	82	Representative in the General Assembly District 38 (Vote For 1)	Write-in	NON	57	0.16	45858	36783	68	68	0	0
83	83	Representative in the General Assembly District 39 (Vote For 1)	Andrew Kuzma	REP	19500	61.61	38828	32561	49	49	0	0
84	84	Representative in the General Assembly District 39 (Vote For 1)	Angela Girol	DEM	12103	38.24	38828	32561	49	49	0	0
85	85	Representative in the General Assembly District 39 (Vote For 1)	Write-in	NON	48	0.15	38828	32561	49	49	0	0
86	86	Representative in the General Assembly District 40 (Vote For 1)	Natalie Mihalek	REP	15586	56.43	33631	28350	36	36	0	0
87	87	Representative in the General Assembly District 40 (Vote For 1)	Peter Kohnke	DEM	11994	43.42	33631	28350	36	36	0	0
88	88	Representative in the General Assembly District 40 (Vote For 1)	Write-in	NON	41	0.15	33631	28350	36	36	0	0
89	89	Representative in the General Assembly District 42 (Vote For 1)	Dan Miller	DEM	26932	66.57	50449	41675	68	68	0	0
90	90	Representative in the General Assembly District 42 (Vote For 1)	Joseph Leckenby	REP	13436	33.21	50449	41675	68	68	0	0
91	91	Representative in the General Assembly District 42 (Vote For 1)	Write-in	NON	86	0.21	50449	41675	68	68	0	0
92	92	Representative in the General Assembly District 44 (Vote For 1)	Valerie Gaydos	REP	20811	53.74	49331	39471	42	42	0	0
93	93	Representative in the General Assembly District 44 (Vote For 1)	Hadley Haas	DEM	17872	46.15	49331	39471	42	42	0	0
94	94	Representative in the General Assembly District 44 (Vote For 1)	Write-in	NON	41	0.11	49331	39471	42	42	0	0
95	95	Representative in the General Assembly District 45 (Vote For 1)	Anita Astorino Kulik	DEM	21045	57.98	48516	37216	63	63	0	0
96	96	Representative in the General Assembly District 45 (Vote For 1)	James Julius	REP	15192	41.86	48516	37216	63	63	0	0
97	97	Representative in the General Assembly District 45 (Vote For 1)	Write-in	NON	59	0.16	48516	37216	63	63	0	0
98	98	Representative in the General Assembly District 46 (Vote For 1)	Jason Ortitay	REP	6860	59.55	14256	11855	15	15	0	0
99	99	Representative in the General Assembly District 46 (Vote For 1)	Alex Taylor	DEM	4646	40.33	14256	11855	15	15	0	0
100	100	Representative in the General Assembly District 46 (Vote For 1)	Write-in	NON	14	0.12	14256	11855	15	15	0	0
101	101	Special Election Question - City of Duquesne (Vote For 1)	Yes	YES	1313	77.83	3436	1962	10	10	0	0
102	102	Special Election Question - City of Duquesne (Vote For 1)	No	NO	374	22.17	3436	1962	10	10	0	0
103	103	Government Study Commissioner - Duquesne (Vote For 7)	Write-in	NON	957	23.72	3436	1962	10	10	0	0
104	104	Government Study Commissioner - Duquesne (Vote For 7)	Denise L. Brownfield	NON	901	22.34	3436	1962	10	10	0	0
105	105	Government Study Commissioner - Duquesne (Vote For 7)	Connie A. Lucas-Kemp	NON	794	19.68	3436	1962	10	10	0	0
106	106	Government Study Commissioner - Duquesne (Vote For 7)	Kirsten A. Pastrick	NON	711	17.63	3436	1962	10	10	0	0
107	107	Government Study Commissioner - Duquesne (Vote For 7)	Burton Comensky	NON	671	16.63	3436	1962	10	10	0	0
108	108	Special Election Question - Borough of Jefferson Hills (Vote For 1)	No	NO	3540	50.79	9123	7744	9	9	0	0
109	109	Special Election Question - Borough of Jefferson Hills (Vote For 1)	Yes	YES	3430	49.21	9123	7744	9	9	0	0
110	110	Government Study Commissioner - Jefferson Hills (Vote For 7)	Melissa L. Steffey	NON	2665	12.03	9123	7744	9	9	0	0
111	111	Government Study Commissioner - Jefferson Hills (Vote For 7)	Karen M. Bucy	NON	2317	10.46	9123	7744	9	9	0	0
112	112	Government Study Commissioner - Jefferson Hills (Vote For 7)	Kevin B. Polick	NON	2280	10.3	9123	7744	9	9	0	0
113	113	Government Study Commissioner - Jefferson Hills (Vote For 7)	Douglas A. Pascoe	NON	2026	9.15	9123	7744	9	9	0	0
114	114	Government Study Commissioner - Jefferson Hills (Vote For 7)	James V. Bender	NON	1989	8.98	9123	7744	9	9	0	0
115	115	Government Study Commissioner - Jefferson Hills (Vote For 7)	Lorelei M. Bartrug	NON	1854	8.37	9123	7744	9	9	0	0
116	116	Government Study Commissioner - Jefferson Hills (Vote For 7)	Nicholas F. Horgan	NON	1835	8.29	9123	7744	9	9	0	0
117	117	Government Study Commissioner - Jefferson Hills (Vote For 7)	Joseph Zukiewicz	NON	1652	7.46	9123	7744	9	9	0	0
118	118	Government Study Commissioner - Jefferson Hills (Vote For 7)	Dennis M. Bailey	NON	1474	6.66	9123	7744	9	9	0	0
119	119	Government Study Commissioner - Jefferson Hills (Vote For 7)	Darla K. Kozak	NON	1438	6.49	9123	7744	9	9	0	0
120	120	Government Study Commissioner - Jefferson Hills (Vote For 7)	William L. Lucas	NON	1204	5.44	9123	7744	9	9	0	0
121	121	Government Study Commissioner - Jefferson Hills (Vote For 7)	Gloria B. Koehlinger	NON	1143	5.16	9123	7744	9	9	0	0
122	122	Government Study Commissioner - Jefferson Hills (Vote For 7)	Write-in	NON	268	1.21	9123	7744	9	9	0	0
123	123	Special Election Question - South Park Township (Vote For 1)	Yes	YES	4833	57.01	10608	8880	13	13	0	0
124	124	Special Election Question - South Park Township (Vote For 1)	No	NO	3644	42.99	10608	8880	13	13	0	0
125	125	Special Election Question - West Deer Township (Vote For 1)	Yes	YES	4016	54.86	9146	7894	8	8	0	0
126	126	Special Election Question - West Deer Township (Vote For 1)	No	NO	3305	45.14	9146	7894	8	8	0	0
127	127	Special Election Question - Borough of Wilkinsburg (Vote For 1)	Yes	YES	3961	57.87	12761	7840	17	17	0	0
128	128	Special Election Question - Borough of Wilkinsburg (Vote For 1)	No	NO	2884	42.13	12761	7840	17	17	0	0