OATH Hearings Division Case Status — NYC Open Data

NOTE: As of May 4, 2026, the Respondent First Name, Respondent Address (Street Name), Respondent Address (City), and Respondent Address (State Name) fields have been removed from this dataset. All other fields and records remain searchable, or as an alternative, use the OATH Summons Finder or a summons lookup tool from the issuing agency. This Actor returns it as one flat JSON row per record, with 74 declared fields — typed, named and documented in the dataset schema, so a spreadsheet or an agent can use it without guessing.

What you get

Field	Type	Meaning
charge_7_code_section	string	Charge #7: Code Section
charge_6_infraction_amount	string	Charge #6: Infraction Amount
charge_4_infraction_amount	number	Charge #4: Infraction Amount
violation_details	string	Violation Details
charge_4_code_section	string	Charge #4: Code Section
charge_4_code	string	Charge #4: Code
charge_4_code_description	string	Charge #4: Code Description
charge_6_code_section	string	Charge #6: Code Section
charge_1_code_description	string	Charge #1: Code Description
hearing_result	string	Hearing Result
charge_8_infraction_amount	string	Charge #8: Infraction Amount
charge_2_code	string	Charge #2: Code
additional_penalties_or_late_fees	number	Additional Penalties or Late Fees
decision_location_borough	string	Decision Location (Borough)
charge_3_code	string	Charge #3: Code
charge_6_code_description	string	Charge #6: Code Description
hearing_status	string	Hearing Status
total_violation_amount	number	Total Violation Amount
ticket_number	string	Ticket Number
charge_1_code_section	string	Charge #1: Code Section

The output schema lists all 74 fields; the table above is the first twenty.

Every row also carries sourceRowId, sourceUpdatedAt and scrapedAt, so a pipeline can tell one record from another and know exactly when it was read.

{
  "charge_7_code_section": "text",
  "charge_6_infraction_amount": "text",
  "charge_4_infraction_amount": 0,
  "violation_details": "Document Printed",
  "charge_4_code_section": "11.29",
  "charge_4_code": "H2",
  "charge_4_code_description": "See Attached NOV",
  "charge_6_code_section": "text"
}

Inputs

Field	What it does
Filter (SoQL)	Applied at the source, so a narrow question fetches a narrow page instead of downloading everything.
Order	Empty keeps the publisher's own order; set a column to sort, for example amount DESC.
Maximum rows	Hard cap. The source is paged 1,000 rows at a time.
Time budget	Stops cleanly and reports how far it got.
Pause between pages	Keeps the run inside the publisher's rate limits.

Limitations

• This is one dataset, from one publisher. It is the OATH Hearings Division Case Status dataset as Office of Administrative Trials and Hearings (OATH) publishes it — not a national or cross-city equivalent, and not a merge with other sources.
• The publisher can change it. Columns are added, renamed and retired upstream; the field list here is the schema the Actor was generated from. A renamed column arrives as a new field only after the Actor is updated.
• Fields are typed from live records. A column that was empty in the sample is declared as text; a value that does not fit the declared type comes back null rather than being coerced into a wrong number.
• Records are what the publisher publishes. No geocoding, no de-duplication across datasets, no enrichment.
• Freshness is the publisher's. The data was last changed upstream on 2026-10-25. Where the publisher supplies a row timestamp it appears as sourceUpdatedAt; scrapedAt records when this Actor read the row.

Why this is different

• OATH Hearings Division Case Status — NYC Open Data declares all 74 of its output fields in the dataset schema, each with a type, a description and an example.
• The Actor reads the OATH Hearings Division Case Status dataset directly from NYC Open Data; no key, login or account is needed.
• Filters run at the source with SoQL, so a narrow request returns a narrow page rather than a full download.
• Every row is flat JSON: nested location objects become latitude and longitude, and no field holds a nested object.
• The row id is stable, so the same request de-duplicates instead of returning the same record twice.

FAQ

Do I need an API key? No. NYC Open Data publishes this dataset openly.

How fresh is it? The Actor reads the dataset live. scrapedAt records when each row was read, and sourceUpdatedAt carries the publisher's own row timestamp where it supplies one.

Can I filter by date or status? Yes — use the Filter field with SoQL, for example status = 'Active'.

What happens if my filter is wrong? The run stops with the portal's own message and the hint to check SoQL, rather than returning an empty dataset that looks like "no data".

Is this the whole dataset? Up to your row cap, paged 1,000 at a time. Raise the cap to read more.

What is sourceRowId? The publisher's own row id when it supplies one, otherwise a stable hash of the row. Either way it is what makes de-duplication and joins possible.

Pricing

Pay per result: $0.0005 per row. Each stored dataset row is billed, including any diagnostic row returned instead of results.

An Actor-start event is also charged at $0.0001 per GB of allocated memory (minimum one event), even if no rows are returned. At 1 GB or less, 1,000 result rows cost $0.5001 before any applicable Store discount.

Data source

NYC Open Data — OATH Hearings Division Case Status, published by Office of Administrative Trials and Hearings (OATH). Public data under the portal's open-data terms.