asns_botnet_threat_feed

Creates, updates, deletes, gets or lists an asns_botnet_threat_feed resource.

Overview

Name	asns_botnet_threat_feed
Type	Resource
Id	cloudflare.radar.asns_botnet_threat_feed

Fields

The following fields are returned by SELECT queries:

list

Successful response.

Name	Datatype	Description
ases	array
meta	object

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select		limit, offset, metric, date, compareDateRange, location, asn, sortOrder, format	Retrieves a ranked list of Autonomous Systems based on their presence in the Cloudflare Botnet Threat Feed. Rankings can be sorted by offense count or number of bad IPs. Optionally compare to a previous date to see rank changes.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
asn	array	Filters results by Autonomous System. Specify one or more Autonomous System Numbers (ASNs) as a comma-separated list. Prefix with - to exclude ASNs from results. For example, -174, 3356 excludes results from AS174, but includes results from AS3356.
compareDateRange	string	Relative date range for rank change comparison (e.g., "1d", "7d", "30d").
date	string (date)	The date to retrieve (YYYY-MM-DD format). If not specified, returns the most recent available data. Note: This is the date the report was generated. The report is generated from information collected from the previous day (e.g., the 2026-02-23 entry contains data from 2026-02-22).
format	string	Format in which results will be returned.
limit	integer	Limits the number of objects returned in the response.
location	string	Filters results by location. Specify an alpha-2 location code.
metric	string	Metric to rank ASNs by.
offset	integer	Skips the specified number of objects before fetching the results.
sortOrder	string	Sort order.

SELECT examples

list

Retrieves a ranked list of Autonomous Systems based on their presence in the Cloudflare Botnet Threat Feed. Rankings can be sorted by offense count or number of bad IPs. Optionally compare to a previous date to see rank changes.

SELECT
ases,
meta
FROM cloudflare.radar.asns_botnet_threat_feed
WHERE limit = '{{ limit }}'
AND offset = '{{ offset }}'
AND metric = '{{ metric }}'
AND date = '{{ date }}'
AND compareDateRange = '{{ compareDateRange }}'
AND location = '{{ location }}'
AND asn = '{{ asn }}'
AND sortOrder = '{{ sortOrder }}'
AND format = '{{ format }}'
;