Wattpad.com 2020 cleaned
by Tanaka - Wednesday May 14, 2025 at 03:03 AM
thanks a lot
Reply
(15-05-25, 03:03 AM)Tanaka Wrote: Wattpad 2020 cleaned

Parsed all users that have name/email from original SQL file.

format: csv
rows: 133,641,389
date: 2020
size: 13G uncompressed

sample:
 
NAME,EMAIL,LOGINDATE,ACTIVE,VERIFIED,REALNAME,LOCATION,COUNTRY,WEBSITE,PHONE,SUBSCRIBE,DOB,GENDER,FBID,TWITTERID,AVATAR_TIMESTAMP,BACKGROUND_TIMESTAMP,EMAILBOUNCEDATE\ mtextbox,[email protected],2012,1,1,sdsds,,ES,,,0,1992-01-01,F,,,2020,2020,2019 ivanyuen,[email protected],2017,1,1,"Ivan Yuen","Toronto, Ontario",CA,https://www.flickr.com/photos/iyuen/sets/,,1,1977-01-07,M,590575780,,2019,2015, _minicooper,[email protected],2012,0,1,"Mini Cooper",Toronto,CA,,,0,,,,,2012,, slarlasrevenge,[email protected],2019,1,1,"Starlights Revenge",London,GB,,,0,1995-10-26,F,,,2020,2020, _smshsm,[email protected],2018,0,1,shsajib,"Dhaka,Bangladesh",BD,www.wattpad.com/user/smshs69,,1,1901-09-22,M,,,,, n1neuls,[email protected],2012,1,1,Nick,Vancouver,BC,CA,,,0,,M,,,2008,2009, maziz66,[email protected],2017,1,0,MAA,,SA,,,1,1966-06-15,M,,,,, martel_bell,[email protected],2012,1,1,"Martel Bell","La Habra, CA",US,,,1,,M,,,2009, mmplayer,[email protected],2014,1,1,Sheng Long Li,Toronto,Canada,CA,,,0,1970-04-26,M,,,,, _having_fun,[email protected],2020,0,1,Just Checking,Canada,CA,,,0,1980-01-31,F,,,2010,2010, gutenberg,[email protected],2016,1,1,Project Gutenberg,The Public Domain,CA,http://www.gutenberg.org,,0,,M,,,2013,2009, VanBabe2,[email protected],2011,1,0,VanBabe,Canada,CA,,,0,1993-01-01,F,,,,, editionsdedicaces,[email protected],2014,1,1,Editions Dédicaces,Montréal,Québec,CA,http://www.dedicaces.biz,,0,1962-12-13,M,,,2011,, Arnobxxx,[email protected],2012,0,1,Ishmam,Woodbridge,Ontario,CA,,,0,,,1313454962,,2012,2009, lillet666,[email protected],2016,1,1,siobhan,ontario,CA,,,0,1989-07-22,F,1183644432,,2015,2011, ipodmaniac,[email protected],2018,1,1,Hannah,West Coast of Canada,CA,,,0,1995-08-23,F,,hannah_hazelton,2014,2013, trxckster,[email protected],2012,1,1,Angela Taylor,Washington,DC,US,http://trxckster.blogspot.com,,1,1965-10-11,F,1081756078,,2010,, _mtsmith,[email protected],2011,0,1,Moreland Smith,Greensboro,NC,US,,,1,1969-12-05,M,,,,, robertswilson,[email protected],2016,1,1,Robert S. Wilson,Mount Juliet,Tennessee,US,http://www.shiningincrimson.com,,1,1978-05-06,M,837496434,EmpireOfBloodRW,2012,2018, karthik_it2004,[email protected],2014,1,1,karthik,bangalore,US,karthik.it2004.googlepages.com,,1,,,1072097380,,2008,, paragpahwa,[email protected],2015,1,1,Parag Pahwa,Indore,India,US,,,1,1990-07-19,M,539088698,,,, maedhanie,[email protected],2013,1,0,Abe Kun,,US,Opera News

OMG this is 2026 but we still share this notorious data
ahahah
Reply
wow very nice, thanks for sharing
Reply
appreciate it
Reply
Thanks, been looking for this
Reply
(15-05-25, 03:03 AM)Tanaka Wrote: Wattpad 2020 cleaned

Parsed all users that have name/email from original SQL file.

format: csv
rows: 133,641,389
date: 2020
size: 13G uncompressed

sample:
 
NAME,EMAIL,LOGINDATE,ACTIVE,VERIFIED,REALNAME,LOCATION,COUNTRY,WEBSITE,PHONE,SUBSCRIBE,DOB,GENDER,FBID,TWITTERID,AVATAR_TIMESTAMP,BACKGROUND_TIMESTAMP,EMAILBOUNCEDATE\ mtextbox,[email protected],2012,1,1,sdsds,,ES,,,0,1992-01-01,F,,,2020,2020,2019 ivanyuen,[email protected],2017,1,1,"Ivan Yuen","Toronto, Ontario",CA,https://www.flickr.com/photos/iyuen/sets/,,1,1977-01-07,M,590575780,,2019,2015, _minicooper,[email protected],2012,0,1,"Mini Cooper",Toronto,CA,,,0,,,,,2012,, slarlasrevenge,[email protected],2019,1,1,"Starlights Revenge",London,GB,,,0,1995-10-26,F,,,2020,2020, _smshsm,[email protected],2018,0,1,shsajib,"Dhaka,Bangladesh",BD,www.wattpad.com/user/smshs69,,1,1901-09-22,M,,,,, n1neuls,[email protected],2012,1,1,Nick,Vancouver,BC,CA,,,0,,M,,,2008,2009, maziz66,[email protected],2017,1,0,MAA,,SA,,,1,1966-06-15,M,,,,, martel_bell,[email protected],2012,1,1,"Martel Bell","La Habra, CA",US,,,1,,M,,,2009, mmplayer,[email protected],2014,1,1,Sheng Long Li,Toronto,Canada,CA,,,0,1970-04-26,M,,,,, _having_fun,[email protected],2020,0,1,Just Checking,Canada,CA,,,0,1980-01-31,F,,,2010,2010, gutenberg,[email protected],2016,1,1,Project Gutenberg,The Public Domain,CA,http://www.gutenberg.org,,0,,M,,,2013,2009, VanBabe2,[email protected],2011,1,0,VanBabe,Canada,CA,,,0,1993-01-01,F,,,,, editionsdedicaces,[email protected],2014,1,1,Editions Dédicaces,Montréal,Québec,CA,http://www.dedicaces.biz,,0,1962-12-13,M,,,2011,, Arnobxxx,[email protected],2012,0,1,Ishmam,Woodbridge,Ontario,CA,,,0,,,1313454962,,2012,2009, lillet666,[email protected],2016,1,1,siobhan,ontario,CA,,,0,1989-07-22,F,1183644432,,2015,2011, ipodmaniac,[email protected],2018,1,1,Hannah,West Coast of Canada,CA,,,0,1995-08-23,F,,hannah_hazelton,2014,2013, trxckster,[email protected],2012,1,1,Angela Taylor,Washington,DC,US,http://trxckster.blogspot.com,,1,1965-10-11,F,1081756078,,2010,, _mtsmith,[email protected],2011,0,1,Moreland Smith,Greensboro,NC,US,,,1,1969-12-05,M,,,,, robertswilson,[email protected],2016,1,1,Robert S. Wilson,Mount Juliet,Tennessee,US,http://www.shiningincrimson.com,,1,1978-05-06,M,837496434,EmpireOfBloodRW,2012,2018, karthik_it2004,[email protected],2014,1,1,karthik,bangalore,US,karthik.it2004.googlepages.com,,1,,,1072097380,,2008,, paragpahwa,[email protected],2015,1,1,Parag Pahwa,Indore,India,US,,,1,1990-07-19,M,539088698,,,, maedhanie,[email protected],2013,1,0,Abe Kun,,US,Opera News


thnx
Reply
thank you sir
Reply
Thank you
Reply
thank you much!
Reply
(15-05-25, 03:03 AM)Tanaka Wrote: Wattpad 2020 cleaned

Parsed all users that have name/email from original SQL file.

format: csv
rows: 133,641,389
date: 2020
size: 13G uncompressed

sample:
 
NAME,EMAIL,LOGINDATE,ACTIVE,VERIFIED,REALNAME,LOCATION,COUNTRY,WEBSITE,PHONE,SUBSCRIBE,DOB,GENDER,FBID,TWITTERID,AVATAR_TIMESTAMP,BACKGROUND_TIMESTAMP,EMAILBOUNCEDATE\ mtextbox,[email protected],2012,1,1,sdsds,,ES,,,0,1992-01-01,F,,,2020,2020,2019 ivanyuen,[email protected],2017,1,1,"Ivan Yuen","Toronto, Ontario",CA,https://www.flickr.com/photos/iyuen/sets/,,1,1977-01-07,M,590575780,,2019,2015, _minicooper,[email protected],2012,0,1,"Mini Cooper",Toronto,CA,,,0,,,,,2012,, slarlasrevenge,[email protected],2019,1,1,"Starlights Revenge",London,GB,,,0,1995-10-26,F,,,2020,2020, _smshsm,[email protected],2018,0,1,shsajib,"Dhaka,Bangladesh",BD,www.wattpad.com/user/smshs69,,1,1901-09-22,M,,,,, n1neuls,[email protected],2012,1,1,Nick,Vancouver,BC,CA,,,0,,M,,,2008,2009, maziz66,[email protected],2017,1,0,MAA,,SA,,,1,1966-06-15,M,,,,, martel_bell,[email protected],2012,1,1,"Martel Bell","La Habra, CA",US,,,1,,M,,,2009, mmplayer,[email protected],2014,1,1,Sheng Long Li,Toronto,Canada,CA,,,0,1970-04-26,M,,,,, _having_fun,[email protected],2020,0,1,Just Checking,Canada,CA,,,0,1980-01-31,F,,,2010,2010, gutenberg,[email protected],2016,1,1,Project Gutenberg,The Public Domain,CA,http://www.gutenberg.org,,0,,M,,,2013,2009, VanBabe2,[email protected],2011,1,0,VanBabe,Canada,CA,,,0,1993-01-01,F,,,,, editionsdedicaces,[email protected],2014,1,1,Editions Dédicaces,Montréal,Québec,CA,http://www.dedicaces.biz,,0,1962-12-13,M,,,2011,, Arnobxxx,[email protected],2012,0,1,Ishmam,Woodbridge,Ontario,CA,,,0,,,1313454962,,2012,2009, lillet666,[email protected],2016,1,1,siobhan,ontario,CA,,,0,1989-07-22,F,1183644432,,2015,2011, ipodmaniac,[email protected],2018,1,1,Hannah,West Coast of Canada,CA,,,0,1995-08-23,F,,hannah_hazelton,2014,2013, trxckster,[email protected],2012,1,1,Angela Taylor,Washington,DC,US,http://trxckster.blogspot.com,,1,1965-10-11,F,1081756078,,2010,, _mtsmith,[email protected],2011,0,1,Moreland Smith,Greensboro,NC,US,,,1,1969-12-05,M,,,,, robertswilson,[email protected],2016,1,1,Robert S. Wilson,Mount Juliet,Tennessee,US,http://www.shiningincrimson.com,,1,1978-05-06,M,837496434,EmpireOfBloodRW,2012,2018, karthik_it2004,[email protected],2014,1,1,karthik,bangalore,US,karthik.it2004.googlepages.com,,1,,,1072097380,,2008,, paragpahwa,[email protected],2015,1,1,Parag Pahwa,Indore,India,US,,,1,1990-07-19,M,539088698,,,, maedhanie,[email protected],2013,1,0,Abe Kun,,US,Opera News

let's see this
Reply


Forum Jump:


 Users browsing this thread: 1 Guest(s)