Identifying Influential Bloggers: Techcrunch
Combining productivity and influence in a blog community
@kaggle.lakritidis_identifying_influential_bloggers_techcrunch
Combining productivity and influence in a blog community
@kaggle.lakritidis_identifying_influential_bloggers_techcrunch
CREATE TABLE authors (
"n_1" BIGINT,
"jason_kincaid" VARCHAR,
"n_43" BIGINT,
"n_43_1" BIGINT,
"n_4_257910" DOUBLE,
"n_5_858018" DOUBLE
);
CREATE TABLE comments (
"n_1" BIGINT,
"n_1_1" BIGINT,
"seemed_to_work_fine" VARCHAR,
"bj_cook" VARCHAR,
"n_2010_04_01" TIMESTAMP,
"n_1_2" BIGINT
);
CREATE TABLE inlinks (
"n_319895" BIGINT,
"n_19464" BIGINT,
"popular_blogs_and_their_first_post" VARCHAR,
"alex" VARCHAR,
"n_2009_06_17" TIMESTAMP,
"http_feeds_notaniche_com_r_afrison_3_hxarxfintem" VARCHAR
);
CREATE TABLE posts (
"n_1" BIGINT,
"we_just_tested_twitter_8217_s_anywhere_platform_screenshots" VARCHAR,
"jason_kincaid" VARCHAR,
"n_1_1" BIGINT,
"n_14" BIGINT,
"during_his_keynote_at_sxsw_last_month_twitter_ceo_evan_dc85c240" VARCHAR,
"http_techcrunch_com_2010_04_01_we_just_tested_twitters_711e7eeb" VARCHAR,
"n_2010_04_01" TIMESTAMP,
"n_0" BIGINT,
"n_14_1" BIGINT,
"n_314" BIGINT,
"n_223" BIGINT,
"n_4_130293" DOUBLE,
"n_5_686099" DOUBLE,
"n_0_00000" DOUBLE,
"n_0_00000_1" DOUBLE
);
Anyone who has the link will be able to view this.