Employee Jobs and Attributes 2013-2020

Information about each regular hire* employee at specific points in time, at the end of each calendar year. Employee-related information includes ethnicity, gender and age range. Age range can change from year to year. Job-related information includes date of regular hire, type of regular hire, date of any termination, department, title, SOC job code, SOC job code description, EEO4 job code and management level.

Data is at the end of each calendar year for each of 2013 through 2018. Data is updated annually.

Hire dates for regular hire employees hired before 2013 are all set to December 31, 2012, so accurate employee longevity counts cannot be determined. Employee numbers in the data set are masked, and are not actual employee numbers.

• Regular hire employees have full salaries and benefits and do not have fixed terms on their employment.

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 \"marincounty/employee-jobs-and-attributes-20132020-jd8p-5ykr\".\"employee_jobs_and_attributes_20132020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.