Useful DQL Queries

Many new and learning users find Diffbot Query Language and the Knowledge Graph easier to traverse with some template queries. Start with some of the useful searches below and modify them to work towards your own external data needs!

Market Intelligence Search Queries

Companies in a City with Female CEO and Specified Size (San Francisco, <500 FTE)

type:Organization location.city.name:"San Francisco" nbEmployeesMax<500 ceo.gender:"Female"

Top Current Employers of Data Science Roles

type:Person employments.{title:or("data scientist", "analyst", "data science", "business intelligence") isCurrent:true} facet:employments.employer.name

Investments by Companies in a Certain Industry (Insurance)

type:Organization investments.{investors.name:or("AIG","CNA Financial","Manulife","Munich Re") date>="01/01/2019"} sortBy:name

Global Mid-Market Software Companies

type:Organization nbEmployeesMin>100 nbEmployeesMax<1000 industries:"Software Companies" not(industries:"Educational Companies") not(has:parentCompany) not(has:acquiredBy) revSortBy:nbActiveEmployeeEdges

SMB Advertising Companies With No Investments

type:Organization not(has:investments.amount.value) industries:"Advertising Companies" nbEmployeesMax<=100 nbEmployeesMin>=50

Individuals Employed In Automotive Software Roles In Europe (<1,100 miles from Hamburg)

type:Person employments.{isCurrent:true title:"Software" employer.industries:"Car"} locations:near[1100mi] (name:"Hamburg") facet:locations.country.name

Recent Founders Who Were VPs/Directors In Big Tech

type:Person employments.{employer.name:or("Google","Facebook","Uber","Apple") title:or("VP","Director")} employments.{isCurrent:true title:"Founder"}

Pre-IPO Companies

type:Organization investments.series:"Series E" totalInvestment.value>500000000 isPublic:false nbLocations>2 not(has:parentCompany) revSortBy:nbActiveEmployeeEdges

Small B2B Marketing Agencies Near Atlanta

type:Organization industries:"Service Companies" industries:"Marketing Companies" industries:"Advertising Companies" nbEmployeesMax<=15 location.country.name:"United States" description:"b2b" not(description:or("b2c", "consumer")) near[30mi](name:"Atlanta")

All Whole Foods Locations (By Fact Page Origin)

type:LocalBusiness name:"Whole Foods Market" re:homepageUri:"wholefoodsmarket.com/stores/[a-z]+" 

Industry Co Occurrence

type:Organization industries:"Manufacturing Companies" facet:industries

Hires Post a Specific Date at Google

type:Person employments.{employer.name:"Google" from>"2020-01-21" not(from<"2020-01-21")}

Industries FAANG Companies Invested In IN 2019

type:Organization investments.{investors.name:or("Facebook","Alphabet","Amazon","Microsoft","Apple","Netflix") date>="01/01/2019" date<="01/01/2020"} facet:industries

Companies who use Tableau software

type:Organization technographics.technology.name:"Tableau"

News Monitoring Search Queries

Most Recent Articles About Elon Musk (in English)

type:Article tags.uri:"diffbot.com/entity/EO2F04lnbMPOwRSDFAlKlGw" language:"en" sortBy:date

Negative Articles About Apple By Week

type:Article tags.{uri:"http://diffbot.com/entity/CHb0_0NEcMwyY8b083taTTw" sentiment<0.0} facet[week]:date

Media Mentions of Competitors

type:Article date<30d tags.label:or("Microsoft Teams", "Facebook Workplace")

Most Recirculated Quotes By Joe Biden (Last 30d)

type:Article date<30d quotes.speaker:"Joe Biden" facet:quotes.quote

Coverage About Protests By Country

type:Article tags.label:"protests" facet:publisherCountry

Most Prolific Authors on Medium.com

type:Article pageUrl:"medium.com" facet:author

Sentiment Distribution of Articles About GOP On CNN.com

type:Article pageUrl:"cnn.com" tags.label:or("GOP", "republicans", "conservatives") facet[-1:-.75,-.75:-.5,-.5:-.25,-.25:0,0:.25,.25:.5,.5:.75,.75:1]:sentiment