sites

2 rows where failed_attempts = 0, "last_failed" is on date 2025-07-26 and scrapes = 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
760cf85d-93ea-4adf-8916-7e0fc43dc1e4 http://1.234.31.204:8080 
[
    "1.234.31.204"
]
 
[
    "8080"
]
 KR   online 2026-05-01 20:12:09.813269 2026-05-01 20:12:09.813269     8 8 0 1 0 2025-07-26 11:02:06.224191 2026-05-01 20:12:09.813269   0 0   637 0
eab0bdb0-1596-41be-a909-54285dfd63b9 http://108.70.83.153:8080 
[
    "108.70.83.153"
]
 
[
    "8080"
]
 US   online 2026-05-01 20:12:26.074545 2026-05-01 20:12:26.074545     6784 6784 0 1 0 2025-07-26 11:05:50.835248 2026-05-01 20:12:26.074545   0 0   710 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);