We would like someone to create a database as an XLS file, containing:
email (the main one):
Telephone (main one):
Of all the businesses, in the following categories, in the UK:
- Design agencies (1000)
- Web site design companies (1000)
- Product design companies (200)
- Games design companies (500)
- SEO service providers (500)
- Marketing companies (1000)
- Training companies and providers (1000)
- Media and Film companies (500)
- Multi media companies (1000)
The list must not include companies that fall outside these areas (i.e. outside the creative industries and new media industries), so a company that offers Kitchen Design, should not be included.
The numbers required for each category, are shown in brackets. You must work on a per county basis and geographically spread out from that county, we would like you to start in Yorkshire first and spread out from there. You must spread your search across England and if you run out of companies then continue to Wales, Scotland and then Northern Ireland.
As you work through this process, you must provide an estimate of how many companies you think you can 'possibly' get for each category. So for example if you were to look at 'web design companies' in the city of Leeds. You will see that you could extract around 200 just in that city alone. Based on the fact Leeds holds 7% of population, it can be assumed that maybe you could get 2000 web design firms in total, across UK.
Based on these further estimated figures, I will consider employing you to get all of them, and thus more work on top of the work you have already done. We might also expand the job to other countries.
Ideas for finding this information:
Companies House (having an account would be advantageous)
Google Maps (this would allow you to make estimates of how many companies you could fully get across the country).
Web Search engines
You must not extract confidential and none public data. It has to be public data that is freely available on the web or in public directories.
Your work and results will be tested for reliability.