Manual search/data collection + data/ web scraping - 30k records

  • Posted:
  • Proposals: 17
  • Remote
  • #2770990
  • via mobile app
  • OPPORTUNITY
  • Awarded
Hoang D.
Daniel K.JAY P.Surjit P.LeadLoaaf LLC + 12 others have already sent a proposal.
  • 13

Description

Experience Level: Expert
Estimated project duration: 1 - 2 weeks
The job is a manual research of data – which could be partially automated with a script for data mining and data scraping / web scraping. The job includes daily updates about progress.
The job is made of 3 parts: EPALE, ETWINNING, ERASMUS+. Please, provide a sample for 5 records of each of the parts in order for your proposal to be accepted.
The final selection of the provider will be based on price and quality of your sample.
Please, note the deadlines and timing for deliverables below.

#EPALE - 2100 records
For each page https://epale.ec.europa.eu/en/organisations?alphabet_1=All&field_organization_country_tid_i18n=All&field_organization_type_tid_i18n=All&combine=&page=1
With page id going from 1 to 208
Select each of the 10 records per page
Extract the organization name and the country (use the flag caption)
Check if the organization description (not the rest of the page!) includes an email and/or phone and/or fax. If so, select the email and/or phone and/or fax
If the organization description does not include an email, go on the organization website and search for the email, phone and fax
Phone and fax numbers must be clean of the international code and the international code must appear in a separate column.
The final Excel file must be in the Country, Organization Name, Email, International code, Phone, Fax, Organization website
#ETWINNING – 13k records
For each of the following countries in the map, please select the country and click on Browse Schools.
https://www.etwinning.net/en/pub/community/countries.cfm
Turkey 49195 schools
Spain 15234 schools
France 22228 schools
Germany 9457 schools
Poland 17997 schools
Belgium 2319 schools
Sweden 3378 schools
Romania 9429 schools
Austria 1872 schools
Portugal 1978 schools
Netherlands 2371 schools
TOTAL 135458 schools
Please, work only of 10% of the records for each country.
Here is how to find the information:
Below “Search results”, you will see a number of links to information about schools (click “Load more” to load more)
For each school, please select the name, address and website.
Select the website and search for the email, phone and fax numbers. If the website is not available, search the school name and address in order to identify the website, email and phone/fax – otherwise if it is easier to automate, you can work only with the records already showing a website, if they are more than 10%.
Below “Meet the teachers”, there is a list of teacher names, subjects and languages: please, select only the teacher names. If there is more than one teacher name, please list all the teachers by separating them with a comma in one single cell.
Phone and fax numbers must be clean of the international code and the international code must appear in a separate column.
The final Excel file must be in the Country, School Name, Email, International code, Phone, Fax, website, Teacher names. Teacher names must go all in one cell, separated by commas.
#ERASMUS+ - 15k records
Please, search the email address, phone and fax numbers of those “Coordinating organisation name” records in the attached db.
You can use the “Coordinator's website” if available -otherwise use the “Coordinating organisation name” and “Coordinator's address” to locate the organization.
Please, notice that there are more than 8k “Coordinator's website” duplicates as their refer to different “Coordinator's address”: make sure you search data for unique records
Phone and fax numbers must be clean of the international code and the international code must appear in a separate column.
Please, add to the attached Excel the Email, International code, Phone, Fax columns
DELIVERABLES AND TIMING
The job will be assigned on Mon 30th 12.00 CET
You must send daily updates with data you scraped otherwise a refund will be requested.
The job must be completed according to the following deadlines:
EPALE: Thu 2nd April 9.00 CET
ETWINNING: Tue 7th April 9.00 CET
ERASMUS+: Fri 10th April 9.00 CET

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

  • Kshan Lal V.

    I sent the sample according to the guidelines of your project, can you give me an opportunity to do this project, I will be very grateful to you.

  • Shumaila Y.

    Can you invite me Please ???