people

✎ View and edit SQL

This data as json

0 records

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);
CREATE INDEX idx_people_hydrated ON people(hydrated);
CREATE INDEX idx_people_date_of_death ON people(date_of_death);