europarks / trial_sm_company_numbers

trial_sm_company_numbers


List of company numbers of San Marino, extracted from the Official Registry: https://registroimprese.cc.sm .
In San Marino, the Company Number is the C.O.E. (Codice Operatore Economico) a 5 number code. The scraper has queried the register for all the 100000 possible codes, ensuring that it has a complete list of all San Marino Companies. Now it checks at each only the numbers after the last company scraped, to ensure that the list remains updated.
Given a COE (company number), for example 23883, the corresponding search results is: https://registroimprese.cc.sm/ricerca.asp?imp_coe=23883

Forked from ScraperWiki

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
  • Forked from ScraperWiki

Scraper code

Python

trial_sm_company_numbers / scraper.py