{ "fields": [{"id":"_id","type":"int"},{"id":"line_number","type":"int4"},{"id":"contest_name","type":"text"},{"id":"choice_name","type":"text"},{"id":"party_name","type":"text"},{"id":"total_votes","type":"int4"},{"id":"percent_of_votes","type":"float8"},{"id":"registered_voters","type":"int4"},{"id":"ballots_cast","type":"int4"},{"id":"total_number_of_precincts","type":"int4"},{"id":"number_of_precincts_reporting","type":"int4"},{"id":"over_votes","type":"int4"},{"id":"under_votes","type":"int4"}], "records": [ [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] ]}