EEO-4 Reports

The EEOC collects workforce data from employers with more than 100 employees, including State and Local governments. Federal agencies use the report to develop new strategies in furtherance of EEO practices, helping jurisdictions to establish benchmarks and provide guidance in the evaluation of internal programs to ensure equal employment opportunity. The City of New York is legally mandated to submit the federal EEO-4 report every two years. The report provides a summary of a jurisdiction's workforce composition by agency function, job category, salary, race/ethnicity, and gender.

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 \"cityofnewyork-us/eeo4-reports-dbpt-pbmd\".\"eeo4_reports\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.