Input

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

Data

Total Results: 56 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Sv15-osk	unicef.or.jp	37244.0	www.unicef.or.jp	2023-10-25 20:50:17.695288-07:00	2023-11-09 00:11:48.275953-08:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	smcworld.com	61811.0	www.smcworld.com	2023-11-12 22:16:43.856454-08:00	2024-04-30 02:12:55.513831-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	senso-ji.jp	63860.0	www.senso-ji.jp	2023-12-28 22:15:33.347276-08:00	2024-12-08 00:55:12.624094-08:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	ncgg.go.jp	88611.0	www.ncgg.go.jp	2023-11-05 04:25:04.056292-08:00	2024-07-07 14:55:43.350520-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	bitters.co.jp	95355.0	www.bitters.co.jp	2023-12-11 17:21:47.122063-08:00	2024-09-15 02:07:12.879700-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	sumida-aquarium.com	107498.0	www.sumida-aquarium.com	2023-10-28 12:12:52.406848-07:00	2024-04-30 02:44:06.319317-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	109cinemas.net	116661.0	109cinemas.net	2024-06-07 14:19:51.558122-07:00	2024-12-08 01:59:17.958838-08:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	hanayashiki.net	139176.0	www.hanayashiki.net	2023-12-07 22:10:14.014589-08:00	2024-05-28 09:00:01.935683-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	tbc-sendai.co.jp	140021.0	www.tbc-sendai.co.jp	2024-02-11 12:48:51.323146-08:00	2024-05-26 07:48:14.036890-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	peace-winds.org	143106.0	peace-winds.org	2023-11-02 04:39:23.857571-07:00	2024-02-13 03:31:54.542261-08:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	eigakan.org	146740.0	eigakan.org	2024-03-02 06:47:53.597694-08:00	2024-06-26 19:50:49.018021-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	hcr.or.jp	162927.0	hcr.or.jp	2024-09-18 08:47:35.691892-07:00	2024-09-18 04:28:43.414278-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	kyoto-aquarium.com	165532.0	www.kyoto-aquarium.com	2023-12-10 18:25:09.543064-08:00	2024-10-01 03:49:05.124111-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	npn.co.jp	172120.0	npn.co.jp	2023-12-25 11:18:11.315634-08:00	2024-01-26 04:06:49.990418-08:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	kobe-park.or.jp	194393.0	www.kobe-park.or.jp	2023-12-09 06:41:45.478889-08:00	2024-09-13 04:16:47.022391-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	isenp.co.jp	245451.0	www.isenp.co.jp	2023-12-12 16:45:24.903192-08:00	2024-07-06 20:32:45.358073-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	tokyoheadline.com	274742.0	www.tokyoheadline.com	2024-02-12 07:14:47.845487-08:00	2024-12-01 05:12:07.017488-08:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	shiken.or.jp	280858.0	www.shiken.or.jp	2023-10-30 22:01:11.015190-07:00	2023-10-30 03:14:22.906964-07:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	sendaitanabata.com	287159.0	www.sendaitanabata.com	2024-11-15 19:41:42.996728-08:00	2024-11-15 06:32:11.467878-08:00	lower(http_request.response_headers) contains 'sv15-osk'
Sv15-osk	bones.co.jp	288752.0	www.bones.co.jp	2024-12-01 14:04:30.407702-08:00	2024-12-01 04:44:10.256608-08:00	lower(http_request.response_headers) contains 'sv15-osk'