Input

field	value
Query:	SELECT 'Bunnycdn-la1-912' AS technology_name ,domain ,global_rank ,url_matchable AS url ,created AS first_seen ,last_seen ,CASE WHEN indicator_matchable[2] = 'plain' THEN 'lower(' || indicator_matchable[3] || '.' || indicator_matchable[4] || ') contains ''' || indicator_matchable[1] || '''' ELSE indicator_matchable[3] || '.' || indicator_matchable[4] || ' is regex match of ''' || indicator_matchable[1] || '''' END AS indicator FROM indicator_detection_domain_rollup WHERE (indicator_matchable[1] = 'bunnycdn-la1-912' AND indicator_matchable[2] = 'plain' AND indicator_matchable[3] = 'http_request' AND indicator_matchable[4] = 'response_headers') ORDER BY global_rank ASC NULLS LAST

Query Plan

Download: csv json

Query Plan
Limit (cost=3485.21..3486.06 rows=20 width=117)
-> Result (cost=3485.21..3521.68 rows=858 width=117)
-> Sort (cost=3485.21..3487.36 rows=858 width=168)
Sort Key: global_rank
-> Bitmap Heap Scan on indicator_detection_domain_rollup (cost=61.64..3462.38 rows=858 width=168)
Recheck Cond: ((indicator_matchable[1] = 'bunnycdn-la1-912'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))
-> Bitmap Index Scan on indicator_detection_domain_rollup_indicator_matchable_arr_idx (cost=0.00..61.43 rows=858 width=0)
Index Cond: ((indicator_matchable[1] = 'bunnycdn-la1-912'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 479 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Bunnycdn-la1-912	iubenda.com	764.0	www.iubenda.com/en	2023-10-17 05:15:18.374296-07:00	2024-09-09 00:08:09.419279-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	b-cdn.net	1336.0	demo2wpopal.b-cdn.net	2024-01-06 04:15:13.475558-08:00	2024-08-25 00:14:29.667780-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	newadvent.org	4061.0	www.newadvent.org	2023-11-09 08:05:36.120764-08:00	2024-08-20 00:27:08.355663-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	suite101.com	5069.0	suite101.com	2024-05-02 03:03:11.423627-07:00	2024-09-16 00:18:40.653328-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	ironman.com	6320.0	www.ironman.com	2023-10-27 02:46:15.623546-07:00	2024-09-17 06:10:35.423615-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	answersingenesis.org	7582.0	answersingenesis.org	2024-01-27 02:53:50.785085-08:00	2024-09-17 00:30:31.006170-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	ipfs.io	8041.0	blog.ipfs.io/24-uncensorable-wikipedia	2023-10-15 05:01:56.106044-07:00	2024-02-03 05:53:53.286358-08:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	jamaicaobserver.com	8456.0	www.jamaicaobserver.com	2024-02-14 02:26:47.069160-08:00	2024-09-16 00:23:30.816137-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	ghanaweb.com	8940.0	ghanaweb.com	2024-01-28 05:52:17.785383-08:00	2024-01-28 00:42:04.480831-08:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	frydge.uk	9292.0	www.frydge.uk	2023-10-16 05:21:48.594118-07:00	2024-08-28 00:47:53.477682-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	maketecheasier.com	9363.0	www.maketecheasier.com	2023-10-30 13:42:57.844661-07:00	2024-08-23 00:57:15.612043-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	bunkbedsstore.uk	9727.0	www.bunkbedsstore.uk	2023-10-26 14:25:09.296789-07:00	2024-08-19 03:09:22.223440-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	mymobilityscooters.uk	10457.0	www.mymobilityscooters.uk	2023-10-23 12:22:43.451277-07:00	2024-08-22 00:54:55.950796-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	openpr.com	10644.0	www.openpr.com	2024-02-03 02:01:23.625918-08:00	2024-09-14 00:05:38.286363-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	lyricstranslate.com	11096.0	lyricstranslate.com	2024-08-21 05:17:49.968618-07:00	2024-08-29 00:39:46.512341-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	fireplacesandstove.com	12622.0	www.fireplacesandstove.com	2023-10-21 01:13:03.382268-07:00	2024-08-27 07:49:25.047382-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	yootheme.com	13052.0	yootheme.com	2024-03-24 06:17:16.488238-07:00	2024-07-07 00:58:33.406795-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	coffeee.uk	13550.0	www.coffeee.uk	2023-10-23 05:22:07.549773-07:00	2024-09-01 00:42:18.815226-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	gifdb.com	13901.0	gifdb.com/music	2023-10-17 12:51:42.209600-07:00	2024-02-19 11:04:18.707250-08:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'
Bunnycdn-la1-912	plausible.io	14801.0	plausible.io	2023-10-29 18:58:10.602114-07:00	2024-08-29 01:01:25.320860-07:00	lower(http_request.response_headers) contains 'bunnycdn-la1-912'