MLB Social Media Dataset
MLB teams social media accounts
@kaggle.igalbronshtein_mlb_social_media_dataset
MLB teams social media accounts
@kaggle.igalbronshtein_mlb_social_media_dataset
Created as supplementary to the dataset of the competition “MLB Player Digital Engagement Forecasting”. I assume that data from social media accounts of the teams, can give additional useful insights about funs engagement. The data were collected manually from the web. Mainly from teams social media accounts and from sites: mlb.com/team, socialblade.com, socialtracker.io.
Cover image: unsplash.com/photos/l1TP3s9clLE
CREATE TABLE teams (
"id" BIGINT,
"team" VARCHAR,
"twitter" VARCHAR,
"t_joined" VARCHAR,
"t_following" BIGINT,
"t_followers" VARCHAR,
"t_tweets" BIGINT,
"t_cover_people" VARCHAR,
"tweets_30_days" BIGINT,
"pinned_tweet" VARCHAR,
"instagram" VARCHAR,
"i_posts" BIGINT,
"i_followers" VARCHAR,
"i_following" BIGINT,
"i_av_likes" BIGINT,
"i_av_comments" BIGINT,
"youtube" VARCHAR,
"y_subscribers" VARCHAR,
"user_created" VARCHAR,
"y_uploads" BIGINT,
"facebook" VARCHAR,
"f_likes" VARCHAR,
"f_follow" VARCHAR,
"tiktok" VARCHAR,
"tik_following" VARCHAR,
"tik_followers" VARCHAR,
"tik_likes" VARCHAR,
"tiktok_verified" VARCHAR,
"pinterest" VARCHAR,
"pinterest_followers" BIGINT,
"pinterest_following" BIGINT,
"pinterest_verified" VARCHAR
);Anyone who has the link will be able to view this.