sites

7 rows where libraries_count = 0 and new_books = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ports, country, status, last_book_count, failed_attempts, last_online (date), last_check (date), last_failed (date), last_success (date), hostnames (array), ports (array)

uuid ▼ url hostnames ports country isp status last_online last_check error error_message book_count last_book_count new_books libraries_count failed_attempts last_failed last_success last_scrape scrapes downloads last_download demeter_id active
28a11fa1-a43d-4109-9a27-699eb0dbee4d http://86.40.0.111:3112 
[
    "86.40.0.111"
]
 
[
    "3112"
]
 IE   unknown 2025-10-24 11:29:02.902289 2025-10-24 11:29:02.902289     0 582 0 0 0   2025-10-24 11:29:02.902289   0 0   37 0
5d0efc77-35e3-43b9-ae7d-06e4e0d760e8 http://184.99.22.135:8080 
[
    "184.99.22.135"
]
 
[
    "8080"
]
 US   unknown 2025-10-24 12:49:10.979583 2025-10-24 12:49:10.979583     0 1731 0 0 0   2025-10-24 12:49:10.979583   0 0   2997 0
73c98cb8-0e48-4ebe-8d54-4d2945985693 http://179.49.112.238:2020 
[
    "179.49.112.238"
]
 
[
    "2020"
]
 HN   unknown 2025-10-24 11:35:32.483371 2025-10-24 11:35:32.483371     0 1992 0 0 0 2025-08-22 13:55:11.734268 2025-10-24 11:35:32.483371   0 0   612 0
75779a50-92c2-4fc7-9190-9f6b4c590be1 http://68.10.158.69:8080 
[
    "68.10.158.69"
]
 
[
    "8080"
]
 US   unknown 2025-10-24 11:31:18.458821 2025-10-24 11:31:18.458821     0 3372 0 0 0   2025-10-24 11:31:18.458821   0 0   76 0
9bbb7e40-d6d2-4c8c-8cf1-036234d56d65 http://184.99.45.77:8080 
[
    "184.99.45.77"
]
 
[
    "8080"
]
 US   down 2025-10-10 09:36:59.920279 2025-10-24 11:38:50.258819 Request failed: HTTPConnectionPool(host='184.99.45.77', port=8080): Max retries exceeded with url: /ajax/search?num=0 (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x10a415590>: Failed to establish a new connection: [Errno 61] Connection refused')) HTTPConnectionPool(host='184.99.45.77', port=8080): Max retries exceeded with url: /ajax/search?num=0 (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x10a415590>: Failed to establish a new connection: [Errno 61] Connection refused')) 0 1731 0 0 2 2025-10-24 11:38:50.258819 2025-10-10 09:36:59.920279   0 0   1219 0
ab39627a-b725-4087-bc8b-2de363da40d4 http://217.82.169.156:8080 
[
    "217.82.169.156"
]
 
[
    "8080"
]
 DE   unknown 2025-10-24 12:03:48.483378 2025-10-24 12:03:48.483378     0 6474 0 0 0 2025-10-03 17:45:58.635479 2025-10-24 12:03:48.483378   0 0   2341 0
c5b168b6-a643-410e-8dc7-840bd3c3ac75 http://38.162.146.32:9202 
[
    "38.162.146.32"
]
 
[
    "9202"
]
 US   unknown 2025-10-24 11:46:57.079157 2025-10-24 11:46:57.079157     0 14340 0 0 0   2025-10-24 11:46:57.079157   0 0   1897 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE sites (
        uuid TEXT PRIMARY KEY,
        url TEXT,
        hostnames TEXT,
        ports TEXT,
        country TEXT,
        isp TEXT,
        status TEXT,
        last_online TEXT,
        last_check TEXT,
        error TEXT,
        error_message TEXT,
        book_count INTEGER,
        last_book_count INTEGER,
        new_books INTEGER,
        libraries_count INTEGER,
        failed_attempts INTEGER DEFAULT 0,
        last_failed TEXT,
        last_success TEXT
    , last_scrape TEXT, scrapes INTEGER DEFAULT 0, downloads INTEGER DEFAULT 0, last_download TEXT, demeter_id INTEGER, active INTEGER DEFAULT 0);