friends Table

Overview

Each row in this table represents the event of a user "friending" another user. The "friendships" reflected in this dataset included all friendships that were publicly visible on the Scratch website at that time that these data were collected. Friendships were unidirectional relationships between users displayed in the website as "friends."

A user can add someone else as a "friend" by visiting that user’s profile page and clicking on the "add to friends" button. The target account gets added immediately to a list of friends, listed in chronological order, in that users’ profile page. The account being added as a "friend" also gets a notification in the Scratch website. If the target account does not reciprocate the friendship, it is still listed in the person who added the account as a friend, essentially following a "follower" model.

Description of Fields

The table includes 1,313,200 observations. Each row of this table corresponds to a single "friend" relationship between two users.

Variable Type Description
follower_user_id integer Unique identifier of the user who is the source of the friendship or the person who is following the other use (see the users table).
followed_user_id integer Unique identifier of the user who is the target of the friendship, i.e., the person who is being followed by the user described in follower_user_id (see the users table).
date_followed datetime The date and time the relationship was established.

Summary Statistics

plot of chunk unnamed-chunk-2

Data on when a relationship was created is missing in the database for 4,886 observations. Because these relationships were still public, we have included them and left this value missing.

Omitted Observations

Due to database errors, the database contained duplicate records for 3,341 friend relationships (i.e., the database contains entries with the same follower/followed relationship). In each of these cases, we retained only the first recorded relationship.

Because relationships are only visible when both participants have public profile pages, we omitted 16,029 observations for which the follower is not included in our published users table, and an additional 2,061 observations where the followed user is not included.

Download Datasets

These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.