{"rows":[{"cartodb_id":10150,"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":"ROBERT MILLER, III","appellanttype":"APPL","internaljobid":1635304,"appealnumber":"21815","acceleratedappeal":null,"createddate":"2013-11-29T20:26:00Z","completeddate":null,"relatedpermit":"Description of Project:  MASTER PLUMBERS LICENSE\n  APPEAL TYPES==> \nAPPEAL TYPE: AGAINSTL&I  \n\n  BOARD DECISIONS==> \nDECISION: CONTINUED  DECDATE: 10-JAN-14  PROVISO:   \nDECISION: MOOT  DECDATE: 13-MAR-14  PROVISO: COMPLIED  \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 THE OTHER JURISDICTION(S) WOULD SATISFY THE PHILADELPHIA CODE REQUIREMENT(S) FOR LICENSING AND EXPERIENCE.","scheduleddate":"2014-03-04T18:15:00Z","decision":null,"meetingresult":null,"proviso":null,"decisiondate":"2014-03-13T04:00:00Z","systemofrecord":"HANSEN","geocode_x":null,"geocode_y":null,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":10044,"coordinatingrco":null}],"time":0.103,"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}