From a 500-row sample across 55 columns.
license_numberboroughlongitudebblnta+13longitudebblnta+7Mappable — Socrata point column `location`.
Open on the map →| download_pdf_report | license_number | industry_sector | base_does_business_as | serving_areas | year_base_opened | green_taxi_service | on_demand_service | book_ahead_service | phone | _24_hours | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B01679.pdf"} | B01679 | livery | CENTURY CAR SERVICE | New York City | 1997 | No | Not Reported | Not Reported | 718-740-6600 | LBLESSINGERJR@OLLIESTAXI.COM |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
download_pdf_report | url | — | — | {'url': 'http://www.nyc.…{'url': 'http://www.nyc.…{'url': 'http://www.nyc.… |
license_number | text | TLC License Number for base | 0% | B02830B01751B02267 |
industry_sector | categorical | TLC FHV industry sectors | 0% | liveryblack carluxury limoof 3 |
base_does_business_as | text | Public-facing business name | 0% |
GET /api/datasets/ph7v-u5f3 GET /api/datasets/ph7v-u5f3/quality GET /api/datasets/ph7v-u5f3/related GET /api/columns?dataset=ph7v-u5f3
:@computed_region_yeji_bk3q:@computed_region_sbqj_enih:@computed_region_f5dn_yrer+1longitudelatitudelongitudebblnta+6location:@computed_region_yeji_bk3qborough+4| Not Reported |
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B02705.pdf"} | B02705 | luxury limo | GROUND JET EXECUTIVE TRANSPORTATION | New York City | 2013 | No | Not Reported | Not Reported | 201-368-1000 | INFO@GROUNDJETLIMO.COM | Not Reported |
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B02727.pdf"} | B02727 | luxury limo | OSCAR LIMOUSINE | New York City | 2014 | No | Not Reported | Not Reported | 646-853-0201 | OSCARLIMO2727@GMAIL.COM | Not Reported |
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B02627.pdf"} | B02627 | luxury limo | APL LIMO | New York City | 2013 | No | Not Reported | Not Reported | 973-777-3007 | APLLIMOLLC@GMAIL.COM | Not Reported |
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B02113.pdf"} | B02113 | luxury limo | BER LIMO | New York City | 2005 | No | Not Reported | Not Reported | 212-647-8400 | PETER@BERMUDALIMO.COM | Not Reported |
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B02382.pdf"} | B02382 | luxury limo | THE ORIGINAL DIAL CAR & LIMO | New York City | 2010 | No | Not Reported | Not Reported | 718-743-8042 | MISHKAK@LIVE.COM | Not Reported |
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B01355.pdf"} | B01355 | livery | NEW HARLEM CAR SERVICE | New York City | 1997 | Yes | Not Reported | Not Reported | 212-663-9090 | NEWHARLEMCARSERVICE@YMAIL.COM | Not Reported |
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B02267.pdf"} | B02267 | luxury limo | IFFY TOWNCAR SERVICE | New York City | 2008 | No | Not Reported | Not Reported | 516-523-6937 | INFO@ROSLYNLIMO.COM | Not Reported |
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B00419.pdf"} | B00419 | livery | KOOP DISPATCHING | The Bronx | 1991 | Yes | Yes | Yes | 718-824-6666 | DIMPLES289@AOL.COM | Not Reported |
| {"url":"http://www.nyc.gov/html/tlc/downloads/pdf/B01979.pdf"} | B01979 | livery | DREAMLAND CAR & LIMO SERVICE | New York City | 2002 | Yes | Not Reported | Not Reported | 718-444-5000 | DREAMLANDCARSANDLIMO@GMAIL.COM | Not Reported |
Showing 12 of 52 columns. All of them are listed below.
UBERTREMONT DISPATCHING ALFRED HOLDINGSbase_name | text | Corporate base name in TLC records | 76% | (FOUR ONES CAR SERVICE)(ELEGANTE)(18TH AVENUE PRIVATE CAR… |
serving_areas | text | Bases reported areas they serve | 0% | New York CityBrooklynQueens |
year_base_opened | integer | — | 1% | 199719992014 |
green_taxi_service | categorical | This business provides street hail service through green Boro taxis. | 0% | NoYes2013of 7 |
on_demand_service | categorical | This business provides on-demand service to customers. (Self-reported) | 0% | Not ReportedYesNoof 6 |
book_ahead_service | categorical | This business allows customers to book trips in advance. (Self-reported) | 0% | Not ReportedYesNoof 3 |
phone | phone | — | 0% | 718-438-1100Yes718-438-6262 |
website | url | — | — | {'url': 'http://londonto…{'url': 'http://qvcarser…{'url': 'http://www.reyn… |
email | — | 1% | NEWDRIVERS@UNTERNYC.COMTLC@NYC2WAY.COMETGTLC@EXECUTIVECHARGE.C… |
booking_app | text | Name of app for booking a trip | 93% | UberLimosysLyft |
_24_hours | categorical | Base provides 24-hour service | 0% | Not ReportedYesNoof 6 |
_2015_honor_roll_drivers | categorical | Number of drivers affiliated to the business who were members of the 2015 TLC Safety Honor Roll at the time of the ceremony in September 2015. | 1% | 012of 6 |
_2015_honor_roll_base | categorical | This business is a member of the 2015 TLC Safety Honor Roll. | 0% | NoYesNot Reportedof 4 |
hosted_vision_zero_training | categorical | This business has hosted TLC staff for a meeting to discuss Vision Zero and safe driving tips with drivers. | 0% | NoYes1of 4 |
vehicle_safety_technology_used | categorical | Vehicles affiliated with this base have some form of vehicle safety technology, such as black boxes, cameras, or driver alert systems. This list includes both official TLC Vehicle Safety Technology Pilot participant vehicles as well as self-reported use of this kind of technology. | 0% | NoYesof 2 |
base_provides_safety_training | categorical | Businesses were invited to share if they provide other safety training programs beyond TLC and City requirements. (Self-reported) | 0% | Not ReportedYesNoof 3 |
fatal_crashes | categorical | All collisions involving a TLC-licensed vehicle affiliated with the base at the time of the crash resulting in a fatality (on-duty and off-duty). | 1% | 012of 3 |
fatal_crash_details | categorical | TLC action in response to fatal crash, if applicable. | 99% | (Not found at fault. No …0Not Reportedof 5 |
injury_crashes_per_vehicle | float | All collisions involving a TLC-licensed vehicle affiliated with the base at the time of the crash resulting in an injury of any severity (major and minor injuries; on-duty and off-duty; irrespective of fault). This metric is per-vehicle, determined by the affiliated vehicle number for this base. | 0% | 00.040.03 |
sector_average_injury_crashes_per_vehicle | categorical | Average within the industry sector this base belongs to (livery, black car, or luxury limo) | 0% | 0.050.040.01of 5 |
vehicle_safety_violations_per_vehicle | float | A count of summonses naming vehicles affiliated to a base at the time the violation was issued and where the violator plead or was found guilty. Violations included in this metric fall into three categories: unlicensed activity, insurance requirements, and vehicle condition. This metric is per-vehicle, determined by the affiliated vehicle number for this base. | 0% | 00.070.09 |
sector_average_vehicle_safety_violations_per_vehicle | categorical | Average within the industry sector this base belongs to (livery, black car, or luxury limo) | 0% | 0.10.090.06of 5 |
base_safety_violations_per_vehicle | float | A count of summonses sent to bases, where the violating base plead or was found guilty. Violations included in this metric fall into four categories: accountability (e.g., trip data submission), accessibility, unlicensed activity, and vehicle condition. This metric is per-vehicle, determined by the affiliated vehicle number for this base. | 0% | 00.010.02 |
sector_average_base_safety_violations_per_vehicle | categorical | Average within the industry sector this base belongs to (livery, black car, or luxury limo) | 0% | 0.030.020.01of 6 |
affiliated_vehicles | integer | Average number of vehicles affiliated with the base during the report period. This number is used for all per-vehicle calculations in the report. | 0% | 111012 |
average_vehicle_age | float | An average of the age (in years) of all affiliated vehicles during the report period, determined through TLC vehicle licensing information. | 0% | 3.32.94 |
sector_average_average_vehicle_age | categorical | Average within the industry sector this base belongs to (livery, black car, or luxury limo) | 0% | 7.33.43.8of 8 |
percent_hybrid_alt_fuel_vehicles | integer | Percentage of vehicles affiliated to a base that have hybrid or electric engines or are models TLC has been alerted to that use alternative fuel. | 0% | 065 |
percent_wheelchair_accessible_vehicles | float | Percentage of Boro Taxis affiliated to a base that is wheelchair-accessible. | 0% | 012 |
top_vehicle_models_1 | text | Most common make and model among base's affiliated vehicles | 0% | Lincoln Town CarToyota CamryFord Crown Victoria |
top_vehicle_models_2 | text | Second-most common make and model among base's affiliated vehicles | 2% | Toyota CamryLincoln Town CarToyota Sienna |
top_vehicle_models_3 | text | Third-most common make and model among base's affiliated vehicles | 5% | Lincoln Town CarToyota SiennaToyota Camry |
top_vehicle_models_4 | text | Fourth-most common make and model among base's affiliated vehicles | 9% | Toyota SiennaLincoln Town CarChevrolet Tahoe |
top_vehicle_models_5 | text | Fifth-most common make and model among base's affiliated vehicles | 16% | Toyota SiennaChevrolet TahoeLincoln Town Car |
address | text | — | 0% | 636 WEST 28 STREET NE…1440 39 STREET BROOKL…335 BOND STREET BROOKLY… |
latitude | float | — | 0% | 40.7527340.63847740.678782 |
longitude | float | — | 0% | -74.00641-73.983333-73.93946 |
location | coordinate | — | — | — |
postcode | integer | — | 4% | 111011000111218 |
borough | categorical | — | 10% | QUEENS BROOKLYN MANHATTANof 5 |
community_board | categorical | — | 10% | 1212of 18 |
council_district | integer | — | 10% | 263922 |
census_tract | integer | — | 10% | 9919228 |
bin | integer | — | 10% | 107918431249404005121 |
bbl | integer | — | 10% | 100673000130534600174004320001 |
nta | text | — | 10% | Hunters Point-Sunnyside-…Borough Park …Hudson Yards-Chelsea-Fla… |