En cours

Confirming accuracy of LW scraped location data


We're still working with the Living Wage dataset. In this spreadsheet there are 2759 Google Places locations for 371 companies. Column F, maps_link, will take you to the location on Google Maps. Column J, google_place_id, is the unique ID for the place. Column A, "company_natural_key" is the company name. And column B, company_website_url, is a link to the company website.

This data has been scraped from Google Places API, so it contains lots of false positives (look at row 93: the place_name "Lifeboat" is not a Brewdog pub)


The task is to set column E to either INCLUDE or EXCLUDE.

If the place is a valid location for the company, set column E to INCLUDE.

If it's an invalid location for the company, set it to EXCLUDE.

Otherwise, leave it as UNSPECIFIED

I've run some code to auto-set the value. So 308 are already set to INCLUDE, 15 are already set to EXCLUDE. Which unfortunately leaves 2436 UNSPECIFIED.

But 2194 of the UNSPECIFIED rows are for the 8 big national brands, particularly COOK (which gives an awful set of results because it's such a common word).

To help decide whether a place is valid or not, you could refer to the google_classification column, although it's not always helpful. But you should be able to knock out a lot that way, especially with COOK and the other national brands.

Your ultimate source of truth is always to be to go to the company website, find their store locator, and confirm the locations manually.

If you find that the spreadsheet is missing places, add a note in the comments column.

*National Companies*

Some notes on the big national companies...

In general, these don't have to be perfect. There is subjectivity anyway (e.g. Ikea "collection points" vs Ikea stores). A few too many or a few too few is not a problem.

Majestic Wine

- Wine store

- We expect "200+" locations

- Store locator: [login to view URL]

- Search seems to be pretty good - only a few false positives


- Pub

- We expect ~49 locations

- Store locator: [login to view URL]

- Search seems to work fairly well for these. Modern company, good with their online presence :)


- Fashion store

- We expect ~23 locations

- Store locator: [login to view URL]

- I don't think the Burberry "outlets" are official stores, so remove these.


- This is a shop that sells high quality ready meals

- We expect ~110 locations

- Store locator: [login to view URL]

- This search is terrible and brings back loads. Hard to tell which are valid and which aren't. Will take some effort, I think :(


- Cosmetics store

- We expect ~106 locations

- Store locator: [login to view URL]

- We are getting more like 300 back, so a lot of false positives here


- Cinema

- We expect ~13 locations

- Store locator: [login to view URL]

- They have an "other" category on their cinema list, which come back in the search. I think we should leave these in.


- We expect ~27 locations

- Store locator: [login to view URL]

- Loads of rubbish comes back here, because the stores are so big (e.g. bus tops, and restaurants)

Richer Sounds

- Electronics store (mainly audio/video I think)

- We expect ~53 locations

- Store locator: [login to view URL]

- Looks like search worked ok

*Other points*

There should be only UK locations in the dataset (England, Scotland, Wales, Northern Ireland; Not Republic of Ireland). If you find any outside of the UK, EXCLUDE them

We do not want the companies' head offices. We only want stores/shops/branches where customers interact directly with the business

Compétences : Excel, Saisie de Données, Recherche sur Internet

en voir plus : collating data business, google maps import location data, data mining restaurants, scraped rss data, send location data using gprs, crawler location data, data business australia listing, location data entry project, location data voice channel, map display location data, real time data business, service data business layer, unlimited telemarketing data business leads, data business cards, backend data business chennai, location type business iphone, data number restaurants philippines, upload location data iphone website, drupal access node location data, javascript location data mobile

Concernant l'employeur :
( 1 commentaire ) Haywards Heath, United Kingdom

Nº du projet : #20324831

Décerné à:


Hey this is Sourabh Gupta from New Delhi. I would like to provide my services for this project. Placing the bid as discussed, thanks. Regards Sourabh

£8 GBP / heure
(114 Commentaires)

33 freelance font une offre moyenne de £6/heure pour ce travail


Hi there. I am a full time web researcher. Updating column E by manually going through store locator pages of listed brands will be done with 100% accuracy. I have years of experience and have completed 500+ data proce Plus

£10 GBP / heure
(394 Commentaires)

Hi there, I can confirm accuracy of LW scraped location data. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

£5 GBP / heure
(422 Commentaires)

Hi, I am a web data research expert. I can help to go to the company website, find their store locator, and confirm the locations manually. Please send me the file. Let's discuss and start. Thanks

£5 GBP / heure
(885 Commentaires)

Hello there, We have reviewed the requirements and we are interested in offering our services. # APPROACH # The Best way to accomplish this is by locating the stores on official website itself. We recently complet Plus

£6 GBP / heure
(182 Commentaires)

Hello, I can help to validate a list of 2,759 UK locations. I’m willing to give a sample for your review and comment. Please drop a PM if you’re interested. Best regards, Hoang

£10 GBP / heure
(159 Commentaires)

Hello Sir, I am research and data entry expert, i can help you with this task, I can set column E to either INCLUDE or EXCLUDE based on the location found or not with 100% accuracy and very quickly, i am ready to start Plus

£5 GBP / heure
(72 Commentaires)

I read the instructions and description thoroughly. Can you share the excel file, let me do few corrections first, I'll send you the sample, then you can tell me whether they are correct. I have done lot of similar wor Plus

£8 GBP / heure
(31 Commentaires)

Hi dear, I have read your work instruction 3 times but some specification is not clear to me. So if you instruct me as my asking question about my some matter then we can start work. I will wait for your reply. Thanks Plus

£5 GBP / heure
(14 Commentaires)

Hi There ! I'm interested in your project. I am detail oriented hard worker and honest. I assure that I will provide you Quality Work with 100% accuracy. My main goal is your satisfaction. If i get this chance to help Plus

£5 GBP / heure
(38 Commentaires)

Hello! I’ve read your job description & I am very much interested in working on your project. I have a good experience of the works. I am the right candidates for this task. I am a quick, reliable and efficient worker Plus

£7 GBP / heure
(34 Commentaires)

Hi, My name is Fedelito Recillo and I am a full-time freelancer. I see your job post and I am interested. I do believe that with my knowledge, skills and experience I can do the job better than the others. I am willi Plus

£9 GBP / heure
(4 Commentaires)

Dear Sir/Ma, This project greatly interests me as this is one of my core areas of expertise as a freelancer. I promise I will do this to your maximum satisfaction and deliver quality work within an agreed timeframe. I Plus

£5 GBP / heure
(33 Commentaires)

Hi Next Employer, I am interested in your project. I hold master degree in Business Administration (Finance). I am experienced data entry operator accountant and auditors having more than 9 years’ experience of data Plus

£5 GBP / heure
(13 Commentaires)

Hello Please let me do this project. I can start immediately. I am very detail-oriented, hard-working, reliable and responsible. I have excellent experience in admin support, lead generation, web research, data entry.

£5 GBP / heure
(3 Commentaires)

Hello, I am interested to work on this project. I am details oriented and have enough experience in data entry and web research. I will provide the best quality with 100% accuracy. Can you please share the files so tha Plus

£5 GBP / heure
(4 Commentaires)

Hello, I have carefully read your project description and totally understand its requirements. I can assure you that I can get it completed within the stipulated time. I place your project as my outmost priority and Plus

£5 GBP / heure
(7 Commentaires)

Hello there, I have got your job posting. I can assure you that I will be able to assist you in your task with quality work. Allow me to start [login to view URL] let me know further details. Waiting for your reply. Rele Plus

£5 GBP / heure
(4 Commentaires)

Hi there I am interested in your project. I have completed projects like this. If you like to offer me the project please contact me. Thank you

£5 GBP / heure
(5 Commentaires)

Dear Mr./Mrs., I believe I am a good fit to finish your project because I have experience working as an Internet Researcher and as a Data Entry Operative. I am tech savvy, attentive to details and hardworking, qualit Plus

£5 GBP / heure
(2 Commentaires)

I am data entry and web research expert and willing to work with you. I believe that I am the right person you are looking for. I am pretty sure that if you make me a part of your valuable work your work will be done a Plus

£5 GBP / heure
(0 Commentaires)