Case Harvester
Data codebook

Judicial officer case links

API table: judicial_officer_case_links

Links between judicial officers and case records, based on published officer IDs or possible name matches.

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 containing the matched officer value.

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

Populated on 100% of served rows (15,943,386 of 15,943,386) and on 100% of records collected since 2026 (12,065,220 of 12,065,220), measured October 15, 2026 at 02:57 UTC

Recorded Name or ID

API field: source_value

The judicial officer's name or ID as written on the case record. Open it to view the matching directory entry.

Served type
String
Nullability
Always present on a served row
Query capabilities
  • selectable

Populated on 100% of served rows (15,943,386 of 15,943,386) and on 100% of records collected since 2026 (12,065,220 of 12,065,220), measured October 15, 2026 at 02:57 UTC

Match Type

API field: match_confidence

Published ID match: the same officer ID appears on the case record and in the Judiciary directory. Possible match: the recorded name matches a directory name, but the records may refer to different people.

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

Populated on 100% of served rows (15,943,386 of 15,943,386) and on 100% of records collected since 2026 (12,065,220 of 12,065,220), measured October 15, 2026 at 02:57 UTC

Closed value set

  • exact_id (Published ID match)
  • possible_match (Possible match)

Officer ID

API field: officer_id

Directory officer ID selected by the match.

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

Populated on 100% of served rows (15,943,386 of 15,943,386) and on 100% of records collected since 2026 (12,065,220 of 12,065,220), measured October 15, 2026 at 02:57 UTC

Person Key

API field: person_key

Person key of the matched officer.

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

Populated on 100% of served rows (15,943,386 of 15,943,386) and on 100% of records collected since 2026 (12,065,220 of 12,065,220), measured October 15, 2026 at 02:57 UTC

Source Column

API field: source_column

Case column that supplied the matched value.

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

Populated on 100% of served rows (15,943,386 of 15,943,386) and on 100% of records collected since 2026 (12,065,220 of 12,065,220), measured October 15, 2026 at 02:57 UTC

Closed value set

  • case_info.judge_assigned
  • case_info.judicial_officer
  • case_info.authoring_judge
  • case_info.magistrate
  • case_events.ruling_judge
  • hearings.judge_id
  • hearings.judge_name
  • hearings.panel_judges
  • charges.disposition_judge
  • charges.plea_judge
  • charges.sentence_judge
  • bond_settings.judge
  • warrants.judges
  • judgments.judge_name
  • judgment_events.judge
  • landlord_tenant_judgments.judge_name
  • bond_settings.judge_id
  • appellate_opinions.authoring_judge

Match Signals

API field: match_signals

Structured evidence behind this match.

Served type
JSONB
Nullability
Always present on a served row
Query capabilities
  • selectable

Populated on 100% of served rows (15,943,386 of 15,943,386) and on 100% of records collected since 2026 (12,065,220 of 12,065,220), measured October 15, 2026 at 02:57 UTC

Judicial Officer Row ID

API field: judicial_officer_id

Foreign key to the matched judicial_officers 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 (15,943,386 of 15,943,386) and on 100% of records collected since 2026 (12,065,220 of 12,065,220), measured October 15, 2026 at 02:57 UTC

Case Link Row ID

API field: id

CaseHarvester's own identifier for this case-link row.

Served type
BigInteger
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 (15,943,386 of 15,943,386) and on 100% of records collected since 2026 (12,065,220 of 12,065,220), measured October 15, 2026 at 02:57 UTC

Generated from the current served catalog.