Public Passenger Vehicle Licenses - Historical

<b>NOT CURRENT DATA</b> - This dataset contains <b>past</b> records from the <a href="https://data.cityofchicago.org/d/tfm3-3j95"> Public Passenger Vehicle Licenses dataset</a>. It is intended for historical reference, not current licensing information. It follows the format of the Public Passenger Vehicle Licenses dataset, with the addition of two additional columns at the end.

The Last Valid Date column indicates the most recent timestamp when that set of values appeared in the Public Passenger Vehicle Licenses dataset. It indicates when that version of the license record <b>stopped</b> being valid (was replaced by an updated version), not when it <b>started</b> being valid (replaced a previous version or was created for a newly added license). Due to various technical limitations, the Last Valid Date may be artificially late and intervening versions not shown are possible.

The Record Version ID is a unique identifier that has no meaning beyond distinguishing different versions of the same RecordID.

Please read the article linked below for more information.

Due to a change in the source system on 11/19/2018, all licenses will appear to have been updated on that date or on 11/20/2018.

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/public-passenger-vehicle-licenses-historical-tx35-q6ia\".\"public_passenger_vehicle_licenses_historical\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.