APTA Vehicle Database - Transit Fleet Equipment by Agency

Name: APTA Vehicle Database - Transit Fleet Equipment by Agency
Creator: American Public Transportation Association
License: APTA statistical publication reuse terms / site copyright notice

Agency-level transit vehicle equipment counts from the APTA Vehicle Database. One row is a transit agency and mode-equipment summary, with counts for features such as cameras, stop announcements, passenger counters, fareboxes, bicycle racks, AVL equipment, and safety systems; the profile contains 746 rows.

american-public-transportation-association-vehicle-equipment·46 columns·69 KB·APTA statistical publication reuse terms / site copyright notice·updated 14d ago

Source: American Public Transportation Association · connector code

Schema

member_id	int64
transit_agency_name	string
city	string
state	string
country	string
new_2025_data	string
last_data_submission	string
country_2	string
mode_code	string
mode_name	string
total_vehicles	int64
air_conditioning_number_with	int64
outlets_for_electrical_devices_number_with	int64
restroom_number_with	int64
overhead_storage_rack_number_with	int64
wireless_capability_number_with	int64
automated_stop_announcement_equipment_number_with	int64
electronic_destination_signs_number_with	int64
dynamic_destination_signs_number_with	int64
operator_base_2_way_radio_number_with	int64
operator_base_telephone_number_with	int64
emergency_passenger_operator_intercom_number_with	int64
public_address_system_number_with	int64
interior_audio_system_number_with	int64
interior_video_system_number_with	int64
emergency_operator_notification_system_number_with	int64
security_camera_number_with	int64
outward_facing_cameras	int64
inward_facing_cameras	int64
cameras_with_audio_recording_capability	int64
alerter_system	int64
emergency_braking	int64
pedestrian_bicyclist_detection	int64
blind_spot_detection	int64
lane_keeping_assist	int64
collision_warning_mitigation	int64
adaptive_cruise_control	int64
electronic_farebox_number_with	int64
non_electronic_farebox_number_with	int64
automatic_passenger_counter_number_with	int64
exterior_bicycle_rack_number_with	int64
interior_bicycle_rack_storage_space_number_with	int64
interior_advertising_number_with	int64
exterior_advertising_number_with	int64
automatic_vehicle_location_equipment_number_with	int64
traffic_light_preemption_equipment_number_with	int64

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small   # or medium, or large
subsets serve   # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →

Bash

subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"american-public-transportation-association-vehicle-equipment\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.