Data Dictionary

dictionary contains explanations and examples of all data fields available in the glassdoor reviews 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 reviews data dictionary#qh8rn review details https //docs coresignal com/source documentation/glassdoor reviews data dictionary#3gnrl ratings https //docs coresignal com/source documentation/glassdoor reviews data dictionary#kxar7 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 reviews 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 meta fields " meta" { 	 "source" "glassdoor", 	 "object" "review", 	 "created at date" \[ 	 2021, 	 7, 	 29 	 ], 	 "created at timestamp" 1627576114 978239, 	 "updated at date" \[ 	 2024, 	 5, 	 1 	 ], 	 "updated at timestamp" 1714587034 936207, 	 "version id" "454126bb", 	 "is deleted" false 	 }, review metadata data point description data type doc d ataset starting point o bject language review language string company id company identifier in our database string source id record identifier on glassdoor string date review publish date in iso 8601 format string id record identifier in our database string see a snippet of the dataset for reference review meta information "doc" { "language" "eng", "company id" "1116468", "source id" "itz rvw54008356", "date" "2022 05 31t20 54 36 170", "id" "glassdoor review microsoft rvw64931797", review details review author data point description data type author location author's location s tring author title author's job title s tring author status author's employment status s tring is current indicates whether the review author is currently employed by the company b oolean author employment length author's employment length in years the field is optional integer see a snippet of the dataset for reference review author "doc" { "author location" "los angeles, ca", "author title" "sales specialist", "author status" "regular", "is current" true, "author employment length" 2, review content data point description data type summary summarized review content s tring cons disadvantages of working in the company s tring pros advantages of working in the company s tring advice to management advice to the management s tring see a snippet of the dataset for reference review summary "summary" "vey stressed", "cons" "middling pay for very experienced", "pros" "culture, management cares about employees", "cons" "middling pay for very experienced", "advice to management" "maybe add a float manager that can help new managers learn and get caught up so you don\u2019t feel like you are sinking under paperwork while you are learning ", ratings general r atings data point description data type recommend main rating categories the user can mark in their review o bject rating ceo ceo rating (approve/disapprove) s tring rating business outlook business outlook rating (positive/negative) s tring rating recommend to friend indicates if the reviewer would recommend the company as a workplace to a friend s tring see a snippet of the dataset for reference approval of the company "recommend" { 	"rating ceo" "no opinion", 	"rating business outlook" "neutral", 	"rating recommend to friend" "positive" }, star ratings data point description data type star rating various ratings on different aspects provided by glassdoor (ranging from one to five stars) o bject overall overall rating of the company integer/float culture values rating for the company's culture and values integer/float career opportunities rating for the career opportunities in the company integer/float compensation benefits rating for the compensation and benefits in the company integer/float senior management rating for the company's senior management integer/float work life balance rating for the work life balance in the company integer/float diversity inclusion rating for diversity inclusion in the company integer/float see a snippet of the dataset for reference star ratings "star rating" { "overall" 5, "culture values" 5, "career opportunities" 5, "compensation benefits" 4, "senior management" 4, "work life balance" 2, "diversity inclusion" 5 },