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 metadata https //docs coresignal com/source documentation/glassdoor companies data dictionary#36g25 company profile details https //docs coresignal com/source documentation/glassdoor companies data dictionary#zo4ws firmographics https //docs coresignal com/source documentation/glassdoor companies data dictionary#djee5 related posts https //docs coresignal com/source documentation/glassdoor companies data dictionary#kkw 2 ratings https //docs coresignal com/source documentation/glassdoor companies data dictionary#qxfxh 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 https //docs coresignal com/source documentation/glassdoor companies data sample 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 o bject source id record identifier on glassdoor s tring main source id indicates the primary company profile when there are multiple profiles for different company branches string id record identifier in our database s tring 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 l ogo 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 s tring name name s tring type type s tring founded founding year integer industry associated industry s tring employee count size s tring 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 s tring 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 s tring 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 n umber of active job postings integer salary count number of company salary posts integer benefit count nu mber of employee comments/ratings on the company benefits integer review count n umber 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 o bject 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 o bject 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 o bject 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 }