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
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