; and (xii) whether the tenant had appeared in landlord-tenant court for a court-ordered or administrative eviction matter involving the landlord in the 6-month, 1-year, or 2-year period preceding the court-ordered or administrative eviction case, and the number of such appearances involving the same landlord. (2) Aggregate data on court-ordered or administrative eviction cases Aggregate data on court-ordered or administrative eviction cases filed on or after the date on which the database is established, including— (A) the total number of cases filed, including a breakdown by— (i) the number of cases filed for nonpayment criminal activity, code violation, other breach of lease, both nonpayment and breach of lease, and any other reason; (ii) the number of cases filed because of the enforcement of a local ordinance impacting eviction; and (iii) the outcome of the dispositive hearing, including default judgment, dismissal, a consent agreement, a trial, and a settlement with or without mediation; (B) the number of tenants and landlords who showed up for the dispositive hearing of a court-ordered or an administrative eviction case, and how many tenants in each such type of case were represented by counsel described in paragraph (1)(E)(viii)(VI); (C) the average duration of a court-ordered or an administrative eviction case, including the average time from filing to first hearing; (D) the average amount allegedly owed by a tenant, per landlord; (E) the average months of rent allegedly owed by a tenant; (F) the average amount paid by a tenant to resolve the case and stay in the housing; (G) the number of court-ordered or administrative eviction cases resulting in a judgment in favor of the tenant due to code violations or warranty of habitability claims, including affirmative defenses; (H) the number and percentage of court-ordered or administrative eviction cases broken down by age bracket; (I) the number and percentage of court-ordered or administrative eviction cases broken down by race and ethnicity