@pipeworx/wa-dmv
Connect: https://gateway.pipeworx.io/wa-dmv/mcp · Install: one-click buttons
Tools: 2
Washington State DMV MCP — the Department of Licensing’s VIN-level electric-vehicle population and its monthly vehicle-registration transaction counts. Keyless.
Washington has no agency called “the DMV”: vehicle registration and driver licensing are run by the Department of Licensing (DOL). Both names appear in the tool descriptions because agents search for “WA DMV”.
Tools
| Tool | What it returns |
|---|---|
wa_dmv_ev_population(...) | Counts of registered electric vehicles by county, city, ZIP, make, model, model year, legislative district, electric utility or drivetrain, with BEV/PHEV split and average electric range. A true fleet snapshot — one source row per registered vehicle. |
wa_dmv_registration_transactions(...) | Registration transactions (new registrations and renewals) for one fiscal year or one calendar month, by owner county, transaction county, fuel type, use class or month. |
Auth
Keyless. Both datasets are public Socrata resources on data.wa.gov; no app token is required at the volumes this pack issues.
Per-state gotchas
hmzg-s6q4counts transactions, not vehicles. This is the trap in this state. King County processes roughly 160,000 registration transactions a month, so summing every month back to fiscal 2017 returns 17.6M for one county — arithmetically correct and completely misleading.wa_dmv_registration_transactionstherefore pins every query to one fiscal year (the latest by default) or one calendar month, and labels the result “registration transactions during <period>”. For the size of a registered fleet, usewa_dmv_ev_population.- Washington fiscal years run July 1 – June 30. Fiscal 2026 covers July 2025 through June 2026. Data starts at fiscal 2017.
- The
monthcolumn stores the last day of the month. Filter it withdate_trunc_ym, which themonthargument (YYYY-MM) does for you; results are reported back asYYYY-MM. - Case differs by column. Counties and cities are plain mixed case (
King,Seattle); makes and models are upper case (TESLA,MODEL 3). - Roughly two-thirds of EV rows carry
electric_range0. 188,456 of 289,564 vehicles sit in the “Eligibility unknown as battery range has not been researched” CAFV bucket with a literal zero range, which drags any average down. The genuinely researched vehicles average ~133 miles. Treataverage_electric_range_milesas a floor, not a spec. - Socrata reports an all-zero average as the string
"0E-24". The sharedgovNumberhelper strips exponent notation into NaN, so this pack parses averages with its ownavgMiles. ev_typehas exactly two values, spelled in full:Battery Electric Vehicle (BEV)andPlug-in Hybrid Electric Vehicle (PHEV). Theev_typeargument acceptsBEV/PHEV/ plain phrases.sum_of_returned_rowsis not a total. Row lists are cut off bylimit;total_electric_vehiclesandtotal_transactions_in_periodare separate full counts over the same filters and are the figures to quote.
Data sources
- EV population — https://data.wa.gov/resource/f6w7-q2d2.json (Electric Vehicle Population Data)
- Registration transactions — https://data.wa.gov/resource/hmzg-s6q4.json (Vehicle Registration Transactions by County)
Tools
- wa_dmv_ev_population — Count electric vehicles currently registered in Washington State, from the Department of Licensing (Washington DMV) VIN-level Electric Vehicle Population file — one row per registered vehicle, so thes
- wa_dmv_registration_transactions — Count Washington State vehicle registration transactions — original registrations and renewals processed by the Department of Licensing (Washington DMV) — for one fiscal year or one calendar month, br
Tools
-
wa_dmv_ev_population— Count electric vehicles currently registered in Washington State, from the Department of Licensing (Washington DMV) VIN-level Electric Vehicle Population file — one row per registered vehicle, so thes -
wa_dmv_registration_transactions— Count Washington State vehicle registration transactions — original registrations and renewals processed by the Department of Licensing (Washington DMV) — for one fiscal year or one calendar month, br