projects_text Table

Overview

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.

Description of Fields

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.

Omitted Observations

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.

Download Datasets

These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.