statusUseful for case aggregation. Can be New, Open, Closed, In Progress and may have (Duplicate) flag. case_ownerDepartment or organization assigned to the case subjectCategory of request subject_codeInternal code for subject/category of request legacy_subjectCategory of request from previous 311 system, if applicable (primarily for tickets created before February 2025) created_date_etDate of case creation (Eastern Time) created_date_utcDate of case creation (UTC) last_modified_date_etDate of last update (Eastern Time) last_modified_date_utcDate of last update (UTC) closed_date_etDate of case closure (Eastern Time) closed_date_utcDate of case closure (UTC) originMethod used to submit the 311 request (Phone, Email, Web, etc.) streetStreet name street_idStreets are assigned a string representation of a numeric code. Useful in certain contexts where street name may be unwieldy. May be 0 if a street is not entered. cityMailing city neighborhoodNeighborhood name council_districtCouncil district wardWard police_zonePolice zone census_tractCensus tract latLatitude lonLongitude geo_accuracyDefines coordinate rounding for privacy. EXCAT = 5 decimals/within 1m, APPROXIMATE = 2 decimals/within 1km