Input

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

Data

Total Results: 53 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Opennemas	elmundo.es	1104.0	diariodevalladolid.elmundo.es	2023-10-15 08:03:08.276918-07:00	2024-02-16 15:49:57.402033+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	publico.es	4844.0	eldiariocantabria.publico.es	2023-10-15 10:38:15.634349-07:00	2024-12-03 01:41:15.404023+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	okdiario.com	9120.0	navarra.okdiario.com	2023-10-15 06:39:21.479897-07:00	2024-12-23 15:36:38.843392+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	elconfidencialdigital.com	18314.0	www.elconfidencialdigital.com	2023-10-16 01:45:00.280449-07:00	2024-12-14 08:24:43.570868+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	diariodeleon.es	30122.0	www.diariodeleon.es	2023-10-16 01:52:22.919205-07:00	2024-01-28 09:20:59.092471+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	atalayar.com	35369.0	www.atalayar.com	2023-10-16 02:12:51.151783-07:00	2024-12-12 10:03:08.679341+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	nuevatribuna.es	50418.0	www.nuevatribuna.es	2023-10-16 02:41:51.082152-07:00	2024-12-23 08:45:18.248427+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	laregion.es	57877.0	www.laregion.es	2023-10-16 02:41:51.082152-07:00	2024-12-23 09:03:01.402416+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	elprogreso.es	72271.0	www.elprogreso.es	2023-10-15 03:37:16.392771-07:00	2024-12-13 09:31:05.129353+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	opinion.com.bo	76736.0	www.opinion.com.bo	2023-10-15 03:37:16.392771-07:00	2024-12-13 09:53:38.731714+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	mundiario.com	78870.0	www.mundiario.com	2023-10-15 03:32:54.049990-07:00	2024-12-13 10:06:58.137079+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	atlantico.net	81979.0	www.atlantico.net	2023-10-15 03:32:26.649483-07:00	2024-11-27 10:19:33.954518+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	aragondigital.es	105192.0	www.aragondigital.es	2024-01-17 21:41:38.102338-08:00	2024-12-23 09:35:25.070051+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	galiciae.com	116103.0	www.galiciae.com	2023-10-15 03:33:04.380475-07:00	2024-12-11 11:17:31.037071+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	diariodepontevedra.es	118566.0	www.diariodepontevedra.es	2023-10-15 03:35:14.855042-07:00	2024-12-11 11:30:52.478097+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	autonomosyemprendedor.es	162576.0	www.autonomosyemprendedor.es	2023-10-16 03:12:45.223446-07:00	2024-12-23 10:03:14.102418+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	opennemas.com	163886.0	www.opennemas.com	2023-10-15 04:27:30.870060-07:00	2024-12-23 10:11:10.808229+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	diariodehuelva.es	164469.0	www.diariodehuelva.es	2023-10-15 03:41:18.783273-07:00	2024-12-23 10:16:43.120225+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	teleprensa.com	180320.0	www.teleprensa.com	2023-10-15 04:33:58.669405-07:00	2024-12-05 10:45:47.231271+00:00	lower(http_request.response_headers) contains 'opennemas'
Opennemas	elmira.es	198239.0	www.elmira.es	2023-10-15 04:38:32.055684-07:00	2024-12-23 10:58:14.879860+00:00	lower(http_request.response_headers) contains 'opennemas'