Skip to content

Points Of Interest - Topics

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).
cluster primary key Analysis Cluster Name (Food, Location, Hospitality, etc.). STRING
topic primary key Subject of analysis identified in the text. STRING
polarity primary key Polarity of the opinion expressed (negative, positive or neutral).
It can take the value + or - or =
language primary key Language of the topic/judgment (opinion) identified. STRING
opinions_count Number of occurrences. INTEGER

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