Case Harvester
Data codebook

complaints

API table: complaints

Individual complaints filed within a case, including their filing dates, amounts, and status.

Historical records: this table holds records migrated from Case Harvester's pre-2026 schema. It no longer receives new records.

Definitions have been recorded for some columns and not others. A column with no definition below has not been documented yet.

A field with a fixed, closed set of values lists that set below. A field with documented codes lists its known values, and shows a meaning for the ones that have been described. Other value lists are not published here. Licensed clients can read them through GET /metadata.

Case Number

API field: case_number

Maryland Judiciary case number that links this complaint to case_info.

Served type
String
Nullability
Always present on a served row
Query capabilities
  • selectable
  • filter: equals
  • filter: set

Populated on 100% of served rows (2,087,688 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Complaint Number

API field: complaint_number

Legacy complaint number within the District Court civil case.

Served type
Integer
Nullability
May be null
Query capabilities
  • selectable

Populated on <100% of served rows (2,087,598 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Plaintiff

API field: plaintiff

Plaintiff recorded for the complaint; policy-protected rows may return null.

Served type
String
Nullability
May be null
Redaction
Returned as null when the row belongs to a protected person.
Query capabilities
  • selectable

Populated on <100% of served rows (2,087,598 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Defendant

API field: defendant

Defendant recorded for the complaint; policy-protected rows may return null.

Served type
String
Nullability
May be null
Redaction
Returned as null when the row belongs to a protected person.
Query capabilities
  • selectable

Populated on <100% of served rows (2,087,598 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Complaint Type

API field: complaint_type

Type of District Court civil complaint.

Served type
String
Nullability
May be null
Query capabilities
  • selectable
  • filter: equals
  • filter: set
  • aggregate group

Populated on <100% of served rows (2,087,297 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Complaint Status

API field: complaint_status

Current or reported status of the complaint.

Served type
String
Nullability
May be null
Query capabilities
  • selectable
  • filter: equals
  • filter: set
  • aggregate group

Populated on 96.4% of served rows (2,012,570 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Complaint Amount

API field: amount

Monetary amount sought or recorded for the complaint.

Served type
Numeric
Nullability
May be null
Query capabilities
  • selectable
  • sortable
  • filter: equals
  • filter: set
  • filter: greaterThan
  • filter: greaterThanOrEqual
  • filter: lessThan
  • filter: lessThanOrEqual
  • filter: inRange
  • aggregate sum

Populated on <100% of served rows (2,087,598 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Filing Date

API field: filing_date

Parsed date the complaint was filed.

Served type
Date
Nullability
May be null
Query capabilities
  • selectable
  • sortable
  • default sort: desc
  • filter: equals
  • filter: set
  • filter: greaterThan
  • filter: greaterThanOrEqual
  • filter: lessThan
  • filter: lessThanOrEqual
  • filter: inRange
  • date bucket

Populated on <100% of served rows (2,087,598 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Status Date

API field: status_date

Parsed date the complaint status took effect or was recorded.

Served type
Date
Nullability
May be null
Query capabilities
  • selectable
  • sortable
  • filter: equals
  • filter: set
  • filter: greaterThan
  • filter: greaterThanOrEqual
  • filter: lessThan
  • filter: lessThanOrEqual
  • filter: inRange
  • date bucket

Populated on <100% of served rows (2,087,598 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Last Activity Date

API field: last_activity_date

Parsed date the complaint's latest reported activity occurred.

Served type
Date
Nullability
May be null
Query capabilities
  • selectable
  • sortable
  • filter: equals
  • filter: set
  • filter: greaterThan
  • filter: greaterThanOrEqual
  • filter: lessThan
  • filter: lessThanOrEqual
  • filter: inRange
  • date bucket

Populated on <100% of served rows (2,087,598 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Complaint Row ID

API field: id

CaseHarvester's own identifier for this complaint row.

Served type
Integer
Nullability
Always present on a served row
Query capabilities
  • selectable
  • filter: equals
  • filter: set
  • filter: greaterThan
  • filter: greaterThanOrEqual
  • filter: lessThan
  • filter: lessThanOrEqual
  • filter: inRange

Populated on 100% of served rows (2,087,688 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Legacy Complaint Row ID

API field: legacy_id

Row identifier this record carried in the legacy table it was migrated from.

Served type
Integer
Nullability
May be null
Query capabilities
  • selectable

Populated on 100% of served rows (2,087,688 of 2,087,688), measured October 15, 2026 at 02:47 UTC

Generated from the current served catalog.