Closed

Scrape all the Google Local NYC restaurant reviews

This project received 24 bids from talented freelancers with an average bid price of $1079 USD.

Get free quotes for a project like this
Employer working
Project Budget
$750 - $1500 USD
Total Bids
24
Project Description

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)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online