Dataset Schema & Mapping Notes

Screenshot of the dataset (📁 download the dataset .csv)

---

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.