_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	United States Senator (Vote For 1)	DEM John Fetterman	DEM	363873	63.31	939390	577474	1323	1323	0	0
2	2	United States Senator (Vote For 1)	REP Mehmet Oz	REP	200632	34.91	939390	577474	1323	1323	0	0
3	3	United States Senator (Vote For 1)	LIB Erik Gerhardt	LIB	5190	0.9	939390	577474	1323	1323	0	0
4	4	United States Senator (Vote For 1)	GRN Richard L. Weiss	GRN	2343	0.41	939390	577474	1323	1323	0	0
5	5	United States Senator (Vote For 1)	KEY Daniel Wassmer	KEY	1671	0.29	939390	577474	1323	1323	0	0
6	6	United States Senator (Vote For 1)	Write-in	NON	1078	0.19	939390	577474	1323	1323	0	0
7	7	Governor and Lieutenant Governor (Vote For 1)	DEM Josh Shapiro	DEM	393386	68.6	939390	577474	1323	1323	0	0
8	8	Governor and Lieutenant Governor (Vote For 1)	REP Douglas V. Mastriano	REP	169913	29.63	939390	577474	1323	1323	0	0
9	9	Governor and Lieutenant Governor (Vote For 1)	LIB Matt Hackenburg	LIB	5354	0.93	939390	577474	1323	1323	0	0
10	10	Governor and Lieutenant Governor (Vote For 1)	GRN Christina DiGiulio	GRN	2319	0.4	939390	577474	1323	1323	0	0
11	11	Governor and Lieutenant Governor (Vote For 1)	KEY Joe Soloski	KEY	1841	0.32	939390	577474	1323	1323	0	0
12	12	Governor and Lieutenant Governor (Vote For 1)	Write-in	NON	606	0.11	939390	577474	1323	1323	0	0
13	13	Representative in Congress District 12 (Vote For 1)	DEM Summer Lee	DEM	166727	60.7	493214	282841	779	779	0	0
14	14	Representative in Congress District 12 (Vote For 1)	REP Mike Doyle	REP	106615	38.81	493214	282841	779	779	0	0
15	15	Representative in Congress District 12 (Vote For 1)	Write-in	NON	1352	0.49	493214	282841	779	779	0	0
16	16	Representative in Congress District 17 (Vote For 1)	DEM Chris Deluzio	DEM	163040	56.21	446922	295012	545	545	0	0
17	17	Representative in Congress District 17 (Vote For 1)	REP Jeremy Shaffer	REP	126445	43.59	446922	295012	545	545	0	0
18	18	Representative in Congress District 17 (Vote For 1)	Write-in	NON	582	0.2	446922	295012	545	545	0	0
19	19	Senator in the General Assembly District 38 (Vote For 1)	DEM Lindsey Williams	DEM	70854	55.71	191461	129139	249	249	0	0
20	20	Senator in the General Assembly District 38 (Vote For 1)	REP Lori Mizgorski	REP	56139	44.14	191461	129139	249	249	0	0
21	21	Senator in the General Assembly District 38 (Vote For 1)	Write-in	NON	182	0.14	191461	129139	249	249	0	0
22	22	Senator in the General Assembly District 42 (Vote For 1)	DEM Wayne D. Fontana	DEM	85905	96.07	185560	110276	292	292	0	0
23	23	Senator in the General Assembly District 42 (Vote For 1)	Write-in	NON	3512	3.93	185560	110276	292	292	0	0
24	24	Representative in the General Assembly District 19 (Vote For 1)	DEM Aerion Andrew Abney	DEM	16296	97.29	44872	19885	80	80	0	0
25	25	Representative in the General Assembly District 19 (Vote For 1)	Write-in	NON	454	2.71	44872	19885	80	80	0	0
26	26	Representative in the General Assembly District 20 (Vote For 1)	DEM Emily Kinkead	DEM	17783	60.99	45313	29791	62	62	0	0
27	27	Representative in the General Assembly District 20 (Vote For 1)	REP Matt Kruth	REP	11313	38.8	45313	29791	62	62	0	0
28	28	Representative in the General Assembly District 20 (Vote For 1)	Write-in	NON	61	0.21	45313	29791	62	62	0	0
29	29	Representative in the General Assembly District 21 (Vote For 1)	DEM Sara Innamorato	DEM	20255	63.47	49779	32647	79	79	0	0
30	30	Representative in the General Assembly District 21 (Vote For 1)	REP Frank Perman	REP	11601	36.35	49779	32647	79	79	0	0
31	31	Representative in the General Assembly District 21 (Vote For 1)	Write-in	NON	58	0.18	49779	32647	79	79	0	0
32	32	Representative in the General Assembly District 23 (Vote For 1)	DEM Dan Frankel	DEM	22340	87.16	52785	27348	64	64	0	0
33	33	Representative in the General Assembly District 23 (Vote For 1)	GRN Jay Ting Walker	GRN	2983	11.64	52785	27348	64	64	0	0
34	34	Representative in the General Assembly District 23 (Vote For 1)	Write-in	NON	307	1.2	52785	27348	64	64	0	0
35	35	Representative in the General Assembly District 24 (Vote For 1)	DEM LaTasha D. Mayes	DEM	21832	97.92	51199	25259	98	98	0	0
36	36	Representative in the General Assembly District 24 (Vote For 1)	Write-in	NON	464	2.08	51199	25259	98	98	0	0
37	37	Representative in the General Assembly District 25 (Vote For 1)	DEM Brandon J. Markosek	DEM	16655	60.06	46398	28228	66	66	0	0
38	38	Representative in the General Assembly District 25 (Vote For 1)	REP Steve Schlauch	REP	11025	39.76	46398	28228	66	66	0	0
39	39	Representative in the General Assembly District 25 (Vote For 1)	Write-in	NON	50	0.18	46398	28228	66	66	0	0
40	40	Representative in the General Assembly District 27 (Vote For 1)	DEM Daniel J. Deasy	DEM	18374	68.86	43640	27327	69	69	0	0
41	41	Representative in the General Assembly District 27 (Vote For 1)	REP Ed Brosky	REP	8263	30.97	43640	27327	69	69	0	0
42	42	Representative in the General Assembly District 27 (Vote For 1)	Write-in	NON	45	0.17	43640	27327	69	69	0	0
43	43	Representative in the General Assembly District 28 (Vote For 1)	REP Rob Mercuri	REP	18376	55.97	47729	33373	40	40	0	0
44	44	Representative in the General Assembly District 28 (Vote For 1)	DEM Alison Duncan	DEM	14432	43.95	47729	33373	40	40	0	0
45	45	Representative in the General Assembly District 28 (Vote For 1)	Write-in	NON	26	0.08	47729	33373	40	40	0	0
46	46	Representative in the General Assembly District 30 (Vote For 1)	DEM Arvind Venkat	DEM	18757	55.28	48294	34335	44	44	0	0
47	47	Representative in the General Assembly District 30 (Vote For 1)	REP Cindy Kirk	REP	15136	44.61	48294	34335	44	44	0	0
48	48	Representative in the General Assembly District 30 (Vote For 1)	Write-in	NON	36	0.11	48294	34335	44	44	0	0
49	49	Representative in the General Assembly District 32 (Vote For 1)	DEM Tony DeLuca	DEM	21796	82.69	48100	29891	68	68	0	0
50	50	Representative in the General Assembly District 32 (Vote For 1)	GRN Queonia Livingston	GRN	3555	13.49	48100	29891	68	68	0	0
51	51	Representative in the General Assembly District 32 (Vote For 1)	Write-in	NON	1009	3.83	48100	29891	68	68	0	0
52	52	Representative in the General Assembly District 33 (Vote For 1)	DEM Mandy Steele	DEM	15945	54.74	45065	29731	61	61	0	0
53	53	Representative in the General Assembly District 33 (Vote For 1)	REP Ted Tomson	REP	13120	45.04	45065	29731	61	61	0	0
54	54	Representative in the General Assembly District 33 (Vote For 1)	Write-in	NON	65	0.22	45065	29731	61	61	0	0
55	55	Representative in the General Assembly District 34 (Vote For 1)	DEM Summer Lee	DEM	22990	93.09	51357	29463	81	81	0	0
56	56	Representative in the General Assembly District 34 (Vote For 1)	Write-in	NON	1707	6.91	51357	29463	81	81	0	0
57	57	Representative in the General Assembly District 35 (Vote For 1)	DEM Austin Davis	DEM	15241	65.9	44675	23726	97	97	0	0
58	58	Representative in the General Assembly District 35 (Vote For 1)	REP Don Nevills	REP	7817	33.8	44675	23726	97	97	0	0
59	59	Representative in the General Assembly District 35 (Vote For 1)	Write-in	NON	71	0.31	44675	23726	97	97	0	0
60	60	Representative in the General Assembly District 36 (Vote For 1)	DEM Jessica Benham	DEM	17385	77.89	43646	24577	77	77	0	0
61	61	Representative in the General Assembly District 36 (Vote For 1)	LIB Ross Sylvester	LIB	4681	20.97	43646	24577	77	77	0	0
62	62	Representative in the General Assembly District 36 (Vote For 1)	Write-in	NON	254	1.14	43646	24577	77	77	0	0
63	63	Representative in the General Assembly District 38 (Vote For 1)	DEM Nick Pisciottano	DEM	20430	94.3	45001	28725	68	68	0	0
64	64	Representative in the General Assembly District 38 (Vote For 1)	Write-in	NON	1234	5.7	45001	28725	68	68	0	0
65	65	Representative in the General Assembly District 39 (Vote For 1)	REP Andrew Kuzma	REP	14596	58.76	37946	25384	48	48	0	0
66	66	Representative in the General Assembly District 39 (Vote For 1)	DEM Rick Self	DEM	10196	41.04	37946	25384	48	48	0	0
67	67	Representative in the General Assembly District 39 (Vote For 1)	Write-in	NON	50	0.2	37946	25384	48	48	0	0
68	68	Representative in the General Assembly District 40 (Vote For 1)	REP Natalie Mihalek	REP	12269	52.67	33475	23597	36	36	0	0
69	69	Representative in the General Assembly District 40 (Vote For 1)	DEM Chris Todd	DEM	10982	47.15	33475	23597	36	36	0	0
70	70	Representative in the General Assembly District 40 (Vote For 1)	Write-in	NON	43	0.18	33475	23597	36	36	0	0
71	71	Representative in the General Assembly District 42 (Vote For 1)	DEM Dan Miller	DEM	23409	68.02	50302	35118	68	68	0	0
72	72	Representative in the General Assembly District 42 (Vote For 1)	REP Pat Tylka	REP	10961	31.85	50302	35118	68	68	0	0
73	73	Representative in the General Assembly District 42 (Vote For 1)	Write-in	NON	43	0.12	50302	35118	68	68	0	0
74	74	Representative in the General Assembly District 44 (Vote For 1)	REP Valerie Gaydos	REP	16703	54.83	48204	30769	39	39	0	0
75	75	Representative in the General Assembly District 44 (Vote For 1)	DEM Debbie Turici	DEM	13719	45.03	48204	30769	39	39	0	0
76	76	Representative in the General Assembly District 44 (Vote For 1)	Write-in	NON	42	0.14	48204	30769	39	39	0	0
77	77	Representative in the General Assembly District 45 (Vote For 1)	DEM Anita Astorino Kulik	DEM	18222	63.26	47943	29261	63	63	0	0
78	78	Representative in the General Assembly District 45 (Vote For 1)	REP Michael Pendel	REP	10540	36.59	47943	29261	63	63	0	0
79	79	Representative in the General Assembly District 45 (Vote For 1)	Write-in	NON	41	0.14	47943	29261	63	63	0	0
80	80	Representative in the General Assembly District 46 (Vote For 1)	REP Jason Ortitay	REP	6480	93.76	13667	9039	15	15	0	0
81	81	Representative in the General Assembly District 46 (Vote For 1)	Write-in	NON	431	6.24	13667	9039	15	15	0	0
82	82	Member of Pittsburgh Council To Fill Vacancy District 5 (Vote For 1)	DEM Barbara Greenwood Warwick	DEM	11930	74.45	27084	16705	47	47	0	0
83	83	Member of Pittsburgh Council To Fill Vacancy District 5 (Vote For 1)	REP Eugene Bokor	REP	3066	19.13	27084	16705	47	47	0	0
84	84	Member of Pittsburgh Council To Fill Vacancy District 5 (Vote For 1)	IND Matthew Alan Mahoney	IND	828	5.17	27084	16705	47	47	0	0
85	85	Member of Pittsburgh Council To Fill Vacancy District 5 (Vote For 1)	RFC Robert McCune	RFC	134	0.84	27084	16705	47	47	0	0
86	86	Member of Pittsburgh Council To Fill Vacancy District 5 (Vote For 1)	Write-in	NON	67	0.42	27084	16705	47	47	0	0
87	87	Allegheny County Home Rule Charter Amendment (Vote For 1)	Yes	NON	305361	58.14	939390	577474	1323	1323	0	0
88	88	Allegheny County Home Rule Charter Amendment (Vote For 1)	No	NON	219822	41.86	939390	577474	1323	1323	0	0
89	89	Wilkinsburg Borough Question (Vote For 1)	Yes	NON	3446	59.36	12930	6270	17	17	0	0
90	90	Wilkinsburg Borough Question (Vote For 1)	No	NON	2359	40.64	12930	6270	17	17	0	0
91	91	Government Study Commissioner Wilkinsburg (Vote For 7)	Kimberly Kaplan	NON	2855	15.94	12930	6270	17	17	0	0
92	92	Government Study Commissioner Wilkinsburg (Vote For 7)	Beverly McCoy	NON	2669	14.9	12930	6270	17	17	0	0
93	93	Government Study Commissioner Wilkinsburg (Vote For 7)	Janet R. Harris	NON	2605	14.55	12930	6270	17	17	0	0
94	94	Government Study Commissioner Wilkinsburg (Vote For 7)	Cheryl Keywanda Ballard-Battle	NON	2467	13.78	12930	6270	17	17	0	0
95	95	Government Study Commissioner Wilkinsburg (Vote For 7)	Ruth Kittner	NON	2283	12.75	12930	6270	17	17	0	0
96	96	Government Study Commissioner Wilkinsburg (Vote For 7)	Paul O’Hanlon	NON	2278	12.72	12930	6270	17	17	0	0
97	97	Government Study Commissioner Wilkinsburg (Vote For 7)	Jacquet Kehm	NON	2261	12.62	12930	6270	17	17	0	0
98	98	Government Study Commissioner Wilkinsburg (Vote For 7)	Write-in	NON	491	2.74	12930	6270	17	17	0	0