# Where are 'Do Not Contact' and Bounce stored in the db

**URL:** https://forum.mautic.org/t/where-are-do-not-contact-and-bounce-stored-in-the-db/6739
**Category:** Product Support
**Created:** [December 4, 2016, 12:15pm UTC](https://forum.mautic.org/t/where-are-do-not-contact-and-bounce-stored-in-the-db/6739 "2016-12-04T12:15:34Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![JakobM](https://avatars.discourse-cdn.com/v4/letter/j/c4cdca/32.png) [@JakobM](https://forum.mautic.org/u/JakobM)
#### Post date: [December 4, 2016, 12:15pm UTC](https://forum.mautic.org/t/where-are-do-not-contact-and-bounce-stored-in-the-db/6739/1 "2016-12-04T12:15:34Z")

</div>

Hi  
  
  
  
Can some one please tell me where the ‘Do Not Contact’ and Bounce are stored in the db, i’m trying to clean my list.  
  
  
  
Thanks

---

<div class="post-metadata">

### Author: ![JakobM](https://avatars.discourse-cdn.com/v4/letter/j/c4cdca/32.png) [@JakobM](https://forum.mautic.org/u/JakobM)
#### Post date: [December 4, 2016, 12:15pm UTC](https://forum.mautic.org/t/where-are-do-not-contact-and-bounce-stored-in-the-db/6739/2 "2016-12-04T12:15:34Z")

</div>

Hi

Can some one please tell me where the ‘Do Not Contact’ and Bounce are stored in the db, i’m trying to clean my list.

Thanks

---

<div class="post-metadata">

### Author: ![JakobM](https://avatars.discourse-cdn.com/v4/letter/j/c4cdca/32.png) [@JakobM](https://forum.mautic.org/u/JakobM)
#### Post date: [December 5, 2016, 9:09pm UTC](https://forum.mautic.org/t/where-are-do-not-contact-and-bounce-stored-in-the-db/6739/3 "2016-12-05T21:09:24Z")

</div>

Found it my self - leads\_donotcontact db

leads\_donotcontact dont have the email address so you have to get the email from the leads db

Mysql -\> PHPMyAdmin  
SELECT lead\_donotcontact._, leads._ FROM lead\_donotcontact, leads WHERE lead\_donotcontact.lead\_id = leads.id

This will get you the result you need, you only need to export it to a CSV file and clean it up.  
Import the CSV into a new segment (list) called Unsubscribe
