viewers Table

Overview

Each row in this table represents the event of a user viewing or loading the webpage of a project for the first time. A counter for views was publicly visible on every project page in the Scratch website.

The view counter for a project was updated whenever a logged-in user visited a project for the first time. This is reported in viewers_website field in the project table. That field might have discrepancies with the number of views in this table associated with a given project — particularly for older projects. The way views were recorded changed several times over the period of data collection and, at earlier points in time, included views by users who were not logged in and repeated views by individual users. This table seeks to provide a consistent measure of exposure over the entire period of the dataset.

The identity of the user viewing a project was not publicly displayed and is not included in this table. Because this table does not include information on the individual user who has loaded the project webpage, the rows in the table includes views by deleted users.

Description of Fields

The final table includes 30,154,002 observations. Each row of this table corresponds to a single user who loaded the project webpage.

Variable Type Description
project_id integer Unique identifier for the project that is being viewed (see the projects table).
date_viewed datetime The date and time that the user viewed the project for the first time. Because a view is only reported publicly when a user views a project for the first time, this will reflect only the first view.

Summary Statistics

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

plot of chunk unnamed-chunk-2

Omitted Observations

First, we remove 39,678,846 rows which are duplicated (i.e., an earlier observation records the same person and project pair). 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 30,154,002 observations which reflect views 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.