_id	case_number	Unique identifier for a 311 case
1	status	Useful for case aggregation. Can be New, Open, Closed, In Progress and may have (Duplicate) flag.
2	case_owner	Department or organization assigned to the case
3	subject	Category of request
4	subject_code	Internal code for subject/category of request
5	legacy_subject	Category of request from previous 311 system, if applicable (primarily for tickets created before February 2025)
6	created_date_et	Date of case creation (Eastern Time)
7	created_date_utc	Date of case creation (UTC)
8	last_modified_date_et	Date of last update (Eastern Time)
9	last_modified_date_utc	Date of last update (UTC)
10	closed_date_et	Date of case closure (Eastern Time)
11	closed_date_utc	Date of case closure (UTC)
12	origin	Method used to submit the 311 request (Phone, Email, Web, etc.)
13	street	Street name
14	street_id	Streets 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.
15	city	Mailing city
16	neighborhood	Neighborhood name
17	council_district	Council district
18	ward	Ward
19	police_zone	Police zone
20	census_tract	Census tract
21	lat	Latitude
22	lon	Longitude
23	geo_accuracy	Defines coordinate rounding for privacy. EXCAT = 5 decimals/within 1m, APPROXIMATE = 2 decimals/within 1km