APTA Fare Database - Demand-Response Fares by Agency

Name: APTA Fare Database - Demand-Response Fares by Agency
Creator: American Public Transportation Association
License: APTA statistical publication reuse terms / site copyright notice

Agency-level demand-response fare information from the APTA Fare Database. One row is a transit agency record with geography and fare-policy fields for demand-response service; the profile contains 387 rows and includes many optional yes/no and text response columns from the source survey.

american-public-transportation-association-fare-demand-response·55 columns·54 KB·APTA statistical publication reuse terms / site copyright notice·updated 2d ago

Source: American Public Transportation Association · connector code

Schema

member_id	int64
new_2025_data	string
survey_sent_in_2025	string
last_data_submission	string
transit_agency_name	string
city	string
state_or_province	string
country	string
month_of_most_recent_fare_change	string
year_of_most_recent_fare_change	string
disabled_minimum_base_fare	double
disabled_maximum_base_fare	double
attendant_to_disabled_minimum_base_fare	double
attendant_to_disabled_maximum_base_fare	double
companion_to_disabled_minimum_base_fare	double
companion_to_disabled_maximum_base_fare	double
senior_minimum_base_fare	double
senior_maximum_base_fare	double
pre_school_child_minimum_base_fare	double
pre_school_chiild_maximum_base_fare	double
elementary_school_child_minimum_base_fare	double
elementary_school_child_maximum_base_fare	double
secondary_school_child_minimum_base_fare	double
secondary_school_child_maximum_base_fare	double
university_student_minimum_base_fare	double
university_student_maximum_base_fare	double
low_income_person_minimum_base_fare	double
low_income_person_maximum_base_fare	double
social_service_agency_client_minimum_base_fare	double
social_service_agency_client_maximum_base_fare	double
general_public_minimum_base_fare	double
general_public_maximum_base_fare	double
service_in_areas_fixed_route_service_does_not_operate	string
service_during_hours_fixed_route_service_does_not_operate	string
service_during_same_hours_and_in_same_areas_as_fixed_route_service	string
service_only_when_space_available	string
mobility_pilot_with_uber	string
mobility_pilot_with_lyft	string
mobility_pilot_with_via	string
mobility_pilot_with_other	string
self_operated_mobility_pilot	string
first_last_mile_mobility_pilot	string
paratransit_supplement_mobility_pilot	string
other_service_mobility_pilot	string
mobility_pilot_per_trip_subsidy_discount_voucher_amount_minimum	double
mobility_pilot_per_trip_subsidy_discount_voucher_amount_maximum	double
mobility_pilot_flat_or_distance_based_fare_maximum	double
mobility_pilot_flat_or_distance_based_fare_minimum	double
mobility_pilot_fare_notes	string
microtransit_mobility_pilot	string
pilotnotes	string
suspended_fares_due_to_covid_19	string
reduced_fares_due_to_covid_19	string
start_of_fare_suspension_reduction	string
end_of_fare_suspension_reduction	string

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-fare-demand-response\" 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.