# Consultas sobre sentimientos comunitarios y toxicidad

**URL:** <https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741>\
**Category:** Data & reporting\
**Tags:** ai, sql-query\
**Created:** [12 Mayo, 2023 18:58 UTC](https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741 "2023-05-12T18:58:55Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![SaraDev](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/saradev/32/335139_2.png) [@SaraDev](https://meta.discourse.org/u/SaraDev)\
**Post date:** [12 Mayo, 2023 18:58 UTC](https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741/1 "2023-05-12T18:58:55Z")

</div>

Para aquellos que se preguntan cómo ver la base de datos de resultados de clasificación para los módulos de `Community Sentiment` y `Toxicity`, esto se puede hacer usando el plugin [Data Explorer](https://meta.discourse.org/t/32566?silent=true) y la tabla `classification_results`.

Esto es útil para ver cómo está funcionando el plugin de IA en su sitio y clasificando las publicaciones.

#### Sentimiento de IA

```sql
SELECT target_id as post_id,
model_used,
classification->'negative' as negative,
classification->'neutral' as neutral,
classification->'positive' as positive
from classification_results
WHERE model_used = 'sentiment'
order by id desc

```

 ![09cb357d6c2799a50b88c9051c47f9529525bd9f_2_690x119](https://global.discourse-cdn.com/meta/original/4X/e/a/5/ea5e9081952b008efbe9db35e2226b8cabb7fb89.png)

#### Emoción de IA:

```sql
SELECT target_id as post_id,
model_used,
classification->'neutral' as neutral,
classification->'sadness' as sadness,
classification->'surprise' as surprise,
classification->'fear' as fear,
classification->'anger' as anger,
classification->'joy' as joy,
classification->'disgust' as disgust
from classification_results
WHERE model_used = 'emotion'
order by id desc

```

 ![image](https://global.discourse-cdn.com/meta/original/4X/f/3/f/f3faa1a44f87edc58a2eac798c1ece7ca2281c6d.png)

#### Toxicidad de IA:

```sql
SELECT target_id as post_id,
classification->'toxicity' as toxicity,
classification->'severe_toxicity' as severe_toxicity,
classification->'obscene' as obscene,
classification->'identity_attack' as identity_attack,
classification->'insult' as insult,
classification->'threat' as threat,
classification->'sexual_explicit' as sexual_explicit
From classification_results
WHERE classification_type = 'toxicity'
order by id desc

```

 ![image](https://global.discourse-cdn.com/meta/original/4X/f/9/0/f909151dc7570d64474333b87f53d12b007a1ad6.png)

---

_[View the full topic](https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741)._