_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)	DEM Joseph R. Biden/Kamala D. Harris	DEM	430759	59.43	942851	0	1323	1323	0	0
2	2	Presidential Electors (Vote For 1)	REP Donald J. Trump/Mike R. Pence	REP	282913	39.03	942851	0	1323	1323	0	0
3	3	Presidential Electors (Vote For 1)	LIB Jo Jorgensen/Jeremy Spike Cohen	LIB	8361	1.15	942851	0	1323	1323	0	0
4	4	Presidential Electors (Vote For 1)	Write-in	NON	2767	0.38	942851	0	1323	1323	0	0
5	5	Attorney General (Vote For 1)	DEM Josh Shapiro	DEM	443166	62.18	942851	0	1323	1323	0	0
6	6	Attorney General (Vote For 1)	REP Heather Heidelbaugh	REP	246253	34.55	942851	0	1323	1323	0	0
7	7	Attorney General (Vote For 1)	LIB Daniel Wassmer	LIB	13585	1.91	942851	0	1323	1323	0	0
8	8	Attorney General (Vote For 1)	GRN Richard L. Weiss	GRN	9220	1.29	942851	0	1323	1323	0	0
9	9	Attorney General (Vote For 1)	Write-in	NON	447	0.06	942851	0	1323	1323	0	0
10	10	Auditor General (Vote For 1)	DEM Nina Ahmad	DEM	396868	56.36	942851	0	1323	1323	0	0
11	11	Auditor General (Vote For 1)	REP Timothy DeFoor	REP	275577	39.14	942851	0	1323	1323	0	0
12	12	Auditor General (Vote For 1)	LIB Jennifer Moore	LIB	21129	3	942851	0	1323	1323	0	0
13	13	Auditor General (Vote For 1)	GRN Olivia Faison	GRN	9954	1.41	942851	0	1323	1323	0	0
14	14	Auditor General (Vote For 1)	Write-in	NON	620	0.09	942851	0	1323	1323	0	0
15	15	State Treasurer (Vote For 1)	DEM Joe Torsella	DEM	403803	57.45	942851	0	1323	1323	0	0
16	16	State Treasurer (Vote For 1)	REP Stacy L. Garrity	REP	270679	38.51	942851	0	1323	1323	0	0
17	17	State Treasurer (Vote For 1)	LIB Joe Soloski	LIB	17136	2.44	942851	0	1323	1323	0	0
18	18	State Treasurer (Vote For 1)	GRN Timothy Runkle	GRN	10696	1.52	942851	0	1323	1323	0	0
19	19	State Treasurer (Vote For 1)	Write-in	NON	573	0.08	942851	0	1323	1323	0	0
20	20	Representative in Congress 17th District (Vote For 1)	DEM Conor Lamb	DEM	177474	54.03	407276	0	493	493	0	0
21	21	Representative in Congress 17th District (Vote For 1)	REP Sean Parnell	REP	150726	45.88	407276	0	493	493	0	0
22	22	Representative in Congress 17th District (Vote For 1)	Write-in	NON	291	0.09	407276	0	493	493	0	0
23	23	Representative in Congress 18th District (Vote For 1)	DEM Mike Doyle	DEM	266084	69.1	538277	0	832	832	0	0
24	24	Representative in Congress 18th District (Vote For 1)	REP Luke Edison Negron	REP	118163	30.69	538277	0	832	832	0	0
25	25	Representative in Congress 18th District (Vote For 1)	Write-in	NON	813	0.21	538277	0	832	832	0	0
26	26	Senator in the General Assembly 37th District (Vote For 1)	DEM Pam Iovino	DEM	79220	49.09	198472	0	214	214	0	0
27	27	Senator in the General Assembly 37th District (Vote For 1)	REP Devlin Robinson	REP	82022	50.83	198472	0	214	214	0	0
28	28	Senator in the General Assembly 37th District (Vote For 1)	Write-in	NON	135	0.08	198472	0	214	214	0	0
29	29	Senator in the General Assembly 43rd District (Vote For 1)	DEM Jay Costa, Jr.	DEM	117770	97.44	201361	0	305	305	0	0
30	30	Senator in the General Assembly 43rd District (Vote For 1)	Write-in	NON	3092	2.56	201361	0	305	305	0	0
31	31	Senator in the General Assembly 45th District (Vote For 1)	DEM Jim Brewster	DEM	57782	52.78	146937	0	234	234	0	0
32	32	Senator in the General Assembly 45th District (Vote For 1)	REP Nicole Ziccarelli	REP	51561	47.1	146937	0	234	234	0	0
33	33	Senator in the General Assembly 45th District (Vote For 1)	Write-in	NON	135	0.12	146937	0	234	234	0	0
34	34	Representative in the General Assembly 16th District (Vote For 1)	DEM Robert F. Matzie	DEM	1004	59.76	2100	0	3	3	0	0
35	35	Representative in the General Assembly 16th District (Vote For 1)	REP Rico Elmore	REP	673	40.06	2100	0	3	3	0	0
36	36	Representative in the General Assembly 16th District (Vote For 1)	Write-in	NON	3	0.18	2100	0	3	3	0	0
37	37	Representative in the General Assembly 19th District (Vote For 1)	DEM Jake Wheatley	DEM	22679	97.33	43353	0	86	86	0	0
38	38	Representative in the General Assembly 19th District (Vote For 1)	Write-in	NON	621	2.67	43353	0	86	86	0	0
39	39	Representative in the General Assembly 20th District (Vote For 1)	DEM Emily Kinkead	DEM	27657	94.55	48002	0	70	70	0	0
40	40	Representative in the General Assembly 20th District (Vote For 1)	Write-in	NON	1594	5.45	48002	0	70	70	0	0
41	41	Representative in the General Assembly 21st District (Vote For 1)	DEM Sara Innamorato	DEM	24035	66.24	47469	0	69	69	0	0
42	42	Representative in the General Assembly 21st District (Vote For 1)	REP John Waugh	REP	12170	33.54	47469	0	69	69	0	0
43	43	Representative in the General Assembly 21st District (Vote For 1)	Write-in	NON	79	0.22	47469	0	69	69	0	0
44	44	Representative in the General Assembly 23rd District (Vote For 1)	DEM Dan Frankel	DEM	24642	84.53	51748	0	62	62	0	0
45	45	Representative in the General Assembly 23rd District (Vote For 1)	GRN Jay Ting Walker	GRN	4197	14.4	51748	0	62	62	0	0
46	46	Representative in the General Assembly 23rd District (Vote For 1)	Write-in	NON	314	1.08	51748	0	62	62	0	0
47	47	Representative in the General Assembly 24th District (Vote For 1)	DEM Ed Gainey	DEM	29894	98.83	50301	0	90	90	0	0
48	48	Representative in the General Assembly 24th District (Vote For 1)	Write-in	NON	353	1.17	50301	0	90	90	0	0
49	49	Representative in the General Assembly 25th District (Vote For 1)	DEM Brandon J. Markosek	DEM	19445	58.21	43994	0	62	62	0	0
50	50	Representative in the General Assembly 25th District (Vote For 1)	REP John Ritter	REP	13896	41.6	43994	0	62	62	0	0
51	51	Representative in the General Assembly 25th District (Vote For 1)	Write-in	NON	64	0.19	43994	0	62	62	0	0
52	52	Representative in the General Assembly 27th District (Vote For 1)	DEM Dan Deasy	DEM	26094	96.08	43821	0	71	71	0	0
53	53	Representative in the General Assembly 27th District (Vote For 1)	Write-in	NON	1064	3.92	43821	0	71	71	0	0
54	54	Representative in the General Assembly 28th District (Vote For 1)	DEM Emily Skopov	DEM	20477	46.24	53284	0	46	46	0	0
55	55	Representative in the General Assembly 28th District (Vote For 1)	REP Rob Mercuri	REP	23770	53.67	53284	0	46	46	0	0
56	56	Representative in the General Assembly 28th District (Vote For 1)	Write-in	NON	40	0.09	53284	0	46	46	0	0
57	57	Representative in the General Assembly 30th District (Vote For 1)	DEM Lissa Geiger Shulman	DEM	19217	45.14	50709	0	60	60	0	0
58	58	Representative in the General Assembly 30th District (Vote For 1)	REP Lori Mizgorski	REP	23309	54.75	50709	0	60	60	0	0
59	59	Representative in the General Assembly 30th District (Vote For 1)	Write-in	NON	44	0.1	50709	0	60	60	0	0
60	60	Representative in the General Assembly 32nd District (Vote For 1)	DEM Tony DeLuca	DEM	30311	96.15	48348	0	68	68	0	0
61	61	Representative in the General Assembly 32nd District (Vote For 1)	Write-in	NON	1214	3.85	48348	0	68	68	0	0
62	62	Representative in the General Assembly 33rd District (Vote For 1)	DEM Frank Dermody	DEM	11421	47.94	30171	0	42	42	0	0
63	63	Representative in the General Assembly 33rd District (Vote For 1)	REP Carrie DelRosso	REP	12359	51.88	30171	0	42	42	0	0
64	64	Representative in the General Assembly 33rd District (Vote For 1)	Write-in	NON	42	0.18	30171	0	42	42	0	0
65	65	Representative in the General Assembly 34th District (Vote For 1)	DEM Summer Lee	DEM	27112	95.57	46353	0	78	78	0	0
66	66	Representative in the General Assembly 34th District (Vote For 1)	Write-in	NON	1258	4.43	46353	0	78	78	0	0
67	67	Representative in the General Assembly 35th District (Vote For 1)	DEM Austin Davis	DEM	21327	92.52	40330	0	84	84	0	0
68	68	Representative in the General Assembly 35th District (Vote For 1)	Write-in	NON	1725	7.48	40330	0	84	84	0	0
69	69	Representative in the General Assembly 36th District (Vote For 1)	DEM Jessica Benham	DEM	20064	62.5	44661	0	72	72	0	0
70	70	Representative in the General Assembly 36th District (Vote For 1)	REP AJ Doyle	REP	11980	37.32	44661	0	72	72	0	0
71	71	Representative in the General Assembly 36th District (Vote For 1)	Write-in	NON	58	0.18	44661	0	72	72	0	0
72	72	Representative in the General Assembly 38th District (Vote For 1)	DEM Nick Pisciottano	DEM	20352	55.98	46507	0	71	71	0	0
73	73	Representative in the General Assembly 38th District (Vote For 1)	REP Linda Book	REP	15930	43.82	46507	0	71	71	0	0
74	74	Representative in the General Assembly 38th District (Vote For 1)	Write-in	NON	75	0.21	46507	0	71	71	0	0
75	75	Representative in the General Assembly 39th District (Vote For 1)	DEM Sara-Summer Oliphant	DEM	11335	38.3	35995	0	41	41	0	0
76	76	Representative in the General Assembly 39th District (Vote For 1)	REP Mike Puskaric	REP	18218	61.56	35995	0	41	41	0	0
77	77	Representative in the General Assembly 39th District (Vote For 1)	Write-in	NON	40	0.14	35995	0	41	41	0	0
78	78	Representative in the General Assembly 40th District (Vote For 1)	DEM Sharon Guidi	DEM	12180	43.1	34163	0	37	37	0	0
79	79	Representative in the General Assembly 40th District (Vote For 1)	REP Natalie Mihalek	REP	16062	56.84	34163	0	37	37	0	0
80	80	Representative in the General Assembly 40th District (Vote For 1)	Write-in	NON	16	0.06	34163	0	37	37	0	0
81	81	Representative in the General Assembly 42nd District (Vote For 1)	DEM Dan Miller	DEM	25552	68.36	46781	0	68	68	0	0
82	82	Representative in the General Assembly 42nd District (Vote For 1)	REP Kurt Korinko	REP	11762	31.47	46781	0	68	68	0	0
83	83	Representative in the General Assembly 42nd District (Vote For 1)	Write-in	NON	65	0.17	46781	0	68	68	0	0
84	84	Representative in the General Assembly 44th District (Vote For 1)	DEM Michele Knoll	DEM	18126	44.99	51011	0	39	39	0	0
85	85	Representative in the General Assembly 44th District (Vote For 1)	REP Valerie Gaydos	REP	22106	54.87	51011	0	39	39	0	0
86	86	Representative in the General Assembly 44th District (Vote For 1)	Write-in	NON	54	0.13	51011	0	39	39	0	0
87	87	Representative in the General Assembly 45th District (Vote For 1)	DEM Anita Astorino Kulik	DEM	22833	61.6	47645	0	67	67	0	0
88	88	Representative in the General Assembly 45th District (Vote For 1)	REP Danny DeVito	REP	14165	38.22	47645	0	67	67	0	0
89	89	Representative in the General Assembly 45th District (Vote For 1)	Write-in	NON	67	0.18	47645	0	67	67	0	0
90	90	Representative in the General Assembly 46th District (Vote For 1)	DEM Byron Timmins	DEM	8365	41.65	24721	0	26	26	0	0
91	91	Representative in the General Assembly 46th District (Vote For 1)	REP Jason Ortitay	REP	11694	58.23	24721	0	26	26	0	0
92	92	Representative in the General Assembly 46th District (Vote For 1)	Write-in	NON	23	0.11	24721	0	26	26	0	0
93	93	Representative in the General Assembly 54th District (Vote For 1)	REP Bob Brooks	REP	7206	95.96	11384	0	11	11	0	0
94	94	Representative in the General Assembly 54th District (Vote For 1)	Write-in	NON	303	4.04	11384	0	11	11	0	0
95	95	Pittsburgh HRC Amendment (Vote For 1)	Yes	NON	118479	78.33	239845	0	402	402	0	0
96	96	Pittsburgh HRC Amendment (Vote For 1)	No	NON	32781	21.67	239845	0	402	402	0	0