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