internal-open-piercecountywa-gov/competency-order-transport-time-4v5h-t3j7
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 3 years ago
Indexed 1 month ago

Competency Order Transport Time

Aggregated by Month - Average number of days from the court's order for a competency evaluation to the actual transport of the defendant from the Pierce County Jail to the location performing the competency evaluation. This data reflects the first competency order

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 \"internal-open-piercecountywa-gov/competency-order-transport-time-4v5h-t3j7\".\"competency_order_transport_time\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • competency_order_transport_time
     
     
     
     
     
Upstream Metadata