From a 500-row sample across 22 columns.
| func_code | function_description | employment_status | job_category | line_no | salary_band | non_hispanic_latino_male | nonhispanic_latino_female | total | fy | hispanic_latino_male | hispanci_latino_female |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | FINANCIAL ADMINISTRATION AND GENERAL CONTROL | 1. FULL-TIME EMPLOYEES | OFFICIAL/ADM | 6 | 43.0-54.9 | 1 | 1 | 2 | 2021 | — | — |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
func_code | categorical | A code indicating the state and local government function | 0% | 1413of 12 |
function_description | categorical | State and local government functions | 0% | FINANCIAL ADMINISTRATION…POLICE PROTECTIONCORRECTIONSof 12 |
employment_status | categorical | Employment Status | 0% | 1. FULL-TIME EMPLOYEESFULL-TIME EMPLOYEES3. NEW HIRES DURING FISC…of 6 |
job_category | text | EEO job category | 0% |
GET /api/datasets/dbpt-pbmd GET /api/datasets/dbpt-pbmd/quality GET /api/datasets/dbpt-pbmd/related GET /api/columns?dataset=dbpt-pbmd
| 1 |
| FINANCIAL ADMINISTRATION AND GENERAL CONTROL |
| 1. FULL-TIME EMPLOYEES |
| OFFICIAL/ADM |
| 7 |
| 55.0-69.9 |
| 26 |
| 43 |
| 159 |
| 2021 |
| 15 |
| 19 |
| 1 | FINANCIAL ADMINISTRATION AND GENERAL CONTROL | 1. FULL-TIME EMPLOYEES | OFFICIAL/ADM | 8 | 70.0 PLUS | 1451 | 1225 | 4690 | 2021 | 260 | 311 |
| 1 | FINANCIAL ADMINISTRATION AND GENERAL CONTROL | 1. FULL-TIME EMPLOYEES | PROFESSIONALS | 13 | 33.0-42.9 | 2 | 1 | 18 | 2021 | 4 | 4 |
| 1 | FINANCIAL ADMINISTRATION AND GENERAL CONTROL | 1. FULL-TIME EMPLOYEES | PROFESSIONALS | 14 | 43.0-54.9 | 49 | 30 | 313 | 2021 | 26 | 16 |
| 1 | FINANCIAL ADMINISTRATION AND GENERAL CONTROL | 1. FULL-TIME EMPLOYEES | PROFESSIONALS | 15 | 55.0-69.9 | 127 | 115 | 842 | 2021 | 64 | 74 |
| 1 | FINANCIAL ADMINISTRATION AND GENERAL CONTROL | 1. FULL-TIME EMPLOYEES | PROFESSIONALS | 16 | 70.0 PLUS | 1038 | 739 | 4019 | 2021 | 255 | 227 |
| 1 | FINANCIAL ADMINISTRATION AND GENERAL CONTROL | 1. FULL-TIME EMPLOYEES | TECHNICIANS | 21 | 33.0-42.9 | 5 | 3 | 37 | 2021 | 1 | 6 |
| 1 | FINANCIAL ADMINISTRATION AND GENERAL CONTROL | 1. FULL-TIME EMPLOYEES | TECHNICIANS | 22 | 43.0-54.9 | 83 | 102 | 681 | 2021 | 56 | 64 |
| 1 | FINANCIAL ADMINISTRATION AND GENERAL CONTROL | 1. FULL-TIME EMPLOYEES | TECHNICIANS | 23 | 55.0-69.9 | 93 | 84 | 438 | 2021 | 22 | 35 |
Showing 12 of 21 columns. All of them are listed below.
PROFESSIONALSTECHNICIANSPARA-PROF |
line_no | integer | Line in EEO-4 report | 0% | 703846 |
salary_band | categorical | Annual salary in $000 | 33% | 55.0-69.970.0 PLUS43.0-54.9of 10 |
hispanic_latino_male | integer | All males of Mexican, Puerto Rican, Cuban, Central or South American, or other Spanish culture or origin, regardless of race. | 12% | 120 |
hispanci_latino_female | integer | All females of Mexican, Puerto Rican, Cuban, Central or South American, or other Spanish culture or origin, regardless of race. | 16% | 102 |
non_hispanic_latino_male | integer | All males having origins in any of the original peoples of Europe, North Africa, or the Middle East. | 11% | 102 |
nonhispanic_latino_male_black | integer | All males having origins in any of the Black racial groups of Africa. | 10% | 123 |
nonhispanic_latino_male_asian | integer | All males having origins in any of the original peoples of the Far East, Southeast Asia, the Indian Subcontinent, or the Pacific Islands. This area includes, for example, China, India, Japan, Korea, the Philippine Islands, and Samoa. | 19% | 102 |
nonhispanic_latino_male_nhopi | categorical | Males who reported Native Hawaiian or Other Pacific Islander and did not report any other race. | 54% | 012of 16 |
nonhispanic_latino_male_amer | integer | All males having origins in any of the original peoples of North America, and who maintain cultural identification through tribal affiliation or community recognition. | 47% | 012 |
nonhispanic_latino_male_2 | integer | This category represents all those respondents who reported more than one race. | 33% | 012 |
non_hispanic_latino_female | integer | All females having origins in any of the original peoples of Europe, North Africa, or the Middle East. | 21% | 012 |
nonhispanic_latino_female | integer | All females having origins in any of the Black racial groups of Africa. | 12% | 102 |
nonhispanic_latino_female_1 | integer | All females having origins in any of the original peoples of the Far East, Southeast Asia, the Indian Subcontinent, or the Pacific Islands. This area includes, for example, China, India, Japan, Korea, the Philippine Islands, and Samoa. | 26% | 012 |
nonhispanic_latino_female_2 | categorical | Females who reported Native Hawaiian or Other Pacific Islander and did not report any other race. | 56% | 012of 14 |
nonhispanic_latino_female_3 | integer | All females having origins in any of the original peoples of North America, and who maintain cultural identification through tribal affiliation or community recognition. | 50% | 012 |
nonhispanic_latino_female_4 | integer | This category represents all those respondents who reported more than one race. | 35% | 012 |
total | integer | The total number of employees in that function for that salary band | 0% | 123 |
fy | categorical | Fiscal Year | 0% | 201920212023of 3 |