sites

1 row where hostnames contains "46.138.251.27" and new_books = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
be3ded00-6487-4f4f-a870-3b9bccf3c67a http://46.138.251.27:8082 
[
    "46.138.251.27"
]
 
[
    "8082"
]
 RU   down 2026-03-20 15:07:53.675435 2026-04-05 15:22:16.949660 Request failed: HTTPConnectionPool(host='46.138.251.27', port=8082): Max retries exceeded with url: /ajax/search?num=0 (Caused by ConnectTimeoutError(<urllib3.connection.HTTPConnection object at 0x109b64380>, 'Connection to 46.138.251.27 timed out. (connect timeout=15)')) HTTPConnectionPool(host='46.138.251.27', port=8082): Max retries exceeded with url: /ajax/search?num=0 (Caused by ConnectTimeoutError(<urllib3.connection.HTTPConnection object at 0x109b64380>, 'Connection to 46.138.251.27 timed out. (connect timeout=15)')) 3862 3862 0 2 2 2026-04-05 15:22:16.949660 2026-03-20 15:07:53.675435   0 0   3469 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);