How the query builder works

The query builder lets you filter CDEK's data without writing SQL. Every query is built from one or more conditions, each made of three parts:

Field (a table column): A dataset is made up of columns and rows; each column represents one type of data — for example Approval status or Trial count.
Operator: How the field is compared — is, contains, >, and so on. Which operators are available depends on the field's type — a date field offers "before/after," a text field offers "contains."
Value: What you're comparing the field against. For example, in Approval status is approved, the value is approved.

Add as many conditions as you like — the query builder ANDs all of them together (a result must match every condition you've added; there's no OR). Every field and operator is validated against a server-side allow-list, so there's no way to construct a query outside what's explicitly supported — see the glossary for a definition of every field on each data set.

Worked example

To find every approved small-molecule drug that reached Phase 4, on the Drugs data set add:

Drug type is Small molecule
Max trial phase is Phase 4

Both conditions apply together — Phase 4 small molecules only, not either on its own.

Once you've run a query, an Export CSV button above the results table downloads exactly what's on screen. Result cells that reference a drug or organization link straight to its detail page.

Try it →