evertr / tripadvisor
St.Petersburg
To change the city:
- go to www.tripadvisor.com
- search for the respective city
- copy geoID; e.g. http://www.tripadvisor.de/RestaurantSearch?geo= 294265
- paste the id into the scraper link in line 88
NOTE: only change the geoID
Forked from ScraperWiki
Contributors
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
11 times
by
To download data sign in with GitHub
rows 10 / 6370
| rating | description | price | number_of_ratings | telephone | source_url | address | 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