evertr / 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 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 10 times by caribtraveler sachin124a shivrajp MikeRalphson preken zhixiong86

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

Scraper code

Python

tripadvisor / scraper.py