Open repository in Console
Readme
Updated 1 month ago
‧ Indexed 1 month ago
Employee Reimbursements
This information is derived from payments made to City of Chicago employees from January 1 of the previous calendar year to the present. Payments are initiated by City Departments and issued by the Department of Finance. Descriptions of each attribute follow:
- Voucher Number: This is a unique number assigned to each payment and is used for identifying that particular payment.
- Amount: This is the dollar amount of the payment made.
- Payment Date: This is the date payment was issued.
- Vendor Name: This is the name of the person or entity to which payment was made.
- Description: This is an optional field that indicates the reason payment was made.
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 \"cityofchicago/employee-reimbursements-g5h3-jkgt\".\"employee_reimbursements\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.
Upstream Metadata