Clube do Ingresso Database
Aug 2019
Domain:
clubedoingresso.com
Breach Count:
85,377
Region:
Global
News Report:
-
Leak from:
File Size:
56.90 MB
Uncompressed File Size:
4.55 GB
File Count:
2
In August 2019, the Brazilian events platform Clube do Ingresso suffered a data breach that impacted 85.3k users. The breach led to the exposure of data including Full names, Genders, Dates of birth, Email addresses, CPF Numbers, Locations and Passwords stored as MD5 hashes.
Leaked Information:
Full Name
Email
Phone
Identity Number
Address
Date Of Birth
We have loaded this breach into our database.
File List:
clientes.sql
clube2-database-c3yh17uk0eov-us-east-1-rds-amazonaws-com.sql
File Content Sample:
DROP TABLE IF EXISTS `clientes`;
CREATE TABLE `clientes` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`conta_id` int(11) DEFAULT '1',
`usuario_id` int(11) DEFAULT '1',
`cliente_id` varchar(100) DEFAULT '1',
`avatar` varchar(255) DEFAULT NULL,
`nome` varchar(255) DEFAULT NULL,
`sexo` varchar(255) DEFAULT NULL,
`data_de_nascimento` date DEFAULT NULL,
`celular` varchar(35) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`estado` varchar(2) DEFAULT NULL,
`cidade` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`senha` varchar(255) DEFAULT NULL,
`rg` varchar(255) DEFAULT NULL,
`cpf` varchar(20) DEFAULT NULL,
`telefone_fixo` varchar(35) DEFAULT NULL,
`cep` varchar(9) DEFAULT NULL,
`endereco` varchar(255) DEFAULT NULL,
`numero` varchar(255) DEFAULT NULL,
`complemento` varchar(255) DEFAULT NULL,
`bairro` varchar(255) DEFAULT NULL,
`ip_ultimo_acesso` varchar(255) DEFAULT NULL,
`time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`chargeback` int(1) DEFAULT '0',
`pais` varchar(45) DEFAULT NULL,
`invoice_id` int(11) DEFAULT NULL,
`iugu_id` int(11) DEFAULT NULL,
`aparelho` varchar(255) DEFAULT NULL,
`endpoint` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `clientes` (`id`, `ip`, `conta_id`, `usuario_id`, `cliente_id`, `avatar`, `nome`, `sexo`, `data_de_nascimento`, `celular`, `email`, `estado`, `cidade`, `status`, `senha`, `rg`, `cpf`, `telefone_fixo`, `cep`, `endereco`, `numero`, `complemento`, `bairro`, `ip_ultimo_acesso`, `time`, `chargeback`, `pais`, `invoice_id`, `iugu_id`, `aparelho`, `endpoint`) VALUES
(1, '172.31.57.165', 1, 1, '1', NULL, 'Emerson Luiz Vignola Garcia', 'Masculino', '1976-05-18', '(11) 99127-4595', '[email protected]', 'SP', 'São Paulo', 'Ativo', 'e6ff4e3951a58e743501a7096b7ab397', '', '246.526.758-28', '', '04137-060', 'Rua Jussara', '83', '', 'Bosque da Saúde', '172.31.57.165', '2018-11-07 00:40:24', 0, 'Brasil', 0, 7, 'e8adda2d04ad2d9479fc7f9ef8dc51b4348aeff6cd3fb9644bf1001eef047a25', 'arn:aws:sns:us-west-1:503688510464:endpoint/APNS/ClubeDoIngressoProd/8f9b9c0a-0f74-35c4-bee0-887546b00514'),
(2, '::1', 1, 1, '1', NULL, 'Daniela Cordeiro de Farias Pereira', 'Feminino', '1997-02-02', '(11) 42013-400', '[email protected]', 'SP', 'Dirce Reis', 'Ativo', 'f3d2426e52be7c11edd6099fa01714c6', NULL, '435.067.648-10', NULL, NULL, NULL, NULL, NULL, NULL, '::1', '2018-11-07 12:34:05', 0, NULL, 0, 3, '636280841b3ef013aa15ebda5063a40853cd14d2b16efb84d8c764efff492834', 'arn:aws:sns:us-west-1:503688510464:endpoint/APNS/ClubeDoIngressoProd/e4edb8bc-2e77-3088-8940-fc06594cdef7'),
(3, '172.31.57.165', 1, 1, '1', NULL, 'Tarciso Souza ', 'Masculino', '1983-03-09', '(11) 98561-6975', '[email protected]', 'SP', 'São Paulo', 'Ativo', '2b314ca62e0cd9328b1d533b261f526b', NULL, '224.568.018-90', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.57.165', '2018-11-08 15:06:37', 0, NULL, 0, 866, 'cYhiq3_1mIw:APA91bGaaWhx5JDTpEKXjlPiUInrATG56gI2d74t1k-kpV1FXhKLerDJmuO4vfk9_EWYOeGefitCrxdKDVJu4_p0v5GIDKwmHsu6HzVmMH1OTqGpH3qcQFDYS3l1Cy9nSIfoHat7NOrI', 'arn:aws:sns:us-west-1:503688510464:endpoint/GCM/ClubeDoIngressoGCM/2317f272-bd6e-34ec-98b2-4136f8b16247'),
(4, '172.31.57.165', 1, 1, '1', NULL, 'Camila Souza Garcia', 'Feminino', '1988-03-15', '(11) 98898-9765', '[email protected]', '0', '', 'Ativo', 'a132c63ffd97f429ed9c7465c9c00317', '', '229.217.068-06', NULL, '', '', '', '', '', '172.31.57.165', '2018-11-08 23:32:58', 0, NULL, NULL, NULL, NULL, NULL),
(6, '172.31.17.144', 1, 1, '1', NULL, 'Daniela Cordeiro de Farias Pereira', 'Feminino', '1987-01-05', '(11) 90384-9038', '[email protected]', NULL, NULL, 'Ativo', '7a15a04c00d7a2e14bbcdd8f605868df', NULL, '411.416.555-00', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.17.144', '2018-11-09 18:10:14', 0, NULL, NULL, NULL, NULL, NULL),
(7, '172.31.57.165', 1, 1, '1', NULL, 'Lucas', 'Masculino', '1981-06-05', '(11) 96013-0080', '[email protected]', 'SP', 'Santo André', 'Ativo', '06a8647723d4d285aefdb02ed285220b', NULL, '303.718.718-24', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.57.165', '2018-11-12 17:50:24', 0, NULL, 0, 370146, '206995252f9e9de4d64f25a19367378959f96b4c1a980e465d0cee395207e4c8', 'arn:aws:sns:us-west-1:503688510464:endpoint/APNS/ClubeDoIngressoProd/30dc8d85-3eb5-3d23-a38d-2445a7256fd1'),
(8, '172.31.17.144', 1, 1, '1', NULL, 'Roberta Cristine Soares Miranda', 'Feminino', '2004-09-16', '(11) 94887-0980', '[email protected]', 'SP', 'São Paulo', 'Ativo', 'e015c2f1f6690f1a5d7dbd2b2aa6ff76', NULL, '439.940.888-01', '', '02230-050', 'Rua Augusto Montenegro', '368', 'casa 6', 'Parque Edu Chaves', '172.31.17.144', '2018-11-20 01:03:22', 0, 'Brasil', 0, 0, NULL, NULL),
(9, '172.31.17.144', 1, 1, '1', NULL, 'Paulo Henrique Rodrigues Alves ', 'Masculino', '2001-12-14', '(11) 99499-8371', '[email protected]', 'SP', 'São Paulo', 'Ativo', '928c0a79d6d96051130411562b45f246', NULL, '900.048.238-00', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.17.144', '2018-11-20 01:25:53', 0, NULL, 0, 0, NULL, NULL),
(10, '172.31.57.165', 1, 1, '1', NULL, 'raquel rosa costa ', 'Feminino', '1974-07-21', '(11) 97506-9026', '[email protected]', 'SP', 'Guarulhos', 'Ativo', '8ef7d389c8111ec11ae8213573c62e26', NULL, '252.972.658-27', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.57.165', '2018-11-20 01:28:46', 0, NULL, NULL, NULL, NULL, NULL),
(11, '172.31.57.165', 1, 1, '1', NULL, 'Marlene Natividade', 'Feminino', '1974-05-12', '(11) 97073-4486', '[email protected]', 'SP', 'São Paulo', 'Ativo', 'ba5ab881b5e9b7d416220f777f9ae132', NULL, '152.042.808-12', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.57.165', '2018-11-20 11:44:29', 0, NULL, 0, 60001, NULL, NULL),
(12, '172.31.17.144', 1, 1, '1', NULL, 'Micheli das Dores Santos Martinez', 'Feminino', '1985-09-13', '(11) 95145-9275', '[email protected]', 'SP', 'São Paulo', 'Ativo', '317205b55d1008fd32075cb63c606db1', NULL, '332.480.508-29', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.17.144', '2018-11-20 11:45:49', 0, NULL, NULL, NULL, NULL, NULL),
CREATE TABLE `clientes` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`conta_id` int(11) DEFAULT '1',
`usuario_id` int(11) DEFAULT '1',
`cliente_id` varchar(100) DEFAULT '1',
`avatar` varchar(255) DEFAULT NULL,
`nome` varchar(255) DEFAULT NULL,
`sexo` varchar(255) DEFAULT NULL,
`data_de_nascimento` date DEFAULT NULL,
`celular` varchar(35) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`estado` varchar(2) DEFAULT NULL,
`cidade` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`senha` varchar(255) DEFAULT NULL,
`rg` varchar(255) DEFAULT NULL,
`cpf` varchar(20) DEFAULT NULL,
`telefone_fixo` varchar(35) DEFAULT NULL,
`cep` varchar(9) DEFAULT NULL,
`endereco` varchar(255) DEFAULT NULL,
`numero` varchar(255) DEFAULT NULL,
`complemento` varchar(255) DEFAULT NULL,
`bairro` varchar(255) DEFAULT NULL,
`ip_ultimo_acesso` varchar(255) DEFAULT NULL,
`time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`chargeback` int(1) DEFAULT '0',
`pais` varchar(45) DEFAULT NULL,
`invoice_id` int(11) DEFAULT NULL,
`iugu_id` int(11) DEFAULT NULL,
`aparelho` varchar(255) DEFAULT NULL,
`endpoint` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `clientes` (`id`, `ip`, `conta_id`, `usuario_id`, `cliente_id`, `avatar`, `nome`, `sexo`, `data_de_nascimento`, `celular`, `email`, `estado`, `cidade`, `status`, `senha`, `rg`, `cpf`, `telefone_fixo`, `cep`, `endereco`, `numero`, `complemento`, `bairro`, `ip_ultimo_acesso`, `time`, `chargeback`, `pais`, `invoice_id`, `iugu_id`, `aparelho`, `endpoint`) VALUES
(1, '172.31.57.165', 1, 1, '1', NULL, 'Emerson Luiz Vignola Garcia', 'Masculino', '1976-05-18', '(11) 99127-4595', '[email protected]', 'SP', 'São Paulo', 'Ativo', 'e6ff4e3951a58e743501a7096b7ab397', '', '246.526.758-28', '', '04137-060', 'Rua Jussara', '83', '', 'Bosque da Saúde', '172.31.57.165', '2018-11-07 00:40:24', 0, 'Brasil', 0, 7, 'e8adda2d04ad2d9479fc7f9ef8dc51b4348aeff6cd3fb9644bf1001eef047a25', 'arn:aws:sns:us-west-1:503688510464:endpoint/APNS/ClubeDoIngressoProd/8f9b9c0a-0f74-35c4-bee0-887546b00514'),
(2, '::1', 1, 1, '1', NULL, 'Daniela Cordeiro de Farias Pereira', 'Feminino', '1997-02-02', '(11) 42013-400', '[email protected]', 'SP', 'Dirce Reis', 'Ativo', 'f3d2426e52be7c11edd6099fa01714c6', NULL, '435.067.648-10', NULL, NULL, NULL, NULL, NULL, NULL, '::1', '2018-11-07 12:34:05', 0, NULL, 0, 3, '636280841b3ef013aa15ebda5063a40853cd14d2b16efb84d8c764efff492834', 'arn:aws:sns:us-west-1:503688510464:endpoint/APNS/ClubeDoIngressoProd/e4edb8bc-2e77-3088-8940-fc06594cdef7'),
(3, '172.31.57.165', 1, 1, '1', NULL, 'Tarciso Souza ', 'Masculino', '1983-03-09', '(11) 98561-6975', '[email protected]', 'SP', 'São Paulo', 'Ativo', '2b314ca62e0cd9328b1d533b261f526b', NULL, '224.568.018-90', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.57.165', '2018-11-08 15:06:37', 0, NULL, 0, 866, 'cYhiq3_1mIw:APA91bGaaWhx5JDTpEKXjlPiUInrATG56gI2d74t1k-kpV1FXhKLerDJmuO4vfk9_EWYOeGefitCrxdKDVJu4_p0v5GIDKwmHsu6HzVmMH1OTqGpH3qcQFDYS3l1Cy9nSIfoHat7NOrI', 'arn:aws:sns:us-west-1:503688510464:endpoint/GCM/ClubeDoIngressoGCM/2317f272-bd6e-34ec-98b2-4136f8b16247'),
(4, '172.31.57.165', 1, 1, '1', NULL, 'Camila Souza Garcia', 'Feminino', '1988-03-15', '(11) 98898-9765', '[email protected]', '0', '', 'Ativo', 'a132c63ffd97f429ed9c7465c9c00317', '', '229.217.068-06', NULL, '', '', '', '', '', '172.31.57.165', '2018-11-08 23:32:58', 0, NULL, NULL, NULL, NULL, NULL),
(6, '172.31.17.144', 1, 1, '1', NULL, 'Daniela Cordeiro de Farias Pereira', 'Feminino', '1987-01-05', '(11) 90384-9038', '[email protected]', NULL, NULL, 'Ativo', '7a15a04c00d7a2e14bbcdd8f605868df', NULL, '411.416.555-00', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.17.144', '2018-11-09 18:10:14', 0, NULL, NULL, NULL, NULL, NULL),
(7, '172.31.57.165', 1, 1, '1', NULL, 'Lucas', 'Masculino', '1981-06-05', '(11) 96013-0080', '[email protected]', 'SP', 'Santo André', 'Ativo', '06a8647723d4d285aefdb02ed285220b', NULL, '303.718.718-24', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.57.165', '2018-11-12 17:50:24', 0, NULL, 0, 370146, '206995252f9e9de4d64f25a19367378959f96b4c1a980e465d0cee395207e4c8', 'arn:aws:sns:us-west-1:503688510464:endpoint/APNS/ClubeDoIngressoProd/30dc8d85-3eb5-3d23-a38d-2445a7256fd1'),
(8, '172.31.17.144', 1, 1, '1', NULL, 'Roberta Cristine Soares Miranda', 'Feminino', '2004-09-16', '(11) 94887-0980', '[email protected]', 'SP', 'São Paulo', 'Ativo', 'e015c2f1f6690f1a5d7dbd2b2aa6ff76', NULL, '439.940.888-01', '', '02230-050', 'Rua Augusto Montenegro', '368', 'casa 6', 'Parque Edu Chaves', '172.31.17.144', '2018-11-20 01:03:22', 0, 'Brasil', 0, 0, NULL, NULL),
(9, '172.31.17.144', 1, 1, '1', NULL, 'Paulo Henrique Rodrigues Alves ', 'Masculino', '2001-12-14', '(11) 99499-8371', '[email protected]', 'SP', 'São Paulo', 'Ativo', '928c0a79d6d96051130411562b45f246', NULL, '900.048.238-00', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.17.144', '2018-11-20 01:25:53', 0, NULL, 0, 0, NULL, NULL),
(10, '172.31.57.165', 1, 1, '1', NULL, 'raquel rosa costa ', 'Feminino', '1974-07-21', '(11) 97506-9026', '[email protected]', 'SP', 'Guarulhos', 'Ativo', '8ef7d389c8111ec11ae8213573c62e26', NULL, '252.972.658-27', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.57.165', '2018-11-20 01:28:46', 0, NULL, NULL, NULL, NULL, NULL),
(11, '172.31.57.165', 1, 1, '1', NULL, 'Marlene Natividade', 'Feminino', '1974-05-12', '(11) 97073-4486', '[email protected]', 'SP', 'São Paulo', 'Ativo', 'ba5ab881b5e9b7d416220f777f9ae132', NULL, '152.042.808-12', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.57.165', '2018-11-20 11:44:29', 0, NULL, 0, 60001, NULL, NULL),
(12, '172.31.17.144', 1, 1, '1', NULL, 'Micheli das Dores Santos Martinez', 'Feminino', '1985-09-13', '(11) 95145-9275', '[email protected]', 'SP', 'São Paulo', 'Ativo', '317205b55d1008fd32075cb63c606db1', NULL, '332.480.508-29', NULL, NULL, NULL, NULL, NULL, NULL, '172.31.17.144', '2018-11-20 11:45:49', 0, NULL, NULL, NULL, NULL, NULL),