tags_text Table

Overview

Each row in this table represents a tag used on a project and/or gallery. This is the text table that contains the free-form and the unstructured text field in the tables tags_projects and tags_galleries. Please see the documentation on those tables 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 196 rows with text encoding issues.

Description of Fields

This table includes 353,934 observations. Each row of this table corresponds to a single tag.

Variable Type Description
tag_id integer Unique identifier of the tag.
date_created datetime Date and time when the tag was first introduced into the system. In most cases, this will match the first recorded use in either the tags_projects or tags_galleries table. In some cases, it may have an earlier timestamp because the tag was first introduced to a project that was removed or because the tag itself was removed from the project or gallery that it was first used in.
text character Actual text of the tag.

Summary

The following figure shows the distribution of tags by date_created:

plot of chunk unnamed-chunk-2

Omitted Observations

We only include text for tags that are included in the either of our two tag relationships tables tags_projects table and tags_galleries table. Those pages give details for omitted observations within those tables. In total, we omit 119,699 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.