> ## Documentation Index
> Fetch the complete documentation index at: https://docs.corsair.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Database

> Benzinga local sync: searchable entities, `.search()` filters, and operators.

The Benzinga plugin syncs data locally. Use `corsair.benzinga.db.<entity>.search({ entity_id?, data, limit?, offset? })` with the filters listed per entity.

<Info>
  **New to Corsair?** See [database operations](/concepts/database), [data synchronization](/concepts/integrations), and [multi-tenancy](/concepts/multi-tenancy).
</Info>

## Conference Calls

Path: `benzinga.db.conferenceCalls.search`

```ts theme={null}
const rows = await corsair.benzinga.db.conferenceCalls.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `access_code` | `string` | equals, contains, startsWith, endsWith, in |
| `confirmed` | `boolean` | equals |
| `cusip` | `string` | equals, contains, startsWith, endsWith, in |
| `date` | `string` | equals, contains, startsWith, endsWith, in |
| `exchange` | `string` | equals, contains, startsWith, endsWith, in |
| `importance` | `number` | equals, gt, gte, lt, lte, in |
| `international_num` | `string` | equals, contains, startsWith, endsWith, in |
| `isin` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `notes` | `string` | equals, contains, startsWith, endsWith, in |
| `period` | `string` | equals, contains, startsWith, endsWith, in |
| `period_year` | `number` | equals, gt, gte, lt, lte, in |
| `phone_num` | `string` | equals, contains, startsWith, endsWith, in |
| `reservation_num` | `string` | equals, contains, startsWith, endsWith, in |
| `start_time` | `string` | equals, contains, startsWith, endsWith, in |
| `ticker` | `string` | equals, contains, startsWith, endsWith, in |
| `time` | `string` | equals, contains, startsWith, endsWith, in |
| `updated` | `number` | equals, gt, gte, lt, lte, in |
| `webcast_url` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Consensus Ratings

Path: `benzinga.db.consensusRatings.search`

```ts theme={null}
const rows = await corsair.benzinga.db.consensusRatings.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `ticker` | `string` | equals, contains, startsWith, endsWith, in |
| `aggregate_type` | `string` | equals, contains, startsWith, endsWith, in |
| `consensus_price_target` | `number` | equals, gt, gte, lt, lte, in |
| `consensus_rating` | `string` | equals, contains, startsWith, endsWith, in |
| `consensus_rating_val` | `number` | equals, gt, gte, lt, lte, in |
| `high_price_target` | `number` | equals, gt, gte, lt, lte, in |
| `low_price_target` | `number` | equals, gt, gte, lt, lte, in |
| `total_analyst_count` | `number` | equals, gt, gte, lt, lte, in |
| `unique_analyst_count` | `number` | equals, gt, gte, lt, lte, in |
| `updated_at` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Dividends

Path: `benzinga.db.dividends.search`

```ts theme={null}
const rows = await corsair.benzinga.db.dividends.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `confirmed` | `boolean` | equals |
| `currency` | `string` | equals, contains, startsWith, endsWith, in |
| `cusip` | `string` | equals, contains, startsWith, endsWith, in |
| `date` | `string` | equals, contains, startsWith, endsWith, in |
| `dividend` | `string` | equals, contains, startsWith, endsWith, in |
| `dividend_prior` | `string` | equals, contains, startsWith, endsWith, in |
| `dividend_type` | `string` | equals, contains, startsWith, endsWith, in |
| `dividend_yield` | `string` | equals, contains, startsWith, endsWith, in |
| `end_regular_dividend` | `boolean` | equals |
| `ex_dividend_date` | `string` | equals, contains, startsWith, endsWith, in |
| `exchange` | `string` | equals, contains, startsWith, endsWith, in |
| `frequency` | `number` | equals, gt, gte, lt, lte, in |
| `importance` | `number` | equals, gt, gte, lt, lte, in |
| `isin` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `notes` | `string` | equals, contains, startsWith, endsWith, in |
| `payable_date` | `string` | equals, contains, startsWith, endsWith, in |
| `period` | `string` | equals, contains, startsWith, endsWith, in |
| `record_date` | `string` | equals, contains, startsWith, endsWith, in |
| `ticker` | `string` | equals, contains, startsWith, endsWith, in |
| `updated` | `number` | equals, gt, gte, lt, lte, in |
| `year` | `number` | equals, gt, gte, lt, lte, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Earnings

Path: `benzinga.db.earnings.search`

```ts theme={null}
const rows = await corsair.benzinga.db.earnings.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `currency` | `string` | equals, contains, startsWith, endsWith, in |
| `cusip` | `string` | equals, contains, startsWith, endsWith, in |
| `date` | `string` | equals, contains, startsWith, endsWith, in |
| `date_confirmed` | `number` | equals, gt, gte, lt, lte, in |
| `eps` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_est` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_prior` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_surprise` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_surprise_percent` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_type` | `string` | equals, contains, startsWith, endsWith, in |
| `exchange` | `string` | equals, contains, startsWith, endsWith, in |
| `importance` | `number` | equals, gt, gte, lt, lte, in |
| `isin` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `notes` | `string` | equals, contains, startsWith, endsWith, in |
| `period` | `string` | equals, contains, startsWith, endsWith, in |
| `period_year` | `number` | equals, gt, gte, lt, lte, in |
| `revenue` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_est` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_prior` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_surprise` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_surprise_percent` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_type` | `string` | equals, contains, startsWith, endsWith, in |
| `ticker` | `string` | equals, contains, startsWith, endsWith, in |
| `time` | `string` | equals, contains, startsWith, endsWith, in |
| `updated` | `number` | equals, gt, gte, lt, lte, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Economics

Path: `benzinga.db.economics.search`

```ts theme={null}
const rows = await corsair.benzinga.db.economics.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `actual` | `string` | equals, contains, startsWith, endsWith, in |
| `actual_t` | `string` | equals, contains, startsWith, endsWith, in |
| `confirmed` | `boolean` | equals |
| `consensus` | `string` | equals, contains, startsWith, endsWith, in |
| `consensus_t` | `string` | equals, contains, startsWith, endsWith, in |
| `country` | `string` | equals, contains, startsWith, endsWith, in |
| `date` | `string` | equals, contains, startsWith, endsWith, in |
| `description` | `string` | equals, contains, startsWith, endsWith, in |
| `event_category` | `string` | equals, contains, startsWith, endsWith, in |
| `event_name` | `string` | equals, contains, startsWith, endsWith, in |
| `event_period` | `string` | equals, contains, startsWith, endsWith, in |
| `importance` | `number` | equals, gt, gte, lt, lte, in |
| `notes` | `string` | equals, contains, startsWith, endsWith, in |
| `period_year` | `number` | equals, gt, gte, lt, lte, in |
| `prior` | `string` | equals, contains, startsWith, endsWith, in |
| `prior_t` | `string` | equals, contains, startsWith, endsWith, in |
| `time` | `string` | equals, contains, startsWith, endsWith, in |
| `updated` | `number` | equals, gt, gte, lt, lte, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Guidance

Path: `benzinga.db.guidance.search`

```ts theme={null}
const rows = await corsair.benzinga.db.guidance.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `confirmed` | `boolean` | equals |
| `currency` | `string` | equals, contains, startsWith, endsWith, in |
| `cusip` | `string` | equals, contains, startsWith, endsWith, in |
| `date` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_guidance_est` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_guidance_max` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_guidance_min` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_guidance_prior_max` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_guidance_prior_min` | `string` | equals, contains, startsWith, endsWith, in |
| `eps_type` | `string` | equals, contains, startsWith, endsWith, in |
| `exchange` | `string` | equals, contains, startsWith, endsWith, in |
| `importance` | `number` | equals, gt, gte, lt, lte, in |
| `is_primary` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `notes` | `string` | equals, contains, startsWith, endsWith, in |
| `period` | `string` | equals, contains, startsWith, endsWith, in |
| `period_year` | `number` | equals, gt, gte, lt, lte, in |
| `prelim` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_guidance_est` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_guidance_max` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_guidance_min` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_guidance_prior_max` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_guidance_prior_min` | `string` | equals, contains, startsWith, endsWith, in |
| `revenue_type` | `string` | equals, contains, startsWith, endsWith, in |
| `ticker` | `string` | equals, contains, startsWith, endsWith, in |
| `time` | `string` | equals, contains, startsWith, endsWith, in |
| `updated` | `number` | equals, gt, gte, lt, lte, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Ipos

Path: `benzinga.db.ipos.search`

```ts theme={null}
const rows = await corsair.benzinga.db.ipos.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `currency` | `string` | equals, contains, startsWith, endsWith, in |
| `cusip` | `string` | equals, contains, startsWith, endsWith, in |
| `date` | `string` | equals, contains, startsWith, endsWith, in |
| `deal_status` | `string` | equals, contains, startsWith, endsWith, in |
| `description` | `string` | equals, contains, startsWith, endsWith, in |
| `exchange` | `string` | equals, contains, startsWith, endsWith, in |
| `initial_filing_date` | `string` | equals, contains, startsWith, endsWith, in |
| `insider_lockup_date` | `string` | equals, contains, startsWith, endsWith, in |
| `insider_lockup_days` | `number` | equals, gt, gte, lt, lte, in |
| `ipo_type` | `string` | equals, contains, startsWith, endsWith, in |
| `last_yr_income` | `number` | equals, gt, gte, lt, lte, in |
| `last_yr_income_year` | `number` | equals, gt, gte, lt, lte, in |
| `last_yr_revenue` | `number` | equals, gt, gte, lt, lte, in |
| `last_yr_revenue_year` | `number` | equals, gt, gte, lt, lte, in |
| `market_cap_at_offer` | `number` | equals, gt, gte, lt, lte, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `notes` | `string` | equals, contains, startsWith, endsWith, in |
| `offering_shares` | `number` | equals, gt, gte, lt, lte, in |
| `offering_shares_ord_adr` | `number` | equals, gt, gte, lt, lte, in |
| `offering_value` | `number` | equals, gt, gte, lt, lte, in |
| `open_date_verified` | `boolean` | equals |
| `ord_shares_out_after_offer` | `number` | equals, gt, gte, lt, lte, in |
| `price_max` | `string` | equals, contains, startsWith, endsWith, in |
| `price_min` | `string` | equals, contains, startsWith, endsWith, in |
| `price_open` | `string` | equals, contains, startsWith, endsWith, in |
| `price_public_offering` | `string` | equals, contains, startsWith, endsWith, in |
| `pricing_date` | `string` | equals, contains, startsWith, endsWith, in |
| `pricing_date_verified` | `boolean` | equals |
| `sec_accession_number` | `string` | equals, contains, startsWith, endsWith, in |
| `sec_filing_url` | `string` | equals, contains, startsWith, endsWith, in |
| `shares_outstanding` | `number` | equals, gt, gte, lt, lte, in |
| `sic` | `number` | equals, gt, gte, lt, lte, in |
| `spac_converted_to_target` | `boolean` | equals |
| `state_location` | `string` | equals, contains, startsWith, endsWith, in |
| `ticker` | `string` | equals, contains, startsWith, endsWith, in |
| `time` | `string` | equals, contains, startsWith, endsWith, in |
| `underwriter_quiet_expiration_date` | `string` | equals, contains, startsWith, endsWith, in |
| `underwriter_quiet_expiration_days` | `number` | equals, gt, gte, lt, lte, in |
| `updated` | `number` | equals, gt, gte, lt, lte, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## News Articles

Path: `benzinga.db.newsArticles.search`

```ts theme={null}
const rows = await corsair.benzinga.db.newsArticles.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `number` | equals, gt, gte, lt, lte, in |
| `author` | `string` | equals, contains, startsWith, endsWith, in |
| `created` | `string` | equals, contains, startsWith, endsWith, in |
| `updated` | `string` | equals, contains, startsWith, endsWith, in |
| `title` | `string` | equals, contains, startsWith, endsWith, in |
| `teaser` | `string` | equals, contains, startsWith, endsWith, in |
| `body` | `string` | equals, contains, startsWith, endsWith, in |
| `url` | `string` | equals, contains, startsWith, endsWith, in |
| `importance_rank` | `number` | equals, gt, gte, lt, lte, in |
| `original_id` | `number` | equals, gt, gte, lt, lte, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## News Channels

Path: `benzinga.db.newsChannels.search`

```ts theme={null}
const rows = await corsair.benzinga.db.newsChannels.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `number` | equals, gt, gte, lt, lte, in |
| `parent` | `number` | equals, gt, gte, lt, lte, in |
| `channel` | `string` | equals, contains, startsWith, endsWith, in |
| `weight` | `number` | equals, gt, gte, lt, lte, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Ratings

Path: `benzinga.db.ratings.search`

```ts theme={null}
const rows = await corsair.benzinga.db.ratings.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `action_company` | `string` | equals, contains, startsWith, endsWith, in |
| `action_pt` | `string` | equals, contains, startsWith, endsWith, in |
| `adjusted_pt_current` | `string` | equals, contains, startsWith, endsWith, in |
| `adjusted_pt_prior` | `string` | equals, contains, startsWith, endsWith, in |
| `analyst` | `string` | equals, contains, startsWith, endsWith, in |
| `analyst_id` | `string` | equals, contains, startsWith, endsWith, in |
| `analyst_name` | `string` | equals, contains, startsWith, endsWith, in |
| `currency` | `string` | equals, contains, startsWith, endsWith, in |
| `cusip` | `string` | equals, contains, startsWith, endsWith, in |
| `date` | `string` | equals, contains, startsWith, endsWith, in |
| `exchange` | `string` | equals, contains, startsWith, endsWith, in |
| `firm_id` | `string` | equals, contains, startsWith, endsWith, in |
| `importance` | `number` | equals, gt, gte, lt, lte, in |
| `isin` | `string` | equals, contains, startsWith, endsWith, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `notes` | `string` | equals, contains, startsWith, endsWith, in |
| `pt_current` | `string` | equals, contains, startsWith, endsWith, in |
| `pt_prior` | `string` | equals, contains, startsWith, endsWith, in |
| `rating_current` | `string` | equals, contains, startsWith, endsWith, in |
| `rating_prior` | `string` | equals, contains, startsWith, endsWith, in |
| `ticker` | `string` | equals, contains, startsWith, endsWith, in |
| `time` | `string` | equals, contains, startsWith, endsWith, in |
| `updated` | `number` | equals, gt, gte, lt, lte, in |
| `url` | `string` | equals, contains, startsWith, endsWith, in |
| `url_calendar` | `string` | equals, contains, startsWith, endsWith, in |
| `url_news` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Removed Calendar Events

Path: `benzinga.db.removedCalendarEvents.search`

```ts theme={null}
const rows = await corsair.benzinga.db.removedCalendarEvents.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `type` | `string` | equals, contains, startsWith, endsWith, in |
| `updated` | `number` | equals, gt, gte, lt, lte, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Removed News Items

Path: `benzinga.db.removedNewsItems.search`

```ts theme={null}
const rows = await corsair.benzinga.db.removedNewsItems.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `number` | equals, gt, gte, lt, lte, in |
| `updated` | `string` | equals, contains, startsWith, endsWith, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***

## Splits

Path: `benzinga.db.splits.search`

```ts theme={null}
const rows = await corsair.benzinga.db.splits.search({
    entity_id: { equals: '<id>' }, // optional, top-level (not inside data)
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

`entity_id` (`string`; equals, contains, startsWith, endsWith, in) is a top-level `.search()` option. The fields below go inside `data`.

| Field | Type | Operators |
| - | - | - |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `cusip` | `string` | equals, contains, startsWith, endsWith, in |
| `date_announced` | `string` | equals, contains, startsWith, endsWith, in |
| `date_distribution` | `string` | equals, contains, startsWith, endsWith, in |
| `date_ex` | `string` | equals, contains, startsWith, endsWith, in |
| `date_recorded` | `string` | equals, contains, startsWith, endsWith, in |
| `exchange` | `string` | equals, contains, startsWith, endsWith, in |
| `importance` | `number` | equals, gt, gte, lt, lte, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `notes` | `string` | equals, contains, startsWith, endsWith, in |
| `optionable` | `boolean` | equals |
| `ratio` | `string` | equals, contains, startsWith, endsWith, in |
| `split_type` | `string` | equals, contains, startsWith, endsWith, in |
| `ticker` | `string` | equals, contains, startsWith, endsWith, in |
| `updated` | `number` | equals, gt, gte, lt, lte, in |

*Every `.search()` also accepts `limit` and `offset` for pagination. `.list()` is available on the same path without the `.search` suffix in code — see [database operations](/concepts/database).*

***


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.