Socialmedia

A Diverse Snapshot of Social Media Users and Engagements

@kaggle.anoopjohny_socialmedia

Table List

1 table(27.11 KB)

Socialmedia

@kaggle.anoopjohny_socialmedia.socialmedia

27.11 KB
39 rows
28 columns

user_id User ID	username Username	platform Platform	post_id Post ID	post_text Post Text	post_timestamp Post Timestamp	likes_reactions Likes/Reactions	comments Comments	shares_retweets Shares/Retweets	hashtags Hashtags	media_type Media Type	media_url Media URL	post_url Post URL	location Location	privacy_settings Privacy Settings	user_followers User Followers	user_following User Following	account_creation_date Account Creation Date	account_verification Account Verification	user_engagement User Engagement	user_interactions User Interactions	user_activity User Activity	user_bio User Bio	user_description_1 User Description 1	user_description_2 User Description 2	server_post Server Post	user_language User Language
101	@adventureSeeker	Instagram	82036	"Experiencing the thrill of a lifetime! #AdventureTime"	30-07-2023 14:45	1500	250	120	#AdventureTime	Image	http://example.com/adventure.jpg	http://instagram.com/adventureSeeker/82036	Yosemite National Park	Public	15000	500	10-05-2019	Verified	1870	15700	3 posts per week	Adventure enthusiast	Nature lover	Seeker of wanderlust ??	California, USA	English
215	@foodieTraveler	Twitter	12463	"Indulging in local delicacies! #FoodieTravels"	30-07-2023 19:30	850	70	50	#FoodieTravels	Text	nan	http://twitter.com/foodieTraveler/12463	Bangkok, Thailand	Public	8000	300	15-09-2017	Not verified	970	8300	5 posts per week	Culinary explorer	Street food connoisseur	Travel addict ??	London, UK	English
303	@wellnessJourney	Facebook	45982	"Finding peace and balance in nature!	30-07-2023 08:15	680	80	40	#WellnessJourney	Image	http://example.com/wellness.jpg	http://facebook.com/wellnessJourney/45982	Bali, Indonesia	Public	6000	200	02-03-2020	Not verified	800	6200	2 posts per week	Wellness enthusiast	Yogi in training	Mindfulness advocate	San Francisco, USA	English
404	@fitnessFreak	Instagram	16572	"Pushing my limits in the gym!	30-07-2023 12:30	1850	350	180	#FitnessGoals	Image	http://example.com/fitness.jpg	http://instagram.com/fitnessFreak/16572	Los Angeles, USA	Public	32000	400	12-08-2016	Verified	2380	32750	4 posts per week	Fitness enthusiast	Health is wealth	Workout addict	Los Angeles, USA	English
521	@foodExplorer	Twitter	75589	"Discovering unique flavors around the world!	30-07-2023 16:20	950	80	60	#Foodies	Text	nan	http://twitter.com/foodExplorer/75589	Paris, France	Public	7200	1800	28-02-2018	Not verified	1090	9080	3 posts per week	Culinary adventurer	Gastronomic traveler	Bon app?it!	Paris, France	English
609	@wanderlustSoul	Facebook	24680	"Embracing the beauty of nature!	30-07-2023 09:45	1200	110	50	#Wanderlust	Image	http://example.com/wanderlust.jpg	http://facebook.com/wanderlustSoul/24680	Bali, Indonesia	Friends Only	9500	650	05-09-2019	Not verified	1360	10850	2 posts per week	Traveler at heart ??	Nature lover	Free spirit	Bali, Indonesia	English
712	@techGeek	Twitter	36901	"Exploring the latest tech innovations!	30-07-2023 11:10	550	40	30	#TechNews	Text	nan	http://twitter.com/techGeek/36901	San Francisco, USA	Public	6500	300	18-01-2021	Not verified	620	6850	1 post per day	Tech enthusiast	Geek by choice	Futurist	San Francisco, USA	English
825	@petWhisperer	Instagram	98342	"Connecting with furry friends!	30-07-2023 15:55	2200	320	200	#PetLove	Image	http://example.com/pet.jpg	http://instagram.com/petWhisperer/98342	New York City, USA	Public	18500	1000	29-03-2022	Verified	2720	21600	2 posts per week	Animal lover	Cat whisperer	Pet advocate	New York City, USA	English
926	@bookwormLife	Facebook	57481	"Diving into the magical world of books!	30-07-2023 17:30	780	60	40	#BookNerd	Image	http://example.com/book.jpg	http://facebook.com/bookwormLife/57481	London, UK	Public	8200	700	20-09-2018	Not verified	880	9620	4 posts per week	Bibliophile	Literature lover	Word devourer	London, UK	English
104	@foodPhotog	Instagram	20589	"Capturing delicious moments!	30-07-2023 12:15	1100	120	80	#FoodPhotography	Image	http://example.com/food.jpg	http://instagram.com/foodPhotog/20589	Paris, France	Friends Only	5000	400	05-12-2017	Verified	1300	5700	3 posts per week	Foodie by heart	Gastronomy explorer	Cuisine critic	Paris, France	English


CREATE TABLE socialmedia (
  "user_id" BIGINT,
  "username" VARCHAR,
  "platform" VARCHAR,
  "post_id" BIGINT,
  "post_text" VARCHAR,
  "post_timestamp" VARCHAR,
  "likes_reactions" BIGINT,
  "comments" BIGINT,
  "shares_retweets" BIGINT,
  "hashtags" VARCHAR,
  "mentions" VARCHAR,
  "media_type" VARCHAR,
  "media_url" VARCHAR,
  "post_url" VARCHAR,
  "location" VARCHAR,
  "privacy_settings" VARCHAR,
  "user_followers" BIGINT,
  "user_following" BIGINT,
  "account_creation_date" VARCHAR,
  "account_verification" VARCHAR,
  "user_engagement" BIGINT,
  "user_interactions" BIGINT,
  "user_activity" VARCHAR,
  "user_bio" VARCHAR,
  "user_description_1" VARCHAR,
  "user_description_2" VARCHAR,
  "server_post" VARCHAR,
  "user_language" VARCHAR
);