Input

field	value
Query:	SELECT 'Nunya' 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] = 'nunya' 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] = 'nunya'::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] = 'nunya'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 107 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Nunya	harvard.edu	99.0	hep.gse.harvard.edu	2023-10-25 06:01:00.123254-07:00	2023-10-25 00:31:40.383035-07:00	lower(http_request.response_headers) contains 'nunya'
Nunya	atlassian.com	568.0	docs.atlassian.com	2024-01-09 03:52:39.106317-08:00	2024-01-09 00:22:19.250067-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	nike.com	657.0	www.nike.com	2024-05-26 02:02:08.946311-07:00	2024-05-26 00:20:34.596236-07:00	lower(http_request.response_headers) contains 'nunya'
Nunya	wyndhamhotels.com	2229.0	www.wyndhamhotels.com/days-inn	2024-02-08 04:51:49.439842-08:00	2024-02-08 00:32:15.197880-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	k-state.edu	3766.0	www.k-state.edu	2024-06-27 01:46:40.427537-07:00	2024-06-27 00:48:25.617004-07:00	lower(http_request.response_headers) contains 'nunya'
Nunya	therealdeal.com	4700.0	therealdeal.com	2024-01-06 17:57:22.938372-08:00	2024-01-06 00:22:27.253167-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	campaignlive.co.uk	4826.0	www.campaignlive.co.uk	2024-10-06 03:03:27.634392-07:00	2024-10-06 00:17:57.741537-07:00	lower(http_request.response_headers) contains 'nunya'
Nunya	dickssportinggoods.com	5163.0	www.dickssportinggoods.com	2024-12-03 01:41:08.645136-08:00	2024-12-03 00:46:14.571131-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	twitlonger.com	8085.0	www.twitlonger.com	2024-03-03 04:04:56.636074-08:00	2024-03-03 00:30:54.725899-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	thegadgetflow.com	9703.0	thegadgetflow.com	2024-05-25 02:39:56.586387-07:00	2024-05-25 00:41:33.264315-07:00	lower(http_request.response_headers) contains 'nunya'
Nunya	ukrinform.ua	10715.0	www.ukrinform.ua	2024-02-20 02:32:49.397706-08:00	2024-02-20 00:05:45.035974-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	interfax-russia.ru	11376.0	www.interfax-russia.ru	2023-11-12 03:27:37.797287-08:00	2023-11-12 00:17:16.328224-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	airforce.com	11691.0	www.airforce.com/ways-to-serve/air-national-guard	2023-10-15 04:22:05.050003-07:00	2024-12-13 03:59:34.929498-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	trains.com	12443.0	www.trains.com	2023-11-19 23:44:11.015351-08:00	2023-11-19 00:06:11.104720-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	blogaritma.com	17296.0	blogaritma.com	2023-11-29 13:31:21.802463-08:00	2023-11-29 00:09:01.714751-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	ukg.com	17323.0	www.ukg.com/workforce-institute	2024-11-30 15:40:52.908386-08:00	2024-11-30 02:11:43.516187-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	eurweb.com	18414.0	eurweb.com	2024-09-10 04:27:51.429348-07:00	2024-09-10 01:03:51.313568-07:00	lower(http_request.response_headers) contains 'nunya'
Nunya	nationalaffairs.com	25933.0	nationalaffairs.com	2023-12-05 16:27:58.849656-08:00	2023-12-05 00:22:15.672717-08:00	lower(http_request.response_headers) contains 'nunya'
Nunya	maryscustomquilts.com	34793.0	maryscustomquilts.com	2024-10-02 06:15:04.630384-07:00	2024-10-02 00:34:01.632983-07:00	lower(http_request.response_headers) contains 'nunya'
Nunya	gudcrb.ru	36215.0	gudcrb.ru	2024-08-22 05:59:10.384852-07:00	2024-08-22 01:42:24.125604-07:00	lower(http_request.response_headers) contains 'nunya'