{"rows":[{"cartodb_id":1,"the_geom":"0101000020E6100000DC3C539FB9C552C02F2BBE5495094440","the_geom_webmercator":"0101000020110F0000AD039EF501E35FC1A82A6507879A5241","objectid":1,"posse_jobid":"9237159","addressobjectid":15325377,"council_district":"10","address":"7800 BURHOLME AVE","unit_type":null,"unit_num":null,"zip":"19111-2210","censustract":"034100","parcel_id_num":"208072","opa_account_num":"631012101","opa_owner":"MC HUGH CHARLES C, MC HUGH JOAN BRYSON","owneroccupied":"Yes","addressed_license":"Yes","licensenum":"246211","revenuecode":"3202","licensetype":"Rental","rentalcategory":"Residential Dwellings","initialissuedate":"2001-06-09T04:00:00Z","mostrecentissuedate":"2008-02-05T12:59:57Z","expirationdate":"2009-02-28T05:00:00Z","inactivedate":"2009-02-18T17:23:00Z","licensestatus":"Inactive","numberofunits":2,"legalfirstname":"CHARLES","legallastname":"MCHUGH","legalname":"CHARLES C MCHUGH","legalentitytype":"Individual","business_name":"CHARLES C MCHUGH","business_mailing_address":"7800 BURHOLME AVE PHILADELPHIA, PA  19111 USA","ownercontact1name":null,"ownercontact1mailingaddress":null,"ownercontact1city":null,"ownercontact1state":null,"ownercontact1zippostalcode":null,"ownercontact2name":null,"ownercontact2mailingaddress":null,"ownercontact2city":null,"ownercontact2state":null,"ownercontact2zippostalcode":null,"geocode_x":2712944.87356774,"geocode_y":281346.030609621,"gdb_geomattr_data":null,"ownerismanagingagentinphilly":null,"cal_number":null,"effectivedate":"2008-02-05T12:59:57Z"},{"cartodb_id":2,"the_geom":"0101000020E6100000000000000000F87F000000000000F87F","the_geom_webmercator":null,"objectid":2,"posse_jobid":"9301813","addressobjectid":15325382,"council_district":"7","address":"3601 A ST","unit_type":null,"unit_num":null,"zip":"19134-1009","censustract":"195","parcel_id_num":null,"opa_account_num":null,"opa_owner":null,"owneroccupied":null,"addressed_license":"Yes","licensenum":"311092","revenuecode":"3120","licensetype":"Food Preparing and Serving","rentalcategory":null,"initialissuedate":"2010-09-23T14:38:00Z","mostrecentissuedate":"2010-09-23T14:38:00Z","expirationdate":"2011-09-23T14:38:00Z","inactivedate":"2010-09-23T14:39:00Z","licensestatus":"Inactive","numberofunits":null,"legalfirstname":null,"legallastname":null,"legalname":"SODEXHO MARRIOTT MGMT INC","legalentitytype":"Company","business_name":"SODEXHO MARRIOTT MGMT INC","business_mailing_address":" GEN SULLIVAN RD RT 532 WASH CROSNG, PA  18977 USA","ownercontact1name":null,"ownercontact1mailingaddress":null,"ownercontact1city":null,"ownercontact1state":null,"ownercontact1zippostalcode":null,"ownercontact2name":null,"ownercontact2mailingaddress":null,"ownercontact2city":null,"ownercontact2state":null,"ownercontact2zippostalcode":null,"geocode_x":null,"geocode_y":null,"gdb_geomattr_data":null,"ownerismanagingagentinphilly":null,"cal_number":"112320","effectivedate":"2010-09-23T14:38:00Z"}],"time":0.002,"fields":{"cartodb_id":{"type":"number","pgtype":"int8"},"the_geom":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":4326},"the_geom_webmercator":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":3857},"objectid":{"type":"number","pgtype":"int4"},"posse_jobid":{"type":"string","pgtype":"varchar"},"addressobjectid":{"type":"number","pgtype":"numeric"},"council_district":{"type":"string","pgtype":"varchar"},"address":{"type":"string","pgtype":"varchar"},"unit_type":{"type":"string","pgtype":"varchar"},"unit_num":{"type":"string","pgtype":"varchar"},"zip":{"type":"string","pgtype":"varchar"},"censustract":{"type":"string","pgtype":"varchar"},"parcel_id_num":{"type":"string","pgtype":"varchar"},"opa_account_num":{"type":"string","pgtype":"varchar"},"opa_owner":{"type":"string","pgtype":"varchar"},"owneroccupied":{"type":"string","pgtype":"varchar"},"addressed_license":{"type":"string","pgtype":"varchar"},"licensenum":{"type":"string","pgtype":"varchar"},"revenuecode":{"type":"string","pgtype":"varchar"},"licensetype":{"type":"string","pgtype":"varchar"},"rentalcategory":{"type":"string","pgtype":"varchar"},"initialissuedate":{"type":"date","pgtype":"timestamptz"},"mostrecentissuedate":{"type":"date","pgtype":"timestamptz"},"expirationdate":{"type":"date","pgtype":"timestamptz"},"inactivedate":{"type":"date","pgtype":"timestamptz"},"licensestatus":{"type":"string","pgtype":"varchar"},"numberofunits":{"type":"number","pgtype":"numeric"},"legalfirstname":{"type":"string","pgtype":"varchar"},"legallastname":{"type":"string","pgtype":"varchar"},"legalname":{"type":"string","pgtype":"varchar"},"legalentitytype":{"type":"string","pgtype":"varchar"},"business_name":{"type":"string","pgtype":"varchar"},"business_mailing_address":{"type":"string","pgtype":"varchar"},"ownercontact1name":{"type":"string","pgtype":"varchar"},"ownercontact1mailingaddress":{"type":"string","pgtype":"varchar"},"ownercontact1city":{"type":"string","pgtype":"varchar"},"ownercontact1state":{"type":"string","pgtype":"varchar"},"ownercontact1zippostalcode":{"type":"string","pgtype":"varchar"},"ownercontact2name":{"type":"string","pgtype":"varchar"},"ownercontact2mailingaddress":{"type":"string","pgtype":"varchar"},"ownercontact2city":{"type":"string","pgtype":"varchar"},"ownercontact2state":{"type":"string","pgtype":"varchar"},"ownercontact2zippostalcode":{"type":"string","pgtype":"varchar"},"geocode_x":{"type":"number","pgtype":"numeric"},"geocode_y":{"type":"number","pgtype":"numeric"},"gdb_geomattr_data":{"type":"bytea","pgtype":"bytea"},"ownerismanagingagentinphilly":{"type":"string","pgtype":"varchar"},"cal_number":{"type":"string","pgtype":"varchar"},"effectivedate":{"type":"date","pgtype":"timestamptz"}},"total_rows":2}