people

14,752 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: hydrated, first_seen, last_seen (date), dob (date), last_contact (date), date_of_birth (date), date_of_last_contact (date), first_seen (date), last_seen_ts (date)

Next page

CREATE TABLE people (
        slug TEXT PRIMARY KEY, url TEXT,
        name TEXT, name_override TEXT, photo TEXT,
        status TEXT, unit TEXT, last_seen TEXT,
        dob TEXT, last_contact TEXT,
        date_of_birth TEXT, date_of_last_contact TEXT,
        fields_json TEXT, raw_html_path TEXT,
        hydrated INTEGER DEFAULT 0, fails INTEGER DEFAULT 0,
        first_seen TEXT, last_seen_ts TEXT);
CREATE INDEX idx_people_hydrated ON people(hydrated);