Skip to content

Location - Sentiment and Footfall by Language

Field Description Type
geometry_id primary key Geometry unique identifier. STRING
geometry WKT format. 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.