Top 10 Tech Subreddits
A comprehensive look at posts and comments of tech subreddits
@kaggle.mohamedkhaledelsafty_top_10_tech_subreddits
A comprehensive look at posts and comments of tech subreddits
@kaggle.mohamedkhaledelsafty_top_10_tech_subreddits
CREATE TABLE apple (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE buildapc (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE buildapcsales (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE combined_subreddits (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE futurology (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE gadgets (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE programmerhumor (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE sysadmin (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE tech (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE technews (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
CREATE TABLE technology (
"title" VARCHAR,
"score" BIGINT,
"id" VARCHAR,
"subreddit" VARCHAR,
"url" VARCHAR,
"num_comments" BIGINT,
"body" VARCHAR,
"ups" BIGINT,
"downs" BIGINT,
"post_comments" VARCHAR
);
Anyone who has the link will be able to view this.