Review ID Unique identifier for the review | | Field ID | id | | Type | NUMBER | | Data Type | dimension |
|
Review URL Link to the original review on Glassdoor | | Field ID | url | | Type | URL | | Data Type | dimension |
|
Rating Star rating given in the review | | Field ID | rating | | Type | NUMBER | | Data Type | metric |
|
Review Title Title of the review | | Field ID | title | | Type | TEXT | | Data Type | dimension |
|
Pros Positive aspects mentioned in the review | | Field ID | pros | | Type | TEXT | | Data Type | dimension |
|
Cons Negative aspects mentioned in the review | | Field ID | cons | | Type | TEXT | | Data Type | dimension |
|
Advice Advice given by the reviewer, if available | | Field ID | advice | | Type | TEXT | | Data Type | dimension |
|
Reviewer Position Job position of the reviewer | | Field ID | reviewer | | Type | TEXT | | Data Type | dimension |
|
Review Date Date when the review was posted | | Field ID | datetime | | Type | YEAR_MONTH_DAY_HOUR | | Data Type | dimension |
|
Language Language of the review | | Field ID | language | | Type | TEXT | | Data Type | dimension |
|
Is Current Job Indicates if the reviewer is currently employed at the company | | Field ID | is_current_job | | Type | BOOLEAN | | Data Type | dimension |
|
Review Count Total number of reviews for the company | | Field ID | review_count | | Type | NUMBER | | Data Type | metric |
|
Filtered Reviews Count Number of reviews filtered by Glassdoor | | Field ID | filtered_reviews_count | | Type | NUMBER | | Data Type | metric |
|
Overall Rating Overall rating across all reviews | | Field ID | overall_rating | | Type | NUMBER | | Data Type | metric |
|
Culture and Values Rating Rating for culture and values | | Field ID | culture_and_values_rating | | Type | NUMBER | | Data Type | metric |
|
Diversity and Inclusion Rating Rating for diversity and inclusion | | Field ID | diversity_and_inclusion_rating | | Type | NUMBER | | Data Type | metric |
|
Work-Life Balance Rating Rating for work-life balance | | Field ID | work_life_balance_rating | | Type | NUMBER | | Data Type | metric |
|
Senior Management Rating Rating for senior management | | Field ID | senior_management_rating | | Type | NUMBER | | Data Type | metric |
|
Compensation and Benefits Rating Rating for compensation and benefits | | Field ID | compensation_and_benefits_rating | | Type | NUMBER | | Data Type | metric |
|
Career Opportunities Rating Rating for career opportunities | | Field ID | career_opportunities_rating | | Type | NUMBER | | Data Type | metric |
|
CEO Rating Percentage rating for the CEO | | Field ID | ceo_rating | | Type | PERCENT | | Data Type | metric |
|
Business Outlook Rating Percentage rating for business outlook | | Field ID | business_outlook_rating | | Type | PERCENT | | Data Type | metric |
|
Recommend to Friend Rating Percentage of employees recommending the company | | Field ID | recommend_to_friend_rating | | Type | PERCENT | | Data Type | metric |
|
Year Year such as 2017. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR | | Type | YEAR | | Data Type | dimension |
|
Year Quarter Year and quarter. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_QUARTER | | Type | YEAR_QUARTER | | Data Type | dimension |
|
Year month Year and month. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH | | Type | YEAR_MONTH | | Data Type | dimension |
|
Year week Year and week. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_WEEK | | Type | YEAR_WEEK | | Data Type | dimension |
|
Quarter of the year Quarter of the year | | Field ID | _NORMALIZED_DATE_FIELD_QUARTER | | Type | QUARTER | | Data Type | dimension |
|
Month of the year Month of the year | | Field ID | _NORMALIZED_DATE_FIELD_MONTH | | Type | MONTH | | Data Type | dimension |
|
Week of the year Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK | | Type | WEEK | | Data Type | dimension |
|
Month and day Month and day | | Field ID | _NORMALIZED_DATE_FIELD_MONTH_DAY | | Type | MONTH_DAY | | Data Type | dimension |
|
Date and Hour Month and day | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR | | Type | YEAR_MONTH_DAY_HOUR | | Data Type | dimension |
|
Date Year month day data | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Day of the week Day of the week | | Field ID | _NORMALIZED_DATE_FIELD_DAY_OF_WEEK | | Type | DAY_OF_WEEK | | Data Type | dimension |
|
Day of the year Day of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY | | Type | DAY | | Data Type | dimension |
|
Extracted Date The date where the extraction take times. | | Field ID | _catchr_date_extract | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Platform Name Return the platform name | | Field ID | _catchr_platform_name | | Type | TEXT | | Data Type | dimension |
|
.svg){kind=logo}