{"rows":[{"cartodb_id":277,"the_geom":"0101000020E61000004E7D3B66D5CE52C0607387EBAEF04340","the_geom_webmercator":"0101000020110F0000A039A0B77AF25FC10B9F2F23EE7E5241","addressobjectid":"139483","address":"8500 ESSINGTON AVE","unit_type":null,"unit_num":null,"zip":"19153-3701","opa_account_num":"773300001","parcel_id_num":"485758","censustract":"9804","opa_owner":"CITY OF PHILA            DEPT OF PUBLIC PROP","primaryappellant":"JAGWINDER SIKKA","appellanttype":"APPL","internaljobid":1032030,"appealnumber":"10311","acceleratedappeal":null,"createddate":"2010-01-21T21:07:00Z","completeddate":null,"relatedpermit":"Description of Project:  R2770507\n  APPEAL TYPES==> \nAPPEAL TYPE: HD-FOOD  \n\n  BOARD DECISIONS==> \nDECISION: LATE-APPRVD  DECDATE: 21-JAN-10  PROVISO: AP STAGE ROLLBACK WOULDN'T WORK. DECISION ENTERED TO ADVANCE STATUS.  \nDECISION: CONTINUED  DECDATE: 10-MAR-10  PROVISO:   \nDECISION: AFFIRMED  DECDATE: 24-MAR-10  PROVISO:   \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"WE HAVE A PRETZEL STAND AT THE AIRPORT.  THE INSPECTOR INSPECTED OUR PREMISES AND FOUND EVERYTHING SATISFACTORY.  IN AN INTERVIEW WITH THE PRESENT EMPLOYEE, SHE ASKED WHAT IS OUR POLICY IF AN EMPLOYEE IS SICK WITH HEPATITIS A .  HE SAID THE EMPLOYEE IS NOT ALLOWED TO COME TO WORK AND THE OWNER IS INFORMED TO TAKE FURTHER ACTION. THE INSPECTOR FELT WE DID NOT HAVE ANY POLICY ON ILLNESS AND ISSUED A VIOLATION NOTICE. OUR COMPANY DOES HAVE AN ILLNESS POLICY.","scheduleddate":"2010-03-23T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":null,"decisiondate":"2010-03-24T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2675153.8842405896,"geocode_y":209342.74303218,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":275,"coordinatingrco":null}],"time":0.67,"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}