something's off with the swagger base url... #216

jnmarcus · 2016-02-24T05:09:13Z

Scenario 1:
a) referencing: http://admin.caciviclab.org/docs/api-docs works. I get:

{
  "info": {
    "description": "",
    "license": "",
    "title": "",
    "contact": "",
    "termsOfServiceUrl": "",
    "licenseUrl": ""
  },
  "basePath": "http://admin.caciviclab.org/docs/api-docs",
  "swaggerVersion": "1.2",
  "apiVersion": "",
  "apis": [
    {
      "path": "/ballot"
    },
    {
      "path": "/candidate"
    },
    {
      "path": "/committee"
    },
    {
      "path": "/elections"
    },
    {
      "path": "/locality"
    },
    {
      "path": "/office_election"
    },
    {
      "path": "/referendum"
    }
  ]
}

b) referencing: http://admin.caciviclab.org:80 does not work. I get a Cron Status back.

Scenario 2:
a) referencing: http://admin.caciviclab.org/docs/api-docs/locality/4 I get a partial chunk of the response I got from calling just http://admin.caciviclab.org/docs/api-docs , but it has some new stuff too:

{
  "swaggerVersion": "1.2",
  "apis": [],
  "models": {},
  "basePath": "http://admin.caciviclab.org",
  "resourcePath": "/locality/4",
  "apiVersion": ""
}

b) referencing: http://admin.caciviclab.org:80/locality/4 works. I get:

{
  "name": "Alameda, County of",
  "type": "city",
  "id": 4
}

jnmarcus · 2016-02-24T05:19:37Z

the following is the Cron Status I get when calling http://admin.caciviclab.org:80, in scenario 1.b) above. (headsup: it's really long)

<a href='/docs/'>Check out the API Documentation</a>
<br/>
<a href='/admin/'>View the admin interface / database data.</a>
<br />


  <h2>Cron Status:</h2>

    <pre>
Report for module &#39;test-listing&#39;

Date:
  June 21, 2015, 11:35 p.m.

Command:
  [&#39;ls&#39;, &#39;-l&#39;, &#39;-a&#39;, &#39;/data/backend&#39;]

Return code:
  0

Stdout (if any):

total 68
drwxr-xr-x 17 backend backend 4096 Jun 21 23:35 .
drwxr-xr-x  8 root    root    4096 Jun 21 23:19 ..
drwxr-xr-x  2 backend backend 4096 Jun 21 19:23 1434914602
drwxr-xr-x  5 backend backend 4096 Jun 21 19:24 1434914643
drwxr-xr-x  2 backend backend 4096 Jun 21 19:25 1434914729
drwxr-xr-x  5 backend backend 4096 Jun 21 19:26 1434914767
drwxr-xr-x  2 backend backend 4096 Jun 21 19:26 1434914799
drwxr-xr-x  5 backend backend 4096 Jun 21 19:27 1434914821
drwxr-xr-x  5 backend backend 4096 Jun 21 19:27 1434914859
drwxr-xr-x  5 backend backend 4096 Jun 21 19:27 1434914865
drwxr-xr-x  5 backend backend 4096 Jun 21 19:29 1434914985
drwxr-xr-x  5 backend backend 4096 Jun 21 19:30 1434915008
drwxr-xr-x  5 backend backend 4096 Jun 21 20:29 1434918594
drwxr-xr-x  5 backend backend 4096 Jun 21 23:05 1434927956
drwxr-xr-x  6 backend backend 4096 Jun 21 23:09 1434928151
drwxr-xr-x  6 backend backend 4096 Jun 21 23:35 1434929715
lrwxrwxrwx  1 backend backend   24 Jun 21 23:35 current -&gt; /data/backend/1434929715
drwxrwxr-x  5 backend backend 4096 Jun 21 19:45 env


Stderr (if any):




</pre>
    <hr />

    <pre>
Report for module &#39;calaccess&#39;

Date:
  Feb. 23, 2016, 12:08 a.m.

Command:
  [&#39;python&#39;, &#39;/data/backend/current/manage.py&#39;, &#39;downloadcalaccessrawdata&#39;, &#39;--no-color&#39;, &#39;--noinput&#39;, &#39;--verbosity=3&#39;]

Return code:
  0

Stdout (if any):

�[36;1mDownloading ZIP file�[0m
�[37m Unzipping archive�[0m
�[37m Prepping unzipped data�[0m
�[36;1mCleaning data files�[0m
�[37m Cleaning CVR2_LOBBY_DISCLOSURE_CD.TSV�[0m
�[37m Cleaning REPORTS_CD.TSV�[0m
�[37m Cleaning LOBBYIST_EMPLOYER1_CD.TSV�[0m
�[37m Cleaning FILINGS_CD.TSV�[0m
�[37m Cleaning FILER_TO_FILER_TYPE_CD.TSV�[0m
�[37m Cleaning LOBBYIST_EMP_LOBBYIST1_CD.TSV�[0m
�[37m Cleaning F495P2_CD.TSV�[0m
�[37m Cleaning FILER_LINKS_CD.TSV�[0m
�[37m Cleaning CVR_F470_CD.TSV�[0m
�[37m Cleaning CVR2_CAMPAIGN_DISCLOSURE_CD.TSV�[0m
�[31m  Bad parse of line 83837 (38 headers, 39 values)�[0m
�[31m  Bad parse of line 84796 (38 headers, 39 values)�[0m
�[31m  Bad parse of line 86772 (38 headers, 39 values)�[0m
�[31m  Bad parse of line 88012 (38 headers, 39 values)�[0m
�[31m  Bad parse of line 88160 (38 headers, 39 values)�[0m
�[31m  Bad parse of line 90278 (38 headers, 39 values)�[0m
�[31m  Bad parse of line 90278 (38 headers, 39 values)�[0m
�[31m  Bad parse of line 93051 (38 headers, 39 values)�[0m
�[31m  Bad parse of line 93053 (38 headers, 39 values)�[0m
�[31m  8 errors�[0m
�[37m Cleaning F690P2_CD.TSV�[0m
�[37m Cleaning LOOKUP_CODES_CD.TSV�[0m
�[37m Cleaning FILER_TYPE_PERIODS_CD.TSV�[0m
�[37m Cleaning LEXP_CD.TSV�[0m
�[31m  Bad parse of line 25870 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 25870 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 25993 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 25993 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27233 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27233 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27234 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27691 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 27805 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 108089 (25 headers, 27 values)�[0m
�[31m  Bad parse of line 108089 (25 headers, 29 values)�[0m
�[31m  Bad parse of line 108089 (25 headers, 29 values)�[0m
�[31m  Bad parse of line 115690 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 150015 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 150015 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 150015 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 151382 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158699 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158699 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158699 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 158812 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 166353 (25 headers, 29 values)�[0m
�[31m  Bad parse of line 173981 (25 headers, 26 values)�[0m
�[31m  Bad parse of line 174630 (25 headers, 26 values)�[0m
�[31m  103 errors�[0m
�[37m Cleaning LOBBYIST_FIRM_EMPLOYER2_CD.TSV�[0m
�[37m Cleaning CVR_CAMPAIGN_DISCLOSURE_CD.TSV�[0m
�[31m  Bad parse of line 340 (86 headers, 98 values)�[0m
�[31m  Bad parse of line 470 (86 headers, 113 values)�[0m
�[31m  Bad parse of line 729 (86 headers, 89 values)�[0m
�[31m  Bad parse of line 1778 (86 headers, 87 values)�[0m
�[31m  Bad parse of line 109219 (86 headers, 89 values)�[0m
�[31m  Bad parse of line 155363 (86 headers, 89 values)�[0m
�[31m  Bad parse of line 167220 (86 headers, 87 values)�[0m
�[31m  Bad parse of line 276370 (86 headers, 87 values)�[0m
�[31m  Bad parse of line 318895 (86 headers, 88 values)�[0m
�[31m  8 errors�[0m
�[37m Cleaning LOBBYIST_EMPLOYER_FIRMS1_CD.TSV�[0m
�[37m Cleaning LOBBYIST_CONTRIBUTIONS1_CD.TSV�[0m
�[37m Cleaning LOBBY_AMENDMENTS_CD.TSV�[0m
�[37m Cleaning HDR_CD.TSV�[0m
�[37m Cleaning FILERNAME_CD.TSV�[0m
�[31m  Bad parse of line 30407 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 30407 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 30407 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 30407 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 32446 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 52200 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 52200 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 52200 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 52200 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 74604 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 74604 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 205239 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 205239 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 244543 (17 headers, 18 values)�[0m
�[31m  Bad parse of line 267417 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 267417 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 330792 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 330792 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 330792 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 330792 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 330792 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 330792 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 330792 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 330792 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 444461 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 444461 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 444461 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 444461 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 444461 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 444461 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 461568 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 461568 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 461568 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 461568 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 574123 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 574123 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 574123 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 574123 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 574123 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 574123 (17 headers, 12 values)�[0m
�[31m  Bad parse of line 574123 (17 headers, 6 values)�[0m
�[31m  Bad parse of line 574123 (17 headers, 12 values)�[0m
�[31m  64 errors�[0m
�[37m Cleaning S498_CD.TSV�[0m
�[31m  Bad parse of line 7955 (37 headers, 38 values)�[0m
�[31m  0 errors�[0m
�[37m Cleaning LOBBYIST_EMPLOYER_FIRMS2_CD.TSV�[0m
�[37m Cleaning CVR_LOBBY_DISCLOSURE_CD.TSV�[0m
�[31m  Bad parse of line 2958 (52 headers, 87 values)�[0m
�[31m  Bad parse of line 4757 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 7497 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 13491 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 17500 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 19103 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 21161 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 23732 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 25790 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 32020 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 33165 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 36115 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 43408 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 46578 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 48774 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 50818 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 53194 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 55030 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 55275 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 57261 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 59755 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 64786 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 73901 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 77577 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 77726 (52 headers, 91 values)�[0m
�[31m  Bad parse of line 79704 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 81246 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 82707 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 87151 (52 headers, 56 values)�[0m
�[31m  Bad parse of line 87466 (52 headers, 60 values)�[0m
�[31m  Bad parse of line 87468 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 87481 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 87619 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 87719 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 90633 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 90964 (52 headers, 62 values)�[0m
�[31m  Bad parse of line 90969 (52 headers, 61 values)�[0m
�[31m  Bad parse of line 90980 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 91035 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 91298 (52 headers, 55 values)�[0m
�[31m  Bad parse of line 91387 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 91629 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 106385 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 108391 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 108454 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 109129 (52 headers, 62 values)�[0m
�[31m  Bad parse of line 109748 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 109748 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 109839 (52 headers, 72 values)�[0m
�[31m  Bad parse of line 112646 (52 headers, 75 values)�[0m
�[31m  Bad parse of line 122412 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 122556 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 122732 (52 headers, 55 values)�[0m
�[31m  Bad parse of line 123780 (52 headers, 55 values)�[0m
�[31m  Bad parse of line 126308 (52 headers, 56 values)�[0m
�[31m  Bad parse of line 138191 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 138841 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 139198 (52 headers, 63 values)�[0m
�[31m  Bad parse of line 139926 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 142040 (52 headers, 74 values)�[0m
�[31m  Bad parse of line 146979 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 156345 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 158709 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 160673 (52 headers, 55 values)�[0m
�[31m  Bad parse of line 168966 (52 headers, 59 values)�[0m
�[31m  Bad parse of line 182307 (52 headers, 82 values)�[0m
�[31m  Bad parse of line 185170 (52 headers, 53 values)�[0m
�[31m  Bad parse of line 189378 (52 headers, 58 values)�[0m
�[31m  Bad parse of line 189786 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 196729 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 201259 (52 headers, 54 values)�[0m
�[31m  Bad parse of line 223958 (52 headers, 54 values)�[0m
�[31m  71 errors�[0m
�[37m Cleaning LOBBYIST_FIRM_EMPLOYER1_CD.TSV�[0m
�[37m Cleaning DEBT_CD.TSV�[0m
�[31m  Bad parse of line 230253 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 230256 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 235756 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 235759 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 236548 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 236551 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 241139 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 241142 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 256288 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 256291 (33 headers, 34 values)�[0m
�[31m  Bad parse of line 391421 (33 headers, 34 values)�[0m
�[31m  10 errors�[0m
�[37m Cleaning LOBBYIST_FIRM_LOBBYIST2_CD.TSV�[0m
�[37m Cleaning FILER_ETHICS_CLASS_CD.TSV�[0m
�[37m Cleaning EXPN_CD.TSV�[0m
�[31m  Bad parse of line 1170527 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 1666937 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2745217 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2745217 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2745927 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2745978 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2745978 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2746568 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2746571 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2748361 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2748992 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2749038 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2749052 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2749057 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2765436 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2773498 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2773498 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2785109 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2795312 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2795356 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2795356 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2795922 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2795978 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2795992 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2795992 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2796067 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2796828 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2803077 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2807451 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2807823 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2807823 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2807823 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2845629 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2885128 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2887541 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2887541 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2914830 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2914830 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2958123 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2964070 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2964644 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2975513 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2975513 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2975513 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2978114 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2979636 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2979640 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2995168 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 2995168 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3010785 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3010841 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3015818 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3015818 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3015818 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3045712 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3048341 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3056197 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3095429 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3100376 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3102434 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3102434 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3103278 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3103394 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3103394 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3103394 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3103850 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3103855 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3103863 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3103864 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3103867 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3105332 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3112056 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3113555 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3116134 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3141108 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3141110 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3187118 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3203112 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3203114 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3203841 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3203843 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3204021 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3204021 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3208015 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3244810 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3244810 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3244810 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3250620 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3251807 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3261117 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3261765 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3280879 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3280890 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3292959 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3353311 (53 headers, 8 values)�[0m
�[31m  Bad parse of line 3353311 (53 headers, 46 values)�[0m
�[31m  Bad parse of line 3392398 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3392398 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3392398 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3402755 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3402755 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3403386 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3403386 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3403388 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3403388 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3403388 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3431118 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3433764 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3435881 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3435890 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3439717 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3441195 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3457231 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3468792 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3497812 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3528071 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3528074 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3528074 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3528079 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3528079 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3528081 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3528709 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3530685 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3534900 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3540583 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3544738 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3544739 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3544739 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3544741 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3545366 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3545426 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3547457 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3558383 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3564517 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3565123 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3565142 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3565151 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3565151 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3565151 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3565151 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3570288 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3591422 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3592014 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3598469 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3604297 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3604394 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3605018 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3605041 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3605723 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3607756 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3610179 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3612924 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3632727 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3636454 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3661400 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3661400 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3661400 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3661400 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3661400 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3661400 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3661400 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3663259 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3663878 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3667418 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3668136 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3671221 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3671221 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3671221 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3671221 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3671924 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3671924 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3671924 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3673243 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3674145 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3674168 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3674196 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3674803 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3674838 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3674838 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3674838 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3680703 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3721535 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3728587 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3729569 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3730068 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3736732 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3743080 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3744650 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3763279 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3763497 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3814409 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3888511 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3915986 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3925688 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3984799 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3986240 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3992267 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3993863 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 3994469 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4001891 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4041936 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4075073 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4094396 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4099251 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4099251 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4102397 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4104354 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4104362 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4104362 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4104778 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4105639 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4106315 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4108063 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4108246 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4108246 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4109173 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4111243 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4133085 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4133085 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4134097 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4144467 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4146867 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4148487 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4149951 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4150846 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4153094 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4155841 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4155843 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4166747 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4192946 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4193824 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4201078 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4201421 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4201485 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4204969 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4206509 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4207997 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4207997 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4214169 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4222302 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4224560 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4244014 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4283918 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4286049 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4287432 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4287518 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4288585 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4328587 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4369900 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4369900 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4369900 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4370683 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4410096 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4410101 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4426659 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4430515 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4432316 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4432316 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4432316 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4436266 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4436266 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4454512 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4454512 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4454512 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4454678 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4459731 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4475033 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4475039 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4496583 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4509473 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4516126 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4517269 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4521280 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4543993 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4550064 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4558758 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4564059 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4566213 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4591584 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4610765 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4653939 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4654916 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4654917 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4654935 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4654937 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4655093 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4661167 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4662274 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4662585 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4674456 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4674456 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4674456 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4679254 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4698218 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4703342 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4704590 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4736457 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4736457 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4736457 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4737118 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4737118 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4759576 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4759576 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4760892 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4772967 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4787219 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4787219 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4787219 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4790561 (53 headers, 54 values)�[0m
�[31m  Bad parse of line 4790561 (53 headers, 54 values)�[0m
�[31m  309 errors�[0m
�[37m Cleaning F501_502_CD.TSV�[0m
�[37m Cleaning CVR_SO_CD.TSV�[0m
�[37m Cleaning FILER_STATUS_TYPES_CD.TSV�[0m
�[37m Cleaning S496_CD.TSV�[0m
�[31m  Bad parse of line 13744 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 13765 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 13765 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 13766 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 19419 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 19419 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 23367 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 27042 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 27070 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 27070 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 27538 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 27538 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 30773 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32381 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32546 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32657 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32657 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32712 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32712 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32822 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32923 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32923 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32923 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32961 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 32961 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 33065 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 33065 (12 headers, 13 values)�[0m
�[31m  Bad parse of line 33129 (12 headers, 13 values)�[0m
�[31m  27 errors�[0m
�[37m Cleaning LPAY_CD.TSV�[0m
�[31m  Bad parse of line 6261 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 6447 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 6558 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 8212 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 8478 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 8478 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 9680 (26 headers, 32 values)�[0m
�[31m  Bad parse of line 9680 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 10102 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 12209 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 12888 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 13472 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 13488 (26 headers, 30 values)�[0m
�[31m  Bad parse of line 13649 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 13729 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 15348 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 15352 (26 headers, 32 values)�[0m
�[31m  Bad parse of line 15379 (26 headers, 47 values)�[0m
�[31m  Bad parse of line 15383 (26 headers, 48 values)�[0m
�[31m  Bad parse of line 15442 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 16510 (26 headers, 50 values)�[0m
�[31m  Bad parse of line 16873 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 17561 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 18845 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 18850 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 19908 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 19908 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 21241 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 24844 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 24973 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 25135 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 29830 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 29830 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 30293 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 30366 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 30735 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 31001 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 31292 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 31292 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 32251 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 33019 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 37301 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 39721 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 40836 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 41966 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 42090 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 42091 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 42091 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 42092 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 42092 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 42104 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 42249 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 42728 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 45926 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 50003 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 142349 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 154021 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 154021 (26 headers, 36 values)�[0m
�[31m  Bad parse of line 154028 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 155058 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 180392 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 180392 (26 headers, 36 values)�[0m
�[31m  Bad parse of line 180523 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 182893 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 184516 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 184516 (26 headers, 36 values)�[0m
�[31m  Bad parse of line 184978 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 222232 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 243418 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 250829 (26 headers, 28 values)�[0m
�[31m  Bad parse of line 258704 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 262207 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 262587 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 263247 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 264826 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 265358 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 266080 (26 headers, 29 values)�[0m
�[31m  Bad parse of line 271894 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 280301 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 287288 (26 headers, 27 values)�[0m
�[31m  Bad parse of line 323677 (26 headers, 28 values)�[0m
�[31m  80 errors�[0m
�[37m Cleaning LCCM_CD.TSV�[0m
�[31m  Bad parse of line 5204 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 7070 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 7177 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 7209 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 7211 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 7243 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 10751 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 10752 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 10754 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 10755 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 14612 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 16934 (24 headers, 26 values)�[0m
�[31m  Bad parse of line 24857 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 24863 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 24867 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 24873 (24 headers, 25 values)�[0m
�[31m  15 errors�[0m
�[37m Cleaning LEMP_CD.TSV�[0m
�[31m  Bad parse of line 62936 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 64157 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 66079 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 74120 (24 headers, 27 values)�[0m
�[31m  Bad parse of line 74150 (24 headers, 27 values)�[0m
�[31m  Bad parse of line 82344 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 82348 (24 headers, 25 values)�[0m
�[31m  Bad parse of line 103402 (24 headers, 27 values)�[0m
�[31m  Bad parse of line 191081 (24 headers, 25 values)�[0m
�[31m  8 errors�[0m
�[37m Cleaning LOBBYIST_EMPLOYER2_CD.TSV�[0m
�[37m Cleaning S497_CD.TSV�[0m
�[31m  Bad parse of line 344123 (41 headers, 42 values)�[0m
�[31m  Bad parse of line 560416 (41 headers, 42 values)�[0m
�[31m  1 errors�[0m
�[37m Cleaning EFS_FILING_LOG_CD.TSV�[0m
�[37m Cleaning LEGISLATIVE_SESSIONS_CD.TSV�[0m
�[37m Cleaning LOAN_CD.TSV�[0m
�[31m  Bad parse of line 55918 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 56375 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 59049 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 59632 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 60753 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 61125 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 61125 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 61705 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 62536 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 62539 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 63212 (49 headers, 50 values)�[0m
�[31m  Bad parse of line 65702 (49 headers, 50 values)�[0m
�[31m  11 errors�[0m
�[37m Cleaning LOBBYIST_CONTRIBUTIONS2_CD.TSV�[0m
�[37m Cleaning FILERS_CD.TSV�[0m
�[37m Cleaning LOBBYIST_CONTRIBUTIONS3_CD.TSV�[0m
�[37m Cleaning FILER_TYPES_CD.TSV�[0m
�[37m Cleaning LOBBYIST_FIRM1_CD.TSV�[0m
�[37m Cleaning CVR_E530_CD.TSV�[0m
�[37m Cleaning LOBBYIST_EMP_LOBBYIST2_CD.TSV�[0m
�[37m Cleaning FILER_INTERESTS_CD.TSV�[0m
�[37m Cleaning LOBBYIST_FIRM3_CD.TSV�[0m
�[37m Cleaning FILER_FILINGS_CD.TSV�[0m
�[37m Cleaning ACRONYMS_CD.TSV�[0m
�[37m Cleaning S401_CD.TSV�[0m
�[31m  Bad parse of line 32554 (37 headers, 38 values)�[0m
�[31m  Bad parse of line 32554 (37 headers, 38 values)�[0m
�[31m  Bad parse of line 32554 (37 headers, 38 values)�[0m
�[31m  2 errors�[0m
�[37m Cleaning NAMES_CD.TSV�[0m
�[31m  Bad parse of line 278142 (10 headers, 12 values)�[0m
�[31m  Bad parse of line 311632 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 311632 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 311632 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 313328 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 313328 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 313328 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 313734 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 313734 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 313734 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 315350 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 315350 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 315350 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 320872 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 320872 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 320872 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 321680 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 321680 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 321680 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 323346 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 323346 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 323346 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 326020 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 326020 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 326020 (10 headers, 1 values)�[0m
�[31m  Bad parse of line 330749 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 330749 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 330749 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 343103 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 343103 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 343103 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 344472 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 344472 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 344472 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 351633 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 351633 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 351633 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 412650 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 412650 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 412650 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 416815 (10 headers, 2 values)�[0m
�[31m  Bad parse of line 416815 (10 headers, 9 values)�[0m
�[31m  Bad parse of line 416815 (10 headers, 0 values)�[0m
�[31m  Bad parse of line 423953 (10 headers, 12 values)�[0m
�[31m  43 errors�[0m
�[37m Cleaning SMRY_CD.TSV�[0m
�[37m Cleaning LOBBYIST_FIRM2_CD.TSV�[0m
�[37m Cleaning ADDRESS_CD.TSV�[0m
�[37m Cleaning SPLT_CD.TSV�[0m
�[37m Cleaning CVR2_SO_CD.TSV�[0m
�[37m Cleaning IMAGE_LINKS_CD.TSV�[0m
�[37m Cleaning GROUP_TYPES_CD.TSV�[0m
�[37m Cleaning RCPT_CD.TSV�[0m
�[31m  Bad parse of line 7890 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 1075880 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 1075880 (63 headers, 67 values)�[0m
�[31m  Bad parse of line 3015143 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 3017143 (63 headers, 65 values)�[0m
�[31m  Bad parse of line 3017144 (63 headers, 65 values)�[0m
�[31m  Bad parse of line 3017144 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 3208143 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 3208152 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 3492354 (63 headers, 65 values)�[0m
�[31m  Bad parse of line 3492356 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 3608702 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 3609402 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 4032165 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 5731038 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 5731038 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 5731887 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 5731887 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 5731887 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 5731887 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 6122135 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 6316432 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 6426826 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 6427175 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 6612992 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 6727460 (63 headers, 8 values)�[0m
�[31m  Bad parse of line 6727460 (63 headers, 56 values)�[0m
�[31m  Bad parse of line 6796233 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 6796233 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7101220 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7233520 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7242483 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7301955 (63 headers, 8 values)�[0m
�[31m  Bad parse of line 7301955 (63 headers, 56 values)�[0m
�[31m  Bad parse of line 7328705 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7352265 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7407715 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7705405 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7834363 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7849374 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 7866605 (63 headers, 8 values)�[0m
�[31m  Bad parse of line 7866605 (63 headers, 56 values)�[0m
�[31m  Bad parse of line 7866808 (63 headers, 8 values)�[0m
�[31m  Bad parse of line 7866808 (63 headers, 56 values)�[0m
�[31m  Bad parse of line 8022905 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8080495 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8104202 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8162080 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8172788 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8204031 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8282545 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8292921 (63 headers, 8 values)�[0m
�[31m  Bad parse of line 8292921 (63 headers, 56 values)�[0m
�[31m  Bad parse of line 8300913 (63 headers, 8 values)�[0m
�[31m  Bad parse of line 8300913 (63 headers, 56 values)�[0m
�[31m  Bad parse of line 8335630 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8335630 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8400445 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8501789 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8548113 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8694866 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8725332 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8924881 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8925108 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8932612 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8941711 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8960990 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 8983982 (63 headers, 8 values)�[0m
�[31m  Bad parse of line 8983982 (63 headers, 56 values)�[0m
�[31m  Bad parse of line 9027349 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 9043277 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 9043277 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 9158166 (63 headers, 64 values)�[0m
�[31m  Bad parse of line 9169556 (63 headers, 64 values)�[0m
�[31m  73 errors�[0m
�[37m Cleaning LOTH_CD.TSV�[0m
�[37m Cleaning FILER_ACRONYMS_CD.TSV�[0m
�[37m Cleaning CVR_REGISTRATION_CD.TSV�[0m
�[31m  Bad parse of line 30381 (71 headers, 72 values)�[0m
�[31m  0 errors�[0m
�[37m Cleaning FILING_PERIOD_CD.TSV�[0m
�[37m Cleaning LOBBYIST_EMPLOYER_HISTORY_CD.TSV�[0m
�[37m Cleaning LOBBYIST_FIRM_LOBBYIST1_CD.TSV�[0m
�[37m Cleaning FILER_XREF_CD.TSV�[0m
�[37m Cleaning HEADER_CD.TSV�[0m
�[37m Cleaning LOBBYIST_EMPLOYER3_CD.TSV�[0m
�[37m Cleaning BALLOT_MEASURES_CD.TSV�[0m
�[37m Cleaning CVR2_REGISTRATION_CD.TSV�[0m
�[31m  Bad parse of line 62104 (12 headers, 13 values)�[0m
�[31m  0 errors�[0m
�[37m Cleaning RECEIVED_FILINGS_CD.TSV�[0m
�[37m Cleaning TEXT_MEMO_CD.TSV�[0m
�[31m  Bad parse of line 31454 (7 headers, 23 values)�[0m
�[31m  Bad parse of line 54212 (7 headers, 23 values)�[0m
�[31m  Bad parse of line 82131 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 82820 (7 headers, 38 values)�[0m
�[31m  Bad parse of line 82821 (7 headers, 32 values)�[0m
�[31m  Bad parse of line 82853 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 83897 (7 headers, 62 values)�[0m
�[31m  Bad parse of line 86204 (7 headers, 28 values)�[0m
�[31m  Bad parse of line 86204 (7 headers, 65 values)�[0m
�[31m  Bad parse of line 86204 (7 headers, 13 values)�[0m
�[31m  Bad parse of line 86204 (7 headers, 33 values)�[0m
�[31m  Bad parse of line 86298 (7 headers, 40 values)�[0m
�[31m  Bad parse of line 86298 (7 headers, 29 values)�[0m
�[31m  Bad parse of line 86298 (7 headers, 40 values)�[0m
�[31m  Bad parse of line 86298 (7 headers, 28 values)�[0m
�[31m  Bad parse of line 88215 (7 headers, 28 values)�[0m
�[31m  Bad parse of line 100394 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 100395 (7 headers, 132 values)�[0m
�[31m  Bad parse of line 136456 (7 headers, 12 values)�[0m
�[31m  Bad parse of line 140913 (7 headers, 12 values)�[0m
�[31m  Bad parse of line 166689 (7 headers, 12 values)�[0m
�[31m  Bad parse of line 181970 (7 headers, 40 values)�[0m
�[31m  Bad parse of line 182059 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 182524 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 185145 (7 headers, 12 values)�[0m
�[31m  Bad parse of line 196235 (7 headers, 27 values)�[0m
�[31m  Bad parse of line 199224 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 201284 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 203282 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 206416 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 211278 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 214027 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 217844 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 220267 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 231854 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 249746 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 250533 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 254842 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 259514 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 265246 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 279021 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 320899 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 331704 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 355154 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 355579 (7 headers, 315 values)�[0m
�[31m  Bad parse of line 355711 (7 headers, 187 values)�[0m
�[31m  Bad parse of line 355758 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 357361 (7 headers, 55 values)�[0m
�[31m  Bad parse of line 367511 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 382646 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 387145 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 400706 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 402204 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 438807 (7 headers, 70 values)�[0m
�[31m  Bad parse of line 453200 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 459810 (7 headers, 70 values)�[0m
�[31m  Bad parse of line 492750 (7 headers, 70 values)�[0m
�[31m  Bad parse of line 492750 (7 headers, 70 values)�[0m
�[31m  Bad parse of line 493941 (7 headers, 70 values)�[0m
�[31m  Bad parse of line 553364 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 572518 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 572518 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 572519 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 573183 (7 headers, 13 values)�[0m
�[31m  Bad parse of line 573227 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 583781 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 592999 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 601529 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 627667 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 647807 (7 headers, 15 values)�[0m
�[31m  Bad parse of line 648694 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 649990 (7 headers, 12 values)�[0m
�[31m  Bad parse of line 674766 (7 headers, 22 values)�[0m
�[31m  Bad parse of line 692188 (7 headers, 12 values)�[0m
�[31m  Bad parse of line 717290 (7 headers, 21 values)�[0m
�[31m  Bad parse of line 719271 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 720144 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 728824 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 730611 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 734019 (7 headers, 12 values)�[0m
�[31m  Bad parse of line 746651 (7 headers, 25 values)�[0m
�[31m  Bad parse of line 755985 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 757209 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 757285 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 758925 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 768839 (7 headers, 25 values)�[0m
�[31m  Bad parse of line 768898 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 769676 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 772720 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 774871 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 781129 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 798296 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 801229 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 804349 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 806369 (7 headers, 25 values)�[0m
�[31m  Bad parse of line 807912 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 811222 (7 headers, 25 values)�[0m
�[31m  Bad parse of line 815566 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 818165 (7 headers, 33 values)�[0m
�[31m  Bad parse of line 818684 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 832752 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 832811 (7 headers, 36 values)�[0m
�[31m  Bad parse of line 839489 (7 headers, 34 values)�[0m
�[31m  Bad parse of line 842527 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 846856 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 863540 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 883159 (7 headers, 0 values)�[0m
�[31m  Bad parse of line 886797 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 889174 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 889175 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 889176 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 889176 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 889176 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 889176 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 889626 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 892659 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 893185 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 895138 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 897221 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 897907 (7 headers, 25 values)�[0m
�[31m  Bad parse of line 914918 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 919789 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 930315 (7 headers, 23 values)�[0m
�[31m  Bad parse of line 935267 (7 headers, 12 values)�[0m
�[31m  Bad parse of line 935583 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 935587 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 935587 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 935587 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 938545 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 939882 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 972958 (7 headers, 20 values)�[0m
�[31m  Bad parse of line 983150 (7 headers, 53 values)�[0m
�[31m  Bad parse of line 986431 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 986431 (7 headers, 20 values)�[0m
�[31m  Bad parse of line 986639 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 992046 (7 headers, 15 values)�[0m
�[31m  Bad parse of line 1020433 (7 headers, 19 values)�[0m
�[31m  Bad parse of line 1021632 (7 headers, 18 values)�[0m
�[31m  Bad parse of line 1023480 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1025628 (7 headers, 19 values)�[0m
�[31m  Bad parse of line 1028246 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1034768 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1066616 (7 headers, 132 values)�[0m
�[31m  Bad parse of line 1072174 (7 headers, 15 values)�[0m
�[31m  Bad parse of line 1078494 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1081889 (7 headers, 48 values)�[0m
�[31m  Bad parse of line 1094594 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1096062 (7 headers, 15 values)�[0m
�[31m  Bad parse of line 1134671 (7 headers, 18 values)�[0m
�[31m  Bad parse of line 1138279 (7 headers, 13 values)�[0m
�[31m  Bad parse of line 1170621 (7 headers, 1 values)�[0m
�[31m  Bad parse of line 1174267 (7 headers, 18 values)�[0m
�[31m  Bad parse of line 1205970 (7 headers, 18 values)�[0m
�[31m  Bad parse of line 1209078 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1216717 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1236415 (7 headers, 17 values)�[0m
�[31m  Bad parse of line 1239753 (7 headers, 34 values)�[0m
�[31m  Bad parse of line 1249206 (7 headers, 0 values)�[0m
�[31m  Bad parse of line 1269442 (7 headers, 18 values)�[0m
�[31m  Bad parse of line 1275008 (7 headers, 0 values)�[0m
�[31m  Bad parse of line 1281314 (7 headers, 152 values)�[0m
�[31m  Bad parse of line 1283696 (7 headers, 1 values)�[0m
�[31m  Bad parse of line 1283696 (7 headers, 1 values)�[0m
�[31m  Bad parse of line 1283696 (7 headers, 1 values)�[0m
�[31m  Bad parse of line 1292041 (7 headers, 0 values)�[0m
�[31m  Bad parse of line 1293365 (7 headers, 91 values)�[0m
�[31m  Bad parse of line 1302191 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1310119 (7 headers, 94 values)�[0m
�[31m  Bad parse of line 1312999 (7 headers, 13 values)�[0m
�[31m  Bad parse of line 1315144 (7 headers, 1 values)�[0m
�[31m  Bad parse of line 1319039 (7 headers, 1 values)�[0m
�[31m  Bad parse of line 1320728 (7 headers, 0 values)�[0m
�[31m  Bad parse of line 1341342 (7 headers, 47 values)�[0m
�[31m  Bad parse of line 1345624 (7 headers, 94 values)�[0m
�[31m  Bad parse of line 1346979 (7 headers, 93 values)�[0m
�[31m  Bad parse of line 1347887 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 1347887 (7 headers, 74 values)�[0m
�[31m  Bad parse of line 1348662 (7 headers, 73 values)�[0m
�[31m  Bad parse of line 1350929 (7 headers, 70 values)�[0m
�[31m  Bad parse of line 1360210 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1360792 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1360792 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1363606 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1373653 (7 headers, 0 values)�[0m
�[31m  Bad parse of line 1381839 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 1382564 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1382564 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 1382612 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 1383196 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 1383196 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1383547 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1384023 (7 headers, 93 values)�[0m
�[31m  Bad parse of line 1384320 (7 headers, 0 values)�[0m
�[31m  Bad parse of line 1384400 (7 headers, 74 values)�[0m
�[31m  Bad parse of line 1384788 (7 headers, 73 values)�[0m
�[31m  Bad parse of line 1385092 (7 headers, 70 values)�[0m
�[31m  Bad parse of line 1385116 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1386261 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 1386871 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1386871 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 1387712 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1394090 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1394090 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1394808 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1394809 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1394809 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1394811 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1399787 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1399787 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1399788 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1400761 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1400763 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1400763 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1400763 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1400764 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1400777 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1400777 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1400778 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1400779 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1400779 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1400781 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1409676 (7 headers, 11 values)�[0m
�[31m  Bad parse of line 1415118 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1419092 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1419092 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1419093 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1419094 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1419572 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1419572 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1419572 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1419573 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1422763 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1423057 (7 headers, 0 values)�[0m
�[31m  Bad parse of line 1424640 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1441158 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1441158 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1442005 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1442005 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1442006 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1442007 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1442009 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1442009 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1442009 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1442010 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1458966 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1459304 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1459304 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1460275 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1460397 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1460463 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1460472 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1460596 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1460651 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1460809 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1461027 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1461244 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1462016 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1462109 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1462315 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1462315 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1462448 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1462448 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1462707 (7 headers, 102 values)�[0m
�[31m  Bad parse of line 1462712 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1462712 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1462712 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1463043 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1472876 (7 headers, 0 values)�[0m
�[31m  Bad parse of line 1473506 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1494778 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1497165 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1497165 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1497389 (7 headers, 1 values)�[0m
�[31m  Bad parse of line 1498119 (7 headers, 10 values)�[0m
�[31m  Bad parse of line 1498518 (7 headers, 9 values)�[0m
�[31m  Bad parse of line 1499689 (7 headers, 13 values)�[0m
�[31m  Bad parse of line 1499689 (7 headers, 17 values)�[0m
�[31m  Bad parse of line 1499733 (7 headers, 8 values)�[0m
�[31m  Bad parse of line 1500585 (7 headers, 10 values)�[0m
�[31m  278 errors�[0m
�[37m Cleaning LOBBYIST_FIRM_HISTORY_CD.TSV�[0m
�[37m Cleaning LATT_CD.TSV�[0m
�[37m Cleaning FILER_ADDRESS_CD.TSV�[0m
�[37m Cleaning CVR3_VERIFICATION_INFO_CD.TSV�[0m
�[37m Cleaning LOBBYING_CHG_LOG_CD.TSV�[0m
�[36;1mLoading data files�[0m
�[37m Loading CvrSoCd�[0m
�[37m Loading Cvr2SoCd�[0m
�[37m Loading CvrCampaignDisclosureCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 342381  CSV: 342382�[0m
�[37m Loading Cvr2CampaignDisclosureCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 97807   CSV: 97808�[0m
�[37m Loading RcptCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 9291111 CSV: 9300478�[0m
�[37m Loading Cvr3VerificationInfoCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 223192  CSV: 223193�[0m
�[37m Loading LoanCd�[0m
�[37m Loading S401Cd�[0m
�[37m Loading ExpnCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 4833019 CSV: 4835121�[0m
�[37m Loading F495P2Cd�[0m
�[37m Loading DebtCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 409443  CSV: 409828�[0m
�[37m Loading S496Cd�[0m
�[37m Loading SpltCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 3172062 CSV: 3177620�[0m
�[37m Loading S497Cd�[0m
�[37m Loading F501502Cd�[0m
�[37m Loading S498Cd�[0m
�[37m Loading CvrRegistrationCd�[0m
�[37m Loading Cvr2RegistrationCd�[0m
�[37m Loading CvrLobbyDisclosureCd�[0m
�[37m Loading Cvr2LobbyDisclosureCd�[0m
�[37m Loading LobbyAmendmentsCd�[0m
�[37m Loading F690P2Cd�[0m
�[37m Loading LattCd�[0m
�[37m Loading LexpCd�[0m
�[37m Loading LccmCd�[0m
�[37m Loading LothCd�[0m
�[37m Loading LempCd�[0m
�[37m Loading LpayCd�[0m
�[37m Loading FilernameCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 688184  CSV: 688186�[0m
�[37m Loading FilerFilingsCd�[0m
�[37m Loading FilingsCd�[0m
�[37m Loading SmryCd�[0m
�[37m Loading CvrE530Cd�[0m
�[37m Loading TextMemoCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 1524490 CSV: 1524536�[0m
�[37m Loading AcronymsCd�[0m
�[37m Loading AddressCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 326108  CSV: 326109�[0m
�[37m Loading BallotMeasuresCd�[0m
�[37m Loading EfsFilingLogCd�[0m
�[37m Loading FilersCd�[0m
�[37m Loading FilerAcronymsCd�[0m
�[37m Loading FilerAddressCd�[0m
�[37m Loading FilerEthicsClassCd�[0m
�[37m Loading FilerInterestsCd�[0m
�[37m Loading FilerLinksCd�[0m
�[37m Loading FilerStatusTypesCd�[0m
�[37m Loading FilerToFilerTypeCd�[0m
�[37m Loading FilerTypesCd�[0m
�[37m Loading FilerXrefCd�[0m
�[37m Loading FilingPeriodCd�[0m
�[37m Loading GroupTypesCd�[0m
�[37m Loading HeaderCd�[0m
�[37m Loading HdrCd�[0m
�[31m  Table record count doesn&#39;t match CSV. Table: 676116  CSV: 676117�[0m
�[37m Loading ImageLinksCd�[0m
�[37m Loading LegislativeSessionsCd�[0m
�[37m Loading LobbyingChgLogCd�[0m
�[37m Loading LobbyistContributions1Cd�[0m
�[37m Loading LobbyistContributions2Cd�[0m
�[37m Loading LobbyistContributions3Cd�[0m
�[37m Loading LobbyistEmployer1Cd�[0m
�[37m Loading LobbyistEmployer2Cd�[0m
�[37m Loading LobbyistEmployer3Cd�[0m
�[37m Loading LobbyistEmployerFirms1Cd�[0m
�[37m Loading LobbyistEmployerFirms2Cd�[0m
�[37m Loading LobbyistEmpLobbyist1Cd�[0m
�[37m Loading LobbyistEmpLobbyist2Cd�[0m
�[37m Loading LobbyistFirm1Cd�[0m
�[37m Loading LobbyistFirm2Cd�[0m
�[37m Loading LobbyistFirm3Cd�[0m
�[37m Loading LobbyistFirmEmployer1Cd�[0m
�[37m Loading LobbyistFirmEmployer2Cd�[0m
�[37m Loading LobbyistFirmLobbyist1Cd�[0m
�[37m Loading LobbyistFirmLobbyist2Cd�[0m
�[37m Loading LookupCode�[0m
�[37m Loading NamesCd�[0m
�[37m Loading ReceivedFilingsCd�[0m
�[37m Loading ReportsCd�[0m
�[32mDone!�[0m


Stderr (if any):




</pre>
    <hr />

    <pre>
Report for module &#39;netfile&#39;

Date:
  Feb. 23, 2016, 1:08 a.m.

Command:
  [&#39;python&#39;, &#39;/data/backend/current/manage.py&#39;, &#39;downloadnetfilerawdata&#39;, &#39;--no-color&#39;, &#39;--verbosity=3&#39;]

Return code:
  0

Stdout (if any):

Found 67 agencies
�[36;1mDownloading raw data files�[0m
Downloading data for 67 agencies in years 2014,2015
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_SFO_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_SFO_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_SJC_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_SJC_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_CSJ_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_CSJ_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_CSL_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_CSL_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_SLOCO_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_SLOCO_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_MAT_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_MAT_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_CSA_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_CSA_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_CSB_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_CSB_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_CSC_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_CSC_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_SCC_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_SCC_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_CRUZ_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_CRUZ_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_CSM_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_CSM_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_CSR_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_CSR_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_CSHA_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_CSHA_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_STO_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_STO_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_COS_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_COS_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_COV_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_COV_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_VCO_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_VCO_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_WESTSAC_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_WESTSAC_cal201_export.csv...�[0m
�[32mOK�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_COW_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_COW_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2014_TOY_cal201_export.csv...�[0m
�[31mNo data�[0m
�[37mWriting /data/backend/1455079647/data/netfile/csv/netfile_2015_TOY_cal201_export.csv...�[0m
�[31mNo data�[0m
�[36;1mLoading Agency CSV file�[0m
�[37m Loading NetFileAgency�[0m
�[32mok.�[0m
�[36;1mLoading Cal201 Transaction Data�[0m
�[37m Loading NetFileCal201Transaction�[0m
�[32mok.�[0m


Stderr (if any):




</pre>
    <hr />

    <pre>
Report for module &#39;xformnetfile&#39;

Date:
  Feb. 23, 2016, 2:08 a.m.

Command:
  [&#39;python&#39;, &#39;/data/backend/current/manage.py&#39;, &#39;xformnetfilerawdata&#39;, &#39;--no-color&#39;, &#39;--skip-download&#39;, &#39;--verbosity=3&#39;]

Return code:
  1

Stdout (if any):

Found 67 agencies
�[36;1mLoading disclosure data into database.�[0m
�[36;1mThere are 705962 rows in /data/backend/1455079647/disclosure/../data/netfile/csv/netfile_cal201_transaction.csv�[0m
Loading 490606 rows of Form 460 Sched. A data.


Stderr (if any):

Traceback (most recent call last):
  File &quot;/data/backend/current/manage.py&quot;, line 11, in &lt;module&gt;
    execute_from_command_line(sys.argv)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/core/management/__init__.py&quot;, line 338, in execute_from_command_line
    utility.execute()
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/core/management/__init__.py&quot;, line 330, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/core/management/base.py&quot;, line 390, in run_from_argv
    self.execute(*args, **cmd_options)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/core/management/base.py&quot;, line 441, in execute
    output = self.handle(*args, **options)
  File &quot;/data/backend/1455079647/netfile_raw/management/commands/downloadnetfilerawdata.py&quot;, line 172, in handle
    self.load()
  File &quot;/data/backend/1455079647/finance/management/commands/xformnetfilerawdata.py&quot;, line 369, in load
    agency_fn=lambda row: self.get_agency(
  File &quot;/data/backend/1455079647/finance/management/commands/xformnetfilerawdata.py&quot;, line 325, in load_f460A_data
    load_f460A_row(minimal_row, agency=agency, verbosity=verbosity)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/utils/decorators.py&quot;, line 145, in inner
    return func(*args, **kwargs)
  File &quot;/data/backend/1455079647/finance/management/commands/xformnetfilerawdata.py&quot;, line 266, in load_f460A_row
    row, verbosity=verbosity)
  File &quot;/data/backend/1455079647/finance/management/commands/xformnetfilerawdata.py&quot;, line 46, in parse_benefactor
    benefactor.save()
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/models/base.py&quot;, line 710, in save
    force_update=force_update, update_fields=update_fields)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/models/base.py&quot;, line 738, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/models/base.py&quot;, line 803, in _save_table
    forced_update)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/models/base.py&quot;, line 853, in _do_update
    return filtered._update(values) &gt; 0
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/models/query.py&quot;, line 580, in _update
    return query.get_compiler(self.db).execute_sql(CURSOR)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py&quot;, line 1059, in execute_sql
    cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py&quot;, line 837, in execute_sql
    cursor.execute(sql, params)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/backends/utils.py&quot;, line 64, in execute
    return self.cursor.execute(sql, params)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/utils.py&quot;, line 97, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/backends/utils.py&quot;, line 64, in execute
    return self.cursor.execute(sql, params)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py&quot;, line 124, in execute
    return self.cursor.execute(query, args)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py&quot;, line 205, in execute
    self.errorhandler(self, exc, value)
  File &quot;/data/backend/env/local/lib/python2.7/site-packages/MySQLdb/connections.py&quot;, line 36, in defaulterrorhandler
    raise errorclass, errorvalue
django.db.utils.OperationalError: (1054, &quot;Unknown column &#39;street&#39; in &#39;field list&#39;&quot;)



</pre>
    <hr />

bcipolli · 2016-02-24T15:48:18Z

@jnmarcus I'm not sure the expectation for your scenario 1. The two URLs are different, so you get different results. In one case you point at the API docs, the other you point to the admin homepage. Can you be explicit about what you expect to see in 1a vs. 1b?

adborden · 2016-06-23T15:49:46Z

@jnmarcus is this sitll an issue for you?

KyleW · 2016-07-20T00:57:16Z

I think this is still an issue. @jeremyad was talking about a fix over on #236 .

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

something's off with the swagger base url... #216

something's off with the swagger base url... #216

jnmarcus commented Feb 24, 2016

jnmarcus commented Feb 24, 2016

bcipolli commented Feb 24, 2016

adborden commented Jun 23, 2016

KyleW commented Jul 20, 2016 •

edited by jeremyad

Loading

something's off with the swagger base url... #216

something's off with the swagger base url... #216

Comments

jnmarcus commented Feb 24, 2016

jnmarcus commented Feb 24, 2016

bcipolli commented Feb 24, 2016

adborden commented Jun 23, 2016

KyleW commented Jul 20, 2016 • edited by jeremyad Loading

KyleW commented Jul 20, 2016 •

edited by jeremyad

Loading