Table 3 Overview of Weekly Aggregated Data on Facebook by Public Officials.
From: The digitally accountable public representation database: online communication by U.S. officials
Type | Column Header | Description | Source |
|---|---|---|---|
Unique ID | official_id | Unique identifier for each official | Authors’ coding |
Weekly Aggregated Data | calendar_week | ISO week and year (YYYY-WW) | Authors’ calculation |
Weekly Aggregated Data | total_posts | The total number of posts made by the official in week XX of a given year YYYY | Authors’ calculation |
Weekly Aggregated Data | urls | List of URLs to each post | Authors’ calculation |
Weekly Aggregated Data | avg_total_interactions | Average number of total interactions (likes, comments, shares, etc.) on the post | Authors’ calculation |
Weekly Aggregated Data | avg_likes | Average number of “Likes” on the post | Authors’ calculation |
Weekly Aggregated Data | avg_comments | Average number of “Comments” reaction on the posts | Authors’ calculation |
Weekly Aggregated Data | avg_shares | Average number of “Shares” reaction on the posts | Authors’ calculation |
Weekly Aggregated Data | avg_love | Average number of “Loves” reaction on the posts | Authors’ calculation |
Weekly Aggregated Data | avg_wow | Average number of “Wows” reaction on the posts | Authors’ calculation |
Weekly Aggregated Data | avg_haha | Average number of “Haha” reaction on the posts | Authors’ calculation |
Weekly Aggregated Data | avg_sad | Average number of “Sad” reaction on the posts | Authors’ calculation |
Weekly Aggregated Data | avg_angry | Average number of “Angry” reaction on the posts | Authors’ calculation |
Weekly Aggregated Data | avg_care | Average number of “Care” reaction on the posts | Authors’ calculation |
Term Matrices | #hashtag1 | TF-IDF representation of each word, #hashtag, and account mention based on content data by week | Authors’ calculation |
Term Matrices | #hashtag2 | TF-IDF representation of each word, #hashtag, and account mention based on content data by week | Authors’ calculation |
Term Matrices | … | TF-IDF representation of each word, #hashtag, and account mention based on content data by week | Authors’ calculation |
Term Matrices | term1 | TF-IDF representation of each word, #hashtag, and account mention based on content data by week | Authors’ calculation |
Term Matrices | term2 | TF-IDF representation of each word, #hashtag, and account mention based on content data by week | Authors’ calculation |
Term Matrices | … | TF-IDF representation of each word, #hashtag, and account mention based on content data by week | Authors’ calculation |
