About this Dataset

TLC Industry Indicators

Monthly metrics containing average daily trips and amount of fares collected, active vehicles and drivers, and credit card usage. The information was tabulated from trip records submitted for all TLC industries.
Organization: City of New York
Last updated: 2025-01-17T22:32:03.159576
Tags: daily-trips, drivers, farebox, fhv, green, industry-indicators, taxi, tlc-industry, vehicles, yellow

Tables

Table 1

@usgov.city_of_new_york_tlc_industry_indicators.table_1

41.04 KB
818 rows
14 columns


CREATE TABLE table_1 (
  "year_month" TIMESTAMP,
  "license_class" VARCHAR,
  "trips_per_day" BIGINT,
  "farebox_per_day" DOUBLE,
  "unique_drivers" BIGINT,
  "unique_vehicles" BIGINT,
  "vehicles_per_day" BIGINT,
  "avg_days_vehicles_on_road" DOUBLE,
  "avg_hours_per_day_per_vehicle" DOUBLE,
  "avg_days_drivers_on_road" DOUBLE,
  "avg_hours_per_day_per_driver" DOUBLE,
  "avg_minutes_per_trip" DOUBLE,
  "percent_of_trips_paid_with_credit_card" DOUBLE,
  "trips_per_day_shared" DOUBLE
);