evertr / manila2

Manila


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=1758900&o=a0&sortOrder=popularity Url: http://www.tripadvisor.com/Restaurant_Review-g1758900-d6872950-Reviews-Kuya_s_At_The_Fort_Jed_Julian_s-Taguig_City_Metro_Manila_Luzon.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 (1.11 MB) Use the API

rows 10 / 1948

rating description price number_of_ratings telephone source_url address email name
4.0
More info
G/F Joya Bldg., Joya Drive, Rockwell Makati City, Manila, Luzon, Philippines
[]
LULU Restaurant
4.5
More info
899 Pres. Quirino Ave. | cor. Leon Guinto St., Manila, Luzon, Philippines
[]
Lolo Dad's Cafe
4.0
More info
(02) 523 0189
Julio Nakpil St., Manila, Luzon, Philippines
[]
Casa Armas
4.0
More info
(02) 833 7595
P Ocampo Sr St | Coconut Palace, Manila, Luzon, Philippines
[]
Figaro Coffee
4.0
More info
63 2 567 3512
2nd Floor, Manila Ocean Park | behind Quirino Grandstand, Manila, Luzon, Philippines (Formerly Makansutra Asian Food Village)
[]
Makan Makan Asian Food Village
4.0
More info
Pablo Ocampo Sr, Manila, Luzon, Philippines
[]
Century Park Seafood Restaurant
4.0
More info
02) 536-78-39
Robinson's Ermita | Ground Floor, Manila, Luzon, Philippines
[]
Jollibee
4.0
More info
6325420196
Connecticut, Greenhills | San Juan, Manila, Luzon 1502, Philippines
[]
Lugang Cafe
4.5
More info
(02) 374 0774
195 T Morato Ave | Quezon City, Manila, Luzon, Philippines
[]
Restaurant Uno
4.0
More info
06325238510
1170 Roxas Boulevard | Ermita, Manila, Luzon, Philippines
[]
Emerald Garden

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 1.13 MB

History

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

Scraper code

Python

manila2 / scraper.py