Iowa Industrial New Jobs Training Contracts

The Iowa Industrial New Jobs Training (260E) program provides employers expanding Iowa’s workforce with new employee training. The 260E program is designed to increase worker productivity and company profitability, and is administered by Iowa's 15 community colleges and financed through bonds sold by the colleges. Depending on wages paid, the participating businesses divert 1.5% or 3% of the Iowa state withholding taxes generated by the new positions to the community college to retire the bonds. Businesses may also be eligible to receive reimbursement for their on-the-job training expenses, and/or corporate tax credits.

This dataset lists 260E contracts open in or after 2012, Qtr 2, and includes information on: the administering community college, participating employer, location of employment, training expenses, and employment information.

More on <a href="https://www.iowaeconomicdevelopment.com/Business/260E">Iowa's 260E program</a>.

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 \"mydata-iowa-gov/iowa-industrial-new-jobs-training-contracts-wjtw-p6gu\".\"iowa_industrial_new_jobs_training_contracts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.