Using the search box
The search box at the top of the screen lets you search for information across all of Enigma Public’s collections and datasets.
Type the term you want to locate into the main search box and press Enter to begin your search. The search function is not case sensitive.
In the example above, we used the search term “federal reserve” (without quotes), which means find matches that include the word “federal” AND the word “reserve” within:
- The metadata for all collections and datasets (both words must appear within the collection metadata or within the dataset metadata)
- Each data record (row) within each dataset (both words must appear within the same row)
The search results for “federal reserve” are displayed below.
These results indicate that:
There are 2,226 datasets that include one or both of the following:
- Both “federal” and “reserve” in the metadata (for example, in the dataset description or the column headings)
- At least one row in the data snapshot with the words “federal” and “reserve”
There are five collections with the words “federal” and “reserve” in the collection metadata. Click Collections to view the matching collections.
The first dataset includes both words in the dataset’s description (you can see them in the snippet that’s displayed). The description for the second dataset does not include either of the words, but the dataset is included because there are matches within the data records.
The first dataset has 184,307 rows that include both words, and five metadata hits.
The second dataset has 16,028 rows that include both words, but no metadata hits. Datasets are typically ordered based on a combination of dataset hits and metadata hits, although there are other factors that can influence the ranking.
Filtering search results
The Filter By column at the left of the search results page lets you filter the results by collection, by dataset size, and by the date the datasets were last updated.
Filtering by collection
Initially, you’ll see results for all collections. To view only the results for specific collections, select the collections you want.
Whenever you filter the results in any way, you’ll see the applied filters listed at the top of the Filter By column. To remove a filter, click the red ‘x’, or use the “Clear all” option.
Filtering by dataset size
The Dataset Size chart shows the distribution of datasets within the search results by size.
If you’re interested in seeing datasets with a specific minimum or maximum size, move the sliders as needed. In the example below, the minimum (left slider) is set to 1,000 rows and the maximum (right slider) is set to 100,000 rows.
Filtering by “last updated” date
The Dataset Size chart shows the distribution of datasets within the search results based on the time each dataset was last updated, blocked by month.
If you’re interested in seeing datasets that were last updated before or after a specific date, move the sliders as needed. In the example below, the after date (left slider) is set to January 2018 and the before date (right slider) is set to April 2018.
Displaying matching data records
Typically when you search, you’re seeking data records that match your search criteria. If this is the case, look for datasets in the search results where the number of data hits (
in the example above) is greater than zero.
To view the matching data records (“hits”):
- Move the pointer over the row for the dataset you want to examine. You’ll see a View Dataset button appear at the right of the row.
- Click the View Dataset button to view the results in the data viewer.
The data viewer displays the rows in the selected dataset that match the search criteria.
You can scroll vertically through the matching rows and horizontally across the available columns. The filter
field at the top indicates the total number of matching rows and the search criteria.
There are various ways to narrow down your search and sort the results within the viewer. For information, see Viewing a dataset.
The search box supports a number of special characters for creating advanced searches. Terms used in advanced searches are not case sensitive.
+ is the AND operator. This is the default operator when you specify multiple terms in your search query. Use this to locate data records and metadata that include all the specified terms. This example searches for records that include the word “federal” AND the word “reserve.”
federal + reserve
| is the OR operator. Use this to locate data records and metadata that include either term (or both terms). This example searches for records with the word “federal” OR the word “reserve” (or both):
federal | reserve
- is the NOT operator. Use this to exclude results that contain a specific word. This example locates records that include the word “federal” but NOT the word “reserve”:
" " (Phrase)
" " indicates a phrase. Use this to locate records and metadata that contain an exact match (except for case) with whatever you put between the quotation marks. This example locates records that include the phrase “federal reserve” (or variants like “Federal Reserve”) within a single field:
* at the end of a term indicates a prefix query. It is like a wildcard character, except that you can use it only at the end of a string. This example locates records that include words that begin with “fed,” like “federal” and “federation”:
~n (Fuzzy matching)
~n, where n is an integer specifying the degree of closeness, lets you locate non-exact matches.
~1 signifies “within one character of,” so
advisor~1 matches both advisor and adviser. Similarly,
sulfur~2 matches both