COVID19 Tweets
Tweets with the hashtag #covid19
@kaggle.gpreda_covid19_tweets
Covid19 Tweets
@kaggle.gpreda_covid19_tweets.covid19_tweets
- 36.94 MB
- 179108 rows
- 13 columns
user_nameUser Name | user_locationUser Location | user_descriptionUser Description | user_createdUser Created | user_followersUser Followers | user_friendsUser Friends | user_favouritesUser Favourites | user_verifiedUser Verified | dateDate | textText | hashtagsHashtags | sourceSource | is_retweetIs Retweet |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ᏉᎥ☻լꂅϮ | astroworld | wednesday addams as a disney princess keepin it [̲̅$̲̅(̲̅ιοο̲̅)̲̅$̲̅] 👸🏻💚♊️🧀🌵🌃🌙 | Fri May 26 2017 05:46:42 GMT+0000 (Coordinated Universal Time) | 624 | 950 | 18775 | Sat Jul 25 2020 12:27:21 GMT+0000 (Coordinated Universal Time) | If I smelled the scent of hand sanitizers today on someone in the past, I would think they were so intoxicated that… https://t.co/QZvYbrOgb0 | nan | Twitter for iPhone | ||
| Tom Basile 🇺🇸 | New York, NY | Husband, Father, Columnist & Commentator. Author of Tough Sell: Fighting the Media War in Iraq. Bush Admin Alum. Newsmax Contributor. Fmr Exec Dir NYSGOP | Thu Apr 16 2009 20:06:23 GMT+0000 (Coordinated Universal Time) | 2253 | 1677 | 24 | true | Sat Jul 25 2020 12:27:17 GMT+0000 (Coordinated Universal Time) | Hey @Yankees @YankeesPR and @MLB - wouldn't it have made more sense to have the players pay their respects to the A… https://t.co/1QvW0zgyPu | nan | Twitter for Android | |
| Time4fisticuffs | Pewee Valley, KY | #Christian #Catholic #Conservative #Reagan #Republican #Capitalist; Sports lover - #BBN #Cincinnati #Reds #Bengals #Trump2020 | Sat Feb 28 2009 18:57:41 GMT+0000 (Coordinated Universal Time) | 9275 | 9525 | 7254 | Sat Jul 25 2020 12:27:14 GMT+0000 (Coordinated Universal Time) | @diane3443 @wdunlap @realDonaldTrump Trump never once claimed #COVID19 was a hoax. We all claim that this effort to… https://t.co/Jkk8vHWHb3 | ['COVID19'] | Twitter for Android | ||
| ethel mertz | Stuck in the Middle | #Browns #Indians #ClevelandProud #[]_[] #Cavs #Resist | Thu Mar 07 2019 01:45:06 GMT+0000 (Coordinated Universal Time) | 197 | 987 | 1488 | Sat Jul 25 2020 12:27:10 GMT+0000 (Coordinated Universal Time) | @brookbanktv The one gift #COVID19 has give me is an appreciation for the simple things that were always around me… https://t.co/Z0pOAlFXcW | ['COVID19'] | Twitter for iPhone | ||
| DIPR-J&K | Jammu and Kashmir | 🖊️Official Twitter handle of Department of Information and Public Relations, Govt of Jammu & Kashmir | Sun Feb 12 2017 06:45:15 GMT+0000 (Coordinated Universal Time) | 101009 | 168 | 101 | Sat Jul 25 2020 12:27:08 GMT+0000 (Coordinated Universal Time) | 25 July : Media Bulletin on Novel #CoronaVirusUpdates #COVID19 @kansalrohit69 @DrSyedSehrish @airnewsalerts @ANI… https://t.co/MN0EEcsJHh | ['CoronaVirusUpdates', 'COVID19'] | Twitter for Android | ||
| 🎹 Franz Schubert | Новоро́ссия | 🎼 #Новоро́ссия #Novorossiya #оставайсядома #STAYatHOME Polymath, composer, English. | Mon Mar 19 2018 16:29:52 GMT+0000 (Coordinated Universal Time) | 1180 | 1071 | 1287 | Sat Jul 25 2020 12:27:06 GMT+0000 (Coordinated Universal Time) | #coronavirus #covid19 deaths continue to rise. It's almost as bad as it ever was. Politicians and businesses want… https://t.co/hXMHooXX2C | ['coronavirus', 'covid19'] | Twitter Web App | ||
| hr bartender | Gainesville, FL | Workplace tips and advice served up in a friendly place. Corporate blog of @ITMGroup by @Sharlyn_Lauby. Cheers! | Tue Aug 12 2008 18:19:49 GMT+0000 (Coordinated Universal Time) | 79956 | 54810 | 3801 | Sat Jul 25 2020 12:27:03 GMT+0000 (Coordinated Universal Time) | How #COVID19 Will Change Work in General (and recruiting, specifically) via/ @ProactiveTalent #Recruiting… https://t.co/bjZxzGPMbK | ['COVID19', 'Recruiting'] | Buffer | ||
| Derbyshire LPC | nan | nan | Fri Feb 03 2012 18:08:10 GMT+0000 (Coordinated Universal Time) | 608 | 355 | 95 | Sat Jul 25 2020 12:27:00 GMT+0000 (Coordinated Universal Time) | You now have to wear face coverings when out shopping - this includes a visit to your local Community Pharmacy… https://t.co/OSu5Q4kdd7 | nan | TweetDeck | ||
| Prathamesh Bendre | nan | A poet, reiki practitioner and a student of law. | Sat Apr 25 2015 08:15:41 GMT+0000 (Coordinated Universal Time) | 25 | 29 | 18 | Sat Jul 25 2020 12:26:59 GMT+0000 (Coordinated Universal Time) | Praying for good health and recovery of @ChouhanShivraj . #covid19 #covidPositive | ['covid19', 'covidPositive'] | Twitter for Android | ||
| Member of Christ 🇨🇳🇺🇸🇮🇳🇮🇩🇧🇷🇳🇬🇧🇩🇷🇺 | 👇🏻location at link below👇🏻 | Just as the body is one & has many members, & all the members of the body, though many, are one body, so it is with Christ. 1 Corinthians 12:12 | Sun Aug 17 2014 04:53:22 GMT+0000 (Coordinated Universal Time) | 55201 | 34239 | 29802 | Sat Jul 25 2020 12:26:54 GMT+0000 (Coordinated Universal Time) | POPE AS GOD - Prophet Sadhu Sundar Selvaraj. Watch here at https://t.co/7X5RTyKVji #HurricaneHanna #COVID19… https://t.co/06dZcGUnwL | ['HurricaneHanna', 'COVID19'] | Twitter for iPhone |
CREATE TABLE covid19_tweets (
"user_name" VARCHAR,
"user_location" VARCHAR,
"user_description" VARCHAR,
"user_created" TIMESTAMP,
"user_followers" BIGINT,
"user_friends" BIGINT,
"user_favourites" BIGINT,
"user_verified" BOOLEAN,
"date" TIMESTAMP,
"text" VARCHAR,
"hashtags" VARCHAR,
"source" VARCHAR,
"is_retweet" BOOLEAN
);