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.