Diversity Data Builder1.1

This tool will help you create or update a CSV file following the Diversity Data Standard for Diversity Dashboards. CSV files following the standard will consist of rows per entry. Each entry is a set of values for a specific date and organisation name/grouping/level. Use the menu at the top right to load/save a file. Use the "Entry editor" to add, update, or delete entries. Note that if you open/save a file in Excel, that software is very likely to change the date format into a different one (exactly what will depend on your settings). If your dates are not saved as YYYY-MM-DD you can use our CSVCleaner tool to help fix them.

Data preview

No data to show.

Entry editor

Metadata

published

The date associated with the entry. This should be in ISO 8601 format as recommended by GDS. This reduces ambiguity in parsing dates and gives flexibility with time precision. It can be reported as just a year (e.g. '2021'), a month (e.g. '2021-01'), or a full date (e.g. '2021-01-26'). This allows an organisation to publish figures as frequently as they need to.

Format: Must by an ISO 8601 date.

organisation

The name of the organisation.

organisation_grouping

This allows you to breakdown the data by a sub-division, area, or group within the organisation.

organisation_level

This allows you to breakdown the data by a particular salary percentile e.g. 'LowerQuartile', 'LowerMiddleQuartile', 'UpperMiddleQuartile', 'TopQuartile'

employees

A number representing the total number of employees.

link_to_dei_info

A link to a diversity and inclusion policy (similar to the CompanyLinkToGPGInfo field provided in gender pay gap reporting)

Format: Must be a valid URL

sic_codes

Semi-colon-separated list of SIC codes as used by Companies House.

Format: Must be valid SIC codes separated by semi-colons

Back to top

Age

This section is about age. It is optional as are each of the columns. These were based on an attempt to find common age brackets from the existing employers who had shared data. The ONS use 5-year bands which match with these (mostly) 10 year bands. In under 25s the ONS use 15-17, and 18-24 but none of the existing employers report under 16s.

age_0-14

The number of employees aged from 0-14 inclusive ie. not yet 15.

age_15-24

The number of employees aged from 15 to 24 inclusive ie. not yet 25.

age_25-34

The number of employees aged from 25 to 34 inclusive ie. not yet 35.

age_35-44

The number of employees aged from 35 to 44 inclusive ie. not yet 45.

age_45-54

The number of employees aged from 45 to 54 inclusive ie. not yet 55.

age_55-64

The number of employees aged from 55 to 64 inclusive ie. not yet 65.

age_65-69

The number of employees aged from 65 to 69 inclusive ie. not yet 70.

age_70+

The number of employees aged 70 or over.

age_prefernottosay

For consistency across categories this can be provided if needed.

age_undisclosed

The number of employees for whom no age is known. This allows us to calculate “response” rates. Assumed to be 0 if not included.

age_total

The total number of people this category applies to. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

Back to top

Carers

This section is about those who are carers for others. It is optional as are each of the columns. These options are based on question 14 of the 2011 Census (which is a super-set of question 24 of the 2021 Census).

carer_yes

The total number of people who look after, or give any help or support to, anyone because they have long-term physical or mental health conditions or illnesses, or problems related to old age (see Q24 Census 2021 Individual).

carer_yes_1-19

Yes, 1-19 hours a week (the sum of 1-9 and 10-19 in the 2021 Census). This field is provided to give a breakdown of carer_yes if you have the data.

carer_yes_20-49

Yes, 20 - 49 hours a week (the sum of 20-34 and 35-49 in the 2021 Census). This field is provided to give a breakdown of carer_yes if you have the data.

carer_yes_50

Yes, 50 or more hours a week. This field is provided to give a breakdown of carer_yes if you have the data.

carer_no

Those who are not a carer

carer_prefernottosay

The number of people who prefer not to say

carer_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

carer_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

Back to top

Disability

This section is about disability. It is optional as are each of the columns. These mostly come from the categories that Yorkshire Water currently publish which are aligned with the Equality Act disability definition answers to Q1 and Q3 of the ONS's Opinion and Lifestyle Survey (OPD). GSS guidance.

disability_yes

The total number of people who have a long-term health problem or disability. In the ONS OPD Q1 is “Do you have any physical or mental health conditions or illnesses?” Answers: yes/no.

disability_yes_daytodayalot

The number of people whose day-to-day activities are limited a lot. This allows a breakdown within the category of disability_yes if known. In the ONS OPD Q3 is “Do any of your illnesses or conditions reduce your ability to carry out day to day activities?” Answer: yes a lot. Make sure to also include this value in the group total (disability_yes).

disability_yes_daytodayalittle

The number of people whose day-to-day activities are limited a little. This allows a breakdown within the category of disability_yes if known. In the ONS OPD Q3 is “Do any of your illnesses or conditions reduce your ability to carry out day to day activities?” Answer: yes a little. Make sure to also include this value in the group total (disability_yes).

disability_no

The number of people with no disability.

disability_prefernottosay

The number of people who prefer not to say

disability_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

disability_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

Back to top

Ethnicity

This section is about ethnicity. It is optional as are each of the columns. These come from ONS Census categories so are very UK-centric.

ethnicity_asian

The Census group “Asian/Asian British”. This should be the total for this entire census group. You can also provide the breakdown by sub-group where you have it.

ethnicity_asian_bangladeshi

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Bangladeshi”. Make sure to also include this value in the group total for ethnicity_asian.

ethnicity_asian_chinese

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Chinese”. Make sure to also include this value in the group total for ethnicity_asian.

ethnicity_asian_indian

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Indian”. Make sure to also include this value in the group total for ethnicity_asian.

ethnicity_asian_pakistani

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Pakistani”. Make sure to also include this value in the group total for ethnicity_asian.

ethnicity_asian_other

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Other”. Make sure to also include this value in the group total for ethnicity_asian.

ethnicity_black

The Census group “Black, African, Caribbean or Black British”. This should be the total for this entire census group. You can also provide the breakdown by sub-group where you have it.

ethnicity_black_african

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “African”. Make sure to also include this value in the group total for ethnicity_black.

ethnicity_black_caribbean

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Caribbean”. Make sure to also include this value in the group total for ethnicity_black.

ethnicity_black_other

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Any other Black, African or Caribbean background”. Make sure to also include this value in the group total for ethnicity_black.

ethnicity_mixed

The Census group “Mixed or Multiple ethnic groups”. This should be the total for this entire census group. You can also provide the breakdown by sub-group where you have it.

ethnicity_mixed_african

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “White and Black African”. Make sure to also include this value in the group total for ethnicity_mixed.

ethnicity_mixed_asian

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “White and Asian”. Make sure to also include this value in the group total for ethnicity_mixed.

ethnicity_mixed_caribbean

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “White and Black Caribbean”. Make sure to also include this value in the group total for ethnicity_mixed.

ethnicity_mixed_other

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Any other Mixed or Multiple ethnic background”. Make sure to also include this value in the group total for ethnicity_mixed.

ethnicity_other

The Census group “Other ethnic group”. This should be the total for this entire census group. You can also provide the breakdown by sub-group where you have it.

ethnicity_other_arab

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Arab”. Make sure to also include this value in the group total for ethnicity_other.

ethnicity_other_anyother

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Any other ethnic group”. Make sure to also include this value in the group total for ethnicity_other.

ethnicity_white

The Census group “White”. This should be the total for this entire census group. You can also provide the breakdown by sub-group where you have it.

ethnicity_white_british

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “English, Welsh, Scottish, Northern Irish or British”. Make sure to also include this value in the group total for ethnicity_white.

ethnicity_white_irish

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Irish”. Make sure to also include this value in the group total for ethnicity_white.

ethnicity_white_traveller

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Gypsy or Irish Traveller”. Make sure to also include this value in the group total for ethnicity_white.

ethnicity_white_other

Not required. Allows some organisations to provide more detailed breakdown if they wish and are able to. The Census group of “Any other White background”. Make sure to also include this value in the group total for ethnicity_white.

ethnicity_prefernottosay

The number of people who prefer not to say

ethnicity_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

ethnicity_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

Back to top

Gender

This section is about sex and gender identity. It is optional as are each of the columns. These are based on what some existing employers currently report.

gender_female

The number of employees who are female (including trans).

gender_male

The number of employees who are male (including trans).

gender_other

Diverse and other genders including non-binary.

gender_prefernottosay

The number of people who prefer not to say

gender_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

gender_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

Back to top

Gender identity

This section is about gender identity. It is optional as are each of the columns.

genderidentitymatchesthatassignedatbirth_no

The number of employees whose gender identity doesn’t match that assigned at birth.

genderidentitymatchesthatassignedatbirth_yes

The number of employees whose gender identity matches that assigned at birth.

genderidentitymatchesthatassignedatbirth_prefernottosay

The number of people who prefer not to say.

genderidentitymatchesthatassignedatbirth_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

genderidentitymatchesthatassignedatbirth_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

Back to top

Religion

This section is about religion. It is optional as are each of the columns. These are based on the categories used by the ONS in the 2021 Census. The sum of individual responses may add up to more than the total number of people.

religion_buddhist

The number of employees who are Buddhist

religion_christian

The number of employees who are Christian. Christian includes Church of England, Catholic, Protestant and all other Christian denominations.

religion_hindu

The number of employees who are Hindu

religion_jewish

The number of employees who are Jewish

religion_muslim

The number of employees who are Muslim

religion_no

The number of employees who are “No Religion”

religion_other

The number of employees who are any other religions not otherwise listed.

religion_sikh

The number of employees who are “Sikh”

religion_prefernottosay

The number of people who prefer not to say

religion_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

religion_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

Back to top

Sexuality

This section is about sexuality. It is optional as are each of the columns. These are based on guidance from the Government Statistical Service (17 April 2019) and similar to the 2021 Census but using language from the Australian Bureau of Statistics (GSS are drawing on ABS’s approach soon).

sexuality_bisexual

The number of employees who are bisexual

sexuality_gaylesbian

The number of employees who are gay or lesbian

sexuality_straight

The number of employees who are heterosexual/straight

sexuality_usedifferentterm

The number of employees who would use a different term - this may be done in the form of a write-in box.

sexuality_prefernottosay

The number of people who prefer not to say

sexuality_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

sexuality_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

Back to top

Socio-economic background

This section is about socio-economic background (SEB). Measuring or estimating socio-economic background is hard including when you ask people to self-identify. All measures are going to be proxies to a complicated question. We have chosen to use the four questions used by The Social Mobility Commission toolkit.

seb_at14

The Social Mobility Commission toolkit suggests this is a key question employers could ask because:

“[T]his question is the best measure to assess someone’s socio-economic background. Not only that but it’s easy to understand, it gets the highest response rates in testing, and it’s applicable to those from all ages and from all countries.”

seb_at14_lower

The number of employees who, at about 14, had their main household earner from a lower socio-economic background – technical and craft occupations; routine, semi-routine manual and service occupations; long-term unemployed.

seb_at14_intermediate

The number of employees who, at about 14, had their main household earner from an intermediate background – clerical and intermediate occupations; small business owners

seb_at14_professional

The number of employees who, at about 14, had their main household earner from a professional background – modern professional & traditional occupations; senior or junior managers or administrators.

seb_at14_prefernottosay

The number of people who prefer not to say

seb_at14_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

seb_at14_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

seb_school

seb_school_independent

The number of employees who attended an Independent or fee-paying school

seb_school_independent+bursary

The number of employees who attended an Independent or fee-paying school, where they received a means tested bursary covering 90% or more of the total cost of attending throughout their time there.

seb_school_outsideuk

The number of employees who attended a school outside the UK

seb_school_staterun

The number of employees who attended a state-run or state-funded school

seb_school_prefernottosay

The number of people who prefer not to say

seb_school_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

seb_school_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

seb_fsm

seb_fsm_no

The number of employees who didn’t receive free school meals at any point during their school years.

seb_fsm_notapplicable

The number of employees who to whom this doesn’t apply because finished school before 1980 or went to school overseas.

seb_fsm_yes

The number of employees who received free school meals at any point during their school years.

seb_fsm_prefernottosay

The number of people who prefer not to say

seb_fsm_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

seb_fsm_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

seb_parentuni

Surveys such as the Longitudinal Survey of Young People in England answer questions such as “are you first in your family to go to university” but this isn’t open data so comparisons at geographies such as “Leeds City Region” won’t be possible. The UK Data Service estimates 15% of those born in 1990 were first-in-family to attend university.

seb_parentuni_no

The number of employees for whom neither parent attended university.

seb_parentuni_notsure

The number of employees who are unsure if their parents attended university.

seb_parentuni_yes

The number of employees who had at least one parent attend university.

seb_parentuni_prefernottosay

The number of people who prefer not to say

seb_parentuni_undisclosed

The number of employees who were not asked or who didn’t respond actively. This allows us to calculate 'response' rates. Assumed to be 0 if not included.

seb_parentuni_total

The total number of people. If not provided it will be assumed to be the same as employees. If it is the same as employees it can be omitted.

Back to top