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". | |
Finds all insights owned by "siyeh". | |
Finds all datasets that are tagged "health" and have the word 'shelter' somewhere in them. | |
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" . | |
Find all datasets that have a specific tech owner. Note: This shows how to use custom metadata to form complex searches. | |
Find all datasets verified by a specific user. Note: This shows how to use custom metadata to form complex searches. | |
Find all columns available in files in datasets and projects with the term "county" in them. | |
Find all table columns in the catalog with the term "sales_agent" in the column name or description. | |
Find all business terms with the word "bill" in the name or description. | |
Find everything verified by a specific user. | |
Find everything that has a value set for a specific custom metadata fields defined for your catalog. | |
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 |