Public Opinion On Republicans (Daily Updated)

Reddit comments on posts related to Republicans

@kaggle.asaniczka_public_opinion_on_republicans_daily_updated

Table List

1 table(949.49 MB)

Reddit Opinion Republican

@kaggle.asaniczka_public_opinion_on_republicans_daily_updated.reddit_opinion_republican

949.49 MB
5395998 rows
24 columns

comment_id Comment Id	score Score	self_text Self Text	subreddit Subreddit	created_time Created Time	post_id Post Id	author_name Author Name	ups Ups	user_is_verified User Is Verified	user_account_created_time User Account Created Time	user_awardee_karma User Awardee Karma	user_link_karma User Link Karma	user_comment_karma User Comment Karma	user_total_karma User Total Karma	post_score Post Score	post_self_text Post Self Text	post_title Post Title	post_upvote_ratio Post Upvote Ratio	post_thumbs_ups Post Thumbs Ups	post_created_time Post Created Time
m8pszq1	1	* Your post has been removed because headlines must be comprised only of the exact copied and pasted headline of the article - [see our rule here](http://www.reddit.com/r/politics/wiki/rulesandregs#wiki_do_not_create_your_own_title). We recommend not using the Reddit 'suggest a title' as it …	politics	Thu Jan 23 2025 13:01:11 GMT+0000 (Coordinated Universal Time)	1i7ye2f	politics-ModTeam	1	True	Mon Aug 29 2022 12:42:20 GMT+0000 (Coordinated Universal Time)		1	3	4	26	nan	Immigrants’ Rights Advocates Sue Trump Administration Over Fast-Track Deportation Policy \| American Civil Liberties Union	0.82	26	Thu Jan 23 2025 07:50:18 GMT+0000 (Coordinated Universal Time)
m8pszhv	1	She writes books and publishes videos from Nebula and since she is no longer on Twitter she can no longer be canceled.	neoliberal	Thu Jan 23 2025 13:01:08 GMT+0000 (Coordinated Universal Time)	1i7in1m	wallander1983	1	True	Mon Jul 01 2019 04:10:38 GMT+0000 (Coordinated Universal Time)	185	740	84672	85597	198	Very interesting in-depth analysis of some of the major young male-oriented YouTube channels and their influence on their audiences.	How 9 Popular YouTubers Helped Trump Win a Second Term	0.94	198	Wed Jan 22 2025 18:51:36 GMT+0000 (Coordinated Universal Time)
m8psz10	1	The scotus ruling - IIRC - was about taking tik tok off app stores. Apple is supposedly not bringing tik tok back to their App Store due to the ruling. Trump didn’t really do anything, he’s just posturing, with clear support from tik tok heads. That’s it for now.	politics	Thu Jan 23 2025 13:01:03 GMT+0000 (Coordinated Universal Time)	1i819em	thrillafrommanilla_1	1	True	Thu Jan 17 2019 23:50:19 GMT+0000 (Coordinated Universal Time)		92	23127	23219	21	nan	Is Trump's order to allow TikTok to continue operating in the U.S. even legal?	0.9	21	Thu Jan 23 2025 11:26:36 GMT+0000 (Coordinated Universal Time)
m8psy97	1	Well I’m a software developer who works in cybersecurity. So I don’t work with voting machines per say. But I can tell you that star link intercepting voter data and changing it is pretty easy to defend against. If spacex could change voter data like that so could Verizon wireless or Comcast. In mo…	politics	Thu Jan 23 2025 13:00:54 GMT+0000 (Coordinated Universal Time)	1i7p1vu	Possible_Inspector52	1	True	Tue Jan 14 2025 21:26:54 GMT+0000 (Coordinated Universal Time)		279	113	392	336	nan	Elon Musk believes he got Trump elected. Now he’s coming for Europe	0.9	336	Wed Jan 22 2025 23:16:43 GMT+0000 (Coordinated Universal Time)
m8psxwe	1	No, you didn't.	politics	Thu Jan 23 2025 13:00:50 GMT+0000 (Coordinated Universal Time)	1i80yfm	terrasig314	1	True	Wed May 24 2023 21:30:39 GMT+0000 (Coordinated Universal Time)		1	77883	77884	328	nan	Donald Trump's war on DEI is not about "merit": Executive orders attacking DEI are about promoting unqualified white men over diverse candidates	0.92	328	Thu Jan 23 2025 11:05:25 GMT+0000 (Coordinated Universal Time)
m8psx7f	1	You don't mind sharing a concentration camp?	politics	Thu Jan 23 2025 13:00:43 GMT+0000 (Coordinated Universal Time)	1i80yfm	zappariah_brannigan	1	True	Thu May 16 2024 13:43:06 GMT+0000 (Coordinated Universal Time)		14	19773	19787	328	nan	Donald Trump's war on DEI is not about "merit": Executive orders attacking DEI are about promoting unqualified white men over diverse candidates	0.92	328	Thu Jan 23 2025 11:05:25 GMT+0000 (Coordinated Universal Time)
m8pswx8	1	We all could do do that. Like this is really bad for biden since it's too long to read	politics	Thu Jan 23 2025 13:00:39 GMT+0000 (Coordinated Universal Time)	1i7ropy	bobolly	1	True	Thu Aug 15 2013 21:13:54 GMT+0000 (Coordinated Universal Time)		2769	10447	13216	106	nan	Trump Seeks to Paralyze Independent Privacy and Civil Liberties Watchdog	0.87	106	Thu Jan 23 2025 01:18:26 GMT+0000 (Coordinated Universal Time)
m8pswjr	1	Ok	politics	Thu Jan 23 2025 13:00:35 GMT+0000 (Coordinated Universal Time)	1i819em	gelatineous	1	True	Wed Jan 24 2024 01:28:14 GMT+0000 (Coordinated Universal Time)		1	6580	6581	21	nan	Is Trump's order to allow TikTok to continue operating in the U.S. even legal?	0.9	21	Thu Jan 23 2025 11:26:36 GMT+0000 (Coordinated Universal Time)
m8psvsz	1	Dude literally struck down an EO to allow places to discriminate against you based off age, sec, gender identity, religion. At least at a federal level https://www.nbcnews.com/news/amp/rcna188839	democrats	Thu Jan 23 2025 13:00:27 GMT+0000 (Coordinated Universal Time)	1i7rxc2	Roach-_-_	1	True	Sun Sep 22 2024 18:03:51 GMT+0000 (Coordinated Universal Time)		1	16067	16068	69	nan	Controversial Trump Policies Face Criticism From Democrats	0.94	69	Thu Jan 23 2025 01:30:05 GMT+0000 (Coordinated Universal Time)
m8psvhj	1	Thank you for participating in /r/Politics. Your submission has been removed because it has already been submitted.	politics	Thu Jan 23 2025 13:00:23 GMT+0000 (Coordinated Universal Time)	1i7zxjc	politics-ModTeam	1	True	Mon Aug 29 2022 12:42:20 GMT+0000 (Coordinated Universal Time)		1	3	4	18	nan	Trump administration directs federal health agencies to pause communications	0.86	18	Thu Jan 23 2025 09:51:17 GMT+0000 (Coordinated Universal Time)


CREATE TABLE reddit_opinion_republican (
  "comment_id" VARCHAR,
  "score" BIGINT,
  "self_text" VARCHAR,
  "subreddit" VARCHAR,
  "created_time" TIMESTAMP,
  "post_id" VARCHAR,
  "author_name" VARCHAR,
  "controversiality" BIGINT,
  "ups" BIGINT,
  "downs" BIGINT,
  "user_is_verified" VARCHAR,
  "user_account_created_time" TIMESTAMP,
  "user_awardee_karma" DOUBLE,
  "user_awarder_karma" DOUBLE,
  "user_link_karma" DOUBLE,
  "user_comment_karma" DOUBLE,
  "user_total_karma" DOUBLE,
  "post_score" BIGINT,
  "post_self_text" VARCHAR,
  "post_title" VARCHAR,
  "post_upvote_ratio" DOUBLE,
  "post_thumbs_ups" BIGINT,
  "post_total_awards_received" BIGINT,
  "post_created_time" TIMESTAMP
);