projects_galleries Table

Overview

Each row in this table reflects a project's inclusion in a gallery at the point of data collection.

Projects will be listed multiple times in this table if they had been placed in multiple galleries. Projects that were not listed in any gallery are not listed. When projects were removed from a gallery, the record was removed from the database. As a result, no indication of historical membership in galleries (e.g., projects that were removed from galleries) was maintained.

Description of Fields

The final table includes 908,717 observations. Each row of this table corresponds to a single relationship (i.e., the inclusion of a project in a gallery).

Variable Type Description
gallery_id integer Unique identifier of the gallery (see the galleries table).
project_id integer Unique identifier for the project (see the projects table).
date_added datetime Date and time when the project was added to the gallery.

Summary Statistics

plot of chunk unnamed-chunk-2

Omitted Observations

We omit 44 observations that describe duplicate relationships in the database. In each case, we retain the first observation.

Additionally, we omit observations that describe either galleries that are not included in the galleries table or projects that are not included in the projects table. The distribution across these two possibilities is shown in following table:

Gallery Exists Project Exists Count
FALSE FALSE 1048
TRUE FALSE 95781
FALSE TRUE 2741
TRUE TRUE 908717

We retain only the 908,717 relationships that involve public galleries and public projects.

Download Datasets

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