pa-gov/pennsylvania-professional-licensee-data-county-fwj2-whnj
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 4 months ago
Indexed 1 hour ago

Pennsylvania Professional Licensee Data County State

This dataset contains counts of professional licensees per each licensed occupation and is broken down by County of licensee.

*Appearances of non-Pennsylvania counties in the data are due to practitioners that are either licensed to practice in Pennsylvania but live out of state or own a facility in Pennsylvania but live out of state.

**Appearances of null values in the data are due to the county field being an optional field for a license application and the county does not auto populate based on the address at this point in time.

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/pennsylvania-professional-licensee-data-county-fwj2-whnj\".\"pennsylvania_professional_licensee_data_county\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • pennsylvania_professional_licensee_data_county
     
     
     
     
     
Upstream Metadata