CSV

CalHR 5112 statewide 2020

CalHR 5112 report for year 2020. Includes data on number of new hires and advancements by ethnicity and gender for each occupation class across all departments.

Download Resource< Back to dataset

Data dictionary

Field definitions supplied by the publishing agency in CKAN.

Column	Type	Label	Description
Department	text	Department	—
SOC Major Group Title	text	SOC Major Group Title	—
SOC Major Group Code	text	SOC Major Group Code	—
SOC Detailed Group Title	text	SOC Detailed Group Title	—
SOC Detailed Group Code	text	SOC Detailed Group Code	—
Class Code	numeric	Class Code	—
Class Schematic Sequence	text	Class Schematic Sequence	—
Class Title	text	Class Title	—
Ethnicity	text	Ethnicity	—
Gender	text	Gender	—
Hire Type	text	Hire Type	—

Resource details

Format	CSV
Size	14 MB
Rows	48,904
Last updated	Sep 30, 2026
Part of	State of CA Workforce Data in Machine Readable Structure

Other resources in this dataset

CKAN Data API

Access resource data through the CKAN DataStore API. The examples below use this resource's ID.

Endpoints

The Data API provides these actions. Creating or updating records requires appropriate permissions; the query actions read public DataStore records.

Create	`https://ckan.cdt.dev.datopian.com/api/3/action/datastore_create`
Update / insert	`https://ckan.cdt.dev.datopian.com/api/3/action/datastore_upsert`
Query	`https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search`
Query via SQL	`https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search_sql`

Query examples

First five results

"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=d308f328-6b5b-41c1-8bc2-a4afcfcee3d1&limit=5"

Results containing "jones"

"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=d308f328-6b5b-41c1-8bc2-a4afcfcee3d1&q=jones"

SQL query

"https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search_sql?sql=SELECT%20%2A%20FROM%20%22d308f328-6b5b-41c1-8bc2-a4afcfcee3d1%22%20LIMIT%205"

SQL queries depend on whether SQL search is enabled by the portal.

OData query

Use the resource's OData URL and its field names for paging, selecting columns, or filtering rows.

ODATA_RESOURCE_URL?$top=5
ODATA_RESOURCE_URL?$skip=5&$top=5
ODATA_RESOURCE_URL?$select=FIELD_NAME&$filter=FIELD_NAME eq 'VALUE'

Replace ODATA_RESOURCE_URL, FIELD_NAME, and VALUE with the details for the selected resource. See the OData query options guide (opens in a new tab) for more examples.

Use the API in code

JavaScript (JSONP)

var data = { resource_id: 'd308f328-6b5b-41c1-8bc2-a4afcfcee3d1', limit: 5, q: 'jones' };
$.ajax({
  url: 'https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search',
  data: data,
  dataType: 'jsonp',
  success: function (response) {
    console.log(response.result.total, response.result.records);
  }
});

Python

import json
from urllib.request import urlopen

url = 'https://ckan.cdt.dev.datopian.com/api/3/action/datastore_search?resource_id=d308f328-6b5b-41c1-8bc2-a4afcfcee3d1&limit=5'
with urlopen(url) as response:
    result = json.load(response)['result']
print(result['total'], result['records'])

For parameters and response fields, see the CKAN DataStore documentation (opens in a new tab).