Database - Corsair

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

New to Corsair? See database operations, data synchronization, and multi-tenancy.

Asns

Path: bigdatacloud.db.asns.search

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.

Bgp Prefixes

Path: bigdatacloud.db.bgpPrefixes.search

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.

Countries

Path: bigdatacloud.db.countries.search

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.

Email Validations

Path: bigdatacloud.db.emailValidations.search

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.

Hazard Reports

Path: bigdatacloud.db.hazardReports.search

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.

Networks

Path: bigdatacloud.db.networks.search

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.

Phone Validations

Path: bigdatacloud.db.phoneValidations.search

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.

Reverse Geocodes

Path: bigdatacloud.db.reverseGeocodes.search

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.

Roaming Statuses

Path: bigdatacloud.db.roamingStatuses.search

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.

Timezones

Path: bigdatacloud.db.timezones.search

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.

Tor Exit Nodes

Path: bigdatacloud.db.torExitNodes.search

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.

User Agents

Path: bigdatacloud.db.userAgents.search

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.

User Risks

Path: bigdatacloud.db.userRisks.search

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.