Skip to main content

Creating advanced searches manually

This article is an advanced look at the search operators used in the search bar on data.world. For an introduction to all search capabilities including filtering search results and finding similar data start with the article on finding data.

There is a lot of information on data.world, and finding just the data resource that you're looking for can be a daunting task. Fortunately the robust search options available with the data.world search engine enable you to craft just the right search string to find what you're looking for. From the search bar (located at the top of your homepage and on many other data.world pages), you can search for an entire phrase or for matches on single words. Additionally, you can qualify your search with various operators or perform complex searches combining operators.

Two ways for running advanced searches:

  • Use the Advanced Search tool. This friendly form helps you construct more complex searches with multiple filters, logical operators, categories, and custom metadata fields.

  • If you are an expert user and know the advanced queries, you can type them directly in the Search bar. See the following table to get you started on the advanced search queries. Replace the resource types and search terms to adapt the queries for your needs.

Note

All the links in the following examples open search results in the data.world open data community.

If you want to

Use

Find all projects owned by "siyeh".

owner:siyeh AND resourcetype:projects

Finds all insights owned by "siyeh".

owner:siyeh AND resourcetype:insight

Finds all datasets that are tagged "health" and have the word 'shelter' somewhere in them.

type:dataset AND tag:health AND shelter

Finds all datasets tagged as "economics" and created between the specified dates.

type:dataset AND tag:"economics" AND created:{2021-01-01 TO 2021-07-03}

Find all datasets owned by "democorp" that have the status "deprecated" .

type:dataset and owner:democorp AND status:deprecated

Find all datasets that have a specific tech owner.

Note: This shows how to use custom metadata to form complex searches.

type:dataset AND metadata:"Tech Owner:brenda griffith"

Find all datasets verified by a specific user.

Note: This shows how to use custom metadata to form complex searches.

type:dataset AND metadata:"verified by:Sarah Smart"

Find all columns available in files in datasets and projects with the term "county" in them.

county AND type:"dataset column"

Find all table columns in the catalog with the term "sales_agent" in the column name or description.

type:column AND "sales_agent"

Find all business terms with the word "bill" in the name or description.

type:"business term" AND bill

Find everything verified by a specific user.

metadata:"verified by:Sarah Smart"

Find everything that has a value set for a specific custom metadata fields defined for your catalog.

hasMetadata:"Steward"

Find everything that does not have a value set for a custom metadata fields defined for your catalog.

NOT hasMetadata:"Steward"

Find everything that has a value/does not have a value set for the following standard data.world fields.

title: For datasets, metadata resources, columns, users, and organizations.

has:title

NOT has:title

tag: For datasets, metadata resources, and columns

has:tag

NOT has:tag

bio: For users and organization

has:bio

NOT has:bio

datatype: For columns

has:datatype

NOT has:datatype

status: For datasets, metadata resources, and columns

has:status

NOT has:status

summary: For datasets and metadata resources

has:summary

NOT has:summary

description: For datasets, metadata resources, and columns

has:description

NOT has:description