Skip to content

Points Of Interest - Sentiment by Language

This CSV file relates to POI_Main_Listing file through the poi_id key field.

Field Description Type
poi_id primary key Unique POI identifier. STRING
date primary key The date of the analysis, based on the aggregated period chosen:
  • DAILY: the single day (ex. 2022-01-13).
  • WEEKLY: the first day of the week, starting from Monday (ex. 2022-01-10).
  • MONTHLY: the first day of the month (ex. 2022-01-01).
  • QUARTERLY: the first day of the quarter (ex. 2022-01-01).
 DATE
language primary key Text language. STRING
reviews Total number of online reviews retrieved during the period of analysis. INTEGER
sentiment Overall sentiment calculated over online content retrieved during the period of analysis.
Valid ranges: 0 (minimum) to 100 (maximum).		 DOUBLE

*The above fields in bold are considered the primary keys of the csv file.