Single County Authority (SCA) Locations Current Drug and Alcohol Programs

This dataset reports the name of the site, street address, city, county, zip code, telephone number, latitude, and longitude of Pennsylvania Single County Authorities (SCAs). SCAs receive state and federal dollars through contracts with the Department of Drug and Alcohol Programs (DDAP) to plan, coordinate, manage, and implement the delivery of drug and alcohol prevention, intervention, and treatment services at the local level.

The Pennsylvania Association of County Drug and Alcohol Administrators (PACDAA) is a professional association that represents the Single County Authorities (SCAs) across the commonwealth who receive state and federal dollars through contracts with the Department of Drug and Alcohol Programs (DDAP), to plan, coordinate, programmatically and fiscally manage and implement the delivery of drug and alcohol prevention, intervention, and treatment services at the local level.

SCAs also receive funding for treatment services from the PA Department of Human Services (DHS), Office of Mental Health and Substance Abuse Services (OMHSAS). These services funded by DHS are primarily targeted to individuals in non-hospital residential care who are eligible for Medical assistance, or to a continuum of treatment services for those individuals no longer eligible as a result of welfare reforms.​

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/single-county-authority-sca-locations-current-drug-tccg-xqsp\".\"single_county_authority_sca_locations_current_drug\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.