@pipeworx/nj-mvc

Connect: https://gateway.pipeworx.io/nj-mvc/mcp · Install: one-click buttons

Tools: 2

New Jersey DMV data: Motor Vehicle Commission (MVC) inspection and emission-repair facilities, and the record-level vehicle-inspection results file. Keyless.

What New Jersey calls its DMV

New Jersey’s agency is the Motor Vehicle Commission, universally the MVC. Residents say “MVC agency” where other states say “DMV office”, so the tool descriptions name both.

Tools

Auth

None. data.nj.gov is a public Socrata portal; the public rate limit handles these queries without an app token.

The distinctive dataset

gvur-kt7q is 2,314,032 per-test records, each carrying make, model, model year, fuel, full OBD-II readiness monitors, and separate emissions and safety verdicts. No other state publishes inspection outcomes at that grain, which is what makes “which cars fail New Jersey emissions inspection most” answerable at all.

Live-verified statewide numbers: 2,080,550 passes and 233,477 failures — about a 10% overall fail rate. Split by test type, initial tests fail 8.7% of the time and re-tests 26.7%.

min_tests (default 100) exists because a fail-rate ranking without it is meaningless — a model with three tests and two failures would top every table. sort="fail_rate" ranks by failure share; the default ranks by volume.

Gotchas worth knowing

These are live-verified behaviours, not guesses:

• The facility file’s county column contradicts the address on some rows. A WATERFORD WORK address — Waterford Works is in Camden County — is labelled MORRIS. The county filter is kept because agents ask for counties, but prefer city when the answer has to be right, and the response says so in its note.
• These are inspection and repair shops, not licensing agencies. Someone asking where to renew a New Jersey licence needs an MVC agency, which this file does not contain. The tool description is explicit so a router does not send that question here.
• Town names are abbreviated and upper case (WATERFORD WORK, not “Waterford Works”), so a partial city string matches more reliably than a full one.
• Coordinates are missing on some facility rows — geocoded_column is absent rather than null, so latitude/longitude come back null for those.
• Inspection rows are tests, not vehicles. A car that fails and returns is counted twice; test_type="R" isolates the re-tests.
• emissions_failures and safety_failures can overlap and do not have to sum to failed, which is the overall verdict column.
• Makes and models are upper case and abbreviated (TOYOTA, CAMRY, F150).
• Model years include junk — a handful of rows carry 2033 and 2041. min_tests filters them out of any ranking by construction.
• nja_vhcl_type is empty on every row despite being documented as P/T/H, so it is not offered as a group_by. nja_body_style is the working equivalent.
• as_of is fetched concurrently with the data, not after it. The 2.3M-row aggregate earns a Socrata throttle, and the metadata helper does not retry, so a sequential call intermittently returned a null refresh date.
• The inspection file was last refreshed 2026-03-12; the facility file 2026-07-20. Both are reported in as_of rather than assumed current.

Data sources

• data.nj.gov Socrata t6tk-mr48 — Vehicle Inspection Facility Locations
• data.nj.gov Socrata gvur-kt7q — Vehicle Inspection Data

Tools

• nj_mvc_inspection_facilities — Find a licensed New Jersey vehicle inspection or emission-repair facility — the private inspection stations, state inspection stations and registered emission repair shops overseen by the New Jersey M
• nj_mvc_vehicle_inspections — Measure how often cars pass or fail New Jersey vehicle inspection, from the Motor Vehicle Commission’s record-level results file — 2,314,032 individual tests, each carrying make, model, model year, fu