Skip to content

Instantly share code, notes, and snippets.

@TGSmith

TGSmith/importing_political_db.rb

Forked from dbc-challenges/importing_political_db.rb
Last active December 19, 2015 14:08
Show Gist options
  • Save TGSmith/9d36555014456337c39e to your computer and use it in GitHub Desktop.
Save TGSmith/9d36555014456337c39e to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. TGSmith revised this gist Jul 11, 2013. 1 changed file with 0 additions and 4 deletions.
    4 changes: 0 additions & 4 deletions importing_political_db.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -1,10 +1,6 @@
    # Your code here
    require 'csv'
    require 'sqlite3'

    # If you want to overwrite your database you will need
    # to delete it before running this file

    class PoliticianDB

    @@politicians_stats =[]
  2. TGSmith revised this gist Jul 11, 2013. 1 changed file with 128 additions and 1 deletion.
    129 changes: 128 additions & 1 deletion importing_political_db.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1,128 @@
    # Your code here
    # Your code here
    require 'csv'
    require 'sqlite3'

    # If you want to overwrite your database you will need
    # to delete it before running this file

    class PoliticianDB

    @@politicians_stats =[]

    def self.setup
    system('rm politicians.db')
    $db = SQLite3::Database.new "politicians.db"
    $db.execute(
    <<-SQL
    CREATE TABLE politicians (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name VARCHAR(64) NOT NULL,
    party VARCHAR(64) NOT NULL,
    location_1 VARCHAR(2) NOT NULL,
    grade_level_since_1996 INTEGER (64) NOT NULL,
    grade_level_112th_congress INTEGER (64) NOT NUll,
    years_in_congress INTEGER (2) NOT NULL,
    dw1_score INTEGER (6) NOT NUll
    );
    SQL
    )
    end

    def self.seed
    CSV.foreach('politician_data.csv', :headers => true, :header_converters => :symbol ) do |row|
    @@politicians_stats << row
    end

    @@politicians_stats.each do |row|
    $db.execute(
    <<-SQL
    INSERT INTO politicians
    (name, party, location_1, grade_level_since_1996, grade_level_112th_congress, years_in_congress, dw1_score)
    VALUES
    ("#{row[:name]}", "#{row[:party]}", "#{row[:location_1]}", "#{row[:grade_level_since_1996]}", "#{row[:grade_level_112th_congress]}", "#{row[:years_in_congress]}", "#{row[:dw1_score]}");
    SQL
    )
    end
    end


    def self.where(col_name,param)
    $db.execute("SELECT * FROM politicians WHERE #{col_name} like '#{param}'")
    end

    # delete all based on column name and parameter
    def self.delete(col_name,param)
    $db.execute("DELETE FROM politicians WHERE #{col_name} like '#{param}'")
    end

    # delete primary keys / single row
    def self.delete_at_id(id)
    $db.execute("DELETE FROM politicians WHERE id = #{id}")
    end

    def self.insert(row={})
    $db.execute(
    <<-SQL
    INSERT INTO politicians
    (name, party, location_1, grade_level_since_1996, grade_level_112th_congress, years_in_congress, dw1_score)
    VALUES
    ("#{row[:name]}", "#{row[:party]}", "#{row[:location_1]}", "#{row[:grade_level_since_1996]}", "#{row[:grade_level_112th_congress]}", "#{row[:years_in_congress]}", "#{row[:dw1_score]}");
    SQL
    )
    end

    def self.update(id,num,row={})
    persons_data_pre_update = self.where(id,num)
    $db.execute(
    <<-SQL
    UPDATE politicians
    SET
    name ="#{row[:name] || persons_data_pre_update[0][1]}",
    party="#{row[:party] || persons_data_pre_update[0][2]}",
    location_1="#{row[:location_1] || persons_data_pre_update[0][3]}",
    grade_level_since_1996="#{row[:grade_level_since_1996] || persons_data_pre_update[0][4]}",
    grade_level_112th_congress="#{row[:grade_level_112th_congress] || persons_data_pre_update[0][5]}",
    years_in_congress="#{row[:years_in_congress] || persons_data_pre_update[0][6]}",
    dw1_score="#{row[:dw1_score] || persons_data_pre_update[0][7]}"
    WHERE "#{id}" = "#{num}"
    SQL
    )
    end

    def self.count(col_name,param)
    $db.execute(
    <<-SQL
    select "#{col_name}",count(*) from politicians where "#{col_name}"= "#{param}";
    SQL
    )
    end


    end

    #PoliticianDB.new
    PoliticianDB.setup
    PoliticianDB.seed
    # puts PoliticianDB.where('party','R')
    # puts PoliticianDB.where('name','Rep.%')
    # puts PoliticianDB.where('id','10')
    # puts PoliticianDB.delete(10)
    # puts PoliticianDB.where('id','10')

    puts PoliticianDB.insert(name:"Dave Hoover", party:"DBC", years_in_congress:5)
    p PoliticianDB.where('id','532')
    # 532 is Dave Hoover
    puts "** UPDATE **"
    PoliticianDB.update('id','532',name:"Super Dave",party:"RastaFarians")
    puts "** UPDATE **"
    puts PoliticianDB.where('id','532')

    # puts PoliticianDB.count('party','R') # 287
    # PoliticianDB.delete('party','R')
    # puts PoliticianDB.count('party','R') # 0



    # parser = PoliticianDB.new

  3. @dbc-challenges dbc-challenges revised this gist Apr 4, 2013. 1 changed file with 532 additions and 0 deletions.
    532 changes: 532 additions & 0 deletions politician_data.csv
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,532 @@
    Name,Party,Location 1,Grade Level (since 1996),Grade Level (112th Congress),Years in Congress,DW1 Score
    Rep. Mick Mulvaney,R,"SC (33.99855000018255, -81.0452500001872)",7.945704026,7.945704026,1,0.819
    Rep. Rob Woodall,R,"GA (32.83967999993223, -83.62758000031658)",8.0191087,8.0191087,1,0.688
    Sen. Rand Paul,R,"KY (37.645969999815804, -84.77496999996538)",8.039832522,8.039832522,1,0.941
    Rep. Sean Duffy,R,"WI (44.39319000021851, -89.8163600002137)",8.088706095,8.088706095,1,0.475
    Rep. Tim Griffin,R,"AR (34.748649999697875, -92.27448999971358)",8.129156251,8.129156251,1,0.441
    Rep. W. Todd Akin,R,"MO (38.63578999960896, -92.5663000000448)",8.140423512,7.709250144,11,0.623
    Rep. Vicky Hartzler,R,"MO (38.63578999960896, -92.5663000000448)",8.44408234,8.44408234,1,0.559
    Rep. Tom Graves,R,"GA (32.83967999993223, -83.62758000031658)",8.600184256,8.376188223,3,0.914
    Rep. David Schweikert,R,"AZ (34.86596999961597, -111.76380999973156)",8.606102568,8.606102568,1,0.622
    Sen. Ron Johnson,R,"WI (44.39319000021851, -89.8163600002137)",8.62470174,8.62470174,1,0.679
    Rep. Phil Roe,R,"TN (35.68094000038087, -85.77449000011325)",8.642390533,8.543112423,3,0.471
    Rep. Jeff Landry,R,"LA (31.312679999782347, -92.44565000034709)",8.644177038,8.644177038,1,0.598
    Rep. John Campbell,R,"CA (37.638300000444815, -120.99958999997835)",8.873045579,8.152157047,5,0.757
    Rep. Joe Walsh,R,"IL (40.485010000411364, -88.99770999971656)",8.907015863,8.907015863,1,0.719
    Rep. John Garamendi,D,"CA (37.638300000444815, -120.99958999997835)",8.923919506,8.931497241,3,-0.501
    Rep. Roscoe Bartlett,R,"MD (39.29057999976732, -76.6092600004485)",8.928747175,7.803678628,19,0.502
    Rep. John Lewis,D,"GA (32.83967999993223, -83.62758000031658)",8.938711508,7.00991988,25,-0.634
    Rep. Adam Kinzinger,R,"IL (40.485010000411364, -88.99770999971656)",8.995621754,8.995621754,1,0.303
    Rep. Paul Gosar,R,"AZ (34.86596999961597, -111.76380999973156)",9.00615631,9.00615631,1,0.446
    Rep. Colleen Hanabusa,D,"HI (21.304770000335395, -157.85761000030112)",9.007790571,9.007790571,1,-0.455
    Sen. Tom Coburn,R,"OK (35.4720099999617, -97.52034999975251)",9.086211896,9.207584574,5,0.797
    Rep. Jeff Flake,R,"AZ (34.86596999961597, -111.76380999973156)",9.140565697,8.969179007,11,0.988
    Rep. Jack Kingston,R,"GA (32.83967999993223, -83.62758000031658)",9.245243859,8.152576941,19,0.542
    Rep. John Carter,R,"TX (31.82724000022597, -99.42676999973554)",9.258185204,9.199844271,9,0.513
    Rep. Keith Ellison,D,"MN (46.3556499998478, -94.79419999982997)",9.300842411,8.87164922,5,-0.634
    Rep. Paul Broun,R,"GA (32.83967999993223, -83.62758000031658)",9.305255208,9.736146631,5,0.954
    Rep. Jason Chaffetz,R,"UT (39.36070000030492, -111.58712999994941)",9.339565934,8.866547873,3,0.706
    Sen. Jeff Sessions,R,"AL (32.840569999605975, -86.63186000013877)",9.352769181,8.673607537,13,0.522
    Rep. Tim Ryan,D,"OH (40.06020999969189, -82.40426000019869)",9.35688064,10.42791318,9,-0.433
    Rep. Louie Gohmert,R,"TX (31.82724000022597, -99.42676999973554)",9.369565081,10.09761887,5,0.54
    Sen. Jim Risch,R,"ID (43.682590000228515, -114.36368000023168)",9.384067765,9.100353664,3,0.527
    Rep. Bill Cassidy,R,"LA (31.312679999782347, -92.44565000034709)",9.385173006,9.285165569,3,0.43
    Rep. Bill Huizenga,R,"MI (44.661320000317914, -84.71438999959867)",9.38648322,9.38648322,1,0.616
    Sen. Marco Rubio,R,"FL (28.932039999846268, -81.9289599999039)",9.394009604,9.394009604,1,0.566
    Sen. Barbara Boxer,D,"CA (37.638300000444815, -120.99958999997835)",9.406367725,8.453452858,17,-0.494
    Sen. Lindsey Graham,R,"SC (33.99855000018255, -81.0452500001872)",9.421858701,9.385953338,7,0.431
    Rep. Todd Young,R,"IN (39.76690999989677, -86.14996000035359)",9.424087163,9.424087163,1,0.582
    Sen. John Hoeven,R,"ND (47.475320000018144, -100.11841999998285)",9.440101193,9.440101193,1,0.311
    Sen. Mike Johanns,R,"NE (41.6410400000961, -99.36572999973953)",9.473773277,9.508552296,3,0.41
    Rep. Mike Pompeo,R,"KS (38.34774000000118, -98.20077999969709)",9.486647309,9.486647309,1,0.679
    Rep. Jaime Herrera,R,"WA (47.521729999839806, -120.46997999977702)",9.488441317,9.488441317,1,0.397
    Rep. Richard Nugent,R,"FL (28.932039999846268, -81.9289599999039)",9.492296727,9.492296727,1,0.528
    Sen. Kent Conrad,D,"ND (47.475320000018144, -100.11841999998285)",9.511404005,9.55559028,23,-0.326
    Rep. Michele Bachmann,R,"MN (46.3556499998478, -94.79419999982997)",9.526568451,10.67842147,5,0.579
    Rep. Jim Jordan,R,"OH (40.06020999969189, -82.40426000019869)",9.535927071,9.816813118,5,0.67
    Rep. Lynn Westmoreland,R,"GA (32.83967999993223, -83.62758000031658)",9.548203993,11.00028914,5,0.687
    Rep. Blake Farenthold,R,"TX (31.82724000022597, -99.42676999973554)",9.551641347,9.551641347,1,0.518
    Sen. Chuck Schumer,D,"NY (42.82699999955048, -75.54396999981549)",9.564084796,9.934968234,11,-0.379
    Sen. Claire McCaskill,D,"MO (38.63578999960896, -92.5663000000448)",9.569931242,9.438729724,3,-0.177
    Rep. Renee Ellmers,R,"NC (35.46624999963797, -79.1593199999179)",9.587071649,9.587071649,1,0.494
    Rep. Morgan Griffith,R,"VA (37.54268000028196, -78.45789000012326)",9.60450071,9.60450071,1,0.529
    Rep. Bob Latta,R,"OH (40.06020999969189, -82.40426000019869)",9.626313402,12.68859731,5,0.536
    Rep. Mike Kelly,R,"PA (40.79372999993973, -77.86069999960512)",9.642195176,9.642195176,1,0.326
    Rep. Ted Poe,R,"TX (31.82724000022597, -99.42676999973554)",9.656611339,8.97799062,5,0.592
    Rep. Paul Ryan,R,"WI (44.39319000021851, -89.8163600002137)",9.665378424,9.692281492,13,0.567
    Sen. Harry Reid,D,"NV (39.49323999972637, -117.07183999971608)",9.732498769,9.889194496,23,-0.304
    Rep. Billy Long,R,"MO (38.63578999960896, -92.5663000000448)",9.732708807,9.732708807,1,0.726
    Rep. Bob Turner,NA,"NY (42.82699999955048, -75.54396999981549)",9.737185366,9.737185366,1,0.37
    Rep. Jim McDermott,D,"WA (47.521729999839806, -120.46997999977702)",9.747014004,9.847790821,23,-0.707
    Rep. John Carney,D,"DE (39.00883000020451, -75.57774000040052)",9.761836967,9.761836967,1,-0.264
    Rep. Hansen Clarke,D,"MI (44.661320000317914, -84.71438999959867)",9.79516128,9.79516128,1,-0.525
    Sen. Barbara Mikulski,D,"MD (39.29057999976732, -76.6092600004485)",9.805853241,8.828579926,23,-0.395
    Rep. James Lankford,R,"OK (35.4720099999617, -97.52034999975251)",9.830000761,9.830000761,1,0.553
    Rep. Peter DeFazio,D,"OR (44.567449999917756, -120.15502999983448)",9.83226533,8.109878414,25,-0.491
    Sen. Max Baucus,D,"MT (47.06653000015956, -109.42441999998289)",9.841093618,9.536344201,31,-0.226
    Rep. Andy Harris,R,"MD (39.29057999976732, -76.6092600004485)",9.852486393,9.852486393,1,0.519
    Rep. Scott DesJarlais,R,"TN (35.68094000038087, -85.77449000011325)",9.871864437,9.871864437,1,0.507
    Sen. Jon Tester,D,"MT (47.06653000015956, -109.42441999998289)",9.886412218,9.96681469,3,-0.278
    Sen. John Barrasso,R,"WY (43.23553999957147, -108.10982999975454)",9.93651933,10.03877047,3,0.532
    Rep. Steve Southerland,R,"FL (28.932039999846268, -81.9289599999039)",9.941099392,9.941099392,1,0.637
    Rep. Justin Amash,R,"MI (44.661320000317914, -84.71438999959867)",9.97152565,9.97152565,1,0.837
    Rep. Adam Smith,D,"WA (47.521729999839806, -120.46997999977702)",9.984028932,10.23695519,15,-0.286
    Sen. Al Franken,D,"MN (46.3556499998478, -94.79419999982997)",9.988261501,9.791044599,3,-0.472
    Rep. Carolyn McCarthy,D,"NY (42.82699999955048, -75.54396999981549)",10.01261016,9.060894272,15,-0.322
    Rep. John Fleming,R,"LA (31.312679999782347, -92.44565000034709)",10.03720494,9.633162683,3,0.547
    Rep. Tim Walz,D,"MN (46.3556499998478, -94.79419999982997)",10.06191897,9.45589632,5,-0.318
    Sen. Bob Corker,R,"TN (35.68094000038087, -85.77449000011325)",10.06425485,10.16211342,3,0.381
    Sen. Tom Harkin,D,"IA (42.469390000048634, -93.81649000001335)",10.08534147,10.46019521,25,-0.383
    Sen. Jim Inhofe,R,"OK (35.4720099999617, -97.52034999975251)",10.10777643,8.850339999,17,0.545
    Rep. Kristi Noem,R,"SD (44.353130000049646, -100.37353000040906)",10.12080178,10.12080178,1,0.377
    Rep. John Shimkus,R,"IL (40.485010000411364, -88.99770999971656)",10.12259705,9.677383947,15,0.399
    Rep. Steve King,R,"IA (42.469390000048634, -93.81649000001335)",10.14024202,9.7609665,9,0.654
    Rep. Cedric Richmond,D,"LA (31.312679999782347, -92.44565000034709)",10.14819402,10.14819402,1,-0.458
    Rep. Reid Ribble,R,"WI (44.39319000021851, -89.8163600002137)",10.15082351,10.15082351,1,0.576
    Rep. Leonard Boswell,D,"IA (42.469390000048634, -93.81649000001335)",10.16184891,11.94072596,15,-0.251
    Rep. Marsha Blackburn,R,"TN (35.68094000038087, -85.77449000011325)",10.21812157,9.913911437,9,0.623
    Rep. Patrick McHenry,R,"NC (35.46624999963797, -79.1593199999179)",10.21845047,9.311120785,5,0.606
    Rep. Tim Huelskamp,R,"KS (38.34774000000118, -98.20077999969709)",10.23278515,10.23278515,1,0.693
    Sen. Amy Klobuchar,D,"MN (46.3556499998478, -94.79419999982997)",10.24111162,11.17663866,3,-0.252
    Rep. David Scott,D,"GA (32.83967999993223, -83.62758000031658)",10.29979327,11.89754654,9,-0.321
    Sen. Dick Durbin,D,"IL (40.485010000411364, -88.99770999971656)",10.30383915,9.874456863,13,-0.396
    Rep. Alan Nunnelee,R,"MS (32.7455100000866, -89.53803000008429)",10.33893365,10.33893365,1,0.464
    Rep. Jim Cooper,D,"TN (35.68094000038087, -85.77449000011325)",10.35578778,12.64456656,9,-0.168
    Rep. Steve Pearce,R,"NM (34.52088000011207, -106.24057999976702)",10.40568385,8.702004998,1,0.475
    Rep. Todd Rokita,R,"IN (39.76690999989677, -86.14996000035359)",10.40819089,10.40819089,1,0.635
    Rep. Tom Price,R,"GA (32.83967999993223, -83.62758000031658)",10.41433438,10.27515788,5,0.642
    Rep. Collin Peterson,D,"MN (46.3556499998478, -94.79419999982997)",10.41898905,7.370128281,21,-0.156
    Sen. Lamar Alexander,R,"TN (35.68094000038087, -85.77449000011325)",10.43178725,10.037117,7,0.323
    Rep. Robert Dold,R,"IL (40.485010000411364, -88.99770999971656)",10.43953638,10.43953638,1,0.216
    Sen. Mark Begich,D,"AK (64.84507999974238, -147.72205999986895)",10.44329608,9.884166067,3,-0.265
    Sen. Tom Carper,D,"DE (39.00883000020451, -75.57774000040052)",10.45066264,9.429126373,9,-0.189
    Sen. Frank Lautenberg,D,"NJ (40.13056999960594, -74.2736899996936)",10.46638173,8.892749062,25,-0.417
    Rep. Jeb Hensarling,R,"TX (31.82724000022597, -99.42676999973554)",10.48135428,10.08517441,9,0.745
    Rep. Steve Womack,R,"AR (34.748649999697875, -92.27448999971358)",10.48409649,10.48409649,1,0.385
    Rep. Sue Myrick,R,"NC (35.46624999963797, -79.1593199999179)",10.5174255,11.06623232,17,0.564
    Rep. Diane Black,R,"TN (35.68094000038087, -85.77449000011325)",10.52256176,10.52256176,1,0.563
    Rep. Frederica Wilson,D,"FL (28.932039999846268, -81.9289599999039)",10.52461077,10.52461077,1,-0.528
    Sen. Mike Enzi,R,"WY (43.23553999957147, -108.10982999975454)",10.5294844,9.900257526,13,0.536
    Rep. G.T. Thompson,R,"PA (40.79372999993973, -77.86069999960512)",10.52952723,10.92647774,3,0.353
    Sen. Scott Brown,R,"MA (42.27687000005062, -72.08269000004333)",10.53798123,10.66036944,1,0.14
    Rep. Jean Schmidt,R,"OH (40.06020999969189, -82.40426000019869)",10.541653,10.28087271,5,0.456
    Sen. Pat Toomey,R,"PA (40.79372999993973, -77.86069999960512)",10.55653989,10.54057815,1,0.684
    Rep. Martha Roby,R,"AL (32.840569999605975, -86.63186000013877)",10.57494649,10.57494649,1,0.421
    Rep. Barney Frank,D,"MA (42.27687000005062, -72.08269000004333)",10.59676957,10.93028123,31,-0.545
    Rep. Spencer Bachus,R,"AL (32.840569999605975, -86.63186000013877)",10.60047552,8.729368044,19,0.403
    Rep. Steve Israel,D,"NY (42.82699999955048, -75.54396999981549)",10.61761703,11.10965414,11,-0.348
    Sen. Mark Pryor,D,"AR (34.748649999697875, -92.27448999971358)",10.62615305,10.24196589,7,-0.217
    Rep. Jason Altmire,D,"PA (40.79372999993973, -77.86069999960512)",10.64498127,12.49390706,5,-0.135
    Rep. Kurt Schrader,D,"OR (44.567449999917756, -120.15502999983448)",10.64703194,9.200550044,3,-0.242
    Rep. Virginia Foxx,R,"NC (35.46624999963797, -79.1593199999179)",10.68441549,11.51441629,5,0.665
    Rep. Brad Miller,D,"NC (35.46624999963797, -79.1593199999179)",10.69421326,9.83455354,9,-0.392
    Rep. Steven LaTourette,R,"OH (40.06020999969189, -82.40426000019869)",10.70217756,9.577295426,17,0.206
    Rep. Chellie Pingree,D,"ME (45.25423000041434, -68.9850299999344)",10.70700752,11.82216879,3,-0.504
    Rep. Sandy Levin,D,"MI (44.661320000317914, -84.71438999959867)",10.71169979,9.643528519,29,-0.403
    Rep. Jeff Duncan,R,"SC (33.99855000018255, -81.0452500001872)",10.7237566,10.7237566,1,0.73
    Rep. Rick Berg,R,"ND (47.475320000018144, -100.11841999998285)",10.72381738,10.72381738,1,0.384
    Rep. Sam Johnson,R,"TX (31.82724000022597, -99.42676999973554)",10.7291433,11.0153039,21,0.617
    Sen. Michael Bennet,D,"CO (38.842890000173554, -106.13314000041055)",10.74000638,10.98091322,3,-0.233
    Rep. Ed Perlmutter,D,"CO (38.842890000173554, -106.13314000041055)",10.74240034,11.0435273,5,-0.328
    Rep. Joe Barton,R,"TX (31.82724000022597, -99.42676999973554)",10.74846842,10.8812134,27,0.531
    Sen. Debbie Stabenow,D,"MI (44.661320000317914, -84.71438999959867)",10.74924135,10.78433996,9,-0.347
    Sen. Joe Manchin,D,"WV (38.66550000002513, -80.71265999975901)",10.74993555,10.78020713,1,-0.144
    Rep. Steny Hoyer,D,"MD (39.29057999976732, -76.6092600004485)",10.76384059,10.1692588,31,-0.395
    Rep. Peter Welch,D,"VT (43.625379999687425, -72.51764000028561)",10.76635787,9.794898585,5,-0.475
    Rep. Joe Pitts,R,"PA (40.79372999993973, -77.86069999960512)",10.76713223,10.19978603,15,0.55
    Rep. Cynthia Lummis,R,"WY (43.23553999957147, -108.10982999975454)",10.78270382,10.62371903,3,0.642
    Rep. Pete Olson,R,"TX (31.82724000022597, -99.42676999973554)",10.78388016,10.53141704,3,0.534
    Rep. Ben Quayle,R,"AZ (34.86596999961597, -111.76380999973156)",10.78574918,10.78574918,1,0.667
    Rep. Scott Rigell,R,"VA (37.54268000028196, -78.45789000012326)",10.80243077,10.80243077,1,0.417
    Rep. Norm Dicks,D,"WA (47.521729999839806, -120.46997999977702)",10.82470825,9.401615717,35,-0.337
    Rep. Sandra Adams,R,"FL (28.932039999846268, -81.9289599999039)",10.83305057,10.83305057,1,0.538
    Rep. Steve Scalise,R,"LA (31.312679999782347, -92.44565000034709)",10.83806557,10.62902546,5,0.562
    Sen. Mary Landrieu,D,"LA (31.312679999782347, -92.44565000034709)",10.84550526,10.08440707,13,-0.208
    Rep. James Scott,R,"GA (32.83967999993223, -83.62758000031658)",10.85012027,10.85012027,1,0.618
    Sen. Kay Hutchison,R,"TX (31.82724000022597, -99.42676999973554)",10.85621564,10.30025068,17,0.358
    Sen. Bernie Sanders,I,"VT (43.625379999687425, -72.51764000028561)",10.85790012,10.82875787,3,-0.541
    Rep. Michael McCaul,R,"TX (31.82724000022597, -99.42676999973554)",10.86420859,11.46144825,5,0.434
    Rep. Mike Conaway,R,"TX (31.82724000022597, -99.42676999973554)",10.86482078,11.71437757,5,0.6
    Sen. Jim DeMint,R,"SC (33.99855000018255, -81.0452500001872)",10.873416,10.45989077,5,0.689
    Sen. Jeff Merkley,D,"OR (44.567449999917756, -120.15502999983448)",10.88716111,10.70749443,3,-0.441
    Sen. Roy Blunt,R,"MO (38.63578999960896, -92.5663000000448)",10.88782365,10.69991534,1,0.462
    Rep. John Barrow,D,"GA (32.83967999993223, -83.62758000031658)",10.88918982,11.2579999,5,-0.132
    Rep. Mike Capuano,D,"MA (42.27687000005062, -72.08269000004333)",10.89077979,9.524571901,13,-0.627
    Sen. Patty Murray,D,"WA (47.521729999839806, -120.46997999977702)",10.89496534,12.00622728,17,-0.375
    Rep. Judy Chu,D,"CA (37.638300000444815, -120.99958999997835)",10.89733937,10.72506788,3,-0.576
    Rep. Rob Bishop,R,"UT (39.36070000030492, -111.58712999994941)",10.89914919,10.9061909,9,0.529
    Sen. Dean Heller,R,"NV (39.49323999972637, -117.07183999971608)",10.91706525,11.30904753,3,0.475
    Rep. Frank Guinta,R,"NH (43.65595000019255, -71.50036000041354)",10.94131093,10.94131093,1,0.452
    Rep. Loretta Sanchez,D,"CA (37.638300000444815, -120.99958999997835)",10.94136251,10.45767933,15,-0.404
    Rep. Cory Gardner,R,"CO (38.842890000173554, -106.13314000041055)",10.95202472,10.95202472,1,0.47
    Rep. Steve Cohen,D,"TN (35.68094000038087, -85.77449000011325)",10.96042647,10.51720605,5,-0.447
    Rep. Denny Rehberg,R,"MT (47.06653000015956, -109.42441999998289)",10.96521499,9.011086686,11,0.357
    Rep. Jay Inslee,D,"WA (47.521729999839806, -120.46997999977702)",10.9662909,12.49223815,13,-0.361
    Rep. Hal Rogers,R,"KY (37.645969999815804, -84.77496999996538)",10.96695139,11.01737416,31,0.332
    Rep. Jim Matheson,D,"UT (39.36070000030492, -111.58712999994941)",10.98124346,9.908922019,11,-0.147
    Rep. Rick Crawford,R,"AR (34.748649999697875, -92.27448999971358)",10.9829153,10.9829153,1,0.39
    Rep. Mike Ross,D,"AR (34.748649999697875, -92.27448999971358)",11.00816589,11.78598487,11,-0.189
    Rep. Bill Pascrell,D,"NJ (40.13056999960594, -74.2736899996936)",11.01155316,10.00286058,15,-0.385
    Rep. Devin Nunes,R,"CA (37.638300000444815, -120.99958999997835)",11.01959668,13.1721979,9,0.498
    Rep. Walter Jones,R,"NC (35.46624999963797, -79.1593199999179)",11.02540687,9.56224455,17,0.255
    Sen. Richard Burr,R,"NC (35.46624999963797, -79.1593199999179)",11.03420827,10.27153443,5,0.463
    Rep. Peter Roskam,R,"IL (40.485010000411364, -88.99770999971656)",11.03473829,11.35072504,5,0.454
    Rep. Tim Scott,R,"SC (33.99855000018255, -81.0452500001872)",11.03762497,11.03762497,1,0.692
    Sen. Sherrod Brown,D,"OH (40.06020999969189, -82.40426000019869)",11.04122803,10.89716997,3,-0.478
    Rep. Larry Bucshon,R,"IN (39.76690999989677, -86.14996000035359)",11.05203366,11.05203366,1,0.409
    Sen. Rob Portman,R,"OH (40.06020999969189, -82.40426000019869)",11.06587116,11.18598554,1,0.383
    Rep. Maxine Waters,D,"CA (37.638300000444815, -120.99958999997835)",11.07508798,10.86445009,21,-0.713
    Rep. Dennis Ross,R,"FL (28.932039999846268, -81.9289599999039)",11.08201007,11.08201007,1,0.599
    Rep. Nydia Velazquez,D,"NY (42.82699999955048, -75.54396999981549)",11.08261499,10.49046458,19,-0.588
    Rep. Larry Kissell,D,"NC (35.46624999963797, -79.1593199999179)",11.089339,12.78093759,3,-0.23
    Rep. John Kline,R,"MN (46.3556499998478, -94.79419999982997)",11.09042733,10.41051711,9,0.518
    Rep. Kevin Brady,R,"TX (31.82724000022597, -99.42676999973554)",11.10132626,10.70341838,15,0.525
    Rep. Trey Gowdy,R,"SC (33.99855000018255, -81.0452500001872)",11.10406386,11.10406386,1,0.732
    Rep. Bill Johnson,R,"OH (40.06020999969189, -82.40426000019869)",11.10618624,11.10618624,1,0.514
    Rep. Tim Murphy,R,"PA (40.79372999993973, -77.86069999960512)",11.10854759,10.83301731,9,0.232
    Rep. Jim McGovern,D,"MA (42.27687000005062, -72.08269000004333)",11.11871751,10.12885643,15,-0.569
    Rep. Dana Rohrabacher,R,"CA (37.638300000444815, -120.99958999997835)",11.12704088,10.64634133,23,0.612
    Rep. Michael Burgess,R,"TX (31.82724000022597, -99.42676999973554)",11.12705528,10.61371576,9,0.523
    Rep. Marcy Kaptur,D,"OH (40.06020999969189, -82.40426000019869)",11.13553346,10.18833423,29,-0.364
    Rep. Luis Gutierrez,D,"IL (40.485010000411364, -88.99770999971656)",11.13779176,11.630582,19,-0.52
    Rep. C. W. Bill Young,R,"FL (28.932039999846268, -81.9289599999039)",11.14062956,11.73006765,41,0.323
    Rep. Joe Baca,D,"CA (37.638300000444815, -120.99958999997835)",11.14498196,10.38865516,13,-0.36
    Rep. Paul Tonko,D,"NY (42.82699999955048, -75.54396999981549)",11.14675494,10.39343542,3,-0.478
    Rep. Tim Johnson,R,"IL (40.485010000411364, -88.99770999971656)",11.15692179,12.43813594,11,0.223
    Sen. Mitch McConnell,R,"KY (37.645969999815804, -84.77496999996538)",11.15845336,10.56354832,25,0.407
    Rep. Kevin McCarthy,R,"CA (37.638300000444815, -120.99958999997835)",11.16752671,9.905327689,5,0.477
    Rep. Chip Cravaack,R,"MN (46.3556499998478, -94.79419999982997)",11.17342334,11.17342334,1,0.387
    Rep. Jim Himes,D,"CT (41.56265999995918, -72.6498400002157)",11.17891952,10.68857069,3,-0.258
    Rep. Marlin Stutzman,R,"IN (39.76690999989677, -86.14996000035359)",11.17965554,11.2987772,3,0.781
    Rep. Charles Boustany,R,"LA (31.312679999782347, -92.44565000034709)",11.18300929,10.58163285,5,0.406
    Rep. Marcia Fudge,D,"OH (40.06020999969189, -82.40426000019869)",11.19069793,10.58342866,3,-0.63
    Rep. Mike Michaud,D,"ME (45.25423000041434, -68.9850299999344)",11.19493536,12.26120545,9,-0.306
    Rep. Randy Neugebauer,R,"TX (31.82724000022597, -99.42676999973554)",11.21081811,9.592398016,9,0.622
    Rep. Bob Gibbs,R,"OH (40.06020999969189, -82.40426000019869)",11.21755543,11.21755543,1,0.466
    Rep. Vern Buchanan,R,"FL (28.932039999846268, -81.9289599999039)",11.22031355,11.00220436,5,0.325
    Rep. John Yarmuth,D,"KY (37.645969999815804, -84.77496999996538)",11.22047341,11.05725021,5,-0.405
    Rep. Ander Crenshaw,R,"FL (28.932039999846268, -81.9289599999039)",11.22521629,8.329363943,11,0.367
    Rep. Tom Reed,R,"NY (42.82699999955048, -75.54396999981549)",11.23384017,11.23242037,3,0.378
    Rep. Raul Labrador,R,"ID (43.682590000228515, -114.36368000023168)",11.24334549,11.24334549,1,0.675
    Rep. Corrine Brown,D,"FL (28.932039999846268, -81.9289599999039)",11.24973926,11.35143072,19,-0.448
    Rep. Jackie Speier,D,"CA (37.638300000444815, -120.99958999997835)",11.25168287,10.87586683,5,-0.437
    Rep. Eliot Engel,D,"NY (42.82699999955048, -75.54396999981549)",11.25326661,10.98003867,23,-0.445
    Sen. Sheldon Whitehouse,D,"RI (41.70828000002217, -71.5224700001902)",11.25923664,11.40970245,3,-0.485
    Rep. Mike Rogers,R,"MI (44.661320000317914, -84.71438999959867)",11.27219414,11.90823499,11,0.404
    Rep. Kay Granger,R,"TX (31.82724000022597, -99.42676999973554)",11.27280191,12.51301314,15,0.407
    Rep. Lynn Woolsey,D,"CA (37.638300000444815, -120.99958999997835)",11.27802496,11.52678725,19,-0.602
    Rep. Donna Edwards,D,"MD (39.29057999976732, -76.6092600004485)",11.27955642,11.64036048,5,-0.621
    Rep. Phil Gingrey,R,"GA (32.83967999993223, -83.62758000031658)",11.28128439,10.91239791,9,0.564
    Rep. Mario Diaz-Balart,R,"FL (28.932039999846268, -81.9289599999039)",11.28135388,12.12087872,19,0.298
    Rep. Dan Burton,R,"IN (39.76690999989677, -86.14996000035359)",11.2893328,11.20189947,29,0.58
    Rep. David McKinley,R,"WV (38.66550000002513, -80.71265999975901)",11.29332705,11.29332705,1,0.255
    Rep. Lee Terry,R,"NE (41.6410400000961, -99.36572999973953)",11.29466453,9.816832242,13,0.433
    Rep. Bobby Rush,D,"IL (40.485010000411364, -88.99770999971656)",11.29658092,11.7401258,19,-0.521
    Rep. Dan Benishek,R,"MI (44.661320000317914, -84.71438999959867)",11.29829673,11.29829673,1,0.625
    Rep. Rosa DeLauro,D,"CT (41.56265999995918, -72.6498400002157)",11.30023233,11.50569159,21,-0.446
    Sen. Johnny Isakson,R,"GA (32.83967999993223, -83.62758000031658)",11.30079649,10.97999097,5,0.426
    Rep. Steve Chabot,R,"OH (40.06020999969189, -82.40426000019869)",11.30351362,11.00146106,1,0.656
    Rep. Tom Cole,R,"OK (35.4720099999617, -97.52034999975251)",11.30764419,10.04233842,9,0.384
    Sen. Roger Wicker,R,"MS (32.7455100000866, -89.53803000008429)",11.30826094,11.42754394,3,0.381
    Rep. Rob Andrews,D,"NJ (40.13056999960594, -74.2736899996936)",11.31613651,10.55875645,23,-0.317
    Rep. Mel Watt,D,"NC (35.46624999963797, -79.1593199999179)",11.3239499,12.40457599,19,-0.569
    Rep. Chris Murphy,D,"CT (41.56265999995918, -72.6498400002157)",11.32542369,11.44088032,5,-0.35
    Rep. Mo Brooks,R,"AL (32.840569999605975, -86.63186000013877)",11.33336286,11.33336286,1,0.524
    Rep. Dave Camp,R,"MI (44.661320000317914, -84.71438999959867)",11.34863768,12.33017731,21,0.383
    Rep. Eric Cantor,R,"VA (37.54268000028196, -78.45789000012326)",11.35088324,10.75530301,11,0.544
    Rep. Daniel Webster,R,"FL (28.932039999846268, -81.9289599999039)",11.37180455,11.37180455,1,0.499
    Rep. Betty Sutton,D,"OH (40.06020999969189, -82.40426000019869)",11.37718676,10.76741012,5,-0.474
    Rep. John Mica,R,"FL (28.932039999846268, -81.9289599999039)",11.38286299,14.78868463,19,0.451
    Rep. Mike Coffman,R,"CO (38.842890000173554, -106.13314000041055)",11.39639447,11.70018711,3,0.548
    Sen. Chuck Grassley,R,"IA (42.469390000048634, -93.81649000001335)",11.40069903,11.35413552,29,0.329
    Sen. David Vitter,R,"LA (31.312679999782347, -92.44565000034709)",11.40166619,10.18732547,5,0.485
    Rep. Bob Filner,D,"CA (37.638300000444815, -120.99958999997835)",11.40266006,10.40423678,19,-0.682
    Rep. Doug Lamborn,R,"CO (38.842890000173554, -106.13314000041055)",11.40384295,10.57404149,5,0.719
    Rep. Don Manzullo,R,"IL (40.485010000411364, -88.99770999971656)",11.42243971,9.619578906,19,0.505
    Sen. Jeanne Shaheen,D,"NH (43.65595000019255, -71.50036000041354)",11.42316099,11.28573728,3,-0.31
    Rep. Greg Walden,R,"OR (44.567449999917756, -120.15502999983448)",11.42571935,10.56657327,13,0.327
    Rep. Shelley Berkley,D,"NV (39.49323999972637, -117.07183999971608)",11.42738241,12.61123148,13,-0.335
    Rep. Dave Reichert,R,"WA (47.521729999839806, -120.46997999977702)",11.42921065,10.18782262,5,0.192
    Rep. Quico Canseco,R,"TX (31.82724000022597, -99.42676999973554)",11.4391491,11.4391491,1,0.593
    Rep. Sam Farr,D,"CA (37.638300000444815, -120.99958999997835)",11.4425314,10.33623431,19,-0.495
    Rep. Randy Hultgren,R,"IL (40.485010000411364, -88.99770999971656)",11.4451789,11.4451789,1,0.47
    Sen. Pat Roberts,R,"KS (38.34774000000118, -98.20077999969709)",11.44822065,11.05252786,13,0.408
    Sen. Bob Casey,D,"PA (40.79372999993973, -77.86069999960512)",11.45086259,11.52004447,3,-0.355
    Rep. Chuck Fleischmann,R,"TN (35.68094000038087, -85.77449000011325)",11.45186791,11.45186791,1,0.499
    Rep. Richard Neal,D,"MA (42.27687000005062, -72.08269000004333)",11.46037959,11.94310032,23,-0.448
    Sen. Bill Nelson,D,"FL (28.932039999846268, -81.9289599999039)",11.46127922,11.02162928,9,-0.195
    Rep. Steven Palazzo,R,"MS (32.7455100000866, -89.53803000008429)",11.47302413,11.47302413,1,0.467
    Rep. Candice Miller,R,"MI (44.661320000317914, -84.71438999959867)",11.47718297,11.70865922,9,0.306
    Rep. Joe Heck,R,"NV (39.49323999972637, -117.07183999971608)",11.4806753,11.4806753,1,0.301
    Rep. Tom Rooney,R,"FL (28.932039999846268, -81.9289599999039)",11.48111739,11.81099812,3,0.462
    Rep. Nancy Pelosi,D,"CA (37.638300000444815, -120.99958999997835)",11.494933,10.40187415,25,-0.533
    Rep. Bill Posey,R,"FL (28.932039999846268, -81.9289599999039)",11.49902895,11.74768224,3,0.425
    Rep. Al Green,D,"TX (31.82724000022597, -99.42676999973554)",11.50251314,10.17197979,19,-0.336
    Rep. Lou Barletta,R,"PA (40.79372999993973, -77.86069999960512)",11.50507481,11.50507481,1,0.273
    Rep. Ann Buerkle,R,"NY (42.82699999955048, -75.54396999981549)",11.51220445,11.51220445,1,0.555
    Rep. Louise Slaughter,D,"NY (42.82699999955048, -75.54396999981549)",11.51391723,11.3084751,25,-0.499
    Rep. Judy Biggert,R,"IL (40.485010000411364, -88.99770999971656)",11.53375244,11.31173326,13,0.312
    Rep. Ed Royce,R,"CA (37.638300000444815, -120.99958999997835)",11.54885077,10.60215458,19,0.698
    Rep. Nan Hayworth,R,"NY (42.82699999955048, -75.54396999981549)",11.55167758,11.55167758,1,0.325
    Rep. Xavier Becerra,D,"CA (37.638300000444815, -120.99958999997835)",11.55180852,12.09465575,19,-0.554
    Rep. Tom McClintock,R,"CA (37.638300000444815, -120.99958999997835)",11.55782293,11.75820833,3,0.733
    Rep. Gene Green,D,"TX (31.82724000022597, -99.42676999973554)",11.56577067,10.90283608,19,-0.336
    Rep. Mike Grimm,R,"NY (42.82699999955048, -75.54396999981549)",11.5689815,11.5689815,1,0.229
    Rep. Charlie Gonzalez,D,"TX (31.82724000022597, -99.42676999973554)",11.57108466,11.9997775,13,-0.358
    Rep. Blaine Luetkemeyer,R,"MO (38.63578999960896, -92.5663000000448)",11.57167384,11.71185443,3,0.474
    Rep. Scott Tipton,R,"CO (38.842890000173554, -106.13314000041055)",11.57463228,11.57463228,1,0.473
    Rep. Yvette Clarke,D,"NY (42.82699999955048, -75.54396999981549)",11.57539568,12.45211362,5,-0.65
    Rep. Frank Wolf,R,"VA (37.54268000028196, -78.45789000012326)",11.57705929,12.31302565,31,0.27
    Sen. Tom Udall,D,"NM (34.52088000011207, -106.24057999976702)",11.57785056,10.82604949,3,-0.492
    Rep. E. Scott Garrett,R,"NJ (40.13056999960594, -74.2736899996936)",11.5793931,11.46392336,9,0.689
    Rep. Pat Tiberi,R,"OH (40.06020999969189, -82.40426000019869)",11.58155685,12.22177473,11,0.391
    Rep. Cliff Stearns,R,"FL (28.932039999846268, -81.9289599999039)",11.58158493,12.24249672,23,0.543
    Rep. Jan Schakowsky,D,"IL (40.485010000411364, -88.99770999971656)",11.60863404,11.23485854,13,-0.647
    Rep. Lois Capps,D,"CA (37.638300000444815, -120.99958999997835)",11.60967322,10.86990742,15,-0.43
    Rep. Emanuel Cleaver,D,"MO (38.63578999960896, -92.5663000000448)",11.6140621,10.39774268,5,-0.491
    Rep. Jose Serrano,D,"NY (42.82699999955048, -75.54396999981549)",11.63151463,11.91226777,23,-0.533
    Rep. Tim Holden,D,"PA (40.79372999993973, -77.86069999960512)",11.65326068,11.09665957,19,-0.227
    Rep. Doc Hastings,R,"WA (47.521729999839806, -120.46997999977702)",11.67382886,10.19107844,17,0.45
    Rep. Jared Polis,D,"CO (38.842890000173554, -106.13314000041055)",11.68308999,11.7024764,3,-0.39
    Rep. Jerry McNerney,D,"CA (37.638300000444815, -120.99958999997835)",11.68624601,11.18463914,5,-0.25
    Rep. Steven Guthrie,R,"KY (37.645969999815804, -84.77496999996538)",11.69094614,10.32590976,3,0.366
    Rep. Darrell Issa,R,"CA (37.638300000444815, -120.99958999997835)",11.69576386,11.69868557,11,0.515
    Rep. Dennis Cardoza,D,"CA (37.638300000444815, -120.99958999997835)",11.6958084,13.47444904,9,-0.252
    Rep. Bobby Scott,D,"VA (37.54268000028196, -78.45789000012326)",11.7040888,10.95960347,19,-0.491
    Rep. Shelley Capito,R,"WV (38.66550000002513, -80.71265999975901)",11.70412706,11.26570247,11,0.246
    Sen. Orrin Hatch,R,"UT (39.36070000030492, -111.58712999994941)",11.70935336,10.82183029,33,0.39
    Rep. Susan Davis,D,"CA (37.638300000444815, -120.99958999997835)",11.71248165,10.36043193,11,-0.371
    Rep. Bobby Schilling,R,"IL (40.485010000411364, -88.99770999971656)",11.72955238,11.72955238,1,0.374
    Rep. Frank Lucas,R,"OK (35.4720099999617, -97.52034999975251)",11.73246665,10.51124685,19,0.392
    Rep. Nita Lowey,D,"NY (42.82699999955048, -75.54396999981549)",11.73859371,13.61995452,23,-0.418
    Rep. John Duncan,R,"TN (35.68094000038087, -85.77449000011325)",11.7459653,10.54035646,25,0.578
    Rep. Tammy Baldwin,D,"WI (44.39319000021851, -89.8163600002137)",11.75013228,12.92146101,13,-0.603
    Rep. C.A. Dutch Ruppersberger,D,"MD (39.29057999976732, -76.6092600004485)",11.75243778,10.32329358,9,-0.323
    Rep. Patrick Meehan,R,"PA (40.79372999993973, -77.86069999960512)",11.75756235,11.75756235,1,0.189
    Sen. John Thune,R,"SD (44.353130000049646, -100.37353000040906)",11.76876533,11.25932366,5,0.387
    Sen. John Boozman,R,"AR (34.748649999697875, -92.27448999971358)",11.77366726,11.35805412,1,0.406
    Rep. Fred Upton,R,"MI (44.661320000317914, -84.71438999959867)",11.77711523,12.20009874,25,0.316
    Rep. Grace Napolitano,D,"CA (37.638300000444815, -120.99958999997835)",11.78256497,11.07366701,13,-0.473
    Rep. John Sullivan,R,"OK (35.4720099999617, -97.52034999975251)",11.7827409,12.37259149,11,0.526
    Rep. Henry Waxman,D,"CA (37.638300000444815, -120.99958999997835)",11.78641741,10.56884052,37,-0.516
    Sen. Jon Kyl,R,"AZ (34.86596999961597, -111.76380999973156)",11.79972438,11.78171981,15,0.558
    Rep. Terri Sewell,D,"AL (32.840569999605975, -86.63186000013877)",11.8005269,11.8005269,1,-0.378
    Rep. Kathy Castor,D,"FL (28.932039999846268, -81.9289599999039)",11.80607124,11.3359386,5,-0.452
    Rep. Rick Larsen,D,"WA (47.521729999839806, -120.46997999977702)",11.81900975,11.50165143,11,-0.39
    Rep. Randy Forbes,R,"VA (37.54268000028196, -78.45789000012326)",11.82234079,9.982090615,11,0.407
    Rep. Brad Sherman,D,"CA (37.638300000444815, -120.99958999997835)",11.82374552,11.70390241,15,-0.386
    Rep. Dan Boren,D,"OK (35.4720099999617, -97.52034999975251)",11.82591617,13.62107322,5,-0.111
    Rep. Tom Latham,R,"IA (42.469390000048634, -93.81649000001335)",11.83917637,12.59157797,17,0.33
    Rep. Ben Lujan,D,"NM (34.52088000011207, -106.24057999976702)",11.84453006,10.9478337,3,-0.424
    Rep. Adrian Smith,R,"NE (41.6410400000961, -99.36572999973953)",11.84612792,12.13020417,5,0.516
    Rep. Mike Turner,R,"OH (40.06020999969189, -82.40426000019869)",11.84808925,13.57337839,9,0.276
    Rep. Tim Walberg,R,"MI (44.661320000317914, -84.71438999959867)",11.85375218,11.05157896,1,0.554
    Rep. Ruben Hinojosa,D,"TX (31.82724000022597, -99.42676999973554)",11.86145244,11.56849308,15,-0.341
    Rep. Joe Crowley,D,"NY (42.82699999955048, -75.54396999981549)",11.86444747,9.256491983,13,-0.43
    Rep. Elijah Cummings,D,"MD (39.29057999976732, -76.6092600004485)",11.8673172,10.9124876,17,-0.461
    Sen. Lisa Murkowski,R,"AK (64.84507999974238, -147.72205999986895)",11.87351946,11.30194037,9,0.241
    Rep. Debbie Wasserman Schultz,D,"FL (28.932039999846268, -81.9289599999039)",11.8740028,12.31619589,5,-0.458
    Rep. Jim Moran,D,"VA (37.54268000028196, -78.45789000012326)",11.88370167,11.01258927,21,-0.328
    Rep. Steven Stivers,R,"OH (40.06020999969189, -82.40426000019869)",11.88870937,11.88870937,1,0.282
    Rep. Zoe Lofgren,D,"CA (37.638300000444815, -120.99958999997835)",11.89184982,12.76643582,17,-0.455
    Rep. Kevin Yoder,R,"KS (38.34774000000118, -98.20077999969709)",11.89570139,11.89570139,1,0.574
    Rep. Geoff Davis,R,"KY (37.645969999815804, -84.77496999996538)",11.90163974,12.10575988,5,0.433
    Rep. Gary Miller,R,"CA (37.638300000444815, -120.99958999997835)",11.90568478,12.37705887,13,0.499
    Rep. Raul Grijalva,D,"AZ (34.86596999961597, -111.76380999973156)",11.9159216,11.86500315,9,-0.639
    Sen. Jerry Moran,R,"KS (38.34774000000118, -98.20077999969709)",11.92120214,12.76575221,1,0.415
    Rep. Dale Kildee,D,"MI (44.661320000317914, -84.71438999959867)",11.92746368,12.04087167,35,-0.4
    Sen. Ben Cardin,D,"MD (39.29057999976732, -76.6092600004485)",11.93450775,11.93987274,3,-0.356
    Rep. Anna Eshoo,D,"CA (37.638300000444815, -120.99958999997835)",11.93637952,10.65351543,19,-0.431
    Rep. Erik Paulsen,R,"MN (46.3556499998478, -94.79419999982997)",11.93758504,11.69134788,3,0.368
    Rep. Mike Quigley,D,"IL (40.485010000411364, -88.99770999971656)",11.94476211,11.79568427,3,-0.358
    Rep. Aaron Schock,R,"IL (40.485010000411364, -88.99770999971656)",11.95875821,11.5362423,3,0.341
    Rep. Lacy Clay,D,"MO (38.63578999960896, -92.5663000000448)",11.99135904,11.49976749,11,-0.536
    Rep. Jo Ann Emerson,R,"MO (38.63578999960896, -92.5663000000448)",11.99956662,10.58528078,17,0.268
    Rep. Joe Donnelly,D,"IN (39.76690999989677, -86.14996000035359)",12.00579882,12.78726012,5,-0.132
    Rep. G.K. Butterfield,D,"NC (35.46624999963797, -79.1593199999179)",12.00769618,12.16871575,9,-0.414
    Rep. Ed Whitfield,R,"KY (37.645969999815804, -84.77496999996538)",12.00822678,10.55855154,17,0.304
    Rep. Duncan Hunter,R,"CA (37.638300000444815, -120.99958999997835)",12.02044387,13.66509733,3,0.528
    Rep. Mike Fitzpatrick,R,"PA (40.79372999993973, -77.86069999960512)",12.02956491,12.50752265,1,0.223
    Rep. Connie Mack,R,"FL (28.932039999846268, -81.9289599999039)",12.03584092,6.686799034,5,0.596
    Rep. Jerry Costello,D,"IL (40.485010000411364, -88.99770999971656)",12.03997742,12.38319432,25,-0.319
    Rep. Trent Franks,R,"AZ (34.86596999961597, -111.76380999973156)",12.0445611,12.25622763,9,0.775
    Rep. Heath Shuler,D,"NC (35.46624999963797, -79.1593199999179)",12.04854088,12.84471939,5,-0.102
    Rep. Wally Herger,R,"CA (37.638300000444815, -120.99958999997835)",12.05243499,14.2618407,25,0.548
    Sen. Jim Webb,D,"VA (37.54268000028196, -78.45789000012326)",12.05582587,12.48977301,3,-0.193
    Rep. Jim Clyburn,D,"SC (33.99855000018255, -81.0452500001872)",12.06024226,11.86660464,19,-0.481
    Rep. Allyson Schwartz,D,"PA (40.79372999993973, -77.86069999960512)",12.06725913,11.11991398,5,-0.361
    Rep. Bill Shuster,R,"PA (40.79372999993973, -77.86069999960512)",12.07316382,12.55418972,11,0.408
    Rep. Gary Ackerman,D,"NY (42.82699999955048, -75.54396999981549)",12.0739639,12.33593222,29,-0.458
    Rep. Ben Chandler,D,"KY (37.645969999815804, -84.77496999996538)",12.07399637,11.38117647,9,-0.238
    Rep. Jon Runyan,R,"NJ (40.13056999960594, -74.2736899996936)",12.07910288,12.07910288,1,0.249
    Rep. George Miller,D,"CA (37.638300000444815, -120.99958999997835)",12.08197589,11.18236367,37,-0.602
    Rep. Howard Coble,R,"NC (35.46624999963797, -79.1593199999179)",12.08733375,12.25011244,27,0.518
    Rep. Albio Sires,D,"NJ (40.13056999960594, -74.2736899996936)",12.09687744,13.07105958,5,-0.434
    Rep. Martin Heinrich,D,"NM (34.52088000011207, -106.24057999976702)",12.0973457,11.17819696,3,-0.307
    Rep. Bruce Braley,D,"IA (42.469390000048634, -93.81649000001335)",12.10098463,11.33271989,5,-0.386
    Rep. Pete King,R,"NY (42.82699999955048, -75.54396999981549)",12.10154704,11.31763167,19,0.264
    Rep. Lamar Smith,R,"TX (31.82724000022597, -99.42676999973554)",12.10214961,11.43552239,25,0.404
    Rep. Gregory Meeks,D,"NY (42.82699999955048, -75.54396999981549)",12.10483911,11.6305186,15,-0.457
    Rep. Robert Hurt,R,"VA (37.54268000028196, -78.45789000012326)",12.1122186,12.1122186,1,0.588
    Rep. Jerry Lewis,R,"CA (37.638300000444815, -120.99958999997835)",12.11420442,11.38029445,33,0.342
    Rep. John Dingell,D,"MI (44.661320000317914, -84.71438999959867)",12.12324485,11.55823085,57,-0.459
    Rep. Christopher Gibson,R,"NY (42.82699999955048, -75.54396999981549)",12.1237,12.1237,1,0.26
    Rep. Dennis Kucinich,D,"OH (40.06020999969189, -82.40426000019869)",12.14304889,11.87060418,15,-0.617
    Rep. Mazie Hirono,D,"HI (21.304770000335395, -157.85761000030112)",12.15098893,11.62492494,5,-0.555
    Rep. Jesse Jackson,D,"IL (40.485010000411364, -88.99770999971656)",12.1562299,11.95152338,17,-0.589
    Rep. Mike Doyle,D,"PA (40.79372999993973, -77.86069999960512)",12.16013063,11.90525287,17,-0.327
    Sen. Kirsten Gillibrand,D,"NY (42.82699999955048, -75.54396999981549)",12.16639777,11.77306299,3,-0.29
    Rep. Danny Davis,D,"IL (40.485010000411364, -88.99770999971656)",12.16961938,13.81060568,15,-0.536
    Rep. Ron Paul,R,"TX (31.82724000022597, -99.42676999973554)",12.17683518,12.91716356,23,0.971
    Rep. Doris Matsui,D,"CA (37.638300000444815, -120.99958999997835)",12.1809007,13.62931563,5,-0.486
    Rep. Karen Bass,D,"CA (37.638300000444815, -120.99958999997835)",12.18455933,12.18455933,1,-0.57
    Rep. Steve Rothman,D,"NJ (40.13056999960594, -74.2736899996936)",12.18815729,13.63439528,15,-0.383
    Rep. Charles Dent,R,"PA (40.79372999993973, -77.86069999960512)",12.19625014,9.443318793,5,0.221
    Rep. Mike McIntyre,D,"NC (35.46624999963797, -79.1593199999179)",12.19823297,11.98199748,15,-0.168
    Rep. Kenny Marchant,R,"TX (31.82724000022597, -99.42676999973554)",12.1989785,12.59379949,5,0.593
    Rep. Richard Hanna,R,"NY (42.82699999955048, -75.54396999981549)",12.1993002,12.1993002,1,0.195
    Sen. Ben Nelson,D,"NE (41.6410400000961, -99.36572999973953)",12.20237927,12.23793328,9,-0.026
    Sen. Dan Coats,R,"IN (39.76690999989677, -86.14996000035359)",12.2063944,11.30614098,1,0.362
    Rep. Sanford Bishop,D,"GA (32.83967999993223, -83.62758000031658)",12.21242911,12.72502613,19,-0.281
    Rep. Donald Payne,D,"NJ (40.13056999960594, -74.2736899996936)",12.21336072,13.16325491,23,-0.635
    Rep. Charlie Rangel,D,"NY (42.82699999955048, -75.54396999981549)",12.22052623,12.71768875,41,-0.556
    Sen. Jay Rockefeller,D,"WV (38.66550000002513, -80.71265999975901)",12.23411065,10.21530137,25,-0.341
    Sen. John Kerry,D,"MA (42.27687000005062, -72.08269000004333)",12.2359562,11.01029616,25,-0.386
    Rep. Mark Critz,D,"PA (40.79372999993973, -77.86069999960512)",12.23664531,12.1438124,3,-0.309
    Rep. Dave Loebsack,D,"IA (42.469390000048634, -93.81649000001335)",12.24220144,11.50722355,5,-0.34
    Rep. Eddie Johnson,D,"TX (31.82724000022597, -99.42676999973554)",12.24694338,12.97377675,19,-0.51
    Rep. John Conyers,D,"MI (44.661320000317914, -84.71438999959867)",12.24720344,12.18624516,47,-0.717
    Sen. Ron Wyden,D,"OR (44.567449999917756, -120.15502999983448)",12.25119925,12.87171951,14,-0.34
    Rep. Maurice Hinchey,D,"NY (42.82699999955048, -75.54396999981549)",12.25209869,11.9667921,19,-0.602
    Rep. Elton Gallegly,R,"CA (37.638300000444815, -120.99958999997835)",12.25883745,12.54078868,25,0.401
    Rep. Steve Austria,R,"OH (40.06020999969189, -82.40426000019869)",12.25993105,13.31484073,3,0.4
    Rep. Robert Aderholt,R,"AL (32.840569999605975, -86.63186000013877)",12.26434136,10.21173465,15,0.389
    Rep. Nick Rahall,D,"WV (38.66550000002513, -80.71265999975901)",12.26877916,12.33505071,35,-0.332
    Rep. John Tierney,D,"MA (42.27687000005062, -72.08269000004333)",12.27595316,12.45814266,15,-0.554
    Rep. Mike Simpson,R,"ID (43.682590000228515, -114.36368000023168)",12.2811012,9.474860824,13,0.312
    Rep. Janice Hahn,NA,"CA (37.638300000444815, -120.99958999997835)",12.28487297,12.28487297,1,-0.517
    Rep. Diana DeGette,D,"CO (38.842890000173554, -106.13314000041055)",12.29873407,12.30008749,15,-0.48
    Rep. Buck McKeon,R,"CA (37.638300000444815, -120.99958999997835)",12.30393227,14.20195377,19,0.418
    Rep. Jeff Denham,R,"CA (37.638300000444815, -120.99958999997835)",12.30747881,12.30747881,1,0.439
    Rep. Ted Deutch,D,"FL (28.932039999846268, -81.9289599999039)",12.30960543,12.2488832,3,-0.462
    Rep. Barbara Lee,D,"CA (37.638300000444815, -120.99958999997835)",12.31118269,12.4519866,15,-0.744
    Rep. Ed Towns,D,"NY (42.82699999955048, -75.54396999981549)",12.31653658,12.43191766,29,-0.55
    Rep. Rob Wittman,R,"VA (37.54268000028196, -78.45789000012326)",12.31739141,10.61954065,5,0.363
    Rep. Lynn Jenkins,R,"KS (38.34774000000118, -98.20077999969709)",12.31905836,11.92177003,3,0.504
    Rep. Rush Holt,D,"NJ (40.13056999960594, -74.2736899996936)",12.32528574,11.8719193,13,-0.498
    Sen. Mike Lee,R,"UT (39.36070000030492, -111.58712999994941)",12.33340489,12.33340489,1,0.923
    Rep. Don Young,R,"AK (64.84507999974238, -147.72205999986895)",12.33638826,8.986709512,39,0.274
    Rep. Jeff Miller,R,"FL (28.932039999846268, -81.9289599999039)",12.35358473,12.21284608,11,0.643
    Rep. John Olver,D,"MA (42.27687000005062, -72.08269000004333)",12.3551902,13.37654724,21,-0.613
    Rep. Ed Markey,D,"MA (42.27687000005062, -72.08269000004333)",12.36450572,9.546587955,37,-0.535
    Rep. Thomas Marino,R,"PA (40.79372999993973, -77.86069999960512)",12.3651867,12.3651867,1,0.434
    Sen. Dianne Feinstein,D,"CA (37.638300000444815, -120.99958999997835)",12.37701267,12.19367,17,-0.286
    Rep. Pete Stark,D,"CA (37.638300000444815, -120.99958999997835)",12.38370811,12.34236599,39,-0.674
    Rep. David Rivera,R,"FL (28.932039999846268, -81.9289599999039)",12.38591385,12.38591385,1,0.304
    Sen. C. Saxby Chambliss,R,"GA (32.83967999993223, -83.62758000031658)",12.38814636,12.94554653,7,0.428
    Rep. Jerrold Nadler,D,"NY (42.82699999955048, -75.54396999981549)",12.39033439,10.82629846,21,-0.554
    Rep. Chaka Fattah,D,"PA (40.79372999993973, -77.86069999960512)",12.40766248,12.58731831,17,-0.504
    Sen. Kelly Ayotte,R,"NH (43.65595000019255, -71.50036000041354)",12.40918818,12.40918818,1,0.47
    Sen. Mark Kirk,R,"IL (40.485010000411364, -88.99770999971656)",12.41673796,12.90257701,1,0.225
    Rep. Bill Keating,D,"MA (42.27687000005062, -72.08269000004333)",12.42259642,12.42259642,1,-0.391
    Rep. Niki Tsongas,D,"MA (42.27687000005062, -72.08269000004333)",12.42491365,12.23581724,5,-0.472
    Rep. Laura Richardson,D,"CA (37.638300000444815, -120.99958999997835)",12.42633157,12.80672571,5,-0.376
    Rep. Rodney Frelinghuysen,R,"NJ (40.13056999960594, -74.2736899996936)",12.43219658,11.16204314,17,0.268
    Rep. Bob Goodlatte,R,"VA (37.54268000028196, -78.45789000012326)",12.44070101,11.93852294,19,0.477
    Rep. Pete Sessions,R,"TX (31.82724000022597, -99.42676999973554)",12.45018929,11.95897367,15,0.6
    Rep. Joe Wilson,R,"SC (33.99855000018255, -81.0452500001872)",12.47099529,12.65233497,11,0.559
    Rep. Allen West,R,"FL (28.932039999846268, -81.9289599999039)",12.48037238,12.48037238,1,0.467
    Sen. Jack Reed,D,"RI (41.70828000002217, -71.5224700001902)",12.50037799,12.77283351,13,-0.425
    Rep. Bennie Thompson,D,"MS (32.7455100000866, -89.53803000008429)",12.50595849,12.98643573,19,-0.523
    Rep. Brian Higgins,D,"NY (42.82699999955048, -75.54396999981549)",12.50614037,12.43313062,5,-0.37
    Rep. Kathy Hochul,NA,"NY (42.82699999955048, -75.54396999981549)",12.51245869,12.51245869,1,-0.298
    Sen. Mark Warner,D,"VA (37.54268000028196, -78.45789000012326)",12.521094,12.39143417,3,-0.237
    Rep. Carolyn Maloney,D,"NY (42.82699999955048, -75.54396999981549)",12.53131822,13.03522892,19,-0.424
    Rep. Timothy Bishop,D,"NY (42.82699999955048, -75.54396999981549)",12.54226184,12.43909577,9,-0.37
    Rep. John Larson,D,"CT (41.56265999995918, -72.6498400002157)",12.54446102,10.79757323,13,-0.445
    Rep. Sheila Jackson Lee,D,"TX (31.82724000022597, -99.42676999973554)",12.54770388,10.91907103,17,-0.475
    Rep. Jim Renacci,R,"OH (40.06020999969189, -82.40426000019869)",12.54879331,12.54879331,1,0.441
    Rep. Alcee Hastings,D,"FL (28.932039999846268, -81.9289599999039)",12.55458976,12.30399023,19,-0.603
    Rep. Brian Bilbray,R,"CA (37.638300000444815, -120.99958999997835)",12.56395043,13.2773292,5,0.393
    Rep. Earl Blumenauer,D,"OR (44.567449999917756, -120.15502999983448)",12.56583811,11.90555398,17,-0.481
    Rep. Gwen Moore,D,"WI (44.39319000021851, -89.8163600002137)",12.56802993,11.71938016,5,-0.578
    Rep. Russ Carnahan,D,"MO (38.63578999960896, -92.5663000000448)",12.57046688,12.43396024,5,-0.375
    Rep. Ed Pastor,D,"AZ (34.86596999961597, -111.76380999973156)",12.57347793,12.46044965,21,-0.439
    Rep. John Sarbanes,D,"MD (39.29057999976732, -76.6092600004485)",12.58399702,13.43897142,5,-0.468
    Sen. Kay Hagan,D,"NC (35.46624999963797, -79.1593199999179)",12.59279723,13.05756534,3,-0.246
    Sen. John McCain,R,"AZ (34.86596999961597, -111.76380999973156)",12.60188169,12.17923421,23,0.382
    Rep. Henry Cuellar,D,"TX (31.82724000022597, -99.42676999973554)",12.60664745,12.3747415,5,-0.231
    Rep. John Boehner,R,"OH (40.06020999969189, -82.40426000019869)",12.60964654,10.64294226,21,
    Rep. John Culberson,R,"TX (31.82724000022597, -99.42676999973554)",12.61056096,11.41678205,11,0.533
    Rep. Gus Bilirakis,R,"FL (28.932039999846268, -81.9289599999039)",12.62349281,11.46628569,5,0.362
    Rep. Mike Rogers,R,"AL (32.840569999605975, -86.63186000013877)",12.6256008,11.10142058,11,0.346
    Rep. Mike Pence,R,"IN (39.76690999989677, -86.14996000035359)",12.64298814,11.90667962,11,0.672
    Sen. Robert Menendez,D,"NJ (40.13056999960594, -74.2736899996936)",12.64435047,11.76713716,3,-0.391
    Sen. Richard Blumenthal,D,"CT (41.56265999995918, -72.6498400002157)",12.64443182,12.64443182,1,-0.351
    Rep. Chris Van Hollen,D,"MD (39.29057999976732, -76.6092600004485)",12.64513791,11.38010458,9,-0.423
    Rep. Bob Brady,D,"PA (40.79372999993973, -77.86069999960512)",12.65011115,12.46616302,15,-0.497
    Rep. Gregg Harper,R,"MS (32.7455100000866, -89.53803000008429)",12.67123466,11.94571807,3,0.471
    Rep. Stephen Lynch,D,"MA (42.27687000005062, -72.08269000004333)",12.68757252,11.4850886,11,-0.393
    Rep. Stephen Fincher,R,"TN (35.68094000038087, -85.77449000011325)",12.71414274,12.71414274,1,0.488
    Rep. Betty McCollum,D,"MN (46.3556499998478, -94.79419999982997)",12.71695941,12.10592099,11,-0.468
    Rep. Jim Costa,D,"CA (37.638300000444815, -120.99958999997835)",12.73091018,13.20082289,5,-0.213
    Rep. Frank Pallone,D,"NJ (40.13056999960594, -74.2736899996936)",12.73500724,11.24205814,25,-0.423
    Rep. Thad McCotter,R,"MI (44.661320000317914, -84.71438999959867)",12.73618766,12.80126203,9,0.331
    Rep. Ron Kind,D,"WI (44.39319000021851, -89.8163600002137)",12.74467324,11.68252758,15,-0.3
    Rep. Lloyd Doggett,D,"TX (31.82724000022597, -99.42676999973554)",12.74537305,11.60417295,17,-0.452
    Rep. David Price,D,"NC (35.46624999963797, -79.1593199999179)",12.74723825,11.58839754,23,-0.349
    Sen. Patrick Leahy,D,"VT (43.625379999687425, -72.51764000028561)",12.75204365,12.80236845,35,-0.392
    Rep. Charlie Bass,R,"NH (43.65595000019255, -71.50036000041354)",12.77700684,10.47779502,1,0.345
    Rep. Silver Reyes,D,"TX (31.82724000022597, -99.42676999973554)",12.78528976,12.93399807,15,-0.329
    Rep. Todd Platts,R,"PA (40.79372999993973, -77.86069999960512)",12.79141667,12.44016444,11,0.248
    Sen. Maria Cantwell,D,"WA (47.521729999839806, -120.46997999977702)",12.79192238,12.07724527,9,-0.306
    Rep. Jeff Fortenberry,R,"NE (41.6410400000961, -99.36572999973953)",12.80381609,12.29988175,5,0.285
    Rep. Bill Owens,D,"NY (42.82699999955048, -75.54396999981549)",12.80438963,12.79149984,3,-0.187
    Rep. Daniel Lipinski,D,"IL (40.485010000411364, -88.99770999971656)",12.84585932,13.4959707,5,-0.287
    Sen. Thad Cochran,R,"MS (32.7455100000866, -89.53803000008429)",12.85568904,13.35345328,31,0.292
    Rep. Ken Calvert,R,"CA (37.638300000444815, -120.99958999997835)",12.86997764,12.571696,19,0.367
    Rep. Jo Bonner,R,"AL (32.840569999605975, -86.63186000013877)",12.87050645,13.01562027,9,0.402
    Rep. Andre Carson,D,"IN (39.76690999989677, -86.14996000035359)",12.87333328,13.79592974,5,-0.469
    Sen. Carl Levin,D,"MI (44.661320000317914, -84.71438999959867)",12.8820932,12.7589262,31,-0.429
    Sen. Richard Shelby,R,"AL (32.840569999605975, -86.63186000013877)",12.88917385,11.31326157,23,0.39
    Sen. Herb Kohl,D,"WI (44.39319000021851, -89.8163600002137)",12.89084414,13.85290638,21,-0.283
    Rep. Bill Flores,R,"TX (31.82724000022597, -99.42676999973554)",12.8982596,12.8982596,1,0.589
    Rep. David Dreier,R,"CA (37.638300000444815, -120.99958999997835)",12.90446168,10.97476006,31,0.481
    Rep. Joe Courtney,D,"CT (41.56265999995918, -72.6498400002157)",12.92437695,12.53074723,5,-0.373
    Rep. Mike Thompson,D,"CA (37.638300000444815, -120.99958999997835)",12.95400843,12.91624943,13,-0.431
    Rep. Frank LoBiondo,R,"NJ (40.13056999960594, -74.2736899996936)",12.96028812,13.08452404,17,0.182
    Rep. Hank Johnson,D,"GA (32.83967999993223, -83.62758000031658)",12.99562452,14.35553403,5,-0.485
    Rep. David Cicilline,D,"RI (41.70828000002217, -71.5224700001902)",13.01071812,13.01071812,1,-0.457
    Sen. John Cornyn,R,"TX (31.82724000022597, -99.42676999973554)",13.0218724,12.43513548,7,0.491
    Sen. Mike Crapo,R,"ID (43.682590000228515, -114.36368000023168)",13.02434228,14.48193636,11,0.468
    Rep. Sam Graves,R,"MO (38.63578999960896, -92.5663000000448)",13.03668978,11.98141428,11,0.437
    Rep. Adam Schiff,D,"CA (37.638300000444815, -120.99958999997835)",13.04915313,13.0347375,11,-0.369
    Sen. Chris Coons,D,"DE (39.00883000020451, -75.57774000040052)",13.09016042,13.04310777,1,-0.37
    Rep. Chris Smith,R,"NJ (40.13056999960594, -74.2736899996936)",13.11851836,12.80562,31,0.121
    Sen. Jeff Bingaman,D,"NM (34.52088000011207, -106.24057999976702)",13.12520988,14.05633122,27,-0.292
    Rep. Ileana Ros-Lehtinen,R,"FL (28.932039999846268, -81.9289599999039)",13.14271644,12.93132331,23,0.241
    Sen. Daniel Inouye,D,"HI (21.304770000335395, -157.85761000030112)",13.15588182,12.9951671,47,-0.331
    Sen. Susan Collins,R,"ME (45.25423000041434, -68.9850299999344)",13.24594759,13.13644237,13,0.107
    Rep. Jim Langevin,D,"RI (41.70828000002217, -71.5224700001902)",13.25930146,13.3630482,11,-0.4
    Rep. Mike Honda,D,"CA (37.638300000444815, -120.99958999997835)",13.32334496,12.46864133,11,-0.574
    Sen. Tim Johnson,D,"SD (44.353130000049646, -100.37353000040906)",13.33949659,13.07535805,13,-0.269
    Sen. Mark Udall,D,"CO (38.842890000173554, -106.13314000041055)",13.34580955,12.29453879,3,-0.394
    Rep. Leonard Lance,R,"NJ (40.13056999960594, -74.2736899996936)",13.39117219,12.24581972,3,0.258
    Sen. Richard Lugar,R,"IN (39.76690999989677, -86.14996000035359)",13.41510394,14.42326467,33,0.322
    Sen. Joseph Lieberman,I,"CT (41.56265999995918, -72.6498400002157)",13.46825345,12.95536381,21,-0.223
    Rep. Pete Visclosky,D,"IN (39.76690999989677, -86.14996000035359)",13.49866694,12.79787508,27,-0.418
    Rep. Gerry Connolly,D,"VA (37.54268000028196, -78.45789000012326)",13.5455154,13.65915851,3,-0.306
    Rep. Gary Peters,D,"MI (44.661320000317914, -84.71438999959867)",13.63128815,13.38863689,3,-0.246
    Rep. Mary Bono Mack,R,"CA (37.638300000444815, -120.99958999997835)",13.6335146,13.76037993,15,0.34
    Rep. Jim Sensenbrenner,R,"WI (44.39319000021851, -89.8163600002137)",13.69396284,11.56066479,33,0.647
    Rep. Ralph Hall,R,"TX (31.82724000022597, -99.42676999973554)",13.73611567,12.12088967,31,0.44
    Rep. Mark Amodei,R,"NV (39.49323999972637, -117.07183999971608)",13.83082922,13.83082922,1,0.479
    Rep. Rodney Alexander,R,"LA (31.312679999782347, -92.44565000034709)",13.94467894,13.40925857,1,0.366
    Sen. Olympia Snowe,R,"ME (45.25423000041434, -68.9850299999344)",14.02189714,13.80125838,15,0.085
    Rep. Mac Thornberry,R,"TX (31.82724000022597, -99.42676999973554)",14.13497702,10.88663711,17,0.561
    Sen. Daniel Akaka,D,"HI (21.304770000335395, -157.85761000030112)",14.18339735,15.05117281,19,-0.444
    Rep. Tom Petri,R,"WI (44.39319000021851, -89.8163600002137)",14.18629418,12.29116075,33,0.354
    Rep. Jim Gerlach,R,"PA (40.79372999993973, -77.86069999960512)",14.19092269,15.65222025,9,0.209
    Rep. Lucille Roybal-Allard,D,"CA (37.638300000444815, -120.99958999997835)",14.93911003,14.42191189,19,-0.508
    Rep. Dan Lungren,R,"CA (37.638300000444815, -120.99958999997835)",16.01390263,20.46577636,7,0.504
    Name,Party,"state",,,,
  4. @dbc-challenges dbc-challenges revised this gist Apr 4, 2013. 2 changed files with 1 addition and 4 deletions.
    4 changes: 1 addition & 3 deletions importing_political_db.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1 @@

    <!-- Code goes here -->

    # Your code here
    1 change: 0 additions & 1 deletion queries_and_statistics.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1,2 +1 @@

    -- Enter your query results and statistical insights here! --
  5. @dbc-challenges dbc-challenges revised this gist Oct 9, 2012. 2 changed files with 2 additions and 1 deletion.
    1 change: 0 additions & 1 deletion importing_political_db.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,3 @@


    <!-- Code goes here -->

    2 changes: 2 additions & 0 deletions queries_and_statistics.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,2 @@

    -- Enter your query results and statistical insights here! --
  6. @dbc-challenges dbc-challenges created this gist Oct 9, 2012.
    4 changes: 4 additions & 0 deletions importing_political_db.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,4 @@


    <!-- Code goes here -->