Nj Mvc Vehicle Inspections
nj_mvc_vehicle_inspectionsRead-onlyIdempotent
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, fuel, and separate emissions and safety verdicts. Returns test counts with pass rate, fail rate, and how many failures were emissions rather than safety, grouped by make, model, model year, fuel, body style or test type. Answers "which cars fail NJ emissions inspection most", "Toyota Camry NJ inspection failure rate", "do older cars fail New Jersey inspection more often", "NJ inspection pass rate by make", and "how many diesels does New Jersey inspect". Statewide overall, roughly 10% of tests fail.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fuel | No | Fuel; plain words map to New Jersey's codes, e.g. "gas" (GASO), "diesel" (DIES), "hybrid" (ELEG), "electric" (ELEC). | |
| make | No | Vehicle make, matched as a substring, e.g. "TOYOTA", "FORD", "HONDA". | |
| sort | No | tests (default) ranks by volume; fail_rate ranks by the share of tests that failed. | |
| limit | No | Max groups to return (default 25, max 200). | |
| model | No | Vehicle model, matched as a substring, e.g. "CAMRY", "F150". | |
| group_by | No | Breakdown dimension: make, model, model_year, fuel, body_style, test_type, cylinders. Defaults to make. | |
| min_tests | No | Drop groups with fewer than this many tests before ranking, so a one-car model cannot top a failure-rate table. Default 100. | |
| test_type | No | I for an initial test, R for a re-test. Defaults to every test. | |
| model_year | No | Four-digit model year, e.g. "2015". |