Example Orange Book queries

To help get you started, we have provided some query examples below. Use the Run query button to call the Application Programming Interface and get back results. You can experiment by editing the example queries in the black text box.

Example query

One product

This query searches for a specific product by application number.

  1. Search for application number 078687.

  2. Limit to 1 record.

Example query

Single source products

This query searches for all products which have only a single source.

  1. Search for all products without a therapeutic equivalence code.

  2. Limit to 20 records.

Example query

Expiring in 2020

This query searches all products that have patents and exclusivities expiring in the calendar year 2020.

Date ranges are wrapped in square brackets [].

  1. Search for all products which have patents.expiration_date falling within 2020.

  2. Search for all products which have exclusivity.exclusivity_expiration_date falling within 2020.

  3. Limit to 1 record.

Example query

Count of products, by application type (N = New Drug Applications and A = Abbreviated New Drug Applications)

This query compares the number of results which fall into the different application types. New applications are designated as N, while abbreviated applications are designated as A.

  1. Count the field application_type (application type).