APTA Fare Database - Fixed-Route Fares by Agency

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

Agency-level fixed-route fare information from the APTA Fare Database. One row is a transit agency record with jurisdiction and detailed fare-policy survey fields for base fares, passes, reduced fares, transfers, smart cards, stored value, and fare media; a verification query found 558 rows, 405 agencies, and 55 state or province values.

american-public-transportation-association-fare-fixed-route·159 columns·130 KB·APTA statistical publication reuse terms / site copyright notice·updated 1mo ago

Source: American Public Transportation Association · connector code

Schema

memberid	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
mode_code	string
adult_base_fare	double
month_of_most_recent_fair_change	string
year_of_most_recent_fare_change	string
month_of_next_fare_change	string
year_of_next_fare_change	string
minimum_transfer_surcharge_to_same_mode	double
maximum_transfer_surcharge_to_same_mode	double
minimum_transfer_surcharge_to_other_fixed_route_mode	double
maximum_transfer_surcharge_to_other_fixed_route_mode	double
transfers_issued_by_machine	string
minimum_distance_or_zone_surcharge	double
maximum_distance_or_zone_surcharge	double
minimum_peak_hour_surcharge	double
maximum_peak_hour_surcharge	double
minimum_express_limited_service_surcharge	double
maximum_express_limited_service_surcharge	double
cash_payment_surcharge	double
minimum_parking_surcharge	double
maximum_parking_surcharge	double
fuelmin	double
fuelmax	int64
fuelcondition	string
reduced_central_business_district_service_base_fare	double
reduced_neighborhood_service_base_fare	double
reduced_local_service_base_fare	double
reduced_feeder_service_base_fare	double
reduced_parking_service_base_fare	int64
reduced_university_service_base_fare	double
other_regular_services_with_reduced_base_fares	string
other_regular_services_reduced_base_fares_2	string
reduced_base_fare_for_other_regular_service	double
disabled_person_base_fare	double
times_reduced_fare_disabled_person_base_fares_or_fare_media_are_valid	string
senior_person_base_fare	double
minimum_age_eligibility_for_senior_person_fares	decimal128(38, 0)
times_reduced_fare_senior_person_base_fares_or_fare_media_are_valid	string
pre_school_child_base_fare	double
maximum_age_eligibility_for_pre_school_child_fares	string
pre_school_child_fare_media_available	string
times_reduced_fare_pre_school_child_base_fares_or_fare_media_are_valid	string
elementary_school_child_base_fare	double
age_range_eligibility_for_elementary_school_child_fares	string
times_reduced_fare_elementary_school_child_base_fares_or_fare_media_are_valid	string
secondary_school_child_base_fare	double
age_range_eligibility_for_secondary_school_child_fares	string
times_reduced_fare_secondary_school_child_base_fares_or_fare_media_are_valid	string
university_student_base_fare	double
times_reduced_fare_university_student_base_fares_or_fare_media_are_valid	string
low_income_person_base_fare	double
low_income_person_fare_media_available	string
times_reduced_fare_low_income_person_base_fares_or_fare_media_are_valid	string
other_groups_eligible_for_reduced_fares	string
other_group_base_fare	double
disabled_age	string
othergroup_age	string
times_reduced_fare_other_group_base_fares_or_fare_media_are_valid	string
multi_agency_regional_pass	string
multi_agency_single_trip_transfer_off_arrangement	string
stored_value	string
multi_agency_other_transfer_arrangement	string
1_year_or_12_month_pass_cost	double
1_month_or_30_day_pass_cost	double
2_week_14_day_or_half_month_pass_cost	double
1_week_or_7_day_pass_cost	double
3_day_pass_cost	double
1_day_pass_cost	double
1_trip_token_card_or_ticket_cost	double
2_trip_token_card_or_ticket_cost	double
5_trip_token_card_or_ticket_cost	double
10_trip_token_card_or_ticket_cost	double
20_trip_token_card_or_ticket_cost	double
stored_value_min	double
stored_value_pass_cost	double
single_person_tourist_pass	string
family_pass	string
other_multi_person_passes	string
weekendpass	string
tokens_used	string
single_trip_tickets_used	string
multi_trip_tearoff_ticket_cards_used	string
multi_trip_punch_cards_used	string
non_magnetic_passes_used	string
magnetic_stored_value_cards_used	string
magnetic_stored_time_passes_used	string
computer_chip_cards_or_passes_used	string
other_fare_media_used	string
fare_media_sold_by_mail	string
fare_media_sold_on_internet	string
fare_media_available_at_transit_headquarters_or_divisions	string
fare_media_available_at_information_centers	string
fare_media_available_at_intercity_transportation_terminals	string
fare_media_available_at_commercial_outlets	string
fare_media_available_on_vehicles	string
personal_check_payment_accepted	string
organization_check_payment_accepted	string
credit_card_payment_accepted	string
automated_teller_machine_card_payment_accepted	string
money_order_payment_accepted	string
vouchers_or_cards_for_federal_tax_benefit_payment_accepted	string
other_types_of_payment_accepted	string
general_subsidized_fare_payment_plans_available	string
university_employee_subsidized_fare_payment_plans_available	string
university_student_subsidized_fare_payment_plans_available	string
government_employee_subsidized_fare_payment_plans_available	string
social_service_agency_client_subsidized_fare_payment_plans_available	string
school_child_subsidized_fare_payment_plans_available	string
other_subsidized_fare_payment_plans_available	string
other_subsidized_fare_payment_plans_available_2	string
mechanical_fareboxes_used	string
electronic_fareboxes_used	string
mechanical_turnstiles_used	string
electronic_turnstiles_used	string
transfer_issuing_machines_used	string
change_making_machines_used	string
cash_only_fare_media_vending_machines_used	string
credit_card_atm_fare_media_vending_machines_used	string
fare_validation_machines_used	string
magnetic_card_swipe_readers_used	string
other_fare_related_equipment_used	string
per_cent_of_fare_revenue_from_prepaid_fare_media	int64
proof_of_payment_fare_system_used	string
exact_fare_system_used_on_vehicles	string
fare_related_revenue_requirement_or_goal_type	string
government_requiring_fare_related_revenue_requirement_or_goal	string
fare_related_revenue_vs_expenses_percentage	int64
guaranteed_ride_home_plan_available	string
on_time_guarantee_used	string
shows_other_fare_information	string
responded2008	bool
regional_smart_card	string
open_payment_system	string
mobile_device_ticketing	string
free_fares_transit_agency_employees	string
number_of_fare_zones	int64
one_time_initial_fee_for_smart_card	double
fare_increase_schedule_policy	string
percent_of_trips_using_smart_card	int64
percent_of_trips_using_monthly_pass	int64
percent_of_trips_using_weekly_pass	int64
percent_of_fare_revenue_from_federal_tax_benefit	int64
transfers_on_smart_card_only	string
fare_capping_on_smart_card	string
enforcement_of_proof_of_payment	string
evasion_penalty	string
pass_cost_evasion	int64
fare_revenue_from_employer_programs	double
suspended_fares_due_to_covid_19	string
covidsuspstart	string
covidsuspend	string
covidreduce	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-fixed-route\" 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.