europarks / trial_sm_company_numbers

trial_sm_company_numbers

Contributors europarks

Last run failed with status code 1.

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... Traceback (most recent call last): File "scraper.py", line 47, in <module> max_coe = scraperwiki.sqlite.select("max(CompanyNumber) as max_code from swdata") File "/app/.heroku/src/scraperwiki/scraperwiki/sqlite.py", line 41, in select result = dt.execute(sqlquery, data, commit = False) File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 136, in execute self.cursor.execute(sql, *args) sqlite3.OperationalError: no such table: swdata

Data

Downloaded 2 times by europarks

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (1.44 MB) Use the API

rows 10 / 9652

Status City CompanyName ScrapedTime Address PostalCode CompanyNumber LicenceCode
LICENCE CEASED
ACQUAVIVA
S.A. IDRAULICA S.I.DI SERRA GILBERTO
2013-04-27T16:58:40.864721
STRADA GENGHE DI ATTO, 0182
47892
2
LICENCES IN EFFECT
ACQUAVIVA
CARROZZERIA LA NUOVA DI BALDACCI LUCIANO
2013-04-27T16:58:43.166036
VIA BIAGIO DI SANTOLINO, 0068
47892
4
A S 31
LICENCE SUSPENDED
BORGO MAGGIORE
S.P.A. PHARMALAND
2013-04-27T16:58:44.145145
VIA VENTOTTO LUGLIO, 0218
47893
6
LICENCES IN EFFECT
DOMAGNANO
S.R.L. MEDUSA
2013-04-27T16:58:44.582954
VIA VENTICINQUE MARZO, 0011
47895
7
I S 174
LICENCE CEASED
SAN MARINO
TIS - TERMO IDRAULICA SAMMARINESE DI STEFANELLI DAVIDE
2013-04-27T16:58:45.125229
VIA CA' CACCIO, 0003
47890
8
LICENCE CEASED
SERRAVALLE
ME.SA DI TERENZI GIANFRANCO
2013-04-27T16:58:45.684469
STRADA BORRANA, 0035
47899
9
LICENCES IN EFFECT
SERRAVALLE
S.P.A. LIBRA
2013-04-27T16:58:46.233870
STRADA CARDIO, 0014
47899
10
I S 128
LICENCE CEASED
DOGANA
CASADEI LUIGI / SAN MARINO IMMOBILIARE
2013-04-27T16:58:48.745292
VIA ALFONSO GIANGI, 0004
47891
11
LICENCE CEASED
CHIESANUOVA
ERBA VITA DI BOLLINI CARLO
2013-04-27T16:58:49.828861
VIA DEI FAGGI, 0026
47894
13
LICENCE CEASED
SERRAVALLE
SAN MARINO BABY SHOP DI ZAFFERANI LUIGI
2013-04-27T16:58:51.258265
VIA PITTULO ORSO, 0061
47899
16

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (1.44 MB) Use the API

rows 1 / 1

value_blob type name
97114
int
last_page

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 1.46 MB

History

  • Manually ran revision 41ec7c17 and failed .
    nothing changed in the database
  • Created on morph.io