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.
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. |

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 |
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).
These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.