frontpage_projects Table

Overview

Each row in this table represents a project that has been displayed on the front page for any of several reasons. For example, projects could be placed on the front page automatically for being among the most remixed or the most viewed projects in the website. They could also be added manually by an administrator or a curator who had the ability to "feature" a project on the front page (see the featured_projects table for more detail on this process).

Within each category, the three most recently added projects would be displayed at any given point. As a result, it is possible to compute the periods of time that individual projects were listed on the front page.

There is at least one important caveat with these data. The first few years of the website’s existence did not record these events at all. Due to errors in the Scratch website software, we also believe that the last several months (we are unsure about the exact period of time) may contain spurious data.

Description of Fields

This table includes 32,208 observations. Each row of this table corresponds to a single addition of a project to the front page of the site.

Variable Type Description
project_id integer Unique Identifier for the project that was displayed on the front page (see the projects table).
date_added datetime Date and time when the project was featured on the front page.
section factor Reason for why the project was featured on the front page. Options are: 'top_loved' for most loved projects; 'top_viewed' for most viewed projects; 'top_downloaded' for most downloaded projects; 'top_remixed' for most remixed projects; 'featured' for projects manually featured (this information is duplicated in the featured_projects table); 'surprise' for projects randomly selected to be in the front page; 'feature_gallery' for projects that show up in the front page as a result of being part of a gallery that is featured; 'curator_favorites' which are selected by a curator; and 'design_studio' which are projects from studio galleries.

Summary Statistics

plot of chunk unnamed-chunk-2

The following table shows the distribution of observations in terms of the values of section, which represents the area of the front page where the project was featured:

Section Count
curator_favorites 1164
design_studio 2009
featured 560
surprise 11160
top_downloaded 85
top_loved 5717
top_remixed 3036
top_viewed 8477

Omitted Observations

We omit 3,686 observations that describe projects placed on the front page that are no longer visible (e.g., they have been deleted by their creators).

Download Datasets

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