{
  "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,"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]
]}