Reference Manual (API Version 2.0)

Filter and sort examples

As documented in the Data rows service, multiple filter and sort parameters may be used to refine the data results from a table. This section combines these parameters for specific use cases. After each example, you may click the “Interactive demo” link to edit and customize the query yourself.

For more information about the content domains and rating scales available in the O*NET Database, see the O*NET Data Dictionary.

Example 1: Most important knowledge areas for architects

• knowledge data table
• filter=onetsoc_code.eq.17-1011.00 — to limit results to the occupation “Architects, Except Landscape and Naval”
• filter=scale_id.eq.IM — to examine Importance ratings specifically
• filter=data_value.gte.3 — to return Content Model descriptors scoring 50% or higher on the 1-to-5 Importance scale
• sort=data_value.descending — to return the highest-rated descriptors first
• sort=element_name — in case of tied ratings, return descriptors in alphabetical order

Example 2: Occupations requiring the most physical stamina

• abilities data table
• filter=element_id.eq.1.A.3.b.1 — to limit results to the “Stamina” Content Model descriptor
• filter=scale_id.eq.LV — to examine Level ratings specifically
• sort=data_value.descending — to return the highest-rated occupations first
• start=1&end=5 — to return the top five occupations

In this section

• Database Services
  • List of data tables
  • Table column information
  • Data rows
  • Filter and sort examples