#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

Aug18 Sample

@kaggle.vincela9_charlottesville_on_twitter.aug18_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_status_id In Reply To Status Id	in_reply_to_user_id In Reply To User Id	hashtags Hashtags
898577667326230529	735878685941768194	TorontoNews	torontonews3	179081	12	115	1120	nan	nan	nan	333333	F5F8FA	It's stress eating, Tina Fey-style, in a new ‘SNL’ segment: https://t.co/ZpczYprtKW	Fri Aug 18 2017 16:09:45 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan
898535539967537152	165171140	Amy Stephenson	amylynn4215	196	31	177	24	Dallas, TX	nan	Central Time (US & Canada)	333333	C0DEED	@realDonaldTrump @POTUS Hey little buddy! Looks like you're losing money! Might be time for you to go! https://t.co/xXaFoBwosQ	Fri Aug 18 2017 13:22:21 GMT+0000 (Coordinated Universal Time)	f	"Three fundraising organizations have pulled their galas from Mar-a-Lago following Trump’s Charlottesville response https://t.co/faX7YFI8YP"	898535026459070500	realDonaldTrump		25073877	nan
898556800923979776	3411126935	Ex GOP Penny	Pennychastain1	15910	8675	745	1325	nan	a Christian, wife, mother, defender of Constitution, Conservative values: defined as prolife, pro Constitution, smaller government, less taxes.	nan	333333	C0DEED	https://t.co/WtYV3rWh4N	Fri Aug 18 2017 14:46:50 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan
898419024119209986	6389182	Melissa	melissarocks	27191	82943	318	463	Northern Virginia	Massage diva. Bleeding heart. Liberal. Pro-love. Feminist. Aunt. Cat fosterer. Dog-owner-wannabe. I don't mean to be this political but I can't keep quiet.	Eastern Time (US & Canada)	333333	FFF04D	Good. Stay there, roach. Your hate doesn't belong in this country. https://t.co/K8NK4fXZpR	Fri Aug 18 2017 05:39:21 GMT+0000 (Coordinated Universal Time)	f	"Jason Kessler, Charlottesville rally organizer, says he's in hiding https://t.co/shWn4QemDi"	898402132902027300	nan			nan
898416456718704642	34478310	real1rock	lakersgirl18	8459	10193	240	142	Vegas, USA	TECH, GYM, SPORTS, & SHOE ADDICT\nStriving to be my own boss. \nStriving to be a good citizen.\nReal talk only. \nI'll rant about politics and music too...	Pacific Time (US & Canada)	000000	000000	@sharn67 lol https://t.co/uGnAlbOTsi	Fri Aug 18 2017 05:29:09 GMT+0000 (Coordinated Universal Time)	f	"Post-Charlottesville covers of The Economist, The New Yorker and TIME. https://t.co/iv7Rt4myKU"	898296957315170300	sharn67		621498571	nan
898707367252168704	50944647	Bharat ☸️	bkusuma	5320	971	745	478	San Francisco, CA	Living life & posting thoughts (both of which are mine). Occasional @SierraClub tweeter. Lover of math & music.	Pacific Time (US & Canada)	000000	000000	this https://t.co/43u7jRvjBH	Sat Aug 19 2017 00:45:08 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan
898520113141252097	1767741	NYT National News	NYTNational	115718	1946	762	72241	From Sea to Shining Sea	Breaking news and in-depth reporting from the National Desk of The New York Times. Header: Todd Heisler. More photographers on poetry: https://nyti.ms/2vkriFx	Eastern Time (US & Canada)	000000	FFFFFF	Black voices on Trump's response to Charlottesville: "His words were bone-crushing" https://t.co/mCjKg5gCjf	Fri Aug 18 2017 12:21:03 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan
898571108445814784	876404155	Tom Wilk	TomWilk2	2045	6519	46	60	Tennessee, USA	nan	nan	333333	C0DEED	"@LarrySchweikart Wow, sure is. Looks like the Charlottesville leadership and police may be guilty of inciting a riot, and perhaps had a hand in the death."	Fri Aug 18 2017 15:43:41 GMT+0000 (Coordinated Universal Time)	f	nan		LarrySchweikart	898568796687941600	562255311	nan
898651343350513665	210474241	Jose Jaimes	the_mantese	215715	1	137	84	some place	nan	Eastern Time (US & Canada)	3E4415	352726	https://t.co/g7yMnHFK3H	Fri Aug 18 2017 21:02:31 GMT+0000 (Coordinated Universal Time)	f	nan		nan			nan
898698894074408963	157158976	AbgArcangel Alvarado	ArcangelAlvarad	1765434	14	6518	6155	Venezuela	LA MORAL DE JESÚS, la obra divina que nos ha enviado la providencia para MEJORAR A LOS HOMBRES,.- Maestria Finanzas Espec.Derechos Humanos	Caracas	333333	C0DEED	RT katiecouric: 1 week ago today I was in #Charlottesville for my natgeo series. The network asked me to share wha… https://t.co/RUA450L4sO	Sat Aug 19 2017 00:11:28 GMT+0000 (Coordinated Universal Time)	f	nan		nan			"Charlottesville"


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