Name: Consumer Business Complaints In Brazil
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Consumer Business Complaints In Brazil

Context

When Brazilian consumers need to resolve a dispute with business the first step is to go to a local Procon (Consumer Protection Agency) and file a complaint. The Procon assists the consumer and intermediates the resolution with the company.

Content

This dataset contains information about complaints filed in Procons between 2012 and 2016. This data was download from official Brazilian government open data website

Tables

Reclamacoes Fundamentadas Sindec 2012

@kaggle.gerosa_procon.reclamacoes_fundamentadas_sindec_2012

10.56 MB
211,076 rows
23 columns

CREATE TABLE reclamacoes_fundamentadas_sindec_2012 (
  "anocalendario" BIGINT,
  "dataarquivamento" TIMESTAMP,
  "dataabertura" TIMESTAMP,
  "codigoregiao" BIGINT,
  "regiao" VARCHAR,
  "uf" VARCHAR,
  "strrazaosocial" VARCHAR,
  "strnomefantasia" VARCHAR,
  "tipo" BIGINT,
  "numerocnpj" DOUBLE,
  "radicalcnpj" DOUBLE,
  "razaosocialrfb" VARCHAR,
  "nomefantasiarfb" VARCHAR,
  "cnaeprincipal" DOUBLE,
  "desccnaeprincipal" VARCHAR,
  "atendida" VARCHAR,
  "codigoassunto" BIGINT,
  "descricaoassunto" VARCHAR,
  "codigoproblema" BIGINT,
  "descricaoproblema" VARCHAR,
  "sexoconsumidor" VARCHAR,
  "faixaetariaconsumidor" VARCHAR,
  "cepconsumidor" VARCHAR
);

Reclamacoes Fundamentadas Sindec 2013

@kaggle.gerosa_procon.reclamacoes_fundamentadas_sindec_2013

14.14 MB
268,096 rows
23 columns

CREATE TABLE reclamacoes_fundamentadas_sindec_2013 (
  "anocalendario" BIGINT,
  "dataarquivamento" TIMESTAMP,
  "dataabertura" TIMESTAMP,
  "codigoregiao" BIGINT,
  "regiao" VARCHAR,
  "uf" VARCHAR,
  "strrazaosocial" VARCHAR,
  "strnomefantasia" VARCHAR,
  "tipo" BIGINT,
  "numerocnpj" DOUBLE,
  "radicalcnpj" DOUBLE,
  "razaosocialrfb" VARCHAR,
  "nomefantasiarfb" VARCHAR,
  "cnaeprincipal" DOUBLE,
  "desccnaeprincipal" VARCHAR,
  "atendida" VARCHAR,
  "codigoassunto" BIGINT,
  "descricaoassunto" VARCHAR,
  "codigoproblema" BIGINT,
  "descricaoproblema" VARCHAR,
  "sexoconsumidor" VARCHAR,
  "faixaetariaconsumidor" VARCHAR,
  "cepconsumidor" VARCHAR
);

Reclamacoes Fundamentadas Sindec 2014

@kaggle.gerosa_procon.reclamacoes_fundamentadas_sindec_2014

12.71 MB
267,764 rows
23 columns

CREATE TABLE reclamacoes_fundamentadas_sindec_2014 (
  "anocalendario" BIGINT,
  "dataarquivamento" TIMESTAMP,
  "dataabertura" TIMESTAMP,
  "codigoregiao" BIGINT,
  "regiao" VARCHAR,
  "uf" VARCHAR,
  "strrazaosocial" VARCHAR,
  "strnomefantasia" VARCHAR,
  "tipo" BIGINT,
  "numerocnpj" DOUBLE,
  "radicalcnpj" DOUBLE,
  "razaosocialrfb" VARCHAR,
  "nomefantasiarfb" VARCHAR,
  "cnaeprincipal" DOUBLE,
  "desccnaeprincipal" VARCHAR,
  "atendida" VARCHAR,
  "codigoassunto" BIGINT,
  "descricaoassunto" VARCHAR,
  "codigoproblema" BIGINT,
  "descricaoproblema" VARCHAR,
  "sexoconsumidor" VARCHAR,
  "faixaetariaconsumidor" VARCHAR,
  "cepconsumidor" DOUBLE
);

Reclamacoes Fundamentadas Sindec 2015

@kaggle.gerosa_procon.reclamacoes_fundamentadas_sindec_2015

13.63 MB
255,650 rows
23 columns

CREATE TABLE reclamacoes_fundamentadas_sindec_2015 (
  "anocalendario" BIGINT,
  "dataarquivamento" TIMESTAMP,
  "dataabertura" TIMESTAMP,
  "codigoregiao" BIGINT,
  "regiao" VARCHAR,
  "uf" VARCHAR,
  "strrazaosocial" VARCHAR,
  "strnomefantasia" VARCHAR,
  "tipo" BIGINT,
  "numerocnpj" DOUBLE,
  "radicalcnpj" DOUBLE,
  "razaosocialrfb" VARCHAR,
  "nomefantasiarfb" VARCHAR,
  "cnaeprincipal" DOUBLE,
  "desccnaeprincipal" VARCHAR,
  "atendida" VARCHAR,
  "codigoassunto" BIGINT,
  "descricaoassunto" VARCHAR,
  "codigoproblema" DOUBLE,
  "descricaoproblema" VARCHAR,
  "sexoconsumidor" VARCHAR,
  "faixaetariaconsumidor" VARCHAR,
  "cepconsumidor" VARCHAR
);

Reclamacoes Fundamentadas Sindec 2016

@kaggle.gerosa_procon.reclamacoes_fundamentadas_sindec_2016

10.49 MB
203,486 rows
23 columns

CREATE TABLE reclamacoes_fundamentadas_sindec_2016 (
  "anocalendario" BIGINT,
  "dataarquivamento" TIMESTAMP,
  "dataabertura" TIMESTAMP,
  "codigoregiao" BIGINT,
  "regiao" VARCHAR,
  "uf" VARCHAR,
  "strrazaosocial" VARCHAR,
  "strnomefantasia" VARCHAR,
  "tipo" BIGINT,
  "numerocnpj" DOUBLE,
  "radicalcnpj" DOUBLE,
  "razaosocialrfb" VARCHAR,
  "nomefantasiarfb" VARCHAR,
  "cnaeprincipal" DOUBLE,
  "desccnaeprincipal" VARCHAR,
  "atendida" VARCHAR,
  "codigoassunto" BIGINT,
  "descricaoassunto" VARCHAR,
  "codigoproblema" DOUBLE,
  "descricaoproblema" VARCHAR,
  "sexoconsumidor" VARCHAR,
  "faixaetariaconsumidor" VARCHAR,
  "cepconsumidor" DOUBLE
);