MLB Social Media Dataset

MLB teams social media accounts

@kaggle.igalbronshtein_mlb_social_media_dataset

Table List

1 table(27.77 KB)

Teams

@kaggle.igalbronshtein_mlb_social_media_dataset.teams

27.77 KB
30 rows
32 columns

id Id	team Team	twitter Twitter	t_joined T Joined	t_following T Following	t_followers T Followers	t_tweets T Tweets	t_cover_people T Cover People	tweets_30_days Tweets 30 Days	pinned_tweet Pinned Tweet	instagram Instagram	i_posts I Posts	i_followers I Followers	i_following I Following	i_av_likes I Av Likes	i_av_comments I Av Comments	youtube Youtube	y_subscribers Y Subscribers	user_created User Created	y_uploads Y Uploads	facebook Facebook	f_likes F Likes	f_follow F Follow	tiktok Tiktok	tik_following Tik Following	tik_followers Tik Followers	tik_likes Tik Likes	tiktok_verified Tiktok Verified	pinterest Pinterest	pinterest_followers Pinterest Followers	pinterest_following Pinterest Following	pinterest_verified Pinterest Verified
108	Los Angeles Angels	https://twitter.com/Angels	May 11th, 2009	221	1.1M	43761	x	227	v	https://www.instagram.com/angels	9589	879k	146	46219	397	https://www.youtube.com/channel/UCS7H_WWPj5_qfD-zoUzuX2A	27.5K	Sep 21st, 2015	85	https://www.facebook.com/Angels	1300056	1255976	https://www.tiktok.com/@angels	29	48K	135.4K	v	/angelsbaseball	3991		x
109	Arizona Diamondbacks	https://twitter.com/Dbacks	Apr 14th, 2009	6424	593.3K	108654	v	337	v	https://instagram.com/dbacks	10038	385k	671	8624	80	https://www.youtube.com/channel/UCxeK534L7DDIwPFv_o9CZjw	18.4K	Aug 18th, 2015	292	https://www.facebook.com/Dbacks	758454	728811	https://www.tiktok.com/@dbacks	5	97.3K	728.9K	v	/dbacks	2554		x
110	Baltimore Orioles	https://twitter.com/Orioles	May 11th, 2009	103	785.1K	45072	xv	300	v	https://www.instagram.com/Orioles	6941	440k	79	9656	92	https://www.youtube.com/channel/UC2jqf9lgDjMUtTow1Q4IKzg	12.7K	Aug 18th, 2015	496	https://www.facebook.com/Orioles	1218352	1168844	https://www.tiktok.com/@orioles	32	82.9K	1.2M	v	/oriolesbaseball	5227	50	x
111	Boston Red Sox	https://twitter.com/RedSox	May 18th, 2009	237	2.1M	96632	v	723	v	https://instagram.com/redsox	11205	1.9m	137	65336	357	https://www.youtube.com/redsox	64.5K	Aug 18th, 2015	643	https://www.facebook.com/RedSox	5132586	4818683	https://www.tiktok.com/@redsox	17	393K	6.2M	v	/bostonredsox	11843	54	x
112	Chicago Cubs	https://twitter.com/Cubs	May 19th, 2009	944	2.5M	88088	x	565	x	https://www.instagram.com/cubs	7625	1.7m	399	50105	500	https://www.youtube.com/channel/UCnU7B7B0U0t2vs-2HMLjgvg	191K	Aug 18th, 2015	411	https://www.facebook.com/Cubs	3363521	3242536	https://www.tiktok.com/@cubs	171	553.5K	9.1M	v	/cubsbaseball	1077066	38	x
113	Cincinnati Reds	https://twitter.com/Reds	Apr 24th, 2009	399	878.1K	69770	v	415	x	https://www.instagram.com/reds	11402	504k	237	22027	162	https://www.youtube.com/channel/UCENXPJrzbHXudxhURfk5NCg	12.4K	Aug 18th, 2015	264	https://www.facebook.com/Reds	1235526	1183120	https://www.tiktok.com/@reds	36	233.4K	4.3M	v	/redsbaseball	4729	33	x
114	Cleveland Indians	https://twitter.com/Indians	Jul 1st, 2009	294	1M	98787	v	354	x	https://www.instagram.com/indians	6746	606k	174	10498	90	https://www.youtube.com/channel/UCpI50OSBxxalmRZRq4gtRDw	13K	Aug 18th, 2015	240	https://www.facebook.com/Indians	1330977	1272910	https://www.tiktok.com/@clevelandindians	65	2758	3088	x	/indiansbaseball	4131	11	x
115	Colorado Rockies	https://twitter.com/Rockies	Jun 24th, 2010	301	587.3K	130920	x	494	x	https://www.instagram.com/rockies	8549	449k	126	12584	88	https://www.youtube.com/channel/UCBci3py0IfkjkjPKDE-B6Bw	10K	Aug 18th, 2015	183	https://www.facebook.com/Rockies	909914	861949	https://www.tiktok.com/@rockies	125	43.8K	246K	v	/coloradorockies	3288	33	x
116	Detroit Tigers	https://twitter.com/tigers	Apr 9th, 2009	915	1.4M	69834	x	723	v	https://www.instagram.com/tigers	6087	733k	257	14627	132	https://www.youtube.com/channel/UCKKG465DFaJ3Yp-jQHA3jhw	13.6K	Aug 18th, 2015	497	https://www.facebook.com/Tigers	2272846	2130094	https://www.tiktok.com/@tigers	42	111.1K	859.6K	v	/tigersbaseball	8345	36	x
117	Houston Astros	https://twitter.com/astros	Jul 1st, 2009	741	1.5M	78752	x	310	v	https://www.instagram.com/astrosbaseball	9917	1.1m	158	29317	202	https://www.youtube.com/channel/UC3RPfeyaEIPosC4eIcNr4Gw	30.4K	Aug 12th, 2015	225	https://www.facebook.com/Astros	1406350	1401056	not_found	not_found	nan	nan	nan	/houstonastros	3746	30	x


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
);