Input

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

Data

Total Results: 21 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Neocities	neocities.org	2832.0	neocities.org	2023-10-16 02:25:52.872100-07:00	2024-12-13 00:28:25.015470-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	restorativland.org	109004.0	restorativland.org	2023-10-15 03:32:26.649483-07:00	2024-12-23 01:50:34.998715-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	gifcities.org	269223.0	gifcities.org	2023-10-15 06:20:29.519944-07:00	2024-12-23 04:25:19.833133-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	bogleech.com	279744.0	bogleech.com	2023-10-15 05:27:27.239983-07:00	2024-12-12 07:31:16.938241-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	yesterweb.org	279975.0	yesterweb.org	2023-10-15 05:20:58.303750-07:00	2024-12-12 07:42:25.129269-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	fedipact.online	383153.0	fedipact.online	2023-10-15 04:39:08.691101-07:00	2024-12-09 07:09:17.121944-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	neustadt.fr	482281.0	neustadt.fr	2023-10-15 10:03:19.645673-07:00	2024-12-08 10:02:40.853002-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	substack.net	496238.0	substack.net	2023-10-15 08:12:37.841376-07:00	2024-12-09 09:31:20.824542-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	melonland.net	509209.0	melonland.net	2024-12-06 22:52:43.361038-08:00	2024-12-07 10:21:07.731425-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	omar.website	527790.0	omar.website	2023-10-15 09:42:13.855156-07:00	2024-12-08 10:33:45.315288-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	sadgrl.online	534859.0	sadgrl.online	2023-10-15 08:03:47.093833-07:00	2024-03-01 06:39:27.164114-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	calmtech.com	551539.0	calmtech.com	2023-10-15 09:46:22.565389-07:00	2024-12-07 11:16:27.220304-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	anticapitalist.software	634467.0	anticapitalist.software	2023-10-15 12:58:57.849523-07:00	2024-12-13 11:57:10.136685-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	localghost.dev	657123.0	localghost.dev	2023-11-09 04:40:35.769411-08:00	2024-10-05 20:14:53.053518-07:00	lower(http_request.response_headers) contains 'neocities'
Neocities	everest-pipkin.com	676296.0	everest-pipkin.com	2023-10-15 17:53:01.133746-07:00	2024-12-13 12:51:21.711554-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	melonking.net	752219.0	melonking.net	2024-12-03 23:54:48.744030-08:00	2024-12-13 12:20:01.670618-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	marupanda.art	NaN	marupanda.art	2023-10-15 10:40:19.553755-07:00	2024-02-26 10:57:57.256396-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	goblin-heart.net	NaN	goblin-heart.net/sadgrl	2024-09-09 23:03:34.364358-07:00	2024-12-07 10:44:30.963716-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	emreed.net	NaN	emreed.net	2023-10-15 14:14:28.538822-07:00	2024-02-18 17:27:41.372435-08:00	lower(http_request.response_headers) contains 'neocities'
Neocities	aywren.com	NaN	aywren.com	2023-10-15 11:05:03.549661-07:00	2024-02-18 16:48:52.259040-08:00	lower(http_request.response_headers) contains 'neocities'