Skip to content

Location - Sentiment by Cluster

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
cluster primary key Analysis Cluster Name (Food, Location, Hospitality, etc.). 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.