Creation of a Company Database Using Web Scraping

Job ID: 38553173

Budget: €30 – €250 EUR

Project Objective:
The goal of this project is to develop a comprehensive company database for various cities, based on publicly accessible data sources. The database should contain essential information such as company name, address, and telephone number, providing a reliable foundation for business activities. In the first phase, 2,000 company records will be collected, with an expansion to 20,000 records if the collaboration is successful.

Scope of Work:

Web Scraping of Company Data:
Using web scraping technologies, company data should be extracted from the following sources:

Google Maps
Wer liefert was
GoYellow
The data should be sourced from different cities, with a focus on companies across various categories and industries of interest for the project.

Categories and Information:
The database must include the following information:

Category (industry, business type)
Company Name
Street
Building Number
Postal Code
City
Website
Phone Number (important)
Contact Person
Particular focus should be placed on the following fields:

Company Name
Address (Street, Building Number, Postal Code, City)
Phone Number
Creation of an Excel File:
All collected data should be structured in an Excel spreadsheet. The spreadsheet will reflect the categories mentioned above, with all information clearly and systematically organized in separate columns.

Target Number of Data Entries:

First Phase: 2,000 company records
Expansion upon successful collaboration: 20,000 company records
Requirements for the Service Provider:

Experience with Web Scraping: Knowledge of data extraction from publicly available websites and platforms.
Data Preparation: Ability to provide the scraped data in a clean and structured format.
Proficiency with Excel: Professional presentation of the data in Excel, with correct mapping of the individual fields (category, name, address, etc.).
Timeframe:

The first phase (2,000 company records) should be completed within [specify timeframe, e.g., 2 weeks].
Upon successful collaboration, there will be an extension to 20,000 company records with a new timeframe.
Success Criteria:

Completeness of Data: At least 95% of the records must have all relevant fields (name, address, phone number) filled in.
Quality: The provided data must be accurate and up to date, with no duplicates or incorrect information.
Structure of the Excel Spreadsheet: Data must be presented in a clean and structured format in Excel.
Compensation:
Compensation will be based on the completion of the 2,000 company records, with a separate rate for the expansion to 20,000 records if the collaboration proves successful. Further details on compensation and payment will be agreed upon individually.

Conclusion:
This project requires precise work in data extraction and preparation. It offers a clear opportunity for long-term collaboration if the service provider meets the requirements reliably and with high quality.
Related categories: Data Entry Excel Web Scraping Web Search Data Mining