{
  "fields": [{"id":"_id","type":"int"},{"id":"case_number","type":"text","info":{"label":"case_number"}},{"id":"Unique identifier for a 311 case","type":"text","info":{"label":"Unique identifier for a 311 case"}}],
  "records": [
    [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"]
]}