# Check user email confirmed via DataExplorer

**URL:** <https://meta.discourse.org/t/check-user-email-confirmed-via-dataexplorer/169187>\
**Category:** Product Support\
**Created:** [November 4, 2020, 6:23am UTC](https://meta.discourse.org/t/check-user-email-confirmed-via-dataexplorer/169187 "2020-11-04T06:23:12Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![ds.discourse](https://avatars.discourse-cdn.com/v4/letter/d/c67d28/32.png) [@ds.discourse](https://meta.discourse.org/u/ds.discourse)\
**Post date:** [November 4, 2020, 6:23am UTC](https://meta.discourse.org/t/check-user-email-confirmed-via-dataexplorer/169187/1 "2020-11-04T06:23:12Z")

</div>

Via the API, I need to determine whether user ids have already confirmed their email address or not. Using DataExplorer I am querying the _email\_tokens_ table, but am confused about how to interpret multiple rows for a given user id. When there are multiple rows, N-1 of them have _expired = true_, but the row with _expired = false_ doesn’t seem to be the current state of whether they have confirmed their email address. For example there are verified users whose email\_tokens row with expired = false showing _confirmed = false_

Probably going about this the wrong way. Please advise. Thank you!

---

_[View the full topic](https://meta.discourse.org/t/check-user-email-confirmed-via-dataexplorer/169187)._