Each row in this table represents a project that was publicly visible on the Scratch website at the time that these data were collected. This is the text table that contains the free-form and the unstructured text fields in the projects table. Please see the documentation on that table for details.
This table includes text input directly from users. Due to technological error, data corruption, and intentional action by users, this table includes invalid UTF-8 data. For completeness sake, we have included these data. Using the find_fix_invalid_encoding_in_json.py program included in the example scripts to decode the JSON data, we found that there were 637 rows with text encoding issues.
This table includes 1,928,699 observations. Each row of this table corresponds to a single project.
| Variable | Type | Description |
|---|---|---|
| project_id | integer | Unique identifier for each project shared on the website (see projects page for detail). |
| title | character | Title of the project as entered by the user who shared the project. The creator could change this field at any time, however, only the last version is stored. |
| description | character | Free-form description of the project as entered by the user who shared the project. The creator could change this field at any time, however, only the last version is stored. |
We only include text for projects that are included in the projects table (that page gives details for omitted observations). In total, we omit 498,195 observations.
These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.