Safe Schools Drug and Alcohol Use SY 2012 - Current County Education
This dataset contains summary information by county on Incidents involving Drug and Alcohol reported use in Schools.
School categories are Public School, Charter, Intermediate, Vo-Tech, Non-Public and other.
The data count fields are suppressed when less than 11.
The data and more information is also published and searchable online on the https://www.education.pa.gov/Schools/safeschools/Pages/default.aspx website under School Safety.
Here are the infraction codes and definitions that are utilized within this report as found within appendix Z of the PIMS manual:
http://www.education.pa.gov/Documents/Teachers-Administrators/PIMS/PIMS%20Manuals/2017-2018%20PIMS%20Manual%20Vol%202.pdf
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/safe-schools-drug-and-alcohol-use-sy-2012-current-umiz-nsja\".\"safe_schools_drug_and_alcohol_use_sy_2012_current\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.