Wattpad.com 2020 cleaned

jackesawh · 13-07-25, 07:12 AM

thanks dear

scheemin · 13-07-25, 08:56 PM

insaneeeeeeeeeeeeeeeeee

uygarist · 13-07-25, 09:06 PM

Thank you

Sabina_mant · 14-07-25, 02:54 AM

wanna see man

Metrik · 14-07-25, 03:46 AM

nice leak thanks

CaptainTsubasa · (This post was last modified: 15-07-25, 11:12 PM by CaptainTsubasa.)

(15-05-25, 03:03 AM)Tanaka Wrote: Wattpad 2020 temizlendi

Orijinal SQL dosyasından adı/e-postası olan tüm kullanıcılar ayrıştırıldı.

biçim: csv
satırlar: 133.641.389
tarih: 2020
boyut: 13G sıkıştırılmamış

örnek:

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

thanks

demo88 · 17-07-25, 07:17 AM

show me bro

Aleyza32 · 17-07-25, 07:25 AM

thankyouu

lozza71 · 18-07-25, 07:38 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

thanks

spamuser75 · (This post was last modified: 18-07-25, 11:05 PM by spamuser75.)

(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

Thanks

[

[quote="Tanaka" pid="50831" dateline="1747258380"]
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

Thanks?