Tables

Account

Returns status and metadata about your Diffbot token. Run this on first install to confirm the connection works. SELECT * FROM Account

Organization

Organizations in San Francisco with 100+ employees: SELECT * FROM Organization WHERE dql = 'type:Organization location.city.name:"San Francisco" nbEmployees>100'

Key fields: name, homepageUri, nbEmployees, categories, revenue, investments, locations, linkedInUri.

Full ontology at https://docs.diffbot.com/docs/ont-organization. Use this for lead generation, market research, competitive intelligence, or CRM enrichment.

Person

Everyone who has ever held a Founder title: SELECT * FROM Person WHERE dql = 'type:Person employments.title:"Founder"'

DQL gets powerful fast. The query below pulls current AI founders who previously worked at a FAANG company.

SELECT * FROM Person WHERE dql = 'type:Person employments.{title:"Founder" employer.categories.name:"Artificial Intelligence Software" isCurrent:true} employments.{employer.name:or("Facebook", "Amazon", "Apple", "Netflix", "Google") isCurrent:false}'

Key fields: name, educations (JSON array), employments (JSON array), linkedInUri.

Full ontology at https://docs.diffbot.com/docs/ont-person. Example use cases could be contact enrichment, talent sourcing, or executive profiling.

Article

M&A articles in English from the last 7 days: SELECT * FROM Article WHERE dql = 'type:Article categories.name:"Acquisitions, Mergers and Takeovers" date<7d language:en sortBy:date'

Key fields: title, text, author, pageUrl, date.str, publisherCountry, tags.

Full ontology at https://docs.diffbot.com/docs/ont-article. Example use cases could be news monitoring, M&A tracking, or market intelligence.

Place

Every city in Texas: SELECT * FROM Place WHERE dql = 'type:Place types:"City" location.country.name:"United States" location.region.name:"Texas"'

Key fields: name, summary, description, population, location.latitude, location.longitude.

Full ontology at https://docs.diffbot.com/docs/ont-place. Example use cases could be market sizing, location based targeting, or geographic enrichment.