2013 OPM JAG Local Pass Through Grants: Police Video Equipment Technology (PVET)

This dataset provides detail on projects funded through the 2013 OPM JAG Local Pass Through Grant for Police Video Equipment Technology (PVET). Approximately $2.6 million of federal funds was distributed to nine police departments/municipalities with the primary purpose to assist towns in complying with Public Act 11-174 AAC Electronic Recording of Interrogations.

Public Act 11-174, An Act Concerning the Electronic Recording of Interrogations, requires the electronic recording of interrogations in certain situations beginning on January 1, 2014. The Office of the Chief States Attorney (OCSA), in conjunction with the Police Officer Standards and Training Council, the Connecticut Police Chiefs Association and the Connecticut State Police, developed the standards for a digital audiovisual recording system for implementation of the statute.

The State of Connecticut Office of Policy and Management (OPM) provided grant funds under the Police Video Equipment Technology (PVET) program to assist local governments with purchasing equipment necessary for conformance with the PA 11-174 standards. OPM developed the grant program parameters in collaboration with the Connecticut Police Chiefs Association.

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 \"ct-gov/2013-opm-jag-local-pass-through-grants-police-5m9p-astg\".\"2013_opm_jag_local_pass_through_grants_police\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.