evertr / tripadvisor

St.Petersburg


Contributors evertr

Last run failed with status code 1.

Console output of last run

Starting On page http://www.tripadvisor.com/RestaurantSearch?geo=186605&o=a0&sortOrder=popularity Url: http://www.tripadvisor.com/Restaurant_Review-g186605-d1829776-Reviews-Sabor_Brazil-Dublin_County_Dublin.html [] Traceback (most recent call last): File "/repo/scraper.py", line 90, in <module> parse_listing_pages(start_url) File "/repo/scraper.py", line 85, in parse_listing_pages parse_list(root) File "/repo/scraper.py", line 68, in parse_list scraperwiki.sqlite.save(unique_keys=['source_url'], data=data, table_name="tripadvisor_SOT") File "/usr/local/lib/python2.7/dist-packages/scraperwiki-0.3.7-py2.7.egg/scraperwiki/sqlite.py", line 34, in save return dt.upsert(data, table_name = table_name) File "/usr/local/lib/python2.7/dist-packages/dumptruck-0.1.5-py2.7.egg/dumptruck/dumptruck.py", line 301, in upsert self.insert(upsert=True, *args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/dumptruck-0.1.5-py2.7.egg/dumptruck/dumptruck.py", line 284, in insert self.execute(sql, values, commit=False) File "/usr/local/lib/python2.7/dist-packages/dumptruck-0.1.5-py2.7.egg/dumptruck/dumptruck.py", line 138, in execute raise self.sqlite3.InterfaceError(unicode(msg) + '\nTry converting types or pickling.') sqlite3 . InterfaceError : Error binding parameter 6 - probably unsupported type. Try converting types or pickling.

Data

Downloaded 12 times by caribtraveler sachin124a shivrajp MikeRalphson preken zhixiong86 smoothquark AdiPersonalWorks

To download data sign in with GitHub

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

rows 10 / 6370

rating description price number_of_ratings telephone source_url address email name
rating
5.0
description
price
number_of_ratings
40 Reviews
telephone
+(65)62980708
source_url address
269 Beach Road, Singapore 199546, Singapore
email
reservations@noxdineinthedark.com
name
NOX - Dine in the Dark
rating
4.5
description
price
number_of_ratings
65 Reviews
telephone
6338-6131
source_url address
1 Beach Road | #02-20 Raffles Hotel, Singapore 189673 , Singapore
email
reservations@shinjikanesaka.com
name
Shinji by Kanesaka
rating
5.0
description
price
number_of_ratings
34 Reviews
telephone
65 63372201
source_url address
30 Victoria Street | Chijmes - #01-08, Singapore 187996 , Singapore
email
[]
name
Auld Alliance
rating
4.5
description
price
number_of_ratings
142 Reviews
telephone
+65 9199 9008
source_url address
2 Stamford Road | Level 70, Equinox Complex, Swissotel The Stamford, Singapore 178882, Singapore
email
reservations@equinoxcomplex.com
name
Jaan
rating
4.5
description
price
number_of_ratings
97 Reviews
telephone
65-68853551
source_url address
Mandarin Oriental | 5 Raffles Avenue, Marina Square, Singapore 039797, Singapore
email
dolcevita@mohg.com
name
Dolce Vita at Mandarin Oriental, Singapore
rating
4.5
description
price
number_of_ratings
137 Reviews
telephone
65-62220089
source_url address
54 & 56 Club Street, Singapore 069431, Singapore
email
enquiry@noti.asia
name
Noti Restaurant & Bar
rating
4.5
description
price
number_of_ratings
111 Reviews
telephone
(65) 6831 6686
source_url address
10 Claymore Road | Pan Pacific Orchard Hotel, Singapore, Singapore
email
[]
name
10 at Claymore
rating
4.5
description
price
number_of_ratings
249 Reviews
telephone
+6565897799
source_url address
25, Scotts Road Singapore 228220, Singapore 228220, Singapore
email
webcarousel@royalplaza.com.sg
name
Carousel, Royal Plaza on Scotts
rating
5.0
description
price
number_of_ratings
11 Reviews
telephone
source_url address
40 Pekin Street, #01-01 | Far East Square, Singapore, Singapore
email
[]
name
Intrepid Gastrobar
rating
4.5
description
price
number_of_ratings
90 Reviews
telephone
(65)6737 1160
source_url address
22 Scotts Road Goodwood Park Hotel, Singapore 228221, Singapore
email
[]
name
Tatsuya

Statistics

Total run time: less than 10 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 3.33 MB

History

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

Scraper code

tripadvisor