Adult keyword database

The database is available in mysqldump format and has two options distribution:

  • Lite (free)

The database contains 235 436 of keywords and 227 055 172 relations.


Database Structure:

Table keywords:

ID a unique identifier of keywords

sem_keyword keywords

sem_categorycategory from the table category (in the current database is always XXX)

sem_datethe date of entering in database

 

Table keywords_rel:

ID - a unique identifier of keywords

rel_idrelated keyword ID from the table keywords


Download links:

sem_small.sql.gz (2015.07.27)

Database size: ~654M archived (tar.gz format), ~5Gb on disk (mysql DB)

  • Full (50 USD)

The database contains 2 553 360 of keywords and 936 386 642 relations


Database Structure:

Table keywords:

IDa unique identifier of keywords

sem_keyword keywords

sem_search_volimeweighted average number of requests in Google search engine

sem_cpcweighted average cost of clicks (data taken from GoogleAdWords)

sem_number_reultsnumber of results in Google search engine

sem_category category from the table category (in the current database is always XXX)

sem_competitionthe relative level of competition for this request (data taken from GoogleAdWords). 1 - high level of competition, 0 - low.

rel_countthe number of keywords related to (the table keywords_rel)

sem_date the date of entering in database

 

Table keywords_rel:

ID - a unique identifier of keywords

rel_idrelated keyword ID from the table keywords


Download links:

sem.part1.rar
sem.part2.rar
sem.part3.rar
sem.part4.rar
sem.part5.rar
sem.part6.rar

Database size: ~2.7G archived (rar format), ~25Gb on disk (mysql DB)

Archive is password protected. In order to acquire a password, select a payment method:

Plati.ru service