Number of total tweets in both datasets

library(tidyverse)
library(lubridate)

neda_nine <- read_rds(here::here("data", 
                                 "NEDA_week_nineteen.rds")) %>% 
  mutate(data_year = 2019) %>% 
  select(-media) %>%   
  filter(created_at_tweet %within% interval(ymd("2019-02-25"), ymd("2019-03-04"))) %>% 
  mutate(interval_created = int_length(interval(ymd("2019-02-25"), created_at_tweet)))

neda_twenty <- read_rds(here::here("data", 
                                   "NEDA_week_twenty.rds")) %>%
  mutate(data_year = 2020) %>% 
  filter(created_at_tweet %within% interval("2020-02-24", ymd("2020-03-02"))) %>% 
  mutate(interval_created = int_length(interval(ymd("2020-02-24"), created_at_tweet)))


neda <- bind_rows(neda_nine, neda_twenty)


library(scales)

neda %>% 
  select(created_at_tweet, screen_name, retweeted_status_user_screen_name, text,
         interval_created, data_year) %>% 
  mutate(rec_screen_name = case_when(screen_name != "NEDAstaff" ~ "Others users", 
                                     TRUE ~ "NEDAstaff")) %>%  
  mutate(round_created_at_tweet = round_date(created_at_tweet, unit = "hour")) %>%
  count(data_year, round_created_at_tweet, rec_screen_name) %>%
  ggplot(aes(x = round_created_at_tweet, y = n, colour = rec_screen_name)) +
  geom_line() +
  labs(title = "", 
       colour = "Tweets posted by:", 
       x = "NEDAwareness week",
       y = "# of tweets") +
  scale_x_datetime() +
  facet_wrap(data_year ~ ., ncol = 1, scales = "free_x") +
  theme_light() +
  theme(legend.position = "bottom") +
  scale_color_brewer(palette = "Set1")

Common users in both datasets

Number of total users who tweeted at some point about neda so they are included in both neda-week data:

neda_nine %>% 
  filter(id %in% neda_twenty$id) %>% 
  distinct() %>% 
  count()
## # A tibble: 1 x 1
##       n
##   <int>
## 1  4237

Number of total users in both historical datasets:

neda_timelapse_twenty <- read_rds(here::here("data", "NEDA_historical_twenty.rds"))
neda_timelapse_nineteen <- read_rds(here::here("data", "NEDA_historical_nineteen.rds"))

neda_timelapse_nineteen %>% 
  filter(id %in% neda_timelapse_twenty$id) %>% 
  select(id) %>% 
  distinct() %>% 
  count()
## # A tibble: 1 x 1
##       n
##   <int>
## 1    75

Number of total users in week and neda historical:

neda_nine %>% 
  filter(id %in% neda_timelapse_nineteen$id) %>% 
  distinct() %>% 
  count()
## # A tibble: 1 x 1
##       n
##   <int>
## 1 13167
neda_twenty %>% 
  filter(id %in% neda_timelapse_twenty$id) %>% 
  distinct() %>% 
  count()
## # A tibble: 1 x 1
##       n
##   <int>
## 1  3486

Talking coronavirus

Number of total tweets including “coronavirus” or “covid”: 3816.

Some examples:

neda_timelapse_twenty %>% 
  filter(str_detect(text, "coronavirus|covid")) %>% 
  select(text) %>% 
  slice(1:10) %>% 
  gt::gt()
text
RT @MinisteroSalute: #covid19italia Resta a casa e segui i consigli utili a prevenire il contagio da #coronavirus: 🤲🙌💧Cura l'igiene delle…
RT @doyou_bangtan: Yes hello, it's Jin of @BTS_twt. These days, many people are worried due to the coronavirus, but it’d be good if we coul…
RT @Kpop_Herald: Seoul exhibition of Connect, @BTS_twt has been tentatively closed due to coronavirus concerns. Korean authorities say th…
RT @BarbieXanax: Italia: Zero casi accertati di coronavirus Tanti casi di razzismo
RT @988Patrick: It’s not a joke . Share guys and stay safe #coronavirus https://t.co/nmcciR8up3
RT @jjk_yeehaw: Recite što hoćete, ali mislim da su se hrvatska vlast i zdravstvo prilično dobro ponijeli tijekom ove covid-19 situacije. M…
RT @nochucamethruu: my dad’s korean restaurant in san francisco has lost 2/3 of our business this past month due to #coronavirus 🥺 if you’r…
RT @tyrathetaurus: why the fuck is our country so fucking stupid??? why are we REFUSING to test people for coronavirus?? why are we refusin…
RT @samklew: THIS IS BIG. Homeless families are taking over vacant homes in LA owned by the state. (!!!!!!!!!) “With the coronavirus, the…
RT @elkhalifag: the government be like: due to the coronavirus we will be providing human rights
LS0tCnRpdGxlOiAiRXh0cmEgUXVlc3Rpb25zIiAKY2xlYW46IHRydWUKb3V0cHV0OgogIGJvb2tkb3duOjpodG1sX2RvY3VtZW50MjoKICAgIG51bWJlcl9zZWN0aW9uczogZmFsc2UKICAgIGNvZGVfZG93bmxvYWQ6IHRydWUKICAgIGNvZGVfZm9sZGluZzogaGlkZQogICAgc2VsZl9jb250YWluZWQ6IHRydWUKICAgIHRvYzogdHJ1ZQogICAgdG9jX2Zsb2F0OiBmYWxzZQotLS0KCmBgYHtyIHNldHVwLCBpbmNsdWRlPUZBTFNFfQprbml0cjo6b3B0c19jaHVuayRzZXQoZWNobyA9IFRSVUUsIHdhcm5pbmcgPSBGQUxTRSwgbWVzc2FnZSA9IEZBTFNFKQoKeGZ1bjo6cGtnX2F0dGFjaCgidGlkeXZlcnNlIiwgImx1YnJpZGF0ZSIsICJrYWJsZUV4dHJhIikKCnRoZW1lX3NldCh0aGVtZV9saW5lZHJhdygpKQpgYGAKCiMjIE51bWJlciBvZiB0b3RhbCB0d2VldHMgaW4gYm90aCBkYXRhc2V0cwoKYGBge3J9CmxpYnJhcnkodGlkeXZlcnNlKQpsaWJyYXJ5KGx1YnJpZGF0ZSkKCm5lZGFfbmluZSA8LSByZWFkX3JkcyhoZXJlOjpoZXJlKCJkYXRhIiwgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICJORURBX3dlZWtfbmluZXRlZW4ucmRzIikpICU+JSAKICBtdXRhdGUoZGF0YV95ZWFyID0gMjAxOSkgJT4lIAogIHNlbGVjdCgtbWVkaWEpICU+JSAgIAogIGZpbHRlcihjcmVhdGVkX2F0X3R3ZWV0ICV3aXRoaW4lIGludGVydmFsKHltZCgiMjAxOS0wMi0yNSIpLCB5bWQoIjIwMTktMDMtMDQiKSkpICU+JSAKICBtdXRhdGUoaW50ZXJ2YWxfY3JlYXRlZCA9IGludF9sZW5ndGgoaW50ZXJ2YWwoeW1kKCIyMDE5LTAyLTI1IiksIGNyZWF0ZWRfYXRfdHdlZXQpKSkKCm5lZGFfdHdlbnR5IDwtIHJlYWRfcmRzKGhlcmU6OmhlcmUoImRhdGEiLCAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAiTkVEQV93ZWVrX3R3ZW50eS5yZHMiKSkgJT4lCiAgbXV0YXRlKGRhdGFfeWVhciA9IDIwMjApICU+JSAKICBmaWx0ZXIoY3JlYXRlZF9hdF90d2VldCAld2l0aGluJSBpbnRlcnZhbCgiMjAyMC0wMi0yNCIsIHltZCgiMjAyMC0wMy0wMiIpKSkgJT4lIAogIG11dGF0ZShpbnRlcnZhbF9jcmVhdGVkID0gaW50X2xlbmd0aChpbnRlcnZhbCh5bWQoIjIwMjAtMDItMjQiKSwgY3JlYXRlZF9hdF90d2VldCkpKQoKCm5lZGEgPC0gYmluZF9yb3dzKG5lZGFfbmluZSwgbmVkYV90d2VudHkpCgoKbGlicmFyeShzY2FsZXMpCgpuZWRhICU+JSAKICBzZWxlY3QoY3JlYXRlZF9hdF90d2VldCwgc2NyZWVuX25hbWUsIHJldHdlZXRlZF9zdGF0dXNfdXNlcl9zY3JlZW5fbmFtZSwgdGV4dCwKICAgICAgICAgaW50ZXJ2YWxfY3JlYXRlZCwgZGF0YV95ZWFyKSAlPiUgCiAgbXV0YXRlKHJlY19zY3JlZW5fbmFtZSA9IGNhc2Vfd2hlbihzY3JlZW5fbmFtZSAhPSAiTkVEQXN0YWZmIiB+ICJPdGhlcnMgdXNlcnMiLCAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFRSVUUgfiAiTkVEQXN0YWZmIikpICU+JSAgCiAgbXV0YXRlKHJvdW5kX2NyZWF0ZWRfYXRfdHdlZXQgPSByb3VuZF9kYXRlKGNyZWF0ZWRfYXRfdHdlZXQsIHVuaXQgPSAiaG91ciIpKSAlPiUKICBjb3VudChkYXRhX3llYXIsIHJvdW5kX2NyZWF0ZWRfYXRfdHdlZXQsIHJlY19zY3JlZW5fbmFtZSkgJT4lCiAgZ2dwbG90KGFlcyh4ID0gcm91bmRfY3JlYXRlZF9hdF90d2VldCwgeSA9IG4sIGNvbG91ciA9IHJlY19zY3JlZW5fbmFtZSkpICsKICBnZW9tX2xpbmUoKSArCiAgbGFicyh0aXRsZSA9ICIiLCAKICAgICAgIGNvbG91ciA9ICJUd2VldHMgcG9zdGVkIGJ5OiIsIAogICAgICAgeCA9ICJORURBd2FyZW5lc3Mgd2VlayIsCiAgICAgICB5ID0gIiMgb2YgdHdlZXRzIikgKwogIHNjYWxlX3hfZGF0ZXRpbWUoKSArCiAgZmFjZXRfd3JhcChkYXRhX3llYXIgfiAuLCBuY29sID0gMSwgc2NhbGVzID0gImZyZWVfeCIpICsKICB0aGVtZV9saWdodCgpICsKICB0aGVtZShsZWdlbmQucG9zaXRpb24gPSAiYm90dG9tIikgKwogIHNjYWxlX2NvbG9yX2JyZXdlcihwYWxldHRlID0gIlNldDEiKQpgYGAKCiMjIENvbW1vbiB1c2VycyBpbiBib3RoIGRhdGFzZXRzCgpOdW1iZXIgb2YgdG90YWwgdXNlcnMgd2hvIHR3ZWV0ZWQgYXQgc29tZSBwb2ludCBhYm91dCBuZWRhIHNvIHRoZXkgYXJlIGluY2x1ZGVkIGluIGJvdGggbmVkYS13ZWVrIGRhdGE6CgpgYGB7cn0KbmVkYV9uaW5lICU+JSAKICBmaWx0ZXIoaWQgJWluJSBuZWRhX3R3ZW50eSRpZCkgJT4lIAogIGRpc3RpbmN0KCkgJT4lIAogIGNvdW50KCkKYGBgCgpOdW1iZXIgb2YgdG90YWwgdXNlcnMgaW4gYm90aCBoaXN0b3JpY2FsIGRhdGFzZXRzOgpgYGB7cn0KbmVkYV90aW1lbGFwc2VfdHdlbnR5IDwtIHJlYWRfcmRzKGhlcmU6OmhlcmUoImRhdGEiLCAiTkVEQV9oaXN0b3JpY2FsX3R3ZW50eS5yZHMiKSkKbmVkYV90aW1lbGFwc2VfbmluZXRlZW4gPC0gcmVhZF9yZHMoaGVyZTo6aGVyZSgiZGF0YSIsICJORURBX2hpc3RvcmljYWxfbmluZXRlZW4ucmRzIikpCgpuZWRhX3RpbWVsYXBzZV9uaW5ldGVlbiAlPiUgCiAgZmlsdGVyKGlkICVpbiUgbmVkYV90aW1lbGFwc2VfdHdlbnR5JGlkKSAlPiUgCiAgc2VsZWN0KGlkKSAlPiUgCiAgZGlzdGluY3QoKSAlPiUgCiAgY291bnQoKQpgYGAKCk51bWJlciBvZiB0b3RhbCB1c2VycyBpbiB3ZWVrIGFuZCBuZWRhIGhpc3RvcmljYWw6CmBgYHtyfQpuZWRhX25pbmUgJT4lIAogIGZpbHRlcihpZCAlaW4lIG5lZGFfdGltZWxhcHNlX25pbmV0ZWVuJGlkKSAlPiUgCiAgZGlzdGluY3QoKSAlPiUgCiAgY291bnQoKQoKbmVkYV90d2VudHkgJT4lIAogIGZpbHRlcihpZCAlaW4lIG5lZGFfdGltZWxhcHNlX3R3ZW50eSRpZCkgJT4lIAogIGRpc3RpbmN0KCkgJT4lIAogIGNvdW50KCkKYGBgCgoKIyMgVGFsa2luZyBjb3JvbmF2aXJ1cwoKTnVtYmVyIG9mIHRvdGFsIHR3ZWV0cyBpbmNsdWRpbmcgImNvcm9uYXZpcnVzIiBvciAiY292aWQiOiAzODE2LgoKU29tZSBleGFtcGxlczoKYGBge3J9Cm5lZGFfdGltZWxhcHNlX3R3ZW50eSAlPiUgCiAgZmlsdGVyKHN0cl9kZXRlY3QodGV4dCwgImNvcm9uYXZpcnVzfGNvdmlkIikpICU+JSAKICBzZWxlY3QodGV4dCkgJT4lIAogIHNsaWNlKDE6MTApICU+JSAKICBndDo6Z3QoKQpgYGAKCg==