badboyilprimo / tripadvisor

St.Petersburg


To change the city:

  1. go to www.tripadvisor.com
  2. search for the respective city
  3. copy geoID; e.g. http://www.tripadvisor.de/RestaurantSearch?geo= 294265
  4. paste the id into the scraper link in line 88

NOTE: only change the geoID

Forked from ScraperWiki

Contributors badboyilprimo

Last run failed with status code 1.

Console output of last run

Starting On page http://www.tripadvisor.com/RestaurantSearch?geo=187147&o=a0&sortOrder=popularity Url: http://www.tripadvisor.com/Restaurant_Review-g187147-d719052-Reviews-Epicure-Paris_Ile_de_France.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 2 times by MikeRalphson preken

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

Scraper code

Python

tripadvisor / scraper.py