Influenza.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Creating a graph database for the Legislative Branch."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "import yaml\n",
    "\n",
    "with open(\"/Users/sahuguet/Documents/Dev/Influenza/legislators-current.yaml\", 'r') as stream:\n",
    "    try:\n",
    "        data = yaml.load(stream)\n",
    "    except yaml.YAMLError as exc:\n",
    "        print(exc)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "CREATE (:`Government Organization` { name:\"US Senate\"})\n",
    "CREATE (:`Government Organization` { name:\"House of Representatives\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CREATE (:Person:Senator { name: \"Sherrod Brown\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Maria Cantwell\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Benjamin L. Cardin\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Thomas R. Carper\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Robert P. Casey, Jr.\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Bob Corker\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Dianne Feinstein\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Orrin G. Hatch\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Amy Klobuchar\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Claire McCaskill\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Robert Menendez\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Bill Nelson\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Bernard Sanders\", party: \"Independent\" })\n",
      "CREATE (:Person:Senator { name: \"Debbie Stabenow\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Jon Tester\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Sheldon Whitehouse\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"John Barrasso\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Roger F. Wicker\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Lamar Alexander\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Thad Cochran\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Susan M. Collins\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"John Cornyn\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Richard J. Durbin\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Michael B. Enzi\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Lindsey Graham\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"James M. Inhofe\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Mitch McConnell\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Jeff Merkley\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Jack Reed\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"James E. Risch\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Pat Roberts\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Jeff Sessions\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Jeanne Shaheen\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Tom Udall\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Mark R. Warner\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Kirsten E. Gillibrand\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Al Franken\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Christopher A. Coons\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Joe Manchin, III\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Robert B. Aderholt\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Justin Amash\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Tammy Baldwin\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Lou Barletta\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Joe Barton\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Karen Bass\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Xavier Becerra\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Michael F. Bennet\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Gus M. Bilirakis\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Rob Bishop\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Sanford D. Bishop, Jr.\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Diane Black\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Marsha Blackburn\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Earl Blumenauer\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Richard Blumenthal\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Roy Blunt\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"John Boozman\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Madeleine Z. Bordallo\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Kevin Brady\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Robert A. Brady\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mo Brooks\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Vern Buchanan\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Larry Bucshon\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Michael C. Burgess\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Richard Burr\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"G. K. Butterfield\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Ken Calvert\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Shelley Moore Capito\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Michael E. Capuano\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"André Carson\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John R. Carter\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Bill Cassidy\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Kathy Castor\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Steve Chabot\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jason Chaffetz\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Judy Chu\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"David N. Cicilline\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Yvette D. Clarke\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Wm. Lacy Clay\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Emanuel Cleaver\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"James E. Clyburn\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Coffman\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Steve Cohen\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Tom Cole\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"K. Michael Conaway\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Gerald E. Connolly\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John Conyers, Jr.\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jim Cooper\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jim Costa\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Joe Courtney\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Mike Crapo\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Eric A. \\\"Rick\\\" Crawford\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Joseph Crowley\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Henry Cuellar\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John Abney Culberson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Elijah E. Cummings\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Danny K. Davis\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Susan A. Davis\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Peter A. DeFazio\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Diana DeGette\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Rosa L. DeLauro\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jeff Denham\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Charles W. Dent\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Scott DesJarlais\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Theodore E. Deutch\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mario Diaz-Balart\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Lloyd Doggett\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Joe Donnelly\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Michael F. Doyle\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Sean P. Duffy\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jeff Duncan\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"John J. Duncan, Jr.\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Keith Ellison\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Eliot L. Engel\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Anna G. Eshoo\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Blake Farenthold\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Jeff Flake\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Charles J. \\\"Chuck\\\" Fleischmann\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Bill Flores\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jeff Fortenberry\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Virginia Foxx\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Trent Franks\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Rodney P. Frelinghuysen\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Marcia L. Fudge\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John Garamendi\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Cory Gardner\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Bob Gibbs\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Louie Gohmert\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Bob Goodlatte\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Paul A. Gosar\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Trey Gowdy\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Kay Granger\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Chuck Grassley\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Sam Graves\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Tom Graves\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Al Green\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Gene Green\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"H. Morgan Griffith\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Raúl M. Grijalva\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Brett Guthrie\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Luis V. Gutiérrez\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Gregg Harper\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Andy Harris\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Vicky Hartzler\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Alcee L. Hastings\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Martin Heinrich\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jeb Hensarling\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jaime Herrera Beutler\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Brian Higgins\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"James A. Himes\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Mazie K. Hirono\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"John Hoeven\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Steny H. Hoyer\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Bill Huizenga\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Randy Hultgren\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Duncan Hunter\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Johnny Isakson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Darrell E. Issa\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Sheila Jackson Lee\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Lynn Jenkins\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Bill Johnson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Eddie Bernice Johnson\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Henry C. \\\"Hank\\\" Johnson, Jr.\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Ron Johnson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Sam Johnson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Walter B. Jones\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jim Jordan\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Marcy Kaptur\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"William R. Keating\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Kelly\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ron Kind\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Peter T. King\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Steve King\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Adam Kinzinger\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Raúl R. Labrador\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Doug Lamborn\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Leonard Lance\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"James R. Langevin\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"James Lankford\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Rick Larsen\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John B. Larson\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Robert E. Latta\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Patrick J. Leahy\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Barbara Lee\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Mike Lee\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Sander M. Levin\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John Lewis\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Daniel Lipinski\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Frank A. LoBiondo\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David Loebsack\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Zoe Lofgren\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Billy Long\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Nita M. Lowey\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Frank D. Lucas\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Blaine Luetkemeyer\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ben Ray Luján\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Stephen F. Lynch\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Carolyn B. Maloney\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Kenny Marchant\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Tom Marino\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Edward J. Markey\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Doris O. Matsui\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"John McCain\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Kevin McCarthy\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Michael T. McCaul\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Tom McClintock\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Betty McCollum\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"James P. McGovern\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Patrick T. McHenry\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David B. McKinley\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Cathy McMorris Rodgers\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jerry McNerney\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Patrick Meehan\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Gregory W. Meeks\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Gwen Moore\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Jerry Moran\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mick Mulvaney\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Lisa Murkowski\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Christopher Murphy\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Tim Murphy\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Patty Murray\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jerrold Nadler\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Grace F. Napolitano\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Richard E. Neal\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Kristi L. Noem\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Eleanor Holmes Norton\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Devin Nunes\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Pete Olson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Steven M. Palazzo\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Frank Pallone, Jr.\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Bill Pascrell, Jr.\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Rand Paul\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Erik Paulsen\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Stevan Pearce\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Nancy Pelosi\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Ed Perlmutter\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Gary C. Peters\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Collin C. Peterson\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Chellie Pingree\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Ted Poe\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jared Polis\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Pompeo\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Rob Portman\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Bill Posey\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David E. Price\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Tom Price\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Quigley\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Tom Reed\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David G. Reichert\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"James B. Renacci\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Cedric L. Richmond\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Martha Roby\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David P. Roe\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Harold Rogers\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Rogers\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Dana Rohrabacher\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Todd Rokita\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Thomas J. Rooney\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ileana Ros-Lehtinen\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Peter J. Roskam\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Dennis A. Ross\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Lucille Roybal-Allard\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Edward R. Royce\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Marco Rubio\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"C. A. Dutch Ruppersberger\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Bobby L. Rush\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Paul D. Ryan\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Tim Ryan\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Gregorio Kilili Camacho Sablan\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John P. Sarbanes\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Steve Scalise\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Janice D. Schakowsky\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Adam B. Schiff\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Kurt Schrader\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Charles E. Schumer\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"David Schweikert\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Austin Scott\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David Scott\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Robert C. \\\"Bobby\\\" Scott\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Tim Scott\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"F. James Sensenbrenner, Jr.\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"José E. Serrano\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Pete Sessions\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Terri A. Sewell\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Richard C. Shelby\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Brad Sherman\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John Shimkus\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Bill Shuster\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Michael K. Simpson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Albio Sires\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Louise McIntosh Slaughter\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Adam Smith\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Adrian Smith\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Christopher H. Smith\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Lamar Smith\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jackie Speier\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Steve Stivers\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Linda T. Sánchez\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Bennie G. Thompson\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Thompson\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Glenn Thompson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mac Thornberry\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"John Thune\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Patrick J. Tiberi\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Scott R. Tipton\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Paul Tonko\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Patrick J. Toomey\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Niki Tsongas\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Michael R. Turner\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Fred Upton\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Chris Van Hollen\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Nydia M. Velázquez\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Peter J. Visclosky\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Tim Walberg\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Greg Walden\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Timothy J. Walz\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Debbie Wasserman Schultz\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Maxine Waters\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Daniel Webster\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Peter Welch\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Joe Wilson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Frederica S. Wilson\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Robert J. Wittman\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Steve Womack\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Rob Woodall\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Ron Wyden\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John A. Yarmuth\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Kevin Yoder\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Don Young\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Todd Young\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Dean Heller\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mark E. Amodei\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Suzanne Bonamici\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Suzan K. DelBene\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Thomas Massie\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Donald M. Payne, Jr.\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Brian Schatz\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Bill Foster\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Dina Titus\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Tom Cotton\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Kyrsten Sinema\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Doug LaMalfa\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jared Huffman\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Ami Bera\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Paul Cook\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Eric Swalwell\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"David G. Valadao\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Julia Brownley\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Tony Cárdenas\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Raul Ruiz\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mark Takano\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Alan S. Lowenthal\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Juan Vargas\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Scott H. Peters\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Elizabeth H. Esty\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Ted S. Yoho\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ron DeSantis\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Lois Frankel\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Doug Collins\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Tulsi Gabbard\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Tammy Duckworth\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Rodney Davis\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Cheri Bustos\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jackie Walorski\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Susan W. Brooks\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Luke Messer\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Andy Barr\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Elizabeth Warren\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Joseph P. Kennedy III\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John K. Delaney\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Angus S. King, Jr.\", party: \"Independent\" })\n",
      "CREATE (:Person:Representative { name: \"Daniel T. Kildee\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Richard M. Nolan\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Ann Wagner\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Steve Daines\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Richard Hudson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Robert Pittenger\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mark Meadows\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"George Holding\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Heidi Heitkamp\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Kevin Cramer\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Deb Fischer\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ann M. Kuster\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Michelle Lujan Grisham\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Grace Meng\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Hakeem S. Jeffries\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Sean Patrick Maloney\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Chris Collins\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Brad R. Wenstrup\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Joyce Beatty\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"David P. Joyce\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jim Bridenstine\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Markwayne Mullin\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Scott Perry\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Keith J. Rothfus\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Matt Cartwright\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Tom Rice\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Ted Cruz\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Randy K. Weber, Sr.\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Beto O'Rourke\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Joaquin Castro\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Roger Williams\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Marc A. Veasey\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Filemon Vela\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Chris Stewart\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Tim Kaine\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Derek Kilmer\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Denny Heck\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mark Pocan\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Robin L. Kelly\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mark Sanford\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jason Smith\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Cory A. Booker\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Katherine M. Clark\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Bradley Byrne\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Dave Brat\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Donald Norcross\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Alma S. Adams\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Gary J. Palmer\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"J. French Hill\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Bruce Westerman\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Martha McSally\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ruben Gallego\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mark DeSaulnier\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Stephen Knight\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Pete Aguilar\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Ted Lieu\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Norma J. Torres\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mimi Walters\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ken Buck\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Carlos Curbelo\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Earl L. \\\"Buddy\\\" Carter\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jody B. Hice\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Barry Loudermilk\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Rick W. Allen\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Rod Blum\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David Young\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Bost\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ralph Lee Abraham\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Garret Graves\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Seth Moulton\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Bruce Poliquin\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"John R. Moolenaar\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Bishop\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David A. Trott\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Debbie Dingell\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Brenda L. Lawrence\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Tom Emmer\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ryan K. Zinke\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David Rouzer\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Thomas MacArthur\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Bonnie Watson Coleman\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Lee M. Zeldin\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Kathleen M. Rice\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Elise M. Stefanik\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"John Katko\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Steve Russell\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ryan A. Costello\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Brendan F. Boyle\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John Ratcliffe\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Will Hurd\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Brian Babin\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mia B. Love\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Donald S. Beyer, Jr.\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Barbara Comstock\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Stacey E. Plaskett\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Dan Newhouse\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Glenn Grothman\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Alexander X. Mooney\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Evan H. Jenkins\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Aumua Amata Coleman Radewagen\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Daniel Sullivan\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"David Perdue\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Joni Ernst\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Thom Tillis\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Mike Rounds\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mark Walker\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Ben Sasse\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Daniel M. Donovan, Jr.\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Trent Kelly\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Darin LaHood\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Warren Davidson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Colleen Hanabusa\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"James Comer\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Dwight Evans\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Kamala D. Harris\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"John Kennedy\", party: \"Republican\" })\n",
      "CREATE (:Person:Senator { name: \"Margaret Wood Hassan\", party: \"Democrat\" })\n",
      "CREATE (:Person:Senator { name: \"Catherine Cortez Masto\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Bradley Scott Schneider\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Carol Shea-Porter\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Tom O'Halleran\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Andy Biggs\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ro Khanna\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jimmy Panetta\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Salud O. Carbajal\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Nanette Diaz Barragán\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"J. Luis Correa\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Lisa Blunt Rochester\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Matt Gaetz\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Neal P. Dunn\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"John H. Rutherford\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Al Lawson, Jr.\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Stephanie N. Murphy\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Darren Soto\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Val Butler Demings\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Charlie Crist\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Brian J. Mast\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Francis Rooney\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"A. Drew Ferguson IV\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Raja Krishnamoorthi\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jim Banks\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Trey Hollingsworth\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Roger W. Marshall\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Clay Higgins\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Johnson\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Anthony G. Brown\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jamie Raskin\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jack Bergman\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Paul Mitchell\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jason Lewis\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Ted Budd\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Don Bacon\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Josh Gottheimer\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jacky Rosen\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Ruben Kihuen\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Thomas R. Suozzi\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Adriano Espaillat\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"John J. Faso\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Claudia Tenney\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Brian K. Fitzpatrick\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Lloyd Smucker\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Jenniffer González-Colón\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"David Kustoff\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Vicente Gonzalez\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Jodey C. Arrington\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Scott Taylor\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"A. Donald McEachin\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Thomas A. Garrett, Jr.\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Pramila Jayapal\", party: \"Democrat\" })\n",
      "CREATE (:Person:Representative { name: \"Mike Gallagher\", party: \"Republican\" })\n",
      "CREATE (:Person:Representative { name: \"Liz Cheney\", party: \"Republican\" })\n"
     ]
    }
   ],
   "source": [
    "for people in data:\n",
    "    name = people['name']['official_full'].replace('\"','\\\\\"')\n",
    "    role = people['terms'][-1]['type']\n",
    "    party = people['terms'][-1]['party']\n",
    "    if role == 'sen':\n",
    "        print \"\"\"CREATE (:Person:Senator { name: \"%s\", party: \"%s\" })\"\"\" % (name, party)\n",
    "    elif role == 'rep':\n",
    "        print \"\"\"CREATE (:Person:Representative { name: \"%s\", party: \"%s\" })\"\"\" % (name, party)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "-- Senators are MEMBER_OF the US Senate.\n",
    "MATCH (n:Senator)\n",
    "MATCH (senate:`Government Organization` { name: \"US Senate\"})\n",
    "CREATE (n)-[:MEMBER_OF]->(senate);\n",
    "\n",
    "-- Representatives are MEMBER_OF the House.\n",
    "MATCH (n:Representative)\n",
    "MATCH (house:`Government Organization` { name: \"House of Representatives\"})\n",
    "CREATE (n)-[:MEMBER_OF]->(house);\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}