`dc_dmv_convictions`

Pack: dc-dmv · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/dc_dmv_convictions for the schema, then POST the same URL with its arguments for the data.

Count Washington DC traffic convictions by violation and court disposition, from the District of Columbia DMV conviction file — 330,728 citation records running from 2002 to 2026, each with the violation text (speeding, failure to use a seat belt, driving under the influence, no DC permit), the court disposition, and whether points were assessed. Answers “most common traffic violations in DC”, “how many DUI convictions did DC record last year”, “DC seat belt ticket convictions”, and “what happens to DC speeding tickets in court”. Group by violation or disposition, and narrow with a citation date range.

Parameters

Name	Type	Required	Description
`violation`	string	no	Violation-text substring, e.g. “SPEED”, “SEAT BELT”, “INFLUENCE”, “INSURANCE”.
`code`	string	no	DC violation code, e.g. “T001”, “T005”.
`disposition`	string	no	Court-disposition substring, e.g. “GUILTY”, “LIABLE”, “SUPERIOR”.
`since`	string	no	Earliest citation date, YYYY-MM-DD, e.g. “2025-01-01”.
`before`	string	no	Latest citation date, YYYY-MM-DD, e.g. “2026-01-01”.
`group_by`	string	no	violation (default) counts convictions per violation; disposition counts them per court outcome; none returns individual citation records.
`limit`	number,string	no	Max rows to return (default 25, max 200).

Example call

Arguments

{
  "group_by": "violation",
  "limit": 6
}

curl

curl -X POST https://gateway.pipeworx.io/dc-dmv/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"dc_dmv_convictions","arguments":{"group_by":"violation","limit":6}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('dc_dmv_convictions', {
  "group_by": "violation",
  "limit": 6
});

More examples

{
  "code": "T001",
  "group_by": "violation",
  "limit": 3
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the dc-dmv pack

{
  "mcpServers": {
    "dc-dmv": {
      "url": "https://gateway.pipeworx.io/dc-dmv/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

dc_dmv_convictions