Vehicle for Hire Licensing and Inspections - by Month

This dataset is the monthly, aggreagated summary of the three licence types for Vehicle for Hire (Dispatching, Drivers and Vehicles) as well as the summary of the Inspections conducted that month and any outcomes from those investigations.

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 \"edmonton-ca/vehicle-for-hire-licensing-and-inspections-by-mssj-gszw\".\"vehicle_for_hire_licensing_and_inspections_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.