downloaders Table

Overview

Each row in this table a represents the event of a user downloading a project. A download counter was publicly visible on the Scratch website. A prominent download link was visible but enabled only for users who were logged in. Users could then open the projects using the Scratch desktop authoring environment to study, modify, and remix the projects they downloaded.

In order to offer the most consistent measure, this dataset counts only the first download per user. Early versions of the Scratch website displayed a counter that included multiple downloads by the same user. This was eventually changed to only showing the first download per user, but the counter was not adjusted for older projects. This will lead to discrepancies between downloaders_website field in the projects table, and the number of observations in this table.

The identity of the user downloading a project was not publicly displayed, hence it is not included in this table. Because this table does not include this information, the table includes downloads by deleted users.

Description of Fields

The final table includes 4,236,575 observations. Each row of this table corresponds to a single user who downloaded the project.

Variable Type Description
project_id integer Unique identifier for the project that was downloaded (see the projects table).
date_downloaded datetime The date and time when the user downloaded the project for the first time. A given user may download projects additional times. Although this data on repeat downloads was recorded, it was never made public so only the first download by a given user is included in the dataset.

Summary Statistics

Number of downloaders (i.e., the number of times a logged in user downloads a project for the first time), each month, over time:

plot of chunk unnamed-chunk-2

Omitted Observations

First, we removed 62,860 projects which were duplicated (i.e., another observation records the same person downloading a file repeatedly). Almost all of these are from the early period of the site when these were recorded as a matter of course. In each case, we retain the earliest observation.

Additionally, we omit 586,405 observations which reflect downloads of projects which are no longer visible on the website.

Download Datasets

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