X
timbr.ai named a Cool Vendor in the 2021 Gartner ‘Cool Vendors in Data Management’ report

Query DBpedia like never before
with timbr-DBpedia SQL Knowledge Graph

Query DBpedia in

Select a Topic to see Sample Queries

General Purpose Queries

SQL Query:
SELECT format_number(count(1), 0) AS `Number of People`, entity_type AS `Belong to Category (Concepts)` FROM `timbr`.`person` GROUP BY entity_type ORDER BY count(1) DESC
Results:
SQL Query:
SELECT entity_id AS `DBpedia global id`, entity_type AS `Category`, entity_label AS `Label` FROM `etimbr`.`thing` WHERE `date` = ‘2000-01-01’
Results:
SQL Query:
SELECT entity_label AS `company_name`, `country.entity_label` AS `company_country`, `ceo.entity_label` AS `ceo_name`, `ceo.birthPlace.entity_label` AS `birthplace`, `ceo.birthPlace.country.entity_label` AS `ceo_birth_country` FROM `dtimbr`.`company` WHERE `ceo.entity_label` IS NOT NULL AND `country.entity_label` = ‘United States of America’ AND `ceo.birthPlace.country.entity_label` != ‘United States of America’ LIMIT 50
Results:

Marketing Industry Queries

SQL Query:
SELECT entity_label AS `Label`, entity_type AS `Category`, slogan AS `Slogan` FROM `etimbr`.`thing` WHERE slogan LIKE ‘%Best%’
Results:
SQL Query:
SELECT entity_id AS `Datasource Link`, entity_label AS `Title`, entity_type AS `Category`, releasedate AS `Release Date`, imdbid AS `IMDB-ID`, isbn AS `ISBN` FROM `etimbr`.`work` WHERE entity_label LIKE ‘%Batman%’
Results:
SQL Query:
SELECT lower(word) AS `word`, count(1) AS `num` FROM ( SELECT explode(split(motto, ‘ ‘)) AS `word` FROM `timbr`.`organisation` WHERE motto IS NOT NULL ) WHERE `length`(word) > 4 GROUP BY lower(word) ORDER BY num DESC LIMIT 50
Results:

Business Related Queries

SQL Query:
SELECT entity_label AS `Bank`, `owner.entity_label` AS `Owner`, `country.entity_label` AS `Country`, `country.continent.entity_label` AS `Continent` FROM `dtimbr`.`bank` WHERE `country.continent.entity_label` = ‘Europe’ AND `owner.entity_label` IS NOT NULL
Results:
SQL Query:
SELECT entity_label AS `Company Name`, format_number(operatingincome, 0) AS `Operating Income`, format_number(numberofemployees, 0) AS `Number of Employees`, format_number(operatingincome/numberofemployees, 0) AS `Operating Income per Employee`, `country.entity_label` AS `Country`, `country.continent.entity_label` AS `Continent` FROM `dtimbr`.`company` WHERE operatingincome > 150000000 AND `country.continent.entity_label` IN (‘Europe’, ‘Asia’) ORDER BY operatingincome DESC
Results
SQL Query:
SELECT entity_label AS `Company Name`, `owningcompany.entity_label` AS `Parent Company`, `owningcompany.owner.entity_label` AS `Owner of Parent Company`, entity_type AS `Company Category`, `country.entity_label` AS `Company Country` FROM `dtimbr`.`organisation` WHERE `owningcompany.owner.entity_label` LIKE ‘%Warner%’
Results:

Healthcare and Research Related Queries

SQL Query:
SELECT max(`country.entity_label`) AS `country`, COUNT(entity_id) AS `total_hospitals` FROM `dtimbr`.`hospital` WHERE `country.entity_id` IS NOT NULL GROUP BY `country.entity_id` ORDER BY COUNT(entity_id) DESC
Results:
SQL Query:
SELECT`entity_label` AS `Disease`, `complications` AS `Complications` FROM `dtimbr`.`disease` WHERE entity_label IS NOT NULL AND complications LIKE ‘%heart%’
Results:
SQL Query:
SELECT `entity_label` AS `Compound`, `meltingpoint` AS `Melting_Point`, `weight` AS `Weight`, `formula` AS `Formula`, `solubility` AS `Solubility`, `solventwithgoodsolubility.entity_label` AS `Good_Solvent` FROM `dtimbr`.`chemicalcompound` WHERE `solventwithgoodsolubility.entity_label` IS NOT NULL AND solubility IS NOT NULL AND solubility < 1000 AND meltingpoint > 200 ORDER BY solubility
Results:

Education Related Queries

SQL Query:
SELECT entity_label AS `University`, `facultysize` AS `Faculty Size`, `numberofstudents` AS `Number of Students`, `numberofundergraduatestudents` AS `Number of Undergraduate Students` FROM `timbr`.`university` ORDER BY facultysize DESC
Results:
SQL Query:
SELECT entity_id AS `Event_Link`, entity_label AS `DBpedia global id`, `country.entity_label` AS `Country`, `date` AS `Battle Date` FROM `dtimbr`.`militaryconflict` WHERE `country.entity_label` = ‘United Kingdom’ AND `date` IS NOT NULL ORDER BY `date` LIMIT 100
Results:
SQL Query:
SELECT entity_label AS `Journal`, `impactfactor` AS `Impact_Factor`, `impactfactorasof` AS `Impact_Factor_Year`, `publisher.entity_label` AS `Publisher` FROM `dtimbr`.`academicjournal` WHERE `publisher.entity_label` IS NOT NULL AND `impactfactor` IS NOT NULL AND `impactfactorasof` IS NOT NULL ORDER BY `impactfactor` DESC
Results:

Entertainment Industry Queries

SQL Query:
SELECT `artist.entity_label` AS `Artist_Name`, COUNT(entity_label) AS `Total_Songs` FROM `dtimbr`.`song` WHERE `entity_label` IS NOT NULL AND `artist.entity_label` IS NOT NULL GROUP BY `Artist_Name` ORDER BY `Total_Songs` DESC
Results:
SQL Query:
SELECT `entity_id` AS `DBpedia global id`, `entity_label` AS `Full_Name`, `birthdate` FROM `timbr`.`person` WHERE `entity_type` LIKE ‘%soccermanager%’ AND `entity_type` LIKE ‘%soccerplayer%’ ORDER BY `birthdate`
Results:
SQL Query:
SELECT `director.entity_label` AS `Director Name`, count(1) AS `num`, collect_list(entity_label) AS `movies` FROM `dtimbr`.`film` WHERE `starring.actor.entity_label` = ‘Adam Sandler’ AND `director` IS NOT NULL GROUP BY `director.entity_label` ORDER BY `num` DESC LIMIT 1
Results: