Joint Training Institute (JTI) and Joint Safety Institute (JSI) Credit Card Expenditures

Credit card statements and transaction details for the Joint Safety Institute and the Joint Training Institute.

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. The two trusts are fully funded by the Department of Water and Power (DWP) and managed by an appointed board made up of equal numbers of representatives from DWP management and from the International Brotherhood of Electrical Workers (IBEW) Local 18, which represents the majority of workers at the DWP. All information below was compiled by the City's auditors for these two audits. For more information, visit: https://controllerdata.lacity.org/Audits-and-Reports/Joint-Training-Institute-JTI-and-Joint-Safety-Inst/4i3e-krmq

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-m9sx-5vbj\".\"joint_training_institute_jti_and_joint_safety\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.