Web Scraping: 160k records

Brief:
One final xls file should be produced for each Country to include the columns specified below:

1. Italy: (57.250 Records)
Main link -- https://cercalatuascuola.istruzione.it/cercalatuascuola/ -- click on the third Icon above “Ricerca Rapida” – a panel containing “Ricerca avanzata” should now appear – then submit by clicking “Cerca” –
From the list of schools you obtain scrape for every Region –
1. Name of the school
2. Telephone
3. E-mail
4. Every record contains a 5 digits number that should be included in a column named “CAP”
5. After the 5 digits number (CAP) there is a written part, this should be included in a column named “City”.
6. For each and every school please also include what is contained in the “Codice” dield under a column by the name “School code”

2. France: (62327 records)
Main link - https://www.education.gouv.fr/annuaire?keywords=&department=&academy=&status=All&establishment=All&geo_point=
Simply select “tout” in every field and click on “Chercher” -> for every voice scrape:
1. Name of the school
2. Telephone
3. Mail address
4. Under the voice “Coordonnées” you can find the address, the five digit code contained in this field should be included in a column named “CAP”,
5. What follows the 5 digits number should be included in a column named “City”

3. Spain: (34336 records)
https://www.educacion.gob.es/centros/home.do
Simply select “Todo el territorio” – and select “Buscar”: you’ll get 34336 records, from here please scrape:
1. Name of the school
2. Telephone
3. Mail address
4. What is contained in the “Codigo postal” field should be included in a column named “CAP”,
5. What is contained in the “Municipio” field should be included in a column named “City”
6. What is contained in the “Codigo de centro” field should be included in a column named “School code


4. Hungary (11192 records)
go to page: https://www.oktatas.hu/hivatali_ugyek/kir_intezmenykereso
leave all the fields blank - click ”Kereses” – you should obtain 11192 records: For each of these please scrape:
1. Name of the school
2. Telephone
3. Mail address
4. The four digits number in the “Székhely cím:” field should be included in a column named “CAP”,
5. What follows the 4 digits number but comes before the comma in the “Székhely cím” field should be included in a column named “City”
6. What is contained in the “OM azonosító szám:” field should be included in a column named “School code”

To be assigned the job please provide a sample of 5 records for each Country before Thursday 19th Jan, 9AM CET.
It will be assigned on Thursday morning, based on the bidding results, experience of the candidate and quality of the sample. It must be completed before Monday 23 Jan, h15 CET.
Please keep in mind that the deadlines are strict and we have more work packages so we'd hope to continue our cooperation.