Vehicle for Hire Inspection Results - by Month and Type

This dataset is an aggregated summary of Inspections conducted by Year, Month and Vehicle for Hire Type:

• Year and month

• Vehicle for Hire Type. Can be one of the following: Limo, Party bus, Taxi, Transportation Network Vehicle (TNV) and Other.

• Number of Inspections conducted in the Month

• Number of Outcomes as a result of the Inspection. An Outcome could be one or more of the following: Warning, Ticket Issued or Other Enforcement Action Taken

• Inspections that passed for the Month.

• Warnings Given

• Tickets Issued

• Other Enforcement Actions Taken

Note: One Inspection can result in a number of Tickets/Warnings or Other Enforcement Actions as well as a number of Bylaw Names and Bylaw sections that were violated.

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-inspection-results-by-month-and-3cyd-j69j\".\"vehicle_for_hire_inspection_results_by_month_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.