> ## 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

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

The BigDataCloud plugin syncs data locally. Use `corsair.bigdatacloud.db.<entity>.search({ 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>

## Asns

Path: `bigdatacloud.db.asns.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.asns.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `asn` | `string` | equals, contains, startsWith, endsWith, in |
| `asnNumeric` | `number` | equals, gt, gte, lt, lte, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `organisation` | `string` | equals, contains, startsWith, endsWith, in |
| `registry` | `string` | equals, contains, startsWith, endsWith, in |
| `registeredCountry` | `string` | equals, contains, startsWith, endsWith, in |
| `registeredCountryName` | `string` | equals, contains, startsWith, endsWith, in |
| `registrationDate` | `string` | equals, contains, startsWith, endsWith, in |
| `registrationLastChange` | `string` | equals, contains, startsWith, endsWith, in |
| `totalIpv4Addresses` | `number` | equals, gt, gte, lt, lte, in |
| `totalIpv4Prefixes` | `number` | equals, gt, gte, lt, lte, in |
| `totalIpv4BogonPrefixes` | `number` | equals, gt, gte, lt, lte, in |
| `totalIpv6Prefixes` | `number` | equals, gt, gte, lt, lte, in |
| `totalIpv6BogonPrefixes` | `number` | equals, gt, gte, lt, lte, in |
| `rank` | `number` | equals, gt, gte, lt, lte, in |
| `rankText` | `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).*

***

## Bgp Prefixes

Path: `bigdatacloud.db.bgpPrefixes.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.bgpPrefixes.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `bgpPrefix` | `string` | equals, contains, startsWith, endsWith, in |
| `bgpPrefixNetworkAddress` | `string` | equals, contains, startsWith, endsWith, in |
| `bgpPrefixLastAddress` | `string` | equals, contains, startsWith, endsWith, in |
| `registryStatus` | `string` | equals, contains, startsWith, endsWith, in |
| `isBogon` | `boolean` | equals |
| `isAnnounced` | `boolean` | equals |
| `asn` | `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).*

***

## Countries

Path: `bigdatacloud.db.countries.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.countries.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `isoAlpha2` | `string` | equals, contains, startsWith, endsWith, in |
| `isoAlpha3` | `string` | equals, contains, startsWith, endsWith, in |
| `m49Code` | `number` | equals, gt, gte, lt, lte, in |
| `name` | `string` | equals, contains, startsWith, endsWith, in |
| `isoName` | `string` | equals, contains, startsWith, endsWith, in |
| `isoNameFull` | `string` | equals, contains, startsWith, endsWith, in |
| `unRegion` | `string` | equals, contains, startsWith, endsWith, in |
| `callingCode` | `string` | equals, contains, startsWith, endsWith, in |
| `countryFlagEmoji` | `string` | equals, contains, startsWith, endsWith, in |
| `wikidataId` | `string` | equals, contains, startsWith, endsWith, in |
| `geonameId` | `number` | equals, gt, gte, lt, lte, in |
| `isIndependent` | `boolean` | equals |

*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).*

***

## Email Validations

Path: `bigdatacloud.db.emailValidations.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.emailValidations.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `emailAddress` | `string` | equals, contains, startsWith, endsWith, in |
| `isValid` | `boolean` | equals |
| `isSyntaxValid` | `boolean` | equals |
| `isMailServerDefined` | `boolean` | equals |
| `isKnownSpammerDomain` | `boolean` | equals |
| `isDisposable` | `boolean` | equals |

*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).*

***

## Hazard Reports

Path: `bigdatacloud.db.hazardReports.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.hazardReports.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `ip` | `string` | equals, contains, startsWith, endsWith, in |
| `isKnownAsTorServer` | `boolean` | equals |
| `isKnownAsVpn` | `boolean` | equals |
| `isKnownAsProxy` | `boolean` | equals |
| `isSpamhausDrop` | `boolean` | equals |
| `isSpamhausEdrop` | `boolean` | equals |
| `isSpamhausAsnDrop` | `boolean` | equals |
| `isBlacklistedUceprotect` | `boolean` | equals |
| `isBlacklistedBlocklistDe` | `boolean` | equals |
| `isKnownAsMailServer` | `boolean` | equals |
| `isKnownAsPublicRouter` | `boolean` | equals |
| `isBogon` | `boolean` | equals |
| `isUnreachable` | `boolean` | equals |
| `hostingLikelihood` | `number` | equals, gt, gte, lt, lte, in |
| `isHostingAsn` | `boolean` | equals |
| `isCellular` | `boolean` | equals |
| `iCloudPrivateRelay` | `boolean` | equals |

*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).*

***

## Networks

Path: `bigdatacloud.db.networks.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.networks.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `ip` | `string` | equals, contains, startsWith, endsWith, in |
| `cidr` | `string` | equals, contains, startsWith, endsWith, in |
| `registry` | `string` | equals, contains, startsWith, endsWith, in |
| `registryStatus` | `string` | equals, contains, startsWith, endsWith, in |
| `registeredCountry` | `string` | equals, contains, startsWith, endsWith, in |
| `registeredCountryName` | `string` | equals, contains, startsWith, endsWith, in |
| `organisation` | `string` | equals, contains, startsWith, endsWith, in |
| `isReachableGlobally` | `boolean` | equals |
| `isBogon` | `boolean` | equals |
| `bgpPrefix` | `string` | equals, contains, startsWith, endsWith, in |
| `bgpPrefixNetworkAddress` | `string` | equals, contains, startsWith, endsWith, in |
| `bgpPrefixLastAddress` | `string` | equals, contains, startsWith, endsWith, in |
| `totalAddresses` | `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).*

***

## Phone Validations

Path: `bigdatacloud.db.phoneValidations.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.phoneValidations.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `number` | `string` | equals, contains, startsWith, endsWith, in |
| `isValid` | `boolean` | equals |
| `e164Format` | `string` | equals, contains, startsWith, endsWith, in |
| `internationalFormat` | `string` | equals, contains, startsWith, endsWith, in |
| `nationalFormat` | `string` | equals, contains, startsWith, endsWith, in |
| `location` | `string` | equals, contains, startsWith, endsWith, in |
| `lineType` | `string` | equals, contains, startsWith, endsWith, in |
| `countryCode` | `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).*

***

## Reverse Geocodes

Path: `bigdatacloud.db.reverseGeocodes.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.reverseGeocodes.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `latitude` | `number` | equals, gt, gte, lt, lte, in |
| `longitude` | `number` | equals, gt, gte, lt, lte, in |
| `continent` | `string` | equals, contains, startsWith, endsWith, in |
| `continentCode` | `string` | equals, contains, startsWith, endsWith, in |
| `countryName` | `string` | equals, contains, startsWith, endsWith, in |
| `countryCode` | `string` | equals, contains, startsWith, endsWith, in |
| `principalSubdivision` | `string` | equals, contains, startsWith, endsWith, in |
| `principalSubdivisionCode` | `string` | equals, contains, startsWith, endsWith, in |
| `city` | `string` | equals, contains, startsWith, endsWith, in |
| `locality` | `string` | equals, contains, startsWith, endsWith, in |
| `postcode` | `string` | equals, contains, startsWith, endsWith, in |
| `plusCode` | `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).*

***

## Roaming Statuses

Path: `bigdatacloud.db.roamingStatuses.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.roamingStatuses.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `ip` | `string` | equals, contains, startsWith, endsWith, in |
| `latitude` | `number` | equals, gt, gte, lt, lte, in |
| `longitude` | `number` | equals, gt, gte, lt, lte, in |
| `isRoaming` | `boolean` | equals |

*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).*

***

## Timezones

Path: `bigdatacloud.db.timezones.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.timezones.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `ianaTimeId` | `string` | equals, contains, startsWith, endsWith, in |
| `displayName` | `string` | equals, contains, startsWith, endsWith, in |
| `effectiveTimeZoneFull` | `string` | equals, contains, startsWith, endsWith, in |
| `effectiveTimeZoneShort` | `string` | equals, contains, startsWith, endsWith, in |
| `utcOffsetSeconds` | `number` | equals, gt, gte, lt, lte, in |
| `utcOffset` | `string` | equals, contains, startsWith, endsWith, in |
| `isDaylightSavingTime` | `boolean` | equals |
| `localTime` | `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).*

***

## Tor Exit Nodes

Path: `bigdatacloud.db.torExitNodes.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.torExitNodes.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `ip` | `string` | equals, contains, startsWith, endsWith, in |
| `countryName` | `string` | equals, contains, startsWith, endsWith, in |
| `countryCode` | `string` | equals, contains, startsWith, endsWith, in |
| `asn` | `string` | equals, contains, startsWith, endsWith, in |
| `organisation` | `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).*

***

## User Agents

Path: `bigdatacloud.db.userAgents.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.userAgents.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `userAgentRaw` | `string` | equals, contains, startsWith, endsWith, in |
| `device` | `string` | equals, contains, startsWith, endsWith, in |
| `os` | `string` | equals, contains, startsWith, endsWith, in |
| `userAgent` | `string` | equals, contains, startsWith, endsWith, in |
| `family` | `string` | equals, contains, startsWith, endsWith, in |
| `versionMajor` | `string` | equals, contains, startsWith, endsWith, in |
| `versionMinor` | `string` | equals, contains, startsWith, endsWith, in |
| `versionPatch` | `string` | equals, contains, startsWith, endsWith, in |
| `isSpider` | `boolean` | equals |
| `isMobile` | `boolean` | equals |
| `userAgentDisplay` | `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).*

***

## User Risks

Path: `bigdatacloud.db.userRisks.search`

```ts theme={null}
const rows = await corsair.bigdatacloud.db.userRisks.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});
```

### Searchable filters

| Field | Type | Operators |
| - | - | - |
| `entity_id` | `string` | equals, contains, startsWith, endsWith, in |
| `id` | `string` | equals, contains, startsWith, endsWith, in |
| `ip` | `string` | equals, contains, startsWith, endsWith, in |
| `risk` | `string` | equals, contains, startsWith, endsWith, in |
| `description` | `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).*

***


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