2017-f500-diversity Data Dictionary
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
NameDescriptionTypeExamples
2
f500-2017-rank
Rank of the company on the 2017 Fortune 500
numeric1, 2, 3, etc
3
name
Name of the company as it appears on the Fortune 500 list
text
Wal-Mart Stores, Berkshire Hathaway, Apple, etc
4
data-avail
Indicates whether the company publicly releases full employee diversity data (full data means it matches EEO-1 form fields), partial data, or no data
textY, N, Partial
5
data-url
The link to the site where the diversity data can be found online
url
https://www.apple.com/diversity/
6
diversity-pg-url
The link to the webpage where the company has a commitment to diversity and/or inclusion or an equal opportunity employment statement
url
https://images.apple.com/diversity/pdf/2016-EEO-1-Consolidated-Report.pdf
7
data-year
The year for which diversity data is available for the company, "n/a" if no data is publicly available
numeric2015, 2016, n/a
8
PAYROLL_START
Date marking the beginning of the payroll period in which the data was collected, "n/a" if no data is publicly available
numeric7/8/2016, n/a
9
PAYROLL_END
Date marking the end of the payroll period in which the data was collected, "n/a" if no data is publicly available
numeric7/8/2016, n/a
10
HISPM1
1-Senior OFF AND MGRS/HISPANIC/MALE
numeric2
11
HISPM1_2
HISPANIC MID OFF AND MGRS
numeric411
12
HISPM2
2-PROF/HISPANIC/MALE
numeric799
13
HISPM3
3-TECH/HISPANIC/MALE
numeric1709
14
HISPM4
4-SALE/HISPANIC/MALE
numeric2562
15
HISPM5
5-CLERICALS/HISPANIC/MALE
numeric672
16
HISPM6
6-CRAFT/HISPANIC/MALE
numeric13
17
HISPM7
7-OPER/HISPANIC/MALE
numeric0
18
HISPM8
8-LABORS/HISPANIC/MALE
numeric0
19
HISPM9
9-Service/HISPANIC/MALE
numeric132
20
HISPM10
10-TOTAL/HISPANIC/MALE
numeric6300
21
HISPM11
11-PREVIOUS YEAR TOTAL/HISPANIC/MALE
numeric5774
22
HISPF1
1-Senior OFF AND MGRS/HISPANICFE/MALE
numeric0
23
HISPF1_2
1.2-Mid OFF AND MGRS/HISPANICFE/FEMALE
numeric149
24
HISPF2
2-PROF/HISPANIC/FEMALE
numeric382
25
HISPF3
3-TECH/HISPANIC/FEMALE
numeric617
26
HISPF4
4-SALE/HISPANIC/FEMALE
numeric1260
27
HISPF5
5-CLERICALS/HISPANIC/FEMALE
numeric666
28
HISPF6
6-CRAFT/HISPANIC/FEMALE
numeric0
29
HISPF7
7-OPER/HISPANIC/FEMALE
numeric0
30
HISPF8
8-LABORS/HISPANIC/FEMALE
numeric0
31
HISPF9
9-Service/HISPANIC/FEMALE
numeric97
32
HISPF10
10-TOTAL/HISPANIC/FEMALE
numeric3171
33
HISPF11
11-PREVIOUS YEAR TOTAL/HISPANIC/FEMALE
numeric2746
34
WHM1
1-Senior OFF AND MGRS/WHITE/MALE
numeric73
35
WHM1_2
WHITE MID OFF AND MGRS
numeric3903
36
WHM2
2-PROF/WHITE/MALE
numeric9012
37
WHM3
3-TECH/WHITE/MALE
numeric7646
38
WHM4
4-SALE/WHITE/MALE
numeric8414
39
WHM5
5-CLERICALS/WHITE/MALE
numeric57
40
WHM6
6-CRAFT/WHITE/MALE
numeric0
41
WHM7
7-OPER/WHITE/MALE
numeric0
42
WHM8
8-LABORS/WHITE/MALE
numeric0
43
WHM9
9-Service/WHITE/MALE
numeric68
44
WHM10
10-TOTAL/WHITE/MALE
numeric31121
45
WHM11
11-PREVIOUS YEAR TOTAL/WHITE/MALE
numeric31135
46
BLKM1
1-Senior OFF AND MGRS/BLACK/MALE
numeric2
47
BLKM1_2
MID BLACK OFF AND MGRS
numeric172
48
BLKM2
2-PROF/BLACK/MALE
numeric273
49
BLKM3
3-TECH/BLACK/MALE
numeric1382
50
BLKM4
4-SALE/BLACK/MALE
numeric1937
51
BLKM5
5-CLERICALS/BLACK/MALE
numeric324
52
BLKM6
6-CRAFT/BLACK/MALE
numeric2
53
BLKM7
7-OPER/BLACK/MALE
numeric0
54
BLKM8
8-LABORS/BLACK/MALE
numeric0
55
BLKM9
9-Service/BLACK/MALE
numeric11
56
BLKM10
10-TOTAL/BLACK/MALE
numeric4103
57
BLKM11
11-PREVIOUS YEAR TOTAL/BLACK/MALE
numeric3821
58
NHOPIM1
1-Senior OFF AND MGRS/Hawaiia/MALE
numeric0
59
NHOPIM1_2
1.2-Mid OFF AND MGRS/Hawaiia/MALE
numeric12
60
NHOPIM2
2-PROF/Hawaiia/MALE
numeric34
61
NHOPIM3
3-TECH/Hawaiia/MALE
numeric68
62
NHOPIM4
4-SALEH/Hawaiia/MALE
numeric107
63
NHOPIM5
5-CLERICALS/Hawaiia/MALE
numeric25
64
NHOPIM6
6-CRAFT/Hawaiia/MALE
numeric0
65
NHOPIM7
7-OPER/Hawaiia/MALE
numeric0
66
NHOPIM8
8-LABORS/Hawaiia/MALE
numeric0
67
NHOPIM9
9-Service/Hawaiia/MALE
numeric4
68
NHOPIM10
10-TOTAL/Hawaiia/MALE
numeric250
69
NHOPIM11
11-PREVIOUS YEAR TOTAL/Hawaiia/MALE
numeric243
70
ASIANM1
1-Senior OFF AND MGRS/ASIAN/MALE/male
numeric10
71
ASIANM1_2
1.2-Mid OFF AND MGRS/ASIAN/MALE
numeric1389
72
ASIANM2
2-PROF/Asian/MALE
numeric6972
73
ASIANM3
3-TECH/ASIAN/MALE
numeric725
74
ASIANM4
4-SALE/ASIAN/MALE
numeric1031
75
ASIANM5
5-CLERICALS/ASIAN/MALE
numeric338
76
ASIANM6
6-CRAFT/ASIAN/MALE
numeric12
77
ASIANM7
7-OPER/ASIAN/MALE
numeric0
78
ASIANM8
8-LABORS/ASIAN/MALE
numeric0
79
ASIANM9
9-Service/ASIAN/MALE
numeric44
80
ASIANM10
10-TOTAL/ASIAN/MALE
numeric10521
81
ASIANM11
11-PREVIOUS YEAR TOTAL/ASIAN/MALE
numeric8751
82
AIANM1
1-Senior OFF AND MGRS/AM-INDIAN-ALK/MALE
numeric0
83
AIANM1_2
1.2-Mid OFF AND MGRS/AM-INDIAN-ALK/MALE
numeric13
84
AIANM2
2-PROF/AM-INDIAN-ALK/MALE
numeric32
85
AIANM3
3-TECH/AM-INDIAN-ALK/MALE
numeric73
86
AIANM4
4-SALE/AM-INDIAN-ALK/MALE
numeric48
87
AIANM5
5-CLERICALS/AM-INDIAN-ALK/MALE
numeric13
88
AIANM6
6-CRAFT/AM-INDIAN-ALK/MALE
numeric0
89
AIANM7
7-OPERT/AM-INDIAN-ALK/MALE
numeric0
90
AIANM8
8-LABORS/AM-INDIAN-ALK/MALE
numeric0
91
AIANM9
9-Service/AM-INDIAN-ALK/MALE
numeric1
92
AIANM10
10-TOTAL/AM-INDIAN-ALK/MALE
numeric180
93
AIANM11
11-PREVIOUS YEAR TOTAL/AM-INDIAN-ALK/MALE
numeric173
94
TOMRM1
1-Senior OFF AND MGRS/Two More Races/MALE
numeric0
95
TOMRM1_2
1.2-mid OFF AND MGRS/Two More Races/MALE
numeric55
96
TOMRM2
2-PROF/Two Races/MALE
numeric171
97
TOMRM3
3-TECH/Two Races/MALE
numeric284
98
TOMRM4
4-SALE/Two Races/MALE
numeric386
99
TOMRM5
5-CLERICALS/Two Races/MALE
numeric78
100
TOMRM6
6-CRAFT/Two Races/MALE
numeric0
Loading...
 
 
 
Sheet1