Spreadsheet: 148410d1333390639-required-different-location-data-to-different-file-all-location-data
Sheet: Sheet1

S. No. | Location | Date of Action | Property ID | Tenure ID
1 | India | 2012-02-24 00:00:00 | 31444200 | 8978
 | China | 2012-02-23 00:00:00 | 30374900 | 1506
 | Singapore | 2012-02-29 00:00:00 | 31678000 | 61299
 | Pakistan | 2012-03-13 00:00:00 | 31678000 | 61299
 | London | 2012-02-29 00:00:00 | 31926600 | 78670
 | India | 2012-02-24 00:00:00 | 30879500 | 3694
 | China | 2012-02-24 00:00:00 | 31872800 | 76679
 | Singapore | 2012-02-24 00:00:00 | 31719500 | 62211
 | Pakistan | 2012-02-23 00:00:00 | 32014800 | 83412
 | India | 2012-02-24 00:00:00 | 31938000 | 83164
 | China | 2012-02-24 00:00:00 | 31436200 | 8802
 | Singapore | 2012-02-23 00:00:00 | 31548800 | 46279
 | Pakistan | 2012-02-23 00:00:00 | 31693300 | 61144
 | London | 2012-02-24 00:00:00 | 32011600 | 83759
 | India | 2012-02-23 00:00:00 | 319339900 | 79851
 | China | 2012-02-23 00:00:00 | 31620000 | 57333
 | Singapore | 2012-02-24 00:00:00 | 31371000 | 7733
 | Pakistan | 2012-02-24 00:00:00 | 31583600 | 47856
 | London | 2012-02-24 00:00:00 | 31591200 | 53054
 | India | 2012-02-24 00:00:00 | 31288500 | 6553
 | China | 2012-02-27 00:00:00 | 31793700 | 67620
 | Singapore | 2012-02-24 00:00:00 | 31151800 | 5774
 | Pakistan | 2012-02-24 00:00:00 | 31748200 | 62954
 | London | 2012-02-27 00:00:00 | 31957300 | 81061
 | India | 2012-02-27 00:00:00 | 31714300 | 80135
 | China | 2012-02-27 00:00:00 | 32058500 | 85054
 | Singapore | 2012-02-27 00:00:00 | 31472400 | 9781
 | Pakistan | 2012-02-27 00:00:00 | 31014800 | 52982
 | India | 2012-02-27 00:00:00 | 31668800 | 61939
 | China | 2012-02-27 00:00:00 | 31082400 | 5022
 | Singapore | 2012-02-29 00:00:00 | 31082400 | 5022
 | Pakistan | 2012-02-27 00:00:00 | 31589100 | 53048
 | London | 2012-02-27 00:00:00 | 31993900 | 82917
 | India | 2012-02-27 00:00:00 | 31488800 | 9844
 | China | 2012-03-05 00:00:00 | 31921400 | 78281
 | Singapore | 2012-02-27 00:00:00 | 31500000 | 44433
 | Pakistan | 2012-02-29 00:00:00 | 31326000 | 7090
 | London | 2012-02-27 00:00:00 | 30894900 | 2824
 | India | 2012-02-29 00:00:00 | 31700600 | 62382
 | China | 2012-02-27 00:00:00 | 31355200 | 7535
 | Singapore | 2012-03-16 00:00:00 | 31355200 | 7535
 | Pakistan | 2012-02-29 00:00:00 | 31241600 | 6034
 | London | 2012-02-29 00:00:00 | 30677900 | 5952
 | India | 2012-02-29 00:00:00 | 31671200 | 59930
 | China | 2012-03-01 00:00:00 | 31798900 | 75705
 | Singapore | 2012-03-12 00:00:00 | 30388800 | 21
 | Pakistan | 2012-03-15 00:00:00 | 30388800 | 21
 | India | 2012-03-01 00:00:00 | 32003000 | 83193
 | China | 2012-03-01 00:00:00 | 31851100 | 79160
 | Singapore | 2012-03-01 00:00:00 | 31871000 | 75910
 | Pakistan | 2012-03-01 00:00:00 | 31116500 | 4603
 | London | 2012-03-02 00:00:00 | 31116000 | 4599
 | India | 2012-03-09 00:00:00 | 31116000 | 4599
 | China | 2012-03-02 00:00:00 | 31115600 | 4595
 | Singapore | 2012-03-09 00:00:00 | 31115600 | 4595
 | Pakistan | 2012-03-03 00:00:00 | 31115800 | 4597
 | London | 2012-03-13 00:00:00 | 31115800 | 4597
 | India | 2012-03-03 00:00:00 | 31117500 | 4610
 | China | 2012-03-12 00:00:00 | 31117500 | 4610
 | Singapore | 2012-03-02 00:00:00 | 31166000 | 5319
 | Pakistan | 2012-03-03 00:00:00 | 31116300 | 4601
 | London | 2012-03-13 00:00:00 | 31116300 | 4601
 | India | 2012-03-01 00:00:00 | 30034500 | 58150
 | China | 2012-02-29 00:00:00 | 31922400 | 82717
 | Singapore | 2012-02-29 00:00:00 | 31115700 | 4596
 | Pakistan | 2012-02-29 00:00:00 | 31116400 | 4602
 | India | 2012-02-29 00:00:00 | 31116600 | 4604
 | China | 2012-02-29 00:00:00 | 31117100 | 4608
 | Singapore | 2012-02-29 00:00:00 | 31115900 | 4598
 | Pakistan | 2012-02-29 00:00:00 | 31116200 | 4600
 | London | 2012-02-29 00:00:00 | 31117300 | 4609
 | India | 2012-02-29 00:00:00 | 31117600 | 4612
 | China | 2012-03-01 00:00:00 | 31800500 | 73179
 | Singapore | 2012-03-02 00:00:00 | 31704100 | 61619
 | Pakistan | 2012-03-02 00:00:00 | 31704100 | 61619
 | India | 2012-03-02 00:00:00 | 31704100 | 61619
 | China | 2012-02-29 00:00:00 | 31636000 | 63259
 | Singapore | 2012-03-01 00:00:00 | 31636000 | 63259
 | Pakistan | 2012-02-29 00:00:00 | 31524500 | 45249
 | London | 2012-03-01 00:00:00 | 31965200 | 84095
 | India | 2012-03-01 00:00:00 | 31965200 | 80132
 | China | 2012-03-01 00:00:00 | 31844200 | 74973
 | Singapore | 2012-03-01 00:00:00 | 31244200 | 6733
 | Pakistan | 2012-03-01 00:00:00 | 31244200 | 6067
 | India | 2012-03-01 00:00:00 | 30739200 | 7642
 | China | 2012-03-02 00:00:00 | 31903300 | 78430
 | Singapore | 2012-03-02 00:00:00 | 31800500 | 73175
 | Pakistan | 2012-03-01 00:00:00 | 31302700 | 6745
 | London | 2012-03-13 00:00:00 | 31302700 | 6745
 | India | 2012-03-01 00:00:00 | 31311700 | 6879
 | China | 2012-03-01 00:00:00 | 30731600 | 1118
 | Singapore | 2012-03-01 00:00:00 | 31133400 | 9380
 | Pakistan | 2012-03-01 00:00:00 | 31263800 | 6272
 | London | 2012-03-03 00:00:00 | 31507700 | 44713
 | India | 2012-03-03 00:00:00 | 31891900 | 76517
 | China | 2012-03-13 00:00:00 | 31891900 | 76517
 | Singapore | 2012-03-02 00:00:00 | 31514400 | 6381
 | Pakistan | 2012-03-03 00:00:00 | 31514400 | 44922
 | London | 2012-03-05 00:00:00 | 31342300 | 7370
 | India | 2012-03-03 00:00:00 | 31675000 | 60274
 | China | 2012-03-03 00:00:00 | 31563300 | 47012
 | Singapore | 2012-03-02 00:00:00 | 31097500 | 4489
 | Pakistan | 2012-03-05 00:00:00 | 31231100 | 62302
 | India | 2012-03-05 00:00:00 | 31231100 | 61505
 | China | 2012-03-03 00:00:00 | 31898800 | 77573
 | Singapore | 2012-03-02 00:00:00 | 31547600 | 46215
 | Pakistan | 2012-03-03 00:00:00 | 31239800 | 62019
 | London | 2012-03-02 00:00:00 | 31119900 | 4629
 | India | 2012-03-05 00:00:00 | 31623500 | 55382
 | China | 2012-03-05 00:00:00 | 31741200 | 73782
 | Singapore | 2012-03-05 00:00:00 | 31822300 | 76216
 | Pakistan | 2012-03-05 00:00:00 | 31822300 | 68363
 | London | 2012-03-05 00:00:00 | 31433900 | 8738
 | India | 2012-03-05 00:00:00 | 31824900 | 68391
 | China | 2012-03-05 00:00:00 | 31673700 | 78527
 | Singapore | 2012-03-05 00:00:00 | 31673700 | 62832
 | Pakistan | 2012-03-05 00:00:00 | 31800100 | 68001
 | London | 2012-03-05 00:00:00 | 31430300 | 8636
 | India | 2012-03-05 00:00:00 | 31316700 | 83351
 | China | 2012-03-06 00:00:00 | 31301200 | 6722
 | Singapore | 2012-03-05 00:00:00 | 30950300 | 8287
 | Pakistan | 2012-03-05 00:00:00 | 31705600 | 63220
 | India | 2012-03-05 00:00:00 | 31839900 | 79008
 | China | 2012-03-05 00:00:00 | 31449700 | 80940
 | Singapore | 2012-03-05 00:00:00 | 31469800 | 9501
 | Pakistan | 2012-03-06 00:00:00 | 32007600 | 83366
 | London | 2012-03-06 00:00:00 | 31852400 | 78746
 | India | 2012-03-06 00:00:00 | 31623100 | 55380
 | China | 2012-03-06 00:00:00 | 31929200 | 78690
 | Singapore | 2012-03-06 00:00:00 | 31584400 | 47874
 | Pakistan | 2012-03-06 00:00:00 | 31491000 | 75619
 | London | 2012-03-06 00:00:00 | 31523300 | 78298
 | India | 2012-03-07 00:00:00 | 31756200 | 68673
 | China | 2012-03-06 00:00:00 | 31428300 | 78314
 | Singapore | 2012-03-06 00:00:00 | 31422600 | 78316
 | Pakistan | 2012-03-06 00:00:00 | 32016300 | 83754
 | London | 2012-03-06 00:00:00 | 32053500 | 85143
 | India | 2012-03-06 00:00:00 | 31423300 | 74871
 | China | 2012-03-09 00:00:00 | 31531100 | 45544
 | Singapore | 2012-03-06 00:00:00 | 31649000 | 75984
 | Pakistan | 2012-03-06 00:00:00 | 31948800 | 80258
 | India | 2012-03-07 00:00:00 | 31900800 | 83155
 | China | 2012-03-06 00:00:00 | 31924000 | 78540
 | Singapore | 2012-03-06 00:00:00 | 31762800 | 83222
 | Pakistan | 2012-03-07 00:00:00 | 32017800 | 83939
 | London | 2012-03-06 00:00:00 | 31422200 | 76077
 | India | 2012-03-07 00:00:00 | 31863600 | 82293
 | China | 2012-03-07 00:00:00 | 31478300 | 76059
 | Singapore | 2012-03-12 00:00:00 | 31604600 | 76008
 | Pakistan | 2012-03-13 00:00:00 | 31604600 | 76008
 | London | 2012-03-07 00:00:00 | 31504100 | 76090
 | India | 2012-03-07 00:00:00 | 31540600 | 76050
 | China | 2012-03-07 00:00:00 | 31538900 | 75916
 | Singapore | 2012-03-07 00:00:00 | 31477100 | 76079
 | Pakistan | 2012-03-07 00:00:00 | 31253300 | 6694
 | London | 2012-03-09 00:00:00 | 31933000 | 78655
 | India | 2012-03-07 00:00:00 | 32007100 | 84542
 | China | 2012-03-09 00:00:00 | 31697900 | 75858
 | Singapore | 2012-03-09 00:00:00 | 31449700 | 76095
 | Pakistan | 2012-03-09 00:00:00 | 31549800 | 78585
 | India | 2012-03-07 00:00:00 | 31424800 | 79604
 | China | 2012-03-07 00:00:00 | 31883300 | 75955
 | Singapore | 2012-03-09 00:00:00 | 31432800 | 8818
 | Pakistan | 2012-03-12 00:00:00 | 31757300 | 63132
 | London | 2012-03-09 00:00:00 | 31747900 | 81051
 | India | 2012-03-09 00:00:00 | 31480600 | 76312
 | China | 2012-03-09 00:00:00 | 31798400 | 80126
 | Singapore | 2012-03-09 00:00:00 | 31807800 | 77647
 | Pakistan | 2012-03-09 00:00:00 | 31900700 | 80969
 | London | 2012-03-09 00:00:00 | 32007000 | 83535
 | India | 2012-03-09 00:00:00 | 31700800 | 80973
 | China | 2012-03-09 00:00:00 | 31904500 | 76991
 | Singapore | 2012-03-14 00:00:00 | 31732900 | 62512
 | Pakistan | 2012-03-14 00:00:00 | 31709000 | 61799
 | London | 2012-03-14 00:00:00 | 31594400 | 54283
 | India | 2012-03-15 00:00:00 | 31594400 | 54283
 | China | 2012-03-14 00:00:00 | 31808600 | 73085
 | Singapore | 2012-03-14 00:00:00 | 31509100 | 78766
 | Pakistan | 2012-03-14 00:00:00 | 31732200 | 62442
 | India | 2012-03-14 00:00:00 | 31920100 | 78192
 | China | 2012-03-14 00:00:00 | 31732300 | 80262
 | Singapore | 2012-03-13 00:00:00 | 31674000 | 74421
 | Pakistan | 2012-03-14 00:00:00 | 30484400 | 52976
 | London | 2012-03-13 00:00:00 | 31344900 | 84119
 | India | 2012-03-13 00:00:00 | 30273500 | 2071
 | China | 2012-03-13 00:00:00 | 31205100 | 79602
 | Singapore | 2012-03-15 00:00:00 | 31416800 | 60391
 | Pakistan | 2012-03-15 00:00:00 | 31933600 | 78883
 | London | 2012-03-15 00:00:00 | 31991800 | 82549
 | India | 2012-03-19 00:00:00 | 31445100 | 8994
 | China | 2012-03-20 00:00:00 | 31445100 | 8994
 | Singapore | 2012-03-14 00:00:00 | 31579600 | 52984
 | Pakistan | 2012-03-15 00:00:00 | 31708900 | 62667
 | London | 2012-03-15 00:00:00 | 31708100 | 61723
 | India | 2012-03-15 00:00:00 | 31609400 | 76767
 | China | 2012-03-16 00:00:00 | 31806400 | 83220
 | Singapore | 2012-03-16 00:00:00 | 31491000 | 84593
 | Pakistan | 2012-03-16 00:00:00 | 32014600 | 84690
 | India | 2012-03-15 00:00:00 | 31314900 | 6926
 | China | 2012-03-16 00:00:00 | 31247800 | 6095
 | Singapore | 2012-03-15 00:00:00 | 31595900 | 55062
 | Pakistan | 2012-03-16 00:00:00 | 31992100 | 82870
 | London | 2012-03-20 00:00:00 | 31992100 | 82870
 | India | 2012-03-16 00:00:00 | 31598200 | 57131
 | China | 2012-03-16 00:00:00 | 31997000 | 82176
 | Singapore | 2012-03-15 00:00:00 | 31900900 | 76773
 | Pakistan | 2012-03-16 00:00:00 | 31128900 | 57270
 | London | 2012-03-16 00:00:00 | 32021200 | 84822
 | India | 2012-03-16 00:00:00 | 31965700 | 80146
 | China | 2012-03-16 00:00:00 | 31954200 | 79834
 | Singapore | 2012-03-16 00:00:00 | 31953100 | 79856
 | Pakistan | 2012-03-16 00:00:00 | 31957100 | 83524
 | London | 2012-03-16 00:00:00 | 31765300 | 63475
 | India | 2012-03-19 00:00:00 | 31862100 | 80358
 | China | 2012-03-16 00:00:00 | 31475000 | 79592
 | Singapore | 2012-03-19 00:00:00 | 31962600 | 85056
 | Pakistan | 2012-03-19 00:00:00 | 31610400 | 54714
 | India | 2012-03-19 00:00:00 | 31611400 | 57114
 | China | 2012-03-19 00:00:00 | 31644500 | 57108
 | Singapore | 2012-03-19 00:00:00 | 31697100 | 63715
 | Pakistan | 2012-03-19 00:00:00 | 31922900 | 78261
 | London | 2012-03-20 00:00:00 | 31868000 | 75868
 | India | 2012-03-19 00:00:00 | 31456500 | 81161
 | China | 2012-03-19 00:00:00 | 32006900 | 83864
 | Singapore | 2012-03-20 00:00:00 | 31974700 | 83073
 | Pakistan | 2012-03-27 00:00:00 | 31974700 | 83073
 | India | 2012-03-20 00:00:00 | 32013500 | 84552
 | China | 2012-03-21 00:00:00 | 30960300 | 7457
 | Singapore | 2012-03-21 00:00:00 | 31741500 | 81820
 | Pakistan | 2012-03-21 00:00:00 | 31758400 | 63843
 | London | 2012-03-21 00:00:00 | 31938100 | 79221
 | India | 2012-03-21 00:00:00 | 31738500 | 63466
 | China | 2012-03-28 00:00:00 | 31738500 | 63466
 | Singapore | 2012-03-21 00:00:00 | 31416400 | 8756
 | Pakistan | 2012-03-21 00:00:00 | 31740500 | 69174
 | India | 2012-03-22 00:00:00 | 31740500 | 69174
 | China | 2012-03-22 00:00:00 | 30480100 | 5994
 | Singapore | 2012-03-22 00:00:00 | 31312800 | 6895
 | Pakistan | 2012-03-26 00:00:00 | 31930800 | 79993
 | London | 2012-03-22 00:00:00 | 31624500 | 57174
 | India | 2012-03-23 00:00:00 | 31508400 | 73766
 | China | 2012-03-27 00:00:00 | 31508400 | 73766
 | Singapore | 2012-03-23 00:00:00 | 31845300 | 69180
 | Pakistan | 2012-03-23 00:00:00 | 31820700 | 76586
 | London | 2012-03-23 00:00:00 | 31595200 | 54322
 | India | 2012-03-23 00:00:00 | 31481700 | 9707
 | China | 2012-03-23 00:00:00 | 31931800 | 78596
 | Singapore | 2012-03-27 00:00:00 | 31931800 | 78596
 | Pakistan | 2012-03-23 00:00:00 | 31343200 | 7403
 | London | 2012-03-26 00:00:00 | 31846100 | 76629
 | India | 2012-03-27 00:00:00 | 31846100 | 76629
 | China | 2012-03-26 00:00:00 | 31683300 | 63687
 | Singapore | 2012-03-27 00:00:00 | 31683300 | 63687
 | Pakistan | 2012-03-26 00:00:00 | 31472900 | 9549
 | India | 2012-03-27 00:00:00 | 31880400 | 76682
 | China | 2012-03-27 00:00:00 | 31234100 | 7310
 | Singapore | 2012-03-27 00:00:00 | 31765500 | 67396
 | Pakistan | 2012-03-27 00:00:00 | 31506000 | 44941
 | London | 2012-03-27 00:00:00 | 31450300 | 9092
 | India | 2012-03-28 00:00:00 | 31911600 | 80456
 | China | 2012-03-28 00:00:00 | 31833700 | 79075
 | Singapore | 2012-03-29 00:00:00 | 31650500 | 59113
 | Pakistan | 2012-03-29 00:00:00 | 31834800 | 72793
 | London | 2012-03-29 00:00:00 | 31866400 | 76701
 | India | 2012-03-29 00:00:00 | 31791800 | 68877