Data Dictionary

10min

Contains explanations and examples of all data fields available in the Trustpilot Reviews dataset.
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
Data points by category 
﻿Metadata﻿
﻿Firmographics﻿
﻿Review details ﻿
﻿Review author details﻿
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.
﻿
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
created_at_timestamp
Unix timestamp for when the record was first scraped
Number
updated_at_date
Date when the record was last updated
Array of numbers
updated_at_timestamp
Unix timestamp for when the record was last updated
Number
version_id
Identifier for the dataset version
String
source
Source from which the record was obtained
String
object
Type of data object or entity described
String
is_deleted
Indicates if the record is available on Trustpilot
Boolean
See a snippet of the dataset for reference:
Metadata
		"_meta": {
			"created_at_date": [
				2024,
				2,
				6
			],
			"created_at_timestamp": 1707234484.291793,
			"updated_at_date": [
				2024,
				5,
				1
			],
			"updated_at_timestamp": 1714551911.316352,
			"version_id": "436a2eff",
			"source": "trustpilot",
			"object": "review",
			"is_deleted": false
		},
		"_meta": {
			"created_at_date": [
				2024,
				2,
				6
			],
			"created_at_timestamp": 1707234484.291793,
			"updated_at_date": [
				2024,
				5,
				1
			],
			"updated_at_timestamp": 1714551911.316352,
			"version_id": "436a2eff",
			"source": "trustpilot",
			"object": "review",
			"is_deleted": false
		},
﻿
Review metadata
Data point
Description
Data type
id
Review identifier assigned by Coresignal
String
source_id
Review identifier assigned by Trustpilot
String
See a snippet of the dataset for reference:
Review metadata
    "id": "trustpilot_review_634dd33bc7b6784ddff0c2ab2caf93",
    "source_id": "634dd33bc7b6784ddff0c2ab2caf93",
    "id": "trustpilot_review_634dd33bc7b6784ddff0c2ab2caf93",
    "source_id": "634dd33bc7b6784ddff0c2ab2caf93",
﻿
Firmographics
Data point
Description
Data type
company_id
Company identifier assigned by Coresignal
String
company_source_id
Company identifier assigned by Trustpilot
String
company_url
Company review URL 
String
See a snippet of the dataset for reference:
Firmographics
"company_id": "trustpilot_company_example-company",
"company_source_id": "example-company",
"company_url": "https://www.trustpilot.com/review/example-company",
"company_id": "trustpilot_company_example-company",
"company_source_id": "example-company",
"company_url": "https://www.trustpilot.com/review/example-company",
﻿
Review details
Data point
Description
Data type
overall
Star rating in the review  
Float
date
Date the review was posted in ISO 8601format
String (date)
title
Review title
String
review_body
Review content
String
See a snippet of the dataset for reference:
Review
"overall": 2,
"date": "2023-02-05T10:19:48.000Z",
"title": "Postage cists",
"review_body": "The charges and arrangements for posting and returns are too costly",
"overall": 2,
"date": "2023-02-05T10:19:48.000Z",
"title": "Postage cists",
"review_body": "The charges and arrangements for posting and returns are too costly",
﻿
Review author details 
Data point
Description
Data type
author
Review author details
Object
name
Author's name
String
location
Author's location
String
review_count
Total review count by the author
Integer
url
Author's Trustpilot profile URL
String
See a snippet of the dataset for reference:
Author
"author": {
			"name": "John Doe",
			"location": "GB",
			"review_count": 5,
			"url": "https://www.trustpilot.com/users/589c51930000ff000a75909efffffff"
			}
"author": {
			"name": "John Doe",
			"location": "GB",
			"review_count": 5,
			"url": "https://www.trustpilot.com/users/589c51930000ff000a75909efffffff"
			}
﻿
﻿

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
created_at_timestamp	Unix timestamp for when the record was first scraped	Number
updated_at_date	Date when the record was last updated	Array of numbers
updated_at_timestamp	Unix timestamp for when the record was last updated	Number
version_id	Identifier for the dataset version	String
source	Source from which the record was obtained	String
object	Type of data object or entity described	String
is_deleted	Indicates if the record is available on Trustpilot	Boolean

Data point	Description	Data type
id	Review identifier assigned by Coresignal	String
source_id	Review identifier assigned by Trustpilot	String

Data point	Description	Data type
company_id	Company identifier assigned by Coresignal	String
company_source_id	Company identifier assigned by Trustpilot	String
company_url	Company review URL	String

Data point	Description	Data type
overall	Star rating in the review	Float
date	Date the review was posted in ISO 8601format	String (date)
title	Review title	String
review_body	Review content	String

Data point	Description	Data type
author	Review author details	Object
name	Author's name	String
location	Author's location	String
review_count	Total review count by the author	Integer
url	Author's Trustpilot profile URL	String

Updated 01 Jul 2024

Did this page help you?

Trustpilot Reviews

Data Sample