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.
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. |

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.
These data are access restricted. Details on gaining access are provided in the "Permission to Use Datasets" section of the overview page.