nj-gov/yourmoney-agency-payroll-iqwc-r2w7
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 1 month ago

YourMoney Agency Payroll

This dataset contains data for State employees paid through the Centralized Payroll System. The data reflects payroll payments made to the employee for the calendar year through the date indicated. There are two types of records: MASTER and DETAIL. There is at least one MASTER and one DETAIL record per employee. Multiple DETAIL records for an employee will appear in the file for a specific year if the employee is paid by more than one department/agency or by more than one section during that calendar year. The sums for all of the departments/agencies appear in the columns with prefix “MASTER”. Additional information is in the attached dataset summary PDF (available on the About tab under "Attachments").

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 \"nj-gov/yourmoney-agency-payroll-iqwc-r2w7\".\"yourmoney_agency_payroll\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • yourmoney_agency_payroll
     
     
     
     
     
Upstream Metadata