Build Excel file with data of around 850 restaurants
$30-5000 USD
Completed
Posted almost 13 years ago
$30-5000 USD
Paid on delivery
I'm looking to have an Excel sheet built with information of around 850 restaurants in my province.
The restaurants can be found here:
Link 1: [login to view URL] -> showing 799 restaurants
Link 2: [login to view URL] -> showing 806 restaurants
I'm not sure how many restaurants there are in common. If it appears there are more than 850 different restaurants, I will give you a bonus for the extra work (for example: 900 restaurants is 50 extra restaurants or 5,9% more => 5,9% bonus).
The exact format of the Excel sheet will be given to you when the job is awarded to you, but it will look something like this:
1 row per restaurant
Column A: restaurant name
Column B: description
Column C: street name
Column D: street number
Column E: city name or postal code (up to you, but has to be consistent over the whole file)
Column F: telephone number (same format for complete file)
Column G: fax number (if available) (same format for complete file)
Column H: website url (if available) (including http://)
Column I: website email (if available)
Column J: opening hours on Sunday (format HH:MM-HH:MM or "closed")
Column K: opening hours on Monday (format HH:MM-HH:MM or "closed")
Column L: opening hours on Tuesday (format HH:MM-HH:MM or "closed")
...
Further columns that are requested: kitchen type (comma separated), number of seats, payment options (comma separated), budget, accomodation and infrastructure. These last two things are available on site 2 as "Accommodaties" and "Kader".
Last but not least, I also want you to save the images/photos you find on those two sites. The naming of these is very important: Take the name of the restaurant and append the extension (.jpg of .png). If you have a 2nd image, you append 2 before the extension. If you have a 3rd image, you append 3 before the extension.
Once awarded to someone, I first want this person to make a test file with 10 entries to make sure we're communicating on the same wavelength :)
Note: How you do it is up to you (with a scraper or manually), as long as the data is correct.
Note: In your reply, please make sure you include your bid AND the time needed + when you can start.
## Deliverables
* * *This broadcast message was sent to all bidders on Wednesday May 18, 2011 7:20:12 AM:
It seems something is wrong with link 2. You need to click "Nieuwe zoekopdracht" and then filter on "Provincie" with value "Limburg". This should give you 807 results.
* * *This broadcast message was sent to all bidders on Wednesday May 18, 2011 8:30:45 AM:
I want to inform all bidders that I don't want you to translate any of the text to English. All text fields can remain untranslated (in Dutch).