people

1,384 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: awards, first_seen, last_seen, date_of_birth (date), date_of_death (date), first_seen (date), last_seen (date)

Next page

CREATE TABLE people (
        slug TEXT PRIMARY KEY, url TEXT,
        name TEXT, photo TEXT,
        call_sign TEXT, rank TEXT, position TEXT, unit TEXT,
        place_of_birth TEXT, place_of_death TEXT,
        awards TEXT, bio TEXT,
        dob TEXT, dod TEXT, date_of_birth TEXT, date_of_death TEXT,
        fields_json TEXT, raw_html_path TEXT, hydrated INTEGER DEFAULT 0,
        first_seen TEXT, last_seen TEXT, name_override TEXT);
CREATE INDEX idx_people_hydrated ON people(hydrated);
CREATE INDEX idx_people_date_of_death ON people(date_of_death);