Here I scrape Twitter Data for both the data science and the sociology department.
#install.packages("httr")
#install.packages("jsonlite")
require(httr)
require(jsonlite)
require(dplyr)library ("rtweet")data_twitter1 <- list()
for (i in 1:nrow(data_df)) {
time <- runif (1,0,3)
Sys.sleep(time)
print(i)
data_twitter1[[i]] <- search_users(data_df[i, c("name")], n=1, parse=FALSE, token=NULL, verbose=TRUE)
}
data_twittercopy <- data_twitter1
data_twitter1[[14]][[1]]
length(data_twitter1[[1]][[1]])
twid <- NA
twname <-NA
twscreenname <- NA
twfollowercount <- NA
for (i in 1:length(data_twitter1)) {
if (!length(data_twitter1[[i]][[1]])==0) {
twid[i] <- data_twitter1[[i]][[1]]$id[1]
twname[i] <- data_twitter1[[i]][[1]]$name[1]
twscreenname[i] <-data_twitter1[[i]][[1]]$screen_name[1]
twfollowercount[i] <- data_twitter1[[i]][[1]]$followers_count[1]
}
}
data_twitterinfo <- as.data.frame(cbind(twid, twname, twscreenname, twfollowercount))
data_df <- cbind(data_df, data_twitterinfo)
data_twitter1[[1]][[1]]$id
str(data_twitter1)
save(data_twitter1, file="./data/data_twitter.RData")
save(data_df, file = "addfiles\\data_df.RData") This is what I used later, when we had the definitive data. I can already notice from the difference that I made progress on knowing what I’m doing.
#Twitter
require(httr)
require(jsonlite)
require(dplyr)
library ("rtweet")
data_twitter <- list()
for (i in 1:nrow(datadef_df)) {
time <- runif (1,0,3)
Sys.sleep(time)
print(i)
data_twitter[[i]] <- search_users(datadef_df[i, c("names")], n=1, parse=FALSE, token=NULL, verbose=TRUE)
}
twid <- NA
twname <-NA
twscreenname <- NA
twfollowercount <- NA
for (i in 1:length(data_twitter)) {
if (!length(data_twitter[[i]][[1]])==0) {
twid[i] <- data_twitter[[i]][[1]]$id[1]
twname[i] <- data_twitter[[i]][[1]]$name[1]
twscreenname[i] <-data_twitter[[i]][[1]]$screen_name[1]
twfollowercount[i] <- data_twitter[[i]][[1]]$followers_count[1]
}
}
data_twitterinfo <- as.data.frame(cbind(twid, twname, twscreenname, twfollowercount))
data_twitterinfo <- cbind(data_twitterinfo, datadef_df$gs_id, datadef_df$total_cites)head(data_twitter1)#> [[1]]
#> [[1]][[1]]
#> id id_str name screen_name location description url urls protected
#> 1 417804690 417804690 Tom Heskes TomHeskes NA NULL FALSE
#> followers_count friends_count listed_count created_at favourites_count
#> 1 7 1 0 Mon Nov 21 11:44:30 +0000 2011 1
#> utc_offset time_zone geo_enabled verified statuses_count lang contributors_enabled is_translator
#> 1 NA NA FALSE FALSE 0 NA FALSE FALSE
#> is_translation_enabled profile_background_color profile_background_image_url
#> 1 FALSE C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> profile_background_image_url_https profile_background_tile
#> 1 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> profile_image_url
#> 1 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> profile_image_url_https profile_link_color
#> 1 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png 1DA1F2
#> profile_sidebar_border_color profile_sidebar_fill_color profile_text_color
#> 1 C0DEED DDEEF6 333333
#> profile_use_background_image has_extended_profile default_profile default_profile_image following
#> 1 TRUE FALSE TRUE TRUE FALSE
#> follow_request_sent notifications translator_type withheld_in_countries
#> 1 FALSE FALSE none NULL
#>
#>
#> [[2]]
#> [[2]][[1]]
#> id id_str name screen_name location
#> 1 21133730 21133730 @djoerd@idf.social djoerd Kleve (Nordrhein Westfalen)
#> 2 1318330388 1318330388 Djoerd Hiemstra DjoerdHiemstra Groningen
#> description
#> 1 Teaching and Researching Data Science at Radboud University
#> 2 Psycholoog, beleidsadviseur NHL Hogeschool, promovendus Rijksuniversiteit Groningen, geïnteresseerd in talentontwikkeling en studiemotivatie.
#> url
#> 1 https://t.co/BMzVXvsKX9
#> 2 http://t.co/Ik4h7GWrR3
#> entities.urls entities.urls
#> 1 https://t.co/BMzVXvsKX9, https://djoerdhiemstra.com/, djoerdhiemstra.com, 0, 23 NULL
#> 2 http://t.co/Ik4h7GWrR3, http://www.Talentenwijzer.com, Talentenwijzer.com, 0, 22 NULL
#> protected followers_count friends_count listed_count created_at
#> 1 FALSE 1205 845 33 Tue Feb 17 21:38:17 +0000 2009
#> 2 FALSE 200 289 2 Sun Mar 31 12:49:29 +0000 2013
#> favourites_count utc_offset time_zone geo_enabled verified statuses_count lang
#> 1 6084 NA NA FALSE FALSE 5340 NA
#> 2 2 NA NA FALSE FALSE 65 NA
#> status.created_at status.id status.id_str
#> 1 Fri Aug 12 11:12:42 +0000 2022 1.558049e+18 1558048829865353218
#> 2 Sun Aug 30 08:58:25 +0000 2015 6.379122e+17 637912242072223745
#> status.text
#> 1 RT @fhasibi: I am hiring 2 PhD students in #InformationRetrieval and #NLProc at @informagus group @Radboud_Uni:\n\n- Knowledge Enriched Conve…
#> 2 Barry Schwartz in the New York Times:"Is it human nature to hate your job?"\nhttp://t.co/zlaGnLsHrl\nhttp://t.co/GnrWJptYvQ”
#> status.truncated status.entities.hashtags status.entities.symbols
#> 1 FALSE InformationRetrieval, NLProc, 43, 64, 69, 76 NULL
#> 2 FALSE NULL NULL
#> status.entities.user_mentions
#> 1 fhasibi, informagus, Radboud_Uni, Faegheh Hasibi, Informagus - Information Retrieval Research Group, Radboud University, 101045085, 1287104705185939456, 45826046, 101045085, 1287104705185939456, 45826046, 3, 11, 80, 91, 98, 110
#> 2 NULL
#> status.entities.urls
#> 1 NULL
#> 2 http://t.co/zlaGnLsHrl, http://www.nytimes.com/2015/08/30/opinion/sunday/rethinking-work.html?smprod=nytcore-ipad&smid=nytcore-ipad-share, nytimes.com/2015/08/30/opi…, 76, 98
#> status.entities.media
#> 1 NULL
#> 2 637535684195127296, 637535684195127296, 99, 121, http://pbs.twimg.com/media/CNj7U7QWEAAFmd6.jpg, https://pbs.twimg.com/media/CNj7U7QWEAAFmd6.jpg, http://t.co/GnrWJptYvQ, pic.twitter.com/GnrWJptYvQ, https://twitter.com/went1955/status/637535691866513408/photo/1, photo, 150, 150, crop, 427, 483, fit, 427, 483, fit, 427, 483, fit, 637535691866513408, 637535691866513408, 124506375, 124506375
#> status.source
#> 1 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 2 <a href="http://twitter.com/#!/download/ipad" rel="nofollow">Twitter for iPad</a>
#> status.in_reply_to_status_id status.in_reply_to_status_id_str status.in_reply_to_user_id
#> 1 NA NA NA
#> 2 NA NA NA
#> status.in_reply_to_user_id_str status.in_reply_to_screen_name status.geo status.coordinates
#> 1 NA NA NA NA
#> 2 NA NA NA NA
#> status.place status.contributors status.retweeted_status.created_at status.retweeted_status.id
#> 1 NA NA Fri Aug 12 10:36:57 +0000 2022 1.55804e+18
#> 2 NA NA <NA> NA
#> status.retweeted_status.id_str
#> 1 1558039833024626690
#> 2 <NA>
#> status.retweeted_status.text
#> 1 I am hiring 2 PhD students in #InformationRetrieval and #NLProc at @informagus group @Radboud_Uni:\n\n- Knowledge Enr… https://t.co/dnAi8a0a7t
#> 2 <NA>
#> status.retweeted_status.truncated status.retweeted_status.entities.hashtags
#> 1 TRUE InformationRetrieval, NLProc, 30, 51, 56, 63
#> 2 NA NULL
#> status.retweeted_status.entities.symbols
#> 1 NULL
#> 2 NULL
#> status.retweeted_status.entities.user_mentions
#> 1 informagus, Radboud_Uni, Informagus - Information Retrieval Research Group, Radboud University, 1287104705185939456, 45826046, 1287104705185939456, 45826046, 67, 78, 85, 97
#> 2 NULL
#> status.retweeted_status.entities.urls
#> 1 https://t.co/dnAi8a0a7t, https://twitter.com/i/web/status/1558039833024626690, twitter.com/i/web/status/1…, 117, 140
#> 2 NULL
#> status.retweeted_status.source
#> 1 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 2 <NA>
#> status.retweeted_status.in_reply_to_status_id status.retweeted_status.in_reply_to_status_id_str
#> 1 NA NA
#> 2 NA NA
#> status.retweeted_status.in_reply_to_user_id status.retweeted_status.in_reply_to_user_id_str
#> 1 NA NA
#> 2 NA NA
#> status.retweeted_status.in_reply_to_screen_name status.retweeted_status.geo
#> 1 NA NA
#> 2 NA NA
#> status.retweeted_status.coordinates status.retweeted_status.place
#> 1 NA NA
#> 2 NA NA
#> status.retweeted_status.contributors status.retweeted_status.is_quote_status
#> 1 NA FALSE
#> 2 NA NA
#> status.retweeted_status.retweet_count status.retweeted_status.favorite_count
#> 1 52 104
#> 2 NA NA
#> status.retweeted_status.favorited status.retweeted_status.retweeted
#> 1 FALSE FALSE
#> 2 NA NA
#> status.retweeted_status.possibly_sensitive status.retweeted_status.lang status.is_quote_status
#> 1 FALSE en FALSE
#> 2 NA <NA> FALSE
#> status.retweet_count status.favorite_count status.favorited status.retweeted status.lang
#> 1 52 0 FALSE FALSE en
#> 2 0 0 FALSE FALSE en
#> status.media
#> 1 NULL
#> 2 637535684195127296, 637535684195127296, 99, 121, http://pbs.twimg.com/media/CNj7U7QWEAAFmd6.jpg, https://pbs.twimg.com/media/CNj7U7QWEAAFmd6.jpg, http://t.co/GnrWJptYvQ, pic.twitter.com/GnrWJptYvQ, https://twitter.com/went1955/status/637535691866513408/photo/1, photo, 150, 150, crop, 427, 483, fit, 427, 483, fit, 427, 483, fit, 637535691866513408, 637535691866513408, 124506375, 124506375
#> status.possibly_sensitive contributors_enabled is_translator is_translation_enabled
#> 1 NA FALSE FALSE FALSE
#> 2 FALSE FALSE FALSE FALSE
#> profile_background_color profile_background_image_url
#> 1 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 2 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> profile_background_image_url_https profile_background_tile
#> 1 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 2 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> profile_image_url
#> 1 http://pbs.twimg.com/profile_images/1875361658/penguin_normal.png
#> 2 http://pbs.twimg.com/profile_images/3756296276/1e6d623dbc1b286c8f1a4b845aedfed4_normal.jpeg
#> profile_image_url_https
#> 1 https://pbs.twimg.com/profile_images/1875361658/penguin_normal.png
#> 2 https://pbs.twimg.com/profile_images/3756296276/1e6d623dbc1b286c8f1a4b845aedfed4_normal.jpeg
#> profile_banner_url profile_link_color
#> 1 https://pbs.twimg.com/profile_banners/21133730/1361221664 1DA1F2
#> 2 <NA> 1DA1F2
#> profile_sidebar_border_color profile_sidebar_fill_color profile_text_color
#> 1 C0DEED DDEEF6 333333
#> 2 C0DEED DDEEF6 333333
#> profile_use_background_image has_extended_profile default_profile default_profile_image following
#> 1 TRUE FALSE TRUE FALSE FALSE
#> 2 TRUE FALSE TRUE FALSE FALSE
#> follow_request_sent notifications translator_type withheld_in_countries
#> 1 FALSE FALSE regular NULL
#> 2 FALSE FALSE none NULL
#>
#>
#> [[3]]
#> [[3]][[1]]
#> id id_str name screen_name
#> 1 1.604077e+09 1604076512 Martha Larson MarthaLSmallBiz
#> 2 8.094049e+08 809404909 Ellie Larson ellie_martha14
#> 3 1.574374e+18 1574374230032285696 Martha Larson MarthaL97567386
#> 4 1.523526e+18 1523525935592611843 Martha Larson MarthaL68880755
#> 5 4.246427e+07 42464267 Martha Larson marthal
#> 6 4.059423e+08 405942347 cup of milk & a peg MarthaLarson330
#> 7 1.559417e+09 1559416850 Onah ! MarthaLarson15
#> 8 1.562920e+18 1562919672890421248 Martha Larson marthalar423
#> 9 1.566301e+18 1566300705543098368 Martha Larson MarthaL55893693
#> 10 1.511453e+18 1511453430778409007 Martha Larson MarthaL50651868
#> 11 1.556893e+18 1556893383213326337 Martha Larson MarthaL96795092
#> 12 7.978673e+17 797867320689442816 Martha Larson MarthMLars
#> 13 1.574102e+18 1574101850202443776 Martha Larson Mar97a74609
#> 14 8.897100e+17 889710029284290560 Martha Larson martha817154
#> 15 2.552924e+09 2552924317 martha larson mllarson_57
#> 16 1.538033e+18 1538033300597805056 Martha Larson MarthaL78467075
#> 17 1.140588e+09 1140587611 Martha Larson merta0632
#> 18 8.456058e+08 845605831 martha larson marthala123
#> 19 1.207712e+08 120771218 Sarah Larson ijoined4martha
#> 20 3.177136e+09 3177136213 martha munoz-larson munoz_larson
#> location
#> 1 Davidson County Comm College
#> 2
#> 3
#> 4
#> 5 Boulder, Co
#> 6
#> 7 Bandung
#> 8
#> 9
#> 10
#> 11
#> 12 Northfield, MN
#> 13
#> 14
#> 15
#> 16 Merritt
#> 17
#> 18
#> 19
#> 20
#> description
#> 1 Small Business Center Director
#> 2 Chaug '16
#> 3
#> 4
#> 5 marketing researcher & strategist, integrated marketing maven, advertising professor and mentor, tiny dancer & supermom
#> 6
#> 7 othng special
#> 8
#> 9 faunail all
#> 10 fight
#> 11 How dare you say it's nothing to me?Baby, you're the only light I ever saw.
#> 12 Mom, musician and environmentalist
#> 13
#> 14
#> 15
#> 16 Buddy
#> 17
#> 18
#> 19
#> 20
#> url
#> 1 http://t.co/H91Osza4fE
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 http://t.co/ycVSHsI6Ra
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> 12 <NA>
#> 13 <NA>
#> 14 <NA>
#> 15 <NA>
#> 16 <NA>
#> 17 <NA>
#> 18 <NA>
#> 19 <NA>
#> 20 <NA>
#> entities.urls
#> 1 http://t.co/H91Osza4fE, http://www.davidsonccc.edu/sbc, davidsonccc.edu/sbc, 0, 22
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 http://t.co/ycVSHsI6Ra, http://www.linkedin.com/in/bullseyebranding, linkedin.com/in/bullseyebra…, 0, 22
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> 12 NULL
#> 13 NULL
#> 14 NULL
#> 15 NULL
#> 16 NULL
#> 17 NULL
#> 18 NULL
#> 19 NULL
#> 20 NULL
#> entities.urls protected followers_count friends_count listed_count
#> 1 NULL FALSE 164 134 2
#> 2 NULL FALSE 110 0 1
#> 3 NULL FALSE 0 1 0
#> 4 NULL FALSE 0 3 0
#> 5 NULL FALSE 13 62 2
#> 6 NULL FALSE 7 99 1
#> 7 NULL FALSE 3 48 0
#> 8 NULL FALSE 0 0 0
#> 9 NULL FALSE 128 0 0
#> 10 NULL FALSE 0 18 0
#> 11 NULL FALSE 0 3 0
#> 12 NULL FALSE 2 5 0
#> 13 NULL FALSE 0 0 0
#> 14 NULL FALSE 0 0 0
#> 15 NULL FALSE 2 3 0
#> 16 NULL FALSE 0 0 0
#> 17 NULL FALSE 0 0 0
#> 18 NULL FALSE 3 4 0
#> 19 NULL FALSE 1 1 0
#> 20 NULL FALSE 1 1 0
#> created_at favourites_count utc_offset time_zone geo_enabled verified
#> 1 Thu Jul 18 18:39:50 +0000 2013 954 NA NA TRUE FALSE
#> 2 Fri Sep 07 18:49:58 +0000 2012 2003 NA NA FALSE FALSE
#> 3 Mon Sep 26 12:24:24 +0000 2022 0 NA NA FALSE FALSE
#> 4 Mon May 09 04:52:14 +0000 2022 0 NA NA FALSE FALSE
#> 5 Mon May 25 19:01:43 +0000 2009 0 NA NA FALSE FALSE
#> 6 Sun Nov 06 01:19:02 +0000 2011 630 NA NA FALSE FALSE
#> 7 Mon Jul 01 02:16:15 +0000 2013 0 NA NA FALSE FALSE
#> 8 Thu Aug 25 21:48:23 +0000 2022 0 NA NA FALSE FALSE
#> 9 Sun Sep 04 05:42:44 +0000 2022 0 NA NA FALSE FALSE
#> 10 Tue Apr 05 21:19:31 +0000 2022 5 NA NA FALSE FALSE
#> 11 Tue Aug 09 06:41:44 +0000 2022 2 NA NA FALSE FALSE
#> 12 Sun Nov 13 18:22:48 +0000 2016 0 NA NA FALSE FALSE
#> 13 Sun Sep 25 18:21:42 +0000 2022 0 NA NA FALSE FALSE
#> 14 Tue Jul 25 04:52:55 +0000 2017 0 NA NA FALSE FALSE
#> 15 Sat Jun 07 16:29:26 +0000 2014 0 NA NA FALSE FALSE
#> 16 Sat Jun 18 05:38:17 +0000 2022 0 NA NA FALSE FALSE
#> 17 Fri Feb 01 19:50:09 +0000 2013 0 NA NA FALSE FALSE
#> 18 Tue Sep 25 14:12:06 +0000 2012 0 NA NA FALSE FALSE
#> 19 Sun Mar 07 14:03:56 +0000 2010 0 NA NA FALSE FALSE
#> 20 Sun Apr 26 21:37:47 +0000 2015 0 NA NA FALSE FALSE
#> statuses_count lang status.created_at status.id status.id_str
#> 1 891 NA Tue Sep 27 12:48:22 +0000 2022 1.574743e+18 1574742747197558784
#> 2 819 NA Sun May 03 00:18:11 +0000 2020 1.256740e+18 1256739796761763840
#> 3 0 NA <NA> NA <NA>
#> 4 0 NA <NA> NA <NA>
#> 5 5 NA Thu May 08 17:03:51 +0000 2014 4.644506e+17 464450620368633857
#> 6 258 NA Mon May 10 15:43:52 +0000 2021 1.391781e+18 1391781040155398150
#> 7 7 NA Wed Dec 04 18:14:38 +0000 2013 4.082983e+17 408298314543923200
#> 8 0 NA <NA> NA <NA>
#> 9 1 NA Sun Sep 04 05:42:49 +0000 2022 1.566301e+18 1566300731820445697
#> 10 1 NA Sun May 22 06:14:29 +0000 2022 1.528258e+18 1528257973977743361
#> 11 0 NA <NA> NA <NA>
#> 12 0 NA <NA> NA <NA>
#> 13 0 NA <NA> NA <NA>
#> 14 294 NA Tue Jul 25 04:54:17 +0000 2017 8.897104e+17 889710371224797184
#> 15 0 NA <NA> NA <NA>
#> 16 115 NA Wed Sep 21 12:23:43 +0000 2022 1.572562e+18 1572562214229528579
#> 17 2 NA Sun Dec 12 21:33:43 +0000 2021 1.470145e+18 1470144861181386758
#> 18 0 NA <NA> NA <NA>
#> 19 1 NA Sun Mar 07 14:05:34 +0000 2010 1.012096e+10 10120958313
#> 20 0 NA <NA> NA <NA>
#> status.text
#> 1 Business men's event - Clemmons, Lewisville, Davie county area. Join us: https://t.co/mOx3PLWROi https://t.co/qbCEybssXf
#> 2 Official website: https://t.co/aPahNTS4rp\n@elfootball2017 @tessalopez21 @gabemgermain @cassidylarson87 @Chaug2016… https://t.co/VmssLekwFf
#> 3 <NA>
#> 4 <NA>
#> 5 APBP e-news May 2014 #constantcontact http://t.co/QZ6QKMdHjA
#> 6 @DanScavino He's so awesome!
#> 7 People are asking if i'm going out with Ceallach Spellman. I'm not going out with him were just friends! So let's leave it at that -Mia Xo
#> 8 <NA>
#> 9 All that is necessary is to accept🍎 the impossible, do without the indispensable, and bear the intolerable.✈️\n#仮面ライダーギーツ
#> 10 Verifying my Web3 identity on @cyberconnecthq: #LetsCyberConnect \n https://t.co/SMdOXyv7nh \n sig:0x9cc00fb9572f1720… https://t.co/ARAi54wQ5a
#> 11 <NA>
#> 12 <NA>
#> 13 <NA>
#> 14 @Sugar_A17 @yaya_voice https://t.co/ewQBDHq5Rn
#> 15 <NA>
#> 16 RT @AptosApeSociety: 🦧🌴🚨 NFT GIVEAWAY 🚨🌴🦧\n\nAptos Ape Society 🤝 Aptos BULLS\n\n🐂💨10 WL spots for @AptosBulls \n \nTo enter:\n✅ Retweet + like\n✅…
#> 17 @fox13 Poor lady oh how I know she must love her kids! Hopefully this is not a bad story!!
#> 18 <NA>
#> 19 @MarthaStewart I want a singer confidence sewing machine
#> 20 <NA>
#> status.truncated status.entities.hashtags status.entities.symbols
#> 1 FALSE NULL NULL
#> 2 TRUE NULL NULL
#> 3 NA NULL NULL
#> 4 NA NULL NULL
#> 5 FALSE constantcontact, 21, 37 NULL
#> 6 FALSE NULL NULL
#> 7 FALSE NULL NULL
#> 8 NA NULL NULL
#> 9 FALSE 仮面ライダーギーツ, 110, 120 NULL
#> 10 TRUE LetsCyberConnect, 47, 64 NULL
#> 11 NA NULL NULL
#> 12 NA NULL NULL
#> 13 NA NULL NULL
#> 14 FALSE NULL NULL
#> 15 NA NULL NULL
#> 16 FALSE NULL NULL
#> 17 FALSE NULL NULL
#> 18 NA NULL NULL
#> 19 FALSE NULL NULL
#> 20 NA NULL NULL
#> status.entities.user_mentions
#> 1 NULL
#> 2 elfootball2017, tessalopez21, gabemgermain, cassidylarson87, Chaug2016, kevin lemke, Tessa Lopez, Gabe Germain, Cassidy, Chaug Seniors, 4291153347, 3213887165, 803977515119374336, 3884825536, 3892247901, 4291153347, 3213887165, 803977515119374336, 3884825536, 3892247901, 42, 57, 58, 71, 72, 85, 86, 102, 103, 113
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 DanScavino, Dan Scavino Jr.🇺🇸🦅, 620571475, 620571475, 0, 11
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 CyberConnectHQ, CyberConnect, 1439094074103898112, 1439094074103898115, 30, 45
#> 11 NULL
#> 12 NULL
#> 13 NULL
#> 14 NULL
#> 15 NULL
#> 16 AptosApeSociety, AptosBulls, Aptos Ape Society 🦧 (Saving Gobo soon), Aptos BULLS 🐂💨, 1514422657839685632, 1557493023101132800, 1514422657839685632, 1557493023101132800, 3, 19, 94, 105
#> 17 fox13, FOX 13 News Utah, 28152330, 28152330, 0, 6
#> 18 NULL
#> 19 MarthaStewart, Martha Stewart, 21324258, 21324258, 0, 14
#> 20 NULL
#> status.entities.urls
#> 1 https://t.co/mOx3PLWROi, https://members.lewisville-clemmons.com/events/details/winning-the-game-a-men-s-conference-6053?calendarMonth=2022-11-01&fbclid=IwAR1L7v4Ukb1sK4jpS7oLkof09HF7s2D1NA0JEqM4VzoSAWF1mS6pVJIKUJE, members.lewisville-clemmons.com/events/details…, 74, 97
#> 2 https://t.co/aPahNTS4rp, https://t.co/VmssLekwFf, https://www.rbygh.com, https://twitter.com/i/web/status/1256739796761763840, rbygh.com, twitter.com/i/web/status/1…, 18, 41, 115, 138
#> 3 NULL
#> 4 NULL
#> 5 http://t.co/QZ6QKMdHjA, http://conta.cc/Rrl4iT, conta.cc/Rrl4iT, 38, 60
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 https://t.co/SMdOXyv7nh, https://t.co/ARAi54wQ5a, https://app.cyberconnect.me/address/0x07DBFcF77609267bc1Be70CDDa43D94b5EE6fBDE, https://twitter.com/i/web/status/1528257973977743361, app.cyberconnect.me/address/0x07DB…, twitter.com/i/web/status/1…, 67, 90, 117, 140
#> 11 NULL
#> 12 NULL
#> 13 NULL
#> 14 https://t.co/ewQBDHq5Rn, http://goo.gl/kcA7Eu, goo.gl/kcA7Eu, 23, 46
#> 15 NULL
#> 16 NULL
#> 17 NULL
#> 18 NULL
#> 19 NULL
#> 20 NULL
#> status.entities.media
#> 1 1574742675806310400, 1574742675806310400, 98, 121, http://pbs.twimg.com/media/FdqcHswVUAAPvEk.jpg, https://pbs.twimg.com/media/FdqcHswVUAAPvEk.jpg, https://t.co/qbCEybssXf, pic.twitter.com/qbCEybssXf, https://twitter.com/MarthaLSmallBiz/status/1574742747197558784/photo/1, photo, 150, 150, crop, 607, 794, fit, 520, 680, fit, 607, 794, fit
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> 12 NULL
#> 13 NULL
#> 14 NULL
#> 15 NULL
#> 16 NULL
#> 17 NULL
#> 18 NULL
#> 19 NULL
#> 20 NULL
#> status.media
#> 1 1574742675806310400, 1574742717157953536, 1574742675806310400, 1574742717157953536, 98, 121, 98, 121, http://pbs.twimg.com/media/FdqcHswVUAAPvEk.jpg, http://pbs.twimg.com/media/FdqcKGzVUAAvizp.jpg, https://pbs.twimg.com/media/FdqcHswVUAAPvEk.jpg, https://pbs.twimg.com/media/FdqcKGzVUAAvizp.jpg, https://t.co/qbCEybssXf, https://t.co/qbCEybssXf, pic.twitter.com/qbCEybssXf, pic.twitter.com/qbCEybssXf, https://twitter.com/MarthaLSmallBiz/status/1574742747197558784/photo/1, https://twitter.com/MarthaLSmallBiz/status/1574742747197558784/photo/1, photo, photo, 150, 150, 150, 150, crop, crop, 607, 607, 794, 791, fit, fit, 520, 522, 680, 680, fit, fit, 607, 607, 794, 791, fit, fit
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> 12 NULL
#> 13 NULL
#> 14 NULL
#> 15 NULL
#> 16 NULL
#> 17 NULL
#> 18 NULL
#> 19 NULL
#> 20 NULL
#> status.source
#> 1 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 2 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 3 <NA>
#> 4 <NA>
#> 5 <a href="http://www.constantcontact.com" rel="nofollow">Constant Contact</a>
#> 6 <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a>
#> 7 <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a>
#> 8 <NA>
#> 9 <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a>
#> 10 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 11 <NA>
#> 12 <NA>
#> 13 <NA>
#> 14 <a href="https://mobile.twitter.com" rel="nofollow">Mobile Web (M2)</a>
#> 15 <NA>
#> 16 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 17 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 18 <NA>
#> 19 <a href="http://twitter.com" rel="nofollow">Twitter Web Client</a>
#> 20 <NA>
#> status.in_reply_to_status_id status.in_reply_to_status_id_str status.in_reply_to_user_id
#> 1 NA <NA> NA
#> 2 NA <NA> NA
#> 3 NA <NA> NA
#> 4 NA <NA> NA
#> 5 NA <NA> NA
#> 6 1.391599e+18 1391598885248831489 620571475
#> 7 NA <NA> NA
#> 8 NA <NA> NA
#> 9 NA <NA> NA
#> 10 NA <NA> NA
#> 11 NA <NA> NA
#> 12 NA <NA> NA
#> 13 NA <NA> NA
#> 14 NA <NA> NA
#> 15 NA <NA> NA
#> 16 NA <NA> NA
#> 17 1.470043e+18 1470042979758968835 28152330
#> 18 NA <NA> NA
#> 19 1.004024e+10 10040240279 21324258
#> 20 NA <NA> NA
#> status.in_reply_to_user_id_str status.in_reply_to_screen_name status.geo status.coordinates
#> 1 <NA> <NA> NA NA
#> 2 <NA> <NA> NA NA
#> 3 <NA> <NA> NA NA
#> 4 <NA> <NA> NA NA
#> 5 <NA> <NA> NA NA
#> 6 620571475 DanScavino NA NA
#> 7 <NA> <NA> NA NA
#> 8 <NA> <NA> NA NA
#> 9 <NA> <NA> NA NA
#> 10 <NA> <NA> NA NA
#> 11 <NA> <NA> NA NA
#> 12 <NA> <NA> NA NA
#> 13 <NA> <NA> NA NA
#> 14 <NA> <NA> NA NA
#> 15 <NA> <NA> NA NA
#> 16 <NA> <NA> NA NA
#> 17 28152330 fox13 NA NA
#> 18 <NA> <NA> NA NA
#> 19 21324258 MarthaStewart NA NA
#> 20 <NA> <NA> NA NA
#> status.place status.contributors status.is_quote_status status.retweet_count
#> 1 NA NA FALSE 0
#> 2 NA NA FALSE 0
#> 3 NA NA NA NA
#> 4 NA NA NA NA
#> 5 NA NA FALSE 0
#> 6 NA NA FALSE 0
#> 7 NA NA FALSE 0
#> 8 NA NA NA NA
#> 9 NA NA FALSE 0
#> 10 NA NA FALSE 0
#> 11 NA NA NA NA
#> 12 NA NA NA NA
#> 13 NA NA NA NA
#> 14 NA NA FALSE 0
#> 15 NA NA NA NA
#> 16 NA NA FALSE 303
#> 17 NA NA FALSE 0
#> 18 NA NA NA NA
#> 19 NA NA FALSE 0
#> 20 NA NA NA NA
#> status.favorite_count status.favorited status.retweeted status.possibly_sensitive status.lang
#> 1 0 FALSE FALSE FALSE en
#> 2 0 FALSE FALSE FALSE en
#> 3 NA NA NA NA <NA>
#> 4 NA NA NA NA <NA>
#> 5 1 FALSE FALSE FALSE en
#> 6 0 FALSE FALSE NA en
#> 7 0 FALSE FALSE NA en
#> 8 NA NA NA NA <NA>
#> 9 0 FALSE FALSE NA en
#> 10 0 FALSE FALSE FALSE it
#> 11 NA NA NA NA <NA>
#> 12 NA NA NA NA <NA>
#> 13 NA NA NA NA <NA>
#> 14 0 FALSE FALSE FALSE qme
#> 15 NA NA NA NA <NA>
#> 16 0 FALSE FALSE NA en
#> 17 0 FALSE FALSE NA en
#> 18 NA NA NA NA <NA>
#> 19 0 FALSE FALSE NA en
#> 20 NA NA NA NA <NA>
#> status.retweeted_status.created_at status.retweeted_status.id status.retweeted_status.id_str
#> 1 <NA> NA <NA>
#> 2 <NA> NA <NA>
#> 3 <NA> NA <NA>
#> 4 <NA> NA <NA>
#> 5 <NA> NA <NA>
#> 6 <NA> NA <NA>
#> 7 <NA> NA <NA>
#> 8 <NA> NA <NA>
#> 9 <NA> NA <NA>
#> 10 <NA> NA <NA>
#> 11 <NA> NA <NA>
#> 12 <NA> NA <NA>
#> 13 <NA> NA <NA>
#> 14 <NA> NA <NA>
#> 15 <NA> NA <NA>
#> 16 Tue Sep 20 12:24:05 +0000 2022 1.5722e+18 1572199919187906560
#> 17 <NA> NA <NA>
#> 18 <NA> NA <NA>
#> 19 <NA> NA <NA>
#> 20 <NA> NA <NA>
#> status.retweeted_status.text
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> 12 <NA>
#> 13 <NA>
#> 14 <NA>
#> 15 <NA>
#> 16 🦧🌴🚨 NFT GIVEAWAY 🚨🌴🦧\n\nAptos Ape Society 🤝 Aptos BULLS\n\n🐂💨10 WL spots for @AptosBulls \n \nTo enter:\n✅ Retweet + like… https://t.co/mR4bEQd2dg
#> 17 <NA>
#> 18 <NA>
#> 19 <NA>
#> 20 <NA>
#> status.retweeted_status.truncated status.retweeted_status.entities.hashtags
#> 1 NA NULL
#> 2 NA NULL
#> 3 NA NULL
#> 4 NA NULL
#> 5 NA NULL
#> 6 NA NULL
#> 7 NA NULL
#> 8 NA NULL
#> 9 NA NULL
#> 10 NA NULL
#> 11 NA NULL
#> 12 NA NULL
#> 13 NA NULL
#> 14 NA NULL
#> 15 NA NULL
#> 16 TRUE NULL
#> 17 NA NULL
#> 18 NA NULL
#> 19 NA NULL
#> 20 NA NULL
#> status.retweeted_status.entities.symbols
#> 1 NULL
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> 12 NULL
#> 13 NULL
#> 14 NULL
#> 15 NULL
#> 16 NULL
#> 17 NULL
#> 18 NULL
#> 19 NULL
#> 20 NULL
#> status.retweeted_status.entities.user_mentions
#> 1 NULL
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> 12 NULL
#> 13 NULL
#> 14 NULL
#> 15 NULL
#> 16 AptosBulls, Aptos BULLS 🐂💨, 1557493023101132800, 1557493023101132800, 73, 84
#> 17 NULL
#> 18 NULL
#> 19 NULL
#> 20 NULL
#> status.retweeted_status.entities.urls
#> 1 NULL
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> 12 NULL
#> 13 NULL
#> 14 NULL
#> 15 NULL
#> 16 https://t.co/mR4bEQd2dg, https://twitter.com/i/web/status/1572199919187906560, twitter.com/i/web/status/1…, 117, 140
#> 17 NULL
#> 18 NULL
#> 19 NULL
#> 20 NULL
#> status.retweeted_status.source
#> 1 <NA>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> 12 <NA>
#> 13 <NA>
#> 14 <NA>
#> 15 <NA>
#> 16 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 17 <NA>
#> 18 <NA>
#> 19 <NA>
#> 20 <NA>
#> status.retweeted_status.in_reply_to_status_id status.retweeted_status.in_reply_to_status_id_str
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> 12 NA NA
#> 13 NA NA
#> 14 NA NA
#> 15 NA NA
#> 16 NA NA
#> 17 NA NA
#> 18 NA NA
#> 19 NA NA
#> 20 NA NA
#> status.retweeted_status.in_reply_to_user_id status.retweeted_status.in_reply_to_user_id_str
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> 12 NA NA
#> 13 NA NA
#> 14 NA NA
#> 15 NA NA
#> 16 NA NA
#> 17 NA NA
#> 18 NA NA
#> 19 NA NA
#> 20 NA NA
#> status.retweeted_status.in_reply_to_screen_name status.retweeted_status.geo
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> 12 NA NA
#> 13 NA NA
#> 14 NA NA
#> 15 NA NA
#> 16 NA NA
#> 17 NA NA
#> 18 NA NA
#> 19 NA NA
#> 20 NA NA
#> status.retweeted_status.coordinates status.retweeted_status.place
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> 12 NA NA
#> 13 NA NA
#> 14 NA NA
#> 15 NA NA
#> 16 NA NA
#> 17 NA NA
#> 18 NA NA
#> 19 NA NA
#> 20 NA NA
#> status.retweeted_status.contributors status.retweeted_status.is_quote_status
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> 12 NA NA
#> 13 NA NA
#> 14 NA NA
#> 15 NA NA
#> 16 NA FALSE
#> 17 NA NA
#> 18 NA NA
#> 19 NA NA
#> 20 NA NA
#> status.retweeted_status.retweet_count status.retweeted_status.favorite_count
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> 12 NA NA
#> 13 NA NA
#> 14 NA NA
#> 15 NA NA
#> 16 303 340
#> 17 NA NA
#> 18 NA NA
#> 19 NA NA
#> 20 NA NA
#> status.retweeted_status.favorited status.retweeted_status.retweeted
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> 12 NA NA
#> 13 NA NA
#> 14 NA NA
#> 15 NA NA
#> 16 FALSE FALSE
#> 17 NA NA
#> 18 NA NA
#> 19 NA NA
#> 20 NA NA
#> status.retweeted_status.possibly_sensitive status.retweeted_status.lang contributors_enabled
#> 1 NA <NA> FALSE
#> 2 NA <NA> FALSE
#> 3 NA <NA> FALSE
#> 4 NA <NA> FALSE
#> 5 NA <NA> FALSE
#> 6 NA <NA> FALSE
#> 7 NA <NA> FALSE
#> 8 NA <NA> FALSE
#> 9 NA <NA> FALSE
#> 10 NA <NA> FALSE
#> 11 NA <NA> FALSE
#> 12 NA <NA> FALSE
#> 13 NA <NA> FALSE
#> 14 NA <NA> FALSE
#> 15 NA <NA> FALSE
#> 16 FALSE en FALSE
#> 17 NA <NA> FALSE
#> 18 NA <NA> FALSE
#> 19 NA <NA> FALSE
#> 20 NA <NA> FALSE
#> is_translator is_translation_enabled profile_background_color
#> 1 FALSE FALSE C0DEED
#> 2 FALSE FALSE 191425
#> 3 FALSE FALSE F5F8FA
#> 4 FALSE FALSE F5F8FA
#> 5 FALSE FALSE C0DEED
#> 6 FALSE FALSE EDECE9
#> 7 FALSE FALSE C0DEED
#> 8 FALSE FALSE F5F8FA
#> 9 FALSE FALSE F5F8FA
#> 10 FALSE FALSE F5F8FA
#> 11 FALSE FALSE F5F8FA
#> 12 FALSE FALSE F5F8FA
#> 13 FALSE FALSE F5F8FA
#> 14 FALSE FALSE F5F8FA
#> 15 FALSE FALSE C0DEED
#> 16 FALSE FALSE F5F8FA
#> 17 FALSE FALSE C0DEED
#> 18 FALSE FALSE C0DEED
#> 19 FALSE FALSE C0DEED
#> 20 FALSE FALSE C0DEED
#> profile_background_image_url
#> 1 http://abs.twimg.com/images/themes/theme1/bg.png
#> 2 http://abs.twimg.com/images/themes/theme4/bg.gif
#> 3 <NA>
#> 4 <NA>
#> 5 http://abs.twimg.com/images/themes/theme1/bg.png
#> 6 http://abs.twimg.com/images/themes/theme3/bg.gif
#> 7 http://abs.twimg.com/images/themes/theme1/bg.png
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> 12 <NA>
#> 13 <NA>
#> 14 <NA>
#> 15 http://abs.twimg.com/images/themes/theme1/bg.png
#> 16 <NA>
#> 17 http://abs.twimg.com/images/themes/theme1/bg.png
#> 18 http://abs.twimg.com/images/themes/theme1/bg.png
#> 19 http://abs.twimg.com/images/themes/theme1/bg.png
#> 20 http://abs.twimg.com/images/themes/theme1/bg.png
#> profile_background_image_url_https profile_background_tile
#> 1 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 2 https://abs.twimg.com/images/themes/theme4/bg.gif TRUE
#> 3 <NA> FALSE
#> 4 <NA> FALSE
#> 5 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 6 https://abs.twimg.com/images/themes/theme3/bg.gif FALSE
#> 7 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 8 <NA> FALSE
#> 9 <NA> FALSE
#> 10 <NA> FALSE
#> 11 <NA> FALSE
#> 12 <NA> FALSE
#> 13 <NA> FALSE
#> 14 <NA> FALSE
#> 15 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 16 <NA> FALSE
#> 17 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 18 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 19 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 20 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> profile_image_url
#> 1 http://pbs.twimg.com/profile_images/1294285492490571781/oh-uQgbk_normal.jpg
#> 2 http://pbs.twimg.com/profile_images/655890169497853952/LpXteQcA_normal.jpg
#> 3 http://pbs.twimg.com/profile_images/1574374495871447040/pKke0dvW_normal.jpg
#> 4 http://pbs.twimg.com/profile_images/1523526235468570625/AYcwRXnW_normal.png
#> 5 http://pbs.twimg.com/profile_images/1349977560/edit_normal.jpg
#> 6 http://pbs.twimg.com/profile_images/1269453420735483915/WSDBSXVw_normal.jpg
#> 7 http://pbs.twimg.com/profile_images/378800000829444551/208285ab0a504381d552cb81f1bedfb8_normal.jpeg
#> 8 http://pbs.twimg.com/profile_images/1562919844307431424/itbfe3Nv_normal.png
#> 9 http://pbs.twimg.com/profile_images/1566300719895961600/sppqhg8p_normal.png
#> 10 http://pbs.twimg.com/profile_images/1525395116923715584/MKDLxJz2_normal.jpg
#> 11 http://pbs.twimg.com/profile_images/1556894481642921986/OrfX-mvh_normal.jpg
#> 12 http://pbs.twimg.com/profile_images/798181257020604417/hNq2J-bJ_normal.jpg
#> 13 http://pbs.twimg.com/profile_images/1574101955294932992/_Kw44woa_normal.jpg
#> 14 http://pbs.twimg.com/profile_images/889710091750060032/Xx_yPFh__normal.jpg
#> 15 http://pbs.twimg.com/profile_images/475314518457729024/oyyyCBYy_normal.jpeg
#> 16 http://pbs.twimg.com/profile_images/1566790454179348480/kCr2Zp5f_normal.jpg
#> 17 http://pbs.twimg.com/profile_images/1087455786144415745/_4gy9Kn0_normal.jpg
#> 18 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 19 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 20 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> profile_image_url_https
#> 1 https://pbs.twimg.com/profile_images/1294285492490571781/oh-uQgbk_normal.jpg
#> 2 https://pbs.twimg.com/profile_images/655890169497853952/LpXteQcA_normal.jpg
#> 3 https://pbs.twimg.com/profile_images/1574374495871447040/pKke0dvW_normal.jpg
#> 4 https://pbs.twimg.com/profile_images/1523526235468570625/AYcwRXnW_normal.png
#> 5 https://pbs.twimg.com/profile_images/1349977560/edit_normal.jpg
#> 6 https://pbs.twimg.com/profile_images/1269453420735483915/WSDBSXVw_normal.jpg
#> 7 https://pbs.twimg.com/profile_images/378800000829444551/208285ab0a504381d552cb81f1bedfb8_normal.jpeg
#> 8 https://pbs.twimg.com/profile_images/1562919844307431424/itbfe3Nv_normal.png
#> 9 https://pbs.twimg.com/profile_images/1566300719895961600/sppqhg8p_normal.png
#> 10 https://pbs.twimg.com/profile_images/1525395116923715584/MKDLxJz2_normal.jpg
#> 11 https://pbs.twimg.com/profile_images/1556894481642921986/OrfX-mvh_normal.jpg
#> 12 https://pbs.twimg.com/profile_images/798181257020604417/hNq2J-bJ_normal.jpg
#> 13 https://pbs.twimg.com/profile_images/1574101955294932992/_Kw44woa_normal.jpg
#> 14 https://pbs.twimg.com/profile_images/889710091750060032/Xx_yPFh__normal.jpg
#> 15 https://pbs.twimg.com/profile_images/475314518457729024/oyyyCBYy_normal.jpeg
#> 16 https://pbs.twimg.com/profile_images/1566790454179348480/kCr2Zp5f_normal.jpg
#> 17 https://pbs.twimg.com/profile_images/1087455786144415745/_4gy9Kn0_normal.jpg
#> 18 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 19 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 20 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> profile_banner_url profile_link_color
#> 1 https://pbs.twimg.com/profile_banners/1604076512/1398448088 16ACE3
#> 2 https://pbs.twimg.com/profile_banners/809404909/1445211414 4DA5B3
#> 3 https://pbs.twimg.com/profile_banners/1574374230032285696/1664195571 1DA1F2
#> 4 <NA> 1DA1F2
#> 5 <NA> 1DA1F2
#> 6 <NA> 088253
#> 7 <NA> 1DA1F2
#> 8 <NA> 1DA1F2
#> 9 https://pbs.twimg.com/profile_banners/1566300705543098368/1662270168 1DA1F2
#> 10 <NA> 1DA1F2
#> 11 https://pbs.twimg.com/profile_banners/1556893383213326337/1660027546 1DA1F2
#> 12 <NA> 1DA1F2
#> 13 <NA> 1DA1F2
#> 14 <NA> 1DA1F2
#> 15 <NA> 1DA1F2
#> 16 https://pbs.twimg.com/profile_banners/1538033300597805056/1662386931 1DA1F2
#> 17 <NA> 1DA1F2
#> 18 <NA> 1DA1F2
#> 19 <NA> 1DA1F2
#> 20 <NA> 1DA1F2
#> profile_sidebar_border_color profile_sidebar_fill_color profile_text_color
#> 1 C0DEED DDEEF6 333333
#> 2 FFFFFF BAEEB9 77D1BF
#> 3 C0DEED DDEEF6 333333
#> 4 C0DEED DDEEF6 333333
#> 5 C0DEED DDEEF6 333333
#> 6 D3D2CF E3E2DE 634047
#> 7 C0DEED DDEEF6 333333
#> 8 C0DEED DDEEF6 333333
#> 9 C0DEED DDEEF6 333333
#> 10 C0DEED DDEEF6 333333
#> 11 C0DEED DDEEF6 333333
#> 12 C0DEED DDEEF6 333333
#> 13 C0DEED DDEEF6 333333
#> 14 C0DEED DDEEF6 333333
#> 15 C0DEED DDEEF6 333333
#> 16 C0DEED DDEEF6 333333
#> 17 C0DEED DDEEF6 333333
#> 18 C0DEED DDEEF6 333333
#> 19 C0DEED DDEEF6 333333
#> 20 C0DEED DDEEF6 333333
#> profile_use_background_image has_extended_profile default_profile default_profile_image
#> 1 TRUE FALSE FALSE FALSE
#> 2 TRUE FALSE FALSE FALSE
#> 3 TRUE TRUE TRUE FALSE
#> 4 TRUE TRUE TRUE FALSE
#> 5 TRUE FALSE TRUE FALSE
#> 6 TRUE FALSE FALSE FALSE
#> 7 TRUE FALSE TRUE FALSE
#> 8 TRUE TRUE TRUE FALSE
#> 9 TRUE TRUE TRUE FALSE
#> 10 TRUE TRUE TRUE FALSE
#> 11 TRUE TRUE TRUE FALSE
#> 12 TRUE TRUE TRUE FALSE
#> 13 TRUE TRUE TRUE FALSE
#> 14 TRUE FALSE TRUE FALSE
#> 15 TRUE FALSE TRUE FALSE
#> 16 TRUE TRUE TRUE FALSE
#> 17 TRUE FALSE TRUE FALSE
#> 18 TRUE FALSE TRUE TRUE
#> 19 TRUE FALSE TRUE TRUE
#> 20 TRUE FALSE TRUE TRUE
#> following follow_request_sent notifications translator_type withheld_in_countries
#> 1 FALSE FALSE FALSE none NULL
#> 2 FALSE FALSE FALSE none NULL
#> 3 FALSE FALSE FALSE none NULL
#> 4 FALSE FALSE FALSE none NULL
#> 5 FALSE FALSE FALSE none NULL
#> 6 FALSE FALSE FALSE none NULL
#> 7 FALSE FALSE FALSE none NULL
#> 8 FALSE FALSE FALSE none NULL
#> 9 FALSE FALSE FALSE none NULL
#> 10 FALSE FALSE FALSE none NULL
#> 11 FALSE FALSE FALSE none NULL
#> 12 FALSE FALSE FALSE none NULL
#> 13 FALSE FALSE FALSE none NULL
#> 14 FALSE FALSE FALSE none NULL
#> 15 FALSE FALSE FALSE none NULL
#> 16 FALSE FALSE FALSE none NULL
#> 17 FALSE FALSE FALSE none NULL
#> 18 FALSE FALSE FALSE none NULL
#> 19 FALSE FALSE FALSE none NULL
#> 20 FALSE FALSE FALSE none NULL
#>
#>
#> [[4]]
#> [[4]][[1]]
#> id id_str name screen_name location
#> 1 1.240472e+07 12404722 elena_marchiori elena_ Lugano, Switzerland
#> 2 3.559587e+09 3559587203 Elena Marchiori ElenaCMarchiori Thiene, Veneto
#> 3 2.865915e+09 2865914557 Elena Marchiori marchiori_elena
#> 4 7.260743e+17 726074330606657536 elena marchiori elenamarchiori1
#> 5 1.524665e+18 1524665155803664384 elena marchiori elenamarchiori2
#> 6 3.464756e+08 346475629 { Elena Marchiori } ElenaMarchiori
#> 7 1.423251e+18 1423251136446930948 Elena Marchiori elena_marchiori
#> 8 1.438985e+09 1438985154 elena marchiori MarchioriElena
#> 9 3.044610e+09 3044610372 Elena Marchiori e4cfaacab2374ee
#> 10 7.303932e+17 730393158627012608 Elena Marchiori ElenaMarchiori3
#> 11 1.281467e+09 1281466886 Elena ele_marchiori
#> description
#> 1 digital comm, happy wife & mom of two
#> 2 Responsabile di Selezione e Servizio - Adecco Italia SpA - Filiale di Thiene\n- coffee/foodblogging/TvSeries addicted - \n#dontgiveup
#> 3
#> 4
#> 5
#> 6 I'm a dreamer I'm a traveler
#> 7
#> 8
#> 9
#> 10
#> 11
#> url
#> 1 https://t.co/TLXYxRjTti
#> 2 https://t.co/F8pjwHdo76
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> entities.urls
#> 1 https://t.co/TLXYxRjTti, http://elenamarchiori.com, elenamarchiori.com, 0, 23
#> 2 https://t.co/F8pjwHdo76, https://it.linkedin.com/in/elemarchiori, it.linkedin.com/in/elemarchiori, 0, 23
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> entities.urls protected followers_count friends_count listed_count
#> 1 NULL FALSE 929 587 49
#> 2 NULL FALSE 83 245 0
#> 3 NULL FALSE 0 7 0
#> 4 NULL FALSE 22 166 0
#> 5 NULL FALSE 0 1 0
#> 6 NULL FALSE 21 0 0
#> 7 NULL FALSE 0 2 0
#> 8 NULL FALSE 23 160 1
#> 9 NULL FALSE 72 307 0
#> 10 NULL FALSE 1 33 0
#> 11 NULL FALSE 0 1 0
#> created_at favourites_count utc_offset time_zone geo_enabled verified
#> 1 Fri Jan 18 15:56:54 +0000 2008 214 NA NA FALSE FALSE
#> 2 Sat Sep 05 21:53:14 +0000 2015 1292 NA NA FALSE FALSE
#> 3 Sun Oct 19 21:46:04 +0000 2014 2 NA NA FALSE FALSE
#> 4 Fri Apr 29 15:43:05 +0000 2016 2 NA NA FALSE FALSE
#> 5 Thu May 12 08:18:12 +0000 2022 0 NA NA FALSE FALSE
#> 6 Mon Aug 01 09:50:41 +0000 2011 2 NA NA FALSE FALSE
#> 7 Thu Aug 05 11:55:26 +0000 2021 4 NA NA FALSE FALSE
#> 8 Sat May 18 17:55:36 +0000 2013 1344 NA NA FALSE FALSE
#> 9 Thu Feb 26 20:57:52 +0000 2015 142 NA NA TRUE FALSE
#> 10 Wed May 11 13:44:33 +0000 2016 3 NA NA FALSE FALSE
#> 11 Tue Mar 19 20:39:24 +0000 2013 0 NA NA FALSE FALSE
#> statuses_count lang status.created_at status.id status.id_str
#> 1 1697 NA Thu Apr 28 13:06:23 +0000 2022 1.519664e+18 1519664325702660098
#> 2 430 NA Tue Jul 06 16:33:32 +0000 2021 1.412450e+18 1412449647726141440
#> 3 0 NA <NA> NA <NA>
#> 4 7 NA Sat May 06 18:41:56 +0000 2017 8.609276e+17 860927629532246017
#> 5 0 NA <NA> NA <NA>
#> 6 63 NA Tue Dec 17 20:16:36 +0000 2013 4.130401e+17 413040051879411712
#> 7 0 NA <NA> NA <NA>
#> 8 940 NA Fri Sep 16 11:55:36 +0000 2022 1.570743e+18 1570743200490614791
#> 9 506 NA Sun Jun 07 05:10:07 +0000 2015 6.074142e+17 607414208595042304
#> 10 8 NA Fri Apr 28 14:57:19 +0000 2017 8.579720e+17 857971997447516162
#> 11 0 NA <NA> NA <NA>
#> status.text
#> 1 RT @LuganoLivingLab: Nasce eQuiD! Un nuovo servizio per la cittadinanza \ndedicato al riuso dei dispositivi elettronici 💻♻\n\nScopri di più e…
#> 2 RT @luca_paladini4: Il fegato ha tenuto.\nNon era scontato\n\n#DDLZan\n#omofobia https://t.co/Y13AyJTXRy
#> 3 <NA>
#> 4 RT @PupiaTv: Napoli, la Banda dell'Arma dei Carabinieri rende omaggio a Totò - https://t.co/EOkQRTQd2Y https://t.co/5gKVozROTz
#> 5 <NA>
#> 6 Presto al cinema per Pif @fanpage http://t.co/mBhKCKsOxo
#> 7 <NA>
#> 8 @Gretao90 Ed è fantastico ..... peccato che in tanti abbiano il prosciutto sugli occhi
#> 9 Grande amore
#> 10 Arma dei carabinieri
#> 11 <NA>
#> status.truncated status.entities.hashtags status.entities.symbols
#> 1 FALSE NULL NULL
#> 2 FALSE DDLZan, omofobia, 59, 66, 67, 76 NULL
#> 3 NA NULL NULL
#> 4 FALSE NULL NULL
#> 5 NA NULL NULL
#> 6 FALSE NULL NULL
#> 7 NA NULL NULL
#> 8 FALSE NULL NULL
#> 9 FALSE NULL NULL
#> 10 FALSE NULL NULL
#> 11 NA NULL NULL
#> status.entities.user_mentions
#> 1 LuganoLivingLab, Lugano Living Lab, 1108085301732405248, 1108085301732405248, 3, 19
#> 2 luca_paladini4, Luca Paladini, 723084665209393152, 723084665209393152, 3, 18
#> 3 NULL
#> 4 PupiaTv, Pupia, 77637855, 77637855, 3, 11
#> 5 NULL
#> 6 fanpage, Fanpage.it, 213254229, 213254229, 25, 33
#> 7 NULL
#> 8 Gretao90, Greta ◟̽◞̽, 1230964883262492672, 1230964883262492673, 0, 9
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> status.entities.urls
#> 1 NULL
#> 2 NULL
#> 3 NULL
#> 4 https://t.co/EOkQRTQd2Y, https://goo.gl/WtJSkX, goo.gl/WtJSkX, 79, 102
#> 5 NULL
#> 6 http://t.co/mBhKCKsOxo, http://cinema.fanpage.it/emozioni-ed-applausi-per-pif-al-modernissimo-di-napoli-video/, cinema.fanpage.it/emozioni-ed-ap…, 34, 56
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> status.entities.media
#> 1 NULL
#> 2 1407845113297047552, 1407845113297047564, 77, 100, http://pbs.twimg.com/media/E4mrq-TXEAwSotG.jpg, https://pbs.twimg.com/media/E4mrq-TXEAwSotG.jpg, https://t.co/Y13AyJTXRy, pic.twitter.com/Y13AyJTXRy, https://twitter.com/luca_paladini4/status/1407845115402633218/photo/1, photo, 1215, 1080, fit, 150, 150, crop, 680, 604, fit, 1200, 1067, fit, 1407845115402633216, 1407845115402633218, 723084665209393152, 723084665209393152
#> 3 NULL
#> 4 860860409741553664, 860860409741553665, 103, 126, http://pbs.twimg.com/media/C_Jj-0vXsAEzV2Z.jpg, https://pbs.twimg.com/media/C_Jj-0vXsAEzV2Z.jpg, https://t.co/5gKVozROTz, pic.twitter.com/5gKVozROTz, https://twitter.com/PupiaTv/status/860860411142426624/photo/1, photo, 300, 300, fit, 150, 150, crop, 300, 300, fit, 300, 300, fit, 860860411142426624, 860860411142426624, 77637855, 77637855
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> status.source
#> 1 <a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>
#> 2 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 3 <NA>
#> 4 <a href="http://www.twitter.com" rel="nofollow">Twitter for Windows Phone</a>
#> 5 <NA>
#> 6 <a href="http://www.apple.com" rel="nofollow">iOS</a>
#> 7 <NA>
#> 8 <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a>
#> 9 <a href="http://www.cloudhopper.com/" rel="nofollow">Twitter SMS</a>
#> 10 <a href="https://mobile.twitter.com" rel="nofollow">Mobile Web (M2)</a>
#> 11 <NA>
#> status.in_reply_to_status_id status.in_reply_to_status_id_str status.in_reply_to_user_id
#> 1 NA <NA> NA
#> 2 NA <NA> NA
#> 3 NA <NA> NA
#> 4 NA <NA> NA
#> 5 NA <NA> NA
#> 6 NA <NA> NA
#> 7 NA <NA> NA
#> 8 1.57037e+18 1570370488450383873 1.230965e+18
#> 9 NA <NA> NA
#> 10 NA <NA> NA
#> 11 NA <NA> NA
#> status.in_reply_to_user_id_str status.in_reply_to_screen_name status.geo status.coordinates
#> 1 <NA> <NA> NA NA
#> 2 <NA> <NA> NA NA
#> 3 <NA> <NA> NA NA
#> 4 <NA> <NA> NA NA
#> 5 <NA> <NA> NA NA
#> 6 <NA> <NA> NA NA
#> 7 <NA> <NA> NA NA
#> 8 1230964883262492673 Gretao90 NA NA
#> 9 <NA> <NA> NA NA
#> 10 <NA> <NA> NA NA
#> 11 <NA> <NA> NA NA
#> status.place status.contributors status.retweeted_status.created_at status.retweeted_status.id
#> 1 NA NA Fri Apr 22 09:27:34 +0000 2022 1.517435e+18
#> 2 NA NA Wed Jun 23 23:36:46 +0000 2021 1.407845e+18
#> 3 NA NA <NA> NA
#> 4 NA NA Sat May 06 14:14:50 +0000 2017 8.608604e+17
#> 5 NA NA <NA> NA
#> 6 NA NA <NA> NA
#> 7 NA NA <NA> NA
#> 8 NA NA <NA> NA
#> 9 NA NA <NA> NA
#> 10 NA NA <NA> NA
#> 11 NA NA <NA> NA
#> status.retweeted_status.id_str
#> 1 1517434930338353152
#> 2 1407845115402633218
#> 3 <NA>
#> 4 860860411142426624
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> status.retweeted_status.text
#> 1 Nasce eQuiD! Un nuovo servizio per la cittadinanza \ndedicato al riuso dei dispositivi elettronici 💻♻\n\nScopri di più… https://t.co/1YjYjafN2s
#> 2 Il fegato ha tenuto.\nNon era scontato\n\n#DDLZan\n#omofobia https://t.co/Y13AyJTXRy
#> 3 <NA>
#> 4 Napoli, la Banda dell'Arma dei Carabinieri rende omaggio a Totò - https://t.co/EOkQRTQd2Y https://t.co/5gKVozROTz
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> status.retweeted_status.truncated status.retweeted_status.entities.hashtags
#> 1 TRUE NULL
#> 2 FALSE DDLZan, omofobia, 39, 46, 47, 56
#> 3 NA NULL
#> 4 FALSE NULL
#> 5 NA NULL
#> 6 NA NULL
#> 7 NA NULL
#> 8 NA NULL
#> 9 NA NULL
#> 10 NA NULL
#> 11 NA NULL
#> status.retweeted_status.entities.symbols status.retweeted_status.entities.user_mentions
#> 1 NULL NULL
#> 2 NULL NULL
#> 3 NULL NULL
#> 4 NULL NULL
#> 5 NULL NULL
#> 6 NULL NULL
#> 7 NULL NULL
#> 8 NULL NULL
#> 9 NULL NULL
#> 10 NULL NULL
#> 11 NULL NULL
#> status.retweeted_status.entities.urls
#> 1 https://t.co/1YjYjafN2s, https://twitter.com/i/web/status/1517434930338353152, twitter.com/i/web/status/1…, 117, 140
#> 2 NULL
#> 3 NULL
#> 4 https://t.co/EOkQRTQd2Y, https://goo.gl/WtJSkX, goo.gl/WtJSkX, 66, 89
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> status.retweeted_status.entities.media
#> 1 NULL
#> 2 1407845113297047552, 1407845113297047564, 57, 80, http://pbs.twimg.com/media/E4mrq-TXEAwSotG.jpg, https://pbs.twimg.com/media/E4mrq-TXEAwSotG.jpg, https://t.co/Y13AyJTXRy, pic.twitter.com/Y13AyJTXRy, https://twitter.com/luca_paladini4/status/1407845115402633218/photo/1, photo, 1215, 1080, fit, 150, 150, crop, 680, 604, fit, 1200, 1067, fit
#> 3 NULL
#> 4 860860409741553664, 860860409741553665, 90, 113, http://pbs.twimg.com/media/C_Jj-0vXsAEzV2Z.jpg, https://pbs.twimg.com/media/C_Jj-0vXsAEzV2Z.jpg, https://t.co/5gKVozROTz, pic.twitter.com/5gKVozROTz, https://twitter.com/PupiaTv/status/860860411142426624/photo/1, photo, 300, 300, fit, 150, 150, crop, 300, 300, fit, 300, 300, fit
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> status.retweeted_status.source
#> 1 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 2 <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a>
#> 3 <NA>
#> 4 <a href="http://www.pupia.tv" rel="nofollow">pupia.tv</a>
#> 5 <NA>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#> status.retweeted_status.in_reply_to_status_id status.retweeted_status.in_reply_to_status_id_str
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> status.retweeted_status.in_reply_to_user_id status.retweeted_status.in_reply_to_user_id_str
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> status.retweeted_status.in_reply_to_screen_name status.retweeted_status.geo
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> status.retweeted_status.coordinates status.retweeted_status.place
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> status.retweeted_status.contributors status.retweeted_status.is_quote_status
#> 1 NA FALSE
#> 2 NA FALSE
#> 3 NA NA
#> 4 NA FALSE
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> status.retweeted_status.retweet_count status.retweeted_status.favorite_count
#> 1 6 10
#> 2 2 85
#> 3 NA NA
#> 4 1 1
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> status.retweeted_status.favorited status.retweeted_status.retweeted
#> 1 FALSE FALSE
#> 2 FALSE FALSE
#> 3 NA NA
#> 4 FALSE FALSE
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> 10 NA NA
#> 11 NA NA
#> status.retweeted_status.possibly_sensitive status.retweeted_status.lang
#> 1 FALSE it
#> 2 FALSE it
#> 3 NA <NA>
#> 4 FALSE it
#> 5 NA <NA>
#> 6 NA <NA>
#> 7 NA <NA>
#> 8 NA <NA>
#> 9 NA <NA>
#> 10 NA <NA>
#> 11 NA <NA>
#> status.retweeted_status.media
#> 1 NULL
#> 2 1407845113297047552, 1407845113297047564, 57, 80, http://pbs.twimg.com/media/E4mrq-TXEAwSotG.jpg, https://pbs.twimg.com/media/E4mrq-TXEAwSotG.jpg, https://t.co/Y13AyJTXRy, pic.twitter.com/Y13AyJTXRy, https://twitter.com/luca_paladini4/status/1407845115402633218/photo/1, photo, 1215, 1080, fit, 150, 150, crop, 680, 604, fit, 1200, 1067, fit
#> 3 NULL
#> 4 860860409741553664, 860860409741553665, 90, 113, http://pbs.twimg.com/media/C_Jj-0vXsAEzV2Z.jpg, https://pbs.twimg.com/media/C_Jj-0vXsAEzV2Z.jpg, https://t.co/5gKVozROTz, pic.twitter.com/5gKVozROTz, https://twitter.com/PupiaTv/status/860860411142426624/photo/1, photo, 300, 300, fit, 150, 150, crop, 300, 300, fit, 300, 300, fit
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> status.is_quote_status status.retweet_count status.favorite_count status.favorited
#> 1 FALSE 6 0 FALSE
#> 2 FALSE 2 0 FALSE
#> 3 NA NA NA NA
#> 4 FALSE 1 0 FALSE
#> 5 NA NA NA NA
#> 6 FALSE 0 0 FALSE
#> 7 NA NA NA NA
#> 8 FALSE 0 0 FALSE
#> 9 FALSE 0 2 FALSE
#> 10 FALSE 0 0 FALSE
#> 11 NA NA NA NA
#> status.retweeted status.lang
#> 1 FALSE it
#> 2 FALSE it
#> 3 NA <NA>
#> 4 FALSE it
#> 5 NA <NA>
#> 6 FALSE it
#> 7 NA <NA>
#> 8 FALSE it
#> 9 FALSE es
#> 10 FALSE it
#> 11 NA <NA>
#> status.media
#> 1 NULL
#> 2 1407845113297047552, 1407845113297047564, 77, 100, http://pbs.twimg.com/media/E4mrq-TXEAwSotG.jpg, https://pbs.twimg.com/media/E4mrq-TXEAwSotG.jpg, https://t.co/Y13AyJTXRy, pic.twitter.com/Y13AyJTXRy, https://twitter.com/luca_paladini4/status/1407845115402633218/photo/1, photo, 1215, 1080, fit, 150, 150, crop, 680, 604, fit, 1200, 1067, fit, 1407845115402633216, 1407845115402633218, 723084665209393152, 723084665209393152
#> 3 NULL
#> 4 860860409741553664, 860860409741553665, 103, 126, http://pbs.twimg.com/media/C_Jj-0vXsAEzV2Z.jpg, https://pbs.twimg.com/media/C_Jj-0vXsAEzV2Z.jpg, https://t.co/5gKVozROTz, pic.twitter.com/5gKVozROTz, https://twitter.com/PupiaTv/status/860860411142426624/photo/1, photo, 300, 300, fit, 150, 150, crop, 300, 300, fit, 300, 300, fit, 860860411142426624, 860860411142426624, 77637855, 77637855
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> 10 NULL
#> 11 NULL
#> status.possibly_sensitive contributors_enabled is_translator is_translation_enabled
#> 1 NA FALSE FALSE FALSE
#> 2 FALSE FALSE FALSE FALSE
#> 3 NA FALSE FALSE FALSE
#> 4 FALSE FALSE FALSE FALSE
#> 5 NA FALSE FALSE FALSE
#> 6 FALSE FALSE FALSE FALSE
#> 7 NA FALSE FALSE FALSE
#> 8 NA FALSE FALSE FALSE
#> 9 NA FALSE FALSE FALSE
#> 10 NA FALSE FALSE FALSE
#> 11 NA FALSE FALSE FALSE
#> profile_background_color profile_background_image_url
#> 1 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 2 000000 http://abs.twimg.com/images/themes/theme1/bg.png
#> 3 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 4 F5F8FA <NA>
#> 5 F5F8FA <NA>
#> 6 F2DECB http://abs.twimg.com/images/themes/theme17/bg.gif
#> 7 F5F8FA <NA>
#> 8 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 9 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 10 F5F8FA <NA>
#> 11 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> profile_background_image_url_https profile_background_tile
#> 1 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 2 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 3 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 4 <NA> FALSE
#> 5 <NA> FALSE
#> 6 https://abs.twimg.com/images/themes/theme17/bg.gif TRUE
#> 7 <NA> FALSE
#> 8 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 9 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 10 <NA> FALSE
#> 11 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> profile_image_url
#> 1 http://pbs.twimg.com/profile_images/656577995/elena_twitter_normal.bmp
#> 2 http://pbs.twimg.com/profile_images/640632181161914368/jSBjZjN8_normal.jpg
#> 3 http://pbs.twimg.com/profile_images/523953468323938304/RuGUnYn7_normal.jpeg
#> 4 http://pbs.twimg.com/profile_images/726075082955706369/3sjabuNC_normal.jpg
#> 5 http://pbs.twimg.com/profile_images/1524665231640870916/xJP9NKTh_normal.png
#> 6 http://pbs.twimg.com/profile_images/378800000852243407/2bfca1583fa138e519c1d0b72735cf7b_normal.jpeg
#> 7 http://pbs.twimg.com/profile_images/1423251296145100802/1c1Re0KD_normal.png
#> 8 http://pbs.twimg.com/profile_images/706932555841478658/TAMJtYWY_normal.jpg
#> 9 http://pbs.twimg.com/profile_images/571344250962644992/jJysM6vm_normal.png
#> 10 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 11 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> profile_image_url_https
#> 1 https://pbs.twimg.com/profile_images/656577995/elena_twitter_normal.bmp
#> 2 https://pbs.twimg.com/profile_images/640632181161914368/jSBjZjN8_normal.jpg
#> 3 https://pbs.twimg.com/profile_images/523953468323938304/RuGUnYn7_normal.jpeg
#> 4 https://pbs.twimg.com/profile_images/726075082955706369/3sjabuNC_normal.jpg
#> 5 https://pbs.twimg.com/profile_images/1524665231640870916/xJP9NKTh_normal.png
#> 6 https://pbs.twimg.com/profile_images/378800000852243407/2bfca1583fa138e519c1d0b72735cf7b_normal.jpeg
#> 7 https://pbs.twimg.com/profile_images/1423251296145100802/1c1Re0KD_normal.png
#> 8 https://pbs.twimg.com/profile_images/706932555841478658/TAMJtYWY_normal.jpg
#> 9 https://pbs.twimg.com/profile_images/571344250962644992/jJysM6vm_normal.png
#> 10 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 11 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> profile_link_color profile_sidebar_border_color profile_sidebar_fill_color profile_text_color
#> 1 1DA1F2 C0DEED DDEEF6 333333
#> 2 4A913C 000000 000000 000000
#> 3 1DA1F2 C0DEED DDEEF6 333333
#> 4 1DA1F2 C0DEED DDEEF6 333333
#> 5 1DA1F2 C0DEED DDEEF6 333333
#> 6 004947 FFFFFF 002E33 8F765B
#> 7 1DA1F2 C0DEED DDEEF6 333333
#> 8 1DA1F2 C0DEED DDEEF6 333333
#> 9 1DA1F2 C0DEED DDEEF6 333333
#> 10 1DA1F2 C0DEED DDEEF6 333333
#> 11 1DA1F2 C0DEED DDEEF6 333333
#> profile_use_background_image has_extended_profile default_profile default_profile_image
#> 1 TRUE FALSE TRUE FALSE
#> 2 FALSE TRUE FALSE FALSE
#> 3 TRUE FALSE TRUE FALSE
#> 4 TRUE FALSE TRUE FALSE
#> 5 TRUE TRUE TRUE FALSE
#> 6 TRUE FALSE FALSE FALSE
#> 7 TRUE TRUE TRUE FALSE
#> 8 TRUE FALSE TRUE FALSE
#> 9 TRUE FALSE TRUE FALSE
#> 10 TRUE FALSE TRUE TRUE
#> 11 TRUE FALSE TRUE TRUE
#> following follow_request_sent notifications translator_type withheld_in_countries
#> 1 FALSE FALSE FALSE none NULL
#> 2 FALSE FALSE FALSE none NULL
#> 3 FALSE FALSE FALSE none NULL
#> 4 FALSE FALSE FALSE none NULL
#> 5 FALSE FALSE FALSE none NULL
#> 6 FALSE FALSE FALSE none NULL
#> 7 FALSE FALSE FALSE none NULL
#> 8 FALSE FALSE FALSE none NULL
#> 9 FALSE FALSE FALSE none NULL
#> 10 FALSE FALSE FALSE none NULL
#> 11 FALSE FALSE FALSE none NULL
#> profile_banner_url
#> 1 <NA>
#> 2 https://pbs.twimg.com/profile_banners/3559587203/1585831435
#> 3 <NA>
#> 4 https://pbs.twimg.com/profile_banners/726074330606657536/1461944765
#> 5 <NA>
#> 6 https://pbs.twimg.com/profile_banners/346475629/1386631843
#> 7 <NA>
#> 8 https://pbs.twimg.com/profile_banners/1438985154/1457380954
#> 9 <NA>
#> 10 <NA>
#> 11 <NA>
#>
#>
#> [[5]]
#> [[5]][[1]]
#> id id_str name screen_name location
#> 1 1.517769e+18 1517768938821668866 Nico Karssemeijer NicoKarssemeij1
#> 2 4.109448e+08 410944776 Nico Karssemeijer NKarssemeijer Wijdemeren, the Netherlands
#> 3 2.173814e+09 2173813655 nico karssemeijer nicokarssemeije
#> description url urls
#> 1 NA NULL
#> 2 Software project manager / Internet Marketing / Technical specialist / Financial analist NA NULL
#> 3 NA NULL
#> protected followers_count friends_count listed_count created_at
#> 1 FALSE 0 0 0 Sat Apr 23 07:35:21 +0000 2022
#> 2 TRUE 45 1718 0 Sat Nov 12 19:51:17 +0000 2011
#> 3 FALSE 9 0 0 Fri Nov 08 22:09:42 +0000 2013
#> favourites_count utc_offset time_zone geo_enabled verified statuses_count lang
#> 1 0 NA NA FALSE FALSE 0 NA
#> 2 131 NA NA FALSE FALSE 316 NA
#> 3 0 NA NA FALSE FALSE 0 NA
#> contributors_enabled is_translator is_translation_enabled profile_background_color
#> 1 FALSE FALSE FALSE F5F8FA
#> 2 FALSE FALSE FALSE C0DEED
#> 3 FALSE FALSE FALSE C0DEED
#> profile_background_image_url
#> 1 <NA>
#> 2 http://abs.twimg.com/images/themes/theme1/bg.png
#> 3 http://abs.twimg.com/images/themes/theme1/bg.png
#> profile_background_image_url_https profile_background_tile
#> 1 <NA> FALSE
#> 2 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 3 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> profile_image_url
#> 1 http://pbs.twimg.com/profile_images/1517769076826902528/H09ie8W0_normal.jpg
#> 2 http://pbs.twimg.com/profile_images/908307887683981312/g96CThPV_normal.jpg
#> 3 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> profile_image_url_https profile_link_color
#> 1 https://pbs.twimg.com/profile_images/1517769076826902528/H09ie8W0_normal.jpg 1DA1F2
#> 2 https://pbs.twimg.com/profile_images/908307887683981312/g96CThPV_normal.jpg 1DA1F2
#> 3 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png 1DA1F2
#> profile_sidebar_border_color profile_sidebar_fill_color profile_text_color
#> 1 C0DEED DDEEF6 333333
#> 2 C0DEED DDEEF6 333333
#> 3 C0DEED DDEEF6 333333
#> profile_use_background_image has_extended_profile default_profile default_profile_image following
#> 1 TRUE TRUE TRUE FALSE FALSE
#> 2 TRUE TRUE TRUE FALSE FALSE
#> 3 TRUE FALSE TRUE TRUE FALSE
#> follow_request_sent notifications translator_type withheld_in_countries
#> 1 FALSE FALSE none NULL
#> 2 FALSE FALSE none NULL
#> 3 FALSE FALSE none NULL
#> profile_banner_url
#> 1 <NA>
#> 2 https://pbs.twimg.com/profile_banners/410944776/1445263648
#> 3 <NA>
#>
#>
#> [[6]]
#> [[6]][[1]]
#> id id_str name screen_name location
#> 1 169415851 169415851 Johannes Textor JohannesTextor Nijmegen, The Netherlands
#> description
#> 1 associate prof/UHD @Radboud_Uni · computational immunology · modeling, simulation, ML, causal inference · 🇩🇪 in 🇳🇱 · dad · makes https://t.co/ojwYJOoZVz
#> url
#> 1 https://t.co/URuaXUr0ty
#> entities.urls
#> 1 https://t.co/URuaXUr0ty, https://computational-immunology.org, computational-immunology.org, 0, 23
#> entities.urls protected followers_count
#> 1 https://t.co/ojwYJOoZVz, http://dagitty.net, dagitty.net, 129, 152 FALSE 1487
#> friends_count listed_count created_at favourites_count utc_offset time_zone
#> 1 640 26 Thu Jul 22 08:22:59 +0000 2010 1421 NA NA
#> geo_enabled verified statuses_count lang status.created_at status.id
#> 1 FALSE FALSE 2388 NA Tue Sep 27 10:42:47 +0000 2022 1.574711e+18
#> status.id_str status.text
#> 1 1574711140059430912 @d_malinsky I'm even surprised that you yourself met Clippy 🙂
#> status.truncated status.entities.hashtags status.entities.symbols
#> 1 FALSE NULL NULL
#> status.entities.user_mentions status.entities.urls
#> 1 d_malinsky, Dan Malinsky, 1366612933795586048, 1366612933795586048, 0, 11 NULL
#> status.source
#> 1 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> status.in_reply_to_status_id status.in_reply_to_status_id_str status.in_reply_to_user_id
#> 1 1.574587e+18 1574586908369264640 1.366613e+18
#> status.in_reply_to_user_id_str status.in_reply_to_screen_name status.geo status.coordinates
#> 1 1366612933795586048 d_malinsky NA NA
#> status.place status.contributors status.is_quote_status status.retweet_count
#> 1 NA NA FALSE 0
#> status.favorite_count status.favorited status.retweeted status.lang contributors_enabled
#> 1 2 FALSE FALSE en FALSE
#> is_translator is_translation_enabled profile_background_color
#> 1 FALSE FALSE C0DEED
#> profile_background_image_url
#> 1 http://abs.twimg.com/images/themes/theme1/bg.png
#> profile_background_image_url_https profile_background_tile
#> 1 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> profile_image_url
#> 1 http://pbs.twimg.com/profile_images/894165962676719616/Mmr0d4y-_normal.jpg
#> profile_image_url_https
#> 1 https://pbs.twimg.com/profile_images/894165962676719616/Mmr0d4y-_normal.jpg
#> profile_banner_url profile_link_color
#> 1 https://pbs.twimg.com/profile_banners/169415851/1502020455 1DA1F2
#> profile_sidebar_border_color profile_sidebar_fill_color profile_text_color
#> 1 C0DEED DDEEF6 333333
#> profile_use_background_image has_extended_profile default_profile default_profile_image following
#> 1 TRUE FALSE TRUE FALSE FALSE
#> follow_request_sent notifications translator_type withheld_in_countries
#> 1 FALSE FALSE none NULL#Now I would like to do the same for the sociology department. Ronald Batenburg's result is not right (I don't think he has Twitter, the first results is a radical right person), but for the others I randomly checked they seemed ok.
soc_twitter <- list()
for (i in 1:nrow(soc_df)) {
time <- runif (1,0,3)
Sys.sleep(time)
print(i)
soc_twitter[[i]] <- search_users(soc_df[i, c("name")], n=1, parse=FALSE, token=NULL, verbose=TRUE)
}
save(soc_twitter, file="./data/soc_twitter.RData")
twids <- NA
twnames <-NA
twscreennames <- NA
twfollowercounts <- NA
for (i in 1:length(soc_twitter)) {
if (!length(soc_twitter[[i]][[1]])==0) {
twids[i] <- soc_twitter[[i]][[1]]$id[1]
twnames[i] <- soc_twitter[[i]][[1]]$name[1]
twscreennames[i] <-soc_twitter[[i]][[1]]$screen_name[1]
twfollowercounts[i] <- soc_twitter[[i]][[1]]$followers_count[1]
}
}
soc_twitterinfo <- as.data.frame(cbind(twids, twnames, twscreennames, twfollowercounts))
soc_df <- cbind(soc_df, soc_twitterinfo)
names(soc_twitterinfo)[names(soc_twitterinfo) == 'twnames'] <- 'name'
soc_df<- merge(soc_df, soc_twitterinfo, all = TRUE, by = "name")
head(cv_tot_panel)
soc_dfc <- soc_df
soc_df <- soc_df[-c (33:40), , drop=FALSE]
save(soc_df, file="./data/soc_df.RData")save(soc_twitterinfo, file="/Users/anuschka/Documents/labjournal/data/soc_twitterinfo.RData")Again this is where I did it with the definitive dataset. I calculated the index by hand because of adjustments I made (people who had the wrong number of followers e.g.). Now I would also know how to fix that in R.
# Now do the same for sociology (a bit faster I hope)
soc_twitter <- list()
for (i in 1:nrow(socdef_df)) {
time <- runif (1,0,3)
Sys.sleep(time)
print(i)
soc_twitter[[i]] <- search_users(socdef_df[i, c("name")], n=1, parse=FALSE, token=NULL, verbose=TRUE)
}
twids <- NA
twnames <-NA
twscreennames <- NA
twfollowercounts <- NA
for (i in 1:length(soc_twitter)) {
if (!length(soc_twitter[[i]][[1]])==0) {
twids[i] <- soc_twitter[[i]][[1]]$id[1]
twnames[i] <- soc_twitter[[i]][[1]]$name[1]
twscreennames[i] <-soc_twitter[[i]][[1]]$screen_name[1]
twfollowercounts[i] <- soc_twitter[[i]][[1]]$followers_count[1]
}
}
soc_twitterinfo <- as.data.frame(cbind(twids, twnames, twscreennames, twfollowercounts))
write.xlsx(socdef_df, '/Users/anuschka/Downloads/pubnets/socdef.xlsx')
soc_twitterinfo <- cbind(soc_twitterinfo, socdef_df$total_cites)
socdef_df$f <- c(616.515368,
412.848115,
298.720004,
157.894808,
298.491133,
693.693625,
545.087971,
157.003041,
228.530958,
289.746799,
366.653062,
359.39986,
163.033508,
788.726149,
259.114091,
347.733125,
955.178524,
515.586116,
540.459485,
488.265532,
317.552884,
619.200085,
170.150917,
430.014658,
798.900213,
76.8238904,
201.956359,
140.97662,
260.651329,
254.059869,
121.291034,
43.3,
121.291034,
61.54,
0,
0
)
socdef_df$ki <- c(0,
0,
0.07364756,
1.83666584,
0,
0,
0.05503699,
2.61778369,
0,
0.05176934,
2.41918067,
5.1112986,
0,
0.00126787,
0.8065945,
1.33148086,
0.01570387,
3.51832592,
0.2627394,
0,
0,
0,
0,
0,
0,
0.46860423,
0.43078614,
0,
0,
0,
6.86777886,
0,
11.1302538,
1.70617118,
0,
0
)
socdef_df$followers <- c(0,
0,
22,
290,
0,
0,
30,
411,
0,
15,
887,
1837,
0,
1,
209,
463,
15,
1814,
142,
0,
0,
0,
0,
36,
87,
0,
0,
833,
0,
1350,
105,
0,
0)
save(socdef_df, file="/Users/anuschka/Downloads/pubnets/socdef_df.RData")head(soc_twitter)#> [[1]]
#> [[1]][[1]]
#> id id_str name screen_name location
#> 1 3.479335e+08 347933486 Ronald Batenburg Dekeurder Swifterbant / Nederland
#> 2 9.240987e+17 924098693283885056 Ronald Batenburg RonaldBatenbur1
#> 3 1.878228e+08 187822777 Ronald J Batenburg tironije
#> 4 3.870658e+08 387065809 Ronald Batenburg BatenburgR
#> 5 9.696224e+07 96962237 Ronald Batenburg RonaldBatenburg
#> 6 7.020011e+17 702001083107958784 Ronald Batenburg Ronald_Batenbur
#> 7 9.724744e+17 972474360001855488 Ronald Batenburg RonaldBatenbur2
#> 8 5.490713e+08 549071282 Ronald Batenburg rs_batenburg
#> 9 2.420964e+09 2420963639 Mindgame BatenburgRonald
#> description url urls protected followers_count friends_count listed_count
#> 1 NA NULL FALSE 9 45 0
#> 2 NA NULL FALSE 0 3 0
#> 3 NA NULL FALSE 1 0 0
#> 4 NA NULL FALSE 0 0 0
#> 5 NA NULL FALSE 12 9 2
#> 6 NA NULL FALSE 1 10 0
#> 7 NA NULL FALSE 0 0 0
#> 8 NA NULL FALSE 0 2 0
#> 9 NA NULL FALSE 0 2 0
#> created_at favourites_count utc_offset time_zone geo_enabled verified
#> 1 Wed Aug 03 16:13:08 +0000 2011 479 NA NA FALSE FALSE
#> 2 Sat Oct 28 02:21:12 +0000 2017 0 NA NA FALSE FALSE
#> 3 Tue Sep 07 07:03:01 +0000 2010 0 NA NA FALSE FALSE
#> 4 Sat Oct 08 12:07:51 +0000 2011 0 NA NA FALSE FALSE
#> 5 Tue Dec 15 11:21:48 +0000 2009 1 NA NA FALSE FALSE
#> 6 Tue Feb 23 05:24:35 +0000 2016 0 NA NA FALSE FALSE
#> 7 Sat Mar 10 14:08:49 +0000 2018 0 NA NA FALSE FALSE
#> 8 Mon Apr 09 09:03:33 +0000 2012 0 NA NA FALSE FALSE
#> 9 Tue Mar 18 20:48:39 +0000 2014 0 NA NA FALSE FALSE
#> statuses_count lang status.created_at status.id status.id_str
#> 1 195 NA Wed Sep 14 04:48:25 +0000 2022 1.569911e+18 1569910919118848001
#> 2 0 NA <NA> NA <NA>
#> 3 0 NA <NA> NA <NA>
#> 4 0 NA <NA> NA <NA>
#> 5 1 NA Thu Jan 10 09:05:42 +0000 2013 2.892970e+17 289296950510096384
#> 6 1 NA Tue Sep 06 09:36:33 +0000 2016 7.730925e+17 773092515914326016
#> 7 2 NA Sat Mar 10 18:37:03 +0000 2018 9.725419e+17 972541861775708160
#> 8 0 NA <NA> NA <NA>
#> 9 0 NA <NA> NA <NA>
#> status.text
#> 1 RT @SimoneSays123: Ik LACH‼️\n\n😂😂😂😂 https://t.co/eVTFZKNIPc
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 RT @ricohhealthcare: UCS P3000, een draagbaar vergadersysteem met eenvoudige bediening, uitstekende beeld- en geluidskwaliteit. http://t ...
#> 6 https://t.co/A87gMlcTIm @jjpkoopman1971, @zuccini
#> 7 @PostNL mijn pakket met track en trace code LX304758647NL heeft de status succesvol afgeleverd. Ik heb echter niet… https://t.co/FYVMHhNGoM
#> 8 <NA>
#> 9 <NA>
#> status.truncated status.entities.hashtags status.entities.symbols
#> 1 FALSE NULL NULL
#> 2 NA NULL NULL
#> 3 NA NULL NULL
#> 4 NA NULL NULL
#> 5 FALSE NULL NULL
#> 6 FALSE NULL NULL
#> 7 TRUE NULL NULL
#> 8 NA NULL NULL
#> 9 NA NULL NULL
#> status.entities.user_mentions
#> 1 SimoneSays123, 🌸Simone Juffermans, 3370628362, 3370628362, 3, 17
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 ricohhealthcare, Ricoh Healthcare, 76955068, 76955068, 3, 19
#> 6 jjpkoopman1971, zuccini, Jan Koopman, zuccini, 3136666023, 16340796, 3136666023, 16340796, 24, 39, 41, 49
#> 7 PostNL, PostNL, 138062686, 138062686, 0, 7
#> 8 NULL
#> 9 NULL
#> status.entities.urls
#> 1 NULL
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 https://t.co/A87gMlcTIm, http://www.baidu.com/link?url=k-mjb-g1woY1PNwPn1jIVA3bDOhedN4NXk7GFvs6Pvu, baidu.com/link?url=k-mjb…, 0, 23
#> 7 https://t.co/FYVMHhNGoM, https://twitter.com/i/web/status/972541861775708160, twitter.com/i/web/status/9…, 117, 140
#> 8 NULL
#> 9 NULL
#> status.entities.media
#> 1 1.569593857549e+18, 1569593857548996608, 35, 58, http://pbs.twimg.com/media/FchRTCDX0AAMQKb.jpg, https://pbs.twimg.com/media/FchRTCDX0AAMQKb.jpg, https://t.co/eVTFZKNIPc, pic.twitter.com/eVTFZKNIPc, https://twitter.com/SimoneSays123/status/1569593860807950336/photo/1, photo, 525, 617, fit, 150, 150, crop, 525, 617, fit, 525, 617, fit, 1569593860807950336, 1569593860807950336, 3370628362, 3370628362
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> status.media
#> 1 1.569593857549e+18, 1569593857548996608, 35, 58, http://pbs.twimg.com/media/FchRTCDX0AAMQKb.jpg, https://pbs.twimg.com/media/FchRTCDX0AAMQKb.jpg, https://t.co/eVTFZKNIPc, pic.twitter.com/eVTFZKNIPc, https://twitter.com/SimoneSays123/status/1569593860807950336/photo/1, photo, 525, 617, fit, 150, 150, crop, 525, 617, fit, 525, 617, fit, 1569593860807950336, 1569593860807950336, 3370628362, 3370628362
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> status.source
#> 1 <a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <a href="http://twitter.com/#!/download/ipad" rel="nofollow">Twitter for iPad</a>
#> 6 <a href="http://twitter.com" rel="nofollow">Twitter Web Client</a>
#> 7 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 8 <NA>
#> 9 <NA>
#> status.in_reply_to_status_id status.in_reply_to_status_id_str status.in_reply_to_user_id
#> 1 NA NA NA
#> 2 NA NA NA
#> 3 NA NA NA
#> 4 NA NA NA
#> 5 NA NA NA
#> 6 NA NA NA
#> 7 NA NA 138062686
#> 8 NA NA NA
#> 9 NA NA NA
#> status.in_reply_to_user_id_str status.in_reply_to_screen_name status.geo status.coordinates
#> 1 <NA> <NA> NA NA
#> 2 <NA> <NA> NA NA
#> 3 <NA> <NA> NA NA
#> 4 <NA> <NA> NA NA
#> 5 <NA> <NA> NA NA
#> 6 <NA> <NA> NA NA
#> 7 138062686 PostNL NA NA
#> 8 <NA> <NA> NA NA
#> 9 <NA> <NA> NA NA
#> status.place status.contributors status.retweeted_status.created_at status.retweeted_status.id
#> 1 NA NA Tue Sep 13 07:48:32 +0000 2022 1.569594e+18
#> 2 NA NA <NA> NA
#> 3 NA NA <NA> NA
#> 4 NA NA <NA> NA
#> 5 NA NA Mon Jan 07 07:55:38 +0000 2013 2.881922e+17
#> 6 NA NA <NA> NA
#> 7 NA NA <NA> NA
#> 8 NA NA <NA> NA
#> 9 NA NA <NA> NA
#> status.retweeted_status.id_str
#> 1 1569593860807950336
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 288192155149807616
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> status.retweeted_status.text
#> 1 Ik LACH‼️\n\n😂😂😂😂 https://t.co/eVTFZKNIPc
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 UCS P3000, een draagbaar vergadersysteem met eenvoudige bediening, uitstekende beeld- en geluidskwaliteit. http://t.co/vRdRneku #RicohNL
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> status.retweeted_status.truncated status.retweeted_status.entities.hashtags
#> 1 FALSE NULL
#> 2 NA NULL
#> 3 NA NULL
#> 4 NA NULL
#> 5 FALSE RicohNL, 128, 136
#> 6 NA NULL
#> 7 NA NULL
#> 8 NA NULL
#> 9 NA NULL
#> status.retweeted_status.entities.symbols status.retweeted_status.entities.user_mentions
#> 1 NULL NULL
#> 2 NULL NULL
#> 3 NULL NULL
#> 4 NULL NULL
#> 5 NULL NULL
#> 6 NULL NULL
#> 7 NULL NULL
#> 8 NULL NULL
#> 9 NULL NULL
#> status.retweeted_status.entities.urls
#> 1 NULL
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 http://t.co/vRdRneku, http://bit.ly/YILfnk, bit.ly/YILfnk, 107, 127
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> status.retweeted_status.entities.media
#> 1 1.569593857549e+18, 1569593857548996608, 16, 39, http://pbs.twimg.com/media/FchRTCDX0AAMQKb.jpg, https://pbs.twimg.com/media/FchRTCDX0AAMQKb.jpg, https://t.co/eVTFZKNIPc, pic.twitter.com/eVTFZKNIPc, https://twitter.com/SimoneSays123/status/1569593860807950336/photo/1, photo, 525, 617, fit, 150, 150, crop, 525, 617, fit, 525, 617, fit
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> status.retweeted_status.media
#> 1 1.569593857549e+18, 1569593857548996608, 16, 39, http://pbs.twimg.com/media/FchRTCDX0AAMQKb.jpg, https://pbs.twimg.com/media/FchRTCDX0AAMQKb.jpg, https://t.co/eVTFZKNIPc, pic.twitter.com/eVTFZKNIPc, https://twitter.com/SimoneSays123/status/1569593860807950336/photo/1, photo, 525, 617, fit, 150, 150, crop, 525, 617, fit, 525, 617, fit
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> 7 NULL
#> 8 NULL
#> 9 NULL
#> status.retweeted_status.source
#> 1 <a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <a href="https://about.twitter.com/products/tweetdeck" rel="nofollow">TweetDeck</a>
#> 6 <NA>
#> 7 <NA>
#> 8 <NA>
#> 9 <NA>
#> status.retweeted_status.in_reply_to_status_id status.retweeted_status.in_reply_to_status_id_str
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> status.retweeted_status.in_reply_to_user_id status.retweeted_status.in_reply_to_user_id_str
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> status.retweeted_status.in_reply_to_screen_name status.retweeted_status.geo
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> status.retweeted_status.coordinates status.retweeted_status.place
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> status.retweeted_status.contributors status.retweeted_status.is_quote_status
#> 1 NA FALSE
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA FALSE
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> status.retweeted_status.retweet_count status.retweeted_status.favorite_count
#> 1 982 5447
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 3 1
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> status.retweeted_status.favorited status.retweeted_status.retweeted
#> 1 FALSE FALSE
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 FALSE FALSE
#> 6 NA NA
#> 7 NA NA
#> 8 NA NA
#> 9 NA NA
#> status.retweeted_status.possibly_sensitive status.retweeted_status.lang status.is_quote_status
#> 1 FALSE nl FALSE
#> 2 NA <NA> NA
#> 3 NA <NA> NA
#> 4 NA <NA> NA
#> 5 FALSE nl FALSE
#> 6 NA <NA> FALSE
#> 7 NA <NA> FALSE
#> 8 NA <NA> NA
#> 9 NA <NA> NA
#> status.retweet_count status.favorite_count status.favorited status.retweeted
#> 1 982 0 FALSE FALSE
#> 2 NA NA NA NA
#> 3 NA NA NA NA
#> 4 NA NA NA NA
#> 5 3 0 FALSE FALSE
#> 6 0 0 FALSE FALSE
#> 7 0 0 FALSE FALSE
#> 8 NA NA NA NA
#> 9 NA NA NA NA
#> status.possibly_sensitive status.lang contributors_enabled is_translator is_translation_enabled
#> 1 FALSE nl FALSE FALSE FALSE
#> 2 NA <NA> FALSE FALSE FALSE
#> 3 NA <NA> FALSE FALSE FALSE
#> 4 NA <NA> FALSE FALSE FALSE
#> 5 NA nl FALSE FALSE FALSE
#> 6 FALSE und FALSE FALSE FALSE
#> 7 NA nl FALSE FALSE FALSE
#> 8 NA <NA> FALSE FALSE FALSE
#> 9 NA <NA> FALSE FALSE FALSE
#> profile_background_color profile_background_image_url
#> 1 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 2 F5F8FA <NA>
#> 3 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 4 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 5 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 6 F5F8FA <NA>
#> 7 F5F8FA <NA>
#> 8 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> 9 C0DEED http://abs.twimg.com/images/themes/theme1/bg.png
#> profile_background_image_url_https profile_background_tile
#> 1 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 2 <NA> FALSE
#> 3 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 4 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 5 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 6 <NA> FALSE
#> 7 <NA> FALSE
#> 8 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 9 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> profile_image_url
#> 1 http://pbs.twimg.com/profile_images/1431896266418630660/Igctrx8m_normal.jpg
#> 2 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 3 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 4 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 5 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 6 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 7 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 8 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 9 http://pbs.twimg.com/profile_images/446026062573891585/56v-o7EL_normal.jpeg
#> profile_image_url_https profile_link_color
#> 1 https://pbs.twimg.com/profile_images/1431896266418630660/Igctrx8m_normal.jpg 0084B4
#> 2 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png 1DA1F2
#> 3 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png 1DA1F2
#> 4 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png 1DA1F2
#> 5 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png 1DA1F2
#> 6 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png 1DA1F2
#> 7 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png 1DA1F2
#> 8 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png 1DA1F2
#> 9 https://pbs.twimg.com/profile_images/446026062573891585/56v-o7EL_normal.jpeg 1DA1F2
#> profile_sidebar_border_color profile_sidebar_fill_color profile_text_color
#> 1 C0DEED DDEEF6 333333
#> 2 C0DEED DDEEF6 333333
#> 3 C0DEED DDEEF6 333333
#> 4 C0DEED DDEEF6 333333
#> 5 C0DEED DDEEF6 333333
#> 6 C0DEED DDEEF6 333333
#> 7 C0DEED DDEEF6 333333
#> 8 C0DEED DDEEF6 333333
#> 9 C0DEED DDEEF6 333333
#> profile_use_background_image has_extended_profile default_profile default_profile_image following
#> 1 TRUE TRUE FALSE FALSE FALSE
#> 2 TRUE FALSE TRUE TRUE FALSE
#> 3 TRUE FALSE TRUE TRUE FALSE
#> 4 TRUE FALSE TRUE TRUE FALSE
#> 5 TRUE FALSE TRUE TRUE FALSE
#> 6 TRUE FALSE TRUE TRUE FALSE
#> 7 TRUE FALSE TRUE TRUE FALSE
#> 8 TRUE FALSE TRUE TRUE FALSE
#> 9 TRUE FALSE TRUE FALSE FALSE
#> follow_request_sent notifications translator_type withheld_in_countries
#> 1 FALSE FALSE none NULL
#> 2 FALSE FALSE none NULL
#> 3 FALSE FALSE none NULL
#> 4 FALSE FALSE none NULL
#> 5 FALSE FALSE none NULL
#> 6 FALSE FALSE none NULL
#> 7 FALSE FALSE none NULL
#> 8 FALSE FALSE none NULL
#> 9 FALSE FALSE none NULL
#>
#>
#> [[2]]
#> [[2]][[1]]
#> list()
#>
#>
#> [[3]]
#> [[3]][[1]]
#> id id_str name screen_name location
#> 1 612350824 612350824 Hidde Bekhuis hidde84 Nijmegen
#> description url
#> 1 wetenschapper - coach - triathlon - zwemmen - fietsen - hardlopen http://t.co/l1RgCkYX
#> entities.urls
#> 1 http://t.co/l1RgCkYX, http://www.linkedin.com/profile/view?id=58440632&trk=tab_pro, linkedin.com/profile/view?i…, 0, 20
#> entities.urls protected followers_count friends_count listed_count created_at
#> 1 NULL FALSE 22 5 0 Tue Jun 19 07:13:32 +0000 2012
#> favourites_count utc_offset time_zone geo_enabled verified statuses_count lang
#> 1 0 NA NA FALSE FALSE 0 NA
#> contributors_enabled is_translator is_translation_enabled profile_background_color
#> 1 FALSE FALSE FALSE C0DEED
#> profile_background_image_url
#> 1 http://abs.twimg.com/images/themes/theme1/bg.png
#> profile_background_image_url_https profile_background_tile
#> 1 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> profile_image_url
#> 1 http://pbs.twimg.com/profile_images/2895856146/3bd87b09b990fbff6a3e8c4147a661f9_normal.jpeg
#> profile_image_url_https
#> 1 https://pbs.twimg.com/profile_images/2895856146/3bd87b09b990fbff6a3e8c4147a661f9_normal.jpeg
#> profile_link_color profile_sidebar_border_color profile_sidebar_fill_color profile_text_color
#> 1 1DA1F2 C0DEED DDEEF6 333333
#> profile_use_background_image has_extended_profile default_profile default_profile_image following
#> 1 TRUE FALSE TRUE FALSE FALSE
#> follow_request_sent notifications translator_type withheld_in_countries
#> 1 FALSE FALSE none NULL
#>
#>
#> [[4]]
#> [[4]][[1]]
#> id id_str name screen_name location
#> 1 1.651434e+09 1651433869 Lonneke van den Berg lonnekevdberg
#> 2 1.564917e+18 1564917448964456449 Lonneke Van Den Berg BergLonneke
#> 3 3.256982e+08 325698189 Lonneke van den Berg lonnekevdb
#> 4 2.459469e+08 245946853 Lonneke Van Den Berg LVDB93
#> 5 1.378992e+09 1378991822 Lonneke van den Berg Interzorg
#> 6 2.280167e+08 228016693 Lonneke van den Berg mamavanSCHATJES Naaldwijk
#> description
#> 1 Postdoctoral researcher @Radboud_Uni. Interested in family sociology, young adulthood, leaving home. she/her
#> 2
#> 3 ❤️Robbert, Julius & Rosalien 💙 Change & Innovation 💚Food & Friends
#> 4
#> 5
#> 6 35jaar. Mama van de drie schatjes Sam, Matthijs en Noah, getrouwd met Rob van den Berg. Maker van taarten en cupcakes
#> url
#> 1 https://t.co/UBzVSD7g3z
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> entities.urls
#> 1 https://t.co/UBzVSD7g3z, https://lonnekevandenberg.com, lonnekevandenberg.com, 0, 23
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> entities.urls protected followers_count friends_count listed_count created_at
#> 1 NULL FALSE 291 509 5 Tue Aug 06 22:35:06 +0000 2013
#> 2 NULL FALSE 0 1 0 Wed Aug 31 10:06:38 +0000 2022
#> 3 NULL FALSE 34 95 0 Tue Jun 28 18:34:28 +0000 2011
#> 4 NULL FALSE 8 15 0 Tue Feb 01 20:14:33 +0000 2011
#> 5 NULL FALSE 5 1 0 Thu Apr 25 08:39:10 +0000 2013
#> 6 NULL FALSE 58 154 1 Sat Dec 18 13:38:50 +0000 2010
#> favourites_count utc_offset time_zone geo_enabled verified statuses_count lang
#> 1 919 NA NA TRUE FALSE 310 NA
#> 2 0 NA NA FALSE FALSE 0 NA
#> 3 7 NA NA FALSE FALSE 14 NA
#> 4 0 NA NA TRUE FALSE 7 NA
#> 5 0 NA NA FALSE FALSE 0 NA
#> 6 58 NA NA FALSE FALSE 6582 NA
#> status.created_at status.id status.id_str
#> 1 Tue Sep 20 08:33:49 +0000 2022 1.572142e+18 1572141969576435717
#> 2 <NA> NA <NA>
#> 3 Tue Apr 16 21:24:11 +0000 2019 1.118264e+18 1118263845636726785
#> 4 Mon May 16 16:12:35 +0000 2011 7.015972e+16 70159720165548032
#> 5 <NA> NA <NA>
#> 6 Sat Jul 21 05:52:45 +0000 2018 1.020547e+18 1020547104241082368
#> status.text
#> 1 RT @MenMaatschappij: Ons speciale themanummer rondom 100 jaar Sociologie in Nederland is uit @AmsterdamUPress! Met beschouwingen van Wout U…
#> 2 <NA>
#> 3 @MarienWijk @Gemeente_LV Feit is ook dat er slechts twee partijen in de coalitie een EOV in hun programma hadden en… https://t.co/nAzVO5vooG
#> 4 @Myronus ik probeer kaarten te winnen voor guus meeuwis! terwijl ik natuurlijk hard aan het leren ben.
#> 5 <NA>
#> 6 @rghvdberg Doe haar de groetjes :)
#> status.truncated status.entities.hashtags status.entities.symbols
#> 1 FALSE NULL NULL
#> 2 NA NULL NULL
#> 3 TRUE NULL NULL
#> 4 FALSE NULL NULL
#> 5 NA NULL NULL
#> 6 FALSE NULL NULL
#> status.entities.user_mentions
#> 1 MenMaatschappij, AmsterdamUPress, Mens & Maatschappij, Amsterdam Univ Press, 1258395810695430144, 45841403, 1258395810695430145, 45841403, 3, 19, 93, 109
#> 2 NULL
#> 3 MarienWijk, Gemeente_LV, Marien van Wijk, Gemeente LV, 425401206, 124393184, 425401206, 124393184, 0, 11, 12, 24
#> 4 myronus, Myron, 45239642, 45239642, 0, 8
#> 5 NULL
#> 6 rghvdberg, Rob van den Berg, 109176892, 109176892, 0, 10
#> status.entities.urls
#> 1 NULL
#> 2 NULL
#> 3 https://t.co/nAzVO5vooG, https://twitter.com/i/web/status/1118263845636726785, twitter.com/i/web/status/1…, 117, 140
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> status.source
#> 1 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 2 <NA>
#> 3 <a href="http://twitter.com/download/iphone" rel="nofollow">Twitter for iPhone</a>
#> 4 <a href="http://twitter.com" rel="nofollow">Twitter Web Client</a>
#> 5 <NA>
#> 6 <a href="http://twitter.com/download/android" rel="nofollow">Twitter for Android</a>
#> status.in_reply_to_status_id status.in_reply_to_status_id_str status.in_reply_to_user_id
#> 1 NA <NA> NA
#> 2 NA <NA> NA
#> 3 1.118263e+18 1118263395814387715 325698189
#> 4 7.015684e+16 70156837709811712 45239642
#> 5 NA <NA> NA
#> 6 1.020546e+18 1020545635861368832 109176892
#> status.in_reply_to_user_id_str status.in_reply_to_screen_name status.geo status.coordinates
#> 1 <NA> <NA> NA NA
#> 2 <NA> <NA> NA NA
#> 3 325698189 lonnekevdb NA NA
#> 4 45239642 myronus NA NA
#> 5 <NA> <NA> NA NA
#> 6 109176892 rghvdberg NA NA
#> status.place status.contributors status.retweeted_status.created_at status.retweeted_status.id
#> 1 NA NA Mon Sep 19 16:41:27 +0000 2022 1.571902e+18
#> 2 NA NA <NA> NA
#> 3 NA NA <NA> NA
#> 4 NA NA <NA> NA
#> 5 NA NA <NA> NA
#> 6 NA NA <NA> NA
#> status.retweeted_status.id_str
#> 1 1571902301954277376
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> status.retweeted_status.text
#> 1 Ons speciale themanummer rondom 100 jaar Sociologie in Nederland is uit @AmsterdamUPress! Met beschouwingen van Wou… https://t.co/Co99qzseix
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> status.retweeted_status.truncated status.retweeted_status.entities.hashtags
#> 1 TRUE NULL
#> 2 NA NULL
#> 3 NA NULL
#> 4 NA NULL
#> 5 NA NULL
#> 6 NA NULL
#> status.retweeted_status.entities.symbols
#> 1 NULL
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> status.retweeted_status.entities.user_mentions
#> 1 AmsterdamUPress, Amsterdam Univ Press, 45841403, 45841403, 72, 88
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> status.retweeted_status.entities.urls
#> 1 https://t.co/Co99qzseix, https://twitter.com/i/web/status/1571902301954277376, twitter.com/i/web/status/1…, 117, 140
#> 2 NULL
#> 3 NULL
#> 4 NULL
#> 5 NULL
#> 6 NULL
#> status.retweeted_status.source
#> 1 <a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>
#> 2 <NA>
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#> status.retweeted_status.in_reply_to_status_id status.retweeted_status.in_reply_to_status_id_str
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> status.retweeted_status.in_reply_to_user_id status.retweeted_status.in_reply_to_user_id_str
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> status.retweeted_status.in_reply_to_screen_name status.retweeted_status.geo
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> status.retweeted_status.coordinates status.retweeted_status.place
#> 1 NA NA
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> status.retweeted_status.contributors status.retweeted_status.is_quote_status
#> 1 NA FALSE
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> status.retweeted_status.retweet_count status.retweeted_status.favorite_count
#> 1 7 11
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> status.retweeted_status.favorited status.retweeted_status.retweeted
#> 1 FALSE FALSE
#> 2 NA NA
#> 3 NA NA
#> 4 NA NA
#> 5 NA NA
#> 6 NA NA
#> status.retweeted_status.possibly_sensitive status.retweeted_status.lang status.is_quote_status
#> 1 FALSE nl FALSE
#> 2 NA <NA> NA
#> 3 NA <NA> FALSE
#> 4 NA <NA> FALSE
#> 5 NA <NA> NA
#> 6 NA <NA> FALSE
#> status.retweet_count status.favorite_count status.favorited status.retweeted status.lang
#> 1 7 0 FALSE FALSE nl
#> 2 NA NA NA NA <NA>
#> 3 0 0 FALSE FALSE nl
#> 4 0 0 FALSE FALSE nl
#> 5 NA NA NA NA <NA>
#> 6 0 0 FALSE FALSE nl
#> contributors_enabled is_translator is_translation_enabled profile_background_color
#> 1 FALSE FALSE FALSE C0DEED
#> 2 FALSE FALSE FALSE F5F8FA
#> 3 FALSE FALSE FALSE C0DEED
#> 4 FALSE FALSE FALSE C0DEED
#> 5 FALSE FALSE FALSE C0DEED
#> 6 FALSE FALSE FALSE B2DFDA
#> profile_background_image_url
#> 1 http://abs.twimg.com/images/themes/theme1/bg.png
#> 2 <NA>
#> 3 http://abs.twimg.com/images/themes/theme1/bg.png
#> 4 http://abs.twimg.com/images/themes/theme1/bg.png
#> 5 http://abs.twimg.com/images/themes/theme1/bg.png
#> 6 http://abs.twimg.com/images/themes/theme13/bg.gif
#> profile_background_image_url_https profile_background_tile
#> 1 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 2 <NA> FALSE
#> 3 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 4 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 5 https://abs.twimg.com/images/themes/theme1/bg.png FALSE
#> 6 https://abs.twimg.com/images/themes/theme13/bg.gif FALSE
#> profile_image_url
#> 1 http://pbs.twimg.com/profile_images/1493884058711044099/NzZWgrQM_normal.jpg
#> 2 http://pbs.twimg.com/profile_images/1564917573254369280/fwITegS6_normal.jpg
#> 3 http://pbs.twimg.com/profile_images/378800000736071589/0460283c2bb9b82f8eec6b10d95e4f88_normal.jpeg
#> 4 http://pbs.twimg.com/profile_images/1335964401/brotherss_normal.jpg
#> 5 http://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 6 http://pbs.twimg.com/profile_images/378800000846711727/2bdfffdc73e56756dd4f00d5b929ed94_normal.jpeg
#> profile_image_url_https
#> 1 https://pbs.twimg.com/profile_images/1493884058711044099/NzZWgrQM_normal.jpg
#> 2 https://pbs.twimg.com/profile_images/1564917573254369280/fwITegS6_normal.jpg
#> 3 https://pbs.twimg.com/profile_images/378800000736071589/0460283c2bb9b82f8eec6b10d95e4f88_normal.jpeg
#> 4 https://pbs.twimg.com/profile_images/1335964401/brotherss_normal.jpg
#> 5 https://abs.twimg.com/sticky/default_profile_images/default_profile_normal.png
#> 6 https://pbs.twimg.com/profile_images/378800000846711727/2bdfffdc73e56756dd4f00d5b929ed94_normal.jpeg
#> profile_link_color profile_sidebar_border_color profile_sidebar_fill_color profile_text_color
#> 1 1DA1F2 C0DEED DDEEF6 333333
#> 2 1DA1F2 C0DEED DDEEF6 333333
#> 3 1DA1F2 C0DEED DDEEF6 333333
#> 4 1DA1F2 C0DEED DDEEF6 333333
#> 5 1DA1F2 C0DEED DDEEF6 333333
#> 6 93A644 EEEEEE FFFFFF 333333
#> profile_use_background_image has_extended_profile default_profile default_profile_image following
#> 1 TRUE FALSE TRUE FALSE FALSE
#> 2 TRUE TRUE TRUE FALSE FALSE
#> 3 TRUE TRUE TRUE FALSE FALSE
#> 4 TRUE FALSE TRUE FALSE FALSE
#> 5 TRUE FALSE TRUE TRUE FALSE
#> 6 TRUE FALSE FALSE FALSE FALSE
#> follow_request_sent notifications translator_type withheld_in_countries
#> 1 FALSE FALSE none NULL
#> 2 FALSE FALSE none NULL
#> 3 FALSE FALSE none NULL
#> 4 FALSE FALSE none NULL
#> 5 FALSE FALSE none NULL
#> 6 FALSE FALSE none NULL
#> profile_banner_url
#> 1 <NA>
#> 2 <NA>
#> 3 https://pbs.twimg.com/profile_banners/325698189/1394450438
#> 4 <NA>
#> 5 <NA>
#> 6 <NA>
#>
#>
#> [[5]]
#> [[5]][[1]]
#> list()
#>
#>
#> [[6]]
#> [[6]][[1]]
#> list()#Kardashian index berekenen
datadef_df$total_cites <- as.integer(datadef_df$total_cites)
dplyr::rename(data_twitterinfo, total_cites = datadef_df$total_cites)
#If I ever get the loop fixed, the Kardashian Index can be calculated using the following code. Of course I have to adapt this to the names of my own variables.
calculate_kardashian_index <- function(twfollowercount, total_cites) {
# Set F_a as number of twitter followers:
F_a <- twfollowercount
# Calculate F_c using equation 1 of Hall (2014):
F_c <- 43 * (total_cites ^ 0.32)
# Retrurn Kardashian Index (equation 2 of Hall 2014):
F_a / F_c
}
calculate_kardashian_index(data_twitterinfo)
summary(data_twitterinfo$`datadef_df$total_cites`)
install.packages("openxlsx")
library(openxlsx)
write.xlsx(data_twitterinfo, '/Users/anuschka/Downloads/pubnets')
data_twitterinfo$f <- c(850.1455808,
737.6146619,
740.6498161,
652.7478124,
703.5440897,
827.9055062,
999.9312023,
635.2725999,
595.7753807,
397.7847223,
419.071737,
334.9903335,
479.6529866,
336.9499762,
519.2863574,
185.934273,
244.6624172,
87.46725544,
456.7787425,
330.8122679,
508.5288602,
451.5208862,
529.7255008,
151.4113033,
365.9116913,
305.201247,
376.8532751,
796.7452654,
261.2608638,
202.480328,
663.4200516,
252.4357858,
1601.95043,
176.686392,
84.23191845,
340.7981992,
156.1003788,
178.0708722,
147.4247509,
498.4233811,
246.7407065,
157.8948082,
76.82389044,
164.6721556,
1477.952295,
80.70849876,
151.4113033,
737.982
)
data_twitterinfo$ki <- c(0.00823388,
0.17101902,
0.02297884,
0.13038054,
0.15251728,
0.00603482,
0,
0,
0.42047026,
0,
0.00664452,
1.50501672,
0,
1.96551724,
0.039949,
0,
0.00446429,
6.11111111,
0.01522843,
0.57391304,
0.04219601,
0,
0.04233227,
0,
0.0748731,
0.52796421,
0,
0.28306937,
0.14909091,
1.70967742,
0.49772682,
0.03643725,
0.00881484,
1.08641975,
0,
0,
3,
1.36144578,
0.76086957,
0,
0.08695652,
0,
13.1666667,
0,
0.01064294,
0,
0,
0.01983846
)
datadef_df$followers <- c(7,
1205,
164,
627,
927,
61,
0,
0,
1520,
0,
8,
900,
0,
1197,
94,
0,
1,
55,
24,
330,
93,
0,
106,
0,
59,
236,
0,
2538,
41,
212,
2518,
9,
88,
0,
0,
165,
113,
35,
0,
20,
0,
79,
0,
0,
0,
140
)
save(data_twitterinfo, file="/Users/anuschka/Downloads/pubnets/datatwitterinfo_df.RData")
datadef_df <- cbind(datadef_df, data_twitterinfo)
datadef_df["datadef_df$gsid"]
save(datadef_df, file="/Users/anuschka/Downloads/pubnets/datadef_df.RData")