{"rows":[{"cartodb_id":10151,"the_geom":"0101000020E6100000000000000000F87F000000000000F87F","the_geom_webmercator":null,"addressobjectid":null,"address":null,"unit_type":null,"unit_num":null,"zip":null,"opa_account_num":null,"parcel_id_num":null,"censustract":null,"opa_owner":null,"primaryappellant":"DANIEL RICKARDS","appellanttype":"APPL","internaljobid":1635305,"appealnumber":"21816","acceleratedappeal":null,"createddate":"2013-11-29T20:32:00Z","completeddate":null,"relatedpermit":"Description of Project:  JOURNEYMAN PLUMBERS LICENSE\n  APPEAL TYPES==> \nAPPEAL TYPE: AGAINSTL&I  \n\n  BOARD DECISIONS==> \nDECISION: SUSTAINED  DECDATE: 10-JAN-14  PROVISO:   \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"THE APPLICANT HAS HAD AN ACTIVE APPRENTICE AND JOURNEYMAN PLUMBER'S LICENSE IN (AN)OTHER JURISDICTION(S) AND BELIEVES THAT HIS LICENSE(S) AND WORK EXPERIENCE IN OTHER JURISDICTION(S) WOULD SATISFY THE PHILADELPHIA CODE REQUIREMENTS FOR LICENSING AND EXPERIENCE.","scheduleddate":"2014-01-07T18:15:00Z","decision":null,"meetingresult":null,"proviso":null,"decisiondate":"2014-01-10T05:00:00Z","systemofrecord":"HANSEN","geocode_x":null,"geocode_y":null,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":10045,"coordinatingrco":null}],"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},"addressobjectid":{"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"},"opa_account_num":{"type":"string","pgtype":"varchar"},"parcel_id_num":{"type":"string","pgtype":"varchar"},"censustract":{"type":"string","pgtype":"varchar"},"opa_owner":{"type":"string","pgtype":"varchar"},"primaryappellant":{"type":"string","pgtype":"varchar"},"appellanttype":{"type":"string","pgtype":"varchar"},"internaljobid":{"type":"number","pgtype":"numeric"},"appealnumber":{"type":"string","pgtype":"varchar"},"acceleratedappeal":{"type":"string","pgtype":"varchar"},"createddate":{"type":"date","pgtype":"timestamptz"},"completeddate":{"type":"date","pgtype":"timestamptz"},"relatedpermit":{"type":"string","pgtype":"varchar"},"relatedcasefile":{"type":"string","pgtype":"varchar"},"appealstatus":{"type":"string","pgtype":"varchar"},"appealtype":{"type":"string","pgtype":"varchar"},"agendadescription":{"type":"string","pgtype":"varchar"},"applicationtype":{"type":"string","pgtype":"varchar"},"meetingnumber":{"type":"string","pgtype":"varchar"},"appealgrounds":{"type":"string","pgtype":"varchar"},"scheduleddate":{"type":"date","pgtype":"timestamptz"},"decision":{"type":"string","pgtype":"varchar"},"meetingresult":{"type":"string","pgtype":"varchar"},"proviso":{"type":"string","pgtype":"varchar"},"decisiondate":{"type":"date","pgtype":"timestamptz"},"systemofrecord":{"type":"string","pgtype":"varchar"},"geocode_x":{"type":"number","pgtype":"numeric"},"geocode_y":{"type":"number","pgtype":"numeric"},"council_district":{"type":"string","pgtype":"varchar"},"posse_jobid":{"type":"string","pgtype":"varchar"},"gdb_geomattr_data":{"type":"bytea","pgtype":"bytea"},"objectid":{"type":"number","pgtype":"int4"},"coordinatingrco":{"type":"string","pgtype":"varchar"}},"total_rows":1}