#Charlottesville On Twitter

A snapshot of American history in the making

@kaggle.vincela9_charlottesville_on_twitter

Table List

5 tables(46.71 MB)

Tweet Count Time Series

Aug16 Sample

@kaggle.vincela9_charlottesville_on_twitter.aug16_sample

11.21 MB
50000 rows
24 columns

id Id	user_id User Id	user_name User Name	screen_name Screen Name	user_statuses_count User Statuses Count	user_favorites_count User Favorites Count	friends_count Friends Count	followers_count Followers Count	user_location User Location	user_description User Description	user_time_zone User Time Zone	user_profile_text_color User Profile Text Color	user_profile_background_color User Profile Background Color	full_text Full Text	created_at Created At	is_retweet Is Retweet	quoted_status_text Quoted Status Text	quoted_status_id Quoted Status Id	in_reply_to_screen_name In Reply To Screen Name	in_reply_to_user_id In Reply To User Id	hashtags Hashtags
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
);