Dataset: Instgram 🔥📷🤳

About this Dataset

Instgram 🔥📷🤳

Indeed, Instagram is one of the most popular social media platforms worldwide. It was launched in October 2010 and quickly gained immense popularity, especially among younger users. As of my last knowledge update in September 2021, Instagram is owned by Meta Platforms, Inc. (formerly known as Facebook, Inc.).

Key Features of Instagram:

Photo and Video Sharing: Instagram allows users to share photos and videos with their followers. Users can apply various filters, edit images, and use creative tools to enhance their posts.
Stories: Instagram Stories are short-lived photos and videos that disappear after 24 hours. Stories provide a more casual and ephemeral way for users to share moments with their followers.
IGTV (Instagram TV): IGTV is a feature within Instagram that enables users and businesses to share longer vertical videos, allowing for more in-depth content.
Explore Page: The Explore page suggests content based on a user's interests and the accounts they follow. It helps users discover new content, accounts, and trends.
Direct Messaging: Instagram has a built-in messaging feature, allowing users to send private messages, photos, and videos to individuals or groups.
Followers and Following: Users can follow other accounts to see their posts in their feed. Likewise, they can be followed by other users, who will see their posts in their followers' feeds.
Business Profiles: Instagram offers features specifically designed for businesses, such as business profiles, insights, and advertising options.
Hashtags: Hashtags play a crucial role on Instagram. Users can add relevant hashtags to their posts to make them discoverable to a broader audience interested in specific topics.
Explore Live: Instagram allows users to watch live streams from accounts they follow or explore live broadcasts from around the world.
Reels: Instagram Reels are short, entertaining videos with music or audio that users can create and share on their profiles.

Instagram's simple and visually engaging interface, combined with its extensive range of features, has contributed to its widespread popularity across various age groups and demographics. It has become a significant platform for individuals, influencers, businesses, and brands to connect with their audiences, share content, and build communities. Please note that since my knowledge is not up-to-date, there may have been additional developments or changes on Instagram beyond September 2021.

Tables

Follows

@kaggle.bhanupratapbiswas_instgram.follows

7.21 KB
7623 rows
5 columns


CREATE TABLE follows (
  "follower" BIGINT,
  "followee" BIGINT,
  "created_time" VARCHAR,
  "is_follower_active" BIGINT,
  "followee_acc_status" VARCHAR
);

Likes

@kaggle.bhanupratapbiswas_instgram.likes

15.66 KB
8782 rows
5 columns


CREATE TABLE likes (
  "user" BIGINT,
  "photo" BIGINT,
  "created_time" VARCHAR,
  "following_or_not" VARCHAR,
  "like_type" VARCHAR
);

Photo Tags

@kaggle.bhanupratapbiswas_instgram.photo_tags

4.43 KB
501 rows
3 columns


CREATE TABLE photo_tags (
  "photo" BIGINT,
  "tag_id" BIGINT,
  "user_id" BIGINT
);

Users

@kaggle.bhanupratapbiswas_instgram.users

7.88 KB
100 rows
6 columns


CREATE TABLE users (
  "id" BIGINT,
  "name" VARCHAR,
  "created_time" VARCHAR,
  "private_public" VARCHAR,
  "post_count" BIGINT,
  "verified_status" VARCHAR
);

Photos

@kaggle.bhanupratapbiswas_instgram.photos

9.55 KB
257 rows
6 columns


CREATE TABLE photos (
  "id" BIGINT,
  "image_link" VARCHAR,
  "user_id" BIGINT,
  "created_dat" VARCHAR,
  "insta_filter_used" VARCHAR,
  "photo_type" VARCHAR
);

Comments

@kaggle.bhanupratapbiswas_instgram.comments

142.54 KB
7488 rows
8 columns


CREATE TABLE comments (
  "id" BIGINT,
  "comment" VARCHAR,
  "user_id" BIGINT,
  "photo_id" BIGINT,
  "created_timestamp" VARCHAR,
  "posted_date" VARCHAR,
  "emoji_used" VARCHAR,
  "hashtags_used_count" BIGINT
);