{"rows":[{"cartodb_id":5872355,"the_geom":null,"the_geom_webmercator":null,"objectid":5872355,"service_request_id":19847484,"status":"Open","status_notes":null,"service_name":"Miscellaneous","service_code":"SR-MI01","agency_responsible":"Philly311 Contact Center","service_notice":null,"requested_datetime":"2026-07-27T08:43:33Z","updated_datetime":"2026-07-27T08:43:35Z","expected_datetime":null,"address":null,"zipcode":null,"media_url":null,"lat":null,"lon":null,"subject":null,"closed_datetime":null,"gdb_geomattr_data":null,"service_type":"Miscellaneous"},{"cartodb_id":5872354,"the_geom":null,"the_geom_webmercator":null,"objectid":5872354,"service_request_id":19847482,"status":"Open","status_notes":null,"service_name":"Miscellaneous","service_code":"SR-MI01","agency_responsible":"Philly311 Contact Center","service_notice":null,"requested_datetime":"2026-07-27T07:16:04Z","updated_datetime":"2026-07-27T07:16:06Z","expected_datetime":null,"address":null,"zipcode":null,"media_url":null,"lat":null,"lon":null,"subject":null,"closed_datetime":null,"gdb_geomattr_data":null,"service_type":"Miscellaneous"},{"cartodb_id":5872353,"the_geom":null,"the_geom_webmercator":null,"objectid":5872353,"service_request_id":19847481,"status":"Open","status_notes":null,"service_name":"Miscellaneous","service_code":"SR-MI01","agency_responsible":"Philly311 Contact Center","service_notice":null,"requested_datetime":"2026-07-27T06:59:22Z","updated_datetime":"2026-07-27T06:59:24Z","expected_datetime":null,"address":null,"zipcode":null,"media_url":null,"lat":null,"lon":null,"subject":null,"closed_datetime":null,"gdb_geomattr_data":null,"service_type":"Miscellaneous"},{"cartodb_id":5872352,"the_geom":"0101000020E6100000D991EEA24FCA52C0C350164F5DF94340","the_geom_webmercator":"0101000020110F0000F593F823CCEA5FC13E997CF98A885241","objectid":5872352,"service_request_id":19847479,"status":"Open","status_notes":null,"service_name":"Other (Streets)","service_code":"SR-ST16","agency_responsible":"Streets Department","service_notice":"5 Business Days","requested_datetime":"2026-07-27T06:18:06Z","updated_datetime":"2026-07-27T06:39:25Z","expected_datetime":"2026-08-03T00:00:00Z","address":"1200 SAINT JAMES ST","zipcode":"19107","media_url":null,"lat":39.94816006,"lon":-75.16111062,"subject":null,"closed_datetime":null,"gdb_geomattr_data":null,"service_type":"Other (Streets)"},{"cartodb_id":5872351,"the_geom":null,"the_geom_webmercator":null,"objectid":5872351,"service_request_id":19847477,"status":"Open","status_notes":null,"service_name":"Miscellaneous","service_code":"SR-MI01","agency_responsible":"Philly311 Contact Center","service_notice":null,"requested_datetime":"2026-07-27T05:10:52Z","updated_datetime":"2026-07-27T05:10:53Z","expected_datetime":null,"address":null,"zipcode":null,"media_url":null,"lat":null,"lon":null,"subject":null,"closed_datetime":null,"gdb_geomattr_data":null,"service_type":"Miscellaneous"},{"cartodb_id":5872350,"the_geom":null,"the_geom_webmercator":null,"objectid":5872350,"service_request_id":19847473,"status":"Open","status_notes":null,"service_name":"License Complaint","service_code":null,"agency_responsible":"License & Inspections","service_notice":"20 Business Days","requested_datetime":"2026-07-27T04:53:25Z","updated_datetime":"2026-07-27T04:58:38Z","expected_datetime":null,"address":"1217 Sansom Street","zipcode":"19107","media_url":null,"lat":null,"lon":null,"subject":null,"closed_datetime":null,"gdb_geomattr_data":null,"service_type":"Vendor Complaint"},{"cartodb_id":5872349,"the_geom":null,"the_geom_webmercator":null,"objectid":5872349,"service_request_id":19847469,"status":"Open","status_notes":null,"service_name":"Miscellaneous","service_code":"SR-MI01","agency_responsible":"Philly311 Contact Center","service_notice":null,"requested_datetime":"2026-07-27T04:26:55Z","updated_datetime":"2026-07-27T04:26:56Z","expected_datetime":null,"address":null,"zipcode":null,"media_url":null,"lat":null,"lon":null,"subject":null,"closed_datetime":null,"gdb_geomattr_data":null,"service_type":"Miscellaneous"},{"cartodb_id":5872348,"the_geom":"0101000020E61000004FCDC05682CE52C098BA0A4873F94340","the_geom_webmercator":"0101000020110F00003F7777A1EDF15FC14C5A1451A3885241","objectid":5872348,"service_request_id":19847467,"status":"Open","status_notes":null,"service_name":"Street Trees","service_code":"SR-PR08","agency_responsible":"Parks & Recreation","service_notice":"15 Business Days","requested_datetime":"2026-07-27T04:24:16Z","updated_datetime":"2026-07-27T04:29:19Z","expected_datetime":"2026-08-18T00:00:00Z","address":"5148 CATHARINE ST","zipcode":"19143","media_url":null,"lat":39.94883061,"lon":-75.22670525,"subject":null,"closed_datetime":null,"gdb_geomattr_data":null,"service_type":"Street Trees"},{"cartodb_id":5872347,"the_geom":"0101000020E61000004FCDC05682CE52C098BA0A4873F94340","the_geom_webmercator":"0101000020110F00003F7777A1EDF15FC14C5A1451A3885241","objectid":5872347,"service_request_id":19847462,"status":"Open","status_notes":null,"service_name":"Maintenance Complaint","service_code":null,"agency_responsible":"License & Inspections","service_notice":"20 Business Days","requested_datetime":"2026-07-27T04:10:22Z","updated_datetime":"2026-07-27T04:15:26Z","expected_datetime":"2026-08-26T00:00:00Z","address":"5148 CATHARINE ST","zipcode":"19143","media_url":null,"lat":39.94883061,"lon":-75.22670525,"subject":null,"closed_datetime":null,"gdb_geomattr_data":null,"service_type":"Property Maintenance Exterior"},{"cartodb_id":5872346,"the_geom":"0101000020E6100000B9E9A6EB06C952C02F0B247D1AFC4340","the_geom_webmercator":"0101000020110F0000DED68DC89DE85FC126E48CE4938B5241","objectid":5872346,"service_request_id":19847448,"status":"Closed","status_notes":"Service Not Needed","service_name":"Sanitation Violation","service_code":null,"agency_responsible":"Streets Department","service_notice":null,"requested_datetime":"2026-07-27T02:41:09Z","updated_datetime":"2026-07-27T02:46:12Z","expected_datetime":null,"address":"240 W GIRARD AVE","zipcode":"19123","media_url":null,"lat":39.96955837,"lon":-75.14104739,"subject":null,"closed_datetime":"2026-07-27T02:41:09Z","gdb_geomattr_data":null,"service_type":"Service Not Needed"}],"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},"objectid":{"type":"number","pgtype":"int4"},"service_request_id":{"type":"number","pgtype":"int4"},"status":{"type":"string","pgtype":"varchar"},"status_notes":{"type":"string","pgtype":"varchar"},"service_name":{"type":"string","pgtype":"varchar"},"service_code":{"type":"string","pgtype":"varchar"},"agency_responsible":{"type":"string","pgtype":"varchar"},"service_notice":{"type":"string","pgtype":"varchar"},"requested_datetime":{"type":"date","pgtype":"timestamptz"},"updated_datetime":{"type":"date","pgtype":"timestamptz"},"expected_datetime":{"type":"date","pgtype":"timestamptz"},"address":{"type":"string","pgtype":"varchar"},"zipcode":{"type":"string","pgtype":"varchar"},"media_url":{"type":"string","pgtype":"varchar"},"lat":{"type":"number","pgtype":"numeric"},"lon":{"type":"number","pgtype":"numeric"},"subject":{"type":"string","pgtype":"varchar"},"closed_datetime":{"type":"date","pgtype":"timestamptz"},"gdb_geomattr_data":{"type":"bytea","pgtype":"bytea"},"service_type":{"type":"string","pgtype":"varchar"}},"total_rows":10}