Database Description

This database captures a comprehensive set of attributes related to tweets about transportation in Montreal. Each entry in the database represents a single tweet and includes a diverse range of information about it, the user who created it, and any related interactions.

Key Fields:

• avatar: The avatar of the user who created the post.
• fullname: The full name of the user.
• id: Unique identifier for the post.
• images/0-3: URLs or references to up to four images associated with the post.
• isQuote: Boolean indicating whether the post is a quote.
• isRetweet: Boolean indicating whether the post is a retweet.
• likes: Number of likes received by the post.
• links/0-28: URLs or references to up to 29 links shared in the post.
• quotedTweet/avatar: The avatar of the user whose tweet is quoted.
• quotedTweet/fullname: The full name of the user whose tweet is quoted.
• quotedTweet/images/0-3: URLs or references to up to four images associated with the quoted tweet.
• quotedTweet/links/0-7: URLs or references to up to eight links shared in the quoted tweet.
• quotedTweet/text: Text content of the quoted tweet.
• quotedTweet/timestamp: Timestamp of the quoted tweet.
• quotedTweet/url: URL of the quoted tweet.
• quotedTweet/username: Username of the user whose tweet is quoted.
• quotes: Number of times the post has been quoted.
• replies: Number of replies received by the post.
• retweets: Number of times the post has been retweeted.
• searchQuery: The search query used to retrieve the post.
• text: Text content of the post.
• timestamp: Timestamp of the post.
• url: URL associated with the post.
• user/avatar: The avatar of the user who created the post.
• user/description: Description or bio of the user.
• user/joinDate: Join date of the user.
• user/location: Location information of the user.
• user/totalFollowers: Total number of followers for the user.
• user/totalFollowing: Total number of users the user is following.
• user/totalLikes: Total number of likes received by the user.
• user/totalTweets: Total number of tweets posted by the user.
• user/url: URL associated with the user.
• user/userFullName: Full name of the user.
• user/username: Username of the user.
• user/verified: Boolean indicating whether the user is verified.
• user/website: Website associated with the user.
• username: Username of the user who created the post.
• verified: Boolean indicating whether the post author is verified.

This database structure allows for detailed analysis and exploration of social media interactions, user behaviors, and content trends.