support_orders
API table: support_orders
Court orders for financial support, including payment amounts, schedules, and recipients.
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 support order to case_info.
- Served type
String- Nullability
- Always present on a served row
- Query capabilities
-
- selectable
- filter:
equals
Populated on 100% of served rows (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
Order ID
API field: order_id
Source-published identifier for the support order.
- Served type
Integer- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on 100% of served rows (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
Order Version
API field: version
Source version number for the support order.
- Served type
Integer- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on 100% of served rows (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
Order Status
API field: status
Current or reported status of the support order.
- Served type
String- Nullability
- May be null
- Query capabilities
-
- selectable
- filter:
equals - filter:
set - aggregate group
Populated on 100% of served rows (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
Status Date
API field: status_date
Parsed date the support-order 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 32.3% of served rows (27,431 of 84,933), measured October 15, 2026 at 03:09 UTC
Order Date
API field: order_date
Parsed date the support order was issued.
- 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 (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
Effective Date
API field: effective_date
Parsed date the support order takes effect.
- 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 59.2% of served rows (50,304 of 84,933), measured October 15, 2026 at 03:09 UTC
Effective Date Text
API field: effective_date_text
Verbatim legacy text describing when the support order becomes effective.
- Served type
String- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on 3.9% of served rows (3,340 of 84,933), measured October 15, 2026 at 03:09 UTC
Obligor
API field: obligor
Person recorded as owing support; 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 28.6% of served rows (24,297 of 84,933), measured October 15, 2026 at 03:09 UTC
Support Payee
API field: support_to
Person or entity designated to receive support; 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 94.2% of served rows (80,007 of 84,933), measured October 15, 2026 at 03:09 UTC
Support Amount
API field: support_amount
Periodic support amount ordered.
- 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 (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
Support Frequency
API field: support_frequency
Frequency at which the support amount is due.
- Served type
String- Nullability
- May be null
- Query capabilities
-
- selectable
- filter:
equals - filter:
set - aggregate group
Populated on 94.3% of served rows (80,075 of 84,933), measured October 15, 2026 at 03:09 UTC
Arrears Payee
API field: arrears_to
Person or entity designated to receive arrears payments; 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 34.3% of served rows (29,142 of 84,933), measured October 15, 2026 at 03:09 UTC
Arrears Amount
API field: arrears_amount
Support-arrears amount recorded by the source.
- 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 (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
Arrears Frequency
API field: arrears_frequency
Payment frequency specified for support arrears.
- Served type
String- Nullability
- May be null
- Query capabilities
-
- selectable
- filter:
equals - filter:
set - aggregate group
Populated on 34.4% of served rows (29,205 of 84,933), measured October 15, 2026 at 03:09 UTC
BTR Amount
API field: btr_amount
Amount carried in the legacy source's BTR field.
- Served type
Numeric- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on 100% of served rows (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
BTR Frequency
API field: btr_frequency
Payment frequency carried in the legacy source's BTR field.
- Served type
String- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on 5.2% of served rows (4,424 of 84,933), measured October 15, 2026 at 03:09 UTC
MAPR Amount
API field: mapr_amount
Amount carried in the legacy source's MAPR field.
- Served type
Numeric- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on 100% of served rows (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
MAPR Frequency
API field: mapr_frequency
Payment frequency carried in the legacy source's MAPR field.
- Served type
String- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on 1.2% of served rows (1,050 of 84,933), measured October 15, 2026 at 03:09 UTC
Medical Insurance Report Date
API field: medical_insurance_report_date
Parsed date medical-insurance information must be reported.
- Served type
Date- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on 30.2% of served rows (25,647 of 84,933), measured October 15, 2026 at 03:09 UTC
Lien
API field: lien
Verbatim lien indicator or description supplied with the support order.
- Served type
String- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on 100% of served rows (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
Order Provisions
API field: provisions
Additional provisions or narrative terms of the support order.
- Served type
String- Nullability
- May be null
- Query capabilities
-
- selectable
Populated on <1% of served rows (675 of 84,933), measured October 15, 2026 at 03:09 UTC
Support Order Row ID
API field: id
CaseHarvester's own identifier for this support order 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 (84,933 of 84,933), measured October 15, 2026 at 03:09 UTC
Generated from the current served catalog.