Taxi Medallion Transfers
Operation of a taxi cab in Chicago requires a City-issued medallion. These medallions may be sold on the open market, with the City of Chicago recording the sale and change in ownership. This dataset shows such medallion transfers.
See https://www.cityofchicago.org/city/en/depts/bacp/supp_info/medallion_owner_information.html for more information about taxi medallions in Chicago.
See https://data.cityofchicago.org/d/tfm3-3j95 for the current Public Passenger Vehicle Licenses in Chicago. For taxis, the Public Vehicle Numbers will match between these datasets.
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 \"cityofchicago/taxi-medallion-transfers-6u8z-aubf\".\"taxi_medallion_transfers\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.