lovers Table

Overview

Each row in this table represents the event of a user clicking a heart-shaped "love-it" button that appears on every project's page. A counter for "love-it's" was publicly visible on every project page in the Scratch website at the time of composing this dataset.

This action was socially framed as an expression of appreciation for a project. The identity of the user "loving" a project was not publicly displayed, but the number of love-it's a project has received (the lovers_website field in the project table) was updated as people clicked the button. Clicking the love-it button once increases the love-it's counter, clicking it twice reverses the action.

The identity of the user loving a project is not publicly displayed, hence it is not included in this table. As a result, the rows in the table includes projects loved by deleted users.

Description of Fields

The final table includes 1,487,112 observations. Each row of this table corresponds to a single event (i.e., a single user "loving" a project).

Variable Type Description
project_id integer Unique identifier for the project that is being loved (see the projects table).
date_loved datetime The date and time that the user loved the project. One project can only be loved once by a given user.

Summary Statistics

plot of chunk unnamed-chunk-2

Omitted Observations

First, we remove 6 observations which are duplicated (i.e., other observation records the same user loving a project). We believe that these are due to errors in the Scratch website software. We retain the observation associated with the first recorded "love it" in each of these cases.

Finally, we remove the 229,420 loveits associated with deleted projects projects table.

Download Datasets

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