2019 Green Taxi Trip Data
These records are generated from the trip record submissions made by green taxi Technology Service Providers (TSPs). Each row represents a single trip in a green taxi. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off taxi zone locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Dormant
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Mar 5, 2020
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Mar 5, 2020, 10:27 AM
- Rows in our copy
- 6,044,050
- Rows at the source
- 6,044,050
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 20 columns carry a concept; 0 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
dolocationid | DOLocationID | The publisher describes this column nowhere. | Not bound | Number | dolocationid | numeric | — | |
tip_amount | tip_amount | The publisher describes this column nowhere. | Not bound | Number | tip_amount | numeric | — | |
store_and_fwd_flag | store_and_fwd_flag | The publisher describes this column nowhere. | Not bound | Text | store_and_fwd_flag | text | — | |
congestion_surcharge | congestion_surcharge | The publisher describes this column nowhere. | Not bound | Text | congestion_surcharge | text | — | |
tolls_amount | tolls_amount | The publisher describes this column nowhere. | Not bound | Number | tolls_amount | numeric | — | |
improvement_surcharge | improvement_surcharge | The publisher describes this column nowhere. | Not bound | Number | improvement_surcharge | numeric | — | |
ratecodeid | RatecodeID | The publisher describes this column nowhere. | Not bound | Number | ratecodeid | numeric | — | |
pulocationid | PULocationID | The publisher describes this column nowhere. |
Download
This file was produced on Sep 2, 2026, 10:02 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/q5mz-t52e
- Version
- Content hash:
f16d9af84d3222e7016a6bcedc115822cc839c56370247f7563199dcc9555c78 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Mar 5, 2020, 10:27 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Sep 1, 2026, 12:46 PM | full_replace | success | 6,044,050 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 29, 2026, 8:15 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 28, 2026, 12:15 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 27, 2026, 8:00 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 27, 2026, 11:45 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 27, 2026, 7:30 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 27, 2026, 5:15 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 27, 2026, 4:00 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |