Baselight
Sign In

#Charlottesville On Twitter

A snapshot of American history in the making

@kaggle.vincela9_charlottesville_on_twitter

Tweet Count Time Series
@kaggle.vincela9_charlottesville_on_twitter.tweet_count_time_series

  • 2.55 MB
  • 261510 rows
  • 4 columns
created_at

Created At

created_at_day

Created At Day

created_at_hour

Created At Hour

tweet_count

Tweet Count

Thu Aug 17 2017 23:35:25 GMT+0000 (Coordinated Universal Time)172315
Wed Aug 16 2017 13:29:49 GMT+0000 (Coordinated Universal Time)161329
Fri Aug 18 2017 13:57:21 GMT+0000 (Coordinated Universal Time)181321
Thu Aug 17 2017 15:56:55 GMT+0000 (Coordinated Universal Time)171518
Wed Aug 16 2017 19:37:28 GMT+0000 (Coordinated Universal Time)161923
Thu Aug 17 2017 15:15:15 GMT+0000 (Coordinated Universal Time)171516
Sat Aug 19 2017 00:57:42 GMT+0000 (Coordinated Universal Time)1917
Fri Aug 18 2017 11:08:04 GMT+0000 (Coordinated Universal Time)18117
Thu Aug 17 2017 06:07:40 GMT+0000 (Coordinated Universal Time)17611
Wed Aug 16 2017 15:02:52 GMT+0000 (Coordinated Universal Time)161525

CREATE TABLE tweet_count_time_series (
  "created_at" TIMESTAMP,
  "created_at_day" BIGINT,
  "created_at_hour" BIGINT,
  "tweet_count" BIGINT
);