tags_galleries Table

Overview

Each row in this table represents a tag placed on a gallery. It is similar in structure and purpose to the tags_projects table. Tags were publicly displayed in the gallery page. Like projects, galleries could have zero or more tags and each tag can be associated with additional projects and galleries. Please see the tags_projects table for details on the way that tags worked in general.

When a gallery was tagged with a new tag that never been used before, a new row was added to the tags_text table and to this table. If a tag had been used before, a new row was only added to this table. It was possible for multiple users to tag the same gallery with the same tag multiple times which would record multiple rows for the same tag and project identifier but with a different user identifier. Because the identity of the user who tagged a gallery was never displayed publicly, we have removed these duplicate tags and included only the earliest gallery/tag relationship.

Galleries could be tagged as they were created, or afterwards, by the gallery creator or by any other logged-in user. Tags could only be removed by the gallery's creator and by administrators.

Description of Fields

This table includes 222,064 observations. Each row of this table corresponds to a single relationship (i.e., the inclusion of a tag on a gallery).

Variable Type Description
gallery_id integer Unique identifier of the gallery (see the galleries table).
tag_id integer Unique identifier of the tag (see the tags_text table for the content of the tag).
date_added datetime Date and time when the tag was assigned to the gallery.

Summary Statistics

plot of chunk unnamed-chunk-2

Omitted Observations

We omit 495 observations that describe duplicate tag relationships in the database (i.e., the same gallery and the same tag). In each case, we retain the first observation.

We omit 61,834 observations that describe tags placed on galleries which are not included in the gallery table (i.e., galleries which have been removed).

Technical issues in the website prevented the collection of gallery tags during several weeks of 2008.

Download Datasets

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