Dataset: Consumer Business Complaints In Brazil

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.07 MB
211076 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

13.49 MB
268096 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.12 MB
267764 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 MB
255650 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 MB
203486 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
);