# Trust Level 3 Requirements Data Explorer

**URL:** https://meta.discourse.org/t/trust-level-3-requirements-data-explorer/113838
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [April 9, 2019, 8:09am UTC](https://meta.discourse.org/t/trust-level-3-requirements-data-explorer/113838 "2019-04-09T08:09:19Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Kyle\_Risi](https://avatars.discourse-cdn.com/v4/letter/k/b5ac83/32.png) [@Kyle\_Risi](https://meta.discourse.org/u/Kyle_Risi)
#### Post date: [April 9, 2019, 8:09am UTC](https://meta.discourse.org/t/trust-level-3-requirements-data-explorer/113838/1 "2019-04-09T08:09:20Z")

</div>

Hi Everyone,

I was wondering if someone can help me identify the [data explorer](https://meta.discourse.org/t/32566?silent=true) data tables that will help me pull the "Trust Level 3 requirements table (see below). I just cannot work out where this information is coming from 😭

I am trying to display all user data around individual progress towards trust level 3 requirements in a single table to help me identify users who are almost at level 3 so I can send out an email of encouragement

Any help will be massively appreciated 🤞

 ![image](https://global.discourse-cdn.com/meta/original/3X/0/2/02263a8470977f16f4bf5a2316cd87473afb4133.png)

---

<div class="post-metadata">

### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [April 9, 2019, 9:32am UTC](https://meta.discourse.org/t/trust-level-3-requirements-data-explorer/113838/2 "2019-04-09T09:32:48Z")

</div>

> [@Kyle\_Risi](#):
>
> I just cannot work out where this information is coming from 😭

It’s all in the [`trust_level_3_requirements.rb`](https://github.com/discourse/discourse/blob/ad5edc8bb1e8d6f156f40118d36e1a154e03fad8/app/models/trust_level3_requirements.rb) file. It’s a lot of queries though…

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [June 26, 2022, 3:13am UTC](https://meta.discourse.org/t/trust-level-3-requirements-data-explorer/113838/3 "2022-06-26T03:13:45Z")

</div>



---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 26, 2022, 5:35am UTC](https://meta.discourse.org/t/trust-level-3-requirements-data-explorer/113838/4 "2022-06-26T05:35:10Z")

</div>



---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 26, 2022, 5:37am UTC](https://meta.discourse.org/t/trust-level-3-requirements-data-explorer/113838/5 "2022-06-26T05:37:17Z")

</div>

For anyone finding this topic in future searches, there is a facsimile of the TL3 stats created as a [data explorer](https://meta.discourse.org/t/32566?silent=true) query in [Find the users which are more likely to become TL3 - #17 by ganncamp](https://meta.discourse.org/t/find-the-users-which-are-more-likely-to-become-tl3/91495/17)