One Million Reddit Confessions

One million confessions from Reddit's users, going back from September 2021.

@kaggle.pavellexyr_one_million_reddit_confessions

Table List

1 table(410.11 MB)

One Million Reddit Confessions

@kaggle.pavellexyr_one_million_reddit_confessions.one_million_reddit_confessions

410.11 MB
1000000 rows
12 columns

type Type	id Id	subreddit_id Subreddit.id	subreddit_name Subreddit.name	created_utc Created Utc	permalink Permalink	domain Domain	url Url	selftext Selftext	title Title	score Score
post	pyw04g	2qo2a	confession	1633046122	https://old.reddit.com/r/confession/comments/pyw04g/i_was_horrible_to_children_at_my_first_preschool/	self.confession	nan	I've always been great with children. I used to nanny and do summer camps etc. however when I got my first job in a preschool things were out of control. we were under staffed and I got EXTEREMLY overwhelmed. I was so stressed and overstimulated. Most of the children were great/ easy to work with…	I was horrible to children at my first preschool job	8
post	pyvzbo	2qo2a	confession	1633046048	https://old.reddit.com/r/confession/comments/pyvzbo/i_asked_my_crush_for_sending_me_her_picture_and/	self.confession	nan	[removed]	I asked my crush for sending me her picture and she got made at me.	1
post	pyvxtt	2qo2a	confession	1633045902	https://old.reddit.com/r/confession/comments/pyvxtt/im_a_fucking_dunce_and_want_to_cringe_myself_out/	self.confession	nan	[removed]	I'm a fucking dunce and want to cringe myself out existence.	1
post	pyvwgp	2qo2a	confession	1633045767	https://old.reddit.com/r/confession/comments/pyvwgp/i_have_0_friends_and_now_i_fantasies_about_having/	self.confession	nan	Hello everyone, I'm probably going to be made a laugh of but here goes nothing, I'm into girls but I crave a companion ship with a guy, I've never gotten a boner to a guy basically, in school I had no friends not even anyone I'd hang out with, anytime I see two dudes playing games together or just s…	I have 0 friends and now I fantasies about having friends	22
post	pyvt7k	2qo2a	confession	1633045443	https://old.reddit.com/r/confession/comments/pyvt7k/i_hired_a_escort_and_i_cant_live_this_with_regret/	self.confession	nan	[removed]	I hired a escort and I can’t live this with regret I need to let this out	1
post	pyvsmx	2qo2a	confession	1633045384	https://old.reddit.com/r/confession/comments/pyvsmx/i_had_sex_with_a_escort_and_im_really_regretting/	self.confession	nan	[removed]	I had sex with a escort and I’m really regretting it I need to let this out	1
post	pyvnvo	2qo2a	confession	1633044924	https://old.reddit.com/r/confession/comments/pyvnvo/someone_tell_me_what_is_wrong_with_me_and_why_im/	self.confession	nan	[removed]	someone tell me what is wrong with me and why I'm like this	1
post	pyvj28	2qo2a	confession	1633044471	https://old.reddit.com/r/confession/comments/pyvj28/i_set_up_cameras_in_my_sons_apartment_and_watched/	self.confession	nan	My son is 20 and he does have a sex life. I ask him for details about it and he says "I would rather not tell you details about my sex life just know it is enjoyable and I am using protection." But that wasn't good enough for me I had to know the details. My husband said "You should mind your own bu…	I set up cameras in my son's apartment and watched him have sex?
post	pyv6q3	2qo2a	confession	1633043281	https://old.reddit.com/r/confession/comments/pyv6q3/the_reason_i_dont_kill_myself_is_that_i_wont_get/	self.confession	nan	[removed]	The reason i dont kill myself is that i wont get to see what will happen afterwards	1
post	pyux60	2qo2a	confession	1633042392	https://old.reddit.com/r/confession/comments/pyux60/my_mother_sexually_abused_me_for_years_and_i/	self.confession	nan	[removed]	My mother sexually abused me for years and I haven’t told my dad.	1


CREATE TABLE one_million_reddit_confessions (
  "type" VARCHAR,
  "id" VARCHAR,
  "subreddit_id" VARCHAR,
  "subreddit_name" VARCHAR,
  "subreddit_nsfw" BOOLEAN,
  "created_utc" BIGINT,
  "permalink" VARCHAR,
  "domain" VARCHAR,
  "url" VARCHAR,
  "selftext" VARCHAR,
  "title" VARCHAR,
  "score" BIGINT
);