#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

Aug17 Sample

@kaggle.vincela9_charlottesville_on_twitter.aug17_sample

11.34 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_status_id In Reply To Status Id	in_reply_to_user_id In Reply To User Id	hashtags Hashtags
898344136067039233	20158770	Bernadette Smith	Bernadette_EQ	13032	180	1127	9101	Chicago, IL	#Socialentrepreneur specializing in LGBTQ #unconsciousbias training for front line workers. Author of 3 books. Mother & partner. Podcast enthusiast. Feisty Sag.	Central Time (US & Canada)	040209	8C8C8C	I get a little jolt of hope every time an exec speaks out. https://t.co/EBcv1jkW8D	Fri Aug 18 2017 00:41:47 GMT+0000 (Coordinated Universal Time)	f	"“What occurred in Charlottesville has no place in our country” - @tim_cook. https://t.co/kwCaDcOVSZ"	898341854432739300	nan			nan
898332199472078848	128482877	Charles Ray	charlieray45	68667	83	3804	4165	North Potomac, Maryland	Author, photographer, artist. Creator of the Buffalo Soldier series of novels.	nan	333333	2B8A77	Israeli leader criticized for response to Charlottesville https://t.co/9kZOldK1yp	Thu Aug 17 2017 23:54:21 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan
898105823808950272	72926510	Durk de Vries	Durkdurk	715	689	55	39	nan	gastroenterologist, avid reader, father, playground gardener	nan	333333	C0DEED	"Even een samenvatting: super scherp en droog somt mevrouw @LamyaeA het op. Dit hebben we nodig in deze vreemde tijden. https://t.co/vRnLY5skTR"	Thu Aug 17 2017 08:54:49 GMT+0000 (Coordinated Universal Time)	f	"Ik schreef over Charlottesville, en hoe wat daar gebeurde het gevolg is van dog whistle politics https://t.co/iOFeKCgLCW"	898088853503955000	nan			nan
898375580655247360	618014078	He broke me Brad	bradgifford1	1164	959	1260	897	wishing I was somewhere warm.	This use to be fun for me. But like everything else, overindulgence caused the novelty to wear off. Now it's become only slightly more amusing than annoying.	nan	333333	C0DEED	"It definitely was since that's the first time anyone's ever used a car to run somebody down. probably be many more copycats https://t.co/gR35qhHD2D"	Fri Aug 18 2017 02:46:44 GMT+0000 (Coordinated Universal Time)	f	"CNN suggests Barcelona terror attack is 'copycat' of Charlottesville https://t.co/vCF6ZJbDPD"	898257666346074100	nan			nan
898270374395236356	786614390879649792	Rarestone	RarestoneCom	408	117	105	9	nan	nan	nan	333333	F5F8FA	@CBSNews Shame on you! Your Mayor I'd responsible for what happened in Charlottesville...Deal with it, POS!	Thu Aug 17 2017 19:48:40 GMT+0000 (Coordinated Universal Time)	f	nan		CBSNews	898142213061959700	15012486	nan
898251199752699904	877264432409325568	Trumps ❤❤ Girl 🇺🇸	only1sl420	12627	18541	1522	1123	Detroit, MI	#MAGA ❤ do no harm, but take no shit. KNOWLEDGE IS POWER! #trumptrain🚂 #1A, #2A, #patriot, #bansharialaw, #military, fucking DEPLORABLE 😊😊❤ OUR @POTUS & USA	nan	333333	F5F8FA	💯💯💯 https://t.co/phuOpQvvPR	Thu Aug 17 2017 18:32:29 GMT+0000 (Coordinated Universal Time)	f	"Poll: Majority of Republicans Agree with Trump's Response to Charlottesville Violence https://t.co/6KP7sJjX4t via @BreitbartNews"	898250918377922600	nan			nan
898319198367121409	827340689792966660	Enigma #Persistence	An_Enigma_2017	16589	9995	453	518	2 Timothy 3:1-5 & Isaiah 5:20	I'm not black nor white, left nor right..I'm a sapiosexual enigma! A strong woman who knows what she wants because she has seen enough of what she doesn't want.	Pacific Time (US & Canada)	333333	F5F8FA	#Charlottesville https://t.co/KfP9r7xiat @SecretService @POTUS	Thu Aug 17 2017 23:02:41 GMT+0000 (Coordinated Universal Time)	f	nan		nan			"Charlottesville"
898196043568775169	111699543	Madelynn Hoard	madelynnroseh	30	43	55	12	nan	Writer ♢ Lover ♢ Seeker ♢ Poet ♢ insta: _madelynn_rose_ https://www.madelynnhoard.com/	Pacific Time (US & Canada)	333333	C0DEED	our power is our voice may we use it to heal these broken times _madelynn_rose #Charlottesville #Trump #love #peace #EqualityForAll	Thu Aug 17 2017 14:53:19 GMT+0000 (Coordinated Universal Time)	f	nan		nan			"EqualityForAll" "peace" "love" "Trump" "Charlottesville"
898185194024443904	2840565032	WWJ Middays	wwjmiddays	3331	1887	275	987	nan	Listen to WWJ Midday Anchor Jackie Paige Monday-Friday from 10am to 3pm.	nan	333333	C0DEED	Be sure to tune in at 10:30 this morning! https://t.co/WjkTiXwYYb https://t.co/ZLf5lwrFJO	Thu Aug 17 2017 14:10:12 GMT+0000 (Coordinated Universal Time)	f	"How can we find peace after #Charlottesville ? Listen tomorrow at 10:40. I speak live with @marwilliamson @WWJ950 @wwjmiddays"	898028460773224400	nan			nan
898173484022591488	1494835716	All American Girl	AIIAmericanGirI	485623	3466	78958	105744	Wisconsin	[ Wife, Mother, Patriot, Friend ] Searching the Internet for news relevant to conservatives. Both good and bad so we can be informed, debate, agree or correct.	Central Time (US & Canada)	000000	DBE9ED	Trump slams two GOP senators who criticized him on Charlottesville @FoxNews https://t.co/ffy3j9oZxc	Thu Aug 17 2017 13:23:40 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan


CREATE TABLE aug17_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
);