mydata-iowa-gov/state-of-iowa-checkbook-cyqb-8ina
Icon for Socrata external plugin
  •  
    Overview
  •  
    Tables
  •  
    REST API
  •  
    SQL Query
Open repository in Console
 
Readme
Updated 20 days ago
‧
Indexed 6 hours ago

State of Iowa Checkbook

This dataset contains payment transactions recorded in the State of Iowa’s central accounting system for the Executive Branch. Please visit Iowa's Open Checkbook at http://checkbook.iowa.gov to explore this dataset more extensively.

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/state-of-iowa-checkbook-cyqb-8ina\".\"state_of_iowa_checkbook\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • state_of_iowa_checkbook
     
    Left sidebar is currently unimplemented
     
     
     
     
    Right sidebar is currently unimplemented
Upstream Metadata
Data UseCompletenessThe data does not include transactions associated with the Legislative or Judicial Branches, nor does it include transactions that occur outside of the central accounting system, such as payments made by the Board of Regents’ Institutions, Community Based Corrections, Community Colleges, and Area Education Agencies. It also excludes transactions associated with the Consumer Fraud Refunds fund and the DOT Clearing Account fund. This data is available in other datasets. Some data has also been redacted to ensure confidential or sensitive data protected by State (e.g. Iowa Code Section 22.7 or other applicable Iowa Code section) or federal law (e.g. Health Insurance Portability and Accountability Act, Social Security Number Protection Act, and Family Educational Rights and Privacy Act) is not included. The data also excludes payments details for some expenditures which are only recorded in a summary in the central accounting system such as Medicaid, IPERS, unemployment compensation, and tax refunds.Terms of UseSee license.
Data CoverageLocationIowaStart Date2013-07-01
Data ManagementUpdatesOpenPublishing NotesData is updated monthly. Updates are typically available 15 to 20 business days following month end.Publishing AgencyAdministrative Services, Department of

About

State of Iowa Checkbook
20 days ago (updated)
6 hours ago (indexed)
Loading...

Topics

  • checkbook
  • expenditures
  • payments
  • vendors

Source

  • SAE Accounting Team - State of Iowa Checkbook

License

Creative Commons 1.0 Universal (Public Domain Dedication)