Public Transit Services and Reduced-fare Programs by County, Current, Transportation

This dataset lists all public transit services and reduced-fare programs currently provided in each county of PA.

Public transportation is available in every county in Pennsylvania, with a wide range of services including:

• Fixed-route transit service in Philadelphia, Pittsburgh, 21 small urban areas, and 22 rural areas

• 44 systems offering shared-ride services in all Pennsylvania counties

• 13 intercity bus routes

• Keystone Corridor Amtrak service, running from Harrisburg to New York by way of Philadelphia, and Pennsylvanian Amtrak service running from Pittsburgh to Philadelphia

• 66 counties with rural transportation for persons with disabilities

NOTE: Service providers offering two or more reduced-fare programs have duplicate records to reflect the various programs and to allow sorting by program type.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"pa-gov/public-transit-services-and-reducedfare-programs-wgkx-3uws\".\"public_transit_services_and_reducedfare_programs\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.