smkrohn / ta_exp2

St.Petersburg


Last run failed with status code 1.

Console output of last run

Starting On page http://www.tripadvisor.com/RestaurantSearch?geo=298184&o=a0&sortOrder=popularity Url: http://www.tripadvisor.com/Restaurant_Review-g1066854-d1692134-Reviews-Sushiryori_Inose-Shinagawa_Tokyo_Tokyo_Prefecture_Kanto.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 1 time by MikeRalphson

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 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 3.33 MB

History

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

Scraper code

ta_exp2