lauraallen
Premium Member
- Joined
- August 4, 2026
- Messages
- 128
- Reaction score
- 30
- Points
- 28
- Thread Author
- #1
USA City of Houston Municipal Government Data 6 Million
┏• Date: 2026
┣• Lines: 6M
┗• Size: 72 Gb
For Order DM on Telegram: @dataseller247
┏• Date: 2026
┣• Lines: 6M
┗• Size: 72 Gb
For Order DM on Telegram: @dataseller247
urrencyid_value": null, "coh_swdrecyclequad": "NE", "coh_streetname": null, "_owningteam_value@Microsoft.Dynamics.CRM.lookuplogicalname": "team", "_owningteam_value": "879f3c80-5f2b-eb11-a813-001dd830487f", "_msa_partnerid_value": null, "exchangerate": null, "coh_isreclassified@OData.Community.Display.V1.FormattedValue": "No", "coh_isreclassified": false, "coh_previoussla": null, "coh_quadrantum": "NE", "coh_swdgarbageroute": "NETH111", "coh_parkname": null, "coh_fieldarrayresolutionmulti": null, "entityimage_timestamp": null, "_coh_closedby_value": null, "_createdby_value@OData.Community.Display.V1.FormattedValue": "D365ProdDM311", "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_createdby_value": "74b59988-8dba-eb11-8236-001dd80210b8", "adx_modifiedbyusername": null, "_modifiedonbehalfby_value@OData.Community.Display.V1.FormattedValue": "D365ProdDM311", "_modifiedonbehalfby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_modifiedonbehalfby_value": "74b59988-8dba-eb11-8236-001dd80210b8", "title": "Investigate leaking meter", "numberofchildincidents": null, "coh_ylocation@OData.Community.Display.V1.FormattedValue": "13,862,358.8591134700", "coh_ylocation": 13862358.85911347, "coh_superneighborhood": "TRINITY / HOUSTON GARDENS", "entityimageid": null, "productserialnumber": null, "ava_objecttypecodeid": null, "coh_modifiedon": null, "caseage": "Resolved", "followuptaskcreated@OData.Community.Display.V1.FormattedValue": "No", "followuptaskcreated": false, "adx_resolutiondate": null, "coh_userlocalslastarttime@OData.Community.Display.V1.FormattedValue": "10/16/2012 2:20 PM", "coh_userlocalslastarttime": "2012-10-16T14:20:21Z", "coh_language@OData.Community.Display.V1.FormattedValue": "English", "coh_language": 181440000, "coh_taxid": "0670760140393", "_createdbyexternalparty_value": null, "ava_addressline2": null, "_contactid_value": null, "coh_userdeviceinfo": null, "lastinteraction": null, "coh_autoresolvecase@OData.Community.Display.V1.FormattedValue": "No", "coh_autoresolvecase": false, "ava_email": null, "statecode@OData.Community.Display.V1.FormattedValue": "Resolved", "statecode": 1, "coh_overrideagentscripting@OData.Community.Display.V1.FormattedValue": "No", "coh_overrideagentscripting": false, "nextsla": null, "_ownerid_value@OData.Community.Display.V1.FormattedValue": "COH 311 Read Only", "_ownerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ownerid", "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "team", "_ownerid_value": "879f3c80-5f2b-eb11-a813-001dd830487f", "adx_createdbyusername": null, "traversedpath": null, "processid": null, "ava_longitude@OData.Community.Display.V1.FormattedValue": "-95.36984", "ava_longitude": -95.36984, "merged@OData.Community.Display.V1.FormattedValue": "No", "merged": false, "coh_fivestarsurveysnippet": "<a href=\"Sad Rating"><img alt=\"Boo!\" src=\"http://houstontx.gov/311/survey/GoldStar1.jpg\" class=\"\"></a>", "versionnumber@OData.Community.Display.V1.FormattedValue": "1,333,527,360", "versionnumber": 1333527360, "entityimage_url": null, "customercontacted@OData.Community.Display.V1.FormattedValue": "No", "customercontacted": false, "coh_documentlistpcf": null, "ava_stateorprovince": "Texas", "coh_buildingname": null, "coh_customeremailaddress": null, "coh_isdataentrycompleted@OData.Community.Display.V1.FormattedValue": "No", "coh_isdataentrycompleted": false, "_primarycontactid_value": null, "coh_county": "HARRIS", "_existingcase_value": null, "coh_managementdistrict": null, "ava_latitude@OData.Community.Display.V1.FormattedValue": "29.75837", "ava_latitude": 29.75837, "coh_xlocation@OData.Community.Display.V1.FormattedValue": "3,130,733.8335289800", "coh_xlocation": 3130733.83352898, "emailaddress": null, "coh_slastarttime": null, "stageid": null, "coh_swmquadrant": "NW", "_contractdetailid_value": null, "coh_gimstilegrid": "5460d", "ticketnumber": "CAS-3280610-H0T5F0", "_coh_concern_value": null, "coh_streetprefix": null, "coh_councildistrict": "B", "createdon@OData.Community.Display.V1.FormattedValue": "10/16/2012 2:20 PM", "createdon": "2012-10-16T14:20:21Z", "_coh_previousconcern_value": null, "deactivatedon": null, "coh_swdrecyclingroute": "NWTH-A-06", "_owninguser_value": null, "isdecrementing@OData.Community.Display.V1.FormattedValue": "No", "isdecrementing": false, "_createdonbehalfby_value": null, "coh_parkinginyardprohibited": null, "ava_addressline3": null, "coh_addressvalidated@OData.Community.Display.V1.FormattedValue": "No", "coh_addressvalidated": false, "entityimage": null, "followupby": null, "statuscode@OData.Community.Display.V1.FormattedValue": "Service Completed", "statuscode": 5, "_accountid_value": null, "coh_streetsuffix": null, "actualserviceunits": null, "escalatedon": null, "checkemail@OData.Community.Display.V1.FormattedValue": "No", "checkemail": false, "resolveby": null, "coh_streetnumber": null, "importsequencenumber": null, "adx_resolution": null, "messagetypecode": null, "coh_reactivationreason": null, "adx_publishtoweb@OData.Community.Display.V1.FormattedValue": "No", "adx_publishtoweb": false, "incidentid": "418b9ead-a01c-48d4-8703-00000482879e", "adx_createdbyipaddress": null, "coh_resolutionpcf": null, "_entitlementid_value": null, "servicestage@OData.Community.Display.V1.FormattedValue": "Identify", "servicestage": 0, "coh_swmrecycleday": "THURSDAY-A", "_subjectid_value": null, "coh_swmrecycleareas": "S", "coh_reclassificationreason": null, "decremententitlementterm@OData.Community.Display.V1.FormattedValue": "Yes", "decremententitlementterm": true, "routecase@OData.Community.Display.V1.FormattedValue": "Yes", "routecase": true, "coh_fieldarraymulti": null, "timezoneruleversionnumber@OData.Community.Display.V1.FormattedValue": "4", "timezoneruleversionnumber": 4, "influencescore": null, "coh_addressid": "189555.0", "coh_swmgarbagepickupday": "THURSDAY", "_ava_servicerequesttypeid_value@OData.Community.Display.V1.FormattedValue": "Meter Leak", "_ava_servicerequesttypeid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ava_ServiceRequestTypeID", "_ava_servicerequesttypeid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "ava_servicerequesttype", "_ava_servicerequesttypeid_value": "3bf4825a-e255-eb11-a811-001dd83098a1", "coh_previousobjecttypecodeid": null, "_kbarticleid_value": null, "msdyn_casesurveyinviteurl": null, "adx_stepstoreproduce": null, "caseorigincode@OData.Community.Display.V1.FormattedValue": "Internal", "caseorigincode": 3, "_contractid_value": null, "_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue": "COH 311", "_owningbusinessunit_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "owningbusinessunit", "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit", "_owningbusinessunit_value": "3e9e53b9-c228-eb11-a813-001dd8309076", "coh_censustract": "230100", "msdyn_precreatenotesid": null, "_msa_partnercontactid_value": null, "coh_previouspcffield": null, "blockedprofile@OData.Community.Display.V1.FormattedValue": "No", "blockedprofile": false, "coh_311casehistorylinksnippet": "<a href=\"Service Request Details · Customer Self-Service">COH Case11561473-101000808693</a>", "coh_pcfagentscript": null, "coh_keymap": "454P", "_msdyn_aiagentstatus_value": null, "coh_commonplacenames2": null, "severitycode@OData.Community.Display.V1.FormattedValue": "Default Value", "severitycode": 1, "coh_addressline1entered": null, "incidentstagecode@OData.Community.Display.V1.FormattedValue": "Default Value", "incidentstagecode": 1, "coh_channel@OData.Community.Display.V1.FormattedValue": "Phone", "coh_channel": 181440000, "_modifiedby_value@OData.Community.Display.V1.FormattedValue": "D365ProdDM311", "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_modifiedby_value": "74b59988-8dba-eb11-8236-001dd80210b8", "coh_newpcffield": null, "coh_casemaplinksnippet": "<a href=\"Home · Customer Self-Service">Houston 311 Case Map</a>", "coh_hcadstatecategorycode": null, "ava_location": null, "ava_isanon@OData.Community.Display.V1.FormattedValue": "No", "ava_isanon": false, "_msdyn_iotalert_value": null, "ava_district@OData.Community.Display.V1.FormattedValue": "I", "ava_district": 915240008, "coh_isinternal@OData.Community.Display.V1.FormattedValue": "No", "coh_isinternal": false, "ava_countryorregion": "United States", "_coh_phonecall_value": null, "firstresponseslastatus@OData.Community.Display.V1.FormattedValue": "In Progress", "firstresponseslastatus": 1, "coh_casenumbersearch": "101000808693", "contractservicelevelcode": null, "ava_city": "HOUSTON", "_msdyn_incidenttype_value": null, "isescalated@OData.Community.Display.V1.FormattedValue": "No", "isescalated": false, "msdyn_copilotengaged": null, "_coh_previoussr_value": null, "coh_commonplacenames1": null, "coh_reclassifycase@OData.Community.Display.V1.FormattedValue": "No", "coh_reclassifycase": false, "lastonholdtime": null, "ava_lockaddress@OData.Community.Display.V1.FormattedValue": "No", "ava_lockaddress": false, "coh_longitude@OData.Community.Display.V1.FormattedValue": "-95.3698400000", "coh_longitude": -95.36984, "_coh_division_value": null, "coh_houstonetj": "FULL", "coh_casenumber": "11561473-101000808693", "coh_scriptagent": null, "utcconversiontimezonecode": null, "coh_heavytrashday": "2nd Friday", "_modifiedbyexternalparty_value": null, "customersatisfactioncode": null, "_parentcaseid_value": null, "billedserviceunits": null, "_slaid_value": null, "_socialprofileid_value": null, "_resolvebykpiid_value": null, "coh_isreactivated@OData.Community.Display.V1.FormattedValue": "No", "coh_isreactivated": false, "ava_objecttypecode": null, "overriddencreatedon@OData.Community.Display.V1.FormattedValue": "6/19/2021", "overriddencreatedon": "2021-06-19T17:08:56Z", "ava_pcffield": null, "description": "3806 CAPLIN, HOUSTON TX 77026", "ava_addressline": "3806 CAPLIN ST", "coh_elapsedtime": null, "activitiescomplete@OData.Community.Display.V1.FormattedValue": "No", "activitiescomplete": false, "_masterid_value": null, "resolvebyslastatus@OData.Community.Display.V1.FormattedValue": "In Progress", "resolvebyslastatus": 1, "msdyn_casesentiment": null, "firstresponsesent@OData.Community.Display.V1.FormattedValue": "No", "firstresponsesent": false, "modifiedon@OData.Community.Display.V1.FormattedValue": "7/22/2023 2:11 AM", "modifiedon": "2023-07-22T02:11:19Z", "casetypecode": null, "ava_postalcode": "77026", "coh_closedate@OData.Community.Display.V1.FormattedValue": "10/17/2012 10:25 AM", "coh_closedate": "2012-10-17T10:25:08Z", "coh_createdon": null, "adx_modifiedbyipaddress": null, "_customerid_value@OData.Community.Display.V1.FormattedValue": "JOSE BRADLEY", "_customerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "customerid_contact", "_customerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "contact", "_customerid_value": "d4ee93aa-ccce-45c7-a709-819d2fbae04e", "msdyn_precreateattachmentsid": null, "prioritycode@OData.Community.Display.V1.FormattedValue": "20-Normal", "prioritycode": 2, "responseby": null, "ava_fieldarray": null, "coh_latitude@OData.Community.Display.V1.FormattedValue": "29.7583700000", "coh_latitude": 29.75837, "_slainvokedid_value": null, "_productid_value": null} "W/\"1642187844\"", "_firstresponsebykpiid_value": null, "sentimentvalue": null, "onholdtime": null, "coh_previousobjecttypecode": null, "coh_harriscountyflooddistrict": null, "coh_swdheavytrashquad": "SW", "coh_alternatecasenumber": null, "_transactioncurrencyid_value": null, "coh_swdrecyclequad": "SW", "coh_streetname": null, "_owningteam_value": null, "_msa_partnerid_value": null, "exchangerate": null, "coh_isreclassified@OData.Community.Display.V1.FormattedValue": "No", "coh_isreclassified": false, "coh_previoussla": null, "coh_quadrantum": "SW", "coh_swdgarbageroute": "SWMO118", "coh_parkname": null, "coh_fieldarrayresolutionmulti": null, "entityimage_timestamp": null, "_coh_closedby_value": null, "_createdby_value@OData.Community.Display.V1.FormattedValue": "D365ProdDM311", "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_createdby_value": "74b59988-8dba-eb11-8236-001dd80210b8", "adx_modifiedbyusername": null, "_modifiedonbehalfby_value": null, "title": "Skipped Collection Reason", "numberofchildincidents": null, "coh_ylocation@OData.Community.Display.V1.FormattedValue": "13,815,273.3289408100", "coh_ylocation": 13815273.32894081, "coh_superneighborhood": "ALIEF", "entityimageid": null, "productserialnumber": null, "ava_objecttypecodeid": "AB4DFA52-1807-4609-B900-6D4846957F41", "coh_modifiedon": null, "caseage": "Resolved", "followuptaskcreated@OData.Community.Display.V1.FormattedValue": "No", "followuptaskcreated": false, "adx_resolutiondate": null, "coh_userlocalslastarttime@OData.Community.Display.V1.FormattedValue": "9/16/2019 11:43 AM", "coh_userlocalslastarttime": "2019-09-16T11:43:46Z", "coh_language@OData.Community.Display.V1.FormattedValue": "English", "coh_language": 181440000, "coh_taxid": "1098520000022", "_createdbyexternalparty_value": null, "ava_addressline2": null, "_contactid_value": null, "coh_userdeviceinfo": null, "lastinteraction": null, "coh_autoresolvecase@OData.Community.Display.V1.FormattedValue": "No", "coh_autoresolvecase": false, "ava_email": null, "statecode@OData.Community.Display.V1.FormattedValue": "Resolved", "statecode": 1, "coh_overrideagentscripting@OData.Community.Display.V1.FormattedValue": "No", "coh_overrideagentscripting": false, "nextsla": null, "_ownerid_value@OData.Community.Display.V1.FormattedValue": "Racheal Manning", "_ownerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ownerid", "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_ownerid_value": "94993835-4266-eb11-bb23-001dd8018a6d", "adx_createdbyusername": null, "traversedpath": null, "processid": null, "ava_longitude@OData.Community.Display.V1.FormattedValue": "-95.60927", "ava_longitude": -95.60927, "merged@OData.Community.Display.V1.FormattedValue": "No", "merged": false, "coh_fivestarsurveysnippet": "<a href=\"Sad Rating"><img alt=\"Boo!\" src=\"http://houstontx.gov/311/survey/GoldStar1.jpg\" class=\"\"></a>", "versionnumber@OData.Community.Display.V1.FormattedValue": "1,642,187,844", "versionnumber": 1642187844, "entityimage_url": null, "customercontacted@OData.Community.Display.V1.FormattedValue": "No", "customercontacted": false, "coh_documentlistpcf": null, "ava_stateorprovince": "Texas", "coh_buildingname": "International MD", "coh_customeremailaddress": null, "coh_isdataentrycompleted@OData.Community.Display.V1.FormattedValue": "No", "coh_isdataentrycompleted": false, "_primarycontactid_value": null, "coh_county": "HARRIS", "_existingcase_value": null, "coh_managementdistrict": "International MD", "ava_latitude@OData.Community.Display.V1.FormattedValue": "29.69342", "ava_latitude": 29.69342, "coh_xlocation@OData.Community.Display.V1.FormattedValue": "3,044,861.8704306300", "coh_xlocation": 3044861.87043063, "emailaddress": null, "coh_slastarttime": null, "stageid": null, "coh_swmquadrant": "SW", "_contractdetailid_value": null, "coh_gimstilegrid": "4854a", "ticketnumber": "CAS-1414796-F5N9L4", "_coh_concern_value": null, "coh_streetprefix": null, "coh_councildistrict": "F", "createdon@OData.Community.Display.V1.FormattedValue": "9/16/2019 11:43 AM", "createdon": "2019-09-16T11:43:46Z", "_coh_previousconcern_value": null, "deactivatedon": null, "coh_swdrecyclingroute": "SWMO-B-01", "_owninguser_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_owninguser_value": "94993835-4266-eb11-bb23-001dd8018a6d", "isdecrementing@OData.Community.Display.V1.FormattedValue": "No", "isdecrementing": false, "_createdonbehalfby_value": null, "coh_parkinginyardprohibited": null, "ava_addressline3": null, "coh_addressvalidated@OData.Community.Display.V1.FormattedValue": "No", "coh_addressvalidated": false, "entityimage": null, "followupby": null, "statuscode@OData.Community.Display.V1.FormattedValue": "Service Completed", "statuscode": 5, "_accountid_value": null, "coh_streetsuffix": null, "actualserviceunits": null, "escalatedon": null, "checkemail@OData.Community.Display.V1.FormattedValue": "No", "checkemail": false, "resolveby": null, "coh_streetnumber": null, "importsequencenumber": null, "adx_resolution": null, "messagetypecode": null, "coh_reactivationreason": null, "adx_publishtoweb@OData.Community.Display.V1.FormattedValue": "No", "adx_publishtoweb": false, "incidentid": "5faf7148-57ae-48a6-a62a-000006369e95", "adx_createdbyipaddress": null, "coh_resolutionpcf": null, "_entitlementid_value": null, "servicestage@OData.Community.Display.V1.FormattedValue": "Identify", "servicestage": 0, "coh_swmrecycleday": "MONDAY-B", "_subjectid_value": null, "coh_swmrecycleareas": "S", "coh_reclassificationreason": null, "decremententitlementterm@OData.Community.Display.V1.FormattedValue": "Yes", "decremententitlementterm": true, "routecase@OData.Community.Display.V1.FormattedValue": "Yes", "routecase": true, "coh_fieldarraymulti": null, "timezoneruleversionnumber@OData.Community.Display.V1.FormattedValue": "4", "timezoneruleversionnumber": 4, "influencescore": null, "coh_addressid": "448760.0", "coh_swmgarbagepickupday": "MONDAY", "_ava_servicerequesttypeid_value@OData.Community.Display.V1.FormattedValue": "Uncollected Service Units", "_ava_servicerequesttypeid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ava_ServiceRequestTypeID", "_ava_servicerequesttypeid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "ava_servicerequesttype", "_ava_servicerequesttypeid_value": "f01c4424-f935-eb11-a813-001dd8309076", "coh_previousobjecttypecodeid": null, "_kbarticleid_value": null, "msdyn_casesurveyinviteurl": null, "adx_stepstoreproduce": null, "caseorigincode@OData.Community.Display.V1.FormattedValue": "Internal", "caseorigincode": 3, "_contractid_value": null, "_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue": "COH 311", "_owningbusinessunit_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "owningbusinessunit", "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit", "_owningbusinessunit_value": "3e9e53b9-c228-eb11-a813-001dd8309076", "coh_censustract": "452801", "msdyn_precreatenotesid": null, "_msa_partnercontactid_value": null, "coh_previouspcffield": null, "blockedprofile@OData.Community.Display.V1.FormattedValue": "No", "blockedprofile": false, "coh_311casehistorylinksnippet": "<a href=\"Service Request Details · Customer Self-Service">COH Case101003645284</a>", "coh_pcfagentscript": null, "coh_keymap": "528L", "_msdyn_aiagentstatus_value": null, "coh_commonplacenames2": null, "severitycode@OData.Community.Display.V1.FormattedValue": "Default Value", "severitycode": 1, "coh_addressline1entered": null, "incidentstagecode@OData.Community.Display.V1.FormattedValue": "Default Value", "incidentstagecode": 1, "coh_channel@OData.Community.Display.V1.FormattedValue": "Not Applicable", "coh_channel": 585600006, "_modifiedby_value@OData.Community.Display.V1.FormattedValue": "D365Prod311", "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_modifiedby_value": "043e1f8b-aaa6-eb11-b1ac-001dd802ea1e", "coh_newpcffield": null, "coh_casemaplinksnippet": "<a href=\"Home · Customer Self-Service">Houston 311 Case Map</a>", "coh_hcadstatecategorycode": null, "ava_location": null, "ava_isanon@OData.Community.Display.V1.FormattedValue": "Yes", "ava_isanon": true, "_msdyn_iotalert_value": null, "ava_district@OData.Community.Display.V1.FormattedValue": "I", "ava_district": 915240008, "coh_isinternal@OData.Community.Display.V1.FormattedValue": "No", "coh_isinternal": false, "ava_countryorregion": "United States", "_coh_phonecall_value": null, "firstresponseslastatus@OData.Community.Display.V1.FormattedValue": "In Progress", "firstresponseslastatus": 1, "coh_casenumbersearch": "101003645284", "contractservicelevelcode": null, "ava_city": "HOUSTON", "_msdyn_incidenttype_value": null, "isescalated@OData.Community.Display.V1.FormattedValue": "No", "isescalated": false, "msdyn_copilotengaged": null, "_coh_previoussr_value": null, "coh_commonplacenames1": null, "coh_reclassifycase@OData.Community.Display.V1.FormattedValue": "No", "coh_reclassifycase": false, "lastonholdtime": null, "ava_lockaddress@OData.Community.Display.V1.FormattedValue": "No", "ava_lockaddress": false, "coh_longitude@OData.Community.Display.V1.FormattedValue": "-95.6092665000", "coh_longitude": -95.6092665, "_coh_division_value": null, "coh_houstonetj": "FULL", "coh_casenumber": "101003645284", "coh_scriptagent": null, "utcconversiontimezonecode": null, "coh_heavytrashday": "1st Tuesday", "_modifiedbyexternalparty_value": null, "customersatisfactioncode": null, "_parentcaseid_value": null, "billedserviceunits": null, "_slaid_value": null, "_socialprofileid_value": null, "_resolvebykpiid_value": null, "coh_isreactivated@OData.Community.Display.V1.FormattedValue": "No", "coh_isreactivated": false, "ava_objecttypecode": "ava_uncollectedserviceunits", "overriddencreatedon@OData.Community.Display.V1.FormattedValue": "6/19/2021", "overriddencreatedon": "2021-06-19T00:38:12Z", "ava_pcffield": null, "description": "9/16/19 at 11:24a yard waste inside green cart - Jennifer", "ava_addressline": "7710 HOLLOW GLEN LN", "coh_elapsedtime": null, "activitiescomplete@OData.Community.Display.V1.FormattedValue": "No", "activitiescomplete": false, "_masterid_value": null, "resolvebyslastatus@OData.Community.Display.V1.FormattedValue": "In Progress", "resolvebyslastatus": 1, "msdyn_casesentiment": null, "firstresponsesent@OData.Community.Display.V1.FormattedValue": "No", "firstresponsesent": false, "modifiedon@OData.Community.Display.V1.FormattedValue": "2/6/2022 3:43 AM", "modifiedon": "2022-02-06T03:43:29Z", "casetypecode": null, "ava_postalcode": "77072", "coh_closedate@OData.Community.Display.V1.FormattedValue": "3/5/2021 10:55 AM", "coh_closedate": "2021-03-05T10:55:15Z", "coh_createdon": null, "adx_modifiedbyipaddress": null, "_customerid_value@OData.Community.Display.V1.FormattedValue": "Anonymous Contact", "_customerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "customerid_contact", "_customerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "contact", "_customerid_value": "9bdf763f-a113-eb11-a813-000d3a5699dc", "msdyn_precreateattachmentsid": null, "prioritycode@OData.Community.Display.V1.FormattedValue": "20-Normal", "prioritycode": 2, "responseby": null, "ava_fieldarray": null, "coh_latitude@OData.Community.Display.V1.FormattedValue": "29.6934160200", "coh_latitude": 29.69341602, "_slainvokedid_value": null, "_productid_value": null} "W/\"1362262031\"", "_firstresponsebykpiid_value": null, "sentimentvalue": null, "onholdtime": null, "coh_previousobjecttypecode": null, "coh_harriscountyflooddistrict": null, "coh_swdheavytrashquad": "SE", "coh_alternatecasenumber": null, "_transactioncurrencyid_value": null, "coh_swdrecyclequad": "SE", "coh_streetname": null, "_owningteam_value@Microsoft.Dynamics.CRM.lookuplogicalname": "team", "_owningteam_value": "879f3c80-5f2b-eb11-a813-001dd830487f", "_msa_partnerid_value": null, "exchangerate": null, "coh_isreclassified@OData.Community.Display.V1.FormattedValue": "No", "coh_isreclassified": false, "coh_previoussla": null, "coh_quadrantum": "SE", "coh_swdgarbageroute": "SETH101A", "coh_parkname": null, "coh_fieldarrayresolutionmulti": null, "entityimage_timestamp": null, "_coh_closedby_value": null, "_createdby_value@OData.Community.Display.V1.FormattedValue": "D365ProdDM311", "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_createdby_value": "74b59988-8dba-eb11-8236-001dd80210b8", "adx_modifiedbyusername": null, "_modifiedonbehalfby_value@OData.Community.Display.V1.FormattedValue": "D365ProdDM311", "_modifiedonbehalfby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_modifiedonbehalfby_value": "74b59988-8dba-eb11-8236-001dd80210b8", "title": "Repair or Replace a Recycling Cart/Bin", "numberofchildincidents": null, "coh_ylocation@OData.Community.Display.V1.FormattedValue": "13,785,933.3790906500", "coh_ylocation": 13785933.37909065, "coh_superneighborhood": "SOUTH BELT / ELLINGTON", "entityimageid": null, "productserialnumber": null, "ava_objecttypecodeid": "C819EE4F-EC4D-43D2-BEF9-9F7F7B51644C", "coh_modifiedon": null, "caseage": "Resolved", "followuptaskcreated@OData.Community.Display.V1.FormattedValue": "No", "followuptaskcreated": false, "adx_resolutiondate": null, "coh_userlocalslastarttime@OData.Community.Display.V1.FormattedValue": "11/17/2017 10:04 AM", "coh_userlocalslastarttime": "2017-11-17T10:04:05Z", "coh_language@OData.Community.Display.V1.FormattedValue": "English", "coh_language": 181440000, "coh_taxid": "1150740030009", "_createdbyexternalparty_value": null, "ava_addressline2": null, "_contactid_value": null, "coh_userdeviceinfo": null, "lastinteraction": null, "coh_autoresolvecase@OData.Community.Display.V1.FormattedValue": "No", "coh_autoresolvecase": false, "ava_email": null, "statecode@OData.Community.Display.V1.FormattedValue": "Resolved", "statecode": 1, "coh_overrideagentscripting@OData.Community.Display.V1.FormattedValue": "No", "coh_overrideagentscripting": false, "nextsla": null, "_ownerid_value@OData.Community.Display.V1.FormattedValue": "COH 311 Read Only", "_ownerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ownerid", "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "team", "_ownerid_value": "879f3c80-5f2b-eb11-a813-001dd830487f", "adx_createdbyusername": null, "traversedpath": null, "processid": null, "ava_longitude@OData.Community.Display.V1.FormattedValue": "-95.36984", "ava_longitude": -95.36984, "merged@OData.Community.Display.V1.FormattedValue": "No", "merged": false, "coh_fivestarsurveysnippet": "<a href=\"Sad Rating"><img alt=\"Boo!\" src=\"http://houstontx.gov/311/survey/GoldStar1.jpg\" class=\"\"></a>", "versionnumber@OData.Community.Display.V1.FormattedValue": "1,362,262,031", "versionnumber": 1362262031, "entityimage_url": null, "customercontacted@OData.Community.Display.V1.FormattedValue": "No", "customercontacted": false, "coh_documentlistpcf": null, "ava_stateorprovince": "Texas", "coh_buildingname": null, "coh_customeremailaddress": null, "coh_isdataentrycompleted@OData.Community.Display.V1.FormattedValue": "No", "coh_isdataentrycompleted": false, "_primarycontactid_value": null, "coh_county": "Harris", "_existingcase_value": null, "coh_managementdistrict": null, "ava_latitude@OData.Community.Display.V1.FormattedValue": "29.75837", "ava_latitude": 29.75837, "coh_xlocation@OData.Community.Display.V1.FormattedValue": "3,161,343.5236217200", "coh_xlocation": 3161343.52362172, "emailaddress": null, "coh_slastarttime": null, "stageid": null, "coh_swmquadrant": "SW", "_contractdetailid_value": null, "coh_gimstilegrid": "5751c", "ticketnumber": "CAS-2020615-X2C2P7", "_coh_concern_value": null, "coh_streetprefix": null, "coh_councildistrict": "D", "createdon@OData.Community.Display.V1.FormattedValue": "11/17/2017 10:04 AM", "createdon": "2017-11-17T10:04:05Z", "_coh_previousconcern_value": null, "deactivatedon": null, "coh_swdrecyclingroute": "SWTH-B-02", "_owninguser_value": null, "isdecrementing@OData.Community.Display.V1.FormattedValue": "No", "isdecrementing": false, "_createdonbehalfby_value": null, "coh_parkinginyardprohibited": null, "ava_addressline3": null, "coh_addressvalidated@OData.Community.Display.V1.FormattedValue": "No", "coh_addressvalidated": false, "entityimage": null, "followupby": null, "statuscode@OData.Community.Display.V1.FormattedValue": "Service Completed", "statuscode": 5, "_accountid_value": null, "coh_streetsuffix": null, "actualserviceunits": null, "escalatedon": null, "checkemail@OData.Community.Display.V1.FormattedValue": "No", "checkemail": false, "resolveby": null, "coh_streetnumber": null, "importsequencenumber": null, "adx_resolution": null, "messagetypecode": null, "coh_reactivationreason": null, "adx_publishtoweb@OData.Community.Display.V1.FormattedValue": "No", "adx_publishtoweb": false, "incidentid": "954d537a-5e2e-4dc4-82c7-000006a06fda", "adx_createdbyipaddress": null, "coh_resolutionpcf": null, "_entitlementid_value": null, "servicestage@OData.Community.Display.V1.FormattedValue": "Identify", "servicestage": 0, "coh_swmrecycleday": "THURSDAY-B", "_subjectid_value": null, "coh_swmrecycleareas": "S", "coh_reclassificationreason": null, "decremententitlementterm@OData.Community.Display.V1.FormattedValue": "Yes", "decremententitlementterm": true, "routecase@OData.Community.Display.V1.FormattedValue": "Yes", "routecase": true, "coh_fieldarraymulti": null, "timezoneruleversionnumber@OData.Community.Display.V1.FormattedValue": "4", "timezoneruleversionnumber": 4, "influencescore": null, "coh_addressid": "567179.0", "coh_swmgarbagepickupday": "THURSDAY", "_ava_servicerequesttypeid_value@OData.Community.Display.V1.FormattedValue": "Recycling Cart Repair", "_ava_servicerequesttypeid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "ava_ServiceRequestTypeID", "_ava_servicerequesttypeid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "ava_servicerequesttype", "_ava_servicerequesttypeid_value": "1beaff6a-e93f-eb11-a813-001dd830487f", "coh_previousobjecttypecodeid": null, "_kbarticleid_value": null, "msdyn_casesurveyinviteurl": null, "adx_stepstoreproduce": null, "caseorigincode@OData.Community.Display.V1.FormattedValue": "Internal", "caseorigincode": 3, "_contractid_value": null, "_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue": "COH 311", "_owningbusinessunit_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "owningbusinessunit", "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit", "_owningbusinessunit_value": "3e9e53b9-c228-eb11-a813-001dd8309076", "coh_censustract": "333902", "msdyn_precreatenotesid": null, "_msa_partnercontactid_value": null, "coh_previouspcffield": null, "blockedprofile@OData.Community.Display.V1.FormattedValue": "No", "blockedprofile": false, "coh_311casehistorylinksnippet": "<a href=\"Service Request Details · Customer Self-Service">COH Case101002825745</a>", "coh_pcfagentscript": null, "coh_keymap": "576W", "_msdyn_aiagentstatus_value": null, "coh_commonplacenames2": null, "severitycode@OData.Community.Display.V1.FormattedValue": "Default Value", "severitycode": 1, "coh_addressline1entered": null, "incidentstagecode@OData.Community.Display.V1.FormattedValue": "Default Value", "incidentstagecode": 1, "coh_channel@OData.Community.Display.V1.FormattedValue": "Phone", "coh_channel": 181440000, "_modifiedby_value@OData.Community.Display.V1.FormattedValue": "D365ProdDM311", "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_modifiedby_value": "74b59988-8dba-eb11-8236-001dd80210b8", "coh_newpcffield": null, "coh_casemaplinksnippet": "<a href=\"Home · Customer Self-Service">Houston 311 Case Map</a>", "coh_hcadstatecategorycode": null, "ava_location": null, "ava_isanon@OData.Community.Display.V1.FormattedValue": "No", "ava_isanon": false, "_msdyn_iotalert_value": null, "ava_district@OData.Community.Display.V1.FormattedValue": "I", "ava_district": 915240008, "coh_isinternal@OData.Community.Display.V1.FormattedValue": "No", "coh_isinternal": false, "ava_countryorregion": "United States", "_coh_phonecall_value": null, "firstresponseslastatus@OData.Community.Display.V1.FormattedValue": "In Progress", "firstresponseslastatus": 1, "coh_casenumbersearch": "101002825745", "contractservicelevelcode": null, "ava_city": "HOUSTON", "_msdyn_incidenttype_value": null, "isescalated@OData.Community.Display.V1.FormattedValue": "No", "isescalated": false, "msdyn_copilotengaged": null, "_coh_previoussr_value": null, "coh_commonplacenames1": null, "coh_reclassifycase@OData.Community.Display.V1.FormattedValue": "No", "coh_reclassifycase": false, "lastonholdtime": null, "ava_lockaddress@OData.Community.Display.V1.FormattedValue": "No", "ava_lockaddress": false, "coh_longitude@OData.Community.Display.V1.FormattedValue": "-95.3698400000", "coh_longitude": -95.36984, "_coh_division_value": null, "coh_houstonetj": "FULL", "coh_casenumber": "101002825745", "coh_scriptagent": null, "utcconversiontimezonecode": null, "coh_heavytrashday": "2nd Friday", "_modifiedbyexternalparty_value": null, "customersatisfactioncode": null, "_parentcaseid_value": null, "billedserviceunits": null, "_slaid_value": null, "_socialprofileid_value": null, "_resolvebykpiid_value": null, "coh_isreactivated@OData.Community.Display.V1.FormattedValue": "No", "coh_isreactivated": false, "ava_objecttypecode": "ava_recyclingcartrepair", "overriddencreatedon@OData.Community.Display.V1.FormattedValue": "6/19/2021", "overriddencreatedon": "2021-06-19T04:20:11Z", "ava_pcffield": null, "description": null, "ava_addressline": "9234 KINGSROSE LN", "coh_elapsedtime": null, "activitiescomplete@OData.Community.Display.V1.FormattedValue": "No", "activitiescomplete": false, "_masterid_value": null, "resolvebyslastatus@OData.Community.Display.V1.FormattedValue": "In Progress", "resolvebyslastatus": 1, "msdyn_casesentiment": null, "firstresponsesent@OData.Community.Display.V1.FormattedValue": "No", "firstresponsesent": false, "modifiedon@OData.Community.Display.V1.FormattedValue": "7/23/2023 5:14 AM", "modifiedon": "2023-07-23T05:14:16Z", "casetypecode": null, "ava_postalcode": "77075", "coh_closedate@OData.Community.Display.V1.FormattedValue": "12/1/2017 1:20 PM", "coh_closedate": "2017-12-01T13:20:04Z", "coh_createdon": null, "adx_modifiedbyipaddress": null, "_customerid_value@OData.Community.Display.V1.FormattedValue": "MARTHA NAVARRETE", "_customerid_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "customerid_contact", "_customerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "contact", "_customerid_value": "8f006fbf-bed4-4831-a9f0-75f2965aa9ae", "msdyn_precreateattachmentsid": null, "prioritycode@OData.Community.Display.V1.FormattedValue": "20-Normal", "prioritycode": 2, "responseby": null, "ava_fieldarray": null, "coh_latitude@OData.Community.Display.V1.FormattedValue": "29.7583700000", "coh_latitude": 29.75837, "_slainvokedid_value": null, "_productid_value": null}