paulbradshaw / birminghamcouncilexpenditure_2nd
BirminghamCouncilExpenditure_2nd
Contributors
Last run failed
with status code 1.
Console output of last run
Injecting configuration and compiling...
Injecting scraper and running...
<_csv.reader object at 0x27609f0>
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
{'ID': 1, 'funding': 'Actual Funding Award', 'end_date': 'End Date', 'start_date': 'Start Date', 'status': 'Grant Status', 'directorate': 'BCC Directorate', 'organisation': 'Organisation Name', 'revised_end': 'Revised End Date', 'ref': 'Ref. No.'}
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
<type 'str'>
{'ID': 2, 'funding': '\xa3', 'end_date': '30.09.2014', 'start_date': '29.11.2012', 'status': 'Approved', 'directorate': 'Adults & Communities', 'organisation': 'ADVOCACY MATTERS LTD', 'revised_end': '', 'ref': '1000706'}
Traceback (most recent call last):
File "scraper.py", line 41, in <module>
scraperwiki.sqlite.save(['ID'], record)
File "/app/.heroku/src/scraperwiki/scraperwiki/sqlite.py", line 34, in save
return dt.upsert(data, table_name = table_name)
File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 301, in upsert
self.insert(upsert=True, *args, **kwargs)
File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 284, in insert
self.execute(sql, values, commit=False)
File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 136, in execute
self.cursor.execute(sql, *args)
sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings.
Data
Downloaded 0 times
To download data sign in with GitHub
rows 1 / 1
| end_date | ID | revised_end | funding | status | start_date | directorate | ref | organisation |
|---|---|---|---|---|---|---|---|---|
|
End Date
|
1
|
Revised End Date
|
Actual Funding Award
|
Grant Status
|
Start Date
|
BCC Directorate
|
Ref. No.
|
Organisation Name
|
Statistics
Total run time: less than 20 seconds
Total cpu time used: less than 5 seconds
Total disk space used: 26.4 KB