Capital District Transportation Authority (CDTA) Performance Metrics: Beginning 2009

CDTA is a public transportation authority in the Capital Region. This dataset presents information that reflects the organizations performance levels. This dataset includes customer boarding’s, miles operated, accidents, preventative maintenance inspections, and complaints.

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 \"ny-gov/capital-district-transportation-authority-cdta-q7iu-6j5f\".\"capital_district_transportation_authority_cdta\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.