Create Dataset.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Maryland Bill Analysis\n",
    "# CAPITAL NEWS SERVICE -- JAKE GLUCK\n",
    "\n",
    "# uses the legiscan api\n",
    "# https://legiscan.com/gaits/documentation/legiscan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#import libraries and load in config\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import requests\n",
    "import json\n",
    "import matplotlib\n",
    "import matplotlib.pyplot\n",
    "import datetime\n",
    "import time\n",
    "\n",
    "keys={}\n",
    "with open(\"config.json\",\"r\") as f:\n",
    "    config = json.loads(f.read())\n",
    "   \n",
    "    \n",
    "legiscan_key = config[\"legiscan_key\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'session_id': 1636, 'state_id': 20, 'year_start': 2019, 'year_end': 2019, 'special': 0, 'session_name': 'Regular Session', 'name': '2019 Regular Session', 'session_hash': '9cd9feb727baa263596dd00bb5ee297b'}\n",
      "{'session_id': 1528, 'state_id': 20, 'year_start': 2018, 'year_end': 2018, 'special': 0, 'session_name': 'Regular Session', 'name': '2018 Regular Session', 'session_hash': 'eb1c12a56eb962654527ebcdd2c917e4'}\n",
      "{'session_id': 1412, 'state_id': 20, 'year_start': 2017, 'year_end': 2017, 'special': 0, 'session_name': 'Regular Session', 'name': '2017 Regular Session', 'session_hash': '71ec9991d5a9b20a005bb545f362319f'}\n",
      "{'session_id': 1192, 'state_id': 20, 'year_start': 2016, 'year_end': 2016, 'special': 0, 'session_name': 'Regular Session', 'name': '2016 Regular Session', 'session_hash': 'a73088fd7e18f187cdb24e2a35e87776'}\n",
      "{'session_id': 1133, 'state_id': 20, 'year_start': 2015, 'year_end': 2015, 'special': 0, 'session_name': 'Regular Session', 'name': '2015 Regular Session', 'session_hash': 'f8c1c53485027e82ac1bbd62b3754903'}\n",
      "{'session_id': 1054, 'state_id': 20, 'year_start': 2014, 'year_end': 2014, 'special': 0, 'session_name': 'Regular Session', 'name': '2014 Regular Session', 'session_hash': '4c242811915f3685fde7bc4565de4711'}\n",
      "{'session_id': 1005, 'state_id': 20, 'year_start': 2013, 'year_end': 2013, 'special': 0, 'session_name': 'Regular Session', 'name': '2013 Regular Session', 'session_hash': '112a5e90fb54b35d8a5c5740c69bf3a1'}\n",
      "{'session_id': 963, 'state_id': 20, 'year_start': 2012, 'year_end': 2012, 'special': 1, 'session_name': '1st Special Session', 'name': '2012 Special Session', 'session_hash': '8ea1e41bdcfcca1dce245ede81f69a8e'}\n",
      "{'session_id': 924, 'state_id': 20, 'year_start': 2012, 'year_end': 2012, 'special': 0, 'session_name': 'Regular Session', 'name': '2012 Regular Session', 'session_hash': 'f57fc1b9f22a8e89cf746ccd0f90745a'}\n",
      "{'session_id': 409, 'state_id': 20, 'year_start': 2011, 'year_end': 2011, 'special': 1, 'session_name': '1st Special Session', 'name': '2011 Special Session', 'session_hash': '14ba80a3803d2f743409dc7a16a2dce5'}\n",
      "{'session_id': 113, 'state_id': 20, 'year_start': 2011, 'year_end': 2011, 'special': 0, 'session_name': 'Regular Session', 'name': '2011 Regular Session', 'session_hash': 'ef25f19dcaae06673b235f11b313f5d0'}\n",
      "{'session_id': 34, 'state_id': 20, 'year_start': 2010, 'year_end': 2010, 'special': 0, 'session_name': 'Regular Session', 'name': '2010 Regular Session', 'session_hash': 'e27c590650c4b16ad09e24682262a36e'}\n"
     ]
    }
   ],
   "source": [
    "#list sessions\n",
    "\n",
    "def pullData():\n",
    "\n",
    "    params = {\n",
    "        'key': legiscan_key,\n",
    "        'op' : \"getSessionList\",\n",
    "        'state' : \"MD\"\n",
    "    }\n",
    "\n",
    "    url = 'https://api.legiscan.com/'\n",
    "    r = requests.get(url, params=params)\n",
    "    return r.json()\n",
    "\n",
    "data = pullData()\n",
    "sessions = data[\"sessions\"]\n",
    "for s in sessions:\n",
    "    print(s)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scraping bill # 0\n",
      "scraping bill # 1\n",
      "scraping bill # 2\n",
      "scraping bill # 3\n",
      "scraping bill # 4\n",
      "scraping bill # 5\n",
      "scraping bill # 6\n",
      "scraping bill # 7\n",
      "scraping bill # 8\n",
      "scraping bill # 9\n",
      "scraping bill # 10\n",
      "scraping bill # 11\n",
      "scraping bill # 12\n",
      "scraping bill # 13\n",
      "scraping bill # 14\n",
      "scraping bill # 15\n",
      "scraping bill # 16\n",
      "scraping bill # 17\n",
      "scraping bill # 18\n",
      "scraping bill # 19\n",
      "scraping bill # 20\n",
      "scraping bill # 21\n",
      "scraping bill # 22\n",
      "scraping bill # 23\n",
      "scraping bill # 24\n",
      "scraping bill # 25\n",
      "scraping bill # 26\n",
      "scraping bill # 27\n",
      "scraping bill # 28\n",
      "scraping bill # 29\n",
      "scraping bill # 30\n",
      "scraping bill # 31\n",
      "scraping bill # 32\n",
      "scraping bill # 33\n",
      "scraping bill # 34\n",
      "scraping bill # 35\n",
      "scraping bill # 36\n",
      "scraping bill # 37\n",
      "scraping bill # 38\n",
      "scraping bill # 39\n",
      "scraping bill # 40\n",
      "scraping bill # 41\n",
      "scraping bill # 42\n",
      "scraping bill # 43\n",
      "scraping bill # 44\n",
      "scraping bill # 45\n",
      "scraping bill # 46\n",
      "scraping bill # 47\n",
      "scraping bill # 48\n",
      "scraping bill # 49\n",
      "scraping bill # 50\n",
      "scraping bill # 51\n",
      "scraping bill # 52\n",
      "scraping bill # 53\n",
      "scraping bill # 54\n",
      "scraping bill # 55\n",
      "scraping bill # 56\n",
      "scraping bill # 57\n",
      "scraping bill # 58\n",
      "scraping bill # 59\n",
      "scraping bill # 60\n",
      "scraping bill # 61\n",
      "scraping bill # 62\n",
      "scraping bill # 63\n",
      "scraping bill # 64\n",
      "scraping bill # 65\n",
      "scraping bill # 66\n",
      "scraping bill # 67\n",
      "scraping bill # 68\n",
      "scraping bill # 69\n",
      "scraping bill # 70\n",
      "scraping bill # 71\n",
      "scraping bill # 72\n",
      "scraping bill # 73\n",
      "scraping bill # 74\n",
      "scraping bill # 75\n",
      "scraping bill # 76\n",
      "scraping bill # 77\n",
      "scraping bill # 78\n",
      "scraping bill # 79\n",
      "scraping bill # 80\n",
      "scraping bill # 81\n",
      "scraping bill # 82\n",
      "scraping bill # 83\n",
      "scraping bill # 84\n",
      "scraping bill # 85\n",
      "scraping bill # 86\n",
      "scraping bill # 87\n",
      "scraping bill # 88\n",
      "scraping bill # 89\n",
      "scraping bill # 90\n",
      "scraping bill # 91\n",
      "scraping bill # 92\n",
      "scraping bill # 93\n",
      "scraping bill # 94\n",
      "scraping bill # 95\n",
      "scraping bill # 96\n",
      "scraping bill # 97\n",
      "scraping bill # 98\n",
      "scraping bill # 99\n",
      "scraping bill # 100\n",
      "scraping bill # 101\n",
      "scraping bill # 102\n",
      "scraping bill # 103\n",
      "scraping bill # 104\n",
      "scraping bill # 105\n",
      "scraping bill # 106\n",
      "scraping bill # 107\n",
      "scraping bill # 108\n",
      "scraping bill # 109\n",
      "scraping bill # 110\n",
      "scraping bill # 111\n",
      "scraping bill # 112\n",
      "scraping bill # 113\n",
      "scraping bill # 114\n",
      "scraping bill # 115\n",
      "scraping bill # 116\n",
      "scraping bill # 117\n",
      "scraping bill # 118\n",
      "scraping bill # 119\n",
      "scraping bill # 120\n",
      "scraping bill # 121\n",
      "scraping bill # 122\n",
      "scraping bill # 123\n",
      "scraping bill # 124\n",
      "scraping bill # 125\n",
      "scraping bill # 126\n",
      "scraping bill # 127\n",
      "scraping bill # 128\n",
      "scraping bill # 129\n",
      "scraping bill # 130\n",
      "scraping bill # 131\n",
      "scraping bill # 132\n",
      "scraping bill # 133\n",
      "scraping bill # 134\n",
      "scraping bill # 135\n",
      "scraping bill # 136\n",
      "scraping bill # 137\n",
      "scraping bill # 138\n",
      "scraping bill # 139\n",
      "scraping bill # 140\n",
      "scraping bill # 141\n",
      "scraping bill # 142\n",
      "scraping bill # 143\n",
      "scraping bill # 144\n",
      "scraping bill # 145\n",
      "scraping bill # 146\n",
      "scraping bill # 147\n",
      "scraping bill # 148\n",
      "scraping bill # 149\n",
      "scraping bill # 150\n",
      "scraping bill # 151\n",
      "scraping bill # 152\n",
      "scraping bill # 153\n",
      "scraping bill # 154\n",
      "scraping bill # 155\n",
      "scraping bill # 156\n",
      "scraping bill # 157\n",
      "scraping bill # 158\n",
      "scraping bill # 159\n",
      "scraping bill # 160\n",
      "scraping bill # 161\n",
      "scraping bill # 162\n",
      "scraping bill # 163\n",
      "scraping bill # 164\n",
      "scraping bill # 165\n",
      "scraping bill # 166\n",
      "scraping bill # 167\n",
      "scraping bill # 168\n",
      "scraping bill # 169\n",
      "scraping bill # 170\n",
      "scraping bill # 171\n",
      "scraping bill # 172\n",
      "scraping bill # 173\n",
      "scraping bill # 174\n",
      "scraping bill # 175\n",
      "scraping bill # 176\n",
      "scraping bill # 177\n",
      "scraping bill # 178\n",
      "scraping bill # 179\n",
      "scraping bill # 180\n",
      "scraping bill # 181\n",
      "scraping bill # 182\n",
      "scraping bill # 183\n",
      "scraping bill # 184\n",
      "scraping bill # 185\n",
      "scraping bill # 186\n",
      "scraping bill # 187\n",
      "scraping bill # 188\n",
      "scraping bill # 189\n",
      "scraping bill # 190\n",
      "scraping bill # 191\n",
      "scraping bill # 192\n",
      "scraping bill # 193\n",
      "scraping bill # 194\n",
      "scraping bill # 195\n",
      "scraping bill # 196\n",
      "scraping bill # 197\n",
      "scraping bill # 198\n",
      "scraping bill # 199\n",
      "scraping bill # 200\n",
      "scraping bill # 201\n",
      "scraping bill # 202\n",
      "scraping bill # 203\n",
      "scraping bill # 204\n",
      "scraping bill # 205\n",
      "scraping bill # 206\n",
      "scraping bill # 207\n",
      "scraping bill # 208\n",
      "scraping bill # 209\n",
      "scraping bill # 210\n",
      "scraping bill # 211\n",
      "scraping bill # 212\n",
      "scraping bill # 213\n",
      "scraping bill # 214\n",
      "scraping bill # 215\n",
      "scraping bill # 216\n",
      "scraping bill # 217\n",
      "scraping bill # 218\n",
      "scraping bill # 219\n",
      "scraping bill # 220\n",
      "scraping bill # 221\n",
      "scraping bill # 222\n",
      "scraping bill # 223\n",
      "scraping bill # 224\n",
      "scraping bill # 225\n",
      "scraping bill # 226\n",
      "scraping bill # 227\n",
      "scraping bill # 228\n",
      "scraping bill # 229\n",
      "scraping bill # 230\n",
      "scraping bill # 231\n",
      "scraping bill # 232\n",
      "scraping bill # 233\n",
      "scraping bill # 234\n",
      "scraping bill # 235\n",
      "scraping bill # 236\n",
      "scraping bill # 237\n",
      "scraping bill # 238\n",
      "scraping bill # 239\n",
      "scraping bill # 240\n",
      "scraping bill # 241\n",
      "scraping bill # 242\n",
      "scraping bill # 243\n",
      "scraping bill # 244\n",
      "scraping bill # 245\n",
      "scraping bill # 246\n",
      "scraping bill # 247\n",
      "scraping bill # 248\n",
      "scraping bill # 249\n",
      "scraping bill # 250\n",
      "scraping bill # 251\n",
      "scraping bill # 252\n",
      "scraping bill # 253\n",
      "scraping bill # 254\n",
      "scraping bill # 255\n",
      "scraping bill # 256\n",
      "scraping bill # 257\n",
      "scraping bill # 258\n",
      "scraping bill # 259\n",
      "scraping bill # 260\n",
      "scraping bill # 261\n",
      "scraping bill # 262\n",
      "scraping bill # 263\n",
      "scraping bill # 264\n",
      "scraping bill # 265\n",
      "scraping bill # 266\n",
      "scraping bill # 267\n",
      "scraping bill # 268\n",
      "scraping bill # 269\n",
      "scraping bill # 270\n",
      "scraping bill # 271\n",
      "scraping bill # 272\n",
      "scraping bill # 273\n",
      "scraping bill # 274\n",
      "scraping bill # 275\n",
      "scraping bill # 276\n",
      "scraping bill # 277\n",
      "scraping bill # 278\n",
      "scraping bill # 279\n",
      "scraping bill # 280\n",
      "scraping bill # 281\n",
      "scraping bill # 282\n",
      "scraping bill # 283\n",
      "scraping bill # 284\n",
      "scraping bill # 285\n",
      "scraping bill # 286\n",
      "scraping bill # 287\n",
      "scraping bill # 288\n",
      "scraping bill # 289\n",
      "scraping bill # 290\n",
      "scraping bill # 291\n",
      "scraping bill # 292\n",
      "scraping bill # 293\n",
      "scraping bill # 294\n",
      "scraping bill # 295\n",
      "scraping bill # 296\n",
      "scraping bill # 297\n",
      "scraping bill # 298\n",
      "scraping bill # 299\n",
      "scraping bill # 300\n",
      "scraping bill # 301\n",
      "scraping bill # 302\n",
      "scraping bill # 303\n",
      "scraping bill # 304\n",
      "scraping bill # 305\n",
      "scraping bill # 306\n",
      "scraping bill # 307\n",
      "scraping bill # 308\n",
      "scraping bill # 309\n",
      "scraping bill # 310\n",
      "scraping bill # 311\n",
      "scraping bill # 312\n",
      "scraping bill # 313\n",
      "scraping bill # 314\n",
      "scraping bill # 315\n",
      "scraping bill # 316\n",
      "scraping bill # 317\n",
      "scraping bill # 318\n",
      "scraping bill # 319\n",
      "scraping bill # 320\n",
      "scraping bill # 321\n",
      "scraping bill # 322\n",
      "scraping bill # 323\n",
      "scraping bill # 324\n",
      "scraping bill # 325\n",
      "scraping bill # 326\n",
      "scraping bill # 327\n",
      "scraping bill # 328\n",
      "scraping bill # 329\n",
      "scraping bill # 330\n",
      "scraping bill # 331\n",
      "scraping bill # 332\n",
      "scraping bill # 333\n",
      "scraping bill # 334\n",
      "scraping bill # 335\n",
      "scraping bill # 336\n",
      "scraping bill # 337\n",
      "scraping bill # 338\n",
      "scraping bill # 339\n",
      "scraping bill # 340\n",
      "scraping bill # 341\n",
      "scraping bill # 342\n",
      "scraping bill # 343\n",
      "scraping bill # 344\n",
      "scraping bill # 345\n",
      "scraping bill # 346\n",
      "scraping bill # 347\n",
      "scraping bill # 348\n",
      "scraping bill # 349\n",
      "scraping bill # 350\n",
      "scraping bill # 351\n",
      "scraping bill # 352\n",
      "scraping bill # 353\n",
      "scraping bill # 354\n",
      "scraping bill # 355\n",
      "scraping bill # 356\n",
      "scraping bill # 357\n",
      "scraping bill # 358\n",
      "scraping bill # 359\n",
      "scraping bill # 360\n",
      "scraping bill # 361\n",
      "scraping bill # 362\n",
      "scraping bill # 363\n",
      "scraping bill # 364\n",
      "scraping bill # 365\n",
      "scraping bill # 366\n",
      "scraping bill # 367\n",
      "scraping bill # 368\n",
      "scraping bill # 369\n",
      "scraping bill # 370\n",
      "scraping bill # 371\n",
      "scraping bill # 372\n",
      "scraping bill # 373\n",
      "scraping bill # 374\n",
      "scraping bill # 375\n",
      "scraping bill # 376\n",
      "scraping bill # 377\n",
      "scraping bill # 378\n",
      "scraping bill # 379\n",
      "scraping bill # 380\n",
      "scraping bill # 381\n",
      "scraping bill # 382\n",
      "scraping bill # 383\n",
      "scraping bill # 384\n",
      "scraping bill # 385\n",
      "scraping bill # 386\n",
      "scraping bill # 387\n",
      "scraping bill # 388\n",
      "scraping bill # 389\n",
      "scraping bill # 390\n",
      "scraping bill # 391\n",
      "scraping bill # 392\n",
      "scraping bill # 393\n",
      "scraping bill # 394\n",
      "scraping bill # 395\n",
      "scraping bill # 396\n",
      "scraping bill # 397\n",
      "scraping bill # 398\n",
      "scraping bill # 399\n",
      "scraping bill # 400\n",
      "scraping bill # 401\n",
      "scraping bill # 402\n",
      "scraping bill # 403\n",
      "scraping bill # 404\n",
      "scraping bill # 405\n",
      "scraping bill # 406\n",
      "scraping bill # 407\n",
      "scraping bill # 408\n",
      "scraping bill # 409\n",
      "scraping bill # 410\n",
      "scraping bill # 411\n",
      "scraping bill # 412\n",
      "scraping bill # 413\n",
      "scraping bill # 414\n",
      "scraping bill # 415\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scraping bill # 416\n",
      "scraping bill # 417\n",
      "scraping bill # 418\n",
      "scraping bill # 419\n",
      "scraping bill # 420\n",
      "scraping bill # 421\n",
      "scraping bill # 422\n",
      "scraping bill # 423\n",
      "scraping bill # 424\n",
      "scraping bill # 425\n",
      "scraping bill # 426\n",
      "scraping bill # 427\n",
      "scraping bill # 428\n",
      "scraping bill # 429\n",
      "scraping bill # 430\n",
      "scraping bill # 431\n",
      "scraping bill # 432\n",
      "scraping bill # 433\n",
      "scraping bill # 434\n",
      "scraping bill # 435\n",
      "scraping bill # 436\n",
      "scraping bill # 437\n",
      "scraping bill # 438\n",
      "scraping bill # 439\n",
      "scraping bill # 440\n",
      "scraping bill # 441\n",
      "scraping bill # 442\n",
      "scraping bill # 443\n",
      "scraping bill # 444\n",
      "scraping bill # 445\n",
      "scraping bill # 446\n",
      "scraping bill # 447\n",
      "scraping bill # 448\n",
      "scraping bill # 449\n",
      "scraping bill # 450\n",
      "scraping bill # 451\n",
      "scraping bill # 452\n",
      "scraping bill # 453\n",
      "scraping bill # 454\n",
      "scraping bill # 455\n",
      "scraping bill # 456\n",
      "scraping bill # 457\n",
      "scraping bill # 458\n",
      "scraping bill # 459\n",
      "scraping bill # 460\n",
      "scraping bill # 461\n",
      "scraping bill # 462\n",
      "scraping bill # 463\n",
      "scraping bill # 464\n",
      "scraping bill # 465\n",
      "scraping bill # 466\n",
      "scraping bill # 467\n",
      "scraping bill # 468\n",
      "scraping bill # 469\n",
      "scraping bill # 470\n",
      "scraping bill # 471\n",
      "scraping bill # 472\n",
      "scraping bill # 473\n",
      "scraping bill # 474\n",
      "scraping bill # 475\n",
      "scraping bill # 476\n",
      "scraping bill # 477\n",
      "scraping bill # 478\n",
      "scraping bill # 479\n",
      "scraping bill # 480\n",
      "scraping bill # 481\n",
      "scraping bill # 482\n",
      "scraping bill # 483\n",
      "scraping bill # 484\n",
      "scraping bill # 485\n",
      "scraping bill # 486\n",
      "scraping bill # 487\n",
      "scraping bill # 488\n",
      "scraping bill # 489\n",
      "scraping bill # 490\n",
      "scraping bill # 491\n",
      "scraping bill # 492\n",
      "scraping bill # 493\n",
      "scraping bill # 494\n",
      "scraping bill # 495\n",
      "scraping bill # 496\n",
      "scraping bill # 497\n",
      "scraping bill # 498\n",
      "scraping bill # 499\n",
      "scraping bill # 500\n",
      "scraping bill # 501\n",
      "scraping bill # 502\n",
      "scraping bill # 503\n",
      "scraping bill # 504\n",
      "scraping bill # 505\n",
      "scraping bill # 506\n",
      "scraping bill # 507\n",
      "scraping bill # 508\n",
      "scraping bill # 509\n",
      "scraping bill # 510\n",
      "scraping bill # 511\n",
      "scraping bill # 512\n",
      "scraping bill # 513\n",
      "scraping bill # 514\n",
      "scraping bill # 515\n",
      "scraping bill # 516\n",
      "scraping bill # 517\n",
      "scraping bill # 518\n",
      "scraping bill # 519\n",
      "scraping bill # 520\n",
      "scraping bill # 521\n",
      "scraping bill # 522\n",
      "scraping bill # 523\n",
      "scraping bill # 524\n",
      "scraping bill # 525\n",
      "scraping bill # 526\n",
      "scraping bill # 527\n",
      "scraping bill # 528\n",
      "scraping bill # 529\n",
      "scraping bill # 530\n",
      "scraping bill # 531\n",
      "scraping bill # 532\n",
      "scraping bill # 533\n",
      "scraping bill # 534\n",
      "scraping bill # 535\n",
      "scraping bill # 536\n",
      "scraping bill # 537\n",
      "scraping bill # 538\n",
      "scraping bill # 539\n",
      "scraping bill # 540\n",
      "scraping bill # 541\n",
      "scraping bill # 542\n",
      "scraping bill # 543\n",
      "scraping bill # 544\n",
      "scraping bill # 545\n",
      "scraping bill # 546\n",
      "scraping bill # 547\n",
      "scraping bill # 548\n",
      "scraping bill # 549\n",
      "scraping bill # 550\n",
      "scraping bill # 551\n",
      "scraping bill # 552\n",
      "scraping bill # 553\n",
      "scraping bill # 554\n",
      "scraping bill # 555\n",
      "scraping bill # 556\n",
      "scraping bill # 557\n",
      "scraping bill # 558\n",
      "scraping bill # 559\n",
      "scraping bill # 560\n",
      "scraping bill # 561\n",
      "scraping bill # 562\n",
      "scraping bill # 563\n",
      "scraping bill # 564\n",
      "scraping bill # 565\n",
      "scraping bill # 566\n",
      "scraping bill # 567\n",
      "scraping bill # 568\n",
      "scraping bill # 569\n",
      "scraping bill # 570\n",
      "scraping bill # 571\n",
      "scraping bill # 572\n",
      "scraping bill # 573\n",
      "scraping bill # 574\n",
      "scraping bill # 575\n",
      "scraping bill # 576\n",
      "scraping bill # 577\n",
      "scraping bill # 578\n",
      "scraping bill # 579\n",
      "scraping bill # 580\n",
      "scraping bill # 581\n",
      "scraping bill # 582\n",
      "scraping bill # 583\n",
      "scraping bill # 584\n",
      "scraping bill # 585\n",
      "scraping bill # 586\n",
      "scraping bill # 587\n",
      "scraping bill # 588\n",
      "scraping bill # 589\n",
      "scraping bill # 590\n",
      "scraping bill # 591\n",
      "scraping bill # 592\n",
      "scraping bill # 593\n",
      "scraping bill # 594\n",
      "scraping bill # 595\n",
      "scraping bill # 596\n",
      "scraping bill # 597\n",
      "scraping bill # 598\n",
      "scraping bill # 599\n",
      "scraping bill # 600\n",
      "scraping bill # 601\n",
      "scraping bill # 602\n",
      "scraping bill # 603\n",
      "scraping bill # 604\n",
      "scraping bill # 605\n",
      "scraping bill # 606\n",
      "scraping bill # 607\n",
      "scraping bill # 608\n",
      "scraping bill # 609\n",
      "scraping bill # 610\n",
      "scraping bill # 611\n",
      "scraping bill # 612\n",
      "scraping bill # 613\n",
      "scraping bill # 614\n",
      "scraping bill # 615\n",
      "scraping bill # 616\n",
      "scraping bill # 617\n",
      "scraping bill # 618\n",
      "scraping bill # 619\n",
      "scraping bill # 620\n",
      "scraping bill # 621\n",
      "scraping bill # 622\n",
      "scraping bill # 623\n",
      "scraping bill # 624\n",
      "scraping bill # 625\n",
      "scraping bill # 626\n",
      "scraping bill # 627\n",
      "scraping bill # 628\n",
      "scraping bill # 629\n",
      "scraping bill # 630\n",
      "scraping bill # 631\n",
      "scraping bill # 632\n",
      "scraping bill # 633\n",
      "scraping bill # 634\n",
      "scraping bill # 635\n",
      "scraping bill # 636\n",
      "scraping bill # 637\n",
      "scraping bill # 638\n",
      "scraping bill # 639\n",
      "scraping bill # 640\n",
      "scraping bill # 641\n",
      "scraping bill # 642\n",
      "scraping bill # 643\n",
      "scraping bill # 644\n",
      "scraping bill # 645\n",
      "scraping bill # 646\n",
      "scraping bill # 647\n",
      "scraping bill # 648\n",
      "scraping bill # 649\n",
      "scraping bill # 650\n",
      "scraping bill # 651\n",
      "scraping bill # 652\n",
      "scraping bill # 653\n",
      "scraping bill # 654\n",
      "scraping bill # 655\n",
      "scraping bill # 656\n",
      "scraping bill # 657\n",
      "scraping bill # 658\n",
      "scraping bill # 659\n",
      "scraping bill # 660\n",
      "scraping bill # 661\n",
      "scraping bill # 662\n",
      "scraping bill # 663\n",
      "scraping bill # 664\n",
      "scraping bill # 665\n",
      "scraping bill # 666\n",
      "scraping bill # 667\n",
      "scraping bill # 668\n",
      "scraping bill # 669\n",
      "scraping bill # 670\n",
      "scraping bill # 671\n",
      "scraping bill # 672\n",
      "scraping bill # 673\n",
      "scraping bill # 674\n",
      "scraping bill # 675\n",
      "scraping bill # 676\n",
      "scraping bill # 677\n",
      "scraping bill # 678\n",
      "scraping bill # 679\n",
      "scraping bill # 680\n",
      "scraping bill # 681\n",
      "scraping bill # 682\n",
      "scraping bill # 683\n",
      "scraping bill # 684\n",
      "scraping bill # 685\n",
      "scraping bill # 686\n",
      "scraping bill # 687\n",
      "scraping bill # 688\n",
      "scraping bill # 689\n",
      "scraping bill # 690\n",
      "scraping bill # 691\n",
      "scraping bill # 692\n",
      "scraping bill # 693\n",
      "scraping bill # 694\n",
      "scraping bill # 695\n",
      "scraping bill # 696\n",
      "scraping bill # 697\n",
      "scraping bill # 698\n",
      "scraping bill # 699\n",
      "scraping bill # 700\n",
      "scraping bill # 701\n",
      "scraping bill # 702\n",
      "scraping bill # 703\n",
      "scraping bill # 704\n",
      "scraping bill # 705\n",
      "scraping bill # 706\n",
      "scraping bill # 707\n",
      "scraping bill # 708\n",
      "scraping bill # 709\n",
      "scraping bill # 710\n",
      "scraping bill # 711\n",
      "scraping bill # 712\n",
      "scraping bill # 713\n",
      "scraping bill # 714\n",
      "scraping bill # 715\n",
      "scraping bill # 716\n",
      "scraping bill # 717\n",
      "scraping bill # 718\n",
      "scraping bill # 719\n",
      "scraping bill # 720\n",
      "scraping bill # 721\n",
      "scraping bill # 722\n",
      "scraping bill # 723\n",
      "scraping bill # 724\n",
      "scraping bill # 725\n",
      "scraping bill # 726\n",
      "scraping bill # 727\n",
      "scraping bill # 728\n",
      "scraping bill # 729\n",
      "scraping bill # 730\n",
      "scraping bill # 731\n",
      "scraping bill # 732\n",
      "scraping bill # 733\n",
      "scraping bill # 734\n",
      "scraping bill # 735\n",
      "scraping bill # 736\n",
      "scraping bill # 737\n",
      "scraping bill # 738\n",
      "scraping bill # 739\n",
      "scraping bill # 740\n",
      "scraping bill # 741\n",
      "scraping bill # 742\n",
      "scraping bill # 743\n",
      "scraping bill # 744\n",
      "scraping bill # 745\n",
      "scraping bill # 746\n",
      "scraping bill # 747\n",
      "scraping bill # 748\n",
      "scraping bill # 749\n",
      "scraping bill # 750\n",
      "scraping bill # 751\n",
      "scraping bill # 752\n",
      "scraping bill # 753\n",
      "scraping bill # 754\n",
      "scraping bill # 755\n",
      "scraping bill # 756\n",
      "scraping bill # 757\n",
      "scraping bill # 758\n",
      "scraping bill # 759\n",
      "scraping bill # 760\n",
      "scraping bill # 761\n",
      "scraping bill # 762\n",
      "scraping bill # 763\n",
      "scraping bill # 764\n",
      "scraping bill # 765\n",
      "scraping bill # 766\n",
      "scraping bill # 767\n",
      "scraping bill # 768\n",
      "scraping bill # 769\n",
      "scraping bill # 770\n",
      "scraping bill # 771\n",
      "scraping bill # 772\n",
      "scraping bill # 773\n",
      "scraping bill # 774\n",
      "scraping bill # 775\n",
      "scraping bill # 776\n",
      "scraping bill # 777\n",
      "scraping bill # 778\n",
      "scraping bill # 779\n",
      "scraping bill # 780\n",
      "scraping bill # 781\n",
      "scraping bill # 782\n",
      "scraping bill # 783\n",
      "scraping bill # 784\n",
      "scraping bill # 785\n",
      "scraping bill # 786\n",
      "scraping bill # 787\n",
      "scraping bill # 788\n",
      "scraping bill # 789\n",
      "scraping bill # 790\n",
      "scraping bill # 791\n",
      "scraping bill # 792\n",
      "scraping bill # 793\n",
      "scraping bill # 794\n",
      "scraping bill # 795\n",
      "scraping bill # 796\n",
      "scraping bill # 797\n",
      "scraping bill # 798\n",
      "scraping bill # 799\n",
      "scraping bill # 800\n",
      "scraping bill # 801\n",
      "scraping bill # 802\n",
      "scraping bill # 803\n",
      "scraping bill # 804\n",
      "scraping bill # 805\n",
      "scraping bill # 806\n",
      "scraping bill # 807\n",
      "scraping bill # 808\n",
      "scraping bill # 809\n",
      "scraping bill # 810\n",
      "scraping bill # 811\n",
      "scraping bill # 812\n",
      "scraping bill # 813\n",
      "scraping bill # 814\n",
      "scraping bill # 815\n",
      "scraping bill # 816\n",
      "scraping bill # 817\n",
      "scraping bill # 818\n",
      "scraping bill # 819\n",
      "scraping bill # 820\n",
      "scraping bill # 821\n",
      "scraping bill # 822\n",
      "scraping bill # 823\n",
      "scraping bill # 824\n",
      "scraping bill # 825\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scraping bill # 826\n",
      "scraping bill # 827\n",
      "scraping bill # 828\n",
      "scraping bill # 829\n",
      "scraping bill # 830\n",
      "scraping bill # 831\n",
      "scraping bill # 832\n",
      "scraping bill # 833\n",
      "scraping bill # 834\n",
      "scraping bill # 835\n",
      "scraping bill # 836\n",
      "scraping bill # 837\n",
      "scraping bill # 838\n",
      "scraping bill # 839\n",
      "scraping bill # 840\n",
      "scraping bill # 841\n",
      "scraping bill # 842\n",
      "scraping bill # 843\n",
      "scraping bill # 844\n",
      "scraping bill # 845\n",
      "scraping bill # 846\n",
      "scraping bill # 847\n",
      "scraping bill # 848\n",
      "scraping bill # 849\n",
      "scraping bill # 850\n",
      "scraping bill # 851\n",
      "scraping bill # 852\n",
      "scraping bill # 853\n",
      "scraping bill # 854\n",
      "scraping bill # 855\n",
      "scraping bill # 856\n",
      "scraping bill # 857\n",
      "scraping bill # 858\n",
      "scraping bill # 859\n",
      "scraping bill # 860\n",
      "scraping bill # 861\n",
      "scraping bill # 862\n",
      "scraping bill # 863\n",
      "scraping bill # 864\n",
      "scraping bill # 865\n",
      "scraping bill # 866\n",
      "scraping bill # 867\n",
      "scraping bill # 868\n",
      "scraping bill # 869\n",
      "scraping bill # 870\n",
      "scraping bill # 871\n",
      "scraping bill # 872\n",
      "scraping bill # 873\n",
      "scraping bill # 874\n",
      "scraping bill # 875\n",
      "scraping bill # 876\n",
      "scraping bill # 877\n",
      "scraping bill # 878\n",
      "scraping bill # 879\n",
      "scraping bill # 880\n",
      "scraping bill # 881\n",
      "scraping bill # 882\n",
      "scraping bill # 883\n",
      "scraping bill # 884\n",
      "scraping bill # 885\n",
      "scraping bill # 886\n",
      "scraping bill # 887\n",
      "scraping bill # 888\n",
      "scraping bill # 889\n",
      "scraping bill # 890\n",
      "scraping bill # 891\n",
      "scraping bill # 892\n",
      "scraping bill # 893\n",
      "scraping bill # 894\n",
      "scraping bill # 895\n",
      "scraping bill # 896\n",
      "scraping bill # 897\n",
      "scraping bill # 898\n",
      "scraping bill # 899\n",
      "scraping bill # 900\n",
      "scraping bill # 901\n",
      "scraping bill # 902\n",
      "scraping bill # 903\n",
      "scraping bill # 904\n",
      "scraping bill # 905\n",
      "scraping bill # 906\n",
      "scraping bill # 907\n",
      "scraping bill # 908\n",
      "scraping bill # 909\n",
      "scraping bill # 910\n",
      "scraping bill # 911\n",
      "scraping bill # 912\n",
      "scraping bill # 913\n",
      "scraping bill # 914\n",
      "scraping bill # 915\n",
      "scraping bill # 916\n",
      "scraping bill # 917\n",
      "scraping bill # 918\n",
      "scraping bill # 919\n",
      "scraping bill # 920\n",
      "scraping bill # 921\n",
      "scraping bill # 922\n",
      "scraping bill # 923\n",
      "scraping bill # 924\n",
      "scraping bill # 925\n",
      "scraping bill # 926\n",
      "scraping bill # 927\n",
      "scraping bill # 928\n",
      "scraping bill # 929\n",
      "scraping bill # 930\n",
      "scraping bill # 931\n",
      "scraping bill # 932\n",
      "scraping bill # 933\n",
      "scraping bill # 934\n",
      "scraping bill # 935\n",
      "scraping bill # 936\n",
      "scraping bill # 937\n",
      "scraping bill # 938\n",
      "scraping bill # 939\n",
      "scraping bill # 940\n",
      "scraping bill # 941\n",
      "scraping bill # 942\n",
      "scraping bill # 943\n",
      "scraping bill # 944\n",
      "scraping bill # 945\n",
      "scraping bill # 946\n",
      "scraping bill # 947\n",
      "scraping bill # 948\n",
      "scraping bill # 949\n",
      "scraping bill # 950\n",
      "scraping bill # 951\n",
      "scraping bill # 952\n",
      "scraping bill # 953\n",
      "scraping bill # 954\n",
      "scraping bill # 955\n",
      "scraping bill # 956\n",
      "scraping bill # 957\n",
      "scraping bill # 958\n",
      "scraping bill # 959\n",
      "scraping bill # 960\n",
      "scraping bill # 961\n",
      "scraping bill # 962\n",
      "scraping bill # 963\n",
      "scraping bill # 964\n",
      "scraping bill # 965\n",
      "scraping bill # 966\n",
      "scraping bill # 967\n",
      "scraping bill # 968\n",
      "scraping bill # 969\n",
      "scraping bill # 970\n",
      "scraping bill # 971\n",
      "scraping bill # 972\n",
      "scraping bill # 973\n",
      "scraping bill # 974\n",
      "scraping bill # 975\n",
      "scraping bill # 976\n",
      "scraping bill # 977\n",
      "scraping bill # 978\n",
      "scraping bill # 979\n",
      "scraping bill # 980\n",
      "scraping bill # 981\n",
      "scraping bill # 982\n",
      "scraping bill # 983\n",
      "scraping bill # 984\n",
      "scraping bill # 985\n",
      "scraping bill # 986\n",
      "scraping bill # 987\n",
      "scraping bill # 988\n",
      "scraping bill # 989\n",
      "scraping bill # 990\n",
      "scraping bill # 991\n",
      "scraping bill # 992\n",
      "scraping bill # 993\n",
      "scraping bill # 994\n",
      "scraping bill # 995\n",
      "scraping bill # 996\n",
      "scraping bill # 997\n",
      "scraping bill # 998\n",
      "scraping bill # 999\n",
      "scraping bill # 1000\n",
      "scraping bill # 1001\n",
      "scraping bill # 1002\n",
      "scraping bill # 1003\n",
      "scraping bill # 1004\n",
      "scraping bill # 1005\n",
      "scraping bill # 1006\n",
      "scraping bill # 1007\n",
      "scraping bill # 1008\n",
      "scraping bill # 1009\n",
      "scraping bill # 1010\n",
      "scraping bill # 1011\n",
      "scraping bill # 1012\n",
      "scraping bill # 1013\n",
      "scraping bill # 1014\n",
      "scraping bill # 1015\n",
      "scraping bill # 1016\n",
      "scraping bill # 1017\n",
      "scraping bill # 1018\n",
      "scraping bill # 1019\n",
      "scraping bill # 1020\n",
      "scraping bill # 1021\n",
      "scraping bill # 1022\n",
      "scraping bill # 1023\n",
      "scraping bill # 1024\n",
      "scraping bill # 1025\n",
      "scraping bill # 1026\n",
      "scraping bill # 1027\n",
      "scraping bill # 1028\n",
      "scraping bill # 1029\n",
      "scraping bill # 1030\n",
      "scraping bill # 1031\n",
      "scraping bill # 1032\n",
      "scraping bill # 1033\n",
      "scraping bill # 1034\n",
      "scraping bill # 1035\n",
      "scraping bill # 1036\n",
      "scraping bill # 1037\n",
      "scraping bill # 1038\n",
      "scraping bill # 1039\n",
      "scraping bill # 1040\n",
      "scraping bill # 1041\n",
      "scraping bill # 1042\n",
      "scraping bill # 1043\n",
      "scraping bill # 1044\n",
      "scraping bill # 1045\n",
      "scraping bill # 1046\n",
      "scraping bill # 1047\n",
      "scraping bill # 1048\n",
      "scraping bill # 1049\n",
      "scraping bill # 1050\n",
      "scraping bill # 1051\n",
      "scraping bill # 1052\n",
      "scraping bill # 1053\n",
      "scraping bill # 1054\n",
      "scraping bill # 1055\n",
      "scraping bill # 1056\n",
      "scraping bill # 1057\n",
      "scraping bill # 1058\n",
      "scraping bill # 1059\n",
      "scraping bill # 1060\n",
      "scraping bill # 1061\n",
      "scraping bill # 1062\n",
      "scraping bill # 1063\n",
      "scraping bill # 1064\n",
      "scraping bill # 1065\n",
      "scraping bill # 1066\n",
      "scraping bill # 1067\n",
      "scraping bill # 1068\n",
      "scraping bill # 1069\n",
      "scraping bill # 1070\n",
      "scraping bill # 1071\n",
      "scraping bill # 1072\n",
      "scraping bill # 1073\n",
      "scraping bill # 1074\n",
      "scraping bill # 1075\n",
      "scraping bill # 1076\n",
      "scraping bill # 1077\n",
      "scraping bill # 1078\n",
      "scraping bill # 1079\n",
      "scraping bill # 1080\n",
      "scraping bill # 1081\n",
      "scraping bill # 1082\n",
      "scraping bill # 1083\n",
      "scraping bill # 1084\n",
      "scraping bill # 1085\n",
      "scraping bill # 1086\n",
      "scraping bill # 1087\n",
      "scraping bill # 1088\n",
      "scraping bill # 1089\n",
      "scraping bill # 1090\n",
      "scraping bill # 1091\n",
      "scraping bill # 1092\n",
      "scraping bill # 1093\n",
      "scraping bill # 1094\n",
      "scraping bill # 1095\n",
      "scraping bill # 1096\n",
      "scraping bill # 1097\n",
      "scraping bill # 1098\n",
      "scraping bill # 1099\n",
      "scraping bill # 1100\n",
      "scraping bill # 1101\n",
      "scraping bill # 1102\n",
      "scraping bill # 1103\n",
      "scraping bill # 1104\n",
      "scraping bill # 1105\n",
      "scraping bill # 1106\n",
      "scraping bill # 1107\n",
      "scraping bill # 1108\n",
      "scraping bill # 1109\n",
      "scraping bill # 1110\n",
      "scraping bill # 1111\n",
      "scraping bill # 1112\n",
      "scraping bill # 1113\n",
      "scraping bill # 1114\n",
      "scraping bill # 1115\n",
      "scraping bill # 1116\n",
      "scraping bill # 1117\n",
      "scraping bill # 1118\n",
      "scraping bill # 1119\n",
      "scraping bill # 1120\n",
      "scraping bill # 1121\n",
      "scraping bill # 1122\n",
      "scraping bill # 1123\n",
      "scraping bill # 1124\n",
      "scraping bill # 1125\n",
      "scraping bill # 1126\n",
      "scraping bill # 1127\n",
      "scraping bill # 1128\n",
      "scraping bill # 1129\n",
      "scraping bill # 1130\n",
      "scraping bill # 1131\n",
      "scraping bill # 1132\n",
      "scraping bill # 1133\n",
      "scraping bill # 1134\n",
      "scraping bill # 1135\n",
      "scraping bill # 1136\n",
      "scraping bill # 1137\n",
      "scraping bill # 1138\n",
      "scraping bill # 1139\n",
      "scraping bill # 1140\n",
      "scraping bill # 1141\n",
      "scraping bill # 1142\n",
      "scraping bill # 1143\n",
      "scraping bill # 1144\n",
      "scraping bill # 1145\n",
      "scraping bill # 1146\n",
      "scraping bill # 1147\n",
      "scraping bill # 1148\n",
      "scraping bill # 1149\n",
      "scraping bill # 1150\n",
      "scraping bill # 1151\n",
      "scraping bill # 1152\n",
      "scraping bill # 1153\n",
      "scraping bill # 1154\n",
      "scraping bill # 1155\n",
      "scraping bill # 1156\n",
      "scraping bill # 1157\n",
      "scraping bill # 1158\n",
      "scraping bill # 1159\n",
      "scraping bill # 1160\n",
      "scraping bill # 1161\n",
      "scraping bill # 1162\n",
      "scraping bill # 1163\n",
      "scraping bill # 1164\n",
      "scraping bill # 1165\n",
      "scraping bill # 1166\n",
      "scraping bill # 1167\n",
      "scraping bill # 1168\n",
      "scraping bill # 1169\n",
      "scraping bill # 1170\n",
      "scraping bill # 1171\n",
      "scraping bill # 1172\n",
      "scraping bill # 1173\n",
      "scraping bill # 1174\n",
      "scraping bill # 1175\n",
      "scraping bill # 1176\n",
      "scraping bill # 1177\n",
      "scraping bill # 1178\n",
      "scraping bill # 1179\n",
      "scraping bill # 1180\n",
      "scraping bill # 1181\n",
      "scraping bill # 1182\n",
      "scraping bill # 1183\n",
      "scraping bill # 1184\n",
      "scraping bill # 1185\n",
      "scraping bill # 1186\n",
      "scraping bill # 1187\n",
      "scraping bill # 1188\n",
      "scraping bill # 1189\n",
      "scraping bill # 1190\n",
      "scraping bill # 1191\n",
      "scraping bill # 1192\n",
      "scraping bill # 1193\n",
      "scraping bill # 1194\n",
      "scraping bill # 1195\n",
      "scraping bill # 1196\n",
      "scraping bill # 1197\n",
      "scraping bill # 1198\n",
      "scraping bill # 1199\n",
      "scraping bill # 1200\n",
      "scraping bill # 1201\n",
      "scraping bill # 1202\n",
      "scraping bill # 1203\n",
      "scraping bill # 1204\n",
      "scraping bill # 1205\n",
      "scraping bill # 1206\n",
      "scraping bill # 1207\n",
      "scraping bill # 1208\n",
      "scraping bill # 1209\n",
      "scraping bill # 1210\n",
      "scraping bill # 1211\n",
      "scraping bill # 1212\n",
      "scraping bill # 1213\n",
      "scraping bill # 1214\n",
      "scraping bill # 1215\n",
      "scraping bill # 1216\n",
      "scraping bill # 1217\n",
      "scraping bill # 1218\n",
      "scraping bill # 1219\n",
      "scraping bill # 1220\n",
      "scraping bill # 1221\n",
      "scraping bill # 1222\n",
      "scraping bill # 1223\n",
      "scraping bill # 1224\n",
      "scraping bill # 1225\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scraping bill # 1226\n",
      "scraping bill # 1227\n",
      "scraping bill # 1228\n",
      "scraping bill # 1229\n",
      "scraping bill # 1230\n",
      "scraping bill # 1231\n",
      "scraping bill # 1232\n",
      "scraping bill # 1233\n",
      "scraping bill # 1234\n",
      "scraping bill # 1235\n",
      "scraping bill # 1236\n",
      "scraping bill # 1237\n",
      "scraping bill # 1238\n",
      "scraping bill # 1239\n",
      "scraping bill # 1240\n",
      "scraping bill # 1241\n",
      "scraping bill # 1242\n",
      "scraping bill # 1243\n",
      "scraping bill # 1244\n",
      "scraping bill # 1245\n",
      "scraping bill # 1246\n",
      "scraping bill # 1247\n",
      "scraping bill # 1248\n",
      "scraping bill # 1249\n",
      "scraping bill # 1250\n",
      "scraping bill # 1251\n",
      "scraping bill # 1252\n",
      "scraping bill # 1253\n",
      "scraping bill # 1254\n",
      "scraping bill # 1255\n",
      "scraping bill # 1256\n",
      "scraping bill # 1257\n",
      "scraping bill # 1258\n",
      "scraping bill # 1259\n",
      "scraping bill # 1260\n",
      "scraping bill # 1261\n",
      "scraping bill # 1262\n",
      "scraping bill # 1263\n",
      "scraping bill # 1264\n",
      "scraping bill # 1265\n",
      "scraping bill # 1266\n",
      "scraping bill # 1267\n",
      "scraping bill # 1268\n",
      "scraping bill # 1269\n",
      "scraping bill # 1270\n",
      "scraping bill # 1271\n",
      "scraping bill # 1272\n",
      "scraping bill # 1273\n",
      "scraping bill # 1274\n",
      "scraping bill # 1275\n",
      "scraping bill # 1276\n",
      "scraping bill # 1277\n",
      "scraping bill # 1278\n",
      "scraping bill # 1279\n",
      "scraping bill # 1280\n",
      "scraping bill # 1281\n",
      "scraping bill # 1282\n",
      "scraping bill # 1283\n",
      "scraping bill # 1284\n",
      "scraping bill # 1285\n",
      "scraping bill # 1286\n",
      "scraping bill # 1287\n",
      "scraping bill # 1288\n",
      "scraping bill # 1289\n",
      "scraping bill # 1290\n",
      "scraping bill # 1291\n",
      "scraping bill # 1292\n",
      "scraping bill # 1293\n",
      "scraping bill # 1294\n",
      "scraping bill # 1295\n",
      "scraping bill # 1296\n",
      "scraping bill # 1297\n",
      "scraping bill # 1298\n",
      "scraping bill # 1299\n",
      "scraping bill # 1300\n",
      "scraping bill # 1301\n",
      "scraping bill # 1302\n",
      "scraping bill # 1303\n",
      "scraping bill # 1304\n",
      "scraping bill # 1305\n",
      "scraping bill # 1306\n",
      "scraping bill # 1307\n",
      "scraping bill # 1308\n",
      "scraping bill # 1309\n",
      "scraping bill # 1310\n",
      "scraping bill # 1311\n",
      "scraping bill # 1312\n",
      "scraping bill # 1313\n",
      "scraping bill # 1314\n",
      "scraping bill # 1315\n",
      "scraping bill # 1316\n",
      "scraping bill # 1317\n",
      "scraping bill # 1318\n",
      "scraping bill # 1319\n",
      "scraping bill # 1320\n",
      "scraping bill # 1321\n",
      "scraping bill # 1322\n",
      "scraping bill # 1323\n",
      "scraping bill # 1324\n",
      "scraping bill # 1325\n",
      "scraping bill # 1326\n",
      "scraping bill # 1327\n",
      "scraping bill # 1328\n",
      "scraping bill # 1329\n",
      "scraping bill # 1330\n",
      "scraping bill # 1331\n",
      "scraping bill # 1332\n",
      "scraping bill # 1333\n",
      "scraping bill # 1334\n",
      "scraping bill # 1335\n",
      "scraping bill # 1336\n",
      "scraping bill # 1337\n",
      "scraping bill # 1338\n",
      "scraping bill # 1339\n",
      "scraping bill # 1340\n",
      "scraping bill # 1341\n",
      "scraping bill # 1342\n",
      "scraping bill # 1343\n",
      "scraping bill # 1344\n",
      "scraping bill # 1345\n",
      "scraping bill # 1346\n",
      "scraping bill # 1347\n",
      "scraping bill # 1348\n",
      "scraping bill # 1349\n",
      "scraping bill # 1350\n",
      "scraping bill # 1351\n",
      "scraping bill # 1352\n",
      "scraping bill # 1353\n",
      "scraping bill # 1354\n",
      "scraping bill # 1355\n",
      "scraping bill # 1356\n",
      "scraping bill # 1357\n",
      "scraping bill # 1358\n",
      "scraping bill # 1359\n",
      "scraping bill # 1360\n",
      "scraping bill # 1361\n",
      "scraping bill # 1362\n",
      "scraping bill # 1363\n",
      "scraping bill # 1364\n",
      "scraping bill # 1365\n",
      "scraping bill # 1366\n",
      "scraping bill # 1367\n",
      "scraping bill # 1368\n",
      "scraping bill # 1369\n",
      "scraping bill # 1370\n",
      "scraping bill # 1371\n",
      "scraping bill # 1372\n",
      "scraping bill # 1373\n",
      "scraping bill # 1374\n",
      "scraping bill # 1375\n",
      "scraping bill # 1376\n",
      "scraping bill # 1377\n",
      "scraping bill # 1378\n",
      "scraping bill # 1379\n",
      "scraping bill # 1380\n",
      "scraping bill # 1381\n",
      "scraping bill # 1382\n",
      "scraping bill # 1383\n",
      "scraping bill # 1384\n",
      "scraping bill # 1385\n",
      "scraping bill # 1386\n",
      "scraping bill # 1387\n",
      "scraping bill # 1388\n",
      "scraping bill # 1389\n",
      "scraping bill # 1390\n",
      "scraping bill # 1391\n",
      "scraping bill # 1392\n",
      "scraping bill # 1393\n",
      "scraping bill # 1394\n",
      "scraping bill # 1395\n",
      "scraping bill # 1396\n",
      "scraping bill # 1397\n",
      "scraping bill # 1398\n",
      "scraping bill # 1399\n",
      "scraping bill # 1400\n",
      "scraping bill # 1401\n",
      "scraping bill # 1402\n",
      "scraping bill # 1403\n",
      "scraping bill # 1404\n",
      "scraping bill # 1405\n",
      "scraping bill # 1406\n",
      "scraping bill # 1407\n",
      "scraping bill # 1408\n",
      "scraping bill # 1409\n",
      "scraping bill # 1410\n",
      "scraping bill # 1411\n",
      "scraping bill # 1412\n",
      "scraping bill # 1413\n",
      "scraping bill # 1414\n",
      "scraping bill # 1415\n",
      "scraping bill # 1416\n",
      "scraping bill # 1417\n",
      "scraping bill # 1418\n",
      "scraping bill # 1419\n",
      "scraping bill # 1420\n",
      "scraping bill # 1421\n",
      "scraping bill # 1422\n",
      "scraping bill # 1423\n",
      "scraping bill # 1424\n",
      "scraping bill # 1425\n",
      "scraping bill # 1426\n",
      "scraping bill # 1427\n",
      "scraping bill # 1428\n",
      "scraping bill # 1429\n",
      "scraping bill # 1430\n",
      "scraping bill # 1431\n",
      "scraping bill # 1432\n",
      "scraping bill # 1433\n",
      "scraping bill # 1434\n",
      "scraping bill # 1435\n",
      "scraping bill # 1436\n",
      "scraping bill # 1437\n",
      "scraping bill # 1438\n",
      "scraping bill # 1439\n",
      "scraping bill # 1440\n",
      "scraping bill # 1441\n",
      "scraping bill # 1442\n",
      "scraping bill # 1443\n",
      "scraping bill # 1444\n",
      "scraping bill # 1445\n",
      "scraping bill # 1446\n",
      "scraping bill # 1447\n",
      "scraping bill # 1448\n",
      "scraping bill # 1449\n",
      "scraping bill # 1450\n",
      "scraping bill # 1451\n",
      "scraping bill # 1452\n",
      "scraping bill # 1453\n",
      "scraping bill # 1454\n",
      "scraping bill # 1455\n",
      "scraping bill # 1456\n",
      "scraping bill # 1457\n",
      "scraping bill # 1458\n",
      "scraping bill # 1459\n",
      "scraping bill # 1460\n",
      "scraping bill # 1461\n",
      "scraping bill # 1462\n",
      "scraping bill # 1463\n",
      "scraping bill # 1464\n",
      "scraping bill # 1465\n",
      "scraping bill # 1466\n",
      "scraping bill # 1467\n",
      "scraping bill # 1468\n",
      "scraping bill # 1469\n",
      "scraping bill # 1470\n",
      "scraping bill # 1471\n",
      "scraping bill # 1472\n",
      "scraping bill # 1473\n",
      "scraping bill # 1474\n",
      "scraping bill # 1475\n",
      "scraping bill # 1476\n",
      "scraping bill # 1477\n",
      "scraping bill # 1478\n",
      "scraping bill # 1479\n",
      "scraping bill # 1480\n",
      "scraping bill # 1481\n",
      "scraping bill # 1482\n",
      "scraping bill # 1483\n",
      "scraping bill # 1484\n",
      "scraping bill # 1485\n",
      "scraping bill # 1486\n",
      "scraping bill # 1487\n",
      "scraping bill # 1488\n",
      "scraping bill # 1489\n",
      "scraping bill # 1490\n",
      "scraping bill # 1491\n",
      "scraping bill # 1492\n",
      "scraping bill # 1493\n",
      "scraping bill # 1494\n",
      "scraping bill # 1495\n",
      "scraping bill # 1496\n",
      "scraping bill # 1497\n",
      "scraping bill # 1498\n",
      "scraping bill # 1499\n",
      "scraping bill # 1500\n",
      "scraping bill # 1501\n",
      "scraping bill # 1502\n",
      "scraping bill # 1503\n",
      "scraping bill # 1504\n",
      "scraping bill # 1505\n",
      "scraping bill # 1506\n",
      "scraping bill # 1507\n",
      "scraping bill # 1508\n",
      "scraping bill # 1509\n",
      "scraping bill # 1510\n",
      "scraping bill # 1511\n",
      "scraping bill # 1512\n",
      "scraping bill # 1513\n",
      "scraping bill # 1514\n",
      "scraping bill # 1515\n",
      "scraping bill # 1516\n",
      "scraping bill # 1517\n",
      "scraping bill # 1518\n",
      "scraping bill # 1519\n",
      "scraping bill # 1520\n",
      "scraping bill # 1521\n",
      "scraping bill # 1522\n",
      "scraping bill # 1523\n",
      "scraping bill # 1524\n",
      "scraping bill # 1525\n",
      "scraping bill # 1526\n",
      "scraping bill # 1527\n",
      "scraping bill # 1528\n",
      "scraping bill # 1529\n",
      "scraping bill # 1530\n",
      "scraping bill # 1531\n",
      "scraping bill # 1532\n",
      "scraping bill # 1533\n",
      "scraping bill # 1534\n",
      "scraping bill # 1535\n",
      "scraping bill # 1536\n",
      "scraping bill # 1537\n",
      "scraping bill # 1538\n",
      "scraping bill # 1539\n",
      "scraping bill # 1540\n",
      "scraping bill # 1541\n",
      "scraping bill # 1542\n",
      "scraping bill # 1543\n",
      "scraping bill # 1544\n",
      "scraping bill # 1545\n",
      "scraping bill # 1546\n",
      "scraping bill # 1547\n",
      "scraping bill # 1548\n",
      "scraping bill # 1549\n",
      "scraping bill # 1550\n",
      "scraping bill # 1551\n",
      "scraping bill # 1552\n",
      "scraping bill # 1553\n",
      "scraping bill # 1554\n",
      "scraping bill # 1555\n",
      "scraping bill # 1556\n",
      "scraping bill # 1557\n",
      "scraping bill # 1558\n",
      "scraping bill # 1559\n",
      "scraping bill # 1560\n",
      "scraping bill # 1561\n",
      "scraping bill # 1562\n",
      "scraping bill # 1563\n",
      "scraping bill # 1564\n",
      "scraping bill # 1565\n",
      "scraping bill # 1566\n",
      "scraping bill # 1567\n",
      "scraping bill # 1568\n",
      "scraping bill # 1569\n",
      "scraping bill # 1570\n",
      "scraping bill # 1571\n",
      "scraping bill # 1572\n",
      "scraping bill # 1573\n",
      "scraping bill # 1574\n",
      "scraping bill # 1575\n",
      "scraping bill # 1576\n",
      "scraping bill # 1577\n",
      "scraping bill # 1578\n",
      "scraping bill # 1579\n",
      "scraping bill # 1580\n",
      "scraping bill # 1581\n",
      "scraping bill # 1582\n",
      "scraping bill # 1583\n",
      "scraping bill # 1584\n",
      "scraping bill # 1585\n",
      "scraping bill # 1586\n",
      "scraping bill # 1587\n",
      "scraping bill # 1588\n",
      "scraping bill # 1589\n",
      "scraping bill # 1590\n",
      "scraping bill # 1591\n",
      "scraping bill # 1592\n",
      "scraping bill # 1593\n",
      "scraping bill # 1594\n",
      "scraping bill # 1595\n",
      "scraping bill # 1596\n",
      "scraping bill # 1597\n",
      "scraping bill # 1598\n",
      "scraping bill # 1599\n",
      "scraping bill # 1600\n",
      "scraping bill # 1601\n",
      "scraping bill # 1602\n",
      "scraping bill # 1603\n",
      "scraping bill # 1604\n",
      "scraping bill # 1605\n",
      "scraping bill # 1606\n",
      "scraping bill # 1607\n",
      "scraping bill # 1608\n",
      "scraping bill # 1609\n",
      "scraping bill # 1610\n",
      "scraping bill # 1611\n",
      "scraping bill # 1612\n",
      "scraping bill # 1613\n",
      "scraping bill # 1614\n",
      "scraping bill # 1615\n",
      "scraping bill # 1616\n",
      "scraping bill # 1617\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scraping bill # 1618\n",
      "scraping bill # 1619\n",
      "scraping bill # 1620\n",
      "scraping bill # 1621\n",
      "scraping bill # 1622\n",
      "scraping bill # 1623\n",
      "scraping bill # 1624\n",
      "scraping bill # 1625\n",
      "scraping bill # 1626\n",
      "scraping bill # 1627\n",
      "scraping bill # 1628\n",
      "scraping bill # 1629\n",
      "scraping bill # 1630\n",
      "scraping bill # 1631\n",
      "scraping bill # 1632\n",
      "scraping bill # 1633\n",
      "scraping bill # 1634\n",
      "scraping bill # 1635\n",
      "scraping bill # 1636\n",
      "scraping bill # 1637\n",
      "scraping bill # 1638\n",
      "scraping bill # 1639\n",
      "scraping bill # 1640\n",
      "scraping bill # 1641\n",
      "scraping bill # 1642\n",
      "scraping bill # 1643\n",
      "scraping bill # 1644\n",
      "scraping bill # 1645\n",
      "scraping bill # 1646\n",
      "scraping bill # 1647\n",
      "scraping bill # 1648\n",
      "scraping bill # 1649\n",
      "scraping bill # 1650\n",
      "scraping bill # 1651\n",
      "scraping bill # 1652\n",
      "scraping bill # 1653\n",
      "scraping bill # 1654\n",
      "scraping bill # 1655\n",
      "scraping bill # 1656\n",
      "scraping bill # 1657\n",
      "scraping bill # 1658\n",
      "scraping bill # 1659\n",
      "scraping bill # 1660\n",
      "scraping bill # 1661\n",
      "scraping bill # 1662\n",
      "scraping bill # 1663\n",
      "scraping bill # 1664\n",
      "scraping bill # 1665\n",
      "scraping bill # 1666\n",
      "scraping bill # 1667\n",
      "scraping bill # 1668\n",
      "scraping bill # 1669\n",
      "scraping bill # 1670\n",
      "scraping bill # 1671\n",
      "scraping bill # 1672\n",
      "scraping bill # 1673\n",
      "scraping bill # 1674\n",
      "scraping bill # 1675\n",
      "scraping bill # 1676\n",
      "scraping bill # 1677\n",
      "scraping bill # 1678\n",
      "scraping bill # 1679\n",
      "scraping bill # 1680\n",
      "scraping bill # 1681\n",
      "scraping bill # 1682\n",
      "scraping bill # 1683\n",
      "scraping bill # 1684\n",
      "scraping bill # 1685\n",
      "scraping bill # 1686\n",
      "scraping bill # 1687\n",
      "scraping bill # 1688\n",
      "scraping bill # 1689\n",
      "scraping bill # 1690\n",
      "scraping bill # 1691\n",
      "scraping bill # 1692\n",
      "scraping bill # 1693\n",
      "scraping bill # 1694\n",
      "scraping bill # 1695\n",
      "scraping bill # 1696\n",
      "scraping bill # 1697\n",
      "scraping bill # 1698\n",
      "scraping bill # 1699\n",
      "scraping bill # 1700\n",
      "scraping bill # 1701\n",
      "scraping bill # 1702\n",
      "scraping bill # 1703\n",
      "scraping bill # 1704\n",
      "scraping bill # 1705\n",
      "scraping bill # 1706\n",
      "scraping bill # 1707\n",
      "scraping bill # 1708\n",
      "scraping bill # 1709\n",
      "scraping bill # 1710\n",
      "scraping bill # 1711\n",
      "scraping bill # 1712\n",
      "scraping bill # 1713\n",
      "scraping bill # 1714\n",
      "scraping bill # 1715\n",
      "scraping bill # 1716\n",
      "scraping bill # 1717\n",
      "scraping bill # 1718\n",
      "scraping bill # 1719\n",
      "scraping bill # 1720\n",
      "scraping bill # 1721\n",
      "scraping bill # 1722\n",
      "scraping bill # 1723\n",
      "scraping bill # 1724\n",
      "scraping bill # 1725\n",
      "scraping bill # 1726\n",
      "scraping bill # 1727\n",
      "scraping bill # 1728\n",
      "scraping bill # 1729\n",
      "scraping bill # 1730\n",
      "scraping bill # 1731\n",
      "scraping bill # 1732\n",
      "scraping bill # 1733\n",
      "scraping bill # 1734\n",
      "scraping bill # 1735\n",
      "scraping bill # 1736\n",
      "scraping bill # 1737\n",
      "scraping bill # 1738\n",
      "scraping bill # 1739\n",
      "scraping bill # 1740\n",
      "scraping bill # 1741\n",
      "scraping bill # 1742\n",
      "scraping bill # 1743\n",
      "scraping bill # 1744\n",
      "scraping bill # 1745\n",
      "scraping bill # 1746\n",
      "scraping bill # 1747\n",
      "scraping bill # 1748\n",
      "scraping bill # 1749\n",
      "scraping bill # 1750\n",
      "scraping bill # 1751\n",
      "scraping bill # 1752\n",
      "scraping bill # 1753\n",
      "scraping bill # 1754\n",
      "scraping bill # 1755\n",
      "scraping bill # 1756\n",
      "scraping bill # 1757\n",
      "scraping bill # 1758\n",
      "scraping bill # 1759\n",
      "scraping bill # 1760\n",
      "scraping bill # 1761\n",
      "scraping bill # 1762\n",
      "scraping bill # 1763\n",
      "scraping bill # 1764\n",
      "scraping bill # 1765\n",
      "scraping bill # 1766\n",
      "scraping bill # 1767\n",
      "scraping bill # 1768\n",
      "scraping bill # 1769\n",
      "scraping bill # 1770\n",
      "scraping bill # 1771\n",
      "scraping bill # 1772\n",
      "scraping bill # 1773\n",
      "scraping bill # 1774\n",
      "scraping bill # 1775\n",
      "scraping bill # 1776\n",
      "scraping bill # 1777\n",
      "scraping bill # 1778\n",
      "scraping bill # 1779\n",
      "scraping bill # 1780\n",
      "scraping bill # 1781\n",
      "scraping bill # 1782\n",
      "scraping bill # 1783\n",
      "scraping bill # 1784\n",
      "scraping bill # 1785\n",
      "scraping bill # 1786\n",
      "scraping bill # 1787\n",
      "scraping bill # 1788\n",
      "scraping bill # 1789\n",
      "scraping bill # 1790\n",
      "scraping bill # 1791\n",
      "scraping bill # 1792\n",
      "scraping bill # 1793\n",
      "scraping bill # 1794\n",
      "scraping bill # 1795\n",
      "scraping bill # 1796\n",
      "scraping bill # 1797\n",
      "scraping bill # 1798\n",
      "scraping bill # 1799\n",
      "scraping bill # 1800\n",
      "scraping bill # 1801\n",
      "scraping bill # 1802\n",
      "scraping bill # 1803\n",
      "scraping bill # 1804\n",
      "scraping bill # 1805\n",
      "scraping bill # 1806\n",
      "scraping bill # 1807\n",
      "scraping bill # 1808\n",
      "scraping bill # 1809\n",
      "scraping bill # 1810\n",
      "scraping bill # 1811\n",
      "scraping bill # 1812\n",
      "scraping bill # 1813\n",
      "scraping bill # 1814\n",
      "scraping bill # 1815\n",
      "scraping bill # 1816\n",
      "scraping bill # 1817\n",
      "scraping bill # 1818\n",
      "scraping bill # 1819\n",
      "scraping bill # 1820\n",
      "scraping bill # 1821\n",
      "scraping bill # 1822\n",
      "scraping bill # 1823\n",
      "scraping bill # 1824\n",
      "scraping bill # 1825\n",
      "scraping bill # 1826\n",
      "scraping bill # 1827\n",
      "scraping bill # 1828\n",
      "scraping bill # 1829\n",
      "scraping bill # 1830\n",
      "scraping bill # 1831\n",
      "scraping bill # 1832\n",
      "scraping bill # 1833\n",
      "scraping bill # 1834\n",
      "scraping bill # 1835\n",
      "scraping bill # 1836\n",
      "scraping bill # 1837\n",
      "scraping bill # 1838\n",
      "scraping bill # 1839\n",
      "scraping bill # 1840\n",
      "scraping bill # 1841\n",
      "scraping bill # 1842\n",
      "scraping bill # 1843\n",
      "scraping bill # 1844\n",
      "scraping bill # 1845\n",
      "scraping bill # 1846\n",
      "scraping bill # 1847\n",
      "scraping bill # 1848\n",
      "scraping bill # 1849\n",
      "scraping bill # 1850\n",
      "scraping bill # 1851\n",
      "scraping bill # 1852\n",
      "scraping bill # 1853\n",
      "scraping bill # 1854\n",
      "scraping bill # 1855\n",
      "scraping bill # 1856\n",
      "scraping bill # 1857\n",
      "scraping bill # 1858\n",
      "scraping bill # 1859\n",
      "scraping bill # 1860\n",
      "scraping bill # 1861\n",
      "scraping bill # 1862\n",
      "scraping bill # 1863\n",
      "scraping bill # 1864\n",
      "scraping bill # 1865\n",
      "scraping bill # 1866\n",
      "scraping bill # 1867\n",
      "scraping bill # 1868\n",
      "scraping bill # 1869\n",
      "scraping bill # 1870\n",
      "scraping bill # 1871\n",
      "scraping bill # 1872\n",
      "scraping bill # 1873\n",
      "scraping bill # 1874\n",
      "scraping bill # 1875\n",
      "scraping bill # 1876\n",
      "scraping bill # 1877\n",
      "scraping bill # 1878\n",
      "scraping bill # 1879\n",
      "scraping bill # 1880\n",
      "scraping bill # 1881\n",
      "scraping bill # 1882\n",
      "scraping bill # 1883\n",
      "scraping bill # 1884\n",
      "scraping bill # 1885\n",
      "scraping bill # 1886\n",
      "scraping bill # 1887\n",
      "scraping bill # 1888\n",
      "scraping bill # 1889\n",
      "scraping bill # 1890\n",
      "scraping bill # 1891\n",
      "scraping bill # 1892\n",
      "scraping bill # 1893\n",
      "scraping bill # 1894\n",
      "scraping bill # 1895\n",
      "scraping bill # 1896\n",
      "scraping bill # 1897\n",
      "scraping bill # 1898\n",
      "scraping bill # 1899\n",
      "scraping bill # 1900\n",
      "scraping bill # 1901\n",
      "scraping bill # 1902\n",
      "scraping bill # 1903\n",
      "scraping bill # 1904\n",
      "scraping bill # 1905\n",
      "scraping bill # 1906\n",
      "scraping bill # 1907\n",
      "scraping bill # 1908\n",
      "scraping bill # 1909\n",
      "scraping bill # 1910\n",
      "scraping bill # 1911\n",
      "scraping bill # 1912\n",
      "scraping bill # 1913\n",
      "scraping bill # 1914\n",
      "scraping bill # 1915\n",
      "scraping bill # 1916\n",
      "scraping bill # 1917\n",
      "scraping bill # 1918\n",
      "scraping bill # 1919\n",
      "scraping bill # 1920\n",
      "scraping bill # 1921\n",
      "scraping bill # 1922\n",
      "scraping bill # 1923\n",
      "scraping bill # 1924\n",
      "scraping bill # 1925\n",
      "scraping bill # 1926\n",
      "scraping bill # 1927\n",
      "scraping bill # 1928\n",
      "scraping bill # 1929\n",
      "scraping bill # 1930\n",
      "scraping bill # 1931\n",
      "scraping bill # 1932\n",
      "scraping bill # 1933\n",
      "scraping bill # 1934\n",
      "scraping bill # 1935\n",
      "scraping bill # 1936\n",
      "scraping bill # 1937\n",
      "scraping bill # 1938\n",
      "scraping bill # 1939\n",
      "scraping bill # 1940\n",
      "scraping bill # 1941\n",
      "scraping bill # 1942\n",
      "scraping bill # 1943\n",
      "scraping bill # 1944\n",
      "scraping bill # 1945\n",
      "scraping bill # 1946\n",
      "scraping bill # 1947\n",
      "scraping bill # 1948\n",
      "scraping bill # 1949\n",
      "scraping bill # 1950\n",
      "scraping bill # 1951\n",
      "scraping bill # 1952\n",
      "scraping bill # 1953\n",
      "scraping bill # 1954\n",
      "scraping bill # 1955\n",
      "scraping bill # 1956\n",
      "scraping bill # 1957\n",
      "scraping bill # 1958\n",
      "scraping bill # 1959\n",
      "scraping bill # 1960\n",
      "scraping bill # 1961\n",
      "scraping bill # 1962\n",
      "scraping bill # 1963\n",
      "scraping bill # 1964\n",
      "scraping bill # 1965\n",
      "scraping bill # 1966\n",
      "scraping bill # 1967\n",
      "scraping bill # 1968\n",
      "scraping bill # 1969\n",
      "scraping bill # 1970\n",
      "scraping bill # 1971\n",
      "scraping bill # 1972\n",
      "scraping bill # 1973\n",
      "scraping bill # 1974\n",
      "scraping bill # 1975\n",
      "scraping bill # 1976\n",
      "scraping bill # 1977\n",
      "scraping bill # 1978\n",
      "scraping bill # 1979\n",
      "scraping bill # 1980\n",
      "scraping bill # 1981\n",
      "scraping bill # 1982\n",
      "scraping bill # 1983\n",
      "scraping bill # 1984\n",
      "scraping bill # 1985\n",
      "scraping bill # 1986\n",
      "scraping bill # 1987\n",
      "scraping bill # 1988\n",
      "scraping bill # 1989\n",
      "scraping bill # 1990\n",
      "scraping bill # 1991\n",
      "scraping bill # 1992\n",
      "scraping bill # 1993\n",
      "scraping bill # 1994\n",
      "scraping bill # 1995\n",
      "scraping bill # 1996\n",
      "scraping bill # 1997\n",
      "scraping bill # 1998\n",
      "scraping bill # 1999\n",
      "scraping bill # 2000\n",
      "scraping bill # 2001\n",
      "scraping bill # 2002\n",
      "scraping bill # 2003\n",
      "scraping bill # 2004\n",
      "scraping bill # 2005\n",
      "scraping bill # 2006\n",
      "scraping bill # 2007\n",
      "scraping bill # 2008\n",
      "scraping bill # 2009\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scraping bill # 2010\n",
      "scraping bill # 2011\n",
      "scraping bill # 2012\n",
      "scraping bill # 2013\n",
      "scraping bill # 2014\n",
      "scraping bill # 2015\n",
      "scraping bill # 2016\n",
      "scraping bill # 2017\n",
      "scraping bill # 2018\n",
      "scraping bill # 2019\n",
      "scraping bill # 2020\n",
      "scraping bill # 2021\n",
      "scraping bill # 2022\n",
      "scraping bill # 2023\n",
      "scraping bill # 2024\n",
      "scraping bill # 2025\n",
      "scraping bill # 2026\n",
      "scraping bill # 2027\n",
      "scraping bill # 2028\n",
      "scraping bill # 2029\n",
      "scraping bill # 2030\n",
      "scraping bill # 2031\n",
      "scraping bill # 2032\n",
      "scraping bill # 2033\n",
      "scraping bill # 2034\n",
      "scraping bill # 2035\n",
      "scraping bill # 2036\n",
      "scraping bill # 2037\n",
      "scraping bill # 2038\n",
      "scraping bill # 2039\n",
      "scraping bill # 2040\n",
      "scraping bill # 2041\n",
      "scraping bill # 2042\n",
      "scraping bill # 2043\n",
      "scraping bill # 2044\n",
      "scraping bill # 2045\n",
      "scraping bill # 2046\n",
      "scraping bill # 2047\n",
      "scraping bill # 2048\n",
      "scraping bill # 2049\n",
      "scraping bill # 2050\n",
      "scraping bill # 2051\n",
      "scraping bill # 2052\n",
      "scraping bill # 2053\n",
      "scraping bill # 2054\n",
      "scraping bill # 2055\n",
      "scraping bill # 2056\n",
      "scraping bill # 2057\n",
      "scraping bill # 2058\n",
      "scraping bill # 2059\n",
      "scraping bill # 2060\n",
      "scraping bill # 2061\n",
      "scraping bill # 2062\n",
      "scraping bill # 2063\n",
      "scraping bill # 2064\n",
      "scraping bill # 2065\n",
      "scraping bill # 2066\n",
      "scraping bill # 2067\n",
      "scraping bill # 2068\n",
      "scraping bill # 2069\n",
      "scraping bill # 2070\n",
      "scraping bill # 2071\n",
      "scraping bill # 2072\n",
      "scraping bill # 2073\n",
      "scraping bill # 2074\n",
      "scraping bill # 2075\n",
      "scraping bill # 2076\n",
      "scraping bill # 2077\n",
      "scraping bill # 2078\n",
      "scraping bill # 2079\n",
      "scraping bill # 2080\n",
      "scraping bill # 2081\n",
      "scraping bill # 2082\n",
      "scraping bill # 2083\n",
      "scraping bill # 2084\n",
      "scraping bill # 2085\n",
      "scraping bill # 2086\n",
      "scraping bill # 2087\n",
      "scraping bill # 2088\n",
      "scraping bill # 2089\n",
      "scraping bill # 2090\n",
      "scraping bill # 2091\n",
      "scraping bill # 2092\n",
      "scraping bill # 2093\n",
      "scraping bill # 2094\n",
      "scraping bill # 2095\n",
      "scraping bill # 2096\n",
      "scraping bill # 2097\n",
      "scraping bill # 2098\n",
      "scraping bill # 2099\n",
      "scraping bill # 2100\n",
      "scraping bill # 2101\n",
      "scraping bill # 2102\n",
      "scraping bill # 2103\n",
      "scraping bill # 2104\n",
      "scraping bill # 2105\n",
      "scraping bill # 2106\n",
      "scraping bill # 2107\n",
      "scraping bill # 2108\n",
      "scraping bill # 2109\n",
      "scraping bill # 2110\n",
      "scraping bill # 2111\n",
      "scraping bill # 2112\n",
      "scraping bill # 2113\n",
      "scraping bill # 2114\n",
      "scraping bill # 2115\n",
      "scraping bill # 2116\n",
      "scraping bill # 2117\n",
      "scraping bill # 2118\n",
      "scraping bill # 2119\n",
      "scraping bill # 2120\n",
      "scraping bill # 2121\n",
      "scraping bill # 2122\n",
      "scraping bill # 2123\n",
      "scraping bill # 2124\n",
      "scraping bill # 2125\n",
      "scraping bill # 2126\n",
      "scraping bill # 2127\n",
      "scraping bill # 2128\n",
      "scraping bill # 2129\n",
      "scraping bill # 2130\n",
      "scraping bill # 2131\n",
      "scraping bill # 2132\n",
      "scraping bill # 2133\n",
      "scraping bill # 2134\n",
      "scraping bill # 2135\n",
      "scraping bill # 2136\n",
      "scraping bill # 2137\n",
      "scraping bill # 2138\n",
      "scraping bill # 2139\n",
      "scraping bill # 2140\n",
      "scraping bill # 2141\n",
      "scraping bill # 2142\n",
      "scraping bill # 2143\n",
      "scraping bill # 2144\n",
      "scraping bill # 2145\n",
      "scraping bill # 2146\n",
      "scraping bill # 2147\n",
      "scraping bill # 2148\n",
      "scraping bill # 2149\n",
      "scraping bill # 2150\n",
      "scraping bill # 2151\n",
      "scraping bill # 2152\n",
      "scraping bill # 2153\n",
      "scraping bill # 2154\n",
      "scraping bill # 2155\n",
      "scraping bill # 2156\n",
      "scraping bill # 2157\n",
      "scraping bill # 2158\n",
      "scraping bill # 2159\n",
      "scraping bill # 2160\n",
      "scraping bill # 2161\n",
      "scraping bill # 2162\n",
      "scraping bill # 2163\n",
      "scraping bill # 2164\n",
      "scraping bill # 2165\n",
      "scraping bill # 2166\n",
      "scraping bill # 2167\n",
      "scraping bill # 2168\n",
      "scraping bill # 2169\n",
      "scraping bill # 2170\n",
      "scraping bill # 2171\n",
      "scraping bill # 2172\n",
      "scraping bill # 2173\n",
      "scraping bill # 2174\n",
      "scraping bill # 2175\n",
      "scraping bill # 2176\n",
      "scraping bill # 2177\n",
      "scraping bill # 2178\n",
      "scraping bill # 2179\n",
      "scraping bill # 2180\n",
      "scraping bill # 2181\n",
      "scraping bill # 2182\n",
      "scraping bill # 2183\n",
      "scraping bill # 2184\n",
      "scraping bill # 2185\n",
      "scraping bill # 2186\n",
      "scraping bill # 2187\n",
      "scraping bill # 2188\n",
      "scraping bill # 2189\n",
      "scraping bill # 2190\n",
      "scraping bill # 2191\n",
      "scraping bill # 2192\n",
      "scraping bill # 2193\n",
      "scraping bill # 2194\n",
      "scraping bill # 2195\n",
      "scraping bill # 2196\n",
      "scraping bill # 2197\n",
      "scraping bill # 2198\n",
      "scraping bill # 2199\n",
      "scraping bill # 2200\n",
      "scraping bill # 2201\n",
      "scraping bill # 2202\n",
      "scraping bill # 2203\n",
      "scraping bill # 2204\n",
      "scraping bill # 2205\n",
      "scraping bill # 2206\n",
      "scraping bill # 2207\n",
      "scraping bill # 2208\n",
      "scraping bill # 2209\n",
      "scraping bill # 2210\n",
      "scraping bill # 2211\n",
      "scraping bill # 2212\n",
      "scraping bill # 2213\n",
      "scraping bill # 2214\n",
      "scraping bill # 2215\n",
      "scraping bill # 2216\n",
      "scraping bill # 2217\n",
      "scraping bill # 2218\n",
      "scraping bill # 2219\n",
      "scraping bill # 2220\n",
      "scraping bill # 2221\n",
      "scraping bill # 2222\n",
      "scraping bill # 2223\n",
      "scraping bill # 2224\n",
      "scraping bill # 2225\n",
      "scraping bill # 2226\n",
      "scraping bill # 2227\n",
      "scraping bill # 2228\n",
      "scraping bill # 2229\n",
      "scraping bill # 2230\n",
      "scraping bill # 2231\n",
      "scraping bill # 2232\n",
      "scraping bill # 2233\n",
      "scraping bill # 2234\n",
      "scraping bill # 2235\n",
      "scraping bill # 2236\n",
      "scraping bill # 2237\n",
      "scraping bill # 2238\n",
      "scraping bill # 2239\n",
      "scraping bill # 2240\n",
      "scraping bill # 2241\n",
      "scraping bill # 2242\n",
      "scraping bill # 2243\n",
      "scraping bill # 2244\n",
      "scraping bill # 2245\n",
      "scraping bill # 2246\n",
      "scraping bill # 2247\n",
      "scraping bill # 2248\n",
      "scraping bill # 2249\n",
      "scraping bill # 2250\n",
      "scraping bill # 2251\n",
      "scraping bill # 2252\n",
      "scraping bill # 2253\n",
      "scraping bill # 2254\n",
      "scraping bill # 2255\n",
      "scraping bill # 2256\n",
      "scraping bill # 2257\n",
      "scraping bill # 2258\n",
      "scraping bill # 2259\n",
      "scraping bill # 2260\n",
      "scraping bill # 2261\n",
      "scraping bill # 2262\n",
      "scraping bill # 2263\n",
      "scraping bill # 2264\n",
      "scraping bill # 2265\n",
      "scraping bill # 2266\n",
      "scraping bill # 2267\n",
      "scraping bill # 2268\n",
      "scraping bill # 2269\n",
      "scraping bill # 2270\n",
      "scraping bill # 2271\n",
      "scraping bill # 2272\n",
      "scraping bill # 2273\n",
      "scraping bill # 2274\n",
      "scraping bill # 2275\n",
      "scraping bill # 2276\n",
      "scraping bill # 2277\n",
      "scraping bill # 2278\n",
      "scraping bill # 2279\n",
      "scraping bill # 2280\n",
      "scraping bill # 2281\n",
      "scraping bill # 2282\n",
      "scraping bill # 2283\n",
      "scraping bill # 2284\n",
      "scraping bill # 2285\n",
      "scraping bill # 2286\n",
      "scraping bill # 2287\n",
      "scraping bill # 2288\n",
      "scraping bill # 2289\n",
      "scraping bill # 2290\n",
      "scraping bill # 2291\n",
      "scraping bill # 2292\n",
      "scraping bill # 2293\n",
      "scraping bill # 2294\n",
      "scraping bill # 2295\n",
      "scraping bill # 2296\n",
      "scraping bill # 2297\n",
      "scraping bill # 2298\n",
      "scraping bill # 2299\n",
      "scraping bill # 2300\n",
      "scraping bill # 2301\n",
      "scraping bill # 2302\n",
      "scraping bill # 2303\n",
      "scraping bill # 2304\n",
      "scraping bill # 2305\n",
      "scraping bill # 2306\n",
      "scraping bill # 2307\n",
      "scraping bill # 2308\n",
      "scraping bill # 2309\n",
      "scraping bill # 2310\n",
      "scraping bill # 2311\n",
      "scraping bill # 2312\n",
      "scraping bill # 2313\n",
      "scraping bill # 2314\n",
      "scraping bill # 2315\n",
      "scraping bill # 2316\n",
      "scraping bill # 2317\n",
      "scraping bill # 2318\n",
      "scraping bill # 2319\n",
      "scraping bill # 2320\n",
      "scraping bill # 2321\n",
      "scraping bill # 2322\n",
      "scraping bill # 2323\n",
      "scraping bill # 2324\n",
      "scraping bill # 2325\n",
      "scraping bill # 2326\n",
      "scraping bill # 2327\n",
      "scraping bill # 2328\n",
      "scraping bill # 2329\n",
      "scraping bill # 2330\n",
      "scraping bill # 2331\n",
      "scraping bill # 2332\n",
      "scraping bill # 2333\n",
      "scraping bill # 2334\n",
      "scraping bill # 2335\n",
      "scraping bill # 2336\n",
      "scraping bill # 2337\n",
      "scraping bill # 2338\n",
      "scraping bill # 2339\n",
      "scraping bill # 2340\n",
      "scraping bill # 2341\n",
      "scraping bill # 2342\n",
      "scraping bill # 2343\n",
      "scraping bill # 2344\n",
      "scraping bill # 2345\n",
      "scraping bill # 2346\n",
      "scraping bill # 2347\n",
      "scraping bill # 2348\n",
      "scraping bill # 2349\n",
      "scraping bill # 2350\n",
      "scraping bill # 2351\n",
      "scraping bill # 2352\n",
      "scraping bill # 2353\n",
      "scraping bill # 2354\n",
      "scraping bill # 2355\n",
      "scraping bill # 2356\n",
      "scraping bill # 2357\n",
      "scraping bill # 2358\n",
      "scraping bill # 2359\n",
      "scraping bill # 2360\n",
      "scraping bill # 2361\n",
      "scraping bill # 2362\n",
      "scraping bill # 2363\n",
      "scraping bill # 2364\n",
      "scraping bill # 2365\n",
      "scraping bill # 2366\n",
      "scraping bill # 2367\n",
      "scraping bill # 2368\n",
      "scraping bill # 2369\n",
      "scraping bill # 2370\n",
      "scraping bill # 2371\n",
      "scraping bill # 2372\n",
      "scraping bill # 2373\n",
      "scraping bill # 2374\n",
      "scraping bill # 2375\n",
      "scraping bill # 2376\n",
      "scraping bill # 2377\n",
      "scraping bill # 2378\n",
      "scraping bill # 2379\n",
      "scraping bill # 2380\n",
      "scraping bill # 2381\n",
      "scraping bill # 2382\n",
      "scraping bill # 2383\n",
      "scraping bill # 2384\n",
      "scraping bill # 2385\n",
      "scraping bill # 2386\n",
      "scraping bill # 2387\n",
      "scraping bill # 2388\n",
      "scraping bill # 2389\n",
      "scraping bill # 2390\n",
      "scraping bill # 2391\n",
      "scraping bill # 2392\n",
      "scraping bill # 2393\n",
      "scraping bill # 2394\n",
      "scraping bill # 2395\n",
      "scraping bill # 2396\n",
      "scraping bill # 2397\n",
      "scraping bill # 2398\n",
      "scraping bill # 2399\n",
      "scraping bill # 2400\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "scraping bill # 2401\n",
      "scraping bill # 2402\n",
      "scraping bill # 2403\n",
      "scraping bill # 2404\n",
      "scraping bill # 2405\n",
      "scraping bill # 2406\n",
      "scraping bill # 2407\n",
      "scraping bill # 2408\n",
      "scraping bill # 2409\n",
      "scraping bill # 2410\n",
      "scraping bill # 2411\n",
      "scraping bill # 2412\n",
      "scraping bill # 2413\n",
      "scraping bill # 2414\n",
      "scraping bill # 2415\n",
      "scraping bill # 2416\n",
      "scraping bill # 2417\n",
      "scraping bill # 2418\n",
      "scraping bill # 2419\n",
      "scraping bill # 2420\n",
      "scraping bill # 2421\n",
      "scraping bill # 2422\n",
      "scraping bill # 2423\n",
      "scraping bill # 2424\n",
      "scraping bill # 2425\n",
      "scraping bill # 2426\n",
      "scraping bill # 2427\n",
      "scraping bill # 2428\n",
      "scraping bill # 2429\n",
      "scraping bill # 2430\n",
      "scraping bill # 2431\n",
      "scraping bill # 2432\n",
      "scraping bill # 2433\n",
      "scraping bill # 2434\n",
      "scraping bill # 2435\n",
      "scraping bill # 2436\n",
      "scraping bill # 2437\n",
      "scraping bill # 2438\n",
      "scraping bill # 2439\n",
      "scraping bill # 2440\n",
      "scraping bill # 2441\n",
      "scraping bill # 2442\n",
      "scraping bill # 2443\n",
      "scraping bill # 2444\n",
      "scraping bill # 2445\n",
      "scraping bill # 2446\n",
      "scraping bill # 2447\n",
      "scraping bill # 2448\n",
      "scraping bill # 2449\n",
      "scraping bill # 2450\n",
      "scraping bill # 2451\n",
      "scraping bill # 2452\n",
      "scraping bill # 2453\n",
      "scraping bill # 2454\n",
      "scraping bill # 2455\n",
      "scraping bill # 2456\n",
      "scraping bill # 2457\n",
      "scraping bill # 2458\n",
      "scraping bill # 2459\n",
      "scraping bill # 2460\n",
      "scraping bill # 2461\n",
      "scraping bill # 2462\n",
      "scraping bill # 2463\n",
      "scraping bill # 2464\n",
      "scraping bill # 2465\n",
      "scraping bill # 2466\n",
      "scraping bill # 2467\n",
      "scraping bill # 2468\n",
      "scraping bill # 2469\n",
      "scraping bill # 2470\n",
      "scraping bill # 2471\n",
      "scraping bill # 2472\n",
      "scraping bill # 2473\n",
      "scraping bill # 2474\n",
      "scraping bill # 2475\n",
      "scraping bill # 2476\n",
      "scraping bill # 2477\n",
      "scraping bill # 2478\n",
      "scraping bill # 2479\n",
      "scraping bill # 2480\n",
      "scraping bill # 2481\n",
      "scraping bill # 2482\n",
      "scraping bill # 2483\n",
      "scraping bill # 2484\n",
      "scraping bill # 2485\n",
      "scraping bill # 2486\n",
      "scraping bill # 2487\n",
      "scraping bill # 2488\n",
      "scraping bill # 2489\n",
      "scraping bill # 2490\n",
      "scraping bill # 2491\n",
      "scraping bill # 2492\n",
      "scraping bill # 2493\n",
      "scraping bill # 2494\n",
      "scraping bill # 2495\n",
      "scraping bill # 2496\n"
     ]
    }
   ],
   "source": [
    "#get all bills from session\n",
    "def pullAllBills(session_id, state):\n",
    "\n",
    "    params = {\n",
    "        'key': legiscan_key,\n",
    "        'op' : \"getMasterList\",\n",
    "        \"id\" : session_id,\n",
    "        'state' : state\n",
    "    }\n",
    "\n",
    "    url = 'https://api.legiscan.com/'\n",
    "    r = requests.get(url, params=params)\n",
    "    return r.json()\n",
    "\n",
    "#pull the bills individual information\n",
    "def getBill(bill_id):\n",
    "\n",
    "    params = {\n",
    "        'key': legiscan_key,\n",
    "        'op' : \"getBill\",\n",
    "        'id' : bill_id\n",
    "    }\n",
    "\n",
    "    url = 'https://api.legiscan.com/'\n",
    "    \n",
    "    found = False\n",
    "    \n",
    "    while(found == False):\n",
    "        try:\n",
    "            r = requests.get(url, params=params)\n",
    "            found = True\n",
    "        except requests.exceptions.RequestException as e:  # This is the correct syntax\n",
    "            time.sleep(2)\n",
    "      \n",
    "    return r.json()\n",
    "\n",
    "data = pullAllBills(\"1636\", \"md\")\n",
    "masterlist = data[\"masterlist\"]\n",
    "\n",
    "ids = []\n",
    "numbers = []\n",
    "hashes = []\n",
    "urls = []\n",
    "status_dates = []\n",
    "statuses = []\n",
    "last_action_dates = []\n",
    "last_actions = []\n",
    "titles = []\n",
    "descriptions = []\n",
    "\n",
    "session_ids = []\n",
    "session_names = []\n",
    "state_links = []\n",
    "completeds = []\n",
    "states = []\n",
    "state_ids = []\n",
    "bill_types = []\n",
    "bill_type_ids = []\n",
    "bodies = []\n",
    "body_ids = []\n",
    "current_bodies = []\n",
    "current_body_ids = []\n",
    "pending_committee_ids = []\n",
    "  \n",
    "progress_events = []\n",
    "progress_dates = []\n",
    "\n",
    "history_dates = []\n",
    "history_actions = []\n",
    "history_chambers = []\n",
    "history_chamber_ids = []\n",
    "history_importances = []\n",
    "\n",
    "sponsor_people_ids = []\n",
    "sponsor_party_ids = []\n",
    "sponsor_parties = []\n",
    "sponsor_role_ids = []\n",
    "sponsor_roles = []\n",
    "sponsor_names = []\n",
    "sponsor_districts = []\n",
    "sponsor_type_ids = []\n",
    "sponsor_orders = []\n",
    "sponsor_committee_sponsors = []\n",
    "\n",
    "votes_roll_call_ids = []\n",
    "votes_dates = []\n",
    "votes_descs = []\n",
    "votes_yeas = []\n",
    "votes_nays = []\n",
    "votes_nvs = []\n",
    "votes_absents = []\n",
    "votes_totals = []\n",
    "votes_passeds = []\n",
    "votes_chambers = []\n",
    "votes_chamber_ids = []\n",
    "votes_urls = []\n",
    "votes_state_links = []\n",
    "\n",
    "bill_num = 0\n",
    "\n",
    "bill_track = []\n",
    "while str(bill_num) in masterlist:\n",
    "# while bill_num < 50:\n",
    "    print(\"scraping bill # \" + str(bill_num))\n",
    "    bill_id = masterlist[str(bill_num)][\"bill_id\"]\n",
    "    if (bill_id in bill_track):\n",
    "        print(\"**********\")\n",
    "        print(bill_id)\n",
    "        print(\"**********\")\n",
    "    bill_track.append(bill_id)\n",
    "    bill_track.append(bill_id)\n",
    "    ids.append(bill_id) \n",
    "    numbers.append(masterlist[str(bill_num)][\"number\"]) \n",
    "    hashes.append(masterlist[str(bill_num)][\"change_hash\"]) \n",
    "    urls.append(masterlist[str(bill_num)][\"url\"]) \n",
    "    s_date = datetime.datetime.strptime(masterlist[str(bill_num)][\"status_date\"], '%Y-%m-%d').date()\n",
    "    status_dates.append(s_date) \n",
    "    statuses.append(masterlist[str(bill_num)][\"status\"]) \n",
    "    l_date = datetime.datetime.strptime(masterlist[str(bill_num)][\"last_action_date\"], '%Y-%m-%d').date()\n",
    "    last_action_dates.append(l_date) \n",
    "    last_actions.append(masterlist[str(bill_num)][\"last_action\"]) \n",
    "    titles.append(masterlist[str(bill_num)][\"title\"]) \n",
    "    descriptions.append(masterlist[str(bill_num)][\"description\"]) \n",
    "    bill_num = bill_num + 1\n",
    "    \n",
    "    data = getBill(bill_id)\n",
    "    bill_data = data[\"bill\"]\n",
    "      \n",
    "    session_ids.append(bill_data[\"session_id\"])\n",
    "    session_names.append(bill_data[\"session\"][\"session_name\"])\n",
    "    state_links.append(bill_data[\"state_link\"])\n",
    "    completeds.append(bill_data[\"completed\"])\n",
    "    states.append(bill_data[\"state\"])\n",
    "    state_ids.append(bill_data[\"state_id\"])\n",
    "    bill_types.append(bill_data[\"bill_type\"])\n",
    "    bill_type_ids.append(bill_data[\"bill_type_id\"])\n",
    "    bodies.append(bill_data[\"body\"])\n",
    "    body_ids.append(bill_data[\"body_id\"])\n",
    "    current_bodies.append(bill_data[\"current_body\"])\n",
    "    current_body_ids.append(bill_data[\"current_body_id\"])\n",
    "    pending_committee_ids.append(bill_data[\"pending_committee_id\"])\n",
    "     \n",
    "    # gather progress information\n",
    "    progress = bill_data[\"progress\"] \n",
    "    p_dates = []\n",
    "    p_events = []                 \n",
    "    for p in progress:\n",
    "        p_dates.append(p[\"date\"])\n",
    "        p_events.append(p[\"event\"]) \n",
    "    progress_events.append(p_events)\n",
    "    progress_dates.append(p_dates)   \n",
    "                      \n",
    "            \n",
    "    # gather history information                              \n",
    "    history = bill_data[\"history\"]     \n",
    "    h_dates = []\n",
    "    h_actions = []\n",
    "    h_chambers = []\n",
    "    h_chamber_ids = []\n",
    "    h_importances = []\n",
    "    for h in history:\n",
    "        h_dates.append(h[\"date\"])\n",
    "        h_actions.append(h[\"action\"])\n",
    "        h_chambers.append(h[\"chamber\"])\n",
    "        h_chamber_ids.append(h[\"chamber_id\"])\n",
    "        h_importances.append(h[\"importance\"])\n",
    "    history_dates.append(h_dates)\n",
    "    history_actions.append(h_actions)\n",
    "    history_chambers.append(h_chambers)\n",
    "    history_chamber_ids.append(h_chamber_ids)\n",
    "    history_importances.append(h_importances)\n",
    "                           \n",
    "    # gather sponsor information                              \n",
    "    sponsors = bill_data[\"sponsors\"]  \n",
    "    s_people_ids = []\n",
    "    s_party_ids = []\n",
    "    s_parties = []\n",
    "    s_role_ids = []\n",
    "    s_roles = []\n",
    "    s_names = []\n",
    "    s_districts = []\n",
    "    s_type_ids = []\n",
    "    s_order = []\n",
    "    s_committee_sponsors = []\n",
    "    for s in sponsors:\n",
    "\n",
    "        if (s[\"people_id\"] == 15477):\n",
    "            \n",
    "            s_people_ids.append(4569)\n",
    "            s_party_ids.append(1)\n",
    "            s_parties.append('D')\n",
    "            s_role_ids.append(s[\"role_id\"])\n",
    "            s_roles.append(s[\"role\"])\n",
    "            s_names.append(\"Michael Busch\")\n",
    "            s_districts.append(\"HD-030A\")\n",
    "            s_type_ids.append(s[\"sponsor_type_id\"])\n",
    "            s_order.append(s[\"sponsor_order\"])\n",
    "            s_committee_sponsors.append(0)\n",
    "        else:    \n",
    "            s_people_ids.append(s[\"people_id\"])\n",
    "            s_party_ids.append(s[\"party_id\"])\n",
    "            s_parties.append(s[\"party\"])\n",
    "            s_role_ids.append(s[\"role_id\"])\n",
    "            s_roles.append(s[\"role\"])\n",
    "            s_names.append(s[\"name\"])\n",
    "            s_districts.append(s[\"district\"])\n",
    "            s_type_ids.append(s[\"sponsor_type_id\"])\n",
    "            s_order.append(s[\"sponsor_order\"])\n",
    "            s_committee_sponsors.append(s[\"committee_sponsor\"])\n",
    "            \n",
    "    sponsor_people_ids.append(s_people_ids)\n",
    "    sponsor_party_ids.append(s_party_ids)\n",
    "    sponsor_parties.append(s_parties)\n",
    "    sponsor_role_ids.append(s_role_ids)\n",
    "    sponsor_roles.append(s_roles)\n",
    "    sponsor_names.append(s_names)\n",
    "    sponsor_districts.append(s_districts)\n",
    "    sponsor_type_ids.append(s_type_ids)\n",
    "    sponsor_orders.append(s_order)\n",
    "    sponsor_committee_sponsors.append(s_committee_sponsors)\n",
    "                           \n",
    "    # gather vote information                              \n",
    "    votes = bill_data[\"votes\"]  \n",
    "    v_roll_call_ids = []\n",
    "    v_dates = []\n",
    "    v_descs = []\n",
    "    v_yeas = []\n",
    "    v_nays = []\n",
    "    v_nvs = []\n",
    "    v_absents = []\n",
    "    v_totals = []\n",
    "    v_passeds = []\n",
    "    v_chambers = []\n",
    "    v_chamber_ids = []\n",
    "    v_urls = []\n",
    "    v_state_links = []\n",
    "    for v in votes:\n",
    "        v_roll_call_ids.append(v[\"roll_call_id\"])\n",
    "        v_dates.append(v[\"date\"])\n",
    "        v_descs.append(v[\"desc\"])\n",
    "        v_yeas.append(v[\"yea\"])\n",
    "        v_nays.append(v[\"nay\"])\n",
    "        v_nvs.append(v[\"nv\"])\n",
    "        v_absents.append(v[\"absent\"])\n",
    "        v_totals.append(v[\"total\"])\n",
    "        v_passeds.append(v[\"passed\"])\n",
    "        v_chambers.append(v[\"chamber\"])\n",
    "        v_chamber_ids.append(v[\"chamber_id\"])\n",
    "        v_urls.append(v[\"url\"])\n",
    "        v_state_links.append(v[\"state_link\"])\n",
    "    votes_roll_call_ids.append(v_roll_call_ids)\n",
    "    votes_dates.append(v_dates)\n",
    "    votes_descs.append(v_descs)\n",
    "    votes_yeas.append(v_yeas)\n",
    "    votes_nays.append(v_nays )\n",
    "    votes_nvs.append(v_nvs)\n",
    "    votes_absents.append(v_absents)\n",
    "    votes_totals.append(v_totals)\n",
    "    votes_passeds.append(v_passeds)\n",
    "    votes_chambers.append(v_chambers)\n",
    "    votes_chamber_ids.append(v_chamber_ids)\n",
    "    votes_urls.append(v_urls)\n",
    "    votes_state_links.append(v_state_links)\n",
    "                           \n",
    "#   texts = bill_data[\"texts \"]                         \n",
    "#     amendments = bill_data[\"amendments\"]\n",
    "#     supplements = bill_data[\" supplements\"]\n",
    "#     calendar = bill_data[\"calendar\"]               \n",
    "#     committee = bill_data[\"committee\"]      \n",
    "\n",
    "\n",
    "    \n",
    "                                             \n",
    "bills = pd.DataFrame({\n",
    "    \"bill_id\": ids,\n",
    "    \"bill_number\": numbers,\n",
    "    \"change_hash\": hashes,     \n",
    "    \"url\": urls,\n",
    "    \"status_date\" : status_dates,\n",
    "    \"status\" : statuses,\n",
    "    \"last_action_date\" : last_action_dates,\n",
    "    \"last_action\" : last_actions,\n",
    "    \"title\" : titles,\n",
    "    \"description\" : descriptions,\n",
    "    \"session_id\" : session_ids,\n",
    "    \"session_name\" : session_names,\n",
    "    \"state_link\" : state_links,\n",
    "    \"completed\" : completeds,\n",
    "    \"state\" : states,\n",
    "    \"state_id\" : state_ids,\n",
    "    \"bill_type\" : bill_types,\n",
    "    \"bill_type_id\" : bill_type_ids,\n",
    "    \"bodie\" : bodies,\n",
    "    \"body_id\" : body_ids,\n",
    "    \"current_body\" : current_bodies,\n",
    "    \"current_body_id\" : current_body_ids,\n",
    "    \"pending_committee_id\" : pending_committee_ids,\n",
    "    \"progress_event\" : progress_events,\n",
    "    \"progress_date\" : progress_dates,\n",
    "    \"history_date\" : history_dates,\n",
    "    \"history_action\" : history_actions,\n",
    "    \"history_chamber\" : history_chambers,\n",
    "    \"history_chamber_id\" : history_chamber_ids,\n",
    "    \"history_importance\" : history_importances,\n",
    "    \"sponsor_people_id\" : sponsor_people_ids,\n",
    "    \"sponsor_party_id\" : sponsor_party_ids,\n",
    "    \"sponsor_party\" : sponsor_parties,\n",
    "    \"sponsor_role_id\" : sponsor_role_ids,\n",
    "    \"sponsor_role\" : sponsor_roles,\n",
    "    \"sponsor_name\" : sponsor_names,\n",
    "    \"sponsor_district\" : sponsor_districts,\n",
    "    \"sponsor_type_id\" : sponsor_type_ids,\n",
    "    \"sponsor_order\" : sponsor_orders,\n",
    "    \"committee_sponsor\" : sponsor_committee_sponsors,\n",
    "    \"votes_roll_call_id\" : votes_roll_call_ids,\n",
    "    \"votes_date\" : votes_dates,\n",
    "    \"votes_desc\" : votes_descs,\n",
    "    \"votes_yea\" : votes_yeas,\n",
    "    \"votes_nay\" : votes_nays,\n",
    "    \"votes_nv\" : votes_nvs,\n",
    "    \"votes_absent\" : votes_absents,\n",
    "    \"votes_total\" : votes_totals,\n",
    "    \"votes_passed\" : votes_passeds,\n",
    "    \"votes_chamber\" : votes_chambers,\n",
    "    \"votes_chamber_id\" : votes_chamber_ids,\n",
    "    \"votes_url\" : votes_urls,\n",
    "    \"votes_state_link\" : votes_state_links\n",
    "})\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'people_id': 4569,\n",
       " 'person_hash': 'r2c4aflo',\n",
       " 'party_id': 1,\n",
       " 'party': 'D',\n",
       " 'role_id': 1,\n",
       " 'role': 'Rep',\n",
       " 'name': 'Michael Busch',\n",
       " 'first_name': 'Michael',\n",
       " 'middle_name': 'E',\n",
       " 'last_name': 'Busch',\n",
       " 'suffix': '',\n",
       " 'nickname': '',\n",
       " 'district': 'HD-030A',\n",
       " 'ftm_eid': 4822536,\n",
       " 'votesmart_id': 6116,\n",
       " 'opensecrets_id': '',\n",
       " 'ballotpedia': 'Michael_Busch',\n",
       " 'sponsor_type_id': 1,\n",
       " 'sponsor_order': 1,\n",
       " 'committee_sponsor': 0,\n",
       " 'committee_id': '0'}"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "{'people_id': 4569, 'person_hash': 'r2c4aflo', 'party_id': 1, 'party': 'D', 'role_id': 1, 'role': 'Rep', 'name': 'Michael Busch', 'first_name': 'Michael', 'middle_name': 'E', 'last_name': 'Busch', 'suffix': '', 'nickname': '', 'district': 'HD-030A', 'ftm_eid': 4822536, 'votesmart_id': 6116, 'opensecrets_id': '', 'ballotpedia': 'Michael_Busch', 'sponsor_type_id': 1, 'sponsor_order': 1, 'committee_sponsor': 0, 'committee_id': '0'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[1], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2], [1], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1], [1], [1], [1], [1], [1], [1], [1], [1], [1, 2, 2], [1], [1], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2], [1], [1], [1, 2], [1, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2], [1], [1], [1], [1], [1], [1], [1], [1], [1], [1, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2], [1], [1], [1, 2, 2], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2], [1], [1], [1], [1], [1, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2], [1], [1, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2], [1, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1], [1], [1], [1], [1], [1], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2], [1], [1], [1], [1], [1], [1], [1], [1, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1], [1], [1], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2], [1, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2], [1], [1], [1, 2, 2, 2], [1], [1], [1], [1], [1], [1, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1], [1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2], [1]]\n"
     ]
    }
   ],
   "source": [
    "print(sponsor_type_ids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Output Results \n",
    "bills.to_csv(\"data/bills_2019.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2497\n"
     ]
    }
   ],
   "source": [
    "print(len(bills))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1    12\n",
      "2     2\n",
      "3     2\n",
      "Name: status, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "j_bills = bills[bills['bill_type'] == \"JR\"]\n",
    "statuses = j_bills[\"status\"]\n",
    "print(statuses.value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1    1361\n",
      "3     481\n",
      "4     383\n",
      "2     256\n",
      "Name: status, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "j_bills = bills[bills['bill_type'] == \"B\"]\n",
    "statuses = j_bills[\"status\"]\n",
    "print(statuses.value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1 Introduced\n",
    "# 2 Engrossed\n",
    "# 3 Enrolled\n",
    "# 4 Passed\n",
    "# 5 Vetoed"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}