Welcome to this Chicago API, powered by Socrata

For more information on how to access this dataset via the Socrata Open Data API, read on. Additional information on query functionality, code samples, and libraries can be accessed using the navigation above.

Taxi Trips

Good to go! You're already using the latest version of this dataset API.

About This Dataset

  • Dataset Identifier: wrvz-psew
  • Total Rows: 112860054
  • Source Domain: data.cityofchicago.org
  • Created: 5/27/2016, 9:27:48 PM
  • Last Updated: 8/12/2017, 6:41:52 PM
  • Category: Transportation
  • Attribution: City of Chicago
  • License: See Terms of Use
  • Owner: Jonathan Levy
  • Endpoint Version: 2.1
  • Embed These Docs: copy 
    <script type="application/javascript">
  function resize(id, source) {
    var iframe = document.getElementById(id);
    window.addEventListener('message', function(e) {
      if(e.origin !== source) return;
      if(isNaN(e.data.height)) return;
      iframe.height = (e.data.height + 72) + "px";
    }, false);
  }
</script>
<iframe src="https://dev.socrata.com/foundry/data.cityofchicago.org/wrvz-psew/embed" style="border-width:0" width="1020px" height="1000px" frameborder="0" id="embed-wrvz-psew" scrolling="yes" onload="resize('embed-wrvz-psew', 'https://dev.socrata.com');"></iframe>
View dataset »

Download & Export

Just want to grab this dataset in bulk to analyize offline? You can use the SoQL paging parameters to iterate through the dataset, or you can export the entire dataset as a static, downloadable CSV file.

Export dataset as CSV »

Discuss This Dataset

There are currently 0 open community-supported discussion threads about this dataset.

Start a new discussion »

External Integrations

Explore this dataset using other tools:

Open with Plot.ly
Collaborative data science Open with CartoDB.com
Maps for the web, made easy

Taxi trips reported to the City of Chicago in its role as a regulatory agency. To protect privacy but allow for aggregate analyses, the Taxi ID is consistent for any given taxi medallion number but does not show the number, Census Tracts are suppressed in some cases, and times are rounded to the nearest 15 minutes.

Due to the data reporting process, not all trips are reported but the City believes that most are.

Seehttp://digital.cityofchicago.org/index.php/chicago-taxi-data-releasedfor more information about this dataset and how it was created.

Seehttp://dev.cityofchicago.org/open%20data/data%20portal/2019/04/12/tnp-taxi-privacy.htmlfor further discussion of the approach to privacy in this dataset.

Seehttp://dev.cityofchicago.org/open%20data/data%20portal/2017/10/24/taxi-data-behind.htmlfor a note on data freshness.

Getting Started

All communication with the API is done through HTTPS, and errors are communicated through HTTP response codes. Available response types include JSON, XML, and CSV, which are selectable by the "extension" (.json, etc.) on the API endpoint or through content-negotiation with HTTP Accepts headers.

This documentation also includes inline, runable examples. Click on any link that contains a gear symbol next to it to run that example live against the Taxi Trips API. If you just want to grab the API endpoint and go, you'll find it below.

try it docs copy
https://data.cityofchicago.org/resource/wrvz-psew.json

Learn more about:

App Tokens

All requests should include an app token that identifies your application, and each application should have its own unique app token. A limited number of requests can be made without an app token, but they are subject to much lower throttling limits than request that do include one. With an app token, your application is guaranteed access to it's own pool of requests. If you don't have an app token yet, click the button to the right to sign up for one.

Sign up for an app token!

Once you have an app token, you can include it with your request either by using the X-App-Token HTTP header, or by passing it via the $$app_token parameter on your URL.

Learn more about App Tokens & Throttling.

Fields

Each column in the dataset is represented by a single field in its SODA API. Using filters and SoQL queries, you can search for records, limit your results, and change the way the data is output. For example, you could filter this dataset by its trip_id field using a query like the following:

For richer filtering, you can combine filters together by stacking parameters on your URL or by using SoQL queries. Learn more about about each of the fields in this dataset by clicking the headers below, or read more about the SODA API using the navigation at the top of the page.

Learn more about:

Code Snippets

The following are grab-and-go code code samples you can use with popular programming languages and data science tools.

jQuery makes it super simple to fetch and parse JSON from an API endpoint.

copy 
$.ajax({
    url: "https://data.cityofchicago.org/resource/wrvz-psew.json",
    type: "GET",
    data: {
      "$limit" : 5000,
      "$$app_token" : "YOURAPPTOKENHERE"
    }
}).done(function(data) {
  alert("Retrieved " + data.length + " records from the dataset!");
  console.log(data);
});

The following resources might also be helpful:

Python package using Pandas to easily work with JSON data

copy 
#!/usr/bin/env python

# make sure to install these packages before running:
# pip install pandas
# pip install sodapy

import pandas as pd
from sodapy import Socrata

# Unauthenticated client only works with public data sets. Note 'None'
# in place of application token, and no username or password:
client = Socrata("data.cityofchicago.org", None)

# Example authenticated client (needed for non-public datasets):
# client = Socrata(data.cityofchicago.org,
#                  MyAppToken,
#                  userame="user@example.com",
#                  password="AFakePassword")

# First 2000 results, returned as JSON from API / converted to Python list of
# dictionaries by sodapy.
results = client.get("wrvz-psew", limit=2000)

# Convert to pandas DataFrame
results_df = pd.DataFrame.from_records(results)

The following resources might also be helpful:

PowerShell to extract data from SODA

copy 
$url = "https://data.cityofchicago.org/resource/wrvz-psew"
$apptoken = "YOURAPPTOKENHERE"

# Set header to accept JSON
$headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$headers.Add("Accept","application/json")
$headers.Add("X-App-Token",$apptoken)

$results = Invoke-RestMethod -Uri $url -Method get -Headers $headers

The following resources might also be helpful:

The City of Chicago and community maintains a great RSocrata package on Github.

copy 
## Install the required package with:
## install.packages("RSocrata")

library("RSocrata")

df <- read.socrata(
  "https://data.cityofchicago.org/resource/wrvz-psew.json",
  app_token = "YOURAPPTOKENHERE",
  email     = "user@example.com",
  password  = "fakepassword"
)

The following resources might also be helpful:

SAS is a tried and true application suite for data analysis and visualization. The following snippet brings Socrata data into a SAS.

copy 
filename datain url 'http://data.cityofchicago.org/resource/wrvz-psew.csv?$limit=5000&$$app_token=YOURAPPTOKENHERE';
proc import datafile=datain out=dataout dbms=csv replace;
  getnames=yes;
run;

The following resources might also be helpful:

The soda-ruby gem is a simple wrapper around the SODA APIs that makes usage with Ruby more natural.

copy 
#!/usr/bin/env ruby

require 'soda/client'

client = SODA::Client.new({:domain => "data.cityofchicago.org", :app_token => "YOURAPPTOKENHERE"})

results = client.get("wrvz-psew", :$limit => 5000)

puts "Got #{results.count} results. Dumping first results:"
results.first.each do |k, v|
  puts "#{key}: #{value}"
end

The following resources might also be helpful:

SODA.NET is a Socrata Open Data API client library for .NET

copy 
using System;
using System.Linq;

// Install the package from Nuget first:
// PM> Install-Package CSM.SodaDotNet
using SODA;

var client = new SodaClient("https://data.cityofchicago.org", "YOURAPPTOKENHERE");

// Get a reference to the resource itself
// The result (a Resouce object) is a generic type
// The type parameter represents the underlying rows of the resource
// and can be any JSON-serializable class
var dataset = client.GetResource("wrvz-psew");

// Resource objects read their own data
var rows = dataset.GetRows(limit: 5000);

Console.WriteLine("Got {0} results. Dumping first results:", rows.Count());

foreach (var keyValue in rows.First())
{
    Console.WriteLine(keyValue);
}

The following resources might also be helpful:

Copy and paste the following to import this dataset into Stata

copy 
clear
. import delimited "https://data.cityofchicago.org/resource/wrvz-psew.csv?%24limit=5000&%24%24app_token=YOURAPPTOKENHERE"