#Charlottesville On Twitter
A snapshot of American history in the making
@kaggle.vincela9_charlottesville_on_twitter
Table List
- 5 tables(46.71 MB)
Aug16 Sample
@kaggle.vincela9_charlottesville_on_twitter.aug16_sample
- 11.21 MB
- 50000 rows
- 24 columns
idId | user_idUser Id | user_nameUser Name | screen_nameScreen Name | user_statuses_countUser Statuses Count | user_favorites_countUser Favorites Count | friends_countFriends Count | followers_countFollowers Count | user_locationUser Location | user_descriptionUser Description | user_time_zoneUser Time Zone | user_profile_text_colorUser Profile Text Color | user_profile_background_colorUser Profile Background Color | full_textFull Text | created_atCreated At | is_retweetIs Retweet | retweeted_status_textRetweeted Status Text | retweeted_status_idRetweeted Status Id | quoted_status_textQuoted Status Text | quoted_status_idQuoted Status Id | in_reply_to_screen_nameIn Reply To Screen Name | in_reply_to_status_idIn Reply To Status Id | in_reply_to_user_idIn Reply To User Id | hashtagsHashtags |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 897931319417516032 | 4516278501 | Oscrape | Officialoscrape | 280559 | 151 | 1797 | 1546 | Universe | visit http://oscrape.com to gather all the gists and news in the world all to yourself | West Central Africa | 333333 | F5F8FA | Trump stands by remarks on Charlottesville: 'George Washington was a slave owner' https://t.co/O14RvYkEaZ | Wed Aug 16 2017 21:21:23 GMT+0000 (Coordinated Universal Time) | f | nan | nan | nan | |||||
| 897811531626409984 | 256184059 | Twitcher ❦ | syqau | 258131 | 18663 | 13071 | 17496 | USA | INDEPENDENT TAKE from utmost ubiquitous side of equation… 🇺🇸 | Hawaii | 000000 | 000000 | Late-night hosts blast Trump over VA response https://t.co/QuHD2MYcKn | Wed Aug 16 2017 13:25:24 GMT+0000 (Coordinated Universal Time) | f | nan | nan | nan | |||||
| 898026991848259585 | 292597626 | e.p.dowd | thebreezypoint | 23723 | 1962 | 2480 | 1287 | KCMO East Bottoms | nan | nan | 333333 | C0DEED | @LouDobbs -Both far left & right wing nuts are playing right into the hands of the Media puppeteers-media largest group in Charlottesville | Thu Aug 17 2017 03:41:34 GMT+0000 (Coordinated Universal Time) | f | nan | LouDobbs | 26487169 | nan | ||||
| 898006157519970304 | 117543259 | Miz Schweizenheimer | erika_ess | 32516 | 49225 | 1729 | 680 | nan | politics, culture, food, journalism, tarot, gofishtarot | Quito | 3C3940 | 3B94D9 | Man, it took all this to bring that track back🤔 #hippiebeats #thisland #woodyguthrie #peterpaulandmary https://t.co/aVb4MVCWxY | Thu Aug 17 2017 02:18:46 GMT+0000 (Coordinated Universal Time) | f | "Crowd sings \"This Land Is Your Land\" at Charlottesville vigil https://t.co/5ZZLKGBZyk https://t.co/DN14BIpIaS" | 898004572299563000 | nan | "peterpaulandmary" "woodyguthrie" "thisland" "hippiebeats" | ||||
| 897952302069198849 | 11918032 | lisa rokusek | lisarokusek | 37422 | 2520 | 3835 | 3591 | nan | Intersection of Dharma&Neuroscience. cognition nerd. I eat (mostly my own) assumptions for breakfast. Recruiter: Harbinger of opportunity. | Central Time (US & Canada) | 000000 | 404B28 | The fine people were not marching for supremacy. https://t.co/Stn3wSMYtQ | Wed Aug 16 2017 22:44:46 GMT+0000 (Coordinated Universal Time) | f | nan | nan | nan | |||||
| 897695771138633730 | 18047862 | FAZ.NET | faznet | 98558 | 646 | 255 | 438655 | Frankfurt am Main | Die wichtigsten Nachrichten des Tages, die besten Artikel von http://FAZ.NET und Lese-Empfehlungen der Redaktion. Impressum: http://www.faz.net/impressum | Berlin | 000000 | 333333 | Guten Morgen! #Trump hat sich erneut zu den Ereignissen in #Charlottesville geäußert und sorgt damit für Entsetzen: https://t.co/9VC4MtaMsm | Wed Aug 16 2017 05:45:24 GMT+0000 (Coordinated Universal Time) | f | nan | nan | "Charlottesville" "Trump" | |||||
| 897838096649134081 | 26495303 | Warren | Sechelt | 9658 | 145 | 85 | 152 | Sechelt, BC | A real estate appraiser living on the Sunshine Coast. Warren enjoys sailing and playing rock'n'roll with friends | Pacific Time (US & Canada) | 333333 | C0DEED | Trump’s Latest Charlottesville Remarks Are Condemned Abroad https://t.co/CoLm56Zc8r | Wed Aug 16 2017 15:10:57 GMT+0000 (Coordinated Universal Time) | f | nan | nan | nan | |||||
| 897858494010990593 | 78851624 | EXTRA! | NoticiasVzla | 1014049 | 34 | 6475 | 16632 | Caracas, Venezuela | Noticias ciudadanas de Venezuela y El Mundo | Caracas | 827972 | 59472F | .Guterres invitó a combatir el racismo y la xenofobia tras lo ocurrido en Charlottesville https://t.co/WusPQaF9Iq https://t.co/K4i9uuMfsC | Wed Aug 16 2017 16:32:01 GMT+0000 (Coordinated Universal Time) | f | nan | nan | nan | |||||
| 898004771189248001 | 746776157362716672 | Jup! | JupJobs | 49858 | 107 | nan | We find you a job so you don't have to. #UKJobs | nan | 333333 | F5F8FA | Donald Trump disbands key business councils after CEOs quit over Charlottesville response - The Independent https://t.co/rBc5LPlsYF #ukjobs | Thu Aug 17 2017 02:13:16 GMT+0000 (Coordinated Universal Time) | f | nan | nan | "ukjobs" | |||||||
| 897775599644590080 | 867585740779077632 | Julien Mc 🌐 | creolejulien | 324 | 77 | 30 | 3 | Los Angeles, CA | Lover of good food, good bourbon, good music, and good conversation.\nDon't forget the bourbon. | nan | 333333 | F5F8FA | "When someone tries to defend @realDonaldTrump's verbal vomit yesterday about #Charlottesville, just show them this photo... https://t.co/2XoG7fXYfS" | Wed Aug 16 2017 11:02:37 GMT+0000 (Coordinated Universal Time) | f | nan | nan | "Charlottesville" |
CREATE TABLE aug16_sample (
"id" BIGINT,
"user_id" BIGINT,
"user_name" VARCHAR,
"screen_name" VARCHAR,
"user_statuses_count" BIGINT,
"user_favorites_count" BIGINT,
"friends_count" BIGINT,
"followers_count" BIGINT,
"user_location" VARCHAR,
"user_description" VARCHAR,
"user_time_zone" VARCHAR,
"user_profile_text_color" VARCHAR,
"user_profile_background_color" VARCHAR,
"full_text" VARCHAR,
"created_at" TIMESTAMP,
"is_retweet" VARCHAR,
"retweeted_status_text" VARCHAR,
"retweeted_status_id" VARCHAR,
"quoted_status_text" VARCHAR,
"quoted_status_id" DOUBLE,
"in_reply_to_screen_name" VARCHAR,
"in_reply_to_status_id" DOUBLE,
"in_reply_to_user_id" DOUBLE,
"hashtags" VARCHAR
);