Hi I need to build a marketing database of solicitors in England what I need is someone to visit this site
http://www.lawsociety.org.uk/choosingandusing/findasolicitor/action=[login to view URL]
choose country = ENGLAND
choose area of law = Wills & Probate
you will get 7697 results back
I need each result click on to show full details of the firm then each section of details loaded into a spreadsheet - see example of a firm below the sections are in red
so i expect a spreadsheet with columns for
firms name
phone number
fax number
web site
email address
wheelchair access
legal aid
fixed fee interview
authorised trainer
address
dx
number of offices
no of regulated principals
no of reg principals at this office
area of law 1
area of law 2
area of law 3
--
area of law 20
and then 1 line per firm
more information on the next screen
hope that is clear
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
## Deliverables
here is an example of the data screen that you collect information from
**Phone Number: 01454 202 102**
**Fax Number: 01454 202 832**
**Web Site: [[login to view URL]][1]**
Email Address: [priority@[login to view URL]][2]
| **At this office:** | ![][3] | [**Wheelchair Access:**][4] No <a class="hpInPage" href="[login to view URL]:80/choosingandusing/findasolicitor/view=atthisbranch.law#wheelchair" target="_blank" title="Click here for more information - Link opens in a new window"><b>Wheelchair Access:</b></a> No
[**Legal Aid:**][4] No <a class="hpInPage" href="[login to view URL]:80/choosingandusing/findasolicitor/view=atthisbranch.law#legalaid" target="_blank" title="Click here for more information - Link opens in a new window"><b>Legal Aid:</b></a> No
[**Fixed Fee Interview:**][4] No <a class="hpInPage" href="[login to view URL]:80/choosingandusing/findasolicitor/view=atthisbranch.law#fixedfee" target="_blank" title="Click here for more information - Link opens in a new window"><b>Fixed Fee Interview:</b></a> No
**Authorised Trainer:** No |
| ![][3] |
| **ID:** | ![][3] | 325107 |
| ![][3] |
| **Address:** | ![][3] | 25 The Courtyard
Woodlands
BRISTOL
SOUTH GLOUCESTERSHIRE
[BS32 4NH][5]
ENGLAND |
| ![][3] |
| **DX address:** | ![][3] | DX124893
ALMONDSBURY 3 |
| ![][3] |
| **Number of offices:** | ![][3] | [1][6] |
| ![][3] |
| **Number of [regulated principals][7] in this organisation:** | ![][3] | [1][8] |
| ![][3] |
| **Number of [regulated principals][7] at this office:** | ![][3] | [1][9] |
| ![][3] |
| **Number of solicitors and lawyers at this office:** | ![][3] | [2][10] |
| ![][3] |
| **Areas of law:** | ![][3] | [Commercial property][11]
[Conveyancing residential][12]
[Wills and probate][13] |
| ![][3] |
| **Languages:** | ![][3] | [Welsh][14] |
| ![][3] |
| **Lexcel Accreditation:** | ![][3] | [No][15] [![Click here for more information][16]][17] |