paulbradshaw / birminghamcouncilexpenditure_2nd

BirminghamCouncilExpenditure_2nd


Forked from ScraperWiki

Contributors paulbradshaw

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

Download table (as CSV) Download SQLite database (3 KB) Use the API

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

History

  • Manually ran revision f2b65da0 and failed .
    1 record added, 1 record removed in the database
  • Manually ran revision 13062fc6 and failed .
    1 record added in the database
  • Manually ran revision f4a1e112 and failed .
    1 record added, 143 records updated in the database
  • Forked from ScraperWiki