\n", " | rowid | \n", "query | \n", "tweet_id_str | \n", "inserted_date | \n", "language | \n", "coordinates | \n", "retweeted_status | \n", "created_at | \n", "month | \n", "year | \n", "content | \n", "from_user_screen_name | \n", "from_user_id | \n", "from_user_followers_count | \n", "from_user_friends_count | \n", "from_user_listed_count | \n", "from_user_favourites_count | \n", "from_user_statuses_count | \n", "from_user_description | \n", "from_user_location | \n", "from_user_created_at | \n", "retweet_count | \n", "favorite_count | \n", "entities_urls | \n", "entities_urls_count | \n", "entities_hashtags | \n", "entities_hashtags_count | \n", "entities_mentions | \n", "entities_mentions_count | \n", "in_reply_to_screen_name | \n", "in_reply_to_status_id | \n", "source | \n", "entities_expanded_urls | \n", "entities_media_count | \n", "media_expanded_url | \n", "media_url | \n", "media_type | \n", "video_link | \n", "photo_link | \n", "twitpic | \n", "num_characters | \n", "num_words | \n", "retweeted_user | \n", "retweeted_user_description | \n", "retweeted_user_screen_name | \n", "retweeted_user_followers_count | \n", "retweeted_user_listed_count | \n", "retweeted_user_statuses_count | \n", "retweeted_user_location | \n", "retweeted_tweet_created_at | \n", "Fortune_2012_rank | \n", "Company | \n", "CSR_sustainability | \n", "specific_project_initiative_area | \n", "English | \n", "RTs_binary | \n", "favorites_binary | \n", "hashtags_binary | \n", "mentions_binary | \n", "URLs_binary | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "67340 | \n", "humanavitality | \n", "306897327585652736 | \n", "2014-03-09 13:46:50.222857 | \n", "en | \n", "NaN | \n", "NaN | \n", "2013-02-27 22:43:19.000000 | \n", "2 | \n", "2013 | \n", "@louloushive (Tweet 2) We encourage other empl... | \n", "humanavitality | \n", "274041023 | \n", "2859 | \n", "440 | \n", "38 | \n", "25 | \n", "1766 | \n", "This is the official Twitter account for Human... | \n", "NaN | \n", "Tue Mar 29 16:23:02 +0000 2011 | \n", "0 | \n", "0 | \n", "NaN | \n", "0 | \n", "NaN | \n", "0 | \n", "louloushive | \n", "1 | \n", "louloushive | \n", "306218267737989120.00 | \n", "web | \n", "NaN | \n", "nan | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "0 | \n", "0 | \n", "121 | \n", "19 | \n", "nan | \n", "NaN | \n", "NaN | \n", "nan | \n", "nan | \n", "nan | \n", "NaN | \n", "NaN | \n", "79 | \n", "Humana | \n", "0 | \n", "1 | \n", "1.00 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
1 | \n", "39454 | \n", "FundacionPfizer | \n", "308616393706844160 | \n", "2014-03-09 13:38:20.679967 | \n", "es | \n", "NaN | \n", "NaN | \n", "2013-03-04 16:34:17.000000 | \n", "3 | \n", "2013 | \n", "¿Sabes por qué la #vacuna contra la #neumonÃa ... | \n", "FundacionPfizer | \n", "188384056 | \n", "2464 | \n", "597 | \n", "50 | \n", "11 | \n", "2400 | \n", "Noticias sobre Responsabilidad Social y Fundac... | \n", "México | \n", "Wed Sep 08 16:14:11 +0000 2010 | \n", "1 | \n", "0 | \n", "NaN | \n", "0 | \n", "vacuna, neumonÃa | \n", "2 | \n", "NaN | \n", "0 | \n", "NaN | \n", "nan | \n", "web | \n", "NaN | \n", "nan | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0 | \n", "0 | \n", "0 | \n", "138 | \n", "20 | \n", "nan | \n", "NaN | \n", "NaN | \n", "nan | \n", "nan | \n", "nan | \n", "NaN | \n", "NaN | \n", "40 | \n", "Pfizer | \n", "0 | \n", "1 | \n", "0.00 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
\n", " | content | \n", "from_user_screen_name | \n", "from_user_followers_count | \n", "from_user_listed_count | \n", "from_user_statuses_count | \n", "retweet_count | \n", "favorite_count | \n", "entities_urls_count | \n", "entities_hashtags_count | \n", "entities_mentions_count | \n", "num_characters | \n", "Company | \n", "English | \n", "RTs_binary | \n", "favorites_binary | \n", "hashtags_binary | \n", "mentions_binary | \n", "URLs_binary | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "@louloushive (Tweet 2) We encourage other empl... | \n", "humanavitality | \n", "2859 | \n", "38 | \n", "1766 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "121 | \n", "Humana | \n", "1.00 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
1 | \n", "¿Sabes por qué la #vacuna contra la #neumonÃa ... | \n", "FundacionPfizer | \n", "2464 | \n", "50 | \n", "2400 | \n", "1 | \n", "0 | \n", "0 | \n", "2 | \n", "0 | \n", "138 | \n", "Pfizer | \n", "0.00 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
\n", " | from_user_followers_count | \n", "from_user_listed_count | \n", "from_user_statuses_count | \n", "retweet_count | \n", "favorite_count | \n", "entities_urls_count | \n", "entities_hashtags_count | \n", "entities_mentions_count | \n", "num_characters | \n", "English | \n", "RTs_binary | \n", "favorites_binary | \n", "hashtags_binary | \n", "mentions_binary | \n", "URLs_binary | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
count | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "
mean | \n", "48397.00 | \n", "533.32 | \n", "5190.04 | \n", "3.83 | \n", "1.52 | \n", "0.63 | \n", "1.01 | \n", "0.96 | \n", "111.11 | \n", "0.97 | \n", "0.55 | \n", "0.33 | \n", "0.63 | \n", "0.61 | \n", "0.62 | \n", "
std | \n", "103199.48 | \n", "684.03 | \n", "4004.43 | \n", "42.94 | \n", "15.28 | \n", "0.50 | \n", "1.01 | \n", "1.14 | \n", "29.89 | \n", "0.17 | \n", "0.50 | \n", "0.47 | \n", "0.48 | \n", "0.49 | \n", "0.49 | \n", "
min | \n", "58.00 | \n", "8.00 | \n", "9.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "9.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
25% | \n", "4426.00 | \n", "209.00 | \n", "2311.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "94.00 | \n", "1.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
50% | \n", "6401.00 | \n", "253.00 | \n", "4231.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "122.00 | \n", "1.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
75% | \n", "37586.00 | \n", "748.00 | \n", "6324.00 | \n", "2.00 | \n", "1.00 | \n", "1.00 | \n", "2.00 | \n", "1.00 | \n", "135.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
max | \n", "424892.00 | \n", "4605.00 | \n", "16594.00 | \n", "3719.00 | \n", "1150.00 | \n", "4.00 | \n", "9.00 | \n", "11.00 | \n", "159.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
\n", " | from_user_followers_count | \n", "from_user_listed_count | \n", "from_user_statuses_count | \n", "retweet_count | \n", "favorite_count | \n", "entities_urls_count | \n", "entities_hashtags_count | \n", "entities_mentions_count | \n", "num_characters | \n", "English | \n", "RTs_binary | \n", "favorites_binary | \n", "hashtags_binary | \n", "mentions_binary | \n", "URLs_binary | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
count | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "26257.00 | \n", "
mean | \n", "48397.00 | \n", "533.32 | \n", "5190.04 | \n", "3.83 | \n", "1.52 | \n", "0.63 | \n", "1.01 | \n", "0.96 | \n", "111.11 | \n", "0.97 | \n", "0.55 | \n", "0.33 | \n", "0.63 | \n", "0.61 | \n", "0.62 | \n", "
std | \n", "103199.48 | \n", "684.03 | \n", "4004.43 | \n", "42.94 | \n", "15.28 | \n", "0.50 | \n", "1.01 | \n", "1.14 | \n", "29.89 | \n", "0.17 | \n", "0.50 | \n", "0.47 | \n", "0.48 | \n", "0.49 | \n", "0.49 | \n", "
min | \n", "58.00 | \n", "8.00 | \n", "9.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "9.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
25% | \n", "4426.00 | \n", "209.00 | \n", "2311.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "94.00 | \n", "1.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "
50% | \n", "6401.00 | \n", "253.00 | \n", "4231.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "122.00 | \n", "1.00 | \n", "1.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
75% | \n", "37586.00 | \n", "748.00 | \n", "6324.00 | \n", "2.00 | \n", "1.00 | \n", "1.00 | \n", "2.00 | \n", "1.00 | \n", "135.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
max | \n", "424892.00 | \n", "4605.00 | \n", "16594.00 | \n", "3719.00 | \n", "1150.00 | \n", "4.00 | \n", "9.00 | \n", "11.00 | \n", "159.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
from_user_followers_count | \n", "26257.00 | \n", "48397.00 | \n", "103199.48 | \n", "58.00 | \n", "4426.00 | \n", "6401.00 | \n", "37586.00 | \n", "424892.00 | \n", "
from_user_listed_count | \n", "26257.00 | \n", "533.32 | \n", "684.03 | \n", "8.00 | \n", "209.00 | \n", "253.00 | \n", "748.00 | \n", "4605.00 | \n", "
from_user_statuses_count | \n", "26257.00 | \n", "5190.04 | \n", "4004.43 | \n", "9.00 | \n", "2311.00 | \n", "4231.00 | \n", "6324.00 | \n", "16594.00 | \n", "
retweet_count | \n", "26257.00 | \n", "3.83 | \n", "42.94 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "2.00 | \n", "3719.00 | \n", "
favorite_count | \n", "26257.00 | \n", "1.52 | \n", "15.28 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1150.00 | \n", "
entities_urls_count | \n", "26257.00 | \n", "0.63 | \n", "0.50 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "4.00 | \n", "
entities_hashtags_count | \n", "26257.00 | \n", "1.01 | \n", "1.01 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "2.00 | \n", "9.00 | \n", "
entities_mentions_count | \n", "26257.00 | \n", "0.96 | \n", "1.14 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "11.00 | \n", "
num_characters | \n", "26257.00 | \n", "111.11 | \n", "29.89 | \n", "9.00 | \n", "94.00 | \n", "122.00 | \n", "135.00 | \n", "159.00 | \n", "
English | \n", "26257.00 | \n", "0.97 | \n", "0.17 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
RTs_binary | \n", "26257.00 | \n", "0.55 | \n", "0.50 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
favorites_binary | \n", "26257.00 | \n", "0.33 | \n", "0.47 | \n", "0.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "
hashtags_binary | \n", "26257.00 | \n", "0.63 | \n", "0.48 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
mentions_binary | \n", "26257.00 | \n", "0.61 | \n", "0.49 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
URLs_binary | \n", "26257.00 | \n", "0.62 | \n", "0.49 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "1.00 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "max | \n", "
---|---|---|---|---|---|
from_user_followers_count | \n", "26257.00 | \n", "48397.00 | \n", "103199.48 | \n", "58.00 | \n", "424892.00 | \n", "
from_user_listed_count | \n", "26257.00 | \n", "533.32 | \n", "684.03 | \n", "8.00 | \n", "4605.00 | \n", "
from_user_statuses_count | \n", "26257.00 | \n", "5190.04 | \n", "4004.43 | \n", "9.00 | \n", "16594.00 | \n", "
retweet_count | \n", "26257.00 | \n", "3.83 | \n", "42.94 | \n", "0.00 | \n", "3719.00 | \n", "
favorite_count | \n", "26257.00 | \n", "1.52 | \n", "15.28 | \n", "0.00 | \n", "1150.00 | \n", "
entities_urls_count | \n", "26257.00 | \n", "0.63 | \n", "0.50 | \n", "0.00 | \n", "4.00 | \n", "
entities_hashtags_count | \n", "26257.00 | \n", "1.01 | \n", "1.01 | \n", "0.00 | \n", "9.00 | \n", "
entities_mentions_count | \n", "26257.00 | \n", "0.96 | \n", "1.14 | \n", "0.00 | \n", "11.00 | \n", "
num_characters | \n", "26257.00 | \n", "111.11 | \n", "29.89 | \n", "9.00 | \n", "159.00 | \n", "
English | \n", "26257.00 | \n", "0.97 | \n", "0.17 | \n", "0.00 | \n", "1.00 | \n", "
RTs_binary | \n", "26257.00 | \n", "0.55 | \n", "0.50 | \n", "0.00 | \n", "1.00 | \n", "
favorites_binary | \n", "26257.00 | \n", "0.33 | \n", "0.47 | \n", "0.00 | \n", "1.00 | \n", "
hashtags_binary | \n", "26257.00 | \n", "0.63 | \n", "0.48 | \n", "0.00 | \n", "1.00 | \n", "
mentions_binary | \n", "26257.00 | \n", "0.61 | \n", "0.49 | \n", "0.00 | \n", "1.00 | \n", "
URLs_binary | \n", "26257.00 | \n", "0.62 | \n", "0.49 | \n", "0.00 | \n", "1.00 | \n", "