Each row in this table represents a project that was publicly visible on the Scratch website at the time that these data were collected. Projects are the interactive creations (e.g., video games, interactive art, simulations, and animations) that users share onto the website. Projects are composed of one or more sprites (e.g., a character in a game). Each sprite has one or more images which are called "costumes" in Scratch (e.g., different visual representations of a character in a game). Each sprite can also have blocks of code that control its behavior (e.g., move left when the left arrow is pressed) called "scripts" in Scratch.
The Scratch authoring environment used during the period represented in this dataset allowed users to create and save their projects locally on their computers and, optionally, to share these projects onto the website by pressing a "Share" button. People could also download any project available on the website onto their computers, make changes to them, and upload them back to the website. This is referred to as "remixing" and remix status was reflected on the website on each project's page (e.g., "Project by Alice based on Bob's project").
This table's columns represent metadata about projects and their creators. Some of the columns come from the "projects" database table that was used directly in the production website, others were generated using data from other database tables.
The title and description of projects is available in the projects_text table.
This table includes 1,928,699 observations. Each row of this table corresponds to a single project shared on the Scratch website.
| Variable | Type | Description |
|---|---|---|
| project_id | integer | Unique identifier for each project shared on the website. Used in public URLs and in other tables within the database to refer to projects. This field is "autoincremented" and increases monotonically over time. |
| user_id | integer | Unique identifier of the user who created the project. See the documentation on users for detail. We have limited the dataset to projects by users who are visible (i.e., users who have not been deleted). |
| date_created | datetime | The date and time that the project was first shared on the Scratch website. |
| viewers_website | integer | The number of times a project has been viewed as reported on the project page on the Scratch website. Due to a series of changes to the way in which number has been computed over time, the number is not reproducible for every project today. Originally, this number reflected project views including those from non-logged in visitors. Subsequently, it reflected unique project views (including those from non-logged-in visitors). For most of the life of the Scratch website, it has reflected the number of views by unique logged-in users. This variable is included for people interested in the number published on the website. The viewers table includes the list of unique views and can be used as a more consistent measure. |
| lovers_website | integer | The number of unique logged-in users that have clicked the "loveit" button on the project page for the project, as reflected on the project page. See the documentation on the lovers table for details. |
| downloaders_website | integer | The number of unique users who have downloaded each project as displayed on the project page. See the documentation for the downloads table for detail. |
| sprites_website | integer | Number of "sprites" as displayed on the Scratch website. |
| scripts_website | integer | Number of "scripts" as displayed on the Scratch website. |
| parent_project_id | integer | If a project is a remix, this field reports the project_id of the direct ancestor (i.e., the project that the remix was based on). This value will be empty if the project is not a remix. |
| parent_user_id | integer | If the project is a remix, this field will report the unique user identifier of the user who created the parent project. This will be the user_id of the project referred to in parent_project_id. The value will be empty if the project is not a remix. |
| locked | logical | A boolean indicator of whether or not the creator has disabled comments and tags on the project. Projects that are locked display a message to users explaining that the project is locked. |
| is_remix | logical | A boolean that indicates whether the project is a remix. For non-remixes, it will be false. |
| is_self_remix | logical | A boolean that indicates whether the project is a remix of a project shared by the same user. This variable should indicate whether the user_id is identical to the parent_user_id. For non-remixes, it will be false. |
| is_remixed | logical | A boolean that indicates whether the project has been remixed. For projects that have not been remixed, it will be false. |
| blocks | integer | The total number of blocks of code this project uses. Each occurrence of each block is counted. |
| block_types | integer | The number of unique blocks of code used by this project. Repeated uses of the same block are counted once. For example, this variable will be 2, even if the project has the 'if-then' block ten times, and the 'say' block five times. |
| images | integer | The number of images (i.e., costumes) in the project. This is the sum of all images in all sprites of a project. |
| sounds | integer | The number of sounds in the project. This is the sum of all sounds in all sprites of a project. |
| ugstrings | integer | The number of user-generated text strings in the code of the project. Example: the text "hello" displayed in a speech balloon using the "say" block. |
| saves | integer | The number of times the project was saved locally in the user's hard drive before sharing it on the website. This information is present in the publicly available Scratch project binary files and can be retrieved using a hidden feature in the Scratch authoring environment. |
| seconds_to_share | integer | The number of seconds that passed from the time the project was first saved until it was shared on the website. |
| seconds_to_remix | integer | The number of seconds that passed from the time the project was first shared until it was first remixed. Its value is zero if it has never been remixed. For about 8,000 rows the value is negative and it is caused by unusual circumstances such as when a user deleted a previously remixed project, and then uploaded another with the same name. |
| is_remix_identical | logical | Boolean that is true if the project is a remix and it is identical to the project on which it is based on. |
| is_remix_identical_media | logical | Boolean that is true if the project is a remix and its media (i.e. images and sounds) are identical to the project on which it is based on. Media are considered to be identical if they have the same file size and name. |
| is_remix_identical_code_and_strings | logical | Boolean that is true if the project is a remix and its code (i.e. scripts) is identical to the project on which it is based on. Code is considered to be identical by doing a text string comparison, including user-generated text, such as variable names and text in speech balloons. |
| is_remix_identical_code | logical | Boolean that is true if the project is a remix and its code (i.e. scripts) is identical to the project on which it is based on. Code is considered to be identical by doing a text string comparison, but the user-generated text is not used in this comparison (e.g., variable names and text in speech balloons). |
| remix_added_images | integer | If the project is a remix, this is the number of images that were added to the parent project when creating the current project. This was generated automatically by looking at file size and name. |
| remix_deleted_images | integer | If the project is a remix, this is the number of images that were deleted from the parent project when creating the current project. This was generated automatically by looking at file size and name. |
| remix_changed_images | integer | If the project is a remix, this is the number of images that were changed from the parent project when creating the current project. This was generated automatically by looking at file size and name. |
| remix_added_sounds | integer | If the project is a remix, this is the number of sounds that were added to the parent project when creating the current project. This was generated automatically by looking at file size and name. |
| remix_deleted_sounds | integer | If the project is a remix, this is the number of sounds that were deleted from the parent project when creating the current project. This was generated automatically by looking at file size and name. |
| remix_changed_sounds | integer | If the project is a remix, this is the number of sounds that were changed from the parent project when creating the current project. This was generated automatically by looking at file size and name. |
| remix_editdistance_code_and_strings | integer | If the project is a remix, edit distance is a measure of how different the code of the current project and its parent are. This was generated automatically. This calculation includes the user-generated text (such as variable names and speech balloons). |
| remix_editdistance_code | integer | If the project is a remix, edit distance is a measure of how different the code of the current project and its parent are. This was generated automatically. This calculation does not include the user-generated text (such as variable names and speech balloons). |
| remix_editdistance_media | integer | If the project is a remix, edit distance is a measure of how different the media (i.e. images and sounds) of the current project and its parent are. This was generated automatically simply using the size and name of the media. |
| remix_editdistance_images | integer | If the project is a remix, edit distance is a measure of how different the images of the current project and its parent are. This was generated automatically simply using the file size and name of the images. |
| remix_editdistance_sounds | integer | If the project is a remix, edit distance is a measure of how different the sounds of the current project and its parent are. This was generated automatically simply using the file size and name of the sounds. |
| remix_derivativeness | integer | If the project is a remix, this is a measure of how much of the current project's content is derived from its parent. |
| remix_derivativeness_images | integer | If the project is a remix, this is a measure of how much of the current project's images are derived from its parent. |
| remix_derivativeness_sounds | integer | If the project is a remix, this is a measure of how much of the current project's sounds are derived from its parent. |
| remix_derivativeness_blocks | integer | If the project is a remix, this is a measure of how much of the current project's blocks is derived from its parent. |
| remix_derivativeness_text | integer | If the project is a remix, this is a measure of how much of the current project's user-generated text (e.g., variable names and speech balloons) is derived from its parent. |
| remix_derivativeness_parameters | integer | If the project is a remix, this is a measure of how much of the current project's parameters are derived from its parent. |
Number of projects created, each month, over time:

"Logical" (i.e. boolean) variables are distributed as follows:
| variable | TRUE | FALSE | NAs |
|---|---|---|---|
| locked | 11459 | 1917240 | 0 |
| is.remix | 506698 | 1422001 | 0 |
| is.self.remix | 177661 | 1751038 | 0 |
| is.remixed | 220225 | 1708474 | 0 |
| is.remix.identical | 37015 | 469683 | 1422001 |
| is.remix.identical.media | 80612 | 371566 | 1476521 |
| is.remix.identical.code.and.strings | 102490 | 329081 | 1497128 |
| is.remix.identical.code | 124679 | 306892 | 1497128 |
First, we limit the table to only the 1,929,668 visible projects, i.e. publicly available ones. The visibility field, which is not included, describes the reasons why a project might not be publicly available. The table below shows the distribution of projects across various categories of visibility. For example, delbyuser represents projects removed by their creator, while delbyadmin and censbyadmin are those removed by the website administrators (often due to violation of the terms of use).
| Status | Count |
|---|---|
| censbyadmin | 3657 |
| censbycm | 7 |
| censbycomm | 161 |
| delbyadmin | 4066 |
| delbyusr | 489335 |
| visible | 1929668 |
Additionally, we omit 16 projects that are recorded with invalid user_id which we believe came from testing data. Lastly, we omit 953 projects created by users not included in the public user table. This final group seems primarily to be due to database and software errors.
These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.