gistfile1.txt

(env)➜  utils  python import_revenue.py        
2015-02-06 10:17:57,664 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2015-02-06 10:17:57,664 INFO sqlalchemy.engine.base.Engine ()
2015-02-06 10:17:57,664 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2015-02-06 10:17:57,664 INFO sqlalchemy.engine.base.Engine ()
2015-02-06 10:17:57,665 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2015-02-06 10:17:57,686 INFO sqlalchemy.engine.base.Engine INSERT INTO revenue (code, description, date, monthly_predicted, monthly_outcome, economical_category, economical_subcategory, source, rubric, paragraph, subparagraph) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2015-02-06 10:17:57,686 INFO sqlalchemy.engine.base.Engine (u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-01-31', 235916333.33, 78548657.4, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-02-29', 235916333.33, 825577756.8, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-03-31', 235916333.33, 244987716.21, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-04-30', 235916333.33, 218645634.86, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-05-31', 235916333.33, 184188431.88, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-06-30', 235916333.33, 204342805.87, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-07-31', 235916333.33, 206134851.71, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-08-31', 235916333.33, 195116856.45, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-09-30', 235916333.33, 204447184.93, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-10-31', 235916333.33, 201442610.35, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-11-30', 235916333.33, 183072423.13, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-12-31', 235916333.33, 45803509.95, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-01-31', 11130250.0, 3167489.73, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-02-29', 11130250.0, 41884378.39, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-03-31', 11130250.0, 19903620.92, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-04-30', 11130250.0, 64613.71, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-05-31', 11130250.0, 14464750.89, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-06-30', 11130250.0, 8737740.83, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-07-31', 11130250.0, 8492051.76, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-08-31', 11130250.0, 7530991.91, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-09-30', 11130250.0, 8511892.31, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-10-31', 11130250.0, 8034572.04, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-11-30', 11130250.0, 7352505.98, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-12-31', 11130250.0, 2385657.25, 1, 1, 1, 2, 2, 2, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-01-31', 47250000.0, 50455762.09, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-02-29', 47250000.0, 46982481.96, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-03-31', 47250000.0, 49941194.74, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-04-30', 47250000.0, 50291932.12, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-05-31', 47250000.0, 67260591.69, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-06-30', 47250000.0, 58029895.95, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-07-31', 47250000.0, 53250170.17, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-08-31', 47250000.0, 61692861.69, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-09-30', 47250000.0, 60697033.84, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-10-31', 47250000.0, 55828321.26, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-11-30', 47250000.0, 59860859.31, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-12-31', 47250000.0, 119515181.33, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-01-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-02-29', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-03-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-04-30', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-05-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-06-30', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-07-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-08-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-09-30', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-10-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-11-30', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-12-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-01-31', 8750000.0, 8145249.38, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-02-29', 8750000.0, 8136504.22, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-03-31', 8750000.0, 8836821.23, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-04-30', 8750000.0, 7988418.44, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-05-31', 8750000.0, 7929779.98, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-06-30', 8750000.0, 7600766.46, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-07-31', 8750000.0, 8744816.84, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-08-31', 8750000.0, 9508845.22, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-09-30', 8750000.0, 7009007.15, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-10-31', 8750000.0, 10086931.97, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-11-30', 8750000.0, 8098495.51, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-12-31', 8750000.0, 16589773.79, 1, 1, 1, 2, 4, 34, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-01-31', 45620833.33, 47114185.67, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-02-29', 45620833.33, 44986284.91, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-03-31', 45620833.33, 53773712.48, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-04-30', 45620833.33, 73645811.46, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-05-31', 45620833.33, 59386807.86, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-06-30', 45620833.33, 59645148.58, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-07-31', 45620833.33, 65345114.75, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-08-31', 45620833.33, 61085329.26, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-09-30', 45620833.33, 63233223.66, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-10-31', 45620833.33, 62378012.46, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-11-30', 45620833.33, 51466093.82, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-12-31', 45620833.33, 67798134.6, 1, 1, 1, 2, 8, None, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-01-31', 410000000.0, 484884286.25, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-02-29', 410000000.0, 377723803.47, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-03-31', 410000000.0, 379403740.68, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-04-30', 410000000.0, 420512964.33, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-05-31', 410000000.0, 414646716.93, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-06-30', 410000000.0, 413761129.48, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-07-31', 410000000.0, 471137223.77, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-08-31', 410000000.0, 441533898.46, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-09-30', 410000000.0, 432926213.98, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-10-31', 410000000.0, 471567638.99, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-11-30', 410000000.0, 458534578.6, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-12-31', 410000000.0, 509016988.54, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-01-31', 791666.67, 150133.04, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-02-29', 791666.67, 158864.05, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-03-31', 791666.67, 84803.1, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-04-30', 791666.67, 1098793.71, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-05-31', 791666.67, 134820.18, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-06-30', 791666.67, 199380.85, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-07-31', 791666.67, 434310.7, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-08-31', 791666.67, 132465.72, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-09-30', 791666.67, 129152.1, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-10-31', 791666.67, 304909.89, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-11-30', 791666.67, 157339.05, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-12-31', 791666.67, 97558.27, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.03', u'ISS - CMSP', '2008-01-31', 17916.67, 0.0, 1, 1, 1, 3, 5, 3, u'1.1.1.3.05.03', u'ISS - CMSP', '2008-02-29', 17916.67, 0.0, 1, 1, 1, 3, 5, 3, u'1.1.1.3.05.03', u'ISS - CMSP', '2008-03-31', 17916.67, 0.0, 1, 1, 1, 3, 5, 3, u'1.1.1.3.05.03', u'ISS - CMSP', '2008-04-30', 17916.67, 0.0, 1, 1, 1, 3, 5, 3)
Traceback (most recent call last):
  File "import_revenue.py", line 41, in <module>
    insert_rows(to_insert)
  File "import_revenue.py", line 30, in insert_rows
    db.session.execute(ins)
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/orm/scoping.py", line 150, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/orm/session.py", line 991, in execute
    bind, close_with_result=True).execute(clause, params or {})
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 729, in execute
    return meth(self, multiparams, params)
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
    exc_info
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/home/andres/manuscritos/gastos-abertos/env/lib/python2.7/site-packages/SQLAlchemy-0.9.8-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (OperationalError) too many SQL variables u'INSERT INTO revenue (code, description, date, monthly_predicted, monthly_outcome, economical_category, economical_subcategory, source, rubric, paragraph, subparagraph) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-01-31', 235916333.33, 78548657.4, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-02-29', 235916333.33, 825577756.8, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-03-31', 235916333.33, 244987716.21, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-04-30', 235916333.33, 218645634.86, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-05-31', 235916333.33, 184188431.88, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-06-30', 235916333.33, 204342805.87, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-07-31', 235916333.33, 206134851.71, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-08-31', 235916333.33, 195116856.45, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-09-30', 235916333.33, 204447184.93, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-10-31', 235916333.33, 201442610.35, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-11-30', 235916333.33, 183072423.13, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPRIEDADE PREDIAL', '2008-12-31', 235916333.33, 45803509.95, 1, 1, 1, 2, 2, 1, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-01-31', 11130250.0, 3167489.73, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-02-29', 11130250.0, 41884378.39, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-03-31', 11130250.0, 19903620.92, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-04-30', 11130250.0, 64613.71, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-05-31', 11130250.0, 14464750.89, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-06-30', 11130250.0, 8737740.83, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-07-31', 11130250.0, 8492051.76, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-08-31', 11130250.0, 7530991.91, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-09-30', 11130250.0, 8511892.31, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-10-31', 11130250.0, 8034572.04, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-11-30', 11130250.0, 7352505.98, 1, 1, 1, 2, 2, 2, u'1.1.1.2.02.02', u'IMPOSTO S/ A PROPRIEDADE TERRITORIAL URBANA', '2008-12-31', 11130250.0, 2385657.25, 1, 1, 1, 2, 2, 2, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-01-31', 47250000.0, 50455762.09, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-02-29', 47250000.0, 46982481.96, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-03-31', 47250000.0, 49941194.74, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-04-30', 47250000.0, 50291932.12, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-05-31', 47250000.0, 67260591.69, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-06-30', 47250000.0, 58029895.95, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-07-31', 47250000.0, 53250170.17, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-08-31', 47250000.0, 61692861.69, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-09-30', 47250000.0, 60697033.84, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-10-31', 47250000.0, 55828321.26, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-11-30', 47250000.0, 59860859.31, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.31', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OS RENDIMENTOS DO TRABALHO', '2008-12-31', 47250000.0, 119515181.33, 1, 1, 1, 2, 4, 31, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-01-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-02-29', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-03-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-04-30', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-05-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-06-30', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-07-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-08-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-09-30', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-10-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-11-30', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.33', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ REMESSA DE RECURSOS AO EXTERIOR', '2008-12-31', 0.0, 0.0, 1, 1, 1, 2, 4, 33, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-01-31', 8750000.0, 8145249.38, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-02-29', 8750000.0, 8136504.22, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-03-31', 8750000.0, 8836821.23, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-04-30', 8750000.0, 7988418.44, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-05-31', 8750000.0, 7929779.98, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-06-30', 8750000.0, 7600766.46, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-07-31', 8750000.0, 8744816.84, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-08-31', 8750000.0, 9508845.22, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-09-30', 8750000.0, 7009007.15, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-10-31', 8750000.0, 10086931.97, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-11-30', 8750000.0, 8098495.51, 1, 1, 1, 2, 4, 34, u'1.1.1.2.04.34', u'IMPOSTO DE RENDA RETIDO NAS FONTES S/ OUTROS RENDIMENTOS', '2008-12-31', 8750000.0, 16589773.79, 1, 1, 1, 2, 4, 34, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-01-31', 45620833.33, 47114185.67, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-02-29', 45620833.33, 44986284.91, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-03-31', 45620833.33, 53773712.48, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-04-30', 45620833.33, 73645811.46, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-05-31', 45620833.33, 59386807.86, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-06-30', 45620833.33, 59645148.58, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-07-31', 45620833.33, 65345114.75, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-08-31', 45620833.33, 61085329.26, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-09-30', 45620833.33, 63233223.66, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-10-31', 45620833.33, 62378012.46, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-11-30', 45620833.33, 51466093.82, 1, 1, 1, 2, 8, None, u'1.1.1.2.08', u'IMPOSTO S/ TRANSMISS\xc3O  INTER-VIVOS  DE BENS IM\xd3VE', '2008-12-31', 45620833.33, 67798134.6, 1, 1, 1, 2, 8, None, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-01-31', 410000000.0, 484884286.25, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-02-29', 410000000.0, 377723803.47, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-03-31', 410000000.0, 379403740.68, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-04-30', 410000000.0, 420512964.33, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-05-31', 410000000.0, 414646716.93, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-06-30', 410000000.0, 413761129.48, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-07-31', 410000000.0, 471137223.77, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-08-31', 410000000.0, 441533898.46, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-09-30', 410000000.0, 432926213.98, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-10-31', 410000000.0, 471567638.99, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-11-30', 410000000.0, 458534578.6, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.01', u'IMPOSTO SOBRE SERVI\xc7OS DE QUALQUER NATUREZA', '2008-12-31', 410000000.0, 509016988.54, 1, 1, 1, 3, 5, 1, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-01-31', 791666.67, 150133.04, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-02-29', 791666.67, 158864.05, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-03-31', 791666.67, 84803.1, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-04-30', 791666.67, 1098793.71, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-05-31', 791666.67, 134820.18, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-06-30', 791666.67, 199380.85, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-07-31', 791666.67, 434310.7, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-08-31', 791666.67, 132465.72, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-09-30', 791666.67, 129152.1, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-10-31', 791666.67, 304909.89, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-11-30', 791666.67, 157339.05, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.02', u'ISS - SISTEMA INTEGRADO - SIMPLES', '2008-12-31', 791666.67, 97558.27, 1, 1, 1, 3, 5, 2, u'1.1.1.3.05.03', u'ISS - CMSP', '2008-01-31', 17916.67, 0.0, 1, 1, 1, 3, 5, 3, u'1.1.1.3.05.03', u'ISS - CMSP', '2008-02-29', 17916.67, 0.0, 1, 1, 1, 3, 5, 3, u'1.1.1.3.05.03', u'ISS - CMSP', '2008-03-31', 17916.67, 0.0, 1, 1, 1, 3, 5, 3, u'1.1.1.3.05.03', u'ISS - CMSP', '2008-04-30', 17916.67, 0.0, 1, 1, 1, 3, 5, 3)

Me passe o arquivo que está tentando inserir. Esse erro indica que tem mais values do que colunas. O argumento (u'1.1.1.2.02.01', u'IMPOSTO S/ A PROPR ... possui um número não múltiplo do número de colunas.