Ny Dmv Vehicle Registrations
ny_dmv_vehicle_registrationsCount vehicles registered in New York State from the NYS DMV record-level registration file, broken down by county, ZIP code, city, make, model year, body type, registration class or fuel type. Each of the 12.6 million source rows is one registration record, so this answers "how many cars are registered in Kings County", "how many Teslas are registered in New York", "how many pickup trucks are registered in ZIP 11201", "which New York county has the most registered vehicles", and how many registrations carry a scofflaw, suspension or revocation flag. County names are unabbreviated and upper case, with Brooklyn filed as KINGS. For electric-vehicle share use ny_dmv_ev_adoption; for a DMV office address use ny_dmv_offices.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| zip | No | Five-digit New York ZIP code, e.g. "11201". | |
| city | No | City or town of the registrant, e.g. "BROOKLYN", "BUFFALO", "ALBANY". | |
| make | No | Vehicle make; pass the everyday name, e.g. "TOYOTA", "TESLA", "FORD", "MERCEDES". New York stores makes cut to five characters (TOYOTA is filed as TOYOT), and the full name is cut to match automatically. | |
| limit | No | Max rows to return (default 25, max 200). | |
| county | No | New York county name, unabbreviated and matched case-insensitively. Brooklyn is "KINGS", Manhattan is "NEW YORK", Staten Island is "RICHMOND", Queens is "QUEENS", the Bronx is "BRONX". | |
| group_by | No | Breakdown dimension: county, zip, city, fuel, make, model_year, body_type, registration_class, record_type, state. Defaults to county. | |
| body_type | No | Body-type code, e.g. "SUBN" (SUV/station wagon), "4DSD" (4-door sedan), "PICK" (pickup), "MCY" (motorcycle), "VAN". | |
| fuel_type | No | Fuel; plain words are mapped to New York's codes, e.g. "gas" → GAS, "diesel" → DIESEL, "electric" → ELECTRIC, "cng" → COMP N/G. The published codes are GAS, DIESEL, ELECTRIC, NONE, FLEX, COMP N/G, OTHER, PROPANE. | |
| model_year | No | Four-digit model year, e.g. "2024". | |
| record_type | No | Which register to read: VEH, TRL, BOAT, SNOW. Defaults to VEH (road vehicles); TRL is trailers, BOAT is vessels, SNOW is snowmobiles. | |
| registration_class | No | Registration class code, e.g. "PAS" (passenger), "COM" (commercial), "MOT" (motorcycle), "SRF" (semi-trailer). | |
| scofflaw_indicator | No | Set "Y" to count only registrations flagged as scofflaw (unpaid tickets), "N" for the rest. | |
| revocation_indicator | No | Set "Y" to count only revoked registrations, "N" for the rest. | |
| suspension_indicator | No | Set "Y" to count only registrations under suspension, "N" for the rest. |