> For the complete documentation index, see [llms.txt](https://gang-gems.gitbook.io/qtv/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gang-gems.gitbook.io/qtv/dataset-integration-and-bottom-up-ontology-level-ii/dataset-schema-and-mapping-notes.md).

# Dataset Schema & Mapping Notes

<figure><img src="/files/g0ldvzJF1BdCe6tStpIP" alt=""><figcaption><p>Screenshot of the dataset (📁 <a href="https://raw.githubusercontent.com/Gang-Gems/QTV/main/datasets/dataset_top_down.csv">download the dataset .csv</a>)</p></figcaption></figure>

***

This page provides a technical breakdown of all the attributes included in the custom dataset used for the bottom-up ontology modeling.

Each field is mapped to its corresponding **ontology class or property**, ensuring interoperability and clarity for further reuse (e.g., RDF/OWL export, SPARQL queries).

***

### 🧑‍🎤 Character-Level Attributes

| Dataset Field                       | Ontology Mapping                             | Type          |
| ----------------------------------- | -------------------------------------------- | ------------- |
| Character Name                      | `characterName` (Data Property)              | String        |
| Gender of the Character             | `hasGender` → Gender (Class)                 | Instance      |
| Transgender character               | `isTransgender`                              | Boolean       |
| Sexual Orientation of the Character | `hasSexOrientation` → SexOrientation (Class) | Instance      |
| Character Transformation            | `characterTransformation`                    | String / Text |
| Dynamic Role                        | `hasNarrativeRole` = Dynamic                 | Boolean       |
| Static Role                         | `hasNarrativeRole` = Static                  | Boolean       |
| Character Depth                     | `hasCharacterDepth` → CharacterDepth (Class) | Instance      |
| Stereotypical Characterization      | `hasStereotype` = Stereotypical              | Boolean       |
| Gay Best Friend                     | `hasStereotype` = GayBestFriend              | Boolean       |
| Tragic Trope                        | `hasStereotype` = TragicTrope                | Boolean       |
| Tokenism                            | `hasStereotype` = Tokenism                   | Boolean       |
| Affirmation of Identity             | `affirmationOfIdentity`                      | Boolean       |
| Normalization of Relationships      | `normalizationOfRelationship`                | Boolean       |

***

### 🖼️ Portrayal-Level Attributes

| Dataset Field                    | Ontology Mapping                             | Type                                 |
| -------------------------------- | -------------------------------------------- | ------------------------------------ |
| Representation Type              | `representationType` → Fair / Unfair         | Instance                             |
| Justification for Classification | `justifiesRepresentation` (Data Property)    | String                               |
| Portrayal                        | `authenticityLevel` → Detailed / Superficial | Instance                             |
| Plot Resolution                  | `plotResolution`                             | Instance (e.g., Happy Ending, Death) |
| LGBTQ Community Impact           | `hasImpact` → Positive / Negative Role Model | Instance                             |
| Lens Orientation                 | `hasLensOrientation` → Lens (Class)          | Instance                             |

***

### 📺 TV Show-Level Attributes

| Dataset Field          | Ontology Mapping          | Type                  |
| ---------------------- | ------------------------- | --------------------- |
| Show Title             | `showTitle`               | String                |
| Year of Release        | `yearOfRelease`           | Integer               |
| Genre of the TV Series | `hasGenre`                | Instance              |
| Place of Publication   | `placeOfPublication`      | Instance (Country)    |
| Independent TV Series  | `isIndependentProduction` | Boolean               |
| Big Budget Series      | `hasBudgetCategory`       | Boolean / Categorical |

***

### 🎭 Performer-Level Attributes

| Dataset Field                   | Ontology Mapping                  | Type              |
| ------------------------------- | --------------------------------- | ----------------- |
| Performer                       | `performedBy` → Performer (Class) | Instance / String |
| Gender of Performer             | `hasGender`                       | Instance          |
| Sexual Orientation of Performer | `hasSexOrientation`               | Instance          |
| Transgender Performer           | `isTransgender`                   | Boolean           |

***

### 🖊️ Creator-Level Attributes

| Dataset Field                 | Ontology Mapping              | Type              |
| ----------------------------- | ----------------------------- | ----------------- |
| Creator                       | `createdBy` → Creator (Class) | Instance / String |
| Gender of Creator             | `hasGender`                   | Instance          |
| Sexual Orientation of Creator | `hasSexOrientation`           | Instance          |
| Transgender Creator           | `isTransgender`               | Boolean           |

***

### 🏢 Production Context

| Dataset Field         | Ontology Mapping                   | Type                              |
| --------------------- | ---------------------------------- | --------------------------------- |
| Production Company    | `isProducedBy` → ProductionCompany | Instance                          |
| Place of Publication  | `placeOfPublication`               | Instance                          |
| Independent TV Series | `isIndependentProduction`          | Boolean                           |
| Big Budget Series     | `hasBudgetCategory`                | Categorical (Low / Medium / High) |

***

### 💡 Notes

* All properties follow the conventions used in our dual ontology structure.
* Boolean values (Yes/No) are to be interpreted as RDF literals (`xsd:boolean`).
* Categorical values (e.g., gender identities, genres, representation types) are modeled as **instances of controlled vocabularies**.
* The column “Justification for Classification” may be mapped as a `rdfs:comment` or `explanationNote` for transparency.