{"rows":[{"cartodb_id":147833,"the_geom":"0101000020E6100000C282DFCD6AC852C0442F40624B044440","the_geom_webmercator":"0101000020110F0000E928A89A94E75FC1C10EC7BCA8945241","objectid":147760,"posse_jobid":"376141155","addressobjectid":132664829,"council_district":"9","address":"5400 N 5TH ST","unit_type":null,"unit_num":null,"zip":"19120-2802","censustract":"027500","parcel_id_num":"419163","opa_account_num":"871582800","opa_owner":"TANWAR SUSHANT SINGH","owneroccupied":null,"addressed_license":"Yes","licensenum":"874344","revenuecode":"3524","licensetype":"Precious Metal Dealer","rentalcategory":null,"initialissuedate":"2021-08-02T17:55:20Z","mostrecentissuedate":"2026-09-01T04:00:00Z","expirationdate":"2027-08-01T17:55:20Z","inactivedate":null,"licensestatus":"Active","numberofunits":null,"legalfirstname":null,"legallastname":null,"legalname":"H&S GOLD AND DIAMOND LLC ","legalentitytype":"Company","business_name":"H&S GOLD AND DIAMOND LLC","business_mailing_address":"5400 N 5TH ST PHILADELPHIA, PA  19120 USA","ownercontact1name":"hemant tanwar","ownercontact1mailingaddress":"5400 n. 5th st","ownercontact1city":"philadelphia","ownercontact1state":"Pe","ownercontact1zippostalcode":"19120","ownercontact2name":"sushant tanwar","ownercontact2mailingaddress":"5400 n. 5th st","ownercontact2city":"philadelphia","ownercontact2state":"Pe","ownercontact2zippostalcode":"19120","geocode_x":2701624.60272156,"geocode_y":265948.9582501539,"gdb_geomattr_data":null,"ownerismanagingagentinphilly":null,"cal_number":"837303","effectivedate":"2026-08-02T17:55:20Z"}],"time":1.883,"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":1}