Step 5: The tool fetches the thumbnail of the video, and you also get a lot of video resolutions. Step 4: You have to paste the copied URL of Twitter video post in the space and hit enter or search button on the website. Step 3: Go to Download4Twitter in another browser tab. Step 2: Copy the link of the Twitter post. I try to accommodate data from Twitter search API as much as possible, the data which might be useful for text analysis or anything.Īfter the database set, now we can write our Python 3 code to scrape and save tweets.Step 1: Go to your web browser, and visit that Twitter post, where the video was uploaded. There are so many data that we could retrieve from Twitter API, but I didn’t save it all. CREATE TABLE `tweet` ( `id` int(11) NOT NULL, `search_val` varchar(60) NOT NULL, `created_at` text, `tweet_id` text, `text` text, `source` text, `in_reply_to_status_id` text, `in_reply_to_user_id` text, `in_reply_to_screen_name` text, `user_name` text, `user_screen_name` text, `user_location` text, `user_url` text, `user_description` text, `user_verified` tinyint(1) DEFAULT NULL, `user_followers_count` int(11) DEFAULT NULL, `user_friends_count` int(11) DEFAULT NULL, `user_listed_count` int(11) DEFAULT NULL, `user_favourites_count` int(11) DEFAULT NULL, `user_created_at` text, `user_id` varchar(50) DEFAULT NULL, `user_profile_image_url_https` text, `coordinates_lat` text, `coordinates_lon` text, `place_country` text, `place_country_code` text, `place_full_name` text, `place_id` varchar(50) DEFAULT NULL, `place_type` varchar(30) DEFAULT NULL, `quoted_status_id` varchar(50) DEFAULT NULL, `quoted_status` text, `retweeted_status` text, `quote_count` int(11) DEFAULT NULL, `reply_count` int(11) DEFAULT NULL, `retweet_count` int(11) DEFAULT NULL, `favorite_count` int(11) DEFAULT NULL, `retweeted` tinyint(1) DEFAULT NULL, `entities` text, `lang` varchar(30) DEFAULT NULL, `feeds_link` text, `feeds_video` text, `feeds_image` text, `created_date` datetime DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Following is the SQL to create the table. I create a new database called social_media and create a table called tweet to store the data. First of all, of course, we must prepare the database (MySQL) to save the data later.

Save tweet