Twitter Profiles - 5.7M Records - 1 Gb
CREATE TABLE `tw_profiles` (
`id` bigint(20) UNSIGNED NOT NULL,
`profile_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`username` varchar(50) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`keyword_used` varchar(255) NOT NULL DEFAULT '',
`lang` varchar(2) NOT NULL DEFAULT 'en',
`location` varchar(255) NOT NULL DEFAULT '',
`website` varchar(255) NOT NULL DEFAULT '',
`following` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`following_percentage` float(10,2) NOT NULL DEFAULT 0.00,
`followers` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`followers_percentage` float(10,2) NOT NULL DEFAULT 0.00,
`tweets` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`tweets_percentage` float(10,2) NOT NULL DEFAULT 0.00,
`verified` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
`is_private` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
`date_added` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`date_created` bigint(20) NOT NULL DEFAULT 0,
`date_updated` bigint(20) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Sample
`id` bigint(20) UNSIGNED NOT NULL,
`profile_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`username` varchar(50) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`keyword_used` varchar(255) NOT NULL DEFAULT '',
`lang` varchar(2) NOT NULL DEFAULT 'en',
`location` varchar(255) NOT NULL DEFAULT '',
`website` varchar(255) NOT NULL DEFAULT '',
`following` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`following_percentage` float(10,2) NOT NULL DEFAULT 0.00,
`followers` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`followers_percentage` float(10,2) NOT NULL DEFAULT 0.00,
`tweets` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`tweets_percentage` float(10,2) NOT NULL DEFAULT 0.00,
`verified` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
`is_private` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
`date_added` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
`date_created` bigint(20) NOT NULL DEFAULT 0,
`date_updated` bigint(20) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Sample
HTML:
(1825192, 991492659536715784, 'BlackOnline5', 'Lucas Silva', 'evannnns m', 'pt', 'Nova Russas, Brasil', '', 13, 0.00, 4, 0.00, 3, 0.00, 0, 0, 1666041122, 1525225245, 1666041121),
(1825193, 776462350509568000, 'BLACKONLINE6', 'Rafael Gomes Sebastião', 'evannnns m', 'qm', 'Angola', '', 192, 0.00, 22, 0.00, 34, 0.00, 0, 0, 1666041122, 1473958025, 1666041121),
(1825194, 85893591, 'ScaryThings', 'ScaryThings', 'evannnns m', 'en', '', 'http://bit.ly/1WY9Cm', 0, 0.00, 28, 0.00, 4583, 0.00, 0, 0, 1666041122, 1256758558, 1666041121),
(1825195, 1265077578227781632, 'katswimsregcant', 'spooky kat 🎃', 'bubleclean 9', 'es', 'she/they', '', 246, 0.00, 734, 0.00, 11062, 0.00, 0, 0, 1666041122, 1590453005, 1666041121),
(1825196, 1211541375633674242, 'purple_bubblezz', 't🎃', 'bubleclean 9', 'en', 'she/her¡!', 'https://instagram.com/thai.ge?utm_medium=copy_link', 323, 0.00, 192, 0.00, 5408, 0.00, 0, 0, 1666041122, 1577688960, 1666041121),
(1825197, 831281938690428928, 'MissBubblezz', 'Mariah🫧🧸', 'bubleclean 9', 'en', '🌻The Sunflower Patch🌻', 'http://linktr.ee/msbubblezz', 375, 0.00, 104, 0.00, 251, 0.00, 0, 0, 1666041122, 1487028033, 1666041121),
(1825198, 1845583975, 'KLM_Mika', 'mika.', 'bubleclean 9', 'en', 'Afrique du Sud', '', 286, 0.00, 781, 0.00, 24094, 0.00, 0, 0, 1666041122, 1378731941, 1666041121),
(1825199, 3290097569, 'BrizzyBara', '.', 'bubleclean 9', 'en', 'Uitenhage SOUTH AFRICA🇿🇦', '', 553, 0.00, 3428, 0.00, 310861, 0.00, 0, 0, 1666041122, 1432047346, 1666041121),
(1825200, 1562458684982448129, 'p0pstarbubblez', 'bubblezz', 'bubleclean 9', 'en', 'Orlando, FL', '', 39, 0.00, 39, 0.00, 156, 0.00, 0, 0, 1666041122, 1661354161, 1666041121),
(1825201, 1455649607460036609, 'ntandomatini_', 'SOCIAL CONSTRUCT', 'bubleclean 9', 'en', 'Cape Town, South Africa', 'http://instagram.com/ntandomatini_', 448, 0.00, 13096, 0.00, 26465, 0.00, 0, 0, 1666041122, 1635888907, 1666041121),
(1825202, 1469039275236904965, 'MmagoBlvckhoney', 'Cucumber Cool', 'bubleclean 9', 'en', '', '', 77, 0.00, 36, 0.00, 540, 0.00, 0, 0, 1666041122, 1639081240, 1666041121),