controllerdata-lacity/joint-training-institute-jti-and-joint-safety-4i3e-krmq
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 years ago
Indexed 1 month ago

Joint Training Institute (JTI) and Joint Safety Institute (JSI) Audit Documents

Click here to read the audit: https://controllerdata.lacity.org/views/4i3e-krmq/files/wE3nyRBxhBYswdaB_m7JHiWwQINaHg3myUQ1TUflZkg?filename=JTI%20JSI%20FINAL%20AUDIT.pdf&content_type=application/pdf%3B%20charset%3Dbinary

Financial documents and underlying data relating to City Controller Ron Galperin's audits of two trusts, the Joint Training Institute and the Joint Safety Institute, which are fully funded by the Department of Water and Power (DWP) and managed by a board made up of equal numbers of representatives from the City and from the International Brotherhood of Electrical Workers (IBEW) Local 18, which represents the majority of workers at the DWP. All financial documents and data are audit documents created directly by the City auditor.

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 \"controllerdata-lacity/joint-training-institute-jti-and-joint-safety-4i3e-krmq\".\"joint_training_institute_jti_and_joint_safety\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • joint_training_institute_jti_and_joint_safety
     
     
     
     
     
Upstream Metadata