Correios Reviews

Reviews from Brazilian Post Office (Correios)

@kaggle.arthurrj_correios_reviews

About this Dataset

Correios Reviews

Dataset containing reviews of post offices in Rio de Janeiro, extracted from Google Maps.

Contains 186 agencies distributed among AC (owned agencies), AGF (franchised agencies), and CDD (distribution centers) in the metropolitan region of the state, covering 92% of the agencies in the city of Rio de Janeiro;
30,173 reviews by users through Google Maps, up to 04/20/2023;
Among these evaluations, there are 2,032 reviews texts written by the users themselves;
28,520 unique users evaluating the Rio de Janeiro Post Office.

Tables

Reviews

@kaggle.arthurrj_correios_reviews.reviews

1.84 MB
30028 rows
6 columns


CREATE TABLE reviews (
  "po_id" VARCHAR,
  "user_id" VARCHAR,
  "rating" BIGINT,
  "review_text" VARCHAR,
  "review_dt" TIMESTAMP,
  "review_id" VARCHAR
);

Users

@kaggle.arthurrj_correios_reviews.users

757.54 KB
28520 rows
5 columns


CREATE TABLE users (
  "user" VARCHAR,
  "user_id" VARCHAR,
  "is_local_guide" BIGINT,
  "user_comments" DOUBLE,
  "user_photos" DOUBLE
);

Post Offices

@kaggle.arthurrj_correios_reviews.post_offices

31.08 KB
186 rows
11 columns


CREATE TABLE post_offices (
  "id" VARCHAR,
  "name" VARCHAR,
  "original_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "stars" DOUBLE,
  "reviews" BIGINT,
  "opening_hours" VARCHAR,
  "waiting_time" VARCHAR,
  "category" VARCHAR,
  "short_address" VARCHAR
);

Share link

Anyone who has the link will be able to view this.