cityofchicago/employee-reimbursements-g5h3-jkgt
Icon for Socrata external plugin
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.

 
Preview
  • employee_reimbursements
     
     
     
     
     
Upstream Metadata