#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

Aug15 Sample

@kaggle.vincela9_charlottesville_on_twitter.aug15_sample

10.4 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
897661668787982336	2912874772	KCR	kc_race	428	381	250	32	philly	Communications profesh. Giving everything major side-eye right now. Views mine.	nan	000000	000000	It's almost as if people are exactly who they say they are https://t.co/MnWFXZd9c3	Wed Aug 16 2017 03:29:54 GMT+0000 (Coordinated Universal Time)	f	"Charlottesville suspect was known as “the Nazi” of his high school https://t.co/0gnkFCnJJ3 https://t.co/KRorruI8o8"	897558316355813400	nan			nan
897654901534228480	4840680143	Rory Hart	OpenHartnMinds	5544	3503	510	62	Connecticut, USA	Educator, Coach, Ally, Activist	nan	333333	F5F8FA	@Slate Conservative media: Yes, Trump's response to Charlottesville was bad, but what about Obama? https://t.co/jjINXL5Qp0 via @slate	Wed Aug 16 2017 03:03:00 GMT+0000 (Coordinated Universal Time)	f	nan		OpenHartnMinds	897654842939891700	4840680143	nan
897659748597870592	2884196456	Lee Valentine Smith	leevsmith	9425	49365	5168	6726	NY, London, Paris, Munich.	Writer-artist-activist-contrarian. No debates, just random musings on #music #tv #film #theater #comedy #art and #politics. #TheResistance #fucktrump #1A	nan	000000	000000	👀 https://t.co/qeyzYeblwu	Wed Aug 16 2017 03:22:16 GMT+0000 (Coordinated Universal Time)	f	"WATCH: WH Chief John Kelly reacts to Trump's remarks on violence in #Charlottesville\n\n#ImpeachTrump #QuitTheCouncil https://t.co/u7dEMnuo9B"	897649699909492700	nan			nan
897660496656179202	733618527282814976	Karabo J.R Ramasodi	kjr_inkguy	3374	805	108	45	Pretoria, South Africa	\|Events Guy\|\n●Both Problem and Situation●\n♤Tattoos♤\n\|#1 Nutcase insert disclaimer\|	nan	333333	F5F8FA	😂 😂 😂 Karma really isn't wasting time.. https://t.co/JYRqf6vlSX	Wed Aug 16 2017 03:25:14 GMT+0000 (Coordinated Universal Time)	f	"#NEW: #Charlottesville murder suspect can't afford lawyer; public defender is related to a victim… https://t.co/zNrFkKJmRh"	897107001913868300	nan			nan
897642311903055872	4388881763	ProudTrumpwoman	pmswolfy	120434	61111	805	2263	Salem, VA	Wife, mother, and teacher never been involved in politics till Trump first real person I have seen run for office in my life.	nan	333333	C0DEED	After Charlottesville, Black Lives Matter Issues New Demand - https://t.co/Vuw3IvrhL2	Wed Aug 16 2017 02:12:59 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan
897651192372842502	800124776924622848	Kev Spaceman	burnerunit	4532	3437	17	21	nan	nan	nan	333333	F5F8FA	@seanhannity @JaySekulow @GreggJarrett https://t.co/WHL01vNZKN	Wed Aug 16 2017 02:48:16 GMT+0000 (Coordinated Universal Time)	f	"Thank you President Trump for your honesty & courage to tell the truth about #Charlottesville & condemn the leftist… https://t.co/7LxWB0FaWi"	897559892164304900	seanhannity	897650877607137300	41634520	nan
897642285676056577	9567382	Ak Baş	wittich	975766	1983	1731	2597	Hannover, Germany	Science, medicine, technology, culture, human rights, politics news ,http://eee.am/wittich	Berlin	3D1957	642D8B	Charlottesville Victim Heather Heyer’s Family Asks Mourners to Wear Purple to Memorial Held… https://t.co/iAcW8vi59H	Wed Aug 16 2017 02:12:52 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan
897660234537283585	1403690822	Donroy Ferdinand Jr.	dferdjr	2263	2557	388	395	Massachusetts, USA	Wachusett '19\nsc, ig: dferdjr\n🇻🇨🇺🇸	nan	000000	000000	"\"I like getting the facts\"\nThis is literally the first time he's been the least bit concerned about honesty and attention to detail https://t.co/3wyAHEzME1"	Wed Aug 16 2017 03:24:12 GMT+0000 (Coordinated Universal Time)	f	"\"It was very important to me to get the facts out, and correctly.\" -@POTUS defended his remarks about the violence… https://t.co/N83PgyAApc"	897554743857492000	nan			nan
897650991562199040	2340698592	Herbert	HHooversGhost	99703	9603	12241	11187	nan	Herbert Hoover's Ghost haunts the GOP. Stop Trump's #Collusion #ScabNation #Kleptocracy & our #NewFeudalism. \nSave Democracy in America #Resistance	nan	333333	ACDED6	Meet Trump's "very fine people" who only wanted to peacefully defend a statue in #Charlottesville https://t.co/9ycHbJjQoe	Wed Aug 16 2017 02:47:28 GMT+0000 (Coordinated Universal Time)	f	nan		nan			"Charlottesville"
897647177891274752	731986812323938304	Preview Tweets	preview_tweeter	21				nan	nan	Pacific Time (US & Canada)	333333	F5F8FA	The president who wanted Barack Obama to name radical Islam should take his own advice and be forceful — @EWErickson https://t.co/AO4ROrGazw	Wed Aug 16 2017 02:32:19 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan


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