Operators and keywords
Keywords can also be used with a set of data.world-specific operators to further qualify your searches. There is a common set of rules that govern the use of these operators and it is consistent across all of them. For all keyword operators:
The syntax of an operator search string is
operator:keyword
where operator is the name of the operator and keyword is the string you want to match.There is no space after the colon (
operator:keyword
, notoperator: keyword
).If there are underscores, hyphens, or spaces in the search string you need to use double quotes to match the entire string. (
operator:"key word")
Created and updated
Created
and Updated
are two operators which can be used to find datasets, projects, insights, users, and organizations based on the date they are added or last updated.
Note
Timestamps are set in UTC, not your local time, so you might get results that are a day off of your local time depending on where you are.
Caution
All the links in the following examples open search results in the data.world open data community.
Created after date: created:>2022-01-22
Updated on or after date: updated:>=2021-07-01
Created before date: created:<2021-07-01
Updated on or before date: updated:<=2021-07-01
Created between dates (not including): created:{2021-07-01 TO 2021-07-03}
Extension
Searching with the extension
operator returns all datasets and projects which include files with the specified extension.
Note
The searches are exact-match only and the '.' is optional.
Here are some sample queries:
Note
All the links in the following examples open search results in the data.world open data community.
Search for all resources with .jpg files: extension:jpg, extension:"jpg", or extension:.jpg
Search for all projects with .jpeg files: extension:jpeg and resourcetype:project, extension:.jpeg and resourcetype:project, or extension:"jpeg" and resourcetype:project,
File
Use the file
operator to search for datasets and projects with specific files, or to search for a list of specific files.
Note
All the links in the following examples open search results in the data.world open data community.
Search for a list of projects and datasets with a specific word in file name: file:damage
Search for files with specific word in file name: type:file and damage
owner, creator, and contributor
The owner
of a resource is the person or entity who was designated as such when the resource was created. If a person was selected as the owner, that person will also be the creator. If an organization was selected as the owner, the creator will still be the person who created the resource. The owner
operator returns all the resources owned by either a person or an organization. The creator
operator returns all the resources created by a user. contributor
works the same as owner
, but instead of matching on resources the user owns, it matches resources where the user has been added as a contributor. They all follow the same patterns as user
and org
.
Note
All the links in the following examples open search results in the data.world open data community.
To search for | Use |
---|---|
Resources owned by any user or organization with 'dave' in either the display name or ID. | |
Resources owned by any user or organization with the exact display name or ID 'dave'. | owner:@dave owner:"@dave" |
Resources owned by the user whose display name is Dave Griffith. | |
Resources owned by the organization data-ny-gov (created by individuals in the organization). | |
Resources created by the user with the login stateofny | |
An exact match of everything contributed to by the user dave. | contributor:"dave" |
resourcetype
The resourcetype
operator allows you to search for the following types of resources:
dataset
project
insight
file
table
query
catalogTable
catalog
term
datatype
analysis
catalogEntry
collection
For example, to search for projects, use: resourcetype:project
It is best to use the resourcetype operator in conjunction with another search string. For example, to search for all projects with the word sales in the name, use: resourcetype:project and sales. For more details, see complex search.
status
Use the operator Status
to build advanced search queries to filter results on status. For example:
Search for all resources in Approved status by using a simple query: status:approved
Search for all datasets in Approved status using the following complex query: status:approved AND type:dataset
Search for all datasets owned by democorp in Deprecated status using the following complex query: status:deprecated and type:dataset and owner:democorp
table
The table
operator is used to find datasets and projects with specific tables in them. It looks for tablular data either in table or as a sheet in a spreadsheet.
Note
All the links in the following examples open search results in the data.world open data community.
To search for | Use |
---|---|
All datasets and projects with tables with "income"in the name. | |
Tables with the word "income" in them. This returns a list of tables. | |
All datasets and projects with the exact table name "austin_animal_center_outcomes" in them. | |
Tables with the exact name "austin_animal_center_outcomes". This returns a list of tables. |
tag
The tag
operator specifically searches against the tags associated with datasets or projects and returns a list of only the datasets and projects that have that tag. Partial and exact matches are allowed.
tag:property: Any dataset or project with the word 'property' in its tag (for example, property, property tax).
tag:"property tax": Only datasets and projects with the exact tag 'property tax'.
tag:"property" not tag:"land": Any datasets and projects that are tagged "property" and exclude results that have both the tags "property" and "land"
Note
In addition to alphanumeric characters, tags also support ampersands, apostrophes, and periods.
user and org
The user
and org
operators search for a string found in the display name or the ID of a Useror Organizationrespectively. The character "@" restricts the search to an exact match of the ID.
@denver or@dave:To look for exact user or organization.
org:denver: Any organization with "denver" in the display name or the organization ID.
user:"dave": All users with the exact login name 'dave' or display name 'dave'.
user:"dave griffith": Only the user whose display name is Dave Griffith.
visibility
The visibility
operator is mainly useful to verify permissions on your data:
visibility:private: Returns all private resources owned by you or an organization you are in.
visibility:open: Returns all public resources on data.world.