favoriters Table

Overview

Each row in this table represents the event of a user adding a project to their favorites, i.e., bookmarking it. The list of favorites appeared in the user's profile page, which was publicly visible on the Scratch website.

"Favoriting" was designed as a way for projects to be bookmarked by users. Compared to "loving", "favoriting" was not intended for showing appreciation for a project, and a favorite count was never visible on project pages. A user could add a project to their favorites by clicking on an "Add to favorites?" link on any project’s page. This link was enabled only for users were logged in. A user could add or remove projects from their favorites list. Projects could only be added once.

Description of Fields

This table includes 1,041,387 observations. Each row of this table corresponds to a single relationship (i.e., a user favoriting a project).

Variable Type Description
project_id integer Unique identifier for the project that is being "favorited" (see the projects table).
user_id integer Unique identifier of the user who has added the project to their favorites and on whose profile page the favorite project is listed (see the users table).
date_favorited datetime The date and time that the user favorited the project. A project can only be favorited once by a given user.

Summary Statistics

plot of chunk unnamed-chunk-2

Omitted Observations

First, we remove 485 observations which are duplicated (i.e., other observation record the same person favoriting a project). We believe that these were due to errors in the website software. We retain the observation associated with the first recorded favorite in these cases.

Second, we remove entries by users who have been deleted, or to projects that have been deleted. These two are not mutually exclusive. The cross tabulation below shows the distribution:

Users Exists Project Exists Count
FALSE FALSE 1106
TRUE FALSE 119095
FALSE TRUE 7175
TRUE TRUE 1041387

We retain only the 1,041,387 observations that represent instances where both the user and project exists in our database.

Download Datasets

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