- query
- The company you submitted, echoed on every row so an export covering several employers stays separable.
- company
- The employer name as Indeed spells it on the company page.
- aggregate_rating
- The company's overall star rating - a number with one decimal, describing the employer rather than the review. It is the same value on every row of that company's export.
- review_count
- How many reviews Indeed holds for that employer in total. Also company-level and repeated on every row, and it is normally much larger than the number of rows you asked for. Read it as the size of the pool, not of your export.
- rating
- The reviewer's own star rating, a whole number from 1 to 5. This is the per-review score, and it arrives as a JSON number.
- title
- The short headline the reviewer gave the review.
- review
- The body of the review, as written. Lengths ranged from a couple of lines to several thousand characters across our rows, so budget for a long text column rather than a label.
- job_title
- The role the reviewer held. Optional on Indeed's form - populated on 32 of our 40 rows.
- location
- Where the reviewer worked, and reviewer-entered rather than normalised. Our 40 rows carried a mix of "City, ST", bare state names and lowercase free text. Treat it as a string to clean, never as a key. Populated on 29 of 40.
- date
- The review date, written the way Indeed displays it -
July 1, 2026 - not as an ISO date. Parse it before sorting. - current_employee
- A true/false flag for whether the reviewer still worked there when they wrote it. A real boolean, not a string.
- helpful
- How many readers marked the review helpful.
- unhelpful
- How many marked it unhelpful. Both counters arrive as numbers.
- comp_benefits_rating
- The reviewer's score for pay and benefits, 1 to 5 - one of five optional category ratings.
- culture_rating
- The reviewer's score for company culture.
- management_rating
- The reviewer's score for management.
- job_security_rating
- The reviewer's score for job security and advancement.
- worklife_rating
- The reviewer's score for work-life balance. These five behave as one block - see the note below - and unlike
rating they arrive as strings. - url
- The direct link to that review on Indeed.
- review_id
- Indeed's identifier for the review - a sixteen-character hex string. On every row we measured it was also the
?id= at the end of url, and all 40 were distinct. - status
- A per-row outcome flag from the export layer. It is not part of Indeed's data.