Input

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

Data

Total Results: 541 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Tails	mozilla.org	31.0	bugzilla.mozilla.org	2023-10-15 12:56:31.857603-07:00	2024-12-13 00:16:44.187330-08:00	lower(http_request.response_headers) contains 'tails'
Tails	spotify.com	52.0	open.spotify.com	2024-08-19 13:35:27.177515-07:00	2024-12-23 05:21:28.085893-08:00	lower(http_request.response_headers) contains 'tails'
Tails	archive.org	63.0	archive.org/details/comfort_stand	2024-08-23 23:03:40.603549-07:00	2024-12-12 13:59:14.521495-08:00	lower(http_request.response_headers) contains 'tails'
Tails	shopify.com	112.0	apps.shopify.com/uporder	2024-08-23 11:30:55.350872-07:00	2024-12-23 02:59:18.551889-08:00	lower(http_request.response_headers) contains 'tails'
Tails	ibm.com	119.0	www.ibm.com/products/websphere-application-server	2023-11-16 19:02:04.551938-08:00	2023-11-16 02:36:10.850052-08:00	lower(http_request.response_headers) contains 'tails'
Tails	photobucket.com	465.0	photobucket.com	2024-11-29 02:56:12.236910-08:00	2024-11-29 00:14:14.618128-08:00	lower(http_request.response_headers) contains 'tails'
Tails	routledge.com	1057.0	www.routledge.com	2024-03-02 17:51:52.864977-08:00	2024-03-02 04:57:02.158425-08:00	lower(http_request.response_headers) contains 'tails'
Tails	www.gov.br	1230.0	www.gov.br/pt-br	2024-08-20 01:59:39.015622-07:00	2024-09-23 00:04:45.049606-07:00	lower(http_request.response_headers) contains 'tails'
Tails	cointelegraph.com	1314.0	cointelegraph.com	2023-10-18 07:09:20.033384-07:00	2023-10-18 06:03:09.064860-07:00	lower(http_request.response_headers) contains 'tails'
Tails	alltrails.com	1377.0	www.alltrails.com	2024-11-17 03:16:27.098848-08:00	2024-11-17 00:53:22.550212-08:00	lower(http_request.response_headers) contains 'tails'
Tails	mcdonalds.com	1489.0	www.mcdonalds.com/nl/nl-nl	2024-11-24 12:02:50.161835-08:00	2024-11-24 02:50:48.013948-08:00	lower(http_request.response_headers) contains 'tails'
Tails	web.com	1819.0	www.web.com	2024-05-27 01:44:36.976593-07:00	2024-05-27 00:12:59.584223-07:00	lower(http_request.response_headers) contains 'tails'
Tails	wellsfargo.com	2273.0	retailservices.wellsfargo.com/index	2023-10-15 17:53:01.133746-07:00	2024-02-18 19:05:23.065122-08:00	lower(http_request.response_headers) contains 'tails'
Tails	cognitoforms.com	2703.0	www.cognitoforms.com	2023-10-16 02:23:22.789681-07:00	2024-12-13 00:22:33.881487-08:00	lower(http_request.response_headers) contains 'tails'
Tails	india.com	2776.0	www.india.com	2023-10-16 02:24:31.826640-07:00	2024-12-13 00:25:48.797318-08:00	lower(http_request.response_headers) contains 'tails'
Tails	tailscale.com	4206.0	tailscale.com	2024-10-05 02:43:06.499611-07:00	2024-12-13 00:37:21.148824-08:00	lower(http_request.response_headers) contains 'tails'
Tails	99designs.com	4216.0	99designs.com	2023-10-16 02:23:22.789681-07:00	2024-12-13 00:38:33.495618-08:00	lower(http_request.response_headers) contains 'tails'
Tails	overheid.nl	5316.0	www.overheid.nl	2024-02-27 17:26:34.236609-08:00	2024-07-08 00:51:32.789874-07:00	lower(http_request.response_headers) contains 'tails'
Tails	www.gov.il	5693.0	www.gov.il/he/departments/ministry_of_justice	2024-11-19 14:36:52.785653-08:00	2024-11-19 01:42:50.014367-08:00	lower(http_request.response_headers) contains 'tails'
Tails	google.co.zw	6393.0	www.google.co.zw	2023-11-12 16:26:43.564476-08:00	2023-11-12 00:27:41.041028-08:00	lower(http_request.response_headers) contains 'tails'