evertr / tripadvisor_almaty_1

Tripadvisor Almaty


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 1 time by MikeRalphson

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (59 KB) Use the API

rows 10 / 119

rating description price number_of_ratings telephone source_url address email name
5.0
1 Review
777 971 07 71
68, Zheltoksan St., corner Alimzhanova St., Almaty 050004, Kazakhstan
[]
Uzbechka
5.0
1 Review
+7701-784-77-50
Furmanova St., 44, Almaty, Kazakhstan
[]
Genatsvale
4.0
9 Reviews
75 Shevchenko, Almaty, Kazakhstan
[]
Dastarkhan
3.5
10 Reviews
+7 (727) 272 04 41
Kabanbay Batyr St., 83, Almaty 050000, Kazakhstan
[]
Del Papa
4.0
7 Reviews
13A Tulebayeva Street, Almaty, Kazakhstan
[]
Ozyurt Turkish Restaurant
3.5
10 Reviews
7 727 2642971
Mendikulova, Almaty, Kazakhstan
[]
Pomodoro
4.0
7 Reviews
15 Zhibek Zholy Street | Nearest Cross Street is Vagibayev St., Almaty, Kazakhstan
[]
Sancak Restaurant
4.5
6 Reviews
Zenkova St, Almaty, Kazakhstan
[]
Beirut
4.0
7 Reviews
11/6, Iskendirova str., Almaty, Kazakhstan
[]
Borgo Antico
3.5
27 Reviews
Seyfulina Mamedova, Almaty, Kazakhstan
[]
Esperanza

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 82.1 KB

History

  • Manually ran revision f9dc534f and failed .
    nothing changed in the database
  • Forked from ScraperWiki

Scraper code

Python

tripadvisor_almaty_1 / scraper.py