Wattpad.com 2020 cleaned
by Tanaka - Wednesday May 14, 2025 at 03:03 AM
swagg
Reply
Thanks
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


thx bro
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

THank for this been looking for this
Reply
zrgzrggz
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
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


thanks
Reply
thanks heaps
Reply
t-thank you pookie bearrr
Reply


Forum Jump:


 Users browsing this thread: 4 Guest(s)