evertr / tripadvisor_1

Tripadvisor TH


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 2 times by jlondal MikeRalphson

To download data sign in with GitHub

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

rows 10 / 2481

rating description price number_of_ratings telephone source_url address email name
5.0
32 Reviews
+66 (0) 85 904 6996
Charoen Krung Road, Chinatown, Bangkok, Bangkok 10100 , Thailand
nangginkui@gmail.com
Nang Gin Kui - Bangkok Private Dining
5.0
40 Reviews
+66 853413531
80 Samsen soi 2, Baan Pan Thong,Phra Nakhon, Bangkok, Thailand
[]
Snack Bar Bkk
5.0
23 Reviews
0800527336
Sukhumvit 21 Soi 2, Bangkok, Thailand
[]
Chef Bar
5.0
73 Reviews
(+66)2 632 9513
Soi Patpong 2, Silom Rd., Bangkok 10500, Thailand
[]
G's Bangkok
4.5
172 Reviews
66-02.6299214
22-24 Chakkrapatipong Road | Near the intersection of Jor Por Ror (JPR) and Chakkrapatipong Road., Bangkok 10100, Thailand
[]
Seven Spoons Bar and Restaurant
5.0
89 Reviews
022584247
59/1 Sukhumvit Road Soi 31,Klongtoey,Wattana | Between Soi 23 and Soi 31(Soi Sawadee), Bangkok, Thailand
[]
JP French Restaurant
4.5
140 Reviews
+66 2 637 9541
56/3 Pan Street, Silom | 100m from Myanmar Embassy, Bangkok, Thailand
bonita.c.sc@gmail.com
Bonita Cafe and Social Club
5.0
30 Reviews
92 Rambuttri Bangkok | Taradyod Pranakorn, Bangkok, Thailand
[]
Moka Coffee & Gallery
5.0
27 Reviews
598/66 Asoke-Dindaeng Road | 10 min walk from MRT Phra Ram 9 station, Bangkok, Thailand
[]
Fatty's Bar and Diner
4.5
122 Reviews
006621605188
Chamchuri Square, 2nd floor | Samyan, Bangkok, Thailand
chamchuri@mywaterlibrary.com
Water Library

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 1.29 MB

History

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

Scraper code

Python

tripadvisor_1 / scraper.py