Scrape all the Google Local NYC restaurant reviews

CLOSED
Bids
24
Avg Bid (USD)
$1079
Project Budget (USD)
$750 - $1500

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)

Skills required:
Data Entry, Database Administration, Microsoft Access, Web Scraping, Web Search
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: freelancer example.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 842
in 15 days
$ 1030
in 20 days
$ 1289
in 20 days
$ 1750
in 20 days
$ 1500
in 20 days
Hire pandey2008
$ 789
in 10 days
Hire svteam
$ 750
in 10 days
$ 1473
in 20 days
Hire abupabuya
$ 757
in 20 days
$ 1184
in 20 days