people

11,580 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category, citizenship, hydrated, date_of_birth (date), date_of_death (date), first_seen (date), last_seen (date)

Next page

CREATE TABLE people (
        id INTEGER PRIMARY KEY,
        slug TEXT UNIQUE, category TEXT, url TEXT,
        name TEXT, occupation TEXT, bio TEXT, photo TEXT,
        call_sign TEXT, rank TEXT, unit TEXT, branch TEXT, position TEXT,
        city_of_birth TEXT, country_of_birth TEXT, city_of_death TEXT,
        region_of_death TEXT, place_of_burial TEXT, awards TEXT, citizenship TEXT,
        age INTEGER, dob TEXT, dod TEXT, date_of_birth TEXT, date_of_death TEXT,
        fields_json TEXT, og_title TEXT, og_description TEXT,
        raw_html_path TEXT, hydrated INTEGER DEFAULT 0,
        first_seen TEXT, last_seen TEXT);
CREATE INDEX idx_people_hydrated ON people(hydrated);
CREATE INDEX idx_people_category ON people(category);
CREATE INDEX idx_people_date_of_death ON people(date_of_death);