home / uk_version_0_4

person_recordDetails_addresses

12,152,361 rows

✎ View and edit SQL

This data as json, CSV (advanced)

_link ▼ _link_person_statement type address postcode country_name country_code
0.recordDetails.addresses.0 0 service 71-75, Shelton Street, London WC2H 9JQ United Kingdom  
1.recordDetails.addresses.0 1 service 9 Walton Road, Bournemouth, Dorset BH10 4BJ United Kingdom GB
10.recordDetails.addresses.0 10 service First Floor, Telecom House, 125-135 Preston Road, Brighton, England BN1 6AF United Kingdom GB
100.recordDetails.addresses.0 100 service 84a, Lancaster Road, Via Kynaston Road, Enfield, Middlesex EN2 0BX United Kingdom GB
1000.recordDetails.addresses.0 1000 service Unit 1 - 2, Rear Of No.12 Emery Road, Brislington, Bristol, England BS4 5PF United Kingdom GB
10000.recordDetails.addresses.0 10000 service 22 Finsbury Park Road, London, England N4 2JZ United Kingdom GB
100000.recordDetails.addresses.0 100000 service 34 Streatham Vale, London, England SW16 5TE United Kingdom GB
1000000.recordDetails.addresses.0 1000000 service 186 Tomswood Hill, Ilford, England IG6 2QR United Kingdom GB
10000000.recordDetails.addresses.0 10000000 service 95 Wennington Road, Rainham RM13 9TH United Kingdom  
10000001.recordDetails.addresses.0 10000001 service 73 Cornhill, London EC3V 3QQ United Kingdom  
10000002.recordDetails.addresses.0 10000002 service 2 Compton Way, Witney, Oxfordshire OX28 3AB United Kingdom  
10000003.recordDetails.addresses.0 10000003 service Knabbs Ash, Skipton Road, Felliscliffe, Harrogate, North Yorkshire HG3 2LT United Kingdom  
10000004.recordDetails.addresses.0 10000004 service 203 West Street, Fareham, Hampshire PO16 0EN United Kingdom GB
10000005.recordDetails.addresses.0 10000005 service 30 Bath Street, Southport, England PR9 0DA United Kingdom GB
10000006.recordDetails.addresses.0 10000006 service 20 Mythop Road, Blackpool, Lancashire FY4 4UZ United Kingdom  
10000007.recordDetails.addresses.0 10000007 service Unit 227, Tudorleaf Business Centre, 2/8 Fountayne Road,, London N15 4QL United Kingdom  
10000008.recordDetails.addresses.0 10000008 service 270 Slade Road, Birmingham, England B23 7LX United Kingdom GB
10000009.recordDetails.addresses.0 10000009 service 25 Ernest Webb Drive, Springfield, Chelmsford, England CM1 6HF United Kingdom GB
1000001.recordDetails.addresses.0 1000001 service 42 Holmesdale Avenue, Redhill RH1 2PB United Kingdom  
10000010.recordDetails.addresses.0 10000010 service 6 The Square, Martlesham Heath, Ipswich, England IP5 3SL United Kingdom GB
10000011.recordDetails.addresses.0 10000011 service 352 Fulham Road, London SW10 9UH United Kingdom  
10000012.recordDetails.addresses.0 10000012 service 39 Southill Road, Chatham ME4 5SA United Kingdom  
10000013.recordDetails.addresses.0 10000013 service 8 Cyprus Street, Wolverhampton, England WV2 4PA United Kingdom GB
10000014.recordDetails.addresses.0 10000014 service 39 Southill Road, Chatham ME4 5SA United Kingdom  
10000015.recordDetails.addresses.0 10000015 service 80 Medlicott Road, Sparkbrook, Birmingham B11 1PY United Kingdom  
10000016.recordDetails.addresses.0 10000016 service 7 Bramley Court, Hatton, Derby, England DE65 5QT United Kingdom GB
10000017.recordDetails.addresses.0 10000017 service 217 Ellesmere Road, Newcastle Upon Tyne NE4 8TQ United Kingdom  
10000018.recordDetails.addresses.0 10000018 service 1a, Magdala Road, Nottingham, England NG3 5DD United Kingdom GB
10000019.recordDetails.addresses.0 10000019 service 10 Chester Street, London SW1X 7BB United Kingdom GB
1000002.recordDetails.addresses.0 1000002 service 11 Dormer Place, Leamington Spa, England CV32 5AA United Kingdom GB
10000020.recordDetails.addresses.0 10000020 service 73 Cornhill, London EC3V 3QQ United Kingdom  
10000021.recordDetails.addresses.0 10000021 service Horley Green House, Horley Green Road, Halifax, West Yorkshire HX3 6AS United Kingdom  
10000022.recordDetails.addresses.0 10000022 service 65 Berwick Chase, Peterlee, England SR8 1NQ United Kingdom GB
10000023.recordDetails.addresses.0 10000023 service 35 East Crescent, Stoke-On-Trent, England ST1 6ES United Kingdom GB
10000024.recordDetails.addresses.0 10000024 service 6 Mease Croft, Birmingham, West Midlands B9 4PW United Kingdom  
10000025.recordDetails.addresses.0 10000025 service 3 Fairview Court, Fairview Road, Cheltenham, Gloucestershire GL52 2EX United Kingdom  
10000026.recordDetails.addresses.0 10000026 service 30 Romney Street, Salford, England M6 6DG United Kingdom GB
10000027.recordDetails.addresses.0 10000027 service 60a, Creighton Avenue, St. Albans, England AL1 2LQ United Kingdom GB
10000028.recordDetails.addresses.0 10000028 service 4 Ruby Grove, Rainworth, Mansfield, England NG21 0GL United Kingdom GB
10000029.recordDetails.addresses.0 10000029 service Flat 7 Lynton Court, Horn Lane, London, England W3 6PN United Kingdom GB
1000003.recordDetails.addresses.0 1000003 service 60 Brookside Road, Worcester, Worcestershire WR2 5PS United Kingdom GB
10000030.recordDetails.addresses.0 10000030 service 142 St. James Road, Tunbridge Wells, Kent TN1 2HE United Kingdom GB
10000031.recordDetails.addresses.0 10000031 service 7 Colmore Avenue, Middlesbrough, England TS3 9HB United Kingdom GB
10000032.recordDetails.addresses.0 10000032 service Holmlea Farm, Day Green, Hassall, Sandbach, England CW11 4XU United Kingdom GB
10000033.recordDetails.addresses.0 10000033 service 39 Waterhall Close, London E17 5PS United Kingdom  
10000034.recordDetails.addresses.0 10000034 service 19 Dormie Close, Basingstoke, Hampshire RG24 9YJ United Kingdom  
10000035.recordDetails.addresses.0 10000035 service 6 Carina Drive, Wokingham, England RG40 1EF United Kingdom GB
10000036.recordDetails.addresses.0 10000036 service Sharnoob, Damanhor, Al-Beheira   Egypt  
10000037.recordDetails.addresses.0 10000037 service 26 Parkside Road, Sheffield, England S6 2AA United Kingdom GB
10000038.recordDetails.addresses.0 10000038 service 5a, Mulberry Parade, West Drayton, England UB7 9AE United Kingdom GB
10000039.recordDetails.addresses.0 10000039 service Flat 23 Plover House, Deal Walk, London, England SW9 6DX United Kingdom GB
1000004.recordDetails.addresses.0 1000004 service 48 Studfield Road, Sheffield, England S6 4ST United Kingdom GB
10000040.recordDetails.addresses.0 10000040 service 346a, Bath Road, Hounslow, London TW4 7HW United Kingdom  
10000041.recordDetails.addresses.0 10000041 service 35 Firs Avenue, London, England N11 3NE United Kingdom GB
10000042.recordDetails.addresses.0 10000042 service 105 Berry Head Road, Brixham, Devon TQ5 9AG United Kingdom  
10000043.recordDetails.addresses.0 10000043 service 6 Windsor Place, Conon Bridge, Ross-Shire IV7 8BX United Kingdom  
10000044.recordDetails.addresses.0 10000044 service 1 Anker Street, Nuneaton, England CV11 4JA United Kingdom GB
10000045.recordDetails.addresses.0 10000045 service 36 Alexandra Lane, Flockton, Wakefield, England WF4 4FA United Kingdom GB
10000046.recordDetails.addresses.0 10000046 service 1464 London Road, London SW16 4BU United Kingdom  
10000047.recordDetails.addresses.0 10000047 service 106-108 Reddish Lane, Manchester M18 7JL United Kingdom  
10000048.recordDetails.addresses.0 10000048 service 70 Coleridge Road, Rotherham, England S65 1LW United Kingdom GB
10000049.recordDetails.addresses.0 10000049 service 106-108 Reddish Lane, Manchester M18 7JL United Kingdom  
1000005.recordDetails.addresses.0 1000005 service 377 Warbreck Drive, Blackpool, England FY2 9LD United Kingdom GB
10000050.recordDetails.addresses.0 10000050 service Whiteleaf Business Centre, 11 Little Balmer, Buckingham, Buckinghamshire MK18 1TF United Kingdom  
10000051.recordDetails.addresses.0 10000051 service Celixir House, Stratford Business And Technology Park, Stratford-Upon-Avon, Warwickshire CV37 7GZ United Kingdom  
10000052.recordDetails.addresses.0 10000052 service New Burlington House, Finchley Road, London, England NW11 0PU United Kingdom GB
10000053.recordDetails.addresses.0 10000053 service New Burlington House, Finchley Road, London, England NW11 0PU United Kingdom GB
10000054.recordDetails.addresses.0 10000054 service 12 Gilpin Close, Houghton Regis, Bedfordshire LU5 5SL United Kingdom  
10000055.recordDetails.addresses.0 10000055 service 484 Alcester Road South, Birmingham, England B14 6EP United Kingdom GB
10000056.recordDetails.addresses.0 10000056 service 39 St. Augustines Crescent, Whitstable, England CT5 2NW United Kingdom GB
10000057.recordDetails.addresses.0 10000057 service 194 Kingshill Avenue, Northolt, England UB5 6NZ United Kingdom GB
10000058.recordDetails.addresses.0 10000058 service Office 3, 146/148 Bury Old Road, Manchester M45 6AT United Kingdom  
10000059.recordDetails.addresses.0 10000059 service Office 3, 146/148 Bury Old Road, Manchester M45 6AT United Kingdom  
1000006.recordDetails.addresses.0 1000006 service 272 Bath Street, Glasgow, Scotland G2 4JR United Kingdom GB
10000060.recordDetails.addresses.0 10000060 service Office 9 Alcester Business Centre, Kinwarton Farm Road, Alcester B49 6EH United Kingdom  
10000061.recordDetails.addresses.0 10000061 service Office 6, Mcf Complex, 60 New Road, Kidderminster DY10 1AQ United Kingdom  
10000062.recordDetails.addresses.0 10000062 service 3 Cotswold Way, Downly, High Wycombe HP13 5NP United Kingdom  
10000063.recordDetails.addresses.0 10000063 service Office 9 Alcester Business Centre, Kinwarton Farm Road, Alcester B49 6EH United Kingdom  
10000064.recordDetails.addresses.0 10000064 service Office 6, Mcf Complex, 60 New Road, Kidderminster DY10 1AQ United Kingdom  
10000065.recordDetails.addresses.0 10000065 service 6 Moore Walk, Warwick, England CV34 6QT United Kingdom GB
10000066.recordDetails.addresses.0 10000066 service 27 Tawny Grove, Coventry CV4 8NL United Kingdom  
10000067.recordDetails.addresses.0 10000067 service 20-22, Wenlock Road, London, England N1 7GU United Kingdom GB
10000068.recordDetails.addresses.0 10000068 service 7a, Milton Court, Ravenshead NG15 9BD United Kingdom  
10000069.recordDetails.addresses.0 10000069 service 6 Mussani Court, 10a The Gardens, Erdington, Birmingham B23 6FF United Kingdom  
1000007.recordDetails.addresses.0 1000007 service 1st Floor, 24 Richmond Street, Williamson Square, Liverpool, Merseyside L1 1EF United Kingdom GB
10000070.recordDetails.addresses.0 10000070 service 17 12 Freeland Park Lytchet House, Wareham Road, Poole, Dorset BH16 6FA United Kingdom  
10000071.recordDetails.addresses.0 10000071 service Flat 5 89-91, Park Lane, Croydon, England CR0 1DY United Kingdom GB
10000072.recordDetails.addresses.0 10000072 service Flat 12, 7a, St. Davids Square, London E14 3WJ United Kingdom  
10000073.recordDetails.addresses.0 10000073 service 16 The Shearings, Hightown, Liversedge, England WF15 8LS United Kingdom GB
10000074.recordDetails.addresses.0 10000074 service 7 Smallridge Close, Wirral CH61 8TS United Kingdom  
10000075.recordDetails.addresses.0 10000075 service 67 Hayton Road, Aberdeen, Scotland AB24 2RN United Kingdom GB
10000076.recordDetails.addresses.0 10000076 service 9 Whiteford Court, Hamilton, Scotland ML3 7UW United Kingdom GB
10000077.recordDetails.addresses.0 10000077 service 9 Whiteford Court, Hamilton, Scotland ML3 7UW United Kingdom GB
10000078.recordDetails.addresses.0 10000078 service 18 Devonshire Street, Worksop S80 1NA United Kingdom GB
10000079.recordDetails.addresses.0 10000079 service 732 Broad Lane, Eastern Lane, Coventry CV5 7BB United Kingdom GB
1000008.recordDetails.addresses.0 1000008 service 592 New North Road, Ilford IG6 3TG United Kingdom  
10000080.recordDetails.addresses.0 10000080 service Office G, Charles Henry House, 130 Worcester Road, Droitwich WR9 8AN United Kingdom  
10000081.recordDetails.addresses.0 10000081 service 732 Broad Lane, Eastern Green, Coventry CV5 7BB United Kingdom GB
10000082.recordDetails.addresses.0 10000082 service Office G, Charles Henry House, 130 Worcester Road, Droitwich WR9 8AN United Kingdom  
10000083.recordDetails.addresses.0 10000083 service Office G, Charles Henry House, 130 Worcester Road, Droitwich WR9 8AN United Kingdom  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [person_recordDetails_addresses] ( [_link] TEXT 
 , [_link_person_statement] TEXT 
 , [type] TEXT 
 , [address] TEXT 
 , [postcode] TEXT 
 , [country_name] TEXT 
 , [country_code] TEXT 
 , PRIMARY KEY ([_link]) 
 , FOREIGN KEY ([_link_person_statement]) REFERENCES [person_statement]([_link]) 
   );
Powered by Datasette · Queries took 750.713ms