search

datamade / election-money

Election Money - Bulk Downloads from the Illinois State Board of Elections
http://electionmoney.org
MIT License
1 stars 3 forks source link

Row 13096 of 2012_receipts.tsv appears malformed #22

Open aepton opened 9 years ago

aepton commented 9 years ago

python's csv.DictReader gives me this:

{'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60616 ', 'CommitteeID': 'Political Education Fund', 'RptRcvdDate': 'Kotowski D', 'CmteName': 'True', 'FirstName': '11/3/2012', 'StateID': 'False', 'Address1': '', 'Address2': 'Chicago', 'LocalCmte': '0', 'VendorZip': 'Quarterly', 'StateCmte': '8878', 'VendorLastOnlyName': '', 'RptPdEndDate': '1/15/2013 5:34 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '2260 S. Grove Street', 'VendorCity': ' ', 'Description': '', 'RcvDate': '2500.00', 'RctType': '', 'CmteReferName': 'Dan Kotowski for State Senate', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '10/1/2012', 'RptPdBegDate': '12/31/2012', 'Occupation': ''}

aepton commented 9 years ago

Also rows 44323 and 44324 of that same file:

{'City': '', 'VendorAddress2': '9/30/2012', 'LocalID': None, 'Zip': ' ', 'VendorAddress1': '7/1/2012', 'LastOnlyName': '', 'State': '', 'CommitteeID': 'Spring V', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'Spring Valley', 'StateID': None, 'Address1': '', 'Address2': '', 'LocalCmte': None, 'VendorZip': 'Friends of Sue Rezin', 'StateCmte': None, 'VendorLastOnlyName': ' ', 'RptPdEndDate': None, 'LoanAmount': 'Individual Contribution', 'RptType': 'True', 'VendorState': 'Rezin S', 'VendorFirstName': ' ', 'Employer': '', 'VendorCity': '10/11/2012 6:04 PM', 'Description': 'Quarterly', 'RcvDate': 'IL', 'RctType': ' ', 'CmteReferName': None, 'Amount': ' ', 'ElectionType': '10025', 'ElectionYear': 'False', 'RptPdBegDate': '0', 'Occupation': ''}

(My scrollback buffer is getting obliterated by alla these bad boys so bear with me)

aepton commented 9 years ago

80697 and 80698:

{'City': None, 'VendorAddress2': None, 'LocalID': None, 'Zip': None, 'VendorAddress1': None, 'LastOnlyName': "Fletcher O'Brien Kasper & Nottage P.C.", 'State': None, 'CommitteeID': '22181', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': '', 'StateID': None, 'Address1': '222 North LaSalle Street ', 'Address2': None, 'LocalCmte': None, 'VendorZip': None, 'StateCmte': None, 'VendorLastOnlyName': None, 'RptPdEndDate': None, 'LoanAmount': '0.00', 'RptType': None, 'VendorState': None, 'VendorFirstName': None, 'Employer': '', 'VendorCity': None, 'Description': None, 'RcvDate': '6/21/2012', 'RctType': None, 'CmteReferName': None, 'Amount': '300.00', 'ElectionType': None, 'ElectionYear': None, 'RptPdBegDate': None, 'Occupation': ''}

{'City': '', 'VendorAddress2': '6/30/2012', 'LocalID': None, 'Zip': ' ', 'VendorAddress1': '4/1/2012', 'LastOnlyName': '', 'State': '', 'CommitteeID': 'Suite 30', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'Chicago', 'StateID': None, 'Address1': '', 'Address2': '', 'LocalCmte': None, 'VendorZip': 'Committee to Elect Rich Morthland', 'StateCmte': None, 'VendorLastOnlyName': ' ', 'RptPdEndDate': None, 'LoanAmount': 'Individual Contribution', 'RptType': 'True', 'VendorState': 'Morthland R', 'VendorFirstName': ' ', 'Employer': '', 'VendorCity': '7/16/2012 11:13 AM', 'Description': 'Quarterly', 'RcvDate': 'IL', 'RctType': ' ', 'CmteReferName': None, 'Amount': '60601 ', 'ElectionType': '9974', 'ElectionYear': 'False', 'RptPdBegDate': '0', 'Occupation': ''}

aepton commented 9 years ago

86899: {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '62232 ', 'CommitteeID': 'PAC Fund', 'RptRcvdDate': 'Walker J', 'CmteName': 'True', 'FirstName': '5/30/2012', 'StateID': 'False', 'Address1': '', 'Address2': 'Caseyville', 'LocalCmte': '0', 'VendorZip': 'Quarterly', 'StateCmte': '10167', 'VendorLastOnlyName': '', 'RptPdEndDate': '7/5/2012 4:37 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '1220 Donald Bailey Dr.', 'VendorCity': ' ', 'Description': '', 'RcvDate': '500.00', 'RctType': '', 'CmteReferName': 'Committee to Elect Jeremy R Walker', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '4/1/2012', 'RptPdBegDate': '6/30/2012', 'Occupation': ''}

aepton commented 9 years ago

There are a few more I noticed as well, but I think you get the gist. If you want I can spit out a report of all the malformed rows in that file.

evz commented 9 years ago

@aepton Hey thanks. Whatever info you might be able to give us would be useful. Those files are actually generated by submitting a post to the Illinois Elections site and then just writing out the results. Confusingly, the code for that scraper is over here. I'll take a look at it and see if I can get some better error checking in there. Also, I've been meaning to make those CSVs and not TSVs for a while.

aepton commented 9 years ago

I don't know if this will be helpful or not, but here's my error log from 2009 - present:

Found 27 errors:

Error saving contribution on row 71738: null value in column "isbe_committee_name" violates not-null constraint DETAIL: Failing row contains (1969080, 250.00, 0.00, 2010-08-23, 14923, null, null, null, null, f, f, null, null, Chico & Nunes, P.C., , , , 333 West Wacker Drive, Suite 1650, 333 West Wacker Drive , null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2010).

{'City': None, 'VendorAddress2': None, 'LocalID': None, 'Zip': None, 'VendorAddress1': None, 'LastOnlyName': 'Chico & Nunes, P.C.', 'State': None, 'CommitteeID': '14923', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': '', 'StateID': None, 'Address1': '333 West Wacker Drive, Suite 1650', 'Address2': '333 West Wacker Drive ', 'LocalCmte': None, 'VendorZip': None, 'StateCmte': None, 'VendorLastOnlyName': None, 'RptPdEndDate': None, 'LoanAmount': '0.00', 'RptType': None, 'VendorState': None, 'VendorFirstName': None, 'Employer': '', 'VendorCity': None, 'Description': None, 'RcvDate': '8/23/2010', 'RctType': None, 'CmteReferName': None, 'Amount': '250.00', 'ElectionType': None, 'ElectionYear': None, 'RptPdBegDate': None, 'Occupation': ''} Error saving contribution on row 71739: [u"'Individual Contribution' value must be a decimal number."] {'City': '', 'VendorAddress2': '2/23/2011 9:05 PM', 'LocalID': None, 'Zip': ' ', 'VendorAddress1': '12/31/2010', 'LastOnlyName': 'Chicago', 'State': ' ', 'CommitteeID': 'Suite 1800', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'IL', 'StateID': None, 'Address1': '', 'Address2': '', 'LocalCmte': None, 'VendorZip': 'True', 'StateCmte': None, 'VendorLastOnlyName': ' ', 'RptPdEndDate': None, 'LoanAmount': '', 'RptType': '7508', 'VendorState': 'Citizens for David E Miller', 'VendorFirstName': '7/1/2010', 'Employer': '', 'VendorCity': 'Miller D', 'Description': ' ', 'RcvDate': '60606 ', 'RctType': 'Semiannual', 'CmteReferName': None, 'Amount': 'Individual Contribution', 'ElectionType': 'False', 'ElectionYear': '0', 'RptPdBegDate': None, 'Occupation': ''} Error saving contribution on row 28598: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Individual Contribution', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60615 ', 'CommitteeID': 'DBA: Kimbark Beverage Shoppe', 'RptRcvdDate': 'Preckwinkle', 'CmteName': 'False', 'FirstName': '10/7/2011', 'StateID': 'True', 'Address1': '', 'Address2': 'Chicago', 'LocalCmte': '15056', 'VendorZip': 'Quarterly', 'StateCmte': '0', 'VendorLastOnlyName': '', 'RptPdEndDate': '1/17/2012 2:28 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '1214 E. 53rd St', 'VendorCity': ' ', 'Description': '', 'RcvDate': '1000.00', 'RctType': '', 'CmteReferName': 'Preckwinkle for President', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '10/1/2011', 'RptPdBegDate': '12/31/2011', 'Occupation': ''} Error saving contribution on row 42252: null value in column "isbe_committee_name" violates not-null constraint DETAIL: Failing row contains (2095819, 300.00, 0.00, 2011-09-03, 22181, null, null, null, null, f, f, null, null, Fletcher O'Brien Kasper & Nottage P.C., , , , 222 North LaSalle Street , null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2011).

{'City': None, 'VendorAddress2': None, 'LocalID': None, 'Zip': None, 'VendorAddress1': None, 'LastOnlyName': "Fletcher O'Brien Kasper & Nottage P.C.", 'State': None, 'CommitteeID': '22181', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': '', 'StateID': None, 'Address1': '222 North LaSalle Street ', 'Address2': None, 'LocalCmte': None, 'VendorZip': None, 'StateCmte': None, 'VendorLastOnlyName': None, 'RptPdEndDate': None, 'LoanAmount': '0.00', 'RptType': None, 'VendorState': None, 'VendorFirstName': None, 'Employer': '', 'VendorCity': None, 'Description': None, 'RcvDate': '9/3/2011', 'RctType': None, 'CmteReferName': None, 'Amount': '300.00', 'ElectionType': None, 'ElectionYear': None, 'RptPdBegDate': None, 'Occupation': ''} Error saving contribution on row 42253: [u"'Individual Contribution' value must be a decimal number."] {'City': '', 'VendorAddress2': '9/30/2011', 'LocalID': None, 'Zip': ' ', 'VendorAddress1': '7/1/2011', 'LastOnlyName': '', 'State': '', 'CommitteeID': 'Suite 30', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'Chicago', 'StateID': None, 'Address1': '', 'Address2': '', 'LocalCmte': None, 'VendorZip': 'Committee to Elect Rich Morthland', 'StateCmte': None, 'VendorLastOnlyName': ' ', 'RptPdEndDate': None, 'LoanAmount': 'Individual Contribution', 'RptType': 'True', 'VendorState': 'Morthland R', 'VendorFirstName': ' ', 'Employer': '', 'VendorCity': '10/14/2011 5:43 PM', 'Description': 'Quarterly', 'RcvDate': 'IL', 'RctType': ' ', 'CmteReferName': None, 'Amount': '60601 ', 'ElectionType': '9974', 'ElectionYear': 'False', 'RptPdBegDate': '0', 'Occupation': ''} Error saving contribution on row 71725: null value in column "isbe_committee_name" violates not-null constraint DETAIL: Failing row contains (2125291, 200.00, 0.00, 2011-05-19, 89, null, null, null, null, f, f, null, null, Donnelly, Bruce, , , 23790 N Hillfarm Rd , null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2011).

{'City': None, 'VendorAddress2': None, 'LocalID': None, 'Zip': None, 'VendorAddress1': None, 'LastOnlyName': 'Donnelly', 'State': None, 'CommitteeID': '89', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'Bruce', 'StateID': None, 'Address1': '23790 N Hillfarm Rd ', 'Address2': None, 'LocalCmte': None, 'VendorZip': None, 'StateCmte': None, 'VendorLastOnlyName': None, 'RptPdEndDate': None, 'LoanAmount': '0.00', 'RptType': None, 'VendorState': None, 'VendorFirstName': None, 'Employer': '', 'VendorCity': None, 'Description': None, 'RcvDate': '5/19/2011', 'RctType': None, 'CmteReferName': None, 'Amount': '200.00', 'ElectionType': None, 'ElectionYear': None, 'RptPdBegDate': None, 'Occupation': ''} Error saving contribution on row 71727: [u"'Individual Contribution' value must be a decimal number."] {'City': '', 'VendorAddress2': '6/30/2011', 'LocalID': None, 'Zip': ' ', 'VendorAddress1': '4/1/2011', 'LastOnlyName': '', 'State': '', 'CommitteeID': ' 23790 N', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'Lake Barrington', 'StateID': None, 'Address1': '', 'Address2': '', 'LocalCmte': None, 'VendorZip': 'Lake County Republican Federation', 'StateCmte': None, 'VendorLastOnlyName': ' ', 'RptPdEndDate': None, 'LoanAmount': 'Individual Contribution', 'RptType': 'True', 'VendorState': 'Lake', 'VendorFirstName': ' ', 'Employer': '', 'VendorCity': '7/14/2011 2:11 PM', 'Description': 'Quarterly', 'RcvDate': 'IL', 'RctType': ' ', 'CmteReferName': None, 'Amount': '60010 ', 'ElectionType': '923', 'ElectionYear': 'True', 'RptPdBegDate': '257', 'Occupation': ''} Error saving contribution on row 13097: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60616 ', 'CommitteeID': 'Political Education Fund', 'RptRcvdDate': 'Kotowski D', 'CmteName': 'True', 'FirstName': '11/3/2012', 'StateID': 'False', 'Address1': '', 'Address2': 'Chicago', 'LocalCmte': '0', 'VendorZip': 'Quarterly', 'StateCmte': '8878', 'VendorLastOnlyName': '', 'RptPdEndDate': '1/15/2013 5:34 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '2260 S. Grove Street', 'VendorCity': ' ', 'Description': '', 'RcvDate': '2500.00', 'RctType': '', 'CmteReferName': 'Dan Kotowski for State Senate', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '10/1/2012', 'RptPdBegDate': '12/31/2012', 'Occupation': ''} Error saving contribution on row 40680: null value in column "isbe_committee_name" violates not-null constraint DETAIL: Failing row contains (2208819, 1000.00, 0.00, 2012-09-27, 89, null, null, null, null, f, f, null, null, McLaughlin, Delena, Controller, JnDAgInvestCo, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2012).

{'City': None, 'VendorAddress2': None, 'LocalID': None, 'Zip': None, 'VendorAddress1': None, 'LastOnlyName': 'McLaughlin', 'State': None, 'CommitteeID': '89', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'Delena', 'StateID': None, 'Address1': None, 'Address2': None, 'LocalCmte': None, 'VendorZip': None, 'StateCmte': None, 'VendorLastOnlyName': None, 'RptPdEndDate': None, 'LoanAmount': '0.00', 'RptType': None, 'VendorState': None, 'VendorFirstName': None, 'Employer': 'JnDAgInvestCo', 'VendorCity': None, 'Description': None, 'RcvDate': '9/27/2012', 'RctType': None, 'CmteReferName': None, 'Amount': '1000.00', 'ElectionType': None, 'ElectionYear': None, 'RptPdBegDate': None, 'Occupation': 'Controller'} Error saving contribution on row 40684: [u"'IL' value must be a decimal number."] {'City': '', 'VendorAddress2': '7/1/2012', 'LocalID': None, 'Zip': '', 'VendorAddress1': ' ', 'LastOnlyName': '4560 RFD', 'State': '', 'CommitteeID': ' JnDAgInvestCo', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': '', 'StateID': None, 'Address1': '', 'Address2': '', 'LocalCmte': None, 'VendorZip': 'Lake', 'StateCmte': None, 'VendorLastOnlyName': 'Quarterly', 'RptPdEndDate': '257', 'LoanAmount': '60047 ', 'RptType': 'Lake County Republican Federation', 'VendorState': '10/11/2012 4:28 PM', 'VendorFirstName': ' ', 'Employer': '', 'VendorCity': '9/30/2012', 'Description': ' ', 'RcvDate': 'Long Grove', 'RctType': ' ', 'CmteReferName': None, 'Amount': 'IL', 'ElectionType': 'True', 'ElectionYear': '923', 'RptPdBegDate': 'True', 'Occupation': 'Individual Contribution'} Error saving contribution on row 44323: null value in column "isbe_committee_name" violates not-null constraint DETAIL: Failing row contains (2212458, 250.00, 0.00, 2012-09-21, 22250, null, null, null, null, f, f, null, null, Loveland, James, , , 13146 Peru Princeton Rd, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2012).

{'City': None, 'VendorAddress2': None, 'LocalID': None, 'Zip': None, 'VendorAddress1': None, 'LastOnlyName': 'Loveland', 'State': None, 'CommitteeID': '22250', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'James', 'StateID': None, 'Address1': '13146 Peru Princeton Rd', 'Address2': None, 'LocalCmte': None, 'VendorZip': None, 'StateCmte': None, 'VendorLastOnlyName': None, 'RptPdEndDate': None, 'LoanAmount': '0.00', 'RptType': None, 'VendorState': None, 'VendorFirstName': None, 'Employer': '', 'VendorCity': None, 'Description': None, 'RcvDate': '9/21/2012', 'RctType': None, 'CmteReferName': None, 'Amount': '250.00', 'ElectionType': None, 'ElectionYear': None, 'RptPdBegDate': None, 'Occupation': ''} Error saving contribution on row 44324: [u"' ' value must be a decimal number."] {'City': '', 'VendorAddress2': '9/30/2012', 'LocalID': None, 'Zip': ' ', 'VendorAddress1': '7/1/2012', 'LastOnlyName': '', 'State': '', 'CommitteeID': 'Spring V', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'Spring Valley', 'StateID': None, 'Address1': '', 'Address2': '', 'LocalCmte': None, 'VendorZip': 'Friends of Sue Rezin', 'StateCmte': None, 'VendorLastOnlyName': ' ', 'RptPdEndDate': None, 'LoanAmount': 'Individual Contribution', 'RptType': 'True', 'VendorState': 'Rezin S', 'VendorFirstName': ' ', 'Employer': '', 'VendorCity': '10/11/2012 6:04 PM', 'Description': 'Quarterly', 'RcvDate': 'IL', 'RctType': ' ', 'CmteReferName': None, 'Amount': ' ', 'ElectionType': '10025', 'ElectionYear': 'False', 'RptPdBegDate': '0', 'Occupation': ''} Error saving contribution on row 80697: null value in column "isbe_committee_name" violates not-null constraint DETAIL: Failing row contains (2248831, 300.00, 0.00, 2012-06-21, 22181, null, null, null, null, f, f, null, null, Fletcher O'Brien Kasper & Nottage P.C., , , , 222 North LaSalle Street , null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 2012).

{'City': None, 'VendorAddress2': None, 'LocalID': None, 'Zip': None, 'VendorAddress1': None, 'LastOnlyName': "Fletcher O'Brien Kasper & Nottage P.C.", 'State': None, 'CommitteeID': '22181', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': '', 'StateID': None, 'Address1': '222 North LaSalle Street ', 'Address2': None, 'LocalCmte': None, 'VendorZip': None, 'StateCmte': None, 'VendorLastOnlyName': None, 'RptPdEndDate': None, 'LoanAmount': '0.00', 'RptType': None, 'VendorState': None, 'VendorFirstName': None, 'Employer': '', 'VendorCity': None, 'Description': None, 'RcvDate': '6/21/2012', 'RctType': None, 'CmteReferName': None, 'Amount': '300.00', 'ElectionType': None, 'ElectionYear': None, 'RptPdBegDate': None, 'Occupation': ''} Error saving contribution on row 80698: [u"'Individual Contribution' value must be a decimal number."] {'City': '', 'VendorAddress2': '6/30/2012', 'LocalID': None, 'Zip': ' ', 'VendorAddress1': '4/1/2012', 'LastOnlyName': '', 'State': '', 'CommitteeID': 'Suite 30', 'RptRcvdDate': None, 'CmteName': None, 'FirstName': 'Chicago', 'StateID': None, 'Address1': '', 'Address2': '', 'LocalCmte': None, 'VendorZip': 'Committee to Elect Rich Morthland', 'StateCmte': None, 'VendorLastOnlyName': ' ', 'RptPdEndDate': None, 'LoanAmount': 'Individual Contribution', 'RptType': 'True', 'VendorState': 'Morthland R', 'VendorFirstName': ' ', 'Employer': '', 'VendorCity': '7/16/2012 11:13 AM', 'Description': 'Quarterly', 'RcvDate': 'IL', 'RctType': ' ', 'CmteReferName': None, 'Amount': '60601 ', 'ElectionType': '9974', 'ElectionYear': 'False', 'RptPdBegDate': '0', 'Occupation': ''} Error saving contribution on row 86899: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '62232 ', 'CommitteeID': 'PAC Fund', 'RptRcvdDate': 'Walker J', 'CmteName': 'True', 'FirstName': '5/30/2012', 'StateID': 'False', 'Address1': '', 'Address2': 'Caseyville', 'LocalCmte': '0', 'VendorZip': 'Quarterly', 'StateCmte': '10167', 'VendorLastOnlyName': '', 'RptPdEndDate': '7/5/2012 4:37 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '1220 Donald Bailey Dr.', 'VendorCity': ' ', 'Description': '', 'RcvDate': '500.00', 'RctType': '', 'CmteReferName': 'Committee to Elect Jeremy R Walker', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '4/1/2012', 'RptPdBegDate': '6/30/2012', 'Occupation': ''} Error saving contribution on row 97674: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '62703 ', 'CommitteeID': "Comm. for Responsible Gov't Fund", 'RptRcvdDate': 'Kotowski D', 'CmteName': 'True', 'FirstName': '4/12/2012', 'StateID': 'False', 'Address1': '', 'Address2': 'Springfield', 'LocalCmte': '0', 'VendorZip': 'Quarterly', 'StateCmte': '8878', 'VendorLastOnlyName': '', 'RptPdEndDate': '8/3/2012 2:16 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '3150 Wide Track Dr.', 'VendorCity': ' ', 'Description': '', 'RcvDate': '500.00', 'RctType': '', 'CmteReferName': 'Dan Kotowski for State Senate', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '4/1/2012', 'RptPdBegDate': '6/30/2012', 'Occupation': ''} Error saving contribution on row 97676: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60616 ', 'CommitteeID': 'Political Education Fund', 'RptRcvdDate': 'Kotowski D', 'CmteName': 'True', 'FirstName': '4/12/2012', 'StateID': 'False', 'Address1': '', 'Address2': 'Chicago', 'LocalCmte': '0', 'VendorZip': 'Quarterly', 'StateCmte': '8878', 'VendorLastOnlyName': '', 'RptPdEndDate': '8/3/2012 2:16 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '2260 S. Grove Street', 'VendorCity': ' ', 'Description': '', 'RcvDate': '150.00', 'RctType': '', 'CmteReferName': 'Dan Kotowski for State Senate', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '4/1/2012', 'RptPdBegDate': '6/30/2012', 'Occupation': ''} Error saving contribution on row 115145: invalid literal for int() with base 10: 'True' {'City': '', 'VendorAddress2': '', 'LocalID': 'True', 'Zip': 'IL', 'VendorAddress1': '', 'LastOnlyName': 'Mercado', 'State': 'North Riverside', 'CommitteeID': '21057', None: ['14554'], 'RptRcvdDate': '3/31/2012', 'CmteName': '0001', 'FirstName': 'Nelson', 'StateID': 'True', 'Address1': '2326 S. Westover', 'Address2': 'Ave', 'LocalCmte': '9692', 'VendorZip': ' ', 'StateCmte': '1st Ward Democratic Committeeman Fund', 'VendorLastOnlyName': '', 'RptPdEndDate': '1/1/2012', 'LoanAmount': '0.00', 'RptType': ' ', 'VendorState': '', 'VendorFirstName': '', 'Employer': '', 'VendorCity': '', 'Description': 'Individual Contribution', 'RcvDate': '3/1/2012', 'RctType': '60546 ', 'CmteReferName': '4/18/2012 2:07 PM', 'Amount': '250.00', 'ElectionType': 'Quarterly', 'ElectionYear': ' ', 'RptPdBegDate': ' ', 'Occupation': ''} Error saving contribution on row 115149: [u"'' value must be a decimal number."] {'City': '1547 N. Milwaukee', 'VendorAddress2': '', 'LocalID': '9692', 'Zip': 'Chicago', 'VendorAddress1': '', 'LastOnlyName': 'Travellers', 'State': '', 'CommitteeID': '21057', None: ['True', '14554'], 'RptRcvdDate': '1/1/2012', 'CmteName': '4/18/2012 2:07 PM', 'FirstName': 'Wine Bar', 'StateID': '1st Ward Democratic Committeeman Fund', 'Address1': '', 'Address2': '', 'LocalCmte': 'True', 'VendorZip': '', 'StateCmte': '0001', 'VendorLastOnlyName': 'Transfer In', 'RptPdEndDate': ' ', 'LoanAmount': '3/1/2012', 'RptType': ' ', 'VendorState': '', 'VendorFirstName': '', 'Employer': '0.00', 'VendorCity': '', 'Description': '60622 ', 'RcvDate': 'DBA J. Patricks Bucktown', 'RctType': 'IL', 'CmteReferName': '3/31/2012', 'Amount': '', 'ElectionType': ' ', 'ElectionYear': 'Quarterly', 'RptPdBegDate': ' ', 'Occupation': '200.00'} Error saving contribution on row 123527: [u"'2/15/2012' value must be a decimal number."] {'City': '', 'VendorAddress2': '', 'LocalID': 'True', 'Zip': 'IL', 'VendorAddress1': '', 'LastOnlyName': 'Law', 'State': 'Chicago', 'CommitteeID': '21057', None: ['14554'], 'RptRcvdDate': '3/31/2012', 'CmteName': '0001', 'FirstName': 'Offices Luis A. Aceces & Associates', 'StateID': 'True', 'Address1': '', 'Address2': '33 N. Dearborn St. #2201', 'LocalCmte': '9692', 'VendorZip': ' ', 'StateCmte': '1st Ward Democratic Committeeman Fund', 'VendorLastOnlyName': '', 'RptPdEndDate': '1/1/2012', 'LoanAmount': '250.00', 'RptType': ' ', 'VendorState': '', 'VendorFirstName': '', 'Employer': '', 'VendorCity': '', 'Description': 'Transfer In', 'RcvDate': '', 'RctType': '60602 ', 'CmteReferName': '4/18/2012 2:07 PM', 'Amount': '2/15/2012', 'ElectionType': 'Quarterly', 'ElectionYear': ' ', 'RptPdBegDate': ' ', 'Occupation': '0.00'} Error saving contribution on row 123565: [u"'2/14/2012' value must be a decimal number."] {'City': '', 'VendorAddress2': '', 'LocalID': 'True', 'Zip': 'IL', 'VendorAddress1': '', 'LastOnlyName': 'Michae lE.Sweeney', 'State': 'Chicago', 'CommitteeID': '21057', None: ['14554'], 'RptRcvdDate': '3/31/2012', 'CmteName': '0001', 'FirstName': '& Associates', 'StateID': 'True', 'Address1': '', 'Address2': '221 N. LaSalle #1748', 'LocalCmte': '9692', 'VendorZip': ' ', 'StateCmte': '1st Ward Democratic Committeeman Fund', 'VendorLastOnlyName': '', 'RptPdEndDate': '1/1/2012', 'LoanAmount': '500.00', 'RptType': ' ', 'VendorState': '', 'VendorFirstName': '', 'Employer': '', 'VendorCity': '', 'Description': 'Transfer In', 'RcvDate': '', 'RctType': '60601 ', 'CmteReferName': '4/18/2012 2:07 PM', 'Amount': '2/14/2012', 'ElectionType': 'Quarterly', 'ElectionYear': ' ', 'RptPdBegDate': ' ', 'Occupation': '0.00'} Error saving contribution on row 27593: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60527 ', 'CommitteeID': '& Vici', 'RptRcvdDate': 'Martwick R', 'CmteName': 'False', 'FirstName': '10/15/2013', 'StateID': 'True', 'Address1': 'Suite 300', 'Address2': 'Burr Ridge', 'LocalCmte': '10861', 'VendorZip': 'Quarterly', 'StateCmte': '0', 'VendorLastOnlyName': '', 'RptPdEndDate': '2/4/2014 8:14 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '999 McClintock Drive', 'VendorCity': ' ', 'Description': '', 'RcvDate': '1500.00', 'RctType': '', 'CmteReferName': 'Friends of Robert Martwick', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '10/1/2013', 'RptPdBegDate': '12/31/2013', 'Occupation': ''} Error saving contribution on row 35007: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60153 ', 'CommitteeID': 'IPAL Fund', 'RptRcvdDate': 'Martwick R', 'CmteName': 'False', 'FirstName': '9/30/2013', 'StateID': 'True', 'Address1': '', 'Address2': 'Broadview', 'LocalCmte': '10861', 'VendorZip': 'Quarterly', 'StateCmte': '0', 'VendorLastOnlyName': '', 'RptPdEndDate': '2/4/2014 8:12 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '2525 West Lexington Street', 'VendorCity': ' ', 'Description': '', 'RcvDate': '250.00', 'RctType': '', 'CmteReferName': 'Friends of Robert Martwick', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '7/1/2013', 'RptPdBegDate': '9/30/2013', 'Occupation': ''} Error saving contribution on row 76123: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60153 ', 'CommitteeID': 'IPAL Fund', 'RptRcvdDate': 'Martwick R', 'CmteName': 'False', 'FirstName': '5/29/2013', 'StateID': 'True', 'Address1': '', 'Address2': 'Broadview', 'LocalCmte': '10861', 'VendorZip': 'Quarterly', 'StateCmte': '0', 'VendorLastOnlyName': '', 'RptPdEndDate': '2/4/2014 8:12 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '2525 West Lexington Street', 'VendorCity': ' ', 'Description': '', 'RcvDate': '400.00', 'RctType': '', 'CmteReferName': 'Friends of Robert Martwick', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '4/1/2013', 'RptPdBegDate': '6/30/2013', 'Occupation': ''} Error saving contribution on row 14678: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Transfer In', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60527 ', 'CommitteeID': '& Vici', 'RptRcvdDate': 'Martwick R', 'CmteName': 'False', 'FirstName': '9/26/2014', 'StateID': 'True', 'Address1': 'Suite 300', 'Address2': 'Burr Ridge', 'LocalCmte': '10861', 'VendorZip': 'Quarterly', 'StateCmte': '0', 'VendorLastOnlyName': '', 'RptPdEndDate': '10/14/2014 9:00 AM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '999 McClintock Drive', 'VendorCity': ' ', 'Description': '', 'RcvDate': '1000.00', 'RctType': '', 'CmteReferName': 'Friends of Robert Martwick', 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '7/1/2014', 'RptPdBegDate': '9/30/2014', 'Occupation': ''} Error saving contribution on row 93130: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': '', 'LocalID': None, 'Zip': 'Individual Contribution', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60611 ', 'CommitteeID': "Lizzie Mc Neill's Inc.", 'RptRcvdDate': "O'Connor P", 'CmteName': 'False', 'FirstName': '3/6/2014', 'StateID': 'True', 'Address1': '', 'Address2': 'Chicago', 'LocalCmte': '809', 'VendorZip': 'Quarterly', 'StateCmte': '0', 'VendorLastOnlyName': '', 'RptPdEndDate': '6/8/2014 5:14 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': ' ', 'VendorFirstName': '', 'Employer': '400 N. McClurg Court', 'VendorCity': ' ', 'Description': '', 'RcvDate': '200.00', 'RctType': '', 'CmteReferName': "Citizens for Patrick O'Connor", 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '1/1/2014', 'RptPdBegDate': '3/31/2014', 'Occupation': ''} Error saving contribution on row 111580: [u"'' value must be a decimal number."] {'City': 'IL', 'VendorAddress2': 'NA', 'LocalID': None, 'Zip': 'In-kind Contribution', 'VendorAddress1': '', 'LastOnlyName': '', 'State': '60611 ', 'CommitteeID': "Lizzie Mc Neill's Inc.", 'RptRcvdDate': "O'Connor P", 'CmteName': 'False', 'FirstName': '1/14/2014', 'StateID': 'True', 'Address1': '', 'Address2': 'Chicago', 'LocalCmte': '809', 'VendorZip': 'Quarterly', 'StateCmte': '0', 'VendorLastOnlyName': '', 'RptPdEndDate': '6/8/2014 5:14 PM', 'LoanAmount': '', 'RptType': ' ', 'VendorState': '00000 ', 'VendorFirstName': 'NA', 'Employer': '400 N. McClurg Court', 'VendorCity': 'IL', 'Description': 'NA', 'RcvDate': '100.00', 'RctType': '4 $25 restaurant gift certificates', 'CmteReferName': "Citizens for Patrick O'Connor", 'Amount': '0.00', 'ElectionType': ' ', 'ElectionYear': '1/1/2014', 'RptPdBegDate': '3/31/2014', 'Occupation': ''}