Each row in this table represents a tag placed on a project. Projects can have zero or more tags. Each tag can be also associated with additional projects or galleries. Tags were publicly displayed in the project page.
When a project was tagged with a new tag that never been used before, a new row was added to the tags_text table and to this table. If a tag had been used before, a new row was only added to this table. It was possible for multiple users to tag the same project with the same tag multiple times which would record multiple rows for the same tag and project identifier but with a different user identifier. Because the identity of the user who tagged a project was never displayed publicly, we have removed these duplicate tags and included only the earliest project/tag relationship.
People could tag projects when they uploaded them from the Scratch authoring environment by checking a box next to each item of a predefined list of tags (e.g., game, animation, etc.) or by typing free-form text into a text box. Once a project was uploaded, the creator and other logged in users could also tag the project with additional tags. Only project creators and administrators could remove tags from projects (including tags created by others).
This table includes 2,905,774 observations. Each row of this table corresponds to a single relationship (i.e., the inclusion of a tag on a project).
| Variable | Type | Description |
|---|---|---|
| project_id | integer | Unique identifier for the project (see the projects table). |
| tag_id | integer | Unique identifier of the tag (see the tags_text table for the content of the tag). |
| date_added | datetime | Date and time when the project was taggged. |

We omit 110,356 observations that describe duplicate tag relationships in the database (i.e., the same project and the same tag). In each case, we retain the first observation.
Additionally, we omit 748,008 observations that describe tags placed on projects which are not included in the project table (i.e., projects which have been removed).
These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.