Query Language

Sqoop’s new query language is simple to use and has some syntax in common with popular web and other search engines. Any invalid syntax will just be ignored, with the remaining parts of the query used.

"quoted phrase"

Quote multiple terms to match documents that contain that phrase, with the given terms adjacent to each other. Note that currently, using punctuation such as apostrophes or hyphens in phrases may lead to unexpected results.

AND & (default)

Multiple search terms, or any distinct arguments, are combined by default using the AND operator, meaning that documents must match all arguments. You may also explicitly state this using AND (capitalized or not) or & (with or without spaces).

OR |

Use OR to match documents that contain either left or right terms or arguments, but not necessarily both.


Use NOT to negate the next term or argument (avoid those documents). This is currently only supported when combined with additional arguments via AND.


By default, the infix/suffix operators have the following precedence (highest to lowest): NOT OR AND. Use parentheses to override the default precedence when needed or when in doubt.

SIC:code SIC:prefix*

Use the SIC: scope to filter SEC results to companies that have a particular 4-digit Standard Industry Classification or within a range given by a 2 or 3-digit prefix (trailing asterisk is optional). This may be combined with other SEC filters or query arguments.


Use the COURT scope to filter federal court dockets, and/or releases from the U.S. Attorney's Offices, by court code. See the list of available federal courts and codes. You can include multiple courts using OR and parentheses, and combine with other query arguments.