featured_projects Table

Overview

Each row in this table represents a project that has been displayed on the front page of the Scratch website in a section called "featured projects" that held three projects at a time.

Only Scratch website administrators could add projects to this section. Projects in this section were displayed from most to least recently "featured." When a project was added to the section, it would "bump" the least recently featured project so that it would no longer be displayed on the page. The process of selecting featured projects was entirely manual and was usually driven by a decision about the quality and appeal of the project.

Description of Fields

This table includes 1,227 observations. Each row of this table corresponds to a single addition of a project to the featured project list.

Variable Type Description
project_id integer Unique identifier of the project (see the projects table).
date_featured datetime Date and time when the project was featured.

Summary Statistics

plot of chunk unnamed-chunk-2

Omitted Observations

We omit 58 observations of projects that are not included in the projects table (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.