Iowa Fleet Summary By Year, County And Vehicle Type

The dataset provides vehicle (both motor vehicle and trailer) registration numbers and annual fees in Iowa by year, county and vehicle types. Vehicle types include: Autocycle, Automobile, Bus, Moped, Motor Home - A, Motor Home - B, Motor Home - C, Motorcycle, Multi-purpose, Regular Trailer, Semi Trailer, Small Regular Trailer, Small Semi Trailer, Truck Tractor, Travel Trailer, Truck, Truck - Business Trade, and Truck - Weight and List.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"mydata-iowa-gov/iowa-fleet-summary-by-year-county-and-vehicle-type-6rrx-2vwt\".\"iowa_fleet_summary_by_year_county_and_vehicle_type\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.