Firmographic Data Dictionary
Contains explanations and examples for all data fields available in the Trustpilot Companies dataset.
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
Data points in the example snippets are rearranged for better grouping. To see where a specific data point stands, check the full data sample below:
Data point | Description | Data type |
meta | Contains information about the record | Object |
created_at_date | The date when we first scraped the record | Array of numbers |
created_at_timestamp | The date we first scraped the record (Unix time) | Float |
updated_at_date | The date when we last scraped the record | Array of numbers |
updated_at_timestamp | The date when we last scraped the record (Unix time) | Float |
version_id | Dataset version ID | String |
source | The record source | String |
object | The data object/entity | String |
is_deleted | Marks if the company profile is available Trustpilot | Boolean |
See a snippet of the dataset for reference:
Data point | Description | Data type |
id | Record identifier assigned by Coresignal | String |
source_id | Record identifier on Trustpilot | String |
url | Trustpilot review page of the record company | String |
See a snippet of the dataset for reference:
Data point | Description | Data point |
name | Company name | String |
location | Company location | String |
website | Company's website URL | String |
contact_info | Publicly available company contact address | Object |
Publicly available company email | String | |
image | Company logo URL | String |
category | Company category | Array |
category_tree | Other categories assigned to the company profile | Object |
category_tier_1 | Top-level category of the company | String |
category_tier_2 | Second-level category of the company | String |
category_tier_3 | Third-level category of the company | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
review_rating | Detailed information on reviews visible on the company's Trustpilot page | Object |
1 | Number of 1-star ratings | Integer |
2 | Number of 2-star ratings | Integer |
3 | Number of 3-star ratings | Integer |
4 | Number of 4-star ratings | Integer |
5 | Number of 5-star ratings | Integer |
count | Total number of reviews | Integer |
overall | Overall rating based on reviews | Float |
total_reviews_past_12_months | Total number of reviews in the past 12 months | Integer |
See a snippet of the dataset for reference:
Data type | Description | Data type |
review_source | Number of reviews from different sources | Object |
organic | Number of organic reviews | Integer |
automatic_invitations | Number of reviews from automatic invitations | Integer |
manual_invitations | Number of reviews from manual invitations | Integer |
redirected | Number of redirected reviews | Integer |
See a snippet of the dataset for reference:
Data type | Description | Data type |
organic_reviews_over_time | Number of organic reviews over time (up to the update month). These are written without using Trustpilot-supported invitation methods | Array of objects |
date | Review date | String (date) |
count | Review count | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
automated_invitations_reviews_over_time | Number of reviews from invitations over time (up to the update month). These are written without using Trustpilot-supported automatic invitation methods. | Array of objects |
date | Review date | String (date) |
count | Review count | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
manual_invitations_reviews_over_time | Number of reviews from invitations over time (up to the update month). | Array of objects |
date | Review date | String (date) |
count | Review count | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
redirected_reviews_over_time | Number of reviews written from the business page to Trustpilot redirects (up to the updated month). | Array of objects |
date | Review date | String (date) |
count | Review count | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
new_reviews_by_rating | The counts of dates of reviews based on the star count (from one to five stars) | Object |
1 | The count and dates of one-star reviews | Array of objects |
date | Review date | String (date) |
count | Review number | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
new_reviews_by_rating | The counts of dates of reviews based on the star count (from one to five stars) | Object |
2 | The count and dates of two-star reviews | Array of objects |
date | Review date | String (date) |
count | Review number | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
new_reviews_by_rating | The counts of dates of reviews based on the star count (from one to five stars) | Object |
3 | The count and dates of three-star reviews | Array of objects |
date | Review date | String (date) |
count | Review number | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
new_reviews_by_rating | The counts of dates of reviews based on the star count (from one to five stars) | Object |
4 | The count and dates of four-star reviews | Array of objects |
date | Review date | String (date) |
count | Review number | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
new_reviews_by_rating | The counts of dates of reviews based on the star count (from one to five stars) | Object |
5 | The count and dates of five-star reviews | Array of objects |
date | Review date | String (date) |
count | Review number | Integer |
See a snippet of the dataset for reference: