Wattpad.com 2020 cleaned

kdmcp · 05-02-26, 04:56 PM

thanks a lot

jeanboelard · 05-02-26, 06:15 PM

(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:

Code:
NAME,EMAIL,LOGINDATE,ACTIVE,VERIFIED,REALNAME,LOCATION,COUNTRY,WEBSITE,PHONE,SUBSCRIBE,DOB,GENDER,FBID,TWITTERID,AVATAR_TIMESTAMP,BACKGROUND_TIMESTAMP,EMAILBOUNCEDATE\ mtextbox,noreply@wattpad.com,2012,1,1,sdsds,,ES,,,0,1992-01-01,F,,,2020,2020,2019 ivanyuen,iyuen@yahoo.com,2017,1,1,"Ivan Yuen","Toronto, Ontario",CA,https://www.flickr.com/photos/iyuen/sets/,,1,1977-01-07,M,590575780,,2019,2015, _minicooper,_bt227@hotmail.com,2012,0,1,"Mini Cooper",Toronto,CA,,,0,,,,,2012,, slarlasrevenge,hammie_88@hotmail.com,2019,1,1,"Starlights Revenge",London,GB,,,0,1995-10-26,F,,,2020,2020, _smshsm,_shsajib@gmail.com,2018,0,1,shsajib,"Dhaka,Bangladesh",BD,www.wattpad.com/user/smshs69,,1,1901-09-22,M,,,,, n1neuls,airborne9702@hotmail.com,2012,1,1,Nick,Vancouver,BC,CA,,,0,,M,,,2008,2009, maziz66,g1ksa66@gmail.com,2017,1,0,MAA,,SA,,,1,1966-06-15,M,,,,, martel_bell,martel_bell@medianet.att.net,2012,1,1,"Martel Bell","La Habra, CA",US,,,1,,M,,,2009, mmplayer,allanssyuen@yahoo.com,2014,1,1,Sheng Long Li,Toronto,Canada,CA,,,0,1970-04-26,M,,,,, _having_fun,_eva@wattpad.com,2020,0,1,Just Checking,Canada,CA,,,0,1980-01-31,F,,,2010,2010, gutenberg,wattpad+gutenberg@gmail.com,2016,1,1,Project Gutenberg,The Public Domain,CA,http://www.gutenberg.org,,0,,M,,,2013,2009, VanBabe2,bt227@hotmail.com,2011,1,0,VanBabe,Canada,CA,,,0,1993-01-01,F,,,,, editionsdedicaces,editions.dedicaces@yahoo.fr,2014,1,1,Editions Dédicaces,Montréal,Québec,CA,http://www.dedicaces.biz,,0,1962-12-13,M,,,2011,, Arnobxxx,lorddiablo555@hotmail.com,2012,0,1,Ishmam,Woodbridge,Ontario,CA,,,0,,,1313454962,,2012,2009, lillet666,siobhan_sharpe@outlook.com,2016,1,1,siobhan,ontario,CA,,,0,1989-07-22,F,1183644432,,2015,2011, ipodmaniac,ipodxmanaic@gmail.com,2018,1,1,Hannah,West Coast of Canada,CA,,,0,1995-08-23,F,,hannah_hazelton,2014,2013, trxckster,trxckster@gmail.com,2012,1,1,Angela Taylor,Washington,DC,US,http://trxckster.blogspot.com,,1,1965-10-11,F,1081756078,,2010,, _mtsmith,_moreland.smith@gmail.com,2011,0,1,Moreland Smith,Greensboro,NC,US,,,1,1969-12-05,M,,,,, robertswilson,robertshanewilson@gmail.com,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,karthik.it2004@gmail.com,2014,1,1,karthik,bangalore,US,karthik.it2004.googlepages.com,,1,,,1072097380,,2008,, paragpahwa,paragpahwa@gmail.com,2015,1,1,Parag Pahwa,Indore,India,US,,,1,1990-07-19,M,539088698,,,, maedhanie,maedhanie@myopera.com,2013,1,0,Abe Kun,,US,Opera News

OMG this is 2026 but we still share this notorious data
ahahah

blackhub · 05-02-26, 06:38 PM

wow very nice, thanks for sharing

ollkollk33 · 07-02-26, 12:04 PM

appreciate it

fumbl3 · 08-02-26, 05:30 PM

Thanks, been looking for this

guesswhozb4ck · 09-02-26, 03:56 AM

(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:

Code:
NAME,EMAIL,LOGINDATE,ACTIVE,VERIFIED,REALNAME,LOCATION,COUNTRY,WEBSITE,PHONE,SUBSCRIBE,DOB,GENDER,FBID,TWITTERID,AVATAR_TIMESTAMP,BACKGROUND_TIMESTAMP,EMAILBOUNCEDATE\ mtextbox,noreply@wattpad.com,2012,1,1,sdsds,,ES,,,0,1992-01-01,F,,,2020,2020,2019 ivanyuen,iyuen@yahoo.com,2017,1,1,"Ivan Yuen","Toronto, Ontario",CA,https://www.flickr.com/photos/iyuen/sets/,,1,1977-01-07,M,590575780,,2019,2015, _minicooper,_bt227@hotmail.com,2012,0,1,"Mini Cooper",Toronto,CA,,,0,,,,,2012,, slarlasrevenge,hammie_88@hotmail.com,2019,1,1,"Starlights Revenge",London,GB,,,0,1995-10-26,F,,,2020,2020, _smshsm,_shsajib@gmail.com,2018,0,1,shsajib,"Dhaka,Bangladesh",BD,www.wattpad.com/user/smshs69,,1,1901-09-22,M,,,,, n1neuls,airborne9702@hotmail.com,2012,1,1,Nick,Vancouver,BC,CA,,,0,,M,,,2008,2009, maziz66,g1ksa66@gmail.com,2017,1,0,MAA,,SA,,,1,1966-06-15,M,,,,, martel_bell,martel_bell@medianet.att.net,2012,1,1,"Martel Bell","La Habra, CA",US,,,1,,M,,,2009, mmplayer,allanssyuen@yahoo.com,2014,1,1,Sheng Long Li,Toronto,Canada,CA,,,0,1970-04-26,M,,,,, _having_fun,_eva@wattpad.com,2020,0,1,Just Checking,Canada,CA,,,0,1980-01-31,F,,,2010,2010, gutenberg,wattpad+gutenberg@gmail.com,2016,1,1,Project Gutenberg,The Public Domain,CA,http://www.gutenberg.org,,0,,M,,,2013,2009, VanBabe2,bt227@hotmail.com,2011,1,0,VanBabe,Canada,CA,,,0,1993-01-01,F,,,,, editionsdedicaces,editions.dedicaces@yahoo.fr,2014,1,1,Editions Dédicaces,Montréal,Québec,CA,http://www.dedicaces.biz,,0,1962-12-13,M,,,2011,, Arnobxxx,lorddiablo555@hotmail.com,2012,0,1,Ishmam,Woodbridge,Ontario,CA,,,0,,,1313454962,,2012,2009, lillet666,siobhan_sharpe@outlook.com,2016,1,1,siobhan,ontario,CA,,,0,1989-07-22,F,1183644432,,2015,2011, ipodmaniac,ipodxmanaic@gmail.com,2018,1,1,Hannah,West Coast of Canada,CA,,,0,1995-08-23,F,,hannah_hazelton,2014,2013, trxckster,trxckster@gmail.com,2012,1,1,Angela Taylor,Washington,DC,US,http://trxckster.blogspot.com,,1,1965-10-11,F,1081756078,,2010,, _mtsmith,_moreland.smith@gmail.com,2011,0,1,Moreland Smith,Greensboro,NC,US,,,1,1969-12-05,M,,,,, robertswilson,robertshanewilson@gmail.com,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,karthik.it2004@gmail.com,2014,1,1,karthik,bangalore,US,karthik.it2004.googlepages.com,,1,,,1072097380,,2008,, paragpahwa,paragpahwa@gmail.com,2015,1,1,Parag Pahwa,Indore,India,US,,,1,1990-07-19,M,539088698,,,, maedhanie,maedhanie@myopera.com,2013,1,0,Abe Kun,,US,Opera News

thnx

cafe1231 · 09-02-26, 05:58 PM

thank you sir

igor360 · 09-02-26, 07:10 PM

Thank you

lamani4685 · 09-02-26, 07:54 PM

thank you much!

stazzzzzz · Yesterday, 07:59 PM

(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:

Code:
NAME,EMAIL,LOGINDATE,ACTIVE,VERIFIED,REALNAME,LOCATION,COUNTRY,WEBSITE,PHONE,SUBSCRIBE,DOB,GENDER,FBID,TWITTERID,AVATAR_TIMESTAMP,BACKGROUND_TIMESTAMP,EMAILBOUNCEDATE\ mtextbox,noreply@wattpad.com,2012,1,1,sdsds,,ES,,,0,1992-01-01,F,,,2020,2020,2019 ivanyuen,iyuen@yahoo.com,2017,1,1,"Ivan Yuen","Toronto, Ontario",CA,https://www.flickr.com/photos/iyuen/sets/,,1,1977-01-07,M,590575780,,2019,2015, _minicooper,_bt227@hotmail.com,2012,0,1,"Mini Cooper",Toronto,CA,,,0,,,,,2012,, slarlasrevenge,hammie_88@hotmail.com,2019,1,1,"Starlights Revenge",London,GB,,,0,1995-10-26,F,,,2020,2020, _smshsm,_shsajib@gmail.com,2018,0,1,shsajib,"Dhaka,Bangladesh",BD,www.wattpad.com/user/smshs69,,1,1901-09-22,M,,,,, n1neuls,airborne9702@hotmail.com,2012,1,1,Nick,Vancouver,BC,CA,,,0,,M,,,2008,2009, maziz66,g1ksa66@gmail.com,2017,1,0,MAA,,SA,,,1,1966-06-15,M,,,,, martel_bell,martel_bell@medianet.att.net,2012,1,1,"Martel Bell","La Habra, CA",US,,,1,,M,,,2009, mmplayer,allanssyuen@yahoo.com,2014,1,1,Sheng Long Li,Toronto,Canada,CA,,,0,1970-04-26,M,,,,, _having_fun,_eva@wattpad.com,2020,0,1,Just Checking,Canada,CA,,,0,1980-01-31,F,,,2010,2010, gutenberg,wattpad+gutenberg@gmail.com,2016,1,1,Project Gutenberg,The Public Domain,CA,http://www.gutenberg.org,,0,,M,,,2013,2009, VanBabe2,bt227@hotmail.com,2011,1,0,VanBabe,Canada,CA,,,0,1993-01-01,F,,,,, editionsdedicaces,editions.dedicaces@yahoo.fr,2014,1,1,Editions Dédicaces,Montréal,Québec,CA,http://www.dedicaces.biz,,0,1962-12-13,M,,,2011,, Arnobxxx,lorddiablo555@hotmail.com,2012,0,1,Ishmam,Woodbridge,Ontario,CA,,,0,,,1313454962,,2012,2009, lillet666,siobhan_sharpe@outlook.com,2016,1,1,siobhan,ontario,CA,,,0,1989-07-22,F,1183644432,,2015,2011, ipodmaniac,ipodxmanaic@gmail.com,2018,1,1,Hannah,West Coast of Canada,CA,,,0,1995-08-23,F,,hannah_hazelton,2014,2013, trxckster,trxckster@gmail.com,2012,1,1,Angela Taylor,Washington,DC,US,http://trxckster.blogspot.com,,1,1965-10-11,F,1081756078,,2010,, _mtsmith,_moreland.smith@gmail.com,2011,0,1,Moreland Smith,Greensboro,NC,US,,,1,1969-12-05,M,,,,, robertswilson,robertshanewilson@gmail.com,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,karthik.it2004@gmail.com,2014,1,1,karthik,bangalore,US,karthik.it2004.googlepages.com,,1,,,1072097380,,2008,, paragpahwa,paragpahwa@gmail.com,2015,1,1,Parag Pahwa,Indore,India,US,,,1,1990-07-19,M,539088698,,,, maedhanie,maedhanie@myopera.com,2013,1,0,Abe Kun,,US,Opera News

let's see this