Spreadsheet: 550977d1512641339-how-to-collate-related-data-in-excel-1
Sheet: Sheet1

# | [NAME] | Tenant_Code | Landlord_Code | LLTitle | LLFname | LLSName | House_name | Street_Name | GroundDate | RentBookPr | InvChecked | Finalinsp | DepositRet | ElecMeter | ElecReading | GasMeter | GasReading | UtilityNot | KeysRet | LandlordNot | First_Rent | ElecMeter2 | Match | Beds | WaterUt | GasUt | ElectUt | Council | Pic1 | Pic2 | Pic3 | Pic4 | Pic5 | SixMonth | Picture1 | PropCode | [NAME] | LockCode | Quarter | PetsAcc | UpDatePhoto | UpLoadPhotos | Market | Type2 | Market_Price | ChkGas | ChkIns | ChkElect | ChkMid | ChkMaint | ChkGround | ChkRenew | Cats | Smokers | DSS | Child | Avail_Date | EnergyBand | ChkEnergy | EnergyBand2 | LetType | SendFishPhoto | EtcCode | PropRef | AssignedTo | UnderApp | BoardOk | KeyOut | ServChgDate | ServChg | ServChgPeriod | ServChgDate2 | ServChgDate3 | [NAME] | Applicant
1 | 91 | 0 | 0 |  |  |  |  | X-Report | 2099-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | True |  |  |  |  | 2099-01-01 00:00:00 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
2 | 12 | 3 | 5 | Mr | [NAME] | EXAMPLE |  | 17 Abbotts View | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 550 |  | False | 3 | 3 | 1 | 2 | 6 | \Photos\5a.jpg |  |  |  |  |  |  | 44a |  |  |  | True | 17/11/2001 | True | False | End Terrace | 746 | True | True | True | True | True | True | True | True | True | True | True | 2008-12-07 00:00:00 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
3 | 6 | 5091 | 6 |  |  | EXAMPLE |  | 2 Arundel House | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 560 |  | False |  |  |  |  |  | \Photos\6a.jpg |  |  |  |  | False |  | 33b |  |  | False | False | 2017-04-01 00:00:00 | True | False | Studio Flat | 560 | True | True | True | True | True | True | True | False | False | False | False | 16/02/2018 | C | True |  | not specified | True | 0738-0069-6238-4898-7030 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
4 | 621 | 0 | 8 | Mr | [NAME] | EXAMPLE | Basement Flat | 389 Brighton Road | 2099-01-01 00:00:00 | False | False | False | False | False | Key | False |  | False | False | False | 3000 |  | False | 1 |  |  |  |  | \Photos\8a.jpg |  |  |  |  | True |  | 89b |  |  | False | False | 2009-12-06 00:00:00 | True | False | Flat | 500 | False | True | True | False | True | True | True | False | False | False | False | 30/11/2099 | E | True |  | not specified | True | 0660-2814-6257-0991-1311 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
5 | 3 | 3405 | 9 | Mrs | [NAME] | EXAMPLE |  | 22 Amberley Court | 2099-01-01 00:00:00 | False | False | False | False | False | 50593 | False |  | False | False | False | 3300 | 23968 | False | 1 |  |  |  |  | \Photos\9a.jpg |  |  |  |  | False |  |  |  |  | False | False | 18/06/2012 | True | False | Flat | 575 | False | True | True | True | True | True | True | False | False | False | False | 25/07/2099 | E | True | F | not specified | True | 8722-6825-9960-0850-7972 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
6 | 1 | 2563 | 12 | Mr & Mrs | R | EXAMPLE |  | 118 Brighton Road | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 5250 |  | False | 3 |  |  |  |  | \Photos\12a.jpg | \Photos\12b.jpg | \Photos\12c.jpg | \Photos\12d.jpg | \Photos\12e.jpg | False |  | 58 |  |  | False | False | 2006-09-08 00:00:00 | False | False | Semi-Detached House | 1200 | True | True | True | True | True | True | True | False | False | False | True | 22/01/2010 | C | True | D | not specified | True | 8.69169236660042e+19 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
7 | 15 | 2052 | 15 | Mr | J.R | EXAMPLE |  | 24 Avon Close | 2099-01-01 00:00:00 | False | False | False | False | False | key | False | n/a | False | False | False | 4170 |  | False | 3 |  |  |  |  | \Photos\15a.jpg | \Photos\15b.jpg | \Photos\15c.jpg | \Photos\15d.jpg | \Photos\15e.jpg | False |  | 9 |  |  | False | False | 2007-08-10 00:00:00 | False | False | Terraced House | 800 | False | True | True | True | True | True | True | False | False | False | True | 15/05/2099 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
8 | 34 | 4899 | 31 | Mr | [NAME] | EXAMPLE |  | 19a Bridge Road | 2099-01-01 00:00:00 | False | False | False | False | False | key | False |  | False | False | False | 575 |  | False | 1 | 3 |  | 2 | 10 | \Photos\34a.jpg |  |  |  |  | False |  | 47a |  |  | False | False | 2017-06-01 00:00:00 | True | False | Flat | 575 | False | True | True | True | True | True | True | False | False | False | False | 29/01/2018 | D | True |  | not specified | True | 0068 3024 7277 1724 9960 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
9 | 37 | 41 | 34 | Mrs | Beryl | EXAMPLE |  | 18 Busticle Lane | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 440 |  | False | 2 |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  | True | 2000-01-01 00:00:00 | False | False | Semi-Detached Bungal | 750 | True | True | True | True | True | True | True | True | True | True | True | 2099-04-06 00:00:00 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
10 | 53 | 359 | 50 | Mr | Stephen | EXAMPLE |  | 11 Cottenham Road | 2099-01-01 00:00:00 | False | False | False | False | False | 5433 | False | 358 | False | False | False | 575 |  | False | 3 | 3 | 1 | 2 | 10 |  |  |  |  |  | False |  | 17b |  |  |  | True | 25/08/2017 | True | False | Terraced House | 860 | True | True | True | True | True | True | True | True | True | True | True | 18/09/2099 | D | True |  | not specified | True | 8406 3675 0329 5327 6833 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
11 | 67 | 4733 | 62 | Mrs | Rosemary | EXAMPLE |  | 8 [NAME] | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 490 |  | False |  |  |  |  |  | \Photos\67a.jpg | \Photos\67b.jpg | \Photos\67c.jpg | \Photos\67d.jpg | \Photos\67e.jpg | False |  | 54 |  |  | False | False | 29/04/2016 | True | False | Studio Flat | 490 | False | True | True | True | True | True | True | False | True | False | False | 2099-01-12 00:00:00 | F | True |  | not specified | True | 8.68777270450251e+19 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
12 | 75 | 5131 | 70 | Mr & Mrs | Dennis & Valerie | EXAMPLE |  | 2 Ferrywaye Court | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 750 |  | False | 1 |  |  |  |  | \Photos\75a.jpg |  |  |  |  | False |  | 14 |  |  | False | False | 24/08/2017 | True | False | Flat | 750 | False | True | True | True | True | True | True | False | False | False | False | 2018-11-04 00:00:00 | D | True | E | not specified | True | 2.82283966939129e+18 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
13 | 76 | 1172 | 71 | Mr | Mehmet | EXAMPLE |  | 57 Fircroft Avenue | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 625 |  | False | 2 |  |  |  |  | \Photos\76a.jpg |  |  |  |  | False |  |  |  |  | False | True | 28/09/2015 | True | False | End of Terrace | 880 | True | True | True | True | True | True | True | True | True | True | True | [NAME] |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
14 | 80 | 5099 | 75 | Mr | [NAME] | EXAMPLE | First Floor Flat | 17 Garrick Road | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 700 |  | False | 1 | 3 |  | 2 | 10 |  |  |  |  |  | False |  | 117 |  |  | False | False | 28/07/2017 | True | False | Flat | 700 | False | True | True | True | True | True | True | False | False | False | False | 15/03/2018 | E | True |  | not specified | True | 8.5457122313093e+19 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
15 | 82 | 4895 | 77 | Mrs | [NAME] | EXAMPLE |  | 8 Dominion Close | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 1000 |  | False | 3 |  |  |  |  |  |  |  |  |  | False |  |  |  |  | False | False | 21/11/2016 | True | False | Terraced House | 1000 | True | True | True | True | True | True | True | False | False | False | True | 22/07/2099 | C | True | C | not specified | True | 8.18197562596391e+17 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
16 | 84 | 3893 | 76 | Mr | [NAME] | EXAMPLE | Flat 1 | 36 Dominion Road (F1) | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 550 |  | False | 1 |  |  |  |  |  |  |  |  |  | False |  | 2b |  |  | False | False | [NAME] | True | False | Flat | 550 | False | True | True | True | True | True | True | False | False | False | True | 13/03/2099 | E | True | F | not specified | True | 8.00017159329172e+19 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
17 | 89 | 0 | 82 | Mr | [NAME] | EXAMPLE | First Floor Flat | 20 Grand Avenue | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 4950 |  | False | 3 | 3 | 1 | 2 | 10 | \Photos\89a.jpg | \Photos\89b.jpg | \Photos\89c.jpg | \Photos\89d.jpg | \Photos\89e.jpg | True |  |  |  |  | False | False | 2015-05-02 00:00:00 | True | False | Flat | 825 | False | True | True | True | True | True | True | False | False | False | False | 30/09/2015 | E | True | F | not specified | True | 7.78808762925571e+18 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
18 | 91 | 1356 | 83 | Mrs | L | EXAMPLE |  | 13 Gordon Avenue | 2099-01-01 00:00:00 | False | False | False | False | False | 5919 | False | 6877 | False | False | False | 795 | 01365 04554 | False | 3 |  |  |  |  | \Photos\91a.jpg |  |  |  |  | False |  | 4d |  |  | False | False | 23/09/2002 | False | False | Semi-Detached House | 1000 | True | True | True | True | True | True | True | False | True | False | True | 13/10/2099 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
19 | 93 | 0 | 85 | Mrs | G.M | EXAMPLE |  | 12 Grafton Gardens | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 450 |  | False | 2 |  |  |  |  |  |  |  |  |  | False |  |  |  |  | False | True | 2000-01-01 00:00:00 | False | False | Semi-Detached Bungal | 630 | True | True | True | True | False | False | True | True | True | True | True | 14/05/2008 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
20 | 99 | 3979 | 92 | Mr | [NAME] | EXAMPLE |  | 6 Katherines Lodge | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 560 |  | False | 1 |  |  |  |  | \Photos\99a.jpg | \Photos\99b.jpg |  |  |  | False |  | 70 |  |  | False | False | 2016-12-05 00:00:00 | True | False | Flat | 585 | False | True | True | True | True | True | True | False | False | False | False | 20/05/2015 | D | True |  | not specified | True | 2848-4038-7211-1647-2944 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
21 | 101 | 5074 | 93 | Mrs | [NAME] | EXAMPLE |  | 2 Elm Grove House | 2099-01-01 00:00:00 | False | False | False | False | False | 25445 | False |  | False | False | False | 675 | 71560 | False | 1 |  |  |  |  | \Photos\101a.jpg | \Photos\101b.jpg | \Photos\101c.jpg | \Photos\101d.jpg |  | False |  | 36b |  |  | False | False | 27/06/2017 | True | False | Flat | 675 | False | True | True | True | True | True | True | False | False | False | False | 2018-01-02 00:00:00 | F | True | E | not specified | True | 8.20921176929059e+19 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
22 | 105 | 0 | 96 | Mrs | J | EXAMPLE |  | 8 Essex Court | 2099-01-01 00:00:00 | False | False | False | False | False | 63647 | False |  | False | False | False | 360 | 27375 | False | 1 |  |  |  |  |  |  |  |  |  | False |  |  |  |  |  | True | 2000-01-01 00:00:00 | False | False | Flat | 475 | True | True | True | True | True | True | True | True | True | True | True | 2001-01-01 00:00:00 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
23 | 110 | 3673 | 100 | Mrs | A T | EXAMPLE |  | 72 [NAME] | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 675 |  | False | 2 |  |  |  |  |  |  |  |  |  | False |  | 11d |  |  | False | True | 20/05/2016 | True | False | Bungalow | 800 | True | True | True | True | True | True | True | True | True | True | True | 2099-03-03 00:00:00 |  | False |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
24 | 112 | 3191 | 103 | Mr | [NAME] | EXAMPLE | Ground Floor Flat | 133 Kings Road (GFF) | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 525 |  | False | 1 |  |  |  |  | \Photos\112a.jpg |  |  |  |  | False |  | 3 |  |  | False | False | 2011-03-08 00:00:00 | True | False | Flat | 575 | False | True | True | True | True | True | True | False | False | False | False | 13/04/2099 | C | True | E | not specified | True | 5.92897647401917e+17 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
25 | 113 | 1815 | 104 | Mr | G M | EXAMPLE |  | 23 Kings Court | 2099-01-01 00:00:00 | False | False | False | False | False | 63096 | False | 3600 | False | False | False | 575 |  | False | 1 |  |  |  |  | \Photos\113a.jpg |  |  |  |  | False |  | 83c |  |  | False | False | 2006-11-12 00:00:00 | False | False | Flat | 600 | True | True | True | True | True | True | True | False | False | False | False | 21/08/2099 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
26 | 118 | 2291 | 109 | Mr | [NAME] | EXAMPLE |  | 32 The Lynchette | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 775 |  | False | 3 |  |  |  |  | \Photos\118a.jpg | \Photos\118b.jpg | \Photos\118c.jpg | \Photos\118d.jpg | \Photos\118e.jpg | False |  | 87b |  |  | False | False | 2008-12-08 00:00:00 | False | False | Terraced House | 800 | True | True | True | True | True | True | True | False | True | True | True | 17/03/2009 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
27 | 119 | 3336 | 110 | Mr | [NAME] | EXAMPLE |  | 19 Hamilton Court | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 550 |  | False | 2 |  |  |  |  | \Photos\119a.jpg |  |  |  |  | False |  | 50b |  |  | False | False | 19/03/2012 | True | False | Flat | 575 | True | True | True | True | False | False | True | False | True | False | False | 28/09/2099 | E | True |  | not specified | True | 2368-2090-6264-8269-2970 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
28 | 146 | 3753 | 132 |  |  | EXAMPLE | Flat 2 | 1 [NAME] | 2099-01-01 00:00:00 | False | False | False | False | False | 52695 | False | 782 | False | False | False | 8700 | 99786 | False | 2 | 3 | 1 | 2 | 6 | \Photos\146a.jpg | \Photos\146b.jpg | \Photos\146c.jpg | \Photos\146d.jpg | \Photos\146e.jpg | False |  | 42 |  |  | False | False | 19/02/2013 | True | False | Flat | 725 | True | True | True | True | True | True | True | True | False | False | False | 24/04/2014 | F | True | F | not specified | True | 2688-8052-6244-6311-2064 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
29 | 149 | 0 | 135 | Mr | D | EXAMPLE | Ground Floor Flat | 10 Meadow Road | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 325 |  | False | 1 |  |  |  |  | \Photos\149a.jpg |  |  |  |  |  |  | 51a |  |  |  | True | 23/12/2004 | True | False | Flat | 525 | True | True | True | True | True | True | True | True | True | True | True | 25/10/2096 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
30 | 151 | 1011 | 137 | Mr & Mrs | A | EXAMPLE |  | 37 Newland Road | 2099-01-01 00:00:00 | False | False | False | False | False | key | False | 2519 | False | False | False | 575 |  | False | 2 |  |  |  |  | \Photos\151a.jpg |  |  |  |  | False |  | 34a |  |  | False | True | 2016-05-10 00:00:00 | True | False | Terraced House | 760 | True | True | True | True | False | False | True | True | True | False | True | 30/04/2004 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
31 | 158 | 5147 | 145 | Mrs | [NAME] | EXAMPLE |  | 7 Northcourt Road | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 1100 |  | False | 3 |  |  |  |  | \Photos\158a.jpg | \Photos\158b.jpg | \Photos\158c.jpg | \Photos\158d.jpg | \Photos\158e.jpg | False |  | 6c |  |  | False | False | 2017-07-10 00:00:00 | True | False | Terraced House | 1100 | True | True | True | True | False | False | True | False | False | False | False | 2018-05-05 00:00:00 | E | True | E | not specified | True | 4.752822692391e+18 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
32 | 159 | 0 | 146 | Mr | [NAME] | EXAMPLE |  | 34 Milford Court | 2099-01-01 00:00:00 | False | False | False | False | False | edf  supplier | False |  | False | False | False | 600 | read 31-7-09 by LL | False | 2 |  |  | 6 |  | \Photos\159a.jpg |  |  |  |  | False |  |  |  |  | False | False | 2009-10-06 00:00:00 | False | False | Flat | 600 | False | True | True | True | True | True | True | False | False | False | True | 2014-05-05 00:00:00 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
33 | 160 | 4468 | 111 | Mr | Stephen | EXAMPLE |  | 4 Meadow Road | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 880 |  | False | 2 |  |  |  |  | \Photos\160a.jpg |  |  |  |  | False |  | 71e |  |  | False | False | 2015-01-10 00:00:00 | True | False | Semi-Detached House | 880 | True | True | True | True | True | True | True | False | False | False | True | 2099-09-01 00:00:00 | D | True |  | not specified | True | 8102 [PHONE] 6273 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
34 | 161 | 2426 | 147 | Mr | R.K | EXAMPLE |  | 7 Marine Point | 2099-01-01 00:00:00 | False | False | False | False | False | 9593 | False |  | False | False | True | 595 | 2934 | False | 1 |  |  |  |  | \Photos\161a.jpg | \Photos\161b.jpg | \Photos\161c.jpg | \Photos\161d.jpg | \Photos\161e.jpg | False |  |  |  |  | False | True | 22/09/2016 | True | False | Flat | 700 | False | True | True | True | True | True | True | True | False | False | False | 22/12/2017 | C | True |  | not specified | True | 0052-2868-6390-0201-8805 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
35 | 163 | 4762 | 149 |  |  | EXAMPLE |  | 3 Mill Road | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 1100 |  | False | 2 |  |  |  |  | \Photos\163a.jpg |  |  |  |  | False |  | 47e |  |  | False | False | 29/06/2016 | True | False | Cottage | 1100 | True | True | True | True | False | False | True | True | False | False | True | 2099-12-07 00:00:00 | E | True |  | not specified | True | 2.45285874679626e+18 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
36 | 164 | 1198 | 150 | Mr & Mrs | S | EXAMPLE |  | 15 Monks Avenue | 2099-01-01 00:00:00 | False | False | False | False | False | 54083 | False | 2129 | False | False | False | 675 |  | False | 3 |  |  |  |  | \Photos\164a.jpg | \Photos\164b.jpg |  |  |  | False |  | 30c |  |  | False | False | 24/08/2016 | True | False | Semi-Detached House | 900 | True | True | True | True | True | True | True | True | False | False | True | 27/02/2099 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
37 | 166 | 4252 | 152 | Mrs | [NAME] | EXAMPLE |  | 2 Myrtle Lodge | 2099-01-01 00:00:00 | False | False | False | False | False | 3745 & 10361 | False |  | False | False | False | 575 | 8167 | False | 1 |  |  |  |  | \Photos\166a.jpg |  |  |  |  | False |  | 19 |  |  | False | False | 17/09/2014 | True | False | Flat | 575 | False | True | True | True | False | False | True | False | False | False | False | 30/04/2099 | E | True |  | not specified | True | 8.40272214129999e+19 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
38 | 167 | 3119 | 121 | Mrs | [NAME] | EXAMPLE |  | 12a Meadway Court | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 650 |  | False | 2 |  |  |  |  | \Photos\167a.jpg |  |  |  |  | False |  |  |  |  | False | False | 2011-10-06 00:00:00 | True | False | Flat | 700 | True | True | True | True | True | True | True | False | False | False | True | 17/01/2012 | B | True | B | not specified | True | 8.38160216430875e+19 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
39 | 174 | 0 | 157 | Mr | K | EXAMPLE |  | 11 Rowan House | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 400 |  | False | 2 |  | 6 | 2 | 5 | \Photos\174a.jpg | \Photos\174b.jpg | \Photos\174c.jpg | \Photos\174d.jpg |  |  |  |  |  |  |  | False | 2006-09-02 00:00:00 | False | False | Flat | 625 | True | True | True | True | True | True | True | False | True | True | True | 2001-01-01 00:00:00 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
40 | 180 | 3644 | 162 | Mr & Mrs | S | EXAMPLE |  | 10 Palm Court | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 3300 |  | False | 1 |  |  |  |  | \Photos\180a.jpg |  |  |  |  | True |  |  |  |  | False | False | 2012-11-12 00:00:00 | True | False | Flat | 550 | False | True | True | False | True | True | True | False | False | False | False | 2099-04-07 00:00:00 | C | True | C | not specified | True | 9498-2997-7252-0832-7930 |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
41 | 186 | 0 | 168 | Miss | Julie | EXAMPLE | Ground Floor Flat | [NAME] | 2099-01-01 00:00:00 | False | False | False | False | False |  | False |  | False | False | False | 525 |  | False | 1 |  |  |  |  | \Photos\186a.jpg |  |  |  |  | False |  |  |  |  | False | False | 2003-04-12 00:00:00 | True | False | Flat | 550 | True | True | True | True | True | True | True | False | False | False | False | 2099-08-03 00:00:00 |  | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00
42 | 187 | 4513 | 170 | Mr | [NAME] | EXAMPLE |  | 9 Ryecroft Court | 2099-01-01 00:00:00 | False | False | False | False | False | 4511 | False |  | False | False | True | 625 | 3273 | False | 1 |  |  |  |  | \Photos\187a.jpg | \Photos\187b.jpg | \Photos\187c.jpg | \Photos\187d.jpg | \Photos\187e.jpg | False |  | 18d |  |  | False | False | 23/06/2016 | True | False | Flat | 650 | False | True | True | True | True | True | True | False | False | False | False | 2099-04-07 00:00:00 | C | True |  | not specified | True |  |  |  | False | True | False | 2099-01-01 00:00:00 | 0 | Annually | 2099-01-01 00:00:00 | 2099-01-01 00:00:00 | 2099-01-01 00:00:00