{"rows":[{"cartodb_id":30469,"the_geom":"0101000020E610000090F7FC07E6CA52C084245B14D5034440","the_geom_webmercator":"0101000020110F00008CABE399CBEB5FC1D411B48325945241","addressobjectid":"15662457","address":"100-08 W QUEEN LN","unit_type":null,"unit_num":null,"zip":"19144-6224","opa_account_num":"882681100","parcel_id_num":"466925","censustract":"024200","opa_owner":"SUNOCO LLC","primaryappellant":"MUHAMMAD USMAN DBA: SUNOCO A PLUS MINI MARKET","appellanttype":"Other","internaljobid":null,"appealnumber":"HA-2021-002409","acceleratedappeal":"Standard Appeal","createddate":"2021-06-10T15:39:13Z","completeddate":"2022-03-05T14:48:27Z","relatedpermit":null,"relatedcasefile":null,"appealstatus":"Closed","appealtype":"LIRB-H Tobacco","agendadescription":null,"applicationtype":"L&I Review Board Codes","meetingnumber":"MI-2021-002499","appealgrounds":"Hansen # 39763\n\nCorporation that holds the Tobacco License was sold and purchased by new owners on April 1, 2019. The previous tickets were forgiven and expunged during a court appeal. Current owners were only held responsible for any future violations during the court appeal. After complete transfer of ownership, under new management, there have been no violations and ID rule is enforced for every purchase.","scheduleddate":"2021-07-20T17:15:00Z","decision":"City Affirmed","meetingresult":"Complete","proviso":null,"decisiondate":"2022-03-05T14:47:05Z","systemofrecord":"ECLIPSE","geocode_x":2690810.93896192,"geocode_y":264314.846028537,"council_district":"8","posse_jobid":"358673418","gdb_geomattr_data":null,"objectid":30312,"coordinatingrco":null}],"time":0.003,"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}