Each row in this table represents a gallery that was publicly visible on the Scratch website at the time that these data were collected. Galleries were collections of projects displayed on a web page. In addition to the list of projects, galleries had a name, a description, and a comment section. The projects listed in a gallery were represented by a thumbnail, the project name, and the project creator's username. The list of projects in each gallery can be found in the projects_galleries page table. The name and description of the galleries is available in the galleries text table.
The front page of the Scratch website featured three galleries, and a studio gallery. These galleries were selected and changed by the administrators of the site. Galleries also were linked from users' profile pages. There was also a page that listed all the galleries ever created.
The creator of a gallery determined who could add projects to the gallery from the following options: (1) any logged-in user, (2) only the creator, (3) the creator's friends, or (4) a specific set of the creator's friends. The details of this gallery administration was not systematically made public.
This table includes 120,097 observations. Each row of this table corresponds to a gallery that was available on the Scratch website.
| Variable | Type | Description |
|---|---|---|
| gallery_id | integer | Unique public identifier for each gallery. Used in URLs on the site and in a variety of other places within the dataset. This field is "autoincremented" and increases monotonically over time. |
| user_id | integer | The user id of the creator of the gallery. |
| date_created | datetime | The date and time when the gallery was created. |
Number of new galleries created, each month, over time:

Distribution of gallery creators by the number of galleries they have created.

Many galleries are no longer visible on the website because they have been removed either by the creators themselves (i.e. delbyusr) or by the administrators (delbyadmin). The visibility field, which is not included, includes the following distribution of projects across various categories of visibility.
| Status | Count |
|---|---|
| delbyadmin | 5113 |
| delbyusr | 31285 |
| visible | 120155 |
We limit the table to the 120,155 visible galleries.
Galleries were only public if the user who created the gallery had an active and visible account. As a result, we omit 58 additional galleries which were created by users that do not exist in our public user table. Many more galleries were marked invisible as part of the normal account deactivation process.
These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.