Data Dictionary

Dictionary contains explanations and examples of all data fields available in the Glassdoor Companies dataset.

All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.

Data points by category

1. Metadata

2. Company profile details

3. Firmographics

4. Related posts

5. Ratings

The data points in the example snippets have been rearranged for better grouping. To see where a specific data point stands, check the full data sample here.

---

Metadata

Record metadata

Data point	Description	Data type
meta	Contains metadata about the record	Object
created_at_date	Date when the record was initially scraped	Array of numbers (integer)
created_at_timestamp	Unix timestamp for when the record was first scraped	Float
updated_at_date	Date when the record was last updated	Array of numbers (integer)
updated_at_timestamp	Unix timestamp for when the record was last updated	Float
version_id	Identifier for the dataset version	String
source	Source from which the record was obtained	String
object	Data object type	String
is_deleted	Indicates if the record is available on Glassdoor	Boolean

See a snippet of the dataset for reference:

Record metadata

"_meta": {
	"source": "glassdoor",
	"object": "company",
	"created_at_date": [
		2021,
		1,
		22
	],
	"created_at_timestamp": 1611290232.696056,
	"updated_at_date": [
		2024,
		11,
		1
	],
	"updated_at_timestamp": 1714561033.173981,
	"version_id": "28ff7dfe",
	"is_deleted": false

Profile metadata

Data point	Description	Data type
doc	Dataset starting point	Object
source_id	Record identifier on Glassdoor	String
main_source_id	Indicates the primary company profile when there are multiple profiles for different company branches	String
id	Record identifier in our database	String

See a snippet of the dataset for reference:

Meta information

"doc": {
      "source_id": "1144661",
      "main_source_id": "6036",
      "id": "glassdoor_company_1144661",

Company profile details

Data point	Description	Data type
url	Profile URL	String
image	Logo URL	String
description	Description Note: contains control characters	String
mission	Mission statement	String

See a snippet of the dataset for reference:

Company profile details

"url": "https://www.glassdoor.com.au/Overview/Working-at-example-company-EI_IE97866566655556416.htm?countryPickerRedirect=true",
"image": "https://media.glassdoor.com/sql/978416/example-company-squarelogo-1545395085457.png",
"description": "Example Company is a cutting-edge IT company specializing in innovative software development, cloud computing services, and cybersecurity solutions for businesses worldwide.",
"mission": "Our mission is to empower businesses with innovative and reliable IT solutions, driving growth and efficiency through technology.",

Firmographics

Data point	Description	Data type
location	Headquarters location	String
name	Name	String
type	Type	String
founded	Founding year	Integer
industry	Associated industry	String
employee_count	Size	String

See a snippet of the dataset for reference:

Company details

"location": "Indianapolis, IN",
"name": "Example Company",
"type": "Company - Public",
"founded": 2011,
"industry": "Security & Protective",
"employee_count": "1 to 50 Employees",

CEO

Data point	Description	Data type
ceo	Full name of the company's CEO	String
ceo_approval_count	Approval rate of the CEO	Float

See a snippet of the dataset for reference:

CEO

"ceo": "John Doe",
"ceo_approval_count": -1.0,

Revenue

Data point	Description	Data type
revenue	Revenue	String

See a snippet of the dataset for reference:

Revenue

"revenue": "$2 to $5 billion (USD)",

Website

Data point	Description	Data type
website	Website URL	String

See a snippet of the dataset for reference:

Social media presence

"website": "https://example-company.io",

Affiliated companies

Data point	Description	Data type
affiliated_companies	List of affiliated companies	Array of objects
url	Company profile URL	String
name	Company name	String
is_parent	Indicates if the company is a parent company	Boolean

See a snippet of the dataset for reference:

Affiliated companies

"affiliated_companies": [
    {
      "url": "https://www.glassdoor.com/Overview/Working-at-field-work-EI_IE444334.11,21.htm",
      "name": "Example Company",
      "is_parent": true
    },
    {
      "url": "https://www.glassdoor.com/Overview/Working-at-EI_IEddd35r434433ccc55818.htm",
      "name": "Other Company",
      "is_parent": false
    }
  ]

Related posts

Data point	Description	Data type
job_count	Number of active job postings	Integer
salary_count	Number of company salary posts	Integer
benefit_count	Number of employee comments/ratings on the company benefits	Integer
review_count	Number of employee reviews	Integer
interview_count	Number of employee comments on job interviews	Integer

See a snippet of the dataset for reference:

Related posts

"job_count": 239,
"salary_count": 716,
"benefit_count": 172,
"review_count": 568,
"interview_count": 93,

Ratings

Overall rating

Data point	Description	Data type
rating	Ratings on Glassdoor	Object
aggregated	Overall rating	Float

See a snippet of the dataset for reference:

Rating

"rating": {
          "aggregated": 3.8,
        },

Rating distribution

Data point	Description	Data type
star_distribution	Count of each star rating given in the reviews	Object
1 - 5	Number of reviews that gave one to five stars to the company	Integer
percentage_distribution	Percentage distribution of each star rating in the reviews	Object
1 - 5	Percentage distribution by the total number of stars given in the reviews	Float

See a snippet of the dataset for reference:

Stars

"star_distribution": {
            "1": 13,
            "2": 23,
            "3": 52,
            "4": 64,
            "5": 60
          },
          "percentage_distribution": {
            "1": 6.13,
            "2": 10.85,
            "3": 24.53,
            "4": 30.19,
            "5": 28.3
          }

Detailed ratings

Data point	Description	Data type
rating	Detailed ratings Note: optional ratings that might not be visible in the data.	Object
culture_values	Average rating for the company's culture and values	Float
career_opportunities	Average rating for the career opportunities in the company	Float
compensation_benefits	Average rating for the compensation and benefits in the company	Float
senior_management	Average rating for the company's senior management	Float
work_life_balance	Average rating for the work-life balance in the company	Float
diversity_inclusion	Average rating for diversity and inclusion in the company	Float
biz_outlook	Percentage of employee reviews indicating a positive business outlook	Float
ceo	Percentage of employee reviews that approve of CEO	Float
recommend	Percentage of employee reviews that recommend to a friend	Float

See a snippet of the dataset for reference:

Detailed rating

"rating": {
        "culture_values": 3.9,
        "career_opportunities": 3.7,
        "compensation_benefits": 3.5,
        "senior_management": 3.3,
        "work_life_balance": 3.6,
        "diversity_inclusion": 3.9,
        "biz_outlook": 61,
        "ceo": 87.0,
        "recommend": 73
            }