Closed

Scrape all the Google Local NYC restaurant reviews

End product, three databases (preferably in microsoft access)

Database 1: Restaurants

- each row is a single restaurant. Must include all New York City Restaurants, Bars and Cafes in Google Local

- Columns:

* Restaurant unique ID (created by the freelancer in order to allow matching between databases)

* Restaurant's name

* Restaurant's latitude coordinates (for google maps)

* Restaurant's longitude coordinates (for google maps)

* Restaurant's address

* Restaurant's website

* Restaurant's phone number

* Restaurant's number of "$"

* Restaurant’s category

* Restaurant's Zagat review text (if available)

* Restaurant's "Zagat FOOD Score" number (if available)

* Restaurant's "Zagat DECOR Score" number (if available)

* Restaurant's "Zagat SERVICE Score" number (if available)

* Restaurant's "Zagat Cost" in US$ (if available)

* Restaurant's OpenTable URL (if available)

Database 2: Reviews

- each row is a single review of a restaurant. Must include all reviews of Google Local for New York City Restaurants, Bars and Cafes

- Columns:

* Review unique ID (only one per review, created by freelancer)

* Restaurant unique ID (must match unique ID of restaurant database)

* Reviewers unique ID (must match unique ID of Reviewers database)

* Review date

* Reviewers "Overall" Score on the rating (number of stars)

* Reviewers "Food" Score on the rating (number of stars)

* Reviewers "Decor" Score on the rating (number of stars)

* Reviewers "Service" Score on the rating (number of stars)

* Text on review

Database 3: Reviewers

- each row is a single reviewer. Must include all Google users that have made a review of a New York City Restaurant

- Columns:

* Reviewers unique ID (created by the freelancer in order to allow matching between databases)

* Reviewers name

* Reviewers current place (where is he from?) (if publicly available)

* Reviewers gender (if publicly available)

* Reviewers Google+ URL (if publicly available)

* Reviewers twitter account (if publicly available)

* Reviewers Facebook URL (if publicly available)

* Reviewers "tagline" on on Google+ "about - story" profile page (if publicly available)

* Reviewers "introduction" on on Google+ "about - story" profile page (if publicly available)

* Reviewers "bragging rights" on on Google+ "about - story" profile page (if publicly available)

* Number of people that have the reviewer in their Google circles (if publicly available)

Skills: Data Entry, Database Administration, Microsoft Access, Web Scraping, Web Search

See more: google nyc restaurant, web data scraping freelancer, the freelancer phone number, tagline for profile, tagline for freelancer, story of a freelancer, reviews of freelancer website, reviews from users of freelancer, reviews about freelancer website, reviewer web, restaurant freelancer, profile tagline, profile introduction, ok google freelancer, new york freelancer, microsoft reviews, maps in freelancer, introduction of freelancer, introduction databases, google reviews on freelancer, freelancer website nyc, freelancer web page cost, freelancer web order, freelancer us phone number, freelancer the order

About the Employer:
( 0 reviews ) Madrid, Spain

Project ID: #5532584