blablupcom / sp_E3620_SCC_gov

Contributors woodbine blablupcom

Last run completed successfully .

Console output of last run

Injecting configuration and compiling...  -----> Python app detected -----> Installing python-2.7.6  $ pip install -r requirements.txt  Obtaining scraperwiki from git+http://github.com/openaustralia/scraperwiki-python.git@morph_defaults#egg=scraperwiki (from -r requirements.txt (line 1))  Cloning http://github.com/openaustralia/scraperwiki-python.git (to morph_defaults) to ./.heroku/src/scraperwiki  Collecting lxml==3.4.4 (from -r requirements.txt (line 2))  /app/.heroku/python/lib/python2.7/site-packages/pip-8.1.2-py2.7.egg/pip/_vendor/requests/packages/urllib3/util/ssl_.py:318: SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause validation failures. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#snimissingwarning.  SNIMissingWarning  /app/.heroku/python/lib/python2.7/site-packages/pip-8.1.2-py2.7.egg/pip/_vendor/requests/packages/urllib3/util/ssl_.py:122: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.  InsecurePlatformWarning  Downloading lxml-3.4.4.tar.gz (3.5MB)  Collecting cssselect==0.9.1 (from -r requirements.txt (line 3))  Downloading cssselect-0.9.1.tar.gz  Collecting beautifulsoup4 (from -r requirements.txt (line 4))  Downloading beautifulsoup4-4.5.1-py2-none-any.whl (83kB)  Collecting python-dateutil (from -r requirements.txt (line 5))  Downloading python_dateutil-2.6.0-py2.py3-none-any.whl (194kB)  Collecting dumptruck>=0.1.2 (from scraperwiki->-r requirements.txt (line 1))  Downloading dumptruck-0.1.6.tar.gz  Collecting requests (from scraperwiki->-r requirements.txt (line 1))  Downloading requests-2.12.3-py2.py3-none-any.whl (575kB)  Collecting six>=1.5 (from python-dateutil->-r requirements.txt (line 5))  Downloading six-1.10.0-py2.py3-none-any.whl  Installing collected packages: dumptruck, requests, scraperwiki, lxml, cssselect, beautifulsoup4, six, python-dateutil  Running setup.py install for dumptruck: started  Running setup.py install for dumptruck: finished with status 'done'  Running setup.py develop for scraperwiki  Running setup.py install for lxml: started  Running setup.py install for lxml: still running...  Running setup.py install for lxml: finished with status 'done'  Running setup.py install for cssselect: started  Running setup.py install for cssselect: finished with status 'done'  Successfully installed beautifulsoup4-4.5.1 cssselect-0.9.1 dumptruck-0.1.6 lxml-3.4.4 python-dateutil-2.6.0 requests-2.12.3 scraperwiki six-1.10.0   ! Hello! It looks like your application is using an outdated version of Python.  ! This caused the security warning you saw above during the 'pip install' step.  ! We recommend 'python-2.7.12', which you can specify in a 'runtime.txt' file.  ! -- Much Love, Heroku.   -----> Discovering process types  Procfile declares types -> scraper Injecting scraper and running... E3620_SCC_gov_2015_Q1 E3620_SCC_gov_2016_Q1 E3620_SCC_gov_2014_Q4 E3620_SCC_gov_2015_Q4 E3620_SCC_gov_2015_Q2 E3620_SCC_gov_2016_Q2 E3620_SCC_gov_2014_Q3 E3620_SCC_gov_2015_Q3

Data

Downloaded 2 times by MikeRalphson woodbine

To download data sign in with GitHub

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

rows 10 / 19

l d f
http://www.surreycc.gov.uk/__data/assets/file/0017/43154/Q3-expenditure-exceeding-500.csv
2015-11-23 23:01:35.498479
E3620_SCC_gov_2014_Q4
http://www.surreycc.gov.uk/__data/assets/file/0007/34387/1415-Q2-Expenditure-exceeding-500-Final-reviewed.csv
2015-11-23 23:01:37.393289
E3620_SCC_gov_2014_Q3
http://www.surreycc.gov.uk/__data/assets/file/0018/50445/1415-Q1-Procurement-spend-above-500-pounds.csv
2015-11-23 23:01:39.271040
E3620_SCC_gov_2014_Q2
http://www.surreycc.gov.uk/__data/assets/file/0009/52596/Surrey-Q1-Spend-over-500-pounds-April-to-June-2013-for-Publication-Final.csv
2015-11-23 23:01:41.250666
E3620_SCC_gov_2013_Q2
http://www.surreycc.gov.uk/__data/assets/file/0020/52625/Surrey-Q2-Spend-over-500-pounds-July-to-Sept-2013-for-publication-final.csv
2015-11-23 23:01:42.901819
E3620_SCC_gov_2013_Q3
http://www.surreycc.gov.uk/__data/assets/file/0006/52629/Surrey-Q3-Spend-Publication-over-500-pounds-Oct-to-Dec-2013-for-publication-final.csv
2015-11-23 23:01:44.380662
E3620_SCC_gov_2013_Q4
http://www.surreycc.gov.uk/__data/assets/file/0006/52638/Surrey-Q4-Spend-publication-over-500-pounds-Jan-to-Mar-2014-for-publication-final.csv
2015-11-23 23:01:46.101955
E3620_SCC_gov_2014_Q1
http://www.surreycc.gov.uk/__data/assets/file/0018/52641/Surrey-Q1-12-13-Spend-Publication-April-to-June-2012-for-publication-final.csv
2015-11-23 23:01:47.947753
E3620_SCC_gov_2012_Q2
http://www.surreycc.gov.uk/__data/assets/file/0003/52644/Surrey-Q3-Spend-Publication-Oct-to-Dec-for-publication-final.csv
2015-11-23 23:01:49.544806
E3620_SCC_gov_2012_Q4
http://www.surreycc.gov.uk/__data/assets/file/0005/52646/Surrey-Q4-Spend-Publication-Jan-to-March-2013-for-publication-final.csv
2015-11-23 23:01:51.160364
E3620_SCC_gov_2013_Q1

Statistics

Average successful run time: 2 minutes

Total run time: 4 minutes

Total cpu time used: less than 5 seconds

Total disk space used: 38.1 KB

History

  • Manually ran revision ecad167a and completed successfully .
    8 records added in the database
  • Manually ran revision 362a9bfa and failed .
    nothing changed in the database
    2 pages scraped
  • Manually ran revision 362a9bfa and completed successfully .
    11 records added in the database
    16 pages scraped
  • Created on morph.io

Scraper code

Python

sp_E3620_SCC_gov / scraper.py