home / UK_PSC

person_addresses

4,486,771 rows

✎ View and edit SQL

This data as json, CSV (advanced)

_link ▼ _link_person_statement address country type
10.addresses.0 10 St Andrews Castle, 33 St Andrews Street South, Bury St. Edmunds, Suffolk, IP33 3PH GB registered
1000.addresses.0 1000 Cgc, Tiddly Wink, Yatton Keynell, Chippenham, Wiltshire, SN14 7BY GB registered
10000.addresses.0 10000 Optionis House, 840 Ibis Court, Centre Park, Warrington, WA1 1RL FI registered
1000000.addresses.0 1000000 20-22, Wenlock Road, London, N1 7GU GB registered
1000001.addresses.0 1000001 33a, St Woolos Road, Newport, S Wales, NP20 4GN PH registered
1000002.addresses.0 1000002 Unit B First Floor, Bedford Business Centre, Bedford, MK43 8QR GB registered
1000003.addresses.0 1000003 Floessergasse 4, Munich, Bavaria, 81369 DE registered
1000005.addresses.0 1000005 Suite 52a, Church Street, Hampshire, RG21 7QE GB registered
1000006.addresses.0 1000006 61, Bridge Street, Kington, HR5 3DJ GB registered
1000008.addresses.0 1000008 Unit 1 - Freemantle Business Centre, 152 Millbrook Road East, Southampton, SO15 1JR GB registered
1000009.addresses.0 1000009 148a, Merton High Street, London, SW19 1AZ GB registered
100001.addresses.0 100001 20-22, Wenlock Road, London, N1 7GU GB registered
1000010.addresses.0 1000010 Business First Ltd, Davyfield Road, Blackburn, BB1 2QY GB registered
1000011.addresses.0 1000011 49, Balnacraig Avenue, London, NW10 1TE GB registered
1000015.addresses.0 1000015 103a, Main Street, Fivemiletown, BT75 0PG GB registered
1000021.addresses.0 1000021 Flat 6, 12 Salutary Mount, Heavitree, Exeter, EX1 2QE GB registered
1000023.addresses.0 1000023 Ainsworths, Charter House, Stansfield Street, Nelson, BB9 9XY GB registered
1000024.addresses.0 1000024 11, Hoker Road, Exeter, Devon, EX2 5HR GB registered
1000025.addresses.0 1000025 2, Saxton Road, Lydd On Sea, TN29 9NX GB registered
1000026.addresses.0 1000026 11, West Street, Sheffield, S21 4GA GB registered
1000027.addresses.0 1000027 Room 104, Unit 2, Building 2, No. 51, Ningxia Road, Shibei District, Qingdao City, Shandong Province GB registered
1000028.addresses.0 1000028 Marlowe House, Watling Street, Hockliffe, Leighton Buzzard, LU7 9LS BD registered
100003.addresses.0 100003 58, Ravenslea, Ravenstone, Coalville, Leicestershire, LE67 2AU GB registered
1000030.addresses.0 1000030 Kemp House, 152 - 160 City Road, London, EC1V 2NX GB registered
1000031.addresses.0 1000031 36, Clydesdale Avenue, Stanmore, HA7 1LW GB registered
1000033.addresses.0 1000033 1904 Sky View Tower, High Street, London, E15 2GT GB registered
1000034.addresses.0 1000034 Flat 4, 51 Popes Grove, Twickenham, TW1 4JZ GB registered
1000035.addresses.0 1000035 33a, St Woolos Road, Newport, S Wales, NP20 4GN PH registered
1000038.addresses.0 1000038 Rutherford House St 157, Warrington Road, Warrington, WA3 6ZH PH registered
100004.addresses.0 100004 Burnt House Gardens, Haywards Heath Road, North Chailey, Lewes, East Sussex, BN8 4DJ GB registered
1000040.addresses.0 1000040 12, Halkin Close, Preston, PR2 8HD GB registered
1000042.addresses.0 1000042 3459, South Fm 372, Gainesville, Texas, 76240 US registered
1000043.addresses.0 1000043 23, Austin Friars, London, EC2N 2QP GB registered
1000046.addresses.0 1000046 136, Timber Mill, Southwater, Horsham, West Sussex, RH13 9SR GB registered
100005.addresses.0 100005 114 Towngate, Silkstone, Barnsley, South Yorkshire, S75 4SY GB registered
1000050.addresses.0 1000050 Flat 1 The Grange, Chelford Road, Knutsford, Cheshire, WA16 8NW GB registered
1000051.addresses.0 1000051 35, Wheeler Street, Maidstone, ME14 1UA GB registered
1000052.addresses.0 1000052 18, Church Street, Ashton Under Lyne, OL6 6XE GB registered
1000053.addresses.0 1000053 Stron House, 100 Pall Mall, London, SW1Y 5EA NO registered
1000054.addresses.0 1000054 55 Suite 900, Lake Avenue, Pasadena, California, 91101 US registered
1000058.addresses.0 1000058 14, Keswick Drive, Blackburn, BB25HH GB registered
1000059.addresses.0 1000059 Aston House, Cornwall Avenue, Finchley, N3 1LF GB registered
1000060.addresses.0 1000060 70, Parkes Street, Smethwick, B67 6AZ GB registered
1000061.addresses.0 1000061 4, Manse Terrace, Peterhead, AB42 3AS GB registered
1000062.addresses.0 1000062 15 Warneford Court, 10 Mannock Close, London, NW9 5WD GB registered
1000063.addresses.0 1000063 121 Cleeve Drive, Ivybridge, PL21 9DB GB registered
1000064.addresses.0 1000064 Unit 10, Automotive Court, Prince William Ave, Deeside, Cheshire, CH5 2QZ GB registered
1000069.addresses.0 1000069 71-75 Shelton Street, Covent Garden, London, WC2H 9JQ IT registered
1000071.addresses.0 1000071 150 Farrant Avenue, Farrant Avenue, London, N22 6PG GB registered
1000072.addresses.0 1000072 39 Kingfisher Heights, 2 Bramwell Way, London, E16 2GQ GB registered
1000073.addresses.0 1000073 Axwel House, 2 Westerton Road, Broxburn, West Lothian, EH52 5AU GB registered
1000074.addresses.0 1000074 Rutherford House St, 157 Warrington Road, Warrington, WA3 6ZH PH registered
1000076.addresses.0 1000076 42 Church Road, Church Road, Hove, BN3 2FN GB registered
1000077.addresses.0 1000077 46, The Piazza, Eastbourne, East Sussex, BN23 5TG GB registered
1000078.addresses.0 1000078 20-22, Wenlock Road, London, N1 7GU GB registered
1000079.addresses.0 1000079 Marlowe House, Watling Street, Hockliffe, Leighton Buzzard, LU7 9LS BD registered
1000080.addresses.0 1000080 20, Victoria Road, Ruislip, HA4 0AB GB registered
1000081.addresses.0 1000081 Landmark House, 43-45, Merton Road, Merseyside, Liverpool, L20 7AP GB registered
1000082.addresses.0 1000082 140, Uppingham Avenue, Stanmore, Harrow, HA7 2JU GB registered
1000083.addresses.0 1000083 Unit 25b Park View Road West, Park View Industrial Estate, Hartlepool, Cleveland, TS25 1PE HK registered
1000084.addresses.0 1000084 3, Dorman Gardens, Middlesbrough, TS5 5DS GB registered
1000085.addresses.0 1000085 320 Firecrest Court, Centre Park, Warrington, WA1 1RG GB registered
1000087.addresses.0 1000087 Office 9a Colne House, 96 Mount Chambers, Coggeshall Road, Braintree, Essex, CM7 9BY GB registered
1000088.addresses.0 1000088 Crispins, Manor Farm Lane, Michelmersh, Romsey, SO51 0NT GB registered
1000091.addresses.0 1000091 55, Florence Road, Brighton, BN1 6DL GB registered
1000092.addresses.0 1000092 11 Rosefield Gardens, 11 Rosefield Gardens, London, E14 8ER GB registered
1000093.addresses.0 1000093 27, Broadway Market, London, E8 4PH GB registered
1000094.addresses.0 1000094 Verify House, Grange Road, Alcester, B50 4BY GB registered
1000095.addresses.0 1000095 20 Pentland Avenue, Chelmsford, Essex GB registered
1000098.addresses.0 1000098 30, Oval Road, London, NW1 7DE GB registered
1000099.addresses.0 1000099 Suite 433, 14, London Road, Guildford, Surrey, GU1 2AG GB registered
10001.addresses.0 10001 The Retreat, 406 Roding Lane South, Woodford Green, Essex, IG8 8EY GB registered
100010.addresses.0 100010 14, Market Place, Acton, London, W3 6QS GB registered
1000101.addresses.0 1000101 4, Seamore Close, Benfleet, Essex, SS7 4EY GB registered
1000102.addresses.0 1000102 Mulberry House, Buntsford Park Road, Bromsgrove, B60 3DX GB registered
1000104.addresses.0 1000104 4, Coopers Way, Blackpool, FY1 3RJ GB registered
1000106.addresses.0 1000106 Office 3, 146/148 Bury Old Road, Whitefield, Manchester, M45 6AT GB registered
1000107.addresses.0 1000107 15, Poplar Avenue, Crofton Heath, Orpington, Kent, BR6 8LA GB registered
100011.addresses.0 100011 19/21 Swan Street, West Mallng, Kent, ME19 6JU GB registered
1000110.addresses.0 1000110 Barnsdale Lodge, The Avenue, Exton, Rutland, LE15 8AH GB registered
1000111.addresses.0 1000111 7, Barratt Road, Eckington, Derbyshire, S204AN GB registered
1000112.addresses.0 1000112 22 Sandy Lane, Chippenham, Wiltshire, SN15 2PZ GB registered
1000115.addresses.0 1000115 Brunel House, 340 Firecrest Court, Centre Park, Warrington, Cheshire, WA1 1RG GB registered
1000117.addresses.0 1000117 Suite 112-113 Cumberland House, Scrubs Lane, London, NW10 6RF GB registered
1000119.addresses.0 1000119 Apollo House, Hallam Way, Whitehills Business Park, Blackpool, FY4 5FS GB registered
100012.addresses.0 100012 1, St. Johns Lane, Stansted, Essex, CM24 8JU GB registered
1000120.addresses.0 1000120 Studio 4, Mainyard Studios,, 5 Argall Avenue, London, E10 7QE GB registered
1000122.addresses.0 1000122 14, Fountain Lane, Northwich, Cheshire, CW9 8LT GB registered
1000124.addresses.0 1000124 95, Compton Crescent, Chessington, KT9 2HG GB registered
1000127.addresses.0 1000127 C/O Resolve Advisory Limited, 22 York Buildings, London, WC2N 6JU SG registered
1000130.addresses.0 1000130 The Counting House, 9, High Street, Tring, Herts, HP23 5TE GB registered
1000131.addresses.0 1000131 Swatton Barn, Badbury, Swindon, SN4 0EU DE registered
1000133.addresses.0 1000133 32a, Fryston Road, Castleford, WF10 3EW GB registered
1000134.addresses.0 1000134 Unit 1 Rowan Court, 56 High Street Wimbledon, London, SW19 5EE GB registered
1000135.addresses.0 1000135 20-22, Wenlock Road, London, N1 7GU GB registered
1000136.addresses.0 1000136 34, St. Matthews Gardens, Cambridge, CB1 2PJ GB registered
1000137.addresses.0 1000137 14a, Huggins Lane, North Mymms, Hatfield, AL9 7LR GB registered
1000138.addresses.0 1000138 51, Great Cambridge Road, Haringey, N17 7LJ GB registered
1000139.addresses.0 1000139 71-75, Shelton Street, London, WC2H 9JQ QA registered
100014.addresses.0 100014 255, Bacup Road, Rossendale, Lancashire, BB4 7PA GB registered

Next page

Advanced export

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

CSV options:

CREATE TABLE [person_addresses] ( [_link] TEXT 
 , [_link_person_statement] TEXT 
 , [address] TEXT 
 , [country] TEXT 
 , [type] TEXT 
 , PRIMARY KEY ([_link]) 
 , FOREIGN KEY ([_link_person_statement]) REFERENCES [person_statement]([_link]) 
   );
Powered by Datasette · Queries took 1415.313ms